Google Sheets 함수

IPMT

Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.

AI로 수식 생성 Excel의 동일한 함수

이 함수는 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.

인수

rate필수The interest rate per period.
per필수The period for which you want to find the interest, must be in the range 1 to nper.
nper필수The total number of payment periods in an annuity.
pv필수The present value, or the total amount that a series of future payments is worth now.
fv선택The future value or a cash balance you want to attain after the last payment is made.
type선택The number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

예시

=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.

자주 묻는 질문

Why is the result of IPMT negative?

The result is negative because it represents a cash outflow (payment) from the borrower's perspective.

IPMT

구문

인수

예시

자주 묻는 질문

관련 함수

IPMT

구문

인수

예시

자주 묻는 질문

관련 함수