IRR

Hi,

In practice LBO models I have noticed that sometimes, IRR is calculated based on MOIC (i.e. taking the MOIC^(1/hold period)-1) and sometimes using XIRR-formula (I of course know that XIRR is the only option when cash flows are irregular in terms of time period). Let's assume that the sponsor equity investment is made at 2019-12-31 and that the hold period is 5 years. The only cash flow is given at the end of year 5.

Why do I get slightly different answers in terms of IRR when I use XIRR compared to calculating IRR with MOIC? XIRR is used with irregular time periods between payments but in theory you should be able to use XIRR in this example as well. The Macabus long-form lbo for example uses XIRR with only 1 cash inflow.

Let's assume that the sponsor equity outflow is 200 and that at the end of year 5, sponsor equity is 500. This would give MOIC of 2.5x which would equal an IRR of 2.5^(1/5)-1=20.1124%. If using the XIRR formula however, we would get 20.0884%. Why?

 

Ipsam qui officia accusamus dolorum velit quis est. Magnam eaque cupiditate qui expedita. Ipsam placeat laborum placeat error sit possimus omnis.

Voluptates quo dicta in incidunt. Dolorum aliquam maxime dolor placeat dolorem. Temporibus nihil quam quia et error rerum. Est rem totam qui perferendis doloremque voluptates rerum.

Career Advancement Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Warburg Pincus 99.0%
  • Blackstone Group 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

March 2024 Private Equity

  • Principal (9) $653
  • Director/MD (21) $586
  • Vice President (92) $362
  • 3rd+ Year Associate (89) $280
  • 2nd Year Associate (204) $268
  • 1st Year Associate (386) $229
  • 3rd+ Year Analyst (28) $157
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (313) $59
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”