leasing solution ca-final sfm (full)

32
PRAVINN MAHAJAN 9871255244, 8800684854 1 LEASING Q1 Sunderam ltd.Is contemplating to acquire machine worth Rs 10,00,000. Company has 2 options 1 To lease the asset at annual lease rentals of Rs 3,34,000 for 5 years. 2 To take a Bank loan @ 15% p.a repayable in 5 yearly installments of Rs 2,00,000 + Interest . Tax rate 35% Discount rate 16% Depreciation 15% WDV Option 1 Taking the asset on lease. Lease rent p.a Rs 3,34,000 Tax savings on Lease Rent 3,34,000 (0.35) Rs 1,16,900 Statement of Present Value of Cash Outflow Amount Period Factor Present @ 16% Value Lease Rent 3,34,000 1-5 3.274 10,93,516 Tax saving 1,16,900 1-5 3.274 (3,82,731) Net cash outlow 7,10,785 Option 2 Purchasing the asset by obtaining loan from bank Loan of Rs 10,00,000 @ 15% Annual installment Rs 2,00,000 + interest Depreciation 15% p.a WDV basis Statement of cash outflow 1 2 3 4 5 Payment of Principal 2,00,000 2,00,000 2,00,000 2,00,000 2,00,000 Interest @ 15% 1,50,000 1,20,000 90,000 60,000 30,000 Tax savings on interest 52,500 42,000 31,500 21,000 10,500 Depriciation 1,50,000 1,27,500 1,08,375 92,119 78,301 Book value after 5 years 4,43,705 Tax savings on Depreciation 52500 44625 37,931 32,242 27,405 Salvage value nil

Upload: pravinnmahajan

Post on 18-Apr-2015

180 views

Category:

Documents


20 download

DESCRIPTION

LEASING

TRANSCRIPT

Page 1: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

1

LEASING

Q1 Sunderam ltd.Is contemplating to acquire machine worth Rs 10,00,000. Company has 2 options

1 To lease the asset at annual lease rentals of Rs 3,34,000 for 5 years.

2 To take a Bank loan @ 15% p.a repayable in 5 yearly installments of Rs 2,00,000 + Interest

.

Tax rate 35%

Discount rate 16%

Depreciation 15% WDV

Option 1 Taking the asset on lease.

Lease rent p.a Rs 3,34,000

Tax savings on Lease Rent

3,34,000 (0.35) Rs 1,16,900

Statement of Present Value of Cash Outflow

Amount Period Factor Present

@ 16% Value

Lease Rent 3,34,000 1-5 3.274 10,93,516

Tax saving 1,16,900 1-5 3.274 (3,82,731)

Net cash outlow 7,10,785

Option 2 Purchasing the asset by obtaining loan from bank

Loan of Rs 10,00,000 @ 15%

Annual installment Rs 2,00,000 + interest

Depreciation 15% p.a WDV basis

Statement of cash outflow

1 2 3 4 5

Payment of Principal 2,00,000 2,00,000 2,00,000 2,00,000 2,00,000

Interest @ 15% 1,50,000 1,20,000 90,000 60,000 30,000

Tax savings on interest 52,500 42,000 31,500 21,000 10,500

Depriciation 1,50,000 1,27,500 1,08,375 92,119 78,301

Book value after 5 years 4,43,705

Tax savings on Depreciation 52500 44625 37,931 32,242 27,405

Salvage value nil

Page 2: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

2

Statement of Present value on cash outflows

Amount Period Factor@16% Present value

Principal 2,00,000 1-5 3.274 6,54,800

Interest 1,50,000 1end 0.862 1,29,300

1,20,000 2end 0.743 89,160

90,000 3end 0.641 57,690

60,000 4end 0.552 33,120

30,000 5end 0.476 14,280

Tax savings on Intt 52,500 1end 0.862 (45,255)

42,000 2end 0.743 (31,206)

31,500 3end 0.641 (20,192)

21,000 4end 0.552 (11,592)

10,500 5end 0.476 (4998)

Tax savings on Dep 52500 1end 0.862 (45,255)

44,625 2end 0.743 (33,156)

37,931 3end 0.641 (24,314)

32,242 4end 0.552 (17,798)

27,405 5end 0.476 (13,045)

Salvage value

Scrap value nil

Tax savings on

cap loss

(0 – 4,43,705)x 0.35 1,55,297 5end 0.476 (73,921)

Present value of cash outflow 6,57,619

Present value of cash outflow is lower in case of loan option, So loan option is better

Page 3: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

3

Q2 Agrani Ltd needs Computer costing Rs 5,00,000. Company has 2 options

Option 1 To acquire the computer on lease at annual lease rent of Rs 1,25,000 payable at

Beginning of each year

Annual lease rent Rs 1,25,000

Tax savings on Lease rent

(1,25,000 x 0.4) Rs 50,000

Statement of present value of cash outflow in case of Lease option

Amount Period Factor Present value

@10%

Lease Rent 1,25,000 0 1 1,25,000

1,25,000 1-4beg 3.170 3,96,250

Tax savings on

lease rent 50,000 1-5end 3.791 (1,89,550)

Present value of Cash outflow 3,31,700

Option 2 To Purchase computer by borrowing from bank @ 12%

Loan from Bank Rs 5,00,000 @ 12% , principal repayable as 30%, 25%, 20%,

15%, and 10% along with Interest

Statement of Principal and Interest

Principal p.a Interest Tax saving on

Interest @ 40%

1end 1,50,000 (30%) 60,000 24,000

2end 1,25,000 (25%) 42,000 16,800

3end 1,00,000 (20%) 27,000 10,800

4end 75,000 (15%) 15,000 6,000

5end 50,000 (10%) 6,000 2400

Installment of loan and interest is payable to bank at the end of each year

Depreciation p.a on SLM basis 5,00,000 x 0.2 1,00,000

Tax saving on depreciation 1,00,000 x 0.4 40,000

Page 4: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

4

Statement of Present value of cash outflow if asset is purchased

Particulars Amount Period Factor@ 10% Present

Value

Installment

(Principal +

Interest) 2,10,000 1end 0.909 1,90,890

1,67,000 2end 0.826 1,37,942

1,27,000 3end 0.751 95,377

90,000 4end 0.683 61,470

56,000 5end 0621 34,776

Tax savings on 24,000 1end 0.909 (21,816)

Interest 16,800 2end 0.826 (13,877)

10,800 3end 0.751 (8,111)

6,000 4end 0.683 (4098)

2,400 5end 0.621 (1,490)

Tax savings on

Depreciation 40,000 1-5end 3.791 (1,51,640)

Net cash outflow 3,19,423

It is better to purchase the asset by borrowing from ban, as cash outflow in loan option is lower

than cash outflow in lease option

Q3 ABC company decided to acquire Pulp control device for Rs 5,00,000, Company has 2 options

