Staydium Financial Model — DCF · Scenarios · Investor Returns
Monthly cash & covenants(as requested)

Monthly Cash

60-month cash roll-forward with min-cash covenant test

Scenario
Starting Cash
5,000,000
Assumed opening balance
Total Tranche Cash-In
10,000,000
All planned raises
Lowest Cash (60 mo)
16,236,339
Min-Cash Breach
None
Threshold: 3mo opex
Monthly Cash Roll-Forward (60 months)
PeriodOpeningReceiptsDisbursementsTranche InClosingMin-CashFlag
Y1 M15,000,0002,171,250(934,911)10,000,00016,236,3392,804,733✓
Y1 M216,236,3392,171,250(934,911)—17,472,6782,804,733✓
Y1 M317,472,6782,171,250(934,911)—18,709,0182,804,733✓
Y1 M418,709,0182,171,250(934,911)—19,945,3572,804,733✓
Y1 M519,945,3572,171,250(934,911)—21,181,6962,804,733✓
Y1 M621,181,6962,171,250(934,911)—22,418,0352,804,733✓
Y1 M722,418,0352,171,250(934,911)—23,654,3742,804,733✓
Y1 M823,654,3742,171,250(934,911)—24,890,7132,804,733✓
Y1 M924,890,7132,171,250(934,911)—26,127,0532,804,733✓
Y1 M1026,127,0532,171,250(934,911)—27,363,3922,804,733✓
Y1 M1127,363,3922,171,250(934,911)—28,599,7312,804,733✓
Y1 M1228,599,7312,171,250(934,911)—29,836,0702,804,733✓
Y2 M129,836,0702,653,750(1,070,286)—31,419,5343,210,859✓
Y2 M231,419,5342,653,750(1,070,286)—33,002,9973,210,859✓
Y2 M333,002,9972,653,750(1,070,286)—34,586,4613,210,859✓
Y2 M434,586,4612,653,750(1,070,286)—36,169,9243,210,859✓
Y2 M536,169,9242,653,750(1,070,286)—37,753,3883,210,859✓
Y2 M637,753,3882,653,750(1,070,286)—39,336,8513,210,859✓
Y2 M739,336,8512,653,750(1,070,286)—40,920,3153,210,859✓
Y2 M840,920,3152,653,750(1,070,286)—42,503,7783,210,859✓
Y2 M942,503,7782,653,750(1,070,286)—44,087,2423,210,859✓
Y2 M1044,087,2422,653,750(1,070,286)—45,670,7053,210,859✓
Y2 M1145,670,7052,653,750(1,070,286)—47,254,1693,210,859✓
Y2 M1247,254,1692,653,750(1,070,286)—48,837,6323,210,859✓
Y3 M148,837,6323,211,038(1,212,682)—50,835,9873,638,047✓
Y3 M250,835,9873,211,038(1,212,682)—52,834,3433,638,047✓
Y3 M352,834,3433,211,038(1,212,682)—54,832,6983,638,047✓
Y3 M454,832,6983,211,038(1,212,682)—56,831,0533,638,047✓
Y3 M556,831,0533,211,038(1,212,682)—58,829,4093,638,047✓
Y3 M658,829,4093,211,038(1,212,682)—60,827,7643,638,047✓
Y3 M760,827,7643,211,038(1,212,682)—62,826,1193,638,047✓
Y3 M862,826,1193,211,038(1,212,682)—64,824,4753,638,047✓
Y3 M964,824,4753,211,038(1,212,682)—66,822,8303,638,047✓
Y3 M1066,822,8303,211,038(1,212,682)—68,821,1853,638,047✓
Y3 M1168,821,1853,211,038(1,212,682)—70,819,5413,638,047✓
Y3 M1270,819,5413,211,038(1,212,682)—72,817,8963,638,047✓
Y4 M172,817,8963,853,245(1,346,619)—75,324,5224,039,858✓
Y4 M275,324,5223,853,245(1,346,619)—77,831,1474,039,858✓
Y4 M377,831,1473,853,245(1,346,619)—80,337,7734,039,858✓
Y4 M480,337,7733,853,245(1,346,619)—82,844,3984,039,858✓
Y4 M582,844,3983,853,245(1,346,619)—85,351,0244,039,858✓
Y4 M685,351,0243,853,245(1,346,619)—87,857,6494,039,858✓
Y4 M787,857,6493,853,245(1,346,619)—90,364,2754,039,858✓
Y4 M890,364,2753,853,245(1,346,619)—92,870,9004,039,858✓
Y4 M992,870,9003,853,245(1,346,619)—95,377,5264,039,858✓
Y4 M1095,377,5263,853,245(1,346,619)—97,884,1514,039,858✓
Y4 M1197,884,1513,853,245(1,346,619)—100,390,7774,039,858✓
Y4 M12100,390,7773,853,245(1,346,619)—102,897,4024,039,858✓
Y5 M1102,897,4024,591,784(1,484,134)—106,005,0524,452,403✓
Y5 M2106,005,0524,591,784(1,484,134)—109,112,7014,452,403✓
Y5 M3109,112,7014,591,784(1,484,134)—112,220,3504,452,403✓
Y5 M4112,220,3504,591,784(1,484,134)—115,327,9994,452,403✓
Y5 M5115,327,9994,591,784(1,484,134)—118,435,6484,452,403✓
Y5 M6118,435,6484,591,784(1,484,134)—121,543,2974,452,403✓
Y5 M7121,543,2974,591,784(1,484,134)—124,650,9474,452,403✓
Y5 M8124,650,9474,591,784(1,484,134)—127,758,5964,452,403✓
Y5 M9127,758,5964,591,784(1,484,134)—130,866,2454,452,403✓
Y5 M10130,866,2454,591,784(1,484,134)—133,973,8944,452,403✓
Y5 M11133,973,8944,591,784(1,484,134)—137,081,5434,452,403✓
Y5 M12137,081,5434,591,784(1,484,134)—140,189,1934,452,403✓
Methodology & caveats
  • Monthly receipts / disbursements spread evenly within each fiscal year — refine when Working Capital DSO/DPO curves are wired in.
  • Tranche cash-in lands in the exact close month set on the Funding tab.
  • Min-cash threshold = 3 months × trailing monthly disbursements. Editable on Master Inputs → Working Capital.
  • Breach flag ⚠ = closing cash falls below threshold. Every ⚠ requires an action: pull-forward a tranche, cut opex, or defer capex.