How do I use the NPV function in Access?

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

Guest

I would like to NPV some cashflows in a report. Is there an easy way to do
this?
 
DaveP1 said:
I would like to NPV some cashflows in a report. Is there an easy way to do
this?
Click to expand...


No, although it is possible, there is no easy/good way.

Much better to use the PV function. If the payments
are not equal, find the PV of each and use the report
(or summation query) to sum the results.

(david)
 
You must log in or register to reply here.

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

NPV vs XNPV 6
How to make NPV function work in reports 1
NPV of cashflows to assess contribution to a joint venture 2
Variable length array that exludes (possible) blanks in the middle 1
NPV/Sumif 3
Calculate NPV - Array must be flexible 13
Using NPV (Net PresentValue in Access) 11
Offset function gives different answer in columns v Rows 6

Back
Top