Assume the same information as in P3.4.

Instructions
Redo the analysis using Excel functions for an annuity due. Will the conclusion reached be the same as in P3.4?

Data from P3.4

James Halabi is a financial executive with McDowell Enterprises. Although James has not had any formal training in finance or accounting, he has a “good sense” for numbers and has helped the company grow from a very small company ($500,000 in sales) to a large operation ($45 million in sales). With the business growing steadily, however, the company needs to make a number of difficult financial decisions in which James Halabi feels a little “over his head.” He therefore has decided to hire a new employee with “numbers” expertise to help him. As a basis for determining whom to employ, he has decided to ask each prospective employee to prepare answers to questions relating to situations he has encountered recently.
The following are the facts for the first question asked of prospective employees. In 2019, McDowell Enterprises negotiated and closed a lease contract for newly constructed truck terminals and freight storage facilities. 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.2 million. 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?