|DCF Model, Excel, Financial Projections, NPV, 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?
Write a Review
Leave a reply Cancel reply
Get these templates too for a discount!
This is an Excel financial model template for a single blockbuster product where the founders need to raise funding from…
A versatile template to forecast out a manufacturing or retail sales business that is built around customer re-purchases.