Vidisha Bhopal Kshetriya Gramin Bank, Head Office, Vidisha

HO/CREDIT/50/2011-12 20thOct 2011

Memorandum: Appraisal Note Proposal for sanction of Term Loan: M/s Mini Warehouse
Proposal: We have received a proposal for sanction of a new term loan of Rs.51.30 lacs from our Basoda Branch for construction of Ware house, Grading Shed , purchase of Grading Machine,Weigh bridge etc. under the NABARDs AMI Scheme for which subsidy of 25% of the project cost will be available from the Government of India. This scheme has been formulated to develop marketing infrastructure in the country to cater to the post-harvest requirement of production and marketable surplus of various farm products. This scheme is reform linked and assistance for development of infrastructure projects will be provided in those States/Union Territories which permit setting up of agricultural markets in private and cooperative sectors and allow direct marketing and contract farming. The required reform in APMC Act has been done in Madhya Pradesh and as such the infrastructure financed by bank are eligible for subsidy under the scheme. The recent change in instructions from NABARD dated 11.10.2011 has been incorporated in calculation of subsidy & promotors margin has been proportionately increased in the project Brief History: Smt. Savita Samaiya w/o Shri A.K. Samaiya proprietor of M/s Mini Warehouse proposes to establish aWarehouse & other services at Village Hatoda, Tahsil Ganj Basoda, District Vidisha. The promoter is from a business family and is also proprietor of firm M/s Mini Agencies which is into manufacturing & trading of Agriculture Equipments & they had a good customer base in the surrounding area among farmers which they intend to encash in the present project. The promoters husband Mr. Amresh Kumar Samiya will also assist in the above project & although they are new to our bank but are well known & established in Ganj Basoda with very large means.The above unit will be managed and controlled by the promoter with the assistance of three other employees. The details of their A/cs with other FI are mentioned elsewhere in this appraisal , both A/cs are regular & Standard Asset as per IRAC norms. Project: Construction of Warehouse, Grading shed, installation of Grading Machine and Weigh Bridge for Storage, Grading & Weighing of food grains and pulses of nearby farmers with the installed capacity of 3000 M.T. (Warehouse), 1 MTPH (Grading Machine) 50 MT (Weigh Bridge) respectively. The demand in the area far exceed the existing capacity of storage & other services in private as well as Government Warehouses. Technical Feasibility: Location and site Selection: The proposed project is situated at Village Hatoda in Tahsil Basoda District Vidisha on Ganj Basoda- Bareth road. The land is situated at near New Grain Mandi Ganj Basoda where there is no Godown nearby & the proposed unit is well connected to other parts of state and other major cities by road. The location is situated and surrounded with famous Gram Wheat and Soybean producing Ganj Basoda and Vidisha. The projects site is free from flood and water logging in rainy season. Building of Warehouse: The building of the warehouse is being built as per the specification of Indian Standard code of practice for construction of bagged food grain storage structures.Area of the godown is 1392.53 Sq.m with the average height of a godown not less than 5.6m as per the Indian Standard code of practice for bagged food grain storage structures (IS: 607-1971),the passage between the two stacks is 1.56m, parallel to the width of the building and 0.76 m in the longitudinal directions and around the stacks at the periphery. The cost of construction of godown per MT as per projection comes to Rs.1875. The storage capacity of the proposed warehouse is 3000 M.T.

2.
Building of Grading Shade: The size of grading shed is 83.53 Sq.m & the capacity of grading machine is 1 MTPH . Weigh bridge : A fully electronic weigh bridge of capacity 50 MT is to be installed at site. Process of grading: The grading process is very simple & technical person required is easily available locally, the process involve putting grains through different size of sieve which help in sorting uniform size of grains resulting in higher value of produce. Financial Feasibility: i) Cost of Project: Cost of Construction of Rural Godown of 3000 MT capacity. Grading Machine Grading Shed Boundary wall Weighing Structure (50 MT) & operator Room Weighing Machine (50MT) Tubewell Internal Road Total: (Rs. in lacs) 56.45 7.35 4.04 4.99 1.43 6.38 0.65 2.51 83.80

