Excel Activity: Bond Valuation Clifford Clark is a recent retiree who is interested in investing some of his savings in corporate bonds. His financial planner has suggested the wing Bond A has a 15% annual coupon, matures in 12 years, and has a $1,000 face value. Bond B has a 7% annual coupon, matures in 12 years, and has a $1,000 face value. Bond C has an 11% annual coupon, matures in 12 years, and has a $1,000 face value Each bond has a yield to maturity of 11%. 1. What is the expected current yield for each bond in each year? Round your answers to two decimal places Years Remaining Until Maturity 12 11 Bond A Bond B Bond C % % % % % 10 96 9 06 8 7 9 6 5 4 3 2 1 96 % % 2. What is the expected capital gains yield for each bond in each year? Round your answers to two decimal places Years Remaining Bond A Bond B Bonde 3 2 % 1 % 96 2. What is the expected capital gains yield for each bond in each year? Round your answers to two decimal places Years Remaining Until Maturity Bond A Bond B Bond C 12 % 11 % % 10 % 9 % 8 % 7 % % 6 Yo 5 % 4 3 2 1 3. What is the total return for each bond in each year Round your answers to two decimal places Hoc % 3. What is the total return for each bond in each year? Round your answers to two decimal places Years Remaining Until Maturity 12 Bond A Bond B Bond C % 96 11 10 9 9% %6 96 8 996 7. 6 9 2 Check My Work Reset