Cash Flow Forecast Spreadsheet

The flexible Cash Flow Forecast spreadsheet forecasts your cash flow into the future, so you can project various income/expense scenarios over time.

About the Cash Flow Forecast Spreadsheet

This sheet looks at the long-term picture. Think years, not months. If you are looking for something that looks at the more immediate future, consider the Projected Balances sheet.

Some of the benefits of using this sheet include:

  • Easy to set up
  • Baselines your cashflow with the current-year budget (other ranges can be used)
  • Outputs both chart and tabular data
  • Provides workspace to manually add life events (e.g. children going to college, retirement, etc) with starting/ending years, starting amounts, and growth rates
  • Life events can be activated/deactivated to run scenarios and quickly see long-term impacts
  • Ability to set growth rates for your core income/expenses and life events

Notable Replies

  1. Avatar for jono jono says:

    The Cash Flow Forecast template was updated on Feb 10, 2020 to fix one of the formulas. If you installed it before then, please update it using the Tiller Community Solutions add-on to version 0.91.

    Jon

  2. Avatar for jono jono says:

    On Feb 22, 2021, the Cash Flow Forecast template was updated to Version 0.92 to fix an issue with multiple category overrides to Life Events that matched an existing category name.

    If you downloaded the sheet prior to that date, please update it using Tiller Money Labs add-on.

    Jon

  3. Avatar for jono jono says:

    A revised version of the Cash Flow Forecast sheet has been uploaded. Version 0.93.

    It works with up to 200 non-hidden, income and expense categories.

    You can get it from the Tiller Community Solutions Add-On. Either Add a Solution or use Manage Solutions to update to Version 0.93.

    Jon

Continue the discussion at community.tillerhq.com

Participants

How to install this template

Start your free Tiller trial, set up your Foundation Template, then install this template with the free Tiller Community Solutions add-on for Google Sheets.

Tiller Community Solutions FAQ

Start Your Free Trial

Try Tiller free and track all your accounts in one place, always know where your money goes, and confidently plan your financial future.