Question

Advanced Computers has decided to proceed with the manufacture and distribution of the virtual keyboard (VK) the company has developed. To undertake this venture, the company needs to obtain equipment for the production of the microphone for the key board. Because of the required sensitivity of the microphone and its small size, the company needs specialized equipment for production.

Lucas Johnson, the company president, has found a vendor for the equipment. Memtech Acoustical Equipment has offered to sell Advanced Computers the necessary equipment at a price of $4.3 million. Because of the rapid development of new technology, the equipment will be fully depreciated after four years with the straight line depreciation approach. At the end of the fourth year, the market value of the equipment is expected to be $450,000

Alternatively, the company can lease the equipment. Two leasing companies, Hendrix Leasing and International Leasing Corporation, offered their leasing terms to Advanced Computers. Hendrix proposed the following lease contract: The lease contract calls for monthly payment of $90,000 due at the beginning of each month for four years. Additionally, Advanced Computers must make a security deposit $200,000 at the beginning of the lease contract (i.e. at the beginning of the first month) and the deposit will be returned when the lease expires at the end of the last month.

International Leasing Corporation proposed the following lease contract: The lease contract calls for monthly payment of $91,500 due at the beginning of each month for four years without security deposit.

Advanced Computers can borrow a loan with the interest rate of 10% per year from a bank to finance the equipment. The company has a marginal tax rate of 21%.

Questions:

1. If the before-tax cost of debt of Hendrix Leasing is 4% per year and the marginal tax rate is 21%, what is the net present value of the leasing contract for Hendrix Leasing? Use Excel to do calculation.

Answer 1

		Hendrix Leasing	PVCO		in $
Months	Discount factor @0.2633% Per month	Security Deposit	Lease Payments	Total Outflows	Discounted Cash Outflows	Cost Of Debt = 4% Before tax
1	1.000	200000.00	90000.00	290000.00	290000.00	Tax rate = 21%
2 to 47	43.270	0.00	90000.00	90000.00	3894288.02	Cost of Debt after tax = 4%(1-0.21)
48	0.884	-200000.00	90000.00	-110000.00	-97240.00	3.16% Per annum or 0.2633% Per month
				Total Outflows	40,87,048.02
Note	It is stated in Question to Calculate the NPV of the Leasing Contract Since we are not given the cash Inflows hence we cannot calculate NPV
	However if we want to Compare the Leasing vs Leasing OR Leasing vs Buy Decision We Will Use 40,87,048.02 as PVCO for Comparison Purposes
	and Saving or Deficit in that cases will be NPV.