Question: begin{tabular}{|c|c|c|c|} hline multirow{2}{*}{multicolumn{4}{|c|}{ WACC }} hline & & & hline Cost of common equity (rs) & 18.00% & & hline Before-tax cost




\begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{4}{|c|}{ WACC }} \\ \hline & & & \\ \hline Cost of common equity (rs) & 18.00% & & \\ \hline Before-tax cost of debt (rd) & 10.00% & & \\ \hline Marginal tax rate (T) & 40.00% & & \\ \hline Common shares outstanding & 576 & & \\ \hline Current stock price & $4.00 & & \\ \hline Long-term debt sells at par value & Yes & & \\ \hline \multicolumn{4}{|l|}{ Balance Sheet: } \\ \hline Assets & & Liabilities and Equity & \\ \hline Cash & $120.00 & Accounts payable and accruals & $10.00 \\ \hline Account receivable & $240.00 & Short-term debt & $42.00 \\ \hline Inventories & $360.00 & Long-term debt & $1,090.00 \\ \hline Plant and equipment, net & $2,160.00 & Common equity & $1,738.00 \\ \hline \multirow[t]{2}{*}{ Total assets } & $2,880.00 & Total liabilities and equity & $2,880.00 \\ \hline & & Formulas & \\ \hline Market value of total debt & & \#N/A & \\ \hline Market value of common equity & & \#N/A & \\ \hline Total capital & & \#N/A & \\ \hline \end{tabular} Calculate Paulson's WACC using market-value weights. Round your answer to two decimal places. Do not round your intermediate calculations. \begin{tabular}{|c|c|c|c|} \hline A & B & D & E \\ \hline \multicolumn{4}{|l|}{ Balance Sheet: } \\ \hline Assets & & Liabilities and Equity & \\ \hline Cash & $120.00 & Accounts payable and accruals & $10.00 \\ \hline Account receivable & $240.00 & Short-term debt & $42.00 \\ \hline Inventories & $360.00 & Long-term debt & $1,090.00 \\ \hline Plant and equipment, net & $2,160.00 & Common equity & $1,738.00 \\ \hline Total assets & $2,880.00 & Total liabilities and equity & $2,880.00 \\ \hline & & Formulas & \\ \hline Market value of total debt & & \#N/A & \\ \hline Market value of common equity & & \#N/A & \\ \hline Total capital & & \#N/A & \\ \hline Percentage of debt & & \#N/A & \\ \hline Percentage of common equity & & \#N/A & \\ \hline After-tax cost of debt & & \#N/A & \\ \hline Weighted Average Cost of Capital (WACC) & & \#N/A & \\ \hline \end{tabular} Excel Online Structured Activity: WACC The Paulson Company's year-end balance sheet is shown below. Its cost of common equity is 18%, its before-tax cost of debt is 10%, and its marginal tax rate is 40%. Assume that the firm's long-term debt sells at par value. The firm's total debt, which is the sum of the company's short-term debt and long-term debt, equals $1,132. The firm has 576 shares of common stock outstanding that sell for $4.00 per share. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet Calculate Paulson's WACC using market-value weights. Round your answer to two decimal places. Do not round your intermediate calculations. \begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{4}{|c|}{ WACC }} \\ \hline & & & \\ \hline Cost of common equity (rs) & 18.00% & & \\ \hline Before-tax cost of debt (rd) & 10.00% & & \\ \hline Marginal tax rate (T) & 40.00% & & \\ \hline Common shares outstanding & 576 & & \\ \hline Current stock price & $4.00 & & \\ \hline Long-term debt sells at par value & Yes & & \\ \hline \multicolumn{4}{|l|}{ Balance Sheet: } \\ \hline Assets & & Liabilities and Equity & \\ \hline Cash & $120.00 & Accounts payable and accruals & $10.00 \\ \hline Account receivable & $240.00 & Short-term debt & $42.00 \\ \hline Inventories & $360.00 & Long-term debt & $1,090.00 \\ \hline Plant and equipment, net & $2,160.00 & Common equity & $1,738.00 \\ \hline \multirow[t]{2}{*}{ Total assets } & $2,880.00 & Total liabilities and equity & $2,880.00 \\ \hline & & Formulas & \\ \hline Market value of total debt & & \#N/A & \\ \hline Market value of common equity & & \#N/A & \\ \hline Total capital & & \#N/A & \\ \hline \end{tabular} Calculate Paulson's WACC using market-value weights. Round your answer to two decimal places. Do not round your intermediate calculations. \begin{tabular}{|c|c|c|c|} \hline A & B & D & E \\ \hline \multicolumn{4}{|l|}{ Balance Sheet: } \\ \hline Assets & & Liabilities and Equity & \\ \hline Cash & $120.00 & Accounts payable and accruals & $10.00 \\ \hline Account receivable & $240.00 & Short-term debt & $42.00 \\ \hline Inventories & $360.00 & Long-term debt & $1,090.00 \\ \hline Plant and equipment, net & $2,160.00 & Common equity & $1,738.00 \\ \hline Total assets & $2,880.00 & Total liabilities and equity & $2,880.00 \\ \hline & & Formulas & \\ \hline Market value of total debt & & \#N/A & \\ \hline Market value of common equity & & \#N/A & \\ \hline Total capital & & \#N/A & \\ \hline Percentage of debt & & \#N/A & \\ \hline Percentage of common equity & & \#N/A & \\ \hline After-tax cost of debt & & \#N/A & \\ \hline Weighted Average Cost of Capital (WACC) & & \#N/A & \\ \hline \end{tabular} Excel Online Structured Activity: WACC The Paulson Company's year-end balance sheet is shown below. Its cost of common equity is 18%, its before-tax cost of debt is 10%, and its marginal tax rate is 40%. Assume that the firm's long-term debt sells at par value. The firm's total debt, which is the sum of the company's short-term debt and long-term debt, equals $1,132. The firm has 576 shares of common stock outstanding that sell for $4.00 per share. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet Calculate Paulson's WACC using market-value weights. Round your answer to two decimal places. Do not round your intermediate calculations
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
