model-audit-tieout

Use the model audit script to inspect static Excel workbooks, verify formula integrity, and trace outputs to credible sources. It generates an audit memo, issue log, and tie-out ledger to support investment committee workflows.

A source tie-out ledger traces material outputs in financial models to supporting sources, dates, and evidence. This ensures formulas are correct and outputs are traceable for PM and IC-level decision governance.

Run a static workbook inspection script to identify inconsistent or hardcoded formulas across key schedules. This prevents misstatements in DCFs, comps, and sensitivity decks by ensuring formula consistency.

Yes, the model audit process generates IC-ready HTML reports from static workbook inspections. It produces a concise memo, issue log, tie-out ledger, and HTML deliverable for board-level decision readiness.

Yes, openpyxl is used to read formulas and cell values in Excel workbooks. The static audit script leverages this dependency to triage findings, check formula integrity, and guide remediation for public equity models.

The audit framework supports three-statement models, DCFs, comps, and sensitivity decks. It verifies formula integrity and ensures material outputs tie to credible sources for IC, PM, and board-level decisions.