Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
FV. FV(rate, periods, payment) gives what regular payments grow to, including the interest earned along the way. As with PMT, rate and periods must be per month for monthly saving, and money you pay in counts as negative, so a minus gives a positive result.
=FV(E2/12,E3*12,-E1) what a monthly pension contribution grows to
Instead of borrowing, Brightline could set aside a fixed amount every month for new warehouse racking. The savings account pays the annual rate in B2.
In B5, calculate how much the fund holds at the end, saving the monthly amount in B1 for the years in B3. Show it as a positive number rounded to 2 decimals.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Saved per month | $1,500 | ||||||
| 2 | Annual rate | 4.0% | ||||||
| 3 | Years | 3 | ||||||
| 4 | ||||||||
| 5 | Fund at the end | |||||||
| 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