Formula in Access for Excel formula "XNPV"

M

Margaret

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
 
M

Margaret

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
Autonumber field in Excel that behaves the same as Access 0
Present Value calculation with indexed cash flow amounts 2
XNPV with Formula Builder 2
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
Cannot verify XNPV with PV or HP-12C 4
XIRR vs. IRR Function 11
Financial Time Value of Money calculations 5

Top