Welcome back. In this section I will walk you through a depreciation model which I have created in Excel. This model is created from scratch using straight line method. I have struggled a lot in figuring out accurate depreciation and complex scenarios like in month purchases and sale of assets, profit and loss of this kind of purchases, which happens in month. This template is comprehensive and it takes care of most of the practical scenarios which you often come across an accountant or financial analyst. This template use advanced Excel formulas, date formulas, complex nested functions, Excel tables and excel vba.

You don't have to master all these Excel tools as terrible as this template is free for all the students who are enrolled in this course. This template is flexible and comprehensive. This template is quite flexible, you can add more rows for a number of assets you want in the list or block. It has five blocks for example as given in the template. You can create more additional blocks of assets as you want We'll walk you through how to create additional boxes well expandability you can use this template for next many years have used excel vba. To add functionality to add next is model worksheet with a single click.

This template is calculating definition based on data and method. But don't worry, I'll be sharing with you a new tablet with a DB method, web method and DDP method as well in future you will be notified with an email so let's get started.