Depreciation Cost Help

mdonaldson

Wanted to use the template listed to create a new sheet and see if it would work that way, but it isn't available any longer..

Essentially, I'd like to be able to find the depreciation cost year over year of assets currently being tracked in a sheet. We display the cost price paid on purchase, and the date of purchase, but nothing beyond that.

Is there a formula I could use to display the depreciation cost in another column? What would that look like? I'd prefer not changing a lot of the sheet, as it works pretty well the way it's currently set up now.

Eric Law

Depreciation Cost Help

mdonaldson

Dec 8, 2023

Wanted to use the template listed to create a new sheet and see if it would work that way, but it isn't available any longer..

Essentially, I'd like to be able to find the depreciation cost year over year of assets currently being tracked in a sheet. We display the cost price paid on purchase, and the date of purchase, but nothing beyond that.

Is there a formula I could use to display the depreciation cost in another column? What would that look like? I'd prefer not changing a lot of the sheet, as it works pretty well the way it's currently set up now.

---

View Post

Could you provide more context and some screenshots? Also, let us know what you want it to show.