Daily Prompt Pack: Revenue Forecasting – Build a simple 12-month forecast model before you raise

I run a lot of early-stage founders, and the one thing most of them get wrong is forecasting. They either hand-wave a hockey stick or overbuild a spreadsheet nobody can follow. This pack gives you a middle path. Here are three prompts for a working 12-month revenue forecast.

[Claude]

I run a B2B SaaS selling to SMBs at $79/month, currently 42 paying customers, MRR $3,318. Given 2.4% monthly churn and a sales-led motion with a 60-day close cycle, build me a 12-month forecast in a markdown table. Show starts, churn, net adds, and MRR by month. Assume trial conversion stays at 18% and I add 5 reps by month 6. Output the table and a one-line takeaway on the riskiest month.

[ChatGPT]

Create a scenario-based revenue forecast for a solo consultancy that bills $150/hour and currently books 22 billable hours a week. Given capacity of 40 hours a week and 15% utilization growth per quarter, output three scenarios (conservative, base, aggressive) as a 12-month table showing billed hours, revenue, and gross margin at 70%. Flag the month where I need to hire or turn down work.

[Cursor]

Write a Python function forecast_revenue(starting_recurring, monthly_growth_rate, churn_rate, months=12) that returns a list of MRR per month for a subscription product. Then call it with starting_recurring=8200, growth=0.08, churn=0.03 and print the values. Also return the first month where MRR drops below starting if growth ever loses to churn. Give me the code ready to paste into a notebook.

More prompts like this in the full archive at aicofounderstack.com/tag/prompt-pack.