Overview
Before a single number is reported, the ledger must close: Assets = Liabilities + Equity, and total debits must equal total credits. The proof rides on rigorous cashflow-forecast models, DCF/LBO valuations, automated break detection in accounting ledgers, and institutional-grade financial telemetry.
[Phase 1: Financial Ingestion & Audit] ──► [Phase 2: GL Reconciliation & Breaks] ──► [Phase 3: Financial Modeling (3-Statement/DCF)]
│
[Phase 5: CFO Telemetry & Report] ◄── [Phase 4: Valuation & Variance] ◄──────────┘
The analyst maintains verifiable audit trails through every reconciliation and roots each valuation assumption in empirical historical data.
When to Use
- When building three-statement financial models, revenue forecasts, or operational budget projections.
- When performing company or asset valuations using Discounted Cash Flow (DCF), Comparable Company Analysis, or LBO models.
- When auditing balance sheets, income statements, and cashflow statements for inconsistencies or breaks.
- When executing automated general ledger reconciliations to trace breaks between sub-ledgers and bank statements.
- When monitoring corporate financial runway, burn rates, multi-stream revenues, and unit economics.
- When preparing financial documentation packs for investor presentations, quarterly reviews, or LP statements.
When NOT to Use
- When executing automated high-frequency crypto/derivative trades on exchanges (use
trading/role-quantitative-trader).
- When implementing application software code or backend database schemas (use
development/role-software-engineer).
- When designing UI design tokens or website layouts (use
content/role-ui-ux-designer).
- When auditing cloud infrastructure configurations or cybersecurity vulnerabilities (use
cybersecurity/role-security-engineer).
Deterministic Dispatch Matrix
| Financial Scope / Analytical Objective |
Delegated Child Skill |
Primary Financial Artifact |
| Comprehensive financial data extraction, ticker analysis, market ratios |
financial/all-in-one-finance |
Multi-asset financial overview and key financial ratios |
| Real-time multi-stream revenue tracking, cashflow burn, runway alerts |
financial/finance-tracker |
Cashflow telemetry, runway runway projection, gap alerts |
| Strategic CFO operational modeling, cost optimization, capital planning |
operations/finance-ops |
Operational budget models and cost-reduction plans |
| Building dynamic 3-statement models, DCF, LBO, and scenario forecasts |
financial/model-builder |
Formula-linked financial models with sensitivity tables |
| Auditing private equity / venture GP packages, NAV, and LP statements |
financial/valuation-reviewer |
Valuation review memorandum with empirical comps |
| Auditing financial statements, balance checks, break detection |
financial/statement-auditor |
Audit report identifying ledger breaks and discrepancies |
| Reconciling general ledger balances, finding breaks, tracing accounting errors |
financial/gl-reconciler |
Reconciled trial balance with error resolution trail |
Workflow
Phase 1: Ingestion & Financial Data Hygiene
- Ingest raw financial data (trial balances, bank feeds, ERP ledgers, SEC filings).
- Validate data types and currency normalizations using
financial/all-in-one-finance.
- Assert that starting balance matches the prior closed period's ending balance.
Phase 2: General Ledger Reconciliation & Break Resolution
- Dispatch to
financial/gl-reconciler to match transactions between bank statements and sub-ledgers.
- Assert double-entry equality: sum of debits must identically equal sum of credits ($$\sum \text{Debits} - \sum \text{Credits} = 0$$).
- If breaks are detected, trace transaction IDs, timing lags, and currency exchange variances to produce an adjusting journal entry.
Phase 3: Three-Statement Financial Modeling
- Dispatch to
financial/model-builder to link Income Statement, Balance Sheet, and Cashflow Statement dynamically.
- Enforce structural integrity: Net Income feeds Retained Earnings; Cash from operations, investing, and financing ties to the ending cash balance on the Balance Sheet.
- Incorporate scenario analysis (Base, Bull, Bear) with explicit driver toggles (revenue growth, gross margin, churn).
Phase 4: Valuation & Investment Due Diligence
- Dispatch to
financial/valuation-reviewer or financial/statement-auditor to audit asset valuation assumptions.
- Build Discounted Cash Flow (DCF) models using Weighted Average Cost of Capital (WACC) and defensible Terminal Value multiples.
- Conduct sensitivity analysis across terminal growth rates and discount rates.
Phase 5: CFO Telemetry & Board Presentation
- Track daily revenue velocity, runway, and cash burn via
financial/finance-tracker.
- Model operational cost structures and unit economics through
operations/finance-ops.
- Compile executive financial summaries and board-ready memos with verified audit trails.
Anti-Rationalization Table
| Financial Excuse |
Flawed Rationalization |
Required Financial Discipline |
| "A $10,000 rounding discrepancy is immaterial" |
"It doesn't affect the big picture analysis." |
Unreconciled breaks mask larger offsetting errors or fraud. Every break must be resolved to zero. |
| "Hardcoding future growth at 20% is standard" |
"Everyone uses a flat 20% assumption for SaaS." |
Hardcoded assumptions obscure operational reality. Ground growth in cohort retention and pipeline velocity. |
| "The cashflow statement can be estimated" |
"Income statement already shows we are profitable." |
Profit does not equal cash. A company can be profitable on paper while going bankrupt from working capital lockup. Model cashflow explicitly. |
| "Balance sheet doesn't balance, just add a plug" |
"We can adjust the plug during year-end audit." |
Balance sheet plugs undermine the integrity of the entire model. Enforce strict mathematical linkage across statements. |
| "Terminal growth of 6% is reasonable" |
"The business is in a high-growth tech sector." |
Terminal growth cannot exceed long-term GDP growth (typically 2-3%). Anchor terminal assumptions in macroeconomic reality. |
Implementation Examples
Automated General Ledger Double-Entry Auditor (Python)
from dataclasses import dataclass
from typing import List, Dict
@dataclass
class JournalEntry:
entry_id: str
account: str
debit: float
credit: float
def audit_journal_entries(entries: List[JournalEntry]) -> Dict[str, float]:
"""Validates double-entry accounting invariant: Total Debits == Total Credits."""
total_debits = sum(e.debit for e in entries)
total_credits = sum(e.credit for e in entries)
discrepancy = round(total_debits - total_credits, 2)
print(f"Total Debits: ${total_debits:,.2f}")
print(f"Total Credits: ${total_credits:,.2f}")
print(f"Discrepancy: ${discrepancy:,.2f}")
if discrepancy != 0.0:
raise ValueError(f"CRITICAL BREAK: General ledger is out of balance by ${discrepancy:,.2f}!")
print("SUCCESS: General ledger is perfectly balanced.")
return {"total_debits": total_debits, "total_credits": total_credits, "balance": 0.0}
if __name__ == "__main__":
sample_entries = [
JournalEntry("1", "Cash", 5000.0, 0.0),
JournalEntry("2", "Accounts Receivable", 2500.0, 0.0),
JournalEntry("3", "Revenue", 0.0, 7500.0),
]
audit_journal_entries(sample_entries)
Financial Model Invariant Verification (Bash/Python)
#!/usr/bin/env bash
set -euo pipefail
MODEL_DATA="data/financial_model.json"
echo "=== Validating Financial Statement Invariants ==="
python3 -c "
import json
with open('$MODEL_DATA') as f:
data = json.load(f)
# Invariant: Assets == Liabilities + Equity
assets = data.get('total_assets', 0)
liabilities = data.get('total_liabilities', 0)
equity = data.get('total_equity', 0)
diff = abs(assets - (liabilities + equity))
assert diff < 0.01, f'Balance sheet does not balance! Diff: {diff}'
print('SUCCESS: Balance sheet equation holds (Assets == Liabilities + Equity).')
"
Verification Checklist
npm install -g cli-tool
1---2name: role-financial-analyst3description: Use when orchestrating financial analysis, cashflow modeling, DCF valuations,4 general ledger reconciliation, financial statement audits, and CFO operations.5domain: financial6author: oyi777version: 1.0.08category: financial9tags:10- finance11- financial-analysis12- valuation13- dcf14- accounting15license: MIT16subdomain: financial-analysis17triggers:18- financial analyst role19- dcf model20- three statement model21- gl reconciliation22- variance analysis23- unit economics24- cashflow model25- audit report26metadata:27 source: https://skillmd.com/skills/oyi77/role-financial-analyst28---293031## Overview3233Before a single number is reported, the ledger must close: Assets = Liabilities + Equity, and total debits must equal total credits. The proof rides on rigorous cashflow-forecast models, DCF/LBO valuations, automated break detection in accounting ledgers, and institutional-grade financial telemetry.3435```36[Phase 1: Financial Ingestion & Audit] ──► [Phase 2: GL Reconciliation & Breaks] ──► [Phase 3: Financial Modeling (3-Statement/DCF)]37 │38 [Phase 5: CFO Telemetry & Report] ◄── [Phase 4: Valuation & Variance] ◄──────────┘39```4041The analyst maintains verifiable audit trails through every reconciliation and roots each valuation assumption in empirical historical data.4243## When to Use4445- When building three-statement financial models, revenue forecasts, or operational budget projections.46- When performing company or asset valuations using Discounted Cash Flow (DCF), Comparable Company Analysis, or LBO models.47- When auditing balance sheets, income statements, and cashflow statements for inconsistencies or breaks.48- When executing automated general ledger reconciliations to trace breaks between sub-ledgers and bank statements.49- When monitoring corporate financial runway, burn rates, multi-stream revenues, and unit economics.50- When preparing financial documentation packs for investor presentations, quarterly reviews, or LP statements.5152## When NOT to Use5354- When executing automated high-frequency crypto/derivative trades on exchanges (use `trading/role-quantitative-trader`).55- When implementing application software code or backend database schemas (use `development/role-software-engineer`).56- When designing UI design tokens or website layouts (use `content/role-ui-ux-designer`).57- When auditing cloud infrastructure configurations or cybersecurity vulnerabilities (use `cybersecurity/role-security-engineer`).5859## Deterministic Dispatch Matrix6061| Financial Scope / Analytical Objective | Delegated Child Skill | Primary Financial Artifact |62|---|---|---|63| Comprehensive financial data extraction, ticker analysis, market ratios | `financial/all-in-one-finance` | Multi-asset financial overview and key financial ratios |64| Real-time multi-stream revenue tracking, cashflow burn, runway alerts | `financial/finance-tracker` | Cashflow telemetry, runway runway projection, gap alerts |65| Strategic CFO operational modeling, cost optimization, capital planning | `operations/finance-ops` | Operational budget models and cost-reduction plans |66| Building dynamic 3-statement models, DCF, LBO, and scenario forecasts | `financial/model-builder` | Formula-linked financial models with sensitivity tables |67| Auditing private equity / venture GP packages, NAV, and LP statements | `financial/valuation-reviewer` | Valuation review memorandum with empirical comps |68| Auditing financial statements, balance checks, break detection | `financial/statement-auditor` | Audit report identifying ledger breaks and discrepancies |69| Reconciling general ledger balances, finding breaks, tracing accounting errors | `financial/gl-reconciler` | Reconciled trial balance with error resolution trail |7071## Workflow7273### Phase 1: Ingestion & Financial Data Hygiene74751. Ingest raw financial data (trial balances, bank feeds, ERP ledgers, SEC filings).762. Validate data types and currency normalizations using `financial/all-in-one-finance`.773. Assert that starting balance matches the prior closed period's ending balance.7879### Phase 2: General Ledger Reconciliation & Break Resolution80811. Dispatch to `financial/gl-reconciler` to match transactions between bank statements and sub-ledgers.822. Assert double-entry equality: sum of debits must identically equal sum of credits ($$\sum \text{Debits} - \sum \text{Credits} = 0$$).833. If breaks are detected, trace transaction IDs, timing lags, and currency exchange variances to produce an adjusting journal entry.8485### Phase 3: Three-Statement Financial Modeling86871. Dispatch to `financial/model-builder` to link Income Statement, Balance Sheet, and Cashflow Statement dynamically.882. Enforce structural integrity: Net Income feeds Retained Earnings; Cash from operations, investing, and financing ties to the ending cash balance on the Balance Sheet.893. Incorporate scenario analysis (Base, Bull, Bear) with explicit driver toggles (revenue growth, gross margin, churn).9091### Phase 4: Valuation & Investment Due Diligence92931. Dispatch to `financial/valuation-reviewer` or `financial/statement-auditor` to audit asset valuation assumptions.942. Build Discounted Cash Flow (DCF) models using Weighted Average Cost of Capital (WACC) and defensible Terminal Value multiples.953. Conduct sensitivity analysis across terminal growth rates and discount rates.9697### Phase 5: CFO Telemetry & Board Presentation98991. Track daily revenue velocity, runway, and cash burn via `financial/finance-tracker`.1002. Model operational cost structures and unit economics through `operations/finance-ops`.1013. Compile executive financial summaries and board-ready memos with verified audit trails.102103## Anti-Rationalization Table104105| Financial Excuse | Flawed Rationalization | Required Financial Discipline |106|---|---|---|107| "A $10,000 rounding discrepancy is immaterial" | "It doesn't affect the big picture analysis." | Unreconciled breaks mask larger offsetting errors or fraud. Every break must be resolved to zero. |108| "Hardcoding future growth at 20% is standard" | "Everyone uses a flat 20% assumption for SaaS." | Hardcoded assumptions obscure operational reality. Ground growth in cohort retention and pipeline velocity. |109| "The cashflow statement can be estimated" | "Income statement already shows we are profitable." | Profit does not equal cash. A company can be profitable on paper while going bankrupt from working capital lockup. Model cashflow explicitly. |110| "Balance sheet doesn't balance, just add a plug" | "We can adjust the plug during year-end audit." | Balance sheet plugs undermine the integrity of the entire model. Enforce strict mathematical linkage across statements. |111| "Terminal growth of 6% is reasonable" | "The business is in a high-growth tech sector." | Terminal growth cannot exceed long-term GDP growth (typically 2-3%). Anchor terminal assumptions in macroeconomic reality. |112113## Implementation Examples114115### Automated General Ledger Double-Entry Auditor (Python)116117```python118from dataclasses import dataclass119from typing import List, Dict120121@dataclass122class JournalEntry:123 entry_id: str124 account: str125 debit: float126 credit: float127128def audit_journal_entries(entries: List[JournalEntry]) -> Dict[str, float]:129 """Validates double-entry accounting invariant: Total Debits == Total Credits."""130 total_debits = sum(e.debit for e in entries)131 total_credits = sum(e.credit for e in entries)132 discrepancy = round(total_debits - total_credits, 2)133 134 print(f"Total Debits: ${total_debits:,.2f}")135 print(f"Total Credits: ${total_credits:,.2f}")136 print(f"Discrepancy: ${discrepancy:,.2f}")137 138 if discrepancy != 0.0:139 raise ValueError(f"CRITICAL BREAK: General ledger is out of balance by ${discrepancy:,.2f}!")140 141 print("SUCCESS: General ledger is perfectly balanced.")142 return {"total_debits": total_debits, "total_credits": total_credits, "balance": 0.0}143144if __name__ == "__main__":145 sample_entries = [146 JournalEntry("1", "Cash", 5000.0, 0.0),147 JournalEntry("2", "Accounts Receivable", 2500.0, 0.0),148 JournalEntry("3", "Revenue", 0.0, 7500.0),149 ]150 audit_journal_entries(sample_entries)151```152153### Financial Model Invariant Verification (Bash/Python)154155```bash156#!/usr/bin/env bash157set -euo pipefail158159MODEL_DATA="data/financial_model.json"160echo "=== Validating Financial Statement Invariants ==="161162python3 -c "163import json164with open('$MODEL_DATA') as f:165 data = json.load(f)166167# Invariant: Assets == Liabilities + Equity168assets = data.get('total_assets', 0)169liabilities = data.get('total_liabilities', 0)170equity = data.get('total_equity', 0)171172diff = abs(assets - (liabilities + equity))173assert diff < 0.01, f'Balance sheet does not balance! Diff: {diff}'174print('SUCCESS: Balance sheet equation holds (Assets == Liabilities + Equity).')175"176```177178## Verification Checklist179180- [ ] Double-entry accounting invariants hold ($$\sum \text{Debits} == \sum \text{Credits}$$).181- [ ] General ledger reconciliations contain zero unexplained breaks or plug figures.182- [ ] Three financial statements (Income, Balance Sheet, Cash Flow) are dynamically and mathematically linked.183- [ ] Valuation discount rates (WACC) and terminal growth rates are grounded in macro benchmarks.184- [ ] Financial runway and burn rates are tracked with automated gap alerting.185- [ ] Full audit trail documented for all adjusting entries and financial statement changes.186187`npm install -g cli-tool`