Excel Depreciation for Part of the Year

When working with financial years and depreciation you often have the situation where the asset being purchased has been purchased during the year and not at the start of the year. Here's a function that calculates fixed declining balance depreciation and handles part year depreciation. The DB function has an optional fifth argument that allows you to specify how many months did appreciate in the first year. In the image below you can see the DB function being used in…

Continue ReadingExcel Depreciation for Part of the Year

End of content

No more pages to load