Answered step by step
Verified Expert Solution
Question
1 Approved Answer
basically, we have to use the information given below to complete and correct the incomplete financial accounts drafted by the accountant Question 1 (Marks:48) Background:
basically, we have to use the information given below to complete and correct the incomplete financial accounts drafted by the accountant
Question 1 (Marks:48) Background: You and a couple of your friends are astute students at lIE MSA in the Engineering programme and have been requested to do an internship at Voltage Engineers based in Feather-Brook. The accountant has been diagnosed with COVID-19 as he has travelled to Wuhan this past summer to seek alternative suppliers. He has therefore not been able to complete his month end duties and the audit is due to start in two weeks' time. Voltage Engineers specialises in electrical engineering and has recently procured a lucrative deal with a large petroleum entity to assist with a full solar power solution given the recent surge in load shedding. The government has recently signed off the IPP agreement which will see a great amount of strain relieved from the grid. All transactions are recorded each day. The accounting records are only performed between Monday and Friday, being the normal working days. Financial Information (Accounting Balances and Transactions): The accountant was instructed by the CFO to provide you with the full accounting information and records of the following items in order to prepare for month end: Trade receivables Trade payables Trade inventories Cash and cash equivalents Non-Current Assets . The information below was extracted from the records of Voltage Engineers for the month of September 2020: R As at 31 August 2020: General Ledger accounts balances Trade Receivables Trade Payables Trade Inventories Bank Property, Plant and Equipment 450 000.00 1500 500.00 (Credit) 1 800 000.00 1 300 000.00 500 760 000 The following transactions and events took place during the month of September 2019: Trade Receivable: Date Details R 30 Sep Total - Sales journal 950 560 Returns-out 99 000 27 918 46789 Returns - in R/D cheques received from debtors Credit losses for settlement discount Allowance for settlement discount 980 68590 Discount received 9862 Total - Purchases journal 750658 Bad debts recovered 9500 1250 Interest charged - debtors Cash and cheques received from debtors Cash sales for the month 550350 350960 Payables: R Totals of subsidiary ledgers on 30 September 2020: Cash receipts journal: Receivables column 843 000 Sales column 930 000 VAT output 105 000 Cash payment journal: Receivable column 19 500 Purchases column 930 000 Payables column 558 000 VAT input 114 000 Total: Purchases book 856 000 Purchases returns book 9 800 Total of the general journal: Debit: Payables ledger 24 500 General ledger 45 900 Credits: Payables ledger 17 500 General ledger 42 600 Additional information: . Airliner's debt of R45 000.00 should be written off. . The account of Eishkom should be charged with interest of R8950. Inventories: Voltage Engineers purchased solar panels, invertors and solar control regulators from Germany on 3 September 2020. The purchase price is 158 000 Euros (spot rate is Euro 15: R?). The items were transported from Frankfort to OR Tambo on a Boeing A350 on 6 September. This cost to transport the inventory paid to the airliner is R178 000 on 5 September. Upon arrival, on 7 September, customs duties levied a further 10% on the purchase price when goods were acquired was levied. The entity spent a further R28 000.00 to transport the item to its warehouse in Little Falls. The spot rates on 6 and 7 September were 15.5 and 16 respectively. All the amount incurred were paid by EFT on the same day. Cash and cash equivalents: The following transactions were not processed and need to be accounted for: The bank statements reflected an interest income of R8500.00 interest on a money market account that was not accounted for. The bad debts recovered of R9500 from a debtor was not posted to the cashbook. Cheque 4540 for R650 000, which was on the outstanding cheque list at the end of August 2020, has still not been processed in the bank statement in September 2020. Bank charges were not accounted for an amount of R850. Property, Plant and Equipment: Looking at the entire 2020 financial year and also looking back in time as this will assist in ensuring that the month of September is done correctly. Machinery A machine was purchased on 01 January 2018 for R1 900 000 (VAT included). The estimated useful life of the machine is ten (10) years, and it was expected that the residual value at the end of the ten (10) years will be R150 000. Motor vehicles Fleet C of vehicles was also purchased on 02 January 2016 for R1 300 000 (VAT included). Vehicles incurred licence and registration costs of R35000 (excl. vat) upon acquisition. Motor vehicles are depreciated at 10% p.a. and it is expected that the residual value at the end of the useful life will be R 135 000. Additional information: Property, plant and equipment: o Are held at cost model. o Depreciation methods for different classes are as follows: Machinery - Diminishing Method Motor vehicles - Cost model Returns 27,918 68,590 Incomplete financial accounts drafted by the Accountant: Receivable (Debtors) control account Opening balance b/d 450,000 SRJ Sales - credit SJ 950,560 Allowance settlement discount GJ R/D cheques CBP 46,789 Bad debts G) Cash sales CBR 350,960 credit losses balance b/f 45,000 890 167,485 01/10/2020 Balance b/d 167,485 CR DR b/d 1,500,500 Bank CBP Payable (Creditors) control account opening Balance 558,000 Journal credits 24,500 Discount received GJ G) 16,500 9,862 Journal debit GJ Balance c/d 1,434,858 1,526,862 1,526,862 General Journal for September 2020 Date Description Debit Credit R R 09-Mar-20 2,212,000 Inventories Bank 2,212,000 221,200 221,200 07/092020 Inventories Bank customs Inventories Payables 2,212,000 CR DR Bank R R Balance B/d 1,300,000.00 Trade payables CBP 358,000 Inventories/Consumables CBP bad debts recovered GJ 9,500 2.212.000 Cash sales CBR 350,960 2,212,000 2,018,460 Balance b/d 358,000 2,212,000 Bank reconciliation Closing balance per general ledger Add Outstanding cheques: Cheque 4530 Bank charges Closing balance per bank statements -850 2,211,150 2 000 000 100/115 = 1 652 174 Machinery Cost excl Vat Depreciable amount Annual Depreciation 165,217.40 Accumulated Depreciation Carrying Amount Date Cost Depreciation Depreciable amount 01/01/2018 1,652,174 1,652,174 1,652,174 1,652,174 31/12/2018 1,652,174 165,217 165,217 1,486,957 1,486,957 165,217 330,435 31/12/2019 1,652,174 1,321,739 30/09/2020 TOTAL 1,321,739 1,652,174 123,913 454,348 454,348 950,000 1,197,826 5,658,696 1,652,174.00 calc less 1,652,174.00 Calc dep amount years 1,652,174.00 10 depr 165,217.40 Motor Vehicles Cost (exclusive of VAT) 1 300 000 * 100/115 = 1 500 000 cost of vehicles includ licence Depreciable Amount First Depreciation 1 535 000 -135 000 = 1 405 000 Accumulated Depreciation Carrying Amount Date Cost Depreciable amount Depreciation 1,535,000 1,405,000 1,535,000 01-Jan-16 1,405,000 1,535,000 1,535,000 31-Dec-16 1,405,000 31-Dec-17 1,405,000 1,535,000 31-Dec-18 1,535,000 1,405,000 1,535,000 30-Sep-19 1,535,000 6,140,000 TOTAL Date Fol. Dr Cr Details 30-Sep-20 Depreciation Accumulated depreciation: Motor vehicles Depreciation for the month Date Fol. Dr Cr Details 30-Sep-20 Depreciation Accumulated depreciation: Machinery Depreciation for the month END OF ASSIGNMENT Question 1 (Marks:48) Background: You and a couple of your friends are astute students at lIE MSA in the Engineering programme and have been requested to do an internship at Voltage Engineers based in Feather-Brook. The accountant has been diagnosed with COVID-19 as he has travelled to Wuhan this past summer to seek alternative suppliers. He has therefore not been able to complete his month end duties and the audit is due to start in two weeks' time. Voltage Engineers specialises in electrical engineering and has recently procured a lucrative deal with a large petroleum entity to assist with a full solar power solution given the recent surge in load shedding. The government has recently signed off the IPP agreement which will see a great amount of strain relieved from the grid. All transactions are recorded each day. The accounting records are only performed between Monday and Friday, being the normal working days. Financial Information (Accounting Balances and Transactions): The accountant was instructed by the CFO to provide you with the full accounting information and records of the following items in order to prepare for month end: Trade receivables Trade payables Trade inventories Cash and cash equivalents Non-Current Assets . The information below was extracted from the records of Voltage Engineers for the month of September 2020: R As at 31 August 2020: General Ledger accounts balances Trade Receivables Trade Payables Trade Inventories Bank Property, Plant and Equipment 450 000.00 1500 500.00 (Credit) 1 800 000.00 1 300 000.00 500 760 000 The following transactions and events took place during the month of September 2019: Trade Receivable: Date Details R 30 Sep Total - Sales journal 950 560 Returns-out 99 000 27 918 46789 Returns - in R/D cheques received from debtors Credit losses for settlement discount Allowance for settlement discount 980 68590 Discount received 9862 Total - Purchases journal 750658 Bad debts recovered 9500 1250 Interest charged - debtors Cash and cheques received from debtors Cash sales for the month 550350 350960 Payables: R Totals of subsidiary ledgers on 30 September 2020: Cash receipts journal: Receivables column 843 000 Sales column 930 000 VAT output 105 000 Cash payment journal: Receivable column 19 500 Purchases column 930 000 Payables column 558 000 VAT input 114 000 Total: Purchases book 856 000 Purchases returns book 9 800 Total of the general journal: Debit: Payables ledger 24 500 General ledger 45 900 Credits: Payables ledger 17 500 General ledger 42 600 Additional information: . Airliner's debt of R45 000.00 should be written off. . The account of Eishkom should be charged with interest of R8950. Inventories: Voltage Engineers purchased solar panels, invertors and solar control regulators from Germany on 3 September 2020. The purchase price is 158 000 Euros (spot rate is Euro 15: R?). The items were transported from Frankfort to OR Tambo on a Boeing A350 on 6 September. This cost to transport the inventory paid to the airliner is R178 000 on 5 September. Upon arrival, on 7 September, customs duties levied a further 10% on the purchase price when goods were acquired was levied. The entity spent a further R28 000.00 to transport the item to its warehouse in Little Falls. The spot rates on 6 and 7 September were 15.5 and 16 respectively. All the amount incurred were paid by EFT on the same day. Cash and cash equivalents: The following transactions were not processed and need to be accounted for: The bank statements reflected an interest income of R8500.00 interest on a money market account that was not accounted for. The bad debts recovered of R9500 from a debtor was not posted to the cashbook. Cheque 4540 for R650 000, which was on the outstanding cheque list at the end of August 2020, has still not been processed in the bank statement in September 2020. Bank charges were not accounted for an amount of R850. Property, Plant and Equipment: Looking at the entire 2020 financial year and also looking back in time as this will assist in ensuring that the month of September is done correctly. Machinery A machine was purchased on 01 January 2018 for R1 900 000 (VAT included). The estimated useful life of the machine is ten (10) years, and it was expected that the residual value at the end of the ten (10) years will be R150 000. Motor vehicles Fleet C of vehicles was also purchased on 02 January 2016 for R1 300 000 (VAT included). Vehicles incurred licence and registration costs of R35000 (excl. vat) upon acquisition. Motor vehicles are depreciated at 10% p.a. and it is expected that the residual value at the end of the useful life will be R 135 000. Additional information: Property, plant and equipment: o Are held at cost model. o Depreciation methods for different classes are as follows: Machinery - Diminishing Method Motor vehicles - Cost model Returns 27,918 68,590 Incomplete financial accounts drafted by the Accountant: Receivable (Debtors) control account Opening balance b/d 450,000 SRJ Sales - credit SJ 950,560 Allowance settlement discount GJ R/D cheques CBP 46,789 Bad debts G) Cash sales CBR 350,960 credit losses balance b/f 45,000 890 167,485 01/10/2020 Balance b/d 167,485 CR DR b/d 1,500,500 Bank CBP Payable (Creditors) control account opening Balance 558,000 Journal credits 24,500 Discount received GJ G) 16,500 9,862 Journal debit GJ Balance c/d 1,434,858 1,526,862 1,526,862 General Journal for September 2020 Date Description Debit Credit R R 09-Mar-20 2,212,000 Inventories Bank 2,212,000 221,200 221,200 07/092020 Inventories Bank customs Inventories Payables 2,212,000 CR DR Bank R R Balance B/d 1,300,000.00 Trade payables CBP 358,000 Inventories/Consumables CBP bad debts recovered GJ 9,500 2.212.000 Cash sales CBR 350,960 2,212,000 2,018,460 Balance b/d 358,000 2,212,000 Bank reconciliation Closing balance per general ledger Add Outstanding cheques: Cheque 4530 Bank charges Closing balance per bank statements -850 2,211,150 2 000 000 100/115 = 1 652 174 Machinery Cost excl Vat Depreciable amount Annual Depreciation 165,217.40 Accumulated Depreciation Carrying Amount Date Cost Depreciation Depreciable amount 01/01/2018 1,652,174 1,652,174 1,652,174 1,652,174 31/12/2018 1,652,174 165,217 165,217 1,486,957 1,486,957 165,217 330,435 31/12/2019 1,652,174 1,321,739 30/09/2020 TOTAL 1,321,739 1,652,174 123,913 454,348 454,348 950,000 1,197,826 5,658,696 1,652,174.00 calc less 1,652,174.00 Calc dep amount years 1,652,174.00 10 depr 165,217.40 Motor Vehicles Cost (exclusive of VAT) 1 300 000 * 100/115 = 1 500 000 cost of vehicles includ licence Depreciable Amount First Depreciation 1 535 000 -135 000 = 1 405 000 Accumulated Depreciation Carrying Amount Date Cost Depreciable amount Depreciation 1,535,000 1,405,000 1,535,000 01-Jan-16 1,405,000 1,535,000 1,535,000 31-Dec-16 1,405,000 31-Dec-17 1,405,000 1,535,000 31-Dec-18 1,535,000 1,405,000 1,535,000 30-Sep-19 1,535,000 6,140,000 TOTAL Date Fol. Dr Cr Details 30-Sep-20 Depreciation Accumulated depreciation: Motor vehicles Depreciation for the month Date Fol. Dr Cr Details 30-Sep-20 Depreciation Accumulated depreciation: Machinery Depreciation for the month END OF ASSIGNMENTStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started