Blackstone Group Acquisition
ProfArgeol
blackstone_group_acquisition.xlsxPart D
| Value given in problem | ||||
| Formula/Calculation/Analysis required | ||||
| Investment date | 11/30/07 | |||
| Investment | $6,000,000,000 | |||
| Implied Share Price at investment | ||||
| IPO Date | ||||
| Number of common shares | 752,492,744 | |||
| IPO Price | ||||
| Solution using XIRR | ||||
| Price | Date | |||
| Return | ||||
| Solution using IRR | ||||
| Time | Cash Flow | |||
| Return | ||||
| Solution using formula | ||||
| Price | Date | |||
| Return |
In late November 2007 a private equity group Blackstone Group LP acquired Hilton Worldwide Hotels (HWH) in a leveraged buyout deal for which the group paid $ 6 Billion of its own money (other $20 Billion came from borrowing). According to the HWH IPO prospectus, at IPO the Blackstone Group LP will own 752,492,744 common shares. If Blackstone Group LP participated in IPO and could sell some of these shares at the IPO price of $20.00 , what would be its annualized return on this investment? You may assume the investment date to be exactly 6 years earlier, or use the IRR or XIRR function - one solution is enough!
