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

 | ENTER COMP # IN YOUR SALES HERE | 1
General Data
Develoment Name: |  | XYZ
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.