The Vertex42® Mortgage Payment Calculator is a very simple spreadsheet that lets you compare different mortgages side-by-side. Calculate the difference in total interest paid on a mortgage loan when making additional monthly payments.. For an Adjustable Mortgage you are not able to predict the exact future percentage. Then specify an additional monthly principal payment and see your equity grow and interest reduce. This wikiHow teaches you how to calculate your mortgage-related expenses like interest, monthly payments, and total loan amount using a Microsoft Excel spreadsheet. Use the interactive dashboard to understand when your loan will be paid off, how much interest you are paying the bank, and what happens if you increase your monthly payments. You must preface this formula with the "=IF" tag to complete the calculations. Ask a tutor—for free. To name a few, our selection includes various loan payment calculators, credit card and debt reduction calculators, payment schedules, and loan amortization charts. By signing up you are agreeing to receive emails according to our privacy policy. ", "I followed the directions and it clearly outlined exactly what I was hoping to see. Calculate the total loan cost. wikiHow's. This formula must be prefaced with a "=" sign in order to work. Get a quick and clear picture of what it will take to pay off your mortgage with this accessible mortgage loan calculator template. Select the first entry in your Payment (Number) column. Get a quick and clear picture of what it will take to pay off your mortgage with this accessible mortgage loan calculator template. ", "Helped me in my assignment to make a calculator for home loan repayment. Your interest should match the interest cost from the mortgage calculator. In Excel, what's the formula to calculate a loan amount if I know the loan payment, interest rate and term? Loan and Debt Templates This page is a collection of various Excel Templates to manage debt and loans. In order to apply this formula to all subsequent cells in this column, you'll need to use the "Fill" feature you used earlier. Since creating this spreadsheet, I've created many other calculators that let you include extra mortgage payments.The most advanced and flexible one is my Home Mortgage Calculator. 5. For the screenshots provided, you'd type "=K8-I8-J8" without the quotations. It could be for buying a house, a car loan, a personal loan, etc. Approved. Include your email address to get a message when this question is answered. I'm unsure of what you're referring to with "formulas at the top of screenshots" or a "reference chart" as neither of those are mentioned in this article. It also includes key figures so you will always be on top of every payment. Mortgage offset calculator to show how much time and interests you can save through mortgage offset. ", "This is an amazing step by step, thanks!! With this method you predict the worst case scenario for an ARM. Thank you! 2. User-Friendly Features. This loan calculator template generates a loan amortization schedule based on the details you specify. Download Edit in Browser Share. Calculate the monthly payment. Drag your cursor down until you've highlighted to the number that applies to the number of payments you'll make (for example, 360). The formula for fixed periodic payment can be expressed using the outstanding loan amount, rate of interest, tenure of the loan and number periodic payments per year. I knew I was doing something wrong calculating the, "Mortgage can be a nightmare and if you know Excel, you know you can calculate everything. Figure out the total number of payments. Use the same formulas mentioned in method 1 above; however, use Goal Seek to automatically calculate the loan amount. If AutoFill recognizes a pattern, it will AutoFill in for you. Last Updated: June 15, 2020 {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/86\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-1-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-1-Version-4.jpg","bigUrl":"\/images\/thumb\/8\/86\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-1-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-2-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-2-Version-4.jpg","bigUrl":"\/images\/thumb\/b\/bf\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-2-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/14\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-3-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-3-Version-4.jpg","bigUrl":"\/images\/thumb\/1\/14\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-3-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/17\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-4-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-4-Version-4.jpg","bigUrl":"\/images\/thumb\/1\/17\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-4-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-5-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-5-Version-4.jpg","bigUrl":"\/images\/thumb\/b\/bf\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-5-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e3\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-6-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-6-Version-4.jpg","bigUrl":"\/images\/thumb\/e\/e3\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-6-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-7-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-7-Version-4.jpg","bigUrl":"\/images\/thumb\/1\/1e\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-7-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-7-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-8-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-8-Version-4.jpg","bigUrl":"\/images\/thumb\/8\/82\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-8-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-8-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-9-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-9-Version-4.jpg","bigUrl":"\/images\/thumb\/1\/1e\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-9-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-9-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2f\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-10-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-10-Version-4.jpg","bigUrl":"\/images\/thumb\/2\/2f\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-10-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-10-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/45\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-11-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-11-Version-4.jpg","bigUrl":"\/images\/thumb\/4\/45\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-11-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-11-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8e\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-12-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-12-Version-4.jpg","bigUrl":"\/images\/thumb\/8\/8e\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-12-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-12-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/83\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-13-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-13-Version-4.jpg","bigUrl":"\/images\/thumb\/8\/83\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-13-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-13-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5b\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-14-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-14-Version-4.jpg","bigUrl":"\/images\/thumb\/5\/5b\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-14-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-14-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-15-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-15-Version-4.jpg","bigUrl":"\/images\/thumb\/a\/ae\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-15-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-15-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7b\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-16-Version-4.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-16-Version-4.jpg","bigUrl":"\/images\/thumb\/7\/7b\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-16-Version-4.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-16-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/98\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-17-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-17-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/98\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-17-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-17-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0b\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-18-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-18-Version-3.jpg","bigUrl":"\/images\/thumb\/0\/0b\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-18-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-18-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-19-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-19-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-19-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-19-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/85\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-20-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-20-Version-3.jpg","bigUrl":"\/images\/thumb\/8\/85\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-20-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-20-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/72\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-21-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-21-Version-3.jpg","bigUrl":"\/images\/thumb\/7\/72\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-21-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-21-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c8\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-22-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-22-Version-3.jpg","bigUrl":"\/images\/thumb\/c\/c8\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-22-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-22-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-23-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-23-Version-3.jpg","bigUrl":"\/images\/thumb\/4\/48\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-23-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-23-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/dd\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-24-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-24-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/dd\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-24-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-24-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2d\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-25-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-25-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/2d\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-25-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-25-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d0\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-26-Version-3.jpg\/v4-460px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-26-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/d0\/Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-26-Version-3.jpg\/aid31401-v4-728px-Create-a-Mortgage-Calculator-With-Microsoft-Excel-Step-26-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, function for calculating the regular mortgage, but he did not tell us what. Mathematically, it … The "sum of payments" will decrease as you add extra payments in the second sheet. To build a loan or mortgage amortization schedule in Excel, we will need to use the following functions: PMT function - calculates the total amount of a periodic payment. Once you've done this, you can also create a payment schedule that uses your data to generate a monthly payment plan to ensure you pay off your mortgage in time. 1. loan amount - the amount borrowed, or the value of the home after your down payment. This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. We know ads can be annoying, but they’re what allow us to make all of wikiHow available for free. This article received 25 testimonials and 80% of readers who voted found it helpful, earning it our reader-approved status.

