| 3.01 |
Resize dropdowns on Print Form |
| |
Changed LINKS buttons at bottom of PROGRAM page; Income Statement buttons
were showing up when the section was hidden |
|
Redesigned WWB PA page (was non-functional in version 3.0) (still in
progress at release of 3.01) |
|
Added warning about Excel 97 and digital certficate; now distributing TWO
versions!!!! |
|
Changed "old version" warning from 180 days to 360 days |
| |
Hide "Revalue FA" line on NAVIGATOR |
| |
Corrected version number on REFERENCES; added numeric equivalent so that
IMPORT would work when Windows configured for x.xxx,xx |
| 3.02 |
Correct line 1.32 on VAR ANALYSIS page; sum formula was missing line 1.30 |
| |
Correct import references for offset on MODEL SETUP for row 210 prior to
version 2.97 |
| 3.03 |
Change loan officer calcs for Yrs 3-5; removed one-quarter shift on staffing
requirements |
| |
Fix loan officer calcs for Yrs 3-5; was ignoring caseload override line |
| |
Add formula/comments columns used for technical documentation; major
addition on nearly every sheet! |
| |
Revise spanish translation to match translation of "Using Microfin 3" manual |
| |
Added support for manual programming of initial loans over 24 months for
Product 1 on PRODUCTS page |
| |
Make "auto-width" line on PROGRAM bold to avoid potential ##### after
resizing |
| |
Correct "Number of Loans Disbursed" Graph; was showing Month 0 |
| |
Change OpenMicrofin VBA to correct problem of not finding Help file |
| 3.04 |
Import routine didn't work in 3.03; offset range wasn't set up; won't do
imports from 3.03 |
| |
Further clean-up and documenting of VBA macros |
| |
Changed to right-alignment on loan officer "overcapacity" line on PROGRAM
page |
| |
The ShowPrintGraphMsg wasn't in use; removed it from VBA procedure |
| |
Indexing calculations were screwed up after Month 37 due to changes made in
version 3.03 (additional of TechDoc columns); now corrected |
| |
Investment income lines on FIN FLOWS did have ISBLANK test; changed to
ISNUMBER to avoid text entries |
| |
Continued with formula/comments columns used for technical documentation;
added buttons to show/hide documentation |
| |
If Bal Sheet doesn't balance, now flags an error (in red) on NAVIGATOR |
| |
Add AutowidthAllPages command at end of Import process |
| 3.05 |
Revised spanish translation based on final CGAP review |
| 3.06 |
Correct macro to show TechDoc info |
| |
Formula error: Misc other exp formula was incorrect for
Yrs 3-5. On program it multiplied by 3 and shouldn't have; on Admin it did
not multiply a fixed amount by 3 and should have |
| |
Removed "private" on various VBA procedures to allow users to access them in
emergency situations |
| |
Added "DisableEvents" button on Model Setup |
| |
Fixed: Draw Graph button didn't work for "Avg Loan Size" graph |
| |
Correct formula for 9.52 on PROGRAM (Number new clients per loan officer);
was showing quarterly figure for Yrs 3-5 |
| |
Fix: Automatically change branch sheet names when name is input; avoids
error where user forgets to click the RENAME button (that button is now
unnecessary; left there to avoid confusion) |
| |
On NAVIGATOR, line 4.05, flag error if programmed repayments are not correct |
| |
Eliminated rotating Microfin logo on INTRO page; took too long to redraw in
Excel XP |
| |
Add warning on first open with Excel 97 to use CTRL-ALT-F9 |
| |
Correct problem: Reserves row on compulsory savings was not displaying
properly under some conditions |
| |
Correct problem: Use VBA command on first-time Microfin used to clear
contents of optional FY cell on MODEL SETUP |
| |
Correct problem: Change VBA routines so sheets are renamed properly when
changing languages; was incompatible with Excel XP |
| |
Incorporated French translation changes from Feb 2002 that were left out |
| |
Added Explicit variable declaration to all VBA routines (part of Technical
Documentation requirements) |
| 3.07 |
Correct formula on line 2.40 for Products 3&4 on PROGRAM page; was showing
improper reference number; also affected reference number showing in line
2.32 |
| |
Some VBA corrections for getting SaveName for file; was problem with
explicit variable declaration introduced in 3.06 |
| |
Correct TransferUserSheets routine; wasn't copying formatting of user sheet
during Import process |
| |
Correct VBA when importing data to an earlier version; wasn't flagging the
error, a problem introduced in 3.01, I think |
| |
Solved worksheet renaming problem in Excel XP when switching languages; had
to modify VBA |
| 3.071 |
Fixed ERROR indicator on line 4.05 of NAVIGATOR sheet |
| |
Fixed checkbox control for Advanced Loan Officer input lines on PROGRAM page |
| 3.071a |
Correct FAStepNum variable in VBA code; would crash when opening a
branch-level planning model |
| |
Correct "Compusory Savings on Bal Sheet" section; reserves lines weren't
displaying sometimes |
| |
Note: this version was released with a different release date than 3.071. I
could not change version number because of client needing to import
branch-level planning data, which requires same version |
| 3.072 |
Correct Export routines to close DataWorkbook upon completion |
| |
Added hooks for Compartamos branch process |
| |
Added means to optionally password protect user sheets during export/import
process |
| 3.08 |
Added full support for initial loan balances with terms greater than 24
months |
| |
Modified formula for "number of loans maturing" for Product 1, Yrs 3-5, on
PROGRAM page; revised the change made in version 3.03 |
| |
Add button on INTRO sheet to export Compartamos user-sheet data |
| |
Modify EraseAll VBA procedure to solve FY input cell glitch on MODEL SETUP |
| |
Change Step 5 Eff Int calc to include if int rate method is changed in Month
1 |
| |
Fix penalty income on Products 2/3/4; was double-counted on ADMIN page |
| |
Fix "loan repayment" formula for Product 4, Yrs 3-5 on PROGRAM page; was
only deducting loan write-off for one month each quarter |
| 3.081 |
Modify Export VBA routine to shrink size of hidden EXPORT DATA page |
| |
Correction: PROGRAM, line 5.08 of Product 1, would calculate inaccurate
interest if int rate changed in Month 25 |
| |
Correction: FIN FLOWS sheet "unrestricted loans w/o default" calculation
line only added sources 1,2,&6. Allowed for illiquidity when default
sources activated if sources 3,4, or 5 had activity. |
| |
Added some calculation rows on PROGRAM to determine loan maturation for GAP
analysis (used in Mexico Superintendency reports) |
| |
Modified import/export VBA routines to flag formulas longer than 255
characters in length because they truncated during Export/Import |
| |
Added support for Add-on Tools through Import process that doesn't erase
model or delete existing user sheets |
| |
Modify add-sheet routine to speed up routine; also remove confirmation
during import process |
| |
Add ability to transfer comments on user-sheets during export/import
(validation not working yet) |
| |
Show warning if user-sheet with same name exists during import process |
| 3.1 |
Released 1 April 2004 |
| Major Additions |
ModelSetup: Added support for up to 20 branches in Excel XP and future
versions |
| |
Program/Admin/InstCap: Added additional lines for staffing, other op, and
fixed assets |
| |
FinSources/FinFlows: Added additional input lines for all financing sources |
| |
NOTE: reference line numbers may no longer match those in manual due to
additional input lines added throughout Microfin |
| |
InstCap: Added feature to auto-hide unused rows to make the sections more
concise |
| |
Export: Revised Export Wizard to allow access to new add-on tool creation
feature |
| |
FinFlows: Allow default loan interest rate to vary by month |
| Important Refinements |
Added branch sheet navigation to "Go To" menu on Microfin Toolbar |
| |
ModelSetup: Added ability to add multiple branch sheets at once |
| |
Products: Added option to analyze STEP 5 on PRODUCTS for any month input |
| |
FinFlows: Added "yellow light" warning to liquidity line 5 in top section |
| |
Graphs: Revised Cost Structure graph to match Expenses graph |
| |
Export: Modified message about branch-level planning model on EXPORT Wizard
to minimize user errors |
| |
GraphClipboard: Added GRAPH CLIPBOARD to export/import |
| |
Intro: Added option to load sample FEDA case study data |
| Bug fixes |
FinStatements: Corrected PAR formula in Ratios section; was incorrect
sometime after version 3.03; did not affect projections or graphs |
| |
Graphs: Fixed AROA/AROE graph; wouldn't show trends when all frozen values
were = N/A |
| Minor changes |
Changed "old version" warning from one year to six months |
| |
InstCap: Added autowidth feature to INSTCAP |
| |
Hid calculation rows at bottom of each sheet; add button on MODEL SETUP to
unhide them |
| |
Products: Extended grace, commission, indexing, and floating rate cells
into Init Bals columns |
| |
Products: Improved warning messages for STEP 5 if loan term exceeds 24
months |
| |
Products/Program/Admin: Added more yearly-column totaling |
| |
Graphs: Improved terminology on various graph labels |
| |
Graphs: Improved warning messages on GRAPHS page |
| |
FinSources: Changed recalc method on FIN SOURCES sheet; was too slow in
Excel 2003 |
| |
Program: Improved autowidth function on PROGRAM sheet (was missing some
sections) |
| |
Intro: Deleted all version history prior to 3.0 |
| |
Export: Added percent variance column |
| |
FinFlows: Refined weighted cost of funds formula |
| |
GraphClipboard: Added GRAPH CLIPBOARD to "erase workbook" routine |
| |
References: Removed top section of REFERENCES from the Import/Export
process (maintains previous setup information) |
| |
Improved opening routine to resize columns showing Microfin line numbers |
| |
ModelSetup: Added % of memory used stat when in Branch mode (for Excel
prior to XP) |
| |
GraphClipboard: Changed color scheme |
| |
GraphClipboard: Added worksheet protection |
| 3.11 |
Released 15 April 2004 |
| Bug fixes |
Corrected description formulas on 1.143 and 1.144 of PROGRAM; showed
incorrect Fixed Asset descriptions; all calculations correct |
| |
InstCap: Automated linkages were not working for new rows added for
staffing, other op, fixed assets |
| 3.12 |
Released 20 April 2004 |
| Bug fixes |
Autowidth routine would crash in Excel 2002; solved by unhiding the "autowidth"
row on each sheet |
| 3.13 |
Released 10 June 2004 |
| Bug fixes |
New financing source lines were not being fully picked up in FinFlows
sections; would cause Balance Sheet to get out of balance |
| |
Fin.Statements: new equity lines (lines 4&5) were not being picked up on
"Shareholder Equity" line of Balance Sheet |
| 3.5 |
Released 20 July 2004 |
| |
The following list summarizes all changes from 3.1 to 3.5, by sheet |
| New Rows |
Additions to rows in Microfin may affect formulas that you import from
previous versions. Review this information to correct your formulas |
| Environment |
Added new INTRODUCTORY mode for new users; makes substantial modifications
throughout the model to simplify input; list of changes appears on MODEL
SETUP |
| |
Revised Setup Wizard to ask about new features |
| |
Reorganized OPTIONS menu to reflect new features |
| |
Hid all support calculation lines at end of sheets; can be accessed via
OPTIONS menu |
| |
Added option to load FEDA sample data |
| |
Added option to expose all rows via OPTIONS menu |
| |
Added option to display technical documentation via OPTIONS menu |
| |
Added Go To Branch x option on GOTO menu on Microfin Toolbar |
| |
Add error checks throughout model to test for data entered into hidden
lines and for logical inconsistencies |
| |
Changed "old version" warning from one year to six months |
| |
Rezoom all sheets to 100% after Erase procedure |
| |
Added "new user" reminders that show up every 7th time user changes sheets |
| |
Added "first-time" notices for each sheet |
| |
Allow user to search for Help file if not found in expected locations |
| |
Added elapsed time since last save in notice after Microfin opened |
| |
Incorporated links for new Ford-sponsored self-study tutorials |
| |
Add option to select language of pop-up help when user-defined language is
enabled |
| Navigator |
Added Review Data Validation section, displaying number of errors,
warnings, and not dones |
| |
Completely reworked Not Done system; added ? alerts in Column D |
| |
Added numerous new error checks |
| |
Moved all error messages (and new warnings) to far-right column |
| |
Added new Warning system with override feature |
| |
Reformated Comments column to a single column with wordwrap |
| |
Added more info throughout the sheet |
| |
Integrated new Demo system throughout the sheet |
| |
Reworked the Navigator Wizard to reflect changes and new features |
| |
Default to Level 3 when first opened instead of Level 1 |
| |
Added new Before you Start section |
| |
Added import validation columns on far-right; does line-by-line
validation; hidden from view when not needed |
| Model Setup |
Added new INTRODUCTORY mode for new users |
| |
Added support for up to 20 branches in Excel XP and future versions |
| |
Added ability to add multiple branch sheets at once |
| |
Added % of memory used stat when in Branch mode (for Excel prior to XP) |
| |
Added option to switch between Program/Admin and Branch/HeadOffice
terminology when in Consolidated mode |
| |
Added option to input Annual, Monthly, or Annual-and-Monthy loan
projection figures |
| |
Reworked FY section; eliminate override and default to show two years if
FY doesn't start in Jan |
| |
Add two additional Indexing Source options; allow them to be named; made
exchange rate required |
| |
Add option to skip Historical Financial Statements and Initial Ratio
Analysis; affects other sheets for input of initial balances; when skipped,
no longer shows out of balance messages |
| Products |
Added a second up-front fee to loan products |
| |
Allow Loan and Savings products to be indexed to any of three indexing
sources |
| |
Extended grace, commission, indexing, and floating rate cells into Init
Bals columns for consistency |
| |
Added option to analyze STEP 5 on PRODUCTS for any month input |
| |
Added summary table of active values in STEP 5 |
| |
Improved warning messages for STEP 5 if loan term exceeds 24 months |
| Branch Sheet |
Changed default name from Program to Branch |
| |
Added Comments section to right of Branch Summary Report |
| |
Added additional lines for staffing, other op, and fixed assets |
| |
Added more yearly-column totaling |
| |
Added option to input Annual, Monthly, or Annual-and-Monthy loan
projection figures |
| |
Changed default retention rate threshold to 80% |
| |
Added % figure for number of clients deserting |
| |
Switched order of Number of Branches input section |
| |
Improved autowidth function (was missing some sections) |
| Institutional Capacity |
Added new manual cost allocation option (allows input of amounts or
formulas on Head Office sheet) |
| |
Added feature to hide unused input lines and display counter of number of
remaining lines |
| |
Added new Start Month option for automatic linkages (takes effect in
month indicated) |
| |
Hide branch link option if in branch mode |
| |
Moved Salary Adjustment section |
| |
Added new Salary and Benefit Calculation Tool |
| |
Added auto-width feature |
| |
Add option to hide salary sections with password protection (currently a
hidden feature; will be activated in Mfin 4) |
| Head Office |
Changed default name from Admin to Head Office |
| |
Added more yearly-column totals |
| |
Added additional lines for staffing, other op, and fixed assets |
| Financing Sources |
Added optional Maximum Amount input; flags errors on FIN FLOWS if
financing exceeds this amount |
| |
Allow loans to be indexed to one of three different indexing sources |
| |
Added new financing source lines to all categories |
| |
Added manual input lines for other financial costs |
| |
Added section for adjustment of accrued financial costs |
| |
Changed recalc method on FIN SOURCES sheet; was too slow in Excel 2003 |
| |
Refined weighted cost of funds formula |
| |
Removed blue formatting from initial balance on grants, not really
required |
| Financing Flows |
Added default financing option for a mix of loans and equity injections;
based on equity multiplier, minimum capital amount, and minimum new equity
injection |
| |
Allow grant/loan percentage mix to vary by month |
| |
Allow default loan interest rate to vary by month |
| |
Highlight automated default source information lines |
| |
Add yellow light warning to liquidity Line 5 in top section |
| |
Add ability to input indexed loan information in external currency |
| |
Added indicator to show amount of additional financing needed |
| Graphs |
Revised Cost Structure graph to match Expenses graph |
| |
Improved terminology on various graph labels |
| |
Improved warning messages on GRAPHS page |
| Graph Clipboard |
Added GRAPH CLIPBOARD to export/import |
| |
Added GRAPH CLIPBOARD to "erase workbook" routine |
| |
Changed color scheme |
| |
Changed color scheme |
| |
Added counter, removed "titles" line |
| |
Added routine to reorganize graphs if one gets deleted |
| Summary Report |
Separate dividends from shareholder equity; hide both lines if not in use |
| Fin Statements |
Initial Balance Verification columns get hidden in INTRO mode |
| |
Corrected PAR formula in Ratios section |
| Export Sheet |
Revised Export Wizard to allow access to new add-on tool creation feature |
| |
Modified message about branch-level planning model on EXPORT Wizard to
minimize user errors |
| |
Added percent variance column |
| |
Subdivided export ranges on BRANCH sheet to speed up process |
| |
Added FIN STATEMENTS sheet to transfer any user-defined ratios |
| |
Added add-on tool feature to Export Wizard; allows export of User-sheets
that others can import onto their existing files |
| |
Add feature to allow branch-level plans to be passed back and forth for
revision |
| |
Added an Import Validation feature, showing line-by-line comparisons on
Navigator |
| Cost Client |
Added input line for fees paid but not to MFI |
| Translations |
Reformatted sheet |
| |
Eliminated all formulas to enable improved user-defined translations |
| |
Improved feature for importing a user-defined translation module |
| 3.51 |
Released 4 August 2004 |
| |
Correction when loading Sample Data so that graphs display properly |
| |
Correction when loading Sample Data so that no data appears in hidden rows |
| |
Correct Import routine to import from versions 3.4x when computer has
numeric format of 3,42 instead of 3.42 |
| |
Revised instructions for the branch-planning process on the EXPORT sheet |
| |
Corrections to VBA so that branch-planning model import functions properly |
| |
Changed method of locking input cells on PRODUCTS and INSTCAP for
branch-planning model so that it is reversible |
| |
Added Excel Build info to Version on INTRO and incorporated into Export Data |
| |
Fixed SUMMARY REPORT; some Bal Sht lines were not repeated in the Constant
and External Currency sections |
| |
Delinked external currency information on SUMMARY REPORT from the Indexing
sources |
| 3.52 |
Released 25 August 2004 |
| |
Correct EIR calculation in Step 5 of Product 4; all projection calculations
were accurate |
| |
Reinstated autocalc when on Cost Client, Retention, and Caseload sheets |
| |
Products, Step 5: include indexing cost when analyzing "Initial Bals"
information; show annualized value in "Active Values" chart |
| |
Calculation error: Indexed savings were not calculating
properly, since introduction of multiple index sources, for all savings
products. |
| |
Export error: With multiple branch sheets, export
process was only including the last branch sheet |
