Hospital case Study

requirement 15 doctors1L Salary= 15,00,000

300 beds= 300 crore (210cr Debt) 50 staff 10k avg sal= 5,00,000
7:03 (90cr equity)
300 crores
40% Building 120cr
15% Plant & Machinery 45cr
10% Furnitures & Fixtures 30cr
35% Medical Equipments 105cr
10% appraisal every 3rd year
10% appraisal every 3rd year
 unit 300 300 300 300 300
price ₹ 20,000.00 ₹ 20,200.00 ₹ 20,402.00 ₹ 20,606.02 ₹ 20,812.08
Revenue 1% 1% 1% 1% 1% 1%
unit price ₹ 8,000.00 ₹ 8,080.00 ₹ 8,160.80 ₹ 8,242.41 ₹ 8,324.83
COGS 1% 1% 1% 1% 1% 1%
EBE ₹ 2,000,000.00 ₹ 2,100,000.00 ₹ 2,205,000.00 ₹ 2,315,250.00 ₹ 2,431,012.50
5% 5% 5% 5% 5% 5%
other ₹ 1,000,000.00 ₹ 1,010,000.00 ₹ 1,020,100.00 ₹ 1,030,301.00 ₹ 1,040,604.01
1% 1% 1% 1% 1% 1%
Repairs Etc
OPEX
Tax 40% 40% 40% 40% 40% 40%
Net Revenue₹ 6,000,000.00 ₹ 6,060,000.00 ₹ 6,120,600.00 ₹ 6,181,806.00 ₹ 6,243,624.06
COGS ₹ 2,400,000.00 ₹ 2,424,000.00 ₹ 2,448,240.00 ₹ 2,472,722.40 ₹ 2,497,449.62
Gross Profit ₹ 3,600,000.00 ₹ 3,636,000.00 ₹ 3,672,360.00 ₹ 3,709,083.60 ₹ 3,746,174.44
GP% 60% 60% 60% 60% 60%
Total Op Ex ₹ 3,000,000.00 ₹ 3,110,000.00 ₹ 3,225,100.00 ₹ 3,345,551.00 ₹ 3,471,616.51
Op Income ₹ 600,000.00 ₹ 526,000.00 ₹ 447,260.00 ₹ 363,532.60 ₹ 274,557.93
Op Margin% 10% 9% 7% 6% 4%
TAX ₹ 240,000.00 ₹ 210,400.00 ₹ 178,904.00 ₹ 145,413.04 ₹ 109,823.17
Net Income ₹ 360,000.00 ₹ 315,600.00 ₹ 268,356.00 ₹ 218,119.56 ₹ 164,734.76
Income StatementNI% 0.06 0.05207920792 0.04384472111 0.035284116 0.02638447703
 300 300 300 300 300 300
₹ 21,020.20 ₹ 21,230.40 ₹ 21,442.71 ₹ 21,657.13 ₹ 21,873.71 ₹ 22,092.44
1% 1% 1% 1% 1% 1%
₹ 8,408.08 ₹ 8,492.16 ₹ 8,577.08 ₹ 8,662.85 ₹ 8,749.48 ₹ 8,836.98
1% 1% 1% 1% 1% 1%
₹ 2,552,563.13 ₹ 2,680,191.28 ₹ 2,814,200.85 ₹ 2,954,910.89 ₹ 3,102,656.43 ₹ 3,257,789.25
5% 5% 5% 5% 5% 5%
₹ 1,051,010.05 ₹ 1,061,520.15 ₹ 1,072,135.35 ₹ 1,082,856.71 ₹ 1,093,685.27 ₹ 1,104,622.13
1% 1% 1% 1% 1% 1%

40% 40% 40% 40% 40% 40%

₹ 6,306,060.30 ₹ 6,369,120.90 ₹ 6,432,812.11 ₹ 6,497,140.23 ₹ 6,562,111.64 ₹ 6,627,732.75
₹ 2,522,424.12 ₹ 2,547,648.36 ₹ 2,573,124.85 ₹ 2,598,856.09 ₹ 2,624,844.65 ₹ 2,651,093.10
₹ 3,783,636.18 ₹ 3,821,472.54 ₹ 3,859,687.27 ₹ 3,898,284.14 ₹ 3,937,266.98 ₹ 3,976,639.65
60% 60% 60% 60% 60% 60%
₹ 3,603,573.18 ₹ 3,741,711.43 ₹ 3,886,336.20 ₹ 4,037,767.59 ₹ 4,196,341.70 ₹ 4,362,411.38
₹ 180,063.01 ₹ 79,761.11 ₹ -26,648.93 ₹ -139,483.45 ₹ -259,074.72 ₹ -385,771.73
3% 1% 0% -2% -4% -6%
₹ 72,025.20 ₹ 31,904.44
₹ 108,037.80 ₹ 47,856.67 ₹ -26,648.93 ₹ -139,483.45 ₹ -259,074.72 ₹ -385,771.73
0.01713237711 0.00751385739 -0.00414265633 -0.0214684381 -0.0394803894454 -0.0582056854
 300 300 300 300 300 300
