In: Finance
| 
 The Wildcat Oil Company is trying to decide whether to lease or buy a new computer-assisted drilling system for its oil exploration business. Management has decided that it must use the system to stay competitive; it will provide $3.9 million in annual pretax cost savings. The system costs $8.9 million and will be depreciated straight-line to zero over five years. Wildcat’s tax rate is 24 percent and the firm can borrow at 6 percent. Lambert’s policy is to require its lessees to make payments at the start of the year.  | 
| 
 Suppose it is estimated that the equipment will have an aftertax residual value of $880,000 at the end of the lease. What is the maximum lease payment acceptable to Wildcat?  | 
| Answer | ||
| a | Purchase asset | |
| System Cost | $ 8,900,000.00 | |
| Pre tax cost savings | $ 3,900,000.00 | |
| Life of system | 5 years | |
| Depreciation | Cost /Life | |
| $ 1,780,000.00 | ||
| Pre tax cost savings | $ 3,900,000.00 | |
| Less : Depreciation | $ 1,780,000.00 | |
| Pre tax cost savings | $ 2,120,000.00 | |
| tax @ 24% | $ 508,800.00 | |
| Post tax savings | $ 1,611,200.00 | |
| Add : Depreciation | $ 1,780,000.00 | |
| Net cash flows | $ 3,391,200.00 | |
| Discount rate | 6% | |
| Presnet value of cash flows | PVAF(6%,5years)*1611200 | |
| PVAF(6%,5years) | 1-(1+r)^-n/r | |
| (1-(1.06)^-5)/0.06 | ||
| 4.2124 | ||
| Presnet value of cash flows | $ 14,284,968.07 | |
| NPV | Present Value of cash inflows - Present value of cash outflows | |
| 14284968.07-8900000 | ||
| $ 5,384,968.07 | ||
| b | Asset on Lease | |
| Pre tax cost savings | $ 3,900,000.00 | |
| Lease Payment | X | |
| 3900000-X | ||
| Tax @ 24% | (3900000-X)*24% | |
| Net cash flows | (3900000-X)*76% | |
| After tax residual Value | $ 880,000.00 | |
| Present value | 880000/(1.06)^5 | |
| $ 657,587.19 | ||
| Discount rate | 6% | |
| To be indifference between purchase and lease the NPVs under two options should be equal | ||
| Presnet value of cash flows | ((3900000-X)*76%*4.2124)+657587.19 | |
| NPV | ((3900000-X)*76%*4.2124)+657587.19 | |
| $ 5,384,968.07 | ((3900000-X)*76%*4.2124)+657587.19 | |
| 5384968.07-657587.19 | ((3900000-X)*76%*4.2124) | |
| $ 4,727,380.88 | ((3900000-X)*76%*4.2124) | |
| 4727380.88/4.2124 | (3900000-X)*76% | |
| $ 1,122,253.56 | (3900000-X)*76% | |
| 1122253.56/0.76 | (3900000-X) | |
| 1476649.421 | (3900000-X) | |
| X | 3900000-1476649.421 | |
| X | $ 2,423,350.58 | |
| Maximum Lease payment Acceptable | $ 2,423,350.58 |