Balance Sheet Circularity in 3-Statement Models

Circularity is the single most common technical stumbling block in 3-statement modeling interviews — and one of the most misunderstood. It sounds intimidating, but the underlying logic is straightforward: certain line items depend on each other in a loop, and Excel needs help breaking (or iterating through) that loop. Understanding why circularity exists, where it shows up, and how to handle it separates candidates who've built real models from those who've only watched tutorials.

What circularity actually is

A circular reference occurs when a cell's value depends on itself, directly or indirectly:

Interest Expense → depends on → Debt Balance
Debt Balance     → depends on → Cash Flow
Cash Flow        → depends on → Interest Expense  ← loop

In a 3-statement model, this loop typically runs through the revolver (revolving credit facility) and the cash balance:

1. The model calculates net income and cash flow from operations
2. Cash flow determines whether the revolver needs to be drawn (if cash falls below a minimum) or swept (if cash exceeds the minimum)
3. The revolver balance determines interest expense
4. Interest expense flows back to net income, which affects cash flow — back to step 1

This is a genuine circular reference, not a modeling error. It's inherent to how revolvers work in real life.

Where circularity shows up

1. Revolver (most common in 3-statement models)

IF Ending Cash < Minimum Cash:
    Revolver Draw = Minimum Cash − Ending Cash (before revolver)
    Ending Cash = Minimum Cash
ELSE:
    Revolver Repayment = MIN(Revolver Balance, Excess Cash above Minimum)
    Ending Cash = Cash Flow + Revolver Change

Interest on the revolver = Average Revolver Balance × Rate. If you use average balance (beginning + ending) / 2, you have circularity because ending balance depends on interest, which depends on average balance.

2. Cash sweep in LBO models

Same root cause as the revolver, but in the debt schedule:

Cash Available for Sweep = EBITDA − Interest − Taxes − Capex − NWC Change
Interest = f(Debt Balance)
Debt Paydown = Cash Available for Sweep
Debt Balance = Previous Balance − Paydown

Interest depends on debt; debt paydown depends on cash flow; cash flow depends on interest.

3. Circular depreciation (less common, more advanced)

If PP&E is a function of capex minus depreciation, and depreciation is a function of PP&E, you have a circular loop in the PP&E schedule. Most models avoid this by using beginning-of-period PP&E for depreciation.

Two standard fixes

Fix 1: Enable iterative calculation (the "real model" approach)

In Excel: File → Options → Formulas → Enable iterative calculation. Set maximum iterations to 100 and maximum change to 0.001.

The model will iterate through the circular loop until the values converge — interest, revolver balance, and cash flow all stabilize at consistent numbers.

Always add a circularity breaker:

Circularity Switch: 1 = ON (normal), 0 = OFF (breaks the loop)
Interest Expense = IF(Circularity Switch = 1, Calculated Interest, 0)

If a formula breaks and the model spirals into #REF! errors, flip the switch to 0. Interest goes to zero, the loop breaks, and you can debug without the circular reference masking the real error. This is standard practice on every banking model — not optional.

Fix 2: Use beginning-of-period balances (the "clean model" approach)

Calculate interest off the beginning debt/revolver balance, not the average or ending balance:

Interest Expense = Beginning Revolver Balance × Interest Rate

This eliminates circularity entirely because beginning balance is known from the prior period — it doesn't depend on current-period interest.

Tradeoff: Slightly less precise (interest should technically be on the average balance), but the error is small (typically less than 1% of interest expense) and the model is non-circular, faster, and easier to debug. This is the standard approach for:

• Interview models (timed exercises)
• Paper LBOs
• Quick sensitivity analysis
• Any model where precision debt scheduling isn't the primary purpose

When to use which fix

