Explore

Hands-on Financial Modeling (With 6 Excel Templates)

4 hours on-demand video

$ 9.99

Save Course

Go to Course

Brief Introduction

Learn Financial Modeling in Excel from a professional research analyst.

Description

What is Financial Modeling?
How to build a financial model in Excel?
What is EBITDA?
How to read the P&L?
How to calculate WACC, ROIC, equity risk premium?
How to use DCF?
Every student will receive an Excel file with input data for Sample Company valuation, which will include both historical financial accounts and operating data for every business division (airline catering, events catering and RHL, or restaurants, lounges and hotel). The lecturer will first give detailed comments on the available historical information and will show you how to make assumptions for reconstruction of the missing data, required to start modelling of future financial items.
Business modelling will start with forecasting of P&L items for each of the three divisions, which will then be combined into the Sample Company P&L. Afterwards the lecturer will model Cash Flow statement for the Sample and its Balance Sheet. All the forecasts are being built for the next 6 years.
Once you get all financials forecasted you move to the most interesting part – DCF (or Discounted Cash Flows valuation) with deep plug into the calculations of WACC and its components (risk free rate, Beta and equity risk premium), Terminal Value and Discount Rate. You will learn how to apply logic to make the right assumptions as the ultimate result of every financial modelling is a matter of assumptions used.
Special attention will be paid to the multiples-based analysis and sum of the part valuation.
You will see how theory works in real business with every figure of Excel model created in front of your eyes. This is a unique experience not to be missed.

Requirements

Requirements
While no background is required for this course, a basic knowledge of financial concepts may be helpful.

Recommended for you

Microsoft Power BI - Business Intelligence for Beginners

Beginner Course on Power BI : Business Intelligence & Data/Business Analysis with Microsoft Power BI Do you want to build professional-quality Business Intelligence Reports from the ground up ?...

Save Course

Ace the Energy Risk Professional (GARP) Exam

Certified Exam Preparation Provider by GARP Energy - More important than ever right now! Some economists say that the GDP of a country is directly proportional to its energy consumption....

Save Course