Discounted Cash Flow Excel Model (DABUR India ltd.)
  • Discounted Cash Flow Excel Model (DABUR India ltd.)
  • Discounted Cash Flow Excel Model (DABUR India ltd.)
  • Discounted Cash Flow Excel Model (DABUR India ltd.)
  • Discounted Cash Flow Excel Model (DABUR India ltd.)
  • Discounted Cash Flow Excel Model (DABUR India ltd.)
Originally published: 24/09/2018 09:12
Last version published: 24/09/2018 18:06
Publication number: ELQ-48079-3
View all versions & Certificate
certified

Discounted Cash Flow Excel Model (DABUR India ltd.)

DCF model for Dabur India ltd. On conservative Investment Approach.

capmdcfdiscounted cash flowfree cash flowinvestment bankingscenario analysisvaluations

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.

This business tool includes
1 Excel DCF Model

Acquire business license for $25.00

Add to cart

Add to bookmarks

Discuss

Further information

Valuations (conservative investment approach)

Fundamental analysis, Investment decision

Trading

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Jatin Goel

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Discounted Cash Flow Excel Model (DABUR India Ltd.)?

The user community and author are here to help. Go ahead!

please wait...