Depreciation Calculations in Excel
Depreciation Calculations are usually a tedious exercise when building models. Here we show advanced Excel techniques to do it right.
Depreciation Caculation is highly respected skills in the business world and hugely sought after in the job marketplace.
Depreciation Calculations course will cover the fundamentals of Excel for modellers, detailed modelling mechanics, an overview of accounting and detailed tutorials on how to build a 3 statement model from scratch
Build and incorporate Operating & Financial Schedules.
Recall the techniques for model auditing tax and deferred tax treatment, depreciation calculations, integrity & error checking and more
Apply best practices in capital structuremodelling; Debt schedules, Cash Flow Sweeps, Equity and dividend calculations
“Depreciation Calculation is a good course,but more of it is needed. This kind of excel essential is advance excel not many people has come to across this kind of training”
“It Was Adequate And Resourceful For My Department They Were Very Basic & Relevant, Really Important For Trouble Shooting And Ease Of Work, More Programming Caculations Should Be Includued If Formulars ”
“Accurate And Adequate For Beginners Adequate And Satisfactory Happy With The Contents Of The Course The Content Adreesed My Puzzles In Excel ”
“Demonstrated Deep Knowledge Of The Subject With Excellent Delivery Skill, Useful And Highly Applicable To Present Job.Worth The Time Spent. Very Good, There Is Need To Ensure Participants Gets A Grasp Of The Subject Matter As It’S A Bit Technical And Needs A Lot Of Time. Best Training In A Long While. ”
Here's what you'll learn...
Overview
FREE PREVIEWHow to use the Platform
FREE PREVIEWJoin Excel & Power BI Free Meetups
FREE PREVIEWJoin our Free Financial Modeling Meetups
FREE PREVIEWDownload the Exercise Files
Introduction to Depreciation Calculations
Before we Begin
Exercise Files
Capex Assumptions in Models
FREE PREVIEWBuild a Capex Schedule
Chapter Quiz
Ask the Trainer
Exercise Files
Build a Depreciation Matrix Schedule
Depreciation using Matrix Formulas - Part 1
Depreciation using Matrix Formulas - Part 2
Chapter Quiz
Ask the Trainer
Exercise Files
Prepare Depreciation Schedule for the OFFSET Method
Understanding the OFFSET Function - Part 1
FREE PREVIEWUnderstanding the OFFSET Function - Part 2
FREE PREVIEWDepreciating using OFFSET Formulas - Part 1
Depreciating using OFFSET Formulas - Part 2
Depreciating using OFFSET Formulas - Part 3
Chapter Quiz
Ask the Trainer
Instructions
Before you go...
How to Attach your Certificates to your LinkedIn Profile
10,000+ people are learning on our platform
“Attempting to tackle the AFM Exam is a bit daunting, which is why this course really shines brightly. Unlike many of the other excellent modeling courses out there, this course specifically focuses on the AFM exam and is a great combination of reviewing modeling skills and fine-tuning your exam preparation. This course is like the capstone to your AFM Exam preparation pyramid. There's nothing quite like it out there yet. It reviews the hard skills, sharpens the soft skills such as template preparation, gives exam tips to save time, advises on how to approach the exam, and brings all the needed skills together in an excellently paced course. Highly recommended. ”
“Excel Essentials for Reporting is a wonderful course. It unearths the secrets on which Excel is built and presents it in a very simple manner. I found a solution to a problem I have grappled with for a long time in this course. DBrown training did a great job that deserve to be commended. Thank you for this course and may your reward be great in your chosen enterprise of expanding the frontiers of knowledge in the IT industry. Regards. Engr. Okumo Ipigansi”
“Your course on Report Automation in Modern Excel is indeed an eye opener as to the many possibilities in Microsoft Excel. The training is superb and very informative with great content. I enjoyed every minute of the videos and it has provided me with a greater level of understanding, additional skills and knowledge, to aid my numerous tasks in the office. Report Automation in Modern Excel is suitable for all who analyze data. The course delivery is excellent. DBrown Consulting, please keep it up.”
“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”
“I was really impressed with the simplicity of the lessons and the ease of learning. Looking forward to taking more courses.”
“I particularly love the flow of teaching, its unconstrained. Also, the fact that you are spurred to practise on your own, and tweak as you are taught - not been spoonfed. I am always waiting for the release of the next class. Thank you David.”