Spreadsheet: 88414d1288242129-combining-index-and-match-functions-sample
Sheet: Sheet2

Estimate of Market Rent |  |  |  |  |  |  |  |  |  |  |  |  | U.S. Department of Housing and Urban Development |  |  |  |  |  |  |  |  |  |  | OMB Approval No. 2502-0507
 |  |  |  |  |  |  |  |  |  |  |  |  | Office of Housing |  |  |  |  |  |  |  |  |  |  |  | (exp. 7/31/2001)
by Comparison
 |  |  |  |  |  |  |  |  |  |  |  |  | Federal Housing Commissioner
Public reporting burden for this collection of information is estimated to average 1 hour per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. This information is required by the Housing Appropriation Act of 9/28/1994. The information is needed to analyze the reasonableness of the Annual Adjustment Factor formula, and will be used where rent levels for a specific unit type, in a Substantial Rehabilitation or New Construction Contract, exceed the existing FMR rent. The information is considered nonsensitive and does not require special protection. This agency may not collect this information, and you are not required to complete this form, unless it displays a currently valid OMB control number.
1. Unit Type | 2. Subject Property (Address) |  |  |  | A. Comparable Property No. 1 (address) |  |  |  |  | B. Comparable Property No. 2 (address) |  |  |  |  | C. Comparable Property No. 3 (address) |  |  |  |  | D. Comparable Property No. 4 (address) |  |  |  |  | E. Comparable Property No. 5 (address)
A | Sample Apartments |  |  |  | ABC |  |  |  |  | EEE
1-bed/1.0-bath | Rochester |  |  |  | Canton |  |  |  |  | Detroit
Characteristics |  | Data |  |  | Data |  |  | Adjustments |  | Data |  |  | Adjustments |  | Data |  |  | Adjustments |  | Data |  |  | Adjustments |  | Data |  |  | Adjustments
 |  |  |  |  |  |  |  | - | + |  |  |  | - | + |  |  |  | - | + |  |  |  | - | + |  |  |  | - | +
3.   Effective Date of Rental |  | 2010-10-21 00:00:00 |  |  | 2010-10-01 00:00:00 |  |  |  |  | 2010-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Rental Analysis |  |  | 1 | comparable 1
4.   Type of Project/Stories |  | Flat |  |  | Townhome |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Development |  |  | 2 | comparable 2
5.   Floor of Unit in Building |  | First |  |  | First |  |  |  |  | First |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | City/Township |  |  | 3 | comparable 3
6.   Project Occupancy % |  | 1 |  |  | 0.9333333333333333 |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  |  | 0.9333333333333333 |  |  |  |  | 0.9333333333333333 |  |  |  |  |  |  | [NAME] |  |  | 4 | comparable 4
 |  |  |  |  | 750 |  | 700 |  |  | 0 |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ba. Range Type |  |  | 5 | comparable 5
7.   Concessions |  | --- |  |  | Reduced Rent |  |  | 50 |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ha. Drapes
8.   Year Built |  | 1975 |  |  | 1980 |  |  |  |  | 1990 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aa. Heat Included
9.   Sq. Ft. Area |  | 600 |  |  | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ba. Cooking Included
10.  Number of Bedrooms |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | da. Hot Water
11.  Number of Baths |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Survey Date
12.  Number of Rooms |  | 5 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Style (Flat, Townhome, Etc.)
13.  Balc./Terrace/Patio |  | Yes |  |  | Yes |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Occupancy Rate
14.  Garage or Carport |  | Carport | / | 5 | Surface | / | 0 |  |  | Carport | / | 0 |  |  |  | / |  |  |  |  | / |  |  |  |  | / |  |  |  |  |  | Year Built
15.  Equipment | a. A/C | None |  |  | Central |  |  |  |  | Wall |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balc./Terrace/Patio
 | b. Range/Oven | Yes | / | Elec | Yes | / | Gas |  |  | Yes | / | Elec |  |  |  | / |  |  |  |  | / |  |  |  |  | / |  |  |  |  |  | Garage/Carport
 | c. Refrigerator | Yes |  |  | Yes |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Garage/Carport Fee
 | d. Disposal | 0 |  |  | Yes |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | e. Microwave | 0 |  |  | Yes |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Range/Oven
 | [NAME] | 0 |  |  | No |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Range/Oven Fuel
 | [NAME] | In Unit |  |  | Central |  |  |  |  | In Unit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Refrigerator
 | h. Carpet/Drapes | Yes | / | Blinds | Yes | / | Blinds |  |  | Yes | / | Drapes |  |  |  | / |  |  |  |  | / |  |  |  |  | / |  |  |  |  |  | Disposal
 | I. Pool/Rec. Area | [NAME] |  |  | See Narrative |  |  |  |  | See Narrative |  |  |  |  | See Narrative |  |  |  |  | See Narrative |  |  |  |  | See Narrative |  |  |  |  |  |  | Microwave
16.   Services | a. Heat/Type | Gas | / | No | Central | / | Gas |  |  | Central | / | Gas |  |  |  | / |  |  |  |  | / |  |  |  |  | / |  |  |  |  |  | Dishwasher
 | [NAME] | Elec | / | No | No | / | Gas |  |  | No | / | Elec |  |  |  | / |  |  |  |  | / |  |  |  |  | / |  |  |  |  |  | Carpet
 | c. Electricity | No |  |  | No |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Window Treatments
 | d. Water Cold/Hot | Yes | / | No | Yes | / | No |  |  | Yes | / | No |  |  |  | / |  |  |  |  | / |  |  |  |  | / |  |  |  |  |  | Washer/Dryer
17.   Storage |  | Average |  |  | Average |  |  |  |  | Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heating Source
18.   Project Location |  | Average |  |  | Average |  |  |  |  | Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heating Fuel
19.   Community Quality |  | Average |  |  | Average |  |  |  |  | Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cooking
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electricity
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cold Water
20.  Unit Rent per Month |  |  |  |  | 750 |  |  |  |  |  |  |  |  |  | 750 |  |  |  |  | 750 |  |  |  |  |  |  |  |  |  |  |  | Hot Water
21.  Total Adjustment |  |  |  |  |  |  |  | -50 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | Storage
22.  Indicated Rent |  |  |  |  | 700 |  |  |  |  | 0 |  |  |  |  | 750 |  |  |  |  | 750 |  |  |  |  | 0 |  |  |  |  |  |  | Project Location
23.  Correlated Subject Rent |  |  |  |  | □ If there are any remarks, check here and add the remarks to the back of page. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Condition & Quality of Community
 |  | high rent |  |  | 750 |  |  | low rent |  | 0 |  |  | 60% range |  |  |  |  | 150 |  | to | -600 |  |  |  |  |  |  |  |  |  |  | Size
Note: In the adjustments column, enter dollar amounts by which subject property varies from comparable properties. If subject is better, enter a “Plus” amount and if subject is inferior to the comparable, enter a “Minus” amount. Use back of page to explain adjustments as needed. |  |  |  |  |  |  |  | Appraiser's Signature |  |  |  |  |  |  |  |  | Date (mm/dd/yyyy) | Reviewer's Signature |  |  |  |  |  |  |  |  |  |  | Date (mm/dd/yyyy) |  |  | Beds
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Baths
Previous editions are obsolete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | form HUD-92273 (3/95) |  |  | Unit Style
 |  |  |  |  |  |  |  | 50 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  | Special
 |  |  |  |  |  |  |  | -50 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | Overall Project Location Rating
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overall Community Quality Rating
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Market