8. Increase Repayments Report | |
9. Detailed Payout Plan Report | |
10. Interest Rate Rise Report | |
< Back to main report menu |
Can you really save thousands if you increase your repayments by the smallest of amounts? The following are some of the powerful ways to use this report:
Note: You need to set a Loan Term on the Loan Account for the report information to be accurate. If the report displays Original Loan Term (years) 0.0 you will need to close the report, Edit the loan account and enter a value for the Loan Term.
INCREASE REPAYMENTS REPORT - FIELDS
The increase repayments report contains the following fields:
LOAN DETAILS
| |
Original Loan Amount
|
The original loan amount.
|
Original Loan Term (years)
|
The original loan term.
|
Loan Start Date
|
The original loan contract date.
|
Estimated End Date
|
The estimated end date of the loan based on the loan term and payment frequency.
Note - This is an estimate and may not be the exact end date of the loan. |
New Repayment Amount
|
Enter the new repayment amount for the scenario you wish to calculate.
For example, if the current repayment amount is 1,000 and you want to increase your repayments by 200 per payment, then enter the total figure of 1,200. The Required amount is the standard repayment amount you should use if you wish to pay out the loan over the full term. This value may vary slightly from the bank's figure as it is based on the latest information available, whereas the bank only recalculates the repayment amount on a periodic basis (e.g. every six months). The Minimum amount is the smallest amount you can enter into the report. A number less than the minimum would result in the loan balance increasing forever (as the interest charges will be larger than the amount you are repaying). The report prevents you entering a number less than the minimum amount. The Other Value is set when you type in a value that does not match the Required or Minimum amounts. |
Payment Frequency
|
Enter the period at which the bank charges you interest. In most cases this will be Monthly.
The Show amount save if paid: Weekly / Fortnightly option can be used to show you how much you will save if you split your monthly payments into four equal weekly payments, or two equal fortnightly payments. For example, if your monthly payment is 1,000 and you choose to pay 250 each week, the using this option will show you how much you will save making 52 payments of 250 a week (which is 13,000 a year) instead of 12 payments of 1,000 (which is 12,000 a year) |
Payment Type
|
This report only works with Principal & Interest scenarios.
|
Current Interest Rate
|
Enter the interest rate for the scenario. By default the report will show the interest rate from the last statement.
|
Current Balance
|
Enter the balance for the scenario. By default the report will show the balance from the last statement.
|
Include Offset Balance Of
|
If the mortgage has one or more offset accounts linked to the loan then enter the offset balance to use for the scenario.
By default the report will include a Zero offset balance amount, however you can select the Allowable % amount (which will use the total of the offset account balances multiplied by the allowable offset percent) or you can enter any Other Value. |
Include Lump Sum Of
|
Enter a one-off lump sum amount. This amount will be used in the target calculations.
For example, if you wanted to increase you repayments by 200 per payment cycle, however also wanted to know what would happen if you did a one-off deposit of 1,000 then you would enter the 1,000 into this field. |
Balance Date
|
Enter the balance date for the scenario. By default the report will show the balance date from the Last Statement, however you can change the date to Today (if you want the repayment scenario to start from today) or any Other Value.
|
Summary Text
|
The summary section of the report describes in words the impact of increasing or decreasing your repayment amount.
|
Description
|
The results table at the bottom of the screen displays the impact of changing the repayment amount, on three different lines.
The Requirement Repayment Amount line shows the number that apply when you repay the required amount (i.e. the amount the bank would normally charge). The New Repayment Amount line shows the numbers that will apply if you use the new repayment amount (i.e. the one you set up) The Total Impact line shows the different between the two lines above showing you the impact on the loan. |
Estimated Total Loan Term
|
For each line it shows the estimated total loan term.
|
Loan End Date
|
For each line it shows the estimated loan end date.
|
Estimated Remaining Loan Term
|
For each line it shows the estimated total remaining loan term (starting from the Balance Date entered).
|
Estimated Repayment Amount
|
For each line it shows the estimated repayment amount.
|
Estimated Outstanding Interest
|
For each line it shows the total amount of interest left to pay until the loan is repaid.
|
If you are looking to save thousands in interest payments, then this report is the place to start.
Did you know that if you have a variable rate mortgage your lender will regularly adjust your repayment amount so that you stay on track to paying it off over the full term? They do not want you to pay it off sooner, so even if you get ahead in you repayments, your lender will reduce the amount they want you to repay, to stretch it back out to the full term. They know that if you have a 30 year loan, they can maximise their profit by letting the interest accumulate over 30 years.
The power of this report is that it lets you set the terms of your repayment, and then keeps you on track to achieving your goal. It does not matter if the bank changes the repayment amount, you make a one-off deposit (or withdrawal), interest rates change, etc, this report will continue to adjust your repayment amount to suite your payment terms, not the banks.
Each time you run the report it will show you how long you have left to reach your goal, and the new repayment amount required to achieve it. For example, if you set the target loan term to 20 years, and you are in the second year of repayments, it will show you the required repayment to finish paying the loan off in 18 years.
All you do is enter a Target Loan Term, and the report does the rest. The report also shows you the total interest you will save, by comparing the total remaining interest on the original loan term (for example 30 years) with your new target (for example 20 years).
Note: The repayment amount specified in this report does not include any additional fees your lender charges you. Therefore if you pay a regular account keeping fee you will need to add it to the repayment amount displayed in the report.
Example Results
The following example report highlights that you can save 49,402 on a 100,000 loan, just by paying it off in 20 years instead of 30 years. The report shows this can be achieved by increasing the monthly repayments by approximately 133.24 for the next 18.06 years.
Loan Plan | Loan Term | Loan End Date | Remaining Loan Term |
Estimated Repayment Amount |
Estimated Outstanding Interest |
|
Original Payout Plan | 30.00 | 23/04/2033 | 28.06 | 652.37 | 121,925.94 | |
Target Payout Plan | 20.00 | 26/04/2023 | 18.06 | 785.61 | 72,523.36 | |
Total Impact | 133.24 | -49,402.58 |
NOTE: The information was produced for a loan currently in its second year of repayments (that is, 28 years remaining), with monthly repayments.
As well as the target loan term, you can change any of the following:
Note: You need to set a Loan Term on the Loan Account for the report information to be accurate. If the report displays Original Loan Term (years) 0.0 you will need to close the report, Edit the loan account and enter a value for the Loan Term.
DETAILED PAYOUT PLAN REPORT - FIELDS
The detailed payout report report contains the following fields:
LOAN DETAILS
| |
Original Loan Amount
|
The original loan amount.
|
Original Loan Term (years)
|
The original loan term.
|
Loan Start Date
|
The original loan contract date.
|
Estimated End Date
|
The estimated end date of the loan based on the loan term and payment frequency.
Note - This is an estimate and may not be the exact end date of the loan. |
Target Loan Term
|
Enter the new target loan term for the scenario you wish to calculate.
You can enter the value in one of three ways. Select Target Loan Term (years) if you wish to enter the new loan term in years. For example, if you have a 30 year loan however you want to pay it out in a total of 25 years from the loan start date, then you would type in 25. Select Pay Off Loan By (date) if you have a future date by which you wish to be debt free. Select Reduce Loan Term By (years) if you wish to enter a value to reduce your current loan term by. For example, if you have a 30 year loan however you wish to be debt free five years earlier than the banks end date, enter 5 into this field. |
Payment Frequency
|
Enter the period at which the bank charges you interest. In most cases this will be Monthly.
|
Payment Type
|
This report only works with Principal & Interest scenarios.
|
Current Interest Rate
|
Enter the interest rate for the scenario. By default the report will show the interest rate from the last statement.
|
Current Balance
|
Enter the balance for the scenario. By default the report will show the balance from the last statement.
|
Include Offset Balance Of
|
If the mortgage has one or more offset accounts linked to the loan then enter the offset balance to use for the scenario.
By default the report will include a Zero offset balance amount, however you can select the Allowable % amount (which will use the total of the offset account balances multiplied by the allowable offset percent) or you can enter any Other Value. |
Include Lump Sum Of
|
Enter a one-off lump sum amount. This amount will be used in the target calculations.
For example, if you wanted to cut five years off your loan term, however you wanted to take into account a one-off deposit of 1,000, then you would enter the 1,000 into this field. |
Balance Date
|
Enter the balance date for the scenario. By default the report will show the balance date from the Last Statement, however you can change the date to Today (if you want the repayment scenario to start from today) or any Other Value.
|
Summary Text
|
The summary section of the report describes in words the impact of increasing or decreasing the remaining loan term.
|
Description
|
The results table at the bottom of the screen displays the impact of changing the remaining loan term, on three different lines.
The Original Payment Plan line shows the numbers that apply when the original loan term is used (i.e. the loan term the bank will use in its calculations). The Target Payout Plan line shows the numbers that will apply when the new loan term is used (i.e. the one you set up) The Total Impact line shows the different between the two lines above showing you the impact on the loan. |
Loan Term
|
For each line it shows the total loan term for the loan.
|
Loan End Date
|
For each line it shows the estimated loan end date.
|
Estimated Remaining Loan Term
|
For each line it shows the estimated total remaining loan term (starting from the Balance Date entered).
|
Estimated Repayment Amount
|
For each line it shows the estimated repayment amount.
|
Estimated Outstanding Interest
|
For each line it shows the total amount of interest left to pay until the loan is repaid.
|
If you are worried about the impact of future interest rate changes (and interest rate rises in particular) then
this report will help.
The report lets you to enter a new interest rate for a loan, allowing you to see how much better or worse off you will be when interest rates change.
The report shows the old and new estimated repayment amounts and the total outstanding interest payment for the remainder of the loan.
You will know in advance how much extra a rate rise will cost you, allowing you to better prepare for it.
Note: You need to set a Loan Term on the Loan Account for the report information to be accurate. If the report displays Original Loan Term (years) 0.0 you will need to close the report, Edit the loan account and enter a value for the Loan Term.
INTEREST RATE RISE REPORT - FIELDS
The interest rate rise report contains the following fields:
LOAN DETAILS
| |
Original Loan Amount
|
The original loan amount.
|
Original Loan Term (years)
|
The original loan term.
|
Loan Start Date
|
The original loan contract date.
|
Estimated End Date
|
The estimated end date of the loan based on the loan term and payment frequency.
Note - This is an estimate and may not be the exact end date of the loan. |
New Interest Rate
|
Enter the new interest rate for the scenario you wish to calculate.
|
Payment Frequency
|
Enter the period at which the bank charges you interest. In most cases this will be Monthly.
|
Payment Type
|
Select the payment type for the scenario: Principal & Interest or Interest Only.
|
Current Interest Rate
|
Enter the interest rate for the scenario. By default the report will show the interest rate from the last statement.
|
Current Balance
|
Enter the balance for the scenario. By default the report will show the balance from the last statement.
|
Include Offset Balance Of
|
If the mortgage has one or more offset accounts linked to the loan then enter the offset balance to use for the scenario.
By default the report will include a Zero offset balance amount, however you can select the Allowable % amount (which will use the total of the offset account balances multiplied by the allowable offset percent) or you can enter any Other Value. |
Include Lump Sum Of
|
Enter a one-off lump sum amount. This amount will be used in the target calculations.
For example, if interest rates were going up by 1%, however you wanted to take into account a one-off deposit of 1,000, then you would enter the 1,000 into this field. |
Balance Date
|
Enter the balance date for the scenario. By default the report will show the balance date from the Last Statement, however you can change the date to Today (if you want the repayment scenario to start from today) or any Other Value.
|
Summary Text
|
The summary section of the report describes in words the impact of increasing or decreasing the interest rate.
|
Description
|
The results table at the bottom of the screen displays the impact of changing the interest rate, on three different lines.
The Original Interest Rate line shows the numbers that apply when the original interest rate is used (i.e. the interest rate the bank will use in its calculations). The New Interest Rate line shows the numbers that will apply when the new interest rate is used (i.e. the new one you entered) The Total Impact line shows the different between the two lines above showing you the impact on the loan. |
Interest Rate
|
For each line it shows the interest rate being applied.
|
Estimated Repayment Amount
|
For each line it shows the repayment amount required.
|
Estimated Outstanding Interest
|
For each line it shows the total amount of interest left to pay until the loan is repaid.
|