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

 

 

 

Users who purchased Automotive Supplier DCF Valuation Model, also purchased:
Excel Calculator: Invest Now or Pay Off Debt
Add to wish list
Purchase Excluding 7.7% tax
Residual Land Value Calculation
Add to wish list
Purchase Excluding 7.7% tax
Real Estate Developer Model
Real estate developer
Add to wish list
Purchase Excluding 7.7% tax

Write a Review

Get these templates too for a discount!

Price: $112.00

This is a collection of financial model templates for projects or ventures in the Renewable Energy Industry and its related…

Add to wish list
Add to cart Excluding 7.7% tax

Price: $79.95

This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.

Add to wish list
Add to cart Excluding 7.7% tax

Price: $170.00

  This is a bundle of financial model templates for financial plan templates related to Retail Shops. The following are…

Add to wish list
Add to cart Excluding 7.7% tax