Blended rate calculator - plus rollover?

[Pixelshot]

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]

Throw together a quick spreadsheet.

[Pixelshot]

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]

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]

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]

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]

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]

The other article lists a nice online version of a snowballing calculator, simpler than the spreadsheet but works perfectly: http://ballofsnow.org