"In 2019, McDowell Enterprises negotiated and closed a long-term lease contract for newly constructed truck terminals and freight storage facilities. The buildings were constructed on land owned by the company. On January 1, 2020, McDowell took possession of the leased property. The 20-year lease is effective for the period January 1, 2020, through December 31, 2039. Advance rental payments of $800,000 are payable to the lessor (owner of facilities) on January 1 of each of the first 10 years of the lease term. Advance payments of $400,000 are due on January 1 for each of the last 10 years of the lease term. McDowell has an option to purchase all the leased facilities for $1 on December 31, 2039. At the time the lease was negotiated, the fair value of the truck terminals and freight storage facilities was approximately $7,200,000. If the company had borrowed the money to purchase the facilities, it would have had to pay 10% interest. Should the company have purchased rather than leased the facilities?" Please show work in Excel.