Financial Modeling Techniques

(1 review)


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 online course, 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.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.


Summary

Skill level

Intermediate

Certificate

Yes

Lessons

59

Accredited by

CPD

Pre-requisites

None

Versions supported

TBD


Accreditations and approvals

CPD - The CPD Certification Service.


Syllabus

Overview

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

Try it!

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.


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.

Try it!

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.

Try it!


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.