New website, new models, new Foresight. Save $30 with code THANKYOU.  See all models
  +1.646.770.0052         hello@foresight.is
Best for businesses with recurring subscription revenues - including SaaS, freemium SaaS, Enterprise SaaS, subscription services, etc. - to model users, customers, revenues, costs, and more, combined with consolidated financial statements, cash flow analysis, funding needs, cap table, and valuation. Instant download, use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.
  • New · 2017 Do you run a business or consumer subscription revenue-based company and need to forecast your business? Are you a SaaS or subscription product company? Do you need to understand your costs, revenues and key metrics better for your own business planning or to present to investors? Build a 5 year cost budget, detailed revenue projections, cashflow forecast, and full financial statements for your business in an hour using the SaaS Financial Model.
  • The model is built for businesses with recurring subscription revenues - including SaaS, freemium SaaS, Enterprise SaaS, subscription services, etc. - to model users, customers, revenues, costs, and more, combined with consolidated financial statements, cash flow analysis, funding needs, cap table, and valuation. Includes bookings to billings to revenue recognition to cash, MRR, ACV/TCV, CAC, LTV, and more SaaS metrics. Also includes the Ecommerce Model structure to allow for one-time transactions and ecommerce, to model customers, orders, average order values, product SKUs sold, inventory and operations, to revenues and costs, all aggregated into the consolidated financial statements. The forecast is done monthly, quarterly and annually over a 5 year period. You can use your past historical operations and financials, or start from scratch with a forecast for a new idea. And, it can all be modified to add in your own unique revenue calculations, as all formulas and cells are completely open and unlocked. Purchase one-time, customize however and whenever you want, and updates to the model are automatically distributed for free.
  • Businesses with recurring subscription revenues, including SaaS, freemium SaaS, Enterprise SaaS, subscription services, and more.
  • Works for B2C SaaS services as well as large Enterprise SaaS businesses, for companies from monthly subscription plans to multi-year contracts, and for companies that have a variety of different subscription plans offered.
  • Works for companies starting from scratch as well as companies with multiple years of historical operational and financial data that they want to use in reporting and forecasting.
  • Focuses on creating a monthly and quarterly forecast of revenues, costs and cashflows over a 5 year period.
  • I created the financial models behind Foresight so early-stage entrepreneurs can spend less time on finance and more time on their products. I built the SaaS Model because I’ve worked with many companies with recurring revenue streams on forecasting their revenues, costs and key metrics, and wanted to provide them a better, easier and cleaner way to forecast a lot of the complicated subscription and SaaS-related mechanics to build operational and financial projections easier. I’ve been building and helping entrepreneurs build financial models for startups since 1998. More about my story here.
  • Simple yet robust methodology for creating a 12-60 month forecast of operating expenses, while also automatically handling the accounting treatment of the expenses.
  • Assumptions are entered on the Settings sheeet and the primary Costs and Revenues sheets and can be modified for any time period.
  • Start from scratch, or use historical operational and financial data for reporting or to ad in forecasting.
  • Provides a robust structure for forecasting users, customers, and revenues for commerce revenue models.
  • Cashflow analysis, including external funding forecasts, is integrated into the model with a capitalization table, forecasting out investment rounds, dilution and ownership (optional).
  • Robust functionality to use Actual financial data in the model, to analyze the forecast compared to the actual results, and to create rolling forecasts that seamlessly combine the projections with the actual results.
  • All formulas and sheets are open for editing, anything is open for editing. I don’t believe that models should be locked, everything should be open for you to edit so that you can model your business exactly as you want.
  • 1. README. Description of model, layout, and how to use it.
  • 2. Outline and How To. Two sheets that detail the model and how calculations flow, explaining how each sheet works. Assumptions are noted and explained throughout the model.
  • 3. Key Reports. Charts and tables of costs, active users (optional), cash on hand, revenue and revenue growth rate, net income and cumulative net income, margins, sources and uses, and more.
  • 4. Summary. Key operational and financial metrics organized in a clean summary, reported over 3 years, built to be easily customizable for your key metrics and timeframes.
  • 5. Settings. Model-wide assumptions and settings for acquisition flow.
  • 6. Costs. Cost budget, hiring plan.
  • 7. Revenues. User acquisition and revenue calculations. Detailed forecast of users, subscribers, customers, subscription plans, subscribers retained, churn, shift between plans, bookings, billings, and revenues, and full MRR detail; and optionally for transaction side, includes orders, products sold, revenues, costs, shipping (optional), discounts (optional), affiliates (optional), inventory purchasing (optional) and all changes in inventory levels.
  • 8. Forecast. Consolidated financial statements, including income statement, balance sheet, and statement of cash flows. Includes a detailed cash flow forecast that automatically forecasts funding requirements based on a simple assumption of how many months epenses to raise money for. Use this sheet for forecasting only, or bring in your historical financials to show either a mix of the past and the future, or to compare budgets to forecasts.
  • 9. Cap Table. The cap table in the SaaS Model is the Cap Table Model integrated into the cash flows of the business, mapping forecasted expenses and net burn to needed fundraising to estimated funding rounds by size and date.
  • 10. Actuals. Optional sheet if you have past financial data you want to report in the model and use in forecasting.
  • 11. Actuals + Forecast. Optional sheet that combines the Actual data with the Forecas to create rolling forecasts. Simply “roll over” the model by editing one cell each month after you input new Actual data into the Actuals sheet, and the combined forecast updates automatically.
  • 12. Key Reports - Actuals + Forecast. The same key reports from the earlier sheet, but drawing on the Actuals + Forecast data.
  • 13. Valuation. Automatic valuation of the company through either exit value or cashflows, using discounted cash flow (DCF), VC Method, and EBITDA multiples methodologies.
  • 14. Changelog. Details of all edits to the model since release, by version number.
  • The model includes over 100 assumptions around user acquisition, revenues, costs, and funding.
  • Acquisition: Organic and Paid acquisition, with automatic calculations and manual inputs (optional).
  • Retention: Monthly churn for users (optional; examples include a freemium SaaS business) and subscribers.
  • Revenues: for subscriptions, includes conversion rates, pricing plans (up to eight different plans with any contract length, month-to-month to multi-year contracts), expansion and migration between plans, and more. For transactions, includes conversion rates, orders per user, products sold per order, revenue and cost of goods sold (COGS) per order, discounts, and chargebacks and refunds.
  • Metrics: dashboard of metrics including MRR and ACV / TCV (detailed by new, retention, churned, expansion, contraction), Quick Ratio, CAC and LTV, months to payback, ARPU (per revenue stream), cost budget, sources and uses, cash, and more. Any additional metrics can be calculated from the forecasts in the model.
  • Hiring: staff hiring, salaries, roles, and when to hire, including an overall salary expense assumption to calculate team sizes automatically based on company growth.
  • Costs: flexible inputs to input all costs easily on a month by month basis. Expenses can be allocated to key expense areas and labled for accounting treatment as SG&A, COGS, or CAPEX.
  • Funding: equity fundraising forecasting, number of months to raise capital, % of the company sold in investment round (premoney valuation).
  • Instant Download - one .xlsx Excel file. Immediately after purchase you will receive a download link and an invoice for your records.
  • Updates to the model are free, and the model can be re-downloaded at any time.
  • Credit/Debt Cards and PayPal accepted; all transactions are SSL secured and no payment details are stored by Foresight (see here to understand the details behind our transaction provider, their security and how they never store payment details).
  • All inputs and formulas are clearly labled; all formulas are open for editing and can be changed by user (i.e. no locked cells).
  • Works for any currency; Foresight models have been used by entrepreneurs from over 98 countries.
  • Use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.
  • If applicable, VAT is extra.
  • Bulk license purchases available, details here.
  • Purchase signifies acceptance of terms and privacy policy.
