please perform DCF and LBO analysis in excel

LEVERAGED BUYOUT ANALYSIS (USS in MM, expr por thare amowels) TRANSACTION SUMMARY - Acquisition at $42.65, at 41.6% premium to the stock price of $30.11 on 10/31/2012 - Price representing the 20.0% IRR, midpoint of LBO valuation range - Total leverage of 5.0x LTM EBTTDA (6.2x EBITDAR) - 3.0x Term Loan at L.IBOR + 500 bps - 2.0x Subordinated Debt at 10.0\% - Assumes a "management promote" equivalent to 7.5% of incremental equity value created - Assumes minimum cash requirement of $25 million - Transaction date as of 1/31/2013