Audit advanced Works with: Any AI

Financial Model Sanity Check

Table output

Test a model's logic, assumptions, and outputs.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Test a financial model's logic, assumptions, and outputs. Spreadsheet app: [SPREADSHEET_APP]. Model purpose and period: [PURPOSE_AND_PERIOD]. Key assumptions: [ASSUMPTIONS]. Outputs: [OUTPUTS]. Formulas or structure I can share: [MODEL_STRUCTURE].

Tables:
1. Structure checks: Check | How to test | Result (pass, fail, unknown) | Note. Cover separation of inputs, calculations, and outputs; consistent formulas across rows; no hardcodes in formulas; balance and cash checks; circular references; units and periods.
2. Assumption review: Assumption | Value | Evidence | Reasonableness (low, medium, high concern) | Sensitivity (what happens to the output if it moves 10 percent).
3. Output reasonableness: Metric | Value | Reality check (growth versus history, margins versus similar businesses, cash needs versus funding) | Concern.
4. Stress tests: three scenarios with the formulas to run them.
5. Errors found and fixes.

State assumptions, do not invent benchmarks (say where I should look them up), and remind me that models are estimates. Have an accountant or financial adviser who knows [JURISDICTION] review any model used for lending, tax, or investment decisions.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts