Create Excel model of start up revenue and expenses
$30-250 USD
Anulowano
Opublikowano prawie 7 lat temu
$30-250 USD
Płatne przy odbiorze
Develop a relatively simple Excel model that provides a pro-forma revenue and expense model. The business operates accordingly:
The Finance Company (FinCo) offers three types of loans to a network of channel partners. The channel partners, in turn, offer the loans to their customers. The loans have three components:
a) The loan amount. The minimum is $10,000. The maximum is $100,000. The homeowners can borrow any amount in increments of $10,000 (meaning, $10K, $20K, 30K, etc). These are chosen by means of a drop-down menu
b) The term of the loan. They can choose between terms of 10, 15 and 20 years. These will be inputs by means of a drop-down menu.
c) Interest rates: The interest rates range from 2.99% to 6.99% in increments of 0.5%
d) Dealer Fees: These are one-time fees that are levied on the channel partners and are an input in percentage.
Revenue:
Dealer Fees: Revenues are derived from the one-time dealer fees that our channel partners pay. For example, if they arrange for a customer to take a $30,000 loan to pay for the project, we might charge them a dealer fee of 10%, meaning we will keep $3000 as our revenue and pay the partner $27,000. However, the end user will pay us back $30,000 plus interest.
Interest payments: The end-user customers will make loan payments to FinCo starting 90 days after the loan is originated. They are fixed payments that will include interest and principle repayment over the life of the loan and they are due at the end of each month.
Expenses: There are two types of expenses; one-time expenses and recurring annual expenses
One-time expenses: For each loan, there are one-time charges for the following:
Underwriting: $20
IT Portal: $10
Docusign: 10
Moreover, additionally there are monthly fees that are incurred on a per-loan basis. These are inputs.
Loan Service: $21
Vehicle: $10
Gas: $10
Insurance: $10
Interest fee to lender: Interest to the lender is calculated as (net amount of loan x interest rate)/12 months. So imagine we have sold 10 loans, each where we have borrowed $25000 from our lender. We would make monthly payments including principle and interest on each of those loans at a fixed interest rate. The interest rate should be an input as should be the term of the loan.
The model should calculate revenue less expenses over 12 months. We will not account for taxes. Moreover, the model should also allow for a 5-year forecast based on a growth rate that is an input.
Hello, I am good at Finance, data entry, and analysis,
Relevant Skills and Experience
Data entry skills, analysis using SPSS, financial analysis, finance and accounting,
Proposed Milestones
$250 USD - full task
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Stay tuned, I'm is still working on this proposal.
6+ years of experience in accounting and business research. I am able to do this project as listed in the post with 100% accuracy in a very reasonable time.
Relevant Skills and Experience
Skilled Financial Analyst adept at increasing work process efficiency and profitability through functional and technical analysis.
Proposed Milestones
$222 USD - Accounts and Finance
What are the nature of the business? Product or Services?
Hi,
Can we discuss the project further?
I have done similar project and understood the project outline. Please give me a chance. A trial will convince you. Looking forward to work with you.
Hello, my name is Roberto and I am an Engineer. I have experience with Excel, i have the time to start right now, for any doubt dont hesitate to to ask via chat
Relevant Skills and Experience
excel
Proposed Milestones
$100 USD - excel
hello there, i am a professional accountant and can provide any accounting service. thank you
Relevant Skills and Experience
hello there, i am a professional accountant and can provide any accounting service. thank you
Proposed Milestones
$155 USD - A
Zach and I both have college degrees (TCU & CU Boulder) in Finane and Accounting. We have experience working for hedge funds, private equity funds, and private wealth clients.
Relevant Skills and Experience
Financial Modeling
Excel
Business Valuation (DCF, LBO)
Proposed Milestones
$250 USD - Completion