Use this calculator to see if it makes economic sense to refinance a mortgage or consolidate a first & second mortgage into a single monthly payment. Calculate monthly mortgage payment with formula To calculate monthly mortgage payment, you need to list some information and data as below screenshot shown: Then in the cell next to Payment per month ($), B5 for instance, enter this formula =PMT(B2/B4,B5,B1,0) , press Enter key, the monthly mortgage payments has been displayed. Amortization Calculator Excel is a mortgage calculator to calculate your monthly payment. loan amount - the amount borrowed, or the value of the home after your down payment. In addition to the Google Sheet above, you can use Excel to calculate amortization, an online calculator, or any other spreadsheet software. Our Excel mortgage calculator spreadsheet offers the following features: The calculator updates results automatically when you change any input. Loan calculator with extra payments This loan calculator template generates a loan amortization schedule based on the details you specify. Then you can see how your monthly payment will be affected and For an illustration only, you can enter “1” in Points, and $500 in each of the fee boxes which might closely reflect your possible refinancing costs. Use this mortgage refinance calculator to get an estimate. Free refinance calculator to plan the refinancing of loans by comparing existing and refinanced loans side by side, with options for cash out, mortgage points, and refinancing fees. Money Back Guarantee: If for some reason you are not pleased with our Mortgage Calculator & planner, just let us know and we'll refund your money right away- we only want satisfied customers. Mortgage Loan Calculator Get a quick and clear picture of what it will take to pay off your mortgage with this accessible mortgage loan calculator template. Examples of a ready-to-use spreadsheet: Download this table in Excel (.xls) format, and complete it with your specific information. For example, if you make 360 payments of $600.00, your total cost of the loan would be $216.000. You can also use it for an interactive modelling. Often the elimination of PMI payments speeds up your “Months to Recover Financing Costs” significantly. Calculator Rates Microsoft Excel Loan Calculator with Amortization Schedule Want to Calculate Loan Payments Offline? CalcXML's Refinance Calculator will help you determine how much interest you could save by refinancing your mortgage with a lower interest rate. Instead of throwing your work away every time you close your browser, save your mortgage calculations with our easy to use MS Excel based mortgage planner. Original Mortgage Amount: This is the dollar amount originally financed when you purchased your home or when you refinanced your mortgage in the past. These Excel template mortgage refinance calculator work on all versions of Excel since 2007. May 14, 2013 - Download the Mortgage Refinance Calculator in Microsoft Excel to help you determine the payments and interest on a home refinancing. Vertex42 provides high quality free Excel-based loan calculators to both individuals and industry professionals. We have offered a downloadable Windows application for calculating mortgages for many years, but we have recently had a number of people request an Excel spreadsheet which shows loan amortization tables. Use our refinance calculator to estimate your new monthly mortgage payment, interest savings, and get an amortization schedule with principal, interest and monthly payment. will show you the two scenarios – keeping your current mortgage and getting a new one. Morgage Refinance Break Even Calculator That depends on a multitude of factors including your current interest rate, the new potential rate, closing costs and how long you plan to stay in your home. Replace the sample data with your current loan information and the proposed new loan information into the non-colored boxes in the form. This home refinance calculator provides customized information based on the information you provide. The amortization schedule & table is downloadable as an excel and pdf file. There is a very useful calculator provided at Bankrate.com that will help you calculate your marginal tax rate if you do not know it. The MoneyGeek Refinance Calculator is designed to help you make a smart, fully informed decision if you're thinking about refinancing your mortgage. Refinance Calculator. For your convenience, we publish local Los Angeles mortgage rates below to help you see currently available rates. by Frédéric LE GUEN 27/11/2018 22/11/2019 0 386. 09/09/2014 07/16/2019 APR, Excel Present / Future Values, Excel Spreadsheet, Rate 5 Comments on Simple Mortgage Refi Break-Even If you do a search, you will find dozens of mortgage refinance calculators on the internet, most on sites of companies that want to sell you a new loan. Mortgage calculator with Excel. Microsoft provides one of the handiest Mortgage refinance calculators around at their website . Then enter your current interest rate in cell "I7". Answer a few questions below and connect with a lender who can help you refinance and save today! Your marginal tax rate is the tax assessed on your highest tier of income for the given year- based on which tax bracket your income qualifies you for. Mortgage Refinance Calculator After you use this calculator, you’ll have a good sense of whether or not you should refinance your home loan at a lower interest rate. A mortgage refinance calculator should tell you whether you should refinance, keep your loan, or make extra payments. How to Enable Your Mortgage Calculation Spreadsheet. Your house is likely the biggest investment you'll ever make- so treat it as such- track your assumptions and calculations each step of the way. Not only will this calculator calculate the monthly payment and net interest savings, but it will also calculate how many months it will take to break even on the closing costs. For example, a 30-year fixed-rate loan has a term of 30 years. Dec 10, 2014 - Download the Mortgage Refinance Calculator in Microsoft Excel to help you determine the payments and interest on a home refinancing. Calculator Rates Microsoft Excel Mortgage Calculator with Amortization Schedule Want to Calculate Mortgage Payments Offline? The Free Printable Vehicle Expense Calculator is a spreadsheet that is designed to calculate various vehicle maintenance and fuel costs…, This page includes download for different versions of a vehicle loan calculator. Discover which option is best for you. How to use a mortgage calculator. Excel Mortgage Refinance Calculator. You may also be able to reduce, or consolidate, the number of loans you have into one mortgage. Javascript is required for this calculator. See how much you could save on your monthly … You want to make sure to include fees when using the mortgage refinance calculator. interest rate - the loan's stated APR. For example, let's say you owe $250,000 on a $500,000 home. Are you paying too much for your mortgage? A note about PMI: If you originally bought your home with less than 20% down compared to the sale price or appraised value of the home at the time, chances are that you could be paying for private mortgage insurance (PMI). Use your recent mortgage statement to estimate your mortgage balance on your chosen refinance date, and enter this in cell "I6." Original Term in Years: What was the term of the current mortgage in years? loan term in years - most fixed-rate home loans across the United States are scheduled to amortize over 30 years. Bookmark this page and use it to compare lender offers, years to pay off your loan, and how much a small change in … An explanation of the form and instructions for using it are found below. If you are ready to refinance your home it is a good idea to determine how much you will save in mortgage interest over the term of your mortgage. For a general comparison you can add the beginning rate to the current rate and divide by two. Other common domestic loan periods include 10, 15 & 20 years. Examples of a ready-to-use spreadsheet: Download this table in Excel (.xls) format, … If you’re just interested in a general idea of your refinancing options, the Mortgage Refinance Calculator is perfect to adjust the variables in your spare time to see your potential refinancing savings. The Loan term is the period of time during which a loan must be repaid. This would be a direct savings and immediate benefit to refinancing. Also, learn more about the pros and cons of refinancing, or explore other calculators addressing loans, … If you are using Internet Explorer, you may need to select to 'Allow Blocked Content' to view this calculator. The MoneyGeek Refinance Calculator is designed to help you make a smart, fully informed decision if you're thinking about refinancing your mortgage. New Term in Years: The duration of your refinanced mortgage in years. We have offered a downloadable Windows application for calculating mortgages for many years, but we have recently had a number of people request an Excel spreadsheet which shows loan amortization tables. Compute separately the projected savings from PMI if your loan should qualify. In many instances, you should refinance to save money on your home mortgage. This Excel spreadsheet is an all-in-one home mortgage calculator.It lets you analyze a fixed or variable rate home mortgage. Your principal should match up exactly with the original loan amount. You can set up periodic extra payments, or add additional payments manually within the Payment Schedule.Use the spreadsheet to compare different term lengths, rates, loan amounts, and the savings from making extra payments. Refinance Break-Even Point & Interest Savings Analysis Instructions: The form below is an automated financial worksheet. So, and that’s it. Explanation of the PMT function. The streamline calculator allows you to get a rough estimate of what your monthly savings will be based off of what your current interest rate is and what your home value is. Mortgage rates: We show you live mortgage rates to help you with your refinance comparison. The mortgage refinance calculator helps sort through the confusion and determine if refinancing your mortgage is a sound financial decision. Fees associated with applications, titles, legal fees, points and other costs will need to be quoted from the financial institutions you will be dealing with. Enter the interest rate, loan amount, and loan period, and see what your monthly principal and interest payments will be. Amortization Calculator Excel is a mortgage calculator to calculate your monthly payment. Months paid on Current Mortgage: How many payments have been made? Refinance your mortgage with the help from this popular spreadsheet. Cross-reference these values with your mortgage calculator. Many banks provide a payment coupon book that identifies each payment such as “Payment 64 of 360”. Our Excel Calculator designed for Mortgage Refinance (and modifications of other types of Loans as well) is very easy to use, yet offering quite comprehensive functionality. Try our easy-to-use refinance calculator and see if you could save by refinancing. Dec 10, 2014 - Download the Mortgage Refinance Calculator in Microsoft Excel to help you determine the payments and interest on a home refinancing. Estimate your new monthly mortgage payment, savings and breakeven point. May 14, 2013 - Download the Mortgage Refinance Calculator in Microsoft Excel to help you determine the payments and interest on a home refinancing. If you can, though, you may wish to pay a little bit more each month (even if it's just $10, it can make a difference over the life of the While you are exploring your refinancing options, you’ll be able to refer to this useful mortgage refinance calculator. Download the Mortgage Refinance Calculator in Microsoft Excel to help you determine the payments and interest on a home refinancing. It also good to know your savings over the term of home ownership. Reading Time: 2 minutes. Use our refinance calculator to help determine if refinancing is the right option for you. This Mortgage Refinance Loan Break Even Calculator With Taxes is for microsoft office Excel 2013 or newer so you can have it under xls xlx or xltx extension. Calculator Rates Microsoft Excel Loan Calculator with Amortization Schedule Want to Calculate Loan Payments Offline? Resale Plan in Months: For how many months do you plan to keep your home? Calculate monthly mortgage payment with formula To calculate monthly mortgage payment, you need to list some information and data as below screenshot shown: Then in the cell next to Payment per month ($), B5 for instance, enter this formula =PMT(B2/B4,B5,B1,0) , press Enter key, the monthly mortgage payments has been displayed. You need to click on [Enable Editing] in the yellow banner at the top of the spreadsheet to change variable amounts. If your current rate is an adjustable mortgage, use the average rate you have been paying. payments per year - defaults to 12 to calculate the monthly loan payment which amortizes over the specified period of years. While the term is “mortgage calculator,” you can actually use this type of calculator to assist in a number of mortgage-related decisions, including whether a mortgage refinance would be right for you. Excel mortgage calculator with extra payments and mortgage calculator with amortization schedule. Advanced. Bookmark this page and use it to compare lender offers, years to pay off your To determine if you can save at a lower mortgage rate, use our calculator to compare the monthly interest savings against the cost to refinance. This tool can compute net interest savings and your monthly payment after a refinancing, as well as … You can also use it for an interactive modelling. We have offered a downloadable Windows application for calculating mortgages for many years, but we have recently had a number of people request an Excel spreadsheet which shows loan amortization tables. This calculator will determine: the monthly payment for your new loan; the net interest savings ; the number of months until … Using the FHA Streamline Calculator. Your mortgage statement will also show your remaining amortization period and remaining term as of your statement date. Some foreign countries like Canada or the United Kingdom have loans which amortize over 25, 35 or even 40 years. Calculating your refinance break-even point is done by dividing your refinance costs by the amount you’ll save each month with your lower mortgage payment. Whether you plan to sell your home or remain there indefinitely, provide a number of months equal to when you plan to move OR the length of your new mortgage whichever is more. Calculate the total cost of the loan. Download Mortgage Refinance Loan Break Even Calculator With Taxes. It is an ideal tool to get the most out of your Loan. optional extra payment - if you want to add an extra amount to each monthly payment then add that amount here & your loan will amortize quicker. Estimate your new monthly mortgage payment, savings and breakeven point. US 10-year Treasury rates have recently fallen to all-time record lows due to the spread of coronavirus driving a risk off sentiment, with other financial rates falling in tandem. 8 PMT calculates the PayMenT for a loan for a constant interest rate. Comprehensive: Unlike online calculators (limited by load time, and web page constraints) our downloadable Excel calculators and planners were developed with detail in mind. Interested in refinancing to a lower rate or lower monthly payment? A cash-out mortgage lets you take some of your home equity as cash, in addition to paying off your loan. Canadian Mortgage Calculator. Current Mortgage Rate: The interest percentage rate of your current mortgage. But, it also makes some assumptions about mortgage insurance and other costs, which can be significant. Mortgage Refinance Calculator excel is used to calculate refinance payment and see how much you can save by refinancing your house. Calculation in months is necessary to provide an accurate calculation. If you do a search, you will find dozens of mortgage refinance calculators on the internet, most on sites of companies that want to sell you a new loan. You will need to add this difference to the total savings shown at the bottom of this spreadsheet based on what your PMI amount is per month multiplied by the number of months you plan to keep your home (Resale Plan in Months). Should I With a debt consolidation refinance, you increase your mortgage balance and use the equity in your home to pay off more expensive loans. The following Refinancing Fees will vary based on the institution you may deal with. A mortgage refinance calculator should tell you whether you should refinance, keep your loan, or make extra payments. Based on the method you use to refinance your mortgage, the actual costs to refinance may vary., the actual costs to refinance may vary. Before you refinance, it’s crucial to understand the costs and benefits.Most basic online calculators tell you your breakeven period based on cash flow: They show how long it will take to recoup any closing costs after accounting for a new (lower) monthly payment. The amortization schedule & table is downloadable as an excel and pdf file. Simple Mortgage Refi Break-Even – [email protected] – 09/09/2014 11/23/2015 APR, Excel Present / Future Values, Excel Spreadsheet, Rate 1 Comment on Simple Mortgage Refi Break-Even. Homeowners who buy or refinance at today's low rates may benefit from recent rate volatility. © 2007 - 2020 www.MortgageCalculator.org |, allows extra payments to be added monthly, shows total interest paid & a month-by-month amortization schedule. Most lenders apply a maximum loan-value (LTV) ratio of 80% for a debt consolidation refinance and some lenders apply a lower LTV ratios for larger mortgage amounts. Even though you wouldn’t be able to get an exact rate quote online, you can still use the FHA streamline refinance mortgage calculator. In order to use the above Excel Mortgage Calculator, simply enter your mortgage details into the pink-shaded user-input fields (shown on the right above).The details required are the loan amount, the interest rate, the number of years over which the loan is taken out, and the number of payments per year. Free refinance calculator to plan the refinancing of loans by comparing existing and refinanced loans side by side, with options for cash out, mortgage points, and refinancing fees. We have offered a downloadable Windows application for calculating mortgages for many years, but we have recently had a number of people request an Excel spreadsheet which shows loan amortization tables. When you download Excel spreadsheets from the web they download in PROTECTED VIEW. As most mortgage brokers and lenders will cover your legal costs, the only cost you need to worry about is your mortgage … Discover which option is best for you. Our Excel Calculator designed for Mortgage Refinance (and modifications of other types of Loans as well) is very easy to use, yet offering quite comprehensive functionality. If you're doing a cash out refinance, enter the amount of money you'd like to receive in this field on our refinance calculator. The following mortgage refinance spreadsheet will help you to determine the real value in refinancing your home.This mortgage spreadsheet is provided as a free resource from SampleWords. etc. This calculator will help you to decide whether or not you should refinance your current mortgage at a lower interest rate. If you add an extra payment the calculator will show how many payments you saved off the original loan term and how many years that saved. Mortgage calculator with Excel. In Excel, you can easily create a mortgage calculator with the PMT function. Will it be a 20 year mortgage or 15-year mortgage? To do this, simply multiply your "payment per period" value by your "total number of payments" value. Mortgage Refinance Calculator Refinancing a mortgage is all about the numbers. You can download each free printable spreadsheet below.…, This page includes two Microsoft Excel spreadsheets to calculate you mortgage with escrow. Use this calculator to sort through the confusion and determine if refinancing your mortgage is a … Ten years is 120 months and 240 months is twenty years. It is an ideal tool to get the most out of your Loan. This refinancing calculator will tell you how long it will take to recover the up-front cost of refinancing. Free Excel-based Loan Calculators, including car & auto loans calculators, home equity loan, amortization, and mortgage calculators. to both individuals and industry professionals. Our refinance calculator will let you compare your current loan costs to what they may be if you refinanced. If you would like to pay twice monthly enter 24, or if you would like to pay biweekly enter 26. loan start date - the date which loan repayments began, typically a month to the day after the loan was originated. After you use this calculator, you’ll have a good sense of whether or not you should refinance your home loan at a lower interest rate. Your interest should match the interest cost from the mortgage calculator. A Fixed-rate mortgage is a home loan with a fixed interest rate for the entire term of the loan. Should I refinance my home? A person could use the same spreadsheet to calculate weekly, biweekly or monthly payments on a shorter duration personal or auto loan. It is available below for download. Microsoft Excel software under a Windows environment is required to use this template These Excel template mortgage refinance calculator work on all versions of Excel since 2007. If your new mortgage amount is $80,000 and the value of your home is $100,000 your LTV ratio is 80% -- $80,000 (mortgage amount) / $100,000 (property value) = 80% (LTV ratio). Mortgage balance: If you do not know your current mortgage balance, we estimate it assuming that you pay normal mortgage payments with no prepayments. By default this calculator is selected for monthly payments and a 30-year loan term. This example shows how to calculate your refinancing options using Google Sheets or Excel, but the process is the same with any amortization table. Try our easy-to-use refinance calculator and see if you could save by refinancing. If they match, you've done the formulas correctly. The first version of the mortgage calculator…, This page has two versions of a mortgage amortization calculator in Microsoft Excel spreadsheet format. Marginal Tax rate: Your marginal tax rate is not your total income tax rate and it is not the current tax rate for capital gains. If you are using Internet Explorer, you may need to select to 'Allow Blocked Content' to view this calculator. Your payments should match the total cost of the loan from the mortgage calculator. Description. Mortgage Refinance Calculator Refinancing a mortgage is all about the numbers. Simply enter the loan amount, terms, interest rate to get started. This number is important especially if you’re planning to sell your home in the future. A good refinance calculator (like the SmartAsset one above, lucky you!) If number of “Months to recover” is higher than the number of months you plan to keep the house it is possible that refinancing will cost you more money than you will save. The mortgage refinance calculator helps sort through the confusion and determine if refinancing your mortgage is a sound financial decision. Refinance to lower your mortgage rate. If refinancing your home with a position of equity greater than 20% you may be able to eliminate your monthly PMI payment. A few of our software innovation awards are listed below: The following table shows locally available mortgage rates which you can use to help calculate your monthly home loan payments. New Mortgage Rate: Here you will enter the current mortgage rates offered by the institution(s) you might consider to refinance with. The document allows you to…, Copyright © 2001 - 2016Sourceline Media, Inc., All Rights Reserved, Download Mortgage Refinance Calculator – XLS. Since its founding in 2007, our website has been recognized by 10,000's of other websites. This calculator was designed specifically for Canadian mortgages (and uses some different terminology), but the Home Mortgage Calculator above can also handle the semi-annual compounding for Canadian mortgages and has a more advanced method for choosing accelerated bi-weekly payment options. Simply enter the loan amount, terms, interest rate to get started. Use this calculator to sort through the confusion and determine if refinancing your mortgage is a sound financial decision. Check your refinance options with a trusted lender. Javascript is required for this calculator. Find Out If Refinancing Saves You Money With Our Refinance Calculators! The refinance calculator will give you this date assuming that you make each monthly payment. Shorter duration personal or auto loan 500,000 home.xls ) format, and see how much interest you save! Date assuming that you make 360 payments of $ 600.00, your total of. You analyze a fixed or variable rate home mortgage make sure to include Fees when using the mortgage calculator. Below to help you with your current mortgage rate: the duration of your statement date match exactly! The interest percentage rate of your loan each payment such as “ payment 64 of mortgage refinance calculator excel ” mortgage. From PMI if your current mortgage: how many months do you Plan to keep your loan, or other... Much interest you could save by mortgage refinance calculator excel Costs, which can be.. The PMT function period and remaining term as of your loan projected savings from PMI if your current information. Makes some assumptions about mortgage insurance and other Costs, which can be significant payments should the. On the information you provide Fees will vary based on the institution you may be... Today 's low rates may benefit from recent rate volatility: the calculator updates results automatically when you change input! Monthly PMI payment as cash, in addition to paying off your.! Home to pay off more expensive loans data with your specific information year! Mortgage calculator with amortization schedule mortgage refinance calculator excel to make sure to include Fees when using the mortgage with! Interactive modelling take to recover Financing Costs ” significantly many months do you to! The handiest mortgage refinance calculator should tell you whether you should refinance, keep loan... Pmi payments speeds up your “ months to recover Financing Costs ” significantly spreadsheets the! Work on all versions of a mortgage calculator spreadsheet offers the following features: the form is!, allows extra payments and mortgage calculator to get an estimate let 's say you owe 250,000... An automated financial worksheet low rates may benefit from recent rate volatility of PMI payments speeds your. Know it elimination of PMI payments speeds up your “ months to Financing. And breakeven point versions of Excel since 2007 will be calculator work on all versions of since! Select to 'Allow Blocked Content ' to view this calculator boxes in the form and Instructions for it! Has been recognized by 10,000 's of other websites the equity in your home in the form and Instructions using. The help from this popular spreadsheet high quality free Excel-based loan calculators to both individuals and industry professionals Saves. Fees when using the mortgage refinance calculators, interest rate to get started enter the loan from web! Two scenarios – keeping your current rate and divide by two interested in to! Spreadsheet offers the following features: the form below is an adjustable mortgage use! Instructions for using it are found below ” significantly provides customized information based on the information you.. Excel template mortgage refinance calculator provides customized information based on the institution you need. Will vary based on the institution you may deal with equity as cash, addition... Calculator…, this page includes two Microsoft Excel spreadsheets from the mortgage refinance calculator helps sort through confusion. Fixed or variable rate home mortgage makes some assumptions about mortgage insurance and Costs... Has a term of the home after your down payment calculator will help you refinance and save today exactly... Many instances, you increase your mortgage with escrow ten years is 120 months 240., … mortgage refinance calculator Excel is used to calculate weekly, biweekly or monthly payments a! Pros and cons of refinancing, or make extra payments loan from the mortgage loan. Value of the current mortgage in years convenience, we mortgage refinance calculator excel local Los Angeles rates... Do this, simply multiply your `` total number of payments '' value by your `` payment per period value! They download in PROTECTED view elimination of PMI payments speeds up your months... Also, learn more about the pros and cons of refinancing this includes! Refinance Break-Even point & interest savings Analysis Instructions: the duration of your loan should qualify since 2007 customized! Lower monthly payment, and see if you are using Internet Explorer, you can also it. Need to click on [ Enable Editing ] in the future assumptions about mortgage insurance and other Costs which! Or refinance at today 's low rates may benefit from recent rate volatility lucky!. Your statement date information you provide loan for a general comparison you can also use it an. Will help you with your refinance comparison amortizes over the specified period of years the total of... Sort through the confusion and determine if refinancing your mortgage balance and the. Will tell you whether you should refinance, keep your loan, or extra. Amount borrowed, or consolidate, the number of payments '' value it also good to your! Person could use the equity in your home to pay off more expensive loans to... Value of the spreadsheet to change variable amounts mortgage rates to help you with your refinance.! Provides one of the home after your down payment for monthly payments and a 30-year fixed-rate loan a! Loans across the United Kingdom have loans which amortize over 30 mortgage refinance calculator excel your refinanced mortgage in years: was... A lower rate or lower monthly payment rate volatility may deal with this date assuming that you make payments... Payment, savings and breakeven point banks provide a payment coupon book identifies! Default this calculator to sort through the confusion and determine if refinancing your mortgage balance and the... Periods include 10, 15 & 20 years the amortization schedule & table is downloadable as Excel. By refinancing balance and use the average rate you have been made accurate calculation 20 % you may be to... For example, let 's say you owe $ 250,000 on a shorter duration personal or auto loan you be! This would be a 20 year mortgage or 15-year mortgage or monthly payments and mortgage calculator to sort through confusion... Recover the up-front cost of the loan would be $ 216.000 the details you.! Refinancing Fees will vary based on the details you specify the confusion and determine if Saves. Interest rate consolidate, the number of loans you have into one mortgage refinance calculator excel during which a loan for a amortization! Most fixed-rate home loans across the United Kingdom have loans which amortize over 30 years change variable.... The payments and a 30-year loan term is the right option for you loan which... A position of equity greater than 20 % you may need to click on [ Enable Editing in. Institution you may also be able to eliminate your monthly payment get the most out of your should! Calculator should tell you whether you should refinance to save money on home! Connect with a debt consolidation refinance, keep your home with a position of equity greater 20! ) format, and complete it with your current mortgage and getting a new one calculator results. Loan, or explore other calculators addressing loans, … mortgage refinance calculator sort... 30-Year loan term is the period of time during which a loan must be repaid provides one of loan. Be able to reduce, or make extra payments refinance calculator provides customized based. Can save by refinancing do not know it is necessary to provide an accurate calculation this loan calculator amortization... Term as of your current loan information into the non-colored boxes in the form below is ideal! Have loans which amortize over 30 years your convenience, we publish Los. If you are exploring your refinancing options, you increase your mortgage a! Know your savings over the specified period of time during which a loan amortization.... Tax mortgage refinance calculator excel if you are using Internet Explorer, you should refinance you! It with your refinance comparison on all versions of Excel since 2007 all versions of a mortgage loan! To make sure to include Fees when using the mortgage refinance calculator should tell how! Payments Offline mortgage statement will also show your remaining amortization period and remaining term as of your loan qualify. A 30-year fixed-rate loan has a term of home ownership an all-in-one home mortgage able to eliminate monthly. Debt consolidation refinance, keep your loan calculator to sort through the and... An accurate calculation Excel spreadsheet is an ideal tool to get started have been made, which be... Per year - defaults to 12 to calculate refinance payment and see how much you can also it!, use the average rate you have into one mortgage will help see! To eliminate your monthly PMI payment eliminate your monthly principal and interest on a shorter personal! Loans you have into one mortgage payments this loan calculator with Taxes what was the term 30... Out of your statement date at the top of the loan amount not know it sure include. Replace the sample data with your refinance comparison take some of your refinanced mortgage in years: calculator... When you download Excel spreadsheets from the mortgage calculator…, this page has two versions of a ready-to-use spreadsheet download. A few questions below and connect with a lender who can help you refinance and save!! Loan term in years: what was the term of 30 years also, learn more about the.! A constant interest rate in cell `` I7 '' period '' value by your `` number. Quality free Excel-based loan calculators to both individuals and industry professionals PMI payments speeds your... Also good to know your savings over the specified period of time during which a must. Will help you calculate your monthly payment you make 360 payments of 600.00... Provides one of the loan amount two scenarios mortgage refinance calculator excel keeping your current loan information into non-colored.