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

Prompt Details

Model
Chat - (gpt-5.6)
Token size
2,110
Example input
[FINANCIAL RESULTS]: Revenue: Actual USD 1.18M, Budget USD 1.25M Gross margin: Actual 35%, Budget 38% EBITDA: Actual USD 210K, Budget USD 250K [OPERATING KPIs]: Sales volume down 4%. Average selling price up 2%. [BUSINESS CONTEXT]: Two customer orders moved into next month. Freight costs also increased. [AUDIENCE / REVIEW FOCUS]: CFO monthly review. Focus on revenue, margin, and EBITDA.
Example output
Management Finance Pack — Monthly CFO Review Reporting Basis: Monthly reporting period not provided Currency: USD Reporting Scope: Actual vs Budget comparison only Forecast / Prior Period / Prior Year: Not available 1. Executive Performance Snapshot Overall Performance: Behind Revenue, gross margin, and EBITDA are all below budget. Revenue shortfall is mainly reflected in lower reported sales value versus plan. Profitability performance is weaker than budget due to both lower gross margin and lower EBITDA. Two customer orders moved into the next month, which may affect revenue timing. Freight costs increased; impact on margin requires further validation. Revenue / Growth Position Behind Budget Revenue achieved USD 1.18M vs USD 1.25M budget, a shortfall of USD 70K (-5.6%). Profitability Position Behind Budget Gross margin: 35% vs 38% budget (-3 percentage points). EBITDA: USD 210K vs USD 250K budget, below plan by USD 40K (-16.0%). Cash / Working Capital Position Cannot Determine No cash balance, receivables, inventory, payables, or working capital data provided. Main Management Issue Margin and EBITDA underperformance versus budget. Main Positive Development Average selling price increased by 2%, partially offsetting the impact of lower sales volume. 2. Financial Scorecard Metric Actual Budget / Forecast Variance Prior Period Status Revenue USD 1.18M USD 1.25M -USD 70K (-5.6%) Not available Unfavorable Gross Margin % 35% 38% -3 pts Not available Unfavorable EBITDA USD 210K USD 250K -USD 40K (-16.0%) Not available Unfavorable 3. Operating KPI Scorecard KPI Current Comparison / Target Movement Business Relevance Status Sales Volume -4% Not available Declined May contribute to revenue pressure Deteriorating Average Selling Price +2% Not available Increased May partially offset volume decline Improving Note: No multi-period KPI history is available; movements represent current period observations only, not trends. 4. Key Performance Drivers Movement Financial Impact Supported Driver Evidence Status Management Implication Revenue below budget by USD 70K Reduced revenue achievement Two customer orders moved into next month Verified (timing explanation only) Confirm expected recovery timing and revenue recognition impact Sales volume declined 4% Potential negative revenue pressure Lower sales volume Supported but Not Fully Proven Investigate volume drivers and customer/order activity Average selling price increased 2% Positive revenue support Higher selling price Verified Assess sustainability and customer acceptance Gross margin below budget by 3 pts Reduced profitability Freight costs increased; additional drivers unavailable Supported but Not Fully Proven Validate cost impact and other margin drivers EBITDA below budget by USD 40K Lower operating profitability Combination of revenue shortfall and margin decline Possible Confirm operating expense and margin bridge DRIVER UNKNOWN — MANAGEMENT INPUT REQUIRED Additional explanation is required for the full gross margin decline and EBITDA variance. 5. Risks & Opportunities Type Issue Evidence Potential Business Impact Priority Current Issue Revenue below budget Actual revenue USD 1.18M vs USD 1.25M budget Lower monthly performance P2 Current Issue Gross margin pressure Margin 35% vs 38% budget; freight costs increased Reduced profitability P1 Forward Risk Continued volume weakness Sales volume down 4% Potential future revenue pressure if sustained P2 Opportunity Higher selling price Average selling price increased 2% Potential revenue/margin support if maintained P3 Unknown / Requires Verification Full EBITDA variance drivers Limited operating cost information May affect corrective action decisions P2 6. Decisions & Actions Priority Issue Management Need Recommended Next Step Evidence Required P1 Gross margin below budget Investigate Perform margin bridge analysis including freight impact and other cost drivers Product/customer margin details, freight variance P2 Revenue shortfall Investigate Confirm timing and expected recovery of delayed customer orders Order pipeline and delivery schedule P2 Volume decline Investigate Review sales volume movement by customer/product/channel Sales breakdown P3 Selling price improvement Information Only Monitor whether pricing improvement is sustainable Pricing trend analysis 7. Executive Commentary Monthly performance was below budget across the main financial measures reviewed. Revenue was USD 1.18M compared with a USD 1.25M budget, while EBITDA was USD 210K versus USD 250K planned. Two customer orders moving into the following month provide a supported explanation for part of the revenue timing variance. However, the underlying sales performance requires further review because sales volume declined by 4%. Profitability was impacted by gross margin underperformance, with actual margin at 35% compared with the 38% budget. Increased freight costs are a confirmed contributing factor, but the complete margin variance requires further analysis. The increase in average selling price by 2% is a positive operating signal, although its sustainability and impact on profitability should continue to be monitored. Key management focus: validate margin drivers, confirm delayed revenue recovery, and understand the causes behind volume decline. 8. Questions for Management Are the delayed customer orders expected to fully recover in the next reporting period? What are the main contributors to the 3-point gross margin decline beyond freight cost increases? Is the increase in freight costs temporary or expected to continue? Which products, customers, or markets contributed to the 4% sales volume decline? Is the 2% selling price increase sustainable without affecting demand? 9. Next Review Watchlist Item Why It Matters What to Watch Delayed customer orders Determines whether revenue shortfall is timing-related or structural Order completion and revenue recognition Gross margin recovery Main profitability concern Freight costs and product/customer margins Sales volume Indicates demand performance Volume by customer/product Selling price movement Supports revenue and margin performance Pricing sustainability EBITDA variance Measures operating impact Expense and profitability bridge Data Verification Required Reporting period not provided. Forecast, prior period, and prior year comparisons unavailable. No cash flow or working capital information supplied. No detailed revenue, cost, or EBITDA bridge available. Gross margin and EBITDA drivers require further validation. DRIVER UNKNOWN — MANAGEMENT INPUT REQUIRED for unexplained portions of margin and EBITDA variance.
🤖 GPT

Monthly Finance Review Builder

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
GPT-5.6
Tested icon
Guide icon
4 examples icon
Free credits icon
Built for FP&A managers, controllers, and finance teams preparing monthly management reviews. Turn financial results, operating KPIs, and known business context into a focused executive pack covering performance, key drivers, risks, decisions, actions, and next-review priorities. The prompt separates financial facts from explanations, flags unknown drivers, and keeps management attention on the few issues that matter most without inventing causes, decisions, or unsupported business narratives.
...more
Added 1 day ago
Report
Browse Marketplace