This Professional Split Loan Analysis Tool is created to help you to find the ideal loan split between the variable and the fixed rate options.

As you may know that splitting your home loan can offer the flexibility of a variable rate and save you money as the fixed rate is often lower than the variable rate. However how to split your home loan between fixed and variable is a very important question. Normally with variable loan you can have an offset account and there is no repayment limit per year. While on fixed rate loan you often don't have the same offset facility and there is an annual limit on how much extra you can repay. So how one can figure out the best split between the variable and the fixed rate loans? The answer is this Professional Split Loan Analysis Tool which will run many different scenarios and find out the optimal combination of variable and fixed interest rate loans.

This Professional Split Loan Analysis Calculator lets you experiment with many different loan split scenarios by adjusting variables such as loan term, loan repayment frequency, fixed period, interest rate, extra repayment limit, etc. You can specify the amount you want to fix and the calculator will let you know if your plan works the best.

Here is a screenshot that will give you a better idea that what you need to do and what this Professional Split Loan Analysis Tool can do for you.

Things You Need to Know

This calculator is built in Microsoft Excel worksheet. You need to have Microsoft Excel® 2013 & Above for Microsoft Windows® OR Microsoft Excel 2016 & Above for Mac® to use it. You need to enable Macro in Excel so this tool will work.

All the calculators (paid and free ones) on this website are password protected. We don't provide unprotected versions of the PAID calculators due to copyright reasons. If you purchase the paid calculators because you want to get the unprotected version please don't make the purchase as we are not going to provide unprotected copies. By purchasing the paid calculators you agree that no unprotected copies of the PAID calculators will be provided to you. If you don't agree please do not purchase. If you need the unprotected version of any FREE calculator a fee will apply. The advantage of the unprotected version is that you can freely edit the tool without any limit although we still own the copyright of the unprotected calculator. Please note you cannot redistribute our calculators without a written approval from us even for the ones with your modification or customization. In addition we are not going to provide any support on unprotected calculators with any modification or customization.

Important Assumptions

Please note: This Professional Split Loan Analysis Tool is built based on the following assumptions.

(1) All months are assumed to be of equal length. One year is assumed to contain exactly 52 weeks or 26 fortnights. This implicitly assumes that a year has 364 days rather than the actual 365 or 366.