Manuals/calci/XNPV
XNPV(Rate,V,Dates)
- is the discount rate to apply to the cash flows
- is a series of cash flows that corresponds to a schedule of payments in dates
- is a schedule of payment dates.
Description
- This function computes the net present value for a schedule of cash flows that is not essentially periodic.
- The arguments should be numeric's.
- XNPV shows the error value whenever any number in dates precedes the starting date or values and dates contain a different number of values.
- XNPV is calculated as follows:
where:
- = the payment date,
- = the payment date
- = the payment.
Examples
Column1 | Column2 | Column3 | Column4 | |
Row1 | -10000 | 02-01-2009 | 2069.5268 | |
Row2 | 3000 | 04-01-2009 | ||
Row3 | 4300 | 11-30-2009 | ||
Row4 | 3250 | 03-15-2010 | ||
Row5 | 2200 | 05-01-2010 | ||
Row6 | ||||
Row7 |