Accounting For Depreciation with Microsoft Excel
3.8 (58 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,907 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Accounting For Depreciation with Microsoft Excel to your Wishlist.

Add to Wishlist

Accounting For Depreciation with Microsoft Excel

Accounting for Depreciation with a Robust Excel Model to derive/forecast/budget depreciation
3.8 (58 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,907 students enrolled
Created by Prashant Panchal
Last updated 8/2017
Price: Free
  • 1 hour on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • 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)

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, impact of 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 is the target audience?
  • 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)
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
3 Lectures 04:59

Introduction to the course and Instructor intro 


Minimum requirements before taking the course

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

Download master depreciation template
What is Depreciation? What is amortization? And related terms
3 Lectures 05:31

Definition of depreciation with sweet example :) 

Definition of Depreciation

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

What is amortization? (Depreciation vs 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) 

What are the related terms (other terms) to Depreciation?
Various mathods 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

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

How different depreciation methods affect taxable Income. 

Depreciation Tax Shield Under Various Depreciation Methods
Master Depreciation Model (how to use)
4 Lectures 29:08
Introduction and basics of Depreciation Model in Excel

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

Lets see how model works with practical examples!! 

How to use the model with Example

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
Conclusion (Thank you)
2 Lectures 00:41

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 !

Bonus Lecture (Special Discount to My Other Courses)
About the Instructor
Prashant Panchal
3.8 Average rating
58 Reviews
3,219 Students
2 Courses
Finance Professional (ACA, B.Com)

I am a seasoned Finance Professional (Chartered Accountant) with more than a decade of experience in the field of Finance, Accounting, Auditing and Operations having worked with many (diversified) industries throughout my career

I have hands-on and thorough practical knowledge and experience in routine accounting challenges that every accountant comes across (gained through tons of trials and errors with practical accounting issues faced and solved during my career)

Being an Excel enthusiast, I love report automation while keeping accuracy and reliability of any accounting or management report at 100%. I have automated and enhanced daily accounting reporting tasks and improved reporting styles which have saved tons of hours of work for my colleagues and organisations

I have substantial experience gained throughout my career to improve and automate reports using Microsoft Excel:  
  ♦ Advanced Formulas and Functions
  ♦ VBA
  ♦ Pivot tables
  ♦ Power Query
  ♦ Power Pivots
  ♦ What if analysis tools (Solver, Goal Seek, Data Tables and scenario manager)