_{Formulas please.}

Calculate the net present value, payback period, modified internal rate of return (3 methods), profitability index of proposed projects. Fill in the table highlighted in yellow and enter your name and ID. After each calculated figure, indicate whether the project should be accepted or rejected based on the received data. In the last cell highlighted in red, give a general conclusion on the project and justify your decision. Year 0 Year 1 -218.6 Year 2 68.4 Year 3 88.4 Year 4 47.4 Year 5 43.4 Year 6 78.4 R -51.6 11.2% NPV accept/rejec PBP accept/rejec MIRR 1 accept/rejec MIRR 2 accept/rejec MIRR 3 accept/rejec PI accept/reject Conclusion Calculate the net present value, payback period, modified internal rate of return (3 methods), profitability index of proposed projects. Fill in the table highlighted in yellow and enter your name and ID. After each calculated figure, indicate whether the project should be accepted or rejected based on the received data. In the last cell highlighted in red, give a general conclusion on the project and justify your decision. Year 0 Year 1 -218.6 Year 2 68.4 Year 3 88.4 Year 4 47.4 Year 5 43.4 Year 6 78.4 R -51.6 11.2% NPV accept/rejec PBP accept/rejec MIRR 1 accept/rejec MIRR 2 accept/rejec MIRR 3 accept/rejec PI accept/reject Conclusion