Cost of Construction of the Rural Godown: The estimated cost of construction for the godown has been prepared by Mr. R.K. Dixit Engg. Consultants at Rs. 56.45 lacs for the 3000 MT capacity of the godown which conforms to the NABARD norms of cost of warehouse construction @ of Rs.1875/- per MT capacity. Cost of Grading Machine: The entire processing plant and machine (capacity 1 TPH on wheat basis) will be purchased from the Padsons Industries Pvt. Ltd at the cost of Rs.7.35 lacs which appears to be reasonable and acceptable to us. Cost of Weighbridge :A Kanan fully electronic weighbridge 50MT is proposed to be purchased from M/s Kanan Weighing system for Rs.6.38 lacs which seems to be fairly valued and acceptable to us. Construction Cost of Grading Shade, Weigh Structure, Tubewell, land development and boundary walls: We have discussed about the construction cost of the above with the Engineer and the cost of construction of above items of Rs.13.62 lacs appears to be reasonable as per the enquiries from the existing similar projects operating locally. ii) Means of Finance: Promoter's Contribution Subsidy through NABARD (Back end subsidy) Bank Term Loan Total: (Rs. In lacs) 32.49 17.10 34.20 83.80

Promoters Contribution in the Project: The promoter will contribute 38.77 % of the total project cost excluding land cost as per the 25% norms under the above NABARD Scheme. Subsidy: As per the new guidelines of NABARD that godown cost shall not be more than 50% of total financial outlay (TFO) so it is assumed that Godown cost is 49% of TFO i.e. 83.80*49% = 41.06 Now revised cost for subsidy purpose is Rs. 68.40 Lacs. Subsidy @ 25% = Rs.17.10 lacs The subsidy of Rs.17.10 lacs calculated is realistic. Banks Term Loan: Term loan of Rs.34.20 lacs as computed is as per the scheme. The bank will initially sanction a total term loan of Rs.51.30 lacs including the amount of the subsidy as it is back ended and will be adjusted in the term loan account at the expiry of the entire loan.

3.
Debt Equity Ratio: Debt to Equity Ratio in the above case is 1.50 when subsidy is also treated as debt and it is as per the standard norms of 3. Hence, it is acceptable to us. Promoters contribution in case of cost overrun: Promoter is capable of contributing additional investment in case of cost overrun & has consented to bear the amount if cost overrun than the projections. Working Capital : There is no requirement of working Capital in the project but any meager amount required will be contributed by promoter Project implementation Schedule: Building has been constructed up to plinth level and walls up to the lintel have been completed. Necessary permission for construction has been received from the Gram Panchayat Vill Hatoda Diversion of agriculture land vide Case No.75A02/10-11 dated 24.06.2011 has been obtained from SDM Court. Promoter has invested his contribution as on date. Market: As described earlier, Village Hatoda, Bareth Road which is a good centre for this type of post-harvest management/marketing service business & due to their existing business of M/s Mini Agencies they had a good customer base in the surrounding area among farmers which they intend to encash in the present project. Nowadays due to better Agronomic practices & Farm Management adapted by the farmers the production of cereals, pulses and grains are increasing every year as such providing this type of facility in the area will enable the promoter to utilize installed capacity easily. This facility will also enable the farmers to sell their produce at remunerative prices and avoid distress sales. Economic Viability: Economic viability of the project has been computed on the assumptions of capacity utilization of 75% in first year, 80% in second year and 85% in third year, 90% fourth year onwards for Godown & the Grading machine has been assumed to work at 50% (first year) and 60% from second year onwards after discussion with the promoter and the promoters of similar units presently operating locally. Projected Profitability and DSCR, Cash Flow , Balance Sheet, IRR and Credit Rating have been computed in annexure I, II, III & IV respectively. Financial indicators of the unit are as follows. Average Gross DSCR: Projected Average Gross DSCR of the unit is 2.77. This is well above the standard norms and therefore it is acceptable to us.
Particulars Y-0 Y1 Y2 -3.08 4.01 Profit after Tax Add: Depreciation 0 3.14 Add: Intt on Loan 3.08 4.02 Total(A) 0 11.17 Repayment of term loan 0 1.9 Add: Intt on Term loan 3.08 4.02 Total(B) 3.08 5.92 DSCR (A/B) 0.00 1.89 Average DSCR 2.77 Y3
8.54 4.03 3.78

