Finance modeling interviews

Work in the tool while you explain your decisions.

Choose a role and level. Each interview has a new task, follow-up questions and a report that checks your work and your explanation.

Take the assessment Choose an interview

Speak or type. Sign in to save your results across devices.

Timed assessment

12 practical questions
50 minutes
Mid level

Questions are drawn from a bank of 36. Your report includes a skill breakdown and lessons to practice next.

Start assessment

Practice interviews

Junior tasks cover the fundamentals. Mid and senior tasks add debugging, changing requirements and review decisions.

Position

10 interviews

FP&A analyst
Junior
20 min

Three-statement cash forecast

Build forecast revenue B11 and net income B12 from the supplied assumptions, then connect income to ending cash B13. Explain the statement links before typing formulas.

Start interview

Skills and rubricLinked statements

Produces the requested result and explains the source fields.
Identifies the required output cells or query and preserves the source rows.
Tests a concrete boundary case before reporting a result.

FP&A analyst
Junior
20 min

Working-capital sign audit

Build closing operating working capital B8 and cash from operations B10 from the supplied receivables, inventory, payables and income inputs. Put the working-capital movement in B9.

Start interview

Skills and rubricWorking capital and cash flow

Produces the requested result and explains the source fields.
Identifies the required output cells or query and preserves the source rows.
Tests a concrete boundary case before reporting a result.

FP&A analyst
Junior
20 min

Price-volume variance bridge

Build budget revenue B6, volume effect B7, price effect B8 and actual revenue B9. Explain the convention you choose for the price-volume bridge.

Start interview

Skills and rubricRevenue variance decomposition

Produces the requested result and explains the source fields.
Identifies the required output cells or query and preserves the source rows.
Tests a concrete boundary case before reporting a result.

Corporate finance analyst
Mid
25 min

Debt repayment debugging

Build mandatory repayment B7, cash sweep B8, closing debt B9 and interest B10. Explain which balance drives this contract interest calculation.

Start interview

Skills and rubricDebt repayment cap and interest

Tests a boundary and handles the revised requirement without hard-coded outputs.
Explains how missing values and duplicate business keys affect this result.
Reconciles the source population and the final output before handoff.

Investment banking analyst
Mid
25 min

Capital cost review

Build cost of equity B9 and WACC B10 from the supplied risk and funding assumptions. Explain your capital-weight basis.

Start interview

Skills and rubricAfter-tax cost of capital

Tests a boundary and handles the revised requirement without hard-coded outputs.
Explains how missing values and duplicate business keys affect this result.
Reconciles the source population and the final output before handoff.

Investment banking analyst
Mid
25 min

DCF terminal-value repair

Build terminal value B9 and enterprise value B10 from the three annual free cash flows and the perpetual-growth assumptions.

Start interview

Skills and rubricEnterprise-to-equity valuation

Tests a boundary and handles the revised requirement without hard-coded outputs.
Explains how missing values and duplicate business keys affect this result.
Reconciles the source population and the final output before handoff.

Private equity associate
Mid
25 min

Sponsor exit returns

Build exit enterprise value B9, remaining debt B10, exit equity B11, MOIC B12 and annualized return B13. The sponsor receives one exit distribution after the hold.

Start interview

Skills and rubricLeveraged exit returns

Tests a boundary and handles the revised requirement without hard-coded outputs.
Explains how missing values and duplicate business keys affect this result.
Reconciles the source population and the final output before handoff.

FP&A analyst
Senior
35 min

Driver-based scenario forecast

Build forecast revenue B10, operating profit B11 and margin B12 from the base growth assumption in E2. Explain the operating drivers.

Start interview

Skills and rubricScenario controls and cost drivers

Defends the model grain, exposes silent failure modes and gives a maintainable handoff.
States the contract behind each assumption and identifies its business owner.
Discusses refresh or recalculation cost without making unsupported performance claims.

FP&A analyst
Senior
35 min

Minimum-cash funding limit

Build cash before funding B8 and the funding draw B9 needed to reach minimum cash. Calculate closing cash B10 and show any remaining gap in B11.

Start interview

Skills and rubricRevolver and liquidity shortfall

Defends the model grain, exposes silent failure modes and gives a maintainable handoff.
States the contract behind each assumption and identifies its business owner.
Discusses refresh or recalculation cost without making unsupported performance claims.

Investment banking analyst
Senior
35 min

Acquisition EPS review

Build combined earnings B10, combined EPS B11 and accretion B12. Explain the relationship between a higher total income and earnings per share.

Start interview

Skills and rubricAccretion and dilution

Defends the model grain, exposes silent failure modes and gives a maintainable handoff.
States the contract behind each assumption and identifies its business owner.
Discusses refresh or recalculation cost without making unsupported performance claims.

Choose your character

Finance modeling interviews

Timed assessment

Practice interviews

Three-statement cash forecast

Working-capital sign audit

Price-volume variance bridge

Debt repayment debugging

Capital cost review

DCF terminal-value repair

Sponsor exit returns

Driver-based scenario forecast

Minimum-cash funding limit

Acquisition EPS review

Interview Hub access

Your Work Gym account