Automotive Supplier, Financial Model, Manufacturing |
DCF Model, Financial Statements, Valuation |
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.
Similar Products
Other customers were also interested in...
Manufacturing Startup/Existing Business Financial ...
3 statement 5 year rolling financial projection Excel model for a startup /existing manufacturing bu... Read more
Solar Energy Power Plant Financial Model
In order to assess the financial viability of a Solar Park project, the Solar Energy Financial Model... Read more
Green Hydrogen (Simple Electrolysis Financial Mode...
The Model Incorporates data provided by different available sources to Model an Electrolysis financi... Read more
Manufacturing Plant – Operating Model –...
Specific logic structures and assumptions designed to show the resulting financial performance of ac... Read more
Steel Industry Financial Model
Steel Industry Financial Model presents the business case of the operation of a steel plant using th... Read more
Distillery Financial Plan Template
This Distillery Financial Plan template prepares a sophisticated financial plan for a small distille... Read more
Solar Panel Manufacturing Plant Business Plan Fina...
Get the Best Solar Panel Manufacturing Plant Financial Model. Spend less time on Cash Flow forecasti... Read more
Ethanol and Sugar Production Plant Financial Model
Fin-wiser’s Ethanol and Sugar Plant PPP project model helps users to assess the financial viabilit... Read more
Business Plan for a Biodiesel Manufacturing Plant
Setting up a biodiesel manufacturing plant requires a comprehensive and executed business strategy. ... Read more
Product + Subscription Financial Model
Build a strategy for adding recurring revenues services to your product. Includes financial statemen... Read more
Reviews
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?
-
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 you30 of 73 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
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?
You must log in to submit a review.