Financial Modeling Test: What US Summer Analysts Need to Know

Ace the Financial Modeling Test: A Practical Playbook

A financial modeling test is a timed exercise that produces a working Excel model and a short memo or slides. It checks whether you can turn limited data and a term sheet into decision-grade outputs under pressure, with correct US GAAP linkages and clean logic. In US recruiting, banks, private equity, and private credit use modeling tests to simulate the first 48-72 hours of a live deal.

Firms want signals of day-one effectiveness, and candidates want a fair screen that rewards disciplined builds and sound judgment. A strong test shows structure, speed, and the ability to tell a clear investment or credit story from messy inputs while minimizing execution risk.

What reviewers actually score and why it matters

The scoring rubrics converge on the same core abilities. You must tie accounting correctly, build a credible capital structure, make defensible calls, and package the answer clearly. Each area below tends to carry similar weight in hiring decisions.

US GAAP mechanics: Clean linkages across the income statement, balance sheet, and cash flow; working capital, leases, taxes, and stock-based compensation handled correctly for accuracy and auditability.
Capital structure logic: Interest and fees, waterfall behavior, revolver draw and paydown, and covenant math that align with the term sheet for true risk reflection.
Business judgment: Defensible assumptions, thoughtful EBITDA adjustments, and sensitivities that match how risk manifests in the case.
Auditability and speed: Clear layout, minimal hardcodes, robust checks, and fast navigation so a reviewer can verify your work quickly.
Communication: A tight memo or slides that state the decision, drivers, risks, and next steps in plain language.

Common test variants by seat and what to expect

Tests differ by role but share the same fundamentals. Knowing the likely format helps you budget time and avoid rework.

Investment banking coverage and M&A: A three-statement model, accretion or dilution, or a compact sell-side case with a DCF cross-check.
Private equity: An LBO from a CIM-style prompt with sources and uses, debt mechanics, returns, sensitivities, and a one-page view.
Private credit: A debt case with covenant math, SOFR-based interest, fees and amortization, liquidity, and downside protection.
Restructuring: A 13-week cash flow, a liquidity waterfall, and a priority-of-claims framing.
Infrastructure or project finance: DSCR modeling and sculpted amortization, though less common for US summer roles.

Formats, deliverables, and a build order that saves time

Typical test formats and timing

Proctored on-site: 60-120 minutes with a compact dataset and fixed outputs that emphasize speed.
Take-home: 3-6 hours with a CIM excerpt, a management case, and multiple asks that test breadth.
Live coding: 30-60 minutes focused on process and structure over completion.

Standard deliverables

Excel model: An assumptions tab, three statements, supporting schedules, and outputs. No external links. No macros unless allowed. Include a controlled circularity toggle only if necessary for interest.
Memo or slides: One page or two to five slides covering sources and uses, capital structure, key operating assumptions, valuation or returns, sensitivities, and risks.
Checks page: Balance and cash roll checks, circularity flags, scenario toggles, and covenant headroom.

Execution order that avoids rework

Start by reading instructions and confirming units, currency, and fiscal year-end. List required outputs. Then build in this sequence:

Spine: Time axis and scenario flags; inputs on an assumptions sheet only.
Income statement drivers: Revenue and gross margin; opex and D&A placeholders.
Working capital: A days-based working capital schedule tied to revenue and COGS, linked to the balance sheet and cash flow.
Capex and PP&E: Build a rollforward that ties to depreciation and cash.
Debt: Revolver and term loans with interest and fees, minimum cash, and cash sweep behavior.
Taxes: NOLs and 163(j) rules validated against pretax income and interest limits.
Transaction: Sources and uses, pro forma balance sheet, and ownership.
Outputs: Sensitivities, KPIs, and a dedicated checks tab.
Memo: Reconcile every figure to model outputs.

Mechanics that move cash and credibility

Accounting choices that matter

Working capital: Model receivables, inventory, and payables using days on revenue and COGS. Flow changes through cash from operations and tie to balance sheet lines to preserve cash accuracy.
Leases, ASC 842: Operating leases create right-of-use assets and liabilities with straight-line expense. Finance leases split interest and amortization. For credit comparisons, capitalize operating leases when leverage comparability matters.
Revenue and margins: Pick drivers that match the prompt, such as volume and price or mix. Keep margins independent of EBITDA add-backs or SBC to avoid circularity.
Stock-based compensation: Treat as noncash in EBITDA adjustments if asked, but keep GAAP integrity on the income statement.
Purchase accounting, ASC 805: For M&A or LBO pro formas, use goodwill as a plug. Amortize identifiable intangibles, and set deferred taxes on step-ups using reasonable lives.

Taxes that change cash flow

