finance-business · personal-finance · debt

Student Loan Repayment Planner Calculator

Prices a student loan on the repayment term you choose and puts the ten, twenty and twenty-five year terms beside it from the same balance and rate, so the cost of a longer plan is a number rather than a feeling. It also prices what happens before repayment starts: interest that builds up during school, a grace period or a deferment, and what it costs once it is added to the balance and begins earning interest of its own. Income-driven repayment is not modelled and the workbook says so.

Last updated

Calculator overview

Inputs and outputs

This summary comes from the calculator's published input and output contract.

Inputs

Extra Monthly Payment
When omitted Blank
About this input

Anything you pay each month on top of what the plan asks for. It goes straight against the balance, so it shortens the loan rather than lowering the payment. Leave it blank if you intend to pay only what is due.

Unit $/month Default Not set Range 0 to 5000
Loan Balance (required)
About this input

What you still owe on the loan today, before any interest that has built up while payments are deferred. Enter the principal only. If you are planning several loans at once, add the balances together and use a rate somewhere between theirs, and read the answer as an approximation rather than a statement.

Unit $ Default 30000 Range 0 to 300000
Term Years (required)
About this input

How many years of payments the plan runs for. The payment is whatever clears the balance in that time, so a longer term is a smaller payment and more interest, and both effects are shown. Enter the term you are considering rather than the one you have, because comparing terms is what this tool is for.

Unit years Default 10 Range 5 to 30
APR (required)
About this input

The annual interest rate on the loan, as a percentage of the balance. Federal loans carry the fixed rate of the year the money was paid out, and that rate never changes; a private loan may carry a variable rate, in which case this is only the rate today. Interest is charged here once a month at this rate divided by twelve.

Unit fraction Default 0.065 Range 0 to 0.18
Capitalize Interest (required)
About this input

Whether the interest that builds up before repayment is added to the balance. Yes means it becomes principal and earns interest of its own for the rest of the loan, which is what happens on an unsubsidised federal loan when repayment begins. No means you pay it off instead, so it is interest you paid but it never grows.

Default Yes Allowed Yes, No
Deferral Months
When omitted Blank
About this input

How many months pass before the first payment is due, counting time in school, a grace period, and any deferment or forbearance. Interest still builds up over those months on an unsubsidised loan. Leave it blank if payments start straight away.

Unit months Default Not set Range 0 to 60

Outputs

Table1 Student Column Input
About this output

Machinery, and NOT an input. The same for the column axis: Excel substitutes into it while filling the grid, and the rest of the time it mirrors the annual interest rate.

Unit fraction
Table1 Student Corner
About this output

Machinery. Excel requires the formula being tabulated to sit in the grid's top-left corner, where it means nothing to a reader, so it is formatted away. It holds the interest paid.

Unit currency
Repayment Balance
About this output

What repayment actually starts from: what you owe now plus anything that was added to it. Every payment, every interest charge and every figure below is computed from this rather than from what you originally borrowed.

Unit $
Table1 Student Column Axis
About this output

The values across the top of the grid: the annual interest rate, in steps of one percentage point either side of yours and never below zero. Read a column to hold the rate fixed and vary the term. The middle entry is your own rate.

No unit declared
Table1 Student Row Axis
About this output

The values down the left of the grid: the repayment term in years, in two-year steps either side of yours, never shorter than a year and never longer than the thirty years the schedule unrolls. Read a row to hold the term fixed and vary the rate. The middle entry is your own term.

No unit declared
Total Interest
About this output

The interest charged over the whole plan, leaving out anything that was added to the balance before repayment started, because that became principal rather than interest. When nothing is added, it is every penny of interest you pay. What borrowing cost you altogether is always everything you pay less what you owed to begin with.

Unit $
Total Paid
About this output

Every payment you make over the whole plan, including anything paid on interest that was not added to the balance. This is the figure to compare between two terms, because it is the money that actually leaves your account.

Unit $
Table1 Student Row Input
About this output

Machinery, and NOT an input. Excel substitutes each value from the row axis into this cell while it fills the grid; the rest of the time it mirrors the repayment term. Change the term above, never this: the axis is derived from it, so editing the mirror moves the axis while the table walks and the grid comes out meaningless.

