excel for help

Video Excel Online Structured Activity: WAOC The Paulson Company'e year and balance sheet is shown below the cost of common equity is 17%, its before tax cost of debt and its marginal tax rate is 10%. Asume that the long-term debt sells at par value. The firm's totalebt, which in the sum of the company's short term delt and long-term debet, quals $1.17. The firm has 576 shares of common stock outstanding that all for $4.00 per shore. The data has been collected in the Microche Online film belom. Open the spreadsheet and perform the sequend analysis to at the que Open spreadsheet Calculate Paulson's WACC uing market value weight. Round your answer to the decimal place not round your intermediate calculations Assets Lia And uity Cash $ 120 5.10 Accounts receivable 240 and anal Short-term det Long-term debit Invento 360 51.120 plant and quiment het 2,160 Commons 1,699 Total assets Total babies and equity $2.000 template Saved File Formulas Data Review View Help Tell me what you want to do Home Insert Xount Arial - 10 AA ID Paste BIUD 5 21 - $ % 948 Cell Insert Delete Format Painter Clipboard Conditional Format Formatting Table Styles tables Unda Font Alignment Number C D G H 1 2 Cost of common equity Before-tax cost of debt. 4 Marginal tax rate (0) Common shares outstanding 6 Current sock pece Longterm det sells at par vake 17.00% 8.00% 40.00% 576 $400 Yes Balance Sheet 10 Assets 12 Account recevable 11 hertones 14. Pant and equipment, net 15 Total assets $120.00 $240.00 $360,00 $2 160.00 5288000 Ladies and Equity Accounts payable and accu Short-te debe Long-term debit Common egy Total abilities and equity $10.00 $5100 $1120 00 $1699 00 5111300 Market value of total de 19 Market value of common equity 20 Total captal Formas NA NA NA Sheet File Help Tell me what you want to do Home Insert Formulas Data Review View Xcut . Anal -10 AA Copy IV pab Forat Painter Cipboard Font LO illi DE 1991 Currency $ - %5-28 Insert De Conditional Format Formatting - Table - Styles Tables Ude Alignment Number BE D E F G 13 Accountable inventores 13 Plant and equipment, net 3 5240 00 $360,00 $2 16000 52880.00 Short-term debt Longterm debt Common equity Total abilities and equity $51.00 $1,120.00 $1599.00 52 880.00 17 19 Marte of total debt 30 Mark of common equity Formulas MNIA INUA NA Percentage of deel 3 Peceta of common equity MNIA MNIA Acontece NA Wested forage Cost of Capital (WACC) MIA a