Y4
9.77 3.83 3.51

Y5

Y6

Y7

Y8
11.85 3.12 2.06

Y9

Y10
13.14 2.82 1.03 13.3 2.68 0.89

11.04 11.68 11.23 3.64 3.46 3.28 3.21 2.87 2.49

12.48 2.96 1.58

16.35
2.14 3.78

17.11
2.4 3.51

17.89 18.01
2.71 3.21 3.05 2.87

17
3.43 2.49

17.03
3.86 2.06

17.02
4.34 1.58

16.99
4.89 1.03

16.87
5.5 0.89

5.92 2.76

5.91 2.90

5.92 3.02

5.92 3.04

5.92 2.87

5.92 2.88

5.92 2.88

5.92 2.87

6.39 2.64

*Income tax have not been provided as 100% income is exempted from IT for a period of 5 years to the project and thereafter 70% of income is exempted from IT for the next five year. As clear from above, promoter has sufficient liquid surplus to meet out unforeseen expenditure and can easily repay bank's term loan installments as well as interest in phased manner

4.
Cash Flow Statement: Net cash generated each year has been given as under. It is evident from the following table that the unit has sufficient cash to repay the loan.
PARTICULARS Net cash generated Y-0
-

Y1
3.3 6

Y2
10.4 4

Y3
11.2 0

Y4
11.98

Y5
12.10

Y6
12.20

Y7
11.1 7

Y8
11.17

Y9
11.14

Y10
10. 49

Break Even Point (BEP) Analysis : The unit will break even in the first year itself with a safety margin of minimum 32.85 % & the BEP as computed in the project report is acceptable to the bank. Internal Rate of return : The IRR of the unit is 36.25 % which is above the stipulated norms of 15% & hence acceptable to the bank. Family Concern : The firm is having two more business namely M/s Mini Agencies prop Smt. Savita Samaiya & M/s Mini Traders prop Shri A.K. Samaiya. Other Financial liabilities: S.N .
1 2.

FI
Nagrik Bank Basoda

Type of loan
CC

Particular
M/s Mini Agencies

Date of sanction
22.12.2008

Sanction Amt.
Rs.7.00 lacs Rs.5.00 lacs

Present O/s
Rs.7.33 lacs Rs.5.05 lacs

Status IRAC
Regular & Standard Asset*

Nagrik Bank CC M/s Mini 22.12.2008 Basoda Traders * Branch to obtain opinion report from existing bankers.

Managerial Competency :The above unit will be managed & controlled by promoter himself & her husband both have good experience of running various type of business. Credit Rating :As per the credit policy of bank ,the methodology adopted for Credit rating is as followed in Sponsor bank (SBI) similar loan appraisal. The credit rating is at SBTL - which denote good safety & acceptable bankable risk in the venture. Special Terms & Conditions for Term Loan Rs. 51.30 lacs: Security: A) Primary - 1) Hypothecation of Grading Machine, Weigh bridge etc. 2) EM of 0.627 Hact. land and proposed Warehouse building S.N.
1.

Particulars
EM of land 0.627 hact. diverted land part of survey no.410/3/1/1 P.H No.24/42 and proposed Warehouse Godown at village Hatoda Teh.Ganj Basoda Distt. Vidisha owned by Smt Savita Samaiya TOTAL:

Market Value
Rs. 130.00 lacs (Value of land) Rs.130.00 lacs

Nature of Charge
EM

B) S.N.
1

Collateral Security: Particulars

EM of double story residential house situated at W-7 House No. 728 Near SDO Residence Bareth Road Ganj Basoda Vidisha, Plot size aprox. 1500 sq .ft. owned by Smt Savita Samaiya bounded by E- Bareth Road, W- Gali, N- H/o Shri Samaiya ,S- H/o Smt Rukmini Bai TOTAL:

Market Value
Rs. 48.00 lacs

Nature of Charge
EM

Rs. 48.00 Lacs *

* Valuation by approved valuer dated 25.09.2011

5.

C.

