Calculation 1
Find when the business reaches its cash floor
What are we finding?
We are finding the first month when ending cash reaches zero or less.
What do these numbers mean?
- Cash now: $480,000
- The money available before month one starts.
- Month one cash in: $32,000
- Money expected to be collected during month one.
- Month one cash out: $78,000
- Money expected to be paid during month one.
- Month one burn: $46,000
- Cash out is larger than cash in, so the business uses this much cash.
- Planned outside money: $0
- No outside funding is included.
How do we calculate it?
For each month, add any planned outside money, add cash collected, and subtract cash paid. Then apply the entered monthly changes to next month's cash in and cash out.
ending cash = starting cash + outside money + cash in − cash out
$480,000 + $0 + $32,000 − $78,000
- Month one starts with $480,000.
- Month one cash changes by $32,000 minus $78,000, which is -$46,000.
- After month one, cash in changes by 8% each month and cash out changes by 2% each month.
- Repeating the monthly rule first produces an ending balance at or below zero in month 15.
Final answer
Cash reaches zero or less in month 15
What does the answer mean?
This is a timing model. It depends on collecting and spending exactly as entered. A late payment or surprise cost can shorten the time.