$$Before any calculations, can you rank the projects based solely on the cash flows? Explain.

$$Based on what you have learned, what analytical criteria can you use to rank the projects? Provide an example of an advantage and disadvantage of each of the quantitative ranking criteria. Which criterion is best?

$$Submit the case provided Excel file updated with clearly identified calculations $($must include formulas to receive full credit$)$ for each project at a $10\%$ discount rate. Calculations should be provided for NPV$,$ IRR, Payback, & Profitability Index.

$$Between projects $7$ & $8,$ which is the more attractive investment? Why?

$$What are the $$four best$$ projects that you recommend the company accept?

$$In general, explain the impact of increasing the discount rate to $15\%.$

$$If the company had unlimited capital to invest, which project$($s$)$ would you recommend? Explain.