Author Topic: Rough idea on a month's P&I vs payoffs  (Read 3171 times)

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Rough idea on a month's P&I vs payoffs
« on: August 01, 2015, 05:07:40 PM »
I've been showing my significant other a rough idea of what were are getting back each month recently.

Does this rough method make sense? 

- Account Activity screen  https://www.lendingclub.com/account/getLenderActivity.action#
- Select a given months range
- Select 'Payment&Fees' for 'Type'
- Click on Type to group 'PAYMENTs' by date and 'Investor Fees' by date.
- Cut-n-Paste the Orange and then the Blue section with 2 columns between into Excel or the like.
- Do the simple formulas to remove payoffs for the yellow and purple columns.
- Roughly 1/4th of the SUM'd yellow column is the earned amoritized interest

Image: http://i.imgur.com/LLREP6u.png


Image: http://i.imgur.com/QMzgmea.png
« Last Edit: August 01, 2015, 06:00:09 PM by lascott »
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

Fred93

  • Hero Member
  • *****
  • Posts: 2161
    • View Profile
Re: Rough idea on a month's P&I vs payoffs
« Reply #1 on: August 01, 2015, 06:11:18 PM »
Quote
- Roughly 1/4th of the SUM'd yellow column is the earned amoritized interest

I was following until you did the "1/4".  Why 1/4?

They don't make this easy, do they?  It is now nearly impossible to get at the breakdown of payments (p vs i) on the web site.

Here's a different approach.  Go to your monthly statements.  Look at the "earnings summary".  Look at the "This period" column.  Write down the "total" from each month.  That's what you earned that month.  All the interest, writeoffs & fees, and none of the principal repayments.  You can also look at the "account total" box and write down the total account value at the beginning of the month and divide.  If the total earnings is $1 and your total account value was $100, then you made $1/$100 = 1% that month.   1%/month annualized is 12.7%/year. 

This approach neatly removes any need to subtract or adjust for principal payments or payoffs.

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Rough idea on a month's P&I vs payoffs
« Reply #2 on: August 01, 2015, 09:50:40 PM »
Quote
- Roughly 1/4th of the SUM'd yellow column is the earned amoritized interest

I was following until you did the "1/4".  Why 1/4?

They don't make this easy, do they?  It is now nearly impossible to get at the breakdown of payments (p vs i) on the web site.

Here's a different approach.  Go to your monthly statements.  Look at the "earnings summary".  Look at the "This period" column.  Write down the "total" from each month.  That's what you earned that month.  All the interest, writeoffs & fees, and none of the principal repayments.  You can also look at the "account total" box and write down the total account value at the beginning of the month and divide.  If the total earnings is $1 and your total account value was $100, then you made $1/$100 = 1% that month.   1%/month annualized is 12.7%/year. 

This approach neatly removes any need to subtract or adjust for principal payments or payoffs.
Thanks for that example.

Sorry for the confusion about the 1/4 or 25% number.  It was a rough number just accounting for early payoffs.  Not sure if people use some other general percentage of P&I for their interest earnings (excluding what tax bracket you are in)?

I used 17|18 months of a 36 month loan. ... or the completed loan.  Both about 1/4.

Image: http://i.imgur.com/8Da5OuQ.png


Image: http://i.imgur.com/mIuPrAw.png
« Last Edit: August 02, 2015, 07:48:11 AM by lascott »
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

rawraw

  • Hero Member
  • *****
  • Posts: 2767
    • View Profile
Re: Rough idea on a month's P&I vs payoffs
« Reply #3 on: August 02, 2015, 11:01:12 AM »
Why don't you just use your monthly statements to get the interest?

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Rough idea on a month's P&I vs payoffs
« Reply #4 on: August 04, 2015, 11:00:02 AM »
Why don't you just use your monthly statements to get the interest?
I haven't looked at monthly statements that much recently. They usually are a few days after the end of the month.
I was just doing some rough math thought others may have some guidelines too.

I'm out of town a few days and will check out statements for a few months when I'm back.

Nice to have P2P investing keep chugging along as I'm enjoying some time away.
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y