NAIL 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.
NAIL FINANCIAL MODELING
Accounting meets
Financial Modeling
Tieing together accounting can get tricky. Get rock solid on the
concepts and translate that to best practice financial modeling.
Thanks so much for your interest in Depreciation, Tax & Financial Statements
- Do you get mixed up in accounting concepts and trying to figure out debits and credits?
- Do you look at the accounting part of a model and view it as “annoying” because it doesn’t affect much?
- Do cashflows make intuitive sense to you, but not so much a P&L and a Balance Sheet?
I created this course to bridge the gap between “accounting theory” that many of us learned at some point in our lives (or maybe not!)... and real world implementation.
This course kicks off from where the Blueprint course ends, but is agnostic to Corporate Finance, Project Finance or Startups… the concepts and implementation are common to all of these areas.
Watch, Build, Optimise
For financial model developer - the 'micro picture' in financial modelling
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.
WHAT TO EXPECT FROM THE TRAINING
Depreciation, Tax
& Financial Statements
Model Working Capital, Accounting & Tax Depreciation, Corporate Tax and a Profit & Loss Statement and a Balance Sheet, threading them into an existing cashflow model.
- Understand the timing impact of cashflows by modeling 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 modeling Straight-line (or MACRS) depreciation
- Develop Corporate Tax calculations, starting with an understanding of financial income versus taxable income, incorporating tax losses and accounting & tax depreciation
- Discuss advanced tax concepts, including DTAs and DTLs and ungeared tax calculations.
- Learn how to Balance Sheet, any time, in less than five minutes: using the "scalpel method"
- Integrate checks into the model to check known integrity & commercial issues.
SIGN UP TODAY
Accounting Can Be Confusing. Straighten Out Your Understanding With A Practical Case Study.
What You Are Going To Get
3 Hours of jammed packed video
31 bite-size videos
The Excel Start and End Model
Private Access to our Mastermind Community
Key Slides PDF Download
12 MONTH Access to All the Training Material
Option to extend for $50 P.A
Detailed Course Breakdown
Build the accounting modules in a case study model
COURSE OVERVIEW
- A Introduction to the Course
- B Course Aims & Structure
3mins
MODULE 4: Geared and Ungeared Tax Calculations
- 4.1 Inttroduction to Tax
8mins
- 4.2 Calculating Taxable Income & Modeling
the Tax Loss Account
8mins
- 4.3 Calculating Tax Payable & Tax Paid
4mins
- 4.4 Ungeared Tax Calculations for
stripping Out the capital Structure
2mins
- 4.5 Recap of Tax
5mins
MODULE 1: Model working Capital to Adjust
Revenue & Expenses from Accrual to Cash Basis
- 1.1 Introductionto Working Capital
7mins
- 1.2 Debtors & WC adjustments
6mins
- 1.3 Creditors & WC adjustments
5mins
MODULE 5: The Balance Sheet - Fitting
Everything Together Like a Jigsaw Puzzle
- 5.1 Introduction to the Balance Sheet
7mins
- 5.2 Establishing the Balance sheet
Framework & Linking in Balances
11mins
- 5.3 Balance Sheet Checks and Correcting
Errors Using Timing & Magnitude
9mins
- 5.4 Using the Scalpel Method
to Isolated Errors
6mins
- 5.5 Correction Errors to Balance
the Balance Sheet
4mins
MODULE 2: The Profit & Loss Statement
- 2.1 Introduction to the P&L
4mins
- 2.2 Modeling the P&L
7mins
MODULE 6: Warnings & Alerts Checks to Improve Model Robustness
- 6.1 Setting up & Creating Alerts
6mins
- 6.2 Creating Warnings, and Using
Rounding & Formatting
4mins
- 6.3 Setting up the Ribbon for Best
Practice Transparency
5mins
MODULE 3: Modeling Accounting & Tax
Depreciation Flexibly Using the OFFSET Method
- 3.1 Inroduction & Tax vs Accounting
Depreciation
3mins
- 3.2 Type of Depreciation
3mins
- 3.3 Challenges of Depreciation & Introduction
to the Old School Depreciation Table
6mins
- 3.4 The Depreciation Setup in The Model
1mins
- 3.5 Calculating Maintenance Capex
4mins
- 3.6 Depreciation Inputs: Categories &
Useful Life
2mins
- 3.7 How to Summarise Capex into
Additions Categories
12mins
- 3.8 Creating a Template Account &
Depreciation Base
18mins
- 3.9 Linking Additions & Depreciation
and Reviewing Depreciation
6mins
- 3.10 Replicating the Templates,
Updating for Tax Dpreciation & Summarising
11mins
CLOSING
- 7 Conclusion
1mins
Detailed Course Brekdown
Build up a best practice cashflow model with a case study of a Greenfieled Wind Farm
COURSE OVERVIEW
- 1A Introduction to the Course
- 1B Course Aims & Structure
3mins
MODULE 1: Model working Capital to Adjust
Revenue & Expenses from Accrual to Cash Basis
- 1.1 Introductionto Working Capital
7mins
- 1.2 Debtors & WC adjustments
6mins
- 1.3 Creditors & WC adjustments
5mins
MODULE 2: The profit & Loss Statement
- 3A Inroduction to the P&L
15mins
- 3B Modeling the P&L
15mins
MODULE 3: Modeling Accounting & Tax
Depreciation Flexibly Using the OFFSET Method
- 4A Inroduction & Tax vs Accounting
Depreciation
3mins
- 4B Type of Depreciation
3mins
- 4C Challenges of Depreciation & Introduction
to the Old School Depreciation Table
6mins
- 4D The Depreciation stepup in The Model
1mins
- 4E Calculating Maintenance Capex
4mins
- 4F Depreciation Inputs: Categories &
Useful Lie
2mins
- 4G How to Summarise Capex into
Additions Categories
12mins
- 4H Creating a Template Account &
Depreciation Base
18mins
- 4J Linking Additions & Depreciation
and Reviewing Depreciation
6mins
- 4K Replicating the Templates,
Updating for Tax Dpreciation & Summarising
11mins
MODULE 4: Geared and Ungeared Tax Calculations
- 5A Inttroduction to Tax
8mins
- 5B Calculating Taxable Income & Modeling
the Tax Loss Account
8mins
- 5C Calculating Tax Payable & Tax Paid
4mins
- 5D Ungeared Tax Calculations for
stripping Out the capital Structure
2mins
- 5ERecap of Tax
5mins
MODULE 5: The Balance Sheet - fitting
Everything Together Like a Jigsaw Puzzle
- 6A Introduction to the Balance Sheet
7mins
- 6B Establishing the Balance sheet
Framework & Linking in Balances
11mins
- 6C Balance Sheet Checks and Correcting
Errors Using Timing & Magnitude
9mins
- 6D Using the Scalpe Method to Isolated Errors
6mins
- 6E Correction Errors to Balance the Balcnce Sheet
4mins
MODULE 6: Warnings EAlerts Checks to Improve Model Robustnes
- 7A Setting up & Creating alerts
6mins
- 7B Creating Warnings, and Using
Rounding & Formatting
4mins
- 7C Setting up the Ribbon for Best
Practice Transparency
15mins
CLOSING
- 8. Conclusion
1mins
WORDS FROM MY CLIENTS
“As a past M&A advisor and latterly a direct investor (via corporate and project finance), I can safely say that Kyle has been the best trainer I’ve ever seen. He’s been able to take my team, some with little knowledge of financial modelling, to a highly competent level in a short period of time."
Jason Frank, Group Director of Data Analytics, European Tyre Enterprise Ltd
WORDS FROM MY CLIENTS
“Kyle was an excellent trainer – very focused
on developing our skills and making sure we understood each aspect of the course."
Alexander G., STUDENT
WORDS FROM MY CLIENTS
“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, Head of Energy Access, CrossBoundary
WORDS FROM MY CLIENTS
“Kyle had a wealth of knowledge and was able to answer any questions that were asked."
Sarah D., STUDENT
PS - if you’re on the fence.
May I make a suggestion?
Don’t make a decision now. Put the training to the test and try it for 30 days. Go through the fully built model and have a play with it. Explore the step-by-step trainings which show you EXACTLY what to do.
Feel what it feels like to have a three way-statement model at your fingertips
See what it looks like to balance a balance sheet almost effortlessly.
Get used to crystal clear explanations.
If after 30 days it isn’t everything I’ve promised and more, let me know and I’ll refund every penny.
