Use this cable industry comps template as a guideline for a comparable companies universe for Charter Communications Inc. Charter is an American telecommunications company that offers cable under their brand, Spectrum. To take a look at another industry, check out CFI's banking industry comps template!

Comparable Company Analysis

Comparable company analysis ("comps") looks at financial ratios from multiple companies in the same industry to determine the value of a firm. Comps analysis is one of three common valuation methods, the other two being discounted cash flow (DCF) analysis and precedent transactions analysis. Unlike discounted cash flow (DCF) analysis, which is an intrinsic form of valuation, comps analysis is a relative form of valuation. This makes comps analysis similar to precedent transactions analysis in that they both look for external evidence to value a company. On a basic level, comps analysis is more intuitive than DCF analysis. Comps analysis uses fewer assumptions than DCF analysis. DCF analysis uses assumptions to forecast each line item. Comparing things to determine relative value is also a fundamental part of behavior, making this a simple concept to understand. Use this cable industry comps template to help you gain an understanding of comparable company analysis.

Choosing Comparable Companies

When choosing comparable companies, an analyst must look for companies similar to the company they are valuing. If investors will pay a certain amount for similar companies, they should be willing to pay that amount for the company being valued. Analysts consider several important elements when building their comparables universe. Although it is unlikely that all points will match, it is still important to keep them in mind when selecting a comps universe. Here are the comparing metrics:
  • Industry Classification
  • Size
  • Geography
  • Growth Rate
  • Profitability
  • Capital Structure
However, to keep things simple, this cable industry comps template focuses on industry classification, size, and geography. Although the three other factors are just as important, they require a deeper dive into a company's financials and are often much more difficult to match. Thus, this template selects companies these characteristics:
  • Similar size and geographical coverage
  • Similar size and different geographical coverage
  • Different size and similar geographical coverage
  • Companies with similar business models
CFI covers all kinds of valuation techniques in our Financial Modeling and Valuation Analyst® certification program. Take a look at our program and some of our free courses to learn all the skills you need to become a world-class financial analyst!
Reviews Add a review
No reviews yet

More From Victor Ho

Browse our top rated business templates. See All
Opportunity Cost Template
This opportunity cost template is a fun tool you can use to calculate the opportunity cost of purchase. This tool…
Purchase Order Template Word Preview Purchase Order Template (Word)
This purchase order template (word) is a document that you can use to request a purchase from a vendor. Use…
Purchase Order Template Excel Preview Purchase Order Template (Excel)
This purchase order template (excel) is a document that you can use to request a purchase from a vendor. Use…
Personal Budget Template
This personal budget template is a basic tracker for your daily, monthly, and yearly personal finances! Use this budget if…
Advanced Personal Budget Template Preview Advanced Personal Budget Template
This advanced personal budget template includes everything you need to keep track of your daily, monthly, and yearly personal finances!…
Advanced WACC Analysis Template Preview Advanced WACC Analysis Template
This advanced WACC analysis template is a comprehensive analysis used to calculate the weighted average cost of capital for a…
See All