Use a spreadsheet to show how you accumulate your money.
2. (Future value of an annuity) You are trying to plan for retirement in 10 years and currently you have $150,000 in a savings account and $250,000 in
stocks. In addition, you plan to deposit $8,000 per year into your savings account at the end of each of the next 10 years
Assuming your savings account returns 8 percent compounded annually, but credited every quarter to your account, and your investment in stocks will
return 12 percent compounded annually, how much will you have at the end of 10 years?
Use a spreadsheet to show how the money is accumulated [P1]