Spreadsheet: 80866d1281031520-combining-match-and-index-functions-test
Sheet: 45.1

Operating Expense Analysis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U.S. Department of Housing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMB Approval No. 2502-0331
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and Urban Development |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (exp. 4/30/2006)
Worksheet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Office of Housing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Federal Housing Commissioner
See Instructions on back and [NAME] to Handbook
4480.1 for details on completing this form.
Public reporting burden for this collection of information is estimated to average 16 hours 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 agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless that collecton displays a valid OMB control number.
This information is being collected under Public Law 101-625 which requires the Department of to implement a system for mortgage insurance for mortgages insured under Sections 207,221,223,232, or 241 of the National Housing Act. The information will be used by HUD to approve rents, property appraisals, and mortgage amounts, and to execute a firm commitment. Confidentiality to respondents is ensured if it would result in competitive harm in accord with the Freedom of Information Act (FOIA) provisions or if it could impact on the ability of the Department’s mission to provide housing units under the various Sections of the Housing legislation. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: Only green cells are for input
Project Name |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Set this cell to 0 to turn off green for printing
City |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date of Appraisal (mm/dd/yyyy) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Signature of Processor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signature of Reviewer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date (mm/dd/yyyy)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Project Name |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | t |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Project Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Location |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Type of Project & |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
No. of Stories
Type of Construction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Walk-up |  |  |  |  |  |  |  |  |  |  |  | Walk-up |  |  |  |  |  |  |  |  |  |  |  |  |  | LINE REQUIRES MANUAL ENTRY
No. of Living Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Age of Project |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Project Unit |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM |  |  | BRM
Composition |  |  | ( | 0 | ) | ( | 1 | ) | ( | 2 | ) | ( | 3 | ) | ( | 0 | ) | ( | 1 | ) | ( | 2 | ) | ( | 3 | ) | ( | 0 | ) | ( | 1 | ) | ( | 2 | ) | ( | 3 | ) | ( | 0 | ) | ( | 1 | ) | ( | 2 | ) | ( | 3 | ) | ( | 0 | ) | ( | 1 | ) | ( | 2 | ) | ( | 3 | )
No. of Each Type Unit |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
Sq. Ft. Each Type Unit |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
Average Unit Area |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
Same Tax Rate as |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
Subject *
Same Utility Rate * |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comp 2 |  | Comp 4
Effective Date/Updating |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  | 0.025 |  | 0.025 |  | #N/A | #N/A | #N/A
Operating Yr./Percentage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  | 0.025 |  | 0.025
Equip. & Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REQUIRES MANUAL DATA ENTRY
Incl. Rent **
Equipment Included in Rent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Services Included in Rent
1 | Ranges & Refrig. |  | 2 |  | Carpet & Drapes |  |  |  |  |  |  |  | 3 |  | Disposal |  |  |  |  |  |  | Gas |  |  |  |  |  | 10 |  | Heat |  |  |  | 11 |  | Cooking |  |  |  |  |  | 12 |  | Hot Water |  |  |  |  |  | 13 |  | A/C
4 | Dishwasher |  | 5 |  | Laundry Fac. |  |  |  |  |  |  |  | 6 |  | Air Cond. |  |  |  |  |  |  | Elec. |  |  |  |  |  | 14 |  | Heat |  |  |  | 15 |  | Cooking |  |  |  |  |  | 16 |  | Hot Water |  |  |  |  |  | 17 |  | A/C |  |  |  | 18 |  | Lights
7 | Microwave |  | 8 |  | Pool/Tennis |  |  |  |  |  |  |  | 9 |  | Other |  |  |  |  |  |  | Other Fuel |  |  |  |  |  | 19 |  | Heat |  |  |  | 20 |  | Hot Water |  |  |  |  |  | 21 |  | Water |  |  |  |  |  | 22 |  | Other
Items of Expense by Units of Comparison *** |  |  | Exp. |  |  |  | Adj. +      – |  |  |  | Ind. Exp. |  |  |  | Exp. |  |  | Up- dated Exp. |  |  | Adj. +   – |  |  | Ind. Exp. |  |  | Exp. |  |  | Up- dated Exp. |  |  | Adj. +   – |  |  | Ind. Exp. |  |  | Exp. |  |  | Up- dated Exp. |  |  | Adj. +   – |  |  | Ind. Exp. |  |  | Correlated Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dated |  |  |  |  |  |  |  |  |  |  |  | dated |  |  |  |  |  |  |  |  |  |  |  | dated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exp. |  |  |  |  |  |  |  |  |  |  |  | Exp. |  |  |  |  |  |  |  |  |  |  |  | Exp.
1. Advertising |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2. Management |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
3. Other |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
4. Total Admin. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
5. Elevator |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
6. Fuel |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7. Lighting & |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Misc. Power
8. Water |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
9. Gas |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
10. Garbage & Trash |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Removal
11. Payroll |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
12. Other |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
13. Total Operating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | form HUD-92274 (05/2003)
Previous editions are obsolete
 |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A
 |  |  | #N/A |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  |  |  |  |  | #N/A