The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Retirement Investing


Subject:  Re: Need Present value (?) calculation help Date:  1/14/2013  12:16 PM
Author:  akck Number:  71248 of 88496

There are other factors needed in order to come up with an estimate, mainly the discount rate you'd want to apply. You can do an IRR, but you'd need a starting cost to figure it. You can use a spreadsheet and the NPV function to determine a break-even point, by assuming various initial costs. For instance, here's a table of approximate PVs with associated discount rates:

Rate PV
3% 85,000
4% 72,500
5% 62,500
6% 54,250
7% 47,350

As you can see, the PV varies greatly with the discount rate you use.
Copyright 1996-2018 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us