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 exchangeQ & A with Doug Fuller, Prosper’s Vice President of Operations This is a verbatim reprint of a Prosper forum annoucment... Doug Fuller, background: For over two decades Doug Fuller has been a leader in data driven operations management and process optimization with a specialty in collections and risk-management. Most recently he served as Chief Research Officer at Credigy, a provider of......
  • 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 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 Exchange Related Websites
  • financial newsBrown agrees to bin the Tobin tax UK Prime Minister Gordon Brown was observed to be rapidly retreating from his proposal that a financial transactions tax be imposed to aid the global economy. Brown, made the speech on Saturday at a meeting of global finance ministers, suffered a backlash on his proposal to implement a miniscule......
  • 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......
  • vacation_home_taxNew Rules for Capital Gains Taxation of Second Homes The IRS has targeted vacation homes, second homes, and even rental homes with new rules that govern taxation of capital gains. These new rules go into effect January 1, 2009.  Because ownership (or desire of ownership) of vacation homes is most common among baby boomers, it is an important issue......
  • 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......
  • Bank accountsKnees knocking in the UK as budget day approaches You may love him or you may hate him, but one thing is for sure, not many UK citizens would like to be in Alistair Darling's shoes on Wednesday when he makes his eagerly awaited budget speech. Chancellor Darling is expected to announce spending cuts of around some £15billion of......
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