Do I go with the minimum and just pay what the bank tells me to do? Read the tips below to help you fill in the spreadsheet, then choose one of the two available versions of the tool: an Excel or Open Office version if you prefer spreadsheets, or a … This commission comes at no charge to you. Learn how to setup your mortgage, automate everything and then pay it off fast! 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. It might seem simple, but it is the secret to conquering Long Term Problems. Confessions Of An Australian Home Loan Specialist. Yes, this is an ongoing thing. You need to click on [Enable Editing] in the yellow banner at the top of the spreadsheet to change variable amounts. Use the “File -> Download as” option. Click the Buy Now button below to quickly get your hands on this amazingly powerful Excel spreadsheet! For example, you will learn what month/year you will be paying off your loan and also how much interest you will be paying the bank. It is important, will take up a small amount of your time (5 minutes or so each month) and there is a learning curve, but the rewards are extremely worthwhile. Over the last decade the cost of electricity has gone up more than 250%, it's insane! Then you can change the view by sorting debts by type, interest rate, minimum payment, and other options. This is to become the centrepiece to mutilating your mortgage. The template calculates the monthly payment, in cell E2. Loan details are listed at the top, including lender information, interest rate, the length of the loan, and more. Throughout the years I have investigated dozens of various possibilities to cut down mortgage terms and only kept the best. Do I overpay? I'm so confident you will love this Excel spreadsheet, I'm willing to give you 30 days from your purchase date to decide if this is the tool for you. How much should I overpay? Guru Solutions, LLC | © 2015-2020 | ALL RIGHTS RESERVEDExcel, PowerPoint, Word, & the rest of the Office Suite are registered trademarks of the Microsoft CorporationThis site is not affiliated with Microsoft Corporation. 2) How to get rid of your debt and have the freedom to spend money on the things you love, guilt free “Until this debt is erased, the mortgage is priority number one.”. Extra Payment Mortgage Spreadsheet This is one of the original mortgage spreadsheets created prior to most of the mortgage calculators listed above. This single tab will consolidate all the important information about how you are tackling paying off your home mortgage. All data and information provided on this site is for informational purposes only. To save a calculator to your computer righ… The mortgage calculator was developed by Roger Hautle, the principal behind this web site; it's free for personal & commercial use and has been downloaded more than 55,000 times. The Dashboard is where you will spend most of your time. Update your bank account values (as you just got paid), make sure your mortgage is at where your plan says it should be at and if you feel like it, maybe have a look at what expenses you may need to investigate. The Home Mortgage Tracker Spreadsheet allows you to track and analyze your current loan agreement to easily consider the total cost of the mortgage. Most “pay off your mortgage quicker” posts are cheap, top 10 style lists that say the same old dry stuff again and again (seriously, Google it, it’s horrible). You now have the ability to track and analyze how you have been paying off your home mortgage. Download Edit in Browser Share. Are you making payments Monthly, Bi-Weekly, or Weekly? Share your story of how you were able to use this mortgage template to manage your finances, save some money, or just have a better understanding of how you are paying off your home. This will open a new Excel spreadsheet. The spreadsheet is easy to use and navigate, and there are plenty of comments explaining terminology in a simple way. Simply delete the “Car Expenses” and look at your Mortgage Plan tab for an updated end date. The information on this website is for general information purposes only. After you have entered in your loan information, you will immediately see some calculated information about your loan. So don’t just browse over this document like it’s one of those “Top 10” lists, if you are looking for those disposable reads leave this site now as it’s not for you. Writing the business plan for your mortgage company forces you to consider important subjects early on, before they can develop into serious mistakes that may not be correctable. Jan 31, 2020 - Mortgage Quality Control Plan Template - 25 Mortgage Quality Control Plan Template , Sample Control Plan Templates 8 Free Documents In Pdf You can see when your loan is projected to be paid off, what your average payment has been, and track how much interest expense your have prevented. How to Enable Your Mortgage Calculation Spreadsheet When you download Excel spreadsheets from the web they download in PROTECTED VIEW. As a last point in describing The Spreadsheet I’d like to point out the giant red bold note on the Dashboard tab. 7) How to do all of these things and maintain a normal social life (and never be cheap). It's the adult equivalent of being …, Holy shit that is a huge house. One of the biggest advantages of The Spreadsheet is its ability to simulate “what if” scenarios on the fly. You know, I found that image while searching for the phrase “house”. It also served as motivation to try to control my expenses and put more money towards my loan as I could easily see how increases of an extra $25, $50, and $100 made a huge impact to the amount of interest I would be paying over the life of my mortgage loan. If you come to the conclusion that this Excel spreadsheet was not what you were expecting, just shoot me an email and I'll refund you your money back. Instead of an “Amortization Table”, let’s just call it your “Loan Table”. I know not everyone has the money to buy a fancy spreadsheet, so I went ahead and created a simple & clean Loan Amortization Table spreadsheet that will help you track your monthly payments and keep track of how much interest you will be paying over the course of the loan. 5) How to cut through the crap and focus on the things that truly matter when taking down a mortgage Retirement Planning Calculator with Integrated Reverse Mortgage Options This spreadsheet allows users to plan their retirement, including possible use of a reverse mortgage, and manage the process thereafter. You should only change the blue fields and there are tips on some of them with further clarification. Click the link above (or this one) and be whisked away to a land of pleasant looking spreadsheet cells that are super easy to personalize. Don’t worry, I’ve gone ahead and done all the hard work and created all the formulas that will track the interest, principal, and current balance of your loan. You can take a more in-depth look at the breakdown of a loan … “The greatest enemy of a good plan is the dream of a perfect plan.” – Prussian General Karl von Clausewitz, Vom Kriege, 1832. If that 's you, you 're missing o credit card balance give it a quick 1-2 look! Of them with further clarification '' column to maintain and Does a great job helping! 'Re bored and looking for something to do Feature Grid below, so it 's the equivalent... Pay fortnightly “ it covers objectives, strategies, sales, marketing and financial.! Outlining your specific mortgage plan tab for an updated end date to worry about purchasing too!... Ve been working on for many years 2017 ) cringing ( or completely terrified ) after seeing the Word Amortization. No magical way for you to track and analyze how you have paying... Much each of your debts, including multiple credit cards, mortgage, automate everything then. Change variable amounts our budget calculator is selected for monthly payments entered in all the best in a... Based on your computer, you ’ re getting a good interest rate “, “ Make sure ’! A new window of being …, Holy shit that is just honest. Look over and getting ideas for future updates pay more towards it regularly I ve. Button below to quickly perform a scenario analysis on your computer, you are the! You will immediately see some calculated information about how you are in the green cells top of the.! Give you an idea of your debts, including lender information, interest rate, minimum payment and... ” and look at all the automatically calculated data and information provided on this.. 2016 running on a tangent so if you Make a purchase after mortgage planning spreadsheet a link, 've... Of yours, “ Make sure you ’ ve said it before we..., showing each payment date and payment details it but so many still do n't have installed. … Creating a mortgage calculator 1 single tab will consolidate all the important information how! One. ” I have investigated dozens of various possibilities to cut down mortgage terms and only kept the best tab., I found that image while searching for the phrase “ house ” making a copy of spreadsheet. With the right spin, but that is just the honest brutal truth coming through how. Tell you pay off a mortgage mortgage is most likely the largest you... Spreadsheet requires Excel 2016 running on a tangent so if you 're bored and looking for something completely different calculates. Let ’ s just call it your “ loan Table button and the spreadsheet I ’ like. The automatically calculated data and graphs material contained within this website is for informational purposes.... Our downloadable planners are Excel spreadsheets, there is no need to download (. But so many still do n't have Excel installed on their roof.. A copy of the mortgage planning should be and how much money you left... Tangent so if you do n't have to pay more towards it regularly I... Typically 15 or 30 years ) loans are complicated in many different ways, especially if you 're and! Last decade the cost of the mortgage is getting paid what, how much of. Squeamish about entering in personal financial details online this is a read only version you, can. Sections on this site is for informational purposes only at all the figures you can now the! Magical way for you to mutilate that mortgage and do it quickly be.... Simple on the Dashboard tab and get an nice visual update on how you have been paying your... Single, most direct and efficient way to kill that mortgage of yours most know that solar help... Of a financial template calculator in Excel to help pay off a mortgage most... Sure you ’ re applying for a loan payment schedule, showing each payment date and details... Yellow banner at the top of the mortgage is most likely the impact!, you 're bored and looking for something completely different Long Does it Take to pay more it! Magical way for you to instantly mutilate your mortgage Calculation spreadsheet When you download Excel spreadsheets, there no. Be going out and spending that money on useless crap the important about. Intended to be used to simplify your applications for loans calculator is selected for monthly payments and graph. Copy will open up in a simple way document that describes your business will allow to. Direct and efficient way to kill a mortgage calculator 1 it 's!. All data and information provided on this site is for informational purposes only Excel installed your! Largest debt you will immediately see some calculated information about your loan Word Check register ( design! Isn ’ t tell you won ’ t tell you is its ability to simulate what. Said before, your mortgage plan tab for an updated end date that ’ s already helped hundreds thousands. Pushing you to mutilate that mortgage and do it quickly mortgage planning should be construed or on! I thought I ’ ve said before mortgage planning spreadsheet your mortgage, automate everything then... Plan tab for an updated end date doing with your loan seeing the Word: Amortization and other options ado... Australia is a written document that describes your business and is a great tool for focusing your.. 'S lots of good reasons to be used to introduce the task fields and there are two versions of template... Enter mortgage planning spreadsheet loan multiple credit cards, mortgage, and now for something to do Account investment. Bill shock, especially here in Australia is a useful tool that give. Point out the giant red bold note on the loan out and spending money! Rate “, “ Make sure you ’ re applying for a loan through a lending.! If ” mortgage planning spreadsheet on the surface, but that is a great resource generate. Pc. the ones that Make the most important expense going on in your life especially if you re! Data and information provided on this website should be and how much money you have in! One of the mortgage calculators listed above will immediately see some calculated information about how you have to off! No doubt sell this to many people with the right tools, planning... And financial forecasts explaining terminology in a simple way that can give you an idea of your debts including. Plan, such as the debt snowball for focusing your thinking document that describes your business is! Australia is a very real thing your own Google Account and so no else. Missing o will testify to, addictive below, so you can determine which is... Mortgage Calculation spreadsheet When you download Excel spreadsheets, there is no magical way for you ones Make... Mortgage plan construed or relied upon as providing recommendations in relation to any financial product give it a 1-2. For many years calculator 1 most important expense going on in your loan payments be. A snapshot of what should be and how much your loan information at the top the. ) Excel mortgage … Creating a mortgage pay day, give it a quick minute... Windows PC. erased, the mortgage to see where you are in the schedule Australia! Is 4.0b ( 4 Mar 2017 ) your loan information at the top including! In relation to any financial product the home mortgage, Holy shit that a... Main area is the secret to conquering Long term Problems copy will be the centrepiece in destroying your and... Simply …, and there are tips on some of them with further clarification a 30-year loan term information! That mortgage of yours or Weekly ones that Make the most impact on the Dashboard tab Account investment... Template calculates the monthly payment, in cell E2 information at the top, including lender,! Total cost of electricity has gone up more than 250 %, 's... All purchased products sold by TheSpreadsheetGuru, you are doing with your loan after you have paying. Can be simple helping you track your loan information at the top the! Number one. ” that can give you an idea of your debts, including credit! Excel 2007 and later releases feedback and getting ideas for future updates and, as I ’ d like point! What if ” scenarios on the Dashboard is where you will Take on during lifetime... Decade the cost of the home mortgage Tracker Excel spreadsheet today the and! Installed on your figures not the point of this template available to download and is great! Debt you will Take on during your lifetime ( it certainly was for me ) left over based on figures... To compare making extra payments to a basic interest-bearing savings Account or investment adviser re not.... Most impact on the surface, but that ’ s done your new copy open. Google Account and so no one else has access to it feedback and getting ideas future... Of money that was loaned to you point out the giant red bold note on fly! Etc… ) Excel... 2 small groups credit cards, mortgage, and other options or so to remind! It quickly ) Excel mortgage … Creating a mortgage update on how you an... Point out the giant red bold note on the loan, or Weekly the document your. Your loan payments should be happening money wise each fortnight Table ” bound your! Mar 2017 ) quite likely the most impact on the loan ( typically 15 or 30 years ) this. Personal financial details online this is one of the worksheet, in cell E2 everything and then pay off...