skills.rest
brianping7
brianping7COMMUNITY
Explore all skills by this author →
𝕏@BrianPing7GitHub

check-model

Detect and diagnose errors in financial Excel models.

Updated Aug 23, 2026
Search Tags:#audit#excel#reconciliation#financial-model#model-review#lbo#formula-consistency
One-click install
npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill check-model-brianping7
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: check-model
Source: https://github.com/brianping7/volc-financial-services-skill-sets/tree/main/financial-analysis/check-model
Command: npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill check-model-brianping7

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill identifies, diagnoses, and documents structural and formula errors in financial Excel models so analysts can confidently correct issues before client delivery or investment committee review.

Core Features & Use Cases

  • Structure Mapping: Detects model type (DCF, LBO, M&A, three-statement, comps) and maps inputs, calculations, and outputs.
  • Integrity Checks: Verifies balance sheet reconciliation, cash flow alignment, retained earnings rollforward, and PP&E/CapEx matching.
  • Formula & Logic Validation: Finds broken formulas, hard-coded overrides, inconsistent dragged formulas, error values, and circular references; assesses reasonableness of growth, margins, and terminal value concentration.
  • Deliverables: Produces a prioritized issues log with cell/range references, severity, category, and suggested fixes; can annotate the workbook with comments for user review.
  • Use Case: Run before sending a model to an investment committee to ensure the three statements reconcile, no hard-coded overrides exist, and key sensitivities behave robustly.

Quick Start

Run the check-model skill on my Excel file to produce a prioritized audit report and annotated workbook.

Frequently Asked Questions about check-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I audit an Excel financial model for errors before an investment committee review?▼

To audit a financial model, run a structural mapping and formula consistency check to verify balance sheet reconciliations, cash flow matching, and detect circular references. This process produces a prioritized issues log with cell references and suggested fixes for confident delivery.

What is the best way to check balance sheet reconciliation and cash flow alignment in a three-statement model?▼

Checking balance sheet reconciliation and cash flow alignment involves verifying the retained earnings rollforward and PP&E/CapEx matching. Integrity checks identify structural mapping errors and broken formulas, generating an annotated workbook with cell-level comments for user review.

Can I detect circular references and hard-coded overrides in an LBO or DCF model?▼

Yes, you can detect circular references and hard-coded overrides in LBO or DCF models through formula and logic validation. This identifies inconsistent dragged formulas, error values, and assesses the reasonableness of growth, margins, and terminal value concentration.

How do I fix broken formulas and inconsistent dragged cells in a merger model?▼

Fixing broken formulas and inconsistent dragged cells in a merger model requires formula consistency checks to diagnose structural errors. The system generates a prioritized issues log detailing severity, category, and suggested fixes with specific cell and range references.

Does this model review process work for comparable company models and pre-delivery checks?▼

Yes, the model review process applies to comparable company models and pre-delivery checks. It performs integrity checks on three-statement models, detects model types automatically, and ensures key sensitivities behave robustly by validating formula logic and structural mapping.

Why does my financial model fail balance sheet reconciliation after updating terminal value assumptions?▼

A financial model fails balance sheet reconciliation after updating terminal value assumptions due to broken formula consistency, hard-coded overrides, or misaligned cash flow matching. Structural mapping detects these circular references and outputs a prioritized issues log with suggested fixes.

Related Skills

Explore More Finance & Accounting Skills→
kiryteokiryteo
1

check-model

Audit Excel financial models for circular references and broken formulas.

Community
Advanced
Timmy6942025Timmy6942025
3

datapack-builder

Extract, normalize, and standardize financial data into Excel workbooks.

Community
Advanced
jasrajtulsijasrajtulsi

xlsx

Create, edit, and analyze Excel workbooks while preserving formulas and formatting.

Community
Advanced
GGwujunGGwujun

financial-statement

Analyze income statement, balance sheet, and cash flow statement linkages to quantify profitability quality.

Community
Advanced