Collection

Templates

Templates for Microsoft Excel, Google Sheets, and Causal to create a forecast for a business. The templates share common structures but vary by the level of detail, to acknowledge the needs of enterpreneurs and investors at different stages. Start with the model that has the least detail needed for your immediate needs - and then either build in what you need (all cells and formulas are unlocked) or upgrade to a more advanced model with more features prebuilt.

How do you choose which Foresight template to use?

Here's my perspective on how to choose the right one for you. I build the templates to be used by people with a minimal amount of knowledge of spreadsheets and accounting, with enough flexibility to handle a wide range of situations already built into the templates, but with enough power to be used (and modified) by people with a deep experience in financial modeling.

Base Financial Models vs. Forecasting Tools

The base financial models are built to help an entrepreneur create financial projections for their business. The models provide an increasing amount of prebuilt detail and structure, from the Runway and Cash Budget Tool - the simplest - to the Standard/SaaS/Ecommerce Models - the most complex - to help you find the right level of detail and structure you need in your forecasts.

The forecast tools are all free tools that are built to handle specific kinds of forecasting, they are not intended to be full financial models, but used appropriately can help you make important financial decisions about your business.

Choosing the right template usually comes down to finding the best model for how the company grows and how the revenues are earned. For the base financial models, the financial core of the models - financial statements, operating costs, key reports and summary - are largely the same, so the question usually comes to whether the Standard is a good fit, or whether you need more or less structure.

The Standard is the best option for most businesses. The financial core contains all the details and reports necessary to build and present your financial model to executives and investors and make significant business decisions. The growth and revenue forecasts are prebuilt using the "one size fits all" conversion funnel and revenue forecasts, but the model also offers the Bring Your Own Model functionality to let use build or use your own revenue model with the financial core in the Standard.

Runway & Cash Budget vs. Starter vs. Standard

I built the Runway & Cash Budget Tool to be a free resource for entrepreneurs just getting started. It's built to focus on expenses, cash, and runway, with basic consolidated financial statements, built with the same formatting and reports of the more advanced models, but without the prebuilt logic behind the revenue forecasts. It's also free.

The Starter Model is built to be the simplest, "Minimum Viable Model" for an entrepreneur to use to raise capital. The focus is still on expenses, cash, and runway, but also includes consolidated financial statements - income statement, balance sheet, and statement of cash flows - along with more detailed approach to the operating costs, equity and debt financing, inventory (if applicable), and accounting treatment of the expense forecast. The model is easy to use to build in your own revenue and growth forecast, but that structure does not come prebuilt. For a seed-stage entrepeneur, the focus is on costs, and I'd argue that a detailed revenue forecast is not necessary, thus the structural choice I made with the Starter model to focus on costs and not revenues.

The choice between the Starter and the Standard Model comes down to whether you want to use the prebuilt revenue forecast in the Standard, which allows you to forecast revenues using a range of assumptions around paid and organic growth, sales efforts, conversion rates, churn, repeat purchase rates, prices, cost of goods sold, and much more.

While the prebuilt revenue structure works for a wide variety of businesses, if it happens to not be the best fit for you, you can use the Bring Your Own Model functionality to build or use your own revenue model. The integration process for your revenue model with the financial core of the models is simple and easy to use, making it easy to build custom revenue forecasts to fit your needs.

The Standard Model is the base for all the business model-specific variants, such as the SaaS Financial Model, Ecommerce Financial Model, and more. There are no other structural differences between them, they are targeted to different business types by the default setup of the model. This is done because a) the Standard Model itself is built to handle a wide variety of business types, and natively handles SaaS, Ecommerce, and any subscription or transaction-oriented business, but with additional sheets that can be used to dive deeper into different business models depending on the modeling approach desired by the user, and b) this creates consistency across all models. So anything that references the "Standard Model" also applied to any of the "Standard Model for ..." variants. You can use the Standard or any Standard-variant interchangeably.

My advice: Start with the simplest model possible

My general rule is to start with the model that has the least detail necessary to accomplish what you need and then either build in what you need or upgrade to a more advanced model with more features prebuilt. It's usually the easier and cheaper approach for you.

Sign up for new posts and products

You'll be redirected to my email provider to confirm. Unsubscribe anytime. Here's how I use your data.