You are previewing this course

Each course is broken down into short video tutorials taught by award-winning instructors. To access the entire course:

Login Redeem a voucher View pricing

Financial Modeling Techniques



Lessons

Quick review on the essential skills and topics brought up in the Financial Modeling Basics course.

What are the Financial Statement Types, what do they tell us, and an overview of some of the line items in them.

What is the Income Statement, what does it tell us, and an overview of some of the line items in it.

What is the Balance Sheet, what does it tell us, and an overview of some of the line items in it.

What is the Cash Flow Statement, what does it tell us, and an overview of some of the line items in it.

Link the three financial statements together and explain how it flows through.

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.

How to construct the Financial Statements in basic financial modeling.

How to construct a basic Financial Model by breaking it down into constituent parts.

Why are checks in models important and how to add the checks worksheet system.

An overview of what is required to build a Financial Model.

How to create a timing sheet to be used in building a Financial Model.

A continuation of how to create a timing sheet to be used in building a Financial Model.

How to add Financial Statements to the model in particular the Income Statement.

How to build the Financial Statements into the model.

Understand the different types of checks required when building a Financial Model and how to add them into the model.

A continuation of understanding the different types of checks required when building a Financial Model and how to add them into the model.

How are the Financial Statements linked?

A continuation on how the Financial Statements are linked.

Explanation of what revenue is.

Define and highlight the differences between the four different input methods.

Understand Working Capital.

Understand Receivables as a part of Working Capital.

Understanding Revenue with the use of Control Accounts.

Explanation of how to build COGS into the financial statement.

A continuation of an explanation of how to build COGS into the financial statement.

A continuation of an explanation of how to build COGS into the financial statement.

A continuation of an explanation of how to build COGS into the financial statement.

A continuation of an explanation of how to build COGS into the financial statement.

A continuation of an explanation of how to build COGS into the financial statement.

Explanation of what should be considered as OPEX.

How to calculate OPEX using the Combination method.

How to calculate the OPEX Control Account and input into the Financial Statements.

Explanation of what should be considered as CAPEX.

How to calculate depreciation.

How to calculate the CAPEX Control Account and input into the Financial Statements.

How to calculate the Control Account for Debt and input into the Financial Statements.

How to calculate the Control Account for Interest Payable and input into the Financial Statements.

Understand Interest Received.

How to calculate Interest Receivable.

How to calculate the Control Account for Interest Receivable and input into the Financial Statements.

Understand the differences between Accounting and Tax treatments.

How to calculate Tax Expense.

How to calculate Tax Depreciation.

How to calculate Tax Payable and Tax Losses.

How to calculate the Tax Control Account and input into the Financial Statements.

Explaining the concept of Equity.

How to calculate the Equity Control Account and input into the Financial Statements.

How to calculate the Dividend Payable Control Account and input into the Financial Statements.

How to add the final touches to complete the Balance Sheet.

How to calculate Net Operating Cashflow using the Indirect Cashflow method.

How to add Indirect Cashflow Statement checks.

A summary of what we covered in the Financial Modeling Techniques course.

Sorry, it looks like there are no lessons that match your filter.