Financial Modeling Best Practices for IB Interviews and On the Job

Why Financial Modeling Skills Matter

Financial modeling is the core technical skill of investment banking. Whether you are building a DCF for a pitch, an LBO for a sponsor client, or a merger model for a live deal, your ability to build clean, accurate, and efficient models directly impacts your value as an analyst.

In interviews, modeling tests and case studies separate strong candidates from the rest. On the job, the quality of your models determines whether your VP trusts you with important work or spends hours fixing your mistakes.

Formatting Standards

Every top bank — Goldman Sachs, Morgan Stanley, J.P. Morgan, Evercore — has formatting conventions. While they vary slightly, the core principles are universal:

Color Coding

• Blue font: Hard-coded inputs and assumptions
• Black font: Formulas and calculations
• Green font: Links to other tabs or workbooks
• Red font: Items that need attention or are placeholders

Number Formatting

• Use thousands or millions consistently (state the unit in the header)
• Percentages: one decimal place (e.g., 12.5%)
• Dollar amounts: no decimal places for large numbers, two for per-share values
• Negative numbers: use parentheses, not minus signs — e.g., (500) not -500
• Never mix units within a column

Layout Rules

• Rows for time periods, columns flowing left to right chronologically
• Historical data on the left, projections on the right, separated by a clear border
• One row per line item — never combine two calculations in one cell
• Group related items together with clear section headers

Model Structure

A well-structured model follows a logical flow that anyone can audit:

Tab Organization

1. Cover / Table of Contents: Model name, date, version, analyst name
2. Assumptions: All key inputs in one place
3. Income Statement: Revenue build through net income
4. Balance Sheet: Assets, liabilities, equity
5. Cash Flow Statement: Operating, investing, financing cash flows
6. Supporting Schedules: Depreciation, working capital, debt schedule
7. Valuation / Output: DCF, LBO returns, or merger analysis
8. Sensitivity Analysis: Data tables showing output under different assumptions

Formula Best Practices

• One formula per row: Every cell in a row should have the same formula (just dragged across). If you need a different formula for one period, use an IF statement
• Avoid hardcoding numbers in formulas: Link to the assumptions tab instead
• No circular references: Structure your model to avoid them entirely. If unavoidable, use an iterative macro with a clear toggle
• Keep formulas short: If a formula is longer than one line in the formula bar, break it into helper rows
• Use named ranges sparingly: They can make models harder to audit for others

Common Mistakes That Will Get You in Trouble

In Interviews

• Sign errors: Mixing up positive and negative values in cash flow calculations. Always define a clear sign convention
• Forgetting to annualize or deannualize: Stub periods in M&A models require careful treatment
• Incorrect share count: Use diluted shares, account for options using the treasury stock method
• Not balancing the balance sheet: If assets do not equal liabilities plus equity, your model has an error — find it before submitting

On the Job

• Not stress-testing your model: Run extreme assumptions through your model to catch errors
• Overcomplicating things: The best analysts build models that are simple enough for an MD to follow
• Inconsistent formatting: Makes the model look sloppy and reduces trust in your work
• Not saving versions: Use clear version naming (v1, v2, etc.) and save frequently

Speed Tips for Modeling Tests

In timed modeling tests (common at banks like Evercore, Centerview, and Moelis), speed matters:

• Master keyboard shortcuts: Alt codes for formatting, Ctrl+[ to trace precedents, F2 to edit cells
• Build templates in advance: Have a clean three-statement model template ready to adapt
• Work in a logical order: Income statement first, then balance sheet and cash flow, then valuation
• Do not format until the end: Get the numbers right first, then make it pretty

Keep Improving

Financial modeling is a skill that improves with repetition. For specific question prep, see our financial modeling interview questions guide. The best analysts practice regularly, study models built by senior bankers, and learn from their mistakes. IB Flash includes modeling-focused questions and concept drills — including our DCF Calculator and WACC Calculator — that reinforce the technical foundation you need for both interviews and day one on the desk.