I need to know how to create an Excel spreadsheet with this information:

Company A is considering leasing new equipment to Company Z. The lease would be a 4 year contract with a $95,000 payment due at the end of each year(like an ordinary annuity) and includes maintenance.

In order to lease the equipment to Company Z, Company A has to buy it first at a cost of $250,000. They also have to pay the seller $7,000 for maintenance service at the end of each year.

This equipment is in the MACRS 3 year class; Equipment resale value = $25,000; Company A's tax rate is 40%

Company A requires an 11% after tax return on equipment that it leases, this is also its Weighted Average Cost of Capital.

For this example the Net Advantage to Leasing(NAL) is basically the same as the NPV of the lease.

1. Should Company A go ahead with the lease? Why or why not?

2. If Company A needs a 13% return on the lease, what is the Net Advantage to Leasing(NAL) and how does it affect the analysis and should they write the lease?