Create a Financial Model Integrity Inspector that audits spreadsheets used for budgets, forecasts, valuations, and investment analysis. Identify inconsistent formulas, unexplained hardcoded values, broken assumptions, mismatched time periods, incorrect sign conventions, hidden dependencies, and outputs that change unexpectedly under reasonable inputs. Let users run sensitivity tests, compare scenarios, trace important calculations back to source cells, and review assumptions in a dedicated register. Generate a structured audit report with reproducible findings and proposed corrections. Preserve the original workbook and distinguish confirmed formula errors from suspicious patterns. Never present a model's outputs as reliable merely because its calculations execute successfully.
0 Comments