Lease-buy   |   NPV with Monte Carlo   
 
 
LEASE - BUY ANALYSIS BETA

Companies have usually several options when acquiring capital equipment, including leasing, financing the purchase through a loan, or buying the equipment with cash. Since decision makers want to look at total costs instead of just month-to-month payments, FinanceIsland's lease-buy analysis provides a quick comparison of these options.

This tool calculates the total costs at the time of equipment acquisition, during its use, and at the end of its use. The tool employs net present value (NPV) as a metric to correctly summarize these costs. From a purely financial point of view, companies should acquire capital equipment based on the option with the lowest NPV, i.e., the lowest total costs, which is highlighted in the green section below. For a more thorough review of lease and buy choices, please see FinanceIsland's lease or buy tutorial.

Only the following four parameters can be adjusted in the tool version below: equipment price, usage duration, and annual interest rates for lease and financed purchase. To use all features of this FREE lease-buy tool, please  if you have previously registered or register.
 
         
 



DEFINITIONS

Annual interest rate
Interest rate charged by a financial institution for a lease or loan

Cash flow chart
Cash flows before, during, and after equipment use; positive number = cash outflow

The cash flow chart depicts total annual cash flows for every equipment acquisition option. These cash flows are nominal cash flows, i.e., before discounting. They are visual representations of the total cash flows from the cash flow details tables.

Delivery/installation fee
Equipment delivery, installation, and any other out-of-pocket expenses, such as software or training

Depreciation period
Number of years the equipment will be depreciated for accounting and tax purposes (this tool uses the straight-line depreciation method)

Discount rate
Rate of return to calculate the present value of future cash flows

The discount rate, also referred to as rate of return, hurdle rate, or opportunity cost of capital, is a proxy for the financial risk associated with any investment. This opportunity cost is the return forgone by investing in a specific project rather than in comparable investment alternatives. The discount rate is determined based on the first basic principle of finance that a dollar today is worth more than a dollar tomorrow and based on the second basic finance principle that a safe dollar is worth more than a risky dollar.

In lease-buy decisions most of the investment characteristics are set in stone once the decision is made, leading to very predictable future cash flows such as monthly payments or tax advantages. Hence, lease-buy decisions can be considered low risk. The function of the discount rate is then to appropriately value cash flows in different time periods and discount them to today's dollars.

Because of the usually low financial risk associated with a lease-buy decision, the discount rate needs to reflect this low risk. This can be accomplished by choosing a discount rate that is close to a risk-free rate of return expected for example from short-term (3-month) U.S. Treasury bills. But many times companies determine a weighted average cost of capital (WACC) for the company and use it for all investment decisions. By doing this though companies treat low risk investments, such as capital purchase, the same way as high risk investments, such as bringing new technology to a new market. Hence, FinanceIsland recommends using a risk-free rate for the lease-buy analysis.

You can find more information about choosing an appropriate discount rate for various investment projects in FinanceIsland's tutorial on risk and the Capital Asset Pricing Model.

Disposition fee
Fee that may be set by the leasing company to compensate for the expenses of selling or otherwise disposing the equipment at the end of the lease

Down payment
Payment made usually at the time of equipment possession that reduces the amount to be financed

Effective tax rate
Company's effective tax rate based on the federal tax rate and potentially adjusted for state or local taxes

The effective tax rate is used to calculate tax deductions and after-tax cash flows. According to the guidelines on deductible business expenses from U.S.' Internal Revenue Service (IRS), this tool calculates tax deductions and after-tax cash flows for the following business expenses:
  • lease: down payment, lease payments, and disposition fee
  • financed purchase: loan interest payments, equipment depreciation, and taxes on equipment sale
  • cash purchase: equipment depreciation and taxes on equipment sale
Should other tax regulations apply to your business, please set the effective tax rate to zero. By doing so, calculations of total costs will exclude taxes on equipment sale and all tax deductions. The tool will recommend then the least expensive lease-buy option before taxes. In this case we recommend though consulting with your trusted financial advisor to determine any tax impact from each lease-buy option.