Option1 To acquire the asset on lease by paying annual lease rent of Rs 55,000 at

beginning of each year.

Lease rent p.a Rs 55,000 payable aty beginning of each year

Tax saving on lease rent 55,000 (1-0.5) = Rs 27,500

Discount rate is rate of Interest charge by bank after tax 10% ( 1 – 0.50) = 5%

Statement of Present value of cash outflow if asset is taken on lease

Amount Period Factor @ 5% Present

Value

Lease Rent 55,000 0 1 55,000

55,000 1-9 7.108 3,90,940

Tax saving on

lease rent 27,500 1-10 7.722 (2,12,355)

Present value of Cash out flow 2,33,585

Page 5: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

5

Option 2 Purchase the Asset by borrowing from bank

Cost of Asset 5,00,000

Less Subsidy 50,000

Borrowing from bank 4,50,000

Loan of Rs 4,50,000 payable in 10 equal installments at the beginning of each year

Amount of each installment

Amount x factor = loan

Amount x 6.759 = 4,50,000

Amount = 66,578

Statement of Principal and Interest

Year Installment Interest Principal Principal outstanding

@ 10%

1beg 66,578 nil 66,578 450,000 – 66,578

= 3,83,422

2beg 66,578 38,342 28,236 3,83,422 – 28,236

= 355186

3beg 66,578 35,519 31,059 3,55,186 - 31,059

= 3,24,127

4beg 66,578 32,413 34,165 3,24,127 – 34,165

= 2,89,962

5beg 66,578 28,996 37,582 2,89,962 – 37,582

= 2,52,380

6beg 66,578 25,238 41,340 2,52,380 – 41,340

= 2,11,040

7beg 66,578 21,104 45,474 2,11,040 – 45474

= 1,65,566

8beg 66,578 16,557 50,021 1,65,566 – 50,021

= 1,15,545

9beg 66578 11,555 55,023 1,15,545 – 55,023

= 60,522

10beg 66,578 6,056 60,522 -

Depreciation on actual cost @ 10% p.a = 5,00,000 ÷ 10 = 50,000

Tax saving on depreciation = 50,000 x 0.50 = 25,000

Factor = 1÷ 1.10 =

= 9 times

GT

+1

Page 6: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

6

Statement of present value of cash outflow if asset is purchased

Particulars Amount Period factor Present value

@ 5%

Installment 66,578 0 1 66,578

66578 1-9 7.108 4,73,236

Tax saving on

Interest 38,342 x 0.5

= 19,171 1e 0.952 (18,251)

35,519 x 0.5

= 17,760 2e 0.907 (16,108)

32,413x0.5

= 16,207 3e 0.864 (14,003)

28,996x 0.5

= 14,498 4e 0.823 (11,932)

25,238x0.5

= 12,619 5e 0.784 (9,893)

21,104x0.5

= 10,552 6e 0.746 (7,872)

16,557x0.5

= 8,279 7e 0.711 (5,886)

11,555x0.5

= 5,778 8e 0.677 (3,912)

6,056x0.5

= 3027 9e 0.645 (1,952)

Tax saving

On depreciation 25,000 1-10e 7.722 (1,93,050)

Present value of cash outflow 2,56,955

It is better to take asset on lease as cash outflow in lease option is lower than cash outflow in

loan option.

Page 7: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

7

Q4 Company is planning to acquire a machine costing Rs 5,00,000. Company has two options

Option 1 To acquire the asset by taking a loan from Bank

Amount of Loan = Rs 5,00,000 @ 10%p.a

Statement of Principal and Interest

Year Principal Interest Tax savings on interest @ 30%

1 1,00,000 5,00,000 x 0.1 = 50,000 15,000

2 1,00,000 4,00,000 x 0.1 = 40,000 12,000

3 1,00,000 3,00,000 x 0.1 = 30,000 9,000

4 1,00,000 2,00,000 x 0.1 = 20,000 6,000

5 1,00,000 1,00,000 x 0.1 = 10,000 3,000

Depreciation - Machine will be fully depreciated during its lifetime

Depreciation p.a = 5,00,000 ÷ 5 = 1,00,000

Salvage value = Rs 50,000

Capital gain = Salvage value - Book value after life

= 50,000 – nil

= 50,000

Tax on capital gain = 50,000 x 0,3 = 15,000

Salvage value after Tax = 50,000 – 15,000 = 35,000

Statement of Present Value of cash outflow

Particulars Amount Period Factor Present

@ 8% Value

Principal 1,00,000 1-5end 3.993 3,99,300

Interest 50,000 1end 0.926 46,300

40,000 2end 0.857 34,280

30,000 3end 0.794 23,820

20,000 4end 0.735 14,700

10,000 5end 0.681 6810

Tax savings 15,000 1end 0.926 (13,890)

On Interest 12,000 2end 0.857 (10,284)

9,000 3end 0.794 (7146)

6,000 4end 0.735 (4,410)

3,000 5end 0.681 (2,043)

Tax savings

On Depreciation

(50,000 x 0.3) 1,00,000 1-5end 3.993 (1,19,790)

Salvage value 35,000 5end 0.681 (23,835)

Present value of cash outflow 3,43,812

Page 8: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

8

Option 2 To acquire asset on lease

Company will be indifferent between loan option and lease option if Present value of cash

outflow in lease option is equal to present value of cash outflow in loan option

Present value of Cash outflow of lease option required = 3,43,812

Statement of Present value of cash outflow

Amount Period Factor Present value

@ 8%

Lease Rent x 1-5end 3.993 3.993x

Tax savings on

lease rent 0.3x 1-5end 3,993 (1.1979x)

Present value of cash outflow 3,43,812

3.993x - 1.1979x = 3,43,812

2.7951x = 3,43,812

x = 1,23,005

Lease rent p.a to make company indifferent between loan option and lease option is

Rs 1,23,005

Q5 Agrani ltd needs a machine costing Rs 40,00,000. Company has 2 options

Option 1 Acquire the Machine on Lease at an annual lease rent of Rs12,00,000

Lease Rent p.a Rs 12,00,000

Tax saving on lease rent 12,00,000 x 0.35 = 4,20,000

Statement of Present value of cash outflows

(if Asset is taken on lease)

Amount Period Factor Present value

@ 16%

Lease Rent 12,00,000 1 – 5 end 3.274 39,28,800

Tax Savings on

lease rent 4,20,000 1 – 5 end 3.274 13,75,080

Present Value of Cash outflow 25,53,720

Page 9: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

9

Option 2 Purchase the asset by borrowing from bank

Amount of Loan = Rs 40,00,000 @ 20%

Loan is payable in 5 equal Installments. Amount of each installment is :

Amount x factor (5 yrs, 20%*) = 40,00,000

Amount x 2.991 = 40,00,000

Amount = 13,37,345

Statement of Principal and Interest

Year Installment Interest Principal Principal Tax saving

