Difference between revisions of "Manuals/calci/XNPV"

From ZCubes Wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
'''XNPV'''('''R''','''V''', '''dates''')
+
<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>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.
 +
**XNPV(), returns the net present value for a schedule of cash flows that is not necessarily periodic.
  
−
*'''Where 'rate'''' is the discount rate to apply to the cash flows
 
−
*'V' is a series of cash flows that corresponds to a schedule of payments in dates
 
−
*'dates' is a schedule of payment dates.
 
 
==Description==
 
==Description==
 
*This function computes the net present value for a schedule of cash flows that is not essentially periodic.  
 
*This function computes the net present value for a schedule of cash flows that is not essentially periodic.  
−
*The arguments should be numerics.
+
*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 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:  
 
*XNPV is calculated as follows:  
−
 
+
<math>\sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{(date_i-date_0)}{365}}=0</math>
 
where:
 
where:
−
*di = the ith payment date,
+
*<math>d_i</math> = the <math>i^{th}</math> payment date,
−
*d1 = the 0th payment date  
+
*<math>d_0</math> = the <math>0^{th}</math> payment date  
−
*Pi = the ith payment.
+
*<math>P_i</math> = the <math>i^{th}</math> payment.
−
Equation:
 
−
<math>\sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{(date_i-date_0)}{365}}=0</math>
 
  
−
XNPV
+
==Examples==
  
−
Lets see an example,</font></font></font>
+
{| class="wikitable"
 +
|-
 +
! !! 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
  
−
XNPV(R, V, dates)
+
==Related Videos==
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B C'''</font></font></font>
+
{{#ev:youtube|CVgWvOFyGew|280|center|XNPV}}
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">-10000 02-01-2009</font></font></font>
+
==See Also==
 +
*[[Manuals/calci/NPV| NPV]]
 +
*[[Manuals/calci/PPMT| PPMT]]
 +
*[[Manuals/calci/PV| PV]]
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">3000 04-01-2009</font></font></font>
+
==References==
 +
*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_XNPV_function Xnpv]
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">4300 11-30-2009</font></font></font>
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">3250 03-15-2010</font></font></font>
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2200 05-01-2010</font></font></font>
+
*[[Z_API_Functions | List of Main Z Functions]]
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQ4279e6deca12de8c-nowiki-00000002-QINU is 2069.5268 ''''''</font></font></font>
 
−
 
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="9SpaceContent" class="zcontent" align="left"><div>
 
−
 
 
−
{| id="TABLE2" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| class="      " | Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f  " | -10000
 
−
| class="sshl_f  " | 02-01-2009
 
−
| class=" sshl_f      " | 2069.5268
 
−
| class="                                    sshl_f  " |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 3000
 
−
| class="sshl_f  " | 04-01-2009
 
−
| class="                                                                                " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 4300
 
−
| class="sshl_f" | 11-30-2009
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 3250
 
−
| class=" " | 03-15-2010
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class=" " | 2200
 
−
| class=" " | 05-01-2010
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| class="sshl_f" | Row6
 
−
| class="                                                    sshl_f  " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class="sshl_f  " |
 
−
|- class="odd"
 
−
| class="sshl_f  " | Row7
 
−
| class=" " |
 
−
| class="                          sshl_f  SelectTD  SelectTD" |
 
−
<div id="9Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="9Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
−
|
 
−
|
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 
−
</div>
 

Latest revision as of 16: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

XNPV

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/XNPV&oldid=210804"