Alternative Investments — Master Formula Sheet
1. Multiple on Invested Capital (MOIC)
where:
- Realized value = cash distributions received from exited investments
- Unrealized value = estimated fair value of remaining portfolio
- Total amount invested = total capital deployed (not committed)
MOIC does not account for the time value of money.
2. Internal Rate of Return (IRR)
where:
- = cash flow at time (negative for capital calls, positive for distributions)
- = total number of periods
- = the rate that makes NPV of all cash flows equal to zero
IRR accounts for both the magnitude and timing of cash flows.
3. Management Fee
where:
- Fee rate = annual percentage, typically 1.5%—2.0%
- AUM = assets under management (or committed capital during investment period)
During investment period: Fee base is often committed capital After investment period: Fee base is often invested capital or NAV
4. Performance Fee — Hard Hurdle
where:
- Fee rate = performance fee percentage (typically 20%)
- Return = actual fund return
- Hurdle rate = minimum return threshold (typically 6%—8%)
- Only applied when
- GP earns fee only on the excess return above the hurdle
5. Performance Fee — Soft Hurdle
where:
- Fee rate = performance fee percentage (typically 20%)
- Total return = full return of the fund
- Only applied when
- If hurdle is met, GP earns fee on the entire return (not just excess)
6. Net Return
where:
- Gross return = total return on investments before fees
- Net return = return actually received by LPs
7. Commodity Futures Pricing
where:
- = futures price at time 0
- = spot price at time 0
- = risk-free rate
- = time to expiration (in years)
- Storage costs = cost of physically storing the commodity
- Convenience yield = benefit from holding the physical commodity (e.g., avoiding supply disruptions)
8. Contango and Backwardation
| Condition | Relationship | Implication |
|---|---|---|
| Contango | Storage costs exceed convenience yield; negative roll yield | |
| Backwardation | Convenience yield exceeds storage costs; positive roll yield |
- Roll yield in contango: negative (selling low, buying high when rolling contracts)
- Roll yield in backwardation: positive (selling high, buying low when rolling contracts)
9. Capitalization Rate (Real Estate)
where:
- NOI = Net Operating Income = Rental income Operating expenses (excluding financing costs and depreciation)
- Property value = current market value or purchase price
Rearranged to find value:
A lower cap rate implies higher property value (and vice versa). Cap rate is analogous to an earnings yield for real estate.