Do you have a spreadsheet for calculating a lease/buy decision?

In the current financial climate, the most obvious answer to this question is quite possibly why?

With the base rate still at 0.5% there’s little point leasing a piece of equipment if you have the cash to buy it.

Asset backed lending – a fancy term for leasing – can be relatively cheap if the asset in question has a good and easily realisable second hand market value. The lenders used to love fancy IBM mainframe computer hardware as it could be repossessed and sold-on if the lease went bad. It’s not quite the same these days with £500 servers, but the principle remains.

The interest rates you get charged on a lease can vary wildly depending on the asset security, term and risk the lender sees in you the borrower. Rates will often exceed 10%, which is easily achievable when customers have no option but to lease and the lease values are small and relatively expensive to administer.

Modelling a lease-buy scenario is quite easy with a bit of Excel know-how and each case is probably best looked at in isolation. YouTube has quite a wealth of content on the subject, some of which looks pretty daunting and probably confusing.

The bottom line is buying involves cash outlay now with a VAT recovery (for equipment not cars) a month or few later. Leasing (HP or rental) involves payment of a deposit and fees now and then a rental stream over a period and maybe a balloon payment at the end. Ownership may pass to you or not and this will impact the VAT treatment. You are trading one set of cash flows for another.

A business we know has an HP agreement for an industrial floor cleaner which helps illustrate this. The cleaner cost £5,800 plus VAT of £1,160 (recovered by the company). The business paid the lease company a deposit of £1,496 and now has 35 rentals to pay of £185.60 each with a final purchase payment of £75 at the end.

If you do the sums you will see the finance cost is £1,107 (an extra 19% on the cost of asset) and the annual rate of return for the lender is 13.4%. For a business sitting on cash at the moment, it’s not quite clear why they took the lease option. They certainly did not consult Tectona at that time.

There are other tax related considerations in a lease-buy decision which depend on the type of lease and the business tax allowances you get. Buying could bring a 100% tax deduction in the year of purchase but you might not see the cashflow benefit of that for well over a year. With a lease with no change of ownership at the end, the rentals themselves are tax deductible.

There will be spreadsheets out there that will do a calculation for you, but beware. They may not be detailed enough to cover all aspects of your lease option and they may not cover the tax properly. If it’s a big decision for you, come and talk to one of our FDs.

Posted in Uncategorized.