Question


a. Create a spreadsheet similar to Table 3.1 to model the following: (1) A multiple-step comparative income statement for Day

Tofits of the expen 2019 interest, net proto Once we have the before- appropriate tax rates. Deducting taxes leaves us divide
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Hi, See below

Multi step income comparitive statement of Dayton Inc
Particulars 2019 2018
Sales revenue       1,050,000           735,000
Less: Cost of Goods sold - See note 1 below          270,000           189,000
Gross Profits          780,000           546,000
                  -  
Less: Operating expenses                   -  
Selling expenses            50,000            35,000
General and administrative expenses          120,000            84,000
Other operating expenses          115,000            80,500
Depreciation expenses          150,000           105,000
Total Operating expenses          435,000           304,500
                  -  
Operating profits          345,000           241,500
Less: Interest expense          100,000            70,000
Net profit before taxes          245,000           171,500
Less: Preferred stock dividends            20,000            14,000
Earnings available for common stcokholders          225,000           157,500
Earnings per share
(225000/75000)
(157500/75000)
              3.00                2.10
Dividend per share
(99000/75000 shares)
(100000/75000 shares)
              1.32                1.33
All the numbers above are assumed.
Note 1: Based on assumptions
Opening inventory 70000
Add: Purchases 310000
Less: Closing inventory -110000
Cost of Goods sold 270000
Shares outstanding 2018(Assumed) 75000
Shares outstanding 2019( Assumed) 75000
Common size income statement of Dayton Inc
Particulars 2019 % 2018 %
Sales revenue 1,050,000 100% 735,000 100%
Less: Cost of Goods sold - See note 1 below     270,000 26% 189,000 26%
Gross Profits     780,000 74% 546,000 74%
          -  
Less: Operating expenses           -  
Selling expenses       50,000 5%    35,000 5%
General and administrative expenses     120,000 11%    84,000 11%
Other operating expenses     115,000 11%    80,500 11%
Depreciation expenses     150,000 14% 105,000 14%
Total Operating expenses     435,000 41% 304,500 41%
          -  
Operating profits     345,000 33% 241,500 33%
Less: Interest expense     100,000 10%    70,000 10%
Net profit before taxes     245,000 23% 171,500 23%
Less: Preferred stock dividends       20,000 2%    14,000 2%
Earnings available for common stcokholders     225,000 21% 157,500 21%
Earnings per share
(225000/75000)
(157500/75000)
          3.00        2.10
Dividend per share
(99000/75000 shares)
(100000/75000 shares)
          1.32        1.33
All the numbers above are assumed.
Add a comment
Know the answer?
Add Answer to:
a. Create a spreadsheet similar to Table 3.1 to model the following: (1) A multiple-step comparative...
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
  • Using the tables (pictured) below, conduct a complete ratio analysis of the Bartlett Company for the...

    Using the tables (pictured) below, conduct a complete ratio analysis of the Bartlett Company for the years 2018 and 2019. You should assess the firm’s liquidity, activity, debt, and profitability ratios. Highlight any particularly positive or negative developments that you uncover when comparing ratios from 2018 to 2019. Bartlett Company Income Statements ($000) For the Years Ended December 31 2019 2018 Sales revenue $3,080 $2,590 Less: Cost of goods sold 2,086 1,705 Gross profits $994 $885 Less: Operating expenses Selling...

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

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

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

  • I need help on this question. Creek Enterprises Income Statement for the Year Ended December 31,...

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

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

  • Same Table for each question. Thank you! Please use the attached balance sheet and income statements...

    Same Table for each question. Thank you! Please use the attached balance sheet and income statements to calculate. Cash flow from operation activity for 2019 is 2018 2019 2018 2019 Assets Liabilities & Equity Current liabilities: Current assets: Cash and marketable securities $ 10 $ 5 19 Accounts receivable $ 5 Accrued wages and taxes 20 Accounts payable 36 Notes payable Inventory - $ 53 Total $ 61 Total $ 34 S 40 Fixed assets: $ 53 $ 57 Gross...

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

  • (Click on the icon located on the top-right corner of the data table below in order...

    (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Creek Enterprises Income Statement for the Year Ended December 31, 2015 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses $29,987,000 20,980,000 $9,007,000 $3,041,000 1,818,000 183,000 956,000 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...

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

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