@ 20% Outstanding on intt @ 35%

1end 13,37,345 8,00,000 5,37,345 34,62,655 2,80,000

2end 13,37,345 6,92,531 6,44,814 28,17,841 2,42,386

3end 13,37,345 5,63,568 7,73,777 20,44,064 1,97,249

4end 13,37,345 4,08,813 9,28,532 11,15,532 1,43,085

5end 13,37,345 2,21,813 11,15,532 - 77,635 (13,37,345 – 11,15,532)

Depreciation @ 25% p.a WDV basis

Tax saving on dep @ 35%

Cost 40,00,000

Dep 1 year 10,00,000 3,50,000

30,00,000

Dep 2nd

yr 7,50,000 2,62,500

22,50,000

Dep 3rd

yr 5,62,500 1,96,875

16,87,500

Dep 4th yr 4,21,875 1,47,656

12,65,625

Dep 5th yr 3,16,406 1,10,742

WDV after 5 years 9,49,219

Salvage value after 5 yrs 8,00,000

Capital loss 1,49,219

Tax savings on cap loss 52,226 (1,49,219 x 0.35)

Net salvage value 8,00,000 + 52,226 = 8,52,226

Page 10: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

10

Statement of Present value of cash outflow if Loan is taken from Bank

Amount Period factor Present

@ 16% value

Installment (Principal

+ interest) 13,37,345 1 – 5 end 3.274 43,78,468

Tax savings on

Interest and dep 6,30,000 1e 0.862 (5,43,060)

(2,80,000 + 3,50,000)

504,886 2e 0.743 (3,75,130)

(2,42,386 + 2,62,500)

3,94,124 3e (0.641) (2,52,633)

2,90,741 4e (0.552) (1,60,490)

1,88,377 5e (0.476) (89,667)

Salvage value 8,52,226 5e (0.476) (4,05,660)

25,51,828

Present value of Cash ouflow in loan option is lower than present value of cash outflow in lease

option, so company should purchase the asset by borrowing from Bank

b. Evaluation of Proposal from the point of view of lessor, If lessor’s cost of capital is 14%

Lessor will receive Lease rent and pay tax on such lease rent

Lessor will claim depreciation on asset and tax saving on such depreciation and will claim

salvage value

Cash outflow will be purchase price of machine.

Statement of NPV of Lessor @ 14%

Amount Period factor Present

@ 14% value

Present value of cash inflows

Lease rent (net of tax)

12,00,000 (1 – 0.35) 7,80,000 1 – 5e 3.433 26,77,740

Tax savings on Depreciation 3,50,000 1e 0.877 3,06,950

2,62,500 2e 0.769 2,01,863

1,96,875 3e 0.675 1,32,891

1,47,656 4e 0.592 87,412

1,10,742 5e 0.519 57,475

Salvage value 8,52,226 5e 0.519 4,42,305

Cash Inflows 39,06,636

Present value of cash outflows

Purchase price of machine 40,00,000 0 1 40,00,000

NPV (93,364)

Since NPV of lease is negative, so lessor should not lease the Asset

Page 11: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

11

Q6 Company is considering to buy personal computer with modem and printer costing Rs 60,000.

Company has 2 options.

Option 1 To purchase the asset by borrowing from bank @ 12% p.a. Principal is to be

repaid in 5 equal investments

Statement of Principal and Interest

Year Principal Interest Tax saving on Interest

1 12,000 7,200 2,160

2 12,000 5760 1,728

3 12,000 4320 1,296

4 12,000 2,880 864

5 12,000 1,440 432

Statement of Depreciation on Asset

Full cost of the Asset is to be depreciated during the life

Depreciation p.a = 12,000

Tax savings on depreciation = 12,000 x 0.3 = 3,600

Statement of present value of cash outflows if asset is purchased

Particulars Amount Period P.V factor Present

@ 11% value

Principal Payment 12,000 1 – 5 end 3.696 44,352

