John, the general manager of AAA is planning an expansion for the AAA store. John was debating this decision for a longtime, but when demand outstripped supply at his store, he decided to expand the business. Expanding the business requires a thorough analysis, which he plans to carry out this week. AAA Company is a successful business venture. It is expected that sales at the AAA will increase substantially in the coming 5 years. Right now, the company occasionally runs out of inventory. To meet the increase in demand John is planning an expansion. John has two locations in mind each location has a unique value proposition. John gathered a lot of data, to make sure he is taking the right decision. First, he went out, and calculated the rent rates at each location. The rent is a running expense, it is not volatile, but it increases in-line with inflation. Next, John analyzed the neighborhood demographics, this is an essential step which will enable forecasting future sales. The neighborhood demographics proved to be very similar. Both neighborhoods have a lot of middle-class working families, which is the target market for AAA Company. Moreover, John also made sure to visit the local city council, in order to obtain more information on the required permits. The permit is essential, since zoning requirements could restrict certain business activities. After obtaining the information for each location, john started thinking about capital investments. He researched the appropriate equipment which will be used in each store. He also went out and talked to a couple contractors and obtained quotes for his suggested design and store layout. He was satisfied with pricing. Finally, John went to his financial manager and they together analyzed the required working capital financing for each location. The financial manager, used pro-forma financial statements to forecast the expected sales figure, cost of goods sold, and operating expenses. Also, the financial manager, made sure to calculate the Weighted Average Cost of Capital, the stores will be financed via a mix of equity and debt. The financial manager summarized the key cash flows (presented in the tables below), and hes eager to know the expected profitability for each project; NPV, IRR, and Payback Period. Its expected that each store will require major renovations after 10 years, and thus the project life is limited to 10 years. Use case variations from the excel sheet. Your task is: 2% Correct calculation of: NPV, IRR, and Payback. 1% Correct project selection. 2% Selecting the appropriate credit facility and justifying the selection.