writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 15:
Line 15: − Equation: − + − 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">-10000 02-01-2009</font></font></font> − − <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">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> Line 102:
Line 70: − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----+ − </div>
→Description
*<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==
{| id="TABLE2" class="SpreadSheet blue"
{| id="TABLE2" class="SpreadSheet blue"
|}
|}
==See Also==
==References==