show how to do it on excel.

5 Link below to two-way sensitivity analysis indicating the best and worst case After-Tax MIRR of the investment opportunity with a terminal cap rate alternatively assumed be 6%,7.5%, or 9%, and growth in potential gross income from 0 to 6% holding other factors constant. Note you will need to change terminal cap rates on sensitivity tables from example. 5 Link below to two-way sensitivity analysis indicating the best and worst case After-Tax MIRR of the investment opportunity with a terminal cap rate alternatively assumed be 6%,7.5%, or 9%, and growth in potential gross income from 0 to 6% holding other factors constant. Note you will need to change terminal cap rates on sensitivity tables from example