Question
I need help on this question.

Creek Enterprises Income Statement for the Year Ended December 31, 2018 Sales revenue ($34,963,000) Less Cost of goods sold Creek Enterprises Income Statement for the Year Ended December 31, 2019 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses 1000 % $29,980,000 20,995,000 $8,985,000 338 % Less: Operating expenses Seling experse General and administrative expenses 13.3 % $3.041,000 1,774,000 193,000 979,000 Seling expense General and administrative expenses 04 3.6 Lease expense Total operating expense 235 Depreciation expense Total operating expense Operating profits Less: Interest expense Net prolts before taxes Less: Operaing profits Less: Interest expense Net profits before taxes Less Taxes (rate .21%) 5,987,000 $2,998,000 997,000 89% Taxes (rate .21%) 420,210 $1,580,790 1,000 $1,509,790 0.2 Less: Preferred stock dividends Eamings avalable for common stockholders Less: Preferred stock dividends Earnings available for common stockholders
Cemmon-aize statement analysis Acommon-size income statement for Ceek Enterprises 2018 eperations folows 201Baement. Which arean require furher analysis and investigason? Using the frms 2019 inceme statement IT.develop the 2019 cmmon-dize income statement and compare t to te Common Siee Ineome Statement Ended Desember 31, 2018 Sales revenue Less: Cost of goods sold Gross pos Less Operating expenses Seling expens 00.0% 66.2 338 % 133 % Lease epen Depresiaton expens Total operating expense Opereting profts Less Interest expense Net prolls before taxes Lasa Tam Crate-21%) Net prolis aher ae Less: Prefered stock dividends Earmings available for common slockholdars 36 23 5 10.3% 89% 70% 02
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Common Size Income statement
Sales revenue 100.0%
Less: Cost of goods sold 70.0%
Gross Profits 30.0%
Less:Operating expenses
Selling expense 10.1%
General and administrative expenses 5.9%
Lease 0.6%
Depreciation 3.3%
Total operating expenses 20.0%
Operating Profits 10.0%
Less: Interest 3.3%
Net profits before taxes 6.7%
Less taxes 1.4%
PAT 5.3%
Less: Preferred stock dividends 0.2%
Earnings available for equity shareholders 5.0%

WORKINGS

AutoSave Book1 - Excel 《Product Activation Failed) Sign in File Insert Page Layout Formulas Data Review View Help Tell me what you want to do 수 Share Home Calibri Wrap Text General Conditional Fornat as Cell Insert Delete Fornat FormattingTable Styles- 、. Sort & Find & Paste . 녀 . 의 _ . 로三들經垣臣 Merge & Center-5 . % , : Filter-Select- Clipboard Font Alignment Number Stles Cells Editing A1 Common Size Income statement 2 Sales revenue 3 Less: Cost of goods sold 4 Gross Profits 5 Less:Operating expenses 6 Selling expense 7 General and administrative expenses 8 Lease 9 Depreciation 10 Total operating expenses 11 Operating Profits 12 Less: Interest 13 Net profits before taxes 14 Less taxes 15 PAT 16 Less: Preferred stock dividends 17 Earnings available for equity shareholders -29980000/29980000 -20995000/29980000 -8985000/29980000 3041000/29980000 -1774000/29980000 -193000/29980000 -979000/29980000 -SUM(B6:B9) -C4-C10 -997000/29980000 =C11-C12 420210/29980000 -C13-C14 71000/29980000 -C15-C16 Sheet1 Sheet3 Sheet2 Ready + 100 C/ ENG 11:40 ANM

