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
Overdue 31+ Days
KES 2.70M
Excludes 0-30 day receivables
Overdue %
83.6%
31+ days / outstanding
Portfolio Risk Score = overdue percentage + aging severity + concentration penalty. Aging severity adds 2.5 points for each account over 60 days, capped at 15 points. Concentration adds 5 points only if the largest buyer is more than 40% of total outstanding.
Portfolio Risk Score
58.4
HIGH
PRESSURE
CASH RISK SIGNAL
Collection lag increasing overdue exposure across hospital portfolio
Largest Single Exposure
KES 620K
Largest unpaid invoice
Top Buyer Concentration shows how much of total unpaid receivables sits with the single largest buyer. Formula: largest buyer outstanding balance divided by total outstanding receivables.
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.
RECEIVABLES AGING
Total Receivables AgeCurrent / 0-30 Days
KES 510K
31–60 Days
KES 1.08M
61–90 Days
KES 285K
90+ Days
KES 840K
60+ Exposure
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 month end. Prioritise the largest aged accounts for 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 timing gap created by delayed collections; KSh 10.0M facility leaves KSh 6.8M liquidity 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
DJO Global, Chattanooga, freight
Gross Margin
42.0%
KSh 3.5M gross profit
Peak Cash Timing Gap
(KSh 3.2M)
Worst weekly cash shortfall before liquidity support
Liquidity Headroom
KSh 6.8M
Available facility after peak cash gap
Collections vs Forecast
72.0%
Cash received vs forecast
Cashflow Status
WATCH
Collections delayed, margin still positive
Top Risk Driver
45-day hospital payment terms create recurring W3-W6 cash trough.
Recommended Action
Escalate overdue hospital accounts. Request advance on Chattanooga restock. Review DJO Global terms.
Management Priority
Use facility only if collections remain delayed after W6. Hold KSh 2M buffer and review supplier terms 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
Liquidity Cover
WC Facility
KSh 10.0M
Peak Gap
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
Cash Timing 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 | Cash Timing 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
Liquidity cover3.12x
Supplier termsGlobal Suppliers Ltd/Elysium Ltd
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 |