Language: This version of FRAME only functions in EnglishCheck SEEP website for availability of other languages

© SEEP Network, 2005

0 0

0 MFI Solutions, LLCChuck Waterfield (Head Developer)Ana Escalona (Assistant Developer) 0 Tony Sheldon (Advisor) 0

0

0

0

0

0

0 `

#VALUE! 0 0

Changes by Version (This list only appears in English)1.01 This was a test version with limited release1.02 Released 16 November 2005

EnhancementsAutomatically carry over renogotiated portfolio value from DataInput to AdjInput sheet; affects Export from 1.0Automatically carry over portfolio > 180 days in A5.1 from section A4 above on AdjInput sheet; affects Export from 1.0Add error-counter to top of AdjInputAdd reference of selected adjustment methodology on FinReports(Adj) and Ratios sheetsAdded out-of-balance warning to Balance Sheet reportsAdded forced-balance formula to current loans on DataInput when breaking portfolio down by productAdded comments columns to far-right of all outputs sheetsAdded note about NA in Current Period column of MMR/QMR/etcAdded a check in VBA; if one year old recommend looking for new version on websiteAdded "Enable Events" button to INTRO to solve intermittent problemsAdded reference numbers and YTD clarifications to AdjInput sheetRatios: Added more lines for user-defined ratiosIntro: Added logos of funding organizations

Formatting/Output CorrectionsFinReports(Unadj): P5 was showing as negative value for previous year columnFinReports(Unadj): P5(0) was not showing beginning balanceFinReports(Adj): deleted figure in first column for B31; shouldn't have been thereFinReports(Adj): added A2.3 depreciation adjustment to reportFinReports(Adj): shifted A4 adjustment from I13 to I14OutputAdj: Added A2.3 to Balance SheetAdjInput: Correct to hide all rows in A2.3 if method=BenchmarkingQtrFinan: Correct "All figures are in " Stated foreign currency and must be local currencyMMR/QMR, etc: "As of Last Yr" figure for data coming from Ratios sheet was not displaying properlyFinReports(Unadj): Changed prorating messages for Balance Sheet and Portfolio ReportRatios: Changed data types from "flow" to "stock" for many ratios so that Reports would handle properlyMMR/QMR, etc: Changed "YTD Variance / Target (YTD)" column to only annualize flow variables, not stockMMR/QMR, etc: Modified to avoid large percentage variances when data is incompleteQtrFinan: Changed percentage column to show NA if denominators are 0VBA Open routine was checking for 180-old version and blocking accessImprovements to the Spanish translationFinReports(Unadj): Correct end-dates for 2nd and 3rd year for BS, CF, and NFD reports

Calculation ChangesAdjInput: Subsidized Cost of Funds calculation for True Performance was flawed for non-annual calcsAdjInput: Adjusted Denominator values were not all calculating correctlyDataInput: C24 and C48 showed wrong figure for Year 2AdjInput: True Performance inflation adjustment was not calculating for "beginning balances" optionAdjInput: Redesigned True Performance subidized funds adjustment to use average YTD figuresAdjInput: Redesigned True Performance depreciation adjustment to use period figures

1.03 Released 30 August 2006Correct loss allowance rate input cells for Year 3 / Quarterly Data; were not properly displayedCorrect annual target figures for user-defined rows; were not displaying on

1.04 Released 18 October 2006

`

Year-end conversion was not working; now correctedDisable right-click on sheet tabs to avoid lockup problemsCorrected "Adjusted Denominator Formulas" on AdjInput sheetRemoved error-check on rows 400 and 401 of DataInput for the InitBal columns

1.10 Released 12 February 2007Corrected SUMIF formula on R11 and R11Adj; was not summing all PAR aging categoriesRemoved "*" from R11 and R11 formula descriptionsRevised definition of R16 on RATIOS sheetAdded new IMPORT feature via button on SETUP sheetIncorporated French translation

1.11 Released 16 February 2007Minor correction to IMPORT routine to work with version 1.04

