| Line 42: |
Line 42: |
| | #=PV(5%/12,25*12,25000,1) = -4276501.46327 | | #=PV(5%/12,25*12,25000,1) = -4276501.46327 |
| | | | |
| | + | ==See Also== |
| | + | *[[Manuals/calci/FV | FV ]] |
| | + | *[[Manuals/calci/IPMT | IPMT ]] |
| | + | *[[Manuals/calci/PPMT | PPMT ]] |
| | + | *[[Manuals/calci/NPER | NPER ]] |
| | + | *[[Manuals/calci/PV | PMT ]] |
| | | | |
| | | | |
| − | | + | ==References== |
| − | | |
| − | | |
| − | | |
| − | where ,, , , and
| |
| − | | |
| − | | |
| − | <div id="6SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | '''PV'''(Rate, NoPaymentPeriods, Payments, FutureValue, Type)
| |
| − | | |
| − | where,
| |
| − | | |
| − | '''Rate''' - is the interest rate per period.
| |
| − | | |
| − | '''NoPaymentPeriods''' - is the total number of payment periods
| |
| − | | |
| − | '''Payments''' - the payment made each period, it not change over the life of the annnuity.Payment contains principal and interest but except other fees and taxes.If omitted, include PresentValue parameters.
| |
| − | | |
| − | '''FutureValue''' - the future value.If omitted assumed to be 0 and include Payments parameters.
| |
| − | | |
| − | '''Type''' - is indicates payments due by number 0 or 1
| |
| − | | |
| − | '''TYPE Payments due'''
| |
| − | | |
| − | 0 At the end of the period
| |
| − | | |
| − | 1 At the beginning of the period
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | Returns the present vlaue of an investment.
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">If Type other than 0 or 1, PV returns the #ERROR.</div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| − | | |
| − | PV
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | Lets see an example in (Column1, Row6)
| |
| − | | |
| − | UNIQ581acce90e066248-nowiki-00000004-QINU
| |
| − | | |
| − | PV returns -1245262.336586.
| |
| − | | |
| − | Consider an another example(Column1, Row2)
| |
| − | | |
| − | UNIQ581acce90e066248-nowiki-00000005-QINU
| |
| − | | |
| − | PV returns #ERROR(Type other than 0 or 1).
| |
| − | | |
| − | </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="2SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | {| id="TABLE3" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | class=" SelectTD ChangeBGColor SelectTD" |
| |
| − | <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>Column2
| |
| − | | Column3
| |
| − | | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class=" " | 8000
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class="sshl_f" | 2%
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class=" " | 15
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class="sshl_f" | 8
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class="sshl_f " | 1
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | | class="sshl_f" | -1245262.336586
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |}
| |
| − | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |