Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how Financial Modeling Techniques 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.
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.
Once enrolled, our friendly support team is here to help with any course-related inquiries.
Summary
- Skill level: Intermediate
- Lessons: 59
- Pre-requisites: None
- Estimated study time: 29h 30m for all materials
- Certificate: Yes
- Accredited by: CPD
- Video duration: 5h 45m
Features
Premium video tutorials
Personalized Learning
Learn at your own pace
Tests and Quizzes
Award winning instructors
Get Certified
Mobile - Learn on the go
Regularly updated content
Accreditations & Approvals
All courses under each learning path are accredited and approved by one or more of the following bodies as is applicable.
Instructors
All courses are taught by reputed trainers with relevant accreditations and industry experience.
Modules
Overview
Quick review on the essential skills and topics brought up in the Financial Modeling Basics course.
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.
Income Statement
What is the Income Statement, what does it tell us, and an overview of some of the line items in it.
Balance Sheet
What is the Balance Sheet, what does it tell us, and an overview of some of the line items in it.
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.
Three Way Integrated Financial Statements
Link the three financial statements together and explain how it flows through.
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.
Constructing Basic Financial Model
How to construct the Financial Statements in basic financial modeling.
Eating an Elephant
How to construct a basic Financial Model by breaking it down into constituent parts.
Importance of Checks
Why are checks in models important and how to add the checks worksheet system.
Exploring the Model Base
An overview of what is required to build a Financial Model.
Creating a Timing Sheet
How to create a timing sheet to be used in building a Financial Model.
Creating a Timing Sheet Part B
A continuation of how to create a timing sheet to be used in building a Financial Model.
The Income Statement
How to add Financial Statements to the model in particular the Income Statement.
Adding Financial Statements
How to build the Financial Statements into the model.
Checking Again
Understand the different types of checks required when building a Financial Model and how to add them into the model.
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.
Linking the Financial Statements
How are the Financial Statements linked?
Linking the Financial Statements Part 2
A continuation on how the Financial Statements are linked.
Revenue Introduction
Explanation of what revenue is.
2
Modeling Revenue Part 1
How to model revenue.
Four Types of Inputs
Define and highlight the differences between the four different input methods.
Working Capital Adjustments Part 1
Understand Working Capital.
Working Capital Adjustments Part 2
Understand Receivables as a part of Working Capital.
Revenue Part 2 – Control Accounts
Understanding Revenue with the use of Control Accounts.
COGS
Explanation of how to build COGS into the financial statement.
COGS Part 2
A continuation of an explanation of how to build COGS into the financial statement.
COGS Part 3 (Inventory)
A continuation of an explanation of how to build COGS into the financial statement.
COGS Part 4 (Inventory)
A continuation of an explanation of how to build COGS into the financial statement.
COGS Part 5 (Inventory)
A continuation of an explanation of how to build COGS into the financial statement.
COGS Part 6 (Inventory)
A continuation of an explanation of how to build COGS into the financial statement.
OPEX Part 1
Explanation of what should be considered as OPEX.
OPEX Part 2
How to calculate OPEX using the Combination method.
OPEX Part 3
How to calculate the OPEX Control Account and input into the Financial Statements.
CAPEX Part 1
Explanation of what should be considered as CAPEX.
CAPEX Part 2
How to calculate depreciation.
CAPEX Part 3
How to calculate the CAPEX Control Account and input into the Financial Statements.
Debt Part 1
Explanation of Debtors.
Debt Part 2
How to calculate the Control Account for Debt and input into the Financial Statements.
Debt Part 3
How to calculate the Control Account for Interest Payable and input into the Financial Statements.
Interest Received
Understand Interest Received.
Interest Received Part 2
How to calculate Interest Receivable.
Interest Received Part 3
How to calculate the Control Account for Interest Receivable and input into the Financial Statements.
Tax Part 1
What is Tax?
Tax Part 2
Understand the differences between Accounting and Tax treatments.
Tax Part 3
What is a DTA and a DTL?
Tax Part 4
How to calculate Tax Expense.
Tax Part 5
How to calculate Tax Depreciation.
Tax Part 6
How to calculate the DTLs.
Tax Part 7
How to calculate Tax Payable and Tax Losses.
Tax Part 8
How to calculate DTAs.
Tax Part 9
How to calculate the Tax Control Account and input into the Financial Statements.
Equity Part 1
Explaining the concept of Equity.
Equity Part 2
How to calculate the Equity Control Account and input into the Financial Statements.
Equity Part 3
How to calculate the Dividend Payable Control Account and input into the Financial Statements.
Completing the Balance Sheet
How to add the final touches to complete the Balance Sheet.
Indirect Cash Flow
How to calculate Net Operating Cashflow using the Indirect Cashflow method.
Indirect Cash Flows Checks
How to add Indirect Cashflow Statement checks.
Summary
A summary of what we covered in the Financial Modeling Techniques course.
Target Audience
- Graduates exploring placement in the entry-level Financial positions across industries
- Finance professionals needing upskilling to be future-ready or become more productive in their current roles
- Experienced individuals exploring Financial Modeling Techniques roles to join the workforce
How do I Access The Program
- Buy the course online
- Save your payment transaction receipt for any future reference
- Our team will share the credentials to enable you access your course online within 2 business days of payment transfer
Bulk Orders
Incase you are looking for bulk user licenses, or customized Learning Paths for various Job Roles, reach out to us with your detailed requirements.
Reviews
There are no reviews yet.