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
- 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.
How to use the template?
- 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. 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. All assumptions are illustrative ONLY, do not assume they are market data or standard.
- 4. As with all templates, feel free to create your own model from scratch, using this as a guide.
- 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.
Yes! This is absolutely free for you to download and use.
We will always keep your personal information safe.