Depreciation schedule - Excel

I want a Excel spreadsheet to calculate asset depreciation and be able to handle all common methods of depreciation. I want to select my own percentage per year but have that default to 10% if nothing entered. I want to be able to enter a large number of items into the sheet and have that display the amount that has been depreciated each year item by item as well as totals for each item as well as grand totals. These items have a broad range of purchase dates / years. ranging from 1980's through to 2021 and beyond. I'd like to see projections for each item as well - for example being able to display for each item at what point / year the item value will / has reached $0.00 value. Below are some example templates that I downloaded for free, they are all depreciation schedules / calculators in their own way but lack some of the functionality I want. Particularly running totals for each item - most simply give an amount by which an item has been depreciated by in a given year.