Author Topic: Blended rate calculator - plus rollover?  (Read 2024 times)

Pixelshot

  • Stubble
  • **
  • Posts: 146
Blended rate calculator - plus rollover?
« on: November 03, 2014, 02:16:19 PM »
I'm trying to calculate where my student loan balances will be in 5 years, 10 years, etc if we stay at the current payoff rate. My wife and I have three student loans that fall like this:

33.5K at 5.375%
25.5k at 3.0%
5k at 4.1%

I found this blended rate calculator - http://www.globalrph.com/blended.php - which shows a nice result of when the loans will be paid off with a certain payoff amount. However, it assumes that I won't roll over the payment amounts to apply to the remaining loans (in other words, as each loan is paid off, the total payment amount per month drops down). But, I want to know where I will be if I put, say $1000/month toward ALL of my loans each month, and then KEPT paying $1000 a month until I'm done. (or $2000, $3000, etc).

Does anyone know of a web site or formula that I can use which will calculate the loan payoff schedule with a blended rate, and also assume that I will rollover the extra payments?  Thanks.


skunkfunk

  • Handlebar Stache
  • *****
  • Posts: 1057
  • Age: 33
  • Location: Oklahoma City
Re: Blended rate calculator - plus rollover?
« Reply #1 on: November 03, 2014, 02:49:51 PM »
Throw together a quick spreadsheet.

Pixelshot

  • Stubble
  • **
  • Posts: 146
Re: Blended rate calculator - plus rollover?
« Reply #2 on: November 03, 2014, 06:41:32 PM »
that, for me, would take quite a while to figure it out so "quick" might not be the best description. Seems like there would be something like this readily available online but can't find one.

MDM

  • Walrus Stache
  • *******
  • Posts: 9676
Re: Blended rate calculator - plus rollover?
« Reply #3 on: November 03, 2014, 09:16:14 PM »
See http://forum.mrmoneymustache.com/ask-a-mustachian/spreadsheet-to-test-different-debt-payment-scenarios for a very nice spreadsheet by schimt that might apply to your situation.

If it doesn't, explain why not and someone may have an alternative.  From the OP I can't tell whether you intend to refinance the three loans into one (as implied by "blended rate") or continue to keep them separate (as implied by "rollover the extra payments").


MsWillow

  • Stubble
  • **
  • Posts: 135
Re: Blended rate calculator - plus rollover?
« Reply #4 on: November 04, 2014, 07:25:55 AM »
You can also set a goal on mint, which allows a debt snowball calculation with the end date given. If you increase payoff mount, it will move payoff date.

skunkfunk

  • Handlebar Stache
  • *****
  • Posts: 1057
  • Age: 33
  • Location: Oklahoma City
Re: Blended rate calculator - plus rollover?
« Reply #5 on: November 04, 2014, 07:27:20 AM »
that, for me, would take quite a while to figure it out so "quick" might not be the best description. Seems like there would be something like this readily available online but can't find one.

We could make one for you if we knew the minimum payments.

Pixelshot

  • Stubble
  • **
  • Posts: 146
Re: Blended rate calculator - plus rollover?
« Reply #6 on: November 04, 2014, 02:17:21 PM »
See http://forum.mrmoneymustache.com/ask-a-mustachian/spreadsheet-to-test-different-debt-payment-scenarios for a very nice spreadsheet by schimt that might apply to your situation.

If it doesn't, explain why not and someone may have an alternative.  From the OP I can't tell whether you intend to refinance the three loans into one (as implied by "blended rate") or continue to keep them separate (as implied by "rollover the extra payments").

Thanks. The loans were already consolidated upon our graduation (although different dates). They can't be combined. So, I will keep them separate.


Pixelshot

  • Stubble
  • **
  • Posts: 146
Re: Blended rate calculator - plus rollover?
« Reply #7 on: November 05, 2014, 04:57:16 AM »
The other article lists a nice online version of a snowballing calculator, simpler than the spreadsheet but works perfectly: http://ballofsnow.org