📊
FY27 Financial Projection — Key Building Blocks₹59,731L Revenue · ₹14,283L EBITDA| Category | Amount (₹L) | % of Revenue | Detail |
|---|---|---|---|
| Total Income | 59,731 | 100% | IP ₹43,785L + OP ₹15,021L + Other ₹925L |
| Revenue from Initiatives (21) | 4,432 | 7.4% | IP ₹3,440L + OP ₹992L across 6 categories |
| Less: Cost to Execute | −735 | 1.2% | Hiring, marketing, IT, training for 21 initiatives |
| Net Revenue Contribution | 3,697 | 6.2% | |
| Cost Savings (20 initiatives) | 1,135 | 1.9% | Procurement, staffing & operational efficiencies |
| Consumption | 14,946 | 25.0% | Procurement + materials |
| Doctor Cost | 9,864 | 16.5% | Kochi doctors — professional fees separate |
| Contribution | 34,920 | 58.5% | |
| Employee Cost | 9,610 | 16.1% | ₹800.8L/month flat |
| Marketing | 4,025 | 6.7% | Front-loaded H1 for BD ramp |
| Other Fixed Costs | 6,846 | 11.5% | R&M, HK, utilities, security, admin |
| EBITDA (Conservative) | 14,283 | 24.2% | Margin target after full initiative ramp |
💰
P&L Projection — Monthly Breakdown₹59,731L Revenue| P&L Line | Annual ₹L | %Rev | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IP Revenue | 43,785 | 73.3% | 2,955 | 3,252 | 3,387 | 3,784 | 3,364 | 3,766 | 3,621 | 3,796 | 3,948 | 3,971 | 3,812 | 4,130 |
| OP Revenue | 15,021 | 25.1% | 1,152 | 1,202 | 1,252 | 1,352 | 1,202 | 1,302 | 1,252 | 1,252 | 1,302 | 1,252 | 1,202 | 1,302 |
| Other Income | 925 | 1.5% | 68 | 76 | 76 | 77 | 77 | 78 | 78 | 79 | 79 | 78 | 80 | 79 |
| Total Income | 59,731 | 100% | 4,175 | 4,530 | 4,715 | 5,213 | 4,643 | 5,146 | 4,951 | 5,127 | 5,329 | 5,301 | 5,094 | 5,511 |
| Consumption | 14,946 | 25.0% | 1,091 | 1,165 | 1,190 | 1,317 | 1,154 | 1,285 | 1,224 | 1,267 | 1,320 | 1,311 | 1,256 | 1,366 |
| Doctor Cost | 9,864 | 16.5% | 795 | 807 | 813 | 831 | 810 | 828 | 821 | 827 | 834 | 833 | 826 | 840 |
| Contribution | 34,920 | 58.5% | 2,289 | 2,558 | 2,712 | 3,065 | 2,679 | 3,033 | 2,906 | 3,033 | 3,175 | 3,157 | 3,012 | 3,305 |
| Employee Cost | 9,610 | 16.1% | ₹800.8L/month flat | |||||||||||
| Perf Incentive Pool | 344 | 0.6% | 16 | 16 | 16 | 24 | 16 | 16 | 37 | 16 | 16 | 44 | 16 | 105 |
| Marketing Cost | 4,025 | 6.7% | 495 | 471 | 455 | 396 | 381 | 365 | 244 | 244 | 244 | 244 | 244 | 244 |
| Repair & Maint | 1,612 | 2.7% | ₹134-135L/month | |||||||||||
| Housekeeping | 1,040 | 1.7% | ₹86-88L/month | |||||||||||
| Bad Debts | 1,000 | 1.7% | 167 | 167 | 167 | 167 | 167 | 167 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Fixed | 2,850 | 4.8% | Utilities, Lab, Rent, Security, etc. | |||||||||||
| Total Fixed Cost | 20,481 | 34.3% | 2,034 | 1,995 | 1,985 | 1,829 | 1,802 | 1,786 | 1,516 | 1,490 | 1,487 | 1,519 | 1,488 | 1,582 |
| EBITDA | 14,439 | 24.2% | 255 | 563 | 727 | 1,236 | 877 | 1,247 | 1,390 | 1,543 | 1,688 | 1,638 | 1,524 | 1,723 |
📋
Q1 Operating Plan — Apr-Jun 2026₹13,420L Rev · ₹1,479L EBITDA · 13 initiatives live| P&L Line (₹L) | Apr | May | Jun | Q1 Total | % of FY |
|---|---|---|---|---|---|
| IP Revenue | 2,955 | 3,252 | 3,387 | 9,594 | 21.9% |
| OP Revenue | 1,152 | 1,202 | 1,252 | 3,606 | 24.0% |
| Other Income | 68 | 76 | 76 | 220 | 23.8% |
| Total Revenue | 4,175 | 4,530 | 4,715 | 13,420 | 22.5% |
| Consumption | 1,091 | 1,165 | 1,190 | 3,446 | 23.1% |
| Contribution | 2,289 | 2,558 | 2,712 | 7,559 | 21.6% |
| EBITDA | 255 | 563 | 727 | 1,545 | 10.8% |
| EBITDA Margin | 6.1% | 12.4% | 15.4% | 11.5% |
🚀
Revenue Growth Initiatives (21)₹4,432L uplift · ₹735L cost · ₹3,697L net
💡 Click any initiative card to see its full financial flow, monthly phasing, and deliverables
Initiative Phasing — Impact Start Month
AprMayJunJulAugSepOctNovDecJanFebMar
✂️
Cost Rationalisation Initiatives (20)₹1,135L savings
💡 Click any initiative card to see its savings flow, monthly phasing, and deliverables
Cost Saving Phasing — Impact Start Month
AprMayJunJulAugSepOctNovDecJanFebMar
👥
Leadership Accountability & OKR Ownership7 Roles · Per-person cards🏆
Performance Incentive Framework₹365L pool · 3 Tiers · 12.1× ROIThe TC generates ₹4,432L in incremental revenue. This framework takes 8.2% of that uplift (₹365L) and returns it as staff incentives — only when the uplift is actually delivered. Nothing is paid on base revenue. Everything is paid on what the transformation adds.
TIER 1₹192L/yrMonthly Spot Award · ₹16L/month
Who: Any employee, any level (not doctors) · Amount: Up to ₹25,000 per award · Trigger: HOD nomination citing specific TC initiative · Gate: CEO/COO approval · ~356 awards/month across 1,779 staff
TIER 2₹84L/yrQuarterly KPI Pool · 2% of revenue uplift
Who: 7 HODs + functional heads · Gate: Scorecard ≥ 60% · Weights: Revenue 30% · Cost 15% · BD admissions 20% · Billing 15% · Execution 10% · NPS 10%
| Quarter | Uplift Target | 2% Pool | # Live |
|---|---|---|---|
| Q1 (Apr-Jun) | ₹387L | ₹7.7L | 1→13 |
| Q2 (Jul-Sep) | ₹1,062L | ₹21.2L | 16→19 |
| Q3 (Oct-Dec) | ₹1,386L | ₹27.7L | 21 |
| Q4 (Jan-Mar) | ₹1,386L | ₹27.7L | 21 |
TIER 3₹89LAnnual Award · EBITDA gate ≥ ₹13,000L
Who: CEO, CFO, Medical Director, Head BD, Head Ops · Max: ₹12L/person · Hard gate: EBITDA ≥ ₹13,000L (90% of target). If missed, Tier 3 does NOT pay. No exceptions.
📑
Cost Line Item Detail — All DT_ Sheets22 Sheets · Monthly Projections
💡 Click any cost line to expand its monthly projection with a chart
| Cost Line Item | Annual (₹L) | Monthly Avg (₹L) | H1 (₹L) | H2 (₹L) | Linked Initiatives |
|---|
📋
TC Deliverables & Milestones — Quarterly Roadmap4 Quarters · 61 Initiatives
Quarterly milestones for the Transformation Case. Each deliverable maps to specific initiatives and accountable owners. Status should be updated monthly during TC Steering Committee reviews.
Q1 — Apr-Jun 2026 · Foundation & Launch · 13 Initiatives Live
Q2 — Jul-Sep 2026 · Scale & Accelerate · 19 Initiatives Live
Q3 — Oct-Dec 2026 · Optimize & Deliver · All 21 Initiatives Live
Q4 — Jan-Mar 2027 · Sustain & Close · Full Run-Rate
🔄
How to Update This Dashboard
Monthly update workflow: Open a Cowork session with the latest Excel actuals and say
Manual edit: All data is in the
Data source: Budget_AOP_FY27_TC_v2_fixed.xlsx · Sheets: Overall Summary, TC Initiatives, Initiative Impact, TC Governance & OKR, TC Perf Pay Advisory
"Update the TC AOP dashboard". Claude will extract new numbers and regenerate this page.Manual edit: All data is in the
DATA object at the bottom of this HTML file. Update the arrays for monthlyEBITDA, revInits, costInits, etc. and redeploy to GitHub Pages.Data source: Budget_AOP_FY27_TC_v2_fixed.xlsx · Sheets: Overall Summary, TC Initiatives, Initiative Impact, TC Governance & OKR, TC Perf Pay Advisory