Financial model template for ecommerce businesses. Operational assumptions - growth rate, repeat transaction rates, average revenues per order, customer acquisition costs - to create a revenue forecast plus key reports, including CAC, LTV, CAC payback period and more.
The free Ecommerce Model is the simplest structure of the models for forecasting Ecommerce businesses. 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. I built this tool 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.
It intentionally simplifies the business down to key inputs, and by default does not include expenses and a calculation of net income.
For financial statements and full financial reporting, including full support for SaaS and subscription businesses, check out the Standard Financial Model.
Show all 6 screenshots >
Below is a video that details how to use the assumptions on the
Get Started sheet, and details of how the customer retention and repeat orders calculations work on the
Make better decisions by mastering budgeting, forecasting, analysis, storytelling, in partnership with FP&A Prep. Live session masterclass to help founders build a finance capability in their company.
Join fellow founders for 5 live, 1.5 hour sessions to learn how to operationalize the finance function at your company. Creating a process to budget, forecast, analyze, and report the key metrics for your business is hard. We'll teach you what to care about, and how to do it.
Taylor Davidson, Founder, Foresight
I created the financial models behind Foresight so early-stage entrepreneurs can spend less time on finance and more time on their products. I care about financial modeling because I believe that financial models can help us make critical business decisions even if the models themselves are not “always right”. Financial models can help even the earliest entrepreneurs if we build “minimum viable models” to focus on the decisions that matter most.
You will have the option to download a Microsoft Excel .xlsx file and copy a Google Sheet file immediately after purchase or submission or your email, and anytime through the link in your email receipt, as well as by logging into my transaction provider at Gumroad and creating an account.
Foresight's spreadsheet models can be used in both Excel and Google Sheets interchangeably; simply upload the Microsoft Excel model template from Foresight into Google Sheets, or download the Google Sheets to Excel, and everything will structurally work fine.
The models are originally built in Google Sheets, and the formatting is a bit better in Google Sheets; in Excel you may want to adjust the row spacing, fonts, and chart formatting to get the aesthetics you want.
We accept credit cards, debit cards, and PayPal. The transmission of your billing information is encrypted using secure socket layer technology (SSL/TLS) and will be processed by Gumroad. Foresight does not have access to your payment details (why it's safe).
You'll get a payment receipt by email immediately after purchase. Note, you will see Gumroad, not Foresight, on your payment card or PayPal statement.
Get help buying. Call (or text, WhatsApp, et.al.) 1-646-770-0052.