Excel Online Structured Activity: WACC The Paulson Company's year-end balance sheet is shown below. Its cost...

Transcribed Image Text:

Excel Online Structured Activity: WACC The Paulson Company's year-end balance sheet is shown below. Its cost of common equity is 17%, its before-tax cost of debt is 9%, 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,158. 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. X Open spreadsheet Calculate Paulson's WACC using market-value weights. Round your answer to two decimal places. Do not round your intermediate calculations. Assets Liabilities And Equity Cash $ 120 Accounts payable and accruals $ 10 Accounts receivable 240 Short-term debt 58 Inventories 360 Long-term debt $1,100 Plant and equipment, net 2,160 Common equity 1,712 Total liabilities and Total assets $2,880 $2,880 equity % Excel Online Structured Activity: WACC The Paulson Company's year-end balance sheet is shown below. Its cost of common equity is 17%, its before-tax cost of debt is 9%, 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,158. 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. X Open spreadsheet Calculate Paulson's WACC using market-value weights. Round your answer to two decimal places. Do not round your intermediate calculations. Assets Liabilities And Equity Cash $ 120 Accounts payable and accruals $ 10 Accounts receivable 240 Short-term debt 58 Inventories 360 Long-term debt $1,100 Plant and equipment, net 2,160 Common equity 1,712 Total liabilities and Total assets $2,880 $2,880 equity %