Cash Flow Forecast template question

[roger.chu91]

I have a question about the Cash Flow Forecast template from Tiller Money Labs. The incomes I put under “Life Events” are not applied to my forecast. Please help thanks!

[jono]

Hi @roger.chu91 ,
Did you add or delete any rows or columns to your sheet?
Or put any data in the white cells? Only green background cells should be editable.

I’m unable to duplicate what you are seeing.
Maybe try re-installing the sheet?

Jon

[roger.chu91]

Yes I inserted rows in Life Events and I think that broke it. I fixed it by restoring the sheet. Thanks!

[roger.chu91]

@jono

Follow up questions.

When I put Income Budget Change / Year to 5%, it’s showing that my Yearly Cash Flow is becoming more negative. Shouldn’t it become more positive?

And when I put Expense Budget Change / Year to 3%, my Yearly Cash Flow doesn’t change?

[Blake]

@roger.chu91

Your image shows negative cash flow. Please see the language below which comes from the link below. Read this very closely. This template pulls amounts from the budget columns in your categories sheet. Modify those budget numbers and then those results will flow over.

Cheers,

Blake

The sheet works best if you have a Tiller Categories sheet with monthly Budgets in place for the current year.

Core Income and Expense Budgets

The Cash Flow Forecast sheet looks at the Categories sheet to establish your baseline cashflow from your existing income/expense budget. If you have monthly budget columns for the current year, those budget values will be annualized and used.

Income or expenses in categories that are hidden from reports are not included.

If you do not have budgets for the current year or want to use a different initial range, see the FAQ #1 below for how the initial Income and Expense range is determined and can be overridden.

This sheet doesn’t use any information from the Transactions or Balance History sheets. It only uses the amounts in your budget located in the Categories sheet.

How to Use the Cash Flow Forecast

Overview The Cash Flow Forecast template from Tiller Money Labs forecasts your cash flow many years into the future. This solution allows you to test out different income/expense scenarios and view the impact of those changes over the long term. [cash flow forecast] 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 inclu…

[roger.chu91]

@Blake Hey thanks for your input but I don’t think it addresses my questions though?

[jono]

Hi @roger.chu91 ,
Thanks for alerting us to this issue.
I believe there is an error in the formula in hidden cell R2.
There is a reference to E5 in the POW() function that should be changed to E6.

New formula in R2:
=IFNA(ARRAYFORMULA(IF(ISNUMBER(L2:L),C12*POW(1+E6,L2:L-AF10) ,IFERROR(1/0))),IFERROR(1/0))

Give that a try and see if it makes more sense.

We will update the template shortly.

Jon

[roger.chu91]

Thank you so much! This is too advance for me so I’m just gonna wait for the updated template lol

[jono]

@roger.chu91
The template has been update to version 0.91.
You can update your sheet using the Tiller Labs add on.