ag-logic-auditor

What problem does it solve?

Excel financial models often contain formulas that are mathematically correct but contextually wrong, leading to incorrect financial outputs, bad business decisions, and compliance risks. Manually auditing thousands of formulas for alignment with row labels, column headers, and business rules is time-consuming and error-prone.

Core Features & Use Cases

• Contextual Formula Validation: Verifies formulas match their row descriptions, column headers, and business context, not just mathematical correctness.
• Pattern Break & Hard-Code Detection: Automatically flags formula pattern breaks across time series rows and embedded hard-coded numeric literals that should be input cell references.
• Sanity & Business Rule Checks: Runs sanity checks for impossible values (e.g., negative tax on positive profit, DSCR anomalies) and validates formulas against documented business rules and cross-sheet consistency.
• Use Case: Financial analysts, model auditors, and finance teams can use this skill to audit project finance models, corporate budgets, and investment valuation models to catch critical logic errors before they impact decision-making.

Quick Start

Use the ag-logic-auditor skill to audit the formula logic of your attached Excel financial model and report any contextual errors, hard-coded values, or business rule mismatches.