Lessee Analysis

Craxton Engineering will either purchase or lease a new $756,000 fabricator. If purchased, the fabricator will be 100% funded with a 12 percent loan that is amortized with end-of-year payments over five years and it will be depreciated using a MACRS 5-year schedule. Craxton will be responsible for maintenance of the equipment. A service contract covering parts and labor is available from the manufacturer for a $18,000 end-of-year payment. Alternative to purchasing, Craxton can lease the fabricator for beginning-of-year annual payments of $190,000 for five years with the lessor responsible for maintenance. In either alternative of purchasing or leasing, Craxton will be responsible for the insurance of the fabricator. It is estimated that the insurance is $2,500 per year. Craxtons tax rate is 40%. Assume the fabricator has no residual value at the end of the five years.

You are required to:

1. Prepare the Depreciation Schedule.

2. Prepare the Loan Amortization Table.

3. Find the after-tax cash flow and PV of the lease alternative.

4. Find the after-tax cash flow and PV of the borrow & buy alternative.

5. Explain which alternative you would recommend giving your reasons.