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.
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
- The rate behind a financing offer
- Interest and principal in one payment
- NPV on irregular dates
- Average price paid