The best index is a profitable one

Continue to work on the SPEND dashboard and think about how to format the visuals nicely.

The profitability index (PI) turns NPV into a ratio by dividing NPV by the initial investment amount. This is useful for understanding the rate of return of the project.

The CFO is interested in what the PI is for the two projects SPEND is considering, and they want you to add this in your dashboard for the projects.

If you have lost progress, close any open workbooks and load 4_2_profitability_index.pbix from the Exercises folder on the Desktop.