a.Re-create the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Note, the tax rate is 40% and there is no payout ratio

b.On another worksheet, create a statement of cash flows for 2018. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets.

c.Using Excel’s outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section.

Income statement

 

2018 2017 $ 3,000.0 $ 2,850.0 $ 2,616.2 $ 2,497.0 100.0 $ Net Sales Operating costs except depreciation and amortization Depreciation and Amortization Earning before Interest and Taxes (EBIT) 90.0 283.8 $ 263.0 Less interest 88.0 $ 60.0 Earning before Taxes (EBT) 195.8 $ 203.0 Taxes 78.3 $ 81.2 Net Income 117.5 $ 121.8 Total Dividends 57.5 $ 53.0 Rate 40%