Cash Flow Forecast Designer (App)
The Cash Flow Forecast Designer (App) prompt, for financial controllers and SaaS product designers, creates a detailed structural blueprint for a cash flow forecasting tool, encompassing calculation logic, visualization, and a 12-month projection model.
What is the Cash Flow Forecast Designer (App) prompt?
Copy the prompt below into ChatGPT, Gemini, Claude or any capable LLM, replace the bracketed variables with your own values, and run it.
ROLE: You are an expert Financial Controller and SaaS Product Designer specializing in cash flow management, liquidity forecasting, and financial modeling. Your goal is to design a comprehensive, user-friendly cash flow forecasting application architecture or tool based on specific business data. GOAL: Produce a detailed structural blueprint for a Cash Flow Forecast Tool that translates raw accounting data into actionable insights. You must provide the calculation logic, visualization recommendations, and a 12-month projection model tailored to the user’s specific industry and constraints. CONTEXT: Business Type: [BUSINESS TYPE] Primary Revenue Streams: [REVENUE STREAMS] Major Expense Categories: [EXPENSE CATEGORIES] Current Cash Position: [CURRENT CASH BALANCE] Forecast Interval: [WEEKLY OR MONTHLY] Growth Assumptions: [GROWTH PERCENTAGE OR TRENDS] INSTRUCTIONS: 1. Data Architecture: Define the necessary data inputs (AP/AR, payroll, recurring subscriptions, tax obligations) required to build an accurate forecast for a [BUSINESS TYPE]. 2. Calculation Engine: Outline the logic for "Projected Ending Balance." Incorporate formulas that account for [REVENUE STREAMS] and subtract [EXPENSE CATEGORIES] while adjusting for [GROWTH PERCENTAGE OR TRENDS]. 3. Scenario Modeling: Create a framework for "Best Case," "Worst Case," and "Most Likely" scenarios. Define how the tool should handle late payments or unexpected capital expenditures. 4. Liquidity Health Indicators: Identify key performance indicators (KPIs) to display, such as Burn Rate, Runway (in months), and Working Capital Ratio. 5. User Interface Design: Describe a dashboard layout that prioritizes high-level visibility for executives while allowing for "drill-down" analysis into individual line items. 6. Risk Mitigation: Suggest automated alerts for when the [CURRENT CASH BALANCE] is projected to fall below a predefined safety threshold. OUTPUT FORMAT: The final output should be a structured "Product Requirement Document" (PRD) logic flow. Organize it with the following clear labels: - EXECUTIVE SUMMARY - DATA INPUT & INTEGRATION STRATEGY - FORECASTING LOGIC & FORMULAS - SCENARIO ANALYSIS PARAMETERS - DASHBOARD & VISUALIZATION SPECIFICATIONS - ACTIONABLE INSIGHTS GENERATION QUALITY BAR: The output must avoid generic financial advice. It must be a technical design blueprint that a developer could use to begin building a tool or a CFO could use to build a robust spreadsheet model. Ensure the [FORECAST INTERVAL] is strictly adhered to in the structural design. Explicitly account for the volatility inherent in [REVENUE STREAMS].
What variables does the Cash Flow Forecast Designer (App) prompt use?
| Variable | What to put | Example |
|---|---|---|
| [BUSINESS TYPE] | The specific industry or operational model of the business (e.g., B2B SaaS, Retail E-commerce, Manufacturing). | B2B SaaS |
| [REVENUE STREAMS] | The primary sources of income for the business (e.g., Subscription fees, Product sales, Consulting services). | Monthly subscriptions, usage-based fees, professional services |
| [EXPENSE CATEGORIES] | The major types of expenditures (e.g., Payroll, Marketing, COGS, Rent, Cloud Infrastructure). | Employee salaries, cloud hosting, marketing spend, office rent |
| [CURRENT CASH BALANCE] | The starting cash on hand for the forecast (e.g., $500,000). | $1,250,000 |
| [WEEKLY OR MONTHLY] | The desired granularity for the forecast interval (specify 'Weekly' or 'Monthly'). | Monthly |
| [GROWTH PERCENTAGE OR TRENDS] | Assumptions about revenue and/or expense growth (e.g., '10% monthly revenue growth', 'Seasonal Q4 spike'). | 15% year-over-year revenue growth, 5% annual expense inflation |
How do I use the Cash Flow Forecast Designer (App) prompt?
- 1Step 1: Understand your business's financial data, including revenue streams, expense categories, and growth assumptions.
- 2Step 2: Replace all bracketed placeholders within the 'CONTEXT' section of the prompt with your specific financial details.
- 3Step 3: Run the prompt with the fully customized input.
- 4Step 4: Review the generated 'Product Requirement Document' for clarity, completeness, and alignment with your business needs.
- 5Step 5: Use the output as a foundational document for developers or financial strategists to build or refine your cash flow forecasting tool.
When should you use the Cash Flow Forecast Designer (App) prompt?
Startup Financial Planning
Helps early-stage companies design a robust cash flow tool for managing dynamic finances and securing funding.
SaaS Product Development
Provides a comprehensive architectural plan for building a new financial forecasting feature within a SaaS platform.
Corporate Treasury Management
Assists established businesses in designing an internal tool to optimize liquidity, manage working capital, and mitigate financial risks.
Consulting Engagements
Enables financial consultants to rapidly generate tailored tool designs for clients across various industries.
Educational Simulations
Supports academic institutions in creating realistic case studies and simulation tools for finance and business students.
What does the Cash Flow Forecast Designer (App) prompt output look like?
EXECUTIVE SUMMARY This document outlines the architectural blueprint for a Cash Flow Forecast Tool tailored for a B2B SaaS company, designed to provide comprehensive liquidity insights over a 12-month horizon. It focuses on granular data integration from accounting systems to deliver actionable financial projections, scenario modeling, and key liquidity indicators for executive decision-making. DATA INPUT & INTEGRATION STRATEGY Required data inputs include Accounts Receivable (subscription invoices, usage overages), Accounts Payable (vendor bills, operational expenses), detailed payroll reports, recurring software subscriptions, and estimated tax obligations. Integration via API with QuickBooks Online and Stripe for revenue data, and Expensify for expense categorization. FORECASTING LOGIC & FORMULAS Projected Ending Balance = Beginning Balance + Projected Cash Inflows (Subscriptions + Usage Fees) - Projected Cash Outflows (Payroll + Hosting + Marketing + Rent + Taxes). Revenue growth assumes a 15% YoY increase based on historical trends. Expenses are adjusted for 5% annual inflation. SCENARIO ANALYSIS PARAMETERS Best Case: 20% YoY revenue growth, 95% on-time AR collection. Worst Case: 5% YoY revenue growth, 70% on-time AR collection, 1 unanticipated $50k capital expenditure in Q3. Most Likely: 15% YoY revenue growth, 85% on-time AR collection. DASHBOARD & VISUALIZATION SPECIFICATIONS Dashboard features high-level cash balance trend line with drill-down to monthly details. KPIs: Burn Rate (monthly), Runway (months of cash), Working Capital Ratio. Interactive charts for revenue vs. expense, and scenario comparisons. Executive view: simplified visual summary. Detailed view: table with line-item breakdown. ACTIONABLE INSIGHTS GENERATION Automated alerts when projected cash falls below $500,000 or when Burn Rate increases by more than 10% month-over-month. Recommendations for optimizing AR collection or renegotiating vendor terms based on cash runway predictions.
Which AI model works best with the Cash Flow Forecast Designer (App) prompt?
Excels at complex structural design, detailed logic, and integrating multiple constraints into a coherent, high-quality output.
Strong in understanding financial concepts and generating nuanced, industry-specific recommendations for both technical architecture and user experience.
Capable of producing well-structured, lengthy documents like PRDs, with good adherence to formatting and clear separation of sections.
What are the pros and cons of the Cash Flow Forecast Designer (App) prompt?
Pros
- Generates detailed, actionable architectural blueprints.
- Customizes to specific business types and financial constraints.
- Includes critical financial calculation logic and KPIs.
- Provides framework for scenario modeling (Best/Worst/Most Likely).
- Tailors user interface and alerts for practical application.
- Expert role setup ensures high-quality financial insights.
Cons
- Requires precise input for business details to be effective.
- Output is a design, not a ready-to-use application.
- May require minor refinement by a human expert for very niche industries.
How can you get better results from the Cash Flow Forecast Designer (App) prompt?
- Be as specific as possible with all bracketed variables.
- For 'Growth Assumptions', indicate if it applies to revenue, expenses, or both.
- Specify existing accounting software or data sources if relevant for data integration.
- Consider adding a 'Contingency Fund' variable for even more realistic scenarios.
- After generating, review the calculation logic carefully for your specific context.
Frequently asked questions about the Cash Flow Forecast Designer (App) prompt
What is the Cash Flow Forecast Designer (App) prompt?
This prompt acts as an expert financial controller and SaaS product designer, generating a comprehensive architectural blueprint for a customized cash flow forecasting application or tool based on your specific business data.
Who is this prompt best suited for?
It is ideal for financial controllers, SaaS product managers, business owners, and financial consultants who need a structured plan for developing or enhancing their cash flow management tools.
What kind of output does this prompt produce?
The prompt outputs a detailed 'Product Requirement Document' (PRD) logic flow, covering data architecture, calculation engine logic, scenario modeling, KPIs, and UI design recommendations.
Do I need to be a financial expert to use this prompt?
While it helps to understand your own business's finances, the prompt is designed to guide you. You just need to accurately provide the requested business data in the bracketed variables.
Can this prompt handle different business types?
Yes, it is highly customizable. By specifying your '[BUSINESS TYPE]', '[REVENUE STREAMS]', and '[EXPENSE CATEGORIES]', it tailors the design to your specific operational model.
Does it provide the actual code for an application?
No, it provides a technical design blueprint and logic, which developers can then use to write the actual code for your cash flow forecasting application.
Which AI model works best with this prompt?
GPT-4o, Gemini 2.5 Pro, and Claude Sonnet are recommended due to their strong performance in generating structured, detailed, and technically specific outputs required for this kind of design document.
How can I improve the quality of the output?
Provide highly specific and detailed information for each of the bracketed variables. The more granular your input, the more tailored and effective the generated design will be.