Sample inputs
Sample working view
Month 12 cash$22,819.86
Lowest cash$10,825.00
Reserve breachNone in 12 months
Collection lag1 months
12 sample rows
| Month | Opening cash | Invoiced revenue | Cash collected | Cash costs | Closing cash | Reserve check |
|---|---|---|---|---|---|---|
| 1 | $18,000.00 | $6,500.00 | $0.00 | $7,175.00 | $10,825.00 | Within reserve |
| 2 | $10,825.00 | $6,630.00 | $6,500.00 | $5,994.50 | $11,330.50 | Within reserve |
| 3 | $11,330.50 | $6,762.60 | $6,630.00 | $6,014.39 | $11,946.11 | Within reserve |
| 4 | $11,946.11 | $6,897.85 | $6,762.60 | $6,034.68 | $12,674.03 | Within reserve |
| 5 | $12,674.03 | $7,035.81 | $6,897.85 | $6,055.37 | $13,516.51 | Within reserve |
| 6 | $13,516.51 | $7,176.53 | $7,035.81 | $6,076.48 | $14,475.84 | Within reserve |
| 7 | $14,475.84 | $7,320.06 | $7,176.53 | $6,098.01 | $15,554.36 | Within reserve |
| 8 | $15,554.36 | $7,466.46 | $7,320.06 | $6,119.97 | $16,754.45 | Within reserve |
| 9 | $16,754.45 | $7,615.79 | $7,466.46 | $6,142.37 | $18,078.54 | Within reserve |
| 10 | $18,078.54 | $7,768.10 | $7,615.79 | $6,165.22 | $19,529.11 | Within reserve |
| 11 | $19,529.11 | $7,923.46 | $7,768.10 | $6,188.52 | $21,108.69 | Within reserve |
| 12 | $21,108.69 | $8,081.93 | $7,923.46 | $6,212.29 | $22,819.86 | Within reserve |
Read the sample report
12-MONTH CASH SCENARIO Currency: USD. Starting cash: $18,000.00. Invoices start at $6,500.00 per month with 2% compounded monthly change. Collection lag: 1 months. No pre-period receivables are assumed. Variable costs are paid in the month of invoicing. One-off cost is paid in month 1. Closing cash after 12 months: $22,819.86. First reserve breach: none in modeled horizon. This is a simplified scenario, not an accounting forecast or financing recommendation.
No taxes, borrowing, opening receivables, inflation or unpaid invoices are modeled unless included in your assumptions.