MVR SEDPI Cash Flow Analysis (Final Form)

SEDPI Cash Flow Analysis
Branch*
Name

First NameLast Name
Position
Date of Interview*

MonthDayYear
Date
Member Name*

First NameLast Name
Client ID (Bijli ID)
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

Dept 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
Maximum JVC Possible
Monthly amortization
Weekly amortization
Email*
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

Dept Capacity Analysis

Joint Venture Capital