The new Starter Model. Save $30 with code THANKYOU.  Click here
  +1.646.770.0052         hello@foresight.is
New · 2017 Best for ecommerce and retail businesses looking to model customers, orders, products sold, inventory, revenues, and cost of goods sold, combined with consolidated financial statements, cash flow analysis, funding needs, cap table, and valuation. Works for one-time and subscription revenues. Extendable up to hundreds of products and SKUs.
  • The Ecommerce Financial Model is for businesses with the need to create a comprehensive five year forecast (covering monthly, quarterly and annual results) for fundraising or business planning.
  • Start from scratch, or import your historical financial data.
  • Forecast the potential operational and financial future of your ecommerce and/or physical retail business. The model helps to project traffic, customer acquisition, orders and customers, product SKUs sold, and inventory management. It uses the prices of products sold to forecast average order value, revenues, and cost of goods sold, aggregating automatically to consolidated financial statements and a cash flow analysis, forecast of funding needs, cap table, and valuation. Supports up to 10 unique products (SKUs), but can be extended for up to hundreds of SKUs.
  • Create a hiring plan, forecast your revenues, operating expenses and full financial statements in under an hour.
  • Instant download, use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.
  • Everything can be modified to add in your own unique revenue calculations, as all formulas and cells are completely open and unlocked.
  • Purchase one-time, download instantly, customize however and whenever you want. Any updates to the model are emailed to you or can be re-downloaded anytime for free.
  • Ecommerce or phyical retail companies.
  • Works for companies starting from scratch as well as companies with multiple years of historical operational and financial data that they want to use in reporting and forecasting.
  • Focuses on creating a monthly and quarterly forecast of revenues, costs and cashflows over a 5 year period.
  1. README. Description of model, layout, and how to use it.
  2. Outline. Flowchart of how the model works, with a description of every sheet and their goals.
  3. How To. Documentation that details of each sheet and how the inputs and calculations work. Assumptions and calculations are noted and explained throughout the model.
  4. Settings. Model-wide assumptions and settings for acquisition flow, with a full walkthrough of what every calculation and term means.
  5. Summary. Key operational and financial metrics organized in a clean summary, reported over 5 years, built to be easily customizable for your key metrics and timeframes.
  6. Key Reports. Charts and tables of costs, active users (optional), cash on hand, revenue and revenue growth rate, net income and cumulative net income, margins, sources and uses, and more.
  7. Costs. Simple yet robust methodology for creating a cost budget for up to 60 months of operations, including a detailed hiring plan, while also automatically handling the accounting treatment of the expenses. Set hiring, salaries, roles, and when to hire, including a method to automatically calculate hiring as the company scales. Flexible inputs to input all costs easily on a month by month basis. Expenses can be allocated to key expense areas and labled for accounting treatment as SG&A, COGS, or CAPEX.
  8. Revenues. User acquisition using organic and paid acquisition methods, and models direct and one third-party channel. Uses a robust, detailed methodology to create a forecast of customers, orders, and products purchased over time. If needed, can forecast cost of goods sold (COGS), inventories, changes in inventory levels and inventory purchases, shipping revenue and costs, discounts, affiliates, and chargebacks and refunds.
  9. Forecast. Consolidated financial statements, including income statement, balance sheet, and statement of cash flows. Includes a detailed cash flow forecast that automatically forecasts funding requirements based on a simple assumption of how many months expenses to raise money for. Use this sheet for forecasting only, or bring in your historical financials to show either a mix of the past and the future, or to compare budgets to forecasts.
  10. Cap Table. (Optional) The cap table in the Ecommerce Model is the Cap Table Model integrated into the cash flows of the business, mapping forecasted expenses and net burn to needed fundraising to estimated funding rounds by size and date. Models equity, convertible note and SAFE financing rounds, mapped to expected financing dates and amounts. Exit waterfall calculates distributions of proceeds to investors in the case of a sale, and calculates returns to all shareholders.
  11. Actuals. (Optional) Robust functionality to use Actual financial data in the model, to analyze the forecast compared to the actual results, and to create rolling forecasts that seamlessly combine the projections with the actual results.
  12. Actuals + Forecast. (Optional) Combines the Actual data with the Forecas to create rolling forecasts. Simply “roll over” the model by editing one cell each month after you input new Actual data into the Actuals sheet, and the combined forecast updates automatically.
  13. Key Reports - Actuals + Forecast. (Optional) The same key reports from the earlier sheet, but drawing on the Actuals + Forecast data.
  14. External Data. Sheet used for importing financials from Quickbooks, Xero, Freshbooks, and other accounting software.
  15. Changelog. Details of all edits to the model since release, by version number.

