Answer all theses $4$ questions and use table like that to each question and explain each step.

Assignment Questions

Evaluate the two investment options, Project A and Project B$,$ based on the provided financial data and recommend the most suitable project for the company. Please note that the cutoff period is $3$ years and the opportunity cost of capital is $12\%.$

$\backslash$table$[[$Year$,$Cash flows $($$$)$ Project A$,$Cash flows $($$$)$ Project B$],[0,100,000,100,000],[1,30,000,49,000],[2,50,000,49,000],[3,70,000,49,000]]$

Using the Payback, Discounted Payback:

$2$:Use NPV

$3.,$ MIRR and PI$.$

$4.$Which project would you choose according to each model and Why?

$\backslash$table$[[$year$,\backslash$table$[[$Cash flow$],[F_r$