Microfin 3.5   
Home Up Download Problems Microfin 4.0 Microfin 3.5 Download TecDocs Microfin Demos Download Microfin Demos

 

Microfin 3.5 Download Page

Microfin 3.5

NOTE:  Microfin 3.5 and Microfin 4.0 do not yet function on Excel 2007.  Excel 2007 is radically changed, and various aspects of Microfin (eg, toolbars) do not function.  We plan a future version that will be Excel 2007-compatible.  In the meantime, you will need to use Excel 2000, Excel XP, or Excel 2003.

Microfin 3.5 is a significant upgrade of Microfin that was released in July 2004.  In addition, the manual was completely revised and incorporated into a new on-line help file.

Microfin 4 is now complete and can be downloaded and used if you wish.

Click here to download the software (version 3.58)

Click here to download the new Appendum to the Using Microfin 3 manual which documents the changes in version 3.5

Click here to download the manual, Using Microfin 3

Summary of changes between versions 3.0 and 3.57

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