Model Bucket

Valuation Model for Company/Projects/Businesses using DCF Methodology

Excellent model for valuation of companies/businesses/projects. It uses discounted cash flow methodology (which is extensively used due to its flexibility of use across companies).

Model calculates explicit free cash flow for 10 years & terminal value after 10 years. It provides enough flexiblity to play with assumptions & check out the impact on the company's valuation.

This valuation model was be used in
1. Evaluating companies/businesses
2. Feasiblity study of new projects
3. To check out whether the company/business will be able to achieve its future targets at particular assumptions.
4. Play with assumptions & evaluate impact on the company's value.

Inputs required are:
1. Projected revenue growth
2. GP/SG&A/Dep/Capex/NWC as % of sales
3. Growth & discount factors
4. Actual financials of latest year

The model throws out a detailed output sheet with:
1. Year wise revenues/costs/profits for the next 10 years
2. Free cash flow calculation for each of the next 10 years
3. Present value (which can be checked at various disocunt rates & terminal growth rates)
4. FCF/DCF value of the company
5. Market value of the company's assets
1.

  • Screenshot
  • Screenshot

About the author

sapansheth

2 models
-----
sapansheth avatar Ask author a question

Reviews

This model has no reviews yet

Be the first to purchase this model and leave a review. Add this to your cart

Need some help?

This modeller has offered to support this model, you can commission them to support your model and customise it through Model Factory.

Get Support

Can't find what you need? No problem.

Start a Model Factory job for FREE and engage a professional to build your model for you.

Start Job