USE EXCEL

J Simpson, a sole trader, sells glassware at Metro Hypermarket. The following trial balance was extracted from the books of J Simpson as at 30 September 2020: Debit (S) Credit (s) Land 198,540 Inventory as at 1/10/2019 26,180 Receivables 61,730 Payables 57,160 Cash at bank 11,985 Mortgage loan 11,870 Sales 557,820 Purchases 317,450 Purchases Retums & Allowances 17.965 Sales Returns & Allowances 22,980 Rental costs on office space 41,480 Bank loan 151,000 Interest charged by supplier 1.780 Carriage expense 5,780 Discount expense 2.540 Discount income 1,850 Advertising and media costs 3,150 Light and heat 6,520 Telephone and internet charges 2,220 Insurance 17.850 Rates and water charges 7,950 Wages and salaries 103,740 Staff welfare 12.150 Interest on loan 3,050 Drawings 11,720 Capital 61,130 858,795 858,795 The following information, which has nor been accounted for above, is also available: (1) The inventory count as at 30 September 2020 showed closing inventory valued at S21,540. (ii) During the year to 30 September 2020, J Simpson took the following for personal use: $450 in inventory items per month; $220 from cash at bank per month (iii) Included in the insurance costs above is S14,400 for building insurance which covers the period from 1 October 2019 to 31 December 2020. (iv) Telephone and internet charges are consistent at $222 per month. The amount included in the trial balance above does not include telephone and internet charges for August and September 2020. (v) 40% of carriage expense relates to carriage inwards and the remainder relates to carriage outwards. You are required to prepare: (a) the Statement of Comprehensive Income for the year ended 30 September 2020. (b) the Statement of Financial Position as at 30 September 2020