Question

Prepare a common size income statement for Sterling Company and upload it. You may prepare this in excel or manually.
102 PART 2 Pinancial Tools LO P3-24 Integrative Complete ratio analysis Given the financial statements below and on the follo
CHAPTER 3 Financial Statements and Ratio Analysis 103 Analyze its overall financial situation from both a cross-sectional and
102 PART 2 Financial Tools eylate Sterling 365-day yet 0 h 31, 2012 P3-24 Interative Complete ratio analysis Given the financ

all that is needed is a common size income statement. the pictures are just all the info provided in the book
0 0
Add a comment Improve this question Transcribed image text
Answer #1
FY 2012 Formulae FY 2012
Particulars Income Statement Common Size       Income Statement Common Size Income Statement
Sale Revenue 100,00,000.00 100,00,000/100,00,000 = 100.0%
Less : Cost of goods sold 75,00,000.00 75,00,000/100,00,000 = 75.0%
Gross Profit 25,00,000.00 25,00,000/100,00,000 = 25.0%
Less : Operating expenses
Selling expenses 3,00,000.00 3,00,000/100,00,000 = 3.0%
General & administrative expenses 6,50,000.00 6,50,000/100,00,000 = 6.5%
Lease expenses 50,000.00 50,000/100,00,000 = 0.5%
Depreciation expenses 2,00,000.00 2,00,000/100,00,000 = 2.0%
Total Operating expenses 12,00,000.00 12,00,000/100,00,000 = 12.0%
Operating Profit 13,00,000.00 13,00,000/100,00,000 = 13.0%
Less : Interest expenses 2,00,000.00 2,00,000/100,00,000 = 2.0%
Net profit before taxes 11,00,000.00 11,00,000/100,00,000 = 11.0%
Less : Taxes (rate = 40%) 4,40,000.00 4,40,000/100,00,000 = 4.4%
Net profit after taxes 6,60,000.00 6,60,000/100,00,000 = 6.6%
Less : Preferred stock dividends 50,000.00 50,000/100,00,000 = 0.5%
Earnings available for common stockholders 6,10,000.00 6,10,000/100,00,000 = 6.1%
Add a comment
Know the answer?
Add Answer to:
all that is needed is a common size income statement. the pictures are just all the...
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
  • Help on my Finance homework please! Integrative: Complete ratio analysis Given the following financial statements, historical...

    Help on my Finance homework please! Integrative: Complete ratio analysis Given the following financial statements, historical ratios, and industry averages, calculate Sterling Company’s financial ratios for the most recent year. (Assume a 365-day year.) Sterling Company Income Statement for the Year Ended December 31, 2019 Sales revenue $10,000,000 Less: Cost of goods sold 7,500,000       Gross profits $ 2,500,000 Less: Operating expenses        Selling expense $ 300,000        General and administrative expenses 650,000        Lease expense 50,000        Depreciation expense...

  • 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...

  • $10,006,000 7505000 $2,501,000 Given the following financial statements Sterling Company Income Statement for the Year Ended...

    $10,006,000 7505000 $2,501,000 Given the following financial statements Sterling Company Income Statement for the Year Ended December 31, 2015 Sales revenue 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=40%) Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders Earnings per share (EPS) $293,000 635000 48200 192000 1168200 $1,332,800 212000...

  • 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...

  • *Calculate all liqudity, debt, activity, and profitability ratios that are found on the table showing a...

    *Calculate all liqudity, debt, activity, and profitability ratios that are found on the table showing a list of Industry Averages for the firm. This is found beneath the firm's income statement. Please note that the balance sheet is found on the next page. Show all of your calculations. *Complete a cross-sectional analysis by comparing the firm's ratios compared to the industry averages. Use financial terminology and proper English including complete sentences. Cross-sectional ratio analysis Use the financial statements below and...

  • LG P3-23 Financial statement analysis The financial statements of Zach Industries for the year ended December...

    LG P3-23 Financial statement analysis The financial statements of Zach Industries for the year ended December 31, 2012, follow. Zach Industries Income Statement for the Year Ended December 31, 2012 $160,000 106,000 $ 54,000 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expens General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes Net profits after $ 16,000 10,000 1,000 10,000 $ 37,000...

  • 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...

  • Occidental Industries Income Statement for the Year Ended December 31, 2019 200,000 106,000 Sales revenue Less:...

    Occidental Industries Income Statement for the Year Ended December 31, 2019 200,000 106,000 Sales revenue 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 Net profits after taxes 16,000 10,000 1,000 10,000 6,100 4,360 Occidendatal Industries Balance Sheet December 31, 2019 Assets Cash 43,500 Marketable securities 1,000 Accounts receivable 25,000 Inventories 45,500 Total current assets...

  • 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...

  • 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...

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