You have been recently engaged as the Chief Executive Officer (CEO) of a microfinance Institution (MFI). You are expected to do a presentation to the board of the directors of the MFI on the financial health and performance of the institution. You found the need to explain The relevant concepts used for the evaluation of MFIs in order to facilitate the appreciation of The issues by your audience. The content of the presentation shall form the basis of the Strategic plan currently being considered. (Use the data the provided in excel in the column Assigned to your index number). You are required to: a) Provide an asyessment of the financial health and performance of the MFI using the data Extracts from income statements and balance sheet of the microfinance institution (MFI) that Have assigned to you. (35 Marks) b) Make recommendations based on your analysis which will be used for the crafting of the Strategic plan for the MFI. ASSETS 52,175.90 Cash on hand Balances in current accounts with bank/Fin Inst (Schedule A) Balances in savings account with banks/Fin inst Money on call with banks/fin inst Placement with banks/fin inst (Schedule B) Cash and short term funds ( sum 1 to 5) GOG/BOG Securities (Schedule B) Loans and Advances (net) (Schedule C) Other Assets (Schedule D) Property, Plant and Equipment (net) Total Assets CAPITAL AND UABILITIES Paid up capital Redeemable Preference Shares Reserves OWN FUNDS/SHAREHOLDERS' FUNDS Borrowings ( Schedule E) Deposits from the public ( Schedule F) 589,128.46 0.00 0.00 600,287.06 1,241,591.42 0.00 6,429,379.50 30,369.96 430,991.32 8,132,332.20 2,086,000.00 0.00 3,384,040.59 5,470,040.59 279,950.00 1,831,778.07 Other Liabilities Schedule G) Total Liabilities Shareholders' Funds and Total Liabilities 550,563.54 2,662,291.61 8,132,332.20 600,287.06 7,029,666.56 2,111,728.07 Net Difference (A-B) Short Term Investments (4+5+7) Earning Assets (3+4+5+7+8) Interest Bearing Liability (15+16) Percentage Share of Total Assets Percentage Share of Total Loan & Advances Percentage Share of Total Short Term Investment Percentage Share of Total Deposits Percentage Share of Total Borrowings Percentage Share of Total Share Capital Percentage Share of Total Reserves Advances to Deposits Ratio Advances to Borrowings Ratio Short Term Investments To Deposits Ratio Short Term Investments To Borrowings Ratio Advances to Total Share Capital Ratio Short Term Investments To Total Share Capital Ratio Advances To Total Assets Ratio Short Term Investments To Total Assets Ratio CAR (%) 350.99% 2296.62% 32.77% 214.43% 308.22% 28.78% 79.06% 7.38% 77% NPL 0.00 INCOME / EXPENSE Interest on loans assets received (Schedule A) Interest on investments received (Schedule B) Interest income (1+2) Interest expense (Schedule C) Net interest income (3-4) Other operating income (Schedule D) Total Operating Income (5+6) 154,633.97 142.30 154,776.27 22,893.50 131,882.77 27,267.48 159,150.25 Operating cost (Schedule E) Net Operating Income (7-8) Risk provisions (including charge offs) Operaing profit/loss (9-10) Non-operating income/loss (Schedule F) Total income (7+12) Profit before tax/operating loss (11+12) Provision for tax Net Income (14-15) 115,281.56 43,868.69 0.00 43,868.69 0.00 159,150.25 43,868.69 0.00 43,868.69 You have been recently engaged as the Chief Executive Officer (CEO) of a microfinance Institution (MFI). You are expected to do a presentation to the board of the directors of the MFI on the financial health and performance of the institution. You found the need to explain The relevant concepts used for the evaluation of MFIs in order to facilitate the appreciation of The issues by your audience. The content of the presentation shall form the basis of the Strategic plan currently being considered. (Use the data the provided in excel in the column Assigned to your index number). You are required to: a) Provide an asyessment of the financial health and performance of the MFI using the data Extracts from income statements and balance sheet of the microfinance institution (MFI) that Have assigned to you. (35 Marks) b) Make recommendations based on your analysis which will be used for the crafting of the Strategic plan for the MFI. ASSETS 52,175.90 Cash on hand Balances in current accounts with bank/Fin Inst (Schedule A) Balances in savings account with banks/Fin inst Money on call with banks/fin inst Placement with banks/fin inst (Schedule B) Cash and short term funds ( sum 1 to 5) GOG/BOG Securities (Schedule B) Loans and Advances (net) (Schedule C) Other Assets (Schedule D) Property, Plant and Equipment (net) Total Assets CAPITAL AND UABILITIES Paid up capital Redeemable Preference Shares Reserves OWN FUNDS/SHAREHOLDERS' FUNDS Borrowings ( Schedule E) Deposits from the public ( Schedule F) 589,128.46 0.00 0.00 600,287.06 1,241,591.42 0.00 6,429,379.50 30,369.96 430,991.32 8,132,332.20 2,086,000.00 0.00 3,384,040.59 5,470,040.59 279,950.00 1,831,778.07 Other Liabilities Schedule G) Total Liabilities Shareholders' Funds and Total Liabilities 550,563.54 2,662,291.61 8,132,332.20 600,287.06 7,029,666.56 2,111,728.07 Net Difference (A-B) Short Term Investments (4+5+7) Earning Assets (3+4+5+7+8) Interest Bearing Liability (15+16) Percentage Share of Total Assets Percentage Share of Total Loan & Advances Percentage Share of Total Short Term Investment Percentage Share of Total Deposits Percentage Share of Total Borrowings Percentage Share of Total Share Capital Percentage Share of Total Reserves Advances to Deposits Ratio Advances to Borrowings Ratio Short Term Investments To Deposits Ratio Short Term Investments To Borrowings Ratio Advances to Total Share Capital Ratio Short Term Investments To Total Share Capital Ratio Advances To Total Assets Ratio Short Term Investments To Total Assets Ratio CAR (%) 350.99% 2296.62% 32.77% 214.43% 308.22% 28.78% 79.06% 7.38% 77% NPL 0.00 INCOME / EXPENSE Interest on loans assets received (Schedule A) Interest on investments received (Schedule B) Interest income (1+2) Interest expense (Schedule C) Net interest income (3-4) Other operating income (Schedule D) Total Operating Income (5+6) 154,633.97 142.30 154,776.27 22,893.50 131,882.77 27,267.48 159,150.25 Operating cost (Schedule E) Net Operating Income (7-8) Risk provisions (including charge offs) Operaing profit/loss (9-10) Non-operating income/loss (Schedule F) Total income (7+12) Profit before tax/operating loss (11+12) Provision for tax Net Income (14-15) 115,281.56 43,868.69 0.00 43,868.69 0.00 159,150.25 43,868.69 0.00 43,868.69