Management Accounting & FP&A
Budgeting, forecasting, variance analysis, KPIs, and financial modeling.
55 prompts
Variance Analysis Report Builder
Creates a structured variance analysis comparing actual vs. budget results with root cause analysis.
Driver-based budget model template (revenue, headcount, opex)
Creates a driver-based budgeting framework and templates that link revenue drivers, headcount, and operating expenses. Useful for FP&A teams building a scalable budget process.
Rolling forecast update: variance bridge to new forecast
Updates a rolling forecast by bridging from prior forecast to actuals and new assumptions. Produces a clear bridge and narrative for leadership.
Budget kickoff pack: timeline, owners, templates, instructions
Generates a budget kickoff pack with roles, deadlines, template instructions, and FAQs. Useful for FP&A leaders coordinating cross-functional budgeting.
Scenario planning: base/upside/downside with triggers
Builds a scenario framework with quantified assumptions, trigger points, and recommended actions. Useful for uncertain environments and board discussions.
Monthly variance analysis: budget vs actual with bridges
Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.
COGS variance: purchase price vs usage vs mix
Breaks COGS variance into purchase price, usage/efficiency, and mix components. Useful for manufacturing/retail and product businesses.
Sales variance: price-volume-mix with segment insights
Creates a PV/M decomposition for sales and highlights segment-level drivers. Useful for commercial leaders and board packs.
Expense variance triage: controllable vs noncontrollable
Separates expense variances into controllable and noncontrollable buckets and drafts targeted follow-ups. Useful for expense owners and cost governance.
Cost allocation model: shared services and drivers
Designs a cost allocation approach for shared services using clear drivers and documentation. Useful for management reporting and chargeback models.
Activity-based costing (ABC) pilot: scope and data design
Plans an ABC pilot including activities, cost drivers, data sources, and reporting outputs. Useful for organizations seeking better product/customer profitability insights.
Standard cost setting: BOM/routing assumptions and updates
Creates a standard cost setting framework including BOM, labor routing, overhead rates, and update cadence. Useful for manufacturing and inventory valuation consistency.
Service line costing: utilization, billable rates, margins
Builds a service line costing model using utilization and blended rates to compute margins. Useful for professional services and agency businesses.
KPI tree: link strategy to drivers and metrics
Creates a KPI tree that connects strategic objectives to operational drivers and metrics with definitions. Useful for leadership alignment and dashboard design.
Dashboard spec for finance: layout, filters, and data model
Drafts a dashboard specification including layout, filters, and a data model for BI tools. Useful for FP&A partnering with analytics/engineering.
Metric definition library (single source of truth) template
Creates a standardized metric dictionary to prevent KPI drift across teams. Useful for scaling reporting and ensuring consistent definitions.
13-week cash flow forecast with receipts/disbursements
Builds a 13-week cash forecast structure and assumptions, including a weekly receipts/disbursements schedule. Useful for liquidity management and turnaround planning.
Indirect cash flow statement builder (from P&L and BS)
Guides building an indirect cash flow statement and identifies common classification errors. Useful for private company reporting and monthly management packs.
Working capital analysis: drivers and cash conversion cycle
Analyzes working capital changes and cash conversion cycle drivers, producing actionable insights. Useful for CFOs and operations leaders.
Break-even analysis with fixed/variable cost classification
Classifies costs into fixed and variable, calculates break-even volume/revenue, and includes sensitivity analysis. Useful for pricing decisions and cost planning.
Customer/product profitability model with contribution margins
Builds a profitability view by customer or product including allocations where appropriate and a transparency note. Useful for commercial strategy and pruning unprofitable segments.
Unit economics for subscription/business model (CAC, LTV, payback)
Creates a unit economics model with CAC, LTV, gross margin, and payback, including sensitivity analysis. Useful for growth planning and investor discussions.
Board pack finance section: storyline, charts list, and narrative
Drafts a board-ready finance section outline including key charts, narrative, and talking points. Useful for CFO/FP&A preparing monthly/quarterly board materials.
Capex request evaluation: ROI, payback, and approval memo
Evaluates capex requests using ROI/payback metrics and drafts an approval memo with risks and assumptions. Useful for finance business partnering and capital committees.
Headcount planning model: hires, attrition, and cost impact
Builds a headcount planning model including start dates, attrition, and fully loaded cost impacts. Useful for annual planning and reforecasting.
Forecast accuracy retrospective: bias, MAPE, and process fixes
Analyzes forecast accuracy using metrics like MAPE and bias, and recommends process improvements. Useful for FP&A teams improving credibility and planning cadence.
SaaS Churn & LTV Analysis Model
Generates a Python script or Excel logic to calculate SaaS metrics. Perfect for FP&A professionals in the tech industry.
Rolling Forecast Model Logic
Creates a framework for a 12-month rolling forecast that updates monthly. Replaces static annual budgets.
Flexible Budget Variance Analysis
Adjusts the budget based on actual volume to isolate price and efficiency variances.
SaaS Rule of 40 Performance Review
Calculates the balance between growth and profitability for technology companies.
Zero-Based Budgeting (ZBB) Justification
Requires every expense to be justified from scratch rather than using last year as a baseline.
Product Line Profitability (Contribution Margin)
Analyzes which products contribute most to fixed costs and profit after variable expenses.
Standard Costing: Material & Labor Variances
Breaks down manufacturing variances into Price, Quantity, Rate, and Efficiency.
Break-Even Point Analysis (Multi-Product)
Calculates the point of zero profit for companies selling multiple items with different margins.
Cash Flow Forecast (Direct Method)
Projects short-term liquidity based on expected cash receipts and disbursements.
Activity-Based Costing (ABC) Allocation
Assigns overhead to products based on actual consumption of resources.
Executive Dashboard KPI Selection
Identifies the 'Vital Few' metrics for a specific industry to show in a board-level dashboard.
Working Capital Optimization Plan
Analyzes DSO, DPO, and DIO to free up cash trapped on the balance sheet.
Price-Volume-Mix (PVM) Analysis
Deconstructs revenue growth into its three core components for better sales visibility.
Inventory Valuation: LIFO vs FIFO Impact
Analyzes the effect of inventory cost flow assumptions on COGS and taxes.
Departmental Expense Budget Template
Provides a structured guide for managers to submit their annual spending requests.
Customer Acquisition Cost (CAC) vs LTV
Measures the efficiency of marketing spend relative to the lifetime value of a customer.
Board Reporting: Financial Highlights Memo
Summarizes quarterly performance for the Board of Directors using a narrative format.
Allocating Shared Service Costs (Corporate Overhead)
Determines how to charge back HR, IT, and Finance costs to operating business units.
Margin Bridge (EBITDA Bridge) Narrative
Explains the 'walk' from last year's EBITDA to this year's EBITDA.
Scenario Planning for Market Entry
Models three scenarios (Base, Best, Worst) for expanding into a new territory.
Inventory Turnover & Obsolescence Analysis
Identifies slow-moving stock and calculates the necessary valuation reserve.
Labor Productivity & Efficiency Reporting
Measures output per hour to identify bottlenecks in service or manufacturing.
Manufacturing: Inventory Absorption & Variance
Calculates the overhead absorbed into inventory and identifies under/over-absorbed amounts.
Hospitality: RevPAR & Occupancy Variance
Analyzes the key performance drivers for hotels and resorts.
Construction: Retainage & Cash Flow
Manages the 'held back' portion of construction payments.
Professional Services: WIP & Realization Rate
Measures the efficiency of a law or accounting firm's billable hours.
SaaS: Churn Analysis & Retention Bridge
Explains the walk from Opening ARR to Closing ARR.
Quarterly Firm Performance Dashboard (Internal)
Identifies the KPIs the Partners should track to measure the health of the practice.
Employee Onboarding Technical Checklist
Ensures new hires have the right software access and training from day one.