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 Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.