Prompt Details
Model
(claude-5-5-sonnet)
Token size
690
Example input
[{business_type}]: Online store selling home goods
[{business_data}]: Monthly revenue and expenses (USD). Jan: 10,000 / 7,000. Feb: 10,500 / 7,200. Mar: 9,800 / 7,100. Apr: 11,200 / 7,800. May: 12,100 / 8,300. Jun: 12,800 / 8,900. Expenses are not broken into categories.
[{analysis_goal}]: Understand profit trend and what to expect next month
[{time_period}]: January to June
[{audience}]: Business Owner
Example output
1. Executive Summary: Revenue grew 28 percent from January to June, and expenses grew 27.1 percent, so the margin stayed near 30 percent. March was the only dip. Actions: check what happened in March, break down expenses, plan July with a range.
2. Data Quality: 6 months, no missing values or duplicates seen. Expenses are one total, so it is unclear if they include product cost, ads, or salaries. Net versus gross profit cannot be stated [DATA NEEDED].
3. Performance Overview: Total revenue = 10,000 + 10,500 + 9,800 + 11,200 + 12,100 + 12,800 = 66,400. Total expenses = 7,000 + 7,200 + 7,100 + 7,800 + 8,300 + 8,900 = 46,300. Profit (revenue minus listed expenses) = 66,400 - 46,300 = 20,100.
4. KPIs: Profit margin = profit / revenue x 100 = 20,100 / 66,400 = 30.3 percent. Revenue growth Jan to Jun = (12,800 - 10,000) / 10,000 = 28.0 percent. Expense growth = (8,900 - 7,000) / 7,000 = 27.1 percent.
5. Trends: Revenue rose in 4 of 5 month-to-month changes. March fell 6.7 percent versus February ((9,800 - 10,500) / 10,500). Seasonality cannot be judged with 6 months. Possible reason for March: unknown, hypothesis only.
6. Customer and Product Insights: [DATA NEEDED] (no customer or product data given).
7. Financial Analysis: Monthly margin: Jan 30.0 percent, Jun 30.5 percent (3,900 / 12,800). Margin is stable. Budget comparison: [DATA NEEDED].
8. Dashboard Spec: KPIs: revenue, expenses, profit, margin. Charts: line chart for revenue and expenses, column chart for monthly profit. Warning: margin below 25 percent (a suggested alert level, set your own). Table columns: month, revenue, expenses, profit, margin.
9. Problems (1 of 2): Problem: expenses rise almost as fast as revenue. Evidence: 27.1 percent versus 28.0 percent. Impact: profit grows only with sales. Investigate: expense categories. Action: split expenses into product cost, ads, shipping, and other.
10. Opportunities: 1) Review the top expense category (medium impact, low effort). 2) Study what drove April to June growth (high impact, medium effort).
11. Forecast (July revenue): Method: three scenarios from the data. Conservative: average of last 3 months = (11,200 + 12,100 + 12,800) / 3 = 12,033. Realistic: June level, 12,800. Optimistic: June plus the average monthly change (+500, -700, +1,400, +900, +700 = +2,800 / 5 = +560), so 13,360. Based on 6 months only, so low reliability.
12. Recommendations: Insights: stable margin, steady growth, March dip, unclear expenses, short history. Actions: expense breakdown, March review, monthly tracking, keep a range-based plan, add 6 more months of data.
13. 30-Day Plan: Week 1 break down expenses. Week 2 review the March dip. Week 3 build the dashboard. Week 4 compare July with the forecast range.
By purchasing this prompt, you agree to our terms of service
CLAUDE-5-5-SONNET
Turn raw business data into a clear report using the Check-Calculate-Explain method. Paste your data, business type, analysis goal, time period, and report audience to get a data quality check, KPI and financial calculations with formulas, trends, customer and product insights, a dashboard layout, problems with evidence, growth opportunities, cautious forecast ranges, and a 30-day plan. It never changes data silently. No profit or growth is promised.
...more
Added 2 days ago
