Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
IPMT(rate, per, nper, pv, [fv], [type])The IPMT function calculates the interest portion of a loan or investment payment for a specific period. It assumes that payments are made at regular intervals and the interest rate remains constant throughout the term.
=IPMT(0.05/12, 1, 36, 10000)ผลลัพธ์: -41.67
Calculates the interest for the first month of a $10,000 loan at 5% annual interest over 3 years.
The result is negative because it represents a cash outflow (payment) from the borrower's perspective.