During 2016-2017, Winter Ltd. purchased three types of machines. Because of frequent employee turnover in the accounting department, a different accountant was in charge of selecting the depreciation method for each machine, and various methods have been used. Information concerning the machines is summarised in the table below. Machine Date Initial Initial site Initial delivery Residual Useful Depreciation type acquired cost preparation and assembly value life Method costs Diminishing- 30/09/2016 $36,300 $1,200 $900 $9,000 8 balance Sum-of- 1/02/2017 $25,000 $1,000 $6,000 5 years'-digits 15/11/2017 $52,500 $700 $800 $10,500 10 Straight-line costs 1 2 The end of financial year is at 30 June. The following transactions has taken place since the start of 2018; 2018 Feb. 24 Purchased land and a building worth $145,000, with the intention of tearing down the building and constructing a new office complex. An interest-free loan for $120,000 was taken from another company and the rest was paid in cash, plus an agent's commission of 8,800 and title search fees of $2,750. May 14 Paid Dan's Demolition Services $9,900 to demolish the building acquired on 24 September and received $750, from sale of materials salvaged from demolishing the old building June 30 End of financial year depreciation expenses recorded. July 3 Singed a contract with Easy Construction Ltd, for construction of a new office complex on the land acquired on 24 February. It is expected to cost around $85,000 1 Nov. 25 Paid $1,700 cash for oil changes for the machines. Insurance cost for the machines for the year was $2,000. 2019 June Mar. 10 Purchased a used machine (number 4) for a recommended price of $48,200, but after careful negotiation it was purchased for $42,900 cash. The machine was treated for rust and was re-painted for $600 and installed for $1,200. The engine was reconditioned for $800 cash, as well as servicing the machine at a cost of $520. During installation, one of the major components was dropped and was repaired at a cash cost of $1,500. The machine is expected to make 50,000 units in total, with a residual value of $3,000. 30 End of financial year depreciation expenses recorded. Machine number 4, due to delay in training new labour was not used Aug. 20 The construction of the new office complex was completed. The breakdown of the construction costs (all paid in cash) was as follows: Payment to building contractor, $21,800 building's structure materials, S56,300 planning permit and building approvals, 55,400 excavation costs, $12,000 fees for the design and engineering of the complex, S3,830 The office complex is expected to have a residual value of $8,000 and a useful life of 15 years. The accountant has decided to use straight-line method to calculate the depreciation expenditure. Nov. 25 Paid $1,700 cash for oil changes for the machines. Insurance cost for the machines for the year was $2,000. 2020 Mar. 25 Machine 3 broke down. The management thought about replacing the machine with a new one, but after considering the cost of a new machine, it was decided to perform major repairs on this machine. A new engine was installed for a cost of $23,000, cash. The company expects these repairs to extend the machine's useful life by 2 years and the expected selling price by the end of useful life is 2 June estimated to be $1,200. The carrying amount of the parts replaced in the machine was considered to be equal to $12,000. Apr. 20 A parking area was paved, on the land purchased at a cost of $30,800. The parking area has a useful life of 8 years with $9,000 residual value. The depreciation method is diminishing balance method. 30 End of financial year depreciation expenses recorded. Machine number 4 has produced 12,450 units. July 28 Due to high demand for the newly built office complex, management has decided to extend the office complex, by adding four new offices. The extension is to finish by early September 2020, at a cost of $25,600. As the extension will be fully financed through the Commonwealth Bank of Australia, the full cost of the extension is borrowed on this date from the bank and kept in an account called "cash trust", to be used for the project. The extension will increase the useful life of the building by 4 years. Aug. 11 Due to technological advances the company sold machine 2 for $10,000. Sep. 8 The extension work on the office complex was completed. Interest paid on the loan for extension was $2,800. Required Prepare the necessary general journal entries for all the above transactions, rounding to the nearest whole number for the amounts to be recorded. Depreciation calculations must be based on the dates provided (no rounding to the nearest month). Narrations are not required. Instructions: You are required at least, to have a sheet in excel for General journal entries Workings and calculations (including any relevant T accounts and depreciation rate calculation). Depreciation schedules for each depreciable asset (this could be on a separate sheet or part of the above sheet) 3 During 2016-2017, Winter Ltd. purchased three types of machines. Because of frequent employee turnover in the accounting department, a different accountant was in charge of selecting the depreciation method for each machine, and various methods have been used. Information concerning the machines is summarised in the table below. Machine Date Initial Initial site Initial delivery Residual Useful Depreciation type acquired cost preparation and assembly value life Method costs Diminishing- 30/09/2016 $36,300 $1,200 $900 $9,000 8 balance Sum-of- 1/02/2017 $25,000 $1,000 $6,000 5 years'-digits 15/11/2017 $52,500 $700 $800 $10,500 10 Straight-line costs 1 2 The end of financial year is at 30 June. The following transactions has taken place since the start of 2018; 2018 Feb. 24 Purchased land and a building worth $145,000, with the intention of tearing down the building and constructing a new office complex. An interest-free loan for $120,000 was taken from another company and the rest was paid in cash, plus an agent's commission of 8,800 and title search fees of $2,750. May 14 Paid Dan's Demolition Services $9,900 to demolish the building acquired on 24 September and received $750, from sale of materials salvaged from demolishing the old building June 30 End of financial year depreciation expenses recorded. July 3 Singed a contract with Easy Construction Ltd, for construction of a new office complex on the land acquired on 24 February. It is expected to cost around $85,000 1 Nov. 25 Paid $1,700 cash for oil changes for the machines. Insurance cost for the machines for the year was $2,000. 2019 June Mar. 10 Purchased a used machine (number 4) for a recommended price of $48,200, but after careful negotiation it was purchased for $42,900 cash. The machine was treated for rust and was re-painted for $600 and installed for $1,200. The engine was reconditioned for $800 cash, as well as servicing the machine at a cost of $520. During installation, one of the major components was dropped and was repaired at a cash cost of $1,500. The machine is expected to make 50,000 units in total, with a residual value of $3,000. 30 End of financial year depreciation expenses recorded. Machine number 4, due to delay in training new labour was not used Aug. 20 The construction of the new office complex was completed. The breakdown of the construction costs (all paid in cash) was as follows: Payment to building contractor, $21,800 building's structure materials, S56,300 planning permit and building approvals, 55,400 excavation costs, $12,000 fees for the design and engineering of the complex, S3,830 The office complex is expected to have a residual value of $8,000 and a useful life of 15 years. The accountant has decided to use straight-line method to calculate the depreciation expenditure. Nov. 25 Paid $1,700 cash for oil changes for the machines. Insurance cost for the machines for the year was $2,000. 2020 Mar. 25 Machine 3 broke down. The management thought about replacing the machine with a new one, but after considering the cost of a new machine, it was decided to perform major repairs on this machine. A new engine was installed for a cost of $23,000, cash. The company expects these repairs to extend the machine's useful life by 2 years and the expected selling price by the end of useful life is 2 June estimated to be $1,200. The carrying amount of the parts replaced in the machine was considered to be equal to $12,000. Apr. 20 A parking area was paved, on the land purchased at a cost of $30,800. The parking area has a useful life of 8 years with $9,000 residual value. The depreciation method is diminishing balance method. 30 End of financial year depreciation expenses recorded. Machine number 4 has produced 12,450 units. July 28 Due to high demand for the newly built office complex, management has decided to extend the office complex, by adding four new offices. The extension is to finish by early September 2020, at a cost of $25,600. As the extension will be fully financed through the Commonwealth Bank of Australia, the full cost of the extension is borrowed on this date from the bank and kept in an account called "cash trust", to be used for the project. The extension will increase the useful life of the building by 4 years. Aug. 11 Due to technological advances the company sold machine 2 for $10,000. Sep. 8 The extension work on the office complex was completed. Interest paid on the loan for extension was $2,800. Required Prepare the necessary general journal entries for all the above transactions, rounding to the nearest whole number for the amounts to be recorded. Depreciation calculations must be based on the dates provided (no rounding to the nearest month). Narrations are not required. Instructions: You are required at least, to have a sheet in excel for General journal entries Workings and calculations (including any relevant T accounts and depreciation rate calculation). Depreciation schedules for each depreciable asset (this could be on a separate sheet or part of the above sheet) 3