Please show workings clearly on excel sheet

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

(a) Recommend if your company should lease or purchase the asset?

(b) Compute the maximum lease payment your company would agree to pay