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
- 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,281 remove_red_eye
Combination ModelA 22 section excel model to assess the impact on the financials of the combination of companiescombinationimpactfinancemergersm&aacquisitionsfinancial statements1,543 remove_red_eyefreeby John P. Burns
Mergers & Acquisitions ValuationThis module explores all details of M&A that investment bankers need to know, from a valuation perspective.modelvaluationmergersm&aacquisitionsinvestment bankdilution analysisaccretion131 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 & acquisition5,148 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 projections5,440 remove_red_eye
Accretion Dilution Template Excel Model (Stock Exchange)Simple Accretion Dilution Model for you to quickly work out if an acquisition will generate value for a public company.acquisitionmodelmergersepsm&atemplateexceldilutionaccretionstock exchange26 remove_red_eye$9.00by Alexander Jarvis
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 a13 remove_red_eye
All in One Private Equity ModelUsed by Investment Professionals at Private Equity and IB Firmsfinancevaluationdcfevaprivate equityinvestment bankinglbofinancial statements2,817 remove_red_eye$180.00by John Swan
LBO Financial Model Excel Template (Illustrative)LBO (Leveraged Buyout) financial model for private companies (clean, simple, functional, and reusable template).acquisitionfinancialmodelleveraged buyoutprivate equitypefinancial modelinvestment bankinglboib47 remove_red_eye$100.00by Karl Schopf
Any questions on Comparable Companies (NON-FDS) Excel Model?
The user community and author are here to help. Go ahead!