Academy/Module 4

Practical: build your own forecast

Build your own forecast

Lesson 7 of 7 10 min

You've seen how to model revenue and every major expense line. Now put it together into a forecast for your store. There are two ways to do it — build it by hand from our template, or connect your tools and let Foreqast build and maintain it for you.

Option A · Do it yourself

Download the template and build your forecast

Our free 12-month cash-flow template already has the formulas wired up — revenue from orders × AOV, the expense lines you just learned to model, and cash balance and runway on top. Drop in your numbers and your forecast comes to life. It works in both Excel and Google Sheets.

Want the walkthrough first? See the template guide or revisit the 5-step forecast from Module 2.

Option B · Do it automatically

Build your forecast automatically with Foreqast

A spreadsheet is a great way to learn the model — but it needs constant upkeep. Foreqast ships with the same model already built and keeps it live. Connect your stack once and your forecast updates itself from real data, every day.

  • Sync your store — Shopify feeds orders, average order value, and refunds into your revenue line.
  • Connect your ads — Meta and Google spend flows straight into your expense and paid-revenue model.
  • Get forecasts automatically — cash flow, cash balance, and runway, recalculated from your real numbers with the drivers underneath every line.

Free for 14 days, no credit card required.