Question

In: Finance

A common size income statement for Creek Enterprises 2018 operations follows. Using the firms 2019 income...

A common size income statement for Creek Enterprises 2018 operations follows. Using the firms 2019 income statement presented in 3-16, develop the 2019 common size income statement and compare it with the 2018 statement. (I don't know how to get the answers for the 2019 common size income statement)

2018 common size income statement:

Sales Revenue ($35,000,000) 100%
Less: Cost of goods sold 65.9
           Gross Profits 34.1
Less: Operating expenses
           Selling expense 12.7%
           General and administrative expenses 6.3
           Lease expense 0.6
           Depreciation expense 3.6
                 Total operating expense 23.2%
           Operating profits 10.9%
Less: Interest expense 1.5
           Net profits before taxes 9.4%
Less: Taxes (rate=40%) 3.8
           Net profits after taxes 5.6%
Less: Preferred stock dividends 0.1
           Earnings available for common stockholders 5.5%

3-16 Income Statement:

Sales Revenue 30,000,000
Less: cost of goods sold 21,000,000
gross profits 9,000,000
Less: operating expenses
selling expense 3,000,000
general and administrative expenses 1,800,000
Lease expense 200,000
Depreciation expense 1,000,000
total operating expense 6,000,000
operating profits 3,000,000
less:interest expense 1,000,000
net profits before taxes 2,000,000
Less: taxes (rate=40%) 800,000
net profits after taxes 1,200,000
Less: preferred stock dividends 100,000
Earnings available for common stockholders 1,100,000

Solutions

Expert Solution

2019 common size income statement and comparison with 2018 Common size income statement
2019 2018 Comparison
Amount % % Increase / (Decrease)
Sales Revenue 30,000,000 100.0% 100.0% 0.0%
Less: cost of goods sold 21,000,000 70.0% 65.9% 4.1%
gross profits 9,000,000 30.0% 34.1% -4.1%
Less: operating expenses
selling expense 3,000,000 10.0% 12.7% -2.7%
general and administrative expenses 1,800,000 6.0% 6.3% -0.3%
Lease expense 200,000 0.7% 0.6% 0.1%
Depreciation expense 1,000,000 3.3% 3.6% -0.3%
total operating expense 6,000,000 20.0% 23.2% -3.2%
operating profits 3,000,000 10.0% 10.9% -0.9%
less:interest expense 1,000,000 3.3% 1.5% 1.8%
net profits before taxes 2,000,000 6.7% 9.4% -2.7%
Less: taxes (rate=40%) 800,000 2.7% 3.8% -1.1%
net profits after taxes 1,200,000 4.0% 5.6% -1.6%
Less: preferred stock dividends 100,000 0.3% 0.1% 0.2%
Earnings available for common stockholders 1,100,000 3.7% 5.5% -1.8%

Related Solutions

Income Statement 2019 Common Size Income Statement Details 2019 2018 Sales 30,000,000 Sales/Sales 100.00% 100.00% Less:...
Income Statement 2019 Common Size Income Statement Details 2019 2018 Sales 30,000,000 Sales/Sales 100.00% 100.00% Less: Cost of Goods Sold 21,000,000 Cost of Goods Sold/Sales 70.00% 65.90% Gross Profits 9,000,000 Gross Profits/Sales 30.00% 34.10% Less: Operating Expenses Less: Operating Expenses Selling Expense 3,000,000 Selling Expense/Sales 10.00% 12.70% General and Administrative Expenses 1,800,000 General and Administrative Expenses/Sales 6.00% 6.30% Lease Expense 200,000 Lease Expenses/Sales 0.67% 0.60% Depreciation Expense 1,000,000 Depreciation Expense/Sales 3.33% 3.60% Total Operating Expense 6,000,000 Total Operating Expense/Sales 20.00%...
prepare a common size income statement from the following income statement: CONSOLIDATED STATEMENTS OF OPERATIONS -...
prepare a common size income statement from the following income statement: CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) 12 Months Ended shares in Millions, $ in Millions Feb. 01, 2020 Feb. 02, 2019 Feb. 03, 2018 Total net sales $10,716 $11,664 $12,554 Credit income and other 451 355 319 Total revenues 11,167 12,019 12,873 Costs and expenses/(income): Cost of goods sold (exclusive of depreciation and amortization shown separately below) 7,013 7,870 8,208 Selling, general and administrative (SG&A) 3,585 3,596 3,845...
to create a common size income statement ---- all items on the income statement by -----...
to create a common size income statement ---- all items on the income statement by ----- a) divide; net income b) multiply; total revenue c) multiply; net income d) divide; total revenue
A common size balance sheet or common size income statement expresses everything in percentages rather than...
A common size balance sheet or common size income statement expresses everything in percentages rather than in numbers. Your manager has just asked you why you need to spend the time and money to have your analyst create both a common size and a regular balance sheet and income statement. How would you respond to her?
S&C Corp. recently completed its 2019 operations. The company’s financial ratios are as follows. 2019 2018...
S&C Corp. recently completed its 2019 operations. The company’s financial ratios are as follows. 2019 2018 Current ratio 2:1 times 1.8:1 times Accounts receivable turnover 22 times 12 times Profit margin (Net profit margin) 23% 15% Inventory turnover 12 times 19 times Times interest earned 4 times 8 times Total assets turnover 0.7 times 1.20 times Acid-test ratio 0.8:1 times 1.3:1 times Debt ratio 60% 30% Required: Comment on the financial performance of S&A Corp Just need some comments
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $ 445,000 2019 365,000 2020 435,000 2021 475,000     Included in the income of 2018 was an installment sale of property in the amount of $68,000. However, for tax purposes, DeVille reported the income in the year cash was collected. Cash collected on the installment sale was $27,200 in 2019, $34,000 in 2020, and $6,800 in 2021. Included in the 2020 income was $29,000 interest...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $ 440,000 2019 360,000 2020 430,000 2021 470,000     Included in the income of 2018 was an installment sale of property in the amount of $66,000. However, for tax purposes, DeVille reported the income in the year cash was collected. Cash collected on the installment sale was $26,400 in 2019, $33,000 in 2020, and $6,600 in 2021. Included in the 2020 income was $28,000 interest...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $ 360,000 2019 280,000 2020 350,000 2021 390,000     Included in the income of 2018 was an installment sale of property in the amount of $32,000. However, for tax purposes, DeVille reported the income in the year cash was collected. Cash collected on the installment sale was $12,800 in 2019, $16,000 in 2020, and $3,200 in 2021. Included in the 2020 income was $11,000 interest...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $ 390,000 2019 310,000 2020 380,000 2021 420,000     Included in the income of 2018 was an installment sale of property in the amount of $44,000. However, for tax purposes, DeVille reported the income in the year cash was collected. Cash collected on the installment sale was $17,600 in 2019, $22,000 in 2020, and $4,400 in 2021. Included in the 2020 income was $18,000 interest...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $...
The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $ 365,000 2019 285,000 2020 355,000 2021 395,000     Included in the income of 2018 was an installment sale of property in the amount of $34,000. However, for tax purposes, DeVille reported the income in the year cash was collected. Cash collected on the installment sale was $13,600 in 2019, $17,000 in 2020, and $3,400 in 2021. Included in the 2020 income was $12,000 interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT