just looking for some guidance with this thank you :)

Problem: You have just completed your undergraduate degree, and one of your favorite courses was "Is Entrepreneurship for You." You enjoyed it so much you have decided you want to start your own business. While you were in the program, your grandmother died and left you $325,000 with no restrictions. You are not an inventor, and you do not have a trade skill that you can market; however, you have decided that you would like to purchase at least one established fast-food franchise, maybe two (if profitable). The problem is that you have never been one to stay with any project for too long, so you figure that your time frame is four years. After four years, you will sell off your investment and go on to something else. You have narrowed your selection down to two choices: (1) Franchise 1: Chicken Express and (2) Franchise 2: Healthy Comfort Food. (1) Franchise 1: Chicken Express and (2) Franchise 2: Healthy Comfort Food. The net cash flows shown below include the price you would receive for selling the franchise in Year 4 and the forecast of how each franchise will do over the four years. Franchise 1's cash flows will start high but will trail off as other competitors enter the marketplace and as people become more health- conscious and avoid fried foods. In contrast, Franchise 2's cash flows will start slowly but will increase rather quickly as people become health-conscious. Franchise 2 serves breakfast and lunch, while Franchise 1 serves only dinner, so it is possible for you to invest in both franchises (i.e., projects may or may not be independent). You see these franchises as perfect complements to one another: you could attract both the lunch and dinner crowds and the health-conscious and not so health-conscious crowds without the franchises' directly competing against one another. Here are the net cash flows (in thousands of dollars): Year Expected Net Cash Flows Franchise 1 Franchise 2 ($100) ($100) 95 8 75 45 45 55 20 85 2 3 4 Depreciation, salvage values, net working capital requirements, and tax effects are all included in these cash flows. You also have made subjective risk assessments of each franchise and concluded that both franchises have risk characteristics that require a return of 8 percent. You need to select one or both projects for your investment To do so, please answer the following questions thoroughly. Make sure to show a time line, the formula to be used, the steps used to solve the problem (calculator or Excel), and the final numerical answer when appropriate. Quantitative questions. 1. (5 points) Create a time line for each of the franchises. 2. (10 points) What is each franchise's NPV? Make sure to show the formula, steps, and final answer. 3. (10 points) Calculate the IRR for each project. Make sure to show the formula, calculator, or excel steps and final answer. 4. (10 points) Find the MIRRs for Franchises 1 and 2. Make sure to show the formula, steps, and final answer. 5. (10 points) Calculate the payback period for each franchise. Make sure to show the formula, steps, and final answer. 6. (10 points) Calculate the discounted payback period for each franchise. Make sure to show the formula, steps, and final answer. Qualitative questions. Each question is worth 15 points. 1. (15 points) After obtaining the five different models' results, indicate which franchise you would ultimately choose if the projects are independent or mutually exclusive (i.e., you decide to invest in both or just on one). Make sure to explain in some detail why. Please use definitions and do not forget to point out the advantages and disadvantages of each model. 2. (15 points) In the case of mutually exclusive projects (i.e., you can only select one of the two projects), determine which project you would select and why. 3. (15 points) Regarding question 2, assume that you need to make your decision using only one model, which model would you choose to make your selection and why