Spreadsheet: phillip_allen__28908__version 12_17
Sheet: UCost Final

 | Construction Management Fee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1 | SM134Units | 134 |  | Perimeter [NAME] |  |  |  | [NAME] First Flr | 570
 | Total Rental Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Const Profit | 0.25 |  | Int. Courtyard |  |  |  | ThreeBdrm First Flr
FAB L# | Construction Sequence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Phase Totals |  |  |  | Pool |  |  |  | MgrOffFirstFlr
 | ESW PHASE 2 COST DATA - FAB LOAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vollyball & Basketball
 |  |  |  | 1 | 2 | 7 | 3 | 4 | 5 | 6 |  |  |  |  |  |  |  | Manager's Unit, Office & Computer Center |  |  |  | PLAN B - 2+2.5+2 |  |  |  | PLAN C - 3+3.5+2 |  |  |  | PLAN D - 4+2+2 |  |  |  | TOTALS
 | Description | DRAW ALLOW | % Tcost | 812/814 | 820/822 | 826/828 | 832/834 | 838/840 | 861/863 | 867/869 | Totals |  |  | Per Unit | Per ACSF | Per Cvrd SF |  | Totals | Per Unit | Per SF |  | Totals | Per Unit | Per SF |  | Totals | Per Unit | Per SF |  | Totals | Per Unit | Per SF |  | Totals | Per Unit | Per SF | % TOTAL |  | Description | % Of Est. | Estimate Totals | Per Unit | Per A/C SF
 | MIX - Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 72 |  |  |  |  |  |  |  | 0
 | MIX - %
 | Heated/Total SF |  |  |  |  |  |  |  |  |  |  |  |  |  | 1376 |  |  |  |  |  |  |  | 1107 |  |  |  | 1287 |  |  |  | 1550
L#1 | Permits |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. | Permits/Fees
L#2 | Architecture & Structural Eng. |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. | Arch & Eng & Replat
L#35 | Builder's Risk |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. | Water/Sewer Con. |  | 0
L#4 | Temp Electic & Utilities |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  | 4. | Site Work
L#4 | Sitework |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. | Foundation
 | FOUNDATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6. | Plumbing Rough
L#5 | Setup |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7. | Framing & Sheeting (M&L)
L#5 | Concrete |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8. | Roof (Matl & Labor)
L#5 | Finish |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9. | Cornice (M&L)
 | PLUMBING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10. | Windows/Mirrors
L#6 | Rough | 0.333 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11. | Painting-Outside
L#17 | Top Out | 0.333 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12. | Electric-Rough
L#17 | Set Out | 0.333 |  | X | X |  | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13. | Ducts
 | FRAMING LABOR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14. | Heat/Air-Units
L#7 | 1st [NAME] | 0.15 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15. | Insulation-Walls
L#7 | 2nd [NAME] | 0.25 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16. | Insulation-Ceiling | Included in Insulation- Walls, Line #15
L#7 | Roof-Decking-Subfascia | 0.25 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17. | Plumbing - Top Out
L#9 | Cornice | 0.35 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18. | Masonry/Siding
 | FRAMING MATERIALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19. | Fireplace |  | 0
L#7 | Trusses - Roof |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | Shrck/Tape/Float
L#7 | [NAME] |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21. | Trim Work W/Garage Drs.
L#7 | 1st [NAME] |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22. | Cabinets/Formica
L#7 | 2nd Floor Materials |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23. | Tile |  | 0
L#7 | Roof System Materials |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24. | Painting-Interior
L#9 | Cornice Materials |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25. | Wallpaper |  | 0
L#10 | Windows |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26. | Appliances
L#7 | Exterior Doors |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27. | Carpet/Vinyl
 | MASONRY/SIDING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28. | Drives & Sidewalks
[NAME] | Materials |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  | 29. | Hardware
[NAME] | Labor |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  | 30. | Ldscp., Fencing & Clean Up
 | ROOFING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31. | Clean Up & Temps
L#8 | Materials |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32. | Septic
L#8 | Labor |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33. | Interest & Fees
 | ELECTRIC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34. | Lot
L#12 | Temp Set | 0.1 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35. | Other Costs
L#12 | Rough | 0.5 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36. | Electric - Trim,Pre-Wire & Fix.
L#36 | Trim | 0.4 |  | X | X |  | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37. | Supervision
 | PREWIRE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35. | Construction Management
