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 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 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......
  • 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 exchangeAnother Default Debt Sale Prosper completed another debt sale...  The details are not yet on the Default Sale History page; however, Prosper Shira did make an announcement on the forums... We completed a debt sale this week which will be evident in participating lender accounts over the next few business days. When a loan......
  • 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
  • calcPresent Value and Future Value - Understanding the Difference In macroeconomics, two important financial structures are the present value and future value. Below is a discussion describing the two structures, and how they differ from one another. Present versus future value is analogous to the concept that today's dollar will be worth more in the future. This concept is......
  • 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......
  • 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 exchangePowerball AU 40 million Tonight's Powerball Jackpot of AU $40 million is the biggest ever offered on Australian Powerball. If one person wins the entire $40 million Jackpot, they will become Australia’s largest ever lottery winner! It is good value to have a go today, even if they are hard to pick. The Saliu......
  • :)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......
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