From the course: Excel: Financial Functions in Depth (2022)

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Creating a depreciation schedule

Creating a depreciation schedule - Microsoft Excel Tutorial

From the course: Excel: Financial Functions in Depth (2022)

Start my 1-month free trial Buy for my team

Creating a depreciation schedule

“

- [Instructor] Now that we've calculated the depreciation on a monthly basis, we'll be able to create the depreciation schedule below. We've got our opening balance already here for you using a SUMIFS function that will pick up all of the fixed assets that were purchased prior to the date on the schedule, which is January 25. So we can go in now and use another SUMIFS function to pick up all of the new CapEx, so that is all of the cost that happened during the month of January. However, as we discussed back in chapter four, the date here is in fact the first of the month. But if we look at the spend date in our purchase items, we can see that the day of the month is all over the place. So that means that our SUMIFS function is not going to work because it's going to look for the first of the month and it won't necessarily find that in the spend date. So there's a few ways of dealing with that, and probably the simplest way of…

Contents