Do-It-Yourself DCF Valuation Blank Template with Forecasting
Originally published: 01/12/2020 10:32
Publication number: ELQ-21772-1
View all versions & Certificate

Do-It-Yourself DCF Valuation Blank Template with Forecasting

Do-It-Yourself DCF Valuation Excel Model

The process of valuation is both art and science and hence we leave it up to you for making appropriate assumptions. The rest of the workbook is completely formula based.

The entire Do-it-yourself valuation takes about 10-15 hours for one company and you can master the process by using this Excel template. All you need to do is take past data from websites or annual reports, fill suitable assumptions in the given areas, forecast the financial statements and apply the discounting factors to get the Intrinsic value of stocks. This model is applicable to all the listed companies in the world.

The Excel model covers all the major fundamental aspects of the company over 15 years period. The model is easy to edit and update for the future years as well when the company releases its new annual report. It also includes interactive charts used for visualization of both original last 10 years data and the forecasted 5 years values for the company's financials.

Discounted cash flow (DCF) is a valuation method used to estimate the value of an investment based on its expected future cash flows. DCF analysis attempts to figure out the value of an investment today, based on projections of how much money it will generate in the future. The following step by step procedure should be followed.

Determining the Revenue Growth Rates
Forecasting the Financial Statements
Deriving the FCFF and FCFE
Calculating the Terminal Value
Calculating the Discount Rate
Discounting the Cashflows
Arriving at the Intrinsic Value of the Shares

You can also get our "Stock Valuation Handbook Series" from Amazon for additional help.

Note: This is a blank Template and needs your input for calculations. All the research done by us is only for educational purposes and should not be seen as Investment recommendations. We are Research analysts and not a SEBI registered Investment Advisor. My research completely reflects my personal opinions and not of my employers. Kindly do your own due diligence before Investing

This Best Practice includes
1 Microsoft Excel Model

Acquire nonprofit license for $3.50

Add to cart

Add to bookmarks


Further information

The aim is to provide a thorough outlook into the company's financial position. This will help the students and Investors who are looking to do their own due diligence before investing in the Indian Stock Markets.

DCF Valuation, Intrinsic Price Calculation, Fundamental Analysis, Financial Statements Forecasting

0.0 / 5 (0 votes)

please wait...