Phase $2$: Part B $($when instructor provides updated template solutions$)$ in each of the three project tabs:

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.

Please help! I am having a really hard time with this. I have already sent this to an expert twice. I need all the answers to all the green, blue, and yellow colored cells for each of the three cities. I also need the answers to part c$.$ Part c has $7$ yes or no questions for each of the three cities. Please help i have to submit in an hour!