Lease vs Buy Decision
Not what you're looking for?
Kemp Corporation is evaluating whether to lease or purchase equipment. The equipment will cost $500,000 if purchased, and the entire amount will be financed by a bank loan at an annual interest rate of 10 percent. At the end of 4 years, the company expects to sell the equipment for $60,000. The equipment falls in the MACRS 3-year class. The firm's tax rate is 30 percent. The lease terms call for payments of $100,000 for 4 years, payable at the beginning of the year.
MACRS % by year 0.33 0.45 0.15 0.07
a. Calculate the cost of purchasing the equipment.
b. Calculate the cost of leasing the equipment.
c. Calculate the NAL. Should the firm purchase or lease the equipment? Why?
Please provide in Excel.
Purchase this Solution
Solution Summary
This solution provides you with a detailed layout in excel of how to approach the question given. Guidance is given as to how to format a table which deals with the costing data and also a table which deals with the leasing data. A link is also provided in the solution which gives an in depth overview of things you need to know when trying to determine whether a firm should lease or buy equipment.
Solution Preview
Before attempting this question, you may vist the following link to get an in depth of understand of information related to the leasing vs buying decision - http://www.agmanager.info/farmmgt/machinery/Lease%20vs.%20Buy.pdf.
For your computation as it relates to the cost of purchasing the equipment, you must note the following at the top of your spreadsheet:
Equipment ...
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.