AutoSave OF AA OOP... ComprehensiveAccounting Case_Excel(6) - Compatibility Mode Review View Tell me Insert Home - Draw Design Layout References Mailings Share Comments Times New... v v 12 X G ~ A Aa As Ev CE > 2 T AMOWE Ald Althide AalbCoid AaBbCoD Hang Heating Pastc BIU al X x A Av Ev Imxx Normal Steng Dictate Editor Y Y Styles Pane 4. Payments to suppliers Gage Bad Dube Supp NERE Carin aradan Campur HP Curapuk 20 EN 26,0 US 14 22 Bank POL PSIH P303 2000 12.1422 Buri 10,185 3. Return Inwards (Sales Recams) HERNA CES Nina Mia Electro AB SNR TM CN91 Der Borys 3.113:32 TWO CDs Ir Printer 2513 Deurbed because they wery Birritatis wrisathan Er hem is ecc. 6. Return Outwards (Purchases Returns RM Som Gelir Nes HP Campus XAR 10 DNSOL 282.22 Turcs (3) HP Tinka u EU the pier (25) 7. Expans paid DER Radio KA DMI Lats ABBRI 2007 BUL Bu Bank Bu Bu 20:02:2022 Melu Vaick: ESSA 10,02:21,22 Teleskus 212.2122 Elarity 2002/20022 Ruu. 2&02.2022 Sery 200 3000 500 SOO 4,00 400 021 1. Motor Vehicle experees of SARS were still owing to a garage on 28.02.2022. 9. The company depreciates its fixed on 2 straight line basis as follows: Land and Huikling Motor Vehicles Pumiture and Fittings Note: Inore VAT 1% pcs 20% per mm 10 peraturam Page 4 of 5 1132 words OX English (United States D Focus 93% AutoSave OF AA OOP... ComprehensiveAccounting Case_Excel(6) - Compatibility Mode Review View Tell me Insert Home - Draw Design Layout References Mailings Share Comments Times New... v v 12 X G ~ A Aa As vvv CE > 2. T Mr- Aalthcdr Cl21. cD Hunting Heating Anledde Normal Pastc BI U vul x X A ov Trun9k 4 Strong Styles Pane Dictate Editor Y Note: Ignore VAT. 3 Required: (a) Use the information in the trial balance on 31st January 2022 to prepare an Income Statement for the year ended 31st January 2022 and a Statement of Financial position as at 31st January 2022 in Microsoft Excel (use separate sheets for these two statements) (b) Kcy in the transactions in MS Excel for the month of February 2022 and prepare an Income statement for the month ended 28 February 2022, and a Statement of Financial Position as at 28 February 2022 (use separate sheets for these two statements) Page 4 of 8 1132 words IE English (United States O Focus ES .66% AutoSave OF AA OOP... ComprehensiveAccounting Case_Excel(6) - Compatibility Mode Review View Tell me Insert Home - Draw Design Layout References Mailings Share Comments Times New... v v 12 X G ~ A Aa As Ev CE > 2 T AMOWE Ald Althide AalbCoid AaBbCoD Hang Heating Pastc BIU al X x A Av Ev Imxx Normal Steng Dictate Editor Y Y Styles Pane 4. Payments to suppliers Gage Bad Dube Supp NERE Carin aradan Campur HP Curapuk 20 EN 26,0 US 14 22 Bank POL PSIH P303 2000 12.1422 Buri 10,185 3. Return Inwards (Sales Recams) HERNA CES Nina Mia Electro AB SNR TM CN91 Der Borys 3.113:32 TWO CDs Ir Printer 2513 Deurbed because they wery Birritatis wrisathan Er hem is ecc. 6. Return Outwards (Purchases Returns RM Som Gelir Nes HP Campus XAR 10 DNSOL 282.22 Turcs (3) HP Tinka u EU the pier (25) 7. Expans paid DER Radio KA DMI Lats ABBRI 2007 BUL Bu Bank Bu Bu 20:02:2022 Melu Vaick: ESSA 10,02:21,22 Teleskus 212.2122 Elarity 2002/20022 Ruu. 2&02.2022 Sery 200 3000 500 SOO 4,00 400 021 1. Motor Vehicle experees of SARS were still owing to a garage on 28.02.2022. 9. The company depreciates its fixed on 2 straight line basis as follows: Land and Huikling Motor Vehicles Pumiture and Fittings Note: Inore VAT 1% pcs 20% per mm 10 peraturam Page 4 of 5 1132 words OX English (United States D Focus 93% AutoSave OF AA OOP... ComprehensiveAccounting Case_Excel(6) - Compatibility Mode Review View Tell me Insert Home - Draw Design Layout References Mailings Share Comments Times New... v v 12 X G ~ A Aa As vvv CE > 2. T Mr- Aalthcdr Cl21. cD Hunting Heating Anledde Normal Pastc BI U vul x X A ov Trun9k 4 Strong Styles Pane Dictate Editor Y Note: Ignore VAT. 3 Required: (a) Use the information in the trial balance on 31st January 2022 to prepare an Income Statement for the year ended 31st January 2022 and a Statement of Financial position as at 31st January 2022 in Microsoft Excel (use separate sheets for these two statements) (b) Kcy in the transactions in MS Excel for the month of February 2022 and prepare an Income statement for the month ended 28 February 2022, and a Statement of Financial Position as at 28 February 2022 (use separate sheets for these two statements) Page 4 of 8 1132 words IE English (United States O Focus ES .66%