DCF Valuation Model Excel

(Become a professional in Company Valuation with our self paced online course)

Company Valuation using DCF Valuation Model in Excel


Company Valuation using DCF Valuation Model in Excel

Course Details
Name: Company Valuation using DCF Valuation Model in Excel
Total Videos: 12
Buy Now
Language: English
Skill Level: All Level Relative Valuation Model
Price: Rs.2000

Includes:
  • Free life time access to the videos
  • 7 days money back guarantee
Rating: 3.9 stars, based on 78 reviews
Short Description of Course
In this course, you will learn how to make company valuation using Discounted Cash Flow (DCF) Valuation Model using Excel. This course is recommended for beginners as well as advanced users.

Company Valuation using DCF Valuation Model in Excel

Valuation is the Process to determine the current worth of any asset. In our course, the asset is a company. For the valuation of companies, following are the three widely used techniques.
  • Discounted Cash Flow Valuation (DCF)
  • Relative Valuation (Trading Combs, Comparable Analysis)
  • Transaction Valuations
In general all main stream finance profiles require the valuation skills found in our course. We shall take the most important three techniques which are used in every research house, Rating agency, Investment bank, consulting firm, Private equity and KPO. We shall understand the application of the techniques with real case studies and companies.

Discounted Cash Flow model (DCF) Modeling
In Financial modeling, cash flows are only forecasted where as in DCF valuation; those cash flows are used to derive the intrinsic value of the company. So by now the participants would have learned how the Financial Model is designed and Projections are made for the Company. Now we learn how to use Financial Models in Valuations.

Valuation is the most important part the investment banking and corporate finance skill set. You need to have theoretical knowledge of valuation before building valuation models.

Key Learning Outcomes
When the theoretical frame work is laid down, the participants start learning DCF model which includes the calculations of FCFF, WACC, Terminal Value, Levered and un-levered Beta and Intrinsic Value.
  • Using cash flows forecasted in the course, participants learn to prepare a DCF valuation model in Excel from scratch
  • Understand differences between Enterprise value & Equity value, relative value & intrinsic value, Un-levered and levered free cash flows, and the implication on Enterprise value and implied share price. Deal with Non-equity claims, WC, CapEx and debt related items
  • Calculate Terminal value with Multiple and Perpetual method
  • Use of CAPM to calculate the discount rate by deriving the cost of debt of equity.
  • Understand the role of capital structure in determining beta, the cost of equity, and ultimately WACC
  • Understand use of beta and how to de-lever and re-lever beta and implication on WACC.
  • Calculate shares outstanding using the treasury stock method
  • When Dilutive securities are ITM (In-the-Money) Utilize the enterprise value to determine implied share prices.
  • Calculating net debt and treatment of debt equivalents such as preferred stock, convertible securities, capital leases, and minority interest
  • Calculating options and convertible securities using both the standard and treasury stock methods.

List of Videos included in this Course

Introduction to DCF Valuation
  1. How to calculate free cash flow to firm - Unlevered FCF

Calculation and Analysis of Weighted Average Cost of Capital (WACC)
  1. Understanding the Discount Rate
  2. Calculating cost of Equity
  3. Calculating Cost of Debts and Preferred Stock
  4. Finding out Weight of Debt and Equity - Part 1
  5. Finding out Weight of Debt and Equity - Part 2
  6. Calculating Cost of Capital
  7. Calculating present value (PV) of free cash flow to firm

Terminal Value
  1. Calculation of Terminal Value using Perpetual & Multiple Method - Part 1
  2. Calculation of Terminal Value using Perpetual & Multiple Method - Part 2

Calculation and Analysis of Weighted Average Cost of Capital (WACC)
  1. Calculation of Intrinsic Value of Company's Shares
  2. Senstivity Analysis on Share Price


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. 22,500
4.6 Stars

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

24 Sessions
4 hrs/session
Rs. 25,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:09312222566, 09896999313, 011-45092926

Follow




Page Tags

DCF Valuation Model Excel

Discounted Cash Flow Valuation Model Excel

DCF valuation model excel

Company Valuation Methods

Company Valuation Excel

Company Valuation Models

Company Valuation Course

Company Valuation 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:9312222566, 011-45092926

Copyrights © 2011-2018 All Rights Reserved.