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 Income1,932,5212,891,9534,225,8557,212,7189,876,895
Depreciation & Amortization186,000511,500759,500811,000704,500
PIK Interest Add-back (non-cash)1,000,0001,100,0001,210,000--
Change in Working Capital2,678,396520,265589,462658,646743,345
Cash from Operations5,796,9175,023,7186,784,8168,682,36411,324,740
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-14,596,91718,720,63511,495,45119,577,815
Net Change in Cash14,596,9174,123,718(7,225,184)8,082,36410,724,740
Ending Cash14,596,91718,720,63511,495,45119,577,81530,302,555
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.