Comparable Company Analysis Excel Walkthrough Valuation Multiples

############################# Video Source: www.youtube.com/watch?v=CPtBJN3SAvs

📈 The Complete Finance Valuation Course (use code EMAIL10): https://www.careerprinciples.com/cour... • Learn comparable companies analysis, also known as comps or multiples valuation. • 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/624462... • Comparable companies valuation is a valuation method that compares multiples of similar companies to determine a valuation range for a target business. This is a relative valuation method, meaning it's based on the market as opposed to the intrinsic value of the target company. • The following are the steps we take: • 1. Select the comparable companies: find 5-10 companies that are comparable based on industry, growth, credit risk etc. • 2. Gathering financials and calculating multiples: Find revenues, EBITDAs, earnings, etc. to calculate multiples such as EV/Revenue, EV/EBITDA, P/E etc. • 3. Benchmark the multiples: calculate the average, median, high, low, and quartiles to see multiple ranges • 4. Determine a valuation range: Calculate the enterprise or equity value and eventually reach an implied share price • 5. Simplifications for the model: Factors we need to consider such as calendarization, shares outstanding etc. • You can follow along and practice using the excel valuation template above. • LEARN: • 📈 The Complete Finance Valuation Course: https://www.careerprinciples.com/cour... • 👉 Excel for Business Finance Course: https://www.careerprinciples.com/cour... • 📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS • SOCIALS: • 📸 Instagram - / kenji_expla. . • 🤳 TikTok - / kenjiexplains. . • GEAR: • 📹 My Favorite Books Gear: https://kit.co/kenjiexplains • ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ • Chapters: • 0:00 - What is a Comparable Companies Valuation? • 1:49 - Selecting the comparable companies • 3:16 - Gathering financials and calculating multiples • 7:28 - Benchmark the multiples • 8:58 - Determine a valuation range • Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

#############################

New on site