Intercompany Loan: Northwind Holdings LLC

Intercompany Loan: Northwind Holdings LLC

Active T3 Private Credit Tax history → Tax tracker
Total Invested
$2,000,000
S
FMV
$2,000,000
as of Sep 30, 2026
S
Unrealized P&L
$0
C
Lifetime ROI
11.5%
C
Capital Stack Breakdown
Component Amount Tag
Initial Investment Components
Initial Cash $2,000,000 S
= Initial Investment $2,000,000 C
Capital Activity
= Total Invested Capital $2,000,000 C
Hale Share (100.0%) $2,000,000 C
Scope
Rolled up across 2 investment rows sharing the deal name “Intercompany Loan: Northwind Holdings LLC”: #1034 Northwind Family LP · #1035 Northwind Holdings LLC
Workbook ledger through Oct 1, 2026, QBO after it. Only postings in a distribution or capital-deployment account appear; ordinary GL activity does not.
Contributions
$-4,000,000
2 postings · capital contribution + loan
Distributions
$230,000
operations + capital + synd
Cash In / Out
$230,000 / $-4,000,000
by sign, ignoring the bucket
Net
$-3,770,000
12 postings
✓ Foots to the Total Returns KPI — the rows below add to $230,000. Both figures count the same postings, so this checks the itemisation across all 2 rows in scope — nothing dropped, nothing counted twice — not the figure itself.
Transaction Ledger Export .xlsx ↓ Search all QB →
DateLedgerBucketCategory TypeNumPayeeMemo ClassEntityInv #Amount
10/01/2026 Workbook Operations Distribution - Interest Deposit 59796 Northwind Family Office Q3 2026 interest NWLP Northwind Family LP 1034 $23,000
07/01/2026 Workbook Operations Distribution - Interest Deposit 58632 Northwind Family Office Q2 2026 interest NWLP Northwind Family LP 1034 $23,000
04/01/2026 Workbook Operations Distribution - Interest Deposit 81883 Northwind Family Office Q1 2026 interest NWLP Northwind Family LP 1034 $23,000
01/01/2026 Workbook Operations Distribution - Interest Deposit 76538 Northwind Family Office Q4 2025 interest NWLP Northwind Family LP 1034 $23,000
10/01/2025 Workbook Operations Distribution - Interest Deposit 18001 Northwind Family Office Q3 2025 interest NWLP Northwind Family LP 1034 $23,000
07/01/2025 Workbook Operations Distribution - Interest Deposit 53682 Northwind Family Office Q2 2025 interest NWLP Northwind Family LP 1034 $23,000
04/01/2025 Workbook Operations Distribution - Interest Deposit 83646 Northwind Family Office Q1 2025 interest NWLP Northwind Family LP 1034 $23,000
01/01/2025 Workbook Operations Distribution - Interest Deposit 56553 Northwind Family Office Q4 2024 interest NWLP Northwind Family LP 1034 $23,000
10/01/2024 Workbook Operations Distribution - Interest Deposit 83355 Northwind Family Office Q3 2024 interest NWLP Northwind Family LP 1034 $23,000
07/01/2024 Workbook Operations Distribution - Interest Deposit 49685 Northwind Family Office Q2 2024 interest NWLP Northwind Family LP 1034 $23,000
01/02/2024 Workbook Investments Loan Deposit 77227 Northwind Family LP Intercompany advance received NWH Northwind Holdings LLC 1035 $-2,000,000
01/02/2024 Workbook Investments Loan Check 26419 Northwind Family Office Loan funded NWLP Northwind Family LP 1034 $-2,000,000
Total (12 postings) $-3,770,000
Ownership Metrics
% of Deal Owned by Legal Entity 100.0%
Ownership % per OA 100.0%
Best Available Ownership % 100.0%
Effective Deal Ownership % 100.0%
% of Investor Owned by Hale 100.0%
% of Deal Owned by Hale 100.0%
Entity Chain (1 tiers)
Tier 1
Northwind Family LP
Ownership
100.0%
Total Returns
$230,000
click for detail
Capital
—
click for detail
Operations
$230,000
click for detail
ROI
11.5%
click for detail
Ann. ROI
4.0%
click for detail
IRR
4.2%
click for detail
Eq. Multiple
1.11x
click for detail
# Distributions
10
click for detail
Total Returns — Backup Calculation
Capital Returns$0
Operations Returns$230,000
= Total Returns (Capital + Operations) $230,000
Sum of all Capital-type and Operations-type distributions received.
Capital Returns — Backup
= Total Capital Returns $0
Loan repayments, return of capital, sale proceeds.
Operations Returns — Backup
10/01/2026 $23,000
07/01/2026 $23,000
04/01/2026 $23,000
01/01/2026 $23,000
10/01/2025 $23,000
07/01/2025 $23,000
04/01/2025 $23,000
01/01/2025 $23,000
10/01/2024 $23,000
07/01/2024 $23,000
= Total Operations Returns $230,000
Income distributions, interest, dividends.
ROI — Backup Calculation
Total Returns $230,000
Invested Basis $2,000,000
= Lifetime ROI 11.5%
Formula: Total Returns ÷ Invested Basis
Branch taken: Denominator is the imported Excel value (col 85, xlsx_total_invested_capital), not the component sum.
Returns as a share of capital at risk. This is a simple ratio, not time-weighted — see IRR for the time-weighted view.
Source: services/distribution_service.py → compute_roi()
Annualized ROI — Backup Calculation
Lifetime ROI 11.5%
Holding Period 2.77 yrs
= Annualized ROI 4.0%
Formula: (1 + Lifetime ROI) ^ (1 ÷ Holding Period) − 1
Compound annual rate, not ROI ÷ years. A total loss annualises to −100% however long it was held; a growth factor below zero has no real root, so the metric is left blank rather than shown as a complex number.
Source: services/distribution_service.py → compute_annualized_roi()
IRR (XIRR) — Backup Calculation
Initial Investment (01/02/2024) -$2,000,000
Operations — 10/01/2026 $23,000
Operations — 07/01/2026 $23,000
Operations — 04/01/2026 $23,000
Operations — 01/01/2026 $23,000
Operations — 10/01/2025 $23,000
Operations — 07/01/2025 $23,000
Operations — 04/01/2025 $23,000
Operations — 01/01/2025 $23,000
Operations — 10/01/2024 $23,000
Operations — 07/01/2024 $23,000
Terminal Value (FMV or Invested, today) $2,000,000
= XIRR 4.2%
XIRR computed using mid-month (15th) assumption for distribution dates. Red = outflows, green = inflows.
Equity Multiple — Backup Calculation
Total Returns $230,000
Initial Investment $2,000,000
= Equity Multiple 1.11x
Formula: (Total Returns + Initial Investment) ÷ Initial Investment
Note the denominator is INITIAL investment, not the invested basis ROI uses — the two metrics deliberately divide by different figures, so they will not reconcile to each other on rows where the two differ.
Source: services/distribution_service.py → compute_equity_multiple()
Distribution Count — Breakdown
Capital Distributions0
Operations Distributions10
Other0
= Total Count 10
Avg per Distribution$23,000
Cumulative Distributions Over Time
Distribution Summary by Date Received
Year Month # Distributions Total Amount Types
2026 4 $92,000
Oct 2026 1 $23,000 Operations
Jul 2026 1 $23,000 Operations
Apr 2026 1 $23,000 Operations
Jan 2026 1 $23,000 Operations
2025 4 $92,000
Oct 2025 1 $23,000 Operations
Jul 2025 1 $23,000 Operations
Apr 2025 1 $23,000 Operations
Jan 2025 1 $23,000 Operations
2024 2 $46,000
Oct 2024 1 $23,000 Operations
Jul 2024 1 $23,000 Operations
TOTAL 10 $230,000
Complete Distribution History
Date Received Period Type Amount Notes
10/01/2026 2026-10 Operations $23,000
07/01/2026 2026-07 Operations $23,000
04/01/2026 2026-04 Operations $23,000
01/01/2026 2026-01 Operations $23,000
10/01/2025 2025-10 Operations $23,000
07/01/2025 2025-07 Operations $23,000
04/01/2025 2025-04 Operations $23,000
01/01/2025 2025-01 Operations $23,000
10/01/2024 2024-10 Operations $23,000
07/01/2024 2024-07 Operations $23,000
TOTAL $230,000
Performance History
As Of Date Total Returns Lifetime ROI Annualized ROI IRR Equity Multiple
Historic snapshots, last written Sep 30, 2026 — not the live figures shown above. Some early rows carry values that were never right; they are kept as a record of what was reported at the time.
09/30/2026 $230,000 11.5% 4.0% 4.0% 1.11x
Sections
34/75 answered · 45.3%
Deal Info 18/23 answered
DEAL ID 16/20
Investment # (column) 1,034
Date of Investment (column) 1/2/2024
Holding Period (Years) (formula) 2.7699
Name of Investment (column) Intercompany Loan: Northwind Holdings LLC
Legal Name of Investment (column) Northwind Family LP
Asset Type (column) Private Credit
Asset Sub-Type (column) Line of Credit
City (column) Charlotte
State (column) NC
ZIP (document) —
Geography (document) —
Investing Entity (column) Northwind Family LP
Role (GP / LP) (column) Lender
Partners (document) —
Entity that Owns the Deal (column) Northwind Family LP
Ownership % (column) 100.00%
Initial Investment (column) 2,000,000
Total Invested Capital (formula) 2,000,000
MH / AK Code (column) —
Deal Manager (column) Casey Lin
Investment Info (ALL) 2/3
Strategy / Thesis (column)
Current Stage (column)
Projected Returns (document) —
Loan 12/27 answered
Loan 12/27
Original Maturity Date 1/2/2034 source ↗ confirmed
Extension Option / Excercised (document) —
Extended Maturity Date (formula) —
Loan Amount - Total $2,000,000 source ↗ confirmed
Loan Amount - Our Share (formula) —
Rate 4.40% fixed source ↗ confirmed
Default Rate (document) —
Points (document) —
Extension Fee (document) —
Exit Fee (document) —
Interest Reserve (document) —
Prepayment Terms Prepayable at any time without premium source ↗
Late Fee Terms (document) —
Interest Payment Frequency Annually source ↗
Principal Payment Frequency At maturity source ↗ confirmed
Payment Due Dates December 31 each year source ↗ confirmed
Last Expected Payment ($) $88,000.00 source ↗ confirmed
Last Expected Payment Date 12/31/2025 source ↗ confirmed
Last Payment ($) —
Last Payment Date —
Next Expected Payment ($) $88,000.00 source ↗ confirmed
Next Expected Payment Date 12/31/2026 source ↗
Repayment Status (formula) —
Missing Amount (formula) —
Collateral Unsecured source ↗ confirmed
Personal Guarantors (document) —
Profit-Share Rider (document) —
Tax 3/5 answered
Tax 3/5
Initial Tax Year Expected (formula) 2,024
Tax Document Expected (column) 1099-INT
Tax Preparer (column) —
Contact for K1 (column) Casey Lin
FEIN / Account # (column) —
Legal 1/6 answered
Legal 1/6
OA Status (column) Executed
Preferred Return (document) —
LP / GP Split (document) —
GP Ownership (document) —
Pref / Split Note (document) —
Side Letter —
Reporting & Docs 0/14 answered
FS / Document Filing / Reporting 0/14
OA (document) —
Loan Docs (loan) - tbd if separate (document) —
Closing Statement (RE) (document) —
OM (document) —
UW (document) —
General Reporting Frequency —
Accounting Basis (Cash, Accrual) —
P&L Frequency —
Balance Sheet Frequency —
Collections Report Frequency —
Rent Roll Frquency —
GL Frequency —
Investor Report Frequency —
Capital Account Frequency —
Capital Summary
Initial Investment
$2,000,000
S
Committed
$2,000,000
S
Current Cash
—
S
Total Invested
$2,000,000
C
Entities
Entity Owning Deal
Northwind Family LP
Investing Entity
Northwind Family LP
Tax Reporting Entity
Northwind Family LP
Quick Links
Distributions
Performance
Tax Docs
No property details available
Total Returns
$230,000
C
Capital
$0
C
Operations
$230,000
C
Lifetime ROI
11.5%
C
Annualized ROI
4.0%
C
IRR
4.2%
C
Equity Multiple
1.11x
C
# Distributions
10
Total Returns — Backup Calculation
Capital Returns $0
Operations Returns $230,000
Total Returns $230,000
Sum of all Capital + Operations distribution records for this investment.
Capital Returns — Backup Calculation
Sum of all distribution records where type = "Capital".
$0
Operations Returns — Backup Calculation
Sum of all distribution records where type = "Operations".
$230,000
Lifetime ROI — Backup Calculation
Total Returns (numerator) $230,000
Total Invested Capital (denominator) $2,000,000
ROI = Returns / Invested 11.5%
Formula: Total Distributions / Total Invested Capital × 100
Annualized ROI — Backup Calculation
Lifetime ROI 11.5%
Investment Date 01/02/2024
Years Held 2.8 yrs
Annualized ROI 4.0%
Formula: Lifetime ROI / Years Held
IRR — Backup Calculation
Initial Investment (outflow) -$2,000,000
10/01/2026 — Operations $23,000
07/01/2026 — Operations $23,000
04/01/2026 — Operations $23,000
01/01/2026 — Operations $23,000
10/01/2025 — Operations $23,000
07/01/2025 — Operations $23,000
04/01/2025 — Operations $23,000
01/01/2025 — Operations $23,000
10/01/2024 — Operations $23,000
07/01/2024 — Operations $23,000
Terminal Value (Current FMV) $2,000,000
IRR (XIRR) 4.2%
XIRR calculation using actual cash flow dates. Investment outflow → Distribution inflows → Terminal FMV (if active).
Equity Multiple — Backup Calculation
Total Distributions $230,000
Current FMV $2,000,000
Total Invested Capital (denominator) $2,000,000
Equity Multiple 1.11x
Formula: (Total Distributions + Current FMV) / Total Invested Capital
# Distributions — Details
10 distribution records on file.
Latest: 10/01/2026 — Operations: $23,000
Performance History
As Of Date Total Returns Lifetime ROI Annualized ROI IRR Equity Multiple
09/30/2026 $230,000 11.5% 4.0% 4.0% 1.11x
Distribution Summary
Total Distributions $230,000
YTD Distributions $92,000
Distribution Count 10
Latest 2026-10
Financial Statement Coverage — have vs need, from the Documents app
Loading coverage…
Statement coverage comes from the Documents app, which isn't connected in this demo.
Available Financial Statements — from the Documents app
Loading documents…
Statement coverage comes from the Documents app, which isn't connected in this demo.
Tax Documents — by Year (this entity)
2025 (1)
1099-INT · Northwind Family LP Rcvd 03/22/26 View
2024 (1)
1099-INT · Northwind Family LP Rcvd 03/24/25 View
Cross-Reference Tracking
Distribution Applicable Yes
Tax Tracker Yes
FS Tracker No
REO (Property) No
Shared Expenses No
Annual Report No
Syndicated Entities No
Loan Tracker No
Exchange Tracker No
Investment Notes
No notes recorded.
Investment Status
OA Status Executed
Amount per OA —
Static demo · synthetic data · read-only  ↩