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.
This exercise is part of the course
Financial Analysis in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
