Calculate the Payback Period for each project. $($Show Work$)$

Calculate the NPV for each project, assuming a discount rate of $11\mathrm{.}1\%.$

Calculate the IRR for each project.

Which projects should the firm implement based on your analysis If the projects are mutually exclusive? What if they are independent and $$400,000$ in capital funding is available?

Five Projects Under Consideration

$\backslash$table$[[,$Project A$,$Project B$,$Project C$,$Project D$,$Project E$],[\backslash$table$[[$Initial$],[$Investment$]],-$$$100,000,-$$$150,000,-$$$140,000,-$$$60,000,-$$$1,500$