ISPMT
Calculates the interest paid during a specific period of an investment.
FinancialFinance & Accounting
What it does
Calculates interest paid (straight-line principal).
Syntax
ISPMT(rate, per, nper, pv)
Arguments
rate(number) — Interest rate.per(number) — Period.nper(number) — Total periods.pv(number) — Present value.
Examples
Straight-line Interest
Interest for period 1.
FORMULA
=ISPMT(0.1, 1, 3, 1000)
RESULT
-66.67
SAMPLE DATA
| A | |
|---|---|
| 1 | Loan |
| 2 | 1000 |