Thanks for the advice. File attached. Because this is a fairly complex model, I've stripped the naming after it but have otherwise attached the entire thing. Sensitivity tables are located on the Input tab at the very bottom. Calculated Equity Partner IRR (output) can be found in cell B108 on the Cash Flow tab but I've linked it to the Input tab as well. Other than that, all variable inputs can be found on the Input tab and have been highlighted in yellow for ease. As one can see, the "base case" IRR is only calculating correctly for the first table. All others are off.
Bookmarks