Formuladrill

Level 5: Finance Exercise 89 of 118

Months to clear a balance

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

How many monthly payments does it take to clear the card balance in B1, paying the amount in B3 every month at the yearly rate in B2? The last payment may be smaller, so round up to whole months. Answer in B4.

What this exercise teaches

NPER solves the loan equation for the number of periods. It returns a fraction (29.97 here), and since a part payment still takes a month, the answer rounds up.

A hint if you get stuck

NPER(rate per period, payment, present value). The rate is monthly, and the payment is negative because it is money you pay out.

Functions used: NPER, ROUNDUP

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