Unit years
Table1 Student Values
About this output

The body of the grid: the interest paid, recomputed for every combination of the two axes. One hundred and twenty-one cells, each one the whole plan run again. It is a component of the grid rather than a result on its own.

Unit currency
Payment 25 Years
About this output

What the monthly payment would be over twenty-five years, at your rate and with anything extra you are paying. Twenty-five years is the longest of the published fixed terms.

Unit $/month
Interest 20 Years
About this output

What the interest would come to over twenty years, on the same terms. It is usually more than twice the ten-year figure, which is the part the lower payment does not show.

Unit $
Interest 25 Years
About this output

What the interest would come to over twenty-five years, on the same terms. This is the highest of the three and the clearest measure of what the lowest payment costs.

Unit $
Capitalized Interest
About this output

The interest that built up before repayment and was then added to the balance. It is the part of your debt you never borrowed, and from the day it is added it earns interest like the rest. It is reported on its own line because once it becomes principal it stops being counted as interest, so a figure that looks like a saving is really a transfer.

Unit $
Interest 10 Years
About this output

What the interest would come to over ten years, on the same terms. Compare it with the twenty and twenty-five year figures to see what each extra decade of repayment costs.

Unit $
Model Status
About this output

Reads OK, or explains why the inputs are not valid or why a figure below deserves a second look.

No unit declared
Payment 10 Years
About this output

What the monthly payment would be if the same balance were repaid over ten years, at your rate and with anything extra you are paying. Ten years is the shortest of the published fixed terms and the one with the highest payment.

Unit $/month
Payment 20 Years
About this output

What the monthly payment would be over twenty years, at your rate and with anything extra you are paying. Roughly two thirds of the ten-year payment, which is why a longer term is tempting.

Unit $/month
Monthly Payment
About this output

The payment that clears the balance over the term you chose, not counting anything extra you decide to pay. It is the same every month.

Unit $/month
Months
About this output

How many monthly payments the plan takes. It matches the term you chose unless you pay extra, in which case it is shorter, and a plan that would run past thirty years stops there and the status line says so.

Unit months
This page is provided by LogicCommons for informational purposes only. Results are model outputs computed from the inputs you supply and are not financial, investment, tax, accounting, or legal advice, and no advisory relationship is created. Verify all inputs and results independently before relying on them in any decision.

LogicCommons is in beta. If a result, label, or reference looks wrong, tell us here; we read every message.

Methodology

Purpose and model boundary

Use this to price a student loan on the repayment term you choose, and to put the ten, twenty and twenty-five year terms beside it from the same balance and rate, so the cost of a longer plan is a number rather than a feeling. It also prices what happens before repayment starts: the interest that builds up during school, a grace period or a deferment, and what it costs once it is added to the balance and begins earning interest of its own.

Income-driven repayment is not modelled. Those plans set the payment from what you earn and can forgive a remaining balance, which is a different calculation from the fixed plans priced here.

Inputs and units

Input Unit Accepted range What it means
Loan Balance $ 0 through 300,000 What you still owe on the loan today, before any interest that has built up while payments are deferred. Enter the principal only. If you are planning several loans at once, add the balances together and use a rate somewhere between theirs, and read the answer as an approximation rather than a statement.
APR % 0% through 18% The annual interest rate on the loan. Federal loans carry the fixed rate of the year the money was paid out, and that rate never changes; a private loan may carry a variable rate, in which case this is only the rate today.
Term Years years 5 through 30 How many years of payments the plan runs for. The payment is whatever clears the balance in that time, so a longer term is a smaller payment and more interest, and both effects are shown. Enter the term you are considering rather than the one you have, because comparing terms is what this is for.
Capitalize Interest choice Yes or No Whether the interest that builds up before repayment is added to the balance. Yes means it becomes principal and earns interest of its own for the rest of the loan, which is what happens on an unsubsidised federal loan when repayment begins. No means you pay it off instead, so it is interest you paid but it never grows.
Deferral Months months 0 through 60 Optional. How many months pass before the first payment is due, counting time in school, a grace period, and any deferment or forbearance. Interest still builds up over those months on an unsubsidised loan. Leave it blank if payments start straight away.
Extra Monthly Payment $/month 0 through 5,000 Optional. Anything you pay each month on top of what the plan asks for. It goes straight against the balance, so it shortens the loan rather than lowering the payment.