I created the financial models behind Foresight so early-stage entrepreneurs can spend less time on finance and more time on their products. I built the Ecommerce Model because I’ve worked with many ecommerce companies on forecasting their revenues, costs and inventory needs, and wanted to provide a solid base to take their understanding of how people purchase their products to create solid financial projections. I’ve been building and helping entrepreneurs build financial models for startups since 1998. More about my story here.

  • Instant Download - one .xlsx Excel file. Immediately after purchase you will receive a download link and an invoice for your records.
  • Updates to the model are free, and the model can be re-downloaded at any time.
  • Credit/Debt Cards and PayPal accepted; all transactions are SSL secured and no payment details are stored by Foresight (see here to understand the details behind our transaction provider, their security and how they never store payment details).
  • All inputs and formulas are clearly labled; all formulas are open for editing and can be changed by user (i.e. no locked cells).
  • Works for any currency; Foresight models have been used by entrepreneurs from over 98 countries.
  • Use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.
  • If applicable, VAT is extra.
  • Bulk license purchases available, details here.
  • Purchase signifies acceptance of terms and privacy policy.

Use in Recommended Spreadsheet Programs

Integrate with Popular Financial Programs

“The Foresight Financial Model is very comprehensive and covers all the main drivers for a variety of business models. What I found really helpful too were the help guides and tips that Taylor included in the beginning of the model to help you reason through coming up with your assumptions and thinking about your business as a whole and what VCs look for. Finally, Taylor was great to work with. He picked up our business model very quickly and provided insight on business drivers and assumptions that I hadn’t thought through yet - which really helped me refine my thinking in order to create a more sophisticated and nuanced model.”

Jude Chiy, Founder, HelloHealthy

Jude Chiy
Founder, HelloHealthy

Watch a Demo

Click below to watch me demo the model.

Packages

Model
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
$150
Model
+
Video Course
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  Video Course. Targeted for beginners to financial modeling that want to learn the concepts of how to create a financial model, the video course is not a “how-to” for the model, but a deep dive into the fundamentals of building a financial model for startups in general. Preview here
  •  Course is sold for $99 on its own, only $50 in package with a model.
$200
Model
+
Get Started
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  1 Hour of assistance in completing the model, customization and review. Focus is on structuring and adjusting inputs for your business, and refining unit economics, cost budget, financial statements, and financing strategy.
  •  Additional customization may be necessary depending on your business; to be determined and billed separately.
$425
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  Video Course. Targeted for beginners to financial modeling that want to learn the concepts of how to create a financial model, the video course is not a “how-to” for the model, but a deep dive into the fundamentals of building a financial model for startups in general. Preview here
  •  Course is sold for $99 on its own, only $50 in package with a model.
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  1 Hour of assistance in completing the model, customization and review. Focus is on structuring and adjusting inputs for your business, and refining unit economics, cost budget, financial statements, and financing strategy.
  •  Additional customization may be necessary depending on your business; to be determined and billed separately.
$150
$200
$425

All transactions are SSL secured and no payment details are stored. Refunds, returns and exchanges terms here.

Need a custom model?

Need help forecasting your business? Looking to fundraise but don’t know how much to raise or where to start with building a financial model? Need help taking your current fundraising deck or a financial model to the next level?

I work with startups and investment funds, assisting with financial models for fundraising, capital planning, and market development strategy. I have experience from both sides of the table as a venture capitalist and a part-time CFO, and I’ve worked with thousands of companies throughout my career.

How it Works

Screenshots

Learn Financial Modeling

In 5 free lessons I share what I’ve learned from helping more than 18,200 early-stage entrepreneurs from over 98 countries learn financial modeling.

How can I help?

Hi, this is Taylor. Is there anything I can do to help? I’m happy to explain more about the models or services and help determine what you need. Just call +1 646.770.0052 or email hello@foresight.is

Looking for a discount code?
Use THANKYOU at checkout for $30 off.