Audit Spreadsheet

Audit formulas and data for accuracy and mistakes. Scope determines depth — from quick formula checks on a selection up to full financial-model integrity audits.

Step 1: Determine scope

If the user already gave a scope, use it. Otherwise ask them:

What scope do you want me to audit?

• selection — just the currently selected range
• sheet — the current active sheet only
• model — the whole workbook, including financial-model integrity checks (BS balance, cash tie-out, roll-forwards, logic sanity)

The model scope is the deepest — use it for DCF, LBO, 3-statement, merger, comps, or any integrated financial model before sending to a client or IC.

Step 2: Formula-level checks (ALL scopes)

Run these regardless of scope:

Step 3: Model-integrity checks (MODEL scope only)

If scope is model, identify the model type (DCF / LBO / 3-statement / merger / comps / custom) and run the appropriate integrity checks below.

3a. Structural review

3b. Balance Sheet

If BS doesn't balance, quantify the gap per period and trace where it breaks — nothing else matters until this is fixed.

3c. Cash Flow Statement

3d. Income Statement

3e. Circular references

• Interest → debt balance → cash → interest is a common intentional circ in LBO/3-stmt models
• If intentional: verify iteration toggle exists and works
• If unintentional: trace the loop and flag how to break it

3f. Logic & reasonableness

3g. Model-type-specific bugs

DCF:

• Discount rate applied to wrong period (mid-year vs end-of-year)
• Terminal value not discounted back

…