Top RateLadder Referrers Aug07

I would like to say thanks to the blogs that in the last 30 days were the top 10 referrers to RateLadder that are blogs.

No Comments | August 31, 2007 | Filed Under Site Statistics | Leave a Comment

RateLadder Loan Performance According to Prosper

I regularly write about the 2 methods of tracking my Prosper performance that I use: Quicken and IRR. It occurs to me that I haven’t said why I need to use these methods; which is to say, why is the Prosper tracking page inadequate.

To start with the easy, Prosper lacks integration with Quicken. This lack of integration forces me to manually enter transactions into Quicken. I have simplified my Prosper account in Quicken by rolling all loans together. Also, Prosper reports accrued interest (see example later) in the account balance. This creates an inflated account value from a pure Quicken tracking model..

To better understand why I use an IRR calculation let’s take a look at what Prosper claims is my loan performance…

Loans starting during this period					Net income (accrued)		Net defaults		Net gain/loss
No. of loans	Principal loaned	Avg. interest rate	Payments received	Loan value	APY	Amount	APY	Amount	APY	Amount
149	$9,547.15	18.35%	$2,279.35	$7,812.36	18.10%	$656.42	1.46%	$107.24	16.64%	$549.19

As previously stated, net income includes accrued interest. I think from Quicken and personal accounting perspective accrued interest has no place. After all, I don’t get to write off loss of accrued interest when a loan defaults.

Use of accrued interest on the performance page is speculative. It is the best possible assumption from a performance perspective. To be slightly facetious, all accrued interest will be paid and only the currently defaulted loans will default… leading to a net gain/loss that is completely unrealistic. It is only because accrued interest in included on the performance page that this hyperbole is valid. If it were only the net income actually received then it would be what has actually happened, but as is it is speculating as to future performance.

This is were my IRR calculation comes into play. It is my speculative look into the future trying to maintain an even (maybe even slightly negative) perspective. My IRR calculation takes actual cashflows and then uses the account balance (which includes accrued interest) as an outflow (as if you could liquidate your Prosper account on the spot) and the sum of all loans 1 month late or more as an inflow (as if all loans one month late or more are worthless). I then track this number through time to watch my Prosper performance.

I use Quicken to track exactly what has happened. I use the IRR calculation to speculate as to what will happen. I ignore the current RateLadder performance according to Prosper as it is a mixed picture.

No Comments | August 30, 2007 | Filed Under Prosper.com, Strategy, Tools | Leave a Comment

Pensioner Debt Sale Results for August 07 Sale