Governing relationships

Interest before repayment is accrued simply on the balance, at the annual rate over twelve for each month of the deferral. It does not compound over that window.

What happens to that accrued interest is the choice you make. Where it is added to the balance, repayment starts from the balance plus it, and from that day it earns interest like the rest of the loan. Where it is not, it is paid off instead: money you handed over, but never principal.

The monthly payment is the level amount that clears the balance repayment actually starts from, at the monthly rate, over the number of months in the term. Each month is then charged one twelfth of the annual rate on the balance at the start of it, the payment is applied, and any extra goes entirely to the balance.

The ten, twenty and twenty-five year figures are the same calculation run three more times at those terms, on the same starting balance and the same rate, which is what makes them comparable with the term you chose.

Calculation sequence

This is the order in which the reported figures depend on one another, each step traceable to what the calculator says a figure is built from. It is not a claim about the order in which the workbook evaluates its own cells.

  1. Accrue interest over the months before repayment starts, at the rate over twelve on the balance, with no compounding across that window.
  2. Add that interest to the balance, or set it aside as interest paid, according to the choice you made.
  3. Take the balance repayment starts from, which is what every figure below is computed against rather than what you originally borrowed.
  4. Work out the level payment that clears it over the term you chose.
  5. Unroll the plan month by month with any extra payment added, to get the months it really takes and the interest charged along the way.
  6. Add every payment together to get what leaves your account over the whole plan.
  7. Run the same calculation at ten, twenty and twenty-five years to get the payment and the interest each of the published fixed terms would produce.
  8. Rerun the interest across a grid of terms and rates, so the trade between a smaller payment and a larger total is visible rather than asserted.

Outputs and interpretation

Output Role Unit What it means
Monthly Payment primary $/month The payment that clears the balance over the term you chose, not counting anything extra you decide to pay. It is the same every month.
Total Interest primary $ The interest charged over the whole plan, leaving out anything that was added to the balance before repayment started, because that became principal rather than interest. What the borrowing cost you altogether is always everything you pay less what you owed to begin with.
Capitalized Interest primary $ The interest that built up before repayment and was then added to the balance. It is the part of your debt you never borrowed, and from the day it is added it earns interest like the rest. It is reported on its own line because once it becomes principal it stops being counted as interest, so a figure that looks like a saving is really a transfer.
Repayment Balance detail $ What repayment actually starts from: what you owe now plus anything that was added to it. Every payment and every interest charge below is computed from this.
Total Paid detail $ Every payment you make over the whole plan, including anything paid on interest that was not added to the balance. This is the figure to compare between two terms, because it is the money that actually leaves your account.
Months detail months How many monthly payments the plan takes. It matches the term you chose unless you pay extra, in which case it is shorter.
Payment 10 Years detail $/month What the monthly payment would be if the same balance were repaid over ten years, at your rate and with anything extra you are paying. Ten years is the shortest of the published fixed terms and the one with the highest payment.
Payment 20 Years detail $/month What the monthly payment would be over twenty years, on the same terms. Roughly two thirds of the ten year payment, which is why a longer term is tempting.
Payment 25 Years detail $/month What the monthly payment would be over twenty-five years. Twenty-five years is the longest of the published fixed terms.
Interest 10 Years detail $ What the interest would come to over ten years, on the same terms. Compare it with the twenty and twenty-five year figures to see what each extra decade of repayment costs.
Interest 20 Years detail $ What the interest would come to over twenty years. It is usually more than twice the ten year figure, which is the part the lower payment does not show.
Interest 25 Years detail $ What the interest would come to over twenty-five years. This is the highest of the three and the clearest measure of what the lowest payment costs.

Model Status reads OK, or explains why the inputs are not valid or why a figure deserves a second look. It is shown alongside the results rather than in place of them.

