Imported from arjundrath-star/klade-analyst (clients/_archived/alexander-wysk/skills/subscription-line-analyzer/SKILL.md). Install upstream with npx skills add arjundrath-star/klade-analyst --skill subscription-line-analyzer. Copyright stays with the author.

subscription-line-analyzer

Analyze subscription line facilities (also called capital call facilities or subscription credit facilities) used by PE, VC, and real estate funds. Subscription lines have become nearly universal in private funds — over 90% of PE funds use them — but they are one of the most misunderstood tools in fund finance. A sub line bridges the gap between investment deployment and LP capital calls, providing operational convenience but also inflating reported IRR by delaying the start of the IRR clock. This skill quantifies the true impact: how much does the sub line improve reported returns, what are the real economics, and what should LPs know?

Trigger

• "Analyze subscription line for [FUND]"
• "Sub line impact on IRR"
• "Capital call facility analysis"
• "Subscription credit facility terms"
• "Sub line leverage and reporting"
• "IRR with and without subscription line"
• "LP capital call bridging analysis"
• "Fund finance facility review"

Inputs

Required

• Fund size: total committed capital
• Sub line size: facility amount (typically 15-30% of commitments)
• Facility terms: interest rate (spread + base), commitment fee, maturity
• Usage pattern: average outstanding balance, drawdown periods, repayment timing
• Fund cash flows: capital calls (with and without sub line timing)

Optional

• Eligible LP commitments: borrowing base calculation (which LPs count as collateral)
• Advance rate: percentage of eligible commitments available for borrowing
• Financial covenants: LTV tests, minimum NAV, concentration limits
• Sub line lender: bank name and relationship context
• Fund performance data: actual IRR/MOIC with and without sub line adjustment
• LP notification provisions: advance notice for capital calls
• Recycling provisions: interaction between sub line and recycling
• Multi-tranche structure: revolving vs term, working capital vs bridge
• Guarantee structure: several vs joint, LP exclusion criteria
• ILPA guidance compliance: alignment with ILPA subscription line principles

⚠️ DATA SOURCING MANDATE (NON-NEGOTIABLE)

1. Facility Agreement (PRIMARY):

   • All terms must come from the actual credit agreement or term sheet
   • Borrowing base mechanics, covenants, and pricing from facility documents

2. Fund Cash Flow Records (PRIMARY):

   • Actual capital call dates and amounts (with and without sub line)
   • Sub line drawdown and repayment dates and amounts

3. FRED API (for base rates):

   • web_fetch("https://api.stlouisfed.org/fred/series/observations?series_id=SOFR&api_key=${FRED_API_KEY}&file_type=json&limit=1&sort_order=desc")
   • web_fetch("https://api.stlouisfed.org/fred/series/observations?series_id=DFF&api_key=${FRED_API_KEY}&file_type=json&limit=1&sort_order=desc")
   • Use for: SOFR, Fed Funds rate (base rate for sub line pricing)

4. web_search (SUPPLEMENTARY):

   • web_search("subscription line facility PE fund terms pricing [YEAR]")
   • web_search("ILPA subscription line guidance recommendations")
   • web_search("subscription line impact IRR PE fund research")
   • web_search("capital call facility market terms spread [YEAR]")

Methodology

Step 1: Facility Structure Analysis

Document the complete facility terms:

Subscription Line Facility Summary:
| Parameter                | Value                                  |
|--------------------------|----------------------------------------|
| Borrower                 | [Fund Name LP]                         |
| Lender(s)                | [Bank name(s)]                         |
| Facility Size            | $[XX]M                                 |
| % of Commitments         | [XX]%                                  |
| Base Rate                | [SOFR / Fed Funds / Prime]             |
| Spread                   | [XXX] bps                              |
| All-In Rate (current)    | [X.XX]%                                |
| Commitment Fee           | [XX] bps on unused                     |
| Maturity                 | [X] years (renewable)                  |
| Advance Rate             | [XX]% of eligible commitments          |
| Clean-Down Provision     | [X] days per year at $0 outstanding    |
| Maximum Tenor per Draw   | [XXX] days                             |
| Security                 | Uncalled capital commitments of LPs    |

Borrowing Base Calculation:

| LP Class              | Commitment | Eligible? | Advance Rate | Borrowing Base |
|-----------------------|-----------|-----------|-------------|---------------|
| Pension Funds         | $[XX]M    | Yes       | [XX]%       | $[XX]M        |
| Sovereign Wealth      | $[XX]M    | Yes       | [XX]%       | $[XX]M        |
| Insurance Companies   | $[XX]M    | Yes       | [XX]%       | $[XX]M        |
| Family Offices        | $[XX]M    | Partial   | [XX]%       | $[X]M         |
| Fund-of-Funds         | $[XX]M    | Yes       | [XX]%       | $[XX]M        |
| High Net Worth        | $[X]M     | Excluded  | 0%          | $0            |
| Total Commitments     | $[XXX]M   |           |             |               |
| Eligible Commitments  | $[XXX]M   |           |             |               |
| Total Borrowing Base  |           |           |             | $[XX]M        |
| Facility Size (lesser)| $[XX]M    |           |             |               |