1.12 Released 12 March 2007Correction to IMPORT to allow import from another same-version file and to prohibit import from FUTURE versionsMoved VBA security/macro warning message higher on the INTRO screenAdd test for recent Excel patches installed if using Excel 2003Add notice if opened in Excel 2007; toolbars are hidden

1.12 Re-released 5 April 2007Enabled Chinese language translation

1.13 Released 2 July 2007Add Arabic translation, with left-to-right optionIncorporate translation of worksheet tabsAdded digital certificate to VBA moduleSmall correction on test for installed Excel patches

2.00 Released 6 March 2008Major new revisions and features throughout the model; refer to documentation for a complete listNOTE: Only English version released in 2.00

2.01 Released 16 March 2008Corrected "% Achieved" and "YTD Variance" columns for MMR, QMR, BoardRep, and DonorRep sheets

2.02 Released 12 April 2008Corrected "Plan YTD"column for MMR, QMR, BoardRep, and DonorRep sheets

This version of FRAME only functions in English 0 0 0 Check SEEP website for availability of other languages 0 30-Dec-1899 0

0 Build:

0 0

0 0

0

0

0

0

FRAME@seepnetwork.orgwww.seepnetwork.org/FRAME

`

Automatically carry over renogotiated portfolio value from DataInput to AdjInput sheet; affects Export from 1.0Automatically carry over portfolio > 180 days in A5.1 from section A4 above on AdjInput sheet; affects Export from 1.0

Add reference of selected adjustment methodology on FinReports(Adj) and Ratios sheets

Added forced-balance formula to current loans on DataInput when breaking portfolio down by product

Added a check in VBA; if one year old recommend looking for new version on website

QtrFinan: Correct "All figures are in " Stated foreign currency and must be local currencyMMR/QMR, etc: "As of Last Yr" figure for data coming from Ratios sheet was not displaying properlyFinReports(Unadj): Changed prorating messages for Balance Sheet and Portfolio ReportRatios: Changed data types from "flow" to "stock" for many ratios so that Reports would handle properlyMMR/QMR, etc: Changed "YTD Variance / Target (YTD)" column to only annualize flow variables, not stockMMR/QMR, etc: Modified to avoid large percentage variances when data is incomplete

FinReports(Unadj): Correct end-dates for 2nd and 3rd year for BS, CF, and NFD reports

AdjInput: Subsidized Cost of Funds calculation for True Performance was flawed for non-annual calcs

AdjInput: True Performance inflation adjustment was not calculating for "beginning balances" optionAdjInput: Redesigned True Performance subidized funds adjustment to use average YTD figuresAdjInput: Redesigned True Performance depreciation adjustment to use period figures

Correct loss allowance rate input cells for Year 3 / Quarterly Data; were not properly displayed

`

Corrected SUMIF formula on R11 and R11Adj; was not summing all PAR aging categories

Correction to IMPORT to allow import from another same-version file and to prohibit import from FUTURE versions

Major new revisions and features throughout the model; refer to documentation for a complete list

Corrected "% Achieved" and "YTD Variance" columns for MMR, QMR, BoardRep, and DonorRep sheets

0

0

0 Branch Model?

0 0

0 0

0

0 0 0 0

0

0 0 0 00

0 0

00

99

98

97

96

0 0

0

0 0

0 0

0 0

0

0 0

0

0 0

0

0 0

00:

01 - 04:

0

0 0

0 0

0 0

0 0

0 0

0

0 0

0

Yr1PerDivisor 1 Yr2PerDivisor 1 Yr3PerDivisor 4

2000 Year2005 1 Month2004 2,004 Bud Y5 042003 2,003 Bud Y4 032002 2,002 Bud Y3 022001 2,001 Bud Y2 012000 2,000 Current Year (bud) 002000 2,000 Current Year 001999 1,999 Previous Year 991998 1,998 Penultimate Year 981997 1,997 Annual Year 2 971996 1,996 Annual Year 1 96

Month Number 1

Control Lists

0 0 1 0 0 3 0 0 12 0 0

