Skip to content

Cash flow and what-if

Available onDeveloper

The tiles are the answer. This is the working behind them.

The cash flow chart

Two years out, then everything in. The closing figure sits above the last bar.

A chart and a month-by-month table, from month 0 to the last settlement.

Column What it is
Money out Every cost falling in that month, after its spread
Money in Sales settling, and deposits if you count them on exchange
Rent and other income Rent after empty time, and any one-off income, in the month it arrives
Net The month on its own
Running balance Where the project stands
Loan balance What the bank is owed, after your own cash has gone in first
Second loan Only with a second loan: what the second lender is owed, and its interest
GST paid / claimed back GST out on costs, and back at the BAS a few months later
Interest Worked out on that month’s real balance, and added to it

The month-by-month table

Every month: out, in, net, the running position, the loan and its interest.

Read it for the shape, not the detail. Almost every small development makes the same picture: money out for two years, nothing in, then everything in over a few months at the end. The deepest point of that trough is your peak loan, and the length of it is your interest bill.

Two things worth looking for:

  • A trough deeper than your facility. The project is unfundable as drawn, however good the margin is.
  • Sales bunched into one month. Settlements slip. If everything lands in month 26, one slow buyer moves your last payment and a month’s interest.

Spending against plan: planned and spent build money, month by month

The build budget month by month, against what has actually been spent.

Under the cash flow, Spending against plan compares the build budget (construction and contingency) with what the job has really spent: the invoices and approved labour on the linked estimate, ex GST.

  • Planned to date and Spent to date, then More than planned or Less than planned, and Build budget spent as a share of the whole plan. The over-or-under tile is deliberately not coloured good or bad: spending ahead of plan can just mean the job is ahead of programme.
  • A chart of the running totals, planned dashed and spent solid, with a marker on this month.
  • Show the month-by-month figures opens the table: Month, Planned, Spent, Difference, Planned to date, Spent to date and the running difference. Months before any build money are left out.

Planned uses the scenario as last saved (and the linked estimate’s current figure, when the build cost follows the estimate); Spent is read fresh from the job’s invoices and approved labour each time you open the page.

The card needs Month 0 and a linked estimate. Without either, it says which is missing and offers Go to Assumptions.

The what-if grid

The same project under worse conditions, with no typing.

The grid runs the feasibility again under worse conditions and shows what survives:

  • Sales down 5% and 10%
  • Build cost up 5% and 10%
  • Three months late, and six months late
  • Interest up 1% and 2%

This is the most useful screen in the section, and it takes no typing. A site whose margin holds up at sales down 5%, build up 5% is a different proposition from one that goes red the moment anything moves — even if both show the same profit today.

Lenders ask for a version of this. Having it already run is a good look.

What you assumed, against what has happened

The forecast beside the real figures, once the job is running.

Once the job is running, the card sets the scenario beside what has actually happened:

Column What it is
This scenario The feasibility as you have it now
Today The same feasibility re-worked with the real figures: the estimate’s budget, and your real sale prices and settlement dates from the sales register
The locked version Once you lock one, such as the version the bank approved: its figures, with its name and date at the top

The rows are Sales (inc GST), Construction, Total development cost, Profit, Margin on cost, Project IRR, Peak loan and Time, then Spent / committed from your orders and invoices, Lots sold, Deposits received and, once lots are in the sales register, Pre-sale cover: how much of the loan is covered by exchanged sales. Lenders usually set a minimum before they release construction funding, and watching it climb is how you know you are on track to draw down.

When the bank approves the loan, press Lock as approved. From then on every figure shows how far it has moved from the approved version - teal where it is better, pink where it is worse - and Locked versions lists the versions you have locked. See locking a version for how locking works.

This is the screen to open every week once you are building. The feasibility was a forecast; this is the score.