Start-up Car Ride Financial Proforma

This excel sheet for a start-up car riding membership financial model contains the following 12 tabs:

1. Index & Summary = It contains links to all the sheets in the model, tabs color coding and cells color coding.

2. Graphs = The sheet contains yearwise key performance metrics like number of new cars, number of total cars, number of new members, number of total members, members break-up etc . This sheet also shows key financial metrics like revenue, gross margin, contribution margin, EBITDA and Net Profit.

3. Input: The assumptions for revenue like no. of cars purchased, members, pricing, trips, cancellation fees; direct expenses, S,G&A, staffing costs, working capital, start-up expenses, funding, income tax rate can be changed here.

4. Staffing Inputs : This sheets show various staffing positions (fixed and variable), start date, end date, their salaries and benefits.

6. Income Statement, Balance Sheet and Cash Flow Statement : These are 3 interlinked key financial statements for the projections. These are 5-year monthly statements rolling into annual.

7. Investor Cap Table : Shows funding and shareholding

8. Revenue & COGS Projections, : Detailed calculation for various revenue items like Revenue from rides, revenue from membership, revenue from tips etc. is shown in this tab. This sheet also shows calculation of various COGS items like maintenance costs, fuel costs etc.

9. Sources & Uses of funding : This sheet calculates funding requirement and the sources from which it will be met.

10. Loan Amortization : This tab is for calculation of principal and interest payment for loan taken to meet funding requirement.

11. Valuation : This tab shows DCF valuation of the business and its sensitivities to various inputs.

12. Cap Table : This tab shows funding and shareholding upto Series A.