3.80 (18 reviews)
☑ Students Will Learn the steps they need to know so as to build whatever FINANCIAL MODEL FROM SCRATCH.
☑ Students will learn how financial models are built in top corporations.
☑ You will learn how to build a dynamic 3 statement financial Model, with 4 different scenarios.
☑ You will learn how to build high level Debt amortization Models
☑ You will learn what a facility agreement is and how it is developed in Top corporations.
☑ You will develope the phsycology needed to build a world class financial model.
☑ You will learn how to build the conceptual framwork of financial models with clear examples of a 3 statement financial model and a Loan Amortization Model.
☑ You will learn how to model out the Cash flow statement, the Balance Sheet and The Income statement.
☑ You will learn how to analyze the Income statements, the balance sheet and the cash flow statements of a company.
As a Financier or an individual in the business milieu, Financial Modelling is that skill that will take your career to the next level and enhance your financial analysis potentials.
A financial model should be build by logically intergrating financial concepts into a given business process, with the aim of telling a story of how that business functions in the real world.
A quality financial model is a concise combination of the 3 pillars of financial modelling. Without striking the equilibrium point of these 3 pillars, it will become very difficult to obtain a financial model of good quality. These 3 pillars will include:
Having a perfect understanding of Financial Concepts,
Having an in-depth mastery of the business process,
And Building a logical flow of the financial concepts in step 1 above, into the business processes in step 2 above to give a well-developed conceptual or mathematical financial model, driven by well refined assumptions.
In this Financial Modelling Course, we are going to teach you the all abouts of financial modelling, detailing out the 3 pillars of financial modeling in a comprehensive manner, using world class examples to show you how you should approach and build whatever financial model.
There exist a wide variety of financial models, ranging from the 3 statement financial model, the company valuation model, LBO models, M & A models, to cost Optimization models. However, there is that model which is considered to be the foundation of all models which is the 3 statement financial model. In this course, we are going to teach you how to build a 4 scenario 3 statement financial model from scratch so that you will be equipped with the knowledge and skills needed to build a top-notch financial model by yourself and for your job.
You will learn how to incorporate risks presented by COVID-19 in your financial model.
We shall also teach you haw to build a loan Facility agreement model from which You will be thought on how to link this loan agreement model into the 3 statement model to check the flexibility of the 3 statement dynamic model.
We at your everyday finance always strive to offer the best return on investment from our courses. After detail considerations, we can nod with pride that this course forms one of those courses that will help take your career to the next level, increase your pay check to between 3 and 6X, change your whole perspective about model development and building and will also provide you with that self-satisfactory worth and confidence you need.
FINANCIAL MODELING COURSE OUTLINE
UNDERSTANDING FINANCIAL MODELS
WHAT IS FINANCIAL MODELING?
THE 3 PILLARS OF FINANCIAL MODELING
IMPORTANCE OF FINANCIAL MODELING
IMPORTANT CONCEPTS OF FINANCIAL MODELLING
FOUR IMPORTANT CONCEPTS YOU SHOULD KNOW ABOUT FINANCIAL MODELLING.
STEPS TO BUILD A WORLD CLASS FINANCIAL MODEL.
UNDERSTANDING THE BUSINESS.
ANALYSING MACRO ECONOMIC FACTORS (PESTEL).
ANALYSIS OF INDUSTRY COMPETITION (PORTERS 5 FORCES).
PRACTICAL EXAMPLE OF HOW TO BUILD A FINANCIAL MODEL.
Module 4 Introduction
CONCEPTUAL FRAMEWORK FOR 3 STATEMENT FINANCIAL MODELS.
BALANCE SHEET ANALYSIS
P & L ASSUMPTIONS IN FINANCIAL MODELING. FIRST PART
P AND L ASSUMPTION PART 2
POPULATING THE P & L IN THE FINANCIAL MODELING COURSE.
POPULATING THE BALANCE SHEET FOR THE FINANCIAL MODELING COURSE.
FIXED ASSET ROLL FORWARD
FIXED ASSET ROLL FORWARD PART 2
CASH FLOW FROM OPERATING
CASH FLOW FROM INVESTMENT ACTIVITIES
CASH FLOW FROM FINANCING ACTVITIES
BALANCING THE BALANCE SHEET IN FINANCIAL MODELING.
CONCEPTUAL FRAMEWORK FOR LOAN AGREEMENT.
TRANCHE A LOAN AGREEMENT
TRANCHE B LOAN AGREEMENT
SUMARRY OF TRANCHE A AND B LOAN
MODEL FLEXIBILITY PART 1
LNKING THE INTEREST EXPENSES IN THE FINANCIAL MODELING COURSE
ATTRIBUTES OF A GOOD AND BAD FINANCIAL MODEL.
IMPORTANT ATTRIBUTES OF FINANCIAL MODELS
No practice test were given. Would have been good to share actual excel template/work book used in the video