Pensioner (the former #1 lender on Prosper by amount loaned) has once again been generous in sharing his default debt sale results…

CreditGrade: B
Homeowner: No
Verified Account: Yes
Debt to Income Ratio: 11%
Sale date: Aug-24-2007
Principal balance before sale: $597.37
Proceeds from sale and forfeited group rewards: $91.16
15% of principal

CreditGrade: C
Homeowner: Yes
Verified Account: Yes
Debt to Income Ratio: 28%
Sale date: Aug-24-2007
Principal balance before sale: $6,726.58
Proceeds from sale and forfeited group rewards: $1,079.65
16% of principal

CreditGrade: C
Homeowner: Yes
Verified Account: Yes
Debt to Income Ratio: 20%
Sale date: Aug-24-2007
Principal balance before sale: $3,152.55
Proceeds from sale and forfeited group rewards: $513.78
16% of principal

CreditGrade: D
Homeowner: Yes
Verified Account: Yes
Debt to Income Ratio: 44%
Sale date: Aug-24-2007
Principal balance before sale: $3,523.97
Proceeds from sale and forfeited group rewards: $367.46
10% of principal

CreditGrade: D
Homeowner: No
Verified Account: Yes
Debt to Income Ratio: 50%
Sale date: Aug-24-2007
Principal balance before sale: $7,228.35
Proceeds from sale and forfeited group rewards: $1,014.06
14% of principal

CreditGrade: D
Homeowner: Yes
Verified Account: No
Debt to Income Ratio: 174%
Sale date: Aug-24-2007
Principal balance before sale: $2,063.97
Proceeds from sale and forfeited group rewards: $170.49
8% of principal

CreditGrade: D
Homeowner: No
Verified Account: Yes
Debt to Income Ratio: 41%
Sale date: Aug-24-2007
Principal balance before sale: $7,925.12
Proceeds from sale and forfeited group rewards: $1,122.22
14% of principal

CreditGrade: D
Homeowner: No
Verified Account: Yes
Debt to Income Ratio: 53%
Sale date: Aug-24-2007
Principal balance before sale: $8,884.50
Proceeds from sale and forfeited group rewards: $201.82
2% of principal

CreditGrade: E
Homeowner: No
Verified Account: No
Debt to Income Ratio: 45%
Sale date: Aug-24-2007
Principal balance before sale: $3,513.83
Proceeds from sale and forfeited group rewards: $368.16
10% of principal

CreditGrade: E
Homeowner: No
Verified Account: No
Debt to Income Ratio: 55%
Sale date: Aug-24-2007
Principal balance before sale: $1,850
Proceeds from sale and forfeited group rewards: $135.75
7% of principal

CreditGrade: E
Homeowner: No
Verified Account: Yes
Debt to Income Ratio: 48%
Sale date: Aug-24-2007
Principal balance before sale: $3,000
Proceeds from sale and forfeited group rewards: $66.97
2% of principal

CreditGrade: E
Homeowner: No
Verified Account: No
Debt to Income Ratio: 14%
Sale date: Aug-24-2007
Principal balance before sale: $2,316.65
Proceeds from sale and forfeited group rewards: $249.06
11% of principal

CreditGrade: E
Homeowner: No
Verified Account: Yes
Debt to Income Ratio: 40%
Sale date: Aug-24-2007
Principal balance before sale: $44.40
Proceeds from sale and forfeited group rewards: $4.66
10% of principal

CreditGrade: E
Homeowner: No
Verified Account: Yes
Debt to Income Ratio: 39%
Sale date: Aug-24-2007
Principal balance before sale: $146.75
Proceeds from sale and forfeited group rewards: $12.20
8% of principal

CreditGrade: E
Homeowner: No
Verified Account: Yes
Debt to Income Ratio: 26%
Sale date: Aug-24-2007
Principal balance before sale: $52.12
Proceeds from sale and forfeited group rewards: $4.50
9% of principal

CreditGrade: E
Homeowner: No
Verified Account: No
Debt to Income Ratio: 23%
Sale date: Aug-24-2007
Principal balance before sale: $6,038.86
Proceeds from sale and forfeited group rewards: $516.75
9% of principal

1 Comment | August 29, 2007 | Filed Under Prosper.com, Statistics | 1 Comment

Debt Sale Accounting via Quicken

In the recent default debt sale I had a loan sold. This is my first opportunity to account for such an event. I use Quicken for my personal finances including my Prosper account (read about it here).

Here are the details of my defaulted loan:

CreditGrade: AA
Homeowner: Yes
Verified Account: Yes
Debt to Income Ratio: 25%
Very Clean Extended Credit
Sale date: Aug-24-2007
Sale reason: Delinquency
Principal balance before sale: $143.87
Loan value before sale: $152.68
Proceeds from sale and forfeited group rewards: $36.63

$36.63 / $143.87 = .2546

So what did I enter into quicken?

I entered a Sale Transaction for 143.87 shares at a per share price of 0.2546. This generated proceeds of $36.63.

I had to immediately set the share price of the Prosper Loans security back to $1.

Works great. Now Quicken thinks my investment has an average annual return of 8.41%

No Comments | August 28, 2007 | Filed Under Prosper.com, Quicken, Tools | Leave a Comment