# Relative Valuation Model Excel

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

## 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 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

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:

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

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

#### 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