Ecommerce - Subscription Model Financial Projection Template

Develop in-depth financial projections for investor discussions and loan applications through this editable Excel template. It incorporates automatically generated 5-year financial statements, over 20 charts displaying vital metrics, and a video tutorial.

How it works?

Template price: $

99

  • 5 Year Projected Financial Statements
  • CPA Developed & Completely Customizable
  • Video Guide Included
  • Free Support & Projections Review
  • Compatible with Google Sheets

Our experienced CPA manually developed this template that enables you to produce professional projections based on your unique situation and numbers.

Create investor- and lender-ready projections in hours, not days.

Our CPA developed template enables you to create professional projections based on your unique assumptions.

Create investor- and lender-ready projections in hours, not days.

Built for subscription-based E-commerce startups specifically — our ProjectionHub software has been used by over 2,000 ecommerce businesses to develop reliable and effective financial projections. Based on this experience we decided to create a DIY customized Excel template that makes creating investor-ready financial projections for e-commerce a breeze.

How it works?

Watch a demo of the template

Save time & money - get organized with our template!

Get a subscription-based E-commerce template now for $99

The template price: $

99

USD

100% money-back guarantee for 30 days!

 Revenue Projection Template Example

Step 1: Purchase and download the template

After purchase, you will download an unlocked Excel file with a ready-to-use financial projection template for your business model. You can also open the file to use in Google Sheets!

Download Now

Step 2: Enter your assumptions on the input tabs

Subscription based E-commerce Sales forecast

  • ​The revenue model will help you forecast your monthly revenue and direct costs for five years. The model starts by using your number of website visitors and your conversion rate to estimate monthly sales units. You will set various product or product categories along with their associated cost, revenue, and shipping and packing expenses. The model then projects out your revenue and direct expenses for five years and automatically passes through updates to the financial statements. The revenue model also allows you to factor in revenue and cost from a subscription program. 

E-commerce Subscription Model Overhead Costs

  • You will be guided to insert your other relevant expenses in the operating expense model, which includes some common line items and default amounts to help you get started. This model will pass through the expenses and cash flows on each of the financial statements for you. You can provide your monthly expenses as either fixed amounts or variable items that could differ each month like payment processing fees. The first three months of the model are broken out separately so that you can account for start-up expenses. 

Subscription Based E-commerce General Financial Assumptions

  • The general assumptions template will guide you to provide balance sheet items such as fixed assets, loans, investments, inventory assumptions, and accounts receivable assumptions. The template will have you input some simple values and then it will calculate the more tedious things for you such as loan amortization, interest expense, depreciation expense, inventory purchases, and things like that.

E-commerce Salaries and Payroll Sheet

  • The salaries and payroll model helps calculate your monthly expenses for salaried employees, including items like employer taxes and benefits, but it also helps you plan for distributions (dividends, owner draws) made to owners.

Step 3: The model is automatically updated based on your assumptions

Subscription Based Ecommerce Snapshot

  • The At-A-Glace tab shows you a digestible financial snapshot in the form of several helpful graphs, charts, ratios, and financial summaries, all ready to be copied into other marketing slicks and pitch decks

E-commerce Financial Statement Tabs

  • There are six differentFinancial Statement tabs that cover your bases: the annual and monthly formats of the income statement, cash flow statement, and balance sheet, and the month-by-month breakdowns of the same financial statements. 

Investor Dashboard Tab

  • The Investor Dashboard tab enables you and any necessary stakeholders to see the impacts of changing the main assumptions of the sales forecast model that may have trickle down effects. This tab presents the income statement from your model and a special, modified income statement that updates whenever you change the assumptions. This provides you the ability to see how sensitive your model is to certain variables without changing the data you already provided.

 Income Projection Chart Example

Tables, charts, graphs and dashboards include:

Tables, charts, graphs and dashboards include:

  • Profit and loss at a glance table
  • Use of start-up funds graph
  • Key ratios table
  • ​​Cash generated from operating activities graph
  • ​Investor dashboard
  • ​5 years of monthly and annual income statement, cash flow and balance sheet reports
  • Profit and loss at a glance table

  • Use of start-up funds graph

  • Key ratios table

  • ​Cash generated from operating activities graph

  • Investor dashboard

  • 5 years of monthly and annual income statement, cash flow and balance sheet reports

Step 4: If you need help, we're here

We can fill out or modify any of the templates we sell, and we’re always happy to answer questions.

