Financial Model Audit Chain

validated financial chain v1.0.0 cc-by-sa

Block ID: 8e564c82-4ee3-4358-b0eb-042f3f437606

Community-contributed block. PromptDNA makes no guarantee of output quality or fitness for purpose. This block operates in a regulated domain. Nothing generated using this block constitutes professional medical, legal, or financial advice. User assumes all responsibility for use.

This block carries additional risk (risk level: medium) and requires a stronger domain-specific disclaimer when used.

Template

Audit the financial model described in {model_description} for errors and fragility, layer by layer. (1) Structure review: are inputs, calculations, and outputs separated? Hardcoded numbers buried inside formulas are the first hunt — every constant should live in a labeled input cell. (2) Mechanical integrity: check that balance sheets balance in every period, cash flow ties to the change in cash, circular references are intentional and controlled, and sums actually span their full ranges. (3) Formula consistency: inconsistent formulas across a row (one cell overridden) are the most common silent error; identify any. (4) Assumption reasonableness: list every growth rate, margin, and rate assumption and test each against history and external benchmarks — a mechanically perfect model on fantasy inputs is worse than no model. (5) Stress behavior: push extreme inputs (zero growth, doubled costs) and verify outputs move plausibly, with no negative revenues or broken logic. (6) Report findings in severity order: errors changing conclusions, errors changing numbers, and style risks that invite future errors.

Audit the financial model described in {model_description} for errors and fragility, layer by layer. (1) Structure review: are inputs, calculations, and outputs separated? Hardcoded numbers buried inside formulas are the first hunt — every constant should live in a labeled input cell. (2) Mechanical integrity: check that balance sheets balance in every period, cash flow ties to the change in cash, circular references are intentional and controlled, and sums actually span their full ranges. (3) Formula consistency: inconsistent formulas across a row (one cell overridden) are the most common silent error; identify any. (4) Assumption reasonableness: list every growth rate, margin, and rate assumption and test each against history and external benchmarks — a mechanically perfect model on fantasy inputs is worse than no model. (5) Stress behavior: push extreme inputs (zero growth, doubled costs) and verify outputs move plausibly, with no negative revenues or broken logic. (6) Report findings in severity order: errors changing conclusions, errors changing numbers, and style risks that invite future errors.

Variables

Name	Type	Required	Trust level
model_description		yes

model-reviewspreadsheet-auditmodel-riskchain-of-thought

Ratings

0.0

Overall (0)

0.0

Accuracy

0.0

Consistency

0.0

Clarity

0.0

Efficiency

Benchmarks

Not yet self-validated against any benchmark. Automated, evaluative only - not a factor in whether this block was published.

Submitted by James P FounderMod via mcp · 2026-07-18