Funding plan
Runway is the first month the closing balance falls through the buffer. Confirmed receipts and assumptions are not mixed into one burn rate.
Buffer runway
5 months
Closing cash stays at or above the buffer for 5 month(s), then falls short.
Lowest close
−£692,175.17
Negative cash is shown, not hidden.
Cash that clears month 1 close
£772,175.17
Smallest whole minor-unit amount, landed in the chosen month, that keeps every modelled closing balance at or above the buffer. Receipts after the confirmed window are assumptions.
Monthly close
Bridge
| Month | Confirmed | Assumed | Out | Close |
|---|---|---|---|---|
| M1 Jan | £18,400.00 | £0.00 | £76,000.00 | £352,400.00 |
| M2 Feb | £0.00 | £18,952.00 | £76,000.00 | £295,352.00 |
| M3 Mar | £0.00 | £19,520.56 | £76,000.00 | £238,872.56 |
| M4 Apr | £0.00 | £20,106.17 | £87,000.00 | £171,978.73 |
| M5 May | £0.00 | £20,709.35 | £87,000.00 | £105,688.08 |
| M6 Jun | £0.00 | £21,330.63 | £87,000.00 | £40,018.71 |
| M7 Jul | £0.00 | £21,970.54 | £87,000.00 | −£25,010.75 |
| M8 Aug | £0.00 | £22,629.65 | £87,000.00 | −£89,381.10 |
| M9 Sep | £0.00 | £23,308.53 | £87,000.00 | −£153,072.57 |
| M10 Oct | £0.00 | £24,007.78 | £87,000.00 | −£216,064.79 |
| M11 Nov | £0.00 | £24,728.01 | £87,000.00 | −£278,336.78 |
| M12 Dec | £0.00 | £25,469.85 | £87,000.00 | −£339,866.93 |
| M13 Jan | £0.00 | £26,233.94 | £87,000.00 | −£400,632.99 |
| M14 Feb | £0.00 | £27,020.95 | £87,000.00 | −£460,612.04 |
| M15 Mar | £0.00 | £27,831.57 | £87,000.00 | −£519,780.47 |
| M16 Apr | £0.00 | £28,666.51 | £87,000.00 | −£578,113.96 |
| M17 May | £0.00 | £29,526.50 | £87,000.00 | −£635,587.46 |
| M18 Jun | £0.00 | £30,412.29 | £87,000.00 | −£692,175.17 |
Assumptions
300 basis points is 3% a month. Growth compounds in integer minor units. Financing is not included until you model a round separately.