Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please I just need the last two pictures done 1 XYZ outstanding bonds as of 12/31/22 Face amounts are in millions. begin{tabular}{|c|c|c|c|c|c|c|c|c|} hline Name &
Please I just need the last two pictures done
1 XYZ outstanding bonds as of 12/31/22 Face amounts are in millions. \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Name & Maturity & \begin{tabular}{r} Face \\ Amount \\ $(Mi) \end{tabular} & \begin{tabular}{r} Current \\ Price \end{tabular} & Coupon \% & \begin{tabular}{r} Yield to \\ Maturity \\ % \end{tabular} & \begin{tabular}{r} Market \\ Value \$ \\ (Mil) \end{tabular} & Weight & \begin{tabular}{r} Weighted \\ YTM \% \end{tabular} \\ \hline Senior Notes & 05/15/23 & 500.00 & 100.05 & 1.850% & 1.6981% & 500.25 & & \\ \hline Senior Notes & 05/15/25 & 300.00 & 101.00 & 2.625% & 2.1895% & 303.00 & & \\ \hline Senior Notes & 03/12/26 & 750.00 & 97.30 & 1.375% & 2.2547% & 729.75 & & \\ \hline Senior Notes & 05/31/27 & 500.00 & 95.00 & 1.125% & 2.3226% & 475.00 & & \\ \hline Senior Notes & 05/04/31 & 750.00 & 91.40 & 1.750% & 2.9188% & 685.50 & & \\ \hline Senior Notes & 06/30/32 & 500.00 & 90.95 & 1.900% & 3.0020% & 454.75 & & \\ \hline Senior Notes & 03/15/40 & 750.00 & 105.20 & 3.875% & 3.4708% & 789.00 & & \\ \hline Senior Notes & 05/15/49 & 1,500.00 & 104.75 & 4.150% & 3.8611% & 1,571.25 & & \\ \hline Senior Notes & 07/31/52 & 500.00 & 78.00 & 2.700% & 3.9705% & 390.00 & & \\ \hline & & & & & & & & \\ \hline & & & & & & \multicolumn{2}{|c|}{ Pre-tax Cost of Debt } & \\ \hline & & & & & & & & \\ \hline & & & & & & \multicolumn{2}{|c|}{ Adjustment for tax rate } & \\ \hline & & & & & & & & \\ \hline & & & & & & \multicolumn{2}{|c|}{ After tax Cost of Debt } & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started