Excel Activity: Calculating the WACC Here is the condensed 2021 balance sheet for Skye Computer Company (in thousands of dollars): 1.224. The firm's total debt, which is the sum of the company's short-term debt and long-term debt, equals $0.825 million. to two decimal places. Download spreadsheet Calculating the WACC-d5cdad.xIsx method to find the cost of common equity. After-tax cost of debt: % Cost of preferred stock: % Cost of retained earnings: % Cost of new common stock: % b. Now calculate the cost of common equity from retained earnings, using the CAPM method. % % calculating WACC.) WACC 1 : % WACC 2 : %