Investment analysis spreadsheet

[Si Marlow]

Hi all - it's been a while since I posted. Hope everyone is well!

I've been looking at opportunities from investment firms like Open Door Capital, et al, and I would like to know if anybody has a recommendation for a spreadsheet or tool for analyzing these deals?

I want to either build a spreadsheet or download/buy one that allows me to review what things such as Projected AAR, Projected Avg CoC, Exit IRR, etc, actually mean to the bottom-line.

I work in comp so I have no issues building my own but I'd prefer to simply use one that's already created.

Finally, aside from reviewing prior projects on the company's website and scouring the internet for reviews, does anyone have any tips on how to select a given company?

Thanks all!