Ecommerce Forecasting Tool

Four-year financial model template for Excel or Google Sheets for e-commerce or retail-style revenue models. The model uses inputs such as future growth rate, repeat transaction rates, average revenues per order, customer acquisition costs, and builds out a full set of e-commerce metrics, including CAC, LTV, CAC payback period, and more.

Download Template
Key Features
  • The free Ecommerce Model is the simplest structure of the models for forecasting Ecommerce businesses.
  • Built to help entrepreneurs understand the mechanics behind forecasting the growth and revenues of an ecommerce business, in a package that is easy to use, easy to edit, and easy to understand.
  • Creates a forecast of acquisitions, retentions, revenues, acquisition costs, cost of goods sold, CAC and LTV, and is easy to use for ecommerce or transaction-style businesses.
About this template

How to use the template?

  1. 1. Any number in blue with a grey shaded background is an input (i.e. an assumption or data point that can be changed), anything in black is the result of a formula. Change blue at will, change anything in black with caution.
  2. 2. All cells and formulas are unlocked - as in all Foresight models - so that you can make edits as needed and completely understand what is going on.
  3. 3. All assumptions are illustrative ONLY, do not assume they are market data or standard.
  4. 4. As with all templates, feel free to create your own model from scratch, using this as a guide.
  5. 5. The model is constructed to fit a wide variety of businesses, and therefore, some sections may or may not be relevant to yours. I have grouped together sections on all sheets so that you can review different sections and see all the possibilities, but also easily hide the sections not relevant for you. Simply click on the "+" button on the left-hand side to unhide a section, and click on the "-" button to hide it."

Visit Foresight to get more instructions and videos on how to use the model.

Frequently Asked Questions (FAQs)
Is this actually free?

Yes! This is absolutely free for you to download and use.

Why should I fill out my information?

We will always keep your personal information safe.

We will not, in any circumstances, share your personal information with other individuals or organizations. We ask for your information in exchange for valuable resources in order to improve your browsing experience and send you communications that we think would be valuable to you. You can read more about our privacy policy.

Download and start using the SaaS Forecasting tool today!