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:

Automotive Supplier Financial Modeling Executive Summary
Automotive Supplier Financial Modeling Executive Summary

 

Automotive Supplier Financial_Modeling Income Statement
Automotive Supplier Financial_Modeling Income Statement

 

Automotive Supplier Financial Modeling Balance Sheet
Automotive Supplier Financial Modeling Balance Sheet

 

Automotive Supplier Financial_Modeling Cash Flow Statement
Automotive Supplier Financial_Modeling Cash Flow Statement

 

Automotive Supplier Financial Modeling Ratio Analysis
Automotive Supplier Financial Modeling Ratio Analysis

 

Automotive Supplier Financial Modeling DCF Valuation
Automotive Supplier Financial Modeling DCF Valuation

 

 

 

Industry , ,
Summary 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.
Screenshots / Pictures
Use Cases , , , , , , , , , , , , , , , ,

Leave a Reply