Find the NPV for each project. Are the projects acceptable?

Find the break$-$even free cash flow for each project.

The firm has estimated the probabilities of achieving various ranges of free cash flow for the two projects as shown in the following table. What is the probability

that each project will achieve at least the break$-$even free cash flow found in part b$?$

Which project is more risky? Which project has the potentially higher NPV$?$ Discuss the risk$-$return tradeoffs of the two projects.

If the firm wished to minimize losses $($i$.$e$.,),$ which project would you recommend? Which would you recommend if the goal were to achieve a higher NPV$?$

PLEASE SHOW EXCEL FORMULAS