Assume that you deposit $10,000 today into an account paying 6% annual interest and leave it on deposit for exactly 8 years.
a. How much will be in the account at the end of 8 years in interest is compounded:
1. annually?
2. semiannually?
3. monthly?
4. continuously?
b. Calculate the effective annual rate (EAR) for a (1) through a (4) above.
c. Based on your findings in parts a and b, what is the general relationship between the frequency of compounding and EAR?
Your submission should be an excel spreadsheet showing all work with each tab containing one question. I recommend using text boxes to verbally answer questions. Please highlight or box all answers. I will also accept a word document showing all work.