Spreadsheet: phillip_allen__29604__SM134 Proforma
Sheet: UCost AltA

 | Construction Management Fee |  |  |  |  |  |  |  |  |  | 1.125
 | Total Rental Units |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  | SM134Units | 134
FAB L# | Construction Sequence |  |  |  |  |  |  |  |  |  | Phase Totals
 | ESW PHASE 2 COST DATA - FAB LOAN
 |  |  |  | 1 | 2 | 7 | 3 | 4 | 5 | 6 |  |  |  |  |  | PLAN A - 2+2+1 |  |  |  | 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 |  |  |  | Description | % Of Est. | Estimate Totals | Per Unit | Per A/C SF
 | MIX |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Heated/Total SF |  |  |  |  |  |  |  |  |  |  |  | 1376 |  |  |  | 1198 |  |  |  | 900 |  |  |  | 1287
L#1 | Permits |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. | Permits/Fees
L#2 | Architecture & Engineering |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  | 0 |  |  |  | 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
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 CONSTRUCTION |  |  | CofO | CofO |  | CofO | CofO
 |  |  |  |  |  |  |  |  |  |  |  | Total | Per Acre
 | Land |  |  |  |  |  |  |  |  |  | $2.50/SF
 | Civil Engineering
 | Improvements
 | Parking & Drives |  |  |  |  |  |  |  |  |  | $2/SF
 | Curbing |  |  |  |  |  |  |  |  |  | $8/LF
 | Striping |  |  |  |  |  |  |  |  |  | $0.50/SF
 | Utilities |  |  |  |  |  |  |  |  |  | $35/LF
 | Landscaping & Sprinklers |  |  |  |  |  |  |  |  |  | $2.50/SF
 | Entry Gates |  |  |  |  |  |  |  |  |  | $4000/Gate
 | Perimeter Wall-Bishop |  |  |  |  |  |  |  |  |  | $35/LF
 | Lighting |  |  |  |  |  |  |  |  |  | 25000
 | Signage |  |  |  |  |  |  |  |  |  | 15000
 | Rental Office FF&E |  |  |  |  |  |  |  |  |  | 15000
 | Sub Total
 | [NAME]
 | Swimming Pool |  |  |  |  |  |  |  |  |  | 75000
 | Pool Shower/Restroom |  |  |  |  |  |  |  |  |  | 4000
 | Vollyball Court |  |  |  |  |  |  |  |  |  | 4000
 | 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
 | Total Bdrm Rent + Garage Fee
 | Rent/Bedroom/Mo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 625 |  |  |  | 575 |  |  |  | 475 |  |  |  | 450
 | Return on Cost/Year
 | Interim Loan Amount |  |  |  |  |  |  |  |  |  | 0.75 | LTC
 | Equity Required
 | Total
 | Less Defferred C. Profit
 | Cash Equity
 |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  | 4
 | Water |  |  |  |  |  |  |  |  |  |  | 16
 | Sewer
 | TV&Cable
 | Elec
 | Lighting |  |  |  |  |  |  |  |  |  | 25000
 | Gates
 | Office FF&E |  |  |  |  |  |  |  |  |  | 15000
 | Signage |  |  |  |  |  |  |  |  |  | 15000
 | Wall On Bishop
 | Pool |  |  |  |  |  |  |  |  |  | 75000
 | Volleyball Court |  |  |  |  |  |  |  |  |  | 4000
 | Baths |  |  |  |  |  |  |  |  |  | 4000