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

Can you REALLY Trust PayPal?

When we were using our old enrolment form I was alerted about the option to…

3 days ago

Bookkeeping Basics: Chart of Accounts Explained

Just wanted to give you the heads-up on some cool stuff we've been working on.…

5 days ago

Thank you Dani!

I've received some negative feedback this week, but it's not as bad as you think.…

2 weeks ago

Stay Ahead of the Curve: Our Updated Xero Beginners Course Reflects Xero’s Constant Evolution

In today’s fast-paced business environment, staying stagnant is a recipe for falling behind. This is…

4 weeks ago

Are you 1) Angry, 2) Frustrated or 3) Exhausted trying to use Microsoft Excel?

Master Microsoft Excel one step at a time with the guidance of: Training Workbooks Excel…

1 month ago

Cyber Security for Bookkeepers – How are scammers trying to get you

Every contract bookkeeper loves receiving these emails but they can wreak havoc with your computer…

2 months ago