Bascilla, Incorporated is trying to determine the value of several projects. Currently there are four being examined:

Required:

Compute the Net Present Value of each project.

Examine the Internal Rate of Return for each project.

Compute the Profitability Index for all projects.

Use the $)$ function to determine the TVM factors. Be sure to put a $"-"$ sign before the function and for cash out flows, and use $"1"$ as the

PMT and FV amounts as necessary.

Please provide all of the equations required in the yellow cells as well as the solutions.