1 2. Use the provided information in this Excel file to find the correct answers in the indicated cells (highlighted yellow). Some information may need to be brought into this sheet from another of the workbook tabs. Alwa use formulas / functions where possible. Never hard code cells if it can be absolutely avoided. 3 4 5 6 7 8 Marginal Tax Rate 9 10 Debt to Equity Ratio Unlevered Beta from each Segment Value of Segment EV / Sales 1.26 Unlevered Beta 1.09 3.14 11 12 Business Segment 13 Metals & Mining 14 Precious Metals 15 Coal & Related Energy 16 Transportation 17 Total 18 19 1.00 Sales $ 181,268.59 $44,221.57 $26,028.31 $14,076.54 $265,595.00 EV % Weights #DIV/0! #DIV/0! #DIV/0! #DIV/0! 1.14 1.27 1.3 0.79 $0.00 0.00 Company's Unlevered Beta 20 Company's Levered Beta 21 22 23 Use the provided information in this Excel file to find the correct answers in the indicated cells (highlighted yellow). Some information may need to be brought into this sheet from another of the workbook tabs. Always remember to link cells and use formulas / functions where possible. Never hard code cells if it can be absolutely avoided. 0.801% 10 Year US Treasury Yield Market Value of Equity Market Value of Debt Total Capital (Equity + Debt) 250,000 Shares Outstanding $26.50 Current Share Price 3,500 Bonds Outstanding $1,250.25 Current Bond Price 4.68% Mature Market ERP 21.00% Marginal Tax Rate 4.75% YTM on Bonds (Yield to Maturity) Country Risk Premium Weight of Equity Weight of Debt Company's Levered Beta Cost of Equity Weighted Average Cost of Capital (WACC) 1 2. Use the provided information in this Excel file to find the correct answers in the indicated cells (highlighted yellow). Some information may need to be brought into this sheet from another of the workbook tabs. Alwa use formulas / functions where possible. Never hard code cells if it can be absolutely avoided. 3 4 5 6 7 8 Marginal Tax Rate 9 10 Debt to Equity Ratio Unlevered Beta from each Segment Value of Segment EV / Sales 1.26 Unlevered Beta 1.09 3.14 11 12 Business Segment 13 Metals & Mining 14 Precious Metals 15 Coal & Related Energy 16 Transportation 17 Total 18 19 1.00 Sales $ 181,268.59 $44,221.57 $26,028.31 $14,076.54 $265,595.00 EV % Weights #DIV/0! #DIV/0! #DIV/0! #DIV/0! 1.14 1.27 1.3 0.79 $0.00 0.00 Company's Unlevered Beta 20 Company's Levered Beta 21 22 23 Use the provided information in this Excel file to find the correct answers in the indicated cells (highlighted yellow). Some information may need to be brought into this sheet from another of the workbook tabs. Always remember to link cells and use formulas / functions where possible. Never hard code cells if it can be absolutely avoided. 0.801% 10 Year US Treasury Yield Market Value of Equity Market Value of Debt Total Capital (Equity + Debt) 250,000 Shares Outstanding $26.50 Current Share Price 3,500 Bonds Outstanding $1,250.25 Current Bond Price 4.68% Mature Market ERP 21.00% Marginal Tax Rate 4.75% YTM on Bonds (Yield to Maturity) Country Risk Premium Weight of Equity Weight of Debt Company's Levered Beta Cost of Equity Weighted Average Cost of Capital (WACC)