Statutory rates: Use a blended federal and state rate unless told otherwise.
Section 163(j): From 2022, the interest limit uses EBIT; disallowed interest carries forward. Flag cases where leverage makes deductibility binding.
NOLs: Post-2017 NOLs carry forward indefinitely but are limited to 80 percent of taxable income. Do not overcomplicate unless the prompt requires detail.
Valuation allowance: Assume no change unless losses persist beyond the forecast horizon.

Debt and flow of funds

SOFR setup: Model base rate plus spread with floors if present. Follow ARRC day count and lookback conventions for accuracy.
Fees and OID: Reduce proceeds at close and amortize to interest expense. Straight-line is acceptable if immaterial and allowed.
Revolver behavior: Borrow after minimum cash, amortization, and capex; include commitment fees on undrawn amounts; cap draws and prevent negatives.
Cash sweep: After required amortization and maintenance capex, sweep excess per priority. Revolvers are prepaid first if drawn.

If you want more context on sequencing and modeling trade-offs, this overview of debt scheduling is a useful complement to practice tests.

Covenants and credit metrics

Leverage ratios: Total Debt or First Lien Debt over EBITDA per the term sheet. Show quarterly headroom to reveal breach risk.
Coverage: Use the specified definitions, such as EBITDA minus capex or EBITDAR versus interest, and split cash versus PIK.
Fixed charge coverage: Include cash taxes, capex, and scheduled amortization when required.
Liquidity: Track minimum cash, revolver availability, springing tests, and the lowest headroom period.

Seat-specific modeling notes and shortcuts

PE LBO specifics

Sources and uses: Show equity, rollover, option pool, debt tranches, OID and fees, and uses to EV and cash. Reconcile to ownership. For structure clarity, review this line-by-line guide to LBO sources and uses.
Operating case: Build base, downside, and upside consistent with QofE cues for revenue growth, margin path, capex, and working capital.
Exit and valuation: Apply an exit multiple to final-year EBITDA. Avoid assuming multiple expansion without a reason. If time permits, add a simple DCF cross-check. For practice, see this LBO modeling framework.
Returns: Present gross IRR and MOIC by scenario, with an equity bridge for dividends or partial exits.

IB M&A specifics

Accretion or dilution: Share count accuracy beats flashy synergy math. Include purchase accounting for intangibles and amortization.
Synergies: Separate cost from revenue, ramp with one-time costs, and never bury synergies in base margins.
Pro forma balance sheet: Allocate consideration, debt paydown, and cash impact through sources and uses. Goodwill is the plug, and every line must balance.

Restructuring basics

13-week cash flow: Model receipts and disbursements weekly; beginning cash plus receipts minus disbursements equals ending cash; flag DIP borrowing and collateral coverage.
Priority of claims: Keep a clear waterfall of secured versus unsecured claims. Precision on valuation is secondary to payment order clarity.

IFRS versus US GAAP

Lease treatment: IFRS 16 puts most leases on balance sheet, lifting EBITDA relative to US GAAP operating lease treatment; note this when comparing leverage or EBITDA.
Revenue recognition: Long-term contract accounting can shift working capital and margins; flag material differences in cross-border deals.

Sensitivities that inform decisions and the quality bar

Decision-grade sensitivities

Two-way tables: For PE, show exit multiple versus EBITDA margin or revenue CAGR; for credit, revenue downside versus interest rate or capex versus DSCR, with IRR, MOIC, leverage, or covenant headroom as outputs. For setup tips, see sensitivity tables.
Scenario toggles: Use a single Base or Downside or Upside switch that drives operating and financing assumptions consistently.
Breakpoints: Identify covenant breaches and minimum liquidity points; highlight the lowest headroom period.

Quality controls that save your model

Balance and flow ties: Balance sheet balances each period; net income ties to cash flow; cash rolls correctly.
No buried hardcodes: Formulas trace to drivers; only inputs are colored and centralized. Consider an audit-ready inputs tab.
Constrained circularity: Allow one controlled loop for interest if needed and document the toggle.
Units and signs: Keep a single unit across the model and a consistent sign convention for cash flows and metrics.

Prompt adherence and non-GAAP discipline

Definitions: Use the prompt’s EBITDA, leverage, and cash interest definitions. Do not substitute rating agency adjustments unless asked.
SOFR specifics: Implement periods, reference rate, spreads, and floors exactly as stated.
Non-GAAP: Many prompts include adjusted EBITDA. Do not pass through unvetted adjustments or run-rate synergies unless contracted. If you cite Adjusted EBITDA, describe adjustments and avoid overemphasis relative to GAAP.

Communicating the answer: the memo that travels

