financial-analyst

What This Skill Does

The financial-analyst skill is a comprehensive toolkit designed to streamline the workflows of investment banking, equity research, and corporate finance professionals. It acts as an expert assistant capable of performing complex quantitative analyses and generating professional-grade research outputs. From building robust Discounted Cash Flow (DCF) models with rigorous assumptions to compiling peer-group benchmarking tables and conducting detailed market sizing exercises, this skill automates the data-heavy aspects of financial modeling. It ensures that every output—whether in Excel, PowerPoint, or Markdown—adheres to industry standards, including clear citation of sources, sensitivity analysis, and structured, logical presentations of financial data.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal: clawhub install openclaw/skills/skills/aniebyl/financial-analyst Once installed, ensure you have the necessary environment variables set if the skill requires access to specific financial APIs or local document parsing tools.

Use Cases

• Investment Banking/Valuation: Rapidly construct 5-year DCF models or perform precedent transaction analysis to determine implied valuation ranges for M&A processes.
• Equity Research: Draft comprehensive research memos that synthesize market trends, competitive positioning, and valuation upside/downside, providing a clear investment thesis.
• Strategy & Consulting: Conduct bottom-up market sizing (TAM/SAM/SOM) and competitive benchmarking to support Go-To-Market strategies or corporate strategic reviews.
• Data Standardization: Convert raw, unstructured data from SQL databases or CSV exports into clean, professional financial exhibits.

Example Prompts

1. "Build a DCF model for Tesla (TSLA) using current market data. Assume a 5-year forecast period, 10% WACC, and 2% terminal growth rate. Output the valuation and sensitivity tables in a Markdown formatted report."
2. "Create a comparable company analysis for Adobe (ADBE). Include key metrics like P/E, EV/Revenue, and EV/EBITDA. Use the standard comps-template and justify why you chose these specific software peers."
3. "Conduct a competitive strategy analysis for a mid-market SaaS startup in the logistics space. Identify three direct competitors and two indirect substitutes, assessing their pricing power and distribution moats."

Tips & Limitations

• Data Integrity: Always verify raw inputs before processing. While the agent follows strict logic, it is only as accurate as the source data provided.
• Assumptions: If you do not provide specific assumptions, the agent will default to standard industry practices. Always review the 'Assumptions Table' generated in the output to ensure it aligns with your specific views.
• Formatting: The skill is optimized for structured data; ensure Excel or CSV files are cleaned of extraneous metadata before ingestion to prevent parsing errors.
• Security: Be cautious when uploading sensitive, non-public, or proprietary financial documents. Ensure your OpenClaw instance complies with your organization's data privacy policies.