Step 2: Sub Line Usage Analysis

Model how the sub line is actually used:

Sub Line Usage Pattern:
| Period | Investment | Sub Line Draw | Sub Line Repay | Outstanding | LP Call (Actual) | LP Call (w/o Sub) |
|--------|-----------|--------------|----------------|-------------|-----------------|-------------------|
| Q1 Yr1 | $[XX]M    | $[XX]M       | $0             | $[XX]M      | $0              | $[XX]M            |
| Q2 Yr1 | $[XX]M    | $[XX]M       | $0             | $[XX]M      | $0              | $[XX]M            |
| Q3 Yr1 | $0        | $0           | ($[XX]M)       | $0          | $[XX]M          | $0                |
| Q4 Yr1 | $[XX]M    | $[XX]M       | $0             | $[XX]M      | $0              | $[XX]M            |
| Q1 Yr2 | $0        | $0           | ($[XX]M)       | $0          | $[XX]M          | $0                |

Usage Metrics:

Average Outstanding:           $[XX]M
Peak Outstanding:              $[XX]M
Average Days Outstanding:      [XX] days per draw
Number of Draws:               [XX] per year
Annual Interest Cost:          $[XXX]K
Annual Commitment Fee:         $[XX]K
Total Annual Cost:             $[XXX]K
Cost as % of Fund Size:        [X.XX]%
Cost as % of NAV:              [X.XX]%

Step 3: IRR Impact Analysis (THE KEY DELIVERABLE)

This is what LPs care about most — how much does the sub line inflate reported IRR?

Method: Calculate IRR with and without sub line timing:

With Sub Line (Reported):

LP cash flows start when LP actually sends money (delayed by sub line bridge)
| Date    | LP Cash Flow | Type                    |
|---------|-------------|-------------------------|
| [Date]  | ($[XX]M)    | Capital call (repay sub) |
| [Date]  | ($[XX]M)    | Capital call (repay sub) |
| [Date]  | $[XX]M      | Distribution             |
| [Date]  | $[XX]M      | Distribution             |
| ...     | ...         | ...                      |
Reported IRR: [XX.X]%

Without Sub Line (Adjusted):

LP cash flows start when fund actually invests (as if LP funded directly)
| Date    | LP Cash Flow | Type                    |
|---------|-------------|-------------------------|
| [Date]  | ($[XX]M)    | Direct funding (earlier) |
| [Date]  | ($[XX]M)    | Direct funding (earlier) |
| [Date]  | $[XX]M      | Distribution             |
| [Date]  | $[XX]M      | Distribution             |
| ...     | ...         | ...                      |
Adjusted IRR: [XX.X]%

IRR Inflation Summary:

| Metric              | With Sub Line | Without Sub Line | Difference |
|---------------------|--------------|-----------------|------------|
| Gross IRR           | [XX.X]%      | [XX.X]%         | +[X.X]pp   |
| Net IRR             | [XX.X]%      | [XX.X]%         | +[X.X]pp   |
| Gross MOIC          | [X.Xx]       | [X.Xx]          | +[X.XX]    |
| Net MOIC            | [X.Xx]       | [X.Xx]          | ≈ same     |
| DPI                 | [X.Xx]       | [X.Xx]          | ≈ same     |
| TVPI                | [X.Xx]       | [X.Xx]          | ≈ same     |

Key insight: Sub lines primarily affect IRR (which is time-weighted). MOIC, DPI, and TVPI are largely unaffected because total dollars in/out don't change materially (small interest cost aside). The IRR inflation comes from shortening the measured holding period for LP capital.

Step 4: IRR Inflation by Usage Pattern

Show how different usage patterns affect the IRR boost:

IRR Inflation Sensitivity:
| Average Days Bridged | IRR w/ Sub | IRR w/o Sub | Inflation | Interest Cost |
|---------------------|-----------|------------|-----------|---------------|
| 30 days             | [XX.X]%   | [XX.X]%    | +[X.X]pp  | $[XX]K        |
| 60 days             | [XX.X]%   | [XX.X]%    | +[X.X]pp  | $[XX]K        |
| 90 days             | [XX.X]%   | [XX.X]%    | +[X.X]pp  | $[XXX]K       |
| 180 days            | [XX.X]%   | [XX.X]%    | +[X.X]pp  | $[XXX]K       |
| 365 days            | [XX.X]%   | [XX.X]%    | +[X.X]pp  | $[XXX]K       |

