Spreadsheet: phillip_allen__28910__version 2_20
Sheet: UCost Final

 | Construction Management Fee |  |  |  |  |  |  |  | 1.1 | SM134Units | 134 | Perimeter [NAME] |  |  | [NAME] First Flr |  |  |  |  |  | 3BGarage
 | Total Rental Units |  |  |  |  |  |  |  | 14 | Const Profit | 0.22 | Int. Courtyard |  |  | ThreeBdrm First Flr |  |  |  |  |  | Adj2B | 91
FAB L# | Construction Sequence |  |  |  |  |  |  |  | Phase Totals |  |  | Pool |  |  | MgrOffFirstFlr |  |  |  |  |  | ADj3B | 74
 |  |  |  |  |  |  |  |  |  |  |  | Vollyball & Basketball
 | CATEGORIES |  |  |  |  |  |  |  | Mgr's Unit, Office & Tech Center |  |  | PLAN 1016 |  |  | PLAN 1213 |  |  | TOTALS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROJECT TOTALS | Per Rental
 | Description |  |  |  |  |  |  |  | Totals | Per Unit | Per SF | Totals | Per Unit | Per SF | Totals | Per Unit | Per SF |  | Unit | SF | % Cost | % Value |  |  | Estimate Totals | Per Unit | Per A/C SF
 | MIX  Rentable Units |  |  |  |  |  |  |  | 1 |  |  |  | 72 |  |  | 61
 | MIX  All Units |  |  |  |  |  |  |  |  |  |  |  | 73 |  |  | 61
 | MIX - %
 | Heated/Total SF
 | Baths/Stories/Garages |  |  |  |  |  |  |  |  |  |  |  | 2.5/2/0 |  |  | 3.5/2/1.5
L#1 | Permits | 0.87 | SF
L#2 | Architecture
 | Foundation Design | 0.15 | SF
L#35 | Builder's Risk |  | SF/YR
L#4 | Temp Electic & Utilities | 88 | Unit
L#4 | Sitework
 | FOUNDATION | 5.5 | SF
L#5 | Setup
L#5 | Concrete
L#5 | Finish
 | PLUMBING
L#6 | Rough
L#17 | Top Out
L#17 | Set Out
 | FRAMING LABOR |  | SF
L#7 | 1st [NAME] | 0.88
L#7 | 2nd [NAME] | 0.88
L#7 | Roof-Decking-Subfascia | 0.35
L#9 | Cornice | 1.29
 | FRAMING MATERIALS
L#7 | Trusses - Roof | 2.37 | SF
L#7 | [NAME] | 2.12 | SF
L#7 | 1st [NAME] |  | SF
L#7 | 2nd Floor Materials |  | SF
L#7 | Roof System Materials |  | SF
L#9 | Cornice Materials |  | SF
L#10 | Windows |  | LS
L#7 | Exterior Doors |  | LS
 | MASONRY/SIDING | Assume Stone & Stucco Same Price.
[NAME] | Materials | 2 | SF
[NAME] | Labor | 3.5 | SF
 | ROOFING
L#8 | Materials | 23.5 | SQ
L#8 | Labor | 21 | SQ
 | ELECTRIC | 2.25 | SF
L#12 | Temp Set | 10000 | LS
L#12 | Rough | 0.6
L#36 | Trim | 0.4
 | PREWIRE | 200 | Unit
L#36 | Rough
L#36 | Trim
 | HVAC
L#13 | Rough | 1.17 | SF
L#14 | Set | 1.17 | SF
L#15&16 | INSULATION | 0.85 | SF
L#20 | SHEETROCK | 3 | SF
L#20 | Stock | 0.33
L#20 | Hang, Tape, Float & Texture | 0.67
L#21 | GARAGE DOORS | 365 | Door | Mgr. & 3B |  |  |  |  |  |  |  |  | 0 |  |  | 365
 | COVERED PARKING | Optional |  |  |  |  |  |  |  | 500 |  |  | 500 |  |  | 0
L#21 | INTERIOR TRIM
L#21 | Doors | 75 | Door
L#21 | Millwork | 0.55 | SF
L#21 | Labor | 0.6 | SF
 | PAINT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200
[NAME] | Exterior | 0.66 | CSF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1250
L#24 | Interior Trim | 1.34 | CSF
L#24 | Touch Up | 0.2 | CSF
 | FINISH ITEMS
