A B 1 Excel Case #2 - XYZ Company 2 3 Total points available 4 5 The Answer Schedule shows the points per question/answer 6 Points available for each answer are all or nothing - must be correct answer AND in correct format 7 Rounding of your answers should take place when you get to the final step, do not round prior to that 8 Please refer to the other worksheets in this Excel file to get the data you need 20 D 9 You need to show your work somewhere in this Excel file to get credit when calculations are involved 10 If you just provide the correct answers and do not show your work when calculations are necessary, you will not earn full credit 11 On the answer schedule, you can use cell references OR manually input your answers (as long as you did the actual calculations in Excel) 12 For example: show the growth rate for equity on the worksheet that contains the data you use for the calculation 13 14

Excel Case #2 - XYZ Company Total points avaliable 20 The Answer Schedule shows the points per question / answer points available for each answer are all or nothing - must be correct answer AND in correct format Rounding of your answers should take place when you get to the final step, do not round prior to that Please refer to the other workheets in this Excel file to get the data you need You need to show your work somewhere in this Excel file to get credit when calculations are involved If you fust provide the correct answers and do not show your work when calculations are necessary, you will not earn full credit On the answer schedule, you can use cell references or manually input your answers (as long as you did the actual calculations in Excel) For example: show the growth rate for equity on the worksheet that contains the data you use for the calculation Save your file with this name format: Excel Case2 Firstinitialtastname sectionnumber Example: Excel Case 2.1Doe 03W Submit by posting to Blackboard (due date and time is Tuesday, November 28th, 11:30pm) \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 4 & B & c & D & E & F & G & H & 1 \\ \hline \begin{tabular}{l} 4 \\ 5 \\ \end{tabular} & Maturity & \begin{tabular}{r} Face \\ Amount \\ $(Mil) \end{tabular} & \begin{tabular}{l} Current \\ Price \end{tabular} & Coupon \% & \begin{tabular}{r} Yield to \\ Maturity \% \end{tabular} & \begin{tabular}{r} Market \\ Value $ \\ [Mil] \end{tabular} & Weight & \begin{tabular}{l} Weighted \\ YTM \% \end{tabular} \\ \hline 6 & 05/15/23 & 50000 & 10005 & 1850% & 1698v & 50025 & & \\ \hline 7 & 0510\%24 & 500.00 & 10050 & 2.250% & 18677% & & & \\ \hline 8 & 05/15125 & 300.00 & 10100 & 2625% & 21895% & & & \\ \hline 9 & 03112125 & 750.00 & 9730 & 1375% & 22547% & -1 & & - \\ \hline 10 & 05/31/27 & 50000 & 9500 & 1125% & 23226% & 3 & E & \\ \hline II & 1103/28 & 500.00 & 100.55 & 2900% & 27968% & & & \\ \hline 12 & 09104/30 & 750.00 & 95.60 & 2250% & 28931% & & & \\ \hline D & 05104/31 & 750.00 & 9140 & 1750% & 29188% & 28 & 3 & \\ \hline 14 & 06/30132 & 500.00 & 9095 & 1900% & 30020% & - & 4 & \\ \hline 15 & 03115140 & 75000 & 10520 & 3.875% & 3.4708% & c & & \\ \hline 15 & 0515149 & 1500.00 & 10475 & 4150% & 38611% & & E & \\ \hline 17 & 0713152 & 50000 & 7800 & 2700% & 39705% & & & \\ \hline 18 & & 7.800 .00 & . & & & = & 5 & C. \\ \hline 19 & & or & & 3 & & or & =0 & \\ \hline 20 & & 7.800 & & & & +2 & & \\ \hline 21 & & billion & & & & billion. & & 2 \\ \hline 22 & & & 7 & & & & & \\ \hline 23 & & & 1 & & & \multicolumn{2}{|c|}{ Pre-tax Cost of Debt } & \\ \hline 24 & & & & & & & & \\ \hline 28 & & & 2x & & & \multirow{2}{*}{\multicolumn{2}{|c|}{ Adjustment for tax rate }} & \\ \hline 28 & & & & & & & & \\ \hline2627 & & & & & & \multirow{2}{*}{\multicolumn{2}{|c|}{ After tax Cost of Debt }} & \\ \hline 29 & & & & & & & & \\ \hline \end{tabular}