Google Sheets 함수

PPMT

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

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

이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.

구문

PPMT(rate, per, nper, pv, [fv], [type])

The PPMT function calculates the principal portion of a loan payment for a specific period. It assumes that the interest rate and payment amounts remain constant throughout the life of the loan.

인수

rate필수The interest rate per period.
per필수The period for which you want to find the principal payment (must be in the range 1 to nper).
nper필수The total number of payment periods in an investment.
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 (defaults to 0).
type선택The number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

예시

=PPMT(0.05/12, 1, 36, 10000)

결과: -260.44

Calculates the principal portion of the first payment for a $10,000 loan at 5% annual interest over 36 months.

자주 묻는 질문

Why is the result of PPMT negative?

In Excel financial functions, cash outflows (payments) are represented as negative numbers.

PPMT

구문

인수

예시

자주 묻는 질문

관련 함수

PPMT

구문

인수

예시

자주 묻는 질문

관련 함수