I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth.
Excel Financial Modeling Course | Online Training
Financial Modeling Techniques
Apply techniques to model scenarios, build forecasts and support financial decisions.
- 4.8 48 reviews
- 29h 30m study time
- 5h 45m video
- Get an accredited certificate
- 14-day money-back guarantee
About this course
Financial modeling in Excel is extremely useful to forecast and make key business decisions for your company. Learn this career-boosting skill in this Excel financial modeling course online, through proven methodologies and tools to help you construct a financial model step by step. The training covers financial statement theory and how they link together, building on the best practices and Excel functions covered in the Financial Modeling Basics course. Examples are provided throughout so that you can apply the practical knowledge you learn through hands-on application in Excel.
Highlights:
- 59 practical tutorials.
- Understand the different financial statement types and their key line items.
- Link the three financial statements together and add them to the model.
- Recognize the importance control accounts play in balancing the model.
- How to add the checks worksheet system to keep your model error-free.
- How to model revenue and working capital adjustments.
- Highlight the differences between the four different input methods.
- How to input COGS, OPEX and CAPEX into the financial statement.
- Calculate the control account for debt and interest payable.
- How to calculate tax components including tax expense, depreciation and losses.
- How to calculate Net Operating Cashflow using the Indirect Cashflow method.
Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how a GoSkills Excel certification can boost your career.
If you are a beginner and want to start with the basic concepts and functions of preparing a financial model, then check out the Financial Modeling Basics course first.
Want to be a more efficient Excel user? Start learning 200 of the best Excel shortcuts for PC and Mac.
Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.
Syllabus
14 sections · 59 lessons · 5h 45m total
Financial Statement Theory
- 1. Financial Statement Types What are the Financial Statement Types, what do they tell us, and an overview of some of the line items in them. 5m View lesson
- 2. Income Statement What is the Income Statement, what does it tell us, and an overview of some of the line items in it. 5m View lesson
- 3. Balance Sheet What is the Balance Sheet, what does it tell us, and an overview of some of the line items in it. 5m View lesson
- 4. Cash Flow Statement What is the Cash Flow Statement, what does it tell us, and an overview of some of the line items in it. 7m View lesson
- 5. Three Way Integrated Financial Statements Link the three financial statements together and explain how it flows through. 3m View lesson
- 6. Control Accounts Explain the importance control accounts play in balancing the model when used effectively. When to create control accounts, how to create them and where to link their line items. 6m View lesson
- 7. Constructing Basic Financial Model How to construct the Financial Statements in basic financial modeling. 3m View lesson
- 8. Eating an Elephant How to construct a basic Financial Model by breaking it down into constituent parts. 8m View lesson
- 9. Importance of Checks Why are checks in models important and how to add the checks worksheet system. 3m View lesson
Timing Sheet
- 1. Exploring the Model Base An overview of what is required to build a Financial Model. 6m View lesson
- 2. Creating a Timing Sheet How to create a timing sheet to be used in building a Financial Model. 6m View lesson
- 3. Creating a Timing Sheet Part B A continuation of how to create a timing sheet to be used in building a Financial Model. 6m View lesson
Adding and Linking the Financial Statements
- 1. The Income Statement How to add Financial Statements to the model in particular the Income Statement. 8m View lesson
- 2. Adding Financial Statements How to build the Financial Statements into the model. 5m View lesson
- 3. Checking Again Understand the different types of checks required when building a Financial Model and how to add them into the model. 7m View lesson
- 4. Checking Again Part 2 A continuation of understanding the different types of checks required when building a Financial Model and how to add them into the model. 5m View lesson
- 5. Linking the Financial Statements How are the Financial Statements linked? 8m View lesson
- 6. Linking the Financial Statements Part 2 A continuation on how the Financial Statements are linked. 4m View lesson
Revenue
- 1. Revenue Introduction Explanation of what revenue is. 4m View lesson
- 2. Modeling Revenue Part 1 How to model revenue. 6m View lesson
- 3. Four Types of Inputs Define and highlight the differences between the four different input methods. 5m View lesson
- 4. Working Capital Adjustments Part 1 Understand Working Capital. 6m View lesson
- 5. Working Capital Adjustments Part 2 Understand Receivables as a part of Working Capital. 5m View lesson
- 6. Revenue Part 2 - Control Accounts Understanding Revenue with the use of Control Accounts. 5m View lesson
Cost of Goods Sold (COGS)
- 1. COGS Explanation of how to build COGS into the financial statement. 6m View lesson
- 2. COGS Part 2 A continuation of an explanation of how to build COGS into the financial statement. 3m View lesson
- 3. COGS Part 3 (Inventory) A continuation of an explanation of how to build COGS into the financial statement. 7m View lesson
- 4. COGS Part 4 (Inventory) A continuation of an explanation of how to build COGS into the financial statement. 6m View lesson
- 5. COGS Part 5 (Inventory) A continuation of an explanation of how to build COGS into the financial statement. 5m View lesson
- 6. COGS Part 6 (Inventory) A continuation of an explanation of how to build COGS into the financial statement. 5m View lesson
Operating Expenditure (OPEX)
- 1. OPEX Part 1 Explanation of what should be considered as OPEX. 7m View lesson
- 2. OPEX Part 2 How to calculate OPEX using the Combination method. 5m View lesson
- 3. OPEX Part 3 How to calculate the OPEX Control Account and input into the Financial Statements. 6m View lesson
Capital Expenditure (CAPEX)
- 1. CAPEX Part 1 Explanation of what should be considered as CAPEX. 5m View lesson
- 2. CAPEX Part 2 How to calculate depreciation. 6m View lesson
- 3. CAPEX Part 3 How to calculate the CAPEX Control Account and input into the Financial Statements. 3m View lesson
Debt
- 1. Debt Part 1 Explanation of Debtors. 5m View lesson
- 2. Debt Part 2 How to calculate the Control Account for Debt and input into the Financial Statements. 5m View lesson
- 3. Debt Part 3 How to calculate the Control Account for Interest Payable and input into the Financial Statements. 5m View lesson
- 4. Interest Received Understand Interest Received. 4m View lesson
- 5. Interest Received Part 2 How to calculate Interest Receivable. 5m View lesson
- 6. Interest Received Part 3 How to calculate the Control Account for Interest Receivable and input into the Financial Statements. 3m View lesson
Tax
- 1. Tax Part 1 What is Tax? 5m View lesson
- 2. Tax Part 2 Understand the differences between Accounting and Tax treatments. 6m View lesson
- 3. Tax Part 3 What is a DTA and a DTL? 5m View lesson
- 4. Tax Part 4 How to calculate Tax Expense. 3m View lesson
- 5. Tax Part 5 How to calculate Tax Depreciation. 8m View lesson
- 6. Tax Part 6 How to calculate the DTLs. 5m View lesson
- 7. Tax Part 7 How to calculate Tax Payable and Tax Losses. 7m View lesson
- 8. Tax Part 8 How to calculate DTAs. 6m View lesson
- 9. Tax Part 9 How to calculate the Tax Control Account and input into the Financial Statements. 5m View lesson
Equity
- 1. Equity Part 1 Explaining the concept of Equity. 7m View lesson
- 2. Equity Part 2 How to calculate the Equity Control Account and input into the Financial Statements. 4m View lesson
- 3. Equity Part 3 How to calculate the Dividend Payable Control Account and input into the Financial Statements. 6m View lesson
Completing the Balance Sheet
- 1. Completing the Balance Sheet How to add the final touches to complete the Balance Sheet. 5m View lesson
Indirect Cash Flow
- 1. Indirect Cash Flow How to calculate Net Operating Cashflow using the Indirect Cashflow method. 7m View lesson
- 2. Indirect Cash Flows Checks How to add Indirect Cashflow Statement checks. 6m View lesson
Summary
- 1. Summary A summary of what we covered in the Financial Modeling Techniques course. 3m View lesson
Time to humblebrag
Complete the course and pass the final test to get a verifiable CPD-accredited certificate
Share on LinkedIn
Add your certificate to your profile in one click, and let recruiters and managers see your new skills.
- CPD accredited
- Verifiable online
Taught by Liam Bastick
Liam is a Fellow of the Institute of Chartered Accountants (ICAEW), a Fellow of the Institute of Chartered Management Accountants (CIMA), a Chartered Global Management Accountant (CGMA) and is also a professional mathematician.
Liam has over 30 years’ experience in financial model development and auditing, valuations, M&A, strategy, training and consultancy. He has considerable experience in many different sectors including banking, energy, media, mining, oil and gas, private equity, transport and utilities. He has worked with many internationally recognised clients, constructing and reviewing strategic, operational and valuation models for many high profile IPOs, LBOs and strategic assignments. This has taken him to many countries including Australia, Belgium, Denmark, France, Germany, Hong Kong, Indonesia, Malaysia, Netherlands, New Zealand, Switzerland, the United Kingdom, the United States and Vietnam.
The reviews are in
See what other learners think of our courses
-
“I learned a lot! Recommend to everyone ”
-
“Awesome course and the lecturer Liam was most amusing! ”
-
“Great course, great presenter, despite the jokes, very knowledgeable on the subject.”
Your questions, answered
Frequently asked questions
We’ve compiled the most important information to help you get the most out of your experience. Can’t find what you’re looking for? Contact us.
How do I track my progress?
Your dashboard shows which lessons you’ve completed and how far you are through each course, so you always know where to pick up next.
Can I use GoSkills for team training?
Yep! With a business account, you can access the full course library along with the GoSkills LMS where you can assign courses, track team progress and report on results from one dashboard. Learn more about GoSkills for teams here.
What if I need help?
Our support team is available at support@goskills.com for questions about your account or the platform. Reach out anytime!