Prepare a working spreadsheet for Davids Shooting Supplies, Inc. for the years 2019 and 2020.

a. The financial statements are attached.

2. Using the financial statements and your spreadsheet, create the Vertical Statements for the years 2020 and 2019, and the Horizontal Statement for the year 2020.

3. Using the financial statements and your spreadsheet, create financial ratios (liquidity, activity or operating, leverage, profitability, and market or valuation ratios) for the firm for both years 2019 and 2020.

Any help is appreciated! thank you, see financial statements below

A E 1 B CI D David's Shooting Supplies, Inc. Income Statements $ Millions 5 31-Dec-20 31-Dec-19 al 100AWIN $ $ $ $ $ $ $ $ $ $ 1,563.700 1,081.100 482.600 231.100 83.100 168.400 5.600 $ $ $ $ $ $ $ $ $ $ 1,386.700 974.800 411.900 197.400 75.300 139.200 18.000 121.200 16.100 105.100 162.800 44.300 118.500 6 7 8 Net Sales 9 Cost of Goods Sold 10 G. Profit 11 Selling and Administrative Expenses 12 Depreciation Expense 13 Net Operating Profit (EBIT) 14 Interest expense 15 Earnings Before Tax 16 Income Tax Expense 17 Net Income 18 19 20 21 22 23 24 Net Income 25 Preferred Dividends 26 Net Income to Common Equity 27 Common Dividends 28 Net Income to Retained Earnings 29 Beginning Retained Earnings 30 Ending Retained Earnings 31 32 Earnings Per Share (EPS) 33 34 David's Shooting Supplies, Inc. Statement of Retained Earnings $ Millions 118.500 105.100 $ $ $ $ 118.500 105.100 $ $ $ $ $ $ $ $ 118.5 (50.700) 67.800 ulla 105.100 (155.800) (50.700) $ 2.172 $ 1.926 A B F G H 1 2 3 D E David's Shooting Supplies, Inc. Balance Sheets $ Millions 4 5 Assets 31-Dec-20 31-Dec-19 6 Current Assets: 7 8 9 10 11 12 Cash/Cash equivalents Accounts Receivable Inventory Other Current Assets Total current assets: $ $ $ $ 288.50 306.20 423.80 21.30 1,039.80 $ $ $ $ $ 16.60 268.80 372.70 29.90 $ 688.00 Gross Plant and Equipment Accumulated Depreciation Net Plant and Equipment 13 14 15 16 17 18 19 20 21 $ $ $ 911.60 512.20 $ $ $ 823.30 429.10 399.40 394.20 Goodwill $ 450.00 $ 411.60 Total Long Term Assets $ 849.40 $ 805.80 22 $ 1,889.20 $ 1,493.80 23 Total Assets 24 25 Liabilities and owners equity 26 27 Current liabilities 28 29 Accounts Payable 30 Notes Payable 31 Accrued Income Tax 32 Total Current Ilabilities || || 349.30 10.50 18.00 377.80 $ $ $ $ 325.00 4.20 16.80 346.00 33 $ $ $ 189.40 384.60 574.00 $ $ $ 91.70 213.90 305.60 $ 951.80 $ 651.60 34 Long term debt 35 36 Debentures 37 Bonds 38 Total Long Term Debt 39 40 Total debt: 41 42 Shareholders equity 43 eferred stock 45 Common stock (54,566,054 shares) 46 Paid in capital 47 Retained Earnings 48 Less: Treasury Stock 49 Total Shareholders equity 50 Total libilities and shareholders equity 52 53 Important Disclosure note information 54 Common Shares 55 Millions 56 Market Price Per Share 51 $ $ $ $ $ $ 50.00 842.90 67.80 (23.30) 937.40 $ $ $ $ $ 50.00 842.90 (50.70) $ 842.20 51 $ 1,889.20 $ 1,493.80 Par Value: $91.63 54,566,054.00 54.57 49.61 54,566,054.00 54.57 $ 40.50 $ A E 1 B CI D David's Shooting Supplies, Inc. Income Statements $ Millions 5 31-Dec-20 31-Dec-19 al 100AWIN $ $ $ $ $ $ $ $ $ $ 1,563.700 1,081.100 482.600 231.100 83.100 168.400 5.600 $ $ $ $ $ $ $ $ $ $ 1,386.700 974.800 411.900 197.400 75.300 139.200 18.000 121.200 16.100 105.100 162.800 44.300 118.500 6 7 8 Net Sales 9 Cost of Goods Sold 10 G. Profit 11 Selling and Administrative Expenses 12 Depreciation Expense 13 Net Operating Profit (EBIT) 14 Interest expense 15 Earnings Before Tax 16 Income Tax Expense 17 Net Income 18 19 20 21 22 23 24 Net Income 25 Preferred Dividends 26 Net Income to Common Equity 27 Common Dividends 28 Net Income to Retained Earnings 29 Beginning Retained Earnings 30 Ending Retained Earnings 31 32 Earnings Per Share (EPS) 33 34 David's Shooting Supplies, Inc. Statement of Retained Earnings $ Millions 118.500 105.100 $ $ $ $ 118.500 105.100 $ $ $ $ $ $ $ $ 118.5 (50.700) 67.800 ulla 105.100 (155.800) (50.700) $ 2.172 $ 1.926 A B F G H 1 2 3 D E David's Shooting Supplies, Inc. Balance Sheets $ Millions 4 5 Assets 31-Dec-20 31-Dec-19 6 Current Assets: 7 8 9 10 11 12 Cash/Cash equivalents Accounts Receivable Inventory Other Current Assets Total current assets: $ $ $ $ 288.50 306.20 423.80 21.30 1,039.80 $ $ $ $ $ 16.60 268.80 372.70 29.90 $ 688.00 Gross Plant and Equipment Accumulated Depreciation Net Plant and Equipment 13 14 15 16 17 18 19 20 21 $ $ $ 911.60 512.20 $ $ $ 823.30 429.10 399.40 394.20 Goodwill $ 450.00 $ 411.60 Total Long Term Assets $ 849.40 $ 805.80 22 $ 1,889.20 $ 1,493.80 23 Total Assets 24 25 Liabilities and owners equity 26 27 Current liabilities 28 29 Accounts Payable 30 Notes Payable 31 Accrued Income Tax 32 Total Current Ilabilities || || 349.30 10.50 18.00 377.80 $ $ $ $ 325.00 4.20 16.80 346.00 33 $ $ $ 189.40 384.60 574.00 $ $ $ 91.70 213.90 305.60 $ 951.80 $ 651.60 34 Long term debt 35 36 Debentures 37 Bonds 38 Total Long Term Debt 39 40 Total debt: 41 42 Shareholders equity 43 eferred stock 45 Common stock (54,566,054 shares) 46 Paid in capital 47 Retained Earnings 48 Less: Treasury Stock 49 Total Shareholders equity 50 Total libilities and shareholders equity 52 53 Important Disclosure note information 54 Common Shares 55 Millions 56 Market Price Per Share 51 $ $ $ $ $ $ 50.00 842.90 67.80 (23.30) 937.40 $ $ $ $ $ 50.00 842.90 (50.70) $ 842.20 51 $ 1,889.20 $ 1,493.80 Par Value: $91.63 54,566,054.00 54.57 49.61 54,566,054.00 54.57 $ 40.50 $