3-Statement Financial Model Template Completion
Complete, populate and fill out 3-statement financial model templates (Income Statement, Balance Sheet, Cash Flow Statement). Use when asked to fill out model templates, complete existing model frameworks, populate financial models with data, complete a partially filled IS/BS/CF framework, or link integrated financial
Overview
The 3-Statement Financial Model Template Completion skill is a specialized tool designed for AI agents like Claude and Claude-code to automate the population of integrated financial frameworks. Part of the fivetaku/claude-office-skills repository, which has gained 56 stars on GitHub, this skill focuses on filling out Income Statements, Balance Sheets, and Cash Flow Statements from existing templates. It assists users by mapping financial data into partially completed models and ensuring the logical linking of integrated statements. By utilizing this skill, users can streamline the manual process of data entry and framework completion within spreadsheet environments. The implementation leverages Python-based logic to handle data extraction and validation, making it a functional utility for financial analysis and spreadsheet management tasks.
Use Cases
Install Notes
# Review source first
open https://github.com/fivetaku/claude-office-skills/blob/main/claude-in-excel/3-statement-model/SKILL.mdCopy or clone the skill folder into your agent skills directory after reviewing its instructions and scripts.
Security Notes
Users should ensure that the financial data provided to the AI agent complies with their organization's data handling policies. As this skill operates within spreadsheet environments via the fivetaku/claude-office-skills framework, verify that the necessary permissions for file access and Python execution are appropriately configured and restricted to trusted environments.
Related Skills
Xlsx
anthropics/skills
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scr...
Experience Lwc Widget Migrate
forcedotcom/sf-skills
Convert a specific existing Lightning web component (LWC) into a declarative HXL / Agentforce widget, end to end. Gates on experience-lwc-widget-assess and stops when a widget cannot serve the LWC's purpose; otherwise hands the derived field shape to platform-widget-generate and wires the widget as the Lightning Typ...
Experience Lwc Widget Assess
forcedotcom/sf-skills
Assess whether a specific Lightning web component can serve its user's purpose as an HXL declarative widget. Use for LWC-to-widget feasibility, portability audits, and candidate screening; use experience-lwc-widget-migrate when the user wants the widget built.
Service De Channel Consent Configure
forcedotcom/sf-skills
Configure consent (opt-in/opt-out) on an Enhanced `MessagingChannel` so activation will accept it. Given a `{CHANNEL_ID}`, sets the channel's `ConsentType` (ImplicitOptIn / ExplicitOptIn / DoubleOptIn) and the `OptInPrompt` / `DoubleOptInPrompt` prompt fields, then creates or updates one `MsgChannelLanguageKeyword`...
DCF Model Builder
fivetaku/claude-office-skills
Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need
Audit Spreadsheet
fivetaku/claude-office-skills
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model, including financial-model integrity checks like BS balance, cash tie-out, and logic sanity. Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreads