$5,000 is deposited today into a bank account. The account earns 2.7% per annum compounded half yearly for the first 7 years, then 8.1% per annum compounded quarterly thereafter. Assuming no further deposits or withdrawals are made.

On Excel

a) Calculate the account balance six months from today.

b) Calculate the account balance 7 Years from today.

c) Calculate the account balance 7.5 Years from today.

d) Calculate the account balance 10 Years from today.