Hospital Project Financial Overview
Hospital Project Financial Overview
(Rs
A) SOURCES AND APPLICATIONS OF FUND
TOTAL
SOURCES OF FUNDS APPLICATION OF FUNDS
TOTAL
1.00
605.00
35.00 640.00
200.00
841.00
ANNEXURE I - PROFESSIONAL RECEIPTS
Charges per
No. of patients
Sr No. Particulars patient/ Total
per month
operations
A) OUTDOOR PATIENTS (OPD)
1) Regular Follow-up Patients 1,000 200.00 200,000.00
2) New Patients 1,500 350.00 525,000.00
Sub Total (A) 2,500.00 725,000.00
INDOOR PATIENTS Receipts (including charges
B)
for stay, nursing, doctor's check-up round, etc.)
1) General Ward (10 Patients per
40 17,500.00 700,000.00
day*charges 2500*7 days stay*4 weeks)
D) LABORATORY
Laboratory Services Collection - - 200,000.00
Sub Total (D) 200,000.00
Presuming 5% increase from second year onwards, revenue receipts will be as under :
(Rs. In Lakhs)
P R O P O S E D Y E A R S
1 2 3 4 5 6 7 8
484.85
484.85
Annual Rent from the Medical Store - (Rs. 1,00,000 p.m) 1,200,000.00
Annual Rent ( in lakhs) 12
Presuming 5% increase from second year onwards, the profit will be as under:
(Rs. In Lakhs)
P R O P O S E D Y E A R S
1 2 3 4 5 6 7 8
16.08
(Rs. In Lakhs)
P R O P O S E D Y E A R S
1 2 3 4 5 6 7 8
10.05
Sr. No. Category No. of Staff Number Wages per/month Monthly Wages Annual Wages
85.36
14.07
Promoter Dr. Aaditya Kurade will be assisted by 1) his father Dr. Vijay Adapppa Kurade who is also pediatrician and is practising in Jaysingpur
for last 38 years 2) his spouse Utkarsha Aaditya Kurade who is also pediatrician and is in this field since 6 years.
These two professionals will be paid Professional charges at 30% (approx) of the receipts generated through them. (It is presumed that the
yearly profession received Rs. 361.80 are equally contributed by these three professionals i.e. Promoter along with Dr. Vijay Kurade and
[Link] Kurade)
Presuming 5% increase from second year onwards, the profit will be as under:
(Rs. In Lakhs)
P R O P O S E D Y E A R S
1 2 3 4 5 6 7 8
93.81
This includes expenses like accounting charges, Bank Charges, MPCB Fees, Printing and Stationery, Telephone Expenses, Vehicle Expenses,
travelling expenses, etc.
10.72
SHUDDHI INDUSTRIES LLP
PROJECT REPORT
(Rs. In Lakhs)
SOURCES OF FUNDS
AMOUNT APPLICATION OF FUNDS AMOUNT
WORKING CAPITAL -
PARTICULARS Rs.
P R O P O S E D Y E A R S
ANNEX
PARTICULARS
URE
1 2 3 4 5 6 7 8 9
I) INCOME
b) MEDICAL SHOP RENT II - - 12.00 12.60 13.23 13.89 14.59 15.32 16.08
SUB TOTAL (I) - - 373.80 392.49 412.11 432.72 454.36 477.07 500.93
II) EXPENSES
b) HOSPITAL EXPENSES III - - 7.50 7.88 8.27 8.68 9.12 9.57 10.05
a) REPAIRS & MAINT. (at Rs. 10000 per month) - - 1.20 1.26 1.32 1.39 1.46 1.53 1.61
d) LABORATORY & RADIOLOGY CHARGES V - - 10.50 11.03 11.58 12.16 12.76 13.40 14.07
g) ELECTRICITY EXPENSES ( at Rs. 50000 per month) - - 6.00 6.30 6.62 6.95 7.29 7.66 8.04
i) ADMINISTRATIVE EXP. VII - - 8.00 8.40 8.82 9.26 9.72 10.21 10.72
SUB TOTAL (II) - - 263.30 260.87 260.17 261.06 263.44 267.18 272.20
6) NET PROFIT BEFORE -- - - 110.50 131.63 151.94 171.66 190.92 209.90 228.73
INTEREST & TAX
7) INTEREST ON TERM LOAN IX - - 40.65 34.44 28.23 22.02 15.81 9.59 3.38
8) PROFIT BEFORE TAX -- - - 69.85 97.19 123.71 149.64 175.11 200.31 225.35
10) NET PROFIT AFTER TAX -- - - 69.85 97.19 81.25 98.28 115.01 131.56 148.01
11) CASH PROFIT (10+5) -- - - 163.85 180.29 154.77 163.36 172.66 182.66 193.33
12) OPERATING PROFIT -- - - 163.85 180.29 197.23 214.71 232.76 251.41 270.67
(11+9)
P R O P O S E D Y E A R S
ANNEX
PARTICULARS
URE 1 2 3 4 5 6 7 8 9
LIABILITIES
CAPITAL X 146.50 341.00 395.85 451.04 472.29 492.57 517.58 553.15 599.15
TOTAL 321.50 841.00 824.45 808.24 758.09 706.97 660.58 624.75 599.15
ASSETS
FIXED ASSETS VII 321.50 841.00 747.00 663.90 590.38 525.30 467.65 416.55 371.23
CURRENT ASSETS
STOCK OF MEDICINES & CONSUMABLES @25% -- - - 0.60 0.63 0.66 0.69 0.73 0.77 0.80
CASH & BANK -- - - 56.85 115.71 88.92 87.98 92.07 101.77 115.77
TOTAL 321.50 841.00 824.45 808.24 758.09 706.97 660.58 624.75 599.15
DIFF 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
P R O P O S E D Y E A R S
PARTICULARS
1 2 3 4 5 6 7 8 9
RECEIPTS
OPENING CASH & BANK BALANCE - - - 56.85 115.71 88.92 87.98 92.07 101.77
TOTAL 321.50 519.50 163.85 237.14 312.94 303.63 320.74 343.48 372.44
PAYMENTS
INCREASE IN LOANS & ADVANCES - - 15.00 5.00 45.33 8.46 3.30 3.22 3.16
INCREASE IN CLOSING STOCK - - 0.60 0.03 0.03 0.03 0.03 0.04 0.04
REPAYMENT OF TERM LOAN - - 71.40 71.40 71.40 71.40 71.40 71.40 71.60
CLOSING CASH AND BANK BALANCE - - 56.85 115.71 88.92 87.98 92.07 101.77 115.77
TOTAL 321.50 519.50 163.85 237.14 312.94 303.63 320.74 343.48 372.44
DIFF 0 0 0 0 0 0 0 0 0
P R O P O S E D Y E A R S
PARTICULARS
1 2 3 4 5 6 7 8 9
SOURCES
TOTAL 321.50 519.50 163.85 180.29 154.77 163.36 172.66 182.66 193.33
APPLICATIONS
INCREASE IN NET CURRENT ASSETS - - 77.45 66.89 23.37 13.96 11.26 15.26 19.73
REPAYMENT OF TERM LOAN - - 71.40 71.40 71.40 71.40 71.40 71.40 71.60
TOTAL 321.50 519.50 163.85 180.29 154.77 163.36 172.66 182.66 193.33
0 0 0 0 0 0 0 0 0
ANNEX YEARS
PARTICULARS
URE
1 2 3 4 5 6 7 8 9
1) DEBT SERVICE CAPACITY RATIO
a) Interest on Term Loan 8 - - 40.65 34.44 28.23 22.02 15.81 9.59 3.38
b)Repayment of Term Loan 8 - - 71.40 71.40 71.40 71.40 71.40 71.40 71.60
a) Long Term Debt. 175.00 500.00 428.60 357.20 285.80 214.40 143.00 71.60 -
b) Own Capital (Equity) 146.50 341.00 395.85 451.04 472.29 492.57 517.58 553.15 599.15
c) Debt + Equity (a+b) 321.50 841.00 824.45 808.24 758.09 706.97 660.58 624.75 599.15
Debt Equity Ratio (a/b) 1.19 1.47 1.08 0.79 0.61 0.44 0.28 0.13 -
Debt Equity Ratio (a/c) 0.54 0.59 0.52 0.44 0.38 0.30 0.22 0.11 -
ANNEXURE VIII - DEPRECIATION
P R O P O S E D Y E A R S
PARTICULARS
1 2 3 4 5 6 7 8 9
(-) Deduction - - - - - - - - -
(-) Depn. @ 15 % P.A. (Put to use from 01/04/2027) - - 30.00 25.50 21.68 18.42 15.66 13.31 11.31
Closing Balance - 200.00 170.00 144.50 122.82 104.40 88.74 75.43 64.12
HOSPITAL BUILDING
Opening Balance b/d 640.00 576.00 518.40 466.56 419.90 377.91 340.12
(+) Addition > 180 Days -
(+) Addition < 180 Days -
(-) Deduction -
(-) Depn. @ 10 % P.A. 64.00 57.60 51.84 46.66 41.99 37.79 34.01
Closing Balance 576.00 518.40 466.56 419.90 377.91 340.12 306.11
PlOT
Opening Balance 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
(+) Addition > 180 Days - - - - - - - - -
(+) Addition < 180 Days - - - - - - - - -
(-) Deduction - - - - - - - - -
Closing Balance 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Opening WDV 1.00 321.50 841.00 747.00 663.90 590.38 525.30 467.65 416.55
Total Additions > 180 Days 302.50 302.50 - - - - - - -
Total Additions < 180 Days - 200.00 - - - - - - -
Exp Capitalised for 2 Year 18.00 17.00 - - - - - - -
Total Deductions - - - - - - - - -
Total Depreciation - - 94.00 83.10 73.52 65.08 57.65 51.10 45.32
Total Closing Balance 321.50 841.00 747.00 663.90 590.38 525.30 467.65 416.55 371.23
P R O P O S E D Y E A R S
PARTICULARS
1 2 3 4 5 6 7 8 9
Opening balance - 146.50 341.00 395.85 451.04 472.29 492.57 517.58 553.15
Add- Net Profit After Tax - - 69.85 97.19 81.25 98.28 115.01 131.56 148.01
Closing Balance 146.50 341.00 395.85 451.04 472.29 492.57 517.58 553.15 599.15
ANNEXURE IX(A) : - REPAYMENT OF TERM LOAN (BUILDING - RS. 3.50 Cr AND MACHINERY RS. 1.50 CR)
There will be a moratorium period of 2 Year and the Term Loan will be repaid in 84 monthly s of Rs. 595000 each.
P R O P O S E D Y E A R S
Installments
1 2 3 4 5 6 7 8 9
Opening Bal. 17500000 35000000 50000000 42860000 35720000 28580000 21440000 14300000 7160000
Less : 1st 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 49405000 42265000 35125000 27985000 20845000 13705000 6565000
Less : 2nd 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 48810000 41670000 34530000 27390000 20250000 13110000 5970000
Less : 3rd 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 48215000 41075000 33935000 26795000 19655000 12515000 5375000
Less : 4th 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 47620000 40480000 33340000 26200000 19060000 11920000 4780000
Less : 5th 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 47025000 39885000 32745000 25605000 18465000 11325000 4185000
Less : 6th 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 46430000 39290000 32150000 25010000 17870000 10730000 3590000
Less : 7th 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 45835000 38695000 31555000 24415000 17275000 10135000 2995000
Less : 8th 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 45240000 38100000 30960000 23820000 16680000 9540000 2400000
Less : 9th 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 44645000 37505000 30365000 23225000 16085000 8945000 1805000
Less : 10th 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 35000000 44050000 36910000 29770000 22630000 15490000 8350000 1210000
Less : 11th 0 0 595000 595000 595000 595000 595000 595000 595000
17500000 50000000 43455000 36315000 29175000 22035000 14895000 7755000 615000
Less : 12th 0 0 595000 595000 595000 595000 595000 595000 615000
Closing 17500000 50000000 42860000 35720000 28580000 21440000 14300000 7160000 0
Balance
Total
0 0 7140000 7140000 7140000 7140000 7140000 7140000 7160000
Repayment
Say Rs. In
0 0 71 71 71 71 71 71 72
Lakhs
NOTE :
0 0.00725
Note 1 :
The Construction work is expected to be completed in 2 years. Hence, the building loan will also be utilised in phases. In the first year, the average
loan amount utilised Rs. 87.50 Lacs is expected to be (3.5 Cr/2 years/2 (average).
Interest on 87.50 Lacs at 8.70% will be Rs.761250
Note 2 :
In the second year, the average loan amount utilised is Rs. 2.625 Cr which is expected to be (3.5Cr/2years + 87.50Lakhs i.e. the amount utilised
in the first year). Interest on 2.625Cr at 8.70% will be Rs. 2283750
SCHEDULE I - COST OF HOSPITAL BUILDING
39194000
7054920
1959700
10000000
58208620
2328345
60536965
605