Jones can deposit $5,500 at the end of each six-month period for the next 12 years and earn interest at an annual rate of 8 percent, compounded semiannually. Required: a. What will the value of the investment be after 12 years? b. If the deposits were made at the beginning of each year, what would the value of the investment be after 12 years?

Please show how and while using excel