# Need Help With Depreciation Worksheet

• I have a spreadsheet that is over-depreciating the assets. I don't understand the formula used well enough to change it to stop depreciating the assets when they reach the end of the useful life. Below is a shot of the formula and the Setup tab referenced in the formula. Can someone tell me how this needs to be edited to do that?

• I apologize. Attached is the workbook I am working from.

## Files

• 1 Why don't you believe it is working? Narrow down the possibilities

2 I added(inserted) a column next to the DateInService and put in the following formula in cell E3 =DATE(YEAR(D3)+C3,MONTH(D3),DAY(D3)) Then I carried it down - this gives you the Ending Date for Depreciating the asset. I didn't look at all of them, but It appears to be working fine.

ON THE "Depr Expens" section is an issue: so after looking into this a bit deeper, the Summary tab (Fixed Asset Summary Tab) needs to have the SUMIF fomulas UPDATED! The range is/was not big enough (it only went to Row100) you need to update this to include all the rows. I would pick 2000 to pull everything in and allow for additional assets.

Open up the GROUPs to see the individual months and you'll see the formula. I went to cell C32 on Fixed Asset summary -Modify them to be =SUMIFS('Depreciation Schedule'!H\$3:H\$5000,'Depreciation Schedule'!\$A\$3:\$A\$5000,'Fixed Asset Summary'!\$B32) and update the other months....then you may be in better shape!

Before doing any changes, MAKE A BACK UP just in casse!

• Queuesoz -

If you look at the prior Acc Depreciation column (F) on all of the fully depreciated items, they are over-depreciated. For example, the first item was put in service on 8/15/11 and had a cost of \$139,406.50 The prior accumulated depreciation amount is \$233,488.72.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!