Skip to Content

Free SaaS Projections Worksheet

A worksheet to help you estimate expenses and revenue for your SaaS application.

A Running Start for Your Projections

You’d like to build a web app but have no idea how much it costs or how much it could make. You're not even sure what types of costs to include in your calculations.

Estimating costs and budgeting for first SaaS application can be overwhelming.

New technology and tools have made it more affordable than ever, but there's still plenty of expenses.

And then there's the expenses you didn't even know about.

Fortunately, It doesn't have to be a wild guess.

Years of Experience in One Worksheet

I've created an evolved version of the spreadsheet that I used to run my SaaS application for eight years until I sold it. It walks the line between too detailed and not detailed enough so you can go into things with a reasonable approximation.

Before you get started, take a quick pass at this worksheet to get an estimate of how much it will really cost to run your application. Make some adjustments and explore different scenarios so you can get an idea of how much money you need in the bank to get your idea off the ground.

Once you've filled it out, you'll be able to mor easily explore scenarios and understand how much money you'll need and help you think through potential costs that you may not even be aware of.

[A screenshot of the overview tab of the worksheet.] A screenshot of the overview tab of the worksheet.
Figure 1

The Overview tab of the worksheet provides a convenient entry-point and some context for how to use it.

The steps to use the spreadsheet will look about like this:

  1. Profit & Loss Update the Profit & Loss tab's months (in yellow cells) to correspond to your relevant dates.
  2. One-time Fixed Costs Think though all of your potential startup costs, and populate them here.
  3. Recurring Fixed Costs Think you all of your recurring costs, whether they're monthly or yearly, and populate them here.
  4. Revenue Set up your anticipated pricing, initial customer and growth estimates to see how your revenue will increase over time.
  5. Marketing Marketing is optional, and this tab is designed to support unstructured advertising spending over time.
  6. Profit & Loss After you've provided everything else, this will help you understand your cash flow for your first two years.
[A screenshot of the profit and loss calculations tab of the worksheet.] A screenshot of the profit and loss calculations tab of the worksheet.
Figure 2

The profit and loss tab of the spreadsheet provides a good overview that can help you anticipate the kind of growth you'd need in order to meet your goals.

Frequently Asked Questions

How does it work?
It's just a Google Docs Spreadsheet. There's not much more to it. It has several tabs and includes some inline notes and guidance to help fill things in. Ultimately, it's just a starting point for you to duplicate and customize for your own business. It's difficult to make a one-size fits all spreadsheet, so it's really just meant to help you get going quickly and save you time.
Is it available for Excel or Numbers?
I haven't created versions for Excel or Numbers, but you should be able to duplicate it and download a version that you can open locally.
OK, I haven’t even had a chance to crack open the book yet, and I’d already pay twice this price—just for the spreadsheet alone. I built a crappy version of this spreadsheet for myself and it took me hours. This is a steal for anyone who’s even half-way serious about a SaaS business.
Photo of Amy Hoy
Amy Hoy Cofounder of Freckle
Cover of Starting & Sustaining Free Saas Projections Worksheet

Get a free projections worksheet and short email course to help you navigate the journey so you can be ready to build your own SaaS application.

No-nonsense, one-click unsubscribes.