Discounted Cashflow Template
Originally published: 04/03/2021 14:27
Publication number: ELQ-95767-1
View all versions & Certificate

Discounted Cashflow Template

Make projections and estimates with our ready-to-use Discounted Cash Flow Excel Template.

Make projections and estimates of the future value of your money using two different methods. Determine the value of your investments and calculate their value in the future.

Discounted Cash Flow (DCF) is a method of valuation that enables you to estimate the value of future cashflows today, taking into account the time value of money.

The time value of money is a concept that assumes that one US dollar in the future is worth less than one US dollar today.
For example, let’s assume that the annual interest rate is 10%. If put in a saving account today, $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. Thus, at a 10% interest rate, the present (discounted) value of future $1 is $0.91.
This same concept can be used to value equity investments or an entire company. It assesses the effectiveness of financial and business investments.

Someka Discounted Cash Flow Template Features:
• Estimate the future value of your money.
• Discounted Cash Flow Valuation in Excel.
• Functional on both on Mac and Windows.
• No installation needed.
• On Sheet Instructions.
• Print-Ready.
• Compatible with Excel versions 2007 and later.

This Best Practice includes
1 Excel Template

Someka offers you this Best Practice for free!

download for free

Add to bookmarks




More Best Practices from Someka

See all

Any questions on Discounted Cashflow Template?

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

4.2 / 5 (5 votes)

please wait...