Table of Contents

• Loading the HUD 92274 Module
• Completing the HUD 92274 Form
• Troubleshooting

Prerequisites

Step 1:  Configure HUD Category Names on the IE_IN Sheet

The IE_IN sheet is where your subject property’s income and expense data lives. By default, it may be set to use a non-HUD expense category structure. You need to switch it to HUD categories before loading the module.

1a. Navigate to the IE_IN sheet in your Workbook. 1b. Locate the category name dropdowns at the top of the sheet. These control which expense category naming convention is used throughout the sheet. 1c. Click the dropdown and select HUD from the list of available options.

Step 2:  Import Expense Comparables to the EXPCMP Sheet

The EXPCMP sheet is where your expense comparable data lives. If you have not already imported expense comps, do so now.

Step 3: Align Expense Category Dropdowns on EXPCMP

After importing your expense comps, you need to update the expense category dropdowns on the EXPCMP sheet to match the HUD category names you set in Setup Step 1. This alignment is what allows the form to correctly map each comparable’s expense data into the right rows.

3a. On the EXPCMP sheet, scroll down to the Expense Comparables Input table. 3b. For each expense category row, click the dropdown in the Category column. 3c. Select the corresponding HUD category name from the list. These names should match what is now showing on the IE_IN sheet. Important: If the expense categories on EXPCMP do not match the HUD category names on IE_IN, the form will either leave rows blank or map expense data to the wrong categories. Take care to match the names exactly as they appear on the IE_IN sheet after switching to HUD categories.

Pro Tip: The category dropdowns on EXPCMP are populated from the IE_IN sheet dynamically. Once you set IE_IN to HUD categories in Setup Step 1, those same names become available in the EXPCMP dropdowns. You do not need to type them manually.

Step 1: Review Subject Property Information

At the top of the form, subject property information will auto-populate from your Workbook setup. 

If any of this information is incorrect, it must be corrected at the source (typically the HOME sheet or Workbook setup) rather than edited directly on the form.

Step 2: Enter the HUD Project Number

Locate the Project Number field near the top of the form and enter the subject property’s HUD Project Number manually. This field does not auto-populate.

Step 3: Add Signatures

Near the top of the form, add the Appraiser’s Signature and Reviewer’s Signature in the designated fields.

3a. Navigate to the HOME sheet in your Workbook. 3b. Copy the Appraiser Signature from the HOME sheet. 3c. Return to the HUD92274 worksheet and paste the signature into the Appraiser’s Signature field..
Pro Tip: Your firm’s saved signatures are stored on the HOME sheet for consistent reuse across all HUD forms. Always copy from there rather than entering signatures manually.

Step 4: Review Auto-Populated Fields and Complete Manual Fields

Work through the main body of the form. Most subject property expense data will have populated from the DIRECTCAP sheet, using the conclusions made on the IE_CONC sheet. Review each section to confirm the data is correct, and complete any fields that require manual entry.

Note: Not all fields auto-populate. Look for blank fields and fields with drop-down arrows as you work through the form. Tab through the form systematically to avoid missing any required entries.

Step 5: Review Expense Comparable Data and Enter Adjustments

The lower section of the form displays expense data for your expense comparables, pulled from the EXPCMP sheet. This is where you document how the comparables’ expenses compare to the subject and support your concluded expense estimates

5a. Review each comparable’s expense data as it has populated. Confirm the figures and category labels look correct. 5b. If any comparable’s categories do not match the HUD categories on the form, return to the EXPCMP sheet and correct the category dropdown selections (see Setup Step 3). 5c. In the Adjustments columns, enter any dollar adjustments needed to reflect differences between each comparable and the subject. 5d. Use the HUD category dropdowns to the left of the expense table to update which category is displayed in a given row, if needed.