8/5/20097:43 PM
167
0d673fd1-63ee-4432-abed-38b5221e0ddc.xlsSources_Uses
Model Is Balanced --- Circ Breaker Is On --- Cash Min Switch Is Off NOTE - Remember To Switch Off Circ Breaker Once Data Has Been Entered and Select Iteration
Written By John P. Burns 98.12.15
Project XXX Transaction Structure
Performance Case: Base (FYE January; $ in millions) Uses of Funds Equity Purchase Price Debt Retired Debt Assumed Cash Infusion Transaction Costs Total Uses Current Stock Price Offer Premium Offer Price Per Share Shares Outstanding (MM) Equity Purchase Price Acquisition Multiples 2004 EBITDA EST. 2005 EBITDA 2004 P/E EST. 2005 P/E To 2004 Book To EST. 2005 Book Exit Multiples Exit Year Exit EBITDA Multiple Exit P