Develop an Excel spreadsheet model for the following: Lease Corp. is considering a lease to XYZ Corp.
Question:
Develop an Excel spreadsheet model for the following: Lease Corp. is considering a lease to XYZ Corp. for some new manufacturing equipment. The lease would be a 4-year contract with a lease payment of $195,000 per year. In addition, payments are to be made at the end of the year and would include maintenance. If Lease Corp. agrees to lease the item to XYZ Corp, they will have to purchase the equipment outright for $525,000 and also will have to pay the local dealer $11,000 at the end of each year for maintenance service. The equipment falls into the MACRS 3-year class and has a resale value of $42,000. The lessor’s tax rate is 35%. Lease Corp. requires a 12.25% after-tax return on equipment it leases, which is also its WACC (in this problem, the NAL is essentially the NPV of the lease).
Answer the following questions (using Microsoft Word): a. Should Lease Corp. write the lease? Why or why not? Be certain to discuss the NAL of the lease. • Using Excel, create a template similar to the one shown on the next page. b. What if Lease Corp. requires a 13% return on the lease? • What is the NAL? How does this affect the lease analysis? Do you write the lease? c. Suppose that there is a 30% chance that the residual value (i.e., resale value of the equipment) will only be $22,000, another 20% chance that the residual value will be $62,000, and a 50% probability that the residual value will be $42,000. Assuming a 12.25% required return on the lease, what is Lease Corp.’s best and worst case NAL? What is its expected NAL?
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright