Difference between revisions of "Manuals/calci/XNPV"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''XNPV'''</font></font><font face="Arial, sans...")
 
 
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left"> 
+
<div style="font-size:30px">'''XNPV (Rate,CashFlowValues,Dates) '''</div><br/>
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''XNPV'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''R'''</font></font><font face="Arial, sans-serif"><font size="2">, </font></font><font face="Arial, sans-serif"><font size="2">'''V'''</font></font><font face="Arial, sans-serif"><font size="2">, </font></font><font face="Arial, sans-serif"><font size="2">'''dates'''</font></font><font face="Arial, sans-serif"><font size="2">)</font></font></font>
+
*<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.
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'rate''''</font></font><font face="Arial, sans-serif"><font size="2"> 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 and 'dates' is a schedule of payment dates.</font></font></font>
+
==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:
 +
<math>\sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{(date_i-date_0)}{365}}=0</math>
 +
where:
 +
*<math>d_i</math> = the <math>i^{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.
  
−
</div>
+
==Examples==
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left"> 
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">This function computes the net present value for a schedule of cash flows that is not essentially periodic. </font></font></font>
+
{| class="wikitable"
−
 
+
|-
−
</div>
+
! !! A !! B
−
----
+
|-
−
<div id="7SpaceContent" class="zcontent" align="left"> 
+
! 1
−
 
+
| -12000 || 02-01-2009
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">The arguments should be numerics.</font></font></font>
+
|-
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">XNPV shows the error value whenever any number in dates precedes the starting date or values and dates contain a different number of values.</font></font></font>
+
! 2
−
 
+
| 3000 || 04-01-2009
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">XNPV is calculated as follows: </font></font></font>
+
|-
−
 
+
!3
−
<font color="#000000"></font>
+
| 4300 || 11-30-2009
−
 
+
|-
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">where:</font></font></font>
+
! 4
−
 
+
| 3250 || 03-15-2010
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">di = the ith payment date, d1 = the 0th payment date and Pi = the ith payment.</font></font></font>
+
|-
 +
! 5
 +
| 2200 || 5-1-2010
 +
|}
 +
=XNPV(0.95,A1:A5,B1:B5)= -4330.389965454265
  
−
</div>
+
==Related Videos==
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
XNPV
+
{{#ev:youtube|CVgWvOFyGew|280|center|XNPV}}
  
−
</div></div>
+
==See Also==
−
----
+
*[[Manuals/calci/NPV| NPV]]
−
<div id="8SpaceContent" class="zcontent" align="left"> 
+
*[[Manuals/calci/PPMT| PPMT]]
 +
*[[Manuals/calci/PV| PV]]
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</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">XNPV(R, V, dates)</font></font></font>
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B C'''</font></font></font>
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">-10000 02-01-2009</font></font></font>
+
*[[Z_API_Functions | List of Main Z Functions]]
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">3000 04-01-2009</font></font></font>
 
−
 
 
−
<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>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=XNPV(.07,B2:B6,C2:C6)</nowiki> 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"