Ask Experts Questions for FREE Help !
Ask
    Peachey's Avatar
    Peachey Posts: 99, Reputation: 1
    Junior Member
    		  
    #1

    Jun 15, 2009, 03:19 PM
    Understanding Depreciation
    Hi! Out there can anyone help me with my depreciation problem I've tried and tried but my working seems to come out wrong. Please show me how to calculate this properly. :confused:
    Attached Images
     
    hamzashakaa's Avatar
    hamzashakaa Posts: 161, Reputation: 8
    Junior Member
    		  
    #2

    Jun 16, 2009, 05:21 AM
    Kindly find attached depreciation schedule. I hope it can help you. Please note that I assumed in my calculation that the assets were acquired during the year 2009.
    Attached Files
  1. File Type: xls Depreciation.xls (28.5 KB, 199 views)
    2. Peachey's Avatar
    Peachey Posts: 99, Reputation: 1
    Junior Member
    		  
    #3

    Jun 16, 2009, 07:00 AM

    Thank you! But how do I calculate the book value for the check printer after 10-years it depreciated.
    The monthly depreciation on the buildining purchased 1/3 =73.33
    The total depreciation for plant equipment for May. = a. 43.33, b. 43.75 c. 72.50 d.175.49
    The total depreciation for office equipment for May. = a.28.83 b. 44.66 c. 72.50 d 175.49
    The total depreciation expense for may. = a. 127.33 b. 170.66 c. 190.49 d. 205.49
    Please show me the calculation. Please.
    hamzashakaa's Avatar
    hamzashakaa Posts: 161, Reputation: 8
    Junior Member
    		  
    #4

    Jun 16, 2009, 07:37 AM

    The book value for the check printer at the end of 10 years will be the same as the salvage value (150) (500 cost -350 total depreciation for 10 years).

    - The monthly depreciation of the building are included in the excel sheet (cell G:R 21)

    - Total depreciation is included in the excel sheet. And the calculations are there.
    Peachey's Avatar
    Peachey Posts: 99, Reputation: 1
    Junior Member
    		  
    #5

    Jun 16, 2009, 11:34 AM

    I don't think your calculation is correct .
    Total depreciation for plant equipment on May
    A. 43.33 B. 43.75 C. 72.50 D. 175.49
    Total depreciation for office equipment for May
    A. 28.33 B. 44.66 C. 72.50 D. 175.49
    Total depreciation expense for May
    A. 172.33 B. 170.66 C. 190.49 D. 205.49
    hamzashakaa's Avatar
    hamzashakaa Posts: 161, Reputation: 8
    Junior Member
    		  
    #6

    Jun 16, 2009, 11:35 PM

    Total depreciation for plant equipment on May is 72.5 but I did not sum them in the excel sheet if you sum the three items on May you will get 72.5
    Total depreciation for office equipment for May is 44.67 but you just sum them and you will fet this number.
    Total depreciation expense for May is 190.49 the total is on the buttom of the sheet
    Peachey's Avatar
    Peachey Posts: 99, Reputation: 1
    Junior Member
    		  
    #7

    Jun 17, 2009, 12:19 PM

    Hamzashakaa I just want to tell you thank you, also my sisters will be using my e-mail please can you help them also. Thank you and may god bless. I got my first job.
    hamzashakaa's Avatar
    hamzashakaa Posts: 161, Reputation: 8
    Junior Member
    		  
    #8

    Jun 17, 2009, 11:37 PM

    You are more than wellcome.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Accumulated Depreciation and Depreciation Expense [ 10 Answers ]

I have accumulated depreciation and depreciation expense. Do they go together on the Asset side of the balance sheet? My balance sheet is not balancing! The accumulated depreciation is subtracted from the assets on my balance sheet. If I add the depreciation expense to the assets, my balance...

Depreciation Expense and Accumulated Depreciation are classified,respectively, as: [ 3 Answers ]

Depreciation Expense and Accumulated Depreciation are classified,respectively, as: a. expense, contra asset b. asset, contra liability c. revenues, asset d. contra assest, expense I think it is A

Depreciation methods; partial year depreciation [ 5 Answers ]

A company had a bulldozer that was destroyed by fire. The bulldozer originally cost $170,000. The accumulated depreciation on it was $90,000. The proceeds from the insurance company were $155,000. The company should recognize a.A loss of $75,000. b.A loss of $80,000. c.A gain of...

Depreciation Expense and Accumulated Depreciation are classified, respectively, as [ 2 Answers ]

Depreciation Expense and Accumulated Depreciation are classified, respectively, as

Understanding men? [ 7 Answers ]

I have been seeing a lovely fella (usually!) for 8mths now. Im a young 43 and he is 30. Things have been fine although he has recently found out he has diabetes 2 and has had a lot of problems from that, emotional & physical. I have done everything to support and help him and always been there...

View more questions Search