Cash Position
Closing cash vs. minimum and target. Shaded weeks indicate covenant exceptions.
Weekly Cash Flows
Receipts, disbursements and net by week.
Direct Cash Flow Forecast
Near-term weeks are driven by open invoices and bills from the uploaded ledger, run through each counterparty's payment behavior. Later weeks use the billing and purchase run-rates. Edited cells are absolute overrides shown in amber; double-click to restore.
Cash Bridge
Opening to closing cash by category over the horizon.
Receivables
Customer payment profiles drive expected receipt timing for open invoices.
Customer Payment Profiles
Open Invoices
AR Aging
Payables
Payment decision per open bill. Rows landing in the trough week are shaded.
Open Payables
Scheduled Outflows
Payroll runs and fixed monthly commitments.
Fixed Monthly Outflows
Operating Expense Cash Flow
Weekly run-rate with discretionary actions applied.
Opex Actions
Capital Expenditure Schedule
Individual projects; deferrable projects can be moved.
Capital Projects
Revolver Utilization
Drawn balance against the facility and covenant ceiling.
Covenant Compliance
Minimum cash, minimum liquidity and utilization tested weekly.
Debt Service Schedule
Scheduled debt service and revolver activity.
Shortfall Coverage Options
Available actions for the selected week, priced on a comparable basis. Critical suppliers and covenant-breaching draws are excluded from the recommendation.
Early-Payment Discount Analysis
Annualized return on each open discount vs. revolver cost.
Scenario Comparison
Closing cash by scenario. Ledger entries, decisions and edits are held constant; dashed line is the minimum.
Sensitivity Analysis
Impact of each driver on trough cash.
Collection History
Paid invoices in the uploaded ledger, used to derive customer payment profiles.