Features
Premium video tutorials
Award-winning instructors
Personalized learning
Get certified
Learn at your own pace
Mobile (learn on-the-go)
Unlimited tests and quizzes
Regularly updated content
Overview
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.
- 720p
- 540p
- 360p
- 0.50x
- 0.75x
- 1.00x
- 1.25x
- 1.50x
- 1.75x
- 2.00x
Summary
Accreditations and approvals
Instructor
Syllabus
Overview Free Lesson
1
Overview
Quick review on the essential skills and topics brought up in the Financial Modeling Basics course.
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.
2
Income Statement
What is the Income Statement, what does it tell us, and an overview of some of the line items in it.
3
Balance Sheet
What is the Balance Sheet, what does it tell us, and an overview of some of the line items in it.
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.
5
Three Way Integrated Financial Statements
Link the three financial statements together and explain how it flows through.
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.
7
Constructing Basic Financial Model
How to construct the Financial Statements in basic financial modeling.
8
Eating an Elephant
How to construct a basic Financial Model by breaking it down into constituent parts.
9
Importance of Checks
Why are checks in models important and how to add the checks worksheet system.
Timing Sheet
1
Exploring the Model Base
An overview of what is required to build a Financial Model.
2
Creating a Timing Sheet
How to create a timing sheet to be used in building a Financial Model.
3
Creating a Timing Sheet Part B
A continuation of how to create a timing sheet to be used in building a Financial Model.
Adding and Linking the Financial Statements
1
The Income Statement
How to add Financial Statements to the model in particular the Income Statement.
2
Adding Financial Statements
How to build the Financial Statements into the model.
3
Checking Again
Understand the different types of checks required when building a Financial Model and how to add them into the model.
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.
5
Linking the Financial Statements
How are the Financial Statements linked?
6
Linking the Financial Statements Part 2
A continuation on how the Financial Statements are linked.
Revenue Free Lesson
1
Revenue Introduction
Explanation of what revenue is.
2
Modeling Revenue Part 1
How to model revenue.
3
Four Types of Inputs
Define and highlight the differences between the four different input methods.
4
Working Capital Adjustments Part 1
Understand Working Capital.
5
Working Capital Adjustments Part 2
Understand Receivables as a part of Working Capital.
6
Cost of Goods Sold (COGS)
1
COGS
Explanation of how to build COGS into the financial statement.
2
COGS Part 2
A continuation of an explanation of how to build COGS into the financial statement.
3
COGS Part 3 (Inventory)
A continuation of an explanation of how to build COGS into the financial statement.
4
COGS Part 4 (Inventory)
A continuation of an explanation of how to build COGS into the financial statement.
5
COGS Part 5 (Inventory)
A continuation of an explanation of how to build COGS into the financial statement.
6
COGS Part 6 (Inventory)
A continuation of an explanation of how to build COGS into the financial statement.
Operating Expenditure (OPEX)
1
OPEX Part 1
Explanation of what should be considered as OPEX.
2
OPEX Part 2
How to calculate OPEX using the Combination method.
3
OPEX Part 3
How to calculate the OPEX Control Account and input into the Financial Statements.
Capital Expenditure (CAPEX)
1
CAPEX Part 1
Explanation of what should be considered as CAPEX.
2
CAPEX Part 2
How to calculate depreciation.
3
CAPEX Part 3
How to calculate the CAPEX Control Account and input into the Financial Statements.
Debt
1
Debt Part 1
Explanation of Debtors.
2
Debt Part 2
How to calculate the Control Account for Debt and input into the Financial Statements.
3
Debt Part 3
How to calculate the Control Account for Interest Payable and input into the Financial Statements.
4
Interest Received
Understand Interest Received.
5
Interest Received Part 2
How to calculate Interest Receivable.
6
Interest Received Part 3
How to calculate the Control Account for Interest Receivable and input into the Financial Statements.
Tax Free Lesson
1
Tax Part 1
What is Tax?
2
Tax Part 2
Understand the differences between Accounting and Tax treatments.
3
Tax Part 3
What is a DTA and a DTL?
4
5
Tax Part 5
How to calculate Tax Depreciation.
6
Tax Part 6
How to calculate the DTLs.
7
Tax Part 7
How to calculate Tax Payable and Tax Losses.
8
Tax Part 8
How to calculate DTAs.
9
Tax Part 9
How to calculate the Tax Control Account and input into the Financial Statements.
Equity
1
Equity Part 1
Explaining the concept of Equity.
2
Equity Part 2
How to calculate the Equity Control Account and input into the Financial Statements.
3
Equity Part 3
How to calculate the Dividend Payable Control Account and input into the Financial Statements.
Completing the Balance Sheet
1
Completing the Balance Sheet
How to add the final touches to complete the Balance Sheet.
Indirect Cash Flow
1
Indirect Cash Flow
How to calculate Net Operating Cashflow using the Indirect Cashflow method.
2
Indirect Cash Flows Checks
How to add Indirect Cashflow Statement checks.
Summary
1
Summary
A summary of what we covered in the Financial Modeling Techniques course.