NOTE: These are in upside down order!96 2 Annual Year 1 (ann/OFF)97 2 Annual Year 2 (ann/OFF)98 4 Year 1 choice (mon/qtr/ann/OFF)99 4 Year 2 choice (mon/qtr/ann/OFF)00 2 Current Year choice (mon/qtr/ann)

2 0 0 0

2 Net fixed assets inflation adjustment method choice

0 0 0

2 Equity inflation adjustment method choice

The MFI has Impairment Loss Allowance policy in place that:0 0

1 Impairment Loss allowance policy choice

The MFI has Write-off policy in place that:0 0

1 Write-off policy choice

0 0 0 0

2 Adjust Method0 AdjustMethod Personnel Month Factor: 0 if bench, 1 if trueperf

Cash Flow Options0 0 0

1 CashFlowType

0 0

2 EnabPARBreakdown

January January-00 Monthly Cutoff Dropdown choicesFebruary February-00

March March-00April April-00May May-00

June June-00July July-00

August August-00September September-00

October October-00November November-00December December-00

(Note: not needed on EXPORT)3 Adjusted Report Dropdown (Monthly list)1 Unadjust Report Dropdown

March March-00 Quarterly Cutoff Dropdown choicesJune June-00

September September-00December December-00

(Note: not needed on EXPORT)1 QtrFinal Report Dropdown

1 Adjusted Report Dropdown (Quarter list)1 Unadjust Report Dropdown

Margin of Error 1 1 10 10 100 100 1,000 1,000 10,000 10,000

2 EnglishEspañol

User-Defined Language1 1

0 0

2

Control variables linked to objects or VBA controled0 0 EnabAdjust (linked to checkbox on SETUP)0 EnabBench (linked to checkbox on SETUP)0 EnabSubAcct (linked to checkbox on SETUP)0 EnabGender (linked to checkbox on SETUP)0 HideDefs (controled by VBA based on toolbar button)1 HideComments (controled by VBA based on toolbar button)0 ShowMnthRatios (linked to button on RATIOS)1 OpenGPMTWasRun (set by VBA)4 Year 1 Budgeting (1: mon, 2: qtr, 3: ann, 4: turn off)1 year 2-5 Budgeting (1: disabled)0 Enable Branch modeling

0 Enable BranchSheet summation0 Enable Branch Sheet model (hides SETUP, etc)

Name of Institution 0 0 are projections enabled?

Français

Chinese -- 中文简体Arabic -- عربي

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#VALUE! 0

0

Dropdown list for future forecasting 00 0 01 01 01 - 02 01 - 02 01 - 03 01 - 03 01 - 04 01 - 04

99 98 98 97 97 96

NOTE: These are in upside down order!

Net fixed assets inflation adjustment method choice

The MFI has Impairment Loss Allowance policy in place that:

AdjustMethod Personnel Month Factor: 0 if bench, 1 if trueperf

Monthly Cutoff Dropdown choices

Adjusted Report Dropdown (Monthly list)

Quarterly Cutoff Dropdown choices

Adjusted Report Dropdown (Quarter list)

NOTE: Do NOT add more lines here… it will mess up the IMPORT!!!!

EnabAdjust (linked to checkbox on SETUP)

EnabSubAcct (linked to checkbox on SETUP)EnabGender (linked to checkbox on SETUP)HideDefs (controled by VBA based on toolbar button)HideComments (controled by VBA based on toolbar button)ShowMnthRatios (linked to button on RATIOS)

Year 1 Budgeting (1: mon, 2: qtr, 3: ann, 4: turn off)

Enable Branch Sheet model (hides SETUP, etc)

0 0

I1 0 0 I2+I5+I6

I2 0 0 I3+I4

I3 0 0

I4 0 0

C1*

Printed 04/08/2023 At 03:21:40 KASHF Page 22File Name: document.xls

0

0B1 C26 C50 0 0

B2 0 0

B3 0 0 B4 - B5 0 0 0 0

B4 P4 0 0

B5 P5 0 0

B6 0 0

B7 0 0

B8 0 0

B9 0 0 B10 + B11 0 0 0 0

