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 $4.1 million in annual pretax cost savings. The system costs $9.1 million and will be depreciated straight-line to zero over 5 years. Wildcat's tax rate is 22 percent, and the firm can borrow at 8 percent. Lambert Leasing Company has offered to lease the drilling equipment to Wildcat for payments of $2.12 million per year. Lambert's policy is to require its lessees to make payments at the start of the year. |
a. |
What is the NAL for Wildcat? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) |
b. | What is the maximum lease payment that would be acceptable to the company? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) |
Answer | ||
a | Purchase asset | |
System Cost | $ 9,100,000.00 | |
Pre tax cost savings | $ 4,100,000.00 | |
Life of system | 5 years | |
Depreciation | Cost /Life | |
$ 1,820,000.00 | ||
Pre tax cost savings | $ 4,100,000.00 | |
Less : Depreciation | $ 1,820,000.00 | |
Pre tax cost savings | $ 2,280,000.00 | |
tax @ 22% | $ 501,600.00 | |
Post tax savings | $ 1,778,400.00 | |
Add : Depreciation | $ 1,820,000.00 | |
Net cash flows | $ 3,598,400.00 | |
Discount rate | 8% | |
Presnet value of cash flows | PVAF(8%,5years)*3598400 | |
PVAF(6%,5years) | 1-(1+r)^-n/r | |
(1-(1.08)^-5)/0.08 | ||
3.9927 | ||
Presnet value of cash flows | $ 14,367,367.80 | |
Asset on Lease | ||
Pre tax cost savings | $ 4,100,000.00 | |
Lease Payment | $ 2,120,000.00 | |
$ 1,980,000.00 | ||
Tax @ 22% | $ 435,600.00 | |
Net cash flows | $ 1,544,400.00 | |
Present Value of Cash Flows | $ 6,166,341.38 | |
NAL of Wildcat | $ (8,201,026.42) | |
b | Maximum Lease Payment acceptable to wildcat | |
In order to accept the lease proposal the cash flows under both options should be equal | ||
Or Else it should be less than cash flows under purchase option. | ||
Pre tax cost savings | $ 4,100,000.00 | |
Lease Payment | X | |
4100000-X | ||
Tax @ 22% | (4100000-X)*22% | |
Net cash flows | (4100000-X)*78% | |
Net cash flows should be equal to | $ 3,598,400.00 | |
(4100000-X)^78% | $ 3,598,400.00 | |
(4100000-X) | $ 4,613,333.33 | |
X | 4613333.33-4100000 | |
Lease payment should be equal to | $ 513,333.33 | |