Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
NPER. NPER(rate, payment, present_value) returns how many periods a loan takes to pay off. Give the rate per period, and the payment and the loan opposite signs: the loan comes in, the payments go out. The answer is usually not whole; the last payment is smaller, so round up to count it.
=NPER(E2/12,-E3,E1) months to clear a supplier credit balance
The North warehouse financed a forklift and Elena Petrova wants to pay a fixed amount each month. She needs to know how many monthly payments it takes, counting a final part-payment as a full month.
In B5, calculate the number of monthly payments needed to repay the loan in B1 at the annual rate in B2, paying the amount in B3 each month. Round up to a whole number of months.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Loan | $12,000 | ||||||
| 2 | Annual rate | 5.0% | ||||||
| 3 | Monthly payment | $800 | ||||||
| 4 | ||||||||
| 5 | Months to pay off | |||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe