Loading...
HomeMy WebLinkAbout07-16-12 TSH Denton Agenda Packet AGENDA THE BOARD OF DIRECTORS OF THE TEXAS STUDENT HOUSING CORPORATION – DENTON PROJECT (AN INSTRUMENTALITY OF THE TOWN OF WESTLAKE) July 16, 2012 6:00 P.M. TEXAS STUDENT HOUSING OFFICE 3 VILLAGE CIRCLE, COUNCIL CHAMBERS/MUNICIPAL COURT ROOM WESTLAKE, TEXAS 1. CALL TO ORDER 2. REVIEW AND APPROVE MINUTES FOR THE MEETING ON JANUARY 17, 2012. 3. DISCUSS AND CONSIDER APPROVAL OF TSHC – DENTON PROJECT ANNUAL BUDGET FOR FY 2012-2013. 4. EXECUTIVE DIRECTORS REPORT. 5. ADJOURN CERTIFICATION I certify that the above notice was posted at the Town Hall of the Town of Westlake, 3 Village Circle, Westlake, Texas, on July 11, 2012, by 5 p.m. under the Open Meetings Act, Chapter 551 of the Texas Government Code. _____________________________________ Kelly Edwards, Secretary If you plan to attend this public meeting and have a disability that requires special needs, please advise the Town Secretary 48 hours in advance at 817-490-5710 and reasonable accommodations will be made to assist you. TSH-Denton Minutes 01/17/12 Page 1 of 2 MINUTES OF THE MEETING OF THE BOARD OF DIRECTORS OF THE TEXAS STUDENT HOUSING CORPORATION – DENTON PROJECT (AN INSTRUMENTALITY OF THE TOWN OF WESTLAKE) January 17, 2012 PRESENT: President Jim Carter, Directors Scott Bradley, and Gregg Malone. ABSENT: George Ledak OTHERS PRESENT : Executive Director Pete Ehrenberg and Secretary Kelly Edwards. 1. CALL TO ORDER President Carter called the meeting to order at 6:20 p.m. 2. REVIEW AND APPROVE MINUTES FOR THE MEETING ON JUNE 21, 2011. MOTION: Director Bradley made a motion to approve the minutes. Director Malone seconded the motion. The motion carried by a vote of 3-0. 3. DISCUSS AND CONSIDER APPROVAL OF TSHC – DENTON PROJECT ANNUAL AUDIT FOR FY 2010-2011. John Manning, Patillo, Brown & Hill, presented an overview of the audit as presented. MOTION: Director Bradley made a motion to approve the FY 2010-2011 Audit. Director Malone seconded the motion. The motion carried by a vote of 3-0. TSHA – Denton Minutes 01/17/12 Page 2 of 2 4. ADJOURN President Cater asked for a motion to adjourn. MOTION: Director Malone made a motion to adjourn the meeting. Director Bradley seconded the motion. The motion carried by a vote of 3-0. There being no further business before the board, President Carter declared the meeting adjourned at 6:30 p.m. APPROVED BY THE TEXAS STUDENT HOUSING DENTON PROJECT BOARD OF DIRECTORS ON ___________, 2012. ______________________________________ Jim Carter, President ATTEST ____________________________________ Kelly Edwards, Secretary Ridge at North Texas Denton, TX 76210 2012/2013 Academic Operating Budget Template 288 = Units 876 = Beds 278,928 =Sq Ft G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 847 847 847 847 822 822 822 822 821 821 821 821 OCCUPANCY %96.69%96.69%96.69%96.69%93.84%93.84%93.84%93.84%93.72%93.72%93.72%93.72%94.75% OPERATING INCOME Gross Potential Rent Gross Market Rent 5005-0000 439,380 439,380 439,380 439,380 439,380 439,380 439,380 439,380 439,380 439,380 439,380 439,380 5,272,560 6,019 18,308 Contract Gain (Loss) to Lease 5010-0000 (400)(400)(400)(400)(400)(400)(400)(400)(400)(400)(12,750)(12,750)(29,500)(34)(102) Total Gross Potential Rent 438,980 438,980 438,980 438,980 438,980 438,980 438,980 438,980 438,980 438,980 426,630 426,630 5,243,060 5,985 18,205 Economic Variances Concessions - Amenity 5030-0050 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Concessions - Misc.5030-0100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Concessions - New Leases 5030-0200 (11,900)(11,900)(11,900)(11,900)(11,900)(11,900)(11,900)(11,900)(11,900)(11,900)(11,900)(11,900)(142,800)(163)(496) Concessions - Renewals 5030-0400 (9,900)(9,900)(9,900)(9,900)(9,900)(9,900)(9,900)(9,900)(9,900)(9,900)(9,900)(9,900)(118,800)(136)(413) Concessions - Schlrshps/Mstr Lease 5030-0500 (3,750)(3,750)(3,750)(3,750)(3,750)(3,750)(3,750)(3,750)(3,750)(3,750)0 0 (37,500)(43)(130) Down Units 5040-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Employee Units 5045-0000 (12,000)(12,000)(12,000)(12,000)(12,000)(12,000)(12,000)(12,000)(12,000)(12,000)(12,000)(12,000)(144,000)(164)(500) Courtsey Officer Discount 5050-0000 (1,650)(1,650)(1,650)(1,650)(1,650)(1,650)(1,650)(1,650)(1,650)(1,650)(1,650)(1,650)(19,800)(23)(69) Model Units 5055-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Bad Debt 5025-0000 (8,000)(6,200)(6,200)(6,200)(6,200)(6,200)(6,200)(6,200)(6,200)(6,200)(6,200)(9,000)(79,000)(90)(274) Vacancy Loss 5065-0000 (14,546)(14,546)(14,546)(14,546)(27,085)(27,085)(27,085)(27,085)(27,587)(27,587)(27,587)(27,587)(276,870)(316)(961) Total Economic Variances (61,746)(59,946)(59,946)(59,946)(72,485)(72,485)(72,485)(72,485)(72,987)(72,987)(69,237)(72,037)(818,770)(935)(2,843) Econ %85.95%86.36%86.36%86.36%83.50%83.50%83.50%83.50%83.39%83.39%84.24%83.60%84.47% Retail Income Commerical/Retail Income 5102-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CAM 5115-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Retail Income 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NET RENTAL INCOME 377,234 379,034 379,034 379,034 366,495 366,495 366,495 366,495 365,993 365,993 357,393 354,593 4,424,290 5,051 15,362 Other Operating Income Accelerated Rent 5205-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Administrative Fees 5210-0000 150 300 50 50 50 100 100 300 300 300 300 500 2,500 3 9 Application Fees 5220-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Damages Income 5260-0000 2,400 7,000 3,200 1,150 1,100 6,486 5,216 800 100 900 100 4,500 32,952 38 114 Deposit Forfeitures 5265-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Carport/Garages/Parking Income 5235-0000 1,125 1,125 1,125 1,125 1,125 1,125 1,125 1,125 1,125 1,125 1,125 1,125 13,500 15 47 Furniture Income 5270-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Key & Access Card Income 5290-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Legal & Collections 5310-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 1 4 Late Charges 5295-0000 5,000 6,500 7,500 6,000 8,000 5,500 5,000 4,000 3,500 4,500 5,000 0 60,500 69 210 Month-to-Month Fees 5320-0000 1,000 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,000 0 0 0 10,400 12 36 NSF Check Fees 5325-0000 100 50 100 50 100 50 100 50 100 50 50 100 900 1 3 Pet Fees 5330-0000 2,000 300 300 300 300 300 300 300 300 300 300 2,000 7,000 8 24 Premium Fees 5335-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Relet/Cancellation Fees 5340-0000 300 2,000 600 800 3,200 1,200 500 200 3,500 2,400 2,000 3,200 19,900 23 69 Reservation Fees 5350-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales Tax Income 5355-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Shuttle Bus Income 5360-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Storage Income 5365-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer Fees 5375-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Vending Income 5390-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Miscellaneous Income 5315-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 1 4 RUBS Income - Electric 5370-0100 5,500 9,500 9,500 7,500 6,500 6,500 7,500 8,500 8,500 10,000 10,000 10,000 99,500 114 345 RUBS Income - Gas 5370-0200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 RUBS Income - Water 5370-0300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 RUBS Income -Trash 5370-0400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Interest Income 5285-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Other Operating Income 17,775 28,175 23,775 18,375 21,775 22,661 21,241 16,675 18,625 19,775 19,075 21,625 249,552 285 867 0 EFFECTIVE GROSS INCOME 395,009 407,209 402,809 397,409 388,270 389,156 387,736 383,170 384,618 385,768 376,468 376,218 4,673,842 5,335 16,229 4/15/2012 Account Descriptions 5/18/2012 Page 1of5 Ridge at North Texas Denton, TX 76210 2012/2013 Academic Operating Budget Template 288 = Units 876 = Beds 278,928 =Sq Ft G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 4/15/2012 Account Descriptions OPERATING EXPENSES Cable & Internet 0 0 Cable TV 6805-0000 6,315 6,315 6,315 6,315 6,315 6,315 6,315 6,315 6,315 6,315 6,315 6,315 75,780 87 263 Internet 6825-0000 10,600 10,600 10,600 10,600 10,600 10,600 10,600 10,600 10,600 10,600 10,600 10,600 127,200 145 442 Total Cable / Internet 16,915 16,915 16,915 16,915 16,915 16,915 16,915 16,915 16,915 16,915 16,915 16,915 202,980 232 705 General & Administrative Audit 6002-0200 0 0 9,000 0 0 1,600 0 0 0 0 0 0 10,600 12 37 Legal 6002-0300 100 100 100 100 100 100 100 100 100 100 100 100 1,200 1 4 Bank Charges/Fees 6005-0000 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 13,200 15 46 Data Processing/Computer Expense 6030-0000 100 100 7,600 100 100 100 100 100 100 100 100 100 8,700 10 30 Resident Screening 6095-0000 150 50 50 50 950 950 1,000 1,000 1,000 1,000 1,000 700 7,900 9 27 Dues & Subscriptions 6035-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Equipment & Supplies for Equipment 6045-0000 600 400 400 400 400 400 400 400 400 400 400 400 5,000 6 17 Postage & Delivery 6070-0000 650 700 700 600 600 250 250 450 300 500 300 250 5,550 6 19 Licenses, Fees & Permits 6060-0000 0 175 550 0 375 0 0 275 0 0 100 0 1,475 2 5 Portal Expense 6770-0000 0 0 0 0 0 0 2,400 0 0 0 0 0 2,400 3 8 Professional Fees 6080-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Supplies 6100-0000 500 300 300 300 300 300 300 300 300 300 300 300 3,800 4 13 Telephone 6105-0000 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 14,400 16 50 Telephone-Answering Service 6110-0000 165 165 165 165 165 165 165 165 165 165 165 165 1,980 2 7 Telephone-Radios/Pagers/Cell 6107-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 1 4 Training 6115-0000 0 250 0 0 1,450 0 0 0 250 0 0 0 1,950 2 7 Travel 6120-0000 150 150 150 150 200 200 200 300 200 550 550 550 3,350 4 12 Travel-Meals 6120-0300 0 0 25 0 0 25 50 50 70 250 100 250 820 1 3 Uniforms 6135-0000 700 0 0 0 400 0 0 0 700 0 0 0 1,800 2 6 Miscellaneous 6065-0000 200 400 400 600 800 800 800 800 600 500 450 200 6,550 7 23 Total General & Administrative 5,715 5,190 21,840 4,865 8,240 7,290 8,165 6,340 6,585 6,265 5,965 5,415 91,875 105 319 Payroll & Benefits Office Salaries 6205-0000 13,045 10,545 10,545 10,545 15,818 10,545 10,545 10,545 10,545 15,818 10,545 16,045 145,090 166 504 Performance 6265-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Leasing 6260-0000 12,000 2,000 8,000 0 0 500 500 500 500 0 0 0 24,000 27 83 Maintenance 6225-0000 10,289 7,289 7,289 7,289 10,934 7,289 7,289 7,289 7,289 10,934 7,289 12,289 102,760 117 357 Contract Labor 6250-0000 2,400 0 0 0 0 0 0 0 0 0 0 4,800 7,200 8 25 Payroll Taxes 6270-0100 4,509 2,370 3,087 2,131 3,197 2,191 2,191 2,191 2,191 3,197 2,131 3,960 33,346 38 116 Worker's Compensation 6270-0200 4,170 2,192 2,855 1,971 2,956 2,026 2,026 2,026 2,026 2,956 1,971 3,661 30,835 35 107 Group Insurance 6280-0000 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 18,000 21 63 Employee Recuriting 6290-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Employee Relations 6295-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Payroll & Benefits 47,914 25,897 33,277 23,437 34,405 24,052 24,052 24,052 24,052 34,405 23,437 42,256 361,232 412 1,254 Contract Services Contract-Alarm/Monitoring-Intrusion/Fire 6305-0000 235 235 235 235 235 235 235 235 235 235 235 235 2,820 3 10 Contract-Bus Service 6310-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contract-Cleaning 6315-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contract-Elevator 6325-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contract - HVAC 6335-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contract - Fire/Saftey 6327-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contract-Landscape Maintenance 6340-0000 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 45,000 51 156 Contract-Other Contract Services 6345-0000 500 500 500 500 500 500 500 500 500 500 500 500 6,000 7 21 Contract-Security/Patrol/Courtesy Officer 6365-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contract-Pest Control 6350-0000 520 520 520 520 520 520 520 520 520 520 520 520 6,240 7 22 Contract-Pool 6360-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contract-Snow Removal 6370-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contract-Trash Removal 6375-0000 6,000 3,100 3,100 2,850 2,850 2,850 2,850 2,850 2,850 2,850 2,850 6,500 41,500 47 144 Total Contract Services 11,005 8,105 8,105 7,855 7,855 7,855 7,855 7,855 7,855 7,855 7,855 11,505 101,560 116 353 5/18/2012 Page 2of5 Ridge at North Texas Denton, TX 76210 2012/2013 Academic Operating Budget Template 288 = Units 876 = Beds 278,928 =Sq Ft G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 4/15/2012 Account Descriptions Repairs & Maintenance Appliances 6410-0000 3,200 2,000 1,100 800 1,800 900 900 1,000 1,800 300 300 300 14,400 16 50 Blind/Drapes 6415-0000 200 20 20 20 20 20 20 20 20 20 770 500 1,650 2 6 Boilers 6420-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Building - Interior 6425-0100 100 100 100 5,000 100 100 100 100 100 100 100 100 6,100 7 21 Building - Exterior 6425-0200 100 100 100 100 100 100 100 100 100 100 100 100 1,200 1 4 Common Areas 6440-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 1 4 Countertops/Sink 6445-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Doors/Windows 6450-0000 50 50 50 50 50 50 50 50 50 50 50 50 600 1 2 Electrical 6455-0000 200 0 0 200 0 200 0 200 0 200 0 200 1,200 1 4 Elevators 6460-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Fencing & Gates 6470-0000 250 250 250 500 250 250 250 250 250 250 250 2,500 5,500 6 19 Fire/Saftey 6475-0000 100 1,700 100 100 100 100 100 100 100 100 100 100 2,800 3 10 Generator 6483-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Glass/Mirrors/Screens 6485-0000 400 200 200 200 300 200 200 200 400 200 200 200 2,900 3 10 Golf Carts 6490-0000 2,500 0 0 500 0 0 0 0 0 500 0 0 3,500 4 12 HVAC 6495-0000 3,250 3,250 1,850 1,650 1,650 1,650 2,850 2,750 2,350 3,050 2,650 2,150 29,100 33 101 Keys & Locks 6500-0000 1,000 100 100 100 100 100 100 100 100 100 100 1,000 3,000 3 10 Landscaping 6510-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Lights, Fixtures, Light Bulbs 6520-0000 800 500 100 100 400 400 400 200 200 200 200 200 3,700 4 13 Miscellaneous 6525-0000 1,300 1,300 1,300 1,300 1,300 1,300 1,100 1,100 1,100 1,300 1,100 1,100 14,600 17 51 Painting 6530-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 1 4 Parking Lots & Sidewalks 6535-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 1 4 Plumbing 6540-0000 1,200 300 200 200 900 1,200 1,000 1,000 600 1,000 600 600 8,800 10 31 Pools 6545-0000 800 300 3,200 100 200 400 600 600 500 500 400 600 8,200 9 28 Recreation 6550-0000 250 0 250 0 250 0 250 0 250 0 250 0 1,500 2 5 Roofs 6555-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Signs 6560-0000 0 200 0 200 0 200 0 200 0 200 0 200 1,200 1 4 Supplies 6570-0000 600 1,000 300 300 400 350 350 300 300 700 500 350 5,450 6 19 Tools 6575-0000 400 100 100 100 100 300 100 100 200 200 200 200 2,100 2 7 Total Repairs & Maintenance 17,000 11,770 9,620 11,820 8,320 8,120 8,770 8,670 8,720 9,370 8,170 10,750 121,100 138 420 Make-Ready Maintenance Carpet Cleaning/Repairs 6610-0000 55,000 14,625 625 0 330 625 0 0 1,285 0 0 625 73,115 83 254 Cleaning 6615-0000 21,125 21,125 0 0 800 0 0 0 1,600 0 0 0 44,650 51 155 Interior Repairs 6630-0000 39,000 2,000 0 0 0 0 0 33,000 0 0 4,000 3,000 81,000 92 281 Painting 6635-0000 30,125 30,125 0 0 2,825 0 0 0 2,825 0 0 0 65,900 75 229 Appliance Supplies 6652-0000 8,500 0 0 0 0 0 0 0 0 0 1,000 6,000 15,500 18 54 Cleaning Supplies 6655-0000 1,000 0 0 0 0 0 0 0 0 0 0 0 1,000 1 3 Paint Supplies 6660-0000 10,000 0 0 0 0 0 0 0 0 0 0 0 10,000 11 35 Total Make-Ready Maintenance 164,750 67,875 625 0 3,955 625 0 33,000 5,710 0 5,000 9,625 291,165 332 1,011 Marketing Advertising Print 6705-0200 0 0 500 2,500 0 0 200 500 500 500 300 0 5,000 6 17 Publications 6730-0000 0 3,000 1,500 1,500 1,500 1,500 3,000 1,400 1,200 5,200 3,200 2,000 25,000 29 87 Direct Mail 6715-0000 0 0 0 0 0 0 0 0 4,500 2,000 0 0 6,500 7 23 Radio 6705-0300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Signs 6735-0000 0 300 0 0 300 0 0 300 0 0 300 0 1,200 1 4 Internet Ads 6720-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other 6748-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Brochures/Promo Items 6750-0000 0 0 0 0 0 3,500 4,500 0 3,500 0 0 0 11,500 13 40 Locator Fees 6760-0000 4,000 4,000 0 0 0 0 0 0 0 0 0 0 8,000 9 28 Referral Fees 6780-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Promotion & Events 6775-0000 13,000 13,000 0 0 0 0 0 1,000 0 0 0 0 27,000 31 94 Resident Activities/Tenant Relations 6790-0000 750 750 500 500 500 750 500 750 500 500 250 250 6,500 7 23 Websites 6740-0000 700 700 700 700 700 700 700 700 700 700 700 700 8,400 10 29 Total Marketing 18,450 21,750 3,200 5,200 3,000 6,450 8,900 4,650 10,900 8,900 4,750 2,950 99,100 113 344 Utilities Electricity Elec-Common Area 6910-0100 2,500 3,500 3,500 3,100 3,500 3,500 3,300 3,500 3,500 3,500 3,500 5,000 41,900 48 145 Elec-Residential Units 6910-0200 39,000 35,000 35,000 26,000 31,000 31,000 31,000 32,000 32,000 43,000 43,000 39,000 417,000 476 1,448 Elec-Vacant Units 6910-0900 0 0 0 0 0 0 0 0 0 0 0 0 0 0 05/18/2012 Page 3of5 Ridge at North Texas Denton, TX 76210 2012/2013 Academic Operating Budget Template 288 = Units 876 = Beds 278,928 =Sq Ft G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 4/15/2012 Account Descriptions Total Electricity 41,500 38,500 38,500 29,100 34,500 34,500 34,300 35,500 35,500 46,500 46,500 44,000 458,900 524 1,593 Other Utilities Gas 6920-0000 150 500 300 500 600 500 200 200 150 250 180 100 3,630 4 13 Water / Sewer 6930-0000 19,770 19,770 19,770 19,770 19,770 19,770 19,770 19,770 19,770 19,770 19,770 19,770 237,240 271 824 Utility Billing Fee 6950-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Other Utilities 19,920 20,270 20,070 20,270 20,370 20,270 19,970 19,970 19,920 20,020 19,950 19,870 240,870 275 836 Total Utilities 61,420 58,770 58,570 49,370 54,870 54,770 54,270 55,470 55,420 66,520 66,450 63,870 699,770 799 2,430 Management Fees 4.00%6990-0000 11,000 11,000 11,000 11,000 11,000 11,000 11,000 11,000 11,000 11,000 11,000 11,000 132,000 151 458 Taxes Property Taxes 7005-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Personal Property Taxes 7010-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Property Tax Consultant 7020-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Franchise Taxes 7060-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales Tax 7085-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance Ins-Property & Casualty Insurance 7105-0100 6,900 6,900 0 0 0 0 0 16,354 6,800 6,800 6,800 6,800 57,354 65 199 General Liability 7105-0500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Insurance 6,900 6,900 0 0 0 0 0 16,354 6,800 6,800 6,800 6,800 57,354 65 199 TOTAL OPERATING EXPENSES 361,069 234,172 163,152 130,462 148,560 137,077 139,927 184,306 153,957 168,030 156,342 181,086 2,158,136 2,464 7,494 33,941 173,038 239,658 266,948 239,710 252,079 247,809 198,864 230,662 217,738 220,127 195,133 2,515,707 2,872 8,735 Debt Service Interest Expense 7210-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Mortgage Principal 7205-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Interest / Financing Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Capital Improvements Appliances 8315-0200 7,500 0 0 0 0 0 0 0 0 0 0 5,000 12,500 14 43 Washer/Dryer 8315-0280 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Blinds 8315-0400 0 0 0 0 0 0 0 0 0 0 750 300 1,050 1 4 Carpet 8315-1000 40,375 0 625 0 0 625 0 0 625 0 0 625 42,875 49 149 Furniture 8315-5000 33,000 0 0 0 0 0 0 33,000 0 0 0 0 66,000 75 229 Vinyl/Tile 8315-1000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Recurring Capital 80,875 0 625 0 0 625 0 33,000 625 0 750 5,925 122,425 140 425 Capital Improvements - Non Recurring Alarms/Access Systems 8315-0100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Boilers 8315-0500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Building 8315-0600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Clubhouse/Model 8315-1200 4,900 0 0 0 0 0 0 0 0 0 0 0 4,900 6 17 Carports 8315-1100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Computers 8315-4000 7,500 0 0 0 0 0 0 0 0 0 0 0 7,500 9 26 Countertop/Sink/Cabinets 8315-1400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Elevators 8315-1700 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Equipment (Office & Maintenance)8315-5100 2,500 0 0 0 0 0 0 0 0 0 0 0 2,500 3 9 Fencing & Gates 8315-1800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Fire/Saftey 8315-1900 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 HVAC 8315-2100 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 15,000 17 52 Keys & Locks 8315-2200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Landscaping 8315-2300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Light Fixtures 8315-2500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Miscellaneous 8315-2700 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 14 42 Painting (Exterior)8315-2900 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Parking Lot & Sidewalks 8315-3000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Pools 8315-3200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NET OPERATING INCOME (LOSS) BEFORE DEBT SERVICE & CAPITAL 5/18/2012 Page 4of5 Ridge at North Texas Denton, TX 76210 2012/2013 Academic Operating Budget Template 288 = Units 876 = Beds 278,928 =Sq Ft G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 4/15/2012 Account Descriptions Pool Furniture 8315-5900 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Recreation/Amenity Areas 8315-3300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Renovations (Units)8315-3400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Roofs 8315-3600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Signage 8315-3700 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Tubs/Showers 8315-3950 8,000 0 0 0 0 0 0 0 0 0 0 1,500 9,500 11 33 Total Non Recurring Capital 25,150 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 3,750 51,400 59 178 Escrow Accounts Tax Reserve 1080-0100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Tax Funding 1080-0100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance Reserve 1080-0300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance Reserve Funding 1080-0300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Replacement Reserve 1080-0400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Replacement Reserve Reimb.1080-0400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Net Escrow Activity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Expenses Accounting / Audit / Tax 8905-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Administrative Expense 8910-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Legal/LLC fees 8950-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Travel 8995-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Start Up Cost 8983-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Miscellaneous 8960-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Asset Management 1.00%8915-0000 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 42,000 48 146 Total Other Expenses 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 42,000 48 146 INCOME (LOSS) Before Depr / Amort (75,584)167,288 233,283 261,198 233,960 245,704 242,059 160,114 224,287 211,988 213,627 181,958 2,299,882 2,625 7,986 Distribution Payments 4201-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 MONTHLY CASH FLOW (75,584)167,288 233,283 261,198 233,960 245,704 242,059 160,114 224,287 211,988 213,627 181,958 2,299,882 2,625 7,986 5/18/2012 Page 5of5