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


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
Get step-by-step solutions from verified subject matter experts
