$3.$ BOND VALUATION $***$ PLEASE ANSWER ACCORDING TO EVERYTHING THAT NEEDS TO BE ANSWERED$/$ CORRECTED ON THE PICTURE TO GET A POSITIVE FEEDBACK $***$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 a $13\%$ annual coupon, matures in $12$ years, and has a $$1,000$ face value.

Bond $B$ has an $11\%$ annual coupon, matures in $12$ years, and has a $$1,000$ face value.

Bond C has a $9\%$ annual coupon, matures in $12$ years, and has a $$1,000$ face value.

Each bond has a yield to maturity of $11\%.$

The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round

intermediate calculations. Use a minus sign to enter negative values, if any. If an answer is zero, enter $"0".$

What is the total return for each bond in each year? Round your answers to two decimal places.

Years Remaining

e$.$ Mr$.$ Clark is considering another bond, Bond D$.$ It has a $7\%$ semiannual coupon and a $$1,000$ face value $($i$.$e$.,$ it pays a $$35$ coupon every $6$ months$).$ Bond D is

scheduled to mature in $8$ years and has a price of $$1,140.$ It is also callable in $6$ years at a call price of $$1,080.$

What is the bond's nominal yield to maturity? Round your answer to two decimal places.

$\%$

What is the bond's nominal yield to call? Round your answer to two decimal places.