A 7-year annuity of fourteen $5,800 semiannual payments will begin 9 years from now, with the first payment coming 9.5 years from now. The discount rate is 8 percent compounded monthly. What is the...

How do I solve this in excel?

Extracted text: A 7-year annuity of fourteen $5,800 semiannual payments will begin 9 years from now, with the first payment coming 9.5 years from now. The discount rate is 8 percent compounded monthly. What is the value of this annuity five years from now? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the value three years from now? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) What is the current value of the annuity? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) а. с. Value at Year 5 $ 39,773.97 X a. b. Value at Year 3 $ 33,998.96 X Value today 2$ 26,869.87 X с.