All expense and income details should be available in the document
http://spreadsheets.google.com/pub?key=p
This blog gives investment details of S3IDF Bangalore investments since July 07. The details are mainly investment description and the final cash flows. The summary sheet of the blog entries can be found in the 'document tracker' document which appears as a label in the blog
This project is to provide LPG connection financing to the members of Chaitanya MFI. Till the end of October 07, Chaitanya had 105 members. Of this 30 members require LPG connection financing as of end October 07. This need is expected to rise. Although there is a huge demand for LPG, supply of new connections is not always available. The local dealer releases small no. of connections once in a while. For customers to avail this window of opportunity they need to have the financing readily available to pay and get it. Loans from banks are generally slow and within the time the loan is sanctioned, the window of opportunity is lost.
Chaitanya MFI will give its customers, individual loans of size Rs. 3000 for a period of 50 weeks charging an interest of 15% flat. As of end October 30 customers are already existing. Within the next one month, another 20 are expected to be given LPG loans. In the next year another 50 are expected to be given LPG loans.
Project Financials
http://spreadsheets.google.com/pub?key=p
This project is LPG connection financing for 50 customers in the first year and another 50 customers in the second year
The project will provide LPG for cooking to 100 households in 2 years. For the 100 households they will get a clean and convenient option for cooking.
Total Costs – Rs. 4835
Partner costs
Returns for S3IDF Revolving Fund
8% flat annual returns;
15% actual returns
Investment indicators:
Investment size – Rs. 150000
Revolving fund – Rs. 150000
RF to investment size –1
Total pre investment cost – Rs. 4835
Pre investment cost/Investment Ratio – 3%
No. of direct beneficiaries – 100 (over 2 years)
Investment size /no. of beneficiaries –Rs. 1500
Project Owner/operator risk:
The operator is Chaitanya microfinance. This is a new microfinance institution. So there is a risk associated with a new comer. However, Chaitanya has done multiple projects with S3IDF and their repayments have had no problems. Hence this is not such a big risk.
Market risk: There is no market risk
Technology risk: There is no technology risk
Portfolio risk: There is no portfolio risk
Mission risk: There is no mission risk
Chaitanya Foundation, Indane dealer at Chalakere
A75w. Expansion of LPG connection financing in Nayakanahatti, Chitradurga District, Karnataka
Implementation start: Jan 08
Project Photos
The financing will be done through Chaitanya MFI. Chaitanya MFI will give its customers, individual loans for the LPG connection for a period of 50 weeks charging an interest of 15% flat.
http://spreadsheets.google.com/pub?key=p
Project Size Details
The size of the project will be as follows:
| Location | Number | Price of 1 connection | Total cost |
| Nayakanahatti | 50 | 3000 | 150000 |
| Jaglur | 20 | 5000 | 100000 |
| Kanahosalli | 10 | 5000 | 50000 |
| Total | | | 300000 |
The project will provide LPG for cooking to 80 households. The impact of the project will be access of LPG cooking to 80 poor households.
Total Expected Costs – Rs. 7670
S3IDF costs
Personnel costs – Rs. 1670
Partner costs
Returns for S3IDF Revolving Fund
8% flat annual returns;
15% actual returns
Investment indicators:
Investment size – Rs. 300000
Revolving fund – Rs. 300000
RF to investment size –1
Cost Indicators
Total pre investment cost – Rs. 7670
Pre investment cost/Investment Ratio – 3%
No. of direct beneficiaries – 80
Investment size /no. of beneficiaries – Rs. 3750
Project Owner/operator risk:
The operator is Chaitanya microfinance. This is a new microfinance institution. So there is a risk associated with a new comer. However, Chaitanya has done multiple projects with S3IDF and their repayments have had no problems. Hence this is not such a big risk.
Market risk: There is no market risk
Technology risk: There is no technology risk
Portfolio risk: There is no portfolio risk
Mission risk: There is no mission risk
Chaitanya, local LPG suppliers in Nayakanahatti, Jaglur and Kanahosalli
| A75u - List of LPG connections | | ||
| | Name | Location | Amount given |
| Members made in the month of October 07 | |||
| 1 | Thippamma | Nayakanahatty | 3000 |
| 2 | Manjula | Nayakanahatty | 3000 |
| 3 | Gowramma | Nayakanahatty | 3000 |
| 4 | Manjula | Nayakanahatty | 3000 |
| 5 | Nagarathnamma | Nayakanahatty | 3000 |
| Members made in the month of November 07 | |||
| 6 | Anusuyamma | Nayakanahatty | 3000 |
| 7 | Jayalakshmi | Nayakanahatty | 3000 |
| 8 | Manjamma | Nayakanahatty | 3000 |
| 9 | Haseena | Nayakanahatty | 3000 |
| 10 | Noorunnisa | Nayakanahatty | 3000 |
| 11 | Thippamma | Nayakanahatty | 3000 |
| Members made in the month of December 07 | |||
| 12 | Nagaveeni | Nayakanahatty | 3000 |
| 13 | Naveeda | Nayakanahatty | 3000 |
| 14 | Faijunnisa | Nayakanahatty | 3000 |
| 15 | Haseena | Nayakanahatty | 3000 |
| 16 | rahamath Bi | Nayakanahatty | 3000 |
| 17 | Vishalakshi | Nayakanahatty | 3000 |
| 18 | Gangamma | Nayakanahatty | 3000 |
| 19 | Sunandamma | Nayakanahatty | 3000 |
| 20 | Jayamma | Nayakanahatty | 3000 |
| 21 | Mallamma Sp | Nayakanahatty | 3000 |
| 22 | Nandini | Nayakanahatty | 3000 |
| 23 | Thasleem | Nayakanahatty | 3000 |
| 24 | Shaheena | Nayakanahatty | 3000 |
| 25 | Papakka | Nayakanahatty | 3000 |
| 26 | Mamthaj Begam | Nayakanahatty | 3000 |
| 27 | Sunanda | Nayakanahatty | 3000 |
| 28 | Manjula | Nayakanahatty | 3000 |
| 29 | Thippamma | Nayakanahatty | 3000 |
| 30 | Vanajakshamma | Nayakanahatty | 3000 |
| 31 | Manjamma | Nayakanahatty | 3000 |
| 32 | Vasanthamma | Nayakanahatty | 3000 |
| 33 | Renukamma | Nayakanahatty | 3000 |
| 34 | Anusuyamma | Nayakanahatty | 3000 |
| 35 | Shilpa | Nayakanahatty | 3000 |
| 36 | Sharadamma | Nayakanahatty | 3000 |
| 37 | Sunandamma | Nayakanahatty | 3000 |
| 38 | Julzar Banu | Nayakanahatty | 3000 |
| 39 | Sapurabi | Nayakanahatty | 3000 |
| 40 | Thaheer banu | Nayakanahatty | 3000 |
| 41 | Sreemathamma | Nayakanahatty | 3000 |
| 42 | Manjulamma | Nayakanahatty | 3000 |
| 43 | Bhagyamma | Nayakanahatty | 3000 |
| 44 | Vijayamma | Nayakanahatty | 3000 |
| 45 | Vanajakshi | Nayakanahatty | 3000 |
| 46 | Nethramma | Nayakanahatty | 3000 |
| 47 | Abida banu | Nayakanahatty | 3000 |
| 48 | Husen Bi | Nayakanahatty | 3000 |
| 49 | Mubina Banu | Nayakanahatty | 3000 |
| 50 | Neelamma | Nayakanahatty | 3000 |
| Total | | | 150000 |
Project Approval Document – May 12, 2008
This project follows A75u and A75w – LPG connection financing at Nayakanahatti and Jaglur. Through A75u and A75w 125 households have been given LPG connection financing. The connections have been given through S3IDF infrastructure shops. The financing will be done through Chaitanya MFI. Chaitanya MFI will give its customers, individual loans for the LPG connection for a period of 50 weeks charging an interest of 15% flat. There is an additional requirement for 150 LPG connections at Jaglur, however Chaitanya MFI is targeting giving 40 connections only due to the lack of funds. The total project cost for giving LPG connections to 40 households is Rs. 200000. Of this Rs. 100000 will be the contribution from Chaitanya Foundation and Rs. 100000 is the support required from S3IDF.
The size of the project will be as follows:
| Location | Number | Price of 1 connection | Total cost |
| Jaglur | 40 | 5000 | 200000 |
The project will provide LPG for cooking to 40 households. The impact of the project will be access of LPG cooking to 40 poor households.
Total Expected Costs – Rs. 5340
Partner costs
Returns for S3IDF Revolving Fund
8% flat annual returns;
15 % returns on a reducing balance method
Investment indicators:
Investment size – Rs. 200000
Revolving fund – Rs. 100000
RF to investment size – 50%
Total pre investment cost – Rs. 5340
Pre investment cost/Investment Ratio – 3%
No. of direct beneficiaries – 40
Investment size /no. of beneficiaries – Rs. 5000
Project Owner/operator risk:
The operator is Chaitanya microfinance. This is a new microfinance institution. So there is a risk associated with a new comer. However, Chaitanya has done multiple projects with S3IDF and their repayments have had no problems. Hence this is not such a big risk.
Market risk: There is no market risk
Technology risk: There is no technology risk
Portfolio risk: There is no portfolio risk
Chaitanya, local LPG suppliers in Jaglur