The following are extracts of the Income Statement and Balance Sheet of Great Success Ltd. 2021 (000) 2022 (000) Non-current Asset Plant and equipment (net)6,6126,960Vehicle (net)1,1001,000 7,7127,960Current Assets Inventory3,4003,250Receivable (net)1,8201,900Balance at Bank750760Cash In hand32Total current asset5,9735,912TOTAL ASSETS13,68513,872Current Liabilities Account payable16241,732Expenses payable7875Current tax liability554.75868 2,256.752,675Non-current Liabilities Loan420400Debentures4,4004,200TOTAL LIABILITIES 7,076.757,275NET ASSETS 6,608.256,597Shareholders equity3,6003,600Retained Profit2,728.252,747General reserve280250 6,608.256,597 Sales23,50025,000Cost of Sales15,98016,250GROSS PROFIT7,5208,750Less: Selling expenses3,0553,250Administrative expenses1,8802,000Interest expenses1,0001,020NET PROFIT BEFORE INCOME TAX1,5852,480Less: Income tax expenses 554.75868NET PROFIT AFTER INCOME TAX1,030.251,612 Investors Ratios: Dividend Per Share 1620Number of Shares Issued 3,600,0003,600,000Average share price 2.53 Ratios Measures Gross Profit Margin 30 percent Net Profit Margin 6.6 percent Receivable Collection Period 35 days Earnings Per Share 40 pence Dividend Yield 3.2 percent Rate of return on total assets 17.8 percent Asset turnover ratio 2.7 times Current ratio 1.9:1 Quick ratio 0.9:1 Inventory turnover in days 64 days Debt ratio 40 percent Times interest earned 4.0 times Price Earnings ratio 6.5 times

You are required to calculate and show your workings on the following ratios for both years: i. Gross Profit Margin ii. Net Profit Margin iii. Current Ratio iv. Quick Ratio v. Receivables Collection Period vi. Earnings Per Share vii. Price Earnings (PE) Ratio viii. Dividend Yield ix. Rate of return on total assets x. Asset turnover ratio xi. Inventory turnover (in days) xii. Debt ratio xiii. Times interest earned Please provide the answer in excel /table including (formula, workings, calculation, answer for 2021 & 2022, comparison with answer 2022 and 2021, comparison with answer 2022 and ratios