Electric Car Company Financial Model

This Financial Model will enable its user to value an Electric Car Company.

, ,
, ,

This Financial model is about valuing an Electric Car Company. This is done by bifurcating the company’s revenue streams, estimating the individual streams, and combining them to get the aggregate value.

List of sheets this model contains:
1) Drivers: This sheet contains the macroeconomic data about the country in which the company is located and some data about the company.
2) Input: This sheet requires input from the user about the existing data of the company; it contains P&L data and Balance sheet data.
3) Income Statement items: These sheets estimate the revenue streams of the business by using the matrices from the industry standards and then estimate how much revenue can be generated by the company.
4) Gross Profit and Cost estimates: These sheets provide step-by-step estimation and realization of the margins of profit and costs.
5) Energy Estimations: These sheets provide the estimation of revenues, profit, and cash flow from the Energy Business segment.
6) Operating Expenses: Scheduling of operating expenses is done in this sheet.
7)PP&E and Working capital: A full schedule of the next 10 years is done in these sheets.
8) Financial Statements: In the next sheets, the assumptions are put in the place, and the actual numbers are projects for all three financial statements P&L, Balance Sheet, and Cash Flow Statements.
9) WACC: Weighted Average Cost of Capital is calculated in this sheet.
10) DCF: Using the discounted cash flow technique, the value per share of the company is calculated.
11) Charts: Many interactive and insightful charts have been added to this sheet, like revenue by type of cars, Types of vehicles, Profitability, Price- Volume-Mix, etc.

This model is completely dynamic, user can change the inputs/assumptions to get the desired result.
For any queries, feel free to contact the support team via the contact author button.

Reviews

  • Electric Car Company Financial Model

    i thought it is financial model for startup electric vehicle manufacturing company, but it is more of a financial analysis of tesla. Your return policy is clear on but i wish if could replace the same with the one i wanted.

    33 of 69 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

    • Hi, Tesla posed as a perfect example for valuing an electric car company, that’s it was chosen to make a base for valuing any electric car company. You can customize the model according to your own needs.
      Thank you

      30 of 73 people found this review helpful.

      Help other customers find the most helpful reviews

      Did you find this review helpful? Yes No

  • Elaborative revenue collection drivers

    Very nicely made financial model which calculated the step by step revenue from different sources and aggregated them to generate future cash flows.

    80 of 151 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • You must log in to submit a review.