Cash Runway with Changing Revenue
Calculate using the labelled inputs: Cash Runway with Changing Revenue.
Enter a finite value within the formula’s domain and supported numeric range.
| Month | Opening cash | Cash receipts | Cash outflow | Closing cash |
|---|
Calculation and assumptions
receipts_(m+1)=round(receipts_m·(1+growth/100),2); cash_m=cash_(m−1)+receipts_m−outflow; zero_time=(m−1)+opening_cash_m/(outflow−receipts_m).
Cash receipts, not booked revenue. Outflow stays constant; receipts change after each month and round to cents, halves away from zero. Growth allows six decimals. Within-month depletion assumes the net flow is uniform. Zero opening cash gives time zero. A dash means no depletion or no covering month within the entered horizon, not infinite runway or guaranteed profit. The table continues hypothetically after depletion and may recover later; continuing activity would need financing that is not included. No funding, tax or cost-growth assumptions are added. First covering month does not guarantee later coverage when receipts decline. In one chosen two-decimal currency; no taxes or current market rates are supplied.
Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.
Frequently asked questions
How is the result calculated?
receipts_(m+1)=round(receipts_m·(1+growth/100),2); cash_m=cash_(m−1)+receipts_m−outflow; zero_time=(m−1)+opening_cash_m/(outflow−receipts_m).
What assumptions apply?
Cash receipts, not booked revenue. Outflow stays constant; receipts change after each month and round to cents, halves away from zero. Growth allows six decimals. Within-month depletion assumes the net flow is uniform. Zero opening cash gives time zero. A dash means no depletion or no covering month within the entered horizon, not infinite runway or guaranteed profit. The table continues hypothetically after depletion and may recover later; continuing activity would need financing that is not included. No funding, tax or cost-growth assumptions are added. First covering month does not guarantee later coverage when receipts decline. In one chosen two-decimal currency; no taxes or current market rates are supplied.
How precise are the results?
Monetary totals use two decimal places with the stated rounding rule; other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.