L#22 | Cabinets | 1500 | Unit
L#22 | Countertops | 600 | Unit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 360
L#29 | Hardware With VING Card) | $0.35+$200 for VinCard
L#36 | Electrical Fixtures | 0.29 | SF
L#26 | Appliances(W/O Washer & Dryer) |  | Unit
[NAME] | Flooring | 1.22 | SF
L#21 | [NAME] | 157 | Unit
L#28 | FLATWORK | 2.25 | SF
L#28 | Curb Cut | See Site Work
L#28 | Drives | See Site Work
L#28 | Walks | See Site Work
L#30 | FENCING | See Amenities
L#30 | LANDSCAPING
L#30 | Sprinklers - Front & Rear | See Amenities
 | CLEAN UP
L#31 | Site |  | Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7000
L#31 | Interior | 0.15 | SF
L#31 | Final Grade | 350 | Unit
L#31 | [NAME] | 442 | Unit
L#31 | Job Toilet | 70 | Month
L#35 | [NAME] | 1000 | LS
L#37 | SUPERVISION |  | Month
 | TOTAL UNIT COST
 |  | Unit | Quantity | Unit Cost | Total | Per Acre
 | Land | $2.50/SF
 | Improvements
 | Civil Engineering | [NAME] | 1 | 37800
 | 8" Flex Base | Sq Yds | 13100 | 5.75
 | 1 1/2" HMAC | Sq Yds | 13100 | 3.75
 | Excavation/Embankment | [NAME] | 10000 | 3
 | Curb & Gutter | Linear Ft | 5000 | 6
 | 8"PVC Watermain | Linear Ft | 2200 | 25
 | 2" PVC Watermain | Linear Ft | 210 | 17
 | Water Services | EA | 134 | 600
 | Master [NAME] | EA | 2 | 17500
 | Fire Hydrants W/Valve | EA | 9 | 2000
 | 8" Wastewater Line(all depths) | Linear Ft | 1860 | 25
 | W.W. Manholes | EA | 12 | 2000
 | Wet Tap 8" | EA | 2 | 2000
 | Striping | [NAME] | 1 | 10000
 | Electrical | [NAME] | 1 | 75000
 | Contingency | [NAME] | 1 | 53592
 | Sub Total
 | Ammenities
 | Perimeter Wall-Bishop | Linear Ft | 670 | 55
 | Perimeter Wall-LBJ & Met | Linear Ft |  | 30
 | Landscaping & Sprinklers | Sq Ft. |  | 2
 | Entry Gates | EA | 2 | 4000
 | Mgr Apt, Computer & Rental Offices | [NAME] | 1
 | Rental Office FF&E | [NAME] | 3 | 7500
 | HighSpeed T-1 Line | EA | 134 | 200
 | Swimming Pool | [NAME] | 1
 | Technology & Fitness Center | [NAME] | 1
 | Vollyball Court | [NAME] | 1 | 20000
 | Basketball Court | [NAME] | 1 | 25000
 | Sub Total Comm. Ammenities
 | Total Imp. & Ammenities
 | TOTAL IMPROVED LOT
 | Construction Profit
 | TOTAL DIRECT COST
 | Finance Cost
 | Appraisal |  |  |  | 3500
 | Interim Construction Loan
 | Origination |  | 0.01
 | Closing Costs |  | 0.0025
 | 110% Interest Reserve | Interim Int Rate
 | Permanent Loan Fee | MortPts | 0.01 |  | 0
 | Total Finance Cost
 | TOTAL COST
 |  |  |  |  | P
 | CONSTRUCTION COST SUMMARY
 | Equity Required - Based on LTV @ 80%
 | Total
 | Less Defferred C. Profit
 | Less Excess CMFee
 | Investor Equity
 | LAND COST
 | RAW LAND
 | IMPROVEMENTS
 | IMPROVED LOT COST
 | UNIT COST
 | COMMON AMENITIES
 | UNIT COST
 | CONSTRUCTION PROFIT
 | TOTAL DIRECT COST
 | FINANCE COST
 | TOTAL COST
 | VALUE @ 10% CAP RATE
 | CONSTRUCTION LOAN
 | 75% Value
 | 80% Cost
 | EQUITY
 | With 75% LTV Loan
 | Land Equity
 | Less Construction Profit
 | Additional Equity
 | With 80% Cost Loan
 | Land Equity
 | Less Construction Profit
 | Additional Equity