Automotive Supplier DCF Valuation Model

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
• 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: