Difference between revisions of "Manuals/calci/FV"
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type) where, '''Rate''' - is the interest rate per pe...") |
(No difference)
|
Revision as of 21:36, 24 October 2013
FV(Rate, NoPaymentPeriods, Payments, PresentValue, 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.
PresentValue - the present 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
Calci returns the future value of an investment based on period, constant interest rate and constant payments.
The annual interest rate is divided by 12 beacuse it is compounded montly.
FV
Lets see an example in (Column1, Row6)
=FV(0.02/12,R2C1,R3C1,R4C1,R5C1)
FV returns -259.258832.
Consider an another example(Column1, Row2)
=FV(0.02/12,5,-45,-1000,3)
FV returns #ERROR(Type other than 0 or 1).
Column1 | Column2 | Column3 | Column4 | |
Row1 | 2% | |||
Row2 | 11 | |||
Row3 | -50 | |||
Row4 | 800 | |||
Row5 | 1 | |||
Row6 | -259.258832 |