Interest (net of

Tax saving

7,200 - 2,160 5,040 1e 0.901 4,541.04

4,032 2e 0.812 3,273.98

4,320 – 1,296 3,024 3e 0.731 2,210.54

2,016 4e 0.659 1,328.54

1,008 5e 0.593 597.74

Tax savings

On depreciation 3,600 1 – 5 3.696 (13,305.6)

Salvage value net of

tax on cap gain

(1500 – 120) –

0.3(1500 - 120) 966 5e 0.593 (572.84)

Present value of cash outflows 42,425.40

Computation of Annual Lease rentals

Present value of Annual lease rentals Rs 42,425.40

Lease rent p.a x 3.696 3.696x

Tax savings 0.3x 3.696 1.1088x

Present value of cash outflow 2.5872 x

2.5872x = 42,425.40

x = 16,398.19

Page 12: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

12

Q7 Jags Ltd is contemplating to acquire a new truck. Company has two options

Option 1 To acquire the asset on lease on annual lease rent of Rs 1,20,000 p.a to be paid

at beginning at of each year

Discount rate is rate of Interest charged by bank after tax 10% (1 – 0.4) = 6%

Statement of present value of cash outflows if asset is taken on lease

Particulars Amount Period Factor Present

@ 6% value

Lease Rent 1,20,000 0 1 1,20,000

1,20,000 1 – 3 2.673 3,20,760

Tax saving on

lease rent 48,000 1 – 4e 3.465 (1,66,320)

Present value of cash outflows 2,74,440

Maintenance cost is not considered as it is incurred in lease and purchase option

Option 2 To purchase the asset for Rs 4,80,000 by borrowing from bank @ 10%

Loan is to be paid in 4 equal installments. Amount of each installment is

Amount x factor @ 10% = 4,80,000

Amount x 3.170 = 4,80,000

Amount = 1,51,420

Statement of Principal and Interest

Year Installment Interest Principal Principal tax

outstanding saving @40%

1 1,51,420 48,000 1,03,420 3,76,580 19,200

2 1,51,420 37,658 1,13,762 2,62,818 15,063

3 1,51,420 26,282 1,25,138 1,37,500 10,513

4 1,51,420 13,920 1,37,500 - 5,568

Statement of depreciation

Year Depreciation Tax saving on Depreciation

1 33% 1,58,400 63,360

2 45% 2,16,000 86,400

3 15% 72,000 28,800

4 7% 33,600 13,440

Page 13: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

13

Statement of Present value of cash outflow if asset is purchased

Particulars Amount period factor Present

@ 6% value

Installment 1,51,420 1 – 4e 3.465 5,24,670

Tax saving on

Interest & depreciation 82,560 1e 0.943 (77,854)

1,01,463 2e 0.890 (92,302)

39,313 3e 0.840 (33,023)

19,008 4e 0.792 (15,054)

Salvage value

1,20,000 –

0.4 x 1,20,000 72,000 4e 0.792 (57,024)

Present value of cash outflows 2,49,413

Maintenance cost is not considered as it is incurred in lease and purchase option

Since present value of cash outflow is lower in case of loan option so company should purchase

the asset by borrowing from bank

Q8 Highlighted line is missing in question in assignment

Zapak Ltd is faced with the decision to purchase or acquire on lease a mini car. The cost of mini

car is Rs 1,26,965. It has a life of 5 years. The mini car can be obtained on lease by paying equal

lease rentals annually. The leasing company desires a return of 10% on the gross value of the

asset. Company can also obtain 100% finance from its regular banking channel. The rate of

interest will be 15% p.a and the loan will be paid in 5 equal annual installments, inclusive of

interest. The effective tax rate of company is 40%. For the purpose of taxation it is to be assumed

that the asset will be written of over a period of 5 years on a straight line basis.

Lease rents are paid at beginning of each year

Advise the company about the method of acquiring the car.

What should be the annual lease rental to be charged by the leasing company to match

the loan option (M96)

Sol Zapak Ltd is considering to purchase a Mini car costing Rs 1,26,965. Company has two options

Option 1 to acquire the asset on lease, by paying equal annual lease rent for 5 years

At beginning of each year

Amount of Lease rent p.a shall be the amount which yields 10% return for Lessor. Thus from

point of view of lessor Present value all cash inflows should be equal to cost of assets.

Page 14: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

14

Statement of present value of cash inflow from point of view of lessor

Particulars Amount Period factor Present

Lease rent x 0 1 x

x 1-4 3.170 3.170x

Tax on lease rent 0.4x 1 – 5 3.791 (1.5164x)

Tax saving on

Depreciation 10,157 1 – 5 3.791 38,505

( )0.4

Present value of all cash inflows 1,26,965

4.170x – 1.5164x + 38,505 = 1,26,965

2.6536x = 88,460

x = 33,335

Statement of present value of cash outflow if asset is acquired on lease (point of view of lessee)

Particulars Amount Period factor Present

@ 9% Value

Lease rent 33,335 0 1 33,335

33,335 1-4 3.240 1,08,005

Tax saving on

Lease rent 13,334 1 – 5e 3.890 (51,869)

Present value of Cash outflow 89,741

Option 2 To purchase the asset by borrowing from bank Rs 1,26,965 @ 15% to be paid in 5 equal

installments (it is assumed that installments of loan are payable at end of each year)

Amount of each installment should be such that present value of all installments @ 15%

is equal to cost of the asset.

Amount x factor @ 15% = 1,26,965

Amount x 3.352 = 1,26,965

Amount = 37,877

Statement of Principal and interest

Year installment interest Principal Principal o/s tax saving on

interest

1 37,877 19,045 18,832 1,08,133 7618

2 37,877 16,220 21,657 86,476 6488

3 37,877 12,971 24,906 61,570 5188

4 37,877 9236 28,641 32,929 3694

5 37,877 4948 32,929 - 1979

Page 15: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

15

Statement of present value of cash outflow

Amount Period factor@ 9% Present value

Installment 37,877 1 – 5 3.890 1,47,342

Tax saving on intt 7618 1e 0.917 (6986)

6488 2e 0.842 (5463)

5188 3e 0.772 (4005)

3694 4e 0.708 (2615)

1979 5e 0.650 (1286)

Tax saving on depn 10,157 1 – 5 3.890 (39,511)

Present value of cash outflow 87,476

Since present value of cash outflow in case of purchase option is lower than present value of

cash outflow in case of lease option, so company should purchase the asset.

b. Annual lease rent if lease option is to be matched with loan option

Present value of cash outflow in lease option = Present value of cash outflow in loan

option

4.240 x – 3.890 (0.4x) = 87,746

4.240 x - 1.556 x = 87,746

2.684 x = 87,746

x = 32,692

if annual lease rent is Rs 32,692, company will be indifferent between loan option and lease

option

Q9a. i. flying hours required to make renting aircraft viable option will be the hours in which

Present value of contribution from the flying hours during the life of aircraft is equal to

present value of cash outflow during the life of aircraft

Statement of Net present value of cash inflow if rented

Amount period factor(10%) Present value

Cash inflows

Annual contribution

(if annual flying hrs is x)

(Contribution per hr – VC / hr) no of

hrs p.a

( – 36,100) x 30,567x 1 – 5 3.791 1,15,879x

Cash outflows

Fixed costs (Rent) 2,50,00,000 0 1 2,50,00,000

2,50,00,000 1-4 3.17 792,50,000

Net present value of cash inflow 0

No of flying hours to make renting viable option is

1,15,879x - 1042,50,000 = 0

x =

x = 900 hours

Page 16: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

16

ii. flying hours required to make buying aircraft viable option will be the hours in which

Present value of contribution from the flying hours during the life of aircraft is equal to

present value of cash outflow during the life of aircraft

Statement of Present value of cash inflow if purchased

Amount Period factor (10%) Present value

Cash inflows

Annual contribution 66,667x 1 – 5 3.791 2,52,735x

Cash outflows

Cost of Aircraft 20,00,00,000 0 1 20,00,00,000

Overhaul cost 6,00,00,000 3e 0.751 4,50,60,000

Annual fixed operating cost 1,00,00,000 1 – 5 3.791 3,79,10,000

Net present value of cash inflows 0

No of flying hours to make renting viable option is

2,52,735x - 2829,70,000 = 0

x =

x = 1120 hours per year

b. Company will be indifferent between buying and renting, NPV of renting an aircraft is equal to

NPV of Renting an aircraft

NPV of renting = NPV of Buying an aircraft

115879x - 1042,50,000 = 252735x - 2829,70,000

2829,70,000 – 1042,50,000 = 252735x – 115879x

x = 1306 hours

if annual flying hrs are

0 – 900 = it is not viable to acquire a plane either by renting or buying

.> 900 < 1306 = it is better to rent the plane

1306 = either rent or buy

> 1306 = Buy the aircraft

c. if purchased, each aircraft flies for 2,400 hours per year

To make 5,750 flying hours per year, company will purchased 2 planes which will fly for 4,800 hrs

p.a and for balance 950 hours (5,750 – 4800), it will be better to rent an aircraft (as for flying

hours between 900 to 1306 buying an aircraft is not a viable option)

Q10 Armada company is a leasing company and is considering to lease a school bus at an annual

lease rent of 1,25,000 p.a for 8 years. Cost of bus is Rs 5,00,000

a. IRR is the rate at which present value of cash inflow is equal to present value of cash outflow

i.e PV of cash inflow = 5,00,000

Present value of cash inflows @ 15%(Random) = 1,25,000 x 4.487 = Rs 5,60,875

Present value of cash inflows @ 20% = 1,25,000 x 3.837 = Rs 4,79,625

IRR = 15 + x 5

= 18.746%

At 15% ……. 5,60,875

At ? ………5,00,000

At 20% ……. 4,79,625

For diff in PV of 81,250, diff in rate is

5%. For diff in PV of 60,875, diff in

rate is

x 5 + 15

Page 17: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

17

b. Company will earn 20% return p.a on its investment if Present value of annual lease rent for 8

years is equal to cost of asset

Annual lease rent x facto @ 20% = Cost of asset

Lease rent x 3.837 = 5,00,000

Annual lease rent = Rs 1,30,310 p.a

C Company will earn 20% return p.a on its investment if Present value of annual cash inflows

for 8 years is equal to cost of asset

Statement of Net present value of cash inflows (of lessor)

Amount Period factor @ 20% Present value

Lease rent x 1 – 8 e 3.837 3.837x

Tax on lease rent 0.4x 1 – 8 e 3.837 (1.5348x)

Annual expenses

After tax savings 50,000(1 – 0.4) 1 - 8e 3.837 (1,15,110)

Ta savings on

Depreciation 20,000 1 – 8e 3.837 76,740

0.4( )

Salvage value 1,00,000 8e 0.233 23,300

Present value of cash inflow 5,00,000

Annual lease rent to earn 20% rate of return

2.3022x - 15,070 = 5,00,000

X =

Annual lease rent = 2,23,730

Page 18: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

18

Q11 Elite Builders will build 6 flats and lease them to foreign embassy for 15 years. Foreign embassy

will provide land to Elite builders, costing Rs 25 lakhs

i. Lease rent per annum for lessor to earn minimum desired return of 10% (if rentals and

repairs will arise on the last day of the year and construction , registration and other costs

are to be incurred at time 0) Lessor will earn 10% if present value of cash inflows (lease rent) – Present value of cash

outflow = 0

Or present value of cash inflows (lease rent) = Present value of cash outflow

Statement of Net present value of cash inflows

Cash inflows

Lease rent x (1 – 0.5) = 0.5x 1 – 5e 3.791 1.8955x

(after tax) 1.20(1 – 0.5) = 0.60x 6 – 10e 3.791 x 0.621 1.4125x

1.50(1 – 0.5) = 0.75x 11 – 15e 3.791 x 0.386 1.09749x

Cash outflows

Construction cost

+ registration cost

(6 x 1000 x 400)

+ 2.5% of 24lacs 24,60,000 0 1 (24,60,000)

Repairs (net of tax)

4,00,000 ( 1 -0.5) 2,00,000 14e 0.263 (52,600)

2,00,000 15e 0.239 (47,800)

Tax saving on depn

x 0.50 82,000 1 – 15 7.606 6,23,692

Salvage value

(8,00,000 – 0.5 x 8 lac) 4,00,000 15e 0.239 95,600

Net present value 0

Normal lease rent is

4.40549 x - 18,41,108 = 0

x =

normal rent = 4,17,912 for 6 flats

= = Rs 69,652

Page 19: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

19

Q12 ABC Ltd is contemplating to acquire computer. Company has two options

Option 1 To Acquire computer at annual lease rent of Rs 85,000 + 5% of annual billings

Annual lease rent

Year 1 85,000 + 5% x 2,20,000 = 96,000

Year 2 85,000 + 5% x 2,60,000 = 98,000

Year 3 85,000 + 5% x 2,60,000 = 98,000

Statement of Present value of cash outflow

Lease rent

(after tax) 96,000(1 – 0.5)= 48,000 1e 0.893 42,864

98,000( 1 – 0.5)= 49,000 2e 0.797 39,053

98,000( 1 – 0.5)= 49,000 3e 0.712 34,888

Present value of cash outflow 1,16,805

Option 2 To purchase the computer by borrowing Rs 2,30,000 from bank @ 16% p.a

Statement of Present value of cash outflow

Repayment of loan

(interest after tax p.a

+ principal in 3rd

year) 36,800(1 – 0.5)

18,400 1e 0.893 16,431

18,400 2e 0.797 14,665

2,30,000 + 18,400 3e 0.712 1,76,861

Maintenance, taxes

Insurance (after tax) 20,000( 1 – 0.5) 1 – 3e 2.402 24,020

Tax savings on depreciation

( )x 0.5 20,000 1 – 3e 2.402 (48,040)

Salvage value 1,10,000 3e 0.712 (78,320)

Present value of cash outflow 1,05,617

Annual operating expenses of Rs 80,000 is ignored, as it is to be incurred in both lease

and purchase option

Since Present value of cash outflow is lower in case of purchase option, So company should

purchase the computer

Page 20: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

20

Evaluation of proposal from point of view of lessor

Lessor will purchase the asset for Rs 2,30,000 and incur maintenance, taxes and insurance

Lessor will claim depreciation and receive salvage value after life

Annual operating expenses Rs 80,000 are to be incurred by lessee

Statement of Net Present value of cash inflows

Cash inflows

Lease rent

(after tax) 96,000(1 – 0.5)= 48,000 1e 0.893 42,864

98,000( 1 – 0.5)= 49,000 2e 0.797 39,053

98,000( 1 – 0.5)= 49,000 3e 0.712 34,888

1,16,805

Cash outflows

Purchase Price 2,30,000 0 1 2,30,000

Maintenance, taxes

Insurance (after tax) 20,000( 1 – 0.5) 1 – 3e 2.402 24,020

Tax savings on

depreciation

( )x 0.5 20,000 1 – 3e 2.402 (48,040)

Salvage value 1,10,000 3e 0.712 (78,320)

Cash outflows 1,27,660

NPV (1,16,805 - 1,27,660) (10,855)

Since NPV of lease proposal is –ve, so it is not viable for lessor

Q13 IRR of leasing company is the rate at which present value of cash inflows are equal to present

value of cash outflows

Cash outflows are purchase price of bus i.e Rs 16,00,000

Cash inflows are Lease rent of Rs 4,00,000 for 8 years

Tax rate no given so depreciation is ignored. Salvage value not given

Present value of cash inflows @ 18% (random) = 4,00,000 x 4.078 = 16,31,200

Present value of cash outflows @ 19% = 4,00,000 x 3.954 = 15,81,600

IRR is = 18 + x 1

= 18.629%

18%........ 16,31,200

? 16,00,000

19%........ 15,81,600

For change in PV of 49,600, change in

rate is 1%. For change in PV of

31,200 change in rate is

x 1

Page 21: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

21

ii. Annual lease rent to earn 20% compound interest

Lease rent x factor (20% , 8yrs) = 16,00,000

Rent x 3.837 = 16,00,000

Rent = 4,16,992

Q14 Cash outflow Rs 100 lakh

Lease period 5 years

Required rate 20%

i. Lease rent p.a for equated level

( Equated level is the rent at which present value of annual lease rent is equal to cash

outflow)

Lease rent x factor (5yrs, 20%) = 100 lac

Rent x 2.991 = 100 lac

Annual lease rent = 33.434 lac p.a

ii. Stepped lease rent i.e Lease rent if it increases 15% p.a

Present value of stepped lease rent for 5 years is equal to cost of asset)

