Present Value calculation with indexed cash flow amounts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Access 2000 and am trying to come up with a formula that calculates the Present Value of a sum invested at say x% that provides a series of cash flows at say y% for fixed term of N years.

For example - how could I express: the amount I would need to invest at 5% today, to provide an income stream of $20,000 indexed at 3% for 10 years

Can anyone help
 
I think you're missing one piece of information: how far into the future
will you start your withdrawl?
--
Bryan Reich
Microsoft Office
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


Margaret said:
I'm using Access 2000 and am trying to come up with a formula that
Click to expand...
calculates the Present Value of a sum invested at say x% that provides a
series of cash flows at say y% for fixed term of N years.
For example - how could I express: the amount I would need to invest at
Click to expand...
5% today, to provide an income stream of $20,000 indexed at 3% for 10 years?
 
I need to provide an annual income stream which will start 1 year from investment start date. The income will be drawn in annual amounts and needs to indexed up at a pre determined inflation rate

Thanks
 
Back
Top