General rule of thumb:

• 30-60 days bridging: 50-150 bps IRR inflation
• 90-180 days bridging: 150-400 bps IRR inflation
• 365+ days bridging: 400-800+ bps IRR inflation (red flag for LP)

Step 5: Cost-Benefit Analysis

Quantify whether the sub line creates or destroys value:

Benefits:

| Benefit                              | Value                    |
|--------------------------------------|--------------------------|
| Operational convenience              | Qualitative — fewer, larger capital calls |
| Investment timing flexibility        | Qualitative — can move quickly on deals |
| LP cash management benefit           | $[XX]K (LP short-term yield on delayed capital) |
| Netting benefit                      | $[XX]K (avoid calling then distributing) |
| Total quantifiable LP benefit        | $[XX]K                   |

Costs:

| Cost                                 | Value                    |
|--------------------------------------|--------------------------|
| Interest expense (charged to fund)   | $[XXX]K/year             |
| Commitment fee                       | $[XX]K/year              |
| Legal/arrangement fees (amortized)   | $[XX]K/year              |
| IRR distortion (harder to assess GP) | Qualitative              |
| Carry impact (IRR-based hurdles)     | $[XX]K (higher carry from IRR inflation) |
| Total quantifiable cost              | $[XXX]K/year             |

Net Value Assessment:

Net Annual Cost to Fund:    $[XXX]K
Net Annual Cost per $100M:  $[XX]K
Impact on Net MOIC:         -[X.XX]x
Carry "Leakage" from IRR inflation: $[XX]K (if hurdle is IRR-based)

Step 6: Carry Impact Analysis

If the fund has an IRR-based hurdle, the sub line can accelerate carry:

Carry Impact of Sub Line:
| Scenario               | IRR    | Hurdle Met? | Carry Earned | Carry Diff |
|------------------------|--------|------------|-------------|-----------|
| With sub line          | [XX.X]%| Yes (>[X]%)| $[XX.X]M    | —         |
| Without sub line       | [XX.X]%| [Yes/No]   | $[XX.X]M    | $[X.X]M   |

If the sub line is the difference between hitting and missing the hurdle, this is a material LP concern.

Step 7: ILPA Compliance Assessment

Evaluate against ILPA Subscription Line Guidance:

ILPA Compliance Checklist:
| Guideline                                    | Status | Notes                |
|----------------------------------------------|--------|----------------------|
| Disclose sub line usage in LP reports        | [✅/❌] |                      |
| Report IRR both with and without sub line    | [✅/❌] |                      |
| Maximum facility tenor < [X] months          | [✅/❌] | Actual: [X] months   |
| Clean-down provision enforced                | [✅/❌] | [X] days/year        |
| Sub line costs borne by fund (not offset)    | [✅/❌] |                      |
| Borrowing base disclosed to LPAC             | [✅/❌] |                      |
| No use to fund distributions                 | [✅/❌] |                      |
| Annual facility review by LPAC              | [✅/❌] |                      |

Output Format

📊 Subscription Line Analysis — [Fund Name]
Prepared: [Date] | Fund Size: $[XXX]M | Facility Size: $[XX]M ([XX]% of commitments)
Lender: [Bank] | Rate: SOFR + [XXX] bps = [X.XX]% all-in

━━━ EXECUTIVE SUMMARY ━━━
[3-4 sentences: facility overview, IRR inflation quantified, cost-benefit conclusion, and key concerns]

The subscription line inflates reported IRR by approximately [X.X] percentage points ([XX.X]% reported vs [XX.X]% adjusted). This inflation [does / does not] affect whether the fund clears its [X]% preferred return hurdle. Annual facility cost of $[XXX]K ([X.XX]% of NAV) [is / is not] justified by operational benefits.

━━━ FACILITY TERMS ━━━
[Facility summary table from Step 1]

━━━ BORROWING BASE ━━━
[Borrowing base table from Step 1]

━━━ USAGE ANALYSIS ━━━
[Usage pattern table from Step 2]

━━━ IRR IMPACT ANALYSIS ━━━
[IRR with/without comparison from Step 3]

Key Finding: Sub line usage inflates reported Net IRR by [X.X] percentage points.

[IRR inflation sensitivity table from Step 4]

━━━ COST-BENEFIT ANALYSIS ━━━
[Benefits and costs tables from Step 5]

Conclusion: The subscription line [creates/destroys] approximately $[XX]K of net value annually for LPs.

━━━ CARRY IMPACT ━━━
[Carry impact analysis from Step 6]

