Difference between revisions of "Manuals/calci/XNPV"
(6 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''XNPV(Rate, | + | <div style="font-size:30px">'''XNPV (Rate,CashFlowValues,Dates) '''</div><br/> |
*<math>Rate</math> is the discount rate to apply to the cash flows | *<math>Rate</math> is the discount rate to apply to the cash flows | ||
− | *<math> | + | *<math>CashFlowValues</math> is a series of cash flows that corresponds to a schedule of payments in dates |
*<math>Dates</math> is a schedule of payment dates. | *<math>Dates</math> is a schedule of payment dates. | ||
+ | **XNPV(), returns the net present value for a schedule of cash flows that is not necessarily periodic. | ||
==Description== | ==Description== | ||
Line 15: | Line 16: | ||
*<math>d_0</math> = the <math>0^{th}</math> payment date | *<math>d_0</math> = the <math>0^{th}</math> payment date | ||
*<math>P_i</math> = the <math>i^{th}</math> payment. | *<math>P_i</math> = the <math>i^{th}</math> payment. | ||
− | |||
+ | ==Examples== | ||
− | + | {| class="wikitable" | |
− | + | |- | |
− | + | ! !! A !! B | |
− | + | |- | |
− | XNPV( | + | ! 1 |
− | + | | -12000 || 02-01-2009 | |
− | + | |- | |
+ | ! 2 | ||
+ | | 3000 || 04-01-2009 | ||
+ | |- | ||
+ | !3 | ||
+ | | 4300 || 11-30-2009 | ||
+ | |- | ||
+ | ! 4 | ||
+ | | 3250 || 03-15-2010 | ||
+ | |- | ||
+ | ! 5 | ||
+ | | 2200 || 5-1-2010 | ||
+ | |} | ||
+ | =XNPV(0.95,A1:A5,B1:B5)= -4330.389965454265 | ||
− | + | ==Related Videos== | |
− | + | {{#ev:youtube|CVgWvOFyGew|280|center|XNPV}} | |
− | + | ==See Also== | |
+ | *[[Manuals/calci/NPV| NPV]] | ||
+ | *[[Manuals/calci/PPMT| PPMT]] | ||
+ | *[[Manuals/calci/PV| PV]] | ||
− | + | ==References== | |
+ | *[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_XNPV_function Xnpv] | ||
− | |||
− | |||
− | + | *[[Z_API_Functions | List of Main Z Functions]] | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | *[[ Z3 | Z3 home ]] | |
− | |||
− |
Latest revision as of 17:05, 27 July 2018
XNPV (Rate,CashFlowValues,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.
- XNPV(), returns the net present value for a schedule of cash flows that is not necessarily periodic.
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
A | B | |
---|---|---|
1 | -12000 | 02-01-2009 |
2 | 3000 | 04-01-2009 |
3 | 4300 | 11-30-2009 |
4 | 3250 | 03-15-2010 |
5 | 2200 | 5-1-2010 |
=XNPV(0.95,A1:A5,B1:B5)= -4330.389965454265
Related Videos
See Also
References