Electric Car company Financial Model

Description
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.