Guarantee: Third party Guarantee of Shri Amresh Kumar Samaiya s/o Shri S. K. Samaiya R/o W-7 House No. 728 Near SDO Residence Bareth Road Ganj Basoda Vidisha having networth of Rs.60.00 lacs as per branch opinion report dated 07th Oct 2011 Margin Subsidy Interest Period of Sanction : 38.77 % : 25% (Back end subsidy) : 12.00% p.a. With monthly rests : 10.5 years including moratorium period

D. E. F. G. H.

Repayment Schedule: 120 EMI of Rs,49067.00 with start up period of 6 Months from the date of first disbursement made or completion of project whichever is earlier. Interest & other charges during start up period to be paid on applied basis. I. Inspection : Quarterly by Branch Manager J. Insurance : For full value with usual bank's clause to cover usual risks at the Borrowers cost. Other Terms & Condition 01. 02. 03. 04.
5.

06. 07. 08. 09. 10. 11. 12. 13. 14. 15. 16. 17.

The terms and conditions of sanction be conveyed in duplicate to the Borrower and Guarantor and obtain their acknowledgement on the duplicate copy and keep it with the security documents. All the documents obtained must be stamped as per rates prescribed in State Stamp Act. Recover processing & other charges as per instructions. Please inspect the properties proposed to be mortgaged and keep it with the inspection report along with security documents. Please take full precaution, to prevent damage to the goods by fire/ water/ moisture/ dampness/White ants/ rusting etc. The security offered to the Bank should be outside the purview of the charge of any other Bank or Financial Institution. Please ensure that the borrowers deal exclusively with our Bank. Bank will have the right to publish the name of borrower/guarantor in case of default. Disbursement shall be made as per progress of work and report of each inspection kept with loan document Branch Manager must ensure the end use of fund after verification of bills and inspection during stages of construction. A detailed report of each inspection shall be prepared and kept with loan document. Ensure valid Equitable Mortgage is created and also follow the suggestions / observations made by the advocate in his title search report Please also refer HO/Cir/ 27 /09 dated 17.08.09 and accordingly please ensure register of EM with the Sub-Registrar. Please ensure compliance of KYC norms Please obtain SME series document. Please ensure to obtain an undertaking that in case subsidy is not received the borrower & guarantor are liable to pay the full amount including subsidy. Please obtain an undertaking from the applicant/borrower that they are not related to any of the Board of Directors & staff members of the bank. A CA certificate should be obtained to this effect that the applicant/borrower has already invested his share of margin money.

6. Recommendation:

It is well known that the small farmers neither have the economic strength to retain the produce with themselves till the markets prices are favorable nor they have the facility to standardize their produce to fetch good prices in the market. There is large gap between demand & supply as during harvest season there always remain lack of space in godowns as such ample scope of rural godowns is always felt in the area. The grading plant will help in value addition of agriculture produce for storage & weighing machine will able farmers to sell the goods with proper weight at warehouse itself. Smt. Savita Samaiya w/o Shri A.K. Samaiya proprietor of M/s Mini Warehouse, although are new to our bank but are well known & established in Ganj Basoda with very large means.The IRR of the project is at 36.25% which is similar to this type of project in vicinity. Keeping in view the Economic viability & technical feasibility of the project, applicants worth , security offered by them & Branch Managers recommendation, We recommend for sanction a Term loan of Rs. 51.30 lacs (including back end subsidy Rs. 17.10 lacs). Thus total liability excluding subsidy shall be Rs.34.20 lacs, which is covered by collateral securities of Rs.48.00 lacs apart from the value of land in primary security which itself is worth Rs.130.00 lacs Recommended for sanction Rs.51.30 lacs (Rs. Fifty One Lacs Thirty Thousands only)

Senior Manager (Credit) Sanctioned as recommended Rs.51.30 lacs (Rs. Fifty One Lacs Thirty Thousands only)

General Manager Submitted for control to the Chairman.

General Manager

Annexure I

Estimates of Probable Profits & DSCR.

PARTICULARS
Storage Capacity (MT) Capacity UtilisatIon ( Rs. 3.50 per qt.*12month*10) INCOMES

Y-0
0%

Y1
3,000 75% 7.0

Y2
3,000 80% 10.2 8 2.0 3.3 7 1.6 2.3 6 2.6 3.5 7

