Foresight Features

  • Actual Financials

    How the Standard Model uses historical financials to create budget variances and rolling forecasts.

  • Breakdown

    The Breakdown sheet goes beyond financial analysis to provide additional management analysis on the performance of the business, by automatically creating a profit and loss statement with each user-defined business segment in its own column.

  • Bring Your Own Model

    Foresight's Bring Your Own Model (BYOM) functionality allows you to build or bring your own growth and revenue model and easily use it to replace the default growth and revenue model in Foresight's Standard Model.

  • Budget

    How to use the prebuilt Budget sheet to do variance comparisons between the forecast and actual results.

  • Changelog

    A quick note on the Changelog sheet in each model.

  • Custom revenue models and additional revenue streams

    The revenue model in the Standard Model enables you to model up to two revenue streams from one or two user bases. Here's how you can add in more revenue streams or build your own custom revenue model.

  • Forecast

    The Forecast sheet contains the core growth, adoption, conversion, retention, and revenue calculations, expenses, accounting, cash, and key metric calculations.

  • Forecasting Drivers

    How to use the prebuilt Forecasting Drivers to easily create dynamic forecasts.

  • Fundraising

    The optional Fundraising sheet creates automatic forecasts of future fundraising rounds based on your assumptions on Get Started.

  • Get Started

    The Get Started sheet covers the most important inputs and assumptions in the Standard Model.

  • Hooks

    Hooks is a key feature to the Standard Model that makes the Bring Your Own Model functionality work. Here's how it works to make the process of integrating Foresight modules, custom revenue models, and non-Foresight models as easy as possible.

  • Impact

    The Impact sheet helps you think about the broader impact of your business and create a basic analysis and reporting structure for using your financial and operational metrics to calculate your impact metrics. Created in partnership with Venture Better.

  • Key Reports

    The Key Reports sheet consists of prebuilt charts for burn, runway, cash, sources and uses, and many other key metrics.

  • Lambda functions, and why they matter

    How I plan to roll out support for LAMBDA functions.

  • Modules

    Explaining the concept of modularity with the Standard Model system.

  • Outline

    The Outline sheet provides an overview of the sheets in the model.

  • Pipeline

    The optional Pipeline sheet is used to model an enterprise sales funnel, a channel growth strategy, or any sales or growth strategy that is high-touch or irregular in terms of when growth happens and how large the sales are.

  • Presets

    How to use the Presets sheet to select the baseline for your model.

  • Pricing

    The optional Pricing sheet is used to model multiple products, SKUs or subscriptions, and is key to more detailed SaaS and Ecommerce strategies.

  • Printable

    The Printable sheet provides a set of annual statements pre-formatted for ease of printing.

  • Revenue Model

    The default revenue model in the Standard Financial Model is prebuilt to handle a wide variety of business models. Here's an explainer on how it works.

  • Review

    How to review a Foresight financial model.

  • Scenarios

    Recommendations on an Excel or Google Sheets add-in to model scenarios.

  • Summary

    The Summary sheet is the first place to view to communicate the key insights about the business to the intended audience of the model.

  • Taxes

    How Foresight's models calculate taxes, and considerations in handling your actual tax responsibilities.

  • Timescale

    By default, the models are built by month for either 3 or 5 years. Here's how to extend them if you need to model more periods.

  • Unit Economics

    How to use the Unit Economics sheet to model and communicate margins, breakeven, and lifetime value on a per-unit basis.

  • Using Causal to create spreadsheets

    How to use spreadsheet view in Causal to build financial models

  • Valuation

    Valuing early-stage companies can be more of an art than a science. Here I'll explain the basics behind discounted cash flow (DCF) and multiple-based valuation, and detail how they are implemented in Foresight's models.

  • Variances

    How to use the prebuilt Variances to do quick variance analysis.

  • Visible

    Integrate Foresight with Visible to report historical and forecasted metrics to internal and external stakeholders. Here's the background on how to use it and a step-by-step integration guide.