ispmt

Interest paid in a specific period (straight-line schedule).

Syntax

v = ispmt(rate, per, nper, pv)

Description

Returns the interest paid during period per for a loan paid down in equal principal amounts each period (Lotus-1-2-3 compatibility).

Example

ispmt(0.05/12, 1, 360, 200000)

See also

• ipmt — Interest portion of a periodic loan payment.
• pmt — Periodic payment for a loan or annuity.