Add a comment
Know the answer?
Add Answer to:
I need help on this question. Creek Enterprises Income Statement for the Year Ended December 31,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A​ common-size income statement for Creek​ Enterprises' 2018 operations follows: Creek Enterprises Income Statement for the...

    A​ common-size income statement for Creek​ Enterprises' 2018 operations follows: Creek Enterprises Income Statement for the Year Ended December 31, 2018                   Sales revenue ($34,966,000)           100.0   %   Less: Cost of goods sold           65.6       Gross profits            34.4   %   Less: Operating expenses                   Selling expense    12.7   %           General and administrative expenses    6.3               Lease expense    0.5               Depreciation expense  ...

  • Common-size statement analysis A common-size income statement for Creek Enterprises' 2018 operations follows E Using the...

    Common-size statement analysis A common-size income statement for Creek Enterprises' 2018 operations follows E Using the firm's 2019 income statements, develop the 2019 common-size income statement and compare it to the 2018statement. Which areas require further analysis and investigation? Complete the common-size income statement for the year ending December 31, 2019 and compare it to the common-size income statement for the year ending December 2018: (Round to one decimal place.) 100.0 % 66.0 34.0 % Creek Enterprises Common-Size Income Statement...

  • Learning Goals 5 P3–19 Common-size statement analysis A common-size income statement for Creek Enterprises' 2018 operations...

    Learning Goals 5 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–169, 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 Sales revenue ($35,000,000) 100.0% Less: Cost of goods sold 65.9 Gross profits 34.1% Less: Operating expenses Selling expense 12.7% General and...

  • . Using the firm's 2019 income statement develop the 2019 common-size income statement and compare it...

    . Using the firm's 2019 income statement develop the 2019 common-size income statement and compare it to the Common-size statement analysis A common-size income statement for Creek Enterprises 2018 operations follows 2018statement. Which areas require further analysis and investigation? Complete the common-size income statement for the year ending December 31, 2019 and compare it to the common-size Income statement for the year ending December 2018: (Round to one decimal place.) Creek Enterprises Common-Size Income Statement for the Years Ended December...

  • P3-19 Common-size statement analysis A common-size income statement for Creek Enterprises 2018 operations follows. Using the...

    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% Sales revenue ($35,000,000) Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense...

  • 133 CHAPTER 3 Financial Statements and Ratio Analysis Common-size statement analysis A common-size income statement for...

    133 CHAPTER 3 Financial Statements and Ratio Analysis Common-size statement analysis A common-size income statement for Creek Enterprises' 2018 operations follows. Using the firm's 2019 income statem presented in Problem 3-16, develop the 2019 common-size income statement an compare it with the 2018 statement. Which areas require further analysis and investigation? P3-19 Creek Enterprises Common-Size Income Statement for the Year Ended December 31, 2018 Sales revenue ($35,000,000) Less: Cost of goods sold 100.0% 65.9 34.1% Gross profits Less: Operating expenses...

  • 133 CHAPTER 3 Financial Statements and Ratio Analysis Common-size statement analysis A common-size income statement for...

    133 CHAPTER 3 Financial Statements and Ratio Analysis Common-size statement analysis A common-size income statement for Enterprises' 2018 operations follows. Using the firm's 2019 income stater Creek ment P3-19 em 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 % Sales revenue ($35,000,000) Less: Cost of goods sold Gross profits Less: Operating expenses...

  • Construct a common-size income statement. Check figure: NPAT for 2012 should be 4.0% Be sure to...

    Construct a common-size income statement. Check figure: NPAT for 2012 should be 4.0% Be sure to indicate if each account is "better" or "worse" compared to the previous year. P3-19 Common-size statement analysis A common-size income statement for Creek Enterprises' 2011 operations follows. Using the firm's 2012 income statement pre- sented in Problem 3-18, develop the 2012 common-size income statement and com- pare it to the 2011 statement. Which areas require further analysis and investigation? Creek Enterprises Common-Size Income Statement...

  • Homework - Terra Stone - Google Chrome math.com/StudentPlayhomeworkshomeword=551107122&question de fushede de7827 centerwinyes pring 1 Term 2020...

    Homework - Terra Stone - Google Chrome math.com/StudentPlayhomeworkshomeword=551107122&question de fushede de7827 centerwinyes pring 1 Term 2020 - College wide and BLC Terra Stone & 01/15/20 1:27 lomework: Chapter 3 Homework core: 0 of 1 pt 20f 4 (0 complete) HW Score: 0%, 0 of 3-19 (similar to) IE Question Help Common size statement analysis A common size income statement for Creek Enterprises 2018 operations follows Using the firm's 2019 income statement develop the 2019 common se income statement and compare...

  • Springfield Bank is evaluating Creek​ Enterprises, which has requested a $ 3,720,000 loan, to assess the​...

    Springfield Bank is evaluating Creek​ Enterprises, which has requested a $ 3,720,000 loan, to assess the​ firm's financial leverage and financial risk. On the basis of the debt ratios for​ Creek, along with the industry averages and​ Creek's recent financial​ statements, evaluate and recommend appropriate action on the loan request. Industry averages Debt ratio 0.47 Times interest earned ratio 7.29 ​Fixed-payment coverage ratio                                                                                                            2.03 Creek Enterprises Income​ Statement: Creek Enterprises Income Statement for the Year Ended December 31, 2019      ...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT