Manufacturing Company

The Manufacturing Financial Model provides a framework to accurately forecast the financial statements of a manufacturing company over the next 10 years. The model uses a detailed breakdown to estimate the company’s operating assumptions on a per ton basis. The model then uses financial ratio analysis and contains a DCF valuation framework. Furthermore, the model also includes an acquisition analysis with sources and uses of funds, as well as investor IRR analysis based on dividend and exit valuation assumptions.

The highlights of this financial model are:

  • Forecast of Income Statement, Balance Sheet, Cash Flow Statement and Financial Ratios over the next 10 years
  • 3 years of historic financials
  • Detailed breakdowns to estimate sales, direct and indirect cost per ton, gross profit and operating costs
  • Debt schedule
  • Fixed Asset Schedule
  • DCF Model
  • Sensitivity Analysis for WACC and EV/EBITDA Exit Multiple
  • Acquisition analysis with uses and sources of funds as well as investor IRR and quick Goodwill calculation
  • Executive summary with a quick glance on the company’s key highlights

 

The financial model is available in two versions, one with only the input cells editable (Free) and all cells editable (FULL Version).

Filetype: .xlsx (Microsoft Excel 2008 for Mac)

Executive Summary

Financial Statements

Financial Analysis

Gross Profit

Production Assumption

Cost per Ton Analysis

Users who purchased Manufacturing Company, also purchased:
Car Wash Tunnel – 5 Year Financial Projection
Add to wish list
Purchase Excluding 8% tax
Hospital Financial Model
Add to wish list
Purchase Excluding 8% tax
Food Truck Cash Flow Model
Add to wish list
Purchase Excluding 8% tax
Industry ,
Summary The Manufacturing Financial Model provides a framework to accurately forecast the financial statements of a manufacturing company over the next 10 years. The model uses a detailed breakdown to estimate the company's operating assumptions on a per ton basis. The model then uses financial ratio analysis and contains a DCF valuation framework. Furthermore, the model also includes an acquisition analysis with sources and uses of funds, as well as investor IRR analysis based on dividend and exit valuation assumptions.
Screenshots / Pictures
Use Cases , , , , , , ,

Reviews

You must log in and be a buyer of this download to submit a review.