The calculator also returns a grid that reruns the interest across a range of terms and rates at once. Its axes, corner and body arrive as separate values and are the grid's parts rather than results to read on their own; the page assembles them into the table.

Every figure above is returned by the model. The page arranges and formats them; it computes none of them.

Validation and status logic

These are the states the delivery's own recorded runs exercise, so the table records what this calculator has been observed to return rather than every branch it could take. A figure that moves with the inputs is shown as ….

Condition Returned status
A balance, rate, term, extra payment or deferral is below nothing NOT VALID: a balance, a rate, a term, an extra payment and a deferral cannot be below zero
No choice has been made about interest before repayment NOT VALID: choose Yes or No for whether the interest that builds up before repayment is added to the balance
The term does not come to a whole month NOT VALID: the repayment term has to come to at least one whole month; a term that rounds to nothing has no payment to compute
There is no balance to repay CHECK: there is no balance to repay, so every figure below is zero
Interest before repayment adds a large share to the balance CHECK: deferring adds … to the balance before repayment starts, which is more than …% of what you borrowed
The term is longer than every published fixed plan CHECK: a term of … years is longer than every federal fixed plan, so the payment is low and the interest is high
The plan runs past the months this model unrolls CHECK: this term runs past the 360 months this planner unrolls, so every figure above stops there; shorten the term or pay more each month
None of the preceding conditions applies OK

Assumptions and limitations

  • Interest is charged once a month during repayment, at the annual rate divided by twelve on the balance at the start of the month. A servicer accruing daily will differ slightly, usually by less than a dollar a month on an ordinary balance.
  • Interest before repayment is accrued simply rather than compounded over that window, which matches how student loan interest is usually described.
  • Income-driven repayment, graduated and extended plans, forgiveness of any kind and interest subsidies are all outside the model.
  • Origination fees, late fees and servicer fees are not modelled.
  • Several loans added together and priced at one blended rate is an approximation. Loans at genuinely different rates pay off at different speeds and the blend hides that.
  • A private loan on a variable rate will not behave like this, because the rate here is held fixed for the whole plan.

Restrictions and non-computing states

This calculator enforces the numeric limits recorded above before the plan is unrolled, so a value outside them is refused rather than answered.

A choice has to be made about the interest that builds up before repayment, because the two answers differ and neither is a safe default to assume on your behalf.

A balance of nothing is answered rather than refused, with every figure reading nothing, because nothing about those inputs is contradictory; the status line says so rather than letting a page of zeros look like an answer.

The plan is unrolled for a limited number of months. A term that runs past that window is followed only as far as it reaches, and the status line says every figure stops there.

Errors and warnings

NOT VALID means the inputs do not describe a loan this calculator can answer, and the figures beside it should not be relied on. CHECK is not an error: the arithmetic is sound and the figures stand, but something about the plan is worth knowing first, such as how much a deferral has added to what you owe. The status is shown with the results rather than in place of them, so a flagged answer is still a readable one.

A value the page itself refuses, because it falls outside the limits above, is rejected before the calculation is requested and no figures are returned at all. That is different again from a transport or service failure, where the page reports that the result could not be fetched rather than showing a stale or partial one.

References

The statutory source for federal student loan repayment, including the fixed plans priced here and the income-driven plans this calculator deliberately does not model, is the US Department of Education's Loan Simulator.

The interest rates that apply to a federal loan are fixed at the rate of the year the money was paid out; the current figures are published by the Department in its announcement of Direct Loan interest rates.

On how interest accrues before repayment, and on what happens to it when repayment begins, see Bankrate on how to calculate student loan interest and NerdWallet's account of the same calculation. Both describe a daily accrual where this model charges once a month, a difference of a few dollars a year on an ordinary balance, and both state that the interest does not compound over that window.

These sources provide background; they do not supply the calculator's assumptions or certify its result. This calculator is informational and is not financial, investment, or tax advice. Income-driven repayment and forgiveness of any kind are outside it, and for a federal loan the official simulator is the place to price those.

Results are informational and not professional advice. See our Terms of Use. Powered by SpreadsheetWeb · About · Privacy · Terms