Technical Interview Question
I went in for a Real Estate PE Interview for an associate role and was asked create my own underwriting model and compute various metrics (ie leverage IRR, GRM, Equity Multiple, etc). 

I didn't know how to do one of the sections and am still trying to figure it out.

I was asked to create a levered IRR sensitivity data table by changing the exit cap rate 25bps.

Would greatly appreciate any tips on how to be able do so.
[{"id": "ej2a6ur", "text": "The IRR matrix shouldn\u2019t be that difficult, I\u2019ll see if I can share anything when I get home", "replies": [{"id": "ej2ml09", "text": "I would really appreciate that. ", "replies": [], "depth": 2}], "depth": 1}, {"id": "ej2a6yp", "text": "Hello! It's a what-if analysis question which has the option for data tables :).\n\n&amp;#x200B;\n\nSo you would have your cap rate as the independent variable (the thing you change) and then you would have your IRR as the dependent variable. Suggest you look up excel data tables on google and it should point you in the right direction.\n\n&amp;#x200B;\n\nbest of luck in your interview!", "replies": [], "depth": 1}, {"id": "ej2tyq3", "text": "On the same tab as the exit cap rate variable\n\nUpper left, = exit cap, one cell to right = leverred irr\n\nBelow upper left, do all the cap rates you wanna test, eg 5.5.25,5.5. Do not link those to the real cap rate ie hardcode. Then select the future table, and data, whatif analysis, data table, first input nothing second input = exit cap variable. \n\nBoom. Save, re open and itll work. ", "replies": [{"id": "ej3k5k8", "text": "This guy excels.", "replies": [], "depth": 2}], "depth": 1}]