Question: Excel with Formulas please and explanation P3-19 Common-size statement analysis A common-size income statement for Creek Enterprises 2018 operations follows. Using the firm's 2019 income
Excel with Formulas please and explanation
P3-19 Common-size statement analysis A common-size income statement for Creek Enterprises 2018 operations follows. Using the firm's 2019 income statement presented in Problem 3-16, develop the 2019 common-size income statement and compare it with the 2018 statement. Which areas require further analysis and investigation? Creek Enterprises Common-Size Income Statement for the Year Ended December 31, 2018 100.0% 65.9 34.1% 0.6 3.6 Sales revenue ($35,000,000) Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 21%) Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders 10.9% 9.49 7.3% P3-19 Common-size statement analysis A common-size income statement for Creek Enterprises 2018 operations follows. Using the firm's 2019 income statement presented in Problem 3-16, develop the 2019 common-size income statement and compare it with the 2018 statement. Which areas require further analysis and investigation? Creek Enterprises Common-Size Income Statement for the Year Ended December 31, 2018 100.0% 65.9 34.1% 0.6 3.6 Sales revenue ($35,000,000) Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 21%) Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders 10.9% 9.49 7.3%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
