Difference between revisions of "Manuals/calci/FV"

From ZCubes Wiki
Jump to navigation Jump to search
(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).


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 2%
Row2 11
Row3 -50
Row4 800
Row5 1
Row6 -259.258832