writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <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-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>+ + + + + + + + − <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>+ − + − </div>+ − ----+ − <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> − − </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − * <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> − − * <font color="#000000"><font face="Arial, sans-serif"><font size="2">XNPV is calculated as follows: </font></font></font> − − <font color="#000000"></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">where:</font></font></font> − − <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> − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − </div></div>+ − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font> − <font color="#000000"><font face="Arial, sans-serif"><font size="2">XNPV(R, V, dates)</font></font></font>+ Line 52:
Line 33: − +
no edit summary
'''XNPV'''('''R''','''V''', '''dates''')
*'''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==
*This function computes the net present value for a schedule of cash flows that is not essentially periodic.
*The arguments should be numerics.
*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:
*di = the ith payment date,
*d1 = the 0th payment date
*Pi = the ith payment.
XNPV
XNPV
Lets see an example,</font></font></font>
XNPV(R, V, dates)
<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">'''B C'''</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">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>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQ4279e6deca12de8c-nowiki-00000002-QINU is 2069.5268 ''''''</font></font></font>
</div>
</div>