Let lease rent of 1st year is x

+ + + + = 100 lac

0.833x + 0.694 + 0.578 + 0.482 + 0.402 = 100 lac

x = 26,08,923

iii. Annual lease rent of 10 lac for 4 years and balloon payment in 5th year. Amount of

payment in 5th year

Present value of + P.V of lease = 100 lac

Rs 10,00,000 for 4 years rent for 5th year

10,00,000 x 2.589 + 0.402 x = 100 lac

x = = Rs 184.35 lac

iv. Annual lease rent if rent is paid after 2 years from 3rd

year for 3 years

Annual lease rent x (factor 3 years 20%)(factor 2nd

year, 20%) = 100 lacs

Lease rent x 2.106 x 0.694 = 100 lacs

Lease rent p.a =

Rs 68.419 lacs p.a

Page 22: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

22

Q15 Alternative 1 Purchase option

Depriciation - 22,00,000 – 10,00,000 = Rs 4,00,000 p.a

3

Operating and training costs are common in both alternatives, hence not relevant

Effective discount rate 16% (1. 0.5) = 8%

Statement of cash flows under purchase option

Particulars Year 1 Year 2 Year 3

Principal 5,00,000 8,50,000 8,50,000

Interest 3,52,000 2,72,000 1,36,000

Tax saving on Interest 1,76,000 1,36,000 68,000

