SEDPI Cash Flow Analysis (Member's only)

SEDPI Cash Flow Analysis
Branch
Name of Interviewer

First NameLast Name
Position
Date of Interview

MonthDayYear
2 digit month, 2 digit day, 4 digit yearDate
Member Name

First NameLast Name
Client ID (Bijli ID)
Upload Member's photo

Cancelof
How many Businesses?
Business 1
Kind of Business
Kind of Business

SALES TOTAL 1
Frequency of Sales
How many days in a week?
Average Monthly Sales
Enterprise Level
Net Income Margin
Business 1 Total Net Income

Rows	Amount
High
Low
Normal

Business 2
Kind of Business
Kind of Business

SALES TOTAL 2
Frequency of Sales
How many days in a week?
Average Monthly Sales
Enterprise Level
Net Income Margin
Business 2 Total Net Income

Rows	Input Value
High (30%)
Low (20%)
Normal (50%)

Business 3
Kind of Business
Kind of Business

SALES TOTAL 3
Frequency of Sales
How many days in a week?
Average Monthly Sales
Enterprise Level
Net Income Margin
Business 3 Total Net Income

Rows	Input Value
High
Low
Normal

Business 4
Kind of Business
Kind of Business

SALES TOTAL 4
Frequency of Sales
How many days in a week?
Average Monthly Sales
Enterprise Level
Net Income Margin
Business 4 Total Net Income

Rows	Input Value
High
Low
Normal

Business 5
Kind of Business
Kind of Business

SALES TOTAL 5
Frequency of Sales
How many days in a week?
Average Monthly Sales
Enterprise Level
Net Income Margin
Business 5 Total Net Income
NET BUSINESS INCOME

Rows	Input Value
High
Low
Normal

Household Income and Expenses
Household Location
How many Households member do you have?
Household Members
Household member 1 Name

First NameLast Name
Relationship
Age
Household member 2 Name

First NameLast Name
Relationship
Age
Household member 3 Name

First NameLast Name
Relationship
Age
Household member 4 Name

First NameLast Name
Relationship
Age
Household member 5 Name

First NameLast Name
Relationship
Age
Household member 6 Name

First NameLast Name
Relationship
Age
Household member 7 Name

First NameLast Name
Relationship
Age
Household member 8 Name

First NameLast Name
Relationship
Age
Household member 9 Name

First NameLast Name
Relationship
Age
Household member 10 Name

First NameLast Name
Relationship
Age
Electric Barrio
Electric Centro
ELECTRIC TOTAL
Water Barrio
Water Centro
Water TOTAL
Transpo 1
Transpo 2
Transpo 3
Transpo 4
Transpo 5
Transpo 6
Transpo 7
Transpo 8
Transpo 9
TRANSPO TOTAL
Mobile Load Barrio 1
Mobile Load Barrio 2
Mobile Load Barrio 3
Mobile Load Barrio 4
Mobile Load Barrio 5
Mobile Load Barrio 6
Mobile Load Barrio 7
Mobile Load Barrio 8
Mobile Load Barrio 9
Mobile Load Barrio 10
LOAD BARRIO TOTAL
Mobile Load Centro 1
Mobile Load Centro 2
Mobile Load Centro 3
Mobile Load Centro 4
Mobile Load Centro 5
Mobile Load Centro 6
Mobile Load Centro 7
Mobile Load Centro 8
Mobile Load Centro 9
Mobile Load Centro 10
LOAD CENTRO TOTAL
MOBILE LOAD TOTAL
Household Occupation
Member 1 Name

First NameLast Name
With IGA
Member 2 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Member 3 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Member 4 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Member 5 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Member 6 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Member 7 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Member 8 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Member 9 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Member 10 Name

First NameLast Name
With IGA
IGA Details
IGA Details
IGA Details
Students in the Household
Member 1 Name

First NameLast Name
Level
Private or Public
Member 2 Name

First NameLast Name
Level
Private or Public
Member 3 Name

First NameLast Name
Level
Private or Public
Member 4 Name

First NameLast Name
Level
Private or Public
Member 5 Name

First NameLast Name
Level
Private or Public
Member 6 Name

First NameLast Name
Level
Private or Public
Member 7 Name

First NameLast Name
Level
Private or Public
Member 8 Name

First NameLast Name
Level
Private or Public
Member 9 Name

First NameLast Name
Level
Private or Public
Member 10 Name

First NameLast Name
Level
Private or Public
ELEMENATARY PRIVATE 1
ELEMENATARY PRIVATE 2
ELEMENATARY PRIVATE 3
ELEMENATARY PRIVATE 4
ELEMENATARY PRIVATE 5
ELEMENATARY PRIVATE 6
ELEMENATARY PRIVATE 7
ELEMENATARY PRIVATE 8
ELEMENATARY PUB 1
ELEMENATARY PUB 2
ELEMENATARY PUB 3
ELEMENATARY PUB 4
ELEMENATARY PUB 5
ELEMENATARY PUB 6
ELEMENATARY PUB 7
ELEMENATARY PUB 8
HS PRIVATE 1
HS PRIVATE 2
HS PRIVATE 3
HS PRIVATE 4
HS PRIVATE 5
HS PRIVATE 6
HS PRIVATE 7
HS PRIVATE 8
HS PUB 1
HS PUB 2
HS PUB 3
HS PUB 4
HS PUB 5
HS PUB 6
HS PUB 7
HS PUB 8
COL PRIVATE 1
COL PRIVATE 2
COL PRIVATE 3
COL PRIVATE 4
COL PRIVATE 5
COL PRIVATE 6
COL PRIVATE 7
COL PRIVATE 8
COL PUB 1
COL PUB 2
COL PUB 3
COL PUB 4
COL PUB 5
COL PUB 6
COL PUB 7
COL PUB 8
EDUCATION TOTAL

Income of Household Members
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Name

First NameLast Name
IGA
Monthly Income
Sub-total
Other Household Income
Note: If any, include monthly remittance, allowance, 4Ps, or other household Income.
4Ps/Ayuda
Isama ang iba pang monthly ayuda kung meron
4Ps/Ayuda
Isama ang iba pang monthly ayuda kung meron
Allowance from family member
Allowance from children or other relatives
Allowance from family member
Allowance from children or other relatives
OFW Remittance
Remittance from Overseas
OFW Remittance
Remittance from Overseas
Other Income 1
Please identify
Monthly Amount
Other Income 2
Please identify
Monthly Amount
Sub-total
Total Household Income

Household Expenses
Rent Monthly
Medical Monthly
Insurance Monthly
Loan Monthly
Monthly Remittance Amount
Food Monthly
Education Monthly
Transportation Monthly
Electricity Monthly
Water Monthly
Mobile Load Monthly
Sub-total
Emergencies (10)%
Monthly Expenses

Debt Capacity Analysis
Number of JVC Cycle
Member Classification
JV Term (In months)
Joint Venture Capital
Net Business Income
Other Household Income
Household Expenses
Net Household Cash Flow
JV Term
Maximum JV Amount
Adjusted Debt Capacity Rate
Adjusted Debt Capacity Amount
Service fee rate 20%
Maximum JVC Possible
Monthly amortization
Weekly amortization
Upload Cashflow hardcopy

Cancelof
Email (SEDPI Staff)
Please enter your email to receive a copy of the submitted form.
Type a question
Should be Empty:

SEDPI Cash Flow Analysis

Business 1

Business 2

Business 3

Business 4

Business 5

Household Income and Expenses

Household Members

Household Occupation

Students in the Household

Income of Household Members

Other Household Income

Household Expenses

Debt Capacity Analysis

Joint Venture Capital