As a consultant, you were asked to evaluate a lease versus buy analysis on the purchase of a new front end cash register system for a clothing store called More Clothes. The cost of the front-end system is $1,000,000.00

The owners of the store will obtain a loan for 8% for the full amount of the system. The loan would be amortized over the 5-year life of the system, with payments made at the end of each year. The system is classified as a special purpose; hence, it falls into the MACRS 3-year class with depreciation rates of (33%; 45%, 15%, and 7%).

If the system is purchased, a maintenance contract will be obtained for $30,000, payable at the start of each of the next 4 years. The firm will upgrade the system at the end of four years and sell the current system for $95,000.

As an alternative, ABC Leasing will write a 4-year lease on the system, including maintenance, for payments of $325,000 at the beginning of each year. The firm's marginal federal plus state tax rate is 35%.

On an Excel spreadsheet, compute the net advantage to leasing.

Clearly note the following on the Excel spreadsheet:

Initial cost of owning

Year one operating cash flow of owning

Net sale price (if owned)

Cost of Owning

Cost of capital used to evaluate project

Operating cost in year 1 associated with leasing

Cost of Leasing

Net advantage (disadvantage) of leasing

show work in excel and formula

Attached is a template that you may use (you do not need to use the template).

Leasing Template.xlsx

What is your initial outflow in Year 1 if you purchase the equiptment?