by Jordan Filko
A new version of MFTransparency’s “Calculating Transparent Prices Tool” is now available. MFTransparency’s most popular resource, this Excel-based tool allows users to input loan terms to analyze the cost of a particular loan product, learn how various factors influence the cost of a loan and view borrower cash flow through graphs and repayment schedules.
(more…)
by Mélina Djre
Si c’est le microcrédit qui fait le plus parler de lui lorsqu’il est question de microfinance, l’offre de services d’épargne n’en est pas moins intéressante. Au même titre que le crédit, l’épargne répond à un besoin pour les populations non bancarisées, qui ne perçoivent pas toujours des revenus réguliers et qui doivent faire face aux aléas du quotidien.
(more…)
by Tim Langeman
In a previous post, I described the technique that computer programs like Microsoft Excel use to calculate the XIRR (effective interest rate) as a very smart version of “guess and check.” The post on Newton’s Method described how the “guessing” part works, but it did not describe how the computer is able to finally verify when it has the correct EIR figure — the “check” part.
In today’s post, I’m going to describe the process that a computer program uses to generate a discounted cashflow, a method of calculating the value of a cashflow that uses the time-value of money. By adding up the discounted cashflows we are able to determine whether we have the correct EIR.
I’m going to start with a sample loan of $4,825.00 that was disbursed on the 28th of the month but is paid back on the 16th of the month every month for about a year. The fact that the disbursement date is not exactly one month prior to the first repayment means that a simple IRR formula can not be used for accurate results, and the calculation must take all the actual dates into account. The exact details are at right. (more…)
by Tim Langeman
When we receive loan data from microfinance institutions that wish to become transparent, they enter the information about their loans into our Data Collection Tool. In addition, we always ask for real repayment schedules for active loans given to real borrowers. We use these repayment schedules to verify the information the MFI has entered into our Data Collection Tool, but they also serve another purpose.
(more…)
by Deepak Goswami & Alexandra Fiorillo
Microcredit products often carry additional fees on top of the basic nominal interest rate charged to the client. In this blog post I will discuss credit insurance, also known as credit-life or credit-plus insurance, as it is one of the most common charges associated with microcredit products.
(more…)
In my series of Bolivia posts so far, I have shared insights on several positive aspects of pricing transparency in the Bolivian microfinance industry. In today’s post, I’d like to highlight how MFTransparency’s pricing data will complement the Bolivian microfinance regulation and transparency efforts already underway.
Often when we talk about reporting the “true cost” of loans we are asked why it isn’t enough to simply tell borrowers the “total cost” of their loan—in other words, the total amount of interest they will pay over the life of the loan. At first glance this can seem like an obvious solution, but in reality it’s a deceptive way of thinking about loan price.
To see why, consider the following loans, all for the same amount:
by Martin Hadsell do Nascimento
Brazilians, as I’ve learned from having lived in the Northeast of the country over the past several months, love credit. Common are the signs sitting in most São Paulo storefronts that advertise the interest rate of products by the “vez”. The number of “vezes” or “aprestações” is the number of months across which the full price of a product can be divided, giving the consumer the number of installments in which one is allowed to pay for a good that can range from a car to a cellular phone to a t-shirt to a plate of beans and rice. Given the strictly monthly nature of such installment plans, perhaps it is logical that the interest rates associated with the purchases be denominated in monthly terms. However, when applied to Brazil’s microfinance industry, denoting prices in familiar monthly terms may also hide important factors that influence the true price of the loan.
by Tim Langeman
In a previous blog post, I described how to use a spreadsheet like Microsoft Excel to calculate interest rates. Again, interest rate calculations are at the core of MFTransparency‘s ability to provide accurate data that can be compared across various products offered by numerous MFIs. In the last post we looked at Excel’s IRR and XIRR functions and concluded that XIRR is more accurate because it takes into account the actual payment dates of the loan and thus allows us to calculate annualized interest rates even with irregular repayment schedules.
But for the more technical among us, I realize that even this may not be sufficient. Today I’m going to demonstrate how to write a computer program that is as accurate as Excel 2007′s XIRR function. This article is likely to be of less broad interest, but it provides transparency into how we will calculate interest rates for future data collection trips; and it may be useful for MFIs that wish to automate interest rate calculations for a larger data set than can be handled with Excel.
by Tim Langeman
Chuck Waterfield and Alexandra Fiorillo, MFTransparency‘s CEO and VP respectively, have been doing many presentations about how interest rates can be calculated using our excel tool, but we haven’t yet featured a story on our blog about our data collection process and our corresponding excel tool. Although technical, interest rate calculations are really at the heart of MFTransparency‘s mission and calculating accurate interest rates is vital to providing transparent pricing data. So today, I would like to give you a brief demonstration of the IRR and XIRR Excel functions, as a way to provide background for the techniques we’ve used to automate interest rate calculations on our web site.
For those of you less familiar with excel, this spreadsheet software offers numerous formulas allowing quick and easy calculations within each spreadsheet. As it is particularly geared towards financial use, there are ready made formulas specifically meant for calculating interest rates. The most basic (but still powerful) calculation is the internal rate of return. (more…)
Blog RSS Feed