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