Credit SAR 40,000 10,000 32,500 DigiPrint Ltd Trial Balance as at 31st January 2022 Account Description Debit SAR Land and Buildings 600,000 Accumulated Depreciation on Land and Buildings Motor Vehicles 40,000 Accumulated Depreciation on Motor Vehicles Furniture and Fittings 90,000 Accumulated Depreciation on Furniture & Fittings Inventory (01/02/2021) 150,000 Accounts Receivable 33,000 Cash at Bank 60,000 Cash in Hand 5,000 Motor vehicle expenses prepaid 200 Accounts Payable Electricity accrued Issued and paid up capital Accumulated retained earnings reserve blf (01/02/2021) Sales Purchases 250,000 Discount Received Discount Allowed 3,000 Return Inwards 5,000 Return Outwards Salary 50,000 Depreciation on Land and Buildings 6,000 Depreciation on Motor Vehicles 8,000 Depreciation on Furniture & Fittings 9,000 Telephone 5,100 Rent 6,000 Electricity 8,500 Motor vehicle expenses 5,000 1,333,800 25,000 300 650,000 80,000 490,000 4,000 2,000 1,333,800 Notes: 1. The following products were in stock of inventory on 31/01/2022: Product ID Product Description Cost Price SAR Unic in Stock CL1 CI2 ELI EI2 HLI HI2 Canon Laser Printer Canon Inkjet Printer Epson Laser Printer Epson Inkjet Printer HP Laser Printer HP Inkjet Printer 300 150 250 200 300 250 Selling Price SAR 400 200 350 300 500 400 140 110 130 90 100 80 Total Stack at Cost SAR 42,000 16,500 32,500 18,000 30,000 20,000 159,000 2. Details of Accounts Receivable at 31/01/2022 were as follows: Customer Address Date Units Customer ID C01 Customer Name Jerico Computers Invoice Number A2030 Dhahran 25/01/20 22 Product ID CL1 CI2 15 20 Amount SAR 6,000 4,000 10,000 CO2 Dammam A2035 Micron Electronics 27/01/20 22 EL 1 EIZ 20 25 7,000 7.500 14,500 CO3 Khobar A2042 Discount Computers 29/01/20 22 HLI HI2 9 10 4,500 4,000 8,500 Total 33,000 Customers are given a discount of 2% if they pay within 15 days of invoice date. 3. Details of Accounts Payable outstanding as at 31/01/2022 were as follows: Supplier Address Date Supplier ID Uuits Product ID Purchase Order Number P501 Amount SAR Supplier Name Canon and Epson Computers S01 Dhahran CLI 26/01/202 2 CI2 15 20 16 15 ELI EI2 4,500 3,000 4,000 3,000 14,500 SO2 Khobar P503 HP Computers 28/01/202 2 HL1 HI2 20 18 6,000 4,500 10.500 Total 25,000 Suppliers provide a discount of 3% if the company pays within 25 days of invoice date. The following transactions took place during the month of February 2022. 1. Sales Product Description Unics Invoice Number A2045 Date Customer Name 10/02/22 Jerico Computers Product ID HLI HI2 HP Laser Printer HP Inkjet Printer 20 15 Amount SAR 10,000 6,000 16,000 A2046 20/02/22 Micron Electronics EL 1 EI2 Epson Laser Printer Epson Inkjet Printer 30 25 10,500 7,500 18,000 A2047 28/02/22 Discount Computers CLI CI2 Canon Laser Printer Canon Inkjet Printer 30 20 12,000 4,000 16,000 Total 50,000 2. Purchases Date Supplier Name Urics Product ID Product Description Amount SAR Purchase Order Number P504 10/02/22 Canon and Epson Computers CLI CI2 ELI EI2 Canon Laser Printer Canon Inkjet Printer Epson Laser Printer Epson Inkjet Printer 25 30 22 30 7,500 4,500 5,500 6,000 23,500 PS05 25/02/22 HP Computers HA201 HA202 HP Laser Printer HP Inkjet Printer 30 30 9,000 7.500 16,500 Total 40,000 3. Receipts from customers Reference No. Date Description Bank Customer Name Jerico Computers Micron Electronics Amount SAR 9,800 R1230 03/02/22 A2030 Bank RU310 04/02/22 A2035 Bank 14,210 4. Payments to suppliers Chaque No. Date Description Bank Supplier Name Canon and Epson Computers HP Computers Amount SAR 36,860 7006 05/02/22 Bank P501 P504 P503 7007 12/02/22 Bank 10,185 5. Retum Inwards (Sales Returns) Reference No. Date Descripcion Customer Name Micron Electronics Amount SAR 700 CN001 25/02/22 Two (2) Epson Laser Printer was returned because they were faulty. DigiPrint decided to write off these items from its stock. 6. Retum Outwards (Purchases Returns) Reference No. Date Description Supplier Name HP Computers Amount SAR 900 DN001 28/02/22 Three (3) HP laser printer was retumed to the supplier (P505) 7. Expenses paid Bank Reference No. Dace Description GL Code Bank Bank Bank Bank Bank 4007 4008 4009 4010 4011 20/02/2022 20/02/2022 20/02/2022 20/02/2022 28/02/2022 Motor Vehicle Expenses Telephone Electricity Rent Salary Amount SAR 400 300 600 500 4,000 8. Motor Vehicle expenses of SAR500 were still owing to a garage on 28/02/2022. 9. The company depreciates its fixed on a straight line basis as follows: Land and Buildings 1% per annum Motor Vehicles 20% per annum Furniture and Fittings: 10% per annum Note: Ignore VAT Required: (a) Use the information in the trial balance on 31 January 2022 to prepare an Income Statement for the year ended 31 January 2022 and a Statement of Financial position as at 31 January 2022 in Microsoft Excel (use separate sheets for these two statements). 6) Key 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)