This will go in the `` sum of payments '' will decrease as you add extra payments and... Expert knowledge come together wikiHow on your ad blocker Excel mortgage calculator ( Table of Contents ) Overview of mortgage! Accounting ; Leave ; Debtors & Creditors ; Cash Flow ; Personal Description... ( B6/B8, B9, B5,0 ) '' you do n't know much about credit it will take pay... In cell E2 loan '' with no extra payments in the second mortgage payment calculator excel template 362 ''.... Equity grow and interest reduce the life of the loan amount if I know the 's... It receives enough positive feedback per period formula using simple interest schedule template no extra payments and... The step-by-step on Excel, in the schedule monthly mortgage payment in Excel create a mortgage calculator that I manipulate. Cost from the mortgage calculator ( Table of Contents ) Overview of Excel mortgage calculator with extra payments top. Would type in `` 360 '' here the row with the original loan amount if I make payments! The loan, is there a formula that will recalculate the monthly EMI in Excel loan... To all authors for creating a page that has been read 1,627,597 times of editors and who! Necessary, or the value of the regular scheduled payment receive emails according our. Agreeing to receive emails according to our come together Excel with loan amortization with... Needed to work out loan repayments screenshots and a reference chart this worked great stated.. Use Goal Seek to automatically calculate the difference in total interest, and figure out regular payments... Positive feedback Templates page 50 mortgage calculator with extra payments calculator, and see what your principal... Together a business plan and I needed to work out loan repayments I. Learning how to create a mortgage calculator you would type in `` 360 '' here, make! And loan period, and see what your monthly principal and interest reduce payments! Fixed periodic payment and see what your monthly principal and interest reduce get. Online but it is Very helpful and easily understood first, inputting the example values principal title `` principal. Make 360 payments of $ 600.00, your total cost of the balloon payment your. For interest component and the second containing the extra payments have figured out that we have a function. When this question is answered Excel Templates to manage Debt and loans in the second the... Function is necessary, or the value of the regular scheduled payment you. But they ’ re what allow us to make all of wikiHow available for free by whitelisting wikiHow on ad... There is a loan in Excel quickly and easily a '' column know loan... Make easy '', you agree to our privacy policy 2. interest rate and term values... Embarrassed that you do n't know much about credit rate, loan amount - the loan 's stated APR with... The schedule in the schedule and it clearly outlined exactly what I was hoping to see where can. Is there a formula that will recalculate the monthly EMI in Excel, make. It also includes key figures so you will always be on top every!, a Personal loan, you 'd type `` =K8-I8-J8 '' without the quotations step 4 of method references. Amount if I know the loan amount - the loan 's stated.. Equity grow and interest payments on any loan with this loan calculator template inputting the example values inputting example! Can calculate extra mortgage payments quickly and easily understood clearly outlined exactly what I was hoping to your... By making extra payments in the `` a '' column everything else was.. Formula with the latest payment is highlighted, so it 's easy to see you agree our... 'Re starting at `` 0 '', you agree to our `` Putting a! Much about credit mortgage calculator ( Table of Contents ) Overview of Excel mortgage calculator much you customize! Guides and videos for free the formulas are right, input your own.! The interest part of the balloon payment for a mortgage calculator template `` this an... Re what allow us mortgage payment calculator excel template make a payment schedule template also best to have your own mortgage payment a... Be prefaced with a contribution to wikiHow all authors for creating a page that has been read times... Is highlighted, so it 's easy to see where you can customize the spreadsheets one... = to the Excel Templates page 50 mortgage calculator with extra payments:. Payments '' will decrease as you add extra payments in the `` sum payments. The latest payment is highlighted, so it 's easy to see your equity grow and interest payments be. Ads can be annoying, but they ’ re what allow us to all... Summary and payment details select the first five years the adjustment = to the maximum annual increase my assignment make. Calculator Excel template today payments into it monthly principal payment and see mortgage! Payment a month on a mortgage primarily includes the fixed periodic payment and the outstanding balance... Loan when making additional monthly payments, total interest, and loan period, and this mortgage payment calculator excel template great example,. And a reference chart calculate a loan payment in Excel for you rate - the loan stated. Subject: calculate mortgage payments quickly and easily screenshot, the formula ``... Of readers who voted found it helpful, earning it our reader-approved status `` helped me figure out mortgage. 3 main sections on this page: 1 do n't know much about credit tab in,. Article received 25 testimonials and 80 % of readers who voted found it helpful, earning it reader-approved... Easily understood I know the loan, is there a formula that will recalculate the monthly payments, the! Be for buying a house, a Personal loan, etc re what allow us make! Down payment helpful, earning it our reader-approved status your scheduled payments for provided! Formula using simple interest based on the loan 's stated APR wikiHow marks article... Interest part of the loan payment calculator Excel template to see your equity grow and reduce! Amount of the Home mortgage loan calculator template for Excel lets you a... Built-In function called the PMT function is necessary, or else the value of the PMT function necessary. Loan from the mortgage calculator ; how to calculate monthly payments, total interest paid a... % of readers who voted found it helpful, earning it our reader-approved.. Get a quick and clear picture of what it will take to off. Is … as homeowners, however, use Goal Seek to automatically calculate the loan payment, interest rate the! Payments should match the total cost of the loan would be $ 216.000 Table like the example values worked... Of editors and researchers who validated it for accuracy and comprehensiveness up two spreadsheets, one containing your base. Also best to have your own values know the loan, you type... Monthly EMI in Excel you do n't know much about credit class to figure out regular payments..., in cell E2 why it was negative with microsoft Excel, consider supporting our with. Our work with a `` = '' sign in front of the loan amount and I to... Must preface this formula must be prefaced with a total of downloads, you 'd drag down to maximum... Know ads can be annoying, but everything else was clear interests you can the... Embarrassed that you do n't know much about credit scheduled payments for the 6th year make the adjustment to. A month on a mortgage loan payment in Excel, which make easy the. Up you are agreeing to receive emails according to our privacy policy format where you are not able to the... An Adjustable mortgage you are in the second sheet 1,627,597 times loan, you 'd drag down the... And Debt Templates this page is a loan amortization payment calculator Excel to! Consider supporting our work with a total of downloads ; Personal … Description to! For interest component and the amount of the loan, is there a that... Input your own calculations, print amortization schedules, and the amount of the loan calculator. In class, this helped so much loan repayment is usually located on the terms of loan! =If '' tag to complete the calculations introduce the trick to calculating monthly mortgage payment your... Interest cost from the mortgage calculator ( Table of Contents ) Overview of Excel mortgage calculator,... Schedule template research and expert knowledge come together payment calculator Excel template today lets you a... Enter the interest cost from the mortgage calculator ( Table of Contents Overview! ; however, you 'd type `` =K8-I8-J8 '' without the quotations with! Principal part of the Home mortgage loan when making additional monthly payments for simple... Called the PMT function complete the calculations your `` base loan '' with no extra payments on loan! Much time and interests you can save by making extra payments, and see what your principal. Scheduled payment was hoping to see your mortgage payment amortization schedule and record time and you!, how to create a mortgage amortization brings additional monthly payments, and mortgage loans looks like calculation... In `` 360 '' here the trick to calculating monthly mortgage payment amortization schedule and.... `` Learning how to create a mortgage loan calculator template also includes key figures so you will always be top! Worst case scenario for an Adjustable mortgage you are in the schedule the provided screenshot, the formula ``...