MFI INPUT FORM
INCOME STATEMENT(during current period)
INCOME
Y01 Interest income from loans
Y02 Fee income from loans
Y03 Income from investments
Y04 Other operating income
Y05 TOTAL operating income
EXPENSES
Financing Expenses
Y06a Interest and fees paid on market debt
Y06b Interest and fees paid on subsidized debt
Y07b Interest paid on compulsory savings
Y10 TOTAL financing expenses
Y11 GROSS FINANCIAL MARGIN
Y12 Provision for loan losses
Y13 NET FINANCIAL MARGIN
Operating Expenses
Y14a Personnel expenses
Y14b Governance costsS
Y15a Rent and utilities (administrative expenses)
Y15b Travel and transport (administrative expenses)
Y15c Stationery and office supplies (administrative expenses)
Y16 Depreciation
Y17 Other operating costs
Y18 TOTAL operating expenses
PROFIT/ LOSS
Y19 TOTAL EXPENSES
Y20 NET INCOME FROM OPERATIONS
Y21 Income from non-financial services
Y22 Expenses from non-financial services
Y23 Net income from non-financial services
Y24 Income taxes
Y25 NET INCOME AFTER TAXES
Y26 Grant income for loan capital
Y27 Grant income for operations
Y28 Total grants received
Y29 NET INCOME AFTER TAXES AND GRANTS FOR THE PERIOD
BALANCE SHEET (at end of period)
ASSETS
Current Assets
B01 Cash
B02 Deposits in financial institutions
B03 Short-term investments
B04 Gross loan portfolio
B05 (Loan loss reserve)
B06 Net loan portfolio
B07 Other short-term assets
B08 TOTAL current assets
Non-Current Assets
B09 Long-term investments
B10 Fixed assets
B11 (Accumulated depreciation)
B12 Net fixed assets
B13 Other long-term assets
B14 TOTAL non-current assets
B15 TOTAL ASSETS
LIABILITIES
Current Liabilities
B16 Compulsory savings
B19 TOTAL short-term deposits
B20 Short-term debt (market rate)
B21 Short-term debt (subsidized rate)
B22 Loans from the central bank
B23 Other current liabilities
TOTAL current liabilities
Non-Current Liabilities
B26 Long-term debt (market rate)
B27 Long-term debt (subsidized rate)
B28 Deferred income or restricted funds
B29 Other long-term liabilities
B30 TOTAL non-current liabilities
B31 TOTAL LIABILITIES
EQUITY
B32 Capital from shareholders or member shares
B33 Donated equity
B34 Reserves
B35 Retained surplus/(deficit) current year
B36 Retained surplus/(deficit) prior years
B37 Retained surplus/(deficit)
B38 Other capital accounts
B39 TOTAL EQUITY
B40 TOTAL LIABILITIES AND EQUITY
PORTFOLIO AND OUTREACH
Portfolio Activity
A01 Value of loans disbursed (during period)
A02 Number of loans disbursed (during period)
A04 Number of loans fully repaid (during the period)
A05 Value of loan payments received (during the period)
A06 Number of clients receiving loans as individuals, excluding group loans (end of period)
A07 Number of outstanding loans (end of period)
A08 Value of outstanding loans (end of period)
Outreach (individuals and members of groups)
A09 Total number of active borrowers (individuals and members of groups) (end of period)
A10a Number of borrowers with income below poverty line (individuals and members of groups) (end of period)
A10b Number of outstanding loans below poverty line (end of period)
A10c Value of outstanding loans to clients below poverty line (end of period)
A11a Number of borrowers in the agriculture sector (individuals and members of groups) (end of period)
A11b Number of outstanding loans in the agriculture sector (end of period)
A11c Value of outstanding loans in the agriculture sector (end of period)
A12a Number of female borrowers (individuals and members of groups) (end or period)
A12b Number of outstanding loans to female borrowers (end or period)
A12c Value of outstanding loans to female borrowers (end of period)
Savings (individuals and members of groups)
A14 Number of savings accounts (end of period)
A15 Total number of savers (individuals and members of groups) (end of period)
A16a Number of clients with compulsory savings (individuals and members of groups) (end of period)A
A16b Value of compulsory savings (end of period)
Portfolio Quality
A20 Value of arrears (principal plus interest) (end of period)
A23 Number of loans in arrears > 30 days (end of period)
A24 Value of outstanding loan balance with arrears > 30 days (PAR) (end of period)
Ageing of Portfolio At Risk (PAR)
A25 Value of outstanding loan balance with arrears by age of arrears (end of period)
A25a 1 - 30 days
A25b 31 - 60 days
A25c 61 - 90 days
A25d 91 - 180 days
A25e > 180 days
Write offs
A26 Amount written off (during period)
A27 Number of loans written-off (during period)
Dividends and Exchange Gains/(Losses)
A29 Foreign exchange gains/(losses) (end of period)
Human Resources
A35 Total number of staff in the head office (end of period)
A36 Total number of staff in branches (end of period)
A37 Total number of loan officers in head office and branches (end of period)
A38 Number of branches (end of period)
Miscellaneous
A39a Nominal lending rate (end of period) (%)
A39b Effective lending rate (end of period) (%)
A40 Effective repayment rate (end of period) (%)
Economic Indicators Uganda (annual)
MIR Market interest rate in %
SBFR Subsidized borrowed funds rate in % (weighted average)
LAIR Inflation rate in % (headline)
GNI GNI per capita