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 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 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 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 exchangeRateLadder Crosses 11K in Prosper Account Value After reaching the 10K milestone I stopped adding fund to my Prosper account unless the funds were generated in advertising/donations.  Today, my account value peaked over the 11K threshold ($11,079.42).  I am very happy with my progress to date.  To be sure, I wish I had avoided certain extended credit that......
  • 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 Exchange Related Websites
  • blog traffic exchangeUpdate On My Self Employed Income Projects A few posts back I described the various projects for self employed income. My pursuit of these projects has limited my activity on this blog,  but in the end I believe it will be beneficial for the growth of this blog. I'm hoping to make a significant enough amount......
  • geezeoGeezeo Review A number of financial planning and "get out of debt" websites have been springing up over the past year or so, because consumers are showing that they are looking for more online web applications and other tools for managing their finances. What makes Geezeo even more exciting in terms of......
  • blog traffic exchangeKeeping your Prosper.com money working Several people responded to my post on a Prosper.com vs ING return, in which I pitted a 4.25% online savings account return against lending the same amount at 8% on Prosper.com. The 4.25% online savings account outperformed the 8% loan over three years, because the interest in the savings account......
  • blog traffic exchangeScotiabank's Bank The Rest Savings Program Scotiabank has a unique savings program, called Bank The Rest, that rounds up your purchase to your choice of either the nearest $1 or $5. The extra amount is automatically transferred to a savings account for you. While this might sound like an easy way to save, the total savings......
  • blog traffic exchangeWealth Builder Ratios - Q3 2009 Update Here is our Q3 2009 Wealth Builder Ratio update. During the third quarter of 2009, the Dow, Nasdaq and S&P500 indices advanced about 15%. Through September 30, 2009, the Dow is up 10.7%. The Nasdaq rose 34.6% and the S&P 500 was up 17.0%. Although my company stock gained 14%......
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