Equipment is being leased from a dealer for $500,000 per year with beginning of year payments and the lease expires three years from now. It is estimated that a new lease for the succeeding four years on similar new equipment will provide the same service and will cost $750,000 per year with beginning of year payments. The first payment under the new lease occurs at the beginning of year four. The equipment manufacturer is offering to terminate the present lease today and to sell the lessee new equipment for $2 million now which together with a major repair cost of $600,000 at the end of year four should provide the needed equipment service for a total of seven years, after which, the salvage value is estimated to be zero. Use present worth cost analysis for a minimum rate of return of 20% to determine if leasing or purchasing is economically the best approach to provide the equipment service for the next seven years. Verify your conclusion with ROR and NPV analysis, respectively. Please work this problem through excel or explain how you would come to the conclusion using excel.