Microsoft Excel Training Course

How does $20,000 mortgage repayments equate to $47,598.02?

All eyes will be on the announcement from the Reserve Bank Governor today to see what is happening with interest rates. If you are like most people your cashflow would have been affected in the years since Covid because of the increasing interest rates.

There has never been a more important time to master your household budget and spending than now and good knowledge of Microsoft Excel will give you these skills.

The COMPLETE Microsoft Excel Course Package now includes a mortgage spreadsheet

A mortgage for your home is a huge debt, particularly for those living in the swelling capital cities with soaring house prices. The pro and cons of buying your own house and living in it are:

  • You don’t pay capital gains tax on a property you live in, but
  • You can’t claim the interest component of your loan

The big problem with this is the interest charge – you can’t claim the cost of it yet it’s a massive component of each and every payment you make on your mortgage.

You’d need your house price to go up at least at the interest rate you are paying to make it a good investment – and right now you’d be doing fine (perhaps except in Perth now).

Bigger payments reduce the interest paid

Our Microsoft Excel Training Course now includes an Excel spreadsheet file that will help you see just how much money you’d save if you paid even a small amount off extra each month!

You can use the mortgage comparison file to compare two mortgages, make extra payments or even shorten the term of the loan to see how much you’d need to pay each month if you want to pay your mortgage off quicker.

If you are an existing Excel Course student you’ll find the new file at the end of our Microsoft Excel Advanced Course 309.

Take 10 years off your mortgage when you can

There are several reasons to open this spreadsheet and start seeing the resulting figures to workout the best way to allocate the money you earn. 

  • Interest rates are at record highs,
  • house prices ‘may’ be peaking,
  • some people say that Australian banks are so highly leveraged to the residential property market that they’ll need to hold more capital reserves.

Either way you look at it, why not use your Microsoft Excel skills and play with some calculations to see how much better off you could be if you are financially prudent now.

You can also use this Microsoft Excel file to do a stress test and see how much your mortgage would be if interest rates do go up as many people expect they will.

50% OFF the normal price for Microsoft Office courses

See our currently discounted Microsoft Office Courses

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Xero gives itself a 90% high distinction – users disagree

Have you seen the recent ads promotion 90+ % approval from their customers? The claims…

4 days ago

Intuit QuickBooks Course updates coming – features and navigation changes

Intuit is hunting for ways of helping their software become more relevant to Australian small…

1 week ago

Another price increase from Xero – 4 straight years of price increases sends social media mad?

It's interesting how negative the sentiment is on Linkedin and Facebook when you start seeing…

2 weeks ago

The election for accounting software is now on

Have you noticed the social media ads for Reckon, MYOB and Xero? It's 2 months…

4 weeks ago

What is the cheapest way to learn Xero and Microsoft Excel

Learning how to use Xero for specific tasks is easy. There are dozens of videos…

1 month ago

Office Admin Workers Day – gift ideas for staff

Office admin workers are the key employees which keep every business running, large or small.…

1 month ago