VPS Lakeshore — Strategic Dashboards

Lakeshore Hospital & Research Centre, Kochi  ·  Internal Use Only

FY24 – FY26 13 Dashboards 3 New Executive Access Confidential
Quick Context
₹500 Cr
FY26E Revenue
19%
EBITDA Margin
₹49K
ARPOB / Day
570+
Operating Beds
8.6%
8-Yr Rev CAGR
Executive Office
💼
Chairman's Executive Dashboard
2-Year Transformation Focus · High-Level Strategy
Top-tier strategic overview focusing on the 2-year transformation plan. Includes dual-campus execution (Complex Cancer Centre vs General Hospital), Phase 1-3 Capex milestones, bed expansion plans (244→541), critical risks (AERB approvals), and 30-day pending Board decisions (DOA, Org Structure). Targets optimized EBITDA of ₹149 Cr (25% margin).
New Executive Priority Target EBITDA: ₹149 Cr (25%) Bed Expansion: 244→541 Dual-Campus Strategy
Open Chairman Dashboard
Strategy & Transformation
🎯
Transformation Scorecard
FY26 Baseline → FY29 Target
The 3-year strategic transformation plan. FY26 baseline KPIs versus FY29 targets across revenue (₹500→₹780 Cr), EBITDA, ARPOB (₹49K→₹70K), complex care mix, and ₹300 Cr capital deployment.
Revenue: ₹500→₹780 Cr ARPOB: ₹49K→₹70K 3-Phase Roadmap Capex ₹300 Cr
Open Scorecard
100-Day Efficiency Transformation
8 Tabs · Revenue + Cost Levers · Weekly Governance
Comprehensive 100-day efficiency plan consolidating both revenue and cost levers. P&L impact bridge, sprint tracker, 3-scenario financial model, risk register, and weekly governance cadence. Targets ₹18–28 Cr annualized EBITDA uplift.
New 9 Workstreams ₹18–28 Cr Savings 3 Phases Weekly Review
Open Plan
🏗️
Transformation Floor Plan
Capacity & Infrastructure
Physical infrastructure and floor-level capacity planning for the hospital transformation. Bed allocation, department layout, and expansion roadmap.
Infrastructure Floor Layout Capacity Plan
Open Floor Plan
Board & Multi-Year Intelligence
📋
Board Performance Intelligence — FY24→FY26
3-Year Consolidated · 10 Tabs
Consolidated board-level view spanning FY24–FY26. Executive summary, revenue trajectory, KPI evolution, department deep-dive, doctor economics, payor transformation, capacity & throughput, peer benchmarks, risk & concentration analysis, and strategic roadmap.
ADR ₹1.21→₹1.47 Cr (+21%) ARPOB ₹32K→₹35K (+10%) Insurance 22%→26% Peer Benchmarks Strategic Roadmap
Open Dashboard
FY26 — Current Year
📊
FY26 Performance Dashboard
YTD Jan '26 · 10 Months · 10 Tabs
Comprehensive FY26 year-to-date operating dashboard. Revenue, volumes, ARPOB, department-level drill-down, monthly trends, and variance analysis against budget and prior year.
YTD Performance Dept Breakdown Monthly Trends Budget vs Actual
Open Dashboard
🔬
Cost Intelligence & FY27 Budget
FY27 Budget Analytics · 8 Tabs + 100-Day Plan
Deep-dive into cost structure, headcount economics, and FY27 budget build. Covers ₹202 Cr people cost, 2,589 FTEs, department-wise cost allocation, margin levers, and an integrated 100-day efficiency plan tab.
₹202 Cr People Cost 2,589 FTEs ₹130 Cr Capex People/Rev 36.7%
Open Analysis
📈
Revenue Analytics — FY24 to FY26 Consolidated
3-Year Revenue Trajectory
Consolidated multi-year revenue analysis spanning FY24–FY26. Department-wise trends, revenue mix evolution, doctor contribution, payor shifts, and year-over-year growth tracking across the full period.
FY24–FY26 Revenue Trends Dept Breakdown YoY Growth
Open Dashboard
Clinical Data & Research
🧬
Clinical Research Data Commons
Multi-Domain · Oncology, Cardiology, Nephrology, Neurology, Endocrinology, ICU
Clinical research data commons platform covering 6 domains. Data architecture, access framework, comorbidity insights, and research-grade clinical datasets. Supports real-world evidence generation and cross-specialty analytics.
New 6 Clinical Domains Data Architecture Access Framework Comorbidity Insights
Open Data Commons
FY25 — Prior Year
🏥
Revenue & Doctor Analytics — FY25
FY25 Full Year BRM · 10 Tabs
FY25 full-year revenue analysis by department, doctor, and payor. ₹410 Cr revenue across 40+ doctors, 21,023 IP discharges. Doctor MIS, concentration risk, and portfolio matrix.
₹410 Cr Revenue 21,023 IP Discharges Top 2 = 20.7% Doctor MIS
Open Dashboard
📐
Historical P&L Deep-Dive
FY18–FY25 Audited · 9 Tabs
8-year consolidated P&L trend analysis. Revenue trajectory, cost structure evolution, margin architecture, DuPont decomposition, cash flow, balance sheet quality, and CEO dashboard.
₹228→₹408 Cr EBITDA 8.8%→19.4% Debt-Free CAGR 8.6%
Open Analysis
FY24 — Base Year
👨‍⚕️
Revenue & Doctor Analytics — FY24
FY24 Full Year BRM · 10 Tabs
FY24 full-year BRM data. ₹397 Cr revenue, 115 doctors, 20,932 IP discharges. Includes department breakdown, doctor-level MIS, concentration risk analysis, peer benchmarks, and strategic priorities.
₹397 Cr Revenue 115 Doctors 20,932 Discharges Top 2 = 27.4%
Open Dashboard
⚙️
Biomedical Capex Analysis
Excel Workbook · Download
Detailed biomedical equipment capital expenditure analysis. Asset-level breakdown, useful life, replacement schedule, and budget impact assessment.
Excel (.xlsx) Equipment Capex Replacement Plan
Download File