₹ 22,313.37 ₹ 22,536.50 ₹ 22,761.87 ₹ 22,989.48 ### ₹ 23,451.57
1% 1% 1% 1% 1% 1%
₹ 8,925.35 ₹ 9,014.60 ₹ 9,104.75 ₹ 9,195.79 ### ₹ 9,380.63
1% 1% 1% 1% 1% 1%
₹ 3,420,678.72 ₹ 3,591,712.65 ₹ 3,771,298.28 ₹ 3,959,863.20 ### ₹ 4,365,749.18
5% 5% 5% 5% 5% 5%
₹ 1,115,668.35 ₹ 1,126,825.03 ₹ 1,138,093.28 ₹ 1,149,474.21 ### ₹ 1,172,578.64
1% 1% 1% 1% 1% 1%
### ₹900,000,000.00 ###
40% 30% 30%
40% 40% 40% 40% 40% 40%
₹ 6,694,010.08 ₹ 6,760,950.18 ₹ 6,828,559.68 ₹ 6,896,845.28 ### ₹ 7,035,471.87
₹ 2,677,604.03 ₹ 2,704,380.07 ₹ 2,731,423.87 ₹ 2,758,738.11 ### ₹ 2,814,188.75
₹ 4,016,406.05 ₹ 4,056,570.11 ₹ 4,097,135.81 ₹ 4,138,107.17 ### ₹ 4,221,283.12
60% 60% 60% 60% 60% 60%
₹ 4,536,347.06 ₹ 4,718,537.68 ### ### ### ₹ 5,538,327.82
₹ -519,941.01 ₹ -661,967.57 ### ### ### ₹ -1,317,044.70
-8% -10% -17585% -13064% ### -19%

₹ -519,941.01 ₹ -661,967.57 ### ### ### ₹ -1,317,044.70

-0.07767257723 -0.0979104350719544 -175.8514696467 -130.6352678278 -129 -0.18720062056732

Capex=
###
₹ 300.00 300 ₹ 300.00 300 300 300 300
₹ 23,686.09 ₹ 23,922.95 ₹ 24,162.18 ₹ 24,403.80 ### ₹ 24,894.32 ₹ 25,143.26
1% 1% 1% 1% 1% 1% 1%
₹ 9,474.44 ₹ 9,569.18 ₹ 9,664.87 ₹ 9,761.52 ### ₹ 9,957.73 ₹ 10,057.30
1% 1% 1% 1% 1% 1% 1%
₹ 4,584,036.64 ### ₹ 5,053,900.39 ₹ 5,306,595.41 ### ₹ 5,850,521.44 ₹ 6,143,047.51
5% 5% 5% 5% 5% 5% 5%
₹ 1,184,304.43 ### ₹ 1,208,108.95 ₹ 1,220,190.04 ### ₹ 1,244,715.86 ₹ 1,257,163.02
1% 1% 1% 1% 1% 1% 1%

40% 40% 40% 40% 40% 40% 40%

₹ 7,105,826.59 ### ₹ 7,248,653.70 ₹ 7,321,140.24 ### ₹ 7,468,295.16 ₹ 7,542,978.11
₹ 2,842,330.64 ### ₹ 2,899,461.48 ₹ 2,928,456.10 ### ₹ 2,987,318.06 ₹ 3,017,191.24
₹ 4,263,495.95 ### ₹ 4,349,192.22 ₹ 4,392,684.14 ### ₹ 4,480,977.10 ₹ 4,525,786.87
60% 60% 60% 60% 60% 60% 60%
₹ 5,768,341.07 ### ₹ 6,262,009.34 ₹ 6,526,785.45 ### ₹ 7,095,237.30 ₹ 7,400,210.53
₹ -1,504,845.11 ### ### ### ### ### ###
-21% -24% -26% -29% -32% -35% -38%

₹ -1,504,845.11 ### ### ### ### ### ###

₹ -0.21 -0.23732512 ₹ -0.26 -0.29149848747 -0.32 -0.35004778855 -0.38107278348
 300 300 300 300 300 300
₹ 25,394.69 ₹ 25,648.64 ₹ 25,905.13 ₹ 26,164.18 ₹ 26,425.82 ₹ 26,690.08
1% 1% 1% 1% 1% 1%
₹ 10,157.88 ₹ 10,259.46 ₹ 10,362.05 ₹ 10,465.67 ₹ 10,570.33 ₹ 10,676.03
1% 1% 1% 1% 1% 1%
₹ 6,450,199.89 ₹ 6,772,709.88 ₹ 7,111,345.38 ₹ 7,466,912.64 ₹ 7,840,258.28 ₹ 8,232,271.19
5% 5% 5% 5% 5% 5%
₹ 1,269,734.65 ₹ 1,282,432.00 ₹ 1,295,256.31 ₹ 1,308,208.88 ₹ 1,321,290.97 ₹ 1,334,503.88
1% 1% 1% 1% 1% 1%

40% 40% 40% 40% 40% 40%

₹ 7,618,407.89 ₹ 7,694,591.97 ₹ 7,771,537.89 ₹ 7,849,253.27 ₹ 7,927,745.80 ₹ 8,007,023.26
₹ 3,047,363.16 ₹ 3,077,836.79 ₹ 3,108,615.16 ₹ 3,139,701.31 ₹ 3,171,098.32 ₹ 3,202,809.30
₹ 4,571,044.73 ₹ 4,616,755.18 ₹ 4,662,922.73 ₹ 4,709,551.96 ₹ 4,756,647.48 ₹ 4,804,213.96
60% 60% 60% 60% 60% 60%
₹ 7,719,934.54 ₹ 8,055,141.88 ₹ 8,406,601.69 ₹ 8,775,121.52 ₹ 9,161,549.24 ₹ 9,566,775.07
### ### ### ### ### ###
-41% -45% -48% -52% -56% -59%

### ### ### ### ### ###

-0.41332649108 -0.44685757323 -0.48171661903 -0.51795622111 -0.55563105495 -0.59479796141
$2,000,000.00