You are considering the following bonds to include in your portfolio:

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 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% 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 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% 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