Need NPV (Net Present Value) Help

[BlackOnBlack]

I have a table that looks like this:

View attachment Access NPV Table.bmp

I'm trying to get the net present value for each asset for the values in the last column. Any suggestions? Thanks in advance to those who reply.

 

[gemma-the-husky]

you wouldnt store this in a table, since it changes as other external factors change (although clearly you could store the calc result at a given point in time)

but you can calculate it when you need it - access has an inbuilt npv function that will do it.

 

[BlackOnBlack]

The inbuilt NPV function doesn't work. I need to calculate NPV for up to 40 periods out, and Access comes back that my query is too complex or something like that.

 

[gemma-the-husky]

usage of npv is as follows

NPV(rate, values())

rate is self-explanatory

values is an array of cash flows

i would imagine you dont have the values array set up correctly to use the function.

how are you trying to call the function?