L#36 | Rough | 0.75 |  | X | X | X | X | X | X | X |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36. | [NAME]
L#36 | Trim | 0.25 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 | HVAC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Less:
L#13 | Rough | 0.6 |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Land & Improvments
L#14 | Set | 0.4 |  | X | X |  | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interest
L#15&16 | INSULATION |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Construction Management
L#20 | SHEETROCK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Construction Profit
L#20 | Stock |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Board & Nail Total
L#20 | Hang, Tape, Float & Texture |  |  | X | X | X | X | X | X | X
L#21 | GARAGE DOORS |  |  | X | X |  | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | COVERED PARKING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 |  |  |  | 500 |  |  |  | 500 |  |  |  | 0
L#21 | INTERIOR TRIM
L#21 | Doors |  |  | X | X |  | X | X | X | X
L#21 | Millwork |  |  | X | X |  | X | X | X | X
L#21 | Labor |  |  | X | X |  | X | X | X | X
 | PAINT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200
[NAME] | Exterior |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1250
L#24 | Interior Trim |  |  | X | X |  | X | X | X | X
L#24 | Touch Up |  |  | X | X |  | X | X | X | X
 | FINISH ITEMS
L#22 | Cabinets |  |  | X | X | X | X | X | X | X
L#22 | Countertops |  |  | X | X |  | X | X |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 360
L#29 | Hardware With VING Card) |  |  | X | X |  | X | X |  | X
L#36 | Electrical Fixtures |  |  | X | X |  | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rent
L#26 | Appliances |  |  | X | X |  | X | X | X | X
[NAME] | Flooring |  |  | X | X |  | X | X |  | X
L#21 | [NAME] |  |  | X | X | x | X | X |  | x
L#28 | FLATWORK
L#28 | Curb Cut |  |  | X | X | X | X | X | X | X
L#28 | Drives |  |  | X | X |  | X | X |  | x
L#28 | Walks |  |  | X | X |  | X | X |  | x
L#30 | FENCING |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
L#30 | LANDSCAPING |  |  | X | X |  | X | X |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
L#30 | Sprinklers - Front & Rear |  |  | N/A
 | CLEAN UP
L#31 | Site |  |  | X | X |  | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7000
L#31 | Interior |  |  | X | X |  | X | X |  | X
L#31 | Final Grade |  |  | X | X |  | X | X |  | X
L#31 | [NAME] |  |  | X | X |  | X | X |  | X
L#31 | Job Toilet |  |  | X | X |  | X | X |  | X
L#35 | [NAME] |  |  | X | X |  | X | X |  | X
L#37 | SUPERVISION |  |  | X | X |  | X | X |  | X
 | TOTAL UNIT COST |  |  | CofO | CofO |  | CofO | CofO
 |  |  |  |  |  |  |  |  |  |  | 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 | 35
 | Perimeter Wall-LBJ & Met |  |  |  |  |  |  |  |  |  | Linear Ft |  | 25
 | 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 | 100000
 | Fitness Center |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 30000
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  | 4000
 | Origination
 | Closing Costs
 | Interest Reserve
 | Total Finance Cost
 | TOTAL COST
 | % of Value
 | Total Bdrm Rent/Month
 | Rent/Bedroom/Month
 | Annual Return on Total Cost
 | Interim Loan - LTC |  |  |  |  |  |  |  |  |  | LTC |  |  | 0.75
 | Interim Loan - LTV |  |  |  |  |  |  |  |  |  | LTV |  |  | 0.7
 | Equity Based on LTC @ 80%
 | Total Cost Less Loan
 | Less Defferred Const. Profit
 | Investor Equity
 | CONSTRUCTION COST SUMMARY
 | Equity Required - Based on LTV @ 80%
 | Total
 | Less Defferred C. Profit
 | Less Excess CMFee
 | Investor Equity
 | LAND
 | UTILITY IMPROVEMENTS
 | IMPROVED LOT COST
 | COMMON AMENITIES
 | UNIT COST
 | CONSTRUCTION PROFIT
 | TOTAL DIRECT COST
 | FINANCE COST
 | TOTAL COST