Build a Trading Comps Valuation Model

Build a Trading Comps Valuation Model

"Comps" analysis is the most widely used valuation methodology and an essential piece of the core valuation skill set of investment bankers and finance professionals. In this course, you will learn how to select and "scrub" comparables, pick the right multiples, and build complete comps models in Excel from scratch, using a real case study the exact way it's done ay financial institutions.

Lessons include:

• 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 to reflect nonrecurring charges and stock option expenses
• 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 key valuation multiples using the VLOOKUP function and generating multiple tables

Learn to build and analyze the single most common model in investment banking. Includes a complete comps model in Excel.

Url: View Details

What you will learn

• At course completion, you will have developed a comprehensive "Wall Street quality" Trading Comps model from scratch.

Rating: 4.4

Level: All Levels

Duration: 7 hours

Instructor: Wall Street Prep