Publication number: ELQ-81726-1
View all versions & Certificate
Comparable Companies (NON-FDS) Excel Model
A full Excel valuation model template comparing companies
This Comparable Companies model in excel contains the following sections:
- Setup Companies Tab
- Reorder Tab (To Compare Companies)
- Comparable Company Analysis Output Tab (TEV Values, Market Values...)
- Latest 10K Excel Sheets for each compared Company (30 sheets)
- Client 10 K
- WACC (Weighted Average Cost of Capital) Tab with Total Debt Tables from 10K
The Excel File has an Old VBA code, so you are more than welcome to update this file and re-post it in its "modernised" version!
=> John P. Burns
This business tool includes
1 Excel Model Template
John P. Burns offers you this business tool for free!
download for free
Add to bookmarks
- Thomas Wiredu(last updated: 10/06/2018 21:49)
- Dave Kumar(last updated: 24/05/2018 16:35)
- 宁 刘(last updated: 09/05/2018 11:23)
- Marcus Paleti(last updated: 23/04/2018 16:12)
- Long Lê(last updated: 25/03/2018 16:51)Very good!
- Alfonso Cioffi(last updated: 31/12/2017 14:15)
People using this tool also downloaded
Leveraged Buyout LBO ModelA fully customizable excel LBO model to assess the debt level your firm can take in a deal & expected investor returnsmergersleveraged buyoutprivate equitylbom&aacquisitionsinvestor returnsdebt levelslbo analysislbo model2,991 remove_red_eye
M&A Analysis Bank Excel ModelDetailed excel financial model for mergers and acquisitions.mergersfinancial analysism&amergers and acquisitionsacquisitionsbusiness acquisitiontarget companyacquiring company116 remove_red_eye
Combination ModelA 22 section excel model to assess the impact on the financials of the combination of companiescombinationimpactfinancemergersm&aacquisitionsfinancial statements2,045 remove_red_eyefreeby John P. Burns
Merger Model - Consolidation of Two CompaniesFinancial Model for a business merger focussing on the consolidation of two companies.income statementmergersbalance sheetcashm&aacquisitionsconsolidationfinancial assumptions77 remove_red_eye
Illustration of different valuation and merger techniquesDetailed excel model analysing the details of the Cadbury/Kraft mergermergersbalance sheetm&amergers and acquisitionsacquisitionsacquiring companycadbury kraftacquisition forecasts53 remove_red_eye
Synergy Valuation Premium DCF Excel ModelA Premium Discounted Cash Flow DCF Model including synergy valuationmergersprivate equitym&aacquisitionsdcf modelsynergy valuationsynergy analysisdiscounted cash flow modeladvanced dcf model574 remove_red_eye
Mergers & Acquisitions ValuationThis module explores all details of M&A that investment bankers need to know, from a valuation perspective.modelvaluationmergersm&aacquisitionsinvestment bankdilution analysisaccretion318 remove_red_eye
LBO model - Leveraged Buyout AnalysisA step by step LBO model tutorial. It is easy to use and we provide support if needed. Have fun modeling!financevaluationleveraged buyoutprivate equityinvestment bankinglbom&amergers & acquisition8,464 remove_red_eye
Discounted Cash Flow Model TemplateA fully customizable excel model to match your needs, and use as a starting point or as a full DCF tool for valuation.financevaluationdcfwaccinvestment bankinginvestment analysisfree cash flow projections8,252 remove_red_eye
How to Prepare For A Merger And Acquisition Transaction Using 9 TacticsHere you will find 9 key ways of preparing for a merger and acquisition transaction.acquisitionstrategymergersm&andatransactionm and a29 remove_red_eye
Any questions on Comparable Companies (NON-FDS) Excel Model?
The user community and author are here to help. Go ahead!