Learn Depreciation Accounting with Advanced Excel Model
- 1 hour on-demand video
- 2 articles
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business- Hands on knowledge on how depreciation and fixed assets accounting works
- Fixed assets and depreciation forecasting in Business budgeting
- The impact of the sale of assets prematurely on your profit and loss for the period
- Basic to Intermediate knowledge of Microsoft Excel
- Basic to Intermediate knowledge of Accounting (Practical Accounting)
- Accounting terms for Fixed Assets and Depreciation (briefly explained in introduction section of this course)
****** Major Update to this Course is coming soon, I will completely revamp the course with additional PRO Excel Templates for other methods of Depreciation: DB (WDV), VDB (DDB), SYD Methods *********
Depreciation Accounting for Fixed assets is usual activity and process for any accountant in his/her job, but things can get really tricky and difficult when there are numbers of assets and there are transactions like disposal, sale and purchase in mid-month/mid-year.
This course is designed to help you understand the concept of depreciation through practical situations and examples
It is very important to have a robust Fixed assets and depreciation model in place which calculates accurate depreciation monthly, helps you in budgeting and forecasting depreciation costs for next year (years to come). Also when there are assets sale/disposal you need to figure out exact profit or loss on such sale/disposal (especially when it takes place on old days in the month/year)
I will guide you through practical accounting issues and situations while accounting for depreciation, forecasting depreciation costs, the impact of the sale of an assets (profit and loss) on your profit and loss statement and Balance sheet
Depreciation model which I have prepared for the course is quite robust and takes care of any practical scenario in dealing with situations
At end of his course, you will have hands-on experience in dealing with any challenging depreciation and fixed assets accounting situation and its financial impact (which your manager would want to know accurately). You will also receipt free copy of the template used in the course !! So let's dive into it!
- Accountants who want to sharpen their practical accounting Knowledge for Fixed Assets and depreciation Accounting
- Auditors who want to audit effectively for Fixed assets and depreciation for their clients
- Non-Accounting professional/Entrepreneurs who wants to estimate impact of depreciation on their investment and Profit and Loss over fixed term (usually assets useful life)
Introduction to the course and Instructor intro
You can download master depreciation model (Excel) with unprotection password here. Please note that VBA module password is also same.
You will have to unprotect sheets if you want to add new block/table of asset or delete block/table of assets in the model
Also for giving names to each block you will need unprotection
I highly recommend you protect entire sheet back once you are happy with modification before passing on to your colleague for use...
Attention: whenever you add new year sheet or add new rows (or use any of the three buttons), all sheets in the workbook will be again locked with same password....
Before using this model make sure to change your macro trust settings : Go to File >>> Options >>> Excel Options dialogue box will open >>>> Trust center >>> Trust center settings >>> Macro settings >>> Choose " Disable all macros with notification" and Click OK to exist !!
=====================================================================================================
I have found some critical errors with Deprecation Template provided with the course as resources.
Issue found: Once you have completed first-year tab/sheet of the template and you carry forward the same to next year (for example, you have started using the model from FY 2016, and you have completed fixed assets data entry for each of your block of assets). And now you are ready to carry forward the sheet to FY 2017; in 2017 you might have assets additions in 2017 for which you will have to add new rows in any of the blocks to make some room.
With the existing template, once you have added new rows in any of the blocks after carrying forward to next year (which is FY 2017). You will have errors in opening balances of Gross Block value, Accumulated depreciation values. These columns are Column L and Column AC
The reason for the same is the custom VBA function called Prevsheet data is still pulling from same previous sheet data row/cell (FY 2016) which has now changed after you have added new rows (for new assets addition in FY 2017) in any of the blocks. I am sure it is not easy to understand what I am trying to say, but I have fixed the issue nonetheless.
With version 2 - I have kept five blocks of fixed assets, each block has 1000 rows which should be enough for any small to medium sized depreciation and fixed assets data analysis or audit of small or medium-sized entities.
The idea is that you CANNOT enter more rows once you have to carry forwarded the sheet from the first year to next year.
Before you start using the template for your work or analysis of any kind, you MUST ensure that you keep enough amount of rows in each block of assets, which would ensure that you won't have to add more rows once the starting sheet (first-year sheet) is carry forwarded.
So FY 2016 Sheet should have enough amount of rows in each block and enough amount of blocks so that once you move forward FY 2016 sheet to FY 2017, you won't have to add new rows in any of the blocks.
You are free to add more blocks of assets in the first sheet (start sheet) and as many rows as possible.
If you still have doubts or question, please do not hesitate to reply to this message and I will be happy to help you.
Cheers!
Prashant
Definition of depreciation with sweet example :)
What are the key differences between terms depreciation and amortization? (definition of amortization)
Other terms related to term depreciation and these terms are quite important to know because they are crucial to depreciation accounting (covered in next section of the course)
Thank you so much for investing your valuation time in my course, I am sure you have learn something new (even if you are veteran finance/accounting professional), as I have mentioned in the course, I will be adding two more Models/templates with DB/WDV and DDB method in future!
Cheers and I will see you in my next course !