When you call us, you can speak directly to the developers of the model, not a call center or customer service representative.

Contact us in the most convenient way for you. We're here to help you

If the model doesn’t work for you, we’re happy to provide a refund.

Questions? Get in touch.
Contact Us

What ProjectionHub Customers Think

The cost of the template is estimated at $ 2000

If you hired a CPA to build this template from scratch it would take at least 20 hours of billable time to build a similar template. At an average hourly rate of $100 per hour it would cost you $2,000.

20 hours X $100 = $2,000 value

But we've already done all the work and you don't need to hire a CPA

Save time & money - get organized with our template!

Get a subscription-based E-commerce template now for $99

The template price: $

99

USD

100% money-back guarantee for 30 days

Back to Top

Our Projection Protection Guarantee

Love it or Swap it
If the template you purchase is not the perfect fit, our team will help recommend the right template and swap your template for no extra charge. You can rest assured we'll make sure you are using the right template.
Expert Review
After you fill out your template, you can upload your projections to our team where we will do a complete review and then send you a custom video recording of us providing feedback so you can feel confident your projections are investor & lender ready.
See How
Help as You Go
Our team will be standing by so you can get help as you fill out your projection template. Through email and custom video recordings, we will make sure you understand how to complete your projections.
See How

You may also like these templates

The ProjectionHub Team

Grace Cisna, CPA

Before joining ProjectionHub, Grace served as an auditor for a public accounting firm in Indianapolis. There, she audited start-up tech companies, major regional hospitals, public manufacturers and everything in between.

As an auditor, she gained insight to the inner workings of all kinds of business models. Grace is a CPA, has a bachelor’s degrees in Accounting and French and a Master’s of Accountancy all from the University of Iowa, where she also taught introductory accounting classes to undergraduates.

Grace loves to use her accounting expertise to serve as an advisor to her clients, helping them understand what it takes to make a business succeed.

Adam Hoeksema — Co-founder ProjectionHub

Adam is the co-founder of ProjectionHub which is a SaaS web application that helps entrepreneurs create financial projections for their business.

Since 2012, over 40,000 entrepreneurs from around the world have used ProjectionHub to help create financial projections.

Adam also serves as the Executive Director of Bankable. Bankable is a Small Business Administration (SBA) lender that makes loans from $500 to $250,000 to Indiana small businesses that are unable to secure financing from a traditional bank.

Adam has managed the loan program since loan #1 in 2010. Since 2010, Bankable has closed over 1,200 loans totaling over $38,000,000. Adam is an entrepreneur at heart and loves working with entrepreneurs to launch and grow their business.

We are available to help you complete your projections

Troubleshoot

We'll answer your questions about how the template works

Customize

We can help you customize your template, add revenue models, expenses or custom charts, tables and graphs -> with our financial modeling services

Frequently Asked Questions

What are examples of successful ecommerce + subscription businesses?

Dollar Shave Club is one of the most popular examples of a successful ecommerce subscription business.  There are also companies such as Birchbox, Pet Circle, and Manpacks, as well as, Amazon’s “Subscribe and Save” business.  

What is the average churn rate for an ecommerce subscription business?

Recurly studied 900 ecommerce subscription businesses and found that the average churn rate was 7.02% and ranged between 3% and 12%.  As you complete your financial projections with our spreadsheet template, you will find what a huge impact churn rate has on your profitability as an ecommerce subscription business.  Since you are likely paying to acquire customers, each time you lose a customer (churn), you have to pay to acquire a new customer to replace them.  

How to determine what shipping should cost for my ecommerce business?

Shipping costs can make or break your ecommerce business.  It can be difficult to estimate what the cost might be to ship your ecommerce items because the location, dimensions, and weight can all play a role in determining the shipping cost.  Additionally, as you grow your shipping volume you can negotiate better shipping rates with carriers such as UPS or FedEx.  Shopify and other ecommerce platforms provide useful calculators to help you predict the cost of shipping your specific items.  

Is an ecommerce business a good business to start?

We studied revenue data from 234 tech startups and we found that ecommerce businesses and DTC Product businesses were the fasted to reach $1,000,000 in revenue; however, growth really slows for DTC companies in year 5 and beyond when compared to B2B SaaS, B2C Software and Marketplace businesses. So although an ecommerce business can be a good business to startup, you will likely have less upside when compared to other software based tech startups.

?