Home > Excel > Loans and Mortgages

Loans and Mortgages

Calculators For Excel  
Financial calculators for calculations of appreciation, assets, cash flow, home mortgage rates, future values of savings, loan spreads and more.
Submitted: Sep 17, 2003
Excel in Banking & Finance  
Free spreadsheet based tools for use in banking and finance. Useful for both lenders and borrowers.
Submitted: Feb 15, 2005
ARM Loan Calculator  
Adjustable Rate Mortgage (ARM) loans can be hard to understand. This free spreadsheet creates an amortization table and graphs for common fully amortized ARM loans, with optional extra payments. Estimates the maximum interest rate and monthly payment (one of the most important things to understand about ARM loans).
Submitted: Jul 30, 2005
Amortization Formulas in Excel  
This article reviews the main Excel functions used for loan amortization calculations (including the CUMIPMT and CUMPRINC functions that are included in the Analysis ToolPak). Download a free example spreadsheet that uses these functions for creating a payment schedule and a table showing the yearly summary of principal and interest payments.
Submitted: Jul 30, 2005
Bi-Weekly Mortgage Amortization  
The Bi-Weekly Mortgage program is designed to show you the savings of paying your mortgage bi-weekly (every other week), rather than once a month.
Submitted: Sep 11, 1999
Balloon Loan Calculator  
Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this free Excel template. Includes an amortization and payment schedule suitable for auto and mortgage loans.
Submitted: Jul 30, 2005

  Privacy - Trademarks - Feedback - Terms of Use Copyright The MathWorks, Inc.