IC Loans - Current Solutions & Workarounds¶

Tools & Systems¶

What it is: Multi-tab Excel workbook tracking all IC loans
How they use it:
Summary tab with all loans: lender, borrower, currency, maturity, balance, notional, rate
Individual loan tabs with detailed interest calculations
Interest rates tab pulling benchmark rates from Bloomberg
Conditional formatting for maturity alerts (30 days out)
Limitations: Manual rate updates, formula maintenance, grows unwieldy at scale (60+ loans)
Used by: Uber (Gurjit's experience)

What it is: Financial data terminal for benchmark rates
How they use it: Pull benchmark rates (LIBOR, CDOR, EURIBOR, etc.) on first business day of month
Limitations: Manual process, requires Bloomberg subscription
Used by: Uber

What it is: TMS module for intercompany loan management
How they use it: Attempted implementation via RFP process
Limitations: "Complete mess", unintuitive interface, accounting/tax teams refused to use it
Used by: Attempted at Uber, abandoned

What they do: First business day of month, pull all benchmark rates from Bloomberg, update interest rates tab, formulas calculate new rates for each loan
Why: No automated rate feed integration
Source: Palm Internal (2025-12-02)

What they do: Export loan summary, send to accounting, accounting matches loan draws to bank movements, books entries
Why: Accounting needs to confirm treasury data before booking
Source: Palm Internal (2025-12-02)

What they do: In November, generate report of all accrued interest due by Dec 31, kick off payments with required documentation
Why: Loan agreements require annual interest settlement
Source: Palm Internal (2025-12-02)

What they do: Conditional formatting turns cell red when loan expires in <30 days
Why: Need lead time to prepare amendments or arrange repayment
Source: Palm Internal (2025-12-02)

What they do: When subsidiary builds cash balance, check if loan can be repaid and closed
Why: Reduce portfolio complexity, get money back to central treasury
Source: Palm Internal (2025-12-02)