Problem No. 02 (Basic Excel/Google Sheet) The following items are taken from the fixed assets listing in James books of accounts. He is having trouble with depreciating all his assets. He is using the straight line method for depreciation, but is unable to identify how much should be his recorded depreciation. Asset Name Acquisition Acquisition life of the Salvage Value Price Date asset ACER Php 46,200 January 2021 7 years 1,250 Computer Lenovo Laptop Php 26,200 February 2021 6 years 0.00 ACER Php 38,200 February 2021 5 years 0.00 Computer 16 Sofa Sets Php 15,000 January 2021 10 years Php 2,000 each 100 Tables Php April 2021 15 years Php 0.00 15,300/each 10 Lenovo Php March 2021 6 years Php 0.00 Laptops 38,920/each Building A Php March 2021 56 years Php 0.00 26,220,390 Building B Php June 2021 58 years Php 0.00 39,500,200 14 Hi Ace Van Php January 2021 15 years Php 0.00 3,250,000.00 1200 Filing Php 15,200 July 2021 35 years Php 1,000 Cabinets each How Much is the Depreciation to be Recorded for the following months:Furnitures and Fixtures Answers Depreciation Expense January 2021 (42) Depreciation Expense February 2021 (43) Depreciation Expense March 2021 (44) Depreciation Expense April 2021 (45) Depreciation Expense May 2021 (46) Depreciation Expense June 2021 (47) Depreciation Expense July 2021 (48) Depreciation Expense August 2021 (49) Depreciation Expense September 2021 (50) Depreciation Expense October 2021 (51) Depreciation Expense November 2021 (52) Depreciation Expense December 2021 (53) Accumulated Depreciation 2021 (54)