Y3
3,000 85% 11.1 4 3.4 3 2.4 8 3.5 2

Y4
3,000 90% 12.0 3 3.5 0 2.6 0 3.4 6

Y5
3,000 90% 12.2 7 3.5 7 2.7 3 3.4 0

Y6
3,000 90% 12. 52 3. 64 2. 87 3. 32 22. 36

Y7
3,000 90% 12. 77 3. 72 3. 02 3. 24 22. 74 0. 76 0. 0. 42 2. 2. 44 0. 0. 07 0. 0. 14 0. 0. 16 0. 0. 25 0. 0. 29 3. 3. 12 15. 08 2. 06 13. 02 1. 17 11. 85 2. 88

Y8
3,000 90% 13.0 3 3.7 9 3.1 7 3.1 5 23.1 3 0.8 0 0.4 4 2.6 9 0.0 7 0.1 5 0.1 6 0.2 5 0.3 0 2.9 6 15.2 9 1.5 8 13.7 2 1.2 3 12.4 8 2. 88

Y9
3,000 90% 13.2 9 3.8 7 3.3 2 3.0 5 23.5 2 0.8 4 0.4 7 2.9 6 0.0 7 0.1 6 0.1 6 0.2 5 0.3 2 2.8 2 15.4 8 1.0 3 14.4 4 1.3 0 13.1 4 2.8 7

Y10
3,000 90% 13. 55 3. 94 3. 49 2. 94 23. 92 0. 88 0. 49 3. 25 0. 08 0. 16 0. 16 0. 38 0. 34 2. 68 15. 50 0. 89 14. 61 1. 32 13. 30 2. 64

(Rs. In Lacs) 9 6 9 3 13.4 6 0.3

Gross rentals from storage Income from Grading Income from Weighbridge Income from trans. & Handling GROSS INCOME LESS: DIRECT COST

19.5 8 0.6 0 3 0.3 3 5 1.5 2 7 0.0 5 6 0.1 0 1 0.1 6 6 0.2 5 5 0.2 1 3 4.0 3 3 12.3 2 9 3.7 8 1 8.5 4 7 8.5 4 7 2.7 6 2. 89 8

20.5 0 0.6 6 0.3 6 1.6 4 0.0 6 0.1 2 0.1 6 0.2 5 0.2 5 3.8 4 13.2 6 3.5 1 9.7 4

21.6 8 0.6 9 0.3 8 1.8 2 0.0 6 0.1 3 0.1 6 0.2 5 0.2 6 3.6 6 14.2 6 3.2 7 11.0 8 -

21.9

0.6 73 0.3 40 2.0 22 0.0 07 0.1 13 0.1 16 0.2 25 0.2 28 3.4 28 14.5 83 2.8 49 11.6 34 11.6 8 23 3.0 4 7 11

0.

Power and Fuel Labour exp. For Grading LESS : EXPENDTURE

6 0.2 4 1.0

Salaries Fumigation and other Preservation exp. Dunnage and cleaning exp. Maintenance of Structure(0.5% of cost of Fixed Assets) Insurance Exp. (@ Rs. 8.25 per MT per annum) Other operational Exp. Depreciation Operating Profit Financial Charges (Intt. Etc) Profit Before Tax Provision for Taxes Profit After Tax DSCR Average DSCR

3.08 -3.08 -3.08 -

4 0.0 4 0.0 7 0.1 6 0.2 5 0.1 4 3.1 4 8.0 3 4.0 2 4.0 1 4.0 1 1. 89 77

14. 2. 12. 1.

9.7 4 2. 2

11.0 3.0

11. 2.8

Annexure II

Projected Cash Flow

PARTICULARS
Cash from operating activities

Y-0

Y1
4.0

Y2
8.5 4 3.1 4.0 3 7.1 12.5 7 -

Y3
9.7 7 3.8 3 13.6 1 0.00 13.6 1

Y4
11.0 4 3.6 4 14.6 8 0.00 14.6 8

Y5
11.6 8 3.4 6 15.1 4 0.00 15.1 4

Y6

Y7

Y8
12.4

Y9
13.1 4 2.9 2.8 2 1.2 1.3 0

Y10