“The Foresight Financial Model is very comprehensive and covers all the main drivers for a variety of business models. What I found really helpful too were the help guides and tips that Taylor included in the beginning of the model to help you reason through coming up with your assumptions and thinking about your business as a whole and what VCs look for. Finally, Taylor was great to work with. He picked up our business model very quickly and provided insight on business drivers and assumptions that I hadn’t thought through yet - which really helped me refine my thinking in order to create a more sophisticated and nuanced model.”

Jude Chiy, Founder, HelloHealthy

Jude Chiy
Founder, HelloHealthy

Packages

Model
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
$150
Model
+
Video Course
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  Video Course. Targeted for beginners to financial modeling that want to learn the concepts of how to create a financial model, the video course is not a “how-to” for the model, but a deep dive into the fundamentals of building a financial model for startups in general. Preview here
  •  Course is sold for $99 on its own, only $50 in package with a model.
$200
Model
+
Get Started
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  1 Hour of assistance in completing the model, customization and review. Focus is on structuring and adjusting inputs for your business, and refining unit economics, cost budget, financial statements, and financing strategy.
  •  Additional customization may be necessary depending on your business; to be determined and billed separately.
$425
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  Video Course. Targeted for beginners to financial modeling that want to learn the concepts of how to create a financial model, the video course is not a “how-to” for the model, but a deep dive into the fundamentals of building a financial model for startups in general. Preview here
  •  Course is sold for $99 on its own, only $50 in package with a model.
  •  Model, downloadable immediately.
  •  One-time purchase, model updates are free.
  •  Free email customer support.
  •  1 Hour of assistance in completing the model, customization and review. Focus is on structuring and adjusting inputs for your business, and refining unit economics, cost budget, financial statements, and financing strategy.
  •  Additional customization may be necessary depending on your business; to be determined and billed separately.
