What formula would I use to calculate straight line depreciacion based on the exact day of purchase? I have attached an Excel Workbook that provides the Acquisition Date, Cost, Estimated life and salvage value. I am wanting to calculate the SL depreciation each year since purchase.
Thanks in advance
straight line depreciation.xlsx
Bookmarks