Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: LFA_Disbursement Recommend_5B

[NAME] On-going Progress Review and Disbursement Recommendation
DISBURSEMENT REQUEST PERIOD
Grant number:
Disbursement Request  - Disbursement Period: |  |  |  |  | Cycle: |  |  | Number:
Disbursement Request  - Period Covered: |  |  |  |  | Beginning Date: |  |  | End Date:
Disbursement Request  - Number:
Currency:
Section 5:  [NAME]-verified Cash Reconciliation & Disbursement Recommendation
[NAME] DISBURSEMENT AMOUNT AND EXPLANATIONS
Total forecasted net cash expenditures by the Principal Recipient for the period immediately following the period covered
by the Progress Update:
1.  Period beginning date: |  |  |  |  |  |  | end date: |  |  | Approved budget amount (reported by PR): |  |  |  | Forecasted amount  (reported by PR):
 |  |  |  |  |  |  |  |  |  | LFA-verified approved budget amount: |  | 499774 |  | LFA-adjusted forecasted amount: | 856891.72
2a. Cash buffer period (by default)
(cash "buffer") beginning date: |  |  |  |  |  |  | end date: |  |  | Approved budget amount (reported by PR): |  |  |  | Forecasted amount  (reported by PR):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PR Total Forecast
 |  |  |  |  |  |  |  |  |  | LFA-verified approved budget amount: |  | 578147 |  | LFA-adjusted forecasted amount: | 542393.68
2b.  Additional "buffer" (discretionary, select only if there is a prior agreement with the FPM) (1) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LFA Total Forecast
(cash "buffer") beginning date |  |  |  |  |  |  | end date: |  |  | approved budget amount: |  |  |  | forecasted amount:
 |  |  |  |  |  |  |  |  |  | LFA-verified approved budget amount: |  |  |  | LFA-adjusted forecasted amount:
(1) Upon agreement with the FPM, additional Cash buffer can be requested if the PU/DR report contains a completed EFR report or a completed Annex on SR financials, requested by the Secretariat, or if there are any additional GF-specific requirements that cannot be delivered within 45 days.  However such requests may or may not be satisfied based on the review of the current PUDR
(2) When the additional (cash "buffer" ) period is 1 or 2months, the approved budget and forecasted amounts should be calculated as prorated values for the period following the regular buffer period.
PR's explanation of any significant variance between forecasted amounts and amounts as originally budgeted.
LFA's explanation of any significant variance between forecasted amounts and amounts as originally budgeted.  Please explain any significant variance (based on your judgment) between the forecasted amounts and the amounts as per approved budgets.  Please specify the main factors and related amounts that are the major drivers of the variance.  NB. Consider the following items when providing the analysis.    - Expected timing of payments for any significant budgetary items,   - Impact of existing cash balance at SR levels   - Current confirmed commitments to be paid during disbursement request period    - Current/expected unit prices compared to those in the budget    - Change in quantities compared to budget   - Exchange rates and inflation   - Linkage between budget absorption and programmatic performance to-date.  ! The forecast should include any existing commitments (eligible under this grant) as of the end of the reporting period and which are likely to be paid during the disbursement period |  |  |  |  |  |  | We noted that the PR used a revised year 2 budget which has not been approved by the GF. This accounts for the difference between the budget reported by the PR and [NAME].  The variance between the forecasted amount and the original budgeted amount is due to the inclusion of outstanding activities from the previous period into the forecast.    The outstanding activities mainly relate to the following:   BCC community outreach and schools - Eur 43,949 , Policy development on HIV advocacy - Eur 6,825,   Educational and nutritional support for OVCs - Eur 43,772, and PR and SR administrative costs - Eur 40,099.   Savings of Eur 169,304 were identified during the review of the forecast. The PR did not provide a plan for utilisation of the savings. These savings have therefore been excluded from the total forecast amount by the LFA.
Less: | 3. Cash Balance: End of period covered by Progress Update (number 10 from LFA or PR Cash Reconciliation sheet): |  |  |  |  |  |  |  | PR-reported amounts | LFA-verified amounts | LFA Comments
 |  |  |  |  |  |  |  |  |  |  | The cash balance in the LFA section represents adjusted cash balance as at 31 December 2010. See details of adjustments in LFA cash reconciliaiton 5A.
 | 4. Cash "in transit" disbursed to the PR:
 | 5. Cash "in transit" disbursed to third parties by the Global Fund on behalf of the PR :
 |  |  |  |  |  |  |  |  | PR-requested amount | LFA-recommended amount
6. Disbursement Request to the Global Fund for the period immediately following the period covered by the Progress Update, plus additional period (cash buffer):
7.  Does the PR's Disbursement Request include funds for health product procurement? |  |  |  |  |  |  |  |  | Yes
8.  [NAME] (used to translate local currency into grant currency)
 |  |  |  |  | Rates used by the PR |  | LFA-verified rates |  | Name of local currency and LFA comments on the exchange rates used by the PR
 | - used to convert Opening Cash Balance |  |  |  |  |  | 37 |  | The PR used Euro 1:37 Dalasi to translate bank and cash balances at the beginning of the period (quarter 4) and a monthly rate generated from the accounting system in translating expenditure incurred in the local currency. At the end of the period, Euro 1:37 [NAME] was used in translating the closing cash and bank balances. The rates used compare to the Central Bank of The Gambia indicative exchange rate which was Eur 1 : 37.46 Dalasi at the end of the period. The outflow for the period were translated at average rates on a monthly basis. October - Eur 1 : 39.41 [NAME], November Eur 1 : 37.84 [NAME] and December Eur 1 : 37.58 Dalasi
 | - used to convert [NAME] |  |  |  |  |  | 37.46
 | - used to convert Total PR Cash Outflow for the Progress Update Period |  |  |  |  |  | Average monthly rate