Jan - 18 | Feb - 18 | Mar - 18 | Apr - 18 | May - 18 | Jun - 18 | Jul - 18 | Aug - 18 | Sep - 18 | Oct - 18 | Nov - 18 | Dec - 18 | Total | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Revenue (Actual) | $30,000 | $32,000 | $37,000 | $45,000 | $79,000 | $ - | $ - | $ - | $ - | $ - | $ - | $223,000 | |
Revenue (Forecast) | $39,000 | $47,000 | $51,000 | $60,000 | $65,000 | $74,750 | $85,963 | $98,857 | $113,685 | $130,738 | $150,349 | $172,901 | $1,084,541 |
Expense (Actual) | $20,000 | $25,000 | $33,000 | $49,000 | $50,000 | $ - | $ - | $ - | $ - | $ - | $ - | $177,000 | |
Expense (Forecast) | $19,000 | $26,000 | $26,000 | $37,000 | $39,000 | $42,900 | $47,190 | $51,909 | $57,100 | $62,810 | $69,091 | $76,000 | $504,000 |
Ending Month Balance | $160,000 | $216,000 | $377,000 | $835,000 | $910,000 | $941,850 | $980,623 | $1,027,570 | $1,084,156 | $1,152,084 | $1,233,342 | $1,330,244 | $10,245,258 |
Jan - 18 | Feb - 18 | Mar - 18 | Apr - 18 | May - 18 | Jun - 18 | Jul - 18 | Aug - 18 | Sep - 18 | Oct - 18 | Nov - 18 | Dec - 18 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Sales Growth | 0% | 7% | 16% | 22% | 76% | -5% | 15% | 15% | 15% | 15% | 15% | 15% |
Expenses Change | 0% | 25% | 32% | 48% | 2% | -14% | 10% | 10% | 10% | 10% | 10% | 10% |
Jan - 18 | Feb - 18 | Mar - 18 | Apr - 18 | May - 18 | Jun - 18 | Jul - 18 | Aug - 18 | Sep - 18 | Oct - 18 | Nov - 18 | Dec - 18 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Cash In ($B = $150K) | $180000 | $82000 | $187000 | $495000 | $114000 | $74750 | $85963 | $98857 | $113685 | $160738 | $150349 | $172901 |
Cash Out | $20000 | $26000 | $26000 | $37000 | $39000 | $42900 | $47190 | $51909 | $57100 | $62810 | $69091 | $76000 |
Endind Month Balance | $160000 | $216000 | $377000 | $835000 | $910000 | $941850 | $980623 | $1027570 | $1084156 | $1152084 | $1233342 | $1330244 |
Gross Burn Rate | $135000 | $143000 | $156000 | $51500 | $58000 | $60950 | $65045 | $99550 | $154504 | $159955 | $165950 | $172545 |
Months of zero cash remaining | 8 | 9 | 15 | 27 | 24 | 23 | 22 | 21 | 12 | 19 | 19 | 19 |