PLEASE USE EXCEL TO SOLVE

7. (10 points) You are considering the following bonds to include in your portfolio: Bond 1 Bond 2 Bond 3 Settlement Date 3/15/2019 9/1/2019 7/15/2018 Maturity Date 1/15/2029 7/1/2039 9/15/2048 Frequency 4 2 2 Face Value $1,000 $1,000 $1,000 Coupon Rate 6% 9% 11% Required Return 9% 12% 13% 3030 3 1) Calculate the invoice (dirty) price, the accrued interest, and the quoted (clean) price of each bond. Find the quoted price as the difference between the invoice price minus the accrued interest and verify this result using the PRICE function. 2) Determine the yield to call on these bonds if the time to first call and the call premium for each one of them are the following: Call Premium % Call Date Bond A Bond B Bond C 3.5% 4.5% 5.5% 7/15/2022 9/1/2023 1/15/2024 7. (10 points) You are considering the following bonds to include in your portfolio: Bond 1 Bond 2 Bond 3 Settlement Date 3/15/2019 9/1/2019 7/15/2018 Maturity Date 1/15/2029 7/1/2039 9/15/2048 Frequency 4 2 2 Face Value $1,000 $1,000 $1,000 Coupon Rate 6% 9% 11% Required Return 9% 12% 13% 3030 3 1) Calculate the invoice (dirty) price, the accrued interest, and the quoted (clean) price of each bond. Find the quoted price as the difference between the invoice price minus the accrued interest and verify this result using the PRICE function. 2) Determine the yield to call on these bonds if the time to first call and the call premium for each one of them are the following: Call Premium % Call Date Bond A Bond B Bond C 3.5% 4.5% 5.5% 7/15/2022 9/1/2023 1/15/2024