answers in excel ?!

A D F G 1 2 3 You must record your answer in the space below the question on this page. Answers recorded elsewhere will not be marked. MARKS QUESTION 12 4 5 8 7 a 9 The accounts of Oval Computers (OC) Pty Ltd for the period 2018-2019 are presented below 2019 2018 Cash in hand $36 $33 Accounts Receivable 129 99 Inventory 351 264 Equipment 480 540 Furniture 330 285 TOTAL 1326 1221 b 10 d 2 e 13 f 14 15 78 93 120 8 h Accounts Payable Bank loan (to be repaid in 3 months) Share Capital Retained Earnings TOTAL 90 900 17 i 900 213 18 153 1221 1326 k 20 21 22 m Net Sales Cost of Goods Sold Operating expenses Profit 921 636 123 162 804 591 114 99 23 n 24 0 25 20 Required: Showing ratio formula, supportive figures; Compute the following ratios for 2019 financial year (2 decimal places) 27 28 29 30 31 i Current Ratio (times) ii Quick or Acid Test Ratio (times) iii Average Receivables turnover ratio (times) iv Average collection period of accounts receivable v Average Inventory turnover (times) vi Net Profit margin 2 marks 2 marks 2 marks 2 marks 2 marks 2 marks 32 33 34 35 30 37 Record YOUR ANSWER (below) 38 39 an