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% FINA 3030 4 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: Bond A Bond B Bond C Call Premium % 3.5% 4.5% 5.5% Call Date 7/15/2022 9/1/2023 1/15/2024

please use excel to solve