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 exchangeRateLadder and LazyMan Default Debt Sale Results RateLadder had 1 loan in the recent debt sale. 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......
  • RateLadder Quicken ROI Update November 1, 2007 I have decided to continue to track my Quicken ROI even though Prosper has removed the Prosper ROI link from the lending tab. I have also decided to keep the Prosper ROI on the graph for reference. This Quicken ROI is calculated using the method described here. My Quicken Prosper......
  • blog traffic exchangeMy Prosper IRR Update Normally, I expect to update My Prosper Internal Rate or Return twice a month: last day of the month for account value and the day I get the monthly statement.  Since posting My Prosper IRR yesterday, I have gotten my monthly statement; hence, there will be 3 updates this month (yesterday, today,......
  • blog traffic exchangeProsper.com and Your Emergency Fund I was reading an article on bankrate.com about Using a CD Ladder as Parking Locations for Your Emergency Fund. One of the big problems with a CD Ladder is the finite number of times you can withdraw money without a fee. Another big problem is length of time it......
  • blog traffic exchangeMy Prosper Internal Rate of Return Update (End of Jun 07) = 5.75% This is a RateLadder only IRR update. (An IRR lender “game” update is in the works.) Here is my permanent tracking page: http://rateladder.com/my-prosper-irr/ My Prosper IRR is defined as: Monthly cash flows with one extra month using the current account value minus any loans 1 month or more late. Current......
Blog Traffic Exchange Related Websites
  • 223/5.56 Caliber Bullets; For: 223/5.56 Caliber 223/5.56 Caliber Bullets Product Description223/5.56 Caliber Bullets - 223/5.56 Caliber (.224") 62gr TacX Boat Tail (Per 50)Manufacture ID: 22406TacX .224 62gr Boat Tail 223/5.56 (Per50)All-copper TAC-X rifle bullets have a proven reputation for accuracy. They’re designed for controlled double-diameter expansion maximum penetration and full functionality at long range. Straighter......
  • compoundinterest.gifCompound Interest Week: An Introduction A lot of personal finance bloggers write about compound interest. I have written about it myself in the past. This week, I'd like to cover compound interest in more detail than I have in the past. I hope to cover some new ground in this area and/or put a little......
  • 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......
  • weight loss chartWeight Tracking (Last Attempt) Total Weight Lost: 58lbs Here is my weight tracking page... It will evolve as I get more accustomed to my new lifestyle, but for starters if you want to know about the Jumpstart Medicine weight loss program that I am following read this post WeightLadder Reset — 390lbs and Starting......
  • blog traffic exchange32in Jensen LCD TV An exceptional high definition picture at an incredible value with the JE3208RTL Jensen LCD RV TV. Reinforced cabinet structure and mounting points to handle shock and vibration while on the road. Conformal coated circuit boards to protect against corrosion and humidity. Easy to use front controls 32" LCD RV TV......
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