PPMT
Returns the payment on the principal for an investment for a given period.
FinancialFinance & Accounting
What it does
Calculates the principal portion of a loan payment.
Syntax
PPMT(rate, per, nper, pv, [fv], [type])
Arguments
rate(number) — Interest rate.per(number) — Period.nper(number) — Total periods.pv(number) — Loan amount.
Examples
Principal Payment
Principal for period 1.
FORMULA
=PPMT(0.05/12, 1, 60, 10000)
RESULT
-147.05
SAMPLE DATA
| A | |
|---|---|
| 1 | Loan |
| 2 | 10000 |