Budgeting, Cash Flow Projections, Cost per Ton Analysis, DCF Model, Debt Schedule, Excel, Financial Projections, IRR (Internal Rate of Return), Valuation

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.

Note: If you are looking for a Startup Manufacturing Model, please check out this alternative model template as well – Manufacturing Startup Feasibility Model.

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 historical 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 at the company’s key highlights

The financial model is available in two versions, a PDF Demo Version (Free) and an Excel Version with all cells editable.

Filetypes:

.pdf PDF Acrobat Reader

.xlsx Microsoft Excel