I have a simple real estate investment model that solves for an IRR. I would like to sensitize the IRR (cell C16) for changes in year 1 rent (cell D3) by using a data table.
Is there any way to link the independent variable (cell B24) to the original input (cell D3) so that I don't have to hard code the data table y axis? In other words I want my data table y axis to update automatically when I change cell D3. Linking cell B24 to cell D3 seems to prevent the data table from calculating. I am forced to calculate the data table with a hard coded value (cell F24). This is causing me issues in more complex models with multiple inputs, more complex calculations and multiple data tables.
Bookmarks