Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
PV and working backwards. PV(rate, periods, payment) answers the reverse question to PMT: given a payment you can afford, how big a loan does it pay off? Use monthly rate and periods, and a minus on the payment for a positive amount. Typing guesses and nudging them until the result hits the target is what Goal Seek does for you.
=PV(E2/12,E3*12,-E4) the largest lease a monthly budget in E4 covers
Marcus Hill can spend at most the monthly budget in B4 on a forklift loan for the South warehouse. B6 already works out the payment for whatever loan amount sits in B1.
Put a loan amount in B1 so the payment in B6 equals the budget in B4, to the cent. You can type amounts and adjust, or calculate the amount with a formula.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Loan amount | |||||||
| 2 | Annual rate | 7.0% | ||||||
| 3 | Years | 4 | ||||||
| 4 | Monthly budget | $700.00 | ||||||
| 5 | ||||||||
| 6 | Monthly payment | $0.00 | ||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 |
=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