M/s.Medi Mart India Private Limited. Profitability Statements Particulars Income Sales from operations Space sales Total Direct Expenditure Medicines Cost Power Shop rent Repairs & Maintenance Depreciation Total (+) Opening Stock of Medicines (-) Closing Stock of Medicines Cost of goods sold Gross profit from operations Indirect Expenditure Interest on Term Loan Interest on Working Capital Salary & Allowances Selling, General,Adm Charges Total Indirect Expenditure Net profit from operations Income Tax Provision PAT EBIT
2009-10
2010-11
2011-12
2012-13
(Rs. In Lakhs) 2013-14 2014-15
1046.50 2.99 1049.49
4254.25 11.05 4265.30
5088.00 13.20 5101.20
5592.00 14.52 5606.52
6156.00 15.97 6171.97
6768.00 17.56 6785.56
837.20 6.55 44.00 5.00 36.04 928.79
3761.03 23.80 135.06 10.00 36.04 3965.92
4223.04 27.09 152.81 10.50 36.04 4449.48
4641.36 28.44 160.45 11.03 36.04 4877.31
5109.48 29.86 168.47 11.58 36.04 5355.43
5617.44 31.36 176.89 12.16 36.04 5873.89
215.26
240.00
470.00
470.00
470.00
470.00
240.00 904.05 145.44
470.00 3735.92 529.38
470.00 4449.48 651.72
470.00 4877.31 729.21
470.00 5355.43 816.54
470.00 5873.89 911.67
5.94 5.34 65.62 40.00 116.90 28.54 2.85 25.69 39.83
32.06 42.75 287.83 90.00 452.64 76.74 24.86 51.87 151.55
24.94 42.75 295.36 94.50 457.55 194.18 66.54 127.64 261.86
17.81 42.75 310.13 99.23 469.92 259.29 90.19 169.10 319.85
10.69 42.75 325.63 104.19 483.26 333.29 116.66 216.63 386.72
3.56 42.75 341.92 109.40 497.62 414.05 145.25 268.79 460.36
COMPUTATION OF INCOME-TAX
Net Profit Add: Depreciation Less: Depreciation as per I.T. Profit as per I.T. Adjusted profit Taxable Profit Tax
2009-10 2010-11 2011-12 2012-13 28.54 76.74 194.18 259.29 36.04 36.04 36.04 36.04 104.73 39.63 34.46 29.98 (40.14) 73.15 195.76 265.35
(Rs. In Lakhs) 2013-14 2014-15 333.29 414.05 36.04 36.04 26.11 22.75 343.22 427.34
(40.14)
73.15
195.76
265.35
343.22
427.34
2.85
73.15 24.86
195.76 66.54
265.35 90.19
343.22 116.66
427.34 145.25
1
M/s.Medi Mart India Private Limited. Cash Flow Statement Sources of Funds Particulars Lomg Term Sources Profit from operations Depreciation charged Increase in Capital Increase In Term Loans Unsecured Loans&reserves Total Long term Sources Long Term Applications Fixed Assets Repayment of Term Loans Sub Total Misc Assets Sub Total Total Long Term Applications Long Term Surplus 'A'
2009-10
2010-11
2011-12
2012-13
(Rs. In Lakhs) 2013-14 2014-15
25.69 36.04 200.00 250.00 300.00 811.73
51.87 36.04 0.00 0.00
127.64 36.04 0.00 0.00
169.10 36.04 0.00 0.00
216.63 36.04 0.00 0.00
268.79 36.04 0.00 0.00
87.91
163.68
205.14
252.67
304.84
518.00 0 518.00
0.00 50.00 50.00
0.00 50.00 50.00
0.00 50.00 50.00
0.00 50.00 50.00
0.00 50.00 50.00
0.00 518.00 293.73
0.00 50.00 37.91
0.00 50.00 113.68
0.00 50.00 155.14
0.00 50.00 202.67
0.00 50.00 254.84
2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 Short term Short term Sources Bank finance 150.00 150.00 0.00 0.00 0.00 0.00 Current Liabilities 0.00 70.00 11.21 8.04 9.00 9.77 Provision for Taxes 2.85 22.01 41.67 23.66 26.47 28.59 152.85 242.01 52.89 31.70 35.47 38.36 Total Short term Sources 'B' Short Term Applications Sundry Debtors 0.00 0.00 97.85 135.15 23.50 25.50 Stock of Medicines 240.00 230.00 0.00 0.00 0.00 0.00 Miscellaneous Advances 40.00 10.00 15.00 10.00 50.00 100.00 Other Current Assets 27.00 28.00 5.00 20.00 105.00 140.00 Advance Tax 2.85 22.01 41.67 23.66 26.47 28.59 290.01 159.52 188.81 204.97 294.09 Total Short term applications 'C' 309.85 Short Term Surplus/ (Defecit) 'B' - 'C' = 'D' Net Long Term Surplus 'A' - 'D' Investments Misc Deposits Total Investments Opening Cash Balance Net Accrual to Cash Balance Closing Cash Balance
-157.00 136.73 0.00 105.00 105.00 0 31.73 31.73
-48.00 -10.09 0.00 0.00 0.00 31.73 -10.09 21.65
2
-106.63 7.04 0.00 0.00 0.00 21.65 7.04 28.69
-157.11 -1.97 0.00 0.00 0.00 28.69 -1.97 26.72
-169.50 33.17 0.00 0.00 0.00 26.72 33.17 59.89
-255.73 -0.90 0.00 0.00 0.00 59.89 -0.90 59.00
M/s.Medi Mart India Private Limited.
Break Even Point Particulars Medicines Cost Power Shop rent Consumables & Stores Repairs & Maintainence Depreciation Interest on Term Loan Interest on Working Capital Salary & Allowances Selling, General,Adm Charges Income Tax Provision Total Total Net Sales for the year Fixed Cost Variable Cost Contribution Break Even Sales Break Even Point %
Fixed Cost 0.00 0.00 0.00 0.00 5.25 36.04 24.94 0.00 177.22 0.00 0.00 243.44
3
(Rs. In Lakhs) Variable Total 4223.04 4223.04 27.09 27.09 152.81 152.81 0.00 0.00 5.25 10.50 0.00 36.04 0.00 24.94 42.75 42.75 118.14 295.36 94.50 94.50 66.54 66.54 4730.12 4973.56 5101.20 243.44 4730.12 371.08 3346.59 65.60%
M/s.Medi Mart India Private Limited.
Balance Sheets - Liabilities Particulars Current Liabilities Bank finance Sundry Creditors Provision for Taxes Total Term Liabilities Term loan from SBH Unsecured Loans
2009-10
2010-11
2011-12
2012-13
(Rs. In Lakhs) 2013-14 2014-15
150.00 0.00 2.85 152.85
300.00 70.00 24.86 394.86
300.00 81.21 66.54 447.75
300.00 89.26 90.19 479.45
300.00 98.26 116.66 514.92
300.00 108.03 145.25 553.28
250.00 300.00
200.00 300.00
150.00 300.00
100.00 300.00
50.00 300.00
0.00 300.00
Total Net Worth Equity Share Capital Profit & loss Account General Reserve Total
550.00
500.00
450.00
400.00
350.00
300.00
200.00 25.69 0.00 225.69
200.00 51.87 25.69 277.56
200.00 127.64 77.56 405.20
200.00 169.10 205.20 574.30
200.00 216.63 374.30 790.93
200.00 268.79 590.93 1059.72
Total Liabilities
928.54
1172.43
1302.95
1453.75
1655.84
1913.00
Balance Sheets - Assets Particulars Current Assets Cash Balance Sundry Debtors Stock of Medicines Miscellaneous Advances Other Current Assets Advance Tax Total Fixed Assets Gross BlocK of Assets Depreciation Net Block of Fixed Assets Misc Assets Misc Deposits Total Total Assets of the Company
2009-10
2010-11
2011-12
2012-13
(Rs. In Lakhs) 2013-14 2014-15
31.73 0.00 240.00 40.00 27.00 2.85 341.58
21.65 0.00 470.00 50.00 55.00 24.86 621.51
28.69 97.85 470.00 65.00 60.00 66.54 788.07
26.72 233.00 470.00 75.00 80.00 90.19 974.91
59.89 256.50 470.00 125.00 185.00 116.66 1213.05
59.00 282.00 470.00 225.00 325.00 145.25 1506.25
518.00 36.04 481.96
518.00 72.08 445.92
518.00 108.12 409.88
518.00 144.16 373.84
518.00 180.21 337.79
518.00 216.25 301.75
105.00 105.00 928.54
105.00 105.00 1172.43
105.00 105.00 1302.95
105.00 105.00 1453.75
105.00 105.00 1655.84
105.00 105.00 1913.01
4
M/s.Medi Mart India Private Limited.
DSCR Statement - Cover Particulars
2009-10
2010-11
2011-12
2012-13
2013-14
2014-15
Profit from Operations
25.69
51.87
127.64
169.10
216.63
268.79
Depreciation
36.04
36.04
36.04
36.04
36.04
36.04
5.94
32.06
24.94
17.81
10.69
3.56
67.67
119.98
188.62
222.95
263.35
308.40
50.00
50.00
50.00
50.00
50.00
Ineterest on Term Loans Total Cover Repayment of Installments
-
Ineterest on Term Loans
5.94
32.06
24.94
17.81
10.69
3.56
Total Debt
5.94
82.06
74.94
67.81
60.69
53.56
Debt Equity Ratio
1.11
0.72
0.37
0.17
0.06
11.40
1.46
2.52
3.29
4.34
5.76
1.76
3.27
4.10
5.05
6.10
GROSS DSCR NET DSCR
NA
AVERAGE GROSS DSCR AVERAGE NET DSCR
Term Loans Repayment Schedule Particulars Principal Loan Opening Balance Repayments Closing Balance Average Balance Interest @ 14.25%
-
2.42 2.85
2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 250.00 250.00 250.00 200.00 150.00 100.00 50.00 0.00 50.00 50.00 50.00 50.00 50.00 250.00 200.00 150.00 100.00 50.00 0.00 250.00 225.00 175.00 125.00 75.00 25.00 5.94
32.06
5
24.94
17.81
10.69
3.56
M/s.Medi Mart India Private Limited.
Computation of Depreciation as per Companies Act PreCost Operative Furniture & Fixtures Interiors Computers & Software Vehicles Other assets
Computation of Depreciation As per IT Cost Rate
Total
Depreciation
133.00
57.53
190.53
6.33%
119.00
51.47
170.47
3.44%
79.00
0.00
79.00
16.21%
11.00
0.00
11.00
9.50%
67.00
0.00
67.00
6.33%
409.00
109.00
518.00
2009-10
2010-11
2011-12
Dep.on SLM 12.10 5.90 12.80 1.00 4.24 36.04
2012-13
2013-14
2014-15
Furniture & Fixtures
190.53
15%
28.58
24.29
20.65
17.55
14.92
12.68
Interiors
170.47
10%
17.05
15.34
13.81
12.43
11.19
10.07
Computers & Software
79.00
60%
47.40
18.96
7.58
3.03
1.21
0.48
Vehicles
11.00
15%
1.65
1.4
1.19
1.01
0.86
0.73
Other assets
67.00
15%
10.05
8.54
7.26
6.17
5.24
4.45
518.00
as per it
104.73
As per co act
36.04
39.63
104.73
39.63
34.46
29.98
34.46
29.98
26.11
22.75
6
26.11
22.75
M/s.Medi Mart India Private Limited.
IRR STATEMENT
CASH INFLOW
2009-10
2010-11
2011-12
2012-13
2013-14
2014-15
E.B.I.T
39.83
151.55
261.86
319.85
386.72
460.36
DEPRECIATION
36.04
36.04
36.04
36.04
36.04
36.04
TOTAL:
75.87
187.59
297.90
355.90
422.76
496.40
YEAR CONSTRN 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 0 2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24
CAPITAL OUTLAY 518.00 309.85 290.01 159.52 188.81 204.97 294.09 0 0 0 0 0 0 0 0
BENEFITS 0 75.87 187.59 297.90 355.90 422.76 496.40 496.40 496.40 496.40 496.40 496.40 496.40 496.40 496.40 1770.15
TOT DISCNTD BENEFITS
I.R.R (%)
NET BENEFITS -518.00 -233.99 -102.42 138.38 167.09 217.80 202.31 496.40 496.40 496.40 496.40 496.40 496.40 496.40 496.40 1770.15
DISCNTED BNFTS -518.00 -187.56 -65.81 71.27 68.98 72.07 53.66 105.54 84.60 67.81 54.36 43.57 34.93 27.99 22.44 64.14
0.00
24.76%
7
M/s.Medi Mart India Private Limited.
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS FORM # II : OPERATING STATEMENT 2009-10 2010-11 2011-12 S.No Particulars Current Next Year Year Estimates Projections Projections 1. GROSS SALES (i) Domestic Sales 1046.50 4254.25 5088.00 (ii) Misc income 2.99 11.05 13.20 Total 1049.49 4265.30 5101.20 3. NET SALES ( 1 - 2 ) 1049.49 4265.30 5101.20 4. % age rise ( + ) or fall ( - ) in Net Sales as 0.00 0.00 0.00 compared to previous year 5. COST OF SALES (i) Medicines ( including Stores and other used in the process of manufacture (a) Imported 0.00 0.00 0.00 (b) Indigenous 837.20 3761.03 4223.04 (ii) Other Spares (a) Imported 0.00 0.00 0.00 (b) Indigenous 0.00 0.00 0.00 (iii) Power and Fuel 6.55 23.80 27.09 (iv) Shop Rent 44.00 135.06 152.81 (v) Repairs & Maintenance 5.00 10.00 10.50 (vi) Depreciation 36.04 36.04 36.04 (vii) SUB - TOTAL ( Items (i) to (vi) 928.79 3965.92 4449.48 Sub-Total 928.79 3965.92 4449.48 (x) COST OF OPERATION 928.79 3965.92 4449.48
8
2012-13
Projections 5592.00 14.52 5606.52 5606.52 0.00
0.00 4641.36 0.00 0.00 28.44 160.45 11.03 36.04 4877.31 4877.31 4877.31
M/s.Medi Mart India Private Limited.
Form # II Operating Statement Cont…. S.No Particulars
6. 7. 8. 9. 10. 11.
12. 13. 14. 15. 16. 17.
(ix) Add: Opening Stocks of Medicines Sub-Total (xii) Deduct: Closing Stocks of Medicines (xiii) Sub - Total ( Total of Cost of Sales ) Selling, General & Administrative Expenses SUB - TOTAL ( 5 + 6 ) Operating Profit before Interest ( 3 - 7 ) Interest Operating Profit after Interest ( 8 - 9 ) (i) Add Other Non-Operating Income a) Other Income Sub - Total ( Income ) (ii) Deduct Other Non-Operating Income a) Preliminary Expenses Written Off b) Others Sub - Total ( Expenses ) (iii) Net of other Non-Operating Income/Expenses Profit before Tax / ( Loss ) 10 + 11(iii) Provision for Taxes & differed tax liability Net Profit / ( Loss ) { 12 -13 } (a) Equity Dividend Paid including Dividend tax (b) Dividend Rate Retained Profit ( 14 - 15 ) Retained Profit / Net Profit ( % age )
9
2009-10 Current Year Estimate s 215.26 1144.05 240.00 904.05 105.62 1009.66 39.83 11.28 28.54
2010-11 Next Year Projection s 240.00 4205.92 470.00 3735.92 377.83 4113.75 151.55 74.81 76.74
2011-12
2012-13
Projection s 470.00 4919.48 470.00 4449.48 389.86 4839.34 261.86 67.69 194.18
Projection s 470.00 5347.31 470.00 4877.31 409.35 5286.67 319.85 60.56 259.29
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 28.54 2.85 25.69
0.00 76.74 24.86 51.87
0.00 194.18 66.54 127.64
0.00 259.29 90.19 169.10
0.00 0.00 25.69 100.00
0.00 0.00 51.87 100.00
0.00 0.00 127.64 100.00
0.00 0.00 169.10 100.00
M/s.Medi Mart India Private Limited.
FORM # III ANALYSIS OF BALANCE SHEET S.No Particulars
1.
2. 3. 4. 5. 6. 7. 8. 9.
10.
CUR ENT LIABILITIES Short Term Borrowings from Banks ( excluding Bills Purchased Discounted (i) From Applicant Bank (ii) From Other Banks (iii) ( of which Bills Purchased & Discounted ) SUB - TOTAL ( A ) Short Term Borrowings from others Sundry Creditors ( Trade ) Advance Payments from Customers / Deposits from Dealers Provision for Taxation Dividend Payable / Proposed Dividend Other Statutory Liabilities ( due within one year ) Deposits / Installments of Term Loan / DPG's / Debentures, etc. ( due within one year ) Other Current Liabilities & Provisions Liabilities for capital goods Liabilities for expenses Other Provisions SUB - TOTAL ( B ) TOTAL CURRENT LIABILITIES ( Total of Items # 1 to 9 )
10
2009-10 Current Year Estimate s
2010-11 Next Year Projection s
2011-12
2012-13
Projection s
Projection s
150.00
300.00
300.00
300.00
150.00 0.00 0.00
300.00 0.00 70.00
300.00 0.00 81.21
300.00 0.00 89.26
0.00 2.85 0.00
0.00 24.86 0.00
0.00 66.54 0.00
0.00 90.19 0.00
0.00
0.00
0.00
0.00
0.00 0.00 0.00 0.00 0.00 0.00 2.85 152.85
0.00 0.00 0.00 0.00 0.00 0.00 94.86 394.86
0.00 0.00 0.00 0.00 0.00 0.00 147.75 447.75
0.00 0.00 0.00 0.00 0.00 0.00 179.45 479.45
M/s.Medi Mart India Private Limited.
FORM # III
ANALYSIS OF BALANCE SHEET
S.No Particulars
11. 12. 13. 14. 15. 16.
17. 18.
19. 20. 21. 22. 23. 24. 25.
TERM LIABILITIES Debentures ( not maturing within one year ) Preference Shares ( Redeemable after one year ) Term Loans ( excluding installments payable within one year ) Hire Purchase Loan ( excluding installments due within one year ) Term Deposits ( Repayable after one year ) Other Term Liabilities Liabilities for Capital Goods Unsecured Loans from shareholders Unsecured Loans from Others TOTAL TERM LIABILITIES ( Total of Items # 11 to 16 ) TOTAL OUTSIDE LIABILITIES (Item 10 plus item 17) NET WORTH Ordinary Share Capital General Reserve Revaluation Reserve Sales Tax Subsidy Surplus (+) or Deficit (-) in profit and loss Account NET WORTH TOTAL IABILITIES ( Total Items # 18 + 24 )
11
2009-10 Current Year Estimate s
2010-11 Next Year Projection s
2011-12
Rs lakhs 2012-13
Projection s
Projection s
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
250.00
200.00
150.00
100.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 300.00
0.00 300.00
0.00 300.00
0.00 300.00
550.00 702.85
500.00 894.86
450.00 897.75
400.00 879.45
200.00 0.00 0.00 0.00
200.00 25.69 0.00 0.00
200.00 77.56 0.00 0.00
200.00 205.20 0.00 0.00
25.69 225.69 928.54
51.87 277.56 1172.43
127.64 405.20 1302.95
169.10 574.30 1453.75
M/s.Medi Mart India Private Limited.
FORM # III ANALYSIS OF BALANCE SHEET S.No Particulars
26. 27.
28.
29. 30.
31. 32. 33.
34.
CURRENT ASSETS Cash and Bank Balances Investments ( other than Long Term Investments) i) Government ii) Fixed deposits with Banks i) Receivables other than deferred & Bills purchased and Discounted by Banks ii) Export receivables ( including Bills Purchased Discounted by Banks ) Installments of deferred Receivables ( due within one year ) Inventory : i) Stock of Medicines a) Imported b) Indigenous Advances to Suppliers of Medicines and Stores and for Job work Advance Payment of Taxes Other Current Assets a)Other Current Assets b) Loans and Advances TOTAL CURRENT ASSETS ( Total of Items # 26 to 33 )
12
2009-10 Current Year Estimate s
2010-11 Next Year Projection s
2011-12
2012-13
Projection s
Projection s
31.73
21.65
28.69
26.72
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00
0.00
97.85
233.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 240.00
0.00 470.00
0.00 470.00
0.00 470.00
0.00 2.85
0.00 24.86
0.00 66.54
0.00 90.19
40.00 27.00
50.00 55.00
65.00 60.00
75.00 80.00
341.58
621.51
788.07
974.91
M/s.Medi Mart India Private Limited.
FORM # III ANALYSIS OF BALANCE SHEET S.No Particulars FIXED ASSETS
35.
36. 37. 38.
39. 40.
41. 42.
43. 44. 45. 46. 47. 48.
Gross Block ( Land, Building & Machinery, Work-inProgress ) Depreciation to date NET BLOCK ( Item # 35 - Item # 36 ) Investment / Book Debts / Advances / Deposits which are not Current Assets I) a) Investments in Subsidiary Companies / Affiliates b) Others II) Advances to Suppliers of Capital Goods and Contract - Capital work in progress III) Deferred receivable ( Maturity exceeding one year ) IV) Others - Deposits FD with Bank Non-Consumable Stores and Spares Other Non-Current Assets including due from Directors TOTAL OTHER NON - CURRENT ASSETS Intangible Assets ( Patents, Goodwill, Preliminary Expenses, Doubtful Debts not provided for & deposits etc. ) TOTAL ASSETS (Total of Items 34,37,41& 42) TANGIBLE NET WORTH ( Items # 24 - 42 ) NET WORKING CAPITAL ( Items # [ ( 17 + 24 ) - ( 37+ 41 + 42 ) ] CURRENT RATIO { Item # 34 / 10 } TOTAL OUTSIDE LIABILITIES TANGIBLE NET WORTH { Items # 18 / 44 ) Total Term Liabilities / Tangible Net Worth
13
2009-10 Current Year Estimate s
2010-11 Next Year Projection s
2011-12
2012-13
Projection s
Projection s
518.00 36.04 481.96
518.00 72.08 445.92
518.00 108.12 409.88
518.00 144.16 373.84
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00
0.00
0.00
0.00
0.00 105.00 0.00 0.00 0.00
0.00 105.00 0.00 0.00 0.00
0.00 105.00 0.00 0.00 0.00
0.00 105.00 0.00 0.00 0.00
105.00
105.00
105.00
105.00
0.00
0.00
0.00
0.00
928.54
1172.43
1302.95
1453.75
225.69
277.56
405.20
574.30
188.73 2.23
226.65 1.57
340.32 1.76
495.46 2.03
3.11 2.44
3.22 1.80
2.22 1.11
1.53 0.70
M/s.Medi Mart India Private Limited.
FORM # IV COMPARATIVE STATEMENT OF CURRENT ASSETS S.No Particulars 2009-10 2010-11 2011-12 2012-13 Current Next Year Year Estimates Projections Projections Projections A CURRENT ASSETS 1. Medicines ( Including Stores & Other Items used in the Process of Manufacture ) (a) Imported : 0.00 0.00 0.00 0.00 Months' Consumption (b) Indigenous : 240.00 470.00 470.00 470.00
2.
3. 4.
5.
6. 7. 8.
9.
Months Consumption Other Consumable Spares, ( excluding those included in 1 above ) (a) Imported : Months' Consumption (b) Indigenous : Months' Consumption Stock-in-Process Months Cost of Production Finished Goods Months Cost of Sales Receivables other that Export deferred rec'bles ( including purchased and discounted by Banks) Months Domestic Sales Export Receivables ( Including Bills Purchased & Disctd) Months' Export Sales Advances to Suppliers of Medicines, Stores and Consumables Other Current Assets including Cash and Bank balances, Deposits, Advance payment of Taxes and Margins for LC's and guarantees. Total Current Assets ( To Agree with Item # 34 in Form # 3 )
14
(3.44)
(1.50)
(1.34)
(1.22)
0.00
0.00
0.00
0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
-
-
-
-
0.00 -
0.00 -
97.85 (0.23)
233.00 (0.50)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
101.58
151.51
220.23
271.91
341.58
621.51
788.07
974.91
M/s.Medi Mart India Private Limited.
FORM # IV COMPARITIVE STATEMENT OF CURRENT LIABILITIES S.No Particulars 2009-10 2010-11 Current Next Year Year Estimate Projection s s B. CURRENT LIABILITIES ( Other than Bank Borrowings for working capital) 10. Creditors for Purchases of Medicines, Stores and Spares 0.00 70.00 0.00 0.00 11. Advances from Customers 0.00 0.00 12. Statutory Liabilities 2.85 24.86 13. Other Current Liabilities 0.00 0.00 Installments of Term loans 0.00 0.00 14. TOTAL 2.85 94.86
15
2011-12
2012-13
Projection s
Projection s
81.21 0.00 0.00 66.54 0.00 0.00 147.75
89.26 0.00 0.00 90.19 0.00 0.00 179.45
M/s.Medi Mart India Private Limited.
Form V Computation Of Maximum Permissible Bank Finance for Working Capital S.No Particulars 2009-10 2010-11 Current Next Year Year Estimate Projection s s 1. Total Current Assets ( Item # 9 in Form # IV ) 341.58 621.51 2. Other Current Liabilities 2.85 94.86 ( Other than Bank Borrowings ) ( Item # 14 in Form IV ) 3. Working Capital Gap ( WCG ) 338.73 526.65 ( Item # 1 - Item # 2 ) Minimum stipulated Net Working Capital ie 4. 25% of WCG / 25% of Total Current Assets as to case may be depending upon the method of lending being 84.68 131.66 applied ( Export Receivables to be excluded under both methods ) 5. Actual / Projected net working Capital 188.73 226.65 ( Item # 45 in Form # III ) 6. Item # 3 Minus Item # 4 254.05 394.99 7. Item # 3 Minus Item # 5 150.00 300.00 MAXIMUM PERMISSIBLE BANK 8. FINANCE 150.00 300.00 ( Item # 6 or Item # 7 whichever is lower ) 9 NWC TO TCA ( % ) 55.25 36.47 10 Bank Finance to TCA ( % ) 43.91 48.27 11 Sundry Creditors to TCA ( % ) 0.00 11.26 12 Other Current Liabilities to TCA ( % ) 0.00 0.00 13 Inventories to Net Sales ( days ) 83.48 40.22 14 Receivables to Gross Sales ( days ) 60 60 15 Sundry Creditors to Purchases ( days ) 0.00 6.79
16
2011-12
2012-13
Projection s
Projection s
788.07 147.75
974.91 179.45
640.32
795.46
160.08
198.87
340.32
495.46
480.24 300.00
596.60 300.00
300.00
300.00
43.18 38.07 10.31 0.00 33.64 60 7.02
50.82 30.77 9.16 0.00 30.60 60 7.02
M/s.Medi Mart India Private Limited.
FORM # VI FUND FLOW STATEMENT 1 SOURCES S.No Particulars
a) Net Profit after Tax b) Depreciation c) Increase in Capital Increase in subsidy d) B/F reserves e) Increase in Term Liabilities e) Decrease in i) Fixed Assets ( Depreciation to date ) ii) Other Non-Current Assets f) Increase in U/Sec loans
2
g) Total USES Particulars
2009-10 Current Year Estimate s 25.69 36.04 200.00
2010-11 Next Year Projection s 51.87 36.04 0.00
2011-12
Rs lakhs 2012-13
Projection s 127.64 36.04 0.00
Projection s 169.10 36.04 0.00
0.00 250.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00 300.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
811.73
87.91
163.68
205.14
2009-10 2010-11 2011-12 2012-13 Current Next Year Year Estimate Projection Projection Projection s s s s 0.00 0.00 0.00 0.00 0.00 50.00 50.00 50.00 0.00 0.00 0.00 0.00
a) Net Loss b) Decrease in Term Liabilities Decrease in U/Secured loans c) Increase in i) Fixed Assets ii) Non current assets d) Dividend Payments e) Decrease in liability for capital goods f) Increase in Preliminary & Pre-operative exp g) TOTAL
17
518.00 105.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 623.00
0.00 50.00
0.00 50.00
0.00 50.00
M/s.Medi Mart India Private Limited.
a) b) c) d) e) f) g) h) I)
Long Term Surplus ( + ) / Deficit ( - ) ( Item # 1 Minus Item # 2 ) Increase / Decrease in Current Assets * ( as per details given below ) Increase or Decrease in Current Liabilities other than Bank Borrowings Increase / Decrease in Working Capital Gap Net Surplus ( + ) / Deficit ( - ) Increase / Decrease in Bank Borrowings INCREASE / DECREASE IN NET SALES
18
188.73
37.91
113.68
155.14
341.58
279.93
166.56
186.84
2.85 338.73 -150.00 150.00 1049.49
92.01 187.92 -150.00 150.00 3215.81
52.89 113.67 0.00 0.00 835.90
31.70 155.14 0.00 0.00 505.32
M/s.Medi Mart India Private Limited.
TURNOVER (Rs.In Lakhs) Year
Month
No.of Shops
Monthly Sales Per Shop Rs.
2009-10
Space Sales Per Shop
Total Space Sale
Rs.
Rs.
Rs.
0 8 13 15 18 19 19 22 35 40 50 60
3.50 3.50 3.50 3.50 3.50 3.50 3.50 3.50 3.50 3.50 3.50 3.50
67 74 81 88 95 100 100 100 100 100 100 100
3.85 3.85 3.85 3.85 3.85 3.85 3.85 3.85 3.85 3.85 3.85 3.85
2011-12
100
4.24
5088.00
13.20
2012-13
100
4.66
5592.00
14.52
2013-14
100
5.13
6156.00
15.97
2014-15
100
5.64
6768.00
17.56
2010-11
April May June July August September October November December January February March Total April May June July August September October November December January February March Total
Total Sales
19
0.00 28.00 45.50 52.50 63.00 66.50 66.50 77.00 122.50 140.00 175.00 210.00 1046.50 257.95 284.90 311.85 338.80 365.75 385.00 385.00 385.00 385.00 385.00 385.00 385.00 4254.25
0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01
0 0.08 0.13 0.15 0.18 0.19 0.19 0.22 0.35 0.4 0.5 0.6 2.99 0.67 0.74 0.81 0.88 0.95 1.00 1.00 1.00 1.00 1.00 1.00 1.00 11.05
M/s.Medi Mart India Private Limited.
ELECTRICITY CHARGES Year
Month
Particulars
No. of Shops
Rent per Month
Per Year
Corporate Office Wear House Shops
1 1
2500 2250
30000 27000
0 8 13 15 18 19 19 22 35 40 50 60 Total Rs. In Laksh
0 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000
0 16000 26000 30000 36000 38000 38000 44000 70000 80000 100000 120000 655000 6.55
2009-10
April May June July August September October November December January February March
20
M/s.Medi Mart India Private Limited.
20010-11
Month
Particulars
No of Shops
Rent per Month
Per Year
Corporate Office Wear House Shops
1 1
2625 2363
31500 28350
67 74 81 88 95
2100 2100 2100 2100 2100
140700 155400 170100 184800 199500
100
2100
1470000
April May June July August September To March
Total Rs.In Lakhs
2011-12
Corporate Office Wear House Shops
1 1 100 Total Rs.In Lakhs
2380350 23.80
2756 2481 2205
33075 29768 2646000 2708843 27.09
2012-13
28.44
2013-14
29.86
2014-15
31.36
21
M/s.Medi Mart India Private Limited. RENT Year
Month
2009-10
Particulars Corporate Office Wear House Shops
April May June July August September October November December January February March
2010-11
Corporate Office Wear House Shops April May June July August September To March
2011-12
No. of Shops 1 1
Rent per Month 40000 65000
Per Year 480000 780000
0 8 13 15 18 19 19 22 35 40 50 60 Total Rs. In Lakhs 1 1
0 10500 10500 10500 10500 10500 10500 10500 10500 10500 10500 10500
42000 68250
0 84000 136500 157500 189000 199500 199500 231000 367500 420000 525000 630000 4399500 44.00 504000 819000
67 74 81 88 95 100
11025 11025 11025 11025 11025 11025
738675 815850 893025 970200 1047375 7717500
Total Rs.In Lakhs 1 1 100
Corporate Office Wear House Shops
Rs.In Lakhs 2012-13 2013-14 2014-15
22
44100 71663 11576
13505625 135.06 529200 859950 13891500 15280650 152.81 160.45 168.47 176.89
M/s.Medi Mart India Private Limited.
SALARIES Year 2009-10
Particulars
No of Shops
Manpower(Per Shop) Pharmacist Pharma Aids Salary Per Month April May June July August September October November December January February March Head Office & Wear House Managers Executives Assistants
No of Persons
Salary per Month
1 3
7000 15000 22000
0 8 13 15 18 19 19 22 35 40 50 60 1 1 1
Less: Preoperative Expenses30%
5 7 18 Total Rs. In Lakhs
Per Year
22000 22000 22000 22000 22000 22000 22000 22000 22000 22000 22000 22000
0 176000 286000 330000 396000 418000 418000 484000 770000 880000 1100000 1320000
16000 9000 5000
960000 756000 1080000 9374000 93.74 28.12 65.62
23
M/s.Medi Mart India Private Limited.
Year 2010-11
Particulars
No of Shops
No of Persons
Salary per Month
Per Year
1 3 67 74 81 88 95
7350 15750 23100 23100 23100 23100 23100 23100
1547700 1709400 1871100 2032800 2194500
100
23100
16170000
5 7 18 Total Rs. In Lakhs
18375 9450 6300 34125
1102500 793800 1360800 28782600 287.83
1 100
35831 24255
429975 29106000 29535975 295.36
Manpower(Per Shop) Pharmacist Pharma Aids April May June July August September To March Head Office & Wear House Managers Executives Assistants
1 1 1
2011-12 Head Office Shops
Rs. In Lakhs 2012-13
310.13
2013-14
325.63
2014-15
341.92
24