Blackstone Group Acquisition

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! - Please use attached spreadsheet to answer.

Attachment Preview: