PromptBase
PromptBase SelectGet Select
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

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.
Claude

Business Data Report And Kpi Kit

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
CLAUDE-5-5-SONNET
Tested icon
Guide icon
4 examples icon
Free credits icon
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
Report
Browse Marketplace