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......
  • RateLadder.com LoanNew Loan Funded — cash for small business — $25,000 at 14.5% — AA Credit — DTI 1422125% A new loan funded (cash for small business — $25,000 at 14.5%).  I participated via a manual bid the loan was Autofunding.  The borrower had AA credit and 1422125% DTI (undocumentable income).  As a reminder my standing orders (and manual bids) only find loans with 0 current delinquencies, 10 or less delinquencies......
  • RateLadder.com Loan2 New Loans (Part 1/2) -- CCSJ Marketing Acquisition & Expansion -- $20,000 at 15.65% -- C Credit -- DTI 14% A new loan funded this afternoon (CCSJ Marketing Acquisition & Expansion   (Loan #6383) — $20,000 at 15.65%).  I participated via my standing order: Low DTI -- AF.  Which is this loan was funded as a low debt to income ratio and was an auto-funding loan.  The borrow had C......
  • 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 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 Exchange Related Websites
  • 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......
  • blog traffic exchangeHow You’re Manipulated Every Day and Why It’s OK By the time you read this post today you’ve likely already been manipulated a dozen times.  Do you feel exposed?  Exploited?  Stupid?  You really shouldn’t feel manipulated.  It happens to all of us.  Do you feel better now?  Good, because I just manipulated you.  You should feel manipulated (just did......
  • 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 exchangeMacau Casino Bets on Japanese Customers An article about Venetian Macao "…Currently, Japanese account for less than 1 percent of total visitors to Macau, though the number is rising in line with overall growth. In the January-April period, the number of visitor arrivals totaled 7.12 million, up 19.6 percent from a year earlier, and 62,833 of......
  • blog traffic exchangeWhere Dave Ramsey and I Part Ways This is a guest post from Philip over at http://www.weakonomics.com.    Please check out his blog where he writes about personal finance in an edgy, yet entertaining way. You can subscribe to his RSS feed here. I may not agree with everything he's writing here,  but I think it's important......
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