Financial Analysis & Trend Interpreter
Analyze financial data to identify trends, anomalies, and actionable insights with executive-ready commentary.
Your monthly financial close produces a P&L and balance sheet that technically answer 'what happened' but not 'why it happened' or 'what it means.' Turning numbers into narrative — spotting trends, flagging anomalies, and explaining variances — is the analysis that drives decisions.
Who it's for: FP&A analysts interpreting monthly financial results, CFOs preparing financial commentary for board meetings, controllers adding narrative to financial statements, small business owners understanding their own financial data, finance managers building recurring financial analysis reports
Example
"Analyze our financial trends from the past 4 quarters" → Trend analysis: revenue growth decelerating from 25% to 15%, gross margin improving due to pricing changes, 3 expense anomalies flagged (marketing +40% in Q3), cash flow forecast concerns, and executive-ready commentary with 5 recommended actions
New here? 3-minute setup guide → | Already set up? Copy the template below.
# Financial Analysis & Trend Interpreter
## Your Role
You are an expert financial analyst. Your job is to transform raw financial data into narrative insights with trends, anomalies, and actionable recommendations.
## Core Principles
- Lead with the story, support with numbers
- Every variance needs a root cause explanation
- Separate one-time events from structural trends
- Benchmark against historical performance and industry norms
- Forward-looking outlook based on trend extrapolation
## Instructions
Produce: executive summary, trend analysis, variance breakdown, anomaly detection, benchmarking, forward outlook, and recommendations.
## Commands
- "Financial analysis" - Full trend interpretation
- "Variance analysis" - Budget vs. actual deep dive
- "Trend outlook" - Forward-looking projection
- "Benchmarking" - Compare to industry norms
What This Does
Processes financial data — P&L statements, budget vs. actual, KPI dashboards — and produces trend analysis with narrative interpretation, anomaly detection, and forward-looking recommendations. Turns numbers into stories executives can act on.
Quick Start
Step 1: Download the Template
Click Download above to get the CLAUDE.md file.
Step 2: Prepare Financial Data
Gather: spreadsheets, P&L exports, budget documents, KPI reports.
Step 3: Start Using It
claude
Say: "Analyze our Q3 financials vs. budget. Identify the biggest variances and explain what's driving them."
Analysis Output
| Section | Content |
|---|---|
| Executive Summary | Key financial headlines in plain language |
| Trend Analysis | Multi-period patterns with direction |
| Variance Breakdown | Budget vs. actual with root causes |
| Anomaly Detection | Unexpected patterns flagged |
| Peer Benchmarking | How metrics compare to industry norms |
| Forward Outlook | What trends suggest for next quarter |
| Recommendations | Specific actions based on findings |
Tips
- Lead with the story, not the spreadsheet: "Revenue grew 12% but margins compressed" beats raw numbers
- Always explain WHY: A variance without a cause isn't useful
- Benchmark everything: "Is 4.2% churn good or bad?" needs context
- Separate structural from temporary: One-time costs vs. trend shifts need different responses
Commands
"Analyze these financials and explain key trends"
"What's driving the revenue variance vs. budget?"
"Compare our margins to industry benchmarks"
"What should we expect next quarter based on current trends?"
Troubleshooting
Analysis too superficial Provide more data: "Here's the previous 4 quarters for trend comparison"
Missing context for variances Add: "We had a one-time legal settlement of $500K in Q3 — separate from operating trends"
Too many data points Focus: "Analyze only revenue, gross margin, and customer acquisition cost"