LogoClawIndex
CasesSkillsAbout
LogoClawIndex

3-statement-model - Complete integrated three-statement financial models

Completes financial model templates by populating historicals, assumptions, formulas, and linked Income Statement, Balance Sheet, and Cash Flow Statement projections.

Tags

Updated: 2026-10-08
financial modelingthree-statement modelExcelforecastingscenario analysisSEC filings

Capabilities

Review template tabsMap model structurePopulate historical actualsEnter assumption drivers

Typical Inputs

Financial model templateHistorical financial dataAssumption drivers

Typical Outputs

Completed Excel modelFormula-linked statementsScenario analysis

What this skill does

  • Review template tabs
  • Map model structure
  • Populate historical actuals
  • Enter assumption drivers
  • Build formula projections
  • Link financial statements
  • Validate balance checks
  • Validate cash tie-outs
  • Apply model formatting
  • Build scenario analysis
  • Calculate requested margins
  • Calculate requested credit metrics
  • Extract SEC filing data

Inputs

  • Financial model template
  • Historical financial data
  • Assumption drivers
  • User instructions
  • SEC filings

Outputs

  • Completed Excel model
  • Formula-linked statements
  • Scenario analysis
  • Margin analysis
  • Credit metrics
  • Balance check results
  • Cash tie-out results
  • User confirmation checkpoints

Requirements

  • Excel Office JS or Python openpyxl
  • Excel formula recalculation
  • Workbook write access
  • recalc.py for standalone files

Source

  • Spec: SKILL.md

ClawIndex

OpenClaw Skills & Use Case Index

ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

Index

Skills·
Cases

Meta

About·
Disclaimer·
Email·
GitHub
© 2026 ClawIndex All Rights Reserved.