💰 Finance Tracker — FY27 Upside Case
VPS Lakeshore Hospital & Research Centre · P&L · Revenue · Costs · Capex · Actuals
FY27 UC Rev ₹575 Cr
EBITDA ₹148.8 Cr (25.8%)
Capex ₹82.21 Cr
Apr 2026 – Mar 2027
FY27 Upside Case · Confidential
Internal Finance Use Only
Last Updated: Mar 2026
Internal Finance Use Only
Last Updated: Mar 2026
📊 YTD Performance — FY27 Upside Case
YTD Revenue (Plan)
—
vs ₹575 Cr FY total
YTD EBITDA (Plan)
—
Target 25.8% margin
EBITDA Margin
—
Plan vs Actual
YTD Total Cost
—
Staff + Doc + COGS + Other
Capex Utilized
—
of ₹82.21 Cr budget
Plan basis: FY27 Upside Case (UC) — Revenue ₹575 Cr · EBITDA ₹148.8 Cr (25.8%) · Based on Executive Dashboard FY27 UC targets.
Revenue ramp: Apr ₹42 Cr → Mar ₹53.5 Cr. Upload monthly actuals via the Upload Actuals tab to see plan vs actual variance.
Monthly Revenue — Plan vs Actual (₹ Cr)
FY27 UC Plan · Actual from uploaded data
Monthly EBITDA — Plan vs Actual (₹ Cr)
FY27 UC Plan · Target 25.8% margin
📋 Monthly P&L — Plan vs Actual (₹ Crores)
🏥 Revenue Breakup by Department — Monthly Plan (₹ Crores)
Department-level monthly plan split from FY27 UC annual targets. Upload dept-wise actuals via the Upload Actuals tab to see plan vs actual here.
Top 20 specialties + ancillaries shown. Remaining revenue is diagnostics, pharmacy, and other ancillaries.
🏥 Department-wise Revenue — FY27 Upside Case (₹ Crores)
Monthly plan is proportionally distributed based on the FY27 UC annual target for each specialty.
Upload actuals to see plan vs actual by department. Total of top-20 specialties = ₹497.1 Cr; remaining ₹77.9 Cr covers diagnostics, pharmacy OTC, and other ancillaries.
Department Revenue — FY27 UC Annual Target (₹ Cr)
Top 20 specialties · Upside Case
👨⚕️ Consultant Revenue — FY27 Estimated Plan (₹ Crores)
Note: Consultant-level revenue split is estimated based on specialty share and key doctors identified in the transformation plan.
Upload actual consultant-wise billing data (from HIS export) via the Upload Actuals tab to replace estimates with actuals.
👥 Staff Payroll — FY27 UC Plan: ₹81.85 Cr
Total Payroll
₹81.85 Cr
After HR rationalization (from ₹94.85 Cr BC)
Total Staff
1,624
Non-doctor headcount
HR Savings Target
₹11.0 Cr
vs FY27 BC staffing plan
Avg Monthly Payroll
₹6.82 Cr
Fixed cost base
Staff Cost by Category (₹ Cr)
🩺 Doctor / Consultant Costs — FY27 UC Plan: ₹99.08 Cr
Total Doctor Cost
₹99.08 Cr
Fees + PLCs + visiting
% of Revenue
17.2%
FY26E was 17.7%
PLC Conversions
Target
Reduces fixed cost risk
💊 Consumption / COGS — FY27 UC Plan: ₹155.25 Cr (26.5%)
Total COGS
₹155.25 Cr
Target 26.5% of revenue
COGS % Target
26.5%
vs FY26E 28.5% (−2pp saving)
Saving vs FY26E
₹7 Cr
Procurement optimization
📋 Other Operating Costs — FY27 UC Plan: ₹65.24 Cr
Other Costs
₹65.24 Cr
Power, Mktg, Overhead, Admin
Saving vs BC
₹2 Cr
Solar + digital marketing shift
✂️ HR Rationalization — Target Savings: ₹11.0 Cr
HR rationalization identifies ₹11 Cr of payroll savings through targeted headcount reduction in over-staffed departments and realignment of senior doctors to PLCs.
Rationalisation is phased through FY27. Upload monthly headcount actuals to track progress.
🏗️ Capex Tracker — FY27 Budget: ₹82.21 Cr
Total Budget
₹82.21 Cr
FY27 AOP V2
Spent (Actual)
₹0.00 Cr
From uploaded actuals
Balance
₹82.21 Cr
Remaining budget
Utilization
0%
of annual budget
P&M Dominant
67.0%
Plant & Machinery
Capex by Category — Budget vs Spent (₹ Cr)
Capex Utilization (%)
📤 Upload Monthly Actuals
Upload your monthly P&L actuals here. Supported formats: Excel (.xlsx), CSV, or Manual Entry.
Data is saved to browser storage and updates all tabs automatically. For best results use the standard template (download below).
Step 1 — Select Month & Upload Type
Step 2A — Upload File
Click to browse or drag & drop your file here
Supports .xlsx, .csv · Max 10MB
Standard P&L template with required column headers
📋 File Preview — Map columns to P&L line items
📊 Months with Actuals Loaded
📋 Finance Requisitions & Document Log
Log of all finance documents uploaded or entered into the tracker. Each upload automatically creates a log entry.
You can also add manual requisition records for finance approvals, vendor invoices, or audit documents.
➕ Add Manual Requisition Entry
📈 FY27 Base Case (BC) — AOP Monthly P&L (₹ Crores)
FY27 Base Case — AOP budget approved for FY27 before upside levers. Revenue ₹525.7 Cr · EBITDA ₹107.2 Cr (20.4% margin).
Payroll includes BC headcount (before HR rationalization savings of ₹11 Cr). Compare with the UC tab to see the value of the transformation levers.
BC Revenue
₹525.7 Cr
vs UC ₹575 Cr (gap: ₹49.3 Cr)
BC EBITDA
₹107.2 Cr
20.4% margin vs UC 25.8%
EBITDA Gap (UC vs BC)
₹41.6 Cr
Revenue levers ₹30 Cr + Cost ₹20 Cr − overlap
BC Total Costs
₹418.5 Cr
Pre-rationalization base
BC vs UC Monthly Revenue (₹ Cr)
BC vs UC Monthly EBITDA (₹ Cr)
📋 FY27 BC Monthly P&L (₹ Crores)
🏥 FY27 BC Revenue by Department
📅 FY26 Closing Numbers — Apr 2025 to Mar 2026
FY26 Estimated Close — ₹452.8 Cr revenue · ₹98.8 Cr EBITDA (21.8%). Currently 10 months of actuals available (Apr-25 to Jan-26).
Feb-26 and Mar-26 actuals pending. Use the Update FY26 Actuals section below to feed in new data as it becomes available. All figures update automatically.
FY26E Revenue
₹452.8 Cr
Full year estimate
FY26E EBITDA
₹98.8 Cr
21.8% margin
10M Actual Rev
—
Apr-25 to Jan-26
10M Actual EBITDA
—
Annualised est.
Months with Data
—
of 12 months
FY26 Monthly Revenue — Plan vs Actual (₹ Cr)
FY26 Monthly EBITDA — Plan vs Actual (₹ Cr)
📋 FY26 Monthly P&L — Plan vs Actual (₹ Crores)
✏️ Update FY26 Actuals
Enter or update monthly actuals for FY26 (₹ Crores)
Months loaded:
🏥 FY26 Revenue by Department — BRM Actuals (YTD Apr-25 to Jan-26)
Source: BRM Deck FY26 — Kochi Unit · Period: 10 months YTD (Apr 2025 – Jan 2026) · Total YTD: ₹378.01 Cr · IP: ₹263.88 Cr | OP: ₹99.70 Cr | F&B: ₹14.43 Cr
Growth % vs FY27 UC is calculated against annualised FY26 (YTD × 1.2).
Growth % vs FY27 UC is calculated against annualised FY26 (YTD × 1.2).
✏️ Input Department-wise FY26 Actuals
Enter or update department-wise actuals for FY26 (₹ Crores)
Use this to record the final full-year FY26 actuals per department once available (Feb-26 & Mar-26 close). Values are stored in your browser session.
Departments with full-year actuals saved: