Home Money Manager Home Money Manager
Home Money Manager

Home Loan Manager - User Manual

Table of Contents > Plan For The Future
Beat Your Bank Beat Your Bank

Plan For The Future

Worried about interest rate rises? Want to find out how to pay off your mortgage sooner? The following reports will give you answers and keep you informed as you circumstances change:
    
   8.  Increase Repayments Report
   9.  Detailed Payout Plan Report
 10.  Interest Rate Rise Report
   <  Back to main report menu


8. Increase Repayments Report



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:

  1. Enter a new repayment amount and see how many years you will cut off the loan.
  2. Enter a one-off lump sum amount and find out how much you will save in interest payments.
  3. If you have an offset account find out the impact the offset balance will have over the life of the loan.



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.


REPORT OPTIONS

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

Summary Text


The summary section of the report describes in words the impact of increasing or decreasing your repayment amount.


RESULTS TABLE

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.


Top of page


9. Detailed Payout Plan Report



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:

  1. The interest rate.
  2. The loan balance.
  3. The option to include the offset balance (if applicable).
  4. The repayment frequency.
  5. The current date.

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.


REPORT OPTIONS

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

Summary Text


The summary section of the report describes in words the impact of increasing or decreasing the remaining loan term.


RESULTS TABLE

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.


Top of page


10. Interest Rate Rise Report



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.


REPORT OPTIONS

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

Summary Text


The summary section of the report describes in words the impact of increasing or decreasing the interest rate.


RESULTS TABLE

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.


Top of page