Financial Modeling Techniques

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.

How to model revenue.

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

Understand Working Capital.

Understand Receivables as a part of Working Capital.

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.

Explanation of Debtors.

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.

What is Tax?

Understand the differences between Accounting and Tax treatments.

What is a DTA and a DTL?

How to calculate Tax Depreciation.

How to calculate the DTLs.

How to calculate Tax Payable and Tax Losses.

How to calculate DTAs.

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.