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. Marginal Tax Rate Debt to Equity Ratio Unlevered Beta from each Segment EV / Sales Value of Segment Unlevered Beta Business Segment Metals & Mining Precious Metals 1.09 1.26 3.14 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.00 1.14 1.27 Coal & Related Energy Transportation Total 1.3 0.79 $0.00 0.00 Company's Unlevered Beta Company's Levered Beta 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. Marginal Tax Rate Debt to Equity Ratio Unlevered Beta from each Segment EV / Sales Value of Segment Unlevered Beta Business Segment Metals & Mining Precious Metals 1.09 1.26 3.14 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.00 1.14 1.27 Coal & Related Energy Transportation Total 1.3 0.79 $0.00 0.00 Company's Unlevered Beta Company's Levered Beta