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.
By purchasing this prompt, you agree to our terms of service
GPT-5.6
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
