You have linked the Capitalized Value in cell D9 into cell F3 and highlighted the appropriate Data Range. You then click “Data Table” under the “What If” analysis. The dialog box requires the Row Input Cell and the Column Input Cell. Assuming you are varying the Rent PSF against the Cap Rate as shown in columns F through K, which of the following cells is the Row Input Cell?

Real Estate Financial Modeling / Questions / You have linked the Capitalized Value in cell D9 into cell F3 and highlighted the appropriate Data Range. You then click “Data Table” under the “What If” analysis. The dialog box requires the Row Input Cell and the Column Input Cell. Assuming you are varying the Rent PSF against the Cap Rate as shown in columns F through K, which of the following cells is the Row Input Cell?

Jun 20