Explore BrainMass

Profit after one year

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

Solution Summary

This solution calculates the profit after a year of investing based on different compounding periods.