B10 0 0

B11 0 0

B12 0 0 0 0 0 0

0B13 0 0

B14 0 0

B15 0 0

B16 0 0

B17 0 0

B18 0 0

B19 0 0

B20 0 0

B21 0 0 0 0 0 0

0B22 0 0

B23 0 0 B24 + B25 0 0 0 0

B24 0 0 0 0 0 0

B25 I28 C44* 0 0 0 0 0 0

B26 0 0 B27 + B28 0 0 0 0

B27 0 0

B28 I27 0 0 0 0 0 0

B29 0 0

B30 0 0

B31 0 0

B32 0 0 0 0 0 0

B1 + B2 + B3 + B6 + B7 + B8 + B9

B13 + B14 + B15 + B16 + B17 + B18 + B19 + B20

B22 + B23 + B26 + B29 + B30 + B31

Printed 04/08/2023 At 03:21:40 1 Page 23File Name: document.xls

0

0B1 C26 0 0 0 0 0 0 0

B2 0 0 0 0 0 0

B3 0 0 B4 - B5 0 0 0 0

B4 P4 0 0 0 0 0 0 0

B5 P5 0 0 0 0 0 0 0

B6 0 0 0 0 0 0

B7 0 0 0 0 0 0

B8 0 0 0 0 0 0

B9 0 0 B10 + B11 0 0 0 0 0

B10 0 0 0 0 0 0

B11 0 0 0 0 0 0

B12 0 0 0 0 0 0 0

0B13 0 0 0 0 0 0 0

B14 0 0 0 0 0 0 0

B15 0 0 0 0 0 0 0

B16 0 0 0 0 0 0

B17 0 0 0 0 0 0

B18 0 0 0 0 0 0 0

B19 0 0 0 0 0 0 0

B20 0 0 0 0 0 0

B21 0 0 0 0 0 0 0

0B22 0 0 0 0 0 0

B23 0 0 B24 + B25 0 0 0 0

B24 0 0 0 0 0 0 0

B25 I28 C44* 0 0 0 0 0 0

B26 0 0 B27 + B28 0 0 0 0

B27 0 0 0 0 0 0

B28 I27 0 0 0 0 0 0

B29 0 0 0 0 0 0

B30 0 0 0 0 0 0

B31 0 0 0 0 0 0

B32 0 0 0 0 0 0 0

C50

B1 + B2 + B3 + B6 + B7 + B8 + B9

B13 + B14 + B15 + B16 + B17 + B18 + B19 + B20

B22 + B23 + B26 + B29 + B30 + B31

Printed 04/08/2023 At 03:21:40 KASHF Page 24File Name: document.xls

0 00 Q1 Q2 Q3 Q4

0 0 0 0 0 Dec-99 Mar-00 Jun-00 Sep-00 Dec-00

0

0P1 0 0 0 0 0

P2 C9 C32 0 0 0 0 0

P3 0 0 0 0 0 0

P4 B4 0 0 0 0 0 0

0P5[0] B5[0] 0 0 0 0 0 0

P5[1] B5[1] 0 0 0 0 0 0 0

P6 0 0 0 0 0

P7 0 P4[avg] * R10 0 0 0 0

P8 I14 0 0 0 0 0

P9 0 0 0 0 0

P10 I15 0 0 0 0 0

0 00 00

From To 0 0 0 0

0 0 0 0

0 0 <= 0

> 1 > 1 0

0 0 0 0 0 P11 0 0 0 0 0 0

P15 <= 0 0 0 0 0

P15 > 1 0 0 0 0 0 P13 0 0 0 0 0 0

P13 0 0 0 0 0 0

0 0 0 0 0 P12 0 0 0 0 0 0

P16 <= 0 0 0 0 0

P16 > 1 0 0 0 0 0 P14 0 0 0 0 0 0

P14 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 <= 0 0 0 0 0 > 1 0 0 0 0 0

P11 + P13 + P15

P12 + P14 + P16

P5[1] - P5[0] + P7

0

0 0

0

0

0 A1 0 0

A2 0 0