Relative Valuation Model Excel

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

Company Valuation using Relative Valuation Model in Excel


Company Valuation using Relative Valuation Model in Excel

Course Details
Name: Company Valuation using Relative Valuation Model in Excel
Total Videos: 16
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: 4.2 stars, based on 57 reviews
Short Description of Course
In this course, you will learn how to make company valuation using Relative Valuation Model (Trading Combs). This course is recommended for beginners as well as advanced users.

Company Valuation using Relative Valuation Modeling in Excel

Comparable Company Trading Analysis is the most basic but effective valuation tool used by investment bankers and analyst. This technique used in all kinds of valuations. For example:- Private market valuation, IPO valuation, comparative analysis, identifying potential targets for M&A etc Establishes value of A Company and measures its performance vis-à-vis the operating and trading statistics of company's peer group.

Leaning Outcomes:
  • Participants learn to select appropriate comparable companies by evaluating operational, financial, size, and other similarities
  • Set evaluation benchmarks & select comparable companies
  • Gather appropriate financial history and projections
  • Normalizing operating results and calculating LTM operating results
  • Exclude nonrecurring charges, normalize for stock option expense
  • Standardize various expense classifications including FIFO to LIFO inventory accounting
  • Calculate shares outstanding using the treasury stock method
  • Input financial data & calculate and interpret financial and market ratios
  • Presenting trading comps by structuring output schedule
  • Selecting and Evaluating Appropriate Multiples (P/E Trailing and forward, EBIT Multiple, EBITDA Multiple, P/B Multiple, Revenue Multiple, PEG)
  • Calculate and interpret financial and market ratios Common analytical challenges including Calandarization, nonrecurring items, dilutive securities, and classification issues are addressed using industry best practices.

List of Videos included in this Course

Introduction to Relative Valuation Model Structure
  1. Introduction to Structure of Model - Part 1
  2. Introduction to Structure of Model - Part 2

Design of templates for trading combs
  1. Making draft structure of model (Valuation Sheet)
  2. Bring items of Income Statement in the Model (Valuation Sheet)
  3. Creating dynamic formula for calculating last 12 months details
  4. Calculating Enterprise Value
  5. Model to calculate dilution from diluted securities
  6. How to prepare switches and currency convertors
  7. Linking currency exchange rate with the valuation sheet
  8. How to convert currency used in valuation sheet into desired currency
  9. Use and preparation of calendarization of financial data
  10. How to put the dynamic formula for calendarization
  11. How to prepare calendarization on valuation sheet
  12. Ways in which calendarization can be done - An important step
  13. Calculations of Multiple for output sheet
  14. Preparation of Relative Valuation Output Sheet with Indirect Function


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

Relative Valuation Model Excel

Relative Valuation model example

Relative Valuation model finance

Relative Valuation method

Relative Valuation Method Formula

Relative Valuation Approach

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:08814846868, 011-45092926

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