Forecast Cash Flow

Pull my monthly revenue for the last 12 months using ShopifyQL to establish a real sales trend line, then use that trend (instead of a guess) as the inflow base for my cash flow forecast below.

Business Financials:

  Average monthly revenue: [MONTHLY REVENUE]
  Average monthly expenses: [MONTHLY EXPENSES]
  Current cash on hand: [CASH BALANCE]
  Outstanding accounts receivable: [IF ANY, e.g., wholesale invoices]
  Outstanding accounts payable: [UNPAID BILLS OR INVENTORY ORDERS]
  Credit line available: [IF ANY]


Revenue Projections:

  Historical monthly revenue for the past [6 / 12] months: use the live ShopifyQL pull above as the base trend
  Known upcoming events that affect sales: [PRODUCT LAUNCHES / SALES / SEASONAL PEAKS]
  Expected growth rate: [PROJECTED MONTHLY GROWTH PERCENTAGE]
  Seasonal adjustment factors: [HIGH MONTHS AND LOW MONTHS]


Expense Projections:

  Fixed monthly expenses (rent, subscriptions, salaries): [TOTAL FIXED COSTS]
  Variable expenses as percentage of revenue: [PERCENTAGE, e.g., 40%]
  Planned large purchases: [LIST ANY UPCOMING INVENTORY ORDERS OR EQUIPMENT]
  Upcoming annual or quarterly payments: [LIST WITH AMOUNTS AND DUE DATES]


Cash Flow Timing Factors:

  Shopify payout schedule: [DAILY / WEEKLY / BIWEEKLY]
  Average payout delay from Shopify: [NUMBER OF DAYS]
  Supplier payment terms: [NET 30 / PREPAID / OTHER]
  Inventory lead time: [WEEKS FROM ORDER TO RECEIPT]


Forecast Output:

  Weekly cash flow projection for the next [4 / 8 / 12] weeks
  Monthly cash flow projection for the next [3 / 6 / 12] months
  Identify weeks or months where cash balance drops below [MINIMUM THRESHOLD]
  Best case, worst case, and expected scenarios
  Break-even daily revenue needed to cover all fixed costs


Cash Management Recommendations:

  When to place inventory orders to optimize cash timing
  Whether to negotiate longer payment terms with suppliers
  Optimal timing for large marketing spend
  Emergency cash reserve target based on expense profile


Present the forecast in a clear table format with running cash balance.