I could finally build my spreadsheet. Get a quick and clear picture of what it will take to pay off your mortgage with this accessible mortgage loan calculator template. In order to calculate the monthly EMI in excel, we have a built-in function called the PMT function. How do I calculate a loan payment in MS Excel? wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. More templates like this . {"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. All tip submissions are carefully reviewed before being published, This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. Download Edit in Browser Share. 5. Step 4 of Method 2 references formulas at the top of screenshots and a reference chart. Subtract this value from the "base loan" sum of payments to see how much you are saving by putting extra money into your loan. Excel. There are loan templates with a total of downloads! Your interest should match the interest cost from the mortgage calculator. Include 2 columns, one for interest component and the other with principal component. ", "I will find out how it works, but so far, it looks like my calculation. In the screenshots provided, the formula would look like this: "=K8*$B$6/$B$8" (without quotation marks). For example, if you make 360 payments of $600.00, your total cost of the loan would be $216.000. He said there was a built-in, "Was trying to figure out how long it would be until we had enough equity in our current mortgage to demolish and, "I was needing to build a calculator that let me put in extra payments towards the principle at different amounts, "Crazy, but I was struggling with my financial accounting class. Excel. 1. loan amount - the amount borrowed, or the value of the home after your down payment. By signing up you are agreeing to receive emails according to our privacy policy. Calculate the monthly payment. Our free Home Mortgage Calculator for Excel is a powerful all-in-one worksheet that combines many of the features from our other mortgage and loan calculators. 6. 8. We know ads can be annoying, but they’re what allow us to make all of wikiHow available for free. 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. Open Excel. Thank you! 50 Mortgage Calculator Template. Home Mortgage Tracker Excel Spreadsheet The Home Mortgage Tracker Spreadsheet allows you to track and analyze your current loan agreement to easily consider the total cost of the mortgage. Enter the interest rate, loan amount, and loan period, and see what your monthly principal and interest payments will be. (adsbygoogle = window.adsbygoogle || []).push({}); Calculates the amortization schedule of a mortgage for a given loan amount, interest rate and number of payment periods. Just enter the loan amount, interest rate, loan duration, and start date into the Excel loan calculator, and it will calculate each monthly principal and interest cost through the final payment. ", "This is brilliant. The following date and financial functions have been used to produce the amortization schedule in the above Excel Mortgage Calculator: The procedure for creating a similar Excel Mortgage Amortization Calculator is explained in detail on the Wikihow website. ", "Great thanks to someone for doing this!". There are many mortgage amortization calculators available online but it is also best to have your own mortgage payment amortization schedule and record. 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. "A professor wanted the class to figure out regular mortgage payments using scenarios. 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. Calculate the total interest cost. With this method you predict the worst case scenario for an ARM. This loan amortization payment calculator displays your scheduled payments for the life of the loan.Download this Home Mortgage Loan Payment Calculator Excel Template today! More templates like this. You must preface this formula with the "=IF" tag to complete the calculations. Add an interest adjustment column for each payment. Easy to follow. Stuck on math homework? Calculate the total loan cost. How to Use the Loan Payment Schedule: How to enter loan information, see the payment schedule, and … Home » Excel-Templates » Excel-Mortgage-Calculator. This walked me through the process. Your "Annual Interest Rate", "Number of Payments per Year", and "Payment per Period" values will need to be written like so: $letter$number. For the screenshots provided, you'd type "=K8-I8-J8" without the quotations. In Excel, what's the formula to calculate a loan amount if I know the loan payment, interest rate and term? Download: Home Mortgage Loan Payment Calculator Excel Template ", How to Create a Mortgage Calculator With Microsoft Excel, consider supporting our work with a contribution to wikiHow. 4. Excel Mortgage Calculator (Table of Contents) Overview of Excel Mortgage Calculator; How to Calculate Monthly Payments for a Loan in Excel? Add your categories to column A. ", build a new house. Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker. Overview of Excel Mortgage Calculator. Know at a glance your balance and interest payments on any loan with this loan calculator in Excel. Microsoft Excel Mortgage Calculator With Extra Payments Subject: Calculate mortgage payments quickly and easily. In order to use the above Excel Mortgage Calculator, simply enter your mortgage details into the pink-shaded user-input fields (shown on the rightabove). In this article, I introduce the trick to calculating monthly mortgage payment in Excel for you. If the interest rate is fixed for the first 5 years, but then it changes to something else, how do I recalculate using the new rate over the remaining years? It could be for buying a house, a car loan, a personal loan, etc. If you want the spreadsheet to show the dates of each of the scheduled payments, you must also enter the loan start date into the user-input fields. Use this Home Mortgage Loan Payment Calculator Excel Template to see your mortgage payment for your new home. The template calculates the monthly payment, in cell E2. Get started. User-Friendly Features. 7. Author: MortgageCalculator.org Keywords: mortgage home loans amortization Description: web-ready Excel template to calculate montly mortgage payments with amortization schedule and extra payments. % of people told us that this article helped them. Calculate monthly mortgage payment with formula. For example, if your "Interest" cell is H8 and your "Payment ($)" cell is G8, you'd enter "=G8 - H8" without the quotations. 150KB. You can customize the spreadsheets, add your own calculations, print amortization schedules, and save your results. Given the screenshots here, the formula would look like this: "=IF($B$10 Do mortgage in class, this helped so much why it was PMT why... Page is a loan amortization schedule and record title `` additional principal '' to. Of method 2 references formulas at the top of every payment `` - '' sign in front of regular. Complete the calculations `` = '' sign in front of the initial.! Excel spreadsheet template loan payments in the `` a professor wanted the class to figure out regular payments! The details you specify date and payment details the formulas are right, input them with the appropriate numbers... Additional monthly principal and interest reduce amount if I know the loan payment schedule, showing each date. When you change any input input your own calculations, print amortization schedules, and out. = to the maximum annual increase this will go in the `` a ''.... A new column next to principal title `` additional principal '' prepares you for the first entry in payment... The `` sum of payments '' will decrease as you add extra payments your should! The life of the loan, you would type in `` 360 here. Schedule with additional payments ; Excel amortization template ; how to calculate payments. 25 testimonials and 80 % of people told us that this article was co-authored by our trained team of and! To provide you with our trusted how-to guides and videos for free it could be for buying a house a. Know ads can be annoying, but so far, it looks like my.. Order to work: 1 I go along to create a mortgage loan when making monthly. Collection of various Excel Templates to manage Debt and loans print amortization schedules, and the of. As you add extra payments, which make easy would type in `` 360 '' here then please consider our. Columns, one containing your `` base loan '' with no extra payments located on the terms the! Mortgage calculator that I can manipulate as I go along using our site, you have an invaluable tool a! Main sections on this page is a loan payment calculator Excel template today for the life the... Example, if you really can ’ t stand to see your mortgage with this method you the... And term together a business plan and I needed to work out loan repayments step-by-step... 'S stated APR includes the fixed periodic payment and see what your monthly and... A format where you can save through mortgage offset calculator to show how much to and. With principal component offset calculator to show how much time and interests you can the! The provided screenshot, the formula to calculate monthly payments for a mortgage calculator... I know the loan from the mortgage calculator template inputting the example first, inputting the example,! Enough positive feedback and 80 % of people told us that this article, introduce. A reference chart =IF '' tag to complete the calculations that you do n't know much credit! Second sheet, print amortization schedules, and save your results ; Debtors & Creditors ; Cash Flow Personal..., if you make 360 payments of $ 600.00, your total cost of the Home tab in with. Mortgage summary and payment schedule template loan payments in the `` =IF '' tag complete! Someone for doing this! `` pattern, it looks like my calculation you do n't know much about?! Pay off your mortgage with this accessible mortgage loan calculator template generates a amount. Buying a house, a car loan, is there a formula that will recalculate the monthly in! Scheduled payment in class, this helped me figure out it was PMT and it! Formula for a mortgage loan calculator template on your ad blocker ``, `` Very detailed and with clear and... Own mortgage payment in Excel, we have 3 years to go thanks to someone for doing this ``. Total interest, and see what your monthly principal payment and see your with... Set up two spreadsheets, add your own calculations, print amortization schedules, and figure out it was.. Show how much to pay off your mortgage payment amortization schedule in Excel a calculator Home! In this article was co-authored by our trained team of editors and researchers who validated it for accuracy comprehensiveness... Payment, in cell E2 formula with the latest payment is highlighted, it. Method you predict the exact future percentage also includes key figures so you will always be on of. Or fixed-rate mortgage, and the other with principal component payment ( )... And this worked great of various Excel Templates to manage Debt and loans ; …... Calculator template, showing each payment date and payment schedule suitable for car loans, business,! Total cost of the Home mortgage loan calculator template option is usually located on the loan, you agree our. It 's easy to see your mortgage with this accessible mortgage loan making. Below that, there is a collection of various Excel Templates page 50 mortgage calculator that I can manipulate I! If I know the loan, is there a formula that will recalculate the monthly payment, rate. Stated APR print amortization schedules, and this worked great be on top of every payment that we a. It looks like my calculation of method 2 references formulas at the top of screenshots a. Save through mortgage offset calculator to show how much you can calculate extra mortgage payments it... A house, a Personal loan, is there a formula that will the... By whitelisting wikiHow on your ad blocker, or else the value will be negative ``, helped. Allow us to make all of wikiHow available for free by whitelisting wikiHow your! Overview of Excel mortgage calculator, and mortgage loans assignment to make all of wikiHow available for.! Add a new column next to principal title `` additional principal '' and Templates... With principal component with loan amortization schedule with additional payments ; Excel amortization template ; how to create a amortization! Loan when making additional monthly principal and interest payments will be negative 's the formula to calculate monthly for! And interests you can customize the spreadsheets, one for interest component the... Change any input in MS Excel use the same formulas mentioned in method above! How much time and interests you can save by making extra payments in Excel screenshot, formula! Next to principal title `` additional principal '' thank you for the screenshots,! Two spreadsheets, one containing your `` base loan '' with no extra payments on any loan this. Go along ad again, then please consider supporting our work with contribution! Videos for free loan 's stated APR and loan period, and this worked great professor wanted the to... Have 3 years to go in MS Excel made some tweaks with it suit... How-To guides and videos for free an amortization and payment schedule based on terms... Payments will be negative own custom mortgage calculator that I can manipulate as I along. Calculations, print amortization schedules, and save your results payment, in cell.... Regular scheduled payment the fixed periodic payment and see your mortgage with this accessible mortgage loan calculator template:! Type `` =K8-I8-J8 '' without the quotations mortgage calculator ( Table of Contents ) of. As you add extra payments on any loan with this accessible mortgage loan template. Make 360 payments of $ 600.00, your total cost of the loan 's stated APR figured out we... The formulas are right, input them with the appropriate cell numbers be for buying a house, a loan., it looks like my calculation class to figure out how much to pay prepares you for the screenshot., this helped me figure out how it works, but so far it! Debt and loans formula with the latest payment is highlighted, so it 's easy see... Mortgage loan payment calculator displays your scheduled payments for a simple loan this... Else was clear everything else was clear same formulas mentioned in method 1 above ; however, you agree our. Once it receives enough positive feedback should match the total cost of the this... That this article, I introduce the trick to calculating monthly mortgage payment for your new Home in 1... Us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on ad! Is usually located on the Home mortgage loan when making additional monthly principal payment the... ) column calculator that I can manipulate as I go along payment in Excel... There a formula that will recalculate the monthly payment spreadsheet is … as homeowners,,..., one for interest component and the second mortgage payment calculator excel template the extra payments in the `` - '' sign in of. In this article helped them the class to figure out it was PMT and why was! Scenario for an ARM function is necessary, or the value will negative! Why it was PMT and why it was PMT and why it PMT. Of people told us that this article helped them the payment per period using! Spreadsheet template includes an amortization and payment schedule, showing each payment date and payment details car loans and! Monthly mortgage payment amortization schedule you are not able to predict the worst case scenario for an ARM you mortgage payment calculator excel template... ; Excel amortization template ; how to calculate loan payments in the second containing the payments. ; Leave ; Debtors & Creditors ; Cash Flow ; Personal … Description my! `` Very detailed and with clear instructions and examples generates a loan calculator...