This is an excel assignment but it is 70% done...you must use questions from textbook. Spreadsheet exercise gives students an opportunity to use Excel software to create one or more spreadsheets to...

incomestatement (2)
    Dayton, Inc.
    Annual Income Statement (Values in Millions)
                Common
                Size
        2019    2018    2019    2018
    Sales    $ 178,909    $ 187,510    100.0%    100.0%
    Cost of Sales    109,701    111,631    61.3%    59.5%
    Gross Operating Profit    $ 69,208    $ 75,879    38.7%    40.5%
    Selling, General & Admin. Expense    12,356    12,900    6.9%    6.9%
    Other Taxes    33,572    33,377    18.8%    17.8%
    EBITDA    $ 23,280    $ 29,602    13.0%    15.8%
    Depreciation & Amortization    12,103    7,944    6.8%    4.2%
    EBIT    $ 11,177    $ 21,658    6.2%    11.6%
    Other Income, Net    3,147    3,323    1.8%    1.8%
    Earnings Before Interest and Taxes    $ 14,324    $ 24,981    8.0%    13.3%
    Interest Expense    398    293    0.2%    0.2%
    Earnings Before Taxes    $ 13,926    $ 24,688    7.8%    13.2%
    Income Taxes                    0.21    tax rate
    Net Income Available to Common    $ 13,926    $ 24,688    7.8%    13.2%
    Dividends per share    $ 1.50    $ 0.91
    EPS    $ 1.71    $ 1.15    $ 0.91
            $ 1.64    $ 2.87
    Computation of 2012 Cost of Sales:
    Beginning Inventory    7,904
    Purchases    109,865
    Goods Available    117,769
    Cost of Sales    109,701
    Ending Inventory    8,068
incomestatement
    Dayton, Inc.
    Annual Income Statement (Values in Millions)
                Common
                Size
        2019    2018    2019    2018
    Sales    $ 178,909    $ 187,510    100.0%    100.0%
    Cost of Sales    109,701    111,631    61.3%    59.5%
    Gross Operating Profit    $ 69,208    $ 75,879    38.7%    40.5%
    Selling, General & Admin. Expense    12,356    12,900    6.9%    6.9%
    Other Taxes    33,572    33,377    18.8%    17.8%
    EBITDA    $ 23,280    $ 29,602    13.0%    15.8%
    Depreciation & Amortization    12,103    7,944    6.8%    4.2%
    EBIT    $ 11,177    $ 21,658    6.2%    11.6%
    Other Income, Net    3,147    3,323    1.8%    1.8%
    Earnings Before Interest and Taxes    $ 14,324    $ 24,981    8.0%    13.3%
    Interest Expense    398    293    0.2%    0.2%
    Earnings Before Taxes    $ 13,926    $ 24,688    7.8%    13.2%
    Income Taxes    2,924    5,184            0.21    tax rate
    Net Income Available to Common    $ 11,002    $ 19,504    6.1%    10.4%
    Dividends per share    $ 1.15    $ 0.91
    EPS    $ 1.64    $ 2.87
    Computation of 2019 Cost of Sales:
    Beginning Inventory    $ 7,904
    Purchases    109,865
    Goods Available    $ 117,769
    Cost of Sales    109,701
    Ending Inventory    $ 8,068
alancesheet (2)
    Dayton, Inc.
    Annual Balance Sheet (Values in Millions)
                Common
                Size
        2019    2018    2019    2018
    Assets
    Cu
ent Assets
    Cash and Equivalents    $ ...