Answer:
Amount in savings account after 7 and a half years is $8,113.62
Explanation:
Given:
Quarterly payments made in savings account (pmt) = $200
Annual interest rate = 8%
Quarter interest rate (rate) = 8÷4 = 2%
Compounding period (nper) = 7 and a half years or 7.5×4 = 30 quarterly payments
This is an annuity as uniform amount of $200 is deposited every quarter.
Savings at the end of seven and a half years mean future value of annuity.
Future value of annuity can be computed using spreadsheet function =FV(rate, nper,pmt,PV)
Savings account will have $8113.62 at the end of seven and a half years.