Loading...
HomeMy WebLinkAbout2003-2004 San Marcos Budget _ v r r , , z « , r " a , - Q 3 .4 " « x 1 2003 Budget Executive Summary 1 1. Jefferson Commons -San Marcos is currently 84% occupied for the 2002 -2003 academic year. The 2003 budget projects a Fall occupancy of 95% for an annual occupancy of 92 %. Market conditions remain competitive in the San Marcos sub - market; however, projected growth at Southwest Texas University and cooperation from the University to refer students to our property will aid our efforts in achieving this occupancy goal. Dents Average rents proposed in the 2003 budget are $420 per bed which is inclusive of the Common Area Fee formerly charged. For marketing purposes, JPI has eliminated this fee at all of its Student Living Communities. Same -store rent growth from 2002 -2003 including concessions is 6.96 %. Other Income Other income in 2003 is budgeted to be $138,973. 2003 proposed fees include: Application Fee: $35 Administrative Fee: $75 Security Deposit: $1251$225 Relet Fee: $200 Carport: $25 Total Income in 2003 is projected to be $2,503,863. Renewal Program Renewal letters will be sent to each resident offering the option to renew at a $10 discount below proposed market rates. The resident is guaranteed their current bedroom if they sign during this renewal period. Additional concessions have been budgeted as leasing incentives in order to compete with new apartment communities. Expenses Total operating expenses for 2003 are $707,867 compared to an annualized 2002 operating expense total of $772,841. This expense growth reflects an 8.41% decrease in operating expenses. The largest decrease occurs in Personnel Expense and is due to a cut in staff. NOI 2002 NOI is projected to be $1,795,996. Other Expenses Interest Expense: $1,617,964 is included for monthly and quarterly interest payments. Reserves: $5,406 has been itemized each month for Replacement Reserves (annual total of $64,872). Budgeted reserve expenses of $26,292 are also included for a net of $38,580. Item Month Ex erase Paving January $450 Other January /July $10,300 HVAC Replacement April /June /August $1,050 Carpet Replacement May /August $9.900 Countertops August $400 Doors August $1,000 Light Fixtures August $500 B linds/Fans August $1,000 Vinyl /Appliances August $1,692 Total $26,292 Servicing Fee: $5,000 has been included for the annual Servicing Fee. (This item is accounted for in the Startup Marketing line item.) Bond Trustee Fee: $3,816 has been included for the annual Bond Trustee Fee. (This item is accounted for in the Startup Marketing line item.) Issuer Fee: $10,000 has been included for the annual Issuer Fee. (This item is accounted for in the Startup Marketing line item.) Program Administrator Fee: $10,000 has been included as an accrual for the annual Program Administrator Fee. Asset Management Fee: This expense falls in the flow of funds after the above fees. Due to projected lower cash flow in the 2003 budget, this expense was not included. Remainder of Property Management Fee: This expense falls in the flow of funds after the above fees. Due to projected lower cash flow in the 2003 budget, this expense was not included. Principal Payment: $78,382 is included for Principal Payments. Net Cash ?Flow Net Cash Flow, after all necessary adjustments and accruals, is $7,897 for 2003. Number of Beds: 553 Project Net Rentable Sq, Ft.: 179,072 JPI MULTIFAMILY, INC. 2003 OPERATING BUDGET BY MONTIi Jefferson Commons - San Marcos SUMMARY Accrued Expenses (Non-cash) Program Administrator Fee 833 833 833 833 833 833 833 833 833 833 833 833 10,000 $18 Total Accrued Expenses 833 833 833 833 833 833 833 833 833 833 833 833 10,000 $18 Cmoro,y saaraary 2003 2003 Per Jan -03 Feb -03 Mar -03 Apr-03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 BudgetTotal Bed $2,792,376 $1.299 Scheduled Rental laconic $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 Gain (Loss) to Lease (16,590) (16,590) (16,590) (16,590) (16,005) (16,005) (16,005) (1,050) (1,050) (1,050) (1,050) (1,050) (119,624) (0.056) Gross Potential Rent $216,108 $216,108 $216,108 $216,108 $216,693 $216,693 $216,693 $231,648 $231,648 $231,648 $231,648 $231,648 $2,672,752 $1.244 Other Adjustments (934) (961) (961) (961) (960) (956) (956) (1,071) (1,109) (1,109) (1,109) (1,109) (12,195) (0.006) Lease Concession Loss (2,470) (,4,940) (4,940) (4,940) (4,940) (4,940) (,4,940) (7,430) (7,450) (4,980) (4,980) (4,980) (61,930) (0.029) Concession Loss as 7 of Sch. Rent 1.067 2.12% 2.127 2.127 2.127 2.1217 2,12% 3.1970 3.207 2.147 2.14'7 2.14;, 2.227 Vacancy Loss (29,351) (23,888) (23,888) (23,888) (24,712) (25,535) (,25,535) (17 „516) (9,776) (9,883) (9,883) (9,883) (233,737) (0.109) Vacancy Loss as 7 of Sch. Rent 12.617 10.277 10.277 10.277 10.627 10.977 10.977 7.537 4.207 4.257 4.257 4.25% 8.377 Rental laconic $183,353 $186,319 $186,319 $186,319 $186,082 $185,262 $185,262 $205,631 $213,313 $215,676 $215,676 $215,676 $2,364,890 $1.101 Other Income 14,015 14,163 14,163 14,262 14,163 14,124 14,124 8,735 7,781 7,781 7,781 7,880 138,973 21 Total Income $197,368 $200,482 $200,482 $200,581 $200,245 $199,386 $199,386 $214, 366 $ 221,094 $223,458 $223,458 $223,557 $2,503,863 $1.165 Personnel Expense $14,244 $13,644 $13,968 $14,043 $13,477 $13, 456 $14, 043 $14, 145 $13,019 $13,095 $12,508 $12,508 $162,151 $293 Connact Services 150 150 2,150 150 2,150 150 2,150 150 2,150 150 150 150 9,800 18 Repair & Maintenance 1,685 425 825 1,300 1,425 1,650 1,600 2,235 1,300 1,025 500 1,050 15,020 27 Turnover Expcme 0 0 0 1,250 2,131 881 0 22,559 22,059 0 0 0 48,880 1 88 Total Repairs /Contract /Turnover 1,835 575 2,975 2,700 5,706 2,681 3,750 24,944 25,509 1,175 650 1,200 73,700 133 Utilities 20,222 20,222 20,222 20,222 20,222 20,222 20,222 22,452 20,222 20,222 20,222 20,222 244,894 443 Advertising & Promotion 4,693 968 4,607 4,018 1,595 1,068 1,218 2,405 718 218 818 218 22,544 41 Administration 1,450 1,310 1,410 1,500 1,410 1,310 1,850 3,810 1,460 1,350 1,310 1,310 19,480 35 Management Fee 9,500 9,500 9,500 9.500 9,500 9,500 9,500 9,500 9,500 9,500 9,500 9,500 114,000 206 hrsuranee 5 ,278 5,278 5,278 5,278 5,278 5,278 6,521 6,521 6,597 6,597 6,597 6,597 71,098 129 'rota) Controllable Expenses $42,444 $36,720 $43,182 $42,483 $42,410 $38,737 $41,083 $67,756 $60,928 $36,060 $35,508 $35,458 $522,769 $945 Toad Non - Controllable Expenses 14,778 14,778 14,778 14,778 14,778 14,778 16,021 16,021 16,097 16,097 16,097 16,097 185,098 335 Total Operating Expense $57,222 $51,498 $57,960 $57, 261 $57,188 $53,515 $57,104 $83,777 $77,025 $52,157 $51,605 $51,555 $707,867 $1,280 Net Operating Income (Loss) $140,146 $148,985 $142,522 $143,320 $143,057 $145,871 $142,281 $ 130, 589 $ 144,070 $171,301 $171,853 $172,002 $1,795,996 $3,248 I nterest Expense $135,072 $135,029 $134,986 $134,942 $134,899 $134,854 $134,810 $134,765 $134,720 $134,675 $134,629 $134583 $1,617,964 $2,926 Combined DCR (he. Principal) 0.95 1.02 0.97 0.98 0.97 0.99 0.97 0.89 0.98 137 1.18 1.18 1.02 Cash Flow after Interest $5,074 $13,955 $7,536 $8,377 $8,158 $11,016 $7,472 ($4,176) $9,350 $36,626 $37,224 $37,419 $178,032 $322 Reserves $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $64,872 $1.17 Start -Up Expense 1,568 1,568 1,568 1,568 1,568 1,568 1,568 1,568 1,568 1,568 1,568 1,568 18,816 34 Capital 3,250 (3,250) 0 350 (50) 50 7,150 7,042 (14,542) 0 0 0 0 0 Other Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NCF(Before Cash Adj.) ($5,150) $10,231 $562 $1,053 $1,234 $3,992 ($6,652) ($18,192) •$16,918 $29,652 $30,250 $30,445 $94,344 $171 'total Cash Adjustments: Tools & Equipment (Capital) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Computer Equipment (Capital) 0 0 0 0 0 0 0 0 0 0 0 0 0 Copier Equipment (Capital) 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance (5,278) (5,278) (5,278) (5,278) (5.278) (5,278) 72,642 (6,521) (6,597) (6,597) (6,597) (6,597) 8,065 Property Tax 0 0 0 0 0 0 0 0 0 0 0 0 0 Principal 6,290 6,333 6,376 6,420 6,464 6,508 6,552 6,597 6,642 6,688 6,733 6,779 78,382 Total Cash Adjustments $1,012 $1,055 $1,098 $1,142 $1,186 $1,230 $79,194 $76 $45 $91 $136 $182 $86,447 NCF(After Cash Adj.) ($6,162) $9,177 ($536) ($88) $49 $2,762 ($85,847) ($18,268) $16,872 $29,562 $30,114 $30,263 $7,897 Accrued Expenses (Non-cash) Program Administrator Fee 833 833 833 833 833 833 833 833 833 833 833 833 10,000 $18 Total Accrued Expenses 833 833 833 833 833 833 833 833 833 833 833 833 10,000 $18 Cmoro,y saaraary Number of Beds: Project Net Rentable Sq. Ft.: Project Number: RENTAL INCOME 4025 Scheduled Rent Income 4030 Gain (Loss) to Lease 4050 Vacancy Loss 4065 Non - Revenue Beds 4060 Lease Concessions 4082 Write Off 4075 Accelerated Rent 4080 Write -Offs Accelerated Rent 4040 MTM Rent Premium 4045 Rent Premium - Short Tenn Total Rental Income JPI MULITFAMILY, INC. 2003 OPERATING BUDGET DETAII, SUMMARY Jefferson Commons - San Marcos 4091 10:25 AM 10252002 3013000 2003 2003 Per Jan -03 Feb-03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug-03 Sep -03 Oct -03 Nov -03 Dec -03 BudgetTotal Bed $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $232,698 $2,792,376 $420.79 (16,590) (16,590) (16,590) (16,590) (16,005) (16,005) (16,005) (1,050) (1,050) (1,050) (1,050) (1,050) (I19,624) ($18.03) (29,351) (23,888) (23,888) (23,888) (24,712) (25,535) (25,535) (17,516) (9,776) (9,883) (9,883) (9,883) (233,737) ($3522) 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 (2,470) (4,940) (4,940) (4,940) (4,940) (4,940) (4,940) (7,430) (7,450) (4,980) (4,980) (4,980) (61,930) ($933) (934) (961) (961) (961) (960) (956) (956) (1,071) (1,109) (1,109) (1,109) (1,109) (12,195) ($1.84) 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 $183,353 $186.319 $186,319 $186,319 $I86,082 $185,262 $185,262 $205,631 $213,313 $215,676 $215,676 $215,676 $2,364,890 $356.37 OTHER INCOME 4095 -00001 Garage / Carport Rent 4095 -00002 Garage / Carport Rent Concessions 4095 -00003 Garage/ Carport Rent Expense 4105 Pet Fees/Rent/Non -Refd. Dep. 4110 Senior Program Amenities Income 4115 -00001 Storage Rental Income 4125 Washer/Dryer Rent Washer/Dryer Rent Concessions (acct. 4125) Washer/Dryer Expense (acct. 4125) 4135 Club Room Fees 4145 Laundry Facility Income 4155 Vending Income 4160 Telephone/Cable /Alarm 5427 Utility Reimbursement 4170 Car Wash Income Car Wash Expense (acct. 4170) Application Fees Application Fee Expense 4185 Cancellation Fees 4187 Write -offs Cancellation Fees 4190 Relet Fees 4200 NSF Fees 4205 Late Fees 4210 Access Card Fees 4215 Damages 4215 -00002 Damages- Carpet 4215 -00001 Write - offs - Damages 4217 Non - Refundable Redecorating Fees 4220 Forfeited Deposits 4305 Miscellaneous Resident Charges 4510 Short-Term Investments 4515 Interest Income Escrow 4525 Interest Income Other 4520 Notes Receivable 4160 -00001 Telephone Units Income Telephone Units Expense (acct. 4160 -000( 4160 -00002 Cable Units Income Cable Units Expense (acct. 4160 - 00002) 10252002 10:25 AM $5,160 $5,160 $5,160 $5,160 $5,160 $5,160 $5,160 $5,160 $5,160 $5,160 $5,160 $5,160 $61,920 $9.33 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 100 0 0 0 100 0 0 0 100 300 0.05 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 c 0 0 0 0 0 0.00 1,768 1,768 1,768 1,768 1,768 1,768 1,768 1,768 0 0 0 0 14,140 2.13 (707) (707) (707) (707) (707) (707) (707) (707) 0 0 0 0 (5,656) (0.85) 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 270 300 300 300 300 300 300 300 330 330 330 330 3,690 0.56 1,880 2,000 2,000 2,000 2,000 1,960 1,960 1,960 2,120 2,120 2,120 2,120 24,240 3.65 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5,543 5,543 5,543 5,543 5,543 5,543 5,543 0 0 0 0 0 38,800 5.85 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 200 200 200 200 200 200 200 200 200 200 200 200 2,400 0.36 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Line Item Summary Page 117 Number of Beds: Project Net Rentable Sq. FL: Project Number: 4247 Water & Sewer Units Income Salaries - Management Water & Sewer Units Expense (acct 4247) Overtime- Management SH - Long Distance Revenue (acct. 4305) 4255 -00001 Commom Area Fee 4255 -00002 Common Area Fee Concessions 4260 Lease Violations income 4311 Write -offs Other Income Total Other Income 5190 TOTAL INCOME PERSONNEL EXPENSE 5023 Salaries - Management 5046 Overtime- Management 5047 Overtime- Service 5025 Hourly Wages - Service 5026 Hourly Wages - Housekeeping 5061 Temporary Employment -Mgt, 5062 Temporary Employment -Sere. 5190 Leasing Commissions 5080 Payroll Taxes 5090 Group Insurance 5100 Workers Compensation 5105 Employer 401 k Contribution 5110 Other Benefits 4085 Employee Rent Discount 5114 Uniforms 5146 Employee Screening Fees 5147 Employment Fees and Expenses 5148 Employee Moving Expenses 5149 Help Wanted Newspaper Ads 591 Other Personnel Expense Personnel Expense CONTRACT SERVICES 6110 Exterminating 6115 Landscape Contract 6120 PondsILake/Fount. - Contr. 6125 Pool Contract 6130 Protection Services Contract 6135 Snow/Ire Removal Contract 6140 Elevator Maintenance Contract 6145 Cleaning 6150 Other Contract Services Total Contract Services JPI MULITFAhIILY, INC. 2003 OPERATING BUDGET DETAIL SUMMARY Jefferson Commons - San Marcos 10:25 AM 10252002 553 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $52,000 $94.03 179,072 0 0 0 0 0 0 0 0 0 0 0 0 0.00 3013000 591 591 591 591 591 591 591 591 591 591 591 7,092 12.82 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 2003 2003 Per Jan-03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug-03 Sep-03 Oct -03 Nov -03 Dec -03 BudgetTotal Bed 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 50 50 50 50 50 50 50 50 50 50 50 50 600 0.09 (149) (150) (150) (151) (150) (150) (150) (95) (79) (79) (79) (80) (1,461) (0.22) $14,015 $14,163 $14,163 $14,262 $14,163 $14,124 $14,124 $8,735 $7,781 $7,781 $7,781 $7,880 $138,973 $20.94 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 $197,368 $200,482 $200,482 $200,581 $200,245 $199,386 $199,386 $214,366 $221,094 $223,458 $223,458 $223,557 $2,503,863 $4,528 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $52,000 $94.03 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 591 591 591 591 591 591 591 591 591 591 591 591 7,092 12.82 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 5,465 65,580 118.59 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 934 934 934 934 934 934 934 934 0 0 0 0 7,470 13.51 1,011 973 842 810 831 810 810 1,499 801 795 795 795 10,771 19.48 833 833 833 833 833 833 833 833 833 833 833 833 10,000 18.08 347 347 347 347 347 347 347 347 347 347 347 347 4,164 7.53 143 143 143 143 143 143 143 143 143 143 143 143 1,716 3.10 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 480 0 0 0 0 0 480 0 0 0 960 1.74 487 25 0 487 0 0 487 0 25 487 0 0 1,998 3.61 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 100 0 0 100 0 0 100 0 0 100 0 0 400 0.72 0 0 0 0 0 0 0 0 0 0 0 0 $0 $0.00 $14,244 $13,644 $13,968 $14,043 $13,477 $13,456 $14,043 $14,145 $13,019 $13,095 $12,508 $12,508 $162,151 $293.22 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 0 0 2,000 0 2,000 0 2,000 0 2,000 0 0 0 8,000 14.47 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 150 150 150 150 150 150 150 150 150 150 150 I50 1,800 325 $150 $150 $2,150 $150 $2,150 $150 $2,150 $150 $2,150 $150 $150 $150 $9,800 $17.72 UTILITIES 5411 Electricity - House $2,148 $2,148 $2,148 $2,148 $2,148 $2,148 $2,148 $2,148 $2,148 $2,148 $2,148 $2,148 $25,776 $46.61 5413 EIectricity - Vacant 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5412 Electricity - Models 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5456 Gas 248 248 248 248 248 248 248 248 248 248 248 248 2,976 5.38 10252002 10:25 AM Line Stem Summary Page 2 / 7 JPI MULITFANHLY, INC. 2003 OPERATING BUDGET DETAIL SUMMARY Jefferson Commons - San Marcos 10:25 AM 10252W2 Number of Beds: Project Net Rentable Sq. Ft.: 553 179,072 Project Number.- 6160 3013000 $125 $0 $0 $0 $0 $125 $0 $0 $0 $0 $0 $0 $250 $0.45 6165 Appliance Repair 150 150 150 150 150 250 250 500 175 175 175 2003 2003 Per 4.43 6170 Jan-03 Feb-03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug-03 Sep-03 Oct -03 Nov -03 Dec -03 BudgetTotal Bed 5458 Gas -Vacant 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5436 Water /Sewer 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 20,400 36.89 5438 - Water /Sewer Vacants 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -00 5475 Refuse Removal 370 370 370 370 370 370 370 2,600 370 370 370 370 6,670 12.06 5515 Resident Telephone Expense 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 36,240 65.53 5442 Resident Water 1,436 1,436 1,436 1,436 1,436 1,436 1,436 1,436 1,436 1,436 1,436 1,436 17,232 31.16 5525 Resident Internet 8,300 8,300 8,300 8,300 8,300 8,300 8,300 8,300 8,300 8,300 8,300 8,300 99,600 180.11 0.00 Resident Electricity (acct. 5413) 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5414 Utility Reimbursement/Electricity 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5515 Utility Reimbursement/Water & Sewer 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5515 Telephone Reimbursement 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5505 Cable 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000 65.10 5520 Other Fuels / Diesel 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Total Utilities $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $22,452 $20,222 $20,222 $20,222 $20,222 $244,894 $442.85 INTERIOR MAINTENANCE 6275 Pool & Spa Supplies 6160 Alarm System Repair $125 $0 $0 $0 $0 $125 $0 $0 $0 $0 $0 $0 $250 $0.45 6165 Appliance Repair 150 150 150 150 150 250 250 500 175 175 175 175 2,450 4.43 6170 Cable TV Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6175 Counter Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6225 Elevator Repairs 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6180 Fireplace Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6230 Interior Corridor 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6185 Interior Electrical Repair 100 0 0 100 0 0 100 0 0 100 0 0 400 0.72 6190 Interior Light Bulbs 50 0 0 50 0 0 0 100 0 50 0 0 250 0.45 6195 Interior Paint 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6265 Interior Repairs 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6205 Interior Sheetrock Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6210 Interior Vinyl & Tile 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6235 Janitorial Supplies 50 50 50 50 50 50 50 50 50 50 50 50 600 1.08 6240 Window Covering Repair 75 0 0 75 0 0 75 0 0 75 0 0 300 0.54 6215 Plumbing Repair 100 0 0 100 0 0 100 0 0 100 0 0 400 0.72 Recreation Facilities Repair 100 0 0 250 0 0 50 0 0 50 0 0 450 0.81 Wallpaper Repair (acct. 6195) 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6200 Carpet Cleaning/Repair/Dyes 50 0 0 50 0 0 0 50 50 0 0 0 200 0.36 6250 Locks and Keys 25 0 25 0 25 0 25 0 25 0 25 0 150 0.27 6265 Other Interior Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 4215 Tenant Reimbursement Stdnt Housing 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Tenant Reimb. - Collection Loss 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Total Interior Maintenance $825 $200 $225 $825 $225 $425 $650 $700 $300 $600 $250 $225 $5,450 $9.86 EXTERIOR MAINTENANCE 6275 Pool & Spa Supplies $100 $100 $350 $350 $450 $450 $450 $450 $400 $300 $100 $100 $3,600 $6.51 Pool In -House (acct. 6275) 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6280 Golf Can Repair 25 25 25 25 25 25 25 25 25 25 25 25 300 0.54 6285 HVAC Repair/Maintenance 610 0 0 0 600 550 350 960 350 0 0 350 3,770 6.82 Boiler Parts and Repairs (acct. 6285) 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6290 Landscape Supplies 0 0 100 0 0 100 0 0 100 0 0 0 300 0.54 6295 Ponds/Lakes/Fount. R &M 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6145 Contract Cleaning 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6305 Exterior Walls 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6310 Roof Repairs 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6315 Windows and Screens 100 100 100 100 100 100 100 100 100 100 100 100 1,200 2.17 1025/2002 10:25 AM Line Item Summary Page 3 17 JPI MULITFAMILY, INC. 2003 OPERATING BUDGET DETAIL SUMMARY Jefferson Commons - San Marcos 1025 AM 10252002 Number of Beds: 553 Project Net Rentable Sq. FL: 179,072 $0 $0 $0 $65 $65 $0 $1,580 $1,580 $0 $0 $0 $3,290 $5.95 Project Number: 3013000 0 0 0 (33) (33) 0 (790) (790) 0 0 0 (1,645) (2.97) 6390 Carpet Cleaning 0 0 0 0 163 163 0 3,950 3,950 0 0 0 2003 2003 Per 6395 Carpet Cleaning Reimbursement Jan-03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jut -03 Aug-03 Sep-03 Oct -03 Nov -03 Dec -03 BudgetTotal Bed 6370 Other Exterior Repairs/Maint. 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6320 Exterior Paint 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6325 Exterior /Garage Elect. Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6330 Exterior Light Bulbs 25 0 25 0 25 0 25 0 25 0 25 0 150 0.27 6345 Access Gate Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6350 Walks & Parking Lots 0 0 0 0 0 0 0 0 0 0 0 250 250 0.45 6355 Garage/Carport R &M 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6360 Tools & Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6335 Exterior Plumbing 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6365 Fence Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Total Exterior Maintenance $860 $225 $600 $475 $1,200 $1,225 $950 $1,535 $1,000 $425 $250 $825 $9,570 $17.31 Newsletters 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Total R & M(Does not include Cont. Serv.) $1,685 $425 $825 $1,300 $1,425 $1,650 $1,600 $2,235 $1,300 $1,025 $500 $1,050 $15,020 $27.16 TURNOVER EXPENSE 6380 Interior Repairs $0 $0 $0 $0 $65 $65 $0 $1,580 $1,580 $0 $0 $0 $3,290 $5.95 6385 Interior Repairs- Reimbursement 0 0 0 0 (33) (33) 0 (790) (790) 0 0 0 (1,645) (2.97) 6390 Carpet Cleaning 0 0 0 0 163 163 0 3,950 3,950 0 0 0 8,225 14.87 6395 Carpet Cleaning Reimbursement 0 0 0 0 (98) (98) 0 (2,370) (2,370) 0 0 0 (4,935) (8.92) 6405 General Cleaning 0 0 0 0 260 260 0 6,320 6,320 0 0 0 13,160 23.80 6410 General CleaninL Reimbursement 0 0 0 0 (169) (169) 0 (4,108) (4,108) 0 0 0 (8,554) (15.47) 6415 Interior Paint 0 0 0 0 520 520 0 12,640 12,640 0 0 0 26,320 47.59 6420 Interior Paint-Reimbursement 0 0 0 0 (208) (208) 0 (5,056) (5,056) 0 0 0 (10,528) (19.04) 6425 Appliance Repair 0 0 0 0 0 0 0 350 350 0 0 0 700 1.27 6430 Lock/Keys 0 0 0 1,250 1,250 0 0 500 0 0 0 0 3,000 5.42 6435 Interior Light Bulbs 0 0 0 0 0 0 0 150 150 0 0 0 300 0.54 6440 Window Coveting Repair 0 0 0 0 0 0 0 150 150 0 0 0 300 0.54 6445 Tenant Reimbursement 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6450 Write -Offs /tenant Reimbursement 0 0 0 0 380 380 0 9,243 9,243 0 0 0 19,247 34.80 Total Turnover Expense $0 $0 $0 $1,250 $2,131 $881 $0 $22,559 $22,059 $0 $0 $0 $48,880 $88.39 Newsletters 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 ,VERTISING & PROMOTION 6640 Traffic Counter $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 6645 Locator Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6650 Locator Relations 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6655 Resident Relations 175 100 100 100 127 100 0 1,062 0 0 0 0 1,764 3.19 6656 Resident Functions 300 0 0 1,250 100 100 100 0 500 0 600 0 2,950 5.33 6657 Resident Referrals 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6670 Newspaper 500 500 500 500 500 500 500 500 0 0 0 0 4,000 7.23 6675 Magazines 0 0 1,830 0 0 0 0 0 0 0 0 0 1,830 3.31 6677 Yellow Pages 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6680 Billboards 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6685 Brochure Advertising 3,000 0 0 0 0 0 0 0 0 0 0 0 3,000 5.42 6690 Direct Mail 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6695 Apartment Guides 150 150 150 150 150 150 150 150 0 0 0 0 1,200 2.17 6700 Signage /Sign Placement 0 0 309 0 0 0 0 0 0 0 0 0 309 0.56 6625 Newsletters 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6705 Radio / TV 0 0 0 1,500 0 0 0 0 0 0 0 0 1,500 2.71 6735 Video Marketing 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6715 Internet Advertising 193 193 193 193 193 193 193 193 193 I93 193 193 2,316 4.19 6720 Model Apartment Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6725 Flags / Banners / Mats 350 0 0 0 0 0 250 0 0 0 0 0 600 1.08 10252002 10:25 AM Line Item Summary Page 4 / 7 Number of Beds: Project Net Rentable Sq. FL: P *nject Number: 553 179,072 3013000 JPI MULITFAMILY, INC. 2003 OPERATING BUDGET DETAIL SUMMARY Jefferson Commons - San Marcos 10:25 AM 102512002 ADMINISTRATION 2003 2003 Per 5838 Bank Charges Jan-03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep-03 Oct -03 Nov -03 Dec -03 BudgetTotal Bed 6730 Office Refreshments 25 25 25 25 25 25 25 500 25 25 25 25 775 1.40 Other Advertising & Marketing (acct. 6735) 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6658 Campus Events 0 0 1,500 300 500 0 0 0 0 0 0 0 x _ ,300 4.16 COOP Advertising Reimbursement (acct. 6735 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Total Advertising & Promotion $4,693 $968 $4,607 $4,018 $1,595 $1,068 $1,218 $2,405 $718 $218 $818 $218 $22,544 $40.77 ADMINISTRATION 5838 Bank Charges $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 5855 Common Facility Dues 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5820 Computer Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5847 Copier /Fax Expense 225 225 225 225 225 225 225 225 225 225 225 225 2,700 4.88 5887 Employee Training/Education 20 20 20 20 20 20 20 20 20 20 20 20 240 0.43 7960 Employee Relations 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 6910 Legal and Professional 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5852 Licenses / Permits / Fees 0 0 0 150 0 0 0 0 150 0 0 0 300 0.54 5845 Fire Alarm Inspection 0 0 0 0 0 0 0 2,500 0 0 0 0 2,500 4.52 7210 Employee Travel/Mileage Reimb_ 15 15 15 15 15 15 15 15 15 15 15 15 180 0.33 5860 Apartment Assoc. Functions 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5843 Office Decorations 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5842 Office Supplies 50 50 50 50 50 50 50 50 50 50 50 50 600 1.08 5805 Postage / Courier / Freight 226 226 226 226 226 226 226 226 226 226 226 226 2,712 4.90 5846 Printing and Stationary 100 0 100 0 100 0 500 0 0 0 0 0 800 I.45 5865 Security/ Alarm Response 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5841 Storage / Office Furn. Rental 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5656 Telephone - Base 335 335 335 335 335 335 335 335 335 335 335 335 4,020 727 5657 Telephone - Long Distance 300 300 300 300 300 300 300 300 300 300 300 300 3,600 6.51 5665 Answering Service/Pagers 139 139 139 139 139 139 139 139 139 139 139 I39 1,668 3.02 5844 Safety Equipment 40 0 0 40 0 0 40 0 0 40 0 0 160 0.29 5839 Employee Evaluations 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 5890 Other Administrative Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 T -1 Administration Expense $1,450 $1,310 $1,410 $1,500 $1,410 $1,310 $1,850 $3,810 $1,460 $1,350 $1,310 $1,310 $19,480 $3523 MANAGEMENT FEE 7420 Property Management Fee $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $114,000 $206.15 Total Management Fee $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $114,000 $206.15 INSURANCE 7510 Property insurance $5,278 $5,278 $5,278 $5,278 $5,278 $5,278 $6,521 $6,521 $6,597 $6,597 $6,597 $6,597 $71,098 $128.57 Total Insurance $5,278 $5,278 $5,278 $5,278 $5,278 $5,278 $6,521 $6,521 $6,597 $6,597 $6,597 $6,597 $71,098 $128.57 TOTAL OPERATING EXPENSES $57,222 $51,498 $57,960 $57,261 $57,188 $53,515 $57,104 $83,777 $77,025 $52,157 $51,605 $51,555 $707,867 $1,280.05 NET OPERATING INCOME $140,146 $148,985 $142,522 $143,320 $143,057 $145,871 $142,281 $130,589 $144,070 $171,301 $171,853 $172,002 $1,795,996 $3,247.73 Total Of'99 Budget & Actual Accounts Not Included Above DEBT SERVICE -See Notes Below 2350 Principal Payment -Not in Total Debt Sery $6,290 $6,333 $6,376 $6,420 $6,464 $6,508 $6,552 $6,597 $6,642 $6,688 $6,733 $6,779 $78,382 9425 Interest Payment - Construction 135,072 135,029 134,986 134,942 134,899 134,854 134,810 134,765 134,720 134,675 134,629 134,583 1,617,964 2,925.79 10252002 10:25 AM Line Item Summary Page 5 / 7 JPI MULITFAMILY, INC. 2003 OPERATING BUDGET DETAIL SUMMARY Jefferson Commons - San Marcos 10:25 AM lufnfu02 Number of Beds: 553 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 Project Net Rentable Sq. Ft.: 179,072 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $18,816 Project Number: 3013000 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9906 Partnership Expense - Other 0 CAPITAL EXPENSE 0 0 0 0 0 0 0 0 0 2003 2003 Per 7814 Other Expense Jan-03 Feb-03 Mar -03 Apr -03 May -03 Jun -03 Jut -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 BudgetTotal Bed 9410 Interest Payment - Permanent 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9426 Interest Payment - Construction (Second) 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9415 Interest Payment- Permanent(Second) 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Total Debt Service $135,072 $135,029 $134,986 $134,942 $134,899 $134,854 $134,810 $134,765 $134,720 $134,675 $134,629 $134,583 $1,617,964 $2,926 RESERVES 0 0 0 0 0 0 0.00 9535 Structural Building Repair 0 0 0 0 0 Reserves $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $64,872 $117.31 Total Reserves $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $5,406 $64,872 $117.31 START - UP EXPENSE 0 0 0 0 0 0 0 0 0 0.00 9550 Cabinets 0 0 9830 - 25150000 Start-Up MarketingExp. $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 9900 Tax Return Prep Fees Total Start -Up Expense $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $1,568 $18,816 $34.03 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9906 Partnership Expense - Other 0 CAPITAL EXPENSE 0 0 0 0 0 0 0 0 0 0 0.00 7814 Other Expense 0 0 9510 Exterior Paint $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 9515 HVAC 0 0 0 350 0 350 0 350 0 0 0 0 1,050 1.90 9520 Landscape 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9525 Paving 450 0 0 0 0 0 0 0 0 0 0 0 450 0.81 9530 Signage 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9535 Structural Building Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9540 Gutter and Downspouts 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9545 Slab/Masonry 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9550 Cabinets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -00 9555 Carpets 0 0 0 0 300 0 0 9,600 0 0 0 0 9,900 17.90 9565 Ceramic Tile / Hearths 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9570 Countertops 0 0 0 0 0 0 0 400 0 0 0 0 400 0.72 9575 Doors 0 0 0 0 0 0 0 1,000 0 0 0 0 1,000 1.81 9580 Light Fixtures 0 0 0 0 0 0 0 500 0 0 0 0 500 0.90 9585 Mats 0 0 0 0 0 0 0 0 0 6 0 0 0 0.00 Oc40 BIinds 0 0 0 0 0 0 0 500 0 0 0 0 500 0.90 Model Cost 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 _v Plumbing 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9605 Recreation Facilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9610 Security System 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9615 Subfloor Replacement 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9620 Vinyl 0 0 0 0 0 0 0 100 0 0 0 0 100 0.18 9625 Wallpaper 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9630 Ceiling Fans 0 0 0 0 0 0 0 500 0 0 0 0 500 0.90 9635 Appliances 0 0 0 0 0 0 0 1,592 0 0 0 0 1,592 188 9645 Transportation 0 (3,250) 0 0 (350) (300) (350) (7,500) (14,542) 0 0 0 (26,292) (47.54) 9650 Other 2,800 0 0 0 0 0 7,500 0 0 0 0 0 10,300 18.63 Total Capital $3,250 ($3,256) $0 $350 ($50) $50 $7,150 $7,042 ($14,542) $0 $0 $0 $0 $0.00 OTHER EXPENSE 9900 Tax Return Prep Fees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 9904 -00002 Asset Management Fee 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9906 Partnership Expense - Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 7814 Other Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 9810 Performance Bonus - NOT BUDGETED 0.00 Total Other Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 10252002 10:25 AM Line Item Summary Page 6 / 7 Number of Beds: 553 Project Net Rentable Sq. Ft.: 179,072 Project Number: 3013000 NCF (Before Cash Adj.) 10:25 AM IOP -52002 JPI MULITFAMILY, INC. 2003 OPERATING BUDGET DETAIL SUMMARY Jefferson Commons - San Marcos 2003 2003 Per Jan-03 Feb-03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug-03 Sep-03 Oct -03 Nov -03 Dec -03 BudgetTotai Bed ($5,150) $10,.231 $562 $1,053 $1,234 $3,992 ($6,652) ($18,192) $16,918 $29,652 $30,250 $30,445 $94,344 $170.60 NOTES: I) Debt Service Total does not include prinicpal payments. Actual Debt Service does not include Int Exp - Intercompany or Deferred Financing Expense. Total Of-99 Budget & Actual Accounts Not Included Above 10252002 10:25 AM Line Item Summary Page 7 17 Jefferson Commons - SWT Hent Hecommenoatlons b 12 t% 2% 4su S 700 S aau > 700 S axi 750 $ ww 700 $ "' ' 700 S 705 Fall 2002 S 705 $ Proposed ..�,. 1.6% 2003 Percent Percent B1,62,B3(2 -2) Effective Average. L Proposed Start+ng , Market Increase from Increase Number of Number of 2002 Rent + Effective .Starting .Current Max Min '. Median Lease , Starting ' Renewal -1.87% Rent average tease front Median Students Average Max Students Average 2002: Efficfive Mkt Rent Rent :. nit Type Beds % of Totai ._ Rent R6nf Rent, Rent:. Resit :. Rate, ; Lease Rate Lease Rate t ,,UPM , : Growth rate. , Rents . - Increased, increase, Increase Decreased D6erease, Concessions , . Reef Gioypth .Growth , . Cammersts. Ll At (1 -1) b 12 t% 2% 4su S 700 S aau > 700 S axi 750 $ ww 700 $ "' ' 700 S 705 -.. $ 715 S 705 $ -- 673 ..�,. 1.6% 1.37% 2.16% B1,62,B3(2 -2) 68 12% S 530 S 499 S 545 S 249 S 530 S 523 $ 520 5 510 $ 491 1.6% -a58% -1.87% C2 (3 -3) 108 20% s 495 S 430 S 510 $ 314 S 430 S 439 $ 450 S 440 S 456 1.6% Z47% 4.67% of (4 -2) 168 30% S 425 $ 199 S 445 $ 199 S 335 S 308 $ 360 $ 350 s 376 1.6% 16.99% 7.49% D3 (4-4) 192 35% S 450 S 249 S 465 S 199 $ 395 $ 377 $ 399 $ 389 $ 404 16% 5.91 % 1.04% Totals/Averages 553 1o0% $ 467 S 312 S 484 S 240 $ 408 $ 391 $ 420 s 410 $ 422 1.6% 7.24% 2.97% Renewals is Proposed Renewal Weighted Goncessio ;Unit Type _ , Rents Rabb airg, ns, , Effective Rent, Growth Rate Et S 460 25% 467.50 10.00 457.50 -0.271/6 A7 (i -i) $ 705 25% 712.60 10 -00 702.60 4.16% WAITING TO SET RENTS UNTIL UPM IS RERUN 81,62,83 (2: S 510 25% 517.60 10.00 507.60 1.51 C2(3 -3) $ 440 25% 447.60 10.00 437.60 4.21% Di (4 -2) S 350 25% 357.60 1000 347.60 20,12% D3 (44) 5 389 25% 396.60 10.00 38660 5.48% Toteis(AVg S 409.59 25.00% S 417.09 $ 10.00 $ 407.09 9.11% Number of increases/decreases based upon proposed starting renewal lease rotes. 11 S 3.74 S 15.10 1 S (44.90) S 31 S 67457 S 685.36 6.01% 11 S 43.74 S 271.10 33 S (25.63) S 23 S 50005 S 508.05 4,01% 79 S .11.63 S 136.10 20 S (36.15) S 19 S 419.92 S 426.64 7.19% 103 S 68.13 S 161.10 39 S (3116) S 18 S 289.38 $ 294.01 24.44% 40 S 126.90 S 200.10 128 S (25.13) $ 10 S 366.52 S 372.38 _ 8.89% 246 $ 72.78 S 271.10 223 S (29.65) S 16.47 $ 377.45 $ 383.49 11.16% JPI MULTIFAMILY, INC. Jefferson Comt San Marcos 2003 OPERA, _..a BUDGET Data Input File Form:INPUT1 GENERAL PROPERTY INFORMATION Property Name J8ff9rSfi; p(YitritillS�Siniyiiibti'f' -' Property Code (Include all 7 digits ie 1077000) 721� Month to Start Budget (1 -12) 1 Year to Begin (enter year only 1,e, 2000, 2001, etc...) 2Q0g Total Beds in Property 553 Net Rentable Square Feet 179,072 RENT SCHEDULE Note: Current Rent Schedule as of sep oz m ; Should be on or before Leasing Assumptions date Total BED # of # of # of Avg. Avg. Avg. Avg. Total Net 'Rent Per I otal 553 177 324 1,012 $421 $1,315 $232,698 179,072 $1.299 232,698 1025/2fM2 10:05 AM Income Inpnl Page 1 / 19 Comments: TOTAL /AVG 0.00% 439 439 Maximum MTM as % of Occupied Beds 0 9Jnj % of Expirations that Go MTM #1,0 329 ........388 91.89% Enter Renewal Ratio Turnover 59% MONTHLY OCCUPANCY / RENTAL INCOME SCHEDULE LEASING ASGUMPTIONS IIIILJILWL 1 Current Occupancy Percent;- Feb -03 .9500 ° /u Apr -03 May -03 Jun -03 Maximum Occupancy „1OO:g9 ° /al Sep -03 Oct 03 Beginning Budget Occupancy Percent Dec -03 Yr. Total 84.99% (If after entering Move Ins you receive #N /A message anywhere in Date above should be on or after Rent Schedule date schedule below ,decrease Move Ins) Begin Occupancy % Rent Beginning Total MTM Lease New MTM MTM Other Total Move Ending Ending Month Increase Occupancy Expirations Leases Renewals Leases Move -Outs Move -Outs Move -Outs Ins Occupancy Occ % Aug 02 0104 -W 0 529 0 0 0 0 0 0 0 0 0 0 0 0.00% Sep 02 4 470 , is 0 0 0 0 0 0 0 0 0 495 470 85.00% Oct 02 491 470 e s t 0 0 0 0 0. Ending Occupancy% 470 85.00% Nov 02 Q{)s: 470 1 0 0 0 0 0 96% 470 85.00% Dec 02 d tlta9e, 470, i 0 0 0 0 �: �.'' 0s``, 470 85.00% Jan 03 00k "/. 470 0 0 0 0 0 495 89.51 Feb 03 495 r -, rr� 0 0 0 0 ;fi D 495 89.51% Mar 03 U � -. 495 i '" 0 0 0 0 r ' 0 ' s. 495 89,51% Apr 03 i3Q"f# 495 o 0 0 0 0 0: 495 89.51% May 03 OA 495%x` a 0 5 0 0 13 491 88.79 Jun 03 491 x sr / 0 0 0 0 0 491 88,79% Ju103YitOb 0 0 0 0 0= 491 88,79% Aug 03 4D�. 491 t $ ' 0 105 0 0 316 ` 5, t 529 95.66% Sep 03 itCtX},I 529 �/� ' r '; 0 0 0 0 0 529 95.66% Oct 03 i4 °. 529 0 0 0 0 0 529 95.66% Nov 03 t1 529 / " 0 0 0 0 0 529 95.66 Dec-03 „U� „! ,0,0q/a; 529 ,,...,, a ; 0 0 0 0 ., °,, > *<<,; 0 •- `, 529 95.86% Comments: TOTAL /AVG 0.00% 439 439 Maximum MTM as % of Occupied Beds 0 9Jnj % of Expirations that Go MTM #1,0 329 ........388 91.89% Enter Renewal Ratio Turnover 59% 10125/2002 ROS AM I.C.- meal Page 2 / 19 MONTHLY OCCUPANCY / RENTAL INCOME SCHEDULE Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct 03 Nov -03 Dec -03 Yr. Total Begin Occupancy % 85%1 90% 90% 90%1 90% 89% 89%1 89%1 96%1 96%1 96%1 96% 11 91% Begin Monthly Occupancy 470 495 495 495 495 491 491 491 529 529 529 529 503 Net Leases (Move -ins) Lease Expirations Renewals MTM's Move -Outs 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 18 5 0 13 0 0 0 0 0 0 0 0 0 0 354 421 105 0 316 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 388 439 110 0 329 Ending Mthly. Occupancy 495 495 495 495 491 491 491 529 529 529 529 529 508 Ending Occupancy% 90% 90% 90% 90% 89% 89% 89% 96% 96% 96% 96% 96% 92% 10125/2002 ROS AM I.C.- meal Page 2 / 19 10:05 AM 10252(%12 41- Scheduled Rental Income - ?d Rent by Mo., 232,698 232,698 232,698 232,698 232,65 232,698 232,698 232,698 232,698 232,698 232,698 232,698 2,7: Sc. edIncreases 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00°7 Scheduled Rent Per Sq. Ft. 1.300 1.300 1.300 1.300 1.300 1.300 1.300 1.300 1.300 1.300 1.300 1.300 1.300 Scheduled Rent Per Bed 421 421 421 421 421 1 421 421 421 421 421 1 421 421 421 Prior Actual: Income /BED: Income /PSF: Increase /Prior Y: 4030 Gain (loss) to Lease LtL /PSF /Mo: (0.668) LIL /BED: (216) LOSS TO LEASE Enter Loss to Lease as a NEGATIVE NUMBER and a Gain to Lease as a POSITIVE NUMBERI (105,746) Total Beds 553 (191) 5 5 t income /PSF: (0.591) N �� increase /Prior Y: -13% Aug -02 Sep -02 Oct -02 Nov -02 Dec -02 Aug -02 Sep -02 Oct -02 Nov -02 Dec -02 Actual Loss to Lease 0 0 0 0 0 (16,590) (16,590) (18,590) (16,590) Beginning Renewal Rate ($ < Market) (Cannot exceed January Avg, LTL) Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Gross Potential Rent 216,108 Jan-03 Feb -03 Mar -03 Apr -03 May -03 Jun•03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Renewal Rate Increase 10.00 (25.30) (25.30) (25.30) (25.30) (25.30) (25.30) (25.30) (25.30) (2530) (25.30) (25.30) Avg LTL - Mid (Unit) (35.30) (35.30) (35.30) (35.30) (3530) (35.30) (35.30 (35.30) (35.30) (35.30) (35.30) 2,873,178 5,196 16.045 -3% Loss to Lease (16,590) (16,590) (16,590) (16,590) (16,005) (16,005) (16,005) (1,050) (1,050) (1,050) (1,050) (1,050) (119,624) Gress Potential Rent Per Sq. Ft. 1.207 1.207 1.207 1.207 1.210 1.210 1.210 1.294 1.294 1.294 1.294 1.294 1.244 Comments: LtL /PSF /Mo: (0.668) LIL /BED: (216) E k # 1 Prior Actual: (105,746) f Income /BED: (191) 5 5 t income /PSF: (0.591) N �� increase /Prior Y: -13% Yr.Total Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Gross Potential Rent 216,108 216,108 216,108 216,108 216,693 216,693 216,693 231,648 231,648 231,648 231,648 1 231,648 2,672,752 4046 Rent Premium- Short Term For Leases <12 Months FM774 lJ Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 pct -03 Nov -03 Dec•03 Yr. Total 4050 Vacancy Loss (29,351) (23,888) (23,888) (23,888) (24,712) (25,535) (25,535) (17,516) (9,776) (9,883) (9,883) (9,883) (233,737) Comments: °Income /PSF: , „ ,,., r,. U•31,v ..,1,,. 5 ,.., , -, . .,, ,,;,, ,-,_T. Income /BED: (423) Prior Actual: (204,443) Income /BED: (370) Income /PSF: (1.142) Increase /Prior Y: •14% 10252002 10:05 AM Income Input Pnge 311`) J, 'on-Revenue BEDs Nui-er of Models in Project Oth-r Non - Revenue BEDs 4065 Non-Revenue BEDs Comments: CONCESSIONS Average Lease Term (months) • of Move Ins Utilizing a Concession • of Monthly Rent Conceeded ' Renewal Concession - % of Renewals Renewal Concession - % Conceeded Comments: "94Offul�g!"C�r o!Rp Jan 03 Feb 03 Mar-03 Apr-03 May-C, Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 0 T, 0 0 0 0 0 0 0 0 0 0 0 777777= 7777777 0 0 (4,940) (4,940) (4,940) (4,940) (4,940) (4,940) (4,940) I WOn M JIV21MKI� [7711, 1 Income/PSF: 0,000 Income/BED: 0 Prior Actual: 0 Income/BED: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 777777= 7777777 (4,940) (4,940) (4,940) (4,940) (4,940) (4,940) (4,940) (9,920) (4,980) (4,980) (4,980) (4,980) (2,470) (4,940) (4,940) (4,940) (4,940) (4,940) (4,940) (7,430) (7,450) (4,980) (4,980) (4,980) 0 0 (64,420) (64,420) (61,930) [i Income/PSF/Mo: (0,360) ncome/BED/Mo: (116.49)1 Prior Actual: 5262 Income/BED: 5C Income/PSF: Increase/Prior Y: -3061% 4082 Write Offs-Rental Income % of Gross Potential Rent less Vacancy Prior Yr. Actual 1 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec -03 Yr.7otai (934) (961)1 (961)1 (961)1 (960)1 (956)1 (956)1 (1,071)1 (1,109)1 (1,109)1 (1,100 (1,109)1 (12,195)1 1012512002 10:05 AM 1­.. Irpw Pq 4 / 19 40 Comments: 4080 Accelerated Rent (Based on "Other Move - Outs" times average rent per bed from base rent sc, `hru July then defaults to August of current budget year) PLEASE HARD CODE IF NECESSARY. Jan -03 Feb -03 I Mar -03 Apr -03 May -03 i... Jun -03 Jul -03 Auc -03 Seo -03 Write -Offs - Accelerated Rent Percent of Accelerated Rent Written Off: Net Accelerated Rent Dec -03 F Yr. Total ff; 0 Income /PSF: 0.000 Income /BED: 0 Prior Actual: 7,107 Income /BED: 13 incomelPSF: 0.040 Increase /Prior Y: 100 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Feb -00 Mar -00 I Apr -00 May -00 Jun -00 Jul -00 Aug -00 0 0 0 0 0 0 0 Q 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 Yr. Total 0 0 vurer rear rtenrnr mcwne 4040 MTM Premium per BED as % of Scheduled Rent p,00a Apt. Rental Income MTM Rent Premium Net Rental Income Collected per Occupied Sq. Ft. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 160,883 186,319 186,319 186,319 186,082 185,262 185,262 203,141 215,783 215,676 215,676 215,676 0 0 0 0 0 0 0 0 0 0 0 0 180,883 186,319 186,319 186,319 186,082 185,262 185,262 203,141 215,783 215,676 215,676 215,676 1.158 1.162 1.162 1.162 1.166 1.165 1.165 1.230 1.260 1.259 1.259 1.259 Yr. Total 2,362,400 0 2,362,400 1.203 10/252002 10:05 AM income Npm Pnp 5 / 19 4 WRITE -OFFS OTHER INCOME % of Other Income Written Off; 1,00, %, < ...... ENTER ZERO IF HARDCODINGIII 0.00 Jan -03 Feb -03 I Mar -03 Apr -03 May -03 Jun -03 Jan -03 Feb -03 Mar -03 I Apr -03 I May -03 Jun -03 I Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 pec -03 Yr.Total 172 Gar /Carport Concessions 17'2,172" 1 t2 172 1T: Amount per month (149) (150) (150) (151) 0 (150) (160) (150) (95) (79) (79) (79) (80) (1,461) Amount per month '7 h ",�`; . 4 ' (must be a negative #) �4 -, J %1: 0 0 D. 4 0 Total Write -offs Other Income 1 (149) (150) (150) (151) (150) (150) (150) (95) (79) (79) Total per month 0 0 Comments:come 0 /PSF Income /BEp: (0,008): (2.64) 4095 -00001 GARAGE / CARPORT RENT # of Garages by Month # of Garages Occupied Collected Rent per Garage Subtotal Garage Income # of Carports by Month # of Carports Occupied Collected Rent per Carport Subtotal Carport Income Total Gar /Carport Income Prior Actual: (6,307) Income /BED: (11) Income /PSF: (0.035) increase/priory: F 77% Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total mo 0 0? 0 �'s 1fi2 .,w X17 t..t;,�,, 0.00 Jan -03 Feb -03 I Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 pec -03 Yr.Total 0.000 Increase /Prior Y; 0 172 Gar /Carport Concessions 17'2,172" 1 t2 172 1T: s0 0 3(5. % .,,0„ .., 0 0 0 4095 -00002 GARAGE /CARPORT RENT CONCESSIONS % Concessions on Garages /Carports: 0, ;Q0;°jo' < ...... ENTER ZERO IF HARDCODINGIII Income /BED: 0.00 Jan -03 Feb -03 I Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 pec -03 Yr.Total 0.000 Increase /Prior Y; 0 Gar /Carport Concessions 0 01 0 0 0 0 0 0 0 0 0 1 0 Gar /Carport Conc. (enter as a negative) g} t „qY Total per month 0 0 1 0 0 0 0 0 0 01 0 1 0 0 Income /PSF: 0.000 Income /BED: 0.00 Prior Actual: 0 Income /BED: 0.00 Income /PSF: 0.000 Increase /Prior Y; 0 10/25002 10:05 AM tncortw input Page 6 / 19 Income /PSF: Net Garage /Carport Rent Income /BED; Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 5,160 5,160 5,160 5,160 5,160 5,160 5,160 5,160 5,160 5,160 5,160 5,160 10:05 AM 10252002 Yr. Total 0.000 0.00 Yr. Total 61,920 %of Residents wlPets,,.t{M1 4105 PET FEES /RENT /NON - REFUNDABLE DEPOSITS Move -In Fees per Pet `Does not include Non - Refundable Redecoration Fees Jan -03 I Feb -03 Mar -03 Apr -03 .031 Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr.Total Amount per Move -in 0 0 0 0 0 q 0 0 Other 0 Total Pet Fees /Rent Deposits 0 0 0 0 0 4110 SENIOR PROGRAM AMENITIES INCOME (DO NOT USE) Total Senior Amenities Income Comments: Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 1 Yr. Total 01 0 01 0 1 0 1 0 1 0 1 0 0 0 0 0 0 0 0 Income /BED: 0.00 0 r ¢ Q. Prior Actual: St 1 0 2 IncomelPSF: 0.000 I ,,ri, creaselPnorY 0% 17 0 0 0 0 0 0 0 0 Amount per Move -in 0 0 0 0 0 q 0 0 Other 0 Total Pet Fees /Rent Deposits 0 0 0 0 0 4110 SENIOR PROGRAM AMENITIES INCOME (DO NOT USE) Total Senior Amenities Income Comments: Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 1 Yr. Total 01 0 01 0 1 0 1 0 1 0 1 0 0 0 0 0 f k f } Income /PSF: 0.000 Income /BED: 0.00 r ¢ Q. Prior Actual: St 1 0 2 IncomelPSF: 0.000 I ,,ri, creaselPnorY 0% 101252002 10:05 AM Income Input Page 7 / 19 4' 1001 STORAGE RENTAL INCOME # of Storage Units by Mo. #' of Stg. Units Occupied Collected Rent per BED ($'s) Total Stg, BED Income Jan -03 Feb -03 I Mar -03 I Apr -03 I D3 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec -03 0 0 0 1. . 0 1 0 1 0 1 01 0 1 0 1 0 1 0 1 0 10:05 AM 10252002 Yr. Total 0 0 0.00 4125 WASHER /DRYER RENTAL INCOME W/D Assumptions Income per BED from resident O O;pfj Jan -03 Feb -03 Mar -03 Apr -03 M May -03 Jun -)3 J Jul -03 A Aug -03 S Sep -03 Oct -03 Nov -03 Dec -03 0 r 0 s # of W /Ds Rented by Mo.,<` OAO �1;Oi7; ,i pA.i t7 Op,. 0 0 0 1. . 0 1 0 1 0 1 01 0 1 0 1 0 1 0 1 0 10:05 AM 10252002 Yr. Total 0 0 0.00 4125 WASHER /DRYER RENTAL INCOME W/D Assumptions Income per BED from resident O O;pfj Jan -03 Feb -03 Mar -03 Apr -03 M May -03 Jun -)3 J Jul -03 A Aug -03 S Sep -03 Oct -03 Nov -03 Dec -03 # of W /Ds Rented by Mo.,<` 4125 WASHERIDRYER RENTAL CONCESSIONS 'Rolled Into account 4125 Income /PSF: 0.000 Income /BED: 0.00 Prior Actual: 0 Income /BED: 0.00 Income /PSF: 0.000 Increase /Prior Y: 0 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Washer /Dryer Rental Concessions (Enter as Negative) Expense /PSF: 0.000 Expense /BED: 0.00 Prior Actual: 0 Income /BED: 0.00 Income /PSF: 0.000 Increase /Prior Y: 0% 1025/2002 10:05 AM In- Input Page 8 /19 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Washer /Dryer Rental Concessions (Enter as Negative) Expense /PSF: 0.000 Expense /BED: 0.00 Prior Actual: 0 Income /BED: 0.00 Income /PSF: 0.000 Increase /Prior Y: 0% 1025/2002 10:05 AM In- Input Page 8 /19 4125 WASHER /DRYER EXPENSES W/D Assumptions Cost per month0 "Booed Into account ails D0 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Yr.To Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 # of Times Rented / Mo. 10:05 AM 10/25/2(X)2 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov03 Dec -03 Yr, Total .Prior Actual; 0 {ncomelBED: 0.00 ,z -. , , r � to / � � t • Income /PSF: 0.000 ,,,,; r ', �__.� -`f` ,,�, . ���- �: s 1 �., , , .; " � � .. .,. ,6,IncreaselPriorY: 0% # of W /Ds Rented by Mo. 0 0 0 0 0 0 0 0 0 0 70 1 0 Expenses per month 0 0 0 0 0 0 0 0 0 0 0 0 t^ =J Total Washer /Dryer Expenses 0 01 01 0 1 01 0 1 0 1 0 0 Expense /PSF: 0.000 Expense /BED: 0.00 Prior Actual: 0 Income /BED: O.DO Income /PSF: 0.000 Increase /Prior Y: 0 Net Washer Dryer Rental Income Jan -03 Feb -03 Mar -03 Apr-63r_ pr -03 May -03 I Jun -03 I Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total 0 0 0 0 0 0 1 0 1 0 0 0 4135 CLUB ROOM FEES Club Room Fee Assumptions Cost to Rent Club Room Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Yr.To Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 # of Times Rented / Mo. —tal — Total Club Room Fees 0 0 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 Comments: come /PSF Inincome 000 00.00 /BED: .Prior Actual; 0 {ncomelBED: 0.00 ,z -. , , r � to / � � t • Income /PSF: 0.000 ,,,,; r ', �__.� -`f` ,,�, . ���- �: s 1 �., , , .; " � � .. .,. ,6,IncreaselPriorY: 0% 10/252002 10:05 AM Income input Pogc9 /19 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr.TOtai Total Vending Income ��i,= ,}., p , ,,, 0, iS 0, 77 � 10252002 10:05 AM Income Input pqg 10119 10:05 AM 101252W2 4' LAUNDRY FACILITY INCOME Jan -03 I Feb -03 Mar -03 I Apr -03 May -03 Jun -03 Jul -03 Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec -03 Yr. Total Total Laundry Income 0" Income/PSF: 0.000 e Income /BED: 0.00 LAUNDRY FACILITY EXPENSES Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Oec -03 Yr. Total Total Laundry Facility Exp. F77770 `"' --� (enter as negative) Income /PSF: 0.000 Income /BED: 0.00 Net Laundry Facility Income Jan -03 Feb -03 I Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr.Totai 0 01 0 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 0 Comments: ; Income /PSF: 0.000 Income /BED. 0.0 0 } j st r r i rnooeIBED: 0.00 00 z, Increase/Prior Y: Oo /. 4155 VENDING INCOME Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr.TOtai Total Vending Income ��i,= ,}., p , ,,, 0, iS 0, 77 � 10252002 10:05 AM Income Input pqg 10119 Prior Actual: 0 Income /BED: 0.00 Income /PSF: 0.000 Increase /Prior Y: 100% 5427 UTILITY REIMBURSEMENT Jan -03 Feb -03 I Mar -03 I Apr -03 I May -03 Jun -03 1 Jul -03 I Aug -03 I Sep -03 I 00t -03 I Nov -03 I Dec -03 Yr.Total Total Utility Reimbursement (Do not Use) 1 0 01 0 1 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 4170 CAR WASH INCOME p Income /BED: 0.00 income /PSF: 0.000 Increase /Prior Y: 1-:1D AM 11VZ,zW4 41' TELEPHONE /CABLEIALARM INCOME Yr'.Tot�ai Apr-03 I May -03 I Jun -03 Jul -03 Description: Revenue sharing for telephone service. Sep -03 Oct -03 Nov -073T---Dec-03] Total Car Wash Income ��; 0 ay , :., ,. S, 0 r.. ,p Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr.Total Monthly Tele /Cable /Alarm Income ?)., - , -1 i? 001 300 Monthly Expense (Do not Use) 0 0 0 0 0 0 0 0 0 0 0 0 1 0 Total Telephone /Cable /Alm 0 0 0 100 01 0 1 0 1 100 1 0 1 0 1 0 100 300 Comments: In comelPSF 0. 002 Income /BED: O.b4 Prior Actual: 0 Income /BED: 0.00 Income /PSF: 0.000 Increase /Prior Y: 100% 5427 UTILITY REIMBURSEMENT Jan -03 Feb -03 I Mar -03 I Apr -03 I May -03 Jun -03 1 Jul -03 I Aug -03 I Sep -03 I 00t -03 I Nov -03 I Dec -03 Yr.Total Total Utility Reimbursement (Do not Use) 1 0 01 0 1 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 4170 CAR WASH INCOME p Income /BED: 0.00 income /PSF: 0.000 Increase /Prior Y: Jan -03 031 Yr'.Tot�ai Apr-03 I May -03 I Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -073T---Dec-03] Total Car Wash Income ��; 0 ay , :., ,. S, 0 r.. ,p CAR WASH EXPENSE Car Wash Exp. (enter as negative) `Rolled into account 4170 Income /PSF: 0.000 Income /BED: 0.00 Prior Actual: p Income /BED: 0.00 income /PSF: 0.000 Increase /Prior Y: 0 10252002 10:05 AM 1-- input P°gc 11119 Net Car Wash Income Increase/PriorY: 1=0% Jan-03 Feb-03 Mar-03 Apr-03 May -C. Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 I Dec-03 I F —Yr 01 0 1 0 1 0 1 0 1 01 0 1 0 1 0 1 0 1 4175 APPLICATION FEE Net Leases by Month Cancels by Month Gross Leases by Month Standard Application Assumptions 0 0 1 01 Rush Application Assumptions 1 12,915 Standard Application Fee Income 0 '00 1 0 Rush Application Fee Income Rush Application Income 0 Standard App. Fee Expense 0 0 0 0 0 Rush App, Fee Expense 0 $0 • of Leases that are Standard 0 100% 0 % of Leases that are Rush Standard Apo. Expense Rush Application Expense Other Assumptions 0 o 1 0 1 (126)1 0 1 0 • of Gross Leases that Cancel 0 0 1 0 (5656) 0 0 0 0 0 1 0 0 1 0 71 Dec-03 Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 1 318 25 0 0 0 9 0 0 364 0 0 0 1 0 0 0 0 0 0 15 0 0 0 0 16 26 0 0 0 9 0 0 369 0 0 0 0 404 Standard App. Income 910 0 0 1 01 315 1 0 1 0 1 12,915 1 01 0 1 0 1 0 14,140 Rush Application Income 0 0 0 0 0 0 0 0 0 0 0 0 0 Gross App. Fee Income 1,768 1,768 1,768 1,768 1,768 1,768 1,768 1,768 0 0 Standard Apo. Expense Rush Application Expense (364)1 0 o 1 0 1 (126)1 0 1 0 1 (5,166)1 0 0 1 0 (5656) 0 0 0 0 0 1 0 0 1 0 1 0 1 0 0 0 0 Misc. App. Fee Expense (enter as negative) 4177 Application Expense (707)1 (707)1 (707)1 (707)1 (707)1 (707)1 (707)1 (707)1 0 1 0 1 Total NetApplication Fees 1,061 1 1,061 1 1,061 1 1,0611 1,0611 1,0611 1,0611 1,0611 0 1 0 1 Comments: Income/PSF: Income/BED: 15.34 Prior Actual: (1,671) (3,02) Income/BED: Inrome/PSF: (0.009) Increase /Prior Y: 608% 1O2512002 10:05 AM I.e.— lapat Page 12 / 19 1O2512002 10:05 AM I.e.— lapat Page 12 / 19 41F` CANCELLATION FEES Cancel Fee Assumptions Cancellation Fee as % of Motnhly Rent Cancellation Fees Collected Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dea-03 Avg, Cancellation Fee # of BEDS Chgd, Canc. Fee 0 0 0 1 01 0 1 0 1 0 1 0 1 0 0 0 0 • of Reletting Fee Collected i5 tl0a>A< Jan -03 Fe6-03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct•03 Nov -03 Dec -03 Yr.Total 0 0 0 0 0 1 0 1 0 1 01 0 1 0 1 0 0 4187 10:05 AM 102521X12 Yr. Total 0 0.0 0 0.000 D: 0.00 0 0.00 0.000 Increase /Prior Y: 1 0 Income /PSF: 0.000 Income /BED: 0.00 Prior Actual: 420 Income /BED: 0,76 Income /PSF: 0.002 Increase /Prior Y: -100% WRITE -OFFS CANCELLATION FEES 0 1 0 0 0 0 0 0 0 0 0 0 0 Net Cancellation Fees 1 0 1 0 ol 0 1 0 1 0 1 0 1 0 1 01 p 4190 RELET FEES Relet Fee Assumptions Average Reletting Fee (% of 1 Month's Rent) • of Other Move -Outs Charged Reletting Fees; • of Reletting Fee Collected i5 tl0a>A< Jan -03 Fe6-03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct•03 Nov -03 Dec -03 Yr.Total Avg. Relet Fee 332 332 332 332 3331 333 333 3S6 356 356 356 356 p # of BEDs Charged Relet 0 0 0 0 0 0 0 0 1 0 0 1 0 .01 Total Relet Fees 0 0 0 0 0 1 0 1 0 1 Comments: i3t � . s'' Income /PSF; 0.000 1 s Income /BED: 0.00 Prior Actual: 10,181 Income /BED: 18.41 Income /PSF: 0.057 Increase /Prior Y: F -100% 1025200 10:05 AM 1w.. Pnga 13 / 19 10:05 AM 1012512W2 47 NSF FEES incom e /PSF: k P1 - NSF Fee Assumptions Income /BED: % NSF Checks (Occupied BEDS) < < r Prior Actual: NSF Fee $ 3 3trg0.3 t F Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr,Total # of BEDs Chgd. NSF Fees 9 10 10 10 11 11 11 11 10 10 10 10 10 Total NSF Fees 270 300 300 3001 330 1 330 1 330 330 3,690 300 300 300 300 4206 LATE FEES Late Fee Assumptions % Charged Late Fee (Occupied BEDS) tH}c Average Late Fee $, Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 pct -03 Nov -03 Dec -03 # of BEDS Chgd, Late Fees 47 50 50 50 50 49 49 49 53 53 53 53 Total Late Fees 1,880 2,000 2,000 2,000 2,000 1,960 1,960 1,960 2,120 2,120 2,120 2,120 Comments: Income /PSF: Income/BED: Prior Actual: Income /BED: Income /PSF: Increase /Prior Y: 4210 ACCESS CARD FEES Jan -03 Feb -03 Mar -03 Apr -03 I May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec-03 Access Card Fees month er P 0, e'ri,b 17770 7717 Total Access Card Fees 01 01 01 01 01 01 01 01 01 0 0 0 Comments: J incom e /PSF: k P1 Income /BED: < < r Prior Actual: t F Income/BED: Into elP m SF' } iIncrease/Prior 10/25/2002 10:05 AM Income Input Yr. Total 50 24,240 0.135 43.83 20,420 36.93 0.114 19% � Yr -Total � I�: .I 0 0.000 0.00 360 0.65 0.002 -100% P.p 14 119 10:05 AM 11125/21x12 4r- DAMAGES 0 0 0 0 0 01 0 1 0 1 01 0 1 "Includes Non - Refundable Redecoration Fees 0 Prior Year Adu6 (DO Prior Year Adual 1 Per BED Charge for Redecorating Fee $ Ot7 00 $45,58 Damages $0.00 Is 2.ee Reallocation Y/N �� Percent of Damages Collected 0.00%1 i Damages - Carpetj $0.00 $0.00 t ,Prior Actual: 1,413 r F s f 1 Yr. Total Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total € <lncome /PSF: 0.008 r 4215 Damages 0 0 0 0 0 0 0 0 0 0 0 0 4216.00002 Damages Carpet 1 0 0 01 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 0 4215 -00001 4217 0.000 0.00 1,413 2.56 0.008 Y: 100% Write -Offs Damages NOT USE) 0 0 0 0 0 01 0 1 0 1 01 0 1 01 0 (DO �> 1 In come /PSF. Income /BED: s 0 000 OAO 2 i 5 t ,Prior Actual: 1,413 r F s f 1 k 3 ncomelBED. 2.58 1 x t € <lncome /PSF: 0.008 r ,. "Increase /PriorY: 100% Redec.Fees 00 2,500 0 01 01 g00 0 1 01 35,400 1 01 0 Hard Code N,;,,.,0: = =,>, ilk 0 Total 2,500 0 0 0 900 0 0 35,400 0 0 0 0 00 g38,800 Reallocation Line 5,543 5,543 5,543 5,543 5,543 5,543 5,543 0 0 0 0 0 1025/2002 10:05 AM Income Input hp 15 / 19 10:05 AM )()/25T2(X12 4' FORFEITED DEPOSITS 0 Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 N F YrT.t.17 Deposits Forfeited by Applicants 0 , 4 Miscellaneous Resident Charges 266 0 Total Forfeited Deposits 0 0 0 0 0 0 0 0 0 0 o Comments: ncome/PSF: 0.000 Income/BED: 0.013 Income/BED: Prior Actual: 2,792 Income/BED: 'Income/PSF: /BED: (0,20) :Income ..,Income/PSF: (mol) 4305 OTHER MISC. INCOME •Rolled Into account 4306 ........ ..... �Increase/PriorY: 1009 % 4305 MISCELLANEOUS RESIDENT CHARGES *Rolled Into account 4305 0 Jan-03 Feb-03 ME May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct -03—F Nov-03F Dec-03 0 0 0 0 , 4 Miscellaneous Resident Charges 266 0 0 0 Total Miscellaneous Resident Charges 200 200 200 200 200 200 200 200 2001 200 1 200 1 200 1 Comments: "Income/P$F: 0.013 Income/BED: Prior Actual: 2,792 Income/BED: 'Income/PSF: 5.05 0,016 Increase/Prior Y: ... ............ . . . . . . . . . . -14% 4305 OTHER MISC. INCOME •Rolled Into account 4306 Total Other Misc. Income 4510 Short-Term Investments 4515 Interest Income Escrow 4625 Interest Income Other 4620 Notes Receivable Comments: Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 F Dec -03 0 0 0 0 0 0 0 0 0 0 0 0 7-7777776777777, 7 M u, Total Income/PSF: Income/BED: Prior Actual: Y: Yr. Total 0 0 0 0 0 0 0.00 217 0.52 0.002 10/25/20112 10:05 AM lu­ input Np 16 119 TELEPHONE UNITS INCOME (DO NOT USE) Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr,Totai Total Telephone Units Income (Do Not Use) 0 0 0 0 0 0 0 0 0 0 0 0 Income /PSF: 0.000 Income /BED: 0.00 4160 -00001 TELEPHONE UNITS EXPENSE (DO NOT USE *Roiled Into account 4160.00001 Jan -03 Feb -03 Mar -03 Apr -03 I May -03 I Jun -( Jul -03 Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec -03 Yr. Total Telephone Units Exp. (Do not Use) 0 0 0 01 01 01 0 1 0 1 0 1 0 1 0 1 0 1 t^ -J Total Telephone Units Income (Expense) Expense /PSF: Expense /BED: 0.000 0.00 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 I Dec -03 Yr. Total 0 0 0 0 0 0 0 0 0 0 Comments: 4160 -00002 CABLE UNITS INCOME (DO NOT USE) *Rolled into account 4160 icome /PSF: 0.000 Income /BED: 0.00 Prior Actual: 0 Income /BED: 0.00 Income /PSF: 0.000 Increase /Prior Y: 0 Jan -03 Feb -03 Mar -03 Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec -03 Yr.Total Total Cable Units Income (Do not Use) 1 0 0 0 --OT- 0 1 0 1 0 1 0 1 0 1 01 0 1 0 Income /PSF: 0.000 Income /BED: 0.00 10/Z52007 10:05 AM Income Inpn1 rnsr 17119 4160.00002 CABLE UNITS EXPENSE (DO NOT USE) *Rolled into account 4160 Jan -03 Feb -03 Mar -03 I Apr -03 May -0 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Cable Units Expense (Do Not Use) 1 0 0 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 0 Total Cable Units Income (Expense) Expense /PSF: Expense /BED: m.w Hm nun>idxra Yr. T 0.000 0.00 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr.Totai 0 0 0 0 0 0 0 01 0 1 0 1 0 0 l�J 4247 WATER & SEWER UNITS INCOME (DO NOT USE) Jan -03 I Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec -03 Yr.Total Water & Sewer Units Income (Do Not Use) 1 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 1 01 01 0 Income /PSF: 0.000 Income /BED: 0.00 WATER & SEWER UNITS EXPENSE (DO NOT USE) *Rolled into account 4247 Jan -03 Feb -03 I Mar -03 Apr -03 May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 —D,—,03-1 Yr.Total 0/0 Water & Sewer Units Expense (Do Not Use) 0 Total Water & Sewer Units Income (Expense) 0 1 0 0 0 1 0 1 0 1 0 1 0 1 01 0 1 0 1 Expense /PSF: Expense /BED: O 0.000 0,00 Jan -03 Feb -03 Mar -03 1 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 I Nov -03 Dec -03 TO—tai 0 0 1 0 01 0 1 0 1 0 1 0 1 0 1 0 1 �—Y—r. Comments rr r ncome /PSF: 0.000 r i s it 4 1 t cua: rlor A t I P' �lncome /BED. 0 0.00 Income /PSF. 4 0.000 crease /PriorY. 0/0 10252002 10:05 AM Income I.Pnt Pnge Is 7 19 4' SH • LONG DISTANCE REVENUE 'Rolled into account 4306 I Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 SH - Long Distance Revenue (Do Not Use) 501 50 1 60 1 50 50 600 Comments, Income/PSF: F-70-0073 Income /BED: 0 0 0 0 0 0 0 0 0 0 Total SH - Long Distance Revenue 0 0 0 b 0 0 0 0 0 0 10;05 AM 10MIZIM Yr. Total 4265-00001 COMMON AREA FEE (DO NOT USE) Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 N 177y—r—T.—t.71 Common Area Fee Income/PSF: Income/BED: 0.00 4255-00002 COMMON AREA FEE CONCESSIONS (DO NOT USE) Jan-03 Feb-03 Mar-03 Apr -03 May-03 I Jun-03 I Jul-031 Aug-03 I Sep-03 I Oct -03 Nov -03 Dec -03 Yr.TOtal Common Area Fee Concessions 0 0 ko (ENTER AS A NEGATIVE) Total Common Area Fee (Net) Expense/PSF: 0.000 Expense/BED: 0.00 Jan-03 I Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov-03 I Dec-03 I Yr. Total 01 01 01 01 01 01 01 01 01 01 01 01 4260 LEASE VIOLATIONS INCOME I Jan-031 Feb-03 I Mai May-03 I Jun-03 I Jul-031 Yr. Total Aug-03 I Sep-03 I Oct-03 I Nov-03 I Dec-03 I Lease Violations Income Total Lease Violations Income 1 50 1 501 60 50 1 50 1 50 1 50 1 501 50 1 60 1 50 50 600 Comments, Income/PSF: F-70-0073 Income /BED: Prior Actual: 186 Income/BED: 0.34 Income/PSF: 0,001 Increase/Prior Y: F 223 % 101252002 10:05 AM Income Input p.tu, 19 119 10105.. ;10252002 PERSONNEL IF START MONTH (PROPERTY) IS NOT ENTERED EMPLOYEE WILL NOT BE ACTIVATED FOR ENTIRE YEAR AT START MONTH (PROPERTY) ENTER I IF EMPLOYEE IS ALREADY EMPLOYED ON SITE OR STARTS IN JANUARY, ENTER 2 IF EMPLOYEE STARTS IN FEBRUARY ON -SITE, ETC.... ENTER 0 (NUMERIC) IF POSITION WILL NOT BE FILLED DURING BUDGET YEAR, 5023 SALARIES . MANAGEMENT Descri tp ion; Salaries paid to exempt and non- exempt employees of the community on a bi- monthly basis to include CommBEDy Managers, Assistant Managers/Leasing Director, Leasing Associates, Lifestyle Director and Concierge. DO NOT INCLUDE EMPLOYEES PROVIDED BY TEMPORARY AGENCIES Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Totat Salaries 4,333 4,333 4,333 4,333 52,000 4,333 4,333 4,333 4,333 4,333 4,333 4,333 4,333 Total Monthly Cost 1 4,3331 4,333 1 4,333 1 4,333 1 52,000 4,333 1 4,333 1 4,333 1 4,333 1 4,333 1 4,333 1 4,333 1 4,333 1 Comments: '` +' ` s - h + - r :Cost/PSF: 0.29 t C ost/BED 94 / f Prior Actual: 127,088 4 t 0 . t ,t norease/Prior Y: 59% 1025/2002 10:05 AM ExPense Input Pep 1/ 62 10:05,. - 1025/2002 5046 OVERTIME Description' Management Overtime Rate (Base Salary times 7,X): Amount of money spent on overtime work for both management and service employees. Sevice Overtime Rate (Base Salary times LX): Jan -03 Feb -03 Mar -03 Apr -03 Yr. Total May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 OT Management -00001 0 0 0 0 0 0 0 0 0 0 0 0 0 OT Service -00002 591 591 591 591 591 591 591 591 591 591 591 591 7,092 Total Overtime Monthly Cost 591 591 591 591 7,092 591 591 591 591 591 591 591 591 Comments: Cost/PSF: o.oa `Cost/BE D: 13 5025 Prior Actual: 2,090 Cost/BED; 4 Cost /PSF: 0.01 Increase /Prior Y: 239 WAGES - MAINTENANCE /GROUNDS Descri. tom Hourly compensation paid weekly to non- exempt service employees of the community, Jmi -03 I Feb -03 ar-0 M3 Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct-03 Nov -03 Dec -03 Yr.Total Wages 1 5,4651 5,465 5,465 5,465 5,4651 5,4651 5,4651 5,4651 5,4651 5,4651 5,4651 5,465 65,580 Total Mouldy Cost 1 5,4651 5,4651 5,4651 5,4651 5,4651 5,4651 5,4651 5,4651 5,4651 5,4651 5,4651 5,465 65,580 1025/2002 10:05 AM Expense Input Age 2162 5026 Wages Total Monthly Cost 10.05, - lo/25/2002 HOURLY WAGES - HOUSEKEEPING Description: Hourly compensation paid weekly to non- exemptjanitorial employees of the community. Includes groundskeepers and Jan -03 Feb -03 cctc Enter in Excel Date Format May -03 Jun -03 Active ? Aug -03 Sep -03 Start Start Eligible Month Month Overtime Term? Last 1 =Y 0 0 (Company) Month for 401K Eligible 401K Hours 1 =YES Full 0 =N N mber Position (mm/dd/yyyy) (Property) 1 =Y 0 =N 401K Starts O=NO Month =0 0 13 0 House Keeper I 01 01 01 1 I 1 01 7 01 0 14 0 House Keeper 2 1 1 1 7777 0 15 0 Porter 0 16 0 Porter f ry 0 19 0 Porter 3 t I 1 1 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total 0 0 0 0 0 0 0 0 0 0 0 =0 01 01 01 01 01 01 01 01 01 01 01 0 5061 TEMPORARY EMPLOYMENT- MANAGEMENT Description• Fees paid to a temporary service for providing temporary office help (i.e. leasing agents). 102512002 10:05 AM Expcnsc input Ng. 3 / 62 M05. 10/25/2002 5062 TEMPORARY EMPLOYMENT- SERVICE Description Expenses paid for temporary employment of personnel directly related to services, including maintenance, housekeeping and groundkeeping of the property. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec-03 1 Yr Total Temporary Srvc. Cost /Mo. �,,.. �,U ij �7; " 0r 0 D ,p; = Total Monthly Cost 0 01 0 1 0 1 0 1 0 1 0 1 0 1 01 0 1 0 1 0 5190 LEASING COMMISSIONS Descri ttiiom Commissions paid to property personnel for the production of new leases and renewals. Uasinp Commission As minions Avg. Commission per Lease or Renewal $$,p�'} 9 Reallocation Y/N Jan -03 I Feb -03 I Mar -03 Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Dec -03 Yr. Tota] Leases/Renewals by Month 25 0 0 0 14 0 0 459 0 0 0 0 r 498 Commissions paid 375 0 0 01 210 1 01 01 6,885 1 01 ol 0 1 7,470 Commissions paid (Hard Code).r0' , J , =,:�0 Total Mouttily Cost 375 0 0 0 210 0 0 6,885 0 0 0 0 1 7,470 Reallocation 934 934 934 934 934 934 934 934 01 0 1 0 1 0 1005/2002 10:05 AM Expense Input Pugo 4 / 62 10:05. :;0125/2002 9810 PERFORMANCE BONUS (DO NOT USE) Comments: cost/PSF-. 0.06 'Cost/BED: 19 Descrintimu Additional compensation for above exceptional work perfor r ance. 15,188 ^Cost/BED: 27 Cost/PSF: Jan -03 Feb -03 I Mar -03 I Apr -03 I May -03 Increase /PrlorY: 29% Yr. Totni Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Dec•03 Bonuses paid 0 01 01 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 Total Monthly Cost 0 0 0 0 0 1 0 1 0 1 0 0 0 1 0 1 0 Connnents: ' Cost1PSF: 0.00 i Cost/BED: 0 tr CosUPSF: 0.00 � � Increase /Prior Y: 0 5080 PAYROLL TAXES Description: Includes FICA, FUTA and State Income Tax payments for employees. Payroll Tax A5snmVjjQ S FUI 0.8000 Maximum $ 7,000 SUI0.9100 Maximum OASDI % 6.20% MEDICARE % 1.45% Maximum NONE Jan -03 Feb -03 Mar -03 Apr -03 May-03 Yr. Totat Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Payroll Taxes 1,011 973 842 810 831 10,771 8101 8101 1,499 1 801 1 795 1 795 795 Total Monthly Cost 1,011 973 842 810 831 810 810 1,499 801 795 795 795 10,771 Comments: cost/PSF-. 0.06 'Cost/BED: 19 r Prior Actual: 15,188 ^Cost/BED: 27 Cost/PSF: 0.08 Increase /PrlorY: 29% 10/25/2002 10:05 AM Expense Input Pn 6 e 5 162 1025/2002 10:05 AM E".. Input Np 6 / 62 10:05 . 1025/2002 5090 GROUP INSURANCE Description- Expense incurred by the corn nunity to maintain Group Health and Life Insurance for all eligible employees. Group Insurance Aumm2fiqu LIFE % 0.01380% Based on 2003 Average Benefit Cost HEALTH $ 4,822 Maximum $ 4,822 LTD %n 0.07500% Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 .777 77-71 Group Insurance Costs 833 833 833 833 833 833 833 833 833 833 833 833 1Q000 Total Monthly Cost 1 833 833 833 833 833 833 833 833 833 833 833 833 1Q000 Comments "� r Cos PSF 006 ' > r rCosNBED: + s 18 2 Prior Actual: 11 , 587 u Cost/BED: 21 Cost/PSF: 0.06 .Increase /Priory 14% 5100 WORKERS COMPENSATION Description: Insurance paid based upon the number of employees and theirjob description for the community. Worker's Compensation Assumptions Worker's Comp. per $100. Office Workers Comp. per $100 - Service Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Workers Comp Insurance 347 347 347 347 347 347 347 347 347 347 347 347 4,164 Total Monthly Cost 347 347 347 347 347 347 347 347 347 347 347 347 4,164 Comments: 0.08 Cost/BED: Prior Actual: COSUBED: 3,823 7 Cost/PSF: 0.02 "Increase/Prior Y: -9% 1025/2002 10:05 AM E".. Input Np 6 / 62 10:05, x 10/25/2002 5105 EMPLOYER 401(K) CONTRIBUTIONS Description; Payments by the company for contributions to the Employee 401K Program. Employer 401K Asjunjat[M Retirement % I Descrinfli2• Other Benefits Monthly Cost Total Monthly Cost Any other expense relative to employee benefits not specifically included in another account Jan-03 Feb-03 I Mar-03 I Apr-03 Jan -03 I Feb-03 Mar-03 Apr-03 May-03 Jim-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 ] Yr. Total 401K Contributions Mo. F — — — 14-3T-143 143 143 143 01 " 'V 143 143 143 143 143 143 143] Total Monthly Cost 143 143 143 143 143 01 01 Colt)PSF: 143 143 143 1431 143 1 1431 143 1 Comments' 0 CostiTSF• 0,01 Cost/BED; 3 Prior Actual 2,080 Cost/BED; Cost/PSF: 0.01 12 Increase/Pr Y 17% 5110 OTHER BENEFITS Descrinfli2• Other Benefits Monthly Cost Total Monthly Cost Any other expense relative to employee benefits not specifically included in another account Jan-03 Feb-03 I Mar-03 I Apr-03 May-03 I Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total 01 " 'V 01 01 01 01 01 01 01 01 01 01 01 01 Colt)PSF: 0.00 C 08 VB ED: 0 10t25/2002 10:05 AM Expense Input Np 7 /62 10:05 10/25/2002 4085 EMPLOYEE RENT DISCOUNT (offset to revenue) Descri ttiow Cost associated with discounts given to employees who live on the property for which they are employed in accordance with owner approved discount plan. Standard Employee Discount Assumptions Corununity Assistant Discount Assume ti ns Manager/ Service Tech Discount Assumnptions % of Standard Rent Discount .0% CA Discount $ Mgr. /Sev. Tech Discount $ # of Emp. with Std. Discount ',``t)=','� # of persons w/ Ca Discount ,r. -�.� ''! # of Emp. w/ Mgr. Discount Jnn -03 Fcb 4 3 Mur -03 Apr -03 Mny -03 Sun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nnv -03 Dcc -03 Yr. Totel Std. Disc. (% of Market) 0 1 0 0 0 0 0 0 0 0 0 0 0 Standard Discount Costs CA Discount Mgr./Sev, Tech Discount $ Total Monthly Cost 9� $114 UNIFORMS # of Srv. Uniforms / Emp. It of Career Uniforms / Emp, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Expenses incurred for management and maintenance personnel's unifomt cost to include purchase and maintenance, Also to include alterations. 0 0 0 0 Cost/PSF: 0.00 1Cost/BED: 0 Prior Actual: (19,261 Cost/BED: (35 Cost/PSF: (0.11 Increase /Prior Y: •100% Staffing Assumptions Uniform Cost Assumptions No. of Service Employees Avg. Cost per Service Uniform $ No. of Career Employees Avg. Cost per Career Uniform $ Nov -03 Dec -03 Yr. Total Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Service Uniform Costs 0 0 480 0 0 0 0 0 480 0 0 0 960 Career Uniform Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 Uniform Maintenance Costs Total Monthly Cost 0 0 480 0 01 0 1 01 0 1 480 1 0 1 0 1 0 960 10/2512002 10:05 AM Expcnsc Input pugs, 8 / G2 10:05 /0252002 5146 EMPLOYEE SCREENING/PRE- EMPLOYMENT FEES Descri t� Expense for pre - employment verifications and personality profiles forjob applicants. Jan -03 I Feb -03 I Mar -03 Apr-03 May -03 Jut -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Screening Fees,`d3T 0 487 D �5 48Z dl, A 1,998 Total Monthly Cost 487 25 0 487 0 0 487 0 25 487 0 0 1,998 5147 EMPLOYMENT FEES AND EXPENSES Description: Expenses related to employees such as Personnel Finder Fees and other related expenses, Employment Fee A Avg, Placement Fee $ 6,00`" Jan -03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 Oca03 Nov -03 5e73 Yr. Total Number oPPlacemettts ,Q? Total Employment Fees 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 0 IOPS2002 10:05 AM Expcnsc Input Pagc 9 162 10:05 10125/20)2 ........... Conulleam ......... 0.0 Cost/BED: 0 iII Prior Actual: Cost/BED: 0 C ost/PSF: 0.00 L Increase/P r lo r Y: a 5149 HELP WANTED NEWSPAPER ADS Description: Expense for placing help wanted ads in local newspapers to fill Vactan positions. 5117 OTHER PERSONNEL EXPENSE Descriptiow Any other expense related to personnel or payroll not specifically included in another account. Jan-03 I Feb-02 3 May-03 Jun-03 I Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total 7-1 Monthly Amount F77-777"-,�7-77, ""77", - Total Other Personnel Expense 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 01 0 1 —() I 10/25/2002 M05 AM Expense Input Page 10 162 Jan-03 I Feb-03 I Mar-03 Apr -03 May-03 Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 Nov-03 Dec-03 I F--Y,-Total - 7. Monthly Advertising Cost 14 [927M M-, Total Monthly Cost 1 100 0 0 100 0 01 1001 0 1 0 1 100 1 0 1 01 5117 OTHER PERSONNEL EXPENSE Descriptiow Any other expense related to personnel or payroll not specifically included in another account. Jan-03 I Feb-02 3 May-03 Jun-03 I Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total 7-1 Monthly Amount F77-777"-,�7-77, ""77", - Total Other Personnel Expense 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 01 0 1 —() I 10/25/2002 M05 AM Expense Input Page 10 162 10:0- ;:.. 10/25MG2 CONTRACT SERVICES 6110 EXTERMINATING/PEST CONTROL CONTRACT �' J7 r<M d3; ` a ` 4 Descri tp ions Includes expenses incurred on a contract basis with an exterminating company and/or any special pest control. r „{), 4 4 F,.> F.xterminadng Acsmmtions Contract Cost / BED / Month (all BEDS) (lD(J .;; 0 Jan -03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec-03 I F—Y—,T—.t—a]7 Contract Cost I7 r z . 0 0 0 0 0 0 0 0 0 0 0 0 1 Other Misc. costs Other M 0 0 8,000 0 Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0 0 ;"onnnents: t r t CosUPSF: 0.00 r 4 Y + k 0 k d f '.�'�`1 t�, ✓4 � Prior Actual: 68� X0.01 s Cost/BED: 4 Cost/PSF; z t Increase /Prior Y: 100 6115 LANDSCAPE /GROUNDS CONTRACT Descriptiom Expense for landscape services over a yearly contract basis. Jan-03 I Feb -03 I Mar -03 I Apr -03 I May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Landscape Contract Costs Color Replacement �' J7 r<M d3; ` a ` 4 ;O4Q`Qppk s „1:, r „{), 4 4 F,.> a Q �J (lD(J .;; 0 OfSa h i! ti. I7 r z . 8,000 Total Monthly Cost 0 01 2,000 1 0 1 2,000 1 0 2,000 0 2,000 1 0 0 0 8,000 10/25/2002 10:05 AM Expense Input Aago 11 IG2 10:05„ 10252002 6120 PONDS / LAKES / FOUNTAINS CONTRACT e •criptiou• Maintenance Contract expense for upkeep of Ponds, Lakes and Fountains. Jan -03 Feb -03 Mar -03 I Apr -03 May -03 Jun -03 Jul -03 Aug -03 Yr. Total Sep -03 Oct -03 Nov -03 Dec-03 Maintenance Contract Costs '. Q „t q„ ` �, a '•}.. �--�� 7,777 Total Monthly Cost 0 0 0 1 0 0 0 0 0 0 0 0 0 (.'flmmeilm x Cost/PSF: 0.00 t `'` �} t t✓ ,; l sc fy 4 Cost/BED: 0 s + } a ct Prior Actual: 0 Cost/BED: 0 Cost/PSP: 0.00 Increase /Prior Y: 0 6125 POOL CONTRACT Desc ,.rintiow Contract experoe for pool and Jmuzzi mainu nance only. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Total Sep -03 Oct -03 Nov -03 Dec -03 Pool Service Contract /Mn. ''Yr. il• -fl Total Monthly Cost 1 0 0 0 0 0 1 01 01 0 1 0 1 0 1 0 1 0 1025/2002 10:05 AM Expense input Page 12 / 62 6130 PROTECTION SERVICES CONTRACT Description: Expense the community incurs to provide a Guard Gate / Security Service / Patrol Service and Courtesy Employee. Guard Service Assumptions Monthly Patrol Assumptions Cost per Hour of Guard Service 5013Q` Monthly Patrol Cost Guard Hours / Month Month to Begin Patrol Costs Month to Begin Guard Service .,. `> s ?, (enter tot 2 or 3 Courtesy Employee Assumptions Monthly Cost of Courtesy Employee Montt to Begin Courtesy Employee Guard Service Costs Monthly Patrol Costs Courtesy Officer Costs Other Protection Services c Jan-03 I Feb -03 I Mar -03 I Apr -03 May -03 Jun-03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Dec -03 Yr. Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r, :A_ 10:05., :'10125/2002 0 0 0 0 Total Line Item Cost 1 0 1 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0-1 6135 SNOWACE REMOVAL CONTRACT Description, Contract expense for removal of snow and ice. Jan -03 I Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec-03 1 Yr. Total Snow/Ice Removal Cont / Mo. Total Monthly Cost 0 0 1 ol 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 ^J 1005/2002 10:05 AM Expenso input Page 13 1!+2 sous f 10P512002 6145 CLEANING Doscril2tiow Contract expense for repetitive cleaning services, including vacant BEDS, models, and office /information center, NOT TO BE USED FOR TURN COSTS! Jan-03 Feb-03 Mar-03 Apr -03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec -03-1 77-77-7-1 --1 Cleaning per Month (Do Not Use) 0 0 0 0 0 0 0 0 0 01 0 1 0 Other Contract Cleaning Total Monthly Cost 0 0 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0-1 Collillierim 000 Cost/BED: 0 169 Prior Actual: 1,616 3 Cost/PSF: Increase 0.01 /Prior Y: 100% 6150 OTHER CONTRACT SERVICES Dcscription; Any other contract expense incurred on a contractual basis not specifically included in another account. Jan-03 I Feb-03 Mar-03 Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 Sep-03 Oct-03 I Nov-03 De.-03-1 Yr. Total Other Contract Services 7 Total Monthly Cost 150 150 150 150 150 1 150 1 150 150 150 150 150 1,800 150 CosL/PSF: Cost/BED: 3 Prior Ao'u 1: 'a C E D o "�-�Cost/PSF: Increase/PriorY: 10/25/2002 10:05 AM Ecp—e Input Page 14 / 62 10:05... - '10/25PW2 UTILITIES 5411 ELECTRICITY - HOUSE Description: Electricity for all common areas of the community which includes die office, exterior lighting, laundry rooms, etc, Jan -03 Feb -03 I Mar -03 Apr -03 I Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 May-03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 I Dec -03 I F—Y-17—ta,71 Common lighting 148 i$ 1A$ 1?48 50 62 24 24 24 24 # BEDs Still Under Construction 148r 2,748 25,776 2 148 148 21'.48 2;1'48a�48f44$ [nfonnation centerzD Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0 �� J Comments, 4 , {i D - t aY - s v t t r CasrBE'D; 0 - � Total Monthly Cost 1 2,148 1 2,148 1 2,148 1 2,148 1 2,148 1 2,148 1 2,148 1 2,148 1 2,148 1 2,146 1 2,148 1 2,148 1 25,776 5413 ELECTRICITY - VACANT Descripti= Electricity for vacate apartments only. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Yr. Total Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 # of Vacancies by Month 83 58 58 58 58 62 62 50 62 24 24 24 24 # BEDs Still Under Construction 0 0 0 0 0 0 0 0 0 0 0 0 00 Avg. Electricity Costs BED Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0 �� J Comments, Cost/pSF; 0.00 - t aY - s v t t r CasrBE'D; 0 - � a _ Prior Actual: Cost/BED: 469 t 7 1rs r i�/ Cost/PSF: 0.00 ;Increase /PriorY: 100% 10/2512002 10:05 AM n & I. Put � P Pngo 15 / 62 5412 ELECTRICITY - MODELS Electricity for model apartntent homes on each commuity, Jan-03 Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-031 10:05 102512002 77-771 Avg. Electricity Cost Per Model I ­, O,,_J,,,, Q Number of Models in Project 1 0 0 0 0 0 0 0 0 0 0 0 0 1 Total Monthly Cost 1 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 5456 GAS Doscriptiom Expense for all natural gas used at the community. Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total Gas Costs / Mo. Total Monthly Cost 248 248 248 248 248 248 248 248 248 248 248 248 5458 GAS-VACANT 10/252002 10,05 AM Exp.­ Input Np 16 162 10:05 10PS /1002 $436 WATER AND SEWER 0.11 Cost/BED: 37 Prior Actual: 191338 Cost/BED : 35 Average Budget Cost Per BED Per Month $3.07 Description Expenses incurred by community to provide water and sewer service. Average Prior Year Cost Per 13ED Per Month $291 Jan -03 Feb -03 I Mar -03 1 0 1 ,..] Yr. Total I Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Water &Sewer Costs /Mo. 3,70 ,, -3;79C Total Monthly Cost 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 2Q400 5438 WATER AND SEWER - VACANTS Description, Expenses incurred by community to provide water and sewer service to vacants. Cost/PSF: 0.11 Cost/BED: 37 Prior Actual: 191338 Cost/BED : 35 COst/PSF: 1 0.11 Increase /Prior Y: -5 Average Budget Cost Per Vacant Per Month , ": $0 °004 Average Prior Year Cost Per Vacant Per Montt $0.00 5475 REFUSE REMOVAL Tan -03 I Feb -03 I Mar -03 I Apr -03 I May -03 Jun -03 I Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 I Yr. Total Water & Sewer Vacant Costs / Mo, %''i0s 1 01 0 1 0 1 0 1 ,..] 01 'w7p 470" 01 0 1 Water &Sewer Vacant Costs / Mo. Total Monthly Cost 370 370 370 370 370 370 370 2,600 370 370 370 370 G,G70 Comments: + r r r Cost/PSF: 0.04 - + r Cost/BED: (USE INPUT IF YOU PREFER TO IJARDCODE NT MIBER) PnorActual: 6,558 r Cc ED. 12 „ COst/PSF: 01 04 rr ,. Total Monthly Cost 1 0 1 0 0 1 0 0 0 1 01 0 1 0 1 0 1 01 0 5475 REFUSE REMOVAL Description • Expenses incurred by conununity for the removal of trash, Jan -03 I Feb -03 Mar -03 I Apr-03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Yr. Total Dec -03 Refuse Removal Costs / Mo. 37p %''i0s 'yT + { r ](J ;'. X70 870 ,S7ppp ,..] 07p 'w7p 470" 6,670 Valet Refuse Removal Costs/Mo, Total Monthly Cost 370 370 370 370 370 370 370 2,600 370 370 370 370 G,G70 Comments: + r r r Cost/PSF: 0.04 - + r Cost/BED: 12 PnorActual: 6,558 r Cc ED. 12 „ COst/PSF: 01 04 rr ,. In Y: crease /Prior - e 2/ 107-192002 10:05 AM Ex Input Pence p Page 17 /f2 Prior Actual: Cost/BED: CosUPSF: Increase/Prior Y: 5442 RESIDENT WATER Description Expenses incurred for resident water. Jan-03 I Feb-03 Mar-03 Apr-03 May-03 Jun-01 I 10:05 �0rSt2(X)2 5515 RESIDENT TELEPHONE EXPENSE Sep-03 I Oct-03 Nov-03 Dec-073 I Yr. Total Resident Water 6, 4P , "A, Average Bodget Coat Per Unit Per Month `,L-126T Description; Expenses incurred by community to provide telephone service (per unit). Average Prior Year Cost Per Unit Per Month $0.00 Jan-03 Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 Nov-03 Dec-03 Yr. Total Resident Telephone Expense 0 01 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 01 0] 0 Resident Telephone Expense (Fixed) 1,4361 -Q�or ; io 0 , 3,020. " t 0,2 (USE mur IF YOU PREFER T011ARI)CODENUMBER) Total Mondily Cost 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,020 3,02E] Comments, Cost/PSF: 0.20 Cost/BED: 66 Prior Actual: Cost/BED: CosUPSF: Increase/Prior Y: 5442 RESIDENT WATER Description Expenses incurred for resident water. Jan-03 I Feb-03 Mar-03 Apr-03 May-03 Jun-01 I Jul-03 I Aug-03 Sep-03 I Oct-03 Nov-03 Dec-073 I Yr. Total Resident Water 6, 4P , "A, `,L-126T , 1,436� 3 Total Monthly Cost 1 1,4361 1,4361 1,4361 1,4361 1,4361 1,4361 1,4361 1,4361 1,436 1 1,4361 1,4361 1,4361 5525 RESIDENT INTERNET Description Expenses incurred for resident internet, Jan-03 Feb-()3 Mar -03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 I Sep-03 I Oct-03 Nov-03 Uec -03 Yr. Total Resident Internet A Total Montlily Cost 8,300 8,300 1 8,300 1 8,300 8,300 8,300 8,300 8,300 8,300 8,300 8,300 8,3070 101-15/2002 IROSAM Exparee top.[ Page 18 / 62 10:05 , )/252002 5413 RESIDENT ELECTRICITY •R„nkd lntn ne—ut 5413 Deseriintion; Expenses incurred for resident electricity, 10/25/2002 10:05 AM Expense input Pqg 19 / 62 Jan 03 Feb -03 1 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 F Yr. Totat Resident Electricity .. °+t 17'..., Total Monthly Cost 0 01 0 1 01 0 1 0 1 0 1 0 1 01 0 1 0 1 0 Comments: ', r s7� 1 i s Cost/pSF: 0.00 1 � /BED 0 � � S 4 Prior Actual: 469 r CosVBED: 1 CoSVPSF: 0.00 Increase/Prior Y: 100% 10/25/2002 10:05 AM Expense input Pqg 19 / 62 ro:os, lon_sn_om_ Electricity 5414 UTILITY REIMBURSEMENT Reeapmre (aQrR=(Ner fcalleeaoa Loar> Electricity 5515 Water /Sewer 5515 Telephone 1025/2002 10:05 AM Expense Input Page 20162 Avg/Oecupied BED $ Reimbursement to project for billed utilities Month to Start Yr. Totat Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Sul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 0 0 0 0 0 0 0 0 0 0 0 0 0 Cos/PSF: Cost/BED: . 00 0 0 Prior Actual: Cost/BED: Cost/PSF: 00. 0 u ,........... , .Increase /Prior Y: 0% Water /Sewer Recapture% "' '�_;,.'d°lo(Net of Collvion Loss) AvgfO.uplcd BED $ - Monti, to Start 01 0 51 0 0 01 0 1 0 1 01 01 0 0 Cos PSF: 'C t1BED; 0.00 0 Prior Actual; 0 Cost B ED: 0 ^Cost/PSF: 0.00 Increase /Prior Y: 0 *Rolled into account 5515 Telephone Recapture %a ' „t)`(Nel afCallecban lase) Avg/Oceupled BED $ - Mouth to Start 01 0 0 1 01 01 0 1 01 01 0 1 0 1025/2002 10:05 AM Expense Input Page 20162 10:05. 10125t-1002 5505 CABLE EXPENSE Ay—g. Budget Cost Pcr Unit Month . . De�crintion• Expenses incurred by community to provide cable service. Average Prior Yen, cost Pcr Unit Pcr Month $238.06 Yr. Total Jatt -03 I Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 I Jul -03 I Aug-03 I Sep -03 I Oct -03 Nov -03 Dec -03 Resident Cable Expense 1 0 01 0 1 0 1 0 1 01 0 1 0 1 01 0 1 0 1 0 1 0 Resident Cable Expense (Fixed) t3 0-9 4 "SMQ Q150 „ , ,3' O(1, 3',AfJQ . -" ' ;'OP 0 „ ,,3,00,01 ,Q00` 36,000 (USE INPUT IF YOU PREFER TO IIARDCODE NUMBER) Total Monthly Cost 1 3,000 1 3,000 1 3,000 1 31000 3,000 1 3,000 1 3,000 1 3,000 3,000 3,000 3,000 1 3,000 36,000 5520 OTHER FUELS/DIESEL Descriotiow Expenses incurred to purchase other fuels, i. e., gasoline (not mileage reimbursement) or diesel for equipment at the community. Jatl -03 Feb -03 Mar -03 I Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov-03 Dec -03 Yr. Total Other Fuel/Diesel Cost/Mo �---� ", Total Monthly Cost 0 0 0 0 0 0 0 0 1 0 0 0 0 1025200 10:05 AM Exponsc Input Ngo 21162 10:0_ 10/25/2002 INTERIOR MAINTENANCE 6160 ALARM SYSTEM REPAIR Description: Maintenance and repair of smoke, fire and heat detectors, individual BED alarm systems, and overhead sprinkler systems. Alann ,Repair Assum tp ions Avg, # of Service Calls / Mo. $ Average Cost /Service Call Month to Begin Charges Jan -03 Feb -03 Mar -03 Apr-03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 7Tota] Alarm Repair Costs 0 0 0 0 0 0 0 1 0 1 0 1 01 0 1 0 0 Other Misc. costs r =y25 t1 0 r 250 Total Monthly Cost 125 0 0 0 0 125 0 0 0 1 0 0 0 250 6165 APPLIANCE REPAIR Descriptio L'. Expenses related to the parts and labor for maintaining the appliances of the community to include stoves, dishwashers, trash compactors, refrigerators, microwaves, and garbage disposals, htcludes bake elements, broiler elements, broiler pans, drip pans, burner switches, crisper covers, dishwasher impellers, dishwasher motors, disposals, disposal pans, icemaker repairs, ice trays, oven thermostats, racks for broilers, refrigerator motors, refrigerator shelves, selector switches, stove bunters, terminal blocks for ovens, timers for dishwashers, and other related items, Jan -03 I Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Appliance Repairs /Mo. rratl , =a t}� # (1 „� 5Q,.,',' ,V11"1, 250 250 :`:500..' f 75. .,,rt Total Monthly Cost 150 1501 150 1 150 1 1 -50 1 250 1 250 1 500 1 175 1 175 1 175 1 175 1 F----2750� 10/25/2002 10:05 AM Sxponse input Pnge 22 / 62 6175 COUNTER REPAIR AND RESURFACING Description: Expenses incurred for the repair of Formica or marble countertops. Not complete replacement. Jan -03 I Feb-03 I M.-03 I Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total 777 Counter Repairs Total Monthly Cost 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 6225 ELEVATOR REPAIR Description: Expenses incurred for the repair of elevator ... not complete, replacement. Jan-03 Feb -03 I Mu-03 I Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 I Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total Elevator Repairs Total Monthly Cost 0 0 1 01 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 10/252(X)2 10:05 AM Expense Jnj­ Ng. 23 162 10:05, 10/25t2002 6170 CABLE TV REPAIR Description Expenses relating to the repair and maintenance of the cable TV system including cable leak-age. Jan-03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 I Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr Total Cable TV Repairs Mo. Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0] Comments. COSUPSF. Cost/BED: 0 Prior Actual' 0 Cost/BED: 0 Cost/PSF: 0.00 4 Increasa/Pri 6175 COUNTER REPAIR AND RESURFACING Description: Expenses incurred for the repair of Formica or marble countertops. Not complete replacement. Jan -03 I Feb-03 I M.-03 I Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total 777 Counter Repairs Total Monthly Cost 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 6225 ELEVATOR REPAIR Description: Expenses incurred for the repair of elevator ... not complete, replacement. Jan-03 Feb -03 I Mu-03 I Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 I Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total Elevator Repairs Total Monthly Cost 0 0 1 01 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 10/252(X)2 10:05 AM Expense Jnj­ Ng. 23 162 10:05 , 012512002 6180 FIREPLACE REPAIR Description, Expenses relating to the maintenance of fireplaces which includes clearing and the replacement of screens, grates, interior painting, and rile /mantle repair. I Jan-03 I Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov-03 I Dec-03 1 F—Y-1 T-771-1 Fireplace Repair Costs Other Misc. Costs Total Monthly Cost 0 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 6230 INTERIOR CORRIDOR Description, Expenses incurred for the repair of interior corridors ... not complete replacement, Jan-03 Feb-03 I Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 De.-03 Yr. Total Interior Corridor Repairs 7' X , Total Monthly Cost 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 10/25/2002 10:05 AM Ex ens. I.Pw Pup 24 / 62 Interior Light Bnlb Aa5umptionss Avg. Cost / Case of Light Bulbs x'•550,00 = =, Jan -03 Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total # of Cases Purchased / Mo. ' f� Total Monthly Cost 1 50 01 0 1 50 0 0 0 100 0 50 0 0 250 101-15/2002 10:05 AM Expense Input Ng,, 25 / 62 1n:os. 1on_sn_oo2 6185 INTERIOR ELECTRICAL REPAIR D,scril2tion, Expenses relating to the repair and/or replacement of electrical fixtures which includes light fixtures, ceiling fans, wall outlets, etc, for interior use at the apartment cotntnunity. (Does not include the above for use in Interior Corridor). Also includes the cost of batteries, breakers, ballast, electrical tape, fuses, and globes for light. Interior Electrical Repajr Assumption, Avg. Cost / Service Cali B Jan -03 Feb -03 Mar -03 I Apr -03 May -03 Jun -03 I Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 11 Yr. T.talT.tal7 # of Service Calls l Mo. 0, {% 0. 4 t 0 0 D x , ;. 0. �., '„ 0, ;.i C.J Service Costs 0 0 0 0 0 0 0 0 0 0 0 0 Other Misc. costs "1:110. - '`'rn�i„ i,fl .- ;"(Q1i 't3-, "., ti, - %•1A0 r0 ,, ;�; ,�: 10Q,- fi,,. .,, {lE A00 Total Monthly Cost 100 0 0 100 0 0 1 100 0 0 1 100 0 0 400 Comments {UjggQ a { CosUPSF: 0.00 I v ` i Prior Actual: 345 Cnst/BED. 1 Cost/PSF: 0.00 Increase /Prior Y: 16% 6190 INTERIOR LIGHT BULBS Description Expense related to the purchase of light bulbs for vacant BEDS. Includes vanity bulbs, patio/balcony lights, closet bulbs, and florescent lights. Does not include fixtures and parts. Interior Light Bnlb Aa5umptionss Avg. Cost / Case of Light Bulbs x'•550,00 = =, Jan -03 Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total # of Cases Purchased / Mo. ' f� Total Monthly Cost 1 50 01 0 1 50 0 0 0 100 0 50 0 0 250 101-15/2002 10:05 AM Expense Input Ng,, 25 / 62 10/25/2002 10:05 AM E"nsc Input Htga 26 / 62 10:05 h:. 100/21002 6195 INTERIOR PAINT Descrintiow Includes the costs associated with touch -up or complete paint for occupied BEDS during lease term. Does not include repairs. htcludes labor and materials. Complete Paint A5sumntiotts Touch-Up Paint Assumptions Avg. Cost for Complete Paint ¢ UO, Average Cost for Touch -Up Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total # of Oceup. Complete Paint/Month -0 # of Occupied Touch- Ups/Month':. ��—� Occupied Complete Paint Costs 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 Occupied Touch-up Costs 0 0 0 0 0 0 0 0 0 0 Misc. COStS �0Y n0 �0Y ',,}' () Total Monthly Cost 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 Comments ° 'CosUPSF: 0,00 C o 0 PriorActual: 8 82 x r Cost/BED: 1 r < �Cost/PSF: 0.00 „ Increase /Prior Y: 100 6265 INTERIOR REPAIRS Description' Expenses incurred for the repair and maintenance of all interior doors, replacement of hardware on cabinets and doors, toilet paper holders and rollers, cabinet repairs, weather stripping, bathtub tile re- grouting and repair. Also includes closet shelves, caulk, peepholes, door chains, mirrors and towel bars. To include doorstops, door knockers, and miscellaneous items for occupied units during lease term. Jan -03 Feb -03 I Mar -03 Apr -03 May -03 Jun -03 I Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Interior Repair Costs n�f „ „y,(j <�;;.; 0 ,:. ,:; „' 41 ., D;' Total Monthly Cost 0 0 0 0 0 0 0 0 1 0 0 0 0 Comments;,CosUPSF; xF 0.00 t Cost/BED: 0 t �� p t� t ✓ { 1 t �` �P rior Aotual: COsUBED: 140 0 Cost /PSF: 0.00 Increase /Prior Y 100 / 10/25/2002 10:05 AM E"nsc Input Htga 26 / 62 10/25/2002 10:05 AM 13"nse Input Pnts, 27 / 62 Jan-03 Feb-03 I Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total 10:05 0/25/2002 6205 INTERIOR SHEETROCK REPAIR Occupied Repair Cost 0 0 0 0 0 0 0 0 1 0 0 0 0 Description: Interior repairs to sheetrock due to water damage, i. e., roof leaks, plumbing leaks, etc. to include TB&T and paint, "'AL v Total Monthly Cost Jan-03 I Feb-03 I Mar-03 Apr-03 May-03 Jun-03 Jul-03 I Aug-03 I Sep-03 Oct-03 Nov-03 F Yr. Total7 Dec-03 Shectrook Repairs T,s V""- 'Co 't/BED: 01 Total Monthly Cost 0 1 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 Prior AC'Ual; J C ""/B , ED. 1 0 Colurneill's; , Cost/PSF: Cost/PSF: Increase/Prior Y: 0 1 P1101Ac'ual; 34 COs' 'BED: 0 Cost/PSF: 0.00 Increase/Prior Y: 100% 6210 INTERIOR VINYL AND TILE Description Cost associated with minor repairs to vinyl and tile floors for occupied units, Does not include major sub-floor work. Vinyl and Tile Repair Assumptions Avg, Vinyl & Tile Repair Cost 10/25/2002 10:05 AM 13"nse Input Pnts, 27 / 62 Jan-03 Feb-03 I Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total # of Occupied BEDS Repaired 7 7, ',7�7777p""' 77771 R 770 770,1 , �A ­­'' """, T 7751 1P, Occupied Repair Cost 0 0 0 0 0 0 0 0 1 0 0 0 0 Other Mise, costs "'AL v Total Monthly Cost F 0 T_( 0 0 0 0 0 0 0 0 0 0 1 Comments: C.stfPS R 0.00 V""- 'Co 't/BED: 01 Prior AC'Ual; J C ""/B , ED. , Cost/PSF: Increase/Prior Y: 10/25/2002 10:05 AM 13"nse Input Pnts, 27 / 62 10:05, Jr52002 6235 JANITORIAL SUPPLIES WINDOW COVERING REPAIR PQm ti0= General cleaning supplies used to clean apts., models, Info Center that are not related to any other account, i. e., _ TEA's. Description, Expenses related to the repair, maintenance or replacement .Ianitorial Supnlics Assam t0 ions Supply Costs per Move In SQ -tH3A San -03 I Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul-03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 I F—T—T.—tal #of Occupied BEDSCleaned ,.. ,.;'f,i}..,,,..'>�,i) :.:;0 ':?14J ;- ..,,,,�,,. .P} .- ::.,�, ,- '::'p,• 11 ht bliud Repair Assumptions Avg. Miniblind Repair Cost2QOb,' `. -'�: 0 ;. -£T ;:;'.,.t,0 ;;,•�%,., A,,:,.'6 ,�. Occupied BED Supply Cost Jan -03 I Feb -03 I Mar -03 I Apr -03 Yr. Total 0 0 0 0 1 0 1 0 1 0 1 01 0 1 0 1 0 0 01 Other Supply Costs 0 0 atl�.' 0 .u00'. ' 30SR� 0 ., 5tl. 51}•. '�. ,50 600 Total Monthly Cost 50 1 50 1 50 1 501 50 1 50 1 50 1 1 0 1 50 600 SO 1 50 1 501 50 Comments Ciublkr ii0ii i iw1u Cost/PSF: 0.00 „'' ;. t75. , 0 =' CostBED: I S Iq$ it t f`r Y; 4 � 1 h y 75 0 1 0 1 75 Prior Actual: • 91 1, 1 �Cost/BED: 3 0 0 75 0 0 COSt/PSF: 0.01 Increase /Prior Y: 69 6240 WINDOW COVERING REPAIR Description, Expenses related to the repair, maintenance or replacement of miniblinds or other window coverings for occupied units. 11 ht bliud Repair Assumptions Avg. Miniblind Repair Cost2QOb,' Jan -03 I Feb -03 I Mar -03 I Apr -03 Yr. Total May -03 Jun -03 Jul -03 Aug -03 Sep -03 I Oct -03 Nov-03 Dec-03 ## of Occupied BEDS Repaired ., .,,.," l?. ,: ti _ : ^,,x : i}. .,I 0 , „< ;; r ..<. t �'; 0 d Occupied Repair Cost 0 0 0 0 0 0 0 1 0 01 0 1 0 1 0 1 0 Other Misc. costs' -;;5.n = i ( „'' ;. t75. , 0 =' p i5< ;:; 0 Total Monthly Cost 75 0 1 0 1 75 300 0 0 75 0 0 75 0 0 1025/2002 10:05 AM Expense Tartu Pogo 28 162 6245 RECREATION FACILITY REPAIR Description: Expenses related to the repair and maintenance of the recreation facility to include racquetball, sauna, steam room, fitness equipment, sports court, clubroom, etc... Jan -03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 I Jul -03 Aug -03 I Sep -03 I Oct -03 Nov -03 Dec -03 Yr. Total Recreation Fac. R & M flD0 v 0„ „5t? i%; ' 1] %a0 0, U, 5�1.: 0' 450 Total Monthly Cost 100 0 0 250 0 0 50 0 0 50 0 0 450 10125/2002 10:05 AM Expen o Input Np 29 / 62 10:05. - '102Sf2002 6215 PLUMBING REPAIR Description, Expenses incurred for parts and labor for repairs to the plumbing system to include faucets, showers, toilets, hot water heaters, boilers, and sewers. Includes stein and bonnet assemblies, tank lavers, tank lids, thermostats coupler for heaters, tub steins and stoppers and all other miscellaneous plumbing supplies. Plumbing$e aiR r A55um tp ions Average Cost / Service Call . ` %i06,00 >.'. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total k of Service Calls /Me, ,,: ,;..7.,,0 ,,:, 0, "0•` _. ., , sf}- ;, . ,,,;; ",1). -., „ -. ,.. -0 , ,. _ .;0- - 0= '','0'; 0 Plumbing Service Call Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 Misc. costs 0 0 . . . SQOOther '0: 400 Total Monthly Cost 100 0 0 100 0 0 100 0 0 100 0 0 400 6245 RECREATION FACILITY REPAIR Description: Expenses related to the repair and maintenance of the recreation facility to include racquetball, sauna, steam room, fitness equipment, sports court, clubroom, etc... Jan -03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 I Jul -03 Aug -03 I Sep -03 I Oct -03 Nov -03 Dec -03 Yr. Total Recreation Fac. R & M flD0 v 0„ „5t? i%; ' 1] %a0 0, U, 5�1.: 0' 450 Total Monthly Cost 100 0 0 250 0 0 50 0 0 50 0 0 450 10125/2002 10:05 AM Expen o Input Np 29 / 62 10:05:.. 10/2512002 6195 WALLPAPER REPAIR Dewril2tiow Expenses incurred to make minor repairs and /or replace wallpaper. Includes die preparation, labor costs and supplies. Wallpaper Repair Accpmptiona Avg. Wallpaper Repair Cost Jan -03 Feb -03 Mar -03 I Yr. Total Apr -03 May -03 Sun -03 I Jul -03 I Aug -03 I Sep -03 Oct -03 Nov -03 Dec -03 # of Occupied BEDS Repaired , "', 7 , y'; = ;: ,.= „gJ =' : '' 0. : , "; ` ; - -, e'17:.' , "' -'., 0' �;,,;,, {}... ' ; ,(1' -, ,`„ � , 4i,' `;'„ 0. ;:`.: ' B. ;; € 777 Occupied Repair Cost 0 0 0 0 01 01 01 0 1 01 01 01 0 Other Misc. costs Total Monthly Cost f 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 10125/2002 10:05 AM ExN— Input Pg. 30 / 62 6200 CARPET CLEANING/REPAIR/DYES Description: Expenses related to the clearing & repair of carpets In occupied BEDS. Carpet Clearting Assumptions Cost for Clean ,$25,00 # of Occupied Units Cleared # of Occupied Units Repaired Occupied Clean Cost Occupied Repair Cost Other Misc. costs Total Monthly Cost Cornmeigs, modf Carpet Repair AssumpIions Cost for Repair Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 77-1 7717 0 0 0 1 0 0 1 0 0 1 0 1 0 1 0 0 --o T-----0 0 0 0 0 0 0 0 0-j'", 0 1 0 0 0 "0"1 0: ;50 50 0 0 so 'R 0 0 0 50 50 0 0 0 Cos(RSF: C ost/BED: 0,00 01 Prior Actual; 907 COS"/BED: 2 COSVPSF: Increase/Prior Y: 10125/2002 10:05 AM E.j=.'o Input Np 31 /62 6250 LOCKS AND KEYS Descriotiom Expenses incurred to repair and/or replace locks and keys. Includes the cost of re- keying the apartment, # of Boxes Key Blanks # of Lock Hardware Sets Key Blanks Cost Lock Hardware Sets Cost Other Mise costs Total Montlily Cost 10:05,. 0/25/2002 Locks Box of Key Blanks Lock Hardware Set and Keys Assumptions 00�1 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 FRX Yr. Total 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 1 0 0 0 0 0 0 0 Q , �,+?5 "Di 0'.25.: Ot g$.. 0 - 25? :0 I50 25 0 25 0 25 0 25 1 0 25 1 0 25 0 150 6265 OTHER INTERIOR MAINTENANCE Descriptiom Any other expense associated widt interior repairs or maintenance not specifically included in another account, Jan -03 I Feb -03 I Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 --Yr. Total Monthly Expenset.. Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0 0 10/2512002 10:05 AM Expcnsc Input Np 32 / 62 10:05, 10/25/2002 4215 TENANT REIMBURSEMENTS STUDENT HOUSING Jan -03 I Feb-03 I Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total T Total Tenant Reimbursement p ,,7 (ENTER AS A POSITIVE) Income/PSF: F-0-0700 Income/BED: 1 0100 TENANT REIMBURSEMENTS STUDENT HOUSING COLLECTION LOSS Jan-03 Feb-03 I Mar-03 Apr-03 May-03 Jun-03 I Yr. Total Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec -03 Tenant Reimbursement Coll, Loss ISM?. 77 Q% 7, (ENTER AS A NEGATIVE) Expense/PSF: Expense/BED: F----O--001 Total Tenant Reimbursements (NET) Jan-03 Feb-03 I Mar-03 Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec-03-1 Yr. Total 1 01 01 01 01 01 01 01 01 01 01 01 01 Comments: Income/BED: 0,000 Prior Actual: 2826 Income/BED: 5.11 I e/PSF: 0.016 Increase/Prior Y: 100% EXTERIOR MAINTENANCE 6275 POOL AND SPA SUPPLIES Description, Expenses related to chemicals, test equipment, the repairs, pool supplies, filters, skimmers, baskets for pools and Jacuzzis. Includes volleyball acts, etc. Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Yr. Total Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Pool supplies Other Misc. costs . . .. . . . 01 0 Total Monthly Cost too 100 3.50 350 450 450 450 450 400 300 1 1001 1570 C"t/psr. 0,02 Cost/BED: 71 P no' A C.sl/BED O'ua': Cost/PSF: 4 , 21!9] F 8 0 02 Increase/Pr ior Y:: M512002 10:05 AM Esr,— lopw ll.g. 33 /62 M05 10252002 6275 POOL IN-HOUSE *Rolled Into count 627$ Description Minor repairs to pools, spas and Jacuzzis performed by property personnel. Does not include repairs performed 25 25 25 25 1 25 251 under maintenance contracts(see CONTRACT SERVICES). Cost/PSF: � Jan-03 I Feb-03 I Mar-03 Apr -03 May-03 May-03 Jun-03 I F—Y-7—Too7i 7 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 N Monthly Pool Repairs # of Batteries Mo. Total Monthly Cost 0 1 0 1 0 0 0 1 o,11 0 0 0 1 0 1 0 1 0 1 0:1 6280 GOLF CART REPAIR Descril2tion, Includes expense for maintaining and/or repairing the golf carts owned by the community. Items such as tires, battery chargers, painting, etc. Golf Cart Battery Assumptions Cost / Battery 25 1 25 1 25 25 25 25 1 25 251 CommelComments: A' Cost/PSF: � Jan-03 I Feb-O' , 3 May-03 Jun-03 I Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 # of Batteries Mo. o,11 Battery Cost 0 1 0 1 0 1 0 1 Increase/Prior Y: 0 0 1 0 0 0 1 0 1 0 1 0 Other Misc. costs Total Monthly Cost 25 1 25 25 25 25 1 25 1 25 25 25 25 1 25 251 CommelComments: A' Cost/PSF: � Cost/BED: Hno, Ar l: 'U a C 0 /BF_ D CosUPSF: 0.00 Increase/Prior Y: 1025/2002 10:05 AM Expen.qc Input Page 34162 10:05. 10?'5/2002 HVAC REPAIR/MAINTENANCE Descriptiom Expenses related to the maintenance ofheating and air conditioning systems to include parts, labor, and air conditioning filter replacement expenses, Includes A/C motors, capacitors, freon, overloud switches, replays, fuses, thermometers, thermostats, etc, Filter Replacement Assumptions Other AssUmq1jQm 60 Cost HVAC Filter / Unit il"4'id I Cost Freon Purchase Cost HVAC Service Call Unit Filter Costs Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 F—Y— Total 7' # of Unit Filters Replaced 0 0 346 # of Freon Purchases /Mo. 0 0 0 0 100 200 0 # of Service Calls / Mo. 0 1 0 500 Service Call Costs 0 2 0 150 0 0 ISO 0 0 0 0 Unit Filter Costs 260 0 0 0 0 0 0 1 260 0 0 0 0 520 Freon Costs 0 0 0 0 100 200 0 200 0 0 0 1 0 500 Service Call Costs 0 0 0 0 150 0 0 ISO 0 0 0 0 300 Compressor Purchase Costs 2g3"-- KXam �'X Prior Actual: F To"I 0 Other Misc. costs LIE �U"e 67 Increase/Prior Y: 2,450 Total Monthly Cost 610 0 0 0 600 1 550 350 1 960 1 350 0 1 o 3501 6285 BOILER PARTS AND REPAIRS -R.11.d int. .--ut 62$5 Description Expenses incurred for the maintenance and repair of boilers, including parts and labor. Includes miscellaneous pails and supplies associated with boilers, Jan-03 I Feb-03 Mar-03 I Apr-03 May -03 Jun-03 I Jul-03 I Aug-03 Sep-03 I Oct-03 Nov-03 Dec-03 Yr. T�otai Monthly Boiler Repairs Total Monthly Cost 0 0 0 0 0 0 0 0 0 1 0 1 0 771 Conatiolim . .. . . .. . . -'0 C. t/PSF: 0.00 Cost/BED: 0 2g3"-- KXam �'X Prior Actual: F To"I Cost/BED: Cost/PSF: Increase/Prior Y: 10/25/2OD2 10o.3AM Esp—,. Input P.gv 35 / 62 10:05 0125/2002 6290 LANDSCAPE SUPPLIES Descriptiow Misc. Costs associated with Landscape (i.e. sprinkler system repair, seasonal color changes) not covered in the annual Landscape Contract Jan-03 I Feb-03 ] Mar-03 Apr-03 May-03 Jun-03 I Jul -03 Aug-03 Sep-03 Oct-03 No,-03 Dec-03 I FYr. -Total Landscape Supplies/Repairs A-,"TT-77,77,77, 77,,7�77 '7,7,' ,,[7 "5'0' '00""I J F 300 Total Monthly Cost 0 01 100 1 0 1 0 1 100 1 0 1 0 1 1001 0 1 0 1 0 Comments; Jan-03 I Feb-03 3 May-03 Jun-03 Jul-03 Cwt/PSF: Yr. Total Pond/Lake /Fountain Wily Cost C ID ost/BED: 0 0 0 0 0 0 0 0 0 0 0 0 Comments --Q 0 t/P F: C S 0.00 Prior Actual: 0 Cost/BED: Cost/BED: 0 000 "Increase/Priory: -100% 6295 PONDALAKE/FOUNTAIN REPAIRS D"criptiom Expense related to the repair and maintenance of ponds, lakes, and fountains not covered in the contract expense line item. Jan-03 I Feb-03 3 May-03 Jun-03 Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total Pond/Lake /Fountain Wily Cost ID Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0 Comments --Q 0 t/P F: C S 0.00 Cost/BED: 0 Prior Actual Cost/BED: Cost/PSF: Increase/Prior Y: 6145 CONTRACT CLEANING Descriptiow Contract cleaning of exterior mid common areas. Jan-03 Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 Nov-03 7c 03 Contract Cleaning Cost d Total Monthly Cost 0 01 0 1 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0-1 10/25/2002 10:05 AM ExJ—' fi'pw Nge 36/ 62 10:05 a 0/2(X)2 6305 EXTERIOR WALLS Descri tp ion: Exterior Walls Repair Cost Total Monthly Cost Comments, %Y 6310 # of Roof Repairs Roof Repair Costs Other Misc. Costs ROOT REPAIRS Descrintiom Expense associated with repair of exterior concrete and/or stone retaining walls Jan-03 I Feb -03 I Mar -03 Apr -03 May -03 Jun -03 I Ju1-03 I Aug -03 Sep -03 Oct -03 I Nov-03 I Dec-03 To Comments, �. k Cost/PSF —Yr'. —tales Cost/BED: 0 1 0 0 0 0 0 0 0 0 0 0 0 0 Aug -03 �t t � .x "�3° ✓b 4 � s � CosUPSF: 0.00 (103) io) d jCost/BED: s Coat PS� 0 s r � /Prior Y: - 100 %.0 } 't - Prior Actual: .Cost/BED: 0 0 Cost/PSF: 0.00 0 01 Increase/Prior Y: 0 Expenses incurred by the apartment community to maintain the exterior roofs and/or make necessary repairs to roofs and vents. Exterior Roof Assumptions Average Cost / Roof Repair1,00;00 1 0 1 0 1 0 1 0 1 0 �_ J Comments, �. k Cost/PSF 0 00 Cost/BED: 0 1 Yr^. Total�� Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Uec -03 Prior Actual: (103) io) s Coat PS� �� .Inorease /Prior Y: - 100 %.0 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 Total Monthly Cost 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 �_ J Comments, �. k Cost/PSF 0 00 Cost/BED: 0 1 Prior Actual: (103) io) s Coat PS� (0 .Inorease /Prior Y: - 100 %.0 1025/2002 10:05 AM Enpcncc Input Pogo 37 / 62 6315 # of Window Repairs # of Screen Repairs # of Door Repairs 10:05. 10/252002 WINDOWS AND SCREENS Description, Expenses incurred for the cleaning, rescreening, and replacement of exterior windows; also includes window leaks. Window and ScIm Assumptions Avg, Cost / Window Repair150;OD 0 0 1 0 0 Avg. Cost Screen Repair 01 0 0 0 Avg. Cost/ Glass Door Repair ...3im , 0 0 0 0 0 0 0 Yr.Total Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Ncv.03 Dec -03 0 0 0 0 o 0 r xv 0 0 0 0t 0 0T 0 i� 0: 4 ti Cla q , q (},'` ` fl _ , 4, 77T777777 , -.;,q� F o1 1,200 0 Window Repair Costs Screen Repair Costs Door Repair Costs Window Cleaning Costs Other misc. Costs 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D ':� ,p, rr, -,, x _ , q (},'` ` fl _ , 4, 77T777777 , -.;,q� 0 1,200 Total Monthly Cost 100 100 100 100 100 100 100 100 100 100 100 100 1,200 Comments �07 CAN�Cb�_ kll$ 8tlif ffa} 1I$ Q} xh1111G11 t�Ci9plt 7iSlri3 a f3{ i^7�7 1iltl 11Qf Cost/PSF: 0.01 1it1,�t19t# yaf sy #4ost61 Cost/BED: 2 { c Prior Actual: 0 J Cost /BED: 0 Oos PSF: 0.00 ra Increase /Prior Y: -100% 6370 OTHER EXTERIOR REPAIRS OR MAINTENANCE Description• Expenses relating to the repair and maintenance of all breezeways, exterior building walls, signage and raise. exterior carpentry repairs: to include stucco repair, brick- pointing, fascia/trim, etc. Does not include exterior repair expense due to building and structural damage. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 .Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Signage Repair Costs r: Q _t0 �s 0 tj} „ t :n. 0 0 Building Repair Costs #'} -i i 0 .; t 1 Other Mise, Costs :n ,ii. s `- �.0, {1 ,; 0 T. 0 9i, „1 , t3, 41 Total Monthly Cost 0 0 1 0 1 0.1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1025/2002 lQ05 AM Expenn Input Ngc 39 / 62 6320 EXTERIOR PAINT Exterior Paint Repairs Contract Labor Other Misc. Costs Total Monthly Cost Comments, 6325 k of Service Calls Service Call Cost Other Misc. costs Total Monthly Cost Commentr l 10:0: 10/2512002 Expenses incurred for the preparation and painting of the exterior of any buildings, stairs, railings, front doors, fences, transformers, hydrants and mailboxes of the apartment community. Major exterior painting should be capitalized. Jun -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total K?? fl 73 iS U 0 d� it Si p iS r IS1 fl ty 4 �_ 0 7 Ik A fit:. 0 0 0 01 01 01 01 01 01 01 01 01 0 tz Cost/PSF: 0.00 Cost/BED: 0 Prior Actual: 659 Cost /BED: i Cost/PSF: 0.00 Increase /Prior Y: 100 EXTERIOR AND GARAGE ELECTRICAL Descri to ion' Expenses relating to the repair and/or replacement of electrical fixtures which includes light fixtures, timers, photocells, ballas, and globes /covers for exterior use at the apartment community. Exterior Electrical Assumptions Avg. Cost / Service Call 1O;Qp` Jan -03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 I Aug -03 Sep -03 I Oct -03 Nov -03 Dec -03 Yc- Total --� PT P 0 1 01 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 01 01 0 01 01 01 01 01 01 01 01 0 O Cost/PSF: 0.00 r 4 Cost/BED: Prior Actual: 85 Cost/BED: 0 Cost/PSF: 0.00 Increase /Prior Y: 100 10/2512002 10:05 AM Expense Input Page 39 162 6330 # of Cases Purchased Total Monthly Cost Mrs IMSW02 EXTERIOR LIGHT BULBS 5 Description: Expense related to the purchase of light bulbs for carports, garage, wall packs, and flood light, Does not include fixtures and parts. Exterior LJghL Bib AsnunpjLQm Case of Exterior Light Bulbs damaged gate anns, motors, and entry screens. Jan -03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 I Jul-03 I Aug -03 I Sep-03 Oct-03 Nov-03 Dec -03 Yr. Total 7777,-7-j" -"P-"l -7-1 —T—. W-17 Jan-03 Feb-03 I Mar-03 Apr73 May -03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 N 0 1 Prior Actual: Cost/BED F----8736 2 25 0 25 0 25 0 1 25 0 25 o 25 01 6345 ACCESS GATE REPAIR Access Gate Repairs Total Monthly Cost Description, Expenses incurred to repair and maintain controlled access gate equipment. Also includes the replacement of damaged gate anns, motors, and entry screens. Jan -03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 I Jul-03 I Aug -03 I Sep-03 Oct-03 Nov-03 Dec -03 Yr. Total 7777,-7-j" -"P-"l 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 -01 C ost/PSF: 0 1 Prior Actual: Cost/BED F----8736 2 ost/PSF: 0.00 Increase/Prior Y] 100% 10125/2002 10:05 AM E.P...'. Input Pag. 40 / 62 10:05 n sr cz 6350 WALKS AND PARKING LOTS Description• Expenses incurred to repair and maintain parking lots. Includes de- icing. Also includes all repairs to sidewalks, pavers, stairs, and bumpers. Includes parking loUgarage sweeping and clean -up, Includes snow removal and paint for striping machine. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 F—T-7-ta-71 Jut -03 Aug -03 Sep -03 Oct -03 Nov-03 Dec -03 1 Routine Maintenance Cost OdierMisa. costs s.,3 0,', ° ;: :.,,Q �, Ci T7r} '= 250 Total Monthly Cost 0 0 1 0 0 1 0 0 250 0 0 0 0 1 0 250 6355 GARAGE /CARPORT REPAIR AND MAINTENANCE Descrintiom Repairs and maintenance Total Monthly Cost Comments: Costs associated widi the repair and maintenance of carports or garages, I. e., carport fascia trial, garage door openers, exhaust faits, etc. Jan -03 I Feb -03 ( Mar-03 Apr -03 ( May -03 Jun -03 I Jul -03 Aug -03 Sep -03 Oct -03 I Nov -03 I D703 Yr. Total Prior Actual: 0 Cost/BED: 0 Cost/PSF: 0.00 Increase /Prior Y: 0 10/15/2002 10:65 AM Exams. Inpi Pug. 41 / 62 10:05 i,. 10/25/2002 6360 TOOLS AND EQUIPMENT Descriptiou, Expenses incurred for the replacement of broken maintenance tools and equipment not covered by any other broad category in the Repair and Maintenance expense category. Also includes repair of gas grills, replacement and /or repair of water hoses, and fire extinguishers. Jun -03 I Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Dec -03 Yr. Total Capital Purchases (>$1,000) 0-"[' ' o o 0 �0 0 1 0 0 0 0 0 0-. Tools and Equipment `� °; ti{i . ',''` 0',. _, :; : 0, "` o. "w:1 0 .,'.r, 0 v' . . Total Monthly Expense 0 0 1 0 0 0 1 0 0 0 1 0 1 0 1 0 0 0 Comments: ' Cost[PSF: 0.00 ,t r s ,t Cost/BED: 0 Prior Actual: 861 Cost/BED; 2 ' Cost /PSF: 0.00 s J ti "' • .� Increase /Prior Y: 100 6335 EXTERIOR PLUMBING Descriptiam Expenses incurred for parts and labor for repairs to sewer lines, water mains, storm sewer located under buildings or in the common area. Jan -03 Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul -03 Aug -03 Yr. Total Sep -03 Oct -03 Nov -03 Dec -03 Plumbin g Costs Total Monthly Cost 01 0 1 0 1 0 1 01 01 0 1 0 1 L! 0 1 0 1 0 1 0 Connnents Cost/PSF: 070 Cost/BED: 0 k Prior Actual: Cost/BIED: 6 0 " F Cost/PSF: 0.00 �Increase /PriorY: 0% 10/25/2002 10:05 AM Expense Inj t Pug. 42 / 62 6365 FENCE REPAIR Description, Fence Repair Costs Total Monthly Cost 10:05 10r5/2002 Costs associated with repair and/or maintenance of patio fences, balcony railings, pool fences/gates, and perimeter fences. ADVERTISING AND PROMOTION 6640 TRAFFIC COUNTER Dg5f2riptiom Expense for traffic counting service to measure drive-by traffic at each community. Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 1 F–Y-77771 Traffic Counter Expense Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0 l0r-1512(X)2 10:05 AM Expo— Input Pogo 43 162 10:05 , - 70/252W2 6645 LOCATOR FEES Description, Expenses related to the commissions or other fees paid to any licensed agency with which the community has a signed commission agreement for referrals of new residents. Locator Fee Assumptions m ptions % of New Leases thra Locator Fee as a % of Project Rent Q* Jan -03 I Feb -03 I Mar -03 I Apr -03 May -03 I Jun -03 I Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec-03 Yr. Total # of Leases dirt Locator 0 0 0 0 0 0 0 0 0 0 0 0 0 Avg, Locator Fee 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Monthly Costs 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 0 0 comments. a Cos UPSF: 0.00 t h CotaBED: 0 I } Prior Actual: 3,679 Cost/BED: 7 CosUPSF: 0,02 U.. , Increase /Prior Y: 100 % 6650 LOCATOR RELATIONS Locator Party Costs Locator Gift Costs Other Relation Costs Total Monthly Cost Expenses incurred relative to locators other than fees and commissions for referrals, such as locator promotions to encourage traffic. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total p' U.. 0 0 0 0 0 0 0 0 0 0 0 0 10/25/2002 10:03 AM Expense Input Pngc 44 / 62 6655 RESIDENT RELATIONS 1 Move- hi/Renew Gift Cost Seasonal Gift Costs Other Rotation Costs Total Monthly Cost Comments dacidiib 10:05. i 0/252002 Expenses incurred by the community to provide resident gifts for new move - ins /cost of providing Move -in Gift Cost/Uase Jan-03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 I Aug -03 I Sep -03 Oct -03 Nov -03 movie rentals /renewal packages and/or occasional gifts purchased for residents. Also, includes Yr. Total Renew Gift Cost/Renewal keychains, preferred resident cards, movie tickets, etc.... 500 0 600 1 0 2,950 Commentr Apn!l p � 11 v l �+balltti � amen, # i0 at si rg ttt>1015trE r fflc €t§IlIi exile e ; VQt1t v ty 7 C F777 Total Jan -03 I Feb -03 I Mar -03 F Apr -03 I May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Dec -03 { - 7 CostBED: S i` 75 1 01 01 0 1 27 1 01 01 1,062 1 01 0 1 0 0 1,164 s U a o 0 i1 0, 0 T00 ,,,.,: 00, plT,..; X00,. <:': , - ,'�Ol. 1.00,.- ;.:;, 0 -,,, .;0;,,, 0. ;_•'- 0.;- ,. t5,,,': 5 600 175 100 100 1 100 1 127 100 1 0 1 1,062 1 0 1 0 1 0 1 0 1,764 I Cost/PSF: 0.01 Prior Actual: Cost/: CosUPSFPSF: 0.01 Increase /Prior Y: 9 6656 RESIDENT FUNCTIONS Descri to iow Includes expenses incurred by the apartment community to provide parties for residents. Jan-03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 I Aug -03 I Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Resident Function Cost Total Monthly Cost 300 0 0 1,250 100 100 100 1 0 1 500 0 600 1 0 2,950 Commentr Apn!l p � 11 v l �+balltti � amen, # i0 at si rg ttt>1015trE r fflc €t§IlIi exile e ; VQt1t v ty 7 C Cosr/PSF: 0.02 { - 7 CostBED: S i` �. Prior Actual: 2,941 q i i 1 Co$UBED: COSUPSF: 5 0.02 t Increase /Prior Y: 0 6657 RESIDENT REFERRALS Description' Expenses incurred for cotmnissions or allowances paid to residents for referrals, where allowed by law. Jan -03 I Feb -03 Mar-631--Apr-03 I May -03 I Jun -03 I Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Resident Referral Cost Total Monthly Cost 1 0 1 0 1 0 1 0 1 01 01 01 0 1 0 1 0 1 0 1 0 1025/2002 10:05 AM Expcnsc Input Ng. 45 / 62 Description Expenses related to the production and placement of advertising scheduled in magazines or periodicals (excluding Apartment Guides). J.-03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 Nov-03 Dec-03 Yr. Tota! Ad Production Cost by Mo. Ad placement Cost by Mo. Total Monthly Cost "21,1111"0 "k 10:05, 1011512(W- 6670 NEWSPAPER Description Expenses related to production and placement of advertising scheduled ill newspapers, Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 I F—Y-1-7071-1 Ad Production Cost by Mo, 0 01 1,8301 0 1 Ad Placement Cost by Mo. 0 1 0 1 0 1 0 1 0 1 0, A Total Monthly Cost 500 500 500 5001 500 1 500 1 500 1 500 1 0 1 0 1 0 1 0-1 o.oi Collullellm Cost/PSF: 0.02 Cost/BED; 7 "CosupsF: Prior Actual: 3,788 Cost/BED: 7 �Cost/PSF; 0.02 Increase/Prior Y: -6% 6675 MAGAZINES Description Expenses related to the production and placement of advertising scheduled in magazines or periodicals (excluding Apartment Guides). J.-03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 Nov-03 Dec-03 Yr. Tota! Ad Production Cost by Mo. Ad placement Cost by Mo. Total Monthly Cost "21,1111"0 "k 0 01 1,8301 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 o.oi & ­C "CosupsF: ostfBE D: 3 10/25/2002 10:05 AM Esp...,. Input Ng. 46 / 62 6680 BILLBOARD ADVERTISING Descriptions Expense incurred for the preparation of all mechanical art plus media cost for all outdoor billboard utilized by the 10:0- 10/25/2002 6677 YELLOW PAGES Description p Expense for boldface listing and/or classified ad in the telephone directories used for advertising purposes by the Yr. Tota] Jan-03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun -03 Jul-03 Aug-03 community, Billboard Production Cost Jau-03 Feb-03 Mar -03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Totai Ad Production Cost by Mo. Ad Placement Cost by Mo, 4 0 Total Monthly Cost 1 0 0 1 0 1 0 0 0 0 0 0 0 0 6680 BILLBOARD ADVERTISING Descriptions Expense incurred for the preparation of all mechanical art plus media cost for all outdoor billboard utilized by the community. Yr. Tota] Jan-03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun -03 Jul-03 Aug-03 Sep-03 Oct-03 Nov -03 Deo-03 Billboard Production Cost Billboard Monthly Le ase Total Monthly Cost 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 --70 Comments: Cost/PSF: CostfBED: 0 Prior Actual: Cost/BED: %mincrease/Priory: o Cost/PSF: 10/25/2002 10:05 AM ExN— lnpui Pap 47 / 63 10/25/2002 10:05 AM Expcnsc Input Fngn 48 / 62 100 100-511002 6655 BROCHURE ADVERTISING Description• Expenses incurred for the production, printing, mid distribution of marketing brochures and floorplan inserts used for new residents and prospective residents. Average Cost per Brochure „; =53,ppti F.—T—Tt-T-j Jan -03 I Feb -03 Mar -03 Apr -03 May -03 Jun-03 I Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 I # of Brochures Purchased ,.,;'I;G00, ..,,,.. 1. ,.,, ;s;i . ,`% 'r ,Q „ . ° „ =, , ;” }. „ . ,; • ; > 0 ,,.,.' - 0 r 1,000 ,7"9 < Total Monthly Cost 3,000 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 3,000 0 1 Comments: COf11�tC1i]JIt%iit?iBi tf?Ii�C�l�14�iCdtaSBftUGl1�Lilt�4lttj Cos PSF: 0.02 'Cost/BED, 5 Prior Actual; 0 Cost/BED: 0 s C t/PSF: 0 u ;Increase /PriorY: 100%.0 6690 DIRECT MAIL Description, Expenses incurred for the production, printing, postage, mailing lists, etc, for a direct mail piece. Jan -03 I Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 I Jut -03 Aug -03 Sep -03 Oct -03 Nov -03 Yr. Total Dec -03 Direct Mail Costs by Month Total Monthly Cost 0 0 0 1 0 0 0 1 0 0 0 1 0 1 0 0-1 Comments #1k11$X J F t OC1 s ti ll �I '� r COgt/PSF: 0.00 Cost/BED: 0 ' a Prior Actual: 5,876 COStBED: 11 s Cost/PSF: Increase /Prior Y: 0.03 100 10/25/2002 10:05 AM Expcnsc Input Fngn 48 / 62 6700 SIGNAGE / SIGN PLACEMENT Signage Placement Cost Signs Purchase Costs Other Misc. Marketing Signs Total Monthly Cost C2111[1 ueld—s • tatria`; 6 " Purchase of bootleg directional signs and contract labor costs for placement of bootleg signage used by the community. Also includes niiscellaneous marketing signage displayed at the property or in other locations to draw traffic to the property. Jan-03 Feb-03 Mar-03 I Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 I Oct -03I --Ro—v--0-3—F- 0 10:6 10/25/2002 6695 APARTMENT GUIDES Descriptio• Expenses related to the production and placement of advertising scheduled in Apartment Guide publications to include Haas Apartment Guide, Apartment Map, etc, Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 I FYr. _771-1-1 Apartment Guide 0 01 309 0 0 0 0 0 0 0 0 0 . ..... a4rom I pp#y 'ion Wit, 0, sand, . .. . Cost/PSF: O.GO M . ........ Cost/BED: 0 Subtotal Apt. Guide 150 17 150 150 150 150 150 ]Sol 0 1 o F ------ 51— 0 1,200 For Rent Magazine Misc• Subtotal For Rent 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 Other Guides Subtotal Other 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 Total Monthly Cost 1 1501 1501 1501 1501 1501 1501 1501 150 1 0 1 0 1 0 1 01 6700 SIGNAGE / SIGN PLACEMENT Signage Placement Cost Signs Purchase Costs Other Misc. Marketing Signs Total Monthly Cost C2111[1 ueld—s • tatria`; 6 " Purchase of bootleg directional signs and contract labor costs for placement of bootleg signage used by the community. Also includes niiscellaneous marketing signage displayed at the property or in other locations to draw traffic to the property. Jan-03 Feb-03 Mar-03 I Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 I Oct -03I --Ro—v--0-3—F- 0 309 0 01 309 0 0 0 0 0 0 0 0 0 . ..... a4rom I pp#y 'ion Wit, 0, sand, . .. . Cost/PSF: O.GO M . ........ Cost/BED: Prior Actual Cost/136D: Cost/PSF; Increase/Prior Y: 10/25/2002 10:05 AM Expense InP'n Np 49 /62 10/25/2002 10:05 AM Ex I 41 pence „ p Page 50 / 62 10:05 �. ;10125/2002 6625 NEWSLETTERS Descrip ion• Expense incurred for producing and printing the monthly community newsletter, Concierge bulletins, etc. Ian -03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 I F—Y-7-71 Newsletters Cost by Month ,i»��r -, €) Ai 0 Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0 Comments: r n ,CostfpSF: 0.00 a j r - tit CostBED: 0 J r �PriorActual: 0 CO"/BED. 0 Cost/PS F: 0.00 ., °- :Inorease /PrPorY: 0% 6705 RADIO/TV ADVERTISING Descril2tiom Expense for the production and placement of all radio/TV advertising. Jan -03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec-03 Yr. Total Radio/I'V Production Cost (i i),';i 1,500 ` ij ! Q r Qi Radio/TV Media Cost U, 0,11 i1. r ' 1- , ,,, s; ,.,,, ,..,, ti,• :..,..a 9J. :`F {J'. 0 Total Monthly Cost 0 0 0 1 1,500 0 0 1 0 1 0 0 0 0 0 1,500 Coimnents FI &dlfjUl•'ii$JF"!f _r CosUPSF: 0.01 -. t v x ED 3 10/25/2002 10:05 AM Ex I 41 pence „ p Page 50 / 62 luo 1025P002 6715 INTERNET ADVERTISING Description, Includes the expenses incurred while advertising on the world wide web, Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 I Sep-03 Oct-03 N Yr. Total Advertising Cost by Mouth 3], Total Monthly Cost 193 193 193 193 193 193 193 193 193 193 193 1931 K Cost/PSF: Cost/BED: 4 Prior Actual: 1,701 Cost/BED: Cost/PSF: ................................... 'W' Increase/Prior 6720 MODEL APARTMENT EXPENSES Descriptiom Includes the miscellaneous expenses for minor upgrades and maintenance of model apartment homes. Also includes rental furniture for models, Jan-03 Feb-03 Mar-03 Apr -03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Model Cost by Month Total Monthly Cost 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0� I025/2002 10:95 AM Ep—. ffip'.t Np 51 / 62 6725 Flag Purchase Cost Banner Purchase Costs Mat Purchase Cost Misc. Marketing Exp. Total Monthly Cost 10:05 • 1012512002 FLAGS/BANNERS/MATS Descritniow Purchase or repair of flags, banners, doonnats used for advertising purposes on the community, I Jan-03 I Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 Nov-03 Dec-03 Yr. Total 500 100 [A 350 0 0 0 0 0 250 0 1 0 0 0 0 rf, Cost/PSF: 0 Cop qo' . .. ... -�20c "W Z Cost/BED: Prior Actual: 1,622 C�ostjBED. 3 Cost/PSR Increase/Prior Y: 6730 OFFICE REFRESHMENTS Description, Expenses for purchase of soft thinks, coffee service, cookies, glasses and napkins, Jan-03 Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 I Oct-03 Nov-03 De.-03 Yr. Total Monthly Coffee Service 0 0, Other Refreshment Cost Total Monthly Cost 25 251 25 1 25 1 25 1 25 1 25 1 500 1 25 1 25 1 25 1 251 10/25/2002 10:05 AM Esp.— Input Page 52 /62 10:0. 6735 OTHER ADVERTISING AND MARKETING *Rolled into account 6735 Desoril2tiow Any other expense associated with advertising or marketing not specifically included in another account. Jan -03 Feb-03 Mar-03 Apr-03 May-03 Jun -03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 F—Y­7771 –1 Dec-03 Other Advertising Miscellaneous Other Advertising 01 Total Mouddy Cost 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 -Cost/PSF: Cost/BED: 0 4,744 zrd R �Cost/BED: 9 0.03 Increase/Prior Y: 100% 665$ CAMPUS EVENTS Yr. Total Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jua-03 Jul-03 Aug-03 Sep-03 Oct-03 -Nov-03 Dec-03 Campus Events Total Monthly Cost 0 0 1 1,5001 300 1 5001 0 1 0 1 0 1 0 1 0 1 01 01 6735 COOP ADVERTISING REIMBURSEMENT *Rolled into account 6735 Jau-03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 I Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 I Dec-03 Yr. Total , COOP Advertising Reimbursement 0 T' (ENTrR AS A NEGATIVE) Total Monthly Cost 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 Comments 0.00 "A Cost/BED: 0 Prior Actual: 'tua C. VBED Cost/PSF: „Increase /Prior IMS/2002 10:01 AM Expense Input Ng,, 53 162 100, 1025/2002 ADMINISTRATION 5838 BANK CHARGES Description, Expenses charged to the community for the cost of checks, NSF fees, wire transfers, etc. to maintain the community bank account. Jan-03 I Feb-03 I Mar-03 Apr-03 May-03 Jun-63 I Jul-03 I Aug-03 I Sep-03 I W-03 777071,7 _Dec-03� Bank Charges by Month -77 Tj Total Monthly Cost 0 0 01 0 1 0 1 0 1 01 0 1 01 0 1 0 1 –01 Comniclits: C rst/pSF; 6, Cost/BED: 0 Prior Actual: Cost/BED: Cost/PSF: Increase/Prior Y: 5855 COMMON FACILITY DUES Description; Expenses incurred for the payment of dues and fees such as planned development association dues, Jan -03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total Common Facility Dues by Mo. Total Monthly Cost 1 0 0 0 0 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 1025/2002 10:05 AM &Pe.— 1n1"a Ng. 54 / 62 5820 COMPUTER EXPENSE Description: Account should include all costs associated with business center, Capital Purchases (>$1,000) Equipment Purchases Equipment Rentals/Lines Maintenance Contracts Supplies and Paper Total Expense 10:05, 10/250002 Jan-03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun 03 I Jul-03 I Aug-03 I Sep-03 Oct-03 I Nov-03 I Dec -03 r. Total I ��o 01 ' 0- 01 1 0 " : 0' 1 '0 n 1 1 1 5847 COPIER / FAX / TYPEWRITER EXPENSE N.—ipti- Capital Purchases (>$1,000) Equipment Purchases Equipment Rcntals Maintenance Contracts Repair Costs Toner and Paper Total Expense Comments, Tor Account should include Acosta --i.wd with N.M.— —w. I I Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 I Sep-03 I Oct-03 Nov-03 Dec Yr. Total i 0 1 1�01 I ..... ..... . . 0] "o 0 0 01 'Q O 1 01 1 0 1 2 0, '4 iy; ........... -K� 10"v'2"'K 0 0 0 0 0 0 0 0 0 0 0 0 5847 COPIER / FAX / TYPEWRITER EXPENSE N.—ipti- Capital Purchases (>$1,000) Equipment Purchases Equipment Rcntals Maintenance Contracts Repair Costs Toner and Paper Total Expense Comments, Tor Account should include Acosta --i.wd with N.M.— —w. I I Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 I Sep-03 I Oct-03 Nov-03 Dec Yr. Total i 0 1 1�01 I ..... ..... . . 0] "o 0 0 01 'Q O 1 01 1 0 1 Cost/PSF: Cost/BED: Prior Actual: Cost/BED: Cost/PSF: Increase/Prior 0 0 2,700 5 2 0.01 10125/2002 10:05 AM Expense Input Np 55 / 62 '4 iy; ........... -K� 10"v'2"'K 225 225 225 225 225 225 225 225 225 225 225 225 Cost/PSF: Cost/BED: Prior Actual: Cost/BED: Cost/PSF: Increase/Prior 0 0 2,700 5 2 0.01 10125/2002 10:05 AM Expense Input Np 55 / 62 Description: Includes expenses such as refreshments for employee staff meetings, special staff lunches (Corp, approval only), special recognition gifts, etc. Award ceremony expenses. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Employee Relations Costs 0 Award Ceremony Costs Total Line Item Cost 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 �� 1005/2002 10:05 AM Expense Input Pogo 56 / 62 10:05 r..___ - `10/25/2002 5887 EMPLOYEE TRAINING/EDUCATION Description: Expenses related to training and continuing education seminars and programs for on -site personnel, including outside speakers attd refreshment costs. Also includes preparation and production costs for policy and training manuals. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 Oct -03 Nov -03 Dec -03 I F-y-r . Tatal Manual Costs0 „ 2U,`20. -.a 2Q X20, , �;`20 20 20 ! " 240 Total Line Item Cost 20 20 20 20 20 20 20 20 20 20 20 20 240 Comments x ostBSF• 0 00 Cost/BED: s � Prior Actual: 167 Am Cost/BED: 0 Cost PSF: 0.00 Increase /Prior Y: 44 7960 EMPLOYEE RELATIONS Description: Includes expenses such as refreshments for employee staff meetings, special staff lunches (Corp, approval only), special recognition gifts, etc. Award ceremony expenses. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Employee Relations Costs 0 Award Ceremony Costs Total Line Item Cost 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 �� 1005/2002 10:05 AM Expense Input Pogo 56 / 62 Mo- 1025/2003 6910 LEGAL AND PROFESSIONAL system Description: Expenses related to cost of evicting residents for nonpayment of rent or nonperformance per lease agreement. certification, Apartment Association dues, and other associated fees as required by law. Also includes legal consultation on other property matters. Jan-03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 I Aug -03 Jwn -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jut -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Eviction Cost by Month Other Miscellaneous Costs , ; B 0' 0 Total Line Item Cost 0 0 0 0 0 0 0 0 0 0 0 0 Comments: 0 0 0 150 0 0 Cost/BED 0.00 0 300 C OS 0 { c, Cost/PSF: 0.00 Prior l: ctua 2,300 coED: 4 s ti fi0 st/P ,J F: Increase /PriorY: 100%.01 5852 Multifamily License Apt. Assoc. Dues Miscellaneous Fees Total Line Item Cost LICENSES, PERMITS, AND FEES Description: City license fees to operate community, pennits for bootleg signage mid pool operation. Fire/burglary system certification, Apartment Association dues, and other associated fees as required by law. Jan-03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total i7 U 0 d11 0' 0 0 t1 Y5D�,, Clx 0; 5- t50, A 300 0 0 0 150 0 0 0 0 150 0 0 0 300 ilfllYl 1 1 P4i45l btl�JTil � �t Cost/PSF: 0.00 Prior Actual: 361 Cost/BED: 1 Cost/PSF: 0.00 Increase /Prior Y: 17 10/252002 10:05 AM Expense Input Pngc 57 162 10/25/2002 10:05 AM Expense Input Np 58 /62 10:0. 10P5/2002 5845 FIRE ALARM/EXTINGUISHER INSPECTIONS Description: Fire system certification fees. Yr. Total Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 I Sep-03 Oct-03 Nov-03 Dec-03 Inspection Expense Total Cost 0 0 0 3 0 0 0 2,500 0 0 0 0 1 commeom wm 1 %P COSOSF: Cost/BED- 51 Prior Actual Cost/BED: M Cost/PSF: Increase/Pri cry 7210 EMPLOYEE TRAVEL AND MILEAGE REIMBURSEMENT Description: Expense related to reimbursement based upon mileage utilized by community personnel for business use of their Automobile and/or monthly care allowance provided, Parking charges included, Mileage Assumptions # of On-Site, Employees Avg. Mthly. Mileage Cost/Emp. Month to Begin Mileage Jan-03 I Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr, Total Employee Mileage Expense 1 151 15 15 15 15 15 15 15 151 is 1 15 1 15 Total Line Item Cost 15 15 15 151 15 1 15 1 is I is I is 1 15 1 15 151 Comments, U, Cost/PSF- Cost/BED: 0 ..... .. . Prior C'u Actual: Cos1/BED 194 0 4 CosVPSF: 0.00 �Ancrease/PrlorY: 7% 10/25/2002 10:05 AM Expense Input Np 58 /62 Jan -03 Feb -03 I Mar -03 I Apr -03 10:051025/2002 5860 APARTMENT ASSOCIATION FUNCTIONS Aug -03 Sep -03 Oct -03 Description: Includes fees for monthly apartment association meetings based on 80 °lo attendance, Expense for Omni Awards 5ec -03 Yr, Total Office Decoration Purchase participation in August. Includes sponsorship of an association meeting in February. 600 Comments = s Jan -03 Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Dec-03 Yr. Total Apt. Association Expenses , , a g , `; - } , &}, .{} -, . f * Q (j, , 0 , x - -Q, .r z„ , , - € ``, �..�:0 Total Line Item Cost 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 0 1 ('m not eats: t zs is z rl z' COSt/PSF; 0.00 0 1 0 1 C ost/BED: 0 Cost/BE0 1 Cost/PSF: 0.00 a -Prior Actual: f 0 Increase /Prior Y: 66 COSUBED. 0 Cost/PSF: 0.00 Increase /Prior Y: 0 5843 OFFICE DECORATIONS Description: Expenses incurred for the decoration of the offices (accessories, prints, Christmas decor, etc.) Jan -03 Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 5ec -03 Yr, Total Office Decoration Purchase 50 600 Comments = s CosdPSP 0 00 Total Line Item Cost 0 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 361 5842 OFFICE SUPPLIES Description: Includes expenses for all office supplies purchased, including pens, pencils, etc. Jan -03 Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Dec -03 Yr, Total Office Supply Purchases - 50 ,,;501.., x:50. : ;" 50 Total Line Item Cost 50 50 50 50 501 50 50 1 50 1 50 1 50 1 501 50 600 Comments = s CosdPSP 0 00 Cost/BED: 1 Prior Actual: 361 Cost/BE0 Cost/PSF: 0.00 Increase /Prior Y: 66 1025/2002 10:03 AM Expense Input pnge 59 162 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total JPI Forms Printing 100 t tl 400 0 q "00 0 X00 $ iY 0 p 0 400 Parking Stickers 0 p= 0 0' ti 400 0 0 0 0 $'' 400 Other Printing /Stationary 0. 0 Total Line Item Cost 100 01 100 1 0 100 1 0 1 500 1 0 1 0 1 0 1 0 1 0 800 10!25/2002 10:Oi AM Expense Input r.xe 60 /62 10:05, 10125na12 5805 POSTAGE / COURIER / FREIGHT Description: Expense for stamps to mail letters, etc, to residents, prospective residents, and vendors, etc. Also includes courier and overnight mail charges. Poatau Asmn p Lion Courier Assumptions Average Postage Per Package 4S 37I Average Courier Cost per Trip Average Postage Usage / Month Average Courier Trip /Month "' Month to Begin Postage Costs Month to Begin Comfier Costs': Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Postage Costs 204 204 204 204 204 204 204 204 204 204 204 2,442 204 Courier Costs 22 22 22 22 22 22 22 22 22 22 22 22 264 Other Misc. Costs Total Line Item Cost 2,706 226 226 226 226 226 226 226 226 226 226 226 226 comments$ttiltt 1$ti$C$ iO t°$t1.An(dt$ tl"i tJSL4'9fbt' &a�$PS$r1i?cetJ$$C8 r Cost/PSF: 0.02 Cost/BED: 5 rr d Prior Actual: 2,615 tt 1 Cost/BED: 5 r, �Cost/PSF: 0.01 Increase /Prior Y: 4 5846 PRINTING AND STATIONARY Description: Expenses relating to office supply printing and community stationary, i. e., letterhead, envelopes, business cads, Shining Star Cards, Welcome Cards, move -in packets, door handing bags, service requests, Thank You cards, etc., and forms obtained from the TAA, AAGD, etc. Does not include brochures. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total JPI Forms Printing 100 t tl 400 0 q "00 0 X00 $ iY 0 p 0 400 Parking Stickers 0 p= 0 0' ti 400 0 0 0 0 $'' 400 Other Printing /Stationary 0. 0 Total Line Item Cost 100 01 100 1 0 100 1 0 1 500 1 0 1 0 1 0 1 0 1 0 800 10!25/2002 10:Oi AM Expense Input r.xe 60 /62 10:0: 10/25/2002 5865 SECURITY / ALARM RESPONSE Description: Expenses incurred for security response to office alarm. Does not include expenses associated with alarm monitoring contract(see Contract Services category.) Alarm Response _ Assumptions Avg. # of Alarm Responses / Me Avg. Cost of Alarm Response Month to Begin Alarm Response a -;3, Jan -03 I Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 I Nov -03 I Dec -03 777-717 Alarm Response Costs 1 0 1 0 0 0 0 0 0 0 0 0 1 0 1 0 Total Line Item Cost 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 01 0 1 5841 STORAGE / OFFICE FURNISHINGS RENTAL 10125/2002 10.05 AM Expense Input Pngc 61 /(2 5656 TELEPHONE Description: 5656 5657 5665 (See Account N's above) Telephone - aasc Miscellaneous Expenses Telephone - Long Distance Answering Service Costs Pager Costs Pager Insurance Costs Total Cost Expenses incurred for business phones. Includes answering service, pagers, pager insurance, maintenance and long distance charges. Does not include expense for Temporary Executive Apartments, Monthly Phone Service Cost 333 { 7640-00000 Answering Service Cost / Month Monthly Long Distance Cost . ; r ;,`3411.;` Month to Begin Answering Srv. Aug -03 Month to Begin Phone Service Oct -03 Nov -03 Dec-03 Pager Cost Assumptions Number of Pagers 335 Pager Insurance Assumptions 7640.00000 Pager Insurance Cost / Yr. Avg. Pager Cost /Month 335 Month to Incur Cost 777717 I Month to Begin Pager Cost 335 335 335 Ian -03 Feb -03 Mar -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec-03 335 335 335 335 335 335 335 335 335 335 300 300 300 "00 300 300 300 300 300 300 300 100 100 100 100 100 100 100 t00 100 100 39 39 39 39 39 39 39 39 39 39 0 0 0 0 0 0 0 0 0 0 10:05 10/25 /2002 Yr. Total 4,020 0 3,600 1,200 468 0 774 1 774J 774 1 774 1 774 1 774 1 774 1 774 1 774 1 774 1 774 1 774 1 F 9788 10/25 /2002 10:05 AM Expcnve input Pngo 62 / 62 10:05 ,1012512002 Prior Actual: 0 Cost/BED: 0 Cost/PSF: 0.00 Increase/Prior Y: 5839 EMPLOYEE EVALUATIONS Dawrlptlon: Expense to contract with outside marketing finn/shopping service to conduct and prepare shopping reports on employee leasing skills. Avg. Cost Shopping Rpt.. / Emp. $ Jan -03 I Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total #of Rpts.. per Month 11;1 , x =- 0 Total Line Item Cost 0 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 10125/2002 10:05 AM Expense Input 2 page I / 23 5890 OTHER ADMINISTRATIVE EXPENSE Description' Any other administrative expense not specifically included in another account 10:0 - 10/25/2W2 Jan -03 Feb -03 I Mar -03 I Apr -03 May -03 Jun -03 Jul -03 I Aug -03 I Sep -03 I Oct -03 Nov -03 Dec -03 Yr. Total Expense by Month 0 Total Monthly Cost 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 J 6830 INTERIOR REPAIRS Cost Per Bed Turned 1k.9q': < - - - -- -Uses (Move -Outs) number from Income Input Schedule Jan -03 I Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 I Dec -03 Yr. Total Interior Repairs (Calculated) Interior Repairs (Hard Code) Total Interior Repairs Total Interior Repairs Reallocation 0 01 0 0 130 0 0 3,160 0 0 0 0 Expense /PSF: 0.018 , , 0 0 0 0 130 0 0 3,160 0 0 0 0 0 0 0 0 65 65 0 1,580 1,580 0 0 0 3,290 0 3,290 3,290 (ENTER AS A POSITIVE) Expense /PSF: 0.018 Expense /BED: 5.95 6635 INTERIOR REPAIRS - REIMBURSEMENT / Billed Jan -03 Feb -03 Mar -03 Apr -03 Yr. Total I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 I Dec -03 Interior Repairs - Reimbursement 0 0 0 0 [= (1,645) (33) (33)1 0 1 (790) (790)1 0 1 0 1 7771 Income /PSF: F777TZFOq Income /BED: Total Interior Reimbursements (NET) Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec -03 Yr. Totai 0 0 0 0 1,645 33 331 01 790 1 790 1 01 01 0 Comments: Expense /PSF: 0.009 r Expense /BED: EE 2.97 z . .. ... ..:.. ..... ..... ., . ,,,. Actual: (2094) ie/BED: 1 (3.79) Y: 10/25/2002 10:05 AM Exp.,,. Input 2 Np 2 / 23 10:05 10/25Y2002 6390 CARPET CLEANING Avg. Cost/Bed $ °)s,ba:, <• -• -- -Uses (Move -Outs) number from Income Input Schedule Carpet Cleaning (Calculated) Carpet Cleaning (Hard Code) Total Carpet Cleaning Total Carpet Cleaning Reallocation (ENTER AS A POSITIVE) Jan -03 I Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I N0v -03 I Dec -03 1 Yr. Total 0 0 0 0 325 0 7,900 0 0 0 0 Yr. Total I May -03 I Jun -03 I Jul -03 I Aug -03 I 0 0 0 0 325 1163 0 7,900 0 0 0 0 0 0 0 0 163 (2,370) 0 3,950 3,950 0 0 0 8,225 0 8,225 8,225 Expense /PSF: 0.046 Expense /BED: 14.87 6395 CARPET CLEANING - REIMBURSEMENT `r Billed Jan -03 Feb -03 I Mar -03 I Apr -03 Yr. Total I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep-03 I Oct-03 I Nov -03 Dec -03 Carpet Cleaning- Reimbursement 0 01 01 0 (4,935) (98) (98)1 0 1 (2,370) (2,370)1 0 1 0 1 0 Income /PSF: Income /BED: 1 (8.92) Total Carpet Cleaning (NET) Jan -03 I Feb -03 Mar -03 Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec -03 Yr. Total 0 0 01 0 1 651 651 01 1,5801 1,5801 01 01 777fl 3,290 Comments: „Expense /PSF: 0.018 Rix Expense/BED: 5.95 Prior Actual: 19,338 Income /BED: 34.97 Income /PSF: 1 0108 10/25/2002 10:05 AM E.1—w 1.pw 2 Fogc 3 / 23 10051 IMS/2002 6405 GENERAL CLEANING Avg. Cost Bed < - - - -- -Uses (Move-Out) number from Income Input Schedule General Cleaning (Calculated) General Cleaning (Hard Code) Total General Cleaning Total General Cleaning Reallocation (ENTER AS A POSITIVE) I Jan-03 I Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov-03 I Dec -03 Yr, Total -0 01 0 1 0 520 1 0 1 0 1 12,64-0 T— o 0 0 0 ;7 Expense/PSF: F 0.026 017 '777,77", Expense/BED: 0 01 0 1 01 520 1 0 1 0 12,640 1 0 0 0 0- 0. 01 0 1 0 1 260 1 260 1 0 1 6,320 1 6,320 0 0 0 6410 GENERAL CLEANING - REIMBURSEMENT % Billed 13,160 0 1$,160 13,160 Expense/PSF: F0 _074� Expense/BED: ]an-03 Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov-03 I 77703 Yr. Total General Cleaning-Reimbursement 0 01 01 01 (169)1 (169)1 0 1 (4,108)1 (4,108)1 0 1 0 1 0 1 Inconne/PSF: F(0_0_48_) Income/BED: 1 (15.47) Total General Cleaning (NET) Jan-03 Feb-03 Mar-03 Apr -03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 I Nov-03 I Dm-03 I Yr. Total 0 0 0 0 91 91 0 2,212 2,212 01 01 0 1 ;7 Expense/PSF: F 0.026 Expense/BED: 10/25/2002 10:05 AM &r ,­ 1.pw 2 Np 4 / 23 10:05 ' I025 12002 6415 INTERIOR PAINT Avg. Cost Bed g;t>' eo:oo,' < ...... Uses (Move -Out) number from Income Input Schedule Interior Paint (Calculated) Interior Paint (Hard Code) Total Interior Paint Total Interior Paint Reallocation (ENTER AS A POSITIVE) Jan -03 I Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 I Dec -03 Yr. Total 0 0 0 01 1,040 0 0 25,280 0 0 0 0 Yr. Total Jan-03 Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Interior Paint - Reimbursement 0 01 0 1 0 0 0 0 0 1,040 0 0 7280 0 0 0 0 0 01, 0 0 520 520 0 12,640 12,640 0 0 0 26,320 0 26,320 26,320 Expense /PSF: 0.147 Expense /BED: 47.59 6410 INTERIOR PAINT - REIMBURSEMENT % Billed; A4.00° /a Yr. Total Jan-03 Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Interior Paint - Reimbursement 0 01 0 1 0 (10,528) (208) (208) 0 (5,056) (5,056) 0 0 0 Income /PSF: Income /BED: (19.04) Tonal Interior Paint (NET) Jan -03 Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total 0 01 01 01 312 1 312 1 0 1 7,584 1 7,584 1 0 1 01 0 1 15,792 Comments: M Expense /PSF; 0.088 c t1 Expense /BED: 1 28.56 Prior Actual: 2025 Income /BED: 3.66 Income /PSF: 0.011 Increase /Prior Y: -680 6425 APPLIANCE REPAIR Description, Tumover expense related to appliance repairs (not replacements). Jan -03 I Feb -03 I Mar -03 I Apr -03 May03 Jun -03 1 Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec -03 Yr. Total Appliance Repair Appliance Repair Reallocation Comments; 1025/2002 10;05 AM EXI—se Input 2 Pugo 5 / 23 10:05 10(25t-1002 6430 LOCK/KEYS Description; Turnover expense related to re- keying and locks. Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun -03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 F—YTT-t-11-1 Lock/Keys Lock/Keys Reallocation 0 0 0 1,250 1,250 0 0 500 0 0 0 0 3,000 conunents, '-,:Y�,),`Cost/PSF: Ul ,:Cost/BED: 5 Prior Actual: '311 Cost/BED: 4 CosUPSF: .01 Increase/Prior Y:F/0 -302 6435 INTERIOR LIGHTBULBS Do'criptiom Turnover expense related to replacement of interior liglitbulbs. I Jon-03 I Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-01 I Sep-03 I Oct-03 I Nov-03 I Dec-03 Yr. Total Interior Liglitbulbs interior Liglitbulbs Reallocation Comments 6440 WINDOW COVERINGIREPAIR Description: Turnover expense related to repair of window covering (not replacement). I Jan-03 I Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov-03 I Dec -03 Yr. Total Wiridow Covering/Repair Window Covering/Rep. R colnuents; 10P5/2002 10:05 AM Expenn Input 2 Np 6 / 23 10:0- 10/25/2002 6445 TENANT REIMBURSEMENT Jan-03 Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov-03 Dec -03 Yr. Total Total Tenant Reimbursement f ---------- 07 , Total Tenant Raimb Reallocation 0 01 01 01 01 0 1 0 1 0 1 0 1 01 01 01 L= (ENTER AS A NEGATIVE) Expense/PSF: Expense/BED: F0_00 11 6450 WRITE-OFFS TENANT REIMBURSEMENT % Millen Off Jan-03 Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov-03 Dec -03 Yr. Total Write-Offs Tenant Reimbursement 0 01 0 1 01 3801 3801 0 1 19,247 9,243 1 9,2431 0 1 0 1 0 Income/PSF: F 0-1-08-1 Income /BED: 34,80 Total Tenant Reimbursement (NET) Jan-03 Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 Sep-03 I Oct-03 I Nov-03 Dec-03 i . �Total 1 01 01 01 1,250 1 2,131 1 881 1 0 1 22,559 22,0591 0 1 0 1 0 1 Comments, Expense/PSF: 0 273 Expense/BED: 88.391 ..... . ... Prior Act ual: (709) Income/BED: (1-28) Income/PSF: (0-004) .Increase/Prio r Y: MANAGEMENT FEES 7420 PROPERTY MANAGEMENT FEES (PLEASE REFER TO MANAGEMENT AGREEMENT TO SEE IF THERE IS A MINIMUM FEE UNTIL OCCUPANCY AND/OR RENT LEVELS ARE ACHIEVED-ASSET MANAGER SHOULD VERIFY) Dewril2tiow Fee incurred by property for management services per Property Management Agreement. Management Fee Assumptions Mgmt.. Fee as a % of Income Mouth Stabilized (enter 13 if not stabilized during budget year) Minimum Moritbly Mgint. Fee Ttt�t Jan-03 Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 Jul-03 Aug-03 I Sep-03 I Oct-03 Nov-03 Dec -03 Yr. Total Total Monthly Cost I0!35/2002 10:05 AM E.p.,. 1.pw 2 Pap 7 / 23 10:6, 10/25/21002 9904-00002 ASSET MANAGEMENT FEES Descriptiom Fee incurred by property for asset management services per Asset Management Agreement. Asset Management Fee Assumptions Flat Monthly Fee Month to start Flat Fee Jm,-03 I Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov -03 Dec -03 F—Y-1 T-71 INSURANCE 7510 PROPERTY INSURANCE Description Expenses incurred to insure the apartment corrurrunity and all property owned by the conuirunity, Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total Property Insurance Cost Total Monthly Cost 5,278 5,278 5,278 5,278 5,278 5,278 6,521 6,521 6,597 6,597 6,597 6,597 71,098 Cash Payments 7805.000!0 ;0 "OT ' 79�163`1 0-1 0 0 79,163 CojTjjTjCjjtS7 .'Cost1PSR 0.40 Cost/BED: 129 Prior Actual: 0 F C ost/ PSF: Increase /Prior Y: 10/2512002 10:05 AM Espe— J.P.t 2 Np 8 / 23 10:05 0/25x002 10!25/2002 10:05 AM E.N- Liput 2 Ng.9 / 23 10:05. :''1025/2002 EXTERIOR REPLACEMENTS 9510 EXTERIOR PAINT Description Cost to repaint the exterior of the buildings, fences, carports, gates, etc. Jan -03 I Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 Dec•03 7 Total Amount paid Total Monthly Cost 1 0 1 0 1 01 0 1 0 1 01 0 1 0 1 0 1 0 1 0 1 0 �, 10/25/2002 10:05 AM Expcnso lapin 2 N 8 o 10 / 23 10:0 I Ot25/2002 9515 HVAC Description: Replacement of HVAC equipment and parts. PAVING Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 I Jul-03 I Aug-03 Sep -03 I Oct -03 Nov-03 F—Y-17-477 Amount paid :'Ii'11`111"' Total Monthly Cost 0 0 0 350 0 350 1 01 350 1 0 1 0 1 0 1 01 Conimenm .. . Cost/PSF: 31' Descrij2dan• Expense for annual paving assessment and repairs for street repair/expansion or ...... ""z Prior Actual: Cost/BED• Jan-03 Feb-03 I Mar-03 Apr-03 I May-03 I Jun-03 Cost/PSF: 0.00 Increase/Prior Y: 100 9520 LANDSCAPE IMPROVEMENTS Yr. Totat DesQription• Includes expense incurred to enhance the aesthetic value of the community. Includes the expense of the plants Sep-03 and the labor cost for installation. Nov-03 Jan-03 Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 Jul-03 I Aug-03 I Sep-03 Oct-03 Nov-03 Dec -03 0 37 Amount paid Amount paid Total Monthly Cost 0 01 01 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 9525 PAVING Descrij2dan• Expense for annual paving assessment and repairs for street repair/expansion or parking lot repairs, Jan-03 Feb-03 I Mar-03 Apr-03 I May-03 I Jun-03 Yr. Totat Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Amount paid Total Monthly Cost 450 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 --70 Colurneum no . .... ... . . ... . ... . . . -W- Co.st/PSF: ...... . . ... . ..... . , . .. . . .. . . . ..... .. . .... .... ..... . Co t/BED ... . ... . .. . . . ...... ... .. ... . . . ..... .... . ... ...... ost/bFD: 0 0 .... ... Cost/PSF: 0.00 Increase/Prior' -100% 10125/2002 10:05 AM E.p-,. T.j t 2 Np I t / 23 10:05 10/25/2002 9530 SIGNAGE Description; Capital costs of signage for die property. May include monument sign, leasing signs, etc, Jan-03 Feb-03 I Mar-03 Apr-03 May-03 I Jun-03 Jul-03 I Aug-03 Sep-03 I Oct-03 I Nov-03 I Dec -03 F—Y—r TtTal Amount paid 0""J Total Monthly Cost 0 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 ---- ci] Comments: y t ............... C ost/ps F: O.GO a .............. Prior Actual: 0 Cost/BED: 0 0.00 . . ... ... ... . --:,,`," Inc reas9/Pr1orY: 0% 9535 STRUCTURAL/BUILDING REPAIR Descriptiow A major repair to a specific building due to foundation, structural, or exterior/interior building repair. Yr. Totat Jan-03 I Feb-03 Mar-03 Apr-03 I May-03 I Jun-03 Jul-03 Aug-03 Sep -03 Oct-03 Nov-03 Dec-03 Amount paid Total MontWy Cost 0 o 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 770 Comnnents• Cost/PSF: 0.00 Cost/BED: 01 Prior Actual: 0 Cost/BED: 0 un Cost/PSF: 0.00 Increase/Prior Y: 0% 9540 GUTTER AND DOWNSPOUTS Description Major repairs to gutters and downspouts, Jan-03 Feb -03 I Mar-03 I Apr-03 May-03 Jun-03 Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov -03 Dec-03 Yr. Total Amount paid 7- 7 'F7 F O� 0], L Total Montlily Cost 0 0 0 0 0 0 0 0 0 0 01 0 1 10/15/2002 10:05 AM &p-w bp., 2 P,,g,, 12 r_3 10:05 10125f1002 9545 SLABIMASONRY 9550 Description• Major repairs to foundation or walls, Description, Expense incurred for the purchase of new cabinets for replacement in the apartment home. J.-03 I Feb -03 I Mar-03 I Apr-03 May-03 I Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 F-777oi,77 Amount paid Amount paid Total Monthly Cost 1 0 0 0 0 1 0 0 0 0 1 0 0 0 1 0 Comments: Comments - C o s C ��Cost/BED- 1 01 ost/BED: Prior Actual: 0 Prior Actual: Cost/BED: Cost/BED: 0 Cost/PSF: 0.00 .Cost l-SR 0010 0% Increase/Prior Y: INTERIOR REPLACEMENTS 9550 CABINETS Description, Expense incurred for the purchase of new cabinets for replacement in the apartment home. Jan -03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 c-03 Yr, Total Amount paid Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 Comments: Cost/PSF- 000 ��Cost/BED- 1 01 Prior Actual: Cost/BED: 0 0 Cost/PSF: 0.00 '111 Increase/Prior Y: 0% 10/25/2002 10:05 AM Esp...,o 1.pw 2 P.p 13 /23 9555 CARPETS of Carpets Replaced based on Total Move Outs " t> i O;Dp'1 Description• Expense incurred for the purchase of new carpet for Average Cost Per BED replacement in the a artmenthome, % of Total BEDS 5.97% Jan -03 Feb -03 Mar-03 I Apr -03 I May -03 Jun -03 Jul -03 Aug -03- Sep -03 Oct -03 Nov -03 Dec -03 Yr. Total Number of Carpets Replaced 0 0 0 0 1 0 0 32 0 0 0 1 0 33 Carpet Replacement 0 0 0 0 300 0 0 9,600 0 0 0 0 9,900 Other Carpet p, 9. Or,: t -,. Q•..�,. -; ,0 Q fl fJ. - II -"; 0 Total Monthly Cost 0 0 1 0 1 01 300 1 0 1 0 1 9,600 1 0 1 0 1 0 1 0 C 9,900 Connneuts• , _ r r CosUPSF: 0.06 •' a d- r 7 t u. r CostBED: is P rior Actua I• 3r 5 4 J 7 1 l Y i 4 1 ' Cost/BED 24 s ' CosVPSF: 0.08 Increase /Prior Y: 27 9565 CERAMIC TILE /HEARTHS Description Expense incurred for the purchase of new ceramic tile/hearths for replacement in the apartment home. Jan -03 I Feb -03 I Mar -03 Apr -03 May -03 I Jun -03 Jul -03 I Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Tota Amount paid 0]': YJ.; —1 -�Y—r- Total Monthly Cost 0 1 0 1 0 0 1 0 1 0 1 0 1 0 0 0 1 0 1 0 Comments: ,- i 1 ;, Cost/PSF: ZIOR 0.00 Cost/BED: J r 0 t p j ' ; Prior Actual: 0 t s ' Cost/BED: ' z r 0 �Cost/PSF: 0.00 Increase /Prior Y: 0 9570 COUNTERTOPS Description: Expense incurred for the purchase of new countertops for replacement to the apartment home, Jan -03 Feb -03 Mar -03 Apr -03 I May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov-03 777-3-1 Yr. Total Amount paid Q CL fY pa �i.` 0 AiiO- 0, 0•. IJ,,,.:;:Ox 400 Total Monthly Cost 0 0 0 0 0 - 0 0 400 1 0 0 0 0 400 Comments: 2. r,yvacirur2r,.�a 3 > - ,Cost/PSF: f 0.00 �+' osdBBD 1 t Prior Actual: t- Cost/BED: 0 0 Cost /PS 0.00 : Increase/Prior rior Y: 100 °a 10:0:. '�10/25Y2W2 10/25/2002 10:05 AM Expense Input 2 Page 14 123 1010, 10125/2002 9575 DOORS Description' Expense incurred for the purchase of new doors/cabinet hardware for replacement in the apartment home. Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun -03 Jul-03 Aug-03 Sep-03 Oct -03 Nov-03 7�T] F-777.—t77 Amount paid Total Monthly Cost 1,000 0 0 0 0 0 0 0 1,000 0 0 0 0 Coniments• . ..... Cost/PSF: . . ... ..... ..... 'V� Cogt/BED: 2 Prior Actual 414 Cost/BED; 1 Cost/PSF: 000 Increase/Prior Y:[-141 9580 LIGHT FIXTURES Description, Expense incurred for the purchase of new light fixtures for replacement in the apartirrient home, Jan -03 I Feb-03 I Mar-03 Apr-03 I May-03 Jun-03 I Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec -03 Yr. Total Amount paid A Total Monthly Cost 0 1 0 0 01 0 1 0 1 0 1 500 1 01 0 1 0 1 F --70 ColvJiletim Cost/PSF: O'� Cost/BED: Prior Actual: Cost/BED: Cost/PSF: 0.00 Increase/Prio 9585 MAT REPLACEMENT Description, Expense incurred for the purchase of new mats for replacement in the apartment home, Jan-03 I Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr. Total Amount paid iw%11 1111111177"Q—] ,, '0",j- � : 0-" " ' " ",0 , , ,,, , v'C" Total Monthly Cost 0 1 0 1 01 0 1 0 1 0 1 0 1 0 1 01 0 1 0 1 0 1 Comments ' Cost/pSF: 00 Cost/BED: 0 Prior Actual Cost/BED: 0 0 [:0:% yk Cost/PSF: 0.00 Increase/Prior Y /. V-15/2002 10:05 AM Expanse Input 2 Page 15 / 23 10:05 10/215/2W2 9590 BLINDS Description: Expense incurred for the purchase of new miniblinds for replacement in the apartment home. Jan-03 I Feb-03 I Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 I Sep-03 I Oct-03 I Nov-03 F-71-7771-1 Amount paid r4, 7 , 7711 Total MoinNy Cost 0 01 o 1 01 0 1 0 1 0 1 500 1 0 1 0 1 0 1 0 9595 MODEL COST Description Expense for additional or complete replacement of FF&E for model homes or information Center. Jan-03 Feb-03 I Mar-03 Apr-03 May-03 I Jun-03 Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov -03 Dec -03 Y —r. Total Amount paid 0, 0 F-,77, . . . . ... . Total Monthly Cost 0 0 0 0 0 0 0 0 0 01 0 1 0 9600 PLUMBING Description Expense incurred for the purchase of new plumbing for replacement in the apartment borne. Jan-03 I Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 Sep-03 I Oct-03 I Nov-03 Dec -03 Yr. Totat Amount paid F77" Total Monthly Cost 0 0 0 0 0 0 0 0 1 01 0 1 0 1 --70 10/15/2002 10:05 AM E.p—. Input 2 P.p 16 / 23 10:0 10125/2002 9605 RECREATIONAL FACILITIES Description Expenses related to the replacement or major repair to include racquetbal,.sauna, steam room, and fitness equipment. Desgription, Installation and/or replacement of electronic parts, fixtures, or wiring of the electronic alann system or controlled Jan-03 I Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 Jul-03 I Aug-03 Sep-03 Oct-03 I Nov-03 F 7-777 --1 '7,7 7�7' - Amount paid """777777,, ,07 -, 0 - 7,— __7 "; � 01 01 01 Total Monthly Cost o 0 1 0 0 Yr. Totat Jan-03 I Feb-03 I Mar-03 Apr-03 May-03 Jun-03 Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 0 0 0 0 0 0 0 0 9610 SECURITY SYSTEM Oct-03 Nov-03 Dec-03 Desgription, Installation and/or replacement of electronic parts, fixtures, or wiring of the electronic alann system or controlled access system. To include cameras and/or motors, 1 01 01 01 01 01 01 01 01 01 01 01 01 Yr. Totat Jan-03 I Feb-03 I Mar-03 Apr-03 May-03 Jun-03 Jul-03 I Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Amount paid 4", Total Monthly Cost 0 1 0 1 0 0 1 0 01 0 1 0 1 0 1 0 1 0 1 0 Comments, Cos t/P SR 0'00 C,st/BE D: 0 6 Prior Actual: 0 'd- Cost/BED: 0 Cost/PSF: 0.00 Increase/Prior Y: 0% 9615 SUB-FLOOR DQro Expense to replace subflooring in apartment home. Includes labor and materials. Does not include purchase of flooring materials. Amount paid Total Monthly Cost Jan-03 I Feb-03 Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 Aug-03 I Sep-03 Oct-03 Nov-03 Dec-03 1 01 01 01 01 01 01 01 01 01 01 01 01 v C.,WPSF: 0.00 j�t Cost/BED: 0 10/25/2002 10:05 AM E.N­ Input 2 Fnp 17 / 23 10051 10125/2002 9620 VINYL Description, Expense incurred for the purchase of new vinyl for replacement in the aparunent home, 9625 WALLPAPER AND WALLCOVERINGS Descriptio• Expense incurred for the purchase of new wallpaper, wall prep(sheetrock) - labor and materials - for replacement in the apartment home. Jan-03 Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 Jul-03 I Aug-03 Sep-03 Oct-03 I Nov-03 I 7—e-7703 Yr. Total Amount paid '0 Total Monthly Cost 0 1 0 1 0 1 0 0 0 0 0 1 0 0 0 9630 CEILING FANS Description; Expense incurred for replacement of ceiling fans in a BED Jan-03 I Feb-03 I Mar-03 I Apr-03 May-03 I Jun-03 Jul -03 Aug-03 Sep-03 Oct-03 Nov-03 I Dec -03 Yr. Total Arriountpaid o"j-, Total Monthly Cost 0 0 0 01 0 1 0 1 0 1 500 1 0 1 0 1 0 1 0 500 10P5/2002 10:05 AM E. N..,. In at 2 Ng, 18 / 23 Jan-03 Feb-03 Mar-03 Apr-03 May-03 I Jun-03 I Jul-03 I Aug-03 Sep-03 Oct-03 I Nov-03 :EcE-01 Yr. Total Amount paid ""O"'j 0'] Total Monthly Cost 0 0 0 0 1 01 0 1 0 1 IGO 1 0 1 0 1 0 1 --70 9625 WALLPAPER AND WALLCOVERINGS Descriptio• Expense incurred for the purchase of new wallpaper, wall prep(sheetrock) - labor and materials - for replacement in the apartment home. Jan-03 Feb-03 I Mar-03 I Apr-03 May-03 Jun-03 Jul-03 I Aug-03 Sep-03 Oct-03 I Nov-03 I 7—e-7703 Yr. Total Amount paid '0 Total Monthly Cost 0 1 0 1 0 1 0 0 0 0 0 1 0 0 0 9630 CEILING FANS Description; Expense incurred for replacement of ceiling fans in a BED Jan-03 I Feb-03 I Mar-03 I Apr-03 May-03 I Jun-03 Jul -03 Aug-03 Sep-03 Oct-03 Nov-03 I Dec -03 Yr. Total Arriountpaid o"j-, Total Monthly Cost 0 0 0 01 0 1 0 1 0 1 500 1 0 1 0 1 0 1 0 500 10P5/2002 10:05 AM E. N..,. In at 2 Ng, 18 / 23 10:05 025/2002 9635 APPLIANCES Descrjption� Expense incurred for the purchase of new ranges/ovens/microwaves, disposals, trash compactors, dishwashers, and refrigerators for replacement in the apartment homes, Jan-03 I Feb-03 I Mar-03 I Apr-03 I May-03 I Jun-03 I Jul-03 I Aug-03 I Sep-03 I Oct-03 I Nov-03 Yr. Total Range/Ovens/Microwaves Disposals Trash Compactors Dishwashers Refrigerators 4-44", "1"44"', �v . . . . . ..... . . . . . . . "X 01 01 0; i�� 7777— , "', Vnnf), T777 j '77 ' " —, I � I C o gt/PSF: 592 0 0 0 Cost/BED: Total Monthly Cost 0 0 01 01 01 01 01 1,592 1 01 01 01 01 Comments; C o gt/PSF: Cost/BED: 3 Prior Actual: 1,853 ] Cost/BED Cost/PSF: 0.0 Increase/Prior Y: 9645 TRANSPORTATION Expense incurred for the purchase of new golfcart/trash cart for replacement 10125/2002 10:05 AM Expense Input 2 Ng. 19 / 23 DEBT SERVICE 2350 PRINCIPAL PAYMENT Expense for principal payment for community mortgage Jan-03 I Feb-03 Mar-03 Apr-03 May-03 Am-03 Jul-03 Aug-03 lao: 10/1512w� 9650 OTHER REPLACEMENTS Principal Paid Ist/ Mo. Description Expense incurred for other replacements in the apartment home not specifically included in another account. 7-87782 Jan-03 I Feb-03 Mar-03 Apr-03 I May-03 Jon-03 I Jul-03 Aug-03 I Sep-03 Oct-03 Nov-03 Yr. Total Annountpaid F-107-00-1 Total Monthly Cost 1 2,800 1 0 1 0 1 0 1 0 1 0 1 7,500 1 0 1 0 1 0 1 0 1 0 10,300 DEBT SERVICE 2350 PRINCIPAL PAYMENT Expense for principal payment for community mortgage 10/2512(K)2 10:05 AM E.p.m Input 2 Np 20 / 23 Jan-03 I Feb-03 Mar-03 Apr-03 May-03 Am-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Yr, Total Principal Paid Ist/ Mo. 7-87782 Principal Paid 2nd Lein/ Mo. J Total Monthly Cost 6,290 1 6,333 6,376 6,420 6,464 6,508 6,552 6,597 6,642 6,688 6,733 779 Comments, W- 0.44 0 COSUBED; 142 10/2512(K)2 10:05 AM E.p.m Input 2 Np 20 / 23 10:05 :10/25/1002 9425 INTEREST PAYMENTS - CONSTRUCTION Description; Expense for interest on cotmnunity mortgage. Projects under construction - pull this number from Depreciation Schedule, Jan -03 I Feb -03 I Mar -03 I Apr -03 I May -03 I Jun -03 I Jul -03 I Aug -03 I Sep -03 I Oct -03 I Nov -03 I Dec -03 Yr. Total Interest Payments / Mo. Capitalized Interest Payments Total Interest Payment Expensed/ Mo 135,072 135,029 134,986 134,942 134,899 134,854 134,810 134,765 1.34,720 134,675 134,629 134,583 1,617,964 0 0 0 0 0 0 0 0 0 0 0 0 1 0 135,072 135,029 134,986 134,942 134,899 134,854 134,810 134,765 134,720 134,675 134,629 134,583 1,617,964 9410 INTEREST PAYMENTS - PERMANENT Expense for interest on community mortgage. Description Expense for interest on community mortgage. Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Interest Payments /Mo. .:,Q„ { jry- ., -% :,d: ,. ,p', ,,Q „A- -.0.. ,s0 p:• ° •'',I%% Y—r. Total Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 0 �(�''� -�1 Comments, , Cost/PSF: 0.00 '? < CosVBED: 0 Prior I 0 r �CosAotua . t/ 0 0.00 ost/P SF Increase/Prior Y: 0 9426 INTEREST PAYMENTS - CONSTRUCTION SECOND LEIN Description• Expense for interest on community mortgage. Y—r. Total Tai -03 I Feb -03 I Mar -03 I Apr -03 I May -03 I Jua -03 Jul -03 Aug -03 Sep -03 Oct -03 Nov -03 Dec -03 Interest Payments / Mo. Capitalized Interest Payments 2nd lein 0 01 0 1 0 1 0 1 0 0 0 0 0 0 Total Monthly Cost 0 01 0 1 0 1 01 0 1 0 1 0 1 0 1 0 1 0 1 0 h_1 m me Conts, _ > CostIPSP: 0.00 ,H.,1, x.. -. ,,,. ur ,. ...,.,... -�,.,. ' - �,Cost/BED: 0 10/2512002 10:05 AM Expense Input 2 Pngc 21 / 23 9415 INTEREST PAYMENTS - PERMANENT SECOND LEIN D,scription• Expense for interest on corturrunity mortgage, Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec -03 Yr. Total Interest Payments / Mo. Total Monthly Cost 0 0 0 0 0 0 0 0 0 0 0 9906 PARTNERSHIP EXPENSE - OTHER Des criptiota Expense for audits, legal and other misc, ownership bills. Jan-03 Feb-03 Mar-03 Apr-03 May-03 I Jun-03 Jul -03 Aug-03 Y Sep-03 I Oct-03 I Nov-03 Dec -03 ""o""" , Partnership Expense Mo, 0 —r,—To —tales T, Total Monthly Cost 0 0 0 1 01 0 1 0 1 0 1 0 F 1 0 1 0 1 0 1 51 Commellm Cost/PSF: 'y Cost/BED 0 --- —] , 1p Prior Actual: 59,772 Cost/BED: 108 Cost/PSF: 0.33 Increase/Prior Y: RESERVES RESERVES (PLEASE ENTER AS NEGATIVE) Descril2tio• Amount to be funded by tender and/or partner. Jan-03 Feb-03 Mar-03 I Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec -03 I Yr. Total Net Reserves Paid /Month F7',,,","'6;4 ,0, f & '140 , 00,J,,'- A 0�11 I LL, Total Monthly Cost 5,406 5,406 5,406 1 5,406 5,406 5,406 5,406 5,406 5,406 5,406 5,406 5,406 R05 0012002 10/25/2002 10:05 AM Exp-.,c Input 2 Np 22 123 10:05. 10/25/2002 OTHER EXPENSE 7814 OTHER EXPENSE Deception; Expenses incurred by property ownership for charitable contributions and for production and distribution of property packages. Jan -03 Feb -03 Mar -03 I Apr -03 May -03 I Jun -03 Jul -03 Aug -03 Sep -03 I Oct -03 Nov -03 De.-03 1 Yr. Total Amount paid 4 Q 0 0.. b A; 0. Total Monthly Cost 0 0 0 01 0 1 0 1 0 1 0 1 0 1 0 1 0 1 ---0-1 9830 START -UP EXPENSE (ENTER EXPENSE ON START -UP SUBEllULE WORKSHEET) Descri to ion. Expense associated with the start up costs for a new cotnmmn6y. San -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Yr. Total Sep -03 Oct -03 Nov -03 Dec -03 Amount paid 1,568 1,568 1,568 1,568 1,568 1,568 1,568 1,568 18,816 1,568 1,568 1,568 1,568 Total Monthly Cost 1,568 1,568 1,568 1,568 1,568 1,568 1,568 11568 1,568 1,568 1,568 1,568 18,816 Cotn!nents: $499(#fot'fie�l�'���� fkty� - / Cost/PSF: O.Ih ' CostBED: 34 r r' Prior Actual 0 Cost/BED: 0 Cost/PSF: 0.00 a se P Increase/Prior rl o M/25/2002 10:05 AM Exj—. l.pm 2 Pap 23 / 23 Jefferson Commons - San Marcos Budget Startup Expense Detail f; J 1 9830 - 25150026 Start up Nolslde S—iee 4 � 9830.25150027 Start up Monthly Continental Breakfast ' =t ,za x s �� ,� . , _ ;` TM 1 10125nW2 Accom Start up F Startup F Startup ( Startup: Start up P Suet up F Start up t Startup) Start up F 54nt up l Start up P Start up Startup I Start up ( Suet up E Start lip F Startup I Start up Startup I Startup( Suet Up P Startup I Startup F Start up F Startup? pkcc 11 a Cetegary Start up Inputs d den -03 F Feb -03 M-03 A Apr-03 M May -03 d dun -03 , ,1.1413 A Aug -03 S SepA3 O Od4l.l Nov -03 D D-03 Y Yearly Totals 9830 - 25150000 Startup Expenses S S 1,568 $ $ 1,568 $ 1,568 $ $ 1,568 $ $ 1,568 S S 1,568 $ $ 1,568 $ $ 1,568 $ $ 1,568 $ $ 1,568 $ 1,568 $ $ 1,568 S S 18,816 9830- 25150W I Start or Revenue $ $Yi ` `d r z z �, 4 z ' '11? , t 4}I ° ° : : r9i a X12 ' ' e 5,000 ,7i'T t e43'� 5 9830 - 25150002 Start up Operadons " "al$ . .S'I,$, z „9. ° ° s 3E ; ; 3t ' '' a 38 ' ' 3 3pg 5 5i}I ; ;,' i3# 31 i i3Pie 3 3,816 9830 - 25150004 Start up Salaries'j3'_ Start u 9830- 251 M7 S s Y Y s s . .r S S y 9830.25150008 Start up Flags /Banners /Mats k rs 9830 - 25150009 Startup Marketing Collateral f f ; ; `f 9830 - 25150010 Start up Apsrunent Guide z ( ( 3 3 1 P z 9830,25150011 Start op For Rent Magazine 4'. 9830 - 25150012 Start up Apm'tnuent Map , , ; ; +, r ,n ,. ` `' t s & Y Y t t I s s & b { z r r 9630 - 25150000 Startup Met Living Magazine ; z i if S S a i i s S t 3 3 9830-2515,],014 Start up Direct Mail Piece ^ ^. + t t„ 7F z :;1' ; ;.:. 9830-25150015 Start up lcroator Visitation A 777 77,1177,715- 9830 - 25150016 Startup Corporate Solicitation 9830-25150017 Start up Bxlloane 9830. 25150018 Start up Prospect , 9830.25150019 Start u up H 9830 - - 2 r 9830 - 25150021 Startup Cacator luncheon - r y - z, 9830 - 25150022 Start up Gauul Opening Party A r 9830. 25150023 SWI up Move -In Gifts t tr ,., - - z g� z 9830.25150024 Start up Directional Signage 9830 - 25150000 Startup Resident interest Directory . .t t t Y,s p � � 1 10125nW2 Accom Start up F Startup F Startup ( Startup: Start up P Suet up F Start up t Startup) Start up F 54nt up l Start up P Start up Startup I Start up ( Suet up E Start lip F Startup I Start up Startup I Startup( Suet Up P Startup I Startup F Start up F Startup? pkcc 11 a 9830. 25150027 Shat up Pack -n -mill /Gift wrapp 9830.25150028 Start up Holiday Deo -minas 9830- 25150029 Start up Complimentary Check out sve 9830. 25150029 Start ❑n Complimentary Video Library 9830 - 25150030 Sw up Billboard 9830 - 25150048 Start up Other Marketing 9830- 25150031 Startup Locator fees, Lease up 9830. 25150036 Start Up Internet Advertising 9830 - 25150037 Start Up Major Prize Promotions 9830. 25150042 Start Up Mike. Print Advertising 9830. 25150043 Start Up Community Relations 9830 - 25150043 Start Up Resident Services 9830 - 25150044 Suvl Up Employee Tm ining 9830 - 25150035 Start Up Leasing Comntiasions 9835. 25155001 Start up Janitorial Supplies 9835. 25155002 Start up Office Supplies 9835- 25155003 Start up Office &luipmenl 9835 - 25155004 Start up Minna, Equipment 9835 - 25155005 Start up Leasing Office 9835 - 25155006 Start Up Membership Fees 9830. 25150004 Start Up PaporworkfForms 9830 - 25150046 Stan Up Displaced Residents I 1C/Ti,2002 Start up F Start up F Start up Start up Start tip F Start up ( Start up I Start Up. Start UP) start Up'. Start Up m Start Up I Stmt Up I Start Up I Start up 1 Start up ( Start up( Start up T Start up I Stan UP) Start UP) Stan Up I 2nm auaacm SWT.xIs S. -Up E,,,— pvgU V4 tte :Xpenses 2evenue Jp -aions 3aluics Nansgement I.., ?lags /Banners /Mats Marketing Colinteral 4t nrunenl Guide ?or Rent Mngaine kPellment Map Het Living Mag;.ine Jlrect Mail Piece .ocntor vi.,nnt on 7orponn , Sol icitation 3elloons '-,pcct Gift, iospimlity Ite- 3ues't CindsNisilor follow ul - ocntor luncheon 3rnnd Opening Penny Mov,in Gilts )irecticmnI Sigonge 3esidcnt Interest Directory >nolside Servlca Monthly Continenud Breakfo 2001 Bengt, Jefferson Commons - San Marcos Budget Startup Expense Detail Comments rte® In125/2002 Pack -n -mail /Gift -app ioliday Decorations ]omplimentary Check out svc 7omplimentary Video Library 3illboard Dther Marketing —ator fees, Lease up Internet Advertising Major Prize P ti.ris Misc. Print Advertising Community Relations Residat Services Employee Training Lmnting Commissions hmitorial Supplies office Supplies Xkc Equipment Kaim. Equipment ,casing Office Membership Pees Paperwork /Forms Displaced Residents I NL52t102 2003 nvdpG MT, 4, S-41p Expense N, V a Jefferson Commons — San Marcos Marketing Summary Historically, Jefferson Commons -San Marcos has performed very well, capturing enough traffic to reach budgeted occupancy percentage. In the 2001 -2002 season, the asset found itself competing with other new development in the market, which initially took many of its current residents. Essentially, the asset found itself in a new "lease -up." Through extensive market research, including student focus groups, JPI coordinated a marketing campaign to increase community traffic and word -of -mouth advertising. During our 2002 -2003 lease -up season, JPI will focus on two core areas to maintain name recognition, critical word -of -mouth advertising and resident retention efforts. Market trends indicate that students today are more focused on the perceived lifestyle they attain rather than the actual "value" they receive. JPIdeas, JPI Student Living's marketing department, builds their "Home is Where Your Friends Are" campaign around this market trend, specifically targeting student's desire for an active lifestyle their peers will envy. Leasing Strategies • Co -Op marketing efforts with local businesses/university • Apartment locator relations • Student newspaper advertising • Community bootleg signs • Internet advertising (implement improved community website) • Distribution of flyers and snack bags to students on campus • Peer -to -peer advertising • Student group sponsorships • Direct mailers • Radio campaign Resident Retention Strategies • Resident referral program • "Town hall" style meetings • Resident functions (breakfast -on- the -go, finals frenzy, spring break out, etc) • Video lending service • Targeted renewal campaign • Resident awareness sessions (debt reduction, time management, etc) ® Seasonal activities Each month throughout the leasing season, a JPIdeas representative will conduct brainstorming meetings with the on -site manager and regional manager in order to re -line the marketing plan in accordance with market fluctuations.