Reynolds Corporation plans to purchase equipment at a cost of $5 million. The company's tax-rate is 21%, the equipment's depreciation would be $1,000,000 per year for 5 years, and no salvage value is expected. If the company leased the asset on a 5-year lease, the payment would be $1,100,000 at the beginning of each year. If Reynolds borrowed and bought, the bank would charge 10 percent interest on the loan.

a. Calculate the cost of purchasing the equipment with debt.

Purchase Option
	CF0	CF1	CF2	CF3	CF4	CF5

b. Calculate the cost of leasing the equipment.

c. Calculate NAL? Should the company buy or lease the equipment? Why?

Please show how to do problem in Excel with formulas so I can do a new problem myself. Thank you in advance!