Equipment depreciation tax deduction
Depreciation of the capital equipment that can be tax deducted

Depreciation is an income tax deduction that allows a business to recover the cost of tangible property such as capital equipment. It is an annual allowance for the wear and tear, deterioration, or obsolescence of the property. According to the Publication 946, How To Depreciate Property from U.S.' Internal Revenue Service (IRS), there are several depreciation methods that can be used to calculate this tax deduction including straight-line depreciation and accelerated depreciation. FinanceIsland's lease-buy tool uses the straight-line depreciation method to calculate the equipment depreciation tax deduction.

Should other tax regulations apply to your business, please set the effective tax rate to zero. By doing so, calculations of total costs will exclude taxes on equipment sale and all tax deductions. The tool will recommend then the least expensive lease-buy option before taxes. In this case we recommend though consulting with your trusted financial advisor to determine any tax impact from each lease-buy option.

Equipment price
Price of the capital equipment to be leased or purchased

Equipment sale
Expected sales price of the capital equipment

Lease payment
Sum of the annual depreciation fee and the annual lease financing fee

Lease payment tax deduction
Tax deduction on the lease payment

FinanceIsland's lease-buy tool takes into account tax deduction on the lease payment according to the guidelines on deductible business expenses from U.S.' Internal Revenue Service (IRS). Should other tax regulations apply to your business, please set the effective tax rate to zero. By doing so, calculations of total costs will exclude taxes on equipment sale and all tax deductions. The tool will recommend then the least expensive lease-buy option before taxes. In this case we recommend though consulting with your trusted financial advisor to determine any tax impact from each lease-buy option.

Loan interest tax deduction
Tax deduction on the interest portion of the loan payment

FinanceIsland's lease-buy tool takes into account tax deduction on the interest portion of the loan payment according to the guidelines on deductible business expenses from U.S.' Internal Revenue Service (IRS). Should other tax regulations apply to your business, please set the effective tax rate to zero. By doing so, calculations of total costs will exclude taxes on equipment sale and all tax deductions. The tool will recommend then the least expensive lease-buy option before taxes. In this case we recommend though consulting with your trusted financial advisor to determine any tax impact from each lease-buy option.

Loan payment
Annual loan payment

Money factor
Another representation of the interest rate in a lease

The money factor may be used by leasing companies to simplify the calculation of the monthly lease financing fee. The money factor equals annual interest rate times 100 and divided by 2400. For more details, please see definition of the monthly lease financing fee below.

Monthly depreciation fee
Part of the monthly lease payment that covers the depreciation of the equipment

The monthly lease payment consists of two components: depreciation fee and lease financing fee. The depreciation fee covers the loss of value of the equipment during the lease duration. The monthly depreciation fee is calculated as:

Formula for monthly depreciation fee

Monthly lease financing fee
Part of the monthly lease payment that covers finance charges

The monthly lease payment consists of two components: depreciation fee and lease financing fee. The lease financing fee is the finance charge to pay the leasing company for the use of its money. It corresponds to the interest payment in a loan. The monthly lease financing fee can be approximated based on the average amount to be financed and based on the monthly interest rate as described in the formula below. The leasing company may simplify the calculation by using the money factor.

Formula for monthly lease financing fee

Monthly lease payment
Sum of the monthly depreciation fee and the monthly lease financing fee

The monthly lease payment is calculated in FinanceIsland's lease-buy tool based on the approximation of the monthly depreciation fee and the monthly lease financing fee as described in their definitions above. This approximation was chosen to illustrate the two components of a lease payment: depreciation fee and lease financing fee. The true lease payment formula wouldn't distinguish these two components. Using that true formula though the resulting monthly lease payment would be slightly higher. For leases with annual interest rates under 10% and terms of 60 months or less the difference would be less than 2%.

Monthly loan payment
Monthly payment to pay off the loan

The calculation of the monthly loan payment is based on the assumption that the payment occurs at the end of the month. Should the payment occur at the beginning of the month, the monthly loan payment would be slightly lower. For typical loans with annual interest rates under 10% the difference between the monthly loan payments would be less than 1%.

