PizzaPizza is considering two college towns, Collegeville and University City, to open their new store this August, just in time for the fall semester. The Collegeville location requires an initial investment of exist126,000, whereas the University City location requires exist185,000. From the student population and the competition, the finance team estimates the revenue at Collegeville to be exist48.000 a year and the revenue at University City to be exist56.000. Assuming a hurdle rate of 15%, how long it will take to get the investment back for each location? Include the time value of money in your analysis.
Please show all steps and formulas used in excel.