M/s.medi Mart India Private Limited. Profitability Statements Particulars Income Sales

  • Uploaded by: Steven Greene
  • 0
  • 0
  • July 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View M/s.medi Mart India Private Limited. Profitability Statements Particulars Income Sales as PDF for free.

More details

  • Words: 4,491
  • Pages: 24
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

Related Documents


More Documents from ""