Financial Modelling Case Study

(Learn Financial Modelling with real case study)

Financial Modelling Case Study


Financial Modelling Case Study

Course Details
Name: Financial Modelling Case Study
Total Videos: 24
Buy Now
Language: English
Skill Level: All Level Financial Modelling Case Study
Price: Rs.2000

Includes:
  • Free life time access to the videos
  • 7 days money back guarantee
Rating: 4.4 stars, based on 109 reviews
Short Description of Course
In this course, we have prepared step by step financial Model (using excel) of a US based company "Colgate Palmolive". So you will learn financial Modelling using excel with real example.

Financial Modelling Case Study

Financial Modeling is the process to make Financial Projection of the company. Financial Model includes the Projection of Income Statement, Balance Sheet and Cash Flow Statement.
  • How to read annual report of company and search the content for financial modelling.
  • How to extract data from Historical Financial Statements
  • Adjustment of Historical Income Statement & Balance Sheet
  • Reading MD&A to define projection criteria
  • How to take assumptions based on information available in annual report (Form 10k)
  • Projection of Income Statement, Balance Sheet and Cash Flow Statement with required schedules
  • Projection of Revenue, Expenses, Shares, Equity, WC, Debt and other
  • Scenario analysis and impact analysis
After this course, you will acquire full knowledge of Financial Modeling. After this you will have to learn only Industry specific Financial Models.

List of Videos included in this Course

Extracting items from Income Statement
1. Preparing Income Statement from Annual Report of Colgate Palmolive - Part 1 6Mins 30Secs
2. Preparing Income Statement from Annual Report of Colgate Palmolive - Part 2 3Mins 43Secs

Cleaning Historical Reported Income Statement
1. Removal of items from Income Statement which are irrelevant and non-recurring 5Mins 27Secs
2. Adjustments related to stock based compensation & equity income 5Mins 42Secs
3. Calculations & Adjustments related to depreciation 4Mins 59Secs
4. Final Discussion on Cleaning of Historical Reported Income Statement 2Mins 52Secs
5. Extracting details of balance sheet in excel and making certain adjustments 2Mins 49Secs

How to find out assumptions parameters for projection
1. Deciding parameters for projections 6Mins 12Secs
2. Preforming historical analysis for projections 4Mins 31Secs

Projection of Income Statement and Schedule Preparation
1. Checking management guidelines about items included in the income statement 2Mins 29Secs
2. Making assumptions for future forecast 4Mins 01Secs
3. Forecasting income statement on the basis of assumptions 4Mins 40Secs
4. Preparing depreciation schedule - Part 1 5Mins 28Secs
5. Preparing depreciation schedule - Part 2 4Mins 00Secs

Forecasting Balance Sheet
1. Forecasting basic and diluted weighted average shares and calculate EPS 3Mins 48Secs
2. Calculate Option proceeds and Treasury Stock 2Mins 41Secs
3. Linking of equity schedule to the balance sheet to calculate closing equity 2Mins 28Secs
4. Projection of other items of balance sheet like intangible assets, goodwill etc. 2Mins 01Secs
5. Projection of equity investments in associates 3Mins 01Secs
6. Forecasting of working capital 4Mins 23Secs

Forecasting Cash Flow Statement
1. How to forecast cash flow statement - Identifying items of CFS 1Mins 41Secs
2. Forecast cash flow statement - Linking CFS items with respective schedules, BS, IS 4Mins 06Secs
3. Prepration of Debt Schedule for CFS - Part 1 3Mins 57Secs
4. Prepration of Debt Schedule for CFS - Part 2 5Mins 36Secs


Free Financial Modelling Videos
Name:
Mobile:
E-mail:
Course:

Links of videos will be sent to your email

Live Weekend Courses

16 Sessions
4 hrs/session
Rs. 20,000
4.6 Stars

12 Sessions
4 hrs/session
Rs. 12,000
4 Stars

24 Sessions
4 hrs/session
Rs. 20,000
4 Stars
Online Courses - Our Packages

250 Videos
19 hrs
Rs. 6000
4.4 Stars
(3 in 1)
180 Videos
13.5 hrs
Rs. 4000
4 Stars
Individual Online Courses

117 Videos
6.5 hrs
Rs. 2200
4.4 Stars

44 Videos
4 hrs
Rs. 2500
4.5 Stars

20 Videos
2.5 hrs
Rs. 2000
4.2 Stars

18 Videos
1hr 45mins
Rs. 2000
4.1 Stars

24 Videos
1hr 40mins
Rs. 2000
4.4 Stars

16 Videos
1hr 20mins
Rs. 2000
4.2 Stars

12 Videos
1hr
Rs. 2000
3.9 Stars
Corporate Training
At Investment Banking Institute, we understand that different Individuals have their own set of requirements and we work closely with our corporate clients to understand and define requirements of the participants and create a customized program that addresses stated goals..
Rating from our Students
IBinstitute
Well designed courses, great content, superb trainer, excellent support
Aggregate Rating: 4.5 out of 5 with 200 ratings

Know Your Course and Trainer


Contact Us
IBI- Investment Banking Institute
1/2, Near Metro Pillar No. 182,
Near East Patel Nagar Metro Station
New Delhi-110060
Call:08814846868, 09896999313, 011-45092926

Follow




Page Tags

Financial Modelling using excel

Financial Modelling Business Case

Financial Modelling Online Training

Financial Modelling Case Study

Financial Modelling in excel

Case Study Based Financial Modelling

Case Study on financial modeling

financial modelling live tutorial

financial modelling case tutorial

financial modelling online certification

financial modelling certification courses

Rating from our Students

IBinstitute
Aggregate Rating:
4.5 out of 5 with 200 ratings
Investment Banking Institute
1/2, Near Metro Pillar No. 182,
Near East Patel Nagar Metro Station
New Delhi-110060
Call:08814846868, 011-45092926

Copyrights © 2011-2018 All Rights Reserved. Designed by Deepak Suhag