Runway and Cash Budget Tool

Runway and Cash Budget Tool is a financial model template for Excel or Google Sheets to plan your expenses, create a cash budget and forecast runway, for up to three years. Prebuilt with key charts and summaries of cashflows, operating costs, and runway. Used by pre-seed and Seed stage companies. Unlocked - edit anything - last updated in January 2019.

Overview

Financial template to forecast your expenses, cash and runway by inputting your revenues, costs, and funding (optional). Automatically builds charts of cash on hand, cash burn, operating costs, and sources and uses of funds. Flexible enough to use for any type of business.

Key features

The free Runway and Cash Budget Tool is the simplest structure of the base financial models, so that you can create a cost budget, estimate revenues, and understand burn, cash, and runway as quickly as possible. Automatically creates summary chart of burn and runway, summary of operating expenses, and sources and uses of funds (optional).

Used by founders and investors

Made for founders, executives, advisors, mentors, or consultants that need to create a cost budget and runway forecast with the simplest structure possible.

Easy to use

Standards-based, extensively tested and used by thousands of companies across a wide variety of business types, revenue models, and needs.

Edit anything

Use in Microsoft Excel or Google Sheets; all cells and formulas are unlocked for editing and transparency, add on or edit for your specific situation.

I use Github to organize updates and collaboration on the tool. Issues or suggestions, log under Issues; create pull requests to work on the core model, and fork for your own use, subject to a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Personal support

Built by a professional financial modeler with experience as an investor and running forecasting inside startups. Responsive, personal support — chat, call, or email — and available for custom services. I created the financial models behind Foresight so early-stage entrepreneurs can spend less time on finance and more time on their products. Learn more about me ›

Reviews

“As a startup coach and repeat entrepreneur myself, I spend a lot of time in spreadsheets. The Foresight tools that I’ve used are easy to understand, modify, and, perhaps most importantly, the formulas are correct! Beyond the actual spreadsheets, Taylor is a wealth of knowledge and an incredibly quick communicator. He has gone above and beyond what I expected to deliver value.”
— Brian Howe, CEO, Format Health

More reviews here ›

Screenshots

Flexible Structure

• The structure is designed to be easy to extend by adding in additional detail or advanced methods for forecasting growth, revenues, and costs for specific business types.
• The core of the revenues and expenses forecast, the Forecast sheet allows you to input your revenues and expenses month over month for 36 months, and sums into quarters and years.

Revenues and Costs

• Completely flexible structure that allows you to enter in any costs, hires, and methodology to forecast how your costs change over time.
• Automatically calculates burn, net burn, average 6 month burn, and your cash balance and how it changes over time. Optionally, you can also enter in any external funding rounds, grants, or loans to see the impact on your cash balance.
• All cells and formulas are completely open and unlocked, so you can edit or change anything in the model.

Key charts and reports

Three charts that summarize the most important parts of the model, consisting of:

• Burn and Runway: a chart that shows net cash burn and cash balance over time, combining revenues, expenses, and any external funding
• Summary of Operating Expenses: A summary of the cost budget, using the categories you create on the Forecast tab
• Sources & Uses: A summary pie chart that shows how the first fundraise - external financing - you put in the model (optional) is used to pay for the summary operating expenses over a period of time.

More information

For more information, see Runway and Cash Budget Tool on Foresight ›