This must be done on excel with formulas. I understand requirement 1.

Learning Objectives 2, 4 PC-29A Completing a comprehensive financial statement analysis In its annual report, ABC Athletic Supply, Inc. includes the following five-year 3. 2018: Inventory turnover 8.04 financial summary: ABC ATHLETIC SUPPLY, INC. Five-Year Financial Summary (Partial; adapted) Dollar amounts in thousands except per share data) 2018 2017 2016 2015 2014 2013 Net Sales Revenue $ 250,000 $ 216,000 $ 191,000 $ 161,000 $ 134,000 Net Sales Revenue Increase 16% 13% 19% 20% 17% Domestic Comparative Store Sales Increase 5% 6% 4% 7% 9% Other Income-Net 2, 110 1,840 1,760 1,690 1,330 Cost of Goods Sold 189,250 164,592 148,216 126,385 106,396 Selling and Administrative Expenses 41,210 36,330 31,620 27,440 22,540 Interest: Interest Expense (1,080) (1,380) (1,400) (1,020) (830) Interest Income 125 165 155 235 190 Income Tax Expense 4,470 3,900 3,700 3,320 2,700 Net Income 16,225 11,803 7,979 4,760 3,054 Per Share of Common Stock: Net Income 1.60 1.30 1.20 1.00 0.78 Dividends 0.40 0.38 0.34 0.30 0.26 Financial Position Current Assets, Excluding Merchandise Inventory $ 30, 700 $ 27,200 $ 26,700 $ 24,400 $ 21,500 Merchandise Inventory 24,500 22,600 21,700 19,000 17,500 $ 16,70 Property, Plant, and Equipment, Net 51,400 45,200 40,000 35, 100 25,600 Total Assets 106,600 95,000 88,400 78,500 64,600 Current Liabilities 32,300 28,000 28,300 25,000 16,500 Long-term Debt 23,000 21,500 17,600 19, 100 12,000 Stockholders' Equity 51,300 45,500 42,500 34,400 36, 100 Financial Ratios Acid-Test Ratio 1.0 1.0 0.9 1.0 1.3 Rate of Return on Total Assets 17.2% 14.4% 11.2% 8. 1% 7.1% Rate of Return on Common Stockholders' Equity 33.5% 26.8% 20.8% 13.5% 13.0%Requirements Analyze the company's financial summary for the fiscal years 2014-2018 to decide whether to invest in the common stock of ABC. Include the following sections in your analysis. 1. Trend analysis for net sales revenue and net income (use 2014 as the base year). 2. Profitability analysis. 3. Evaluation of the ability to sell merchandise inventory. 4. Evaluation of the ability to pay debts. 5. Evaluation of dividends. 6. Should you invest in the common stock of ABC Athletic Supply, Inc.? Fully explain your final decision