\begin{tabular}{|r|r|r|} \hline & \multicolumn{2}{|c|}{ Cash flow (\$) } \\ \hline Year & Project A & Project B \\ \hline 0 & (250,000) & (250,000) \\ \hline 1 & 82,000 & 5,000 \\ \hline 2 & 88,000 & 22,000 \\ \hline 3 & 83,000 & 30,000 \\ \hline 4 & 79,000 & 62,000 \\ \hline 5 & 10,000 & 115,000 \\ \hline 6 & 20,000 & 137,000 \\ \hline 7 & 10,000 & 152,000 \\ \hline \end{tabular} 1. If required rate is 12.5%, what is NPV for each project. 2. Calculate IRR for each project 3. Calculate crossover Point of the two projects. 4. Calculate pay back period for each project 5. Based on the above results, Which project should the company choose? (Suppose the company can only choose one project) Explain. (please use excel functions to calculate NRV,IRR and Crossover point) Please show the details of your calculation including the excel functions you used