The Present Value of a Future Cash Flow - Why Understanding Present Value is Crucial To Any Real Estate Analysis
75
Present Value is All About Time Value of Money
Understanding the concept of present value is essential for any sound investment real cash flow analysis that might (and could) ultimately lead to an investment decision.
So if you are engaged in real estate investing then this one's for you because we are going to discuss present value and how this time value of money concept can play a major role in your next real estate investment decision.
What is Present Value?
The idea is straightforward,
The concept is that the money you might collect in a year or two from a rental property will not have the same purchasing power as it would today (undoubtedly due to inflation). Therefore, due to a concept known as the time value of money, the revenues you might expect to collect from a rental property in future years might be meager when compared to today's dollars, and therefore not worth as much as you think they are.
Consequently, you would want to calculate the present value of a future cash flow (or series of cash flows) to establish the cash flow an income-producing property generates in today's dollars so you can determine what that property is worth to you today.
Discount Rate
The present value of a future cash flow utilizes a discount rate to compute the worth of those dollars to today’s dollars. Think of it this way. Rather than adding value to (say) money placed in a savings account with compound interest over several years, discounting reverses the process.
That is, it reduces the value of money you might collect in the next several years at a given discount rate to figure out its current worth.
A good rule of thumb to use when choosing an appropriate discount rate for calculating present value of a future cash flow would be for you to answer the question, "What rate of return could I reasonably expect to achieve by investing the same amount of money in a similar investment with comparable risk?" Put another way: "What else is competing for my investment dollar, and what does it return?"
The Formula
PV = FV/(1 + r)n
Where r is the rate per period and n is the number of periods.
Okay, let's consider a simplified example that ignores annual cash flow and deals only with the present worth of the single cash flow you expect to collect when the property is sold.
Assume you're looking at a rental property you believe can be sold at the end of five years for $700,000. You decide that your desired rate of return is 11.0% per year and want to know what the property is worth to you today. Namely, you want to know what price you should pay for the rental property in order to achieve your desired rate of return.
Here's what you do.
Solve for the present value of the future value anticipated in x-number of years by discounting that future value using your desired rate of return as the discount rate.
In this case, the future value is $700,000, the number of years is five, and the discount rate is 11.0% per year. The result is $415,416 (rounded). In other words, if you purchase the property for no more than $415,416 and are able to sell it in five years for $700,000, you will earn a rate of return of 11.0% per year.
As a real estate investor present value should be of keen interest. However, it is not a calculation that can be run in your head. In this case, you can consider using Excel, or better yet, a good real estate analysis software or real estate calculator solution that includes computations for present value and other time value of money returns.
About the Author
James Kobzeff is a real estate professional and the owner/developer of ProAPOD - affordable real estate investment software solutions that do include time value of money and present value computations.
Books to Consider
![]() | Amazon Price: $0.99 |
Amazon Price: $6.99 List Price: $14.95 | |
![]() | Amazon Price: $11.20 List Price: $19.95 |
![]() | What Every Real Estate Investor Needs to Know About Cash Flow... And 36 Other Key Financial Measures Amazon Price: $12.04 List Price: $22.95 |
![]() | Amazon Price: $12.57 List Price: $21.99 |
CommentsLoading...
Hi, Manilento
As a new agent you might find my software helpful. Please visit www.proapod.com I also have more articles on that site under Learning Center. Thank you for your comment.
Hi i am confused. i am doing an assignment that is asking me to calculate the PV and NPV of an investment property that is worth $480,000 and hope to sell for $575,000 in 3 years time. I am given a discount rate of 7.5% (this includes the 7.2% for the property loan) and cash flows of 20665 year 1, 21307 year 2 and 21862 year 3. The initial investment was $130,000 leaving a loan of $350,000.
I have read many of your articles on the web which explain things well but if i use the pv formula above i get a high number over 466749 but if i calculate the PV as part of a NPV calculation it works out different as I am discounting the cashflows and adding the sales proceeds of 225,000 after repaying the loan.
Is there 2 different ways of calculating this or if someone asks you what is the present value of my property, do you just give them the formula you have mentioned above?
Hi James,
thanks for the quick reply. I had that PV number calculated but I got confused because I read an ezine article you wrote which said you need to use the sale proceeds (less "outstanding loan balances") in my calcs except the whole $575000 from the sale of the property.
Mr. Jamesrk
Thank you for this informative Hub.
I am an accountant, I wrote a hub about calculating real rate when you take loans using MS Excel.
I am sure you will find it useful for improving your real estate investment.
(Car Loans – Take Care – Accounting POV focusing on the interest RATE – MS Excel)
You can also add the expected dates & amounts of the rent revenue (Monthly, yearly), so you can have a better investment decision.
I voted "Useful"
Thanks
IS THERE any change in the value of money for yesterday, today and tomorrow?
Hi James,
I commented on your page 2 months ago about an assignment I was doing asking to calculate the PV and NPV of an investment property. Your reply that deducting the original investment ($130,000 deposit) from the PV of $518,111 made sense but the examiner has marked me wrong.
On querying this they told me that I must not deduct the loan value from the PV result to get the NPV but should deduct the "initial cash flow, that is the purchase price". With your expertise on the matter are my teachers just clowns when it comes to this subject or is there different ways of interpreting it?
I needed to the go on and calculate the IRR which from my original calcs gives me an IRR of 75% which sounds a little high but it was also marked incorrect.
Are you able to see where I went wrong?
hi can i just ask is net cash flow same as turnover?
Thank you
Hi
I need your help to calculate the Pv of future minimum leaase payments over no of yeras( 5 where rate of intresrt is 3 %.....in which future payments are given like this..
1 1st yr 2000
2nd year 1200
3rd year 850
4th and thereafter 3200
Total 10000/-
How we can calculate present value in this case each year
till 1oth year















manilenio 16 months ago
excellent article! I've recently gone into real estate and would love to learn how to advise potential buyers about the present value of a property to help them decide if the property is right for them. Can you write more about how to come to an accurate discount rate and economic life of a property to come up with a more accurate present value amount? thanks!