ADVANCED Business Planning with Microfin
Washington DC, USA
May 7-9, 2018
Advanced Microfin training moves senior staff beyond Microfin basics and untaps the full resources of Microfin to create more precise projections.
The training starts with a brief overview of the case study recently completed in the standard training.
Once we have had a chance to review Microfin, we will convene an open forum where each delegate will present a challenge, error, difficulty, or improvement suggestion to consider. In the open forum we will explore solutions, confirm reported errors, and viability of suggestions together. Each delegate will have an opportunity to submit several issues to discuss prior to convening the training. The most significant issues submitted early will receive prepared discussion on days 2 and 3.
From there we will start the advanced training by creating new branches and products with additional case study scenarios and data.
Further study of advanced loan portfolio initial balance information demonstrates real life solutions to reconciling Microfin inputs to actual loan portfolio tracking data for those institutions with existing loan portfolio which will be repaid in the first months of the projections.
Microfin can only be as accurate as the data input is accurate. Therefore it is important that Microfin learn accuracy during the first year of projections in order to make subsequent year projections even more accurate. To that end, the case study includes results from the first months of activity. Using an enhanced variance analysis tool, delegates will be trained how to identify advanced cost accounting variances and use the results to adjust the projections in months already passed. This will make intra-year projections, as well as subsequent year projections, more realistic.
Cash flow analysis is further developed in this advanced training. Elements of ALCO (Asset Liability Committee) and treasury management are developed and implications of liquidity (too much and too little) are explored. In addition, other treasury risk factors and their overall sensitivity will be modeled using Microfin, including:
- Interest Rate Risk (not able to re-price assets --loan portfolio-- quickly when liabilities --MFI debt incurred-- interest increases),
- Currency devaluation or depreciation (holding debt in foreign currency more than assets being held in that foreign currency),
- Being leveraged and it's impact on the financial statements when a natural disaster strikes.
Because this training picks up where standard training has left off, and due to the condensed nature of the training (just three days), an enforced prerequisite for anyone wishing to attend the training is to have participated in a training in the past year. The requirement can also be satisfied if the delegate wishes to send a previously completed Microfin projection for analysis. If competently completed, the delegate will be approved and can attend the advanced training.
The training's cost is $750, however the following early booking discounts are available:
Register before March 26, 2018 $75
As with the standard training, Howard Brady, a seasoned microfinance consultant of 20 years, will facilitate the training. Howard has been a Microfin instructor with Chuck Waterfield, the original author of the software, since 2000. In April 2016, Howard assumed the future development and maintenance of Microfin. Howard's consultancies have helped increase the efficiency and effectiveness of MFIs worldwide, have helped organizations find solutions to delinquency issues, and have created appropriate internal audit and internal control environments. Howard integrates his first hand experiences into his teaching to provide practical solutions to complex issues facing MFIs today.
If you are travelling to Washington DC and not a citizen of the United States of America, consult this page to see if your country is part of the visa waiver program and what might be required for entry to the United States. If your country is not listed, you will need to fill out a DS-160 form online and schedule an interview with a representative of the United States of America in your country. It may be helpful to review this document for the questions you might be asked on the DS-160. Note that the appropriate visa to apply for is a B-1 visa, which is used for Conferences and Seminars, not an F-1 or J-1 visa for educational purposes. Since this workshop is not part of an educational institution, a SEVIS ID number does not apply.
A detailed, day by day agenda follows:
Microfin Training Agenda
- Review of the standard training case study
- Open forum: challenges, identified errors, difficulties, and improvement suggestions
- Adding branches/regions, splitting the portfolio appropriately
- Adding new products, splitting the portfolio appropriately
- Advanced initial portfolio reconciliation
- Advanced variance analysis
- Open forum solutions part 1
- Advanced cash flow analysis
- Advanced ALCO / treasury risk analysis
- Open forum solutions part 2
- Closing: certificates and evaluation