Returns the cumulative principal paid on a loan between two periods.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
CUMPRINC(rate, nper, pv, start_period, end_period, type)The CUMPRINC function calculates the total principal portion of loan payments within a specified range of periods. It is useful for determining how much of a loan balance has been paid off between a start and end period.
=CUMPRINC(0.05/12, 360, 200000, 1, 12, 0)결과: -4356.51
Calculates the cumulative principal paid in the first year of a 30-year loan at 5% interest.
CUMPRINC returns a negative value because it represents an outgoing cash flow (payment) from the borrower's perspective.