0 ITEMS
Automotive Supplier DCF Valuation Model
This Excel financial model offers a template to come up with a DCF Valuation of an automotive supplier. The financial forecast (5-years) includes a three statement model which provides a comprehensive understanding of the expected financial scenario.
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:
Users who purchased Automotive Supplier DCF Valuation Model, also purchased:
Write a Review
Get these templates too for a discount!
Renewable Energy Financial Model Bundle
Price: $112.00This is a collection of financial model templates for projects or ventures in the Renewable Energy Industry and its related…
Manufacturing Financial Model Templates Bundle
Price: $79.95This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.
Retail Financial Model Templates Bundle
Price: $170.00This is a bundle of financial model templates for financial plan templates related to Retail Shops. The following are…