skip to Main Content

Discounted Cash Flow Template

5.0 (3 reviews)

This Discounted Cash Flow template helps you to make projections and estimate the future value of your money with two different methods.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



The Discounted Cash Flow (DCF) is a valuation method that estimates today’s value of the future cash flows taking into account the time value of money. Our Discounted Cash Flow template will help you to determine your value of the investment and calculate how much it will be in the future.

The time value of money concept assumes that one dollar in the future is worth less than today’s dollar. The reason you should invest today’s dollar is to bring in additional value.


Let us assume that the annual interest rate is 10%. Being today put in a saving account, $1 will become $1.10 in one year. It also means that future $1 paid or received in one year is equivalent to today’s $0.91. In a nutshell, at a 10% interest rate, the present value of future $1 is $0.91.

You can use the same concept to value equity investments or a company as a whole. It applies to assess the effectiveness of both financial investments (purchasing equity or debt securities) and business investments (acquiring or starting a business).

What is Discounted Cash Flow Valuation?

Discounted cash flow valuation involves two steps:

Making projections of how much money a company will generate in the future
Discounting projected future cash flows

If the present value of the investment is less than the cost paid, or to be paid by the investor, the investor is better off. It is because he or she obtains an opportunity to make more money than spends. Of course, the usefulness of this assessment depends heavily on how accurate its outcome is.

Here we face two problems:

How to accurately predict future cash flows;
What interest rate should we use to discount projected cash flows.

Discounted Cash Flow Template Features:

Discounting rate must reflect the opportunity cost for an investor, in other words, how much an investor could earn, should he or she decide to put his or her money elsewhere. However, the problem is that there exists a wide range of investment opportunities, with dramatically different return rates. Assume that the relevant return rate must reflect the risk level associated with an investment. The more risk an investment involves, the higher the interest rate it has to provide.

The weighted average cost is generally used within place of discount rate when a company evaluate its value. A commonly accepted convention is that the company’s weighted cost of capital (WACC) already takes into account the risk level associated with the company’s business.

WACC – Weighted Average Cost of Capital

The Discounted Cash Flow template calculates WACC using the company’s historical financial data, as well as Capital Asset Pricing Model.

Most companies finance their operations using various mixes of equity and debt. While it is quite straightforward to calculate the cost of debt, it is not so for the equity part, because, unlike debt, equity does not have an explicitly associated cost. If a company pays its shareholders dividends on a regular basis, you can calculate the cost of equity by dividing dividends by the equity value. However, dividend policies are not consistent across companies, and some companies do not pay dividends at all. In such cases, the only available option for estimating the cost of equity is using the Capital Asset Pricing Model (CAPM).


Our Discounted Cash Flow Model template allows you to select two different methods.

In the WACC section, select Equity Cost Calculation Method in the Assumptions sub-section, as provided above. Please enter the applicable income tax rate. It will have an effect on both WACC and free cash flow calculations, thus affecting enterprise value.

What are the CAPM Variables?

If you chose using CAPM for calculating the cost of equity, you need to enter the parameters of the model:


Fill in historical data for Equity Value, Dividends, Market Value of Debt, and Interest Expenses. This DCF Template will calculate After-Tax Cost of Debt by dividing Interest Expenses by the Market Value of Debt, less tax effect of the cost of debt.Discounted-Cash-Flow-Excel-Template-Someka-S03

According to the selected method, you can calculate the Cost of Equity by dividing Dividends by the Market Value of Equity or using CAPM. WACC is equal to the average cost of equity and debt, weighted on equity and debt market values respectively.


You can override calculated interest rates with manually entered User-Defined Rates. After you calculated WACC, go to the Cash Flow section.

Cash Flow

Enter historical financials (from the income statement) along with forecasted figures for the current year. You must enter at least three sequential years of data, including the most recent forecast. You can use the blue written parameters to make predictions about future cash flows.Discounted-Cash-Flow-Excel-Template-Someka-S05

Cash Flow Projection parameters calculate automatically (min, max, and mean value), but you can enter any parameter value manually. Unless you enter User-Defined Value, the mean value of the respective parameter will be used in the calculation of projected future cash flow.

Discounted-Cash-Flow-Excel-Template-Someka-S07The present value of expected cash flows for the next 10 years shows up by applying WACC to calculate the discounted cash flow. The terminal value represents the present value of cash flows beyond the 10-year periodDiscounted-Cash-Flow-Excel-Template-Someka-S08

To arrive at a market capitalization of the company, the calculated present value of future cash flows (enterprise value) is adjusted for an outstanding debt and cash on hand (manually entered). Dividing the market capitalization by a number of outstanding shares will give you an estimated share price.

Someka Discounted Cash Flow Template Features

  • Making a projection for your future value of money
  • DCF Template in Excel
  • Works both on Mac and Windows
  • No installation needed, ready to use.
  • On Sheet Instructions
  • Print-Ready
  • Compatible with Excel 2007 and later versions

This Discounted Cash Flow Excel template is ready-to-use and provided as is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



3 reviews for Discounted Cash Flow Template

  1. stella moi

    the information was really helpful

  2. ahlat mus

    excellent product

  3. javier

    excellet product

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.