NPV
Net present value = sum of discounted cash flows

Discounted cash flows are present values of cash flows, whether in- or outflows. Since the three options to acquire capital equipment, i.e., lease, financed purchase, and cash purchase, lead to varying levels of cash flows in varying time periods, NPV is the best measure to compare these options. Together with the appropriate discount rate, NPV provides one financial measure for each option, which takes into account the total cost before, during, and after the equipment use. In the case of a lease-buy analysis, where positive numbers are cash outflows, the option with the lowest NPV makes the most financial sense and should be selected to acquire the capital equipment.

FinanceIsland's lease-buy tool calculates annual cash flows first and then discounts them on an annual basis. Cash flows from down payment, security deposit, and total cash outlay are treated as cash flows in period 0 and are not discounted. Cash flows from lease or loan payments and tax deductions during the equipment use are discounted annually starting with the first year of equipment use. Cash flows after the equipment use, i.e., security deposit refund, disposition fee, and equipment sale, are discounted in the last year that includes the last month of usage duration.

NPV chart
Net present value comparison of all options based on the usage duration; option with the lowest NPV should be selected

The NPV chart shows net present values of the three lease-buy options as a function of usage duration. It allows for a quick sensitivity analysis of the usage duration to understand if shorter or longer equipment use would change the preferred acquisition option.

Projected salvage value after x months
Expected market value of the equipment at which it can be sold on the market after its use

Residual value
Remaining value of the equipment at the end of the lease that is determined by or negotiated with the leasing company

Security deposit
Security deposit that may be charged by the leasing company

The security deposit is usually fully refunded at the end of the lease if the equipment condition is within the normal wear and tear. FinanceIsland's lease-buy tool assumes a full refund of the security deposit.

Taxes on equipment sale
Taxes to be paid on the gain from the equipment sale

When selling depreciable equipment and calculating any gain to be treated as ordinary income, companies have to take into account the depreciation allowed during the equipment use. According to the Publication 544, Sales and Other Dispositions of Assets from U.S.' Internal Revenue Service (IRS), that gain is the lesser of the depreciation allowed on the equipment and the gain realized on the disposition. This gain has to be taxed accordingly. FinanceIsland's lease-buy tool uses the calculation method described in this IRS publication to determine taxes on equipment sale.

Should other tax regulations apply to your business, please set the effective tax rate to zero. By doing so, calculations of total costs will exclude taxes on equipment sale and all tax deductions. The tool will recommend then the least expensive lease-buy option before taxes. In this case we recommend though consulting with your trusted financial advisor to determine any tax impact from each lease-buy option.

Total cash outlay
Total cash paid to acquire the equipment including delivery and installation fees (equals total cost)

Total cost
Total cost consisting of the equipment price and any fees

Total financing cost
Total amount to be financed through a lease or loan after any down payments

Usage duration
Number of months the equipment will be used (in case of leasing or loan financing equals duration or term of the lease or loan)

DISCLAIMER

FinanceIsland is not a financial advisor. Our financial analysis tools provide directional guidance in many business decisions, but the ultimate decision lies with the responsible decision maker. The calculations in this tool are based on the definitions described above. Actual results may vary depending on the type of loan or lease. Although we strive to provide the tools free of error, we give you no warranty with respect to them. For more details about our tools, please review FinanceIsland's Terms of Service. In case of any doubts, we recommend consulting with your trusted financial advisor.
 
RECOMMENDED LEASING & FINANCING ARTICLES

(Don't) Look Deep Into My Lease
Some companies are enticed by low monthly payments when considering a lease. But the terms can be mesmerizing and companies get a rude awakening when leasing's real cost is revealed. The CFO Magazine addresses some of the pitfalls.

Buy vs. Lease: What You Need to Know
When does it make more sense to buy computers? When does it make more sense to lease? Small Business Computing talked to two fast-growing small businesses, one that made the buy decision, one that decided to lease, to find out.