Calculates the interest paid during a specific period of an investment.
تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.
ISPMT(rate, per, nper, pv)The ISPMT function calculates the interest portion of a loan or investment payment for a specific period. It assumes a linear amortization schedule where the principal is paid off in equal installments.
=ISPMT(0.05, 1, 3, 10000)النتيجة: -500
Calculates the interest for the first period of a 3-year loan of 10,000 at 5% interest.
ISPMT assumes a linear amortization schedule, whereas IPMT assumes a constant payment amount (annuity) where interest decreases over time.