Hi
I can't find any information on how to do this other than through some sort of goal-seek. Ideally I'd like a formula-based solution, if one exists.
Basically I need to 'reverse-engineer' the NPV calculation to find the rate. I've illustrated my problem in the image below (I'm trying to find...