Loan Calculators
This spreadsheet contains eight calculators you can use to make personal financing decisions. Here are brief descriptions:
Loan Payments - Calculates the monthly loan payment necessary to amortize a simple interest loan. Payoff Amount - Calculates the principal balance owed on a loan based on the number of principal and interest payments that you have already made. Add-On Interest - Calculates the monthly payment on an add-on interest loan. Single Payment Discount Loan - Calculates the one payment of interest and principal that you need to make at some future date.
Effective Rate - Calculates the annual cost of a loan based on its contract rate, points, and loan term.
Balloon Payment - Calculates both the monthly payments and the final balloon payment of this type of loan.
Loan Consolidation - Calculates the loan payment you would make if you decide to consolidate several of your loans and debts into one loan.
Refinance Calculator - Calculates the monthly payment and the months to break-even on a refinance loan.
To view the template, click the worksheet tab labeled Template at the bottom of the screen or press CtrlPgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Loan Calculators
Loan Payments Assumptions Loan Principal Amount Annual Interest Rate Loan Period in Years Key Financial Data Annual Loan Payments Monthly Payment Interest Over Term of Loan Sum of All Payments Payoff Amount Assumptions Monthly Payment Annual Interest Rate Number of Payments Already Made Loan Period in Years
Pay off Amount
Add-On Interest Loan Assumptions Loan Principal Amount Annual Interest Rate Loan Period in Years Key Financial Data Interest Over Term of Loan Monthly Payment Sum of All Payments
Single Payment Discount Loan Assumptions Loan Principal Amount Annual Interest Rate Loan Period in Years Key Financial Data Total Interest Loan Proceeds Total Payments
Effective Rate - Simple Interest Loan Assumptions Loan Principal Amount Annual Interest Rate Loan Period in Years Points Key Financial Data Monthly Payment Effective Rate Loan Consolidation Assumptions Debts to be Paid Off with New Loan: Auto Loans Credit Cards Home Improvement Vacation Loans Other Loans Consolidation Amount Annual Interest Rate Loan Period in Years Monthly Payment
Balloon Payment Loan Assumptions Loan Principal Amount Annual Interest Rate Amortization Period in Years Years Till Balloon Payment Key Financial Data Monthly Payment Balloon Payment Refinance Calculator Assumptions New Loan Principal Amount Annual Interest Rate Loan Period in Years Current Monthly Payment Points on the Refinance Loan Other Estimated Closing Costs Key Financial Data New Monthly Payment Monthly Savings Months to Break-even