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 following bonds: Bond A has an 11% annual coupon, matures in 12 years, and has a $1,000 face value. Bond B has an 8% annual coupon, matures in 12 years, and has a $1,000 face value. Bond C has a 14% annual coupon, matures in 12 years, and has a $1,000 face value. Each bond has a yield to maturity of 11%. 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 12 Bond A Bond B Bond C % % % 11 % % % 10 % % % 9 % % % 8 % % % 7 % % % 6 % % % 5 % % % 4 % % % 3 % % % 2 % % % 1 % % % 3. What is the total return for each bond in each year? Round your answers to two decimal places. Bond A Bond B Bond c Years Remaining Until Maturity 12 11 % % % % % % 10 % % % 9 % % % 8 % % % 7 % % % 6 % % % 5 % % % 4 % % % un M N 3 % % % 2 % % % 1 % % %