Enter the Excel calculation $/$ formula in the green cells:

E$14$ Net Present Value

E$18$ Internal Rate of Return

E$19$ Modified Internal Rate of Return

Enter the Excel calculation in the yellow cells:

E$17$ Average Accounting Return

E$20$ Profitability Index

Enter your calculated value from your TI Business Analyst app or calculator in the blue cells:

E$15$ Payback Period

E$16$ Discounted Payback Period

Note there exists multiple ways to do most of the calculations. You will receive credit if you have a valid, alternate

calculation for any of the cells. If you use an alternate calculation solution, you must attach detailed documentation

showing your step$-$by$-$step solution.

Phase $2$: PART C

The instructor will provide you with an updated template.

Complete the Part C tab, blue cells.

Determine if you could use only the selected tool $($for each project$)$ would you accept the project.

Using the updated, provided Excel Template select "Part C$"$ tab.

Do not copy data from another worksheet, or from another cell in this Template.

Do not change the format of any cell.

Place an $\text{'}x\text{'}$ in the proper box for each tool for each project. $21$ gray cell boxes in all.

Would you accept based on your calculation of this tool?

Place an $\text{'}$X$\text{'}$ in the proper box.

Do this for all three projects.

I need to know the answers for all the green,yellow,and blue cells. I also need to know the formulas used in each cell. Thank you!