I'd like to create a spreadsheet that would show me the monthly payments for each of my Fed Loan repayment options. I want to see the impact of making extra payments or having my income change (for the income dependent loans) The standard and extended fixed repayment schedules are easy to program in excel. I can't find the calculations though that support the graduated, pay as you earn, and IBR options. The studentloan.gov calculator just gives you a single payment or range of payments so its hard to figure how it will change. I contacted them but they "do not provide that information".
Has anyone seen a spreadsheet that gives the whole payout for the various options or have any suggestions about the calculation?
Thanks for any suggestions!
Has anyone seen a spreadsheet that gives the whole payout for the various options or have any suggestions about the calculation?
Thanks for any suggestions!