Depreciation 4,00,000 4,00,000 4,00,000

Tax saving on depreciation 2,00,000 2,00,000 2,00,000

Salvage value 10,00,000

Statement of NPV under purchase option

Particulars period Amount Factor @ 8% Present value

Installment and interest 1end 8,52,000 0.926 7,88,952

Payment 2end 11,22,000 0.857 9,61,554

3end 9,86,000 0.794 7,82,884

Tax saving on depreciation 1end 3,76,000 0.926 (3,48,176)

And Interest 2 end 3,36,000 0.857 (2,87,952)

3 end 2,68,000 0.794 (2,12,792)

Salvage value 3 end 10,00,000 0.794 (7,94,000)

NPV of cash flows 8,90,470_

Alternative 2- Lease option

Statement of lease rent

Particulars Year 1 Year 2 Year 3

Lease rent 5,00,000 5,00,000 5,00,000

10 % of revenue 2,25,000 2,50,000 2,75,000

Lump sum payment 6,00,000

7,25,000 7,50,000 13,75,000

Statement of NPV under Lease option

Particulars period Amount Factor @ 8% Present value

Lease rent 1 end 7,25,000 0.926 6,71,350

2end 7,50,000 0.857 6,42,750

3 end 13,75,000 0.794 10,91,750

Tax savings on lease rent 1 end 3,62,500 0.926 (3,35,675)

2 end 3,75,000 0.857 (3,21,375)

3 end 6,87,500 0.794 (5,45,875)

NPV of cash flows 12,02,925

Since NPV is lower in purchase option, so company should purchase the computer

Page 23: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

23

Q16 Classic finance will lease a machine to customer for 3 years at lease rent which for 3 years will be

in the ratio of 3:2:1.

Statement of Depreciation and tax saving on depreciation (in lacs)

Year Book value Depreciation Cl WDV Tax saving

At beg of year of the year(25%)

1 600 150 450 52.50

2 450 112.5 337.5 39.375

3 337.5 84.375 253.125 29.531

Salvage value after 3 years nil

Capital loss after 3 years 253.125

Tax saving on capital loss 88.59 lacs

Statement of lease rent

Let lease rent of 3rd

year is x

Year Lease rent Lease rent after tax

1 3x 3x ( 1 – 0.35) = 1.95x

2 2x 2x ( 1 – 0.35) = 1.30x

3 x x ( 1 - 0.35) = 0.65x

Lessor will earn 10% if PV of cash inflows @ 10% - Present value of cash outflows = 0

Statement of net present value of cash inflows

Amount period factor Present value

Lease Rent (Net of tax) 1.95x 1e 0.909 1.77255 x

1.30x 2e 0.826 1.0738 x

0.65x 3e 0.751 0.48815x

Tax savings on depn 52.5 1e 0.909 47.7225

39.375 2e 0.826 32.52375

29.531 3e 0.751 22.17778

Tax savings on cap loss 88.59 3e 0.751 66.5339

Purchase Price 600 0 1 (600)

NPV 0

3.3345x - 431.042 = 0

X = = 129.267 lacs

Lease rent of 3rd

year = 129.267 lacs

Lease rent of 2nd

year = 258.534 lacs

Lease rent of 1st year = 387.801 lacs

Page 24: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

24

Q17 Company X is considering to acquire a machine costing Rs 10 lakhs. Company has 2 options

Option 1 To acquire machine on hire purchase (just like loan option)

Company X will pay 2,50,000 at the time of signing of agreement and annual

installment of Rs 4,00,000 at the end of each year for 3 years. Rate of interest

paid by company X is the rate at which present value of cash outflow is equal to

loan (10,00,000 – 2,50,000) 7,50,000

Computation of rate of Interest paid by company X

Present value of 4,00,000 p.a for 3 years @ 27% 7,58,400

Present value of 4,00,000 p.a for 3 years @ 28% 7,47,200

ROI paid is

27% + x 1

= 27.75%

Statement of Principal and interest

Period Installment Interest Principal Principal o/s Tax saving on Intt

@ 27.75%

0 2,50,000 - 2,50,000 7,50,000 -

1e 4,00,000 2,08,125 1,91,875 5,58,125 72,844

2e 4,00,000 1,53,484 2,46,516 3,11,609 53,719

3e 4,00,000 88,391 3,11,609 - 30,937

Discount rate is rate of interest charged by Hire purchase company after tax 27.75 (1 – 0.35)

18.0375%

Statement of Present value of cash outflow (if taken on hire purchase)

Amount period factor Present value

@ 18.0375%

Installment 2,50,000 0 1 2,50,000

4,00,000 1 – 3e 2.173 8,69,200

Tax savings on intt 72,844 1e 0.847 (61,699)

53,719 2e 0.718 (38,570)

30,937 3e 0.608 (18,810)

Tax savings on 1,16,667 1 – 3e 2.173 (2,53,517)

depn

x 0.35

Present value of cash outflow 7,46,604

27%.............758400

?...................7,50,000

28%..............7,47,200

For PV of 11,200 change in rate is

1%. For change in PV of 8,400

change in rate is

x 1 = 0.75

Page 25: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

25

Statement of Present value of cash outflow (if asset is taken on lease)

Amount period factor Present value

@ 18.0375%

Initial service fee 20,000 0 1 20,000

Tax savings on

this fee at

1st yr end

