Depends how much effort you want to spend on this.
Since you don't have the PMO accelerator I doubt the reports which come with Clarity (jaspersoft/BO) will work correctly without this installed.
couple of easy options
1. use the "Investment" view, add rank and above waterline into the columns. Export this to excel manually
2. Build a query and package that up in crystal or nsql - export out as excel
3. Buy a ready to go report off a partner