Financial Modelling

| Created on January 17, 2020 | 2675 views
Specializations
Business /Finance & Accounting
Financial Modelling Click to Preview Course

Discount expires in 3 hours

About Reviews
Course Description

Introduction

This course is a detailed financial modeling master class that will equip participants with practical knowledge and skills in modeling financial statements and building integrated financial models. 

This financial modeling course will teach you how to forecast the future performance of a company using a model built in Excel. You will also learn how to deal with a number of important accounting issues, and be able to explain their effects on the overall results of a company. 

This  financial modelling course follows a hands on practical approach and participants will build models from scratch. You will benefit from the instructor’s years of experience in finance and will learn using real-life examples and real case studies, industry best practices and sensitivity analyses. This course will teach you how to build financial models from scratch and give you an invaluable insight for your career progression.

Key Learning Objectives/ Benefits

  • Understanding of Microsoft Excel used in financial modeling
  • Knowledge and skills in modeling financial statements, financial statement analysis, forecasting the income statements, balance sheet and cash flow statements.
  • Learning how to plan and design a model using the right steps
  • Knowledge of Excel formulas and functions for financial modelling.
  • Knowledge of making financial projections 
Course Outline
Introduction to Financial Modelling 20 min, 16 sec
  • 1.1 What is Financial Modeling? 5 min, 15 sec
  • 1.2 Types of Financial Models 5 min, 37 sec
  • 1.3 Planning & Designing a Model 7 min, 23 sec
  • 1.4 Working Files 2 min
Excel Formula and Functions for Financial Modeling 1 hr, 17 min, 37 sec
  • 2.1 Excel Formula & Functions 22 min, 50 sec
  • 2.2 Shortcuts in Excel and why you need them 4 min, 52 sec
  • 2.3 Excel essentials for Financial Modelling 1 min, 56 sec
  • 2.3.1 Cell Referencing Part 1 5 min, 18 sec
  • 2.3.2 Cell Referencing Part 2 5 min, 35 sec
  • 2.3.3 Cell Referencing Part 3 7 min, 53 sec
  • 2.3.4 Cell Referencing Summary 58 sec
  • 2.3.5 Rules of Financial Modeling 2 min, 13 sec
  • 2.3.6 Rules of Financial Modeling Part 2 2 min, 49 sec
  • 2.3.7 Rules of Financial Modeling Part 3 1 min, 38 sec
  • 2.3.8 Rules of Financial Modeling Part 4 1 min, 14 sec
  • 2.3.9 Rules of Financial Modeling Part 5 5 min, 32 sec
  • 2.3.10 Rules of Financial Modeling Part 6 14 min, 43 sec
Basics of Financial Statement Analysis 33 min, 49 sec
  • 3.1 Income Statements 10 min, 17 sec
  • 3.2 Cash Flow Statements 4 min, 39 sec
  • 3.3 Balance Sheet 18 min, 52 sec
Building an Integrated Financial Model 5 hr, 13 min, 52 sec
  • 4.1 Case Study: Floor Mills of Nigeria Plc 5 min, 10 sec
  • 4.2 Normalising the Historical Financial Statement 28 min, 9 sec
  • 4.3 Making Projections – Income Statement Part 1 14 min, 28 sec
  • 4.3 Making Projections – Income Statement Part 2 18 min, 22 sec
  • 4.4 Making Projections – Cash Flow Statement Part 1 13 min, 54 sec
  • 4.4 Making Projections – Cash Flow Statement Part 2 16 min, 45 sec
  • 4.5 Making Projections – Depreciation and Deferred Tax Schedules Part 1 4 min, 18 sec
  • 4.5 Making Projections – Depreciation and Deferred Tax Schedules Part 2 7 min, 45 sec
  • 4.5 Making Projections – Depreciation and Deferred Tax Schedules Part 3 13 min, 20 sec
  • 4.5 Making Projections – Depreciation and Deferred Tax Schedules Part 4 37 min, 53 sec
  • 4.6 Making Projections – Working Capital Schedule Part 1 20 min, 7 sec
  • 4.6 Making Projections – Working Capital Schedule Part 2 14 min, 26 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 1 4 min, 45 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 2 15 min, 23 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 3 17 min, 22 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 4 18 min, 6 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 5 3 min, 58 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 6 14 min, 55 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 7 16 min, 21 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 8 14 min, 5 sec
  • 4.7 Making Projections – Debt Schedule, Circular Referencing and Finalizing the Model Part 9 14 min, 8 sec
Requirements
  • Undergraduate degree or equivalent Higher Education qualification, or relevant work experience.
  • Basic knowledge of Microsoft excel and Google sheets
  • Basic knowledge of financial terms and accounting
Audience

Who is the course Designed for?

The program is designed to benefit

  • Financial Analysts, Investment Bankers, Equity Research Associates, Business Development Analysts, Asset & Hedge Fund Managers, MBAs, Accounting/Treasury/Corporate
  • Finance Professionals and anyone seeking to improve their financial modeling skill set.
  • Graduates looking to improve their skill in financial modelling
  • Business owners or startup founders who want to understand how financial modelling works.
About Instructor
Mathias Amuta

Amuta is a seasoned professional with 17+ years of experience in the Nigerian business environment specializing in finance, strategy and general management.

His experience spans financial modelling, forecasting, financial planning, entrepreneurial development, and banking, having successfully birthed and handled a number of startup projects and operations at the C-suite level.

He is a member of the Association of Chartered and Certified Accountants (ACCA), a microfinance professional certified by the Chartered Institute of Bankers of Nigeria (CIBN), and a Level II candidate of the CFA Program.

He has served as the lead consultant in the establishment of financial institutions under the purview of the Central Bank of Nigeria. He handled financial advisory services and was the project finance lead in the execution of contract for the supply, delivery, installation of weighbridge at the joint border ports across ECOWAS countries with contract finance from the European Union.

He is the CEO and Lead Consultant of Alucas Consulting, a foremost Finance and Investment consulting firm.

Specialties: Financial Modelling, Business Leadership, Project Management, Financial Management; Strategy Implementation; Business Analysis; Functional Effectiveness.

Frequently Asked Questions
  • What is Financial Modeling?

    Financial modeling is the process of building a financial representation or creating a summary of a company's expenses and earnings in the form of a spreadsheet that is used to predict the financial performance of the company in future or to calculate the impact of a future event or decision. This is a mathematical model designed to represent the performance of a financial asset or portfolio of a business, project, or any other investment.

  • When does the course start and finish?

    It is a self-paced course, meaning you can take it at your own speed and time. You decide when you start and when you finish.

  • What is a financial model in Excel?

    Financial Model is a summary of a company's expenses and earnings presented in Excel. Financial Model in Excel is mathematical model designed using Microsoft Excel to represent the performance of a financial asset or portfolio of a business, project, or any other investment.

Financial Modelling

Discount expires in 3 hours

Share with your friends