Calculate principal payments for an annuity for a given period.


Annuity_PPMT('rate', 'per', 'nper', 'pv', ['fv'], ['type'])


rateYesdoubleThe interest rate per period.
perYesdoubleSpecifies the period and must be in the range 1 to nper.
nperYesdoubleThe total number of payment periods in an annuity.
pvNodoubleThe total amount that a series of future payments is worth now.
fvNointThe future value, or cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
typeNodoubleThe number 0 (the end of the period) or 1 (the start of the period), indicates when payments are due.

Example 1

Annuity_PPMT(0.08 / 12, 1, 60, -50000) Returns -680.48