Financial Modeling (Applied Course in Excel)

Learn Financial Modeling in Excel from a professional research analyst.
3.7 (30 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.
4,506 students enrolled
Instructed by Eduson TV Business / Finance
$50
Take This Course
  • Lectures 14
  • Contents Video: 4 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course 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.

What are the requirements?

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

What am I going to get from this course?

  • Learn how to built financial model in excel
  • See how financial model is being built in Excel in the real time by a professional research analyst.
  • Learn how to use DCF method.
  • Master multiples based analysis and sum of the parts valuation.
  • Get a guide on how to read financial accounts, what major changes in the key figures can mean and how to make assumptions when doing a forecast.
  • Do not allow anyone to fool you on the business valuations.

What is the target audience?

  • This is the course for anyone who is interested in applying financial methods to real-life situations. 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Overview of Sample Co Business and Input Data. Getting Started with Excel
Preview
16:02
Overview of Sample Co Business and Input Data. Getting Started with Excel
1 question
Section 2: Sales and Costs Modelling
Airline Catering Division: Sales Modelling
Preview
16:59
Airline Catering Division: Sales Modelling
1 question
Airline Catering Division: Historical Cost Items Reconstruction
16:25
Airline Catering Division: Historical Cost Items Reconstruction
1 question
Airline Catering Division: Costs Modelling and P&L Calculation
15:43
Airline Catering Division: Costs Modelling and P&L Calculation
1 question
Event Catering Division Modelling
15:01
Event Catering Division Modelling
1 question
RLH Division Modelling
15:22
RLH Division Modelling
1 question
Section 3: P&L, Cash Flow and Balance Sheet Modelling
Sample Co P&L Modelling
16:07
Sample Co P&L Modelling
1 question
Sample Co Cash Flow Statement Modelling
27:00
Sample Co Cash Flow Statement Modelling
1 question
Sample Co Balance Sheet Modelling, Finalisation of CF Statement Modelling
23:12
Sample Co Balance Sheet Modelling, Finalisation of CF Statement Modelling
1 question
Section 4: Business Valuation
Getting Ready for DCF Valuation
Preview
13:09
Getting Ready for DCF Valuation
1 question
WACC Calculation
Preview
17:47
WACC Calculation
1 question
DCF Valuation
11:33
DCF Valuation
1 question
Multiples and Sum of the Parts Valuation
17:19
Multiples and Sum of the Parts Valuation
1 question
Section 5: Closing Remarks
Closing Remarks and Useful Pieces of Advice
10:54
Closing Remarks and Useful Pieces of Advice
1 question

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Eduson TV, Corporate E-Learning Service

Eduson has 1000+ videos of business courses on sales, management, personal efficiency and finance.

The courses are delivered by lecturers from leading business schools and successful practitioners. Learning from them is fun.

More than 60,000 employees are using Eduson for self-development, mentorship programs, for training in regional offices.

Learn new skills and apply this knowledge on the job. Pass the tests, the final exam and receive your diploma.

Ready to start learning?
Take This Course