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
  • 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 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 exchangeProsper Lending Review -- 11 perspectives on p2p lending Prosper Lending review has an excellent new article. It combines 11 responses (including both Lending Club, Prosper, and yours truly) to a reader's question.  It is well done on all front's.  Here is the question asked: Reader's Question: I am in my mid-30's. I am not rich, but I am......
  • 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 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......
Blog Traffic Exchange Related Websites
  • blog traffic exchangeTradeKing Now Reimbursing New Clients For $150 In Account Transfer Fees. If you have been thinking of switching your brokerage house, now might be a good time to consider TradeKing. They are running a special where they are offering to reimburse new clients for up to $150 in account transfer fees, and once your account is over there trades are only......
  • blog traffic exchangeBest Places To Put That Tax Refund You Are Getting. Of course, the ideal thing to do is to not get one at all but that's a different story...it seems most people I know are getting a refund this year of at least a few thousand dollars. Not us, we owe money due to a withholding error at my last......
  • One Hundred Pushup Challenge -- Knee Push ups, 1 Handed Knee Pushups, and Full Push ups Well if you haven't heard by now then you aren't paying attention to the Health and Fitness blogosphere... Everyone is doing the 100 push up challenge at 100 push ups.   It is a 6 week training program geared toward a final test where 100 consecutive pushups are completed.  (My first......
  • blog traffic exchangeSize Matters For Emergency Funds A solid emergency fund is the foundation of any solid financial plan.  Having a little tucked away for rainy days puts some distance between you and the ledge of a financial cliff that could give way at any moment--usually from broken appliances, car repairs or major medical issues.  Most financial......
  • blog traffic exchangeHow to figure a restaurant tip Tipping is often a hot topic, and it varies by country and custom. This information applies to the United States. (It's been my experience that tipping generally occurs much less frequently and in significantly smaller amounts in Europe, for example.) Here is a little background related to the U.S.: Servers......
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