Company-wide
Cash Flow
Every draw, closing, equity contribution and payment run across 16 projects, rolled into one forecast.
Current Cash
$612,000
Projected in 7 Days
$648,000
Projected in 30 Days
$512,000
Projected in 13 Weeks
$735,000
Projected Low Point
Week of Sep 21
$404,000
Minimum reserve $500,000 · shortfall $96,000
124 Oak and 931 Pine draw cycles overlap with the equity funding required for 78 Magnolia Court, while the Belle Chasse closing lands two weeks later than the spend.
Potential responses — management decides, not the software
Accelerate 931 Pine drawMove Magnolia closingUse existing line of creditDelay discretionary APDelay next land acquisition
Line of credit: $1.25M available of $1.50M.
13-Week Forecast
Ending cash balance by week
$648KAug 17
$592KAug 24
$705KAug 31
$512KSep 7
$448KSep 14
$404KSep 21
$690KSep 28
$585KOct 5
$521KOct 12
$662KOct 19
$574KOct 26
$498KNov 2
$735KNov 9
Minimum reserve $500K
| Week | Aug 17 | Aug 24 | Aug 31 | Sep 7 | Sep 14 | Sep 21 | Sep 28 | Oct 5 | Oct 12 | Oct 19 | Oct 26 | Nov 2 | Nov 9 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Draw funding | $556K | $482K | $203K | $662K | $458K | $406K | $124K | $579K | $412K | $302K | $414K | $499K | $245K |
| Home sale proceeds | — | — | $465K | — | — | — | $781K | — | — | $437K | — | — | $583K |
| Equity contributions | — | — | — | -$210K | — | — | — | -$180K | — | — | — | -$120K | — |
| Construction spend | -$322K | -$388K | -$401K | -$444K | -$366K | -$298K | -$410K | -$352K | -$318K | -$389K | -$344K | -$301K | -$376K |
| Payroll | -$88K | -$88K | -$92K | -$88K | -$92K | -$88K | -$92K | -$88K | -$92K | -$88K | -$92K | -$88K | -$92K |
| Overhead | -$62K | -$62K | -$62K | -$62K | -$64K | -$64K | -$64K | -$64K | -$66K | -$66K | -$66K | -$66K | -$66K |
| Debt service | -$48K | — | — | -$51K | — | — | -$53K | — | — | -$55K | — | — | -$57K |
| Ending cash | $648K | $592K | $705K | $512K | $448K | $404K | $690K | $585K | $521K | $662K | $574K | $498K | $735K |
Portfolio Cash by Project
Where the company's cash is committed right now
| Project | Cash Invested | Loan Proceeds | Pending Draw Reimb. | Remaining Equity | Next 30-Day Spend | Remaining Budget | Est. Profit | Expected Close |
|---|---|---|---|---|---|---|---|---|
| 124 Oak Street | $149K | $575K | $114K | $51K | $113K | $633K | $394K | Jan 18 |
| 714 Pine Street | $154K | $460K | $60K | $6K | $80K | $256K | $245K | Nov 30 |
| 892 Magnolia Ave | $145K | $253K | $89K | $185K | $133K | $1.20M | $397K | Apr 2 |
| 3812 Lake Terrace | $70K | $81K | $55K | $150K | $101K | $1.04M | $355K | May 20 |
| 931 Pine Hollow | $180K | $554K | $82K | $0 | $86K | $235K | $258K | Nov 6 |
| 78 Magnolia Court | $86K | $0 | $0 | $234K | $121K | $1.31M | $382K | Jun 15 |
| 2201 Cypress Bend | $120K | $458K | $25K | $0 | $23K | $61K | $133K | Sep 26 |
| 55 Heron Point | $132K | $378K | $75K | $68K | $95K | $625K | $309K | Feb 12 |
| 417 Willow Run | $119K | $336K | $46K | $21K | $65K | $288K | $182K | Dec 14 |
| 1908 Bayou Trace | $99K | $231K | $57K | $71K | $75K | $556K | $223K | Mar 8 |
| 6 Live Oak Lane | $240K | $790K | $39K | $0 | $106K | $165K | $322K | Oct 10 |
| 330 Fairview Dr | $128K | $329K | $50K | $32K | $70K | $351K | $190K | Dec 28 |
| 1450 Ridgewood | $73K | $154K | $36K | $67K | $62K | $504K | $170K | Mar 22 |
| 77 Sabine Circle | $67K | $79K | $42K | $124K | $82K | $819K | $258K | May 5 |
| 2840 Belle Chasse | $190K | $614K | $55K | $0 | $92K | $245K | $280K | Nov 18 |
| 19 Chestnut Row | $120K | $437K | $15K | $0 | $21K | $27K | $138K | Sep 12 |
| Company total | $2.07M | $5.73M | $839K | $1.01M | $1.32M | $8.32M | $4.24M |