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

Discounted Cash Flow Excel Model (DABUR India ltd.)

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

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 Best Practice includes
1 Excel DCF Model

Acquire business license for $25.00

Add to cart

Add to bookmarks


Further information

Valuations (conservative investment approach)

Fundamental analysis, Investment decision



  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Jatin Goel

See all

Discussion feed for Discounted Cash Flow Excel Model (DABUR India Ltd.)

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

  • Suhanee Shome
    I am stuck in this part of balance sheet assumptions-
    Non- Current Borrowings-
    Addition -
    End balance Borrowings-

    And i have to take the adjustment from the annual report of dabur (2018-2019) page no-265 and 266
    arrow_drop_uparrow_drop_downReply reply
    • Suhanee Shome
      Hi, i was preparing the financial modelling of dabur but right now i am stuck with the borrowings part in assumptions. I need to take the adjustments from the annual report(2018-2019) but dont know how to take this adjustments. Please help me
      arrow_drop_uparrow_drop_downReply reply

      0.0 / 5 (0 votes)

      please wait...