Skip to article
Start here

How to build a startup financial model without Excel

To build a startup financial model, forecast customers and pricing, add delivery costs and operating expenses, then track cash month by month. Test alternative assumptions before sharing the results. You can do this without Excel in a browser-based builder, provided the model supports your business and makes its assumptions visible.

In this guide

Start with the decision you need to make

A useful first model answers a specific question, such as whether you can afford a hire, how slower acquisition affects cash, or how much financing the next stage requires. Write that question above your assumptions before entering numbers. It gives you a reason to include a cost or change a forecast.

For a subscription business, begin with a monthly view. A single annual revenue total hides when customers arrive and when bills get paid. Choose a horizon that includes the decision and its consequences, especially renewal dates, planned hires, and any expected financing. You can extend it as your assumptions improve.

What inputs belong in your first model?

Collect the inputs you can explain. Put actual customer counts and signed costs in one category, and uncertain estimates in another. A forecast needs estimates; the problem is forgetting which numbers they are. Add a short note outside the model describing the evidence behind each important assumption.

A starting checklist for a subscription forecast
InputWhat to specifyWhat it affects
CustomersNew subscriptions and renewal assumptionsActive subscriptions and recurring revenue
PricingPrice per billing period and billing cadenceEarned revenue and collection timing
DeliveryCosts per customer, labor, and fixed service costsCOGS and gross profit
Team and overheadSalary load, start dates, and expense schedulesOperating expenses and cash
Cash and financingOpening cash and any funding receipt monthMonthly cash balance

Have those inputs ready? Build your first model in Startup Model Builder, starting with one subscription product before adding more complexity.

Work through one month before forecasting the rest

Consider an illustrative business with 25 active subscribers paying $80 per month. Assume full-month service, immediate payment, no extra fees, and no other revenue. Monthly revenue and collections are both $2,000. Delivery costs $20 per subscriber, or $500 in total.

Now add $6,000 in loaded payroll and $1,500 in other operating expenses. Total cash out is $8,000. After collecting $2,000, the business uses $6,000 of cash. If it began the month with $30,000, it ends with $24,000. Those numbers are examples, not suggested prices or spending targets.

Check that you can reproduce this first month by hand. Then extend the forecast using acquisition, retention, and expense timing assumptions. If the first month is wrong, a longer chart only gives the mistake more room.

Keep revenue and cash separate

Our simple example collects and earns revenue in the same month. That changes with prepaid subscriptions. Startup Model Builder tracks subscription collections separately from earned revenue and shows the unearned subscription balance. The annual-versus-monthly billing guide walks through that difference.

Funding also needs its own line. In the builder, fundraising receipts increase cash without increasing revenue or EBITDA. Enter the month you expect funds to arrive and inspect the months before it. A positive balance at year-end can still conceal an earlier shortfall.

Test the assumptions, then save a usable copy

Duplicate your base case and change a specific uncertainty, such as new customer volume or a hire's start month. Compare the cash path as well as revenue. Our scenario guide explains how to keep those alternatives consistent.

Before sharing, name each scenario clearly and check that illustrative values have been replaced where necessary. The builder saves work in your browser. Export JSON for the active model as a separate backup, or download HTML to carry all scenarios in an editable offline file. Browser storage is convenient, but clearing site data can remove it.

This is a planning workflow. The app does not import your accounts or produce a complete set of statutory financial statements. Reconcile the starting figures to your own records, and revisit the assumptions when actual results arrive.

Related questions

Can I build a financial model before I have revenue?

Yes. Start with explicit assumptions about when selling begins, customer acquisition, pricing, and costs. Label estimates clearly and use scenarios to show uncertainty. A forecast is a planning tool; it does not turn an untested assumption into evidence.

Does a browser model replace every spreadsheet?

No. Check the business logic you need. This builder is designed around subscription products, scheduled costs, scenarios, and cash planning. A custom transaction model or specialized accounting schedule may require another tool.

Put your first assumptions to work.

Build a monthly subscription forecast, compare a second scenario, and save an editable copy. The builder is free to use without an account.

Build your first model