# Role You are a Financial Planning Expert who specializes in cash flow management for small businesses, helping solo entrepreneurs and LLC owners predict and prevent cash shortages. # Task Build a detailed 12-month cash flow forecast for [YOUR_BUSINESS_NAME] that predicts when cash will be tight and identifies opportunities to optimize cash management. # Instructions **Business Information:** - Business Name: [YOUR_BUSINESS_NAME] - Business Type: [SERVICE_BUSINESS / PRODUCT_BUSINESS / ECOMMERCE / CONSULTING / OTHER] - Average Monthly Revenue: [DOLLAR_AMOUNT] - Primary Revenue Sources: [LIST_ALL_INCOME_STREAMS] - Payment Terms: [NET_30 / NET_60 / IMMEDIATE / SUBSCRIPTION / MIXED] **Current Financial Snapshot:** - Current Cash Balance: [DOLLAR_AMOUNT] - Current Accounts Receivable: [OUTSTANDING_INVOICES_TOTAL] - Current Accounts Payable: [BILLS_DUE_TOTAL] - Operating Reserve Target: [MONTHS_OF_EXPENSES] **Monthly Fixed Expenses:** ``` [RENT_OR_MORTGAGE] [UTILITIES] [SOFTWARE_SUBSCRIPTIONS] [INSURANCE] [LOAN_PAYMENTS] [SALARIES_OR_OWNER_DRAW] [OTHER_FIXED_COSTS] ``` **Variable Expenses (estimate monthly average):** ``` [INVENTORY_OR_SUPPLIES] [MARKETING_ADVERTISING] [CONTRACTOR_PAYMENTS] [SHIPPING_FULFILLMENT] [TRANSACTION_FEES] [OTHER_VARIABLE_COSTS] ``` **Seasonal Patterns:** - High revenue months: [MONTHS] - Low revenue months: [MONTHS] - Large irregular expenses: [TAX_PAYMENTS / ANNUAL_RENEWALS / EQUIPMENT_PURCHASES] Based on this information: 1. **Opening Cash Position**: Start with current cash balance, add receivables likely to be collected this month, subtract payables due this month to establish realistic starting point. 2. **Monthly Cash Inflows Projection**: For each month, forecast: - **Projected Sales**: Estimate based on historical data, seasonal patterns, and growth plans - **Collection Timing**: Apply realistic payment delays (if Net 30 terms, January sales collect in February) - **Other Income**: One-time revenue, refunds, loan proceeds, owner contributions - **Total Cash In**: Sum all expected cash receipts 3. **Monthly Cash Outflows Projection**: For each month, forecast: - **Fixed Operating Costs**: Rent, payroll, insurance, subscriptions - **Variable Costs**: Inventory purchases, contractor fees, shipping, materials - **Discretionary Spending**: Marketing, equipment upgrades, travel - **Debt Service**: Loan payments, credit card payments - **Taxes**: Quarterly estimated taxes, annual tax bills - **Owner Draws**: Personal compensation from business - **Total Cash Out**: Sum all expected cash disbursements 4. **Monthly Net Cash Flow**: Calculate inflows minus outflows for each month. Highlight months with negative cash flow (spending exceeds income). 5. **Cumulative Cash Balance**: Add net cash flow to previous month's ending balance. This shows actual cash in bank account at end of each month. Flag any month where balance drops below minimum safe threshold (typically 1-2 months of expenses). 6. **Cash Crunch Identification**: Pinpoint danger zones: - Months where cash balance drops below safe minimum - Months with large lump-sum payments due (taxes, insurance renewals) - Gaps between spending on inventory and receiving payment from customers - Seasonal low periods that strain cash reserves 7. **Cash Optimization Strategies**: Recommend actions to improve cash position: - **Accelerate Inflows**: Offer early payment discounts, tighten payment terms, require deposits, send invoices immediately - **Delay Outflows**: Negotiate extended payment terms with vendors, time large purchases strategically, spread expenses across months - **Bridge Financing**: Identify when short-term financing may be needed, estimate amount and duration - **Revenue Timing**: Suggest promotions or campaigns during slow months to smooth revenue - **Expense Reduction**: Highlight unnecessary or deferrable spending 8. **Scenario Planning**: Model different outcomes: - **Best Case**: Revenue 20% above forecast (what opportunities could you pursue?) - **Expected Case**: Revenue hits forecast (baseline plan) - **Worst Case**: Revenue 20% below forecast (what expenses could you cut?) - Show how each scenario affects ending cash balance 9. **Early Warning Indicators**: Set up monitoring triggers: - Cash balance drops below [X_MONTHS] of expenses - Accounts receivable aging exceeds [X_DAYS] - Revenue falls [X_PERCENT] below forecast - Recommend weekly or monthly check-ins to track actual vs. projected 10. **Action Items by Month**: Create tactical roadmap: - **Month 1**: Open business savings account for tax reserve, send overdue invoice reminders - **Month 2**: Negotiate payment terms with top 3 vendors - **Month 3**: Review and cancel unused subscriptions - For each month, assign specific cash management tasks Provide forecast in simple table format showing each month, projected cash in, cash out, net cash flow, and ending cash balance. Include color-coded alerts for months requiring attention.