Adjustments by huangyuarong

VIEWS: 3 PAGES: 2

									                                              Sample adjustments
Provisioning Adjustment                                    Calculation
Do the Portfolio adjustment?              Y
Adjust Write-off of loans?                N
UnadjustedGLP                         a       1,648,864 [Amount of MFI's stated Gross Loan Portfolio]
PAR > 365                             b             -      [Amount from MFI's portfolio report]
Adjusted GLP                          c       1,648,864 a-b
Renegotiated loans                    d             -      [Amount from MFI's portfolio report]
PAR 91-180                            e          16,000 [Amount from MFI's portfolio report]
PAR 181-365                           f           3,500 [Amount from MFI's portfolio report]
Minimum Reserve                       g          11,500 (d*0.5) + (e*0.5) + (f*1)
Unadjusted LLR                        h          11,000 [Amount of MFI's stated Loan Loss Reserve]
Adjusted LLR                          i          11,500 if h>g, h-b, otherwise g
Unadjusted LLPE                       j           7,500 [Amount of MFI's stated Loan Loss Provision Expense]
Adjusted LLPE                         k           8,000 [a-h] - [c-i] +j



Cost of Funds Adjustment                                   Calculation
Last year's borrowings                a       1,131,850 [MFI's stated Borrowings from previous year]
This year's borrowings                b       1,118,150 [MFI's stated Borrowings from current year]
Average borrowings                    c       1,125,000 (a+b) / 2
Market rate                           d                5% [Shadow rate chosen]
Market rate cost of funds             e          56,250 c*d
Financial expense on borrowings       f          25,000 [MFI's stated Financial expense on borrowings]
Subsidized cost of funds adjustment   g          31,250 if e>f, e-f, otherwise null



In-Kind Adjustment                        Unadjusted       In-Kind donation          Adjusted Amount
                                          Amount
Personnel                                      170,850                     15,000                        185,850
Rent and Utilities                               25,400                                                   25,400
Transportation                                    5,600                                                    5,600
Office Supplies                                  21,200                                                   21,200
Other Administrative Expenses                  165,637                       5,000                       170,637
Total                                          388,687                     20,000                        408,687



Inflation Adjustment                                       Calculation
Last year's Equity                    a        862,239 [MFI's stated Equity from previous year]
Last year's Fixed Assets              b        106,650 [MFI's stated Fixed Assets from previous year]
Inflation Rate                        c                3% [Inflation rate]
Inflation Adjustment Expense          d          25,867 a*c
Inflation Adjustment Revenue          e           3,200 b*c
Net Inflation Adjustment Expense      f          22,668 d-e




08092168-8e64-4b14-a7a9-1cb9cf4ce959.xls                                                                           1/2
                                              Sample adjustments (2)
Provisioning Adjustment                                    Calculation
Do the Portfolio adjustment?              Y
Adjust Write-off of loans?                N
UnadjustedGLP                         a        1,648,864 [Amount of MFI's stated Gross Loan Portfolio]
PAR > 365                             b            5,000 [Amount from MFI's portfolio report]
Adjusted GLP                          c        1,648,864 a-b
Renegotiated loans                    d              -     [Amount from MFI's portfolio report]
PAR 91-180                            e              -     [Amount from MFI's portfolio report]
PAR 181-365                           f              -     [Amount from MFI's portfolio report]
Minimum Reserve                       g              -     (d*0.5) + (e*0.5) + (f*1)
Unadjusted LLR                        h              -     [Amount of MFI's stated Loan Loss Reserve]
Adjusted LLR                          i              -     if h>g, h-b, otherwise g
Unadjusted LLPE                       j            5,000 [Amount of MFI's stated Loan Loss Provision Expense]
Adjusted LLPE                         k            5,000 [a-h] - [c-i] +j



Cost of Funds Adjustment                                   Calculation
Last year's borrowings                a        1,131,850 [MFI's stated Borrowings from previous year]
This year's borrowings                b        1,118,150 [MFI's stated Borrowings from current year]
Average borrowings                    c        1,125,000 (a+b) / 2
Market rate                           d                5% [Shadow rate chosen]
Market rate cost of funds             e           56,250 c*d
Financial expense on borrowings       f           25,000 [MFI's stated Financial expense on borrowings]
Subsidized cost of funds adjustment   g           31,250 if e>f, e-f, otherwise null



In-Kind Adjustment                        Unadjusted       In-Kind donation          Adjusted Amount
                                          Amount
Personnel                                       170,850                     15,000                        185,850
Rent and Utilities                                25,400                                                   25,400
Transportation                                     5,600                                                    5,600
Office Supplies                                   21,200                                                   21,200
Other Administrative Expenses                   165,637                      5,000                        170,637
Total                                           388,687                     20,000                        408,687



Inflation Adjustment                                       Calculation
Last year's Equity                    a         862,239 [MFI's stated Equity from previous year]
Last year's Fixed Assets              b         106,650 [MFI's stated Fixed Assets from previous year]
Inflation Rate                        c                3% [Inflation rate]
Inflation Adjustment Expense          d           25,867 a*c
Inflation Adjustment Revenue          e            3,200 b*c
Net Inflation Adjustment Expense      f           22,668 d-e




08092168-8e64-4b14-a7a9-1cb9cf4ce959.xls                                                                            2/2

								
To top