Discounted Cash Flow Excel Model (DABUR India ltd.)

Description
This is an Excel based DCF (Discounted Cash Flow) model tool on Dabur India ltd. as per conservative investment approach. where past 5 year actual data is used to forecast the next 5 year data and expected return. In this DCF model free cash flow has been calculated on the basis of future projections and forecasting. Then all those cash flows have been discounted by a rate which is calculated with the CAPM (Capital Asset Pricing Model) approach. The tool also considers the variations on projections, to the some level, because projections don't guarantee a true estimate.

1.Terminal value
2.Perpetual Growth rate
3.EBITDA multiple

Are three parameters which has been considered while making it as a perfect model.

While using the tool you just have to put values and your assumptions (if any).

It will auto calculate the terminal period value and enterprise value of the company.

In last "scenarios" table you will find 3 scenarios which are here to consider the variations ups-downs, clearly showing the EBITDA multiple, company values at all levels.

The model has been prepared and modified as per my understandings and assumptions and according to my investment style it doesn't guarantee you that it is a actual true verdict.

You can modify it to your convenience and it will provide you a clear understandings of DCF (Discounted Cash Flow) model.