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%

 

Blog Traffic Exchange Related Posts
  • blog traffic exchangepninen in Prosper forums -- Magnificent Writeup on the Lender Costs of Not Paying Interest Here is the post in it's entirety because it is that good: In the early days of Prosper, I estimated that the cost of my idle cash (cash balance waiting to be bid, cash tied up in bids, cash tied up in loan verification, cash tied up waiting for payments......
  • blog traffic exchangeProsper in May Set a New Monthly Loan Origination Volume High Water Mark (sql to produce statistics at the end of post)  In May, Prosper originated more loan volume than in any previous month roughly 9.6M loans the vast majority were credit grades AA-C.  This is great news for Prosper on 2 fronts: total volume and loan quality. Here is the breakdown... May......
  • blog traffic exchangePensioner 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......
  • blog traffic exchangeAccounting for the New Agency Test in Quicken Recently it was revealed that Prosper is Going To Sue Deadbeat Borrowers and that lenders on the loans would be given a choice between taking a guaranteed upfront buyout at the price of the last junk debt sale or participating in the loan pool suit and reaping the consequences or rewards......
  • blog traffic exchangeLoan Rate Ananlyzer Strategy Update With some of the loans that I analyze there aren't enough matching loans to analyze the interest rates.  I have been thinking of ways to increase the pool of loans without changing the match characteristics.  To that end from what I can tell DTI seems to be the least correlated......
Blog Traffic Exchange Related Websites
  • jerrykellyStricker and Kelly win Shark Shootout The 2009 Shark Shootout, held at the Tiburón Golf Club at the Ritz-Carlton Golf Resort in Naples, Florida, ended on Sunday, won by the team of Jerry Kelly and Steve Stricker. The team went into the lead on Friday's first round, tying with the team of Justin Leonard and Scott......
  • blog traffic exchangeOnline Income Update: 1st Quarter 2009 Several of my long time readers have asked me to post my online income. I didn't realize that I haven't posted the passive income and online revenue numbers since December. A few reader are just starting to make money online and are particularly curious! So here's a quarterly breakdown for......
  • :)Ten Largest Banks in the U.S. The Move Your Money campaign peaked a few weeks ago but in our household we still haven’t yet made the change from a large bank to a local community bank or credit union. Part of the reason is inertia, the center spoke in our financial network map if our Bank......
  • blog traffic exchangeEvan By The Numbers March 2010 One of the main reasons that I started this blog was to hold myself accountable, since I truly believe that Accountability Leads to Success when dealing with personal finance and me..  Oh so you want to question my belief? Check out my FIRST post from August 2008 it is right there......
  • mind body wellness camps logoMind Body Wellness Solutions of Orlando Mind Body Wellness Solutions of Orlando Mind Body Wellness Solutions is the answer to all of your fitness and nutritional needs. Mind Body Wellness Camps in Orlando offers various comprehensive programs to ensure success for men and women in all walks of life. Fitness, Personal Training Camps Mind Body......
Online Stores If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Prosper.com, Quicken, Tools



Tags:

,


1 comment so far ↓
#1 Master Wong on 12.15.08 at 11:56 am

How would you record charge-offs in Quicken?
The lines on Proper statement are:
Charge-offs: -$51.537445
Interest: -$2.059444
Late fees: -$0.666668
Principal: -$48.811333

Leave a Comment

aa algorithm axis azerbaijan banks benefit blog borrowers ceo Collections credit grade credit history credit information credit score curves doug fuller email friends and family good luck google income borrowers interest rate interest rates investments launch lenders lending institutions liquidity loans marketplace money mozambique peer to peer lending portfolio plan private data promissory notes quiet period registration statement risk securities and exchange securities and exchange commission spreadsheets sql student loans Zopa