USE EXCEL FOR CALCULATION AND SHOW FORMULAS

Question 3 (based on Chapter 11) Angola United Theaters, Inc. is considering opening a new movie theater in Angola, Indiana. The relevant cost of capital is 8%. The purchase, renovation, and modification of a downtown building would require an initial investment of $1.5 million. The theater is expected to be operational for 25 years. After 25 years, the property would be sold for $1 million. The annual operating cost is equal to $100,000 plus $2 per customer. The annual revenues are estimated at $15 per customer. Determine the minimum number of customers per year that would result in accepting the project. (Hint: use annualized worth and solve for the number of customers. Do not use Goal Seek or Solver; perform all of the necessary calculations directly in the Excel cells.)