Create Excel model of start up revenue and expenses

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.