Loading...
2012-2013 Ballpark revised budgetBallpark at Austin Austin, TX 78681 2012/2013 Academic Operating Budget Template 282 = Units Gross Market Rent =$432 $432 768 = Beds Ave Gain (Loss) to Lease =$5 $5 250,218 =Sq Ft Ave Billing per Bed =$437 $437 G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 759 759 759 759 745 745 745 745 745 745 745 745 OCCUPANCY %98.83%98.83%98.83%98.83%97.01%97.01%97.01%97.01%97.01%97.01%97.01%97.01%97.61% OPERATING INCOME Gross Potential Rent Gross Market Rent 5005-0000 331,800 331,800 331,800 331,800 331,800 331,800 331,800 331,800 331,800 331,800 331,800 331,800 3,981,600 5,184 14,119 Contract Gain (Loss) to Lease 5010-0000 3,282 3,282 3,282 3,282 3,282 3,282 3,282 3,282 3,282 3,282 (15,600)(15,600)1,620 2 6 Total Gross Potential Rent 335,082 335,082 335,082 335,082 335,082 335,082 335,082 335,082 335,082 335,082 316,200 316,200 3,983,220 5,186 14,125 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 (1,620)0 0 0 0 0 0 0 0 0 0 0 (1,620)(2)(6) Concessions - Renewals 5030-0400 (60,780)0 0 0 0 0 0 0 0 0 0 0 (60,780)(79)(216) Concessions - Schlrshps/Mstr Lease 5030-0500 (11,526)(11,526)(11,526)(11,526)(11,526)(11,526)(11,526)(11,526)(11,526)(11,526)0 0 (115,260)(150)(409) Down Units 5040-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Employee Units 5045-0000 (6,300)(6,300)(6,300)(6,300)(6,300)(6,300)(6,300)(6,300)(6,300)(6,300)(6,300)(6,300)(75,600)(98)(268) Courtsey Officer Discount 5050-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Model Units 5055-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Bad Debt 5025-0000 (3,320)(3,320)(3,320)(3,320)(3,320)(3,320)(3,320)(3,320)(3,320)(3,320)(3,320)(3,320)(39,840)(52)(141) Vacancy Loss 5065-0000 (3,888)(3,888)(3,888)(3,888)(9,937)(9,937)(9,937)(9,937)(9,937)(9,937)(9,937)(9,937)(95,047)(124)(337) Total Economic Variances (87,434)(25,034)(25,034)(25,034)(31,083)(31,083)(31,083)(31,083)(31,083)(31,083)(19,557)(19,557)(388,147)(505)(1,376) Econ %73.65%92.46%92.46%92.46%90.63%90.63%90.63%90.63%90.63%90.63%94.11%94.11%90.25% 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 247,648 310,048 310,048 310,048 303,999 303,999 303,999 303,999 303,999 303,999 296,643 296,643 3,595,073 4,681 12,748 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 50 50 50 50 50 50 50 50 50 50 50 50 600 1 2 Application Fees 5220-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Damages Income 5260-0000 0 0 0 0 0 0 0 0 0 0 0 5,000 5,000 7 18 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 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 30,000 39 106 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 50 50 50 50 50 50 50 50 50 50 50 500 1,050 1 4 Legal & Collections 5310-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 2 4 Late Charges 5295-0000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 0 44,000 57 156 Month-to-Month Fees 5320-0000 700 700 700 700 700 700 700 700 700 0 0 0 6,300 8 22 NSF Check Fees 5325-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 2 4 Pet Fees 5330-0000 500 300 300 300 200 200 200 200 200 200 200 200 3,000 4 11 Premium Fees 5335-0000 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 500 20,300 26 72 Relet/Cancellation Fees 5340-0000 0 0 1,000 3,200 1,400 1,400 2,800 400 1,000 1,200 1,200 2,000 15,600 20 55 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 2 4 RUBS Income - Electric 5370-0100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 9,900 9,700 10,700 12,900 11,000 11,000 12,400 10,000 10,600 10,100 10,100 11,050 129,450 169 459 0 EFFECTIVE GROSS INCOME 257,548 319,748 320,748 322,948 314,999 314,999 316,399 313,999 314,599 314,099 306,743 307,693 3,724,523 4,850 13,208 3/1/2012 Account Descriptions 6/1/2012 Page 1of5 Ballpark at Austin Austin, TX 78681 2012/2013 Academic Operating Budget Template 282 = Units Gross Market Rent =$432 $432 768 = Beds Ave Gain (Loss) to Lease =$5 $5 250,218 =Sq Ft Ave Billing per Bed =$437 $437 G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 3/1/2012 Account Descriptions OPERATING EXPENSES Cable & Internet 0 0 Cable TV 6805-0000 6,650 6,650 6,650 6,650 6,650 6,650 6,650 6,650 6,650 6,650 6,650 6,650 79,800 104 283 Internet 6825-0000 10,400 10,400 10,400 10,400 10,400 10,400 10,400 10,400 10,400 10,400 10,400 10,400 124,800 163 443 Total Cable / Internet 17,050 17,050 17,050 17,050 17,050 17,050 17,050 17,050 17,050 17,050 17,050 17,050 204,600 266 726 General & Administrative Audit 6002-0200 0 0 9,000 0 0 1,600 0 0 0 0 0 0 10,600 14 38 Legal 6002-0300 150 150 150 150 150 150 150 150 150 150 150 150 1,800 2 6 Bank Charges/Fees 6005-0000 25 25 25 25 25 25 25 25 25 25 25 25 300 0 1 Data Processing/Computer Expense 6030-0000 150 150 150 150 150 150 150 150 150 150 150 150 1,800 2 6 Resident Screening 6095-0000 100 30 30 30 600 600 600 600 500 300 300 250 3,940 5 14 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 500 500 500 500 500 500 500 500 500 500 500 500 6,000 8 21 Postage & Delivery 6070-0000 250 600 250 250 600 250 250 250 250 600 250 250 4,050 5 14 Licenses, Fees & Permits 6060-0000 300 0 50 300 300 0 100 0 0 0 800 800 2,650 3 9 Portal Expense 6770-0000 0 0 0 0 0 0 2,400 0 0 0 0 0 2,400 3 9 Professional Fees 6080-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Supplies 6100-0000 200 200 200 200 200 200 200 200 200 200 200 200 2,400 3 9 Telephone 6105-0000 745 745 745 745 745 745 745 745 745 745 745 745 8,940 12 32 Telephone-Answering Service 6110-0000 125 125 125 125 125 125 125 125 125 125 125 125 1,500 2 5 Telephone-Radios/Pagers/Cell 6107-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 2 4 Training 6115-0000 0 0 0 0 1,000 300 0 0 0 0 0 0 1,300 2 5 Travel 6120-0000 100 1,000 100 250 250 1,200 500 900 900 250 250 1,200 6,900 9 24 Travel-Meals 6120-0300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Uniforms 6135-0000 100 100 100 100 500 100 100 100 100 100 100 500 2,000 3 7 Miscellaneous 6065-0000 300 300 300 300 300 300 300 300 300 300 300 300 3,600 5 13 Total General & Administrative 3,145 4,025 11,825 3,225 5,545 6,345 6,245 4,145 4,045 3,545 3,995 5,295 61,380 80 218 Payroll & Benefits Office Salaries 6205-0000 11,155 9,155 9,155 9,155 13,733 9,155 9,155 9,155 9,155 13,733 9,155 11,155 123,019 160 436 Performance 6265-0000 0 8,200 0 0 0 0 0 0 0 0 0 0 8,200 11 29 Leasing 6260-0000 8,500 0 0 0 0 500 500 500 500 0 0 0 10,500 14 37 Maintenance 6225-0000 10,139 8,139 8,139 8,139 12,208 8,139 8,139 8,139 8,139 12,208 8,139 10,139 109,806 143 389 Contract Labor 6250-0000 2,400 0 0 0 0 0 0 0 0 0 0 2,400 4,800 6 17 Payroll Taxes 6270-0100 3,847 3,047 2,067 2,067 3,100 2,126 2,126 2,126 2,126 3,100 2,067 2,831 30,631 40 109 Worker's Compensation 6270-0200 3,557 2,817 1,911 1,911 2,867 1,966 1,966 1,966 1,966 2,867 1,911 2,618 28,324 37 100 Group Insurance 6280-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 19 51 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 40,799 32,558 22,472 22,472 33,108 23,087 23,087 23,087 23,087 33,108 22,472 30,344 329,681 429 1,169 Contract Services Contract-Alarm/Monitoring-Intrusion/Fire 6305-0000 260 260 260 260 260 260 260 260 260 260 260 260 3,120 4 11 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 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 34,800 45 123 Contract-Other Contract Services 6345-0000 250 250 250 250 250 250 250 250 250 250 900 900 4,300 6 15 Contract-Security/Patrol/Courtesy Officer 6365-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 17 47 Contract-Pest Control 6350-0000 700 550 550 550 550 550 550 550 550 700 550 550 6,900 9 24 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 3,900 1,700 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 3,900 21,200 28 75 Total Contract Services 9,110 6,760 6,360 6,360 6,360 6,360 6,360 6,360 6,360 6,510 7,010 9,610 83,520 109 296 6/1/2012 Page 2of5 Ballpark at Austin Austin, TX 78681 2012/2013 Academic Operating Budget Template 282 = Units Gross Market Rent =$432 $432 768 = Beds Ave Gain (Loss) to Lease =$5 $5 250,218 =Sq Ft Ave Billing per Bed =$437 $437 G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 3/1/2012 Account Descriptions Repairs & Maintenance Appliances 6410-0000 4,000 800 800 800 1,400 1,400 800 800 800 2,500 2,500 2,500 19,100 25 68 Blind/Drapes 6415-0000 20 20 20 20 20 20 20 20 20 20 1,250 20 1,470 2 5 Boilers 6420-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Building - Interior 6425-0100 100 100 50 50 50 50 100 100 100 100 100 100 1,000 1 4 Building - Exterior 6425-0200 100 100 50 50 50 50 100 100 100 100 100 100 1,000 1 4 Common Areas 6440-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Countertops/Sink 6445-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Doors/Windows 6450-0000 250 50 50 50 50 50 50 50 50 50 250 500 1,450 2 5 Electrical 6455-0000 400 50 50 50 50 50 50 250 50 50 50 400 1,500 2 5 Elevators 6460-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Fencing & Gates 6470-0000 150 150 150 150 150 150 150 150 150 150 1,350 750 3,600 5 13 Fire/Saftey 6475-0000 600 350 300 350 300 350 300 300 300 4,800 300 300 8,550 11 30 Generator 6483-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Glass/Mirrors/Screens 6485-0000 200 200 200 200 200 200 200 200 200 200 200 200 2,400 3 9 Golf Carts 6490-0000 1,000 0 0 0 0 0 0 0 0 500 0 0 1,500 2 5 HVAC 6495-0000 2,500 1,000 500 250 250 400 1,000 1,000 1,650 1,650 1,500 1,500 13,200 17 47 Keys & Locks 6500-0000 900 50 50 50 50 50 50 50 50 50 50 900 2,300 3 8 Landscaping 6510-0000 50 50 50 50 50 50 50 50 50 50 50 50 600 1 2 Lights, Fixtures, Light Bulbs 6520-0000 1,000 100 100 100 100 100 100 100 100 300 300 500 2,900 4 10 Miscellaneous 6525-0000 100 100 100 100 100 100 100 100 100 100 100 100 1,200 2 4 Painting 6530-0000 300 50 50 100 100 100 100 100 100 100 300 100 1,500 2 5 Parking Lots & Sidewalks 6535-0000 0 0 0 0 0 0 0 0 0 0 0 1,500 1,500 2 5 Plumbing 6540-0000 1,950 250 800 250 500 800 500 800 500 750 800 1,950 9,850 13 35 Pools 6545-0000 750 200 200 200 300 300 700 700 700 700 700 700 6,150 8 22 Recreation 6550-0000 500 50 50 50 150 50 50 150 50 150 150 150 1,550 2 5 Roofs 6555-0000 300 0 0 300 0 0 300 0 0 300 0 0 1,200 2 4 Signs 6560-0000 500 0 0 0 0 0 0 0 0 0 0 500 1,000 1 4 Supplies 6570-0000 250 150 150 100 150 250 250 250 250 250 250 250 2,550 3 9 Tools 6575-0000 50 50 50 50 50 50 50 50 50 50 50 50 600 1 2 Total Repairs & Maintenance 15,970 3,870 3,770 3,320 4,070 4,570 5,020 5,320 5,370 12,920 10,350 13,120 87,670 114 311 Make-Ready Maintenance Carpet Cleaning/Repairs 6610-0000 30,450 30,450 0 0 165 0 0 0 495 0 0 0 61,560 80 218 Cleaning 6615-0000 16,625 16,625 0 0 400 0 0 0 1,200 0 0 0 34,850 45 124 Interior Repairs 6630-0000 43,000 0 0 0 0 0 0 40,000 0 0 1,500 1,500 86,000 112 305 Painting 6635-0000 22,850 22,850 0 0 565 0 0 0 1,695 0 0 0 47,960 62 170 Appliance Supplies 6652-0000 1,000 0 0 0 0 0 0 0 0 0 1,000 1,000 3,000 4 11 Cleaning Supplies 6655-0000 1,500 0 0 0 0 0 0 0 0 0 0 5 1,505 2 5 Paint Supplies 6660-0000 9,000 0 0 0 0 0 0 0 0 0 0 0 9,000 12 32 Total Make-Ready Maintenance 124,425 69,925 0 0 1,130 0 0 40,000 3,390 0 2,500 2,505 243,875 318 865 Marketing Advertising Print 6705-0200 300 300 300 300 150 150 150 800 150 0 0 500 3,100 4 11 Publications 6730-0000 3,000 0 1,250 1,400 2,200 1,900 0 750 0 3,800 500 0 14,800 19 52 Direct Mail 6715-0000 0 0 0 0 0 1,000 1,000 0 0 0 0 0 2,000 3 7 Radio 6705-0300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Signs 6735-0000 0 250 0 0 0 0 0 250 0 0 250 0 750 1 3 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 2,500 0 0 5,000 750 0 0 0 0 0 8,250 11 29 Locator Fees 6760-0000 5,000 15,000 3,000 1,000 1,000 0 0 0 0 0 0 0 25,000 33 89 Referral Fees 6780-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Promotion & Events 6775-0000 17,500 0 0 0 0 0 0 0 0 0 0 0 17,500 23 62 Resident Activities/Tenant Relations 6790-0000 1,000 1,200 600 600 750 1,000 750 600 600 300 300 300 8,000 10 28 Websites 6740-0000 800 800 800 800 800 800 800 800 800 800 800 800 9,600 13 34 Total Marketing 27,600 17,550 8,450 4,100 4,900 9,850 3,450 3,200 1,550 4,900 1,850 1,600 89,000 116 316 Utilities Electricity Elec-Common Area 6910-0100 3,750 3,000 2,750 2,250 2,500 2,750 2,750 2,750 2,750 2,750 2,750 2,750 33,500 44 119 Elec-Residential Units 6910-0200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Elec-Vacant Units 6910-0900 2,500 250 250 250 250 250 250 250 250 250 250 250 5,250 7 196/1/2012 Page 3of5 Ballpark at Austin Austin, TX 78681 2012/2013 Academic Operating Budget Template 282 = Units Gross Market Rent =$432 $432 768 = Beds Ave Gain (Loss) to Lease =$5 $5 250,218 =Sq Ft Ave Billing per Bed =$437 $437 G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 3/1/2012 Account Descriptions Total Electricity 6,250 3,250 3,000 2,500 2,750 3,000 3,000 3,000 3,000 3,000 3,000 3,000 38,750 50 137 Other Utilities Gas 6920-0000 225 225 225 225 225 225 225 225 225 225 225 225 2,700 4 10 Water / Sewer 6930-0000 26,475 24,282 26,261 24,425 18,533 24,773 23,597 23,300 25,578 24,225 23,637 22,092 287,178 374 1,018 Utility Billing Fee 6950-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Other Utilities 26,700 24,507 26,486 24,650 18,758 24,998 23,822 23,525 25,803 24,450 23,862 22,317 289,878 377 1,028 Total Utilities 32,950 27,757 29,486 27,150 21,508 27,998 26,822 26,525 28,803 27,450 26,862 25,317 328,628 428 1,165 Management Fees 4.00%6990-0000 10,302 12,790 12,830 12,918 12,600 12,600 12,656 12,560 12,584 12,564 12,270 12,308 148,981 194 528 Asset Management 1.00%3,044 3,044 3,044 3,044 3,044 3,044 3,044 3,044 3,044 3,044 3,044 3,044 36,528 48 130 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 General Liability 7105-0500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL OPERATING EXPENSES 284,395 195,329 115,287 99,639 109,315 110,904 103,734 141,291 105,283 121,091 107,403 120,193 1,613,862 2,101 5,723 (26,847)124,419 205,461 223,309 205,684 204,095 212,665 172,708 209,316 193,008 199,341 187,501 2,110,661 2,748 7,485 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 Carpet 8315-1000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Furniture 8315-5000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Vinyl/Tile 8315-1000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Recurring Capital 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Carports 8315-1100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Computers 8315-4000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NET OPERATING INCOME (LOSS) BEFORE DEBT SERVICE & CAPITAL 6/1/2012 Page 4of5 Ballpark at Austin Austin, TX 78681 2012/2013 Academic Operating Budget Template 282 = Units Gross Market Rent =$432 $432 768 = Beds Ave Gain (Loss) to Lease =$5 $5 250,218 =Sq Ft Ave Billing per Bed =$437 $437 G/L 2012/2013 Cost per Cost per Codes Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Forecast Bed Unit 3/1/2012 Account Descriptions 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 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Non Recurring Capital 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 Total Other Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 INCOME (LOSS) Before Depr / Amort (26,847)124,419 205,461 223,309 205,684 204,095 212,665 172,708 209,316 193,008 199,341 187,501 2,110,661 2,748 7,485 Distribution Payments 4201-0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 MONTHLY CASH FLOW (26,847)124,419 205,461 223,309 205,684 204,095 212,665 172,708 209,316 193,008 199,341 187,501 2,110,661 2,748 7,485 6/1/2012 Page 5of5