CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
SCHEDULE - 1 FACILITIES PROPOSED TO BE SET UP
SL.NO.. PARTICULARS 1 2 500 mA X-Ray system for all types of investigation Color Doppler system for investigation of Heart, Abdomen (upper & lower), Pelvis, Peripheral Vascular regions. 3 channel ECG machine with couch and Doctors table, chair and PC. Same room to be used for Holter Analysis TMT and PFT also to be in the same room Digital EEG machine with couch and PC with provision for UPS. Same room to be used for Lung Function Test Analysis Bone Mineral Density Meter for measuring Osterophoresis with UPS to use the same room Pathology Lab for investigation of all types of tests of blood , urine, sputum, complete with auto analyzer, cell counter, centrifuge, incubator, microscope etc. Lab. Room Size Blood Collection 2 Nos. Toilets 10 nos. Doctors chambers complete with Table, couch, X-Ray visor etc Reception area, patient waiting area, cash counter, report issue counter, common passages, accounts office etc. Physio Therapy room Store and Misc. Common Toilets TOTAL AREA REQUIRED FOR CENTER AREA (SQFT) 300.00
160.00
3
160.00
4
160.00
5
500.00
6
1150.00
7
1600.00 160.00 160.00 150.00 4500.00
8 9 10
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
SCHEDULE - 2 EQUIPMENT COSTS AND INVESTMENT REQUIRED
Sl.No.. PARTICULARS 1 Cost of 500 mA X-Ray Machine with 5 position table and accessories Color Doppler system for investigation of Heart, Abdomen (upper & lower), Pelvis, Peripheral Vascular regions. Machine supplied with 3 transducers and MOD, CD writer, image archive facility and printer. 3 Channel ECG Machine with measurement and self interpretation 1.64 4 Solid State Flash Card Holter Recorders 2 nos. for recording 24 hours continuos ECG of the patient TMT Machine for stress Testing of the Heart Digital EEG Machine with Plotter of EEG waveforms and reporting 4.37 7 8 BMD Testing machine / Full Mouth Dental Xray - OPG Pathology Lab with all instruments for testing of Biochemistry investigations, Total counts and differential counts of blood, Elisa testing, Flame Photometer for Sodium, Potassium levels in blood etc. Diagnostic Center Software along with computers, ups and printers for the above equipment Electrical Installation along with Security Deposit to CESC along with control panel for all Equipment Air Conditioning Plant / Separate AC for complete air-conditioning of the whole place Furniture and Fixtures including building modification cost with interiors and exteriors 7.64 Amount
8.66
2
33.85
3
15.29 8.74
5 6
15.00
9
17.00
10
8.00
11
15.00
12
14.81
TOTAL INVESTMENT REQUIRED
150.00
MEANS OF FINANCING
PROMOTERS EQUITY AND LOANS TERM LOAN FROM BANK 37.50 112.50 150.00
Note: All the Equipment will be purchased from Reputed suppliers like General Electric(GE) or Siemens or Shiller through their authorized dealers. The choice of the Supplier will depend upon evaluation of the equipment's by a panel of eminent doctors.
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
SCHEDULE - 3
Sl.No. PARTICULARS A) REVENUE No. of Working days 500 mA X-Ray Machine
STATEMENT OF OPERATIONS
APPX.RT YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5 YEAR-6 YEAR-7
300.00 200.00 15 9.00 22 13.20 23 13.80 23 13.80 25 15.00 25 15.00 25 15.00
1
2
Color Doppler System a) Cardiac cases
1100.00
10 33.00 10 13.50 2 6.60
12 39.60 15 20.25 2 6.60 5
14 46.20 17 22.95 2 6.60 7
14 46.20 17 22.95 3 9.90 7
16 52.80 19 25.65 3 9.90 9
16 52.80 19 25.65 4 13.20 11 4.13 2
18 59.40 21 28.35 5 16.50 13 4.88 2
b) USG Cases (upper/lower/pelvic)
450.00
c) Peripheral Vascular Studies
1100.00
3
3- Channel ECG machine
125.00
5 1.88
1.88 2 2 7.20 4 4 8.40 3 3 5.40 2 2 1.20
2.63 2 7.20 4 8.40 3 5.40 2 1.20
2.63 2 7.20 4 8.40 3 5.40 2 1.20
3.38
4
Holter Recorder / Analyzer
1200.00
2 7.20
7.20 4 8.40 3 5.40 2 1.20
7.20 4 8.40 3 5.40 2 1.20
7.20
5
TMT Machine
700.00
4 8.40
8.40
8
Digital EEG Machine
600.00
3 5.40
5.40
9
Lung Function Test Machine
200.00
2 1.20
1.20
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
SCHEDULE - 3
Sl.No. PARTICULARS 10 Bone Mineral Density Machine / OPG
STATEMENT OF OPERATIONS
APPX.RT 400.00 YEAR-1 5 6.00 YEAR-2 5 6.00 75 22.50 40 14.40 146.63 YEAR-3 7 8.40 80 24.00 50 18.00 164.78 YEAR-4 7 8.40 90 27.00 50 18.00 171.08 YEAR-5 9 10.80 90 27.00 60 21.60 188.33 YEAR-6 9 10.80 100 30.00 60 21.60 195.38 YEAR-7 11 13.20 100 30.00 60 21.60 211.13
11
Pathology Tests
100.00
70 21.00 40 14.40 127.58
12
Doctors Chambers
60.00 3000.00 A
TOTAL REVENUE B) 1 2 3 4 5 OPERATIVE EXPENSES Salary & Referrer's fees Power Consumption Consumables Administrative Repairs & maintenance
ANX-1 ANX-2 ANX-3 ANX-4 ANX-5
55.72 5.62 5.81 18.00 0.75
61.92 6.18 8.06 18.54 5.50
68.46 6.80 8.71 19.13 5.98
74.29 7.47 9.12 21.05 6.50
81.73 8.22 9.74 21.77 7.07
88.73 9.04 10.17 22.56 7.70
97.22 9.95 10.61 24.81 8.40
TOTAL OPERATIVE EXPENSES
B
85.89
100.19
109.07
118.43
128.53
138.20
150.99
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
SCHEDULE - 3
Sl.No. PARTICULARS GROSS PROFIT (A-B) Interest payment Depreciation Profit Before Tax Provision for Tax Profit after Tax
STATEMENT OF OPERATIONS
APPX.RT YEAR-1 41.68 ANX-6 ANX-7 18.56 21.48 1.64 35.00% 0.57 1.06 YEAR-2 46.43 16.71 18.38 11.34 3.97 7.37 YEAR-3 55.70 14.23 15.73 25.74 9.01 16.73 YEAR-4 52.65 11.76 13.47 27.42 9.60 17.82 YEAR-5 59.79 9.08 11.54 39.18 13.71 25.47 YEAR-6 57.18 5.78 9.88 41.52 14.53 26.99 YEAR-7 60.14 2.48 8.46 49.20 17.22 31.98
DEBT EQUITY RATIO DEBT SERVICE COVERAGE RATIO RETURN ON INVESTMENT (ORIGINAL AMOUNT) RETURN ON CAPITAL EMPLOYED AT YEAREND
2.80 1.58 0.71% 0.74%
2.61 1.81 4.92% 5.55%
2.63 2.38 11.15% 13.00%
2.67 2.89 11.88% 14.20%
2.42 3.12 16.98% 20.38%
1.90 3.81 17.99% 21.43%
0.00 4.87 21.32% 23.27%
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
SCHEDULE - 4
Sl.No. PARTICULARS A LIABILITIES Share Capital Prompters contribution as long term loan Reserves & Surplus Term Loan from Bank
BALANCE SHEET
Pre-Oper. YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5 YEAR-6 YEAR-7
10.00 27.50 112.50
10.00 27.50 1.06 105.00
10.00 24.50 8.44 90.00
10.00 18.50 25.17 75.00
10.00 12.50 42.99 60.00
10.00 6.50 68.46 40.00
10.00 0.50 95.45 20.00
10.00 0.00 127.43 0.00
150.00 B ASSETS Fixed Assets Gross Block Less : Cumulative Depreciation Net Block Cash & Bank Balances
143.56
132.94
128.67
125.49
124.96
125.95
137.43
150.00 0.00 150.00
150.00 21.48 128.51 15.05 143.56
150.00 39.87 110.13 22.81 132.93
150.00 55.60 94.39 34.27 128.66
150.00 69.07 80.92 44.56 125.48
150.00 80.61 69.39 55.57 124.95
150.00 90.49 59.51 66.44 125.94
150.00 98.95 51.04 86.38 137.42
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
SCHEDULE - 5
Sl.No. PARTICULARS 1 2 3 4 5 6 7 Profit after Tax Add: Opening Balance Add: Depreciation (non-cash expenses) Available Cash Term Loan principal Repayment Repayment of Promoters Loan Closing/Cumulative Cash Flow
CASH FLOW STATEMENT
YEAR-1 1.06 0.00 21.48 22.55 ANX-6 7.50 0.00 15.05 YEAR-2 7.37 15.05 18.38 40.81 15.00 3.00 22.81 YEAR-3 16.73 22.81 15.73 55.27 15.00 6.00 34.27 YEAR-4 17.82 34.27 13.47 65.56 15.00 6.00 44.56 YEAR-5 25.47 44.56 11.54 81.57 20.00 6.00 55.57 YEAR-6 26.99 55.57 9.88 92.44 20.00 6.00 66.44 YEAR-7 31.98 66.44 8.46 106.88 20.00 0.50 86.38
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
Annexure -1
Sl. No. Staff per Equipment 1 X-Ray Machine & BMD Technicians 2 Color Doppler Machine Technicians Senior Radiologist for X-ray and USG Junior Radiologist for X-ray and USG Cardio Sonologist for Echo ECG, TMT, Holter & PFT Technicians Visiting Sr. Cardiologists Junior Cardiologist Digital EEG Machine Technicians Visiting Neurologist Pathology Lab Technicians Visiting Sr. Pathologist Junior Pathologist Hematologist Administration Receptionists Accounts Staff Office manager Marketing Executives Office Assistants Peons TOTAL SALARY COST PER YEAR
Salary & Wages
Staff 2 Monthly 3500.00 Yearly 0.84
1 1 1 1
3000.00 35000.00 20000.00 35000.00
0.36 4.20 2.40 4.20
3
2 1 1
3000.00 35000.00 25000.00
0.72 4.20 3.00
4
1 1
3000.00 25000.00
0.36 3.00
5
6 1 1 1
3000.00 35000.00 20000.00 20000.00
2.16 4.20 2.40 2.40
6
6 2 1 4 2 4 40
3000.00 4500.00 10000.00 5000.00 3000.00 2000.00
2.16 1.08 1.20 2.40 0.72 0.96 42.96
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
Annexure -1 …. Continued
Sl. No. CATEGORY 1 2 STAFF SALARY REFERRAL FEES TOTAL
Salary & Wages
NO. 40 10% YEAR-1 42.96 12.76 55.72 YEAR-2 47.26 14.66 61.92 YEAR-3 51.98 16.48 68.46 YEAR-4 57.18 17.11 74.29 YEAR-5 62.90 18.83 81.73 YEAR-6 69.19 19.54 88.73 YEAR-7 76.11 21.11 97.22
Assuming 10% increase in Salary cost per year
Annexure - 2
Sl. No. CATEGORY 1 Power consumption of All Equipment, Acs Lighting, Operation 12 hours a day for 300 days Equipment AC Room Lighting Bulk electricity rate with 10% hike every year TOTAL ELECTRICITY EXPENSES
Power Consumption
YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5 YEAR-6 YEAR-7
5.62 kWh 10 10 6 6.00 5.62
6.18
6.80
7.47
8.22
9.04
9.95
6.18
6.80
7.47
8.22
9.04
9.95
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
Annexure - 3
Sl. No. CATEGORY 1 2 3 4 5 X-Ray Films Photopaper / CD / VHS Tapes Graph paper ECG Paper Chemicals Assumption 10% hike every year TOTAL COST OF CONSUMABLES
Consumables
Rate 40.00 25.00 2.00 10.00 10.00 YEAR-1 1.80 1.65 0.11 0.15 2.10 YEAR-2 2.90 2.39 0.12 0.17 2.48 YEAR-3 3.04 2.72 0.15 0.17 2.64 YEAR-4 3.04 2.81 0.15 0.17 2.97 YEAR-5 3.30 3.14 0.17 0.17 2.97 YEAR-6 3.30 3.22 0.18 0.17 3.30 YEAR-7 3.30 3.63 0.21 0.17 3.30
5.81
8.06
8.71
9.12
9.74
10.17
10.61
Annexure - 4
Sl. No. CATEGORY 1 2 3 4 5 6 Printing & Stationery Advertisement & Publicity Rent Staff Welfare Telephone Conveyance & travelling Assumption 10% hike every year and 10% hike in rent every 3 years TOTAL ADMINISTRATIVE COST
Administrative Expenses
p.m. 0.05 0.15 1.05 0.05 0.10 0.10 YEAR-1 0.60 1.80 12.60 0.60 1.20 1.20 YEAR-2 0.66 1.98 12.60 0.66 1.32 1.32 YEAR-3 0.73 2.18 12.60 0.73 1.45 1.45 YEAR-4 0.80 2.40 13.86 0.80 1.60 1.60 YEAR-5 0.88 2.64 13.86 0.88 1.76 1.76 YEAR-6 0.97 2.90 13.86 0.97 1.93 1.93 YEAR-7 1.06 3.19 15.25 1.06 2.13 2.13
18.00
18.54
19.13
21.05
21.77
22.56
24.81
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
Annexure - 5
Sl. No. CATEGORY 1 2 3 4 Service Contract Spares AC Systems Insurance
Repairs & Maintenance
Rate YEAR-1 0.00 0.00 0.00 0.75 YEAR-2 2.50 1.25 1.00 0.75 YEAR-3 2.75 1.38 1.10 0.75 YEAR-4 3.03 1.51 1.21 0.75 YEAR-5 3.33 1.66 1.33 0.75 YEAR-6 3.66 1.83 1.46 0.75 YEAR-7 4.03 2.01 1.61 0.75
0.75%
Assumption 10% escalation from 3rd year onwards
TOTAL OF REPAIRS, MAINTENANCE,INSURANCE
0.75
5.50
5.98
6.50
7.07
7.70
8.40
Annexure - 6
Sl. No. CATEGORY 1 a)Outstanding Principal amount 1st 6 month b)Interest c)Principal Repayment a)Outstanding Principal amount 2nd 6 month b)Interest c)Principal Repayment TOTAL INTEREST PAYMENT PER YEAR TOTAL PRINCIPAL REPAYMENT PER YEAR
Interest on Term Loan / Repayment of Term Loan
Rate YEAR-1 112.50 9.28 0.00 112.50 9.28 7.50 18.56 7.50 YEAR-2 105.00 8.66 7.50 97.50 8.04 7.50 16.71 15.00 YEAR-3 90.00 7.43 7.50 82.50 6.81 7.50 14.23 15.00 YEAR-4 75.00 6.19 7.50 67.50 5.57 7.50 11.76 15.00 YEAR-5 60.00 4.95 10.00 50.00 4.13 10.00 9.08 20.00 YEAR-6 40.00 3.30 10.00 30.00 2.48 10.00 5.78 20.00 YEAR-7 20.00 1.65 10.00 10.00 0.83 10.00 2.48 20.00
16.50%
2
16.50%
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
Annexure - 7
Sl. No. CATEGORY 1 Equipment cost 112.19 2 Furniture & fixture 14.81 3 AC and Electrical Installation 23.00 TOTAL DEPRECIATION CHARGEABLE CUMULATIVE DEPRECIATION
Depreciation Schedule
Rate 13.91% CUM. 18.10% CUM. 13.91% CUM. YEAR-1 15.61 15.61 2.68 2.68 3.20 3.20 21.48 21.48 YEAR-2 13.43 29.04 2.20 4.88 2.75 5.95 18.38 39.87 YEAR-3 11.57 40.61 1.80 6.67 2.37 8.32 15.73 55.60 YEAR-4 9.96 50.56 1.47 8.15 2.04 10.37 13.47 69.07 YEAR-5 8.57 59.13 1.21 9.35 1.76 12.12 11.54 80.61 YEAR-6 7.38 66.51 0.99 10.34 1.51 13.64 9.88 90.49 YEAR-7 6.35 72.87 0.81 11.15 1.30 14.94 8.46 98.95
CARE & CURE POLYCLINIC PRIVATE LIMITED
Distribution of Revenue on Expenses
250.00
200.00
150.00
Rs.(Lakhs)
Net Profit Tax Interest
100.00
Deprecaition
Repairs & maintenance
50.00
Administrative Consumables
0.00
1
2
3
Years 4
Power Consumption
5
6
7
Salary & Referrer's fees
CARE & CURE POLYCLINIC PRIVATE LIMITED
Cumulative Cash Flow
90.00
80.00
70.00
60.00
Rs.(Lakhs)
50.00
40.00
30.00
Cumulative Cash Flow
20.00
10.00
0.00 1 2 3 4 Year 5 6 7
CARE & CURE POLYCLINIC PRIVATE LIMITED
Impact of Income Tax
50.00
45.00
40.00
35.00 30.00
Rs.(Lakhs)
25.00
Profit Before Tax
20.00 15.00
Provision for Income Tax
10.00
5.00
Profit after tax
0.00 1 2 3 4 Year 5 6 7
CARE & CURE POLYCLINIC PRIVATE LIMITED
Operating Expenses Vs. Gross Profit
160.00
140.00
120.00
100.00
Rs.(Lakhs)
80.00
Operating Expenses
60.00
Gross Profit
40.00
20.00
0.00 1 2 3 4 Year 5 6 7
CARE & CURE POLYCLINIC PRIVATE LIMITED
Investment Vs. Revenue Vs. Gross profit
60.00
50.00
40.00
30.00
Investment
Revenue
20.00
Gross Profit
10.00
0.00
CARE & CURE POLYCLINIC PRIVATE LIMITED
Investment Breakup
Chambers 7% Patahlogy 11% Digital EEG 5% X-Ray, BMD 18%
ECG,TMT,Holter,PFT 28%
Color Doppler 31%
CARE & CURE POLYCLINIC PRIVATE LIMITED
Revenue Breakup 1st year
Chambers 11%
X-Ray, BMD 12%
Patahlogy 16%
Digital EEG 5%
Color Doppler 42%
ECG,TMT,Holter,PFT 14%
CARE & CURE POLYCLINIC PRIVATE LIMITED
IMPORTANT RATIOS
6.00
5.00
4.00
DEBT EQUITY RATIO
1:X
3.00
2.00
DEBT SERVICE COVERAGE RATIO
1.00
0.00
1 2 3 4 5 6 7
Year
CARE & CURE POLYCLINIC PRIVATE LIMITED
RETURN ON INVESTMENT
50.00%
45.00%
40.00% 35.00%
30.00%
Return %
25.00% 20.00%
RETURN ON CAPITAL EMPLOYED AT YEAREND
15.00%
10.00%
RETURN ON INVESTMENT (ORIGINAL AMOUNT)
5.00%
0.00% 1 2 3 4 Year 5 6 7
CARE & CURE POLYCLINIC PRIVATE LIMITED (All amounts in Rs. Lakhs)
Summary Project Report
Salary & Referrer's fees Power Consumption Consumables Administrative Repairs & maintenance Deprecaition Interest Tax Net Profit Total Revenue Operating Expenses Gross Profit Profit Before Tax Provision for Income Tax Profit after tax Cumulative Cash Flow 1 55.72 5.62 5.81 18.00 0.75 21.48 18.56 0.57 1.06 127.58 85.89 41.68 1.64 0.57 1.06 15.05 2 61.92 6.18 8.06 18.54 5.50 18.38 16.71 3.97 7.37 146.63 100.19 46.43 11.34 3.97 7.37 22.81 3 68.46 6.80 8.71 19.13 5.98 15.73 14.23 9.01 16.73 164.78 109.07 55.70 25.74 9.01 16.73 34.27 4 74.29 7.47 9.12 21.05 6.50 13.47 11.76 9.60 17.82 171.08 118.43 52.65 27.42 9.60 17.82 44.56 5 81.73 8.22 9.74 21.77 7.07 11.54 9.08 13.71 25.47 188.33 128.53 59.79 39.18 13.71 25.47 55.57 6 88.73 9.04 10.17 22.56 7.70 9.88 5.78 14.53 26.99 195.38 138.20 57.18 41.52 14.53 26.99 66.44 7 97.22 9.95 10.61 24.81 8.40 8.46 2.48 17.22 31.98 211.13 150.99 60.14 49.20 17.22 31.98 86.38
X-Ray, BMD Color Doppler ECG,TMT,Holter,PFT Digital EEG Patahlogy Chambers
Investment Revenue Operating Profit Rev. % of 25.69 15.00 12.19 81.26% 44.50 53.10 22.28 41.96% 40.44 17.48 13.99 80.03% 6.88 6.60 6.22 94.26% 15.00 21.00 20.41 97.19% 10.17 14.40 13.81 95.90% 142.68 127.58 88.89