Spreadsheet: 80368d1280531142-how-to-apply-a-combination-of-index-and-match-functions-template-test
Sheet: Sheet1

 |  | ENTER COMP # IN YOUR SALES HERE | 1
General Data
 | Property Name: |  | XYZ
 | Property Address: |  | XYZ
 | Cross Streets: |  | XYZ
 | City/Township: |  | XYZ
 | County: |  | Oakland
 | State: |  | Michigan
 | Parcel ID(s): |  | 188 parcels
Building Data
 | Property Type: |  | Flats
 | MVS Classification: |  | Class D
 | Gross Building Area: |  | n/a
 | Living Area: |  | 192450
 | Total Units |  | 188
 | Average Unit [NAME] |  | 1024
 | Year Built: |  | 1988
 | Effective Age |  | 20
 | Stories: |  | Two
 | Laundry (Central, In-Unit, Hook-ups, or any combo) |  | Hook-ups
 | Project Amenities (Clubhouse, pool, tennis, fitness, etc):
 |  | Pool | Yes
 |  | [NAME] | Yes
 |  | Walking Trails | No
 |  | Tennis Court(s) | No
 |  | Basketball Court(s) | No
 |  | Volleyball Area(s) | No
 |  | Park Area(s) | No
 |  | Lake/Pond Area(s) | Yes
 |  | Car Care Area (Wash/Vacuum) | No
 |  | Gated Entry | No
 |  | Security Patrol | No
 |  | Dedicated Clubhouse Building | Yes
 |  | Fitness Center | Yes
 |  | Comp./Business Center | No
 |  | Sauna | No
 |  | Spa | No
 |  | Locker/Changing Rms | No
 |  | Lounge Areas | No
 |  | Bar/Kitchen Area | No
 |  | Billiards/Game Room | No
 |  | Concierge Services | No
 |  | Other | n/a
 | Community Type (Market Rate, Section 8, Senior, etc.): |  | Market Rate
 | Deferred Maintenance: |  | None noted
Unit Mix
 | Studio |  | 0
 | 1-Bedroom |  | 67
 | 2-Bedroom |  | 104
 | 3-Bedroom |  | 17
 | 4-Bedroom
Site Information
 | Land Area (Acres): |  | 25.12
 | Zoning: |  | Multi-Family
 | Shape: |  | Irregular
 | Ingress/Egress: |  | Adequate
 | Easements: |  | Typical utility easements
 | Excess Land: |  | None noted
 | Parking Area (surface, garage, carport, etc): |  | Surface, Carports
 | Deferred Maintenance: |  | None noted
Transaction Information
 | Sale Date: |  | 2008-12-01 00:00:00
 | Sale Price: |  | 9400000
 | Sale Price Adjustments (Def. Maint, Concessions, etc.) |  | 0
 | Grantor |  | XYZ
 | Grantee |  | XyZ
 | Occupancy at Time of Sale: |  | 0.8
 | Gross Potential Income |  | 2210656
 | Vacancy & Collection Loss |  | 448820
 | Effective Gross Income |  | 1761836
 | Operating Expenses |  | 982048
 | Net Operating Income |  | 779788
 | Capitalization Rate: |  | 0.08295617021276595
 | Do Operating Expenses Include Mgt Fee & Reserve: |  | Yes
 | Number of Employee Units |  | n/a
 | Property Rights |  | Fee Simple
 | Buyer Investment Criteria: |  | n/a
 | Financing (New Mortgage, [NAME], Etc.): |  | New Mortgage
 | Sale Terms (Cash Equiv. Land Contract, Etc.) |  | Cash Equivalent
 | Conditions of Sale (Arm's Length, Etc.) |  | Arm's-Length
 | 1031 Exchange: |  | n/a
 | Bank Owned Property: |  | No
Document Check List
 | Public Record Card/Assessor Field Sheet
 | Warranty Deed
 | Property Transfer Affidavit
 | Property Photograph
 | Property Aerial View
 | Plat Map Image
Verification
 | Source:
 | Source Contact Number:
 | Source Relationship (Broker, [NAME], etc.): |  | Broker
 | Verification Date:
Comment Section of Write-up |  |  | This comparable represents the sale of 188 units.  The overall development included 230 units, but 42 units were sold as condominiums.  The 188 units noted in this transaction were each identified by an individual parcel identification number.  The buyer intended to operate the units as apartments.  Interviews with the broker indicate no notable deferred maintenance other than typical painting and minor asphalt repairs.  The broker reported that there were a few units that had been updated prior to the sale (cabinets, etc.).  The overall development was reportedly acquired in 2004 by BR Meadowbrook for $15.2 million with the intention of condominium conversion.