Financial forecasting template for eComm

Financial model template for e-commerce startups with random customer return patterns. Ready-made Google Spreadsheet — enter your metrics and get a full financial model.

What's inside

• Unit economics for e-commerce (AOV = AIV × AIQ)
• Automatic forecast up to 36 months
• NPV, IRR, investor ROI with equity share
• Staffing schedule and fixed costs
• Visitor cohorts with random churn
• Seasonal variations included
• All formulas transparent, no macros

Revenue modeling

Revenue is modeled through unit economics. Enter metrics for the first and last month of sales — the model fills in the rest automatically using exponential growth.

Average order value (AOV) is determined by average item value (AIV) and average items per cart (AIQ).

Getting started

1. Buy the model — you'll receive a Google Sheet link
2. Copy it to your Google Drive
3. Fill in the fields on gray background (blue text) across all tabs
4. Done — the model calculates everything automatically

All values are approximate and for reference only — you enter your own data. License: use within your company, resale prohibited.

License Agreement

This License Agreement ("Agreement") is between you, the licensee, and Autónomo Daniil Khanin ESZ0548134A (the "Company"), operating under the laws of Spain. The Company owns the financial model (the "Product") and any modifications, additions, or customizations (the "Service") provided under this Agreement. This Agreement grants you a non-exclusive, non-transferable right to use and incorporate the Product and Service into personal and corporate projects for the organization that purchased the Product and/or Service.

You agree to the following:

1. Scope of Use

• You are permitted to use and integrate the Product and/or Service into personal and commercial projects for your company.
• You may modify the Product and/or Service to better suit your project's needs.
• Unlimited use of the purchased Product and/or Service is granted within your organization.
• If the licensee is an organization, all employees of that organization may use the same license.

2. Restrictions

• You are not allowed to distribute, sublicense, or resell the Product and/or Service.
• You cannot distribute, license, or sell derivative, recompiled, reverse-engineered, or modified versions.
• The Product and/or Service cannot be used in projects for other organizations.
• The Product and/or Service is provided "as is," without warranty of any kind.
• The Company retains all rights, title, intellectual property, and interest in the Product and/or Service.

This Agreement is governed by the laws of Spain. Legal proceedings may only be initiated in the courts of Barcelona. Contact: daniil@khanin.info.