The analysis below (chart #1) shows what the IRR is at a 6.75% Cap Rate and a
$4.60 Rental Rate. The IRR was derived from a long formula of inputs (note
Cap Rate and Rental Rate were both one of the inputs). I need to create a
sensitivity (what if) analysis table showing what happens to the IRR if the
Cap Rate and/or Rental Rate is increased (see chart #2). Any recommendations
on how I can do this?


#1) Cap Rate 6.750%
_________
Rental |IRR
$4.60 |29.71%


#2) Cap Rate 6.750% 7.000%
_____________________________
Rental |IRR IRR
$4.60 |29.71% 25.14%
$4.70 |32.44% 27.86%