Financial Forecasting Scenario Builder & Risk Assessment Tool
Act as a financial analyst specializing in small business forecasting. Build 3 financial forecasting scenarios (optimistic, baseline, pessimistic) for a [café business] with the following baseline data: [monthly revenue $50,000, COGS 30%, fixed costs $15,000, monthly growth rate 2%]. For each scenario, provide: 1) 12-month projected profit and loss (P&L) summary, 2) Key assumptions (e.g., 10% revenue growth for optimistic), 3) Break-even point calculation, 4) Risk factors specific to the scenario, 5) Mitigation strategies for pessimistic scenario risks.ADVERTISEMENT - IN-ARTICLE
Implementation Guide
This prompt empowers accountants and small business owners to create financial forecasting scenarios in 1 hour instead of 8+ hours of manual modeling. By specifying the business type and baseline data, ChatGPT/Claude generates three scenarios (optimistic, baseline, pessimistic) with 12-month P&L summaries, key assumptions, break-even calculations, and risk mitigation strategies. The output helps businesses plan for different market conditions, reducing financial risk and improving decision-making (e.g., hiring, expansion). Ideal for cafes, retail stores, and freelance businesses, it adapts to both short-term (12-month) and long-term (5-year) forecasting needs, and supports cash flow forecasting with minor prompt tweaks.