Download the Kiva toolbar! - (what's this?)

May 24, 2012, 12:56:08 AM *
Welcome, Guest. Please login or register (it's quick and free!) for full access to all community features and functions, including instant messaging and message viewing preferences.

Login with username, password and session length

Cool Forum Options
: Not available. Login or register :)
: Popular Topics on Kiva Friends

Kivapedia
: View recent changes on Kivapedia
: Online shopping that helps support Kiva
: List of Kiva microfinance institutions
: List of Kiva group lenders
: Kiva Timeline : More...


.
Welcome to Kiva Friends, an active community for Kiva users, staff and supporters. Don't know what Kiva is? Read this!
   
   Home   Search Calendar Help Tags Login Register  

Pages: [1]   Go Down
  Bookmark This  |  E-Mail This  |  Print It  
Author Topic: A Payments Return on Investment (PROI)  (Read 4352 times)
0 Members and 3 Guests were last seen viewing this topic.
RichardF
Kiva Supporter
*****
Posts: 3939



View Profile
« on: July 20, 2008, 02:35:38 PM »

I wanted to have a financial index that represented the Kiva "lending" model better than those I was used to seeing in typical investment summaries.  For example, the Return on Investment (ROI) is something like

ROI = ((Final Value - Initial Value) / Initial Value) * 100.

Since Kiva doesn't pay interest to lenders, this ROI can range from -100% (a total loss of capital from defaults) to 0% (breaking even and pulling out all capital).

I don't like using this ROI index for Kiva because
a) it doesn't reflect the "grant" nature of these "loans;" and
b) it doesn't reflect the "re-lending" multiplier effect Kiva encourages.

I don't know if such an index that takes these factors into account is in common use anywhere, so I just made one up.

Payments Return on Investment (PROI) = ((Payments - Net Investment)/ Net Investment) * 100

I showed the details of how this index can be computed using Christopher's spreadsheet at that discussion.

The advantages to using this PROI for Kiva lending, as I see them, is
a) it assumes money sent out is a grant until it comes back, and
b) it shows how re-lending funds can have an ever-increasing multiplier effect, even if all the initial investment eventually disappears.

Here are a few examples to show how this PROI works.

ExamplePROI
A loan of $100 with no payments:  -100%
A loan of $100 completely defaulted:  -100%
A loan of $100 with $50 repaid:  -50%
A loan of $100 with $50 defaulted:  -50%
A loan of $100 completely repaid:  0%
Two loans of $100 completely repaid
from a single investment of $100: 
100%
Five loans of $100 completely repaid
from a single investment of $100: 
400%

As of today, I have received about $800 in payments from my net investment of about $1,000.  That means my current PROI is about -20%.  Based on my entrepreneurs' schedules of payments, I should "break even" real soon now - the payments I have received will be equal to the amount I have invested.  If I took everything out at that point, I still would have lost some cash due to defaults, but my money would have been repaid by someone due to re-lending.  After that break even point, any further payments I receive shows how my "grant money" has multiplied itself.

I'm sure folks can pick lots of holes / improve this index, so go at it.  The goal is to find a way to better represent the actual financial workings of the Kiva lending model.
Logged

Soul lives by giving.
Christopher
Kiva Supporter
London
*****
Gender: Male
Posts: 449



View Profile
WWW
« Reply To This #1 on: July 20, 2008, 03:18:46 PM »

Thanks Richard, that looks like a really good way of measuring the power of the Kiva lending model.
I think I might fire up the spreadsheet and have a play around to replicate and see how far I can take it.  I will be great to identify my break even point and if I can forecast it...
Cheers
C
Logged

If you think you're too small to make a difference try sleeping in a closed room with a mosquito, or give kiva.org a try.
Dagfinn
Kiva Supporter
*****
Posts: 514


View Profile
« Reply To This #2 on: July 20, 2008, 03:26:38 PM »

Clever thinking Richard and I think you have the right rationale behind it.  To see how far our money put in will travel so to speak is a godd measure of what we want to do.

And now maybe Cristopher come up with a revised speadsheet - all the better Smiley

Thank you both, Dagfinn A.
Logged
RichardF
Kiva Supporter
*****
Posts: 3939



View Profile
« Reply To This #3 on: July 20, 2008, 03:40:48 PM »

Cool. Yes  Considering the payment schedule info is in there, it also would be possible to include a projected break even date.  However, I'll leave that calculation up to Christopher!  Swoon Laugh
Logged

Soul lives by giving.
Pages: [1]   Go Up
  Bookmark This  |  E-Mail This  |  Print It  
 
Jump to:  

 
Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC
Thanks to PixelSlot
Valid XHTML 1.0! Valid CSS!
Page created in 0.244 seconds with 22 queries.