Skip to main content

How to Run a Sensitivity Analysis

Excel Add-in

Sensitivity Analysis in U-Rite​

U-Rite allows you to sensitize different inputs within your model without manually adjusting assumptions, enabling you to quickly evaluate multiple outcomes. To run a sensitivity analysis in U-Rite, the relevant inputs must be configured within your model and assigned as drivers.

Setting Up a Simple Sensitivity Analysis in U-Rite​

Step 1: Create and Configure Your Model​

  1. Create a Property
    Ensure you add the Property Area.

  2. Create a Tenant
    Add a tenant within your Contractual Lease table.

  3. Set the Unit (Area)
    Define the unit or area associated with the tenant.

  4. Set the Lease Term
    Enter the Start Date and End Date under Term.
    The term can also be set in Years.

  5. Set Base Rent
    Select the appropriate Base Rent methodology and enter the Amount.

  6. Set Tenant Improvements
    Select the Tenant Improvement methodology and enter the Amount.

  7. Save and Run the Model
    Save your changes in U-Rite and click RUN ▶.

Creating a Sensitivity Analysis Table​

Step 2: Prepare the Excel Worksheet​

  1. Open your Property – Cash Flow worksheet.

  2. Locate the Building Cash Flow row.

  3. Select a cell where you want the sensitivity table to appear.

  4. Enter the following formula and set the range to include all values in the Building Cash Flow row:

    =SUM()

Step 3: Define Sensitivity Ranges​

  1. List your Base Rent Amount range in a row beside the Building Cash Flow total.
  2. List your Tenant Improvement Amount range in a column below the Building Cash Flow total.
  3. Place your model’s default value in the center of the row or column.
  4. Apply positive and negative increments (+/-) around the default value to define your scenarios.

Note:
The default value is typically placed at the center of the row or column. You may also choose to separate the default Base Rent Amount and Tenant Improvement Amount from the table.

Linking Inputs to U-Rite​

  1. Link Base Rent Amount

    • Press Ctrl = in the Base Rent cell.
    • Select the Excel input cell for the Base Rent Amount.

  2. Link Tenant Improvement Amount

    • Press Ctrl = in the Tenant Improvement cell.
    • Select the Excel input cell for the Tenant Improvement Amount.

Running the Sensitivity Analysis​

Step 5: Execute the Analysis​

  1. Highlight the entire sensitivity table, including:

    • Base Rent Amounts
    • Tenant Improvement Amounts
    • Building Cash Flow total

  2. In the U-Rite ribbon, click Sensitivity Analysis.

  3. Assign the inputs:

    • Row Input Cell: Base Rent Amount
    • Column Input Cell: Tenant Improvement Amount

  4. Run the analysis.

Styling and Formatting​

After the analysis is complete, you may apply:

  • Comma Style formatting for readability
  • Conditional Formatting to highlight trends and outcomes
  • Any additional formatting needed for presentation or reporting purposes