Staydium Financial Model — DCF · Scenarios · Investor Returns
Statements drill-through(as requested)
Income StatementBalance SheetDCF
Pivot convertible ($10M PIK)(as requested)
Balance SheetIncome Statement
Tranched funding(as requested)
Funding & TranchesOwnership
Working capital(as requested)
Working CapitalMaster Inputs

Cash Flow Statement

Click any number to open source, formula, and editable drivers

Scenario
Consolidated Cash Flow Statement
FY2026FY2027FY2028FY2029FY2030
Operating Activities
Net Income10,237,55313,042,54716,508,07321,951,38027,440,468
Depreciation & Amortization186,000511,500759,500811,000704,500
PIK Interest Add-back (non-cash)1,000,0001,100,0001,210,000--
Change in Working Capital4,007,201815,555930,5211,051,6771,195,331
Cash from Operations15,430,75315,469,60219,408,09423,814,05729,340,298
Investing Activities
Capital Expenditures(1,200,000)(900,000)(700,000)(600,000)(600,000)
Cash from Investing(1,200,000)(900,000)(700,000)(600,000)(600,000)
Financing Activities
Convertible Debt Issuance (Pivot)10,000,000----
Convertible Debt Repayment (principal + accrued PIK)--(13,310,000)--
Equity Contributions (residual plug to min cash)-----
Cash from Financing10,000,000-(13,310,000)--
Cash Rollforward
Beginning Cash-24,230,75338,800,35544,198,44967,412,506
Net Change in Cash24,230,75314,569,6025,398,09423,214,05728,740,298
Ending Cash24,230,75338,800,35544,198,44967,412,50696,152,805
Minimum Cash Requirement2,856,9873,259,0813,687,7154,091,0164,505,096
Convertible Debt Schedule — Pivot ($10M principal, 10% PIK, repay end of FY2028)
FY2026FY2027FY2028FY2029FY2030
Opening Balance-11,000,00012,100,000--
Debt Issued10,000,000----
PIK Interest Accrued (10%)1,000,0001,100,0001,210,000--
Principal + Accrued PIK Repaid--(13,310,000)--
Closing Balance11,000,00012,100,000---

Click any number to open its drill-down.