Mortgage Loan Comparison Worksheet

Built in formula for accurate computations. This calculator will calculate the monthly payment and interest costs for up to 3 loans all on one screen for comparison purposes.

Loan Estimate Explainer

Weigh the pros and cons of various mortgages with this accessible loan comparison template.

Mortgage loan comparison worksheet. The first seven lines set the basis for the analysis and the remaining lines track the balance of the mortgage from the initial loan balance until the loan is paid off a process known as amortization. Loan comparison calculator compare loans calculate costs and more when it comes time to compare loans its always important to have a clear picture of all relevant costs. Subtotal add discount based on line 4.

This template provides a table of comparison for the contract terms. Existing va loan balance plus cost of energy efficient improvements 2. This loan analysis worksheet template in excel features a comprehensive table of the loan rates over the years for various terms of mortgages and installment loans.

Mortgage 1 mortgage 2 mortgage 1 mortgage 2. Use this accessible template to analyze various loan scenarios. Lender 1 lender 2 name of lender.

Interest rate reduction refinancing loan worksheet. Below is a worksheet you can use to start to do some economic analysis to compare mortgages. Payments 4 through 359 are not shown.

Looking for the best mortgage. Contents reputable florida reverse mortgage company monthly mortgage payments no upfront costs monthly calculator compare loans mortgage comparison worksheet free download as pdf file pdf text file txt or read online for free. Enter the interest rate loan term and amount and see the monthly payment total payments and total interest calculated for you.

2 mortgage comparison worksheet. Download edit in browser share. Note submit this form when requesting guaranty on an interest rate reduction refinancing loan.

Mortgage shopping compare home loan fixed adjustable. To calculate the payment amount and the total interest of any fixed term loan simply fill in the 3 left hand cells of the first row and then click on compute. All the loan comparison tools i found on the net were poor they didnt take into account a lot of really important factors that could change the outcome and cost people needless money.

Check register excel credit card payoff calculator excel mortgage loan calculator excel net worth summary. More templates like this. I wrote this loan comparison tool when my family was looking for a loan and i realized how difficult it was to compare loans accurately.

Other interest rates and loan terms are provided for comparison to help you make the choice thats right for your situation. Mortgage shopping worksheet author.

Mortgage Comparison Spreadsheet Excel Loan Payment Calculator