Excel structured activity: WACC

Excel Online Structured Activity: WACC The Paulson Company's year-end balance sheet is shown below. Its cost of common equity is 16%, its before-tax cost of debt is 8%, 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,164. 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 1 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 44 Short-term debt 240 360 Inventories Long-term debt $1,120 1,706 Plant and equipment, net 2,160 Common equity $2.680 Total assets Total abilities and equity $2,380