3-Statement Financial Model Skill
Complete and validate linked income statement, balance sheet, and cash flow templates with proper financial statement integrity.
The skill is documentation-only guidance, not directly executing code or accessing external resources, so permission and confirmation risks are low. However, it lacks explicit user confirmation mechanisms, data-flow transparency, and rollback options, and relies on external Excel operations that may affect sensitive financial data. Deductions due to absence of data-flow transparency and recovery measures.
Provides detailed steps and validation checklists, but no automated tests or executable scripts; relies on manual user operations in Excel. Key-path reproduction depends on user environment. Limited failure-feedback for abnormal inputs (e.g., template structure mismatch). Hence low score.
Clearly intended for 3-statement financial model population; scenarios are clear, but capability boundaries not fully delineated (e.g., adaptation to non-standard templates). Trigger conditions rely on description without precise semantic indicators. Also does not account for mainland-China network reachability (e.g., SEC EDGAR access may be restricted).
Documentation is well-structured with layered references, but lacks version numbers, changelog, maintenance responsibility, and update path. Known limitations and troubleshooting guidance not explicitly disclosed. Naming of parameters is stable.
Comprehensive filling and validation guide, but no actual output examples or comparison to alternatives; direct usability unverified. Marginal value depends on user's Excel proficiency, but cost is reasonable. Limited due to lack of verification evidence.
Only documentation and external references; no executable tests or independent verification evidence. Key claims (e.g., formula correctness) cannot be verified from static read, hence very low score.
- The skill relies on manual Excel operations with no automated execution or error recovery; back up original templates before use.
- External services such as SEC EDGAR may be unreachable in mainland China; verify data source availability or prepare alternatives.
- No versioning or maintenance commitment; verify compatibility with your Excel and template before use.
- Formulas and validation rules (e.g., NOL utilization cap) are based on specific assumptions; carefully reconcile with actual financial scenarios.
What does this skill do, and when should you use it?
This skill, from the LangAlpha repository (Apache-2.0 licensed), focuses on completing and populating integrated 3-statement financial models. It guides users through identifying template tab structure, distinguishing input vs. formula cells, and following safe entry rules to avoid breaking existing formulas. The skill provides step-by-step fill instructions, per-statement quality checks, cross-statement integrity checks (balance sheet balance, cash tie-out, net income link, retained earnings roll), and frameworks for scenario analysis (Base/Upside/Downside) and credit metrics (leverage, coverage, liquidity). It also includes a reference for extracting data from SEC filings (10-K, 10-Q) and guidance on handling circular references (e.g., interest expense loop). Margin analysis and credit analysis are only performed if explicitly prompted by the user or required by the template.
Analyzes the user's financial model template (typically Excel) to understand its tabs (e.g., IS, BS, CF, WC, DA, Debt) and structure. Identifies input vs. formula cells, respecting named ranges, units, and sign conventions. Guides step-by-step population of historical data and assumption drivers without overwriting formulas. Validates formula integrity via trace precedents, evaluate formula, and consistency checks. Performs quality checks per statement (e.g., revenue matching, assets = liabilities + equity, net income link). Executes cross-statement integrity checks: balance sheet balance, cash tie-out, net income link, retained earnings roll. Provides guidance for scenario analysis (Base/Upside/Downside) using CHOOSE or INDEX/MATCH toggles. If prompted, computes core margins (gross, EBITDA, EBIT, net income) on the income statement and credit metrics (total debt/EBITDA, net debt/EBITDA, interest coverage, etc.) on the balance sheet. Offers a quick debug workflow and a master check formula to determine if all checks pass or errors need review.
- An investment banking analyst needs to quickly populate a three-statement Excel template for a quarterly update of an acquired company, ensuring all formulas and linkages are correct.
- An equity research associate is updating a 5-year forecast for a covered company and needs help navigating a complex template structure and validating model integrity.
- A FP&A professional is building a new three-statement model and wants to ensure the template structure is sound and formulas are correct before inputting assumption data.
- A consultant or auditor is reviewing a client's financial model and uses the skill to audit the template's structure and formula integrity, identifying potential broken links.
- A student or analyst needs to extract data from SEC filings (e.g., 10-K) into a three-statement template, and the skill provides extraction steps and formatting guidance.
What are this skill's strengths and limitations?
- Detailed step-by-step guidance from template structure analysis to final audit, suitable for various skill levels.
- Emphasizes discipline in respecting existing formulas and input cells, reducing risk of breaking the model.
- Comprehensive quality check list covering statement-specific and cross-statement balances.
- Provides guidance on circular reference handling, a common complexity in three-statement models.
- Supports scenario analysis (Base/Upside/Downside) and credit metrics for deeper analysis.
- It is a guide, not an automation tool - the agent does not directly manipulate files; manual data entry or other tools are required.
- No test suite or automated validation mechanism; quality checks are manual steps.
- Relies on user's familiarity with Excel features (e.g., Name Manager, Trace Precedents).
- SEC filing extraction is only a reference document, with no actual API calls or implementation.
- Margin and credit analysis are only performed if explicitly prompted, otherwise skipped.
How do you install this skill?
Copy the entire 'skills/3-statements' folder to your Agent Skills directory. For LangAlpha users, the skill is already included in the repository and can be used via slash command or automatic detection. For other Agent Skills-compliant tools, place it in the appropriate skills directory. Ensure you comply with the Apache-2.0 license when installing.
How do you use this skill?
- Open your financial model template (e.g., Excel file). 2. Provide instruction to the agent, such as: 'Please complete this 3-statement model template.' 3. The skill will guide you through all steps: analyze structure, enter data, validate formulas, perform quality checks. 4. If the template requires SEC data, refer to 'references/sec-filings.md' for detailed guidance. 5. For margin analysis or credit analysis, explicitly request them. Note: The skill does not automatically open or process files; it provides guidance and operational steps, assuming you have access to the model file.