Excel formula or function for Depreciation schedule.

Good day everyone. I am currently working my depreciation schedule and I am looking for any function or formula that could help me in my schedule. the schedule must show the depreciation expenses of each and every asset of different category, for every particular year and its accumulated depreciation as well. And if possible a warning for every asset that is neering its end of life so I can easilly spot it and remove it on my schedule and transfer it somewhere else. I hope that someone could also help me have the schedule showing the depreciation expense per category for I need to make an entry of the total depreciation per asset account type, eg. Furniture & Fixture, Office Equip., etc.
Attached herewith are the samples of my desired schedule. I hope someone could help me with this.
Attachment 210901

Thanks in advance. Godbless us all. :D

Hi Hale, I had a look at your attachment, and some of the info in there seems to of a sensitive/confidential nature, so I removed the attachment (for your protection)

If I am mistaken and the data is not sensitive, please let me know and I will replace it for you. If I am correct, then please upload a file without the sensitive info (replace with dummy info if you want)

Thanks

edit: also, take a look at this web site and see if it will help you at all?

http://www.dummies.com/how-to/conten...syd-db-an.html