Udemy

Learn Depreciation Accounting with Advanced Excel Model

Enroll Now
  • 7,245 Students
  • Updated 7/2019
  • Certificate Available
4.1
(475 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 2 Minute(s)
Language
English
Taught by
Prashant Panchal, ACA, ExActProBi (Prashant Panchal)
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.1
(475 Ratings)

Course Overview

Learn Depreciation Accounting with Advanced Excel Model

Accounting for Fixed Assets & Depreciation with a Robust Excel Model to derive/forecast/budget depreciation and Assets

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

Course Content

  • 6 section(s)
  • 16 lecture(s)
  • Section 1 Introduction
  • Section 2 What is Depreciation? What is amortization? And related terms
  • Section 3 Various methods of depreciation and Depreciation Accounting
  • Section 4 Depreciation and Taxation
  • Section 5 Master Depreciation Model (how to use)
  • Section 6 Conclusion (Thank you)

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


Reviews

  • Y
    Yeshi Choden
    2.5

    Good

  • T
    Tanmay Rayrikar
    5.0

    good

  • M
    Marianne Herrin
    3.0

    too fast and hard to understand language

  • S
    Sonja Newsome
    3.5

    Yes it's a good match.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed