This Excel financial model offers a simple spreadsheet template to come up with a Discounted Cash Flow (DCF) Valuation of an automotive supplier. Automotive suppliers mostly produce a variety of parts (e.g. plastic or metal parts) in form of large serial productions. The business is driven by its customers and the product life cycle of its parts. This model forecasts revenues by customers and splits them into existing business and new business.
The highlights of this financial model template in Excel are the following:
- Executive Summary which contains a summary of the financial projections but also key assumptions as well as charts and graphs
- Operating Model
- Forecasted revenues by customer
- Existing business
- New business
- Project and other business
- Forecast cost of goods sold (COGS) as % of sales
- Forecast of direct labour costs as % of sales
- Forecast of operating costs
- Fixed Asset schedule with Capital Expenditures (CAPEX) and Depreciation assumptions by different categories of fixed assets
- Debt Schedule
- Forecasted revenues by customer
- Financial Statements containing a 5-year forecast of a Three Statement Model
- Income Statement
- Balance Sheet
- Cash Flow Statement
- Financial Ratios
- DCF Valuation based on Discount Rate and Exit EV/EBITDA Multiple (for easy to understand Terminal Value estimate)
- Sensitivity Analysis to understand the effect of any change in assumptions for the main key value drivers
This financial model template in Excel comes in two versions. One as a PDF Demo Version (free) and the other is a Full Excel Version (paid version). The model does not include macros and the file type is .xlsx. This model also works on a Mac Book unit.
Screenshots are provided below:
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
Electric Car Company Financial Model
This Financial model is about valuing an Electric Car Company. This is done by bifurcating the compa... Read more
Distillery Financial Plan Template
This Distillery Financial Plan template prepares a sophisticated financial plan for a small distille... Read more
Business Plan for a Biodiesel Manufacturing Plant
Setting up a biodiesel manufacturing plant requires a comprehensive and executed business strategy. ... Read more
Manufacturing Financial Model Templates Bundle
This is a collection of financial model templates in Excel for businesses in the Manufacturing indus... Read more
EPC Model for Builders and JV Partners
The EPC Financial Model Template for Builders and JV Partners targets to assist companies and entrep... Read more
Manufacturing Plant – Operating Model –...
Specific logic structures and assumptions designed to show the resulting financial performance of ac... Read more
Product + Subscription Financial Model
Build a strategy for adding recurring revenues services to your product. Includes financial statemen... Read more
Hydrogen Gas Sales & Tolling Business Plan an...
Hydrogen Gas Sales & Tolling Fee business plan and valuation model is an excellent tool to asses... Read more
Hydrogen Gas Equipment Manufacturing and Sales Mod...
This is a very detailed and user-friendly financial model with three financial statements ... Read more
You must log in to submit a review.