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.



Loan Calculators

Microsoft Excel 2010
Family Budget Planner Spreadsheet
Loan Calculators
Download Download

Created On

Template Details

Created By: Admin
License: Private Use
(Only for personal Use)


Download free excel template and don't forget to like our Facebook page for latest updates.


Write a comment for this product!


Very nice

Please Write your Comments
Rating for product: