Question: Answer all please Problem No. 02 (Basic Excel/Google Sheet) The following items are taken from the fixed assets listing in James books of accounts. He

Answer all please  Answer all please 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

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. \begin{tabular}{|l|l|l|l|l|} \hline Computer & & & & \\ \hline 16 Sofa Sets & Php 15,000 each & January 2021 & 10 years & Php 2,000 \\ \hline 100 Tables & Php 15,300 leach & April 2021 & 15 years & Php 0.00 \\ \hline 10 Lenovo Laptops & Php 38,920 each & March 2021 & 6 years & Php 0.00 \\ \hline Building A & Php 26,220,390 & March 2021 & 56 years & Php 0.00 \\ \hline Building B & Php 39,500,200 & June 2021 & 58 years & Php 0.00 \\ \hline 14 Hi Ace Van & Php 3,250,000.00 & January 2021 & 15 years & Php 0.00 \\ \hline 1200 Filing Cabinets & Php 15,200 each & July 2021 & 35 years & Php 1,000 \\ \hline \end{tabular} How Much is the Depreciation to be Recorded for the following months

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!