Net profit as per P/L A/c Add: Depreciation Income Tax Provided for Net cash generated from operations Less: Income Taxes Paid Increase/decrease in net Working Capital Net cash from operating activities Cash from investing activities Net increase in Fixed Assets Back Ended Subsidy ( Deposit) Security Deposit(MPEB) Net cash from investing activities

-3.08 0 (3.0 8)

1 4 5 -

11.23 3.28 1.11 15.63 0.00 -

11.85 3.12 1.17 16.14 (1.1 1) 0.00 -

8 6 3 16.6 8 (1.1 7) 0.00 15.5

13.30 2.68 1.32 17.2 17.29 (1.30 ) 0.00 16.0

6 (1.2 3) 0.00 -

3.08 -

-1.60

0.00 -

5.5 5 7

12.5

15.63

15.03

15.99

(83.8 0) (17.1 0) (0.3 0) (17.4 0)

17.10

17.10

Net cash from financing activities 32.4 Net capital introduced 9 17.1 Subsidy Long Term loans ( including Subsidy) 51.3 0 (1.9 Repayment of loans Net cash generated from fi83.8 nancing activities 0 Total cash generated (A, B, and C) Add: Opening balance of cash and cash equivalents Cl. balance of cash and bank 0) 15.2 0 3.3 6 3.3 6 9 ) ) 10.4 4 3.3 6 13.7 0

(2.7 1) (2.7 1) 11.9 8 25.0 0 36.9 7

(3.0 5) (3.0 5) 12.1 0 36.9 7 49.0 7

(3.4 3) (3.4 3) 12.20 49.07 61.27

(3.8 6) (3.8 6) 11.17 61.27 72.44

(4.3 4) (4.3 4) 11.1 7 72.4 4 83.6 1

(4.8 9) (4.8 9) 11.1 4 83.6 1 94.7 5 )

