The Paulson Company's year-end balance sheet is shown below. Its cost of common equity is 15%, its before-tax cost of debt is 12%, and its marginal tax rate is 40%. Assume that the firm's long-term debt sells at par value. The firms total debt, which is the sum of the companys short-term debt and long-term debt, equals $1,151. 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.

Calculate Paulson's WACC using market-value weights. Round your answer to two decimal places. Do not round your intermediate calculations.

Please complete in a spreadsheet

Assets Liabilities And Equity

Cash $ 120

Accounts payable and accruals $ 10

Accounts receivable 240

Short-term debt 41

Inventories 360

Long-term debt $1,110

Plant and equipment, net 2,160

Common equity 1,719

Total assets $2,880

Total liabilities and equity $2,880

%

12 Case Analysis Team 1-3/20 X Mind Tap - Cengage Learning x * Excel Online Student Work X My Home TEAM 1 - MGMT - Case Ana X C Get Homework Help With CX + X c about:blank e K !!! Apps * Bookmarks Microsoft Office Ho... Gmail Student Home My... Welcome, Kaylin... Cengage VitalSource ID SHEILD TROY QuickBo + Reset Other bookmarks Excel template - Saved File Home Insert Formulas Data Review View Help Tell me what you want to do Comments Arial 10 A A 25 Wrap Text General 28 Pasta le Copy Format Painter Insert Delete Format D ct = = Morge & Center Conditional Format Cell Formatting Table Styles $ % 98 23 Sort Find & Filter Select Clipboard Font Alignment Number Tables Urdu 016 E F H - K L M N 0 P B S T U 15.00% 12.00% 40.00% 578 $4.00 Yes 12 A 1 WACC 2 3 Cost of common equity Beforo-tax cost of debtro) 5 Marginal tax rate Common shares outstanding 7 Current stock price 2 Long-term debt sells at par value 9 10 Balance Sheet 11 Assers Cash 13 Account receivable 14 Inventories 15 Hant and equipment, net Total assets 17 10 19 Market value of total deht 20 Mario wake of common cquity 21 Total captal 22 23 Percentage of debt 24 Percentage of common equity 25 26 After-tax cost of debt 27 28 Weighted Average Cost of Capital (WACC) 29 30 31 $120.00 $240.00 $360,00 $2,150.00 $2999.00 Liabines and Equity Accounts payable and accruals Short-term debt Long term del Common equity Totallinlities and equity $10.00 $41.00 $1.110.00 $1./19.00 $2.990 00 Formulas NA NA NA SENATOR NA NA #NA NA Sheet1 Calculation Mode: Automatic Workbook Statistics Hep improve Office