|DCF Model, Excel, Financial Projections, NPV (Net Present Value), Sensitivity Analysis, Valuation|
This Valuation Model template provides a framework to forecast the cash flows of a can food manufacturing company and derives its Discounted Cash Flow (DCF) value.
The valuation model forecasts sales volumes and prices of each product line, its costs of goods sold, overhead costs and models the expected free cash flows.
The financial model also provides a forecasted Income Statement, Balance Sheet and Cash Flow Statement.
The DCF value is derived by using a simple Gordon Growth Terminal Value model. The model also provides the sensitivities of the model’s main assumptions such as sales volumes, costs of goods sold, salaries and General & Admin costs.
The model is available in two versions, a free version with all cells protected and an advanced version with all cells free to be edited.
Its nice to have initial projections..
1 of 2 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?