Unknown Loan Variable Calculator

Show expandable text

Warning

Product support for ToolBox CS ended on October 31, 2022.

Help & How-To Center content for ToolBox CS may be outdated and is used at your own risk.

When one of the following loan components is missing, this calculator determines which component is missing and then produces a payment schedule.

  • Interest rate
  • Length of loan
  • Payment amount
  • Loan amount

Example

A borrower is considering a bank loan and can pay up to $500 per month for two years. How much can they borrow?

Field Input
Loan amount $0
Years of payment 2
Annual interest rate 9%
Each payment $500
Payments per year 12

In this example, the calculated loan amount is $10,944.57.

Notes

  • The interest calculation uses 365 days in a year. If the loan uses a computation not covered by this calculator, use the Custom Loan Payment Schedule calculator. By entering all the information about the loan and adjusting the missing variable, the Custom Loan Payment Schedule calculator may be able to give the desired results.
  • The difference between the interest rate and the effective interest rate is caused by the compounding of interest.

Copying and pasting loan payment schedules into Microsoft Excel or other applications

View this procedure to find out how to copy loan payment schedules from this calculator to the application clipboard, and then paste them into Microsoft Excel or other applications.

Was this article helpful?

Thank you for the feedback!