Federal Student Loan Repayment Calculator

Instructions

This spreadsheet will help you calculate the best income-driven plan for any set of current or future set of incomes. It will also allow you to see the effect of filing jointly or separately (if married).

Note that if you are not eligible for PAYE, then use our 'Old' IBR vs REPAYE calculator. Remember that PAYE is always better than any kind of IBR. So if you are eligible for PAYE, there is no need to do any calculations for IBR.

Enter your data in the white boxes. Start with your total loan balances and average (weighted) interest rates broken into subsidized and unsubsidized loans. We have a calculator to help figure out totals and weighted average interest rates. Then enter your family size and estimated/projected Adjusted Gross Incomes for up to 10 years.

The graphs and charts should auto-adjust as you enter data, but there might be a delay of several seconds before they are updated, especially at first. Leave “Spouse AGI” at “$0” for all years if you are not married (or not planning to get married). Scroll down to see all of the results. The goal is to minimize your total costs over the years you have the loans. For example, if just starting out making PSLF-eligible payments, your goal is to have the lowest number in the "Running Total Loan Costs" chart in year 10.

 

Important

This spreadsheet is meant only to illustrate general principals and we make no warranty as to the accuracy of any of the calculations. While we believe it to be accurate, there are some simplifying assumptions made which may not apply to you.

For example, the same family size is applied to all years in the chart. Also, if you have subsidized loans, you are eligible for subsidy with PAYE, but we do not (yet) account for those in our calculations.

This spreadsheet is free for individual use and for use by student financial aid offices but cannot be shared or reverse engineered and the copyright is reserved by the founders of DOCTORED MONEY.