Formula in Access for Excel formula "XNPV"

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

Guest

Does anyone know how the excel “XNPV†formula can be stated in an Access 2000 calculated query field

I need to be able to create a calculated field in Access that gives me the amount I would need to invest today to provide an indexed income stream for a pre determined number of years

Eg. In the event of my death, I want to be able to provide my family with an amount that they can invest at a pre determined interest rate. This amount is then drawn on annually to provide an annuity that is indexed at a pre determined inflation rate for a pre determined number of years

The PV formula in Access only provides for a constant income stream – ie not indexed
 
I'vejust realized that the excel XNPV doesn't really do what I want either. - Basically I want something like the PV formula but instead of a constant annuity, I need it indexed

Can someone please help?
 
Back
Top