ValueQuarry Pricing, profit, and payout tools

Calculator template

Cash Flow Forecast Template

Build a cash flow forecast calculator with starting cash, inflows, fixed costs, variable costs, and extra spend.

Review the inputs and formulas below, then open this template in the calculator builder to customize the field names, values, result styles, and notes.

Open this template in the calculator builder Browse all calculator templates

Inputs

What people fill out

  • Starting cash

    Uses starting_cash in formulas, starts as a currency field, and begins at 10000.

  • Monthly inflows

    Uses monthly_inflows in formulas, starts as a currency field, and begins at 3500.

  • Fixed costs

    Uses fixed_costs in formulas, starts as a currency field, and begins at 3000.

  • Variable costs

    Uses variable_costs in formulas, starts as a currency field, and begins at 2000.

  • Extra spend

    Uses extra_spend in formulas, starts as a currency field, and begins at 500.

Outputs

What the template calculates

  • Net cash flow

    Format currency

    Result style primary

    Formula monthly_inflows - fixed_costs - variable_costs - extra_spend

    Net monthly change in cash from inflows and costs.

  • Ending cash

    Format currency

    Result style metric

    Formula starting_cash + monthly_inflows - fixed_costs - variable_costs - extra_spend

    Cash on hand after the forecast period.

  • Runway months

    Format number

    Result style breakdown

    Formula starting_cash / MAX(fixed_costs + variable_costs + extra_spend - monthly_inflows, 1)

    Simple runway estimate if current conditions continue.

Use cases

When this template helps

  • Estimate one-period cash flow before committing to extra spend.
  • See ending cash after inflows, fixed costs, variable costs, and extras.
  • Create a simple runway calculator for small business planning.

Related

More ways to work with this math

FAQ

Quick answers

Short answers for the questions that usually come up first.

Can I edit this cash flow forecast template?

Yes. Open the template in the builder, then change the labels, values, formulas, notes, or output display styles to fit your workflow.

Can I save a version after I change it?

Yes. Save it on this device, export JSON, or copy a share link after you make changes.

Can I use this as a starting point for a different calculator?

Yes. Templates are meant to be edited. Remove fields, add new ones, or swap formulas if you want a different custom calculator.