0% found this document useful (0 votes)
59 views4 pages

Compact Comps (Template)

The document provides valuation summaries for a target company using comparable trading analysis, precedent transaction analysis, and discounted cash flow analysis. The comparable trading analysis values the company between $8.4 billion to $11.5 billion based on EBITDA multiples of peer companies. The precedent transaction analysis values the company between $11.7 billion to $14.6 billion based on EBITDA multiples of similar M&A transactions. A discounted cash flow analysis further values the company at $6.85 billion.

Uploaded by

dudutomy67
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
59 views4 pages

Compact Comps (Template)

The document provides valuation summaries for a target company using comparable trading analysis, precedent transaction analysis, and discounted cash flow analysis. The comparable trading analysis values the company between $8.4 billion to $11.5 billion based on EBITDA multiples of peer companies. The precedent transaction analysis values the company between $11.7 billion to $14.6 billion based on EBITDA multiples of similar M&A transactions. A discounted cash flow analysis further values the company at $6.85 billion.

Uploaded by

dudutomy67
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Compact Comparable Model Strictly Confidential

Table of Contents

Summary
Comparable Trading Analysis
Precedent Transaction Analysis

© 2015 to 2022 CFI Education Inc.


This Excel model is for educational purposes only and should not be used for any other reason. All content is Copyright material of CFI Education Inc.
All rights reserved. The contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected
under international copyright and trademark laws. No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted in any
form by any means, including photocopying, recording, or other electronic or mechanical methods, without prior written permission of the publisher,
except in the case of certain noncommercial uses permitted by copyright law.

[Link]
Valuation Summary

All figures in USD millions unless stated

Enterprise Value

15,000 14,569

14,000

13,000 12,848

12,000
11,466
11,673
11,000

10,000

9,000

8,000 8,411

7,000
6,850
6,000
Comparable Trading Analysis Precedent Transaction Analysis DCF Valuation Analysis

Comparable Trading and Precedent Transaction Analysis both use LTM EBITDA.⁽¹⁾
Comparable Trading Analysis

All figures in USD millions unless stated

Enterprise Market EBITDA Net Income EV / EBITDA P/E3


Peer Companies Value 1 Cap LTM 2 FY+1 LTM 2 FY+1 LTM 2 FY+1 LTM 2 FY+1

[Link] 10,142 7,992 586 600 453 480 17.3x 16.9x 17.6x 16.7x
Big Bucks Company 10,846 10,796 569 613 370 398 19.1x 17.7x 29.2x 27.1x
Centibillions Inc. 11,584 10,301 530 655 332 485 21.9x 17.7x 31.0x 21.2x
Deep Pockets Ltd. 12,787 9,921 542 635 361 465 23.6x 20.1x 27.5x 21.3x
Evergreen Co. 12,328 11,932 525 619 393 427 23.5x 19.9x 30.4x 27.9x
Fat Cat Inc. 10,500 9,282 516 631 432 360 20.3x 16.6x 21.5x 25.8x

Target Company Valuation 4

Average 10,178 7,597 486 290 20.9x 18.2x 26.2x 23.3x


Median 10,256 8,216 486 290 21.1x 17.7x 28.3x 23.6x
Maximum 11,466 8,998 486 290 23.6x 20.1x 31.0x 27.9x
Minimum 8,411 5,116 486 290 17.3x 16.6x 17.6x 16.7x

Enterprise Value = Market Cap + Net Debt. ⁽¹⁾


LTM means Last Twelve Months. ⁽²⁾
Calculated as Market Cap divided by Net Income. ⁽³⁾
Target Company Valuation based on LTM Multiple. ⁽⁴⁾
Precedent Transaction Analysis

All figures in USD millions unless stated

Enterprise EBITDA EV / EBITDA


Date Acquirer Target Value LTM 1
FY+1 FY+2 LTM 1
FY+1 FY+2
(YYYY-MM-DD)

2022-03-11 Cake Ice Cream 12,411 414 591 650 30.0x 21.0x 19.1x
2022-03-06 Salt Pepper 12,490 520 595 654 24.0x 21.0x 19.1x
2021-09-17 Fish Chips 12,825 475 558 602 27.0x 23.0x 21.3x
2020-11-13 Peanut Butter Jelly 11,133 445 530 541 25.0x 21.0x 20.6x
2020-08-13 Brisket NoSauce 11,447 424 498 513 27.0x 23.0x 22.3x
2020-05-01 Biscuits Gravy 12,803 441 640 647 29.0x 20.0x 19.8x

Target Company Valuation 2

Average 13,126 486 27.0x 21.5x 20.4x


