SFM Operating Lease Liabilities Analysis
SFM Operating Lease Liabilities Analysis
Excel Transport needs a truck for which it is considering the following two options:
(i) Buy the asset for `3,00,000 by borrowing the amount @12% interest and repaying the same together with
interest in 4 equal annual instalments.
(ii) Acquiring the asset on lease with a payment of annual lease rentals for 4 years.
The firm follows straight line method of depreciation and is under the income tax bracket of 30%. Life of the asset
is 4 years.
What is the maximum amount the lessee will be willing to pay for accepting the lease?
Solution:
Refer to Illustration 1 for detail calculation.
Present value of cash flow under buy option
Particulars `
Present value of instalments (98,782 × 3.2828) 3,24,282
Less. Interest tax shield 24,258
Less. Depreciation tax shield 73,864
Total 2,26,160
So, the maximum amount the lessee will be willing to pay for accepting the lease (i.e., BELR) is `98,417.
ABC finance, a leasing company, has been approached by a prospective customer intending to acquire a machine
whose Cash Down price is `6 crores. The customer, in order to leverage his tax position, has requested a quote for a
four-year lease with rentals payable at the end of each year but in a diminishing manner such that they are in the
ratio of 4: 3: 2: 1. Depreciation can be assumed to be on straight line basis and ABC Finance‟s marginal tax rate
is 30%. The target rate of return for ABC Finance on the transaction is 10% p.a. The asset has no salvage value.
Solution:
Applicable discount rate = 10 (1-0.3) = 7.0% p.a.
or, X = 73,04,171
So, the lease rentals to be quoted are `2,92,16,684, `2,19,12,513, `1,46,08,342 and `73,04,171
So, the minimum lease rent that must be quoted by H Ltd. is `10,86,11,956.
Illustration 7
Particulars `
Present value of instalments (1,97,564 × 3.2828) 6,48,563
Less. Interest tax shield Less. 48,514
Depreciation tax shield 1,47,727
Total 4,52,322
Solution:
Present value of cash flow under buy option = `4,52,322
Present value of the after-tax lease rental
Year Lease rental After tax lease rental PVIF @ 8.4% PV of after-tax lease rental
1 X X (1-0.30) = 0.7X 0.9225 0.64575X
2 2X 2X (1-0.30) =1.4X 0.8510 1.1914X
3 3X 3X (1-0.30) =2.1X 0.7851 1.64871X
4 4X 4X (1-0.30) =2.8X 0.7242 2.02776X
Total 5.51362X
Conditionally, 5.51362X = 4,52,322
or, X = 82,037
So, the lease rental for 1st year = `82,037; for 2nd year = `1,64,074; for 3rd year = `2,46,111; for 4th year =
`3,28,148.
(d) Balloon Payment Plan – it may be similar to a stepped-up plan.
(e) Deferred Payment Plan
Refer to the previous information. Assume that the lessee requires a plan to pay nothing in the first year and
pay the rest equally in the remaining three years.
Solution:
Present value of cash flow under buy option = `4,52,322
Present value of the after-tax lease rental
Year Lease rental After tax lease rental PVIF @ 8.4% PV of after-tax lease rental
1 0 0 0.9225 0
2 X X (1-0.30) =0.7X 0.8510 0.5957X
3 X X (1-0.30) =0.7X 0.7851 0.54957X
4 X X (1-0.30) =0.7X 0.7242 0.50694X
Total 1.65221X
Conditionally, 1.65221X = 4,52,322
or, X = 2,73,768
So, from the second year onwards, the lessee is required to pay `2,73,768 per year for three consecutive years.
Additional Illustrations
1. A factory needs an equipment for use. It has the option of outright purchase or leasing the equipment. Data are
given below. Recommend the best option that the factory should choose.
Option I
Purchase outright for a cost of `80 lakhs. It is to be entirely financed by a term loan @ 18% p.a. interest on
outstanding payable on a yearly basis. The term loan to be repaid in eight equal instalments of `10 lakhs each,
beginning from second year-end. The economic life of the equipment is assessed to be ten years. The
equipment will be depreciated @ 10% p.a. on straight line basis, with insignificant salvage value at the end of the
economic life? The estimated maintenance expenses would be as detailed below:
Year 1 2 3 4 5 6 7 8 9 10
MC* 4.00 4.40 4.88 5.47 6.18 7.05 8.11 9.41 11.01 13.00
*MC = maintenance cost in ` Lakhs
Option II
The equipment may be leased for a ten-year period. The maintenance of the equipment will be done by the lessor.
The lessee has to pay `18 lakhs annual rental at the beginning of each year over the lease period.
Note - Assume that the lessee is in a tax bracket of 50% and average cost of capital of the lessee firm as 14%
p.a.
Solution:
Option I: Purchase (` in lakhs)
Comment: The present value of net cash flows is lowest for lease option; hence it is suggested to take
equipment on lease basis.
2. Fair finance, a leasing company, has been approached by a prospective customer intending to acquire a machine whose
Cash Down price is `3 crores. The customer, in order to leverage his tax position, has requested a quote for a three-
year lease with rentals payable at the end of each year but in a diminishing manner such that they
are in the ratio of 3: 2: 1. Depreciation can be assumed to be on straight line basis and Fair Finance‟s marginaltax rate
is 35%. The target rate of return for Fair Finance on the transaction is 12%.
Calculate the lease rents to be quoted for the lease for three years.
Solution:
Capital sum to be placed under Lease
Particulars ` in lakhs
Cash Down price of machine 300.00
Less: PV of depreciation tax shield [100 × 0.35 × PVIFA (12%, 3 years) = 35 × 2.4018] 84.06
215.94
If the normal annual lease rent per annum is x, then cash flow will be:
Year Post-tax cash flow P.V. of post-tax cash flow
1 3x × (1 – .35) = 1.95x 1.95 × (1/1.12) = 1.7411x
2
2 2x × (1 – .35) = 1.3x 1.30 × [(1/(1.12) ] = 1.0364x
3
3 x × (1 – .35) = 0.65x 0.65 × [1/(1.12) ] = 0.4626x
= 3.2401x
Therefore 3.2401 x = 215.94or, x =
`66.6409 lakhs
Year-wise rentals are as follows: (` in lakhs)
Year 1 3 × 66.6409 lakhs 199.9227
Year 2 2 × 66.6409 lakhs 133.2818
Year 3 1 × 66.6409 lakhs 66.6409
3, ABC Company Ltd. is faced with two options as under in respect of acquisition of an asset valued `1,00,000/-
Either
(a) to acquire the asset directly by taking a Bank Loan of `1,00,000/- repayable in 5 year-end instalments atan interest
of 15%.
OR
(b) to lease in the asset at yearly rentals of `320 per `1,000 of the asset value for 5 years payable at year [Link]
following additional information are available.
(a) The rate of depreciation of the asset is 15% W.D.V.
(b) The company has an effective tax rate of 50%.
(c) The company employs a discounting rate of 16%.
You are to indicate in your report which option is more preferable to the Company. Restrict calculation over aperiod
of ten years
The present value of one Rupee due at the end of each year is
End of
1 2 3 4 5 6 7 8 9 10
year
Present 0.86207 0.74316 0.64066 0.55229 0.47611 0.41044 0.35313 0.30503 0.26295 0.22668
Value
Solution:
ABC Company Ltd
Appraisal of Buying Decision: PV of Cash Out Flows (Fig in `)
Principal Tax savings Tax savings Net cash PV factor Present
Year Interest Outflow
repayment on dep. on int. out flow @ 16% value
1 20,000 15,000 35,000 7,500 7,500 20,000 0.86207 17,241.4
2 20,000 12,000 32,000 6,375 6,000 19,625 0.74316 14,584.5
3 20,000 9,000 29,000 5,420 4,500 19,080 0.64066 12,223.8
4 20,000 6,000 26,000 4,606 3,000 18,394 0.55229 10,158.8
5 20,000 3,000 23,000 3,915 1,500 17,585 0.47611 8,372.4
6 - - - 3,328 – (3,328) 0.41044 (1,366)
7 - - - 2,829 – (2,829) 0.35313 (999.0)
8 - - - 2,405 – (2,405) 0.30503 (733.6)
9 - - - 2,044 – (2,044) 0.26295 (537.5)
10 - - - 1,737 – (1,737) 0.22668 (393.7)
58,551.1
Net present value of outflows `58,551.1.
(b) Appraisal of Leasing Decision: Present Value of Cash outflows under Lease Alternative
Lease rent per year is 320/1,000 × 1,00,000 = `32,000
Year Lease rent (`) Tax savings (`) Net out flow (`) PVCF @ 16% Present value (`)
1-5 32,000 16,000 16,000 3.27429 52,390
PVCF = Present Value of Cashflow
From “a” and “b”, it is advised to lease, Since the net cash outflow is lower under Lease alternative.
However, it is not wise to compare the two projects with different life periods. So, consider equivalent annualcash
outflows, which is calculated as follows,
4, Elite Builders has been approached by a foreign embassy to build for it a block of six flats to be used as guest
houses. As per the terms of the contract, the foreign embassy would provide Elite Builders the plans and the land
costing `25 lakhs. Elite Builders would build the flats at their own cost and lease them to the foreign
embassy for 15 years. At the end of which the flats will be transferred to the foreign embassy for a nominal
value of `8 lakh. Elite Builders estimates the cost of constructions as follows:
Area per flat, 1,000 sq. feet; Construction cost, `400 per sq. feet; Registration and other costs, 2.5 per cent ofcost of
construction; Elite Builders will also incur `4 lakhs each in years 14 and 15 towards repairs.
5, The Sharda Beverages Ltd has taken a plant on lease, valued at `20 crore. The lease arrangement is in the form
of a leveraged lease. The Kuber Leasing Limited is the equity participant and the Hindusthan Bank Ltd. (HBL)
is the loan participant. They fund the investment in the ratio of 2:8. The loan from HBL carries a fixed rate of
interest of 19 percent, payable in 6 equated annual instalments. „The lease term is 6 years, with lease rental
payable annually in arrear.
a) Compute the equated annual instalment from the point or view - of HBL.
b) If the lease rate is unknown, and HBL‟s per-tax yield is 25 percent, what is the minimum lease rent thatmust be
quoted‟?
Solution:
Cost of the asset `20 cr
Debt Equity ratio 2: 8
Loan raised (20 × 8/10) = `16cr
Rate of interest 19%
(a) Computation of annual instalment
X × PVCF6yr, 19% = `16 cr.
X = `16 cr/3.4098
X = 4,69,23,573
So, equated annual instalment is `4,69,23,573
(b) Let the lease rent be X
Net outflow = Lease rent – Loan instalment = X – 46923573
Then,
(X – 46923573) PVCF6yr, 25% = 40000000
X = 6,04,76,463
(iii) Borrow and buy Three-year loan; Interest rate 15%; Quantum to be determined, such that annual repayment
of principal will be equal to annual lease rental payment.
(iv) Other: Tax Rate is 40%, and opportunity cost of capital is 11%.
Based on information given above, determine the preferred option as between leasing and buying.
Solution:
Appraisal of Leasing decision
Benefits of leasing (` in lakhs)
1. Saving in Investment 120.00
2. PV of tax shield on lease rentals 50.91
170.91
Net advantage of leasing = `(170.91 -182.1) lakhs = `(11.19) lakhs. Hence, it is better to purchase the asset
than to lease.
Working Notes:
7, HB Finance Ltd is considering to enter the computer leasing business. Mainframe computers can be purchased
for `2,00,000 each and, in turn, be leased out at `50,000 per year for 8 years with the initial payment occurring at
the end of first year. You may ignore taxes and depreciation.
a) Estimate the annual before tax expenses and internal rate of return (IRR) for the company.
b) What should be the yearly lease payment charged by the company in order to earn a 20 percent annual
compounded rate of return before expenses and taxes?
c) Assume that the firm uses the straight-line method of depreciation, there is no salvage value, the annual
expenses are `20,000, and the tax rate is 35%. Calculate the yearly lease payment in order to enable the firm to
earn 20 percent after tax annual compound rate of return.
d) Further, assume that computer has a resale value of `40,000. Determine the revised lease rental to enable
the firm to earn 20 per cent.
Solution:
(a) Cost of the Asset ` 2,00,000
Life 8 years
Lease rent ` 50,000 p.a.
(50,000) PVCF8yr, IRR = `2,00,000
PVCF8yr, IRR = 4
IRR = 18.63%
(b) Calculation of yearly lease rent to be charged to earn 20% returnLet the
yearly lease rent be X
So, X × PVCF8yr, 20% = 200000
or, X = 200000 / 3.8372
or, X = `52120
(c) Let X be the yearly lease rent Computation of cash
inflows per annumLease rent X
(-) annual expenses 20,000
(-) Depreciation 25,000
PBT X - 45,000
PAT @ (1-35%) 0.65X – 29,250
CIAT 0.65X – 4,250
Cash inflows after tax
Present value for 8years @ 20% = (0.65X – 4250) × 3.8372 = 2,00,000
Yearly lease rent X = `86,725
(d) Present value of cash outflows
Cost of computer 2,00,000
Present value of recurring cash inflows
Lease rent X
(-) annual expenses 20,000
(-) Depreciation 20,000
PBT X – 40,000
PAT @ (1-35%) 0.65X - 26,000
CIAT 0.65X- 6000
Present value for 8years @ 20% = (0.65X-6,000) × 3.872
Present value of terminal cash inflows:
Resale value = `40,000
Its present value (40,000 × 0.23257)= `9,303
At 20%,
Inflows = Outflows
(0.65x – 6,000) × 3.8372 + 9303 = 2,00,000;
Revised lease rent, X = `85,687.
8, Beta Ltd is considering the acquisition of a personal computer costing `50,000. The effective life of the
computer is expected to be five years. The company plans to acquire the same either by borrowing `50,000 from
its bankers at 15% interest p.a. or on lease. The company wishes to know the lease rentals to be paid
annually, which match the loan option. The following further information is provided to you:
a) The principal amount of loan will be paid in five annual equal instalments.
b) Interest, lease rentals, principal repayment are to be paid on the last day of each year.
c) The full cost of the computer will be written off over the effective life of computer on a straight-line basis
and the same will be allowed for tax purposes
d) The company‟s effective tax rate is 40% and the after-tax cost of capital is 9%
e) The computer will be sold for `1,700 at the end of the 5th Year. The commission on such sales is 9% on
the sale value.
You are required to compute the annual lease rentals payable by Beta Ltd, which will result in indifference to
the loan option.
Solution:
Computation of Net Cash outflow if the Asset is Purchased by Borrowing
Principal Tax Tax Net cash
Interest Installment PV @ Present
Year repayment savings on savings on outflow
(`) (`) 9% value (`)
(`) interest (`) dep (`) (`)
1 10,000 7,500 17,500 3,000 4,000 10,500 0.91743 9,633
2 10,000 6,000 16,000 2,400 4,000 9,600 0.84168 8,080
3 10,000 4,500 14,500 1,800 4,000 8,700 0.77218 6,718
4 10,000 3,000 13,000 1,200 4,000 7,800 0.70843 5,526
5 10,000 1,500 11,500 600 4,000 6,900 0.64993 4,485
Present Value of Total outflow of cash `34,442
Less: Present value of terminal cash inflows:
Sale value of asset ` 1,700
(-) Commission ` 153 ` 1,547
(-) Tax on profit @ 40% ` 619
` 928
Its Present value ` (928 × 0.64993) ` 603
Net cash outflow = 34,442 – 603 = `33,839
Since we are required to find the annual lease rental payable, which will result in indifference to loan [Link]
present value of net cash outflow will be the same in each case.
Computation of break-even lease rent:
Lease rent `X
(-) Tax saving (X @ 40%) ` 0.4X
Lease rent after tax per year ` 0.6X
Present value of lease rental for five years = (0.6X) × (3.8896) = 33,839
or, X = `14,500.
So, the required annual lease rental is `14,500.
9, ABC leasing Ltd. is in the process of making out a proposal to lease certain equipment. The cost of the
equipment is `10,00,000 and the period of lease is 10 years. The following additional information is available. You are
required to determine the equated annual rent to be charged for the proposal.
a) The ma chine can be depreciated fully over the 10 years on straight-line basis
b) The current effective tax rate is 40% and expects to go down to 30% from the beginning of the 6 th year
of the lease.
c) It is the normal objective to make a 10% post-tax return in its lease pricing
d) Lease management fee of 1% of the value of the assets is usually collected from the lessees upon signingof the
contract of lease, to cover the overhead costs related to processing of the proposal.
e) Annual lease rents are collected at the beginning of every year.
Solution:
Present value of cash outflow:
Cost of equipment `10,00,000
Let X be the equated annual lease rent
Present value of lease rentals after tax (Figures in `)
Year Lease rent Tax Net cash inflows PV @ 10% Present value
0 X - X 1.0000 X
1-5 X 0.4X 0.6X 3.7908 2.2745X
6-9 X 0.3X 0.7X 1.9680 1.3776X
10 0 0.3X (0.3X) 0.3855 (0.1158X)
The company estimates that the computer under review will be worth `10 lakhs at the end of third year.
Forecast Revenues are:
Year 1 2 3
Amount (` in lakhs) 22.5 25 27.5
Annual operating costs excluding depreciation/lease rent of computer are estimated at `9 lakhs with an additional
`1 lakh for start-up and training costs at the beginning of the first year. These costs are to be borne by the lessee. Your
company will borrow at 16% interest to finance the acquisition of the computer. Repayments
are to be made according to the following schedule:
Year end 1 2 3
Principal (` in ‟000) 500 850 850
Interest (` in ‟000) 352 272 136
The company uses straight line method (SLM) to depreciate its assets and pays 50% tax on its income. The
management approaches you to advice. Which alternative would be recommended and why?
Note: The PV factor at 8% and 16% rates of discount are:
Year 1 2 3
8% 0.926 0.857 0.794
16% 0.862 0.743 0.641
Solution:
Working Notes:0
a) Depreciation: ` (22,00,000 – 10,00,000)/3 = ` 4,00,000 p.a.
b) Effective rate of interest after tax shield: 0.16 × (1 - 0.50) = 0.08 or 8%.
c) Operating and training costs are common in both alternatives hence not considered while calculating NPV
of cash flows.
Calculation of NPV
1, Alternative I: Purchase of Computer