The sub line [does / does not] affect carry economics. [If it does: the facility accelerates carry by approximately $[X.X]M, equivalent to [XX] bps of LP returns transferred to GP.]

━━━ ILPA COMPLIANCE ━━━
[ILPA checklist from Step 7]

Overall ILPA Alignment: [Strong / Moderate / Weak]
Key Gaps: [List any non-compliance items]

━━━ SENSITIVITY ANALYSIS ━━━
| Variable                | Bear    | Base    | Bull    |
|-------------------------|---------|---------|---------|
| SOFR Rate               | [X.X]%  | [X.X]%  | [X.X]%  |
| Average Days Outstanding| [XXX]   | [XX]    | [XX]    |
| Facility Utilization    | [XX]%   | [XX]%   | [XX]%   |
| Annual Interest Cost    | $[XXX]K | $[XXX]K | $[XX]K  |
| IRR Inflation           | [X.X]pp | [X.X]pp | [X.X]pp |

━━━ RECOMMENDATIONS ━━━
1. [Specific recommendation on facility size — right-sized or oversized?]
2. [Recommendation on usage pattern — operational bridge vs IRR enhancement?]
3. [Reporting recommendation — ILPA-compliant dual IRR reporting?]
4. [Carry impact mitigation — should hurdle be calculated on adjusted IRR?]

━━━ TRIPLE-THREAT LENS ━━━
🏦 Banker: [Fund finance advisory — is the facility competitively priced? Should the fund consider a multi-bank syndicate for larger facilities? Refinancing considerations at maturity. Covenant headroom analysis. Relationship value of the facility for the lending bank. Market trends in sub line pricing and terms.]
📊 Accountant: [Fund accounting — how is sub line interest allocated across the partnership? ASC 820 implications if sub line affects NAV timing. Tax treatment of interest expense (fund-level vs investor-level deduction). Impact on GAAP vs ILPA reporting. Audit considerations for sub line disclosure.]
💰 Wealth Manager: [LP perspective — is the LP being shown an inflated IRR? How does adjusted IRR compare to the LP's hurdle rate and benchmark? Should the LP request dual IRR reporting? Is the LP's capital commitment being used as collateral without adequate disclosure? For LP portfolio modeling, should reported IRR or adjusted IRR be used for allocation decisions?]

━━━ SOURCES & ASSUMPTIONS ━━━
- Facility terms: [Credit agreement / Term sheet / User-provided]
- SOFR rate: [FRED, as of date]
- Fund cash flows: [Actual / Modeled]
- IRR calculation: [XIRR on actual dates]
- ILPA guidance: [Version/date of ILPA Subscription Line Principles]

Quality Gates

• Facility terms completely documented (size, rate, advance rate, covenants, maturity)
• Borrowing base calculated with LP eligibility and advance rates
• IRR calculated BOTH with and without sub line timing (the essential deliverable)
• IRR inflation quantified in basis points with clear methodology
• Interest cost and commitment fees calculated and charged to fund
• Carry impact analyzed (does sub line affect whether hurdle is met?)
• Cost-benefit analysis includes both quantifiable and qualitative factors
• ILPA compliance checklist completed
• Sensitivity analysis covers rate changes and usage pattern variations
• Clean-down provision compliance verified
• No use of sub line to fund distributions (red flag check)
• All base rates sourced from FRED (not approximated)

Professional Standards

What separates A from B:

• A-grade: IRR inflation precisely calculated using actual cash flow dates (not approximated). Carry impact quantified through the waterfall. ILPA compliance assessed against current guidance. Cost-benefit includes carry leakage. Borrowing base mechanics understood and modeled. Recommendations are specific and actionable.
• B-grade: General statement that "sub lines inflate IRR" without quantification. No dual IRR reporting. No carry impact analysis. No ILPA compliance check. Interest cost mentioned but not analyzed relative to fund size/NAV.

Common pitfalls:

• Reporting only with-sub-line IRR without the adjusted figure (misleading to LPs)
• Ignoring carry impact — if the sub line helps clear an IRR hurdle, it transfers economics from LP to GP
• Treating sub line usage as "free" — interest costs are real fund expenses
• Not checking ILPA compliance — increasingly expected by institutional LPs
• Confusing IRR inflation with value creation — the sub line doesn't create returns, it compresses the time measurement
• Not distinguishing operational bridging (30-60 days, reasonable) from IRR enhancement (180+ days, concerning)
• Ignoring the borrowing base — if key LPs default or are excluded, facility availability can shrink

See Also

• carried-interest-calculator — carry impact when sub line affects IRR-based hurdles
• distribution-waterfall — integration of sub line timing into waterfall calculations
• fund-admin-reconciler — reconcile sub line balances between admin and internal books
• monthly-investor-letter — disclosure of sub line usage in LP communications