Data-as-a-Service Startup Financial Model (Excel XLSX)

VIDEO DEMO

BENEFITS OF THIS EXCEL DOCUMENT

1. A framework for studying the economics of selling data via API requests, volume of data downloaded, a subscription, and one-time sales.

SAAS EXCEL DESCRIPTION

This product (Data-as-a-Service Startup Financial Model) is an Excel template (XLSX), which you can download immediately upon purchase.

You could have 1 GB of valuable information you are granting millions of people API access to and charging per request or per download or even a monthly subscription, or you could have 1,000,000,000s of GBs that are you selling access to. Either way this model has the ability for the user to enter in relevant assumptions and see the resulting revenues, expenses, and returns of starting and running a data-as-a-service business.

The entire model runs off customers that exist over time. There are multiple paid and free/organic acquisition channels that drive new customers as well as retention curves that drive how long a customer is active for. Everything has monthly granularity views and rolls up to annual views. There is a fully integrated 3-statement model that auto-updates when the bottom-up assumptions are adjusted.

Your main variable costs will be any capex for infrastructure, data transmission costs (transferring data out of your network to customers), and possibly data acquisition costs. This model is a little unique in that you have a non-cash cost of goods sold items that hit as depreciation expense (infrastructure capital expenditures) so that is added back when driving down to actual cash flow. You don't want to double count the expenditure.

The model lets the user have multiple revenue streams and the first three look at the number of customers that exist (up to 6 customer tiers). They may be paying a monthly fee with monthly/annual or any length contracts or they may be paying per use. The pay per use is based on the number of API requests per customer per month and how much is being charged per request. There is also another option for revenue and that is pay per amount of data used, which drives off of average GBs downloaded per month per customer and cost per GB downloaded. Finally, there is also an option for one-time data sales, which doesn't look at the number of customers that exist over time, but rather the number of downloads per month, average GBs per download, and average price per download (7 download options).

If you want to denote the data in a different unit of measure other than GBs, that is completely fine. Simply adjust the labels and make sure your price and units match the unit of measure you are using.

In terms of financial analysis, the model has a DCF Analysis, IRR, NPV, and Equity Multiple output for the project as a whole and for the investor / owner contribution pools depending on who is financing the initial startup costs and any operating burn. There are also lots of visualizations for KPIs like average customer lifetime value, average customer acquisition costs, average months to pay back customer acquisition cost, and LTV to CaC ratio.

The model can be configured to run for up to 72 months and includes an option for terminal value based on a trailing 12-month revenue multiple. There is also an option to finance some of the startup costs with debt and any remaining balance is automatically paid back at the forecasting end month if a terminal value is selected as being displayed.

Source: Best Practices in SaaS, Data Monetization, Integrated Financial Model Excel: Data-as-a-Service Startup Financial Model Excel (XLSX) Spreadsheet, Jason Varner | SmartHelping