Skip to main content

Novated Lease vs Car Loan vs Cash Purchase


You could have been searching for a sample Novated Lease calculator or illustration that you can use to compare versus a typical car loan or a straight-forward cash purchase.

Below is a sample comparison.

Those ones in yellow, except for the 'annual salary' which you should be providing to leasing company, will be provided by the same leasing company. You can play around and replace the values as you please. Those ones in 'orange' can be changed as well on the Car Loan and Cash Purchase options.


sample comparison



For the car loan option, you can change the values for the 'Loan Capital/Car Purchase' and 'Interest Rate'. You should be able to provide this by asking a car dealer and/or bank where you will avail of the loan.

For the car purchase option, the 'Opportunity Loss Rate' can be optionally supplied. You can supply a value that may be equivalent to the ongoing bank interest rates or any investment tool interest rate that you think is applicable.

Here is the link of the spreadsheet:

You can download and share this article and please don't forget to hit the like button as well.

Enjoy shopping for your new car!

The following excel sheet may also be useful to get a glimpse of  your payout schedule each month as well as the amount should you wish to early terminate your lease. Please note though that this is only for comparison. The formulas used in this file may be different from that of your novated leasing company.


Please help the blogger by leaving a comment, hitting like button and sharing this article. Thanks!




Novated Car Leasing Myths



DISCLAIMER: 

The information in this website and the links provided are for general information only and should not be taken as constituting professional advice from the website owner

The calculators and tools on this website are provided for your information and to illustrate scenarios. The results should not be taken as a substitute for professional advice.

All reasonable care has been taken in preparing and designing the calculators and tools; however, ASIC provides no warranties and makes no representation that the information provided by the calculators and tools is appropriate for your particular circumstances or indicates you should follow a particular course of action.

 









Comments

  1. Should cell I28 be a real number or a formula i.e. =F28

    ReplyDelete
    Replies
    1. for simplicity, i made them equal.

      Delete
    2. it should be equal to f28 but cell i28 is fixed and can't be ammended...

      Delete
    3. modified. thanks folks for the comments .sorry for the late reply. feel free to like and share.

      Delete
  2. Can you check the interest calculation in f30 please? I used the CUMIPMT formula and calculated the cumulative interest to be $2947.12.

    By the way, I really love this workbook. Got me much further that I could have on my own. I'm just trying to check the formula's so I understand.

    ReplyDelete
  3. Awesome sheet here mate. One thing I noticed is the (I28 Loan Capital/Car Purchase) figure does not change with the figure typed in F28. Could you have a look at it? The value stays at $31500

    ReplyDelete
    Replies
    1. modified. thanks folks for the comments .sorry for the late reply. feel free to like and share.

      Delete

Popular posts from this blog

Novated Lease Calculator - UPDATED!

DOWNLOAD ->  CALCULATOR: Novated Lease vs Car Loan vs Cash Purchase You can download and share this article and please don't forget to hit the like button as well. Enjoy shopping for your new car! Password = check the comments section below. please leave your comments if you like it DISCLAIMER:  The information in this website and the links provided are for general information only and should not be taken as constituting professional advice from the website owner The calculators and tools on this website are provided for your information and to illustrate scenarios. The results should not be taken as a substitute for professional advice. All reasonable care has been taken in preparing and designing the calculators and tools; however, ASIC provides no warranties and makes no representation that the information provided by the calculators and tools is appropriate for your particular circumstances or indicates you should follow a pa...
Novated Car Leasing Myths What is Novated Leasing? A novated lease (colloquially know as ‘salary sacrificing’) is basically a three-way agreement between an employer, an employee and a finance company. The employee gives consent to “sacrifice” some pre-tax salary to pay for their vehicle. The employer agrees to make the payroll deduction on the employee’s behalf. The finance company sets up the deal and handles administration. If the package is structured intelligently, at the end of the term all the employee needs to do is hand the keys back and decide what car to buy next. Novated leases are a popular form of cost- and tax-advantaged car financing and the government estimated that there are approximately 320,000 drivers in Australia who are currently salary sacrificing a car. “Even if you use your car exclusively for private purposes, the government gives you an 80% concession on the FBT. It’s a significant benefit,” explains Bill Baker from   novatedleasing.com.au . “Whe...