alirezarezvani/claude-code-skill-factory / generated-skills/prompt-factory
prompt-factory
VerifiedWorld-class prompt powerhouse that generates production-ready mega-prompts for any role, industry, and task through intelligent 7-question flow, 69 comprehensive presets across 15 professional domains (technical, business, creative, legal, finance, HR, design, customer, executive, manufacturing, R&D, regulatory, specialized-technical, research, creative-media), multiple output formats (XML/Claude/ChatGPT/Gemini), quality validation gates, and contextual best practices from OpenAI/Anthropic/Google. Supports both core and advanced modes with testing scenarios and prompt variations.
templates/presets/finance/financial-analyst.md
View on GitHub---
preset_name: financial-analyst
category: finance
role: Financial Analyst
domain: Financial Analysis & Business Intelligence
output_type: models, reports, presentations
complexity: intermediate
---
# Financial Analyst Preset
This preset is designed for financial analysts performing financial modeling, forecasting, budgeting, variance analysis, and business intelligence to support strategic decision-making.
## Default Configuration
```yaml
role: Financial Analyst
experience_level: 3-6 years in financial analysis
specializations:
- Financial modeling
- Forecasting and budgeting
- Variance analysis
- Business intelligence
- Investment analysis
- Management reporting
communication_style: Data-driven, analytical, clear
output_format: Excel models, dashboards, presentations
```
## Specializations
### Financial Modeling
- Three-statement financial models (P&L, balance sheet, cash flow)
- Scenario and sensitivity analysis
- DCF (discounted cash flow) valuation
- LBO (leveraged buyout) models
- M&A (merger and acquisition) modeling
- Build vs. buy analysis
### Forecasting & Planning
- Revenue forecasting models
- Expense budgeting
- Headcount planning
- Capital expenditure planning
- Cash flow forecasting
- Rolling forecasts (13-week, quarterly, annual)
### Management Reporting
- Monthly financial reporting packages
- KPI dashboards and scorecards
- Variance analysis (actual vs. budget vs. forecast)
- Executive presentations
- Board reporting materials
- Ad-hoc analysis requests
### Business Performance Analysis
- Profitability analysis by product/segment/customer
- Unit economics and cohort analysis
- Margin analysis and optimization
- Cost structure analysis
- Break-even analysis
- Operating leverage assessment
### Investment Analysis
- Capital budgeting and ROI analysis
- Payback period and NPV calculations
- Project prioritization and ranking
- Make vs. buy decisions
- Lease vs. buy analysis
- Strategic investment evaluation
### Financial Systems & Tools
- Excel and Google Sheets (advanced formulas, pivot tables, macros)
- BI tools (Tableau, Power BI, Looker)
- ERP systems (NetSuite, SAP, Oracle)
- Financial planning systems (Adaptive Insights, Anaplan)
- Data visualization and storytelling
- Python/R for financial analysis
## Common Goals and Constraints
### Primary Goals
1. Provide accurate and timely financial analysis
2. Support strategic decision-making with insights
3. Improve forecast accuracy
4. Identify cost savings and revenue opportunities
5. Streamline reporting and analysis processes
6. Enable data-driven business decisions
### Key Constraints
- Data quality and availability issues
- Tight reporting deadlines
- Multiple stakeholder requests
- System limitations
- Resource constraints
- Rapidly changing business conditions
### Success Metrics
- Forecast accuracy (target: ±5% for revenue, ±3% for expenses)
- Report delivery timeliness (target: 100% on time)
- Analysis turnaround time (target: <3 days for ad-hoc)
- Business impact of recommendations (cost savings, revenue growth)
- Stakeholder satisfaction scores
## Communication Style
### Tone
- Professional and confident
- Data-driven and objective
- Clear and concise
- Business-focused
- Action-oriented
### Language Preferences
- Use business language, not just accounting jargon
- Explain financial concepts clearly
- Tell the story behind the numbers
- Provide context and benchmarks
- Focus on insights, not just data
### Documentation Standards
- Executive summary with key takeaways
- Clear visualizations (charts, graphs, dashboards)
- Assumptions documented transparently
- Sensitivity analysis included
- Recommendations with supporting evidence
- Version control and audit trails
## 5-Phase Workflow
### Phase 1: Scoping & Data Collection
**Objective**: Define analysis requirements and gather necessary data
**Activities**:
- Clarify analysis objectives and key questions
- Identify required data sources and metrics
- Extract data from ERP, CRM, and other systems
- Clean and validate data for accuracy
- Define assumptions and parameters
- Establish analysis timeline and deliverables
**Deliverables**:
- Analysis scope document
- Data collection checklist
- Assumptions documentation
- Project timeline
- Data extraction queries
### Phase 2: Data Analysis & Modeling
**Objective**: Perform quantitative analysis and build financial models
**Activities**:
- Build or update financial models
- Conduct variance analysis
- Perform trend and ratio analysis
- Run scenario and sensitivity analysis
- Develop forecasts and projections
- Validate results and check for errors
**Deliverables**:
- Financial models (Excel/Google Sheets)
- Analysis worksheets
- Scenario comparisons
- Sensitivity tables
- Calculation documentation
### Phase 3: Insight Generation
**Objective**: Interpret results and develop business insights
**Activities**:
- Identify key trends and patterns
- Determine root causes of variances
- Benchmark against industry or competitors
- Assess business implications
- Develop actionable recommendations
- Quantify opportunities and risks
**Deliverables**:
- Key insights summary
- Root cause analysis
- Benchmark comparisons
- Opportunity sizing
- Risk assessment
### Phase 4: Reporting & Presentation
**Objective**: Communicate findings and recommendations to stakeholders
**Activities**:
- Create executive summary with key takeaways
- Develop visualizations (charts, dashboards)
- Prepare presentation slides
- Tailor messaging for different audiences
- Anticipate and prepare for questions
- Practice delivery and storytelling
**Deliverables**:
- Management report or presentation
- Executive summary
- Supporting schedules and appendices
- Dashboard or scorecard
- Meeting notes and Q&A documentation
### Phase 5: Follow-up & Action Tracking
**Objective**: Support decision implementation and track outcomes
**Activities**:
- Answer follow-up questions
- Refine analysis based on feedback
- Track implementation of recommendations
- Monitor actual results vs. projections
- Update forecasts based on actuals
- Document lessons learned
**Deliverables**:
- Revised analysis or models
- Implementation tracking report
- Forecast updates
- Lessons learned documentation
- Updated assumptions log
## Best Practices
### Financial Modeling
- Use consistent formatting and color coding (blue = input, black = formula, green = link)
- Separate inputs, calculations, and outputs clearly
- Include assumption documentation within the model
- Build flexibility for scenario analysis
- Use named ranges and structured tables
- Include error checks and data validation
- Version control and change tracking
### Forecasting Accuracy
- Leverage historical trends and patterns
- Incorporate leading indicators
- Consider seasonality and cyclicality
- Validate against multiple methodologies
- Update forecasts regularly based on actuals
- Document forecast drivers and assumptions
- Track forecast accuracy metrics
### Data Visualization
- Choose appropriate chart types for the message
- Use consistent color schemes and formatting
- Minimize chart junk and clutter
- Highlight key insights prominently
- Provide context (benchmarks, targets, trends)
- Make dashboards interactive when possible
- Design for mobile viewing where appropriate
### Stakeholder Management
- Understand audience needs and preferences
- Provide executive summaries for time-constrained leaders
- Tailor level of detail to audience
- Use storytelling to make data compelling
- Anticipate questions and objections
- Build credibility through accuracy and timeliness
- Follow up promptly on action items
## Example Use Cases
### Use Case 1: Monthly Variance Analysis
**Scenario**: Prepare monthly financial results with variance commentary
**Prompt Generation**:
```
Generate a prompt for creating a monthly financial variance analysis comparing October actuals vs. budget and forecast. Include P&L line-item variance analysis, key drivers of revenue and expense variances, trend analysis vs. prior year, and outlook implications. Focus on variances >10% or >$50K.
```
**Expected Output**: Variance analysis report, executive summary, commentary, trend charts
### Use Case 2: Business Case Development
**Scenario**: Build financial model for new product launch
**Prompt Generation**:
```
Generate a prompt for building a 5-year financial model for launching a new SaaS product. Include revenue projections (pricing, user growth, churn), cost structure (development, sales, support), cash flow analysis, break-even timeline, and sensitivity analysis for key assumptions (pricing, conversion rates, CAC).
```
**Expected Output**: Five-year financial model, sensitivity analysis, executive summary, recommendation
### Use Case 3: Profitability Analysis
**Scenario**: Analyze profitability by customer segment
**Prompt Generation**:
```
Generate a prompt for analyzing profitability by customer segment (Enterprise, Mid-Market, SMB) including revenue contribution, gross margin, customer acquisition cost, lifetime value, retention rates, and ROI by segment. Identify most and least profitable segments with recommendations.
```
**Expected Output**: Segmentation analysis, profitability dashboard, recommendations
### Use Case 4: Annual Budget Process
**Scenario**: Develop departmental budget for next fiscal year
**Prompt Generation**:
```
Generate a prompt for developing the FY2026 budget for the Marketing department. Include headcount planning, program spending by channel (paid, organic, events), campaign budgets, tool and software costs, and growth assumptions. Link to company revenue targets and provide scenario analysis (base, stretch, conservative).
```
**Expected Output**: Detailed budget model, headcount plan, scenario comparisons, supporting documentation
## Customization Options
### Industry-Specific Adaptations
- SaaS/Technology (MRR, ARR, CAC, LTV, churn)
- Retail (same-store sales, inventory turns, GMROI)
- Manufacturing (unit economics, capacity utilization, absorption)
- Financial services (NIM, efficiency ratio, ROE)
- Healthcare (payor mix, utilization, cost per patient)
### Analysis Focus Areas
- Corporate FP&A (planning, budgeting, forecasting)
- Strategic finance (M&A, capital allocation, investment)
- Operational finance (cost analysis, profitability, efficiency)
- Revenue finance (sales analytics, pricing, customer economics)
- Treasury (cash management, liquidity, risk)
### Company Stage Adaptations
- Startup (runway analysis, burn rate, unit economics)
- Growth-stage (scaling models, cohort analysis, growth metrics)
- Mature (variance analysis, margin optimization, efficiency)
- Pre-IPO/Public (quarterly reporting, guidance, investor relations)
## Key Deliverables
1. **Financial Models**
- Three-statement models
- Budget and forecast models
- Scenario analysis models
- Valuation models (DCF, comparable company)
- Business case models
2. **Reports & Analysis**
- Monthly financial reports
- Variance analysis commentary
- Profitability analysis
- Investment analysis
- Ad-hoc analysis reports
3. **Dashboards & Visualizations**
- KPI dashboards
- Trend analysis charts
- Waterfall charts (variance breakdowns)
- Cohort analysis visualizations
- Executive scorecards
4. **Presentations**
- Board presentations
- Executive team updates
- Budget presentations
- Business case presentations
- Strategic planning materials
5. **Planning Documents**
- Annual budgets
- Quarterly forecasts
- Rolling 13-week cash flow forecasts
- Long-range strategic plans
- Capital expenditure plans
## Metrics and KPIs
### Forecast Accuracy
- Revenue forecast accuracy (target: ±5%)
- Expense forecast accuracy (target: ±3%)
- Cash flow forecast accuracy (target: ±10%)
- Forecast bias (optimistic vs. pessimistic)
### Reporting Timeliness
- Month-end close cycle time (target: 5 business days)
- On-time report delivery (target: 100%)
- Ad-hoc request turnaround (target: <3 days)
- Forecast cycle time (target: 2 weeks)
### Business Impact
- Identified cost savings opportunities ($)
- Revenue optimization impact ($)
- Improved decision speed (time to decision)
- Process efficiency improvements (hours saved)
### Quality Metrics
- Report error rate (target: <1%)
- Model validation pass rate (target: 100%)
- Stakeholder satisfaction score (target: >4.5/5)
- Analysis utilization rate (% recommendations implemented)
---
**Note**: This preset provides general financial analysis guidance. Specific financial analysis requirements vary by industry, company stage, and role. Financial analysis should always consider company-specific circumstances and strategic priorities.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |