Multi-Specialty Hospital: Ram Sharada Healthcare Pvt. LTD
Multi-Specialty Hospital: Ram Sharada Healthcare Pvt. LTD
Multi-Specialty Hospital: Ram Sharada Healthcare Pvt. LTD
Regd. Office: Plot No. 97, Sector 25, Pradhikaran, Nigdi, Pune-411044
Multi-Specialty Hospital
Project Report
INDEX
Objectives 3
What is planned… 17
Bed Distribution 18
Time Frame 19
2
ObJECTIVES
Healthcare facilities have a very important role in improving the quality of life of
people. With a greater health awareness and consciousness, there is a rising demand
for better healthcare facilities and services.
Considering this rising demand, the proposed Multi Specialty Hospital has following
objectives:
3
NEED OF MULTI-SPECIALTY HOSPITAL
• Multi specialty hospital is a single point solution for patients that offers
diagnosis and treatment facilities across various clinical specialties.
• Increase in diseases like diabetes, hypertension and cancer etc. demands for
better healthcare services under one roof.
• There are less than 1.3 beds per 1000 people in India as against a
recommendation of 3.2 per 1000 people by the World health Organization.
4
BENEFICIARY
Pimpri Chinchwad
New Township
Sector 9 12.49 1,10,000 8807
Sector 3 19.71 1,45,000 7357
2,55,000
Total population of Pimpri Chinchwad - 10,06,417
5
FACILITIES PLANNED IN THE MULTI-SPECIALTY
HOSPITAL
The proposed Multi Specialty hospital will offer comprehensive diagnosis and
treatment in 2 Phases.
DIAgNOSTIC DEPARTMENTS
RADIOLOGY
1. X RAY
X-rays are especially useful in the detection of pathology of the skeletal system, but
are also useful for detecting some disease processes in soft tissue. Some notable
examples are the very common chest X-ray, which can be used to identify lung
diseases such as pneumonia, lung cancer or pulmonary edema, and the abdominal X-
ray, which can detect intestinal obstruction, free air (from visceral perforations) and
free fluid.
6
2. ULTRA SONOGRAPHY AND COLOR DOPPLER
7
PATHOLOGY LAbORATORY
3. BIOCHEMISTRY ANALYZER
4. HEMATOLOGY ANALYZER
Automated cell counters sample the blood, and quantify, classify, and describe
cell populations using both electrical and optical techniques.
8
OUT PATIENT DEPARTMENTS
In phase 1 following clinical branches will offer consultation for out patients.
6. MEDICINE OPD
7. CARDIOLOGY OPD
9
9. STRESS TEST
1
14. OPHTHALMOLOGY OPD
15. DENTISTRY
1
OPERATION THEATRE
1
INTENSIVE CARE UNIT
1
24. IN PATIENT DEPARTMENT
1
PROJECT REQUIREMENTS
• LAND
Bidding process for this land is already complete. The bid offered by Ram Sharada
Healthcare Ltd. is accepted by PCNTDA.
1
• BUILDING
1
WHAT IS PLANNED…
P LA N FOR PHASE 1
P LA N FOR PHASE 2
1
BED DISTRIBUTION (PHASE
1
TIME
Activity Month Year
1. Land Aquisition October 2010
1
FINANCIAL
PROJECTIONS
2
INDEX
2
PROJECT COST & SOURCES OF FINANCE
Amount
Particulars (Rs.)
Project Cost 30400000.00
Asset Cost
Rs.
Land 11500000.00
Building 6992000.00
Office Equipment 485000.00
Computer 375000.00
Furniture 300000.00
Medical Equipment 9000000.00
Pre Operative Expenses 1748000.00
30400000.00
TOTAL 30400000.00
2
DETAILED PROJECT COST
Total Budget
Proposed Cost Quantity Unit Rate (Rs.)
1 Land 11500000
2 Building 6992000
4 Computers 375000
2
5 Furniture 300000
Radiology 2150000
Operation Theatre 2159000
NICU 1564000
ICU 978000
Ophthalmology OPD 682000
Emergency 360000
Cardiology OPD 280000
PICU 214000
Physiotherapy 210000
Obstetrics & Gynecology 145000
Dental OPD 131000
CSSD 77000
ENT OPD 30000
Pathology 10000
Gynaec OPD 10000
2
DETAILED COST OF MEDICAL EQUIPMENT
2
Ophthalm OPD Chart Projector 1 0.80 0.80
Ophthalm OPD indirect optholmascope 1 0.50 0.50
Ophthalm OPD Motorised vision Drum 1 0.15 0.15
Ophthalm OPD Retinoscope 1 0.12 0.12
Ophthalm OPD Slit Lamp 1 0.80 0.80
Ophthalm OPD Total 8 6.82 6.82
Physiotherapy Cervical Traction 1 0.17 0.17
Physiotherapy CPM Machine 1 0.18 0.18
Physiotherapy Exercise Bicycle 1 0.20 0.20
Physiotherapy Hydrocolater 1 0.18 0.18
Physiotherapy Interferrential Current 1 0.35
Therapy 0.35
Physiotherapy Lumber Traction 1 0.17 0.17
Physiotherapy Paraffin Wax Machine 1 0.09 0.09
Physiotherapy shortwave diathermy 1 0.30 0.30
Physiotherapy Transcutaneous Nerve 1 0.14
Stimulator 0.14
Physiotherapy TREADMILL 1 0.20 0.20
Physiotherapy Ultrasound Therapy 1 0.12 0.12
Physiotherapy Total 11 2.10 2.10
Radiology Colour Doppler 1 12.00 12.00
Radiology C.R. System 1 3.50 3.50
Radiology Film Printer 1 1.50 1.50
Radiology X Ray Machine 1 4.50 4.50
Radiology Total 4 21.50 21.50
NICU Bubble CPAP 1 1.50 1.50
NICU Humidifier 1 0.60 0.60
NICU Incubator 2 0.45 0.90
NICU Infusion Pump 2 0.50 1.00
NICU Multipara Monitor 1 0.80 0.80
NICU Phototherapy 2 0.30 0.60
NICU Pulseoximter 1 0.50 0.50
NICU Radiant Warmer 2 0.40 0.80
NICU Syringe Pump 2 0.37 0.74
NICU Ventilator Neonatal 1 8.00 8.00
NICU Weighing Scale 1 0.20 0.20
NICU Total 16 13.62 15.64
OBGY Fetal Monitor 1 1.25 1.25
OBGY Labour Table 1 0.20 0.20
OBGY Total 2 1.45 1.45
PICU ECG Machine 1 0.60 0.60
PICU Multipara Monitor 1 0.80 0.80
PICU Syringe Pump 2 0.37 0.74
2
PICU Total 4 1.77 2.14
ICU Air Matress 1 0.10 0.10
ICU Defibrillator 1 1.50 1.50
ICU ECG Machine 1 0.60 0.60
ICU Multipara Monitor 2 0.80 1.60
ICU Syringe Pump 4 0.37 1.48
ICU Ventilator 1 4.50 4.50
ICU Total 10 7.87 9.78
O.T. Anaesthesia Monitor 1 1.20 1.20
O.T. Anesthesia Machine 1 1.20 1.20
O.T. Cautery 1 0.50 0.50
O.T. Flash Autoclave 1 0.45 0.45
O.T. Instrument Set 1 0.54 0.54
O.T. O.T. Light 1 1.20 1.20
O.T. O.T. Table 1 0.60 0.60
O.T. Operating Microscope 1 2.50 2.50
Ophthalm
O.T. Phaco Machine 1 6.50 6.50
2
HUMAN RESOURCE REQUIREMENT
2
DETAILED INCOME AND COST OF
Income from Hospital Services 5919188 27855000 29247750 30710138 32245644 33857927 35550823 37328364 39194782
Variable Cost of Sale 3667125 14668500 15401925 16172021 16980622 17829653 18721136 19657193 20640053
2 Ultra Sonography
No. of Patients 191 900 945 992 1042 1094 1149 1206 1266
Avg. Charges / Patient 650 650 650 650 650 650 650 650 650
Total Income 124313 585000 614250 644963 677211 711071 746625 783956 823154
Total Cost of Sale 28125 112500 118125 124031 130233 136744 143582 150761 158299
B Pathology
1 Biochemistry
No. of Samples 510 2400 2520 2646 2778 2917 3063 3216 3377
Avg. Charges / Sample 200 200 200 200 200 200 200 200 200
Total Income 102000 480000 504000 529200 555660 583443 612615 643246 675408
Total Cost of Sale 48000 192000 201600 211680 222264 233377 245046 257298 270163
2 Hematology
No. of Samples 510 2400 2520 2646 2778 2917 3063 3216 3377
Avg. Charges / Sample 150 150 150 150 150 150 150 150 150
Total Income 76500 360000 378000 396900 416745 437582 459461 482434 506556
Total Cost of Sale 66375 208800 219240 230202 241712 253798 266488 279812 293803
2 Stress Test
No. of Patients 191 900 945 992 1042 1094 1149 1206 1266
Avg. Charges / Patient 600 600 600 600 600 600 600 600 600
Total Income 114750 540000 567000 595350 625118 656373 689192 723652 759834
Total Cost of Sale 28125 112500 118125 124031 130233 136744 143582 150761 158299
3 E.C.G.
No. of Patients 893 4200 4410 4631 4862 5105 5360 5628 5910
Avg. Charges / Patient 150 150 150 150 150 150 150 150 150
Total Income 133875 630000 661500 694575 729304 765769 804057 844260 886473
Total Cost of Sale 5250 21000 22050 23153 24310 25526 26802 28142 29549
2 Dentistry
No. of Patients 319 1500 1575 1654 1736 1823 1914 2010 2111
Avg. Charges / Patient 300 300 300 300 300 300 300 300 300
Total Income 95625 450000 472500 496125 520931 546978 574327 603043 633195
Total Cost of Sale 56250 225000 236250 248063 260466 273489 287163 301522 316598
Operation Theatre / Ophthalm, Gynac, General Surgeries / Labour Room / Emergency O.T.
Surgical Procedures
No. of Surgeries 128 600 630 662 695 729 766 804 844
Avg. Charges / Patient 20000 20000 20000 20000 20000 20000 20000 20000 20000
Total Income 2550000 12000000 12600000 13230000 13891500 14586075 15315379 16081148 16885205
Total Cost of Sale 1500000 6000000 6300000 6615000 6945750 7293038 7657689 8040574 8442603
Physiotherapy
No. of Patients 255 1200 1260 1323 1389 1459 1532 1608 1689
Avg. Charges / Patient 100 100 100 100 100 100 100 100 100
Total Income 25500 120000 126000 132300 138915 145861 153154 160811 168852
Total Cost of Sale 0 0 0 0 0 0 0 0 0
Pharmacy Shop
2 Ward
Avg. Sale / Bed 500 500 500 500 500 500 500 500 500
No. of Beds 765 3600 3780 3969 4167 4376 4595 4824 5066
Total Income 382500 1800000 1890000 1984500 2083725 2187911 2297307 2412172 2532781
Total Cost of Sale 360000 1440000 1512000 1587600 1666980 1750329 1837845 1929738 2026225
3 Out Patients
Avg. Sale / Patient 250 250 250 250 250 250 250 250 250
No. of Patients 1530 7200 7560 7938 8335 8752 9189 9649 10131
Total Income 382500 1800000 1890000 1984500 2083725 2187911 2297307 2412172 2532781
Total Cost of Sale 360000 1440000 1512000 1587600 1666980 1750329 1837845 1929738 2026225
3
INCOME AND EXPENDITURE
Schedule A : Sales
Rs in Thousands
Particulars Basis 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Income from Hospital Services - 5,919 27,855 29,248 30,710 32,246 33,858 35,551 37,328 39,195
Total - 5,919 27,855 29,248 30,710 32,246 33,858 35,551 37,328 39,195
1.05 1.05 1.05 1.05 1.05 1.05
SALE (Rs in '000) - 5,919.19 27,855.00 29,247.75 30,710.14 32,245.64 33,857.93 35,550.82 37,328.36 39,194.78
Particulars Basis 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Retail
Administrative Expenses 4.00% 100.00 240.00 960.00 1,008.00 1,058.40 1,111.32 1,166.89 1,225.23 1,286.49 1,350.82
TOTAL 100.00 240.00 960.00 1,008.00 1,058.40 1,111.32 1,166.89 1,225.23 1,286.49 1,350.82
TOTAL 0.02 0.04 0.03 0.03 0.03 0.03 0.03 0.04 0.04 0.04
Particulars Basis 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Hospital Expenses 0.00 3,667.13 14,668.50 15,401.93 16,172.02 16,980.62 17,829.65 18,721.14 19,657.19 20,640.05
Fixed Expenses 0.80 0.00 150.00 600.00 630.00 661.50 694.58 729.30 765.77 804.06 844.26
TOTAL 0.00 3,817.13 15,268.50 16,031.93 16,833.52 17,675.20 18,558.96 19,486.91 20,461.25 21,484.31
Hospital Exp. To Sale 15.700% - 0.64 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55
3
INCOME AND EXPENDITURE
Particulars Basis 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Human Resource Repairs 2% 0.00 969.00 3,876.00 4,069.80 4,273.29 4,486.95 4,711.30 4,946.87 5,194.21 5,453.92
and Maintenance Bad debts 0.00 236.25 945.00 236.25 236.25 236.25 236.25 236.25 945.00 236.25
1%
TOTAL 2% 0.00 1,205.25 4,821.00 4,306.05 4,509.54 4,723.20 4,947.55 5,183.12 6,139.21 5,690.17
% of sales - 0.20 0.17 0.15 0.15 0.15 0.15 0.15 0.16 0.15
Schedule G : Interest
Particulars Basis 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Bank Interest 500.00 1,812.00 2,617.14 2,273.64 1,881.07 1,488.50 1,095.93 703.36 310.79 65.43
Other Interest - - - - - - -
TOTAL 500.00 1,812.00 2,617.14 2,273.64 1,881.07 1,488.50 1,095.93 703.36 310.79 65.43
3
PROFIT AND LOSS
I Sales - 5,919.19 27,855.00 29,247.75 30,710.14 32,245.64 33,857.93 35,550.82 37,328.36 39,194.78
II Other Incomes - - - - - - - - - -
TOTAL INCOME - 5,919.19 27,855.00 29,247.75 30,710.14 32,245.64 33,857.93 35,550.82 37,328.36 39,194.78
IV Direct Expenses :
- - - - - - - - - -
Administrative Expenses 100.00 240.00 960.00 1,008.00 1,058.40 1,111.32 1,166.89 1,225.23 1,286.49 1,350.82
Total 100.00 240.00 960.00 1,008.00 1,058.40 1,111.32 1,166.89 1,225.23 1,286.49 1,350.82
Hospital Expenses 0.00 3,817.13 15,268.50 16,031.93 16,833.52 17,675.20 18,558.96 19,486.91 20,461.25 21,484.31
Human Resouce and Repairs and Main 0.00 1,205.25 4,821.00 4,306.05 4,509.54 4,723.20 4,947.55 5,183.12 6,139.21 5,690.17
Total 0.00 5,022.38 20,089.50 20,337.98 21,343.06 22,398.40 23,506.51 24,670.02 26,600.46 27,174.48
3
PROFIT AND LOSS
PROFIT BEFORE DEP. INT. & TAX (100.00) 656.81 6,805.50 7,901.78 8,308.68 8,735.92 9,184.53 9,655.57 9,441.41 10,669.48
Depreciation - 798.55 2,760.62 2,463.20 2,196.23 1,838.93 1,533.20 1,885.62 2,144.02 2,391.47
Profit Before Int. & Tax (100.00) (141.74) 4,044.88 5,438.58 6,112.44 6,896.99 7,651.33 7,769.95 7,297.40 8,278.01
Interest 500.00 1,812.00 2,617.14 2,273.64 1,881.07 1,488.50 1,095.93 703.36 310.79 65.43
Profit After Int. (600.00) (1,953.74) 1,427.74 3,164.93 4,231.37 5,408.49 6,555.40 7,066.60 6,986.61 8,212.58
Profit Before tax (600.00) (1,953.74) 1,427.74 3,164.93 4,231.37 5,408.49 6,355.40 6,866.60 6,736.61 7,762.58
NET PROFIT (600.00) (1,953.74) 1,427.74 3,164.93 2,835.02 3,623.69 4,258.12 4,600.62 4,513.53 5,200.93
Gross Profit (100.00) 656.81 6,805.50 7,901.78 8,308.68 8,735.92 9,184.53 9,655.57 9,441.41 37,843.97
Gross Profit (%) - 0.11 0.24 0.27 0.27 0.27 0.27 0.27 0.25 0.97
Net Profit (%) - (0.33) 0.05 0.11 0.09 0.11 0.13 0.13 0.12 0.13
Operating Ratio (%) - (0.20) 0.15 0.19 0.16 0.17 0.17 0.18 0.18 0.19
DSCR - 0.00 1.42 1.43 1.34 1.46 1.58 1.81 1.95 33.29
3
BALANCE
Particulars Schedule 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Sources of Funds
Capital -
Share Capital 2,500.00 7,500.00 5,546.26 6,974.00 10,138.94 12,973.93 16,597.62 21,055.74 25,856.36 30,619.89
- - - - - - - - - -
Profit (600.00) (1,953.74) 1,427.74 3,164.93 2,835.00 3,623.69 4,258.12 4,600.62 4,513.53 5,200.93
Addition to Capital
Less: Drawings
Net Capital 1,900.00 5,546.26 6,974.00 10,138.94 12,973.93 16,597.62 21,055.74 25,856.36 30,619.89 36,270.82
Loan Funds
Secured Loans
Term Loan I 12,500.00 22,900.00 20,719.05 17,447.62 14,176.19 10,904.76 7,633.33 4,361.90 1,090.48 -
Other Loan II - - - - - - - - - -
Cash Credit - - - -
Unsecured Loans III - 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 -
Total 14,400.00 29,446.26 28,693.05 28,586.56 28,150.13 28,502.38 29,689.07 31,218.27 32,710.37 36,270.82
3
BALANCE
Application of Funds
Fixed Assets V 13,248.00 29,601.45 27,840.83 27,077.64 26,381.40 26,442.47 26,674.26 28,853.65 30,274.63 33,448.16
Revaluation of Assets
Investments / ICD's I - - - - - - - - - -
Current Assets V 1,152.00 757.61 3,003.41 3,680.54 4,022.95 4,400.88 5,446.85 4,892.29 5,122.07 5,556.18
Less: Current Liabilities &
0.00 912.80 2,151.19 2,171.61 2,254.22 2,340.96 2,432.04 2,527.67 2,686.34 2,733.52
Provisions VI
1,152.00 (155.19) 852.22 1,508.92 1,768.72 2,059.92 3,014.81 2,364.62 2,435.73 2,822.66
Net Current Assets VI
- - - - - - - - - -
Pre-operative & Preliminary I - - - - - - - - - -
Misc.Expenses( to the extent - - - - - - - - - -
not written off or adjusted ) - - - - - - - - - -
Deferred Revenue expenses ` - - - - - - -
14,400.00 29,446.26 28,693.05 28,586.56 28,150.13 28,502.38 29,689.07 31,218.27 32,710.37 36,270.82
Total
- - - - - - - - - -
Diff
Ratios Analysis
1,152.00 757.61 3,003.41 3,680.54 4,022.95 4,400.88 5,446.85 4,892.29 5,122.07 5,556.18
Current Assets 1,152.00 657.61 2,697.82 2,458.16 2,739.46 3,053.21 4,031.80 3,406.49 3,561.98 3,918.08
Quick Assets 0.00 912.80 2,151.19 2,171.61 2,276.03 2,373.68 2,464.76 2,560.39 2,719.05 2,766.23
Current Liabilities 0.00 812.80 1,845.60 949.24 992.54 1,026.01 1,049.70 1,074.58 1,158.96 1,128.13
Quick current liabilities 12,500.00 23,900.00 21,719.05 18,447.62 15,176.19 11,904.76 8,633.33 5,361.90 2,090.48 -
Debt 1,900.00 5,546.26 6,974.00 10,138.94 12,973.93 16,597.62 21,055.74 25,856.36 30,619.89 36,270.82
Particulars 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Term Loan 12,500.00 22,900.00 20,719.05 17,447.62 14,176.19 10,904.76 7,633.33 4,361.90 1,090.48 -
TOTAL 12,500.00 22,900.00 20,719.05 17,447.62 14,176.19 10,904.76 7,633.33 4,361.90 1,090.48 -
Particulars 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Particulars 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
TOTAL - - - - - - - - - -
Schedule IV : Investment
Particulars 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
- - - - - - - - - -
TOTAL - - - - - - - - - -
3
SCHEDUL
Particulars 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Inventory - 100.00 305.59 1,222.38 1,283.49 1,347.67 1,415.05 1,485.80 1,560.09 1,638.10
Debtors - 493.27 1,508.81 1,584.25 1,919.38 2,015.35 2,116.12 2,221.93 2,333.02 2,449.67
Advances Income Tax /TDS - 4.37 4.37 19.39 59.39 49.39 58.00 58.00 58.00 58.00
Deposit - - - 25.00 50.00 75.00 100.00 100.00 100.00 100.00
Other Advances - - - 25.00 32.50 50.00 75.00 75.00 75.00 75.00
Cash & bank balance 1,152.00 159.97 1,184.63 804.52 678.18 863.47 1,682.68 951.56 995.95 1,235.40
TOTAL 1,152.00 757.61 3,003.41 3,680.54 4,022.95 4,400.88 5,446.85 4,892.29 5,122.07 5,556.18
Particulars 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Sundry Creditors -Material - 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00
Sundry Creditors -Expenses 0.00 412.80 1,651.19 1,671.61 1,754.22 1,840.96 1,932.04 2,027.67 2,186.34 2,233.52
Provision For Tax - - - - - - - -
Staturory Outstanding Liabili - - - - - - - - - -
Outstanding Liabilities - - - - - -
TOTAL 0.00 912.80 2,151.19 2,171.61 2,254.22 2,340.96 2,432.04 2,527.67 2,686.34 2,733.52
Sub Schedule
3
SCHEDULE FOR INCOME TAx
Particulars Basis 2010-11 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Book Profit (600.00) (1,953.74) 1,427.74 3,164.93 4,231.37 5,408.49 6,355.40 6,866.60 6,736.61 7,762.58
ADD:
Amt. I.Tax paid or 0 0 0 0 0 0 0 0 0 0
payable/Prov
Amt. Carried to reserve - - - - - - - - - -
Amt. Set for contingent - - - - - - - - - -
liabities
Loss of Sub. Co. - - - - - - - - - -
Income U/S 10,10A,10B, - - - - - - - - - -
11 & 12
(600.00) (1,953.74) 1,427.74 3,164.93 4,231.37 5,408.49 6,355.40 6,866.60 6,736.61 7,762.58
Withdrawal from Res.
Exps relatin to sec.10,10A - - - - - - - - - -
10B,11,12
B/F Unabsorbed Dep or - - - - - - - - - -
loss (Which ever is less)
Deduction U/S 0.8
80HHC - - - - - - - - - -
80HHE - - - - - - - - - -
80HHF - - - - - - - - - -
Profit from Sick Ind. - - - - - - - - - -
Book Profit (600.00) (1,953.74) 1,427.74 3,164.93 4,231.37 5,408.49 6,355.40 6,866.60 6,736.61 7,762.58
Income Tax
Profit before tax (600.00) (1,953.74) 1,427.74 3,164.93 4,231.37 5,408.49 6,355.40 6,866.60 6,736.61 7,762.58
Add:
Dep. (Co. Act) - 798.55 2,760.62 2,463.20 2,196.23 1,838.93 1,533.20 1,885.62 2,144.02 2,391.47
(600.00) (1,155.19) 4,188.36 5,628.13 6,427.60 7,247.42 7,888.60 8,752.21 8,880.63 10,154.05
Less:
Dep. (I.T. Act) - 798.55 2,760.62 2,463.20 2,196.23 1,838.93 1,533.20 1,885.62 2,144.02 2,391.47
(600.00) (1,953.74) 1,427.74 3,164.93 4,231.37 5,408.49 6,355.40 6,866.60 6,736.61 7,762.58
Loss C/F - - - - - - - - -
Loss Set/off - - (2,553.74) - - - - - - -
Taxable Income (600.00) (1,953.74) 3,981.48 3,164.93 4,231.37 5,408.49 6,355.40 6,866.60 6,736.61 7,762.58
MAT 7.65% - - - - - - -
Tax Paid 0.54 0.54 0.69 3.00 5.00 6.00 6.00 6.00 6.00 6.00
4
PROJECTED BREAK EVEN POINT
Projected Sales 5,919.19 27,855.00 29,247.75 30,710.14 32,245.64 33,857.93 35,550.82 37,328.36 39,194.78
Other Income - - - - - - - - -
Total 5,919.19 27,855.00 29,247.75 30,710.14 32,245.64 33,857.93 35,550.82 37,328.36 39,194.78
Contribution 2,441.66 13,944.90 15,398.15 16,179.86 17,000.67 17,862.52 18,767.45 19,008.89 20,715.33
Profit Volume Ratio 0.41 0.50 0.53 0.53 0.53 0.53 0.53 0.51 0.53
Total Fixed Costs 3,596.85 9,756.54 9,770.01 11,148.61 11,538.05 11,871.20 12,081.22 12,101.35 12,672.93
Break-Even Point 8,719.64 19,488.74 18,557.49 21,160.59 21,884.54 22,501.54 22,885.22 23,763.80 23,978.03
% Break Even Point 147.31% 69.96% 63.45% 0.69 0.68 0.66 0.64 0.64 0.61
Margin of Safety (Sale) -2800 8366 10690 9,549.55 10,361.11 11,356.39 12,665.61 13,564.57 15,216.75
Margin of Safety (%) -47% 30% 37% 0.31 0.32 0.34 0.36 0.36 0.39
4
SENSITIVITY
Sensitivity Analysis
Direct Costs Increase by 5% 1.05
('000 omitted)
Particulars 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Projected Sales 5919 27855 29248 30710 32246 33858 35551 37328 39195
Increase/ Decrease in stock
Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total 5919 27855 29248 30710 32246 33858 35551 37328 39195
Contribution 2268 13249 14706 15453 16238 17063 17928 18093 19791
Profit Volume Ratio 38.31% 47.57% 50.28% 50.32% 50.36% 50.40% 50.43% 48.47% 50.49%
Total Fixed Costs 3597 9757 9770 11149 11538 11871 12081 12101 12673
Break-Even Point 9388 20512 19431 22155 22912 23556 23956 24967 25097
% Break Even Point 159% 74% 66% 72% 71% 70% 67% 67% 64%
Margin of Safety (Sale) -3469 7343 9816 8555 9334 10302 11594 12361 14097
Margin of Safety (%) -59% 26% 34% 28% 29% 30% 33% 33% 36%
4
SENSITIVITY
Projected Sales 5919 27855 29248 30710 32246 33858 35551 37328 39195
Increase/ Decrease in stock
Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total 5919 27855 29248 30710 32246 33858 35551 37328 39195
Contribution 2094 12554 14013 14727 15476 16263 17089 17177 18867
Profit Volume Ratio 35.37% 45.07% 47.91% 47.95% 47.99% 48.03% 48.07% 46.02% 48.14%
Total Fixed Costs 3597 9757 9770 11149 11538 11871 12081 12101 12673
Break-Even Point 10168 21648 20392 23248 24040 24715 25133 26298 26327
% Break Even Point 172% 78% 70% 76% 75% 73% 71% 70% 67%
Margin of Safety (Sale) -4249 6207 8856 7462 8205 9143 10418 11030 12868
Margin of Safety (%) -72% 22% 30% 24% 25% 27% 29% 30% 33%
4
SENSITIVITY
Sensitivity Analysis
Projected Sales 5623 26462 27785 29175 30633 32165 33773 35462 37235
Increase/ Decrease in stock
Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total 5623 26462 27785 29175 30633 32165 33773 35462 37235
Contribution 2146 12552 13936 14644 15388 16170 16990 17142 18756
Profit Volume Ratio 38.16% 47.43% 50.16% 50.20% 50.23% 50.27% 50.31% 48.34% 50.37%
0.80
Less : Fixed Costs
1) Fixed Expenses 150 600 630 662 695 729 766 804 844
Administrative Expenses 168 672 706 741 778 817 858 901 946
Hospital Expenses 1467 5867 6161 6469 6792 7132 7488 7863 8256
2) Interest on term Loan 1812 2617 2274 1881 1489 1096 703 311 65
3) Income Tax 0 0 0 1396 1785 2097 2266 2223 2562
Total Fixed Costs 3597 9757 9770 11149 11538 11871 12081 12101 12673
Break-Even Point 9426 20569 19480 22210 22969 23614 24016 25034 25159
% Break Even Point 167.63% 77.73% 70.11% 76.13% 74.98% 73.42% 71.11% 70.59% 67.57%
Margin of Safety (Sale) -3803 5894 8306 6964 7665 8551 9758 10428 12076
Margin of Safety (%) -68% 22% 30% 24% 25% 27% 29% 29% 32%
4
SENSITIVITY
Sensitivity Analysis
Projected Sales 5327 25070 26323 27639 29021 30472 31996 33596 35275
Increase/ Decrease in stock
Other Income 0 0 0 0 0 0 0 0 0
Total 5327 25070 26323 27639 29021 30472 31996 33596 35275
Contribution 1850 11159 12473 13109 13776 14477 15212 15276 16796
Profit Volume Ratio 34.72% 44.51% 47.39% 47.43% 47.47% 47.51% 47.54% 45.47% 47.61%
Total Fixed Costs 3597 9757 9770 11149 11538 11871 12081 12101 12673
Break-Even Point 10359 21918 20618 23506 24306 24988 25410 26614 26616
% Break Even Point 194% 87% 78% 85% 84% 82% 79% 79% 75%
Margin of Safety (Sale) -5031.67 3151.51 5704.99 4133.03 4714.74 5484.39 6585.66 6981.91 8659.12
Margin of Safety (%) -94% 13% 22% 15% 16% 18% 21% 21% 25%
4
SCHEDULE: REPAYMENT OF TERM LOAN
Principal outstanding at
the beginning of the
month 272,619
April 2,500,000 20,446,429 17,175,000 13,903,571 10,632,143 7,360,714 4,089,286 817,857
May 20,173,810 16,902,381 13,630,952 10,359,524 7,088,095 3,816,667 545,238
June 19,901,190 16,629,762 13,358,333 10,086,905 6,815,476 3,544,048 272,619
July 2,500,000 22,900,000 19,628,571 16,357,143 13,085,714 9,814,286 6,542,857 3,271,429
August 22,627,381 19,355,952 16,084,524 12,813,095 9,541,667 6,270,238 2,998,810
September 8625000 2,500,000 22,354,762 19,083,333 15,811,905 12,540,476 9,269,048 5,997,619 2,726,190
October 2,900,000 22,082,143 18,810,714 15,539,286 12,267,857 8,996,429 5,725,000 2,453,571
November 21,809,524 18,538,095 15,266,667 11,995,238 8,723,810 5,452,381 2,180,952
December 21,536,905 18,265,476 14,994,048 11,722,619 8,451,190 5,179,762 1,908,333
January 2500000 21,264,286 17,992,857 14,721,429 11,450,000 8,178,571 4,907,143 1,635,714
February 20,991,667 17,720,238 14,448,810 11,177,381 7,905,952 4,634,524 1,363,095
March 1375000 20,719,048 17,447,619 14,176,190 10,904,762 7,633,333 4,361,905 1,090,476
Principal repaid 2,180,952 3,271,429 3,271,429 3,271,429 3,271,429 3,271,429 3,271,429 1,090,476
INTEREST 0
Average Product 4,166,667 6,766,667 21,809,524 18,947,024 15,675,595 12,404,167 9,132,738 5,861,310 2,589,881 545,238
Interest @ 12.0%
12.00% 500,000 1,812,000 2,617,143 2,273,643 1,881,071 1,488,500 1,095,929 703,357 310,786 65,429
.
TOTAL REPAYMENT 4,798,095 5,545,071 5,152,500 4,759,929 4,367,357 3,974,786 3,582,214 1,155,905
4,166,982
Note: Monthly repayment of loan is assumed Loan
repayable in 84 monthly instalments
4
DEPRECIATION SCHEDULE- AS PER INCOME TAx ACT
Particulars Rate 2011-12 2012-2013 2013-2014 2014-15 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
Building 10.00%
Opening Balance 6,817.20 6,646.77 6,480.60 6,318.59 7,623.12 8,895.04 10,135.17 10,856.79
Additions 6,992.00 - - 1,500.00 1,500.00 1,500.00 1,000.00 3,000.00
Deletions - - - - - - - - -
Depreciation 174.80 170.43 166.17 162.02 195.46 228.08 259.88 278.38 346.42
WDV 6,817.20 6,646.77 6,480.60 6,318.59 7,623.12 8,895.04 10,135.17 10,856.79 13,510.37
Furniture 10.00%
Opening Balance - 292.50 263.25 686.93 1,068.23 961.41 923.77 889.89 859.40
Additions 0.00% 300.00 - 500.00 500.00 65.00 65.00 65.00 65.00
Deletions -
Depreciation 7.50 29.25 76.33 118.69 106.82 102.64 98.88 95.49 92.44
WDV 292.50 263.25 686.93 1,068.23 961.41 923.77 889.89 859.40 831.96
Summary
Opening Balance - 16,353.45 14,592.83 13,829.64 13,133.40 13,194.47 13,426.26 15,605.65 17,026.63
Additions 17,152.00 1,000.00 1,700.00 1,500.00 1,900.00 1,765.00 4,065.00 3,565.00 5,565.00
Deletions - - - - - - - - -
Depreciation 798.55 2,760.62 2,463.20 2,196.23 1,838.93 1,533.20 1,885.62 2,144.02 2,391.47
WDV 16,353.45 14,592.83 13,829.64 13,133.40 13,194.47 13,426.26 15,605.65 17,026.63 20,200.16
4
RAM SHARDA HEALTHCARE
MIDC , Bhosari.
ASSUMPTION :
48