(22.60 (22.60 ) 10.49 94.75 105.23

(2.14 (2.14

(2.4 0) (2.4 0) 11.2 0 13.7 9 25.0 0

Projected Balance Sheet :

LIABILITIES OWNERS FUND CAPITAL A/C RESERVE & SURPLUS Net Profit during the year Net Profit previous year CAPITAL SUBSIDY BANK LOAN UNSECURED LOAN CURRENT LIABLITIES PROVISIONS Interest due but not paid 08 Installment due of term loan Provisions for Taxes TOTAL ASSETS FIXED ASSETS Gross Block Depreciation Net block INVESTMENT(Back Ended Subsidy) LOANS & ADVANCES Cash and Bank Balance Security Deposit (MPEB) TOTAL 83. 80 0.30 101.41 0 107.8 2 3.36 9 0.3 83. 80 3.14 80.65 17.10 3 76.6 2 17.1 0 13.7 0 0.3 0 115.1 9 0 25.0 7 0.3 0 123.5 2 9 17.1 0 36.9 7 0.3 0 132.1 6 08 30 141. 83. 80 Y-0 83. 80 3. 1.4 1.48 101.41 Y1 2 Y2 80.6 83.80 5 4.0 3 72.7 5 17.1 0 49.0 27 0. 2 3.8 4 69.1 9 17.1 10 61. 4 8 107.8 8 115.1 9 Y3 76.6 9 3.6 6 65.6 41 17. 0 1.4 8 123.5 2 Y4 72.7 5 3.4 28 62. 9 6 Y5 69.1 69 3. 2 1.4 8 132.1 1.4 48 1. 11 141. 08 Y6 65. 1 1. 8 51. 30 (3.08) 17.10 49.41 (3.0 8) 8.5 4.01 4 0.9 3 17.10 47.2 7 7 9.4 7 17.10 44.8 7 9.7 4 19.2 5 17.10 42.1 6 11.0 8 30.2 9 17.10 39.1 1 11.6 23 41. 98 17.10 35. 69 11. 5

Annexure III
Y1 Y2
32.4 32.49 9 9

Y-0
32. 49

Y3
32.4

Y4
32.4 9

Y5
32.4 9

Y6
32. 49

Y7
32.4 9 11.8

Y8
32.4 9 12.4 8 65.0 5 17.10 27.4 9 -

Y9
32. 49 13. 14 77. 54 17.10 22. 60 -

Y10
32. 49 13. 30 90. 68 17.10 -

53.2 1 17.10 31.8 3 -

1.4 8 1.1 7 149.1 3 Y7 62.4 9 3.1 6 59.2 2 17.1 0 72.4 1 0.3 0 149.1 3

1.4 48 1.2 3 157.3 3 Y8 59.2 32 2.9 82 56.3 51 17.1 10 83.6 75 0.3 0 157.3 3

1. 48 1. 30 165. 65 Y9 56. 51 2. 68 53. 83 17. 94. 0. 30 165. 65

1. 1. 32 156. 36 Y10 53. 2. 50.

105. 23 0. 30 156. 36

INTERNAL RATE OF RETURN

Total Outlay Rs. 83.80Lacs INTERNAL RATE OF RETURN

Net Cash inflows (PBDIT) P V factor at 36.50% Discounted cash flows 36.50%

19.3 7 0.73 14.1 9 1.36 5

66.51

25.21 0.54 13.53 1.365 0.54 13.63 1.36

27.2 0 0.39 10.7 0 1.36 5 0.40 10.8 1 1.36

27.94 0.29 8.05 1.365 0.29 8.17 1.36

28.7 1 0.21 6.06 1.36 5 0.21 6.17 1.36

29.51 0.15 4.56 1.365 0.16 4.66 1.36

30.3 4 0.11 3.44 1.36 5 0.12 3.53 1.36

31.20 0.08 2.59 1.365 0.09 2.67 1.36

32.12 0.06 1.95 1.365 0.06 2.02 1.36

32.6 5 0.04 1.45 1.36 5 0.05 1.51 1.36

Total NPV

P V factor at 36.00% Discounted cash flows 36.00%

Total NPV

0.74 14.2 4 1.36

67.40

36.25 % Total Ouflows at the beginningRs.83.80 Lacs Note : Cash inflows also includes Capital Subsidy of Rs 17.10 Lacs Internal rate of return (IRR)

Net outflows Rs. 66.69 Lacs

Annexure IV
Name of Unit : M/s MINI WAREHOUSE Term Loan : SME Credit rating based on financial statement as on 31.03.2012 Financial Risk Parameters Static Ratio Project Debt / Equity ratio TOL / TNW Gross average DSCR of the project Gross average DSCR for all Loans Terms of Repayment Sub-Total Score (out of 25) Risk Mitigation: Collateral Security/ Financial standing Sub-Total Score (out of 6) Aggregate Fin. Risk Score (Out of 31) Normalized Financial Risk Score (Out of 25) Business Risk Parameters Technology Capacity Utilization Vs. Break Even Point Compliance of Environment Regulations User /Product profile Consistency in Quality Distribution Network Consistency of Cash Flows Aggregate Business Risk Score (Out of 20) Normalized Business Risk Score (Out of 25) Industry Risk Parameters Competition Industry Outlook Regulation Risk Contemporary issues like WTO etc. Aggregate Industry Risk Score (Out of 8) Normalized Industry Risk Score (Out of 10) Management Risk Parameters Integrity : Sole proprietor firm / partnership firm / Pvt. Ltd. Companies or Integrity : Corporate Governance Track record Managerial Competence / Commitment Expertise Structure & System Experience in the Industry Credibility : Ability to meet sales projections Credibility : Ability to meet Profit (PAT) projections Payment record Strategic Initiatives Length of relationship with the Bank Aggregate Management Risk Score (Out of 25) Normalized Management Risk Score (Out of 40) Total Score Credit Risk Rating Value 1.50 1.50 2.88 2.88 Full marks 5 5 5 5 5 25 6 6 31 25
Full marks

Marks Obtained 5 5 5 5 0 20 6 6 26 20.97

Marks Obtained

4 2 2 2 4 2 4 20 25
Full marks

3.5 2 2 1.5 3.5 2 3.5 18 22.50

Marks Obtained

2 2 2 2 8 10
Full marks

1.5 1.5 1 1.5 5.5 6.88

Marks Obtained

3 3 3 2 2 2 2 2 2 2 2 25 40 100 SBTL -

3 2 3 1.5 1.5 0 1.5 1.5 1.5 1.5 2 19 30.40 80.75