Financial Modeling for Business Analysts and Consultants
4.1 (77 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,207 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial Modeling for Business Analysts and Consultants to your Wishlist.

Add to Wishlist

Financial Modeling for Business Analysts and Consultants

Learn Financial Modeling in Excel that will allow you to participate in due diligence, strategy or turn around projects
4.1 (77 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,207 students enrolled
Created by Asen Gyczew
Last updated 8/2017
English
Current price: $10 Original price: $45 Discount: 78% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Article
  • 64 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You will master financial modeling in Excel at the needed for business analysts and consultants level
  • Understand the main challenges in financial modelling
  • Perform the analyses of financial models
  • You will get ready models that you can utilize for your purposes
  • Model your business in Excel
  • Estimate the value of your business
View Curriculum
Requirements
  • Basic Excel
  • Basic knowledge of economics or finance
Description

What is the aim of this course?

As a business analysts or a consultant you will have to from time to time create financial models. There are a bit different than business models. In business models you go into details of operations and you focus on getting the links on the KPIs. Those models are usually done for internal purposes, to manage in the right direction the business. Financial models on the other hand are more for external users. You concentrate in them on creating the picture of the business in a standardized, understood by everybody way. You also want to create the financial statements: profit & loss statement, balance sheet statement, cash flow statement.

On top of that you use the financial statements for valuation purposes.

The most typical situation when, as a business analyst or a consultant, you will have to prepare such a model are connected with selling or purchasing a company. You may be doing it on the sell side or on the buy side.  Financial modeling is done as a part of strategy projects, turn around projects, due diligence.

I will NOT teach you everything on financial modelling because it is simply not efficient (and frankly you don’t need it). This course is organized around 80/20 rule and I want to teach you the most useful (from business analyst / consultant perspective) ways to go as fast as possible from rough description to working model in Excel that you can make more and more complicated.

The aim of this course is that you are able to do a financial model of the business as fast as possible.

If done properly, this course will transform you in 1 day into pretty good business analyst that knows how to create fast and efficiently financial models. It is based on my 12 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from FMCG, SMG, B2B sector that I worked for.  On the basis of what you will find in this course I have trained over 100 business analysts who now are Investment Directors, Senior Analyst, Directors in Consulting Companies, Board Members etc.

I teach step by step on the basis of Excel files that will be attached to the course.  We will go through a real life example of a business and create the financial model for it. To make the best out of the course you should follow my steps and repeat what I do with the data after every lecture. Don’t move to the next lecture if you have not done what I show in the lecture that you have gone through.

 I assume that you know basic Excel so the basic features (i.e. how to write formula in Excel) are not explained in this course. I concentrate on intermediate and advanced solutions and purposefully get rid of some things that are advanced yet later become very inflexible and useless (i.e. naming the variables).

To every lecture you will find attached  (in additional resources) the Excel shown in the Llcture so as a part of this course you will also get a library of ready-made analyses that can, with certain modification, be applied by you in your work.

 

Why I decided to create this course?

This course is a part of my attempt to help business analyst and consultants gain fast useful knowledge that will help them excel at their work. I have done 10 other courses that will help you be great business analysts or consultants. I have covered already: hacks and tricks in Excel, business modelling, market research, management productivity hacks and others. Now you have the opportunity to learn financial modeling in Excel

 

In what way will you benefit from this course?

The course is a practical, step by step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed with which you do the analyses as well as the quality of the conclusions coming out of available in your company data. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know:

  • What is the difference between business models and financial models?
  • How to model cost positions and balance sheet position?
  • How to create on the basis of this financial statements: profit and loss statement, balance sheet statement and cash flow statements
  • How to make sure that there is integrity in the model?
  • What analyses and conclusions you can draw from the financial model?

You can also ask me any question either through the discussion mode or by messaging me directly.

 

How the course is organized?

The course is divided currently in 10 sections and will be adding new section to address other important issues. Currently you will find the following sections:

  • Introduction. We begin with little intro into the course
  • Modeling of Profit & Loss account. In this section we start by showing how to model cost positions (except for Depreciation)and how to create on the basis of this a profit & loss statement
  • Capex and Depreciation.  Capex and Depreciation are one of the most difficult elements that you will model in Excel. Therefore, we have created a separate section devoted just to this subject . In this section you will learn how to follow specific group of assets, truck their gross and net value and calculate depreciation.
  • Working Capital. Working capital is crucial to the business as it defines how much money you have to have engaged in the business. I will show you how to model specific positions of Working Capital
  • Debt.  You may need external sources of financing for the company. I will show you how to model loans and get the necessary info to create balance sheet later.
  • Equity. In this section I will show you how to model the equity and all relations with shareholders
  • Balance sheet modeling. Here we get everything together to model the balance sheet statement.
  • Cash flow modeling.  Here we get everything together to model the cash flow statement.  Here we will check integrity of the model as well.
  • Analyses of the Financial Model.  At the end, on the basis of ready model I will try to draw the conclusions that will show us whether the business we have been analyzing is interesting or not

 

 

You will be able also to download many additional resources

  • Excels with analyses shown in the course
  • Links to additional presentations and movies
  • Links to books worth reading

 

At the end of my course, students will be able to…

  • You will master financial modeling in Excel at the needed for business analyst and consultant level
  • Understand the main challenges in financial modelling
  • Perform the analyses of financial model
  • You will get ready model that you can utilize for your purposes

Who should take this course? Who should not?

  • Business analysts
  • Researchers
  • Controllers
  • Consultants
  • Small and medium business owners
  • Startups founders

 

What will students need to know or do before starting this course?

  • Basic Excel
  • Basic knowledge of economics or finance

 

 

 

Who is the target audience?
  • Business analysts
  • Researchers
  • Controllers
  • Consultants
  • Small and medium business owners
Students Who Viewed This Course Also Viewed
Curriculum For This Course
51 Lectures
02:44:06
+
Introduction
3 Lectures 07:00

Here I will explain you what the course will be about and how you can make the best out of it.

Preview 02:35

Here I will talk a little bit about me and my company

Preview 01:47

As a business analysts or a consultant you will have to from time to time create financial models. There are a bit different than business models. In business models you go into details of operations and you focus on getting the links on the KPIs. Those models are usually done for internal purposes, to manage in the right direction the business. Financial models on the other hand are more for external users. You concentrate in them on creating the picture of the business in a standardized, understood by everybody way. You also want to create the financial statements: profit & loss statement, balance sheet statement, cash flow statement

Preview 02:38
+
Modeling of Profit & Loss Account
7 Lectures 17:03

We start by showing how we will get from cost position to profit & loss statemen

Preview 00:30

Sales are driving the whole financial model. Therefore, we start from sales and show you how to model it.

Preview 04:25

In terms of cost quite often materials and energy are the main cost position. We will show you how to model it.

Preview 02:36

You will be buying a lot of services from third parties. Some companies have a lot of contractors instead of workers. We will show you how to model it in this lecture

External services
02:09

I will show you in this lecture how to model Taxes & Payments

Taxes & Payments
00:56

Salaries and wages are very important in any business. I will show you how to model it taking into account base salaries, FTE (full time equivalents) and assumed growth in salaries and wages

Payroll
04:28

I will show you in this lecture how to model Other Costs

Other Costs
01:59
+
Capex and Depreciation
4 Lectures 11:27

Capex and Depreciation are one of the most difficult elements that you will model in Excel. Therefore, we have created a separate section devoted just to this subject . In this section you will learn how to follow specific group of assets, truck their gross and net value and calculate depreciation.

Preview 03:29

I will show you in this lecture how to model Intangibles especially I will show you in this lecture how to

Intangibles - modeling of gross value, net value and depreciation
04:47

I will show you in this lecture how to model Machinery especially I will show you in this lecture how to

Machinery - modeling of gross value, net value and depreciation
01:51

At the end we add the depreciation to P&L

Adding depreciation to the P&L
01:20
+
Working Capital
5 Lectures 14:54

Working capital is crucial to the business as it defines how much money you have to have engaged in the business. I will show you how to model specific positions of Working Capital

Preview 03:03

I will show you in this lecture how to model inventory of materials, WIP and finished goods

Inventory of materials, WIP and finished goods
03:13

I will show you in this lecture how to model receivables

Receivables
03:22

I will show you in this lecture how to model liabilities

Liabilities
04:03

I will show you in this lecture how to model Corporate tax and final working capital estimation

Corporate tax and final working capital estimation
01:13
+
Debt
4 Lectures 11:20

You may need external sources of financing for the company. I will show you how to model loans and get the necessary info to create balance sheet later.

Introduction to debt modeling
01:00

I will show you in this lecture how to model old loans

Old loans
03:04

I will show you in this lecture how to model new loan

New loan
03:55

I will show you in this lecture how to model interest paid and interest earned

Interest paid and interest earned
03:21
+
Equity
2 Lectures 04:18

In this section I will show you how to model the equity and all relations with shareholders

Introduction to Equity
01:07

I will show you in this lecture how to model Equity

Equity modeling
03:11
+
Balance sheet modeling
6 Lectures 11:37

I will show you in this lecture how to model balance sheet

Preview 01:53

I will show you in this lecture how to model fixed assets

Fixed assets
02:32

I will show you in this lecture how to model current assets

Current Assets
02:10

I will show you in this lecture how to model own capital

Own capital
01:09

I will show you in this lecture how to model current liabilities

Current liabilities
02:27

In this lecture we summarize the balance sheet and check the integrity of the model 

Balance sheet - summary
01:26
+
Cash flow modeling
6 Lectures 12:43

Here we get everything together to model the cash flow statement.  Here we will check integrity of the model as well

Preview 03:32

I will show you in this lecture how to model operational cash flows

Operational cash flows
02:30

I will show you in this lecture how to model investment cash flows

Investment cash flows
00:55

I will show you in this lecture how to model cash flow from financial activities

Cash flow from financial activities
01:46

I will show you in this lecture how to model shareholders influence on Cash Flow

Shareholders influence on Cash Flow
01:02

I will show you in this lecture how to model Final Cash Flow

Final Cash Flow
02:58
+
Analyses of the Financial Model
4 Lectures 10:12

 At the end, on the basis of ready model I will try to draw the conclusions that will show us whether the business we have been analyzing is interesting or not

Preview 01:59

I will show you in this lecture how to model Profit & Loss analyses

Profit & Loss analyses
03:15

I will show you in this lecture how to model Cash Flow analyses

Cash Flow analyses
03:11

In this section I will show you where you can look for improvements on the basis of financial model

Possible improvements to be further analysed
01:47
+
Business Modeling - examples
9 Lectures 01:02:54

Here I will show you examples of business model that differ from financial models

Introduction to business modeling
01:35

We will start with reminder about the difference between financial and business models

Difference between financial model and business model
02:38

Before I show you the model in Excel I want to present you in this lecture the overall logic

Mechanics of business model for a consulting firm
02:26

I show you in the lecture the model of the consulting firm in Excel. After modifying it you can use it for your purposes (we attach the Excel files to the lecture). This model will let you check whether your business idea makes sense.

The business model of a consulting firm in Excel - Capacity and revenues
02:54

I show you in the lecture the model of the consulting firm in Excel. After modifying it you can use it for your purposes (we attach the Excel files to the lecture). This model will let you check whether your business idea makes sense.

The business model of a consulting firm in Excel - costs and profit & loss
05:05

In this lecture we will explain you how e-commerce business model works and what you should concentrate on

E-commerce Introduction
20:57

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

E-commerce business model
09:10

Excel gives you great opportunities to calculate whether your idea makes sense or not. For this you will use the knowledge you have gathered in the previous lectures on your concept, location and your customers. Excel is obviously less emotion than you and the model you will create here can be used as a cornerstone of your business plans. It shows also to banks and potential investors what is your cash flow. We start with a simple model so you can understand it and learn how to use it. 

Business model of a restaurant in Excel - basic model
09:11

In this lecture we make more advanced model. We introduce the traffic parameter and show how it is converted first into people that are engaged (stop and enter your restaurant) and later into customers (they buy something from you). Here we will be operating on 2 customer groups: first one eats at the restaurant; second one comes for take-aways. For both customer groups we calculate separate conversion rates and Average ticket (ATV). We still here show you a business model for a 1 restaurant

Business model of a restaurant in Excel - advanced model
08:58
1 More Section
About the Instructor
Asen Gyczew
4.3 Average rating
824 Reviews
18,437 Students
22 Courses
Expert in performance improvement, turnaround and startups

Expert in performance improvement, startuping and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 40 million) as well as startups.

Specialties:

Functional experience: performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence;

Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing)

Countries: Poland, Serbia, Russia, Ukraine