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.

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

Please show step by step how you fund this answer with either solver or goal seek please!