Your company is considering either purchasing or leasing an asset that cost $1,000,000. The asset, if purchased, will be depreciated on a straight-line basis over the 6 years to a zero residual value. A leasing company is willing to lease the asset for $300,000 per year; the first payment is due at the time the lease contract is signed (i.e., year 0), and the remaining five payments are due at the beginning of years 1-5. Your company has a tax rate Tc = 40% and can borrow at 10% from its bank.

A. Should your company lease or purchase this asset?

B. What is the maximum lease payment it will agree to pay?

Please show the answers in excel