Median 13,121 486 27.0x 21.0x 20.2x
Maximum 14,569 486 30.0x 23.0x 22.3x
Minimum 11,673 486 24.0x 20.0x 19.1x

LTM means Last Twelve Months⁽¹⁾


Target Company Valuation based on LTM Multiple⁽²⁾

Common questions

Powered by AI

Relying heavily on EV/EBITDA multiples can streamline and simplify comparisons across companies in the Compact Comparable Model; however, it could also obscure company-specific factors such as capital structure or growth potential that are not reflected in EBITDA. This approach may overlook significant variations in accounting policies or industry-specific dynamics. Heavy dependence risks oversimplified valuations that do not fully capture the financial health and operational nuances of a company, possibly leading to mispricing or misguided strategic decisions .

Market capitalization and net debt adjustments are critical as they directly affect the calculation of Enterprise Value (EV) in the Compact Comparable Model. A higher market cap reflects increased investor confidence or stock performance, raising the EV. Conversely, increasing net debt—as in liabilities exceeding assets—reduces the EV, indicating higher financial risk or leverage. These components must be accurately adjusted to reflect the true financial position of a company, affecting comparables used in EV/EBITDA multiples and subsequent valuations .

The integration of various financial models—Comparable Trading Analysis, Precedent Transaction Analysis, and Discounted Cash Flow (DCF) Valuation—enhances accuracy by providing multiple valuation perspectives. Each model addresses different aspects: Comparable Trading assesses peer benchmarks in current markets, Precedent Transactions provide historical context, and DCF projects future cash flows discounted to present value. By synthesizing these approaches, the model can triangulate a more nuanced valuation that considers current, past, and anticipated financial dynamics, reducing reliance on any single approach's assumptions and biases .

The Compact Comparable Model differentiates between forward-looking and historical analyses through its use of varying data sets and multiples. Comparable Trading Analysis employs forward-looking multiples such as forecasted EV/EBITDA ratios for projecting future company performance, whereas Precedent Transaction Analyses rely on historical EV/EBITDA ratios from past acquisitions to infer current valuations. This distinction allows the model to balance anticipations of future financial performance with empirical market behavior, crucial for comprehensive evaluation metrics .

Using specific fiscal years like FY+1 or FY+2 in the Compact Comparable Model shifts focus to forward-looking estimations, affecting accuracy and relevance of valuations. These forecasts capture anticipated changes in performance metrics, aligning with expected growth or contraction. However, they introduce risks due to uncertainties in assumptions about future conditions, such as market trends, regulatory changes, or economic shifts. Therefore, while they provide crucial context for strategic planning and investment decisions, they necessitate rigorous scenario analysis to mitigate potential variance in outcome predictions .

The Compact Comparable Model ensures representation of market trends by incorporating both Comparable Trading Analysis and Precedent Transaction Analysis, which leverage historical data and current market caps, EBITDA, and net income figures for peer companies. These analyses provide a holistic view by using market-driven multiples such as EV/EBITDA and P/E ratios, reflecting both current financial performance and historical market behaviors. This synthesis captures temporal changes in investor sentiment and aligns valuations with broader market conditions .

Precedent Transaction Analyses play a crucial role in the Compact Comparable Model's valuation framework, providing a transactional perspective by examining historical acquisitions of similar companies. These analyses establish valuation benchmarks by determining the EV/EBITDA multiples from previous transactions, offering insights into prevailing market conditions and investor sentiment at the time of each transaction. This assists in understanding how much acquirers have been willing to pay historically, aiding in the estimation of the target company's value .

Using LTM EBITDA as a valuation metric in the Compact Comparable Model has several limitations. LTM data may not accurately reflect current business conditions if there have been significant changes in the business environment or the company's operations since the last twelve months. It can also obscure seasonal business variations and one-time events. Furthermore, relying on LTM does not account for future growth prospects or changes in profitability, leading to potential mismatches with forward-looking market valuations .

The Compact Comparable Model evaluates Enterprise Value by applying EV/EBITDA multiples to the EBITDA figures of comparable companies. This involves comparing the market capitalization adjusted for net debt of comparable firms and calculating their EV/EBITDA ratios to apply them to the target company's EBITDA. This model uses Last Twelve Months (LTM) EBITDA figures to ensure consistency and accuracy in valuation metrics .

Contrasting average and median figures in Precedent Transaction Analysis provides insights into the distribution of transaction multiples and variations in market behaviors. A close proximity between these figures suggests a symmetrical distribution of transaction values, indicating consistent market behavior. A significant difference might imply skewness, often due to outliers or extreme valuations in certain transactions, which could distort the overall market sentiment and potentially mislead valuation conclusions if not accounted for .

You might also like