Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
PMT. PMT(rate, periods, present_value) gives the payment per period on a loan. Rate and periods must use the same period: for monthly payments divide the annual rate by 12 and multiply the years by 12. PMT returns money going out as negative, so put a minus in front of the loan amount to get a positive payment.
=PMT(E2/12,E3*12,-E1) monthly payment on a printer lease
Daniel Ortiz wants a second delivery van for the West region. The dealer offers a loan for the full price at the annual rate in B2 over the years in B3, paid monthly.
In B5, calculate the monthly payment from the price in B1, the annual rate in B2 and the years in B3. Show it as a positive number rounded to 2 decimals.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Van price | $38,000 | ||||||
| 2 | Annual rate | 6.5% | ||||||
| 3 | Years | 5 | ||||||
| 4 | ||||||||
| 5 | Monthly payment | |||||||
| 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