| Situation | Recommended Approach | |-----------|---------------------| | Full 3-statement model for a live deal | Iterative calculation + circularity breaker | | LBO model with detailed debt schedule | Iterative calculation + circularity breaker | | Timed interview model (45–90 min) | Beginning-of-period interest (no circularity) | | Paper LBO / mental math | Beginning-of-period interest | | Sensitivity tables / scenario analysis | Beginning-of-period (faster, non-circular) |

How to explain circularity in an interview

The clean answer:

"A revolver creates circularity because the ending cash balance depends on interest expense, which depends on the revolver balance, which depends on the ending cash balance. I handle it two ways: in a full model, I enable iterative calculation with a circularity breaker switch so I can debug without the loop masking errors. In a quick model or interview setting, I calculate interest off the beginning-of-period balance, which eliminates the circularity with minimal precision loss."

Then be ready for the follow-up: "What's the precision difference?"

Beginning-of-period vs. average-balance interest on a $100M revolver at 5% with moderate draw/repay activity: difference is typically $50K–$200K on $5M of annual interest — less than 4%. For a $500M EV company, this is immaterial.

The revolver build (step by step)

Here's the non-circular revolver logic used in most interview models:

Step 1: Calculate cash flow before revolver
  Cash Flow Before Revolver = Operating CF + Investing CF + Financing CF (ex-revolver)

Step 2: Calculate preliminary ending cash
  Preliminary Cash = Beginning Cash + Cash Flow Before Revolver

Step 3: Determine revolver activity
  IF Preliminary Cash < Minimum Cash:
    Revolver Draw = Minimum Cash − Preliminary Cash
  ELSE IF Preliminary Cash > Minimum Cash AND Revolver Balance > 0:
    Revolver Repayment = MIN(Revolver Balance, Preliminary Cash − Minimum Cash)
  ELSE:
    Revolver Draw/Repayment = 0

Step 4: Calculate ending cash and revolver balance
  Ending Cash = Preliminary Cash + Revolver Draw − Revolver Repayment
  Ending Revolver = Beginning Revolver + Revolver Draw − Revolver Repayment

Step 5: Calculate interest (beginning balance method)
  Revolver Interest = Beginning Revolver Balance × Interest Rate

Step 6: Flow interest to income statement
  Interest Expense (total) = Revolver Interest + Term Loan Interest + ...
  Net Income = EBT − Taxes (where EBT includes interest)

Note: with beginning-balance interest, there's no circularity because Step 5 uses last period's revolver balance, which was set before this period's cash flow was calculated. The small imprecision (interest should reflect this period's draw/repay) is the accepted tradeoff.

Common interview questions

"Why does a revolver create circularity?" Ending cash depends on revolver draw/repay, which depends on cash flow, which depends on interest expense, which depends on revolver balance. It's a loop through the cash flow statement, balance sheet, and income statement simultaneously.

"How do you fix it?" Two ways: (1) enable iterative calculation with a circularity breaker for full models, or (2) use beginning-of-period balances for interest to eliminate the loop structurally. State which you'd use and why.

"What's a circularity breaker?" A toggle cell (1/0) that forces interest to zero when set to 0, breaking the circular loop so you can debug formula errors without the model spiraling into #REF! errors.

"Does circularity affect the balance sheet balance check?" If the model is set up correctly, Assets = Liabilities + Equity should still hold regardless of circularity handling. Circularity affects the magnitude of interest and revolver balances, not the structural integrity of the three-statement linkages. If your balance sheet doesn't balance, the problem is in the linkages (retained earnings, cash flow reconciliation), not the circularity fix.

"Is circularity the same in LBO models?" Same root cause — cash sweep creates the loop. Same fixes apply. LBO models more commonly use iterative calculation because precision debt scheduling matters for returns analysis.

The takeaway

Circularity isn't a bug — it's a feature of how revolvers and cash sweeps actually work. The interview skill is knowing that it exists, explaining why, and choosing the right fix for the context. Use iterative calculation with a breaker for production models; use beginning-of-period interest for timed exercises. Either way, demonstrate that you understand the loop — not just that you've heard the word.