Sales forecast planner

Create detailed 12-month sales forecasts and revenue projections for your product using key financial metrics and growth indicators.
Back to prompts
Category
Finances
Stats
47 views
0 copies
0 likes

Prompt

Open in ChatGPT
Copy
Build table business predictive finance for a single product in 12 months with these info: average selling price: #
{{price}}
, monthly growth rate: #
{{growth}}
, first month successful order number: #
{{orders}}
, percentage of last month's revenue spent on sales and marketing: #
{{marketing}}
, net cost for each order: #
{{cost}}
Price
Growth
Orders
Marketing
Cost

This tool helps you build a comprehensive 12-month sales forecast for a single product by analyzing key financial metrics. The forecast is presented in table format, showing how your product sales might grow over time based on initial conditions and growth assumptions.

How to Use

  1. Enter your key financial parameters into the prompt
  2. Review the generated 12-month sales forecast table
  3. Use the results for budgeting, planning, or investor presentations

Variables Explained

  • {{price}}: The average selling price of your product (in currency units)
  • {{growth}}: Expected monthly growth rate (as a percentage, e.g., 5 for 5%)
  • {{orders}}: Number of successful orders expected in the first month
  • {{marketing}}: Percentage of the previous month's revenue to be allocated to sales and marketing efforts
  • {{cost}}: Net cost per order (includes manufacturing, fulfillment, etc.)

Tips for Accurate Forecasting

  • Be realistic with growth rates: Unless you have strong evidence, avoid projecting unsustainable growth rates
  • Consider seasonality: If your product has seasonal variations, you may need to adjust the monthly growth rates accordingly
  • Update regularly: Revisit your forecast monthly or quarterly to adjust based on actual performance
  • Use historical data: If available, base your initial parameters on past performance rather than aspirational targets

Example Use Case

A SaaS company launching a new $49 monthly subscription with 100 initial customers, 8% monthly growth, $15 cost per order, and 25% marketing spend would input: price=49, growth=8, orders=100, marketing=25, cost=15

Want to 10x your AI skills?

Get a free account and learn to code + market your apps using AI (with or without vibes!).

Nah, maybe later