Please can you help me to resolve this problem with the given formulas. No sure how to resolve it:

Payback $=\frac{\text{C}\text{o}\text{s}\text{t}of\text{P}\text{r}\text{o}\text{j}\text{e}\text{c}\text{t}}{\text{A}\text{n}\text{n}\text{u}\text{a}\text{l}\text{P}\text{r}\text{o}\text{f}\text{i}\text{t}\frac{?}{?}\text{S}\text{a}\text{v}\text{i}\text{n}\text{g}\text{s}}$

$NPV={\displaystyle \underset{t=0}{\overset{N}{}}}\frac{C{F}_t}{(1+r{)}^t}$

IRR$=NPV={\displaystyle \underset{t=0}{\overset{N}{}}}\frac{C{F}_t}{(1+r{)}^t}=0$

Solve for the return rate $(r)$

$BCR=\frac{\text{D}\text{i}\text{s}\text{c}\text{o}\text{u}\text{n}\text{t}\text{e}\text{d}\text{V}\text{a}\text{l}\text{u}\text{e}of\text{B}\text{e}\text{n}\text{e}\text{f}\text{i}\text{t}\text{s}}{\text{D}\text{i}\text{s}\text{c}\text{o}\text{u}\text{n}\text{t}\text{e}\text{d}\text{V}\text{a}\text{l}\text{u}\text{e}of\text{C}\text{o}\text{s}\text{t}\text{s}}$

XYZ company is considering multiple projects for the coming year. In addition to the dollar metrics associated with each project, critical decision factors include: how simple the project will be to deploy, how likely the competition is to react$/$respond$,$ and the risk that legislation will impact the project. Of these three risks, XYZ has identified the Risk of Legislation as being twice as important as the other qualitative factors. XYZ company currently operates under a $10\%$ hurdle rate.

Project $1$

Build and deploy a proprietary ERP system in house.

Est cost this year: $$20$ million

Cashflows: $+$$$5$ million

Cashflow Growth year$-$over$-$year: $+0\%/$ year

Useful Life: $6$ years

Ease of Deployment: Low

Competitive Reaction: Low

Risk of Legislation: Moderate Project $2$

Develop and bring to market a new product line.

Est cost this year: $$35$ million

Cashflows: $+$$$4$ million

Cashflow Growth year$-$over$-$year: $+15\%/$ year

Useful Life: $7$ years

Ease of Deployment: Low

Competitive Reaction: High

Risk of Legislation: Moderate

Project $3$

Lean the production system to reduce operational waste.

Est cost this year: $$5$ million

Cashflows: $+$$$2$ million

Cashflow Growth year$-$over$-$year: $-10\%/$ year

Useful Life: $4$ years

Ease of Deployment: High

Competitive Reaction: Moderate

Risk of Legislation: Low Project $4$

Build a new warehouse enabling more efficient logistics$.$

Est cost this year: $$25$ million

Cashflows: $+$$$3$ million

Cashflow Growth year$-$over$-$year: $+5\%/$ year

Useful Life: $12$ years

Ease of Deployment: Moderate

Competitive Reaction: Low

Risk of Legislation: High

Calculate for each project: Payback Period, NPV$,$ IRR, Benefit Cost Ratio. Rank the projects from best to worst investments, economically. Which $($if any$)$ projects would you recommend? Show your work & attach files.