SaaS Forecasting Tool
Simple and flexible tool for forecasting SaaS and subscription revenue models.
The SaaS Forecasting Tool is a spreadsheet financial model template for a SaaS or subscription business for consumer, SMB, midmarket, or Enterprise SaaS. The model uses operational assumptions - growth rates, churn rates, average subscription, and more - and creates a revenue forecast plus SaaS reports such as MRR and ARR.
Walkthrough
Highlights
Forecast a SaaS or subscription business for consumer, SMB, midmarket, or Enterprise SaaS-style businesses. It takes business assumptions as inputs (future growth rate, churn rates, etc.), and builds out a full set of SaaS metrics (MRR, LTV, etc.) forecasted into the future. Calculates bookings, billings, revenues, and deferred revenues using assumptions for revenue per subscriber, contract length, billing cycle, likelihood to close, start date, and churn.
It intentionally simplifies the business down to key inputs, and by default does not include expenses and a calculation of net income.
For financial statements and full financial reporting, including full support for SaaS and subscription businesses, check out the Standard Financial Model.
One-time donation or purchase and free access to updates
Model is one .xlsx Excel file or Google Sheets Workbook and is downloaded or accessed immediately. No macros or VBA used. Can be used in Excel, Google Docs, and many other spreadsheet programs. Email or book a call for support anytime. One time purchase, updates automatically distributed for free.
Download immediately and anytime.
You will have the option to download a Microsoft Excel .xlsx file and copy a Google Sheet file immediately after purchase or submission or your email, and anytime through the link in your email receipt, as well as by logging into my transaction provider at Gumroad and creating an account.
Live outside the USA? Purchasing power parity discounts are automatically applied in your cart if applicable.
Use in any recommended spreadsheet program.
Foresight's spreadsheet models can be used in both Excel and Google Sheets interchangeably; simply upload the Microsoft Excel model template from Foresight into Google Sheets, or download the Google Sheets to Excel, and everything will structurally work fine.
The models are originally built in Google Sheets, and the formatting is a bit better in Google Sheets; in Excel you may want to adjust the row spacing, fonts, and chart formatting to get the aesthetics you want.
Your payment is secure.
We accept credit cards, debit cards, and PayPal. The transmission of your billing information is encrypted using secure socket layer technology (SSL/TLS) and will be processed by Gumroad. Foresight does not have access to your payment details (why it's safe).
You'll get a payment receipt by email immediately after purchase. Note, you will see Gumroad, not Foresight, on your payment card or PayPal statement.
Legal
By purchasing or downloading, you agree for Foresight to contact you by email with advice on financial modeling and promotional offers (you may unsubscribe anytime), and you hereby accept the License Agreement. The Terms of Service and Privacy Policy are also available on the website.