1. 2. and 3.?

should have everything now!!

2. What is the expected capitgl gains yield for each bond in each year? Round your answers to two decimal places. Years Remaining \begin{tabular}{|c|c|c|c|c|c|} \hline Until Maturity & Bond A & & Bond B & & Bond C \\ \hline 12 & & % & & % & % \\ \hline 11 & & % & & % & % \\ \hline 10 & & % & & 9 & % \\ \hline 9 & & 0 & & 9 & % \\ \hline 8 & & % & & 9 & % \\ \hline 7 & & % & & % & \\ \hline 6 & & % & & % & 9 \\ \hline 5 & & % & & is & % \\ \hline 4 & & % & & if & % \\ \hline 3 & & % & & 8% & \\ \hline 2 & & % & & & % \\ \hline 1 & & % & & & % \\ \hline \end{tabular} Fucri Actinty: Bosd Valuabon - Dond B has w 115 aneyal coupos, matures in 12 years, and bas a $1 seoo face valut. rach bend has a valt to materfy of 31%. whatwer ais zers, enter ' 8 '; X Bobd A in sellono at 3 becruse ta souson rate s (6) the asong interest rate Band o is selosa n the goess ivorest rate bahd C is anling at bethute te stupos rate is the gown interest rate: are (Bons a) s Price inond tivis 4 men (bund chi 1 Corrent yalf (bond 2 ) 5 Curstit vitit (eende) Curent vid (Eond C) Dverich mink 1. What is the expected current yield for each bond in each year? Round your answers to two decimal places. Excel Activitys Bond valuation Clifford Clark is a recent retiree who is interested in inwestieg some of his savings in corporate bonda. His financial planner has suggested the following bonds: - Bond A has a 13% anhual ceupon, matures in 12 years, and has a $1,000 foce value. - Eond 8 has an 11% annual coupon, matures in 12 vears, and has a $1,000 face value. - Bond Chas a 9% annual coupon, matures in 12 vears, and has a $1,000 face volue. Each bond has s vield to maturity of 11 \%. The data has been collected in the Microsoft Excel file below, Download the spreaduheet and perform the required analysis to answer the questions below. Do not round inte answer is zerp, enter 10 veare at a call price of 11,940 - A siver bend with an 115 anrue coupen - A 10 verer bend hith a atro coupar 3. What is the total return for each bond in each year? Round your answers to two decimal places. Current yield (fond B): Current vield (Bond c ): d. If the vield to muturity fer each bond remains at 11%, what will be the pnce of cach bond 1 vear from now? Round your answeri to the nearest cent. Price (Dond A): s Proce (Bond B): 1 Price (eond C) i What is the expected capital gains yeid for each bond? What is the expected total teturn for each bond? Round your enswers to tero decimal places. rears at o call price of 13,040 . 2. What is the bends neminal vied to enil? Heund vour answer to twe decimal places. Becruse the YTM is itaric, Mn, clark