(20,000 x 0.35) 7,000 1e 0.847 (5,929)

Lease rent

after tax

( 4,32,000 x 0.65) 2,80,800 1 – 3e 2.173 6,10,178

Present value of cash outflow 6,24,249

Since present value of cash outflow is lower in case of lease option so, lease option is

better.

Q18 An industrial unit desires to acquire a diesel generating set costing Rs 20 lakhs having a life of 10

years. Company has 2 options

Option 1 To acquire machine on lease at an annual lease rent which gives lessor a return

of 10%

Statement of NPV for lessor

Lessor will earn 10% if PV of cash inflows is equal to present value of cash outflows at 10% i.e

NPV = 0

Amount Period factor@ 10% Present value

Lease rent x 0 1 x

After tax x 1 – 9 5.759 5.759x

x( 1 – 0.5)

Tax on Lease rent 0.5x 1 – 10 6.145 (3.0725x)

Tax saving on depn

x 0.5 1,00,000 1 – 10 6.145 6,14,500

Purchase price 20,00,000 0 1 (20,00,000)

NPV 0

Annual lease rent

3.6865x - 13,85,500 = 0

x = = 3,75,831

Page 26: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

26

Statement of Present value of cash inflows for lessee

Amount Period factor @8% Present value

16(1 – 0.5)

Lease rent 3,75,831 0 1 3,75,831

3,75,831 1 – 9 6.247 23,47,816

Tax saving on 1,87,916 1 – 10 6.71 (12,60,916)

lease rent

Present value of cash outflow 14,62,731

Option 2 To purchase the asset by taking loan from bank @ 16% p.a, repayable in 10

equal installments

Installment of loan each year

Amount x factor @ 16% = 20,00,000

Amount x ( 1 + 4.607) = 20,00,000

Amount = 3,56,697

Statement of Principal and interest

Year installment interest principal principal o/s Tax saving on intt

1 3,56,697 - 3,56,697 16,43,303 -

2 3,56,697 2,62,928 93,769 15,49,534 1,31,464

3 3,56,697 2,47,925 1,08,771 14,40,762 1,23,962

4 3,56,697 2,30,522 1,26,175 13,14,587 1,15,261

5 3,56,697 2,10,334 1,46,363 11,68,224 1,05,167

6 3,56,697 1,86,916 1,69,781 9,98,443 93,458

7 3,56,697 1,59,751 1,96,946 8,01,497 79,876

8 3,56,697 1,28,240 2,28,457 5,73,040 64,120

9 3,56,697 91,686 2,65,011 3,08,029 45,843

10 3,56,697 48,668 3,08,029 - 24,334

Statement of present value of cash outflow if asset is purchased

Amount Period factor Present value

@ 8%

Installment 3,56,697 0 1 3,56,697

3,56,697 1 – 9 6.245 22,27,573

Tax saving on intt 1,31,464 1e 0.926 (1,21,736)

1,23,962 2e 0.857 (1,06,235)

1,15,261 3e 0.794 (91,517)

1,05,167 4e 0.735 (77,298)

93,458 5e o.681 (63,645)

79,876 6e 0.630 (50,322)

64,120 7e 0.583 (37,382)

45,843 8e 0.540 (24,755)

24,334 9e 0.500 (12,167)

Tax saving on depn 1,00,000 1 – 10e 6.71 (6,71,000)

Present value of cash outflow 13,28,213

Purchasing the asset is better option

Page 27: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

27

Q19 Alfa Ltd. Is thinking of installing a computer. Company has two options.

Option 1 To acquire computer on lease at annual lease rent of Rs 4,50,000 to be paid at

beg of each year

Annual maintenance expenses are ignored as such expenses are incurred

whether asset is taken on lease or purchase by loan

Statement of present value of cash outflow

Amount Period factor Present value

@ 9%

Lease rent 4,50,000 0 1 4,50,000

4,50,000 1 – 5 3.890 17,50,500

Tax saving on 1,80,000 1 – 6 4.486 (8,07,480)

lease rent

Present value of cash outflow 13,93,020

Option 2 To purchase the asset by borrowing from bank Rs 20,00,000 @ 15% p.a.

Loan is repayable by making 6 year end installments of Rs 5,28,474 each

Statement of Principal and interest

Year installment interest principal principal o/s tax saving

1 5,28,474 3,00,000 2,28,474 17,71,526 1,20,000

2 5,28,474 2,65,729 2,62,745 15,08,781 1,06,292

3 5,28,474 2,26,317 3,02,157 12,06,624 90,527

4 5,28,474 1,80,994 3,47,480 8,59,144 72,398

5 5,28,474 1,28,872 3,99,602 4,59,542 51549

6 5,28,474 68,932 4,59,642 - 27,573

Depreciation p.a = 3,00,000

Tax saving on depreciation = 3,00,000 x 0.4 = 1,20,000

Statement of Present value of cash outflows

Amount period factor Present value

@ 9%

Installment 5,28,474 1 – 6 4.486 23,70,734

Tax saving on 2,40,000 1e 0.917 (2.20.080)

Interest + depn

2,26,292 2e 0.842 (1,90,538)

2,10,527 3e 0.772 (1,62,527)

1,92,398 4e 0.708 (1,36,218)

1,71,549 5e 0.650 (1,11,507)

1,47,573 6e 0.596 (87,954)

Salvage value 2,00,000 6e 0.596 (1,19,200)

Present value of cash outflow 13,42,710

Purchase option is better

Annual maintenance expenses are ignored as such expenses are incurred whether asset is taken on

lease or purchase by loan

Page 28: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

28

Q20 ITC finance is a leasing company, considering to lease a machine costing Rs 30 lac.

Discount rate 12%

Depreciation p.a = 6,00,000

Lease period 5 years

Rent to be received at beginning of each year

Amount of Annual lease rent will be the amount at which PV of cash inflows are equal to present

value of cash outflows i.e NPV = 0

Statement of Present value of cash outflow

Amount period factor Present value

12%

Lease rent x 0 1 x

x 1 – 4 3.037 3.037x

Tax paid on lease rent 0.5x 1 – 5 3.605 (1.8025x)

Tax saving on depn 3,00,000 1 – 5 3.605 10.81,500

Purchase price 30,00,000 0 1 (30,00,000)

NPV 0

Annual lease rent

2.2345x - 19,18,500 = 0

x = 8,58,581

Q21 MGF is a leasing company, which is considering to lease an equipment costing Rs 10,00,000 for

10 years

Depreciation p.a = 1,00,000 p.a

Tax rate 40% for 5 years and 30% for next 5 years

1% management fee charged from lessee is to be ignored as it is equal to overhead cost incurred

Lease rents are to be collected at beginning of each year

Amount of Annual lease rent will be the amount at which PV of cash inflows are equal to present

value of cash outflows i.e NPV = 0

Statement of Present value of cash outflow

Amount period factor@ 10% Present value

