Building A Model

  • Actuals and Rolling Forecasts

    How the Standard Model uses historical financials and creates rolling forecasts.

  • Best Practices and Resources for Financial Modeling

    The best resources, templates, and posts about financial modeling and startups on the web.

  • 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.

  • Choosing the right Foresight template

    How do you choose which Foresight template to use? The product comparison grids outline the differences in the features, and below is my perspective on how to choose the right one for you.

  • Combining operational and financial forecasting

    Foresight's templates focus on using operational mechanics to forecast financials. Here's why.

  • Fundraising

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

  • How to communicate your funding sources and uses

    A key part of creating a fundraising ask is understanding and communicating how the money will be raised. A sources and uses chart is a fairly standard way to communicate it, and a summary of the key expenses helps to tell the full story. Here's how I do it.

  • How to create assumptions

    How to create the assumptions for startup financial models

  • How to model costs

    Estimating your cost budget is the first, and most important, step towards creating your financial projections.

  • How to model revenues

    How to model revenues using the top-down and bottoms-up approaches.

  • How to pitch your financial projections

    Startups often present their financial projections incorrectly. Here's why, and what you need to do instead.

  • How to review a Foresight financial model

    Where do I start with building and reviewing a model? Here's how I do it.

  • 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.

  • Outline

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

  • Printable

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

  • Recommended software

    I recommend using Microsoft Excel or Google Sheets for financial modeling, both in general and for Foresight templates specifically.

  • 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.

  • 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.

  • Why build a financial model?

    Financial models can help entrepreneurs make critical business decisions. But it's more about the process than the result.