Present Value calculation with indexed cash flow amounts

[Margaret]

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

 

[Bryan Reich [MSFT]]

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

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?

 

[Margaret]

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