Lease rent x 0 1 x

x 1 – 9 5.759 5.759x

Tax paid on 0.4x 1 – 5 3.791 (1.5164x)

lease rent 0.3x 6 – 10 3.791 x 0.621 (0.7063x)

Tax saving on 40,000 1 – 5 3.791 1,51,640

Depn 30,000 6 – 10 3.791 x 0.621 70,626

Purchase price 10,00,000 0 1 (10,00,000)

NPV 0

Annual lease rent

4.5363x - 7,77,734 = 0

x = 1,71,447

Page 29: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

29

Q22 ITC Finance Ltd.a leasing company is considering to lease a machine costing 3,00,000 + 30,000

For 5 years

Tax rate 50%

Discount rate 8%

Statement of depreciation

Year op.WDV Depreciation Cl. WDV Tax saving

On Depn

1 3,30,000 82,500 2,47,500 41,250

2 2,47,500 61,875 1,85,625 30,937

3 1,85,625 46,406 1,39,219 23,203

4 1,39,219 34.805 1,04,414 17,402

5 1,04,414 26,104 78,310 13,052

Salvage value assumed Nil

Tax saving on Capital loss 78,310 x 0.5 = 39,155

Amount of Annual lease rent will be the amount at which PV of cash inflows are equal to present

value of cash outflows i.e NPV = 0

Statement of Present value of cash outflow

Amount period factor@ 8% Present value

Lease rent x 1 - 5 3.993 3.993x

Tax paid on

lease rent 0.5x 1 – 5 3.993 (1.9965x)

Tax saving on

Depn 41250 1e 0.926 38,198

30937 2e 0.857 26,513

23203 3e 0.794 18423

17402 4e 0.735 12790

13052 5e 0.681 8888

Salvage value 39,155 5e 0.681 26,665

Purchase price 3,30,000 0 1 (3,30,000)

NPV 0

Annual lease rent

1.9965x - 1,98,523 = 0

x = 99,436

Page 30: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

30

Q23 A leasing company, which is considering to lease an equipment costing Rs 1,00,000 for 5 years

Salvage value Rs 10,000

i. Lease rents are to be collected at end of each year

Amount of Annual lease rent will be the amount at which PV of cash inflows are equal to present

value of cash outflows i.e NPV = 0

Statement of Present value of cash outflow

Amount period factor@ 10% Present value

Lease rent x 1 – 5 3.791 3.791x

Salvage value

To be discounted

at 25% 10,000 5e 0.328 3,280

Purchase price 10,00,000 0 1 (1,00,000)

NPV 0

Annual lease rent

3.791x - 96,720 = 0

x = 25,513

ii. Lease rent are payable at beg of each year

Amount of Annual lease rent will be the amount at which PV of cash inflows are equal to present

value of cash outflows i.e NPV = 0

Statement of Present value of cash outflow

Amount period factor@ 10% Present value

Lease rent x 0 1 x

x 1 - 4 3.170 3.170x

Salvage value

To be discounted

at 25% 10,000 5e 0.328 3,280

Purchase price 10,00,000 0 1 (1,00,000)

NPV 0

Annual lease rent

4.170x - 96,720 = 0

x = 23,194

Page 31: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

31

Q24 Lessee has received 2 offers from leasing company for leasing the asset costing Rs 1,50,000

Option 1 Pay lease rentals for 96 months. Rs 30 / 1000 for 1st 72 months and Rs 5 / 1000

for next 24 months.

Lessor offered to transfer asset to lessee at 5% of original cost after expiry of

lease

(Tax saving on lease rent will be at the end of each year)

Payment of monthly lease rent

Year 1 – 6 (Month 1 – 72) = 1,50,000 x = Rs 4500 pm

Year 7 – 8 (Month 73 – 96) = 1,50,000 x = Rs 750 pm

Yearly lease rent

Year 1 – 6 = 4500 x 12 = 54,000 p.a

7 – 8 = 750 x 12 = 9,000 p.a

On Lease rent discount rate applicable is yearly discount rate calculated on Monthly average

basis

Sum of PV factor for 1 – 72 months =

( 0.923 + 0.795 + 0.685 + 0.590 + 0.509 + 0.438) = 3.940

Sum of PV factor for 73 – 96 months

(0.377 + 0.325) = 0.702

Tax saving on lease rent

Year ( 1 – 6) = 54,000 x 0.4 = 21,600

Factor (0.869 + 0.756 + 0.658 + 0.572 + 0.497 + 0.432) = 3.784

Year (7 – 8) = 9,000 x 0.4 = 3600

Factor ( 0.376 + 0.327_ = 0.703

Statement of Present value of cash outflows

Amount Period factor Present value

Lease rent 54,000 1 – 6 3.940 2,12,760

9.000 7 – 8 0.702 6,318

Tax saving on rent 21,600 1 – 6 3.784 (81,734)

3600 7 – 8 0.703 (2531)

1,34,813

There is no detailed information about the future life of asset. So it is assumed that the company

did not purchase the asset as offered by the leasing company.

Page 32: LEASING SOLUTION CA-FINAL SFM (FULL)

PRAVINN MAHAJAN 9871255244, 8800684854

32

Option 2

Lease rent is to be paid @ Rs 35 / 1000 for 60 months

Initial deposit of 15% is to be paid at the time of agreement

After expiry of lease, asset will be sold to lessee against initial deposit. Further life of asset is 3

years. Thus total life of asset is 5 + 3 = 8 years

Monthly lease rent = 1,50,000 x = Rs 5,250 pm

Annual rent = 5,250 x 12 = Rs 63,000

Discounted at ( 0.923 + 0.795 + 0.685 + 0.590 + 0.509) = 3.502

Yearly rate on monthly average basis

Tax saving on lease rent = 63,000 x 0.4 = 25,200 p.a

Discounted at yearly rate (0.869 + 0.756 + 0.658 + 0.572 + 0.497)= 3.352

At the beginning of lease initial deposit of 15% i.e 22,500 is to be paid. It will be adjusted and the

asset is given to lessee at the end of year 5. Lessee becomes the owner of asset and claim tax

saving on depreciation. He also receives salvage net of tax

Statement of depreciation and tax saving

Year WDV Dep tax saving @ 40%

6 22,500 5,625 2,250

7 16,875 4219 1688

8 12,656 3164 1266

Cl WDV 9492 (assumed asset sold at 9492 after life)

Statement of Present value of cash outflow

Amount Period factor Present value

Initial deposit 22,500 0 1 22,500

Lease rent 63,000 1 – 60 month 3.502 2,20,626

Tax saving on rent 25,200 1 – 5 yr 3.352 (84,470)

Tax saving on dep 2250 6e 0.432 (972)

1688 7e 0.376 (635)

1266 8e 0.327 (414)

Salvage value 9492 8e 0.327 (3104)

NPV 1,53,531