Using Microsoft Excel, calculate the total amount you will receive in a year if you invest $1,000 now (assuming the interest rate is 8% per annum) at:
a. yearly compounding
b. semiannually compounding
c. quarterly compounding
d. daily compounding
This solution calculates the profit after a year of investing based on different compounding periods.