Problem:
You have just placed $1,500 in a bank savings deposit and plan to hold that deposit for eight years, earning 5.5 percent per year. If the bank compounds interest daily, what will be the total value of the deposit in eight years? How does your answer change if the bank switches to monthly compounding? Quarterly compounding?
PLEASE USE AN EXCEL SPREADSHEET FOR RESPONSE.