Manuals/calci/PMT

From ZCubes Wiki
Revision as of 21:42, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''PMT'''(Rate, NoPayments, PresentValue, FutureValue, Type) where, '''Rate''' - represents the interest rate...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

PMT(Rate, NoPayments, PresentValue, FutureValue, Type)

where,

Rate - represents the interest rate for the loan.

NoPayments - the total number of payments for the loan.

PresentValue - represents the present value.

FutureValue - represents the future value.

If omitted cosidered as a 0.

Type - represents payments due.

Type              Payment Due

0 or omitted    end of the period

1                     beginning of the period


It returns the payment for a loan based on constant interest rate and constant payments.


If Type other than 0 or 1, PMT returns the #ERROR.


PMT


Lets see an example in (Column1, Row6)

=PMT(0.2/12, R2C1, R3C1, R4C1, R5C1)

PMT returns -10333.287654.

Consider another example

=NPER(0.1/12,50,52000,1,4)

It returns #ERROR.


Syntax

Remarks

Examples

Description

Column1
Column2
Column3 Column4
Row1 20%
Row2 5
Row3 50000
Row4 0
Row5 1
Row6 -10333.287654