{{organization_name}}
Organization Name
Example: Example: Nova Foods Ltd.
Enter the organization considering the new product line.
Ready to Use
Complete Prompt
This prompt has variables that can be replaced with your own information. Copy and use it with your preferred LLM, or try it out in the LearnerBox Prompt Playground.
Act as a senior FP&A and commercial finance analyst specializing in cost-volume-profit analysis.
Develop a financial forecast for the proposed new product line using the information provided below.
Organization:
{{organization_name}}
Product description:
{{product_description}}
Forecast horizon:
{{forecast_horizon}}
Price and demand assumptions:
{{price_demand_assumptions}}
Variable cost assumptions:
{{variable_costs}}
Fixed and launch costs:
{{fixed_launch_costs}}
Capacity and operational constraints:
{{capacity_constraints}}
Analysis requirements:
1. Define the unit economics for the product.
2. Calculate:
- selling price per unit;
- variable cost per unit;
- contribution per unit;
- contribution margin percentage;
- total fixed cost;
- break-even volume;
- break-even revenue;
- margin of safety; and
- target-profit volume.
3. Separate:
- direct variable costs;
- semi-variable costs;
- incremental fixed costs;
- allocated existing overhead;
- one-time launch costs;
- capital expenditure; and
- working-capital requirements.
4. Build monthly or quarterly forecasts for:
- units sold;
- revenue;
- variable cost;
- contribution;
- fixed cost;
- operating profit;
- cash flow; and
- cumulative cash recovery.
5. Develop downside, base, and upside scenarios.
6. Conduct sensitivity analysis for:
- price;
- volume;
- variable cost;
- launch delay;
- utilization;
- customer acquisition cost;
- returns or defects; and
- cannibalization.
7. Evaluate capacity limits, ramp-up timing, production yield, and supply constraints.
8. Identify whether existing overhead allocation changes the economic decision or only the accounting presentation.
9. Evaluate potential cannibalization of existing products.
10. Identify key assumptions requiring commercial, operational, procurement, tax, or accounting validation.
11. Do not invent demand, customer behavior, costs, capacity, market share, or tax effects.
12. Distinguish accounting profit, contribution, cash flow, and investment recovery.
Present the result as:
{{output_format}}
Include:
- unit-economics table;
- CVP calculations;
- break-even chart specification;
- monthly or quarterly forecast;
- downside, base, and upside scenarios;
- sensitivity table;
- capacity and ramp-up analysis;
- cannibalization assessment;
- cash-recovery profile;
- key risks;
- validation questions; and
- go, revise, or defer decision framework.Customization Variables
Replace each variable shown in double curly brackets with accurate information from your own professional context.
{{product_description}}
Product Description
Example: Describe the product, target customers, channel, launch timing, and strategic purpose.
Include enough commercial context to interpret the financial assumptions.
{{forecast_horizon}}
Forecast Horizon
Example: Example: Monthly for 36 months
Specify the planning period and frequency.
{{price_demand_assumptions}}
Price and Demand Assumptions
Example: Provide selling prices, volumes, ramp-up, customers, discounts, returns, and channel mix.
Use explicit demand and price assumptions for each scenario.
{{variable_costs}}
Variable Cost Assumptions
Example: List materials, labor, freight, commissions, packaging, transaction fees, and warranty costs per unit.
Separate truly variable costs from fixed or semi-variable costs.
{{fixed_launch_costs}}
Fixed and Launch Costs
Example: List marketing, development, equipment, systems, staffing, compliance, and other fixed costs.
Distinguish one-time launch costs from recurring fixed costs.
{{capacity_constraints}}
Capacity and Operational Constraints
Example: Describe production capacity, yield, lead times, minimum orders, staffing, and supply constraints.
Operational constraints may limit achievable volume and timing.
{{output_format}}
Output Format
Choose the format appropriate for analysis, approval, or model construction.
Expected Output
A complete new-product CVP model containing unit economics, break-even analysis, scenarios, sensitivities, capacity constraints, cash recovery, cannibalization, risks, and a decision framework.
💡 Important:
The quality of the result depends on the
completeness, accuracy, and relevance of the
information supplied to the AI.
Prompt Characteristics
These characteristics describe the type of thinking, customization, and output structure involved in using this prompt effectively.
Prompt Anatomy
This breakdown explains how the prompt’s major components work together to guide the AI toward a useful, reliable, and well-structured response.
Role
Positions the AI as an FP&A and commercial finance specialist in CVP analysis.
Context
Defines the product, horizon, demand, pricing, costs, capacity, and launch conditions.
Task
Requires a complete unit-economics, break-even, scenario, sensitivity, and cash-recovery model.
Constraints
Prevents invented demand, costs, market share, capacity, customer behavior, and tax effects.
Output Structure
Requires CVP calculations, scenarios, sensitivities, capacity analysis, risks, and decision framework.
Input Variables
Organization, product description, horizon, price and demand, variable costs, fixed costs, constraints, and output format.
Customization Tips
- Separate incremental fixed costs from allocated existing overhead.
- Model ramp-up and launch delay rather than assuming immediate steady-state volume.
- Include returns, defects, discounts, commissions, and customer-acquisition costs.
- Test price and volume together because they may not change independently.
- Add working-capital and capital-expenditure requirements to distinguish profit from cash viability.
Responsible Professional Use
Review Before Applying the Output
AI-generated responses can contain errors, omissions, unsupported assumptions, outdated information, or recommendations that do not reflect your jurisdiction or professional context.
Verify calculations, evidence, regulations, standards, policies, and professional recommendations before relying on the result. The qualified professional remains responsible for the final decision.