MERIDIAN // FY2026
DISTRIBUTION OPERATIONS
Live portfolio data · auto-refreshes every 60 seconds
Automated WhatsApp & email alerts on breach
Management summary generated every Monday morning
Receivables + working capital in one system
PORTFOLIO OVERVIEW
Receivables Intelligence EngineTotal Outstanding
KES 3.23M
Gross receivables
Total Overdue
KES 2.70M
Past payment date
Overdue %
83.6%
Of total portfolio
Portfolio Risk Score
58.4
HIGH
PRESSURE
CASH RISK SIGNAL
Collection lag creating working capital pressure across hospital portfolio
Largest Single Exposure
KES 620K
Parklands Orthopaedic Hospital
Top Buyer Concentration
19.2%
% of total outstanding
High Risk Accounts
2
Escalation required
Day 1
Instant Visibility
Flag default months before it requires a legal team.
3×
Faster Escalation
Priority accounts ranked automatically — no manual triage required.
0
Manual Reports
Weekly management summaries assembled and delivered without human effort.
AGING BREAKDOWN
Receivables Age0–30 Days
KES 510K
31–60 Days
KES 1.08M
61–90 Days
KES 285K
90+ Days
KES 840K
60+ Amount
KES 1.13M
Accounts > 60 Days
2 accts
MANAGEMENT BRIEF
Monday SignalTop Risk Driver
Parklands Orthopaedic Hospital (91 days) and Riverside Road Specialist Clinic (105 days) are in Legal / Default Review territory. Combined exposure KES 840K at critical risk.
Recommended Action
Issue Legal Notice to Limuru Road immediately. Issue Final Demand to Parklands Orthopaedic this week. Send Urgent Follow-Up to all 31–60 day accounts by Friday.
Management Priority
Clear the 90+ book before end of June to protect working capital cycle. Prioritise Parklands Orthopaedic (KES 620K) and Westgate Specialist (KES 412K) with management calls.
EXPOSURE DETAIL
Customer & Product LineCUSTOMER EXPOSURE
| Customer | Outstanding | Overdue | OD % |
|---|---|---|---|
| Parklands Orthopaedic Hospital | KES 620K | KES 620K | 100.0% |
| City Physio & Rehab | KES 510K | KES 510K | 100.0% |
| Westgate Specialist Hospital | KES 412K | KES 412K | 100.0% |
| Brightfield Children's Hospital | KES 390K | KES 390K | 100.0% |
| Highridge Medical Centre | KES 340K | KES 340K | 100.0% |
| ProMotion Rehab Centre | KES 310K | KES 0 | 0.0% |
| Riverside Medical Centre | KES 285K | KES 285K | 100.0% |
| Highland Mission Hospital | KES 275K | KES 275K | 100.0% |
| Riverside Road Specialist Clinic | KES 220K | KES 220K | 100.0% |
| Lavington Physio Clinic | KES 145K | KES 145K | 100.0% |
PRODUCT LINE RISK SUMMARY
| Product Line | Outstanding | OD % | Risk | Share |
|---|---|---|---|---|
| Orthopaedic | KES 1.36M | 100.0% | HIGH | 42.2% |
| Physiotherapy | KES 1.12M | 100.0% | HIGH | 34.7% |
| Mobility Aids | KES 1.02M | 31.5% | WATCH | 31.5% |
| Rehabilitation | KES 562K | 100.0% | WATCH | 17.4% |
PRIORITY ESCALATION ACCOUNTS
| Rank | Ref | Customer | Product Line | Amount | Days OD | Action |
|---|---|---|---|---|---|---|
| 1 | INV-011 | Riverside Road Specialist Clinic | Orthopaedic | KES 220K | 105 | Legal Notice |
| 2 | INV-004 | Parklands Orthopaedic Hospital | Mobility Aids | KES 620K | 91 | Legal Notice |
| 3 | INV-001 | Riverside Medical Centre | Physiotherapy | KES 285K | 72 | Mgmt Escalation |
| 4 | INV-009 | Lavington Physio Clinic | Physiotherapy | KES 145K | 62 | Urgent F/U |
| 5 | INV-006 | Highridge Medical Centre | Orthopaedic | KES 340K | 55 | Urgent F/U |
| 6 | INV-014 | Highland Mission Hospital | Rehabilitation | KES 275K | 48 | Urgent F/U |
| 7 | INV-002 | Westgate Specialist Hospital | Orthopaedic | KES 412K | 45 | Urgent F/U |
TREND & SETTINGS
SystemOVERDUE TREND
SYSTEM SETTINGS
High Risk Threshold
45
Watch Threshold
5
30-Day Band
30 days
60-Day Band
60 days
90-Day Band
90 days
Alert Recipients
finance@meridianhealthcare.co.ke
+254 700 000 000
WORKING CAPITAL MONITOR
13-Week Cashflow ForecastStatus
ACTIVE
KSh 3.2M working capital trough in Week 5 covered by KSh 10.0M facility with KSh 6.8M headroom.
Facility covers trough at current assumptions, dependent on hospital collection timing improving to 30-day average.
WATCH
WATCH
Monthly Revenue
KSh 8.4M
Invoiced to hospitals & clinics
Monthly COGS
KSh 4.9M
MedTech Supply Co, PhysioEquip International, freight
Gross Margin
42.0%
KSh 3.5M gross profit
Peak Funding Gap
(KSh 3.2M)
Worst weekly shortfall
Facility Headroom
KSh 6.8M
Facility minus peak gap
Collection Rate
72.0%
Actual vs invoiced
Cashflow Status
WATCH
Collection lag critical
Top Risk Driver
Hospital payment terms averaging 45 days vs 30-day supplier requirement creates recurring Weeks 3–6 cash shortfall of KSh 3.2M.
Recommended Action
Escalate Parklands Orthopaedic Hospital (KSh 620K, 91 days) and Westgate Specialist (KSh 412K, 45 days). Request advance payment on next PhysioEquip International restock order.
Management Priority
Draw on WC facility only after Week 6 review. Hold KSh 2M cash buffer minimum through Week 10. Negotiate 45-day terms with MedTech Supply Co rep this month.
Collections Signal
Forecast
KSh 6.05M
Actual
KSh 4.36M
Shortfall
(1.69M)
Rate
72.0%
Risk Signal
Active Risks
5
Top Score
8
Provision
KSh 1.8M
Top Risk
Collection lag
Funding Structure
Facility
KSh 10.0M
Peak Required
KSh 3.2M
Headroom
KSh 6.8M
Covered
YES
Collection Variance
Below target
Actual vs forecast to date
Peak Gap Week
Week 5
Worst cash trough
Max Weekly Outflow
KSh 3.6M
Highest single week
Total Finance Drawn
KSh 2.8M
KSh vs facility
Weekly Inflows vs Outflows — 13-Week Working Capital Forecast
Bars show weekly cash movement · Line shows cumulative position · Red circle marks peak gap · Green triangle marks recovery
Funding Gap by Week
Negative equals cash shortfall · Peak W5 −KSh 3.2M
Inflow Composition by Type
Total across 13-week forecast period
Base collections (30-day)
KSh 31.4M
Contracted receivables
KSh 21.8M
Late-cycle collections
KSh 12.1M
Weekly Cashflow Schedule — All 13 Weeks
Red = peak gap · Green = first recovery
| Week | Inflows | Outflows | Net | Equity / Finance | Cumulative | Funding Gap |
|---|
PROJECT ASSUMPTIONS
Business ContextBusiness
NameMeridian Healthcare Ltd
TypeClinical Equipment Distributor
StartJun 2026
Duration13 weeks rolling
Product LinesPhysio · Mobility · Ortho · Rehab
Revenue
Monthly revenueKSh 8,400,000
Collection rate72% in month 1
Avg payment termsNet 45 days
COGS %58%
Units / month840 cases
Funding
Equity bufferKSh 2,000,000
WC facilityKSh 10,000,000
Interest rate1.5% per month
Facility coverage3.12x
Supplier termsDJO / PhysioEquip International 30d
COST TRACKER
Budget vs ActualTotal Budget
KSh 11.0M
Committed
KSh 8.0M
Actual Spent
KSh 5.8M
Utilisation
52.7%
Remaining
KSh 5.2M
| Category | Budget KSh | Committed | Actual Spent | Remaining | Variance % | Status |
|---|---|---|---|---|---|---|
| Equipment — Physiotherapy | 3,600,000 | 3,600,000 | 2,880,000 | 720,000 | Under 20.0% | On Track |
| Equipment — Mobility Aids | 2,400,000 | 2,400,000 | 1,920,000 | 480,000 | Under 20.0% | On Track |
| Equipment — Orthopaedic | 2,800,000 | 2,100,000 | 1,540,000 | 1,260,000 | Under 45.0% | On Track |
| Equipment — Rehabilitation | 1,800,000 | 1,440,000 | 1,080,000 | 720,000 | Under 40.0% | On Track |
| Clearing, Freight & Logistics | 2,880,000 | 2,880,000 | 2,160,000 | 720,000 | Under 25.0% | On Track |
| Staff Salaries | 7,800,000 | 7,800,000 | 3,250,000 | 4,550,000 | Under 58.3% | On Track |
| Westlands Business Centre Rent (Westlands) | 2,160,000 | 2,160,000 | 900,000 | 1,260,000 | Under 58.3% | On Track |
| Marketing & Trade Promotions | 960,000 | 480,000 | 240,000 | 720,000 | Under 75.0% | Watch |