I prefer to be answered in excel form thanks chegg.

fx Statement of Financial Performance/Income Stat Qtate A B D E 1 2 3 4 5 6 7 Statement of Financial (values in thousands) Sales Sales Discount Net Sales Cost of Sales Gross Profit Operating Expenses Net Income formance/Income Statement 2020 2019 350 330 25 15 325 315 105 125 220 190 145 150 75 40 2018 410 30 380 180 200 165 35 2017 295 10 285 110 175 110 65 8 9 10 11 12 13 14 15 16 17 18 19 20 REQUIREMENT: 1. Prepare Horizontal, Vertical analysis and Trend Percentages for the above Income Stateme 2. Compute for the following ratios: a. Gross Profit Margin b. Net Profit Margin c. Return on Assets A B D 3 4 5 6 7 ASSETS Current Assets Non-Current Assets Total Assets 4,275,000 1,725,000 6,000,000 2,455,000 2,545,000 5,000,000 2,935,000 2,365,000 5,300,000 8 1,470,000 1,400,000 2,870,000 1,485,000 1,500,000 2,985,000 2,100,000 1,700,000 3,800,000 9 10 11 12 13 14 15 LIABILITIES Current Liabilities Non-Current Liabilities Total Liabilities EQUITY Capital Stock Retained Earnings Total Equity 1,130,000 2,000,000 3,130,000 315,000 1,700,000 2,015,000 400,000 1,100,000 1,500,000 16 17 18 19 20 21 22 23 24 25 26 27 REQUIREMENT: 1. Prepare Horizontal, Vertical analysis and Trend Percentages for the above Balance Sheet. 2. Compute for the following ratios: a. Current Ratio b. Working Capital c. Debt to Total Asset Ratio d. Debt to Equity Ratio e. Equity to Assets Ratio