$150
$200
$425

All transactions are SSL secured and no payment details are stored. Refunds, returns and exchanges terms here.

Need a custom model?

Need help forecasting your business? Looking to fundraise but don’t know how much to raise or where to start with building a financial model? Need help taking your current fundraising deck or a financial model to the next level?

I work with startups and investment funds, assisting with financial models for fundraising, capital planning, and market development strategy. I have experience from both sides of the table as a venture capitalist and a part-time CFO, and I’ve worked with thousands of companies throughout my career.

How it Works

  • Download Instantly

    The model is available instantly after purchase; you will get an instant download link as well as an email with a download link. The model is a Microsoft Excel ™ file that can be used with many spreadsheet programs, including Google Sheets ™. Re-download the model anytime; and additionally, any new updates to the model will be emailed to you automatically, for free.
  • Input your most important assumptions

    Each model is already customized to be a good fit for your saas business. Start using the model by inputting the 30 most important assumptions for a saas business, and the model will create a set of financial and operational projections instantly based on a set of normal metrics for a business of your type.
  • Refine your Projections

    After you have input your most important assumptions, go into the detailed assumptions to fine-tune your model. Every input - variables with modifiers, growth rates, or manual inputs - can be modified and the model will update instantly. All formulas are open and editable, and thus the model can be customized further by changing how certain calculations are performed, and you can add in calculations for items specific to your business. In this way, the model is easy enough for someone with no knowledge of spreadsheet modeling to use, but can be infinitely customized by one with knowledge of Excel and spreadsheet modeling.
  • Understand your Forecasts

    The model automatically creates summaries and graphs of key financial and operational metrics, including growth rates, profitability ratios, MRR, ARPU, CAC, LTV, ARPU, AOV, churn, and more. Review the summaries and forecasts to understand what they say about your business, and use them for pitch and presentation materials.
  • Need Help?

    New how-to videos and explainers are regularly added to Learn, I also provide email customer support for free at hello@foresight.is to answer questions on how to use the model, explaining the structure and its results. If you would like more help on getting started, I also offer coaching and customized advisory services to help you prepare and complete your model. Details →

Screenshots

Learn Financial Modeling

In 5 free lessons I share what I’ve learned from helping more than 18,200 early-stage entrepreneurs from over 98 countries learn financial modeling.

How can I help?

Hi, this is Taylor. Is there anything I can do to help? I’m happy to explain more about the models or services and help determine what you need. Just call +1 646.770.0052 or email hello@foresight.is

Looking for a discount code?
Use THANKYOU at checkout for $30 off.