Interest and principal in one payment
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Split the monthly payment with the number in B4 into its interest part (B5) and its principal part (B6). The rate and the term are yearly, payments are monthly, and both answers must be positive.
What this exercise teaches
Every payment is the same size, but early payments are mostly interest and late ones mostly principal. IPMT and PPMT add up to PMT for any payment number, which is how an amortization schedule is built.
A hint if you get stuck
IPMT(rate, period, number of periods, present value) is the interest in one payment and PPMT is the principal. Both take the payment number as their second argument.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Finance
- Loan installment
- Is the project worth it?
- Growth over time
- Portfolio return
- Internal rate of return
- Value of an annuity
- Total interest on a loan
- Compound annual growth
- Break-even units
- Straight-line depreciation
- Monthly deposit for a goal
- Effective annual rate
- Months to clear a balance
- The rate behind a financing offer
- NPV on irregular dates
- Average price paid