Table of Contents

1. Loading the HUD 92273 Standard Module
2. Completing the Forms

Prerequisites

What Gets Loaded

Loading the module adds three new worksheets to your Workbook, one for each valuation scenario:

Each sheet contains five forms, allowing you to present up to five unit types within that scenario. You do not need to use all five forms, unused forms can be left blank or removed from your Valcre Report. 

Step 1: Select the unit type to be presented 

At the top of each form, you will see a row of dropdown selectors: One for your Subject and one for each comparable. Use these to select which unit type you are analysing in this form.

1a. Select the unit type to be pulled in for your Subject
1b. Select the unit type to be pulled in for each of your comps

This will populate the forms with the Subject and Survey Comparable data that corresponds to the unit type you will be presenting.

Note: This data will come from your SURVEY1 sheet, so it is important to import your comps there first. 

Step 2: Review Auto-Populated Fields

After selecting your unit types, review the fields that have populated from your SURVEY data. Confirm that the following pulled in correctly.

If any of this data looks incorrect, check the source data on your SURVEY sheet and correct it there before continuing.

Step 3:  Complete Fields Requiring Manual Entry

Not all fields auto-populate. The following fields require manual entry or a dropdown selection directly in the form. Look for fields with a drop-down arrow or that appear blank after the unit types are selected. These require your input.
Note: If you have not filled out Project Amenities, Unit Amenities, or Included Utilities in Valcre Online, the formulas will return "N" as the default value.

Step 4: Enter Adjustments

The yellow-shaded columns in the form are the Adjustments columns. Use these to enter dollar adjustments to each comparable for relevant differences from the subject.

4a. Click into a yellow-shaded cell in the row for the characteristic you are adjusting. 4b. Enter a positive adjustment if the comp is inferior to the subject on that characteristic. 4c. Enter a negative adjustment using the "-" symbol if the comp is superior to the subject on that characteristic. IE: Type -5, not 5.
Pro Tip: Total adjustments are calculated automatically at the bottom of the adjustments section. Review these totals before finalizing to ensure they are reasonable relative to the unadjusted rents.

Step 5: Add Additional Comparable Characteristics (Optional)

At the bottom of the main comparison grid, there are additional rows you can use to document characteristics not already included in the standard form layout.

You have two options for completing these rows:

• Type the characteristic name and data directly into the cells for each comparable.
• Use the dropdowns located to the right of the table to pull in characteristics that have already been entered for your comps in Valcre Online. This is faster and reduces the chance of typos.

Note: These additional rows are optional. Leave them blank or hide the rows (do not delete) if you do not have characteristics beyond the standard fields to document. 

Step 6: Review Rents, Adjustments, and Remarks

At the bottom of each form, review the following before finalizing:

• Unadjusted contract rents for each comparable
• Total adjustments per comparable (calculated automatically)
• Adjusted rents per comparable (calculated automatically)
• Concluded market rent for the subject unit type

If you will be including written remarks to support your adjustments or conclusions, check the Remarks checkbox at the bottom of the form. This signals that remarks are expected and ensures they are included when the form is linked to your Valcre Report.

Step 7: Add Appraiser and Reviewer Signatures

The final section of each form requires the Appraiser’s Signature and the Reviewer’s Signature.

7a. Navigate to the HOME sheet in your Workbook, where signatures are stored. 7b. Copy the Appraiser Signature from the HOME sheet. 7c. Return to the HUD 92273 form and paste the signature into the Appraiser’s Signature field.
Pro Tip: The HOME sheet stores your firm’s saved signatures. Using copy-paste from there ensures consistency across all forms and avoids re-entering signature data manually.

Step 8: Complete Additional Unit Type Forms (If Applicable)

If your subject property has more than one unit type to analyze, scroll down on the same worksheet to find the next form. Each worksheet contains five forms in sequence.

Repeat Steps 1 through 7 for each additional unit type you need to present.