You must either use EXCEL to do your calcualtions on the assignment or type all of your calcuations manually for full credit

You must choose a franchise option and a lease option! You are planning on going into business for yourself and you have decided on a location for a quick casual restaurant. The first step is to determine which franchise yeilds the Highest Net Present Value Cash Flow. Once you have determined your choice of franchise, you need to negotiate a lease. The new landloard has given you three options. The time horizion for the project is FIVE years. The Ke for the entire assignment is $12\%.$