:: Subscribe to our newsletter
 
Articles / Directory
06/17/2013
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



06/17/2013
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



09/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



09/08/2007
Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.



1/02/2009
Launch of NeuralCode(v1.0) for
Neural Networks Trading.



Free Lease or Buy Calculator - Net Advantage To Leasing

A company will periodically need to make decisions on the purchase of machineries and equipments for the production of the goods and services that it sells. When making some of these decisions, leasing is always an important factor to consider. To the company, it is the use of these machineries or equipments that are important, not the ownership. Thus cost is the main consideration whether to purchase or to lease the machineries and equipments.

A lease is an agreement made between the owner (lessor) and the user (lessee) of an asset. The agreement allows the lessee the right to use the equipment by making periodic payments to the lessor. The lessee will typically only consider leasing if the total amount of the lease is less than the amount required to purchase the asset. The question to ask is of course, how will the lessor be able to gain from such a lease? The answer lies is in the amount of tax reduction call a tax shield that a company will be able to claim.

A tax shield is defined as the reduction in income taxes when a company claims an allowable deduction from taxable income. An example of an allowable deduction is the interest that a company pays on the debt it has taken. The interest can be used to reduce the taxable income. Another example of a tax shield is depreciation. If a lessor is able to use depreciation and interest tax shields that cannot be used by a lessse, then the lessor will be able to offer a low lease payment that reflects the tax shields while still making a profit.



Net Advantage to Leasing

Net advantage to leasing is defined as the net present value of entering into a lease instead of borrowing money to buy the asset. If the net advantage to leasing is a positive value, it suggests that a company should enter into a lease instead of buying.

Net Avantage to Leasing spreadsheet

This spreadsheet helps companies make the decision whether to buy or lease an asset through the calculation of Net Advantage to Leasing.

Inputs

  • Tax rate - The company tax rate.
  • Loans interest rate - The interest rate for taking a loan to purchase the asset.
  • Cost of asset - The amount required to purchase the asset.
  • Lease payments - Lease payments before tax. As lease payments are tax deductible, the lease payments after tax will be calculated by the spreadsheet automatically.
  • Lost depreciation tax shield - If a company choose to purchase an asset, the depreciation is tax deductible. Choosing to lease an asset will result in the lost of depreciation tax shield. This column allows you to enter the lost in depreciation tax shield.

Conclusion

If the Net Present Value is a positive number, it is more beneficial to lease than to buy the asset.

Download Free Lease or Buy Calculator - v1.0

System Requirements

Microsoft® Windows XP®, Microsoft® Windows Vista®, Windows 7 or Windows 8
Windows Server 2003, 2008, 2012
512 MB RAM
5 MB of Hard Disk space
Excel 2002, 2003, XP, 2007, 2010, 2013

License

By downloading this software from our web site, you agree to the terms of our license agreement.

Download

FreeLeaseOrBuy_NetAdvantageToLeasing.zip (Zip Format - 89 KB)

Get the Professional version

Benefits
  • Unlocked
  • Allows removal of copyright message in the template
  • Allows commercial use within the company
  • Allows customization of Lease or Buy calculator
  • Full source code
PDF Specifications Commercial License

Price

USD12.90 - Purchase








 

Copyright (c) 2007-2014, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners