Accounting meets Financial Modeling
Tieing together accounting can get tricky. Get rock solid on the concepts and translate that to best practice financial modeling.
Assemble your knowledge step-by-step
Model Working Capital, Accounting & Tax Depreciation, Corporate Tax and a Profit & Loss Statement and a Balance Sheet, threading them into an existing cashflow model.
DEPRECIATION, TAX & FINANCIAL MODELING
For financial model developers in any field – round out your skillset with the core Accounting Skills
- Understand the timing impact of cashflows through modelling working capital (and get four different methods to do so)
- Understand the role of the P&L and Balance Sheet, and recap accounting concepts
- Model depreciation for accounting and tax flexibly, understanding how to avoid two-way depreciation tables usually required for maintenance capex when modelling Straight-line (or MACRS) depreciation
- Develop tax calculations, starting with an understanding of financial income versus taxable income, incorporating tax losses and accounting & tax depreciation
- Discuss advanced tax concepts, including DTA’s and DTL’s and ungeared tax calculations
- Learn how to balance any balance sheet, any time, in less than five minutes: using the “scalpel method”
- Integrate checks into the model to check known integrity & commercial issues
WATCH, BUILD, OPTIMISE
WATCH THE TRAINING
Spread over six modules, watch three hours of video content
BUILD THE CASE STUDY
Build the model alongside me
Suggested time: 0.5 - 1.0 days to complete the case study model
ENJOY SUCCESS
Whether you're doing Corporate Finance, Project Finance, or start-up modeling, these videos will help you get a firm grip on accounting in financial modeling
Accounting can be confusing. Straighten out your understanding with a practical case study.
Build out the accounting modules in a case study model. Get hands on experience implementing accounting concepts, and learn the functions, tools and shortcuts you expect in best practice financial modeling
WHAT YOU ARE GOING TO GET
-
3 hours of video content
-
31 bite-sized videos that you can come back to time and again
-
.xlsx start model for case study
-
LIFETIME Access to all the training material
Course Modules: Build Your Knowledge Step-By-Step
| Couse Overview | |
| Introduction to the Course | 02:00 |
| Course Aims & Structure | 02:59 |
| MODULE 1: Model Working Capital to Adjust Revenue & Expenses from Accrual to Cash Basis | |
| Introduction to Working Capital | 07:07 |
| Debtors & WC adjustments | 06:03 |
| Creditors & WC adjustments | 05:39 |
| MODULE 2: The Profit & Loss Statement | |
| Introduction to the P&L | 04:43 |
| Modeling the P&L | 07:10 |
| MODULE 3: Modeling Accounting & Tax Depreciation Flexibly Using the OFFSET Method | |
| Introduction & Tax vs Accounting Depreciation | 03:19 |
| Types of Depreciation | 02:59 |
| Challenges of Depreciation & Introduction to the Old School Depreciation Table | 06:23 |
| The Depreciation Setup in The Model | 01:49 |
| Calculating Maintenance Capex | 04:38 |
| Depreciation Inputs: Categories & Useful Life | 02:39 |
| How to Summarise Capex into Additions Categories | 12:23 |
| Creating a Template Account & Depreciation Base | 19:16 |
| Linking Additions & Depreciation and Reviewing Depreciation | 06:08 |
| Replicating the Templates, Updating for Tax Depreciation & Summarising | 11:36 |
| MODULE 4: Geared and Ungeared Tax Calculations | |
| Introduction to Tax | 08:05 |
| Calculating Taxable Income & Modeling the Tax Loss Account | 08:37 |
| Calculating Tax Payable & Tax Paid | 04:16 |
| Ungeared Tax Calculations for Stripping Out the Capital Structure | 03:06 |
| Recap of Tax | 01:03 |
| MODULE 5: The Balance Sheet - Fitting Everything Together Like a Jigsaw Puzzle | |
| Introduction to the Balance Sheet | 07:05 |
| Establishing the Balance Sheet Framework & Linking in Balances | 11:26 |
| Balance Sheet Checks and Correcting Errors Using Timing & Magnitude | 09:39 |
| Using the Scalpel Method to Isolate Errors | 06:08 |
| Correcting Errors to Balance the Balance Sheet | 03:52 |
| MODULE 6: Warnings & Alerts Checks to Improve Model Robustness | |
| Setting up & Creating Alerts | 06:28 |
| Creating Warnings, and Using Rounding & Formatting | 04:59 |
| Setting up the Ribbon for Best Practice Transparency | 05:44 |
| Closing | 01:21 |
"Kyle was fantastic – deep understanding of the overarching principals of modeling and finance, but also great knowledge of the nuts and bolts of it."
Gabriel Davies
Project Finance Professional
SIGN UP TODAY
Get instant access to Depreciation, Tax & Financial Statements and learn Accounting & Financial Modeling like you've never seen it before.
