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…