Question
Please, can you help on this problem Include excel formulas. Please ensure to address the two questions: the time value money and the time it
Please, can you help on this problem Include excel formulas. Please ensure to address the two questions: the time value money and the time it will take to get the investment back for each location. Thanks! 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 $126,000, whereas the University City location requires $185,000. From the student population and the competition, the finance team estimates the revenue at Collegeville to be $48,000 a year and the revenue at University City to be $56,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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started