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 oneoff 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 oneoff 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 oneoff 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 oneoff 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 oneoff 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 oneoff 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 oneoff 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.
