Accounting for Prosper in Quicken Strategy Update?

Yesterday I received a comment from a reader:

Question: would the principal repayment be considered a “return of capital?” as opposed to a sale? What are the implications of using one category over the other? I’ve taken a look at the irs (a search on the phrase returned numerous results) and wikipedia (http://en.wikipedia.org/wiki/Return_of_capital)websites on the topic, but I’m still a little hazy.

I could only find the IRS applying the phrase to stocks and mutual funds.

I’ve tried both in Quicken. Recording principal payments as sales resulted in my cost basis increasing when that payment was reinvested, but with return of capital used the cost basis did not increase. (Well, technically it did with the purchase, but it declined by an equal amount when the payment was recorded.)

I tried the suggestion and it keeps my cost basis at my original dollar moved into Prosper amount.  I like this very much, but when I make this change Quicken thinks my ROI YTD in the account 50%.  Clearly, something is not right.

Looking a little deeper, if I use return of capital the cash balance increases but the assets stay the same.  This is a problem.  The assets (prosper loans) need to decrease in value by the amount of capital returned.

Sale is the right choice.

Blog Traffic Exchange Related Posts
  • Amount LAte Vintage CurvesVintage Curves 04 2008 -- Amount Late By Credit Grade from Origination It is time for my monthly update of the amount late vintage curves... The y axis is the percent of $$ 30 more more days late... the x axis is days from origination.  The curves stop when there are less than 250 loans in the bucket. There are ways to......
  • blog traffic exchangeProsper Ordered to Cease and Desist by SEC http://www.sec.gov/litigation/admin/2008/33-8984.pdf It appears to me that the ruling is that they have been selling unregistered securities without a license.  What does that mean for the lenders?   Doesn't the board and company officers have some personal liability too? There is some discussion at prospers.org: http://www.prospers.org/forum/prosper_order_to_cease_and_desist_by_sec-t10903.0.html No one seems sure just yet... SEC: UNITED......
  • blog traffic exchangeBlogger Obtains Loan Using Social Capital Any regular reader will know that last week I brought my first group listing to the marketplace. (As an aside, a group leader is no longer paid for successful listings and the haven't been since September 13, 2007: Email To Group Leaders After Recent Changes. I think this was a......
  • RateLadder.com LoanNew Loan Funded — Working Capital Loan for Post Production Company — $21,000 at 18.50% — B Credit — DTI 59% A new loan funded (Working Capital Loan for Post Production Company — $21,000 at 18.50%).  I participated via a manual bid, this was an autofunding loan.   The borrow had B credit and 59% DTI.  As a reminder my standing orders (and manual bids) only find loans with 0 current delinquencies, 10......
  • blog traffic exchangeOne Loan Late. Not supposed to happen to AA. What does that mean? Of my 46 loans.  1 is now late (less than 15 days). Here is what Prosper.com says will happen now: What exactly happens if I'm late? Below is the schedule that Prosper follows in the event of a borrower missing a payment due to insufficient funds (NSF). At any point......
Blog Traffic Exchange Related Websites
  • moneyWhat Steps Do I Need to Take to Get On Solid Financial Ground? Learning how to live on a budget will force you to manage your debt and spending. Want financial security? With a small amount of planning, you can have it. Reduce your debt, cut expenses, while making saving and investing a habit. You`ll be on your way to reaching financial goals......
  • blog traffic exchange5510-20B-2 Twin Engine Fuel Meter - I/B, I/O, O/B - Up to 100HP - 10% Summer Sale! Price shown reflects 10% discount. 5510-20B-2 Twin Engine Fuel Meter - I/B, I/O, O/B - Up to 100HP - 10% Summer Sale! Price shown reflects 10% discount. CruiseMaster 5500A Series 5500 CruiseMaster Fuel Monitoring System will increase any boat's effective range by accurately recording total fuel consumed by pinpointing optimum speed. Now you can spend......
  • bloggingEnhancing your Business with Blogging Blogging has become an extremely popular activity for businesses, and it also has created a very important impact in other circles as well, including an activity for the political scene as well as for ordinary individuals as well. Google purchased Blogger in 2003, and ever since, blogging has continued to......
  • short_term_rates_2008Capital Gains, Losses and 2008 Tax Rates For a couple of reasons I recently started reading up on capital gains taxes. I'm purchasing a condo in the next few weeks with the goal of selling it in a few years and realizing a capital gain. Also, I have a goal of earning a sufficiently high income to......
  • blog traffic exchangeSales Marketing Software Sales represent the final goal of any business! And in times of financial crisis a quality sales marketing software can make the difference between money gain and money loss. The consume society seen from the perspective of the investors or producers requires a lot of monitoring in order to identify......
Online Stores If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Prosper.com, Tools



Tags:

,


1 comment so far ↓
#1 chris on 04.24.07 at 11:26 am

You need to adjust the security prices for the return of capital. I had the same issue. It is a pain. Using the market value field in the data entry seems to cause weird behavior, as well. I edit the securities price history, and get a realistic IRR (that is WAY lower than what I’d hoped for).

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