Ecommerce Forecasting Tool

Welcome to the new site. Problems, use store.hemrock.com

Ecommerce Forecasting Tool

Financial model template for ecommerce businesses, using a cohort-based approach to model new and repeat customers and calculate revenues.

5.0(32)2,788 downloads

Ecommerce Forecasting Tool Tutorial
1.2ร—
7 minโšก๏ธ8 min 47 sec7 min 2 sec5 min 51 sec4 min 41 sec4 min 8 sec3 min 31 sec2 min 48 sec
Introduction
1.2ร—
7 minโšก๏ธ8 min 47 sec7 min 2 sec5 min 51 sec4 min 41 sec4 min 8 sec3 min 31 sec2 min 48 sec
Introduction
    • heart
      1
    • yes
      2
    • fire
      3
    • clap
      4
    • yay
      5
    • eyes
      6
  • More reactions
    7

    Frequently Used

    Smileys & Emotion

    People & Body

    Animals & Nature

    Food & Drink

    Activities

    Travel & Places

    Objects

    Symbols

    Flags

    Make frequently used emojis my default
Comment
C
0 Comments
Start with a suggestion from Loom AILoom AI
Be the first to comment
HitCto reply to Taylor or leave a comment at the top of this panel.
Pay what you want

$20 suggested, but "0" is ok. All donations appreciated.

$USD

Instant Access

Download to Excel or Copy to Google Sheets
Easy to customize with your AI
Free email support

License and Terms apply on all purchases, services, and courses.

Get help buying. Call, text, WhatsApp 1-646-770-0052.

Highlights

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.

Optional Historicals sheet allows you to drop in historical cohort retention data to automatically analyze past performance and use past retention to forecast future cohort performance.

For financial statements and full financial reporting, including full support for SaaS and subscription businesses, check out the Standard Financial Model.

What you'll do with it

Forecast an ecommerce or transaction-style business. Inputs for acquisitions, repeat behavior, prices, cost of goods sold, acquisition cost. Outputs revenues, retention curves, CAC, LTV, contribution per cohort.

Intentionally simple. No expenses, no income statement. Optional Historicals sheet, drop in historical cohort retention data to analyze past performance and project forward.

When to use this vs. the Standard Financial Model

This is a focused tool for forecasting ecommerce revenue mechanics. If you need full financial statements, expenses, inventory accounting, hiring plans, and cap table, use the Standard Financial Model, same ecommerce revenue logic plus everything else.

Edit with AI

Cells open. Inputs in blue, formulas in black. Built to be edited.

Documentation

Ratings

5.0(32 ratings)
5
100%
4
0%
3
0%
2
0%
1
0%

Reviews

No reviews yet. Used this product? Sign in to leave a review.