|
|
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
|
|
|
