Formuladrill

Level 5: Finance Exercise 91 of 118

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.

Functions used: IPMT, PPMT

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 exercise

More exercises in Finance