Your memo or slides should read like a decision note, not a data dump. Lead with the call, then show the numbers that matter and the few diligence items that could change your view.

Lead with the decision: State invest or decline, and in one sentence say why.
Drivers and risks: List two or three drivers and two or three risks. Keep them specific and measurable.
One page of numbers: Sources and uses, opening capital structure, leverage path, returns or covenant headroom by scenario, and a two-way sensitivity.
Diligence roadmap: Focus on pipeline, churn, pricing power, supplier concentration, regulatory triggers, or accounting gray areas.

A crisp layout and quick navigation matter. Keyboard workflows and consistent formula anchors help you maintain speed; practice with Excel shortcuts and short formulas, not long nested IFs. If your base case uses a DCF sanity check, revisit your discount rate choice. This overview of DCF analysis inputs is a quick refresher.

Time plan, common kill tests, and governance

A realistic 2-3 hour take-home plan

0-10 minutes: Read all instructions and data, note units and fiscal year, and list required outputs.
60-75 minutes: Build the spine and schedules through debt and taxes.
20 minutes: Add scenarios and sensitivities.
30-40 minutes: Draft the memo or slides and reconcile to the model.
10-15 minutes: Run checks, spellcheck, set print areas, and name files cleanly.

Errors that fail candidates

Broken liquidity: Missing revolver, negative cash, or draws beyond commitment. Review how cash sweeps and revolvers interact before submission.
Interest mistakes: Using the wrong balance or not averaging for timing.
Working capital: Not tying to days and drivers.
Exit math: Wrong EBITDA line or double-counting cash.
Taxes: Ignoring 163(j) in a levered case or misusing NOLs.
Leases and EPS: Double-counting leases or share count errors in accretion or dilution.
Sensitivities: Grids that do not move the right outputs or contradict sponsor or lender behavior.

Governance and compliance

Permitted data only: Use provided data and clearly public sources if allowed. Avoid introducing MNPI.
Non-GAAP compliance: Treat non-GAAP measures per SEC guidance and explain adjustments.
Tool policy: Use AI or code assist only if permitted, disclose usage, and contain data per the rules.

Preparation that works and edge cases to recognize

High-yield prep drills

Three-statement rebuild: Recreate a clean model from raw historicals, add a debt schedule, and a basic LBO top sheet in under 90 minutes. If your debt tab feels slow, revisit this guide to a clean debt schedule.
Credit case: Practice one SOFR-based case with fees and a simple covenant set using ARRC conventions.
M&A mini-model: Build an accretion or dilution analysis with purchase accounting and a balancing pro forma.
Read short guides: Skim ASC 842 leases and a Section 163(j) summary; be ready to explain the EBIT-based limit.
Excel patterns: Memorize 5-10 patterns you actually use, such as days schedules, depreciation methods, iterative interest control, and two-way tables.

Edge cases

PIK toggles: Accrue PIK to principal, keep cash interest separate, and update leverage and coverage metrics.
Delayed-draw loans: Model committed but undrawn amounts and ticking fees; draw schedule follows capex or M&A timing.
Unitranche vs. split lien: Unitranche simplifies tranches but may include make-whole economics on prepay; present cash interest and amortization per instructions.
Dividend recap: Build a one-time distribution once leverage and covenants allow, then recompute returns and headroom.

Final checks, durable habits, and closeout

Final checklist before sending

Balance and liquidity: Balance sheet ties, cash is nonnegative, revolver behavior is correct, and debt is not overdrawn.
Interest and fees: Use average balances and match SOFR conventions if applicable.
Taxes: Tie to pretax income, consider 163(j) if leverage is high, and keep NOLs consistent.
Leases: Treat consistently across EBITDA, interest, and depreciation.
Sensitivities and memo: Grids run and print cleanly; memo reconciles to the model.

Habits that carry on the desk

Keep drivers close: Put key inputs near outputs so reviewers can change one cell and see correct answers fast.
Separate structure from story: Build the spine first, then layer judgment. Prose cannot fix structural errors.
Make it stoppable: A robust sensitivity surface and a clear headroom exhibit beat a perfect base case with hidden fragility.

If you have extra time, add a GAAP to Adjusted to rating-agency EBITDA bridge with explicit, reconcilable adjustments; a quick DCF cross-check off the main outputs; and a covenant summary page with quarterly headroom and a liquidity sparkline. For a refresher on valuation hygiene, see this checklist on DCF model checks.

Key Takeaway

Great modeling tests feel predictable. Build a clean spine, get the cash and debt right, pressure test with the few sensitivities that matter, and present a one-page answer that a busy VP can verify in minutes. If a line item cannot be explained in 15 seconds, simplify it or move it off the main outputs. Precision, speed, and clarity win offers.