Whether you are looking to purchase and put a down payment on a new single family home, condominium, townhome or other real estate property and borrow money by taking out a new mortgage loan, or refinance an existing mortgage loan for debt consolidation of student loans, car (auto loans), credit card debt or other personal debt, or refinance a mortgage to take cash-out based of home equity built up in the home, or refinance a mortgage to get a lower current mortgage interest rate, Georges Excel Loan Calculator provides general estimates regarding what-if mortgage loan scenarios such as payment amounts, interest costs, amortization tables and loan comparison scenarios.
Georges Excel Loan Calculator includes four separate worksheets in one Excel spreadsheet template file providing different mortgage loan estimates for loan comparison and loan analysis. One worksheet allows you to enter the loan amount, fixed interest rate, loan term in years, and optional variable extra payments that can be changed to a different amount every month and based on that information will calculate and display in a table and charts the monthly payment amount, total interest, number of payments, and years to pay off for both scenarios of no extra payments vs. extra principal payments. The amortization schedule created will be based on extra principal payments if any were added. One worksheet allows for comparison of up to three mortgage loans with different loan amounts, fixed interest rates, loan term in years, and optional extra monthly payments.
For example, you can compare a 30 year vs. 15 year vs. 10 year loan at various loan amounts, fixed interest rates, and additional principal payments to compare total interest costs, monthly payments, and length of time to pay off mortgage debt in both table and chart format. One worksheet allows you to enter the loan amount, fixed interest rate, and loan term in years and based that information will calculate the monthly payment amount, total interest, number of payments, total length of loan in years, amortization schedule and charts. One chart shows payment breakdown between principal and interest over the life of the loan and another chart shows ending loan balance, cumulative payment, cumulative principal and cumulative interest over the life of the loan.
Georges Excel Loan Calculator is only for fixed rate mortgages and loans with monthly payments and where interest is accrued and calculated on a monthly basis. Georges Excel Loan Calculator is not for simple interest mortgage loans that calculate interest on a daily basis. Maximum loan term in years is 30 years. Georges Excel Loan Calculator is not for adjustable rate mortgages or loans. Georges Excel Loan Calculator is not for interest only mortgages or loans. Georges Excel Loan Calculator is not for home equity loans. Georges Excel Loan Calculator is not for home equity line of credit (HELOC). Georges Excel Loan Calculator is not for mortgages or loans that have biweekly payments, bimonthly payments, or any other payment period that is not on a monthly basis.
Georges Excel Loan Calculator does not factor in closing costs, discount points, property taxes, and insurance. Amounts are in US $ currency only. Georges Excel Loan Calculator is software in the form of an Excel spreadsheet template file, that requires Microsoft Excel 2007, Excel 2010, Excel 2013 or higher to open the file. Georges Excel Loan Calculator is available for purchase via digital download. The calculations generated by Georges Excel Loan Calculator are rounded and estimates only. Georges Excel Loan Calculator and its calculations are provided as-is without any guarantees as to their accuracy and are not intended to replace mortgage terms, amortization tables, payment amounts, pay off amounts, final payments, and other terms provided by the bank or lending institution of an actual mortgage or loan.
- Supported OS: [Windows 8, Windows 7, Windows Vista, Windows XP]
- Processor: 1.5 GHz processor or higher
- RAM: 1 GB or more
- Hard Disk: 20 MB of free hard disk space
- Video Card: Integrated or dedicated video card
- Additional Requirements: Requires Microsoft Excel 2007, Excel 2010, Excel 2013 or higher
Mortgage home loan calculator with amortization schedule.
Mortgage calculator includes optional extra principal payments where you can add fixed extra payments or change the amount of the extra principal payment each month and see the impact on total interest costs and paying off mortgage early.
Separate worksheet to compare three mortgage loans. For example, compare 30 vs 15 vs 10 year loans at various amounts, interest rates, and additional payments to compare total interest costs, payments, and length of time to pay off mortgage debt.
Amortization schedules / tables that show loan balance and payment breakdown on a monthly basis are automatically calculated by Excel by entering loan amount, annual interest rate, length of loan in years, and optional additional payments
Charts / Graphs are displayed that show key information to help visually compare different mortgage loan scenarios based on loan amount, interest rates, terms in years of loans and optional extra payments.