mortgage calculator
Compare Today's Home Equity Rates

Mortgage Refinance Calculator Excel

Today's Home Equity Rates
Check Today's Mortgage Rates

Mortgage Refinance Calculator excel to calculate refinance payments and see how much you can save by refinancing your house. Use our refinance calculator to estimate your new monthly mortgage payment, interest savings, and get an amortization schedule with principal, interest, and monthly payment.

Refinance Calculator

Remaining Balance
$
Interest Rate
Current Monthly Payment
$
New Interest Rate
New Loan Terms
years
Closing Cost
$
Other Expenses
$ Check Local Mortgage Rates


Refinance Calculator

The refinance calculator is useful for those who already have a mortgage and looking to refinance their home. You will get a comparison table that compares your original mortgage against refinancing. You can export the refinance amortization schedule to excel or download it as a pdf file. For new homeowners, please use the conventional mortgage calculator with PMI to calculate monthly mortgage payments.


What is refinance?

Refinance is to pay off your mortgage and replace it with a new loan. When you refinance, your bank or lender will pay off your existing mortgage and generate a new mortgage. The new mortgage will have a different interest rate, monthly payments, or even a new term. The main reason for refinancing is to save money on the mortgage for the long term.


  • Lower Interest Rate - If the interest rate has declined since you got your mortgage, by refinancing, you may be able to get a much lower interest rate for your new loan, and hence save money on interest payments.

  • Switch from ARM to fixed interest rate - If you have an adjustable-rate mortgage, and are no longer comfortable with rising payments, you can switch to a fixed interest mortgage by refinancing.

  • Change Loan Terms - If you are starting with a 30-year mortgage, and want to pay off your mortgage earlier, you can refinance to a 15-year mortgage with a lower interest rate. Another way to pay off a mortgage faster is to make extra payments towards the principal of your existing mortgage.

  • Cash-Out Refinance - A type of refinancing that allows you to refinance a mortgage into a new loan that is greater than the outstanding balance of your current mortgage.

    You can then pocket the difference between the new loan and the remaining balance of your current mortgage. You can use the cash to make home improvements to increase the value of your home, and use the cash to pay off other debt with a higher interest rate, such as credit card debts.

How does refinancing work?

Refinance has a similar process as when you applied for your first mortgage. You shop around for lenders that give you the best interest rate or you can stay with your current lender. Staying with your current lender may save you some paperwork since they already have all of your information, but they may not offer you the best rate. After you find a lender, they will ask you for the same type of information as to when you first bought your home.


  • Credit Score - Lenders will check your credit score and see if you are qualified for refinancing, and credit score is one of the keys to determining what kind of interest rate you will be getting.

  • Income Check - You will need to provide your most recent pay stubs, W-2 statements or 1099, tax returns from the last 2 or 3 years, and bank statements to make sure you can afford the closing costs.

  • Employment history - Some lenders check your employment history to see if you have stable jobs. If you are self-employed, they may require more documents from you than if you were working for a company.

  • Substantial Home Equity - The more equity you have in your home, the better. Some lenders require the borrower to have at least a 20% equity in their homes in order to refinance, while other lenders may require less than 20%, but then you may have to pay a higher interest rate and pay extra each month for mortgage insurance or PMI.

  • Debt-to-income ratio - Lenders look at your DTI ratio to check how much debt you have and to determine if you can repay the mortgage. The lower your DTI, the better. If you have a high DTI, you will need to check with the bank to see what kind of DTI they can accept.

Once you get approved from the lender, they will pay off your mortgage, and you will get a new refinanced mortgage with the new lender.


How much does it cost to refinance?

Just like when you purchased your home, you have to pay closing close to get a mortgage, there are closing costs to refinance as well. Following are the standard fees that you should expect to pay.

  • Application Fee - This is the fee that you pay when you apply for refinancing. Some banks or lenders may be willing to waive this fee to get you as a customer.

  • Origination Fee - Some lenders require you to pay for a loan origination fee, it could be up to 1.5% of the amount that you are looking to refinance.

  • Appraisal fee - The bank will hire an appraiser to evaluate your house before the loan process begins, and you have to pay the appraisal fee. The appraisal fee varies from city to city, you may be charged anywhere from $250 - $600.

  • Attorney fees - Some states require you to have an attorney in the refinancing process. Even if you live in a state that doesn't require a lawyer, it is helpful to hire one to review all the documents and the mortgage terms to make sure there are no surprises down the road.

    Attorney fees vary from state to state, expect to pay $500-$1200 depending on where you are located.

  • Title search and insurance fees - You will have to pay for a new title search and insurance fees. The costs will be in the range of $500 - $1,000.

There might be other fees that your lender charges, such as credit report fees and recording fees. The total costs to refinance a mortgage could be in the range of 2%-5% of your loan amount depending on your loan size and the lender that you are working with. It's always a good idea to shop around to find a lender that gives you the best interest rate with low closing costs. You can also negotiate with your lender, as they can often waive some of the fees.



How long does it take to refinance a house?

Refinance goes through the same process as a mortgage, it takes the bank or the lender time to verify your income, employment history, credit score, title search, underwriting, and closing. It may take anywhere from 1 month to 2 months depending on how fast your lender processes your application. It is always a good idea to provide all the documents the bank asks for to avoid any delays. Keep in touch with the loan processor so you know where you are standing and make sure they are not waiting on you for any document.


Should I refinance?

Is refinancing worth it, should I refinance, or when to refinance are the kind of questions that many homeowners ask themselves when the interest rate goes down. Here are a few situations that will make refinancing worth the effort.

  • Interest Rates Go Down - If interest rates go down dramatically, refinance will reduce the total costs of your mortgage, and help you build your equity in your home faster.

  • Improved Credit Score - If your credit score has improved substantially since you bought the house, then refinancing is a good idea because the best rates and terms are given to borrowers with good credit scores.

  • Changing Terms - If you want to shorten your 30-year term to a 15-year term, or switch from an ARM to a fixed interest rate, then refinancing is a good option as it will reduce your total payments.

  • Reducing Other Debts - If you have other debts with a much higher interest rate, using a cash-out refinance mortgage is a good way to reduce your debt. Of course, you will need to have good equity in your house to cash out a meaningful amount.

On the other hand, if the interest rate doesn't drop that much, and the costs to refinance are higher or close to the interest savings, then refinance might not make sense.


When to refinance?

Another thing to take into account is how long does it take to break even on your refinance. Does it take 5 years to break even? 10 years? If you are planning to move to another house soon, then refinancing is not a good idea because you won't have time to recoup the costs to refinance. If you are planning to live in your current house for a long time, longer than the breakeven period, then refinancing is a good idea. With our refinance calculator, you can see exactly how much you can save so you can decide whether or not to refinance your mortgage. Not only does it show the total interest savings, but it will also generate a refinance amortization schedule with the new monthly payments so that you can compare it to your current mortgage. Our mortgage refinance breakeven calculator will show you exactly how long it takes to break even based on your refinance costs, interest rate, terms, and refinance balance.



Mortgage Calculator | Terms | Privacy | Disclaimer | Contact

©2024 Mortgage Calculator