Learn Depreciation Accounting with Advanced Excel Model
4.5 (92 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,524 students enrolled

Learn Depreciation Accounting with Advanced Excel Model

Accounting for Fixed Assets & Depreciation with a Robust Excel Model to derive/forecast/budget depreciation and Assets
4.5 (92 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,524 students enrolled
Last updated 7/2019
English
English
Current price: $41.99 Original price: $59.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • 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)
Description

****** 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! 

Who this course is for:
  • 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)
Course content
Expand all 16 lectures 01:02:34
+ Introduction
3 lectures 06:30

Introduction to the course and Instructor intro 

Preview 03:18

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


Download master depreciation template
02:11
+ What is Depreciation? What is amortization? And related terms
3 lectures 05:31

Definition of depreciation with sweet example :) 

Preview 01:40

What are the key differences between terms depreciation and amortization? (definition of amortization)

Preview 02:03

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) 

Preview 01:48
+ Various methods of depreciation and Depreciation Accounting
2 lectures 13:20

In this lecture I will discuss various methods of depreciation (most common ones). 

Most common methods of Depreciation
08:46

Journal entries and book keeping for depreciation (monthly and yearly), accounting (JE) in case of sale of an asset with profit or loss.

Accounting for Depreciation
04:34
+ Depreciation and Taxation
2 lectures 07:21

How depreciation is crucial while filing your annual tax returns, what is tax shield? Explained in detail with example 

Depreciation Tax Shield
04:12

How different depreciation methods affect taxable Income. 

Depreciation Tax Shield Under Various Depreciation Methods
03:09
+ Master Depreciation Model (how to use)
4 lectures 29:08

I will explain you what is depreciation model is all about in depth. What each column does and how it is structured

Deep Dive into Depreciation Model
07:07

Lets see how model works with practical examples!! 

How to use the model with Example
10:02

What are the advance features of the this model? for eg : adding next year sheet, adding and deleting rows within each block (table), how to add more assets block 

Advanced functionalities of the Model
10:33
+ Conclusion (Thank you)
2 lectures 00:44

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 !

Thank you for enrolling !
00:33
Bonus Lecture (Special Discount to My Other Courses)
00:11