Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Please answer all
image text in transcribed
image text in transcribed
image text in transcribed
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} \begin{tabular}{|l|l|} \hline Depreciation Expense May 2021 & (59) \\ \hline Depreciation Expense June 2021 & (60) \\ \hline Depreciation Expense July 2021 & (61) \\ \hline Depreciation Expense August 2021 & (62) \\ \hline Depreciation Expense September 2021 & (63) \\ \hline Depreciation Expense October 2021 & (64) \\ \hline Depreciation Expense November 2021 & (65) \\ \hline Depreciation Expense December 2021 & (66) \\ \hline Accumulated Depreciation 2021 & (67) \\ \hline & \\ \hline Service Vehicle & Amount \\ \hline Accumulated Depreciation 2021 & (68) \\ \hline \end{tabular} 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} \begin{tabular}{|l|l|} \hline Depreciation Expense May 2021 & (59) \\ \hline Depreciation Expense June 2021 & (60) \\ \hline Depreciation Expense July 2021 & (61) \\ \hline Depreciation Expense August 2021 & (62) \\ \hline Depreciation Expense September 2021 & (63) \\ \hline Depreciation Expense October 2021 & (64) \\ \hline Depreciation Expense November 2021 & (65) \\ \hline Depreciation Expense December 2021 & (66) \\ \hline Accumulated Depreciation 2021 & (67) \\ \hline & \\ \hline Service Vehicle & Amount \\ \hline Accumulated Depreciation 2021 & (68) \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Behind Closed Doors What Company Audit Is Really About

Authors: V. Beattie, R. Brandt, S. Fearnley

2001 Edition

0333747844, 978-0333747841

More Books

Students also viewed these Accounting questions