Accounting 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 depending on the outcome.

I have no idea what the outcome will be, but either way I would need to account for the real world situation in Quicken as accurately as possible.  If you take the buyout your accounting is fairly straight forward: Debt Sale Accounting via Quicken.

However, for reasons that are more informational than financial I am choosing to participate in the loan pool and therefore need to account for the process.

(This is not clean accounting, but at the end of the process it will accurately reflect what happened.)

Step 1: Write off all principal in the pool as worthless.  For me, this amounts to a sale transaction of 325.26 shares at a price of $0 per share dated on the day Prosper marks the loans defaulted.

Assuming the loan pool produces net recoveries for each recovery amount:

Step 2: Adjust the Step 1 transaction reducing the number of shares in the sale transaction by the amount of the recovery at a 1:1 ratio of shares to dollars. If the net amount recovered  equals or exceeds the original principal amount simple delete the Step 1 transaction.

Step 3: Enter a new sale transaction dated for the recovery payment date with the number of shares equal to the number of dollars recovered and a sale price of $1 per share.

This will result in no assumptions about recovery in Quicken.  On Day 1 my quicken account will look like it lost $325.26 of assets and value.  My quicken ROI will take an immediate hit, but potentially this loss will be removed over time.

For me, the $33.11 I have to “pay” to be part of the pool is worth it for the information.  I am glad it is not a larger amount as I do not know what the eventual outcome will be.

Blog Traffic Exchange Related Posts
  • blog traffic exchangeNew Agency Test Results Another interesting note from the official forum... New Agency Test Results Prosper is testing a collection law firm and is recording this on member accounts as "New Agency Test".  This is a limited pilot to test the process of collecting more aggressively on Prosper Accounts.  Thus far, in approximately one......
  • blog traffic exchangeAdam Nash Merged with RateLadder to form the Ideal Quicken Solution (without Prosper integration)  I have found what I think is the most complete solution to the Quicken and Prosper dilemma, but that doesn't mean it is the best solution...  Let me start with the negative and work to the positive... The problem with his solution is that it is too much work...  I......
  • blog traffic exchangeMy Prosper Internal Rate of Return Update (End of Apr 07) = 3.57% for an Increase of 0.24% 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 exchangeDebt 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......
  • blog traffic exchangeMy Prosper Internal Rate of Return Update (End of Jan 07) — 12.31% It seems that after some thought EnoughWealth and TB and hit upon the thing that wasn't quite right with my XIRR based IRR My Prosper Internal Rate of Return Update (End of Jan 07) — 18.14%.  It was double counting the interest since it was both being paid at the end......
Blog Traffic Exchange Related Websites
  • blog traffic exchangeOne Foot in Front of the Other This is a guest post from Kevin at No Debt Plan where he writes about helping you get and stay out of debt before building wealth. If you're too busy to visit his site, why not subscribe to his blog and catch up later? There are some amazing similarities between......
  • blog traffic exchangeSavings Account Forex Online Trading Re-inspection For SEM Company Blueprint Everybody can notice the sparky advertisements for the blueprints on the interner. Forex Online Trading A good number of the ones that I have seen in no way seemed like they would work, even if I put all of my time and effort into it. That is until I saw......
  • blog traffic exchangeUnderstanding Your Credit Report Score Your credit report score (or Fico score) plays a huge role in your financial future but surprisingly, most consumers haven't a clue what's in their credit report or how their credit score is calculated even though every consumer has the right to request a free copy of their credit report......
  • ccWhy is it Bad to Cancel a Credit Card? Unless the idea of streamlined credit you have in your head is having 8 credit cards in a single wallet, then chances are good that you have considered canceling some of the cards you do not use much. The truth about canceling credit cards: Do unused credit cards hamper you......
  • blog traffic exchangeHow to Beat the 10% Compounding Myth I had mentioned previously that for a number of reasons, it's very difficult to earn 10% interest on your money. However, I think I found a way to do it. Of course there's some risk involved. For those who get squeamish about the possibility of losing money, you might......
Online Stores If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Collections, Prosper.com, Quicken



1 comment so far ↓
#1 Prosper Roundup — AmSher is a New Collection Agency Edition on 01.27.08 at 8:51 am

[...] RateLadder explains Accounting for the New Agency Test in Quicken [...]

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