Docstoc

2011 Splits - New Columbia

Document Sample
2011 Splits - New Columbia Powered By Docstoc
					New Columbia Owners Association
Homeowner Fees

                                                                                   2011

Block Number
                                       Jan        Feb        Mar        Apr        May        Jun        Jul        Aug        Sep        Oct        Nov        Dec
      1                                       9          9          9          9          9          9          9          9          9          9          9          9
      2                                      13         13         13         13         13         13         13         13         13         13         13         13
      3                                      12         12         12         12         12         12         12         12         12         12         12         12
      4                                      14         14         14         14         14         14         14         14         14         14         14         14
      5                                      13         13         13         13         13         13         13         13         13         13         13         13
      6                                       7          7          7          7          7          7          7          7          7          7          7          7
      7                                       8          8          8          8          8          8          8          8          8          8          8          8
      8                                       9          9          9          9          9          9          9          9          9          9          9          9
      9                                      13         13         13         13         13         13         13         13         13         13         13         13
     11                                      12         12         12         12         12         12         12         12         12         12         12         12
     12                                      16         16         16         16         16         16         16         16         16         16         16         16
     13                                       5          5          5          5          5          5          5          5          5          5          5          5
     14                                       5          5          5          5          5          5          5          5          5          5          5          5
     16                                       8          8          8          8          8          8          8          8          8          8          8          8
   18&19                                     25         25         25         25         25         25         25         25         25         25         25         25
     20                                      14         14         14         14         14         14         14         14         14         14         14         14
     21                                      13         13         13         13         13         13         13         13         13         13         13         13
     22                                      12         12         12         12         12         12         12         12         12         12         12         12
     24                                      19         19         19         19         19         19         19         19         19         19         19         19
     25                                       5          5          5          5          5          5          5          5          5          5          5          5

                 Total Homes:            227        227        227        227        227        227        227        227        227        227        227        227

  Ant. # Qualified for Abatement:            37         37         37         37      37            37         37         37         37         37         37         37

       Anticipated Regular Fees:       12,779     12,779     12,779     12,779     12,779     12,779     12,779     12,779     12,779     12,779     12,779     12,779

        Anticipated Abated Fees:        1,601      1,601      1,601      1,601      1,601      1,601      1,601      1,601      1,601      1,601      1,601      1,601

               Total Fees              14,380     14,380     14,380     14,380     14,380     14,380     14,380     14,380     14,380     14,380     14,380     14,380

               Total to Reserve         1,648      1,648      1,648      1,648      1,648      1,648      1,648      1,648      1,648      1,648      1,648      1,648

               Total Reserve by Unit     7.26       7.26       7.26       7.26       7.26       7.26       7.26       7.26       7.26       7.26       7.26       7.26
                             New Columbia Owners Association
                                           2011 Operating Budget




                                                  Presented to:
                                         New Columbia Owners Association




                                                       Prepared by:




                                              Guardian Real Estate Services

                                                          Draft




   Property Name:    New Columbia Owners Association                                 Mgt Fee %:      $10 per unit
  Property Owner:    New Columbia Owners Association                             Vacancy Factor:             N/A
     Budget Year:                               2011                            Annual Turnover:             N/A
 Number of Units:                                849                  Monthly Turnover (in Units):           N/A
Total Square Feet:                               N/A                      Date of Market Survey:             N/A
       City/State:                  Portland, Oregon
New Columbia Owners Association
Fees from HAP Partnerships and Trenton Terrace

                                                                                     2011
                                 Jan         Feb         Mar         Apr         May         Jun         Jul         Aug         Sep         Oct         Nov         Dec
Cecelia                                131         131         131         131      131            131         131         131         131         131         131         131
Haven                                   44          44          44          44       44             44          44          44          44          44          44          44
Trouton                                250         250         250         250      250            250         250         250         250         250         250         250
Woolsey                                131         131         131         131      131            131         131         131         131         131         131         131
Trenton Terrace                         66          66          66          66       66             66          66          66          66          66          66          66
Total                                  622         622         622         622      622            622         622         622         622         622         622         622

                                                                     Anticipated Dues from HAP Partnerships
                                 Jan         Feb         Mar         Apr         May         Jun          Jul        Aug         Sep         Oct         Nov         Dec
Cecelia                           $4,881      $4,881      $4,881      $4,881      $4,881      $4,881       $4,881     $4,881      $4,881      $4,881      $4,881      $4,881
Haven                             $1,639      $1,639      $1,639      $1,639      $1,639      $1,639       $1,639     $1,639      $1,639      $1,639      $1,639      $1,639
Trouton                           $9,315      $9,315      $9,315      $9,315      $9,315      $9,315       $9,315     $9,315      $9,315      $9,315      $9,315      $9,315
Woolsey                           $4,881      $4,881      $4,881      $4,881      $4,881      $4,881       $4,881     $4,881      $4,881      $4,881      $4,881      $4,881
  Total HAP Partnership
          Fees:                  $20,717     $20,717     $20,717     $20,717     $20,717     $20,717     $20,717     $20,717     $20,717     $20,717     $20,717     $20,717
Trenton Terrace Fees:             $2,459      $2,459      $2,459      $2,459      $2,459      $2,459      $2,459      $2,459      $2,459      $2,459      $2,459      $2,459


Total reserve contrbituion   $    4,516 $     4,516 $     4,516 $     4,516 $     4,516 $     4,516 $      4,516 $    4,516 $     4,516 $     4,516 $     4,516 $     4,516
Total reserves per unit             7.26        7.26        7.26        7.26        7.26        7.26         7.26       7.26        7.26        7.26        7.26        7.26
New Columbia Owners Association
January - December 2011
Final
                                      Account                Total         January       February    March        April         May         June         July         August       September    October       November    December
             Owners Association Dues
4960-00-00   Owners Association Dues                                   0             0           0            0            0            0            0            0            0           0              0          0           0
4960-10-00   Dues - Partnerships                               248,599        20,717        20,717     20,717          20,717    20,717      20,717       20,717        20,717         20,717      20,717        20,717      20,717
4960-20-00   Dues - Homeowners                                 153,353        12,779        12,779     12,779          12,779    12,779      12,779       12,779        12,779         12,779      12,779        12,779      12,779
4960-30-00   Dues - Affordable Homeowners                       19,207         1,601         1,601      1,601           1,601     1,601       1,601        1,601         1,601          1,601       1,601         1,601       1,601
4960-60-00   Dues - Trenton Terrace                             29,510         2,459         2,459      2,459           2,459     2,459       2,459        2,459         2,459          2,459       2,459         2,459       2,459
4944-10-00   Parking Income                                            0             0           0            0            0            0            0            0            0           0              0          0           0
4944-40-00   Commercial Communications Income                          0             0           0            0            0            0            0            0            0           0              0          0           0
4969-00-00   Total Owners Association Dues                     450,669        37,556        37,556     37,556          37,556    37,556      37,556       37,556        37,556         37,556      37,556        37,556      37,556


             Vacancies
4205-02-00   Apartment Vacancies                                       0             0           0            0            0            0            0            0            0           0              0          0           0
4210-02-00   Rent Concessions                                          0             0           0            0            0            0            0            0            0           0              0          0           0
4229-00-00   Less Vacancies                                            0             0           0            0            0            0            0            0            0           0              0          0           0
4299-00-00   Net Rental Income                                 450,669        37,556        37,556     37,556          37,556    37,556      37,556       37,556        37,556         37,556      37,556        37,556      37,556


             Non-Rental Income
4820-00-00   Other Income                                              0             0           0            0            0            0            0            0            0           0              0          0           0
4913-00-00   Utility Allowance Revenue                                 0             0           0            0            0            0            0            0            0           0              0          0           0
4914-00-00   Tenant Utility Income                                     0             0           0            0            0            0            0            0            0           0              0          0           0
4942-00-00   Vending & Phone Income                                    0             0           0            0            0            0            0            0            0           0              0          0           0
4943-00-00   Laundry Income                                            0             0           0            0            0            0            0            0            0           0              0          0           0
4944-50-00   Commercial Reimbursement Income                           0             0           0            0            0            0            0            0            0           0              0          0           0
4945-00-00   NSF & Late Charges                                  7,800          650            650       650             650          650          650          650        650           650         650           650         650
4947-00-00   Damages & Cleaning Charges                                0             0           0            0            0            0            0            0            0           0              0          0           0
4953-00-00   Tenant Screening Charges                                  0             0           0            0            0            0            0            0            0           0              0          0           0
4955-00-00   Bad Debt Recovery                                         0             0           0            0            0            0            0            0            0           0              0          0           0
4990-20-00   Interest Income - Bank Accounts                     1,200          100            100       100             100          100          100          100        100           100         100           100         100
4990-30-00   Interest Income - Bond Funds                              0             0           0            0            0            0            0            0            0           0              0          0           0
4989-00-00   Total Non-Rental Income                             7,800          650            650       650             650          650          650          650        650           650         650           650         650
4999-00-00   Total Income                                      458,469        38,206        38,206     38,206          38,206    38,206      38,206       38,206        38,206         38,206      38,206        38,206      38,206


             Payroll
5601-10-00   Manager Salary & Wages                              9,984          832            832       832             832          832          832          832        832           832         832           832         832
5601-20-00   Assistant Manager Salary & Wages                   13,716         1,143         1,143      1,143           1,143     1,143       1,143        1,143         1,143          1,143       1,143         1,143       1,143
5601-30-00   Leasing Consultant Salary & Wages                         0             0           0            0            0            0            0            0            0           0              0          0           0
5601-40-00   Desk Help Salary & Wages                                  0             0           0            0            0            0            0            0            0           0              0          0           0
5610-10-00   All Admin Payroll Taxes                             3,600          300            300       300             300          300          300          300        300           300         300           300         300
5611-10-00   All Admin Employee Benefits                         5,400          450            450       450             450          450          450          450        450           450         450           450         450
5612-10-00   All Admin Workers Compensation                      1,200          100            100       100             100          100          100          100        100           100         100           100         100
5619-99-00   Total Outside Administrative Payroll Expenses      33,900         2,825         2,825      2,825           2,825     2,825       2,825        2,825         2,825          2,825       2,825         2,825       2,825


5621-10-00   Maintenance Salary & Wages                                0             0           0            0            0            0            0            0            0           0              0          0           0
5621-30-00   Groundskeeper Salary & Wages                       21,420         1,785         1,785      1,785           1,785     1,785       1,785        1,785         1,785          1,785       1,785         1,785       1,785
5621-40-00   Housekeeper Salary & Wages                                0             0           0            0            0            0            0            0            0           0              0          0           0
5621-50-00   Painter Salary & Wages                                    0             0           0            0            0            0            0            0            0           0              0          0           0
5630-10-00   All Main Payroll Taxes                              3,300          275            275       275             275          275          275          275        275           275         275           275         275
5631-10-00   All Maint Employee Benefits                         5,160          430            430       430             430          430          430          430        430           430         430           430         430
5632-10-00   All Maint Workers Compensation                          960         80             80           80           80           80           80           80         80            80          80            80          80
5639-99-00   Total Outside Maintenance Payroll Expenses         30,840         2,570         2,570      2,570           2,570     2,570       2,570        2,570         2,570          2,570       2,570         2,570       2,570


5700-00-00   Temporary Help                                            0             0           0            0            0            0            0            0            0           0              0          0           0


                                                                                                              Page 4
5755-00-00   Employee Bonuses                               0       0       0       0            0       0       0        0        0        0       0       0       0
5760-00-00   Apartment Value Compensation                   0       0       0       0            0       0       0        0        0        0       0       0       0
5999-00-00   Total Labor Expense                        64,740   5,395   5,395   5,395        5,395   5,395   5,395    5,395    5,395    5,395   5,395   5,395   5,395


             Administrative Expense
6030-20-00   Audit Expense                               2,700      0       0       0            0     800       0        0        0     1,900      0       0       0
6035-30-00   Advertising                                    0       0       0       0            0       0       0        0        0        0       0       0       0
6055-09-00   Software                                     840      70      70      70           70      70      70       70       70       70      70      70      70
6043-00-00   Bad Debt Expense                            9,996    833     833     833          833     833     833      833      833      833     833     833     833
6062-00-00   Courtesy Patrol/Protective Services        27,600   1,600      0       0         3,250      0       0     6,500    6,500    6,500   3,250      0       0
6065-00-00   Dues and Membership                            0       0       0       0            0       0       0        0        0        0       0       0       0
6067-00-00   Equipment Rental - Office/Furniture            0       0       0       0            0       0       0        0        0        0       0       0       0
6068-00-00   Office Equipment/Furniture                     0       0       0       0            0       0       0        0        0        0       0       0       0
6069-00-00   Equipment Maintenance - Office                 0       0       0       0            0       0       0        0        0        0       0       0       0
6080-00-00   HAP Management Fee                             0       0       0       0            0       0       0        0        0        0       0       0       0
6084-00-00   Investor Service Fee                           0       0       0       0            0       0       0        0        0        0       0       0       0
6087-00-00   Legal Expense                               3,600    300     300     300          300     300     300      300      300      300     300     300     300
6088-00-00   LIHTC Assessment                               0       0       0       0            0       0       0        0        0        0       0       0       0
6088-10-00   OAHTC Admin Fee                                0       0       0       0            0       0       0        0        0        0       0       0       0
6093-00-00   Office Supplies\Postage\Printing            1,620    135     135     135          135     135     135      135      135      135     135     135     135
6095-00-00   Other Administrative Expense                3,600      0       0     900            0       0     900        0        0      900       0       0     900
6097-00-00   Other Professional Services                  600       0       0       0            0       0       0        0        0        0       0     600       0
6105-00-00   Outside Management Fees                    27,240   2,270   2,270   2,270        2,270   2,270   2,270    2,270    2,270    2,270   2,270   2,270   2,270
6108-00-00   General Partnership Admin Fee                  0       0       0       0            0       0       0        0        0        0       0       0       0
6120-03-00   Telephone\Answering Service\Pagers             0       0       0       0            0       0       0        0        0        0       0       0       0
6125-00-00   Tenant Screening                               0       0       0       0            0       0       0        0        0        0       0       0       0
6128-00-00   Employee Training                              0       0       0       0            0       0       0        0        0        0       0       0       0
6130-02-00   Mileage                                        0       0       0       0            0       0       0        0        0        0       0       0       0
6140-00-00   Trustee Fees                                   0       0       0       0            0       0       0        0        0        0       0       0       0
6141-00-00   Bond Remarketing Fee - New Columbia only       0       0       0       0            0       0       0        0        0        0       0       0       0
6199-00-00   Total Administrative Expense               77,796   5,208   3,608   4,508        6,858   4,408   4,508   10,108   10,108   12,908   6,858   4,208   4,508


             Tenant Services
6210-70-00   Contract Tenant Services                       0       0       0       0            0       0       0        0        0        0       0       0       0
6210-80-00   Services - St. Francis                         0       0       0       0            0       0       0        0        0        0       0       0       0
6299-00-00   Total Tenant Services                          0       0       0       0            0       0       0        0        0        0       0       0       0


             Utilities
6310-00-00   Water                                      24,264   6,066      0       0         6,066      0       0     6,066       0        0    6,066      0       0
6312-00-00   Electricity                                    0       0       0       0            0       0       0        0        0        0       0       0       0
6314-00-00   Gas                                            0       0       0       0            0       0       0        0        0        0       0       0       0
6320-00-00   Garbage                                        0       0       0       0            0       0       0        0        0        0       0       0       0
6321-00-00   Cable TV                                       0       0       0       0            0       0       0        0        0        0       0       0       0
6325-00-00   Sewer                                          0       0       0       0            0       0       0        0        0        0       0       0       0
6360-00-00   Turnover Utilities                             0       0       0       0            0       0       0        0        0        0       0       0       0
6399-00-00   Total Utilities                            24,264   6,066      0       0         6,066      0       0     6,066       0        0    6,066      0       0


             Routine Maintenance
             Maintenance Materials
6420-08-00   Maint Mtrls- Furniture                         0       0       0       0            0       0       0        0        0        0       0       0       0
6420-20-00   Maint Mtrls - Cleaning                         0       0       0       0            0       0       0        0        0        0       0       0       0
6420-25-00   Maint Mtrls - Electrical                       0       0       0       0            0       0       0        0        0        0       0       0       0
6420-33-00   Maint Mtrls - Fountain/Pool                    0       0       0       0            0       0       0        0        0        0       0       0       0
6420-40-00   Maint Mtrls - Hardware                       300      25      25      25           25      25      25       25       25       25      25      25      25
6420-43-00   Maint Mtrls - Heating & Air Cond               0       0       0       0            0       0       0        0        0        0       0       0       0
6420-50-00   Maint Mtrls - Other                            0       0       0       0            0       0       0        0        0        0       0       0       0
6420-55-00   Maint Mtrls - Painting                       120      10      10      10           10      10      10       10       10       10      10      10      10



                                                                                     Page 5
6420-60-00   Maint Mtrls - Plumbing                                     0        0        0        0             0        0        0        0        0        0        0        0        0
6420-70-00   Maint Mtrls - Uniforms                                     0        0        0        0             0        0        0        0        0        0        0        0        0
6420-75-00   Maint Mtrls - Landscape Equipment/Products                 0        0        0        0             0        0        0        0        0        0        0        0        0
6420-99-00   Total Maint Mtrls                                        420       35       35       35            35       35       35       35       35       35       35       35       35


             Maintenance Contracts & Services
6430-05-00   Maint Contracts - Alarm                                    0        0        0        0             0        0        0        0        0        0        0        0        0
6430-10-00   Maint Contracts - Appliance Repair                         0        0        0        0             0        0        0        0        0        0        0        0        0
6430-14-00   Maint Contracts - Carpentry/ Fence Repair                  0        0        0        0             0        0        0        0        0        0        0        0        0
6430-15-00   Maint Contracts - Carpeting/Vinyl Cleaning                 0        0        0        0             0        0        0        0        0        0        0        0        0
6430-20-00   Maint Contracts - Drapery/Blind Clean/Replace              0        0        0        0             0        0        0        0        0        0        0        0        0
6430-22-00   Maint Contracts - Door/Window Replacement & Repair         0        0        0        0             0        0        0        0        0        0        0        0        0
6430-25-00   Maint Contracts - Electrical                            1,200     100      100      100           100      100      100      100      100      100      100      100      100
6430-27-00   Maint Contracts - Elevator                                 0        0        0        0             0        0        0        0        0        0        0        0        0
6430-29-00   Maint Contracts - Exterminating                            0        0        0        0             0        0        0        0        0        0        0        0        0
6430-33-00   Maint Contracts - Fountain/Pool                            0        0        0        0             0        0        0        0        0        0        0        0        0
6430-35-00   Maint Contracts - Fire Exting/Sprinklers                   0        0        0        0             0        0        0        0        0        0        0        0        0
6430-40-00   Maint Contracts - Gutters                                  0        0        0        0             0        0        0        0        0        0        0        0        0
6430-50-00   Maint Contracts - Heat & Air                               0        0        0        0             0        0        0        0        0        0        0        0        0
6430-55-00   Maint Contracts - Landscape                           204,000   17,000   17,000   17,000        17,000   17,000   17,000   17,000   17,000   17,000   17,000   17,000   17,000
6430-56-00   Maint Contracts - Janitorial/Cleaning                      0        0        0        0             0        0        0        0        0        0        0        0        0
6430-58-00   Maint Contracts - Misc.                                    0        0        0        0             0        0        0        0        0        0        0        0        0
6430-64-00   Maint Contracts - Plumbing                                 0        0        0        0             0        0        0        0        0        0        0        0        0
6430-80-00   Maint Contracts - Windows Cleaning                         0        0        0        0             0        0        0        0        0        0        0        0        0
6430-99-00   Total Maint Contracts & Services                      205,200   17,100   17,100   17,100        17,100   17,100   17,100   17,100   17,100   17,100   17,100   17,100   17,100


             Turnover
6470-05-00   Turnover - Appliances Parts                                0        0        0        0             0        0        0        0        0        0        0        0        0
6470-15-00   Turnover - Carpet/Vinyl Cleaning Contract/Supplies         0        0        0        0             0        0        0        0        0        0        0        0        0
6470-20-00   Turnover - Drapery/Blind Clean/Replace                     0        0        0        0             0        0        0        0        0        0        0        0        0
6470-50-00   Turnover - Parts                                           0        0        0        0             0        0        0        0        0        0        0        0        0
6470-54-00   Turnover - Painting Contract/Supplies                      0        0        0        0             0        0        0        0        0        0        0        0        0
6470-56-00   Turnover - Cleaning Contract/Supplies                      0        0        0        0             0        0        0        0        0        0        0        0        0
6470-66-00   Turnover - Resurfacing Contract                            0        0        0        0             0        0        0        0        0        0        0        0        0
6470-99-00   Total Turnover                                             0        0        0        0             0        0        0        0        0        0        0        0        0
6499-00-00   Total Routine Maintenance and Turnover                205,620   17,135   17,135   17,135        17,135   17,135   17,135   17,135   17,135   17,135   17,135   17,135   17,135


             General Expenses
6610-10-00   Insurance - General Liability & Property                7,055     566      567      567           567      567      567      567      567      630      630      630      630
6610-50-00   Insurance - Errors & Omissions                             0        0        0        0             0        0        0        0        0        0        0        0        0
6622-00-00   Payments In Lieu Of Taxes                                  0        0        0        0             0        0        0        0        0        0        0        0        0
6624-00-00   Misc. Taxes, Licenses, Permits                           240       20       20       20            20       20       20       20       20       20       20       20       20
6626-00-00   Property Taxes                                           780        0        0        0             0        0        0        0        0        0        0      780      780
6660-20-00   Interest Expense - Mortgage                                0        0        0        0             0        0        0        0        0        0        0        0        0
6660-30-00   Int Expense - Bond                                         0        0        0        0             0        0        0        0        0        0        0        0        0
6660-40-00   Int Expense - Other                                        0        0        0        0             0        0        0        0        0        0        0        0        0
6660-50-00   Int Expense -Deferred                                      0        0        0        0             0        0        0        0        0        0        0        0        0
6670-00-00   Depreciation Expense - Misc                                0        0        0        0             0        0        0        0        0        0        0        0        0
6670-12-00   Depreciation Expense-Site Improvements                     0        0        0        0             0        0        0        0        0        0        0        0        0
6670-20-00   Depreciation Expense-Dwelling Structures                   0        0        0        0             0        0        0        0        0        0        0        0        0
6670-25-00   Depreciation Expense-Dwelling Equipment                    0        0        0        0             0        0        0        0        0        0        0        0        0
6670-30-00   Depreciation Expense-Non Dwelling Structures               0        0        0        0             0        0        0        0        0        0        0        0        0
6670-35-00   Depreciation Expense-Non Dwelling Equipment                0        0        0        0             0        0        0        0        0        0        0        0        0
6675-00-00   Amortization Expense                                       0        0        0        0             0        0        0        0        0        0        0        0        0
6681-00-00   Land Lease Expense (Hamilton West and New Columbia)        0        0        0        0             0        0        0        0        0        0        0        0        0
6731-20-00   Utility Allowance Reimbursement                            0        0        0        0             0        0        0        0        0        0        0        0        0
6699-00-00   Total General Expenses                                  8,075     586      587      587           587      587      587      587      587      650      650     1,430    1,430



                                                                                                    Page 6
             Non- Recurring Expenses
6910-01-00   Appliances                                      0         0        0        0              0        0        0         0         0         0         0        0        0
6910-02-00   Maintenance Equipment                           0         0        0        0              0        0        0         0         0         0         0        0        0
6910-03-00   Office Equipment                                0         0        0        0              0        0        0         0         0         0         0        0        0
6910-04-00   Exterior Building Improvements                  0         0        0        0              0        0        0         0         0         0         0        0        0
6910-05-00   Interior Building Improvements                  0         0        0        0              0        0        0         0         0         0         0        0        0
6910-06-00   System Building Improvements                    0         0        0        0              0        0        0         0         0         0         0        0        0
6910-07-00   Door and Window                                 0         0        0        0              0        0        0         0         0         0         0        0        0
6910-09-00   Floor Coverings                                 0         0        0        0              0        0        0         0         0         0         0        0        0
6910-10-00   Land Improvements                               0         0        0        0              0        0        0         0         0         0         0        0        0
6910-11-00   Paint Exterior                                  0         0        0        0              0        0        0         0         0         0         0        0        0
6910-12-00   Pavement & Walkways                             0         0        0        0              0        0        0         0         0         0         0        0        0
6910-13-00   Roofing & Gutter Repair                         0         0        0        0              0        0        0         0         0         0         0        0        0
6959-00-00   Total Non-Recurring Expense                     0         0        0        0              0        0        0         0         0         0         0        0        0
8799-00-00   Total Expenses                             380,495   34,390    26,725   27,625        36,041    27,525   27,625   39,291    33,225    36,088    36,104    28,168   28,468
8999-00-00   Net Income (Loss)                           77,974    3,816    11,481   10,581         2,165    10,681   10,581   (1,085)    4,981     2,118     2,102    10,038    9,738


             Adjustments to Cash Basis


             Depreciation Expense                            0         0        0        0              0        0        0         0         0         0         0        0        0
             Amortization Expense                            0         0        0        0              0        0        0         0         0         0         0        0        0
             Ground lease (Hamilton West only)               0         0        0        0              0        0        0         0         0         0         0        0        0


             Non-operating sources of cash
             Replacement Reserves Withdrawals                0         0        0        0              0        0        0         0         0         0         0        0        0


             Non-operating uses of cash
             Debt principal payments                         0         0        0        0              0        0        0         0         0         0         0        0        0
             Capital expenditures                            0         0        0        0              0        0        0         0         0         0         0        0        0
             Restricted Cash                                 0         0        0        0              0        0        0         0         0         0         0        0        0
             Additions to reserves                       74,329    6,164     6,164    6,164         6,164     6,164    6,164    6,164     6,164     6,164     6,164     6,164    6,164   7.3
             Total Non-operating uses of cash            74,329    6,164     6,164    6,164         6,164     6,164    6,164    6,164     6,164     6,164     6,164     6,164    6,164


                     Cash Flow                            3,645   (2,348)    5,317    4,417        (3,999)    4,517    4,417   (7,249)   (1,183)   (4,046)   (4,062)    3,874    3,574


             Add back deferred interest

                                       Real Cash Flow




                                                                                          Page 7
New Columbia Shared Expenses 2011
Shared Expenses

                                                       Total Units Including Owner's Association
             Jan         Feb           Mar         Apr        May          Jun         Jul          Aug          Sep         Oct         Nov        Dec
Cecelia            131         131        131         131          131        131          131         131             131         131      131        131
Haven               44          44         44          44           44         44           44          44              44          44       44         44
Trouton            250         250        250         250          250        250          250         250             250         250      250        250
Woolsey            131         131        131         131          131        131          131         131             131         131      131        131
Owners             226         226        226         226          226        226          226         226             226         226      226        226
Total              782         782        782         782          782        782          782         782             782         782      782        782
                                                         Total Apartment Units By Partnership
             Jan         Feb           Mar         Apr        May          Jun         Jul          Aug          Sep         Oct         Nov        Dec
Cecelia            131         131        131         131          131        131          131         131             131         131      131        131
Haven               44          44         44          44           44         44           44          44              44          44       44         44
Trouton            250         250        250         250          250        250          250         250             250         250      250        250
Woolsey            131         131        131         131          131        131          131         131             131         131      131        131
Total              556         556        556         556          556        556          556         556             556         556      556        556


                                     Percentage of Total Units for Determining Partnership Share of Expenses/All Units
             Jan         Feb           Mar          Apr          May         Jun          Jul        Aug          Sep        Oct         Nov        Dec
Cecelia        22.15       22.15         22.15        22.15        22.15       22.15       22.15       22.15        22.15     22.15       22.15      22.15
Haven           7.43        7.43          7.43         7.43         7.43        7.43         7.43       7.43         7.43      7.43        7.43       7.43
Trouton        42.27       42.27         42.27        42.27        42.27       42.27       42.27       42.27        42.27     42.27       42.27      42.27
Woolsey        22.15       22.15         22.15        22.15        22.15       22.15       22.15       22.15        22.15     22.15       22.15      22.15
Owners             6           6              6           6            6           6            6          6            6          6          6          6
Total            100         100           100          100          100         100          100        100          100        100        100        100


                                                              Landscaping Splits By Percentage
             Jan         Feb           Mar         Apr          May         Jun          Jul        Aug          Sep         Oct         Nov        Dec
Cecelia              6           6            6           6            6           6            6          6             6           6          6          6
Haven                2           2            2           2            2           2            2          2             2           2          2          2
Owners              74          74           74          74          74           74           74         74            74          74         74         74
Trouton             12          12           12          12          12           12           12         12            12          12         12         12
Woolsey           6           6          6           6           6           6           6           6              6           6       6       6
Total           100         100        100         100         100         100         100         100            100         100     100     100

                                                Apartments/Owners Irrigation Splits By Percentage
          Jan         Feb          Mar          Apr       May          Jun           Jul        Aug         Sep         Oct         Nov     Dec
Cecelia           6           6          6           6          6             6            6         6              6           6       6       6
Haven             2           2          2           2          2             2            2         2              2           2       2       2
Owners           74          74         74          74        74            74            74        74             74          74      74      74
Trouton          12          12         12          12        12            12            12        12             12          12      12      12
Woolsey           6           6          6           6          6             6            6         6              6           6       6       6
Total           100         100        100         100       100           100           100       100            100         100     100     100

                             Percentage of Total Units for Determining Partnership Share of Expenses/Apartments Only
          Jan         Feb         Mar           Apr         May         Jun          Jul         Aug        Sep         Oct         Nov     Dec
Cecelia          24          24         24           24          24           24          24          24         24            24      24      24
Haven             7           7           7            7           7           7            7          7          7             7       7       7
Trouton          45          45         45           45          45           45          45          45         45            45      45      45
Woolsey          24          24         24           24          24           24          24          24         24            24      24      24
Total           100         100        100         100          100          100         100         100        100           100     100     100
New Columbia Owners Association
Budget Notes
Final
                                                                         INCOME

                                                                     Rental Income
4960-00-00   Owners Association Dues                        N/A
4960-10-00   Dues - Partnerships                            Dues are $37 per month, per unit
4960-20-00   Dues - Homeowners                              Dues are $67 per month
4960-30-00   Dues - Affordable Homeowners                   Homeowners with qualify ing dues pay an abated assessment of $43
4960-60-00   Dues - Trenton Terrace                         Dues are $37 per unit per month

                                                                        Vacancies
4205-02-00   Apartment Vacancies                            N/A
4210-02-00   Rent Concessions                               N/A

                                                                   Non-Rental Income
4820-00-00   Other Income                                   N/A
4990-20-00   Interest Income - Bank Accounts                N/A
4990-30-00   Interest Income - Bond Funds                   N/A
4913-00-00   Utility Allowance Revenue                      N/A
4914-00-00   Tenant Utility Income                          N/A
4942-00-00   Vending & Phone Income                         N/A
4943-00-00   Laundry Income                                 N/A
4944-10-00   Parking Income                                 N/A
4944-40-00   Commercial Communications Income               N/A
4944-50-00   Commercial Reimbursement Income                N/A
4945-00-00   NSF & Late Charges                             Based on 25 late per month@ $16.50 plus interest on carry ing balances
4947-00-00   Damages & Cleaning Charges                     N/A
4953-00-00   Tenant Screening Charges                       N/A
4955-00-00   Bad Debt Recovery                              N/A

                                                                         EXPENSES

                                                               Payroll - Administrative
5601-10-00   Manager Salary & Wages                         NCOA will cover 4 hours per week of Community Director
5601-20-00   Assistant Manager Salary & Wages               NCOA will cover 16 hours per week for Rent Collection, Late Fee Assessment/ Meeting Prep/Postings

5601-30-00   Leasing Consultant Salary & Wages              N/A
5601-40-00   Desk Help Salary & Wages                       N/A
5610-10-00   All Admin Pay roll Taxes                       Expense includes pay roll preparation fee, approximately 8.45% tax and Oregon State unemploy ment.

5611-10-00   All Admin Employ ee Benefits                   Includes prorated medical, dental, and life insurance premiums paid for employ ees.
5612-10-00   All Admin Workers Compensation                 Amount paid for private worker's compensation insurance.

                                                                   Payroll - Maintenance
5621-10-00   Maintenance Salary & Wages
5621-30-00   Groundskeeper Salary & Wages                   Wage amount is for 40 hours per week of common area maintenance, litter clean-up, and other
                                                            grounds work.
5621-40-00   Housekeeper Salary & Wages                     N/A
5621-50-00   Painter Salary & Wages                         N/A
5630-10-00   All Main Pay roll Taxes                        Expense includes pay roll preparation fee, approximately 8.45% tax and Oregon State unemploy ment.

5631-10-00   All Maint Employ ee Benefits                   Includes medical, dental, and life insurance premiums paid for maintenance employ ees.
5632-10-00   All Maint Workers Compensation                 Amount paid for private worker's compensation insurance for maintenance employ ees.

                                                                      Payroll - Other
5700-00-00   Temporary Help                                 N/A
5755-00-00   Employ ee Bonuses                              N/A
5760-00-00   Apartment Value Compensation                   N/A

                                                                 Administrative Expense
6030-20-00   Audit Expense                                  Financial review performed by TKW each y ear, along with State and Federal tax returns.
6035-30-00   Advertising                                    N/A
6055-09-00   Software                                       N/A
6043-00-00   Bad Debt Expense                               Based on current AR Balance to be written off over 12 months
6062-00-00   Courtesy Patrol/Protective Services            Professional security services for Christmas, (January ), Spring Break (April) and summer time (July -
                                                            October.)
6065-00-00   Dues and Membership                            N/A
6067-00-00   Equipment Rental - Office/Furniture            N/A
6068-00-00   Office Equipment/Furniture                     N/A
6069-00-00   Equipment Maintenance - Office                 N/A
6080-00-00   HAP Management Fee                             N/A
6084-00-00   Investor Service Fee                           N/A
6087-00-00   Legal Expense                                  $300 per month-Vial Fortheringham to issue liens, track foreclosures,advise Board
6088-00-00   LIHTC Assessment                               N/A
6088-10-00   OAHTC Admin Fee                                N/A
6093-00-00   Office Supplies\Postage\Printing               $100 for month mailing of notices plus paper, ink and refreshments when provided
6095-00-00   Other Administrative Expense                   N/A
6097-00-00   Other Professional Services                    $600 budgted for annual update of the reserve study and maintenance plan.
6105-00-00   Outside Management Fees                        Fee is calculated as $10 per private home in the NCOA
6108-00-00   General Partnership Admin Fee                  N/A
6120-03-00   Telephone\Answering Service\Pagers             N/A
6125-00-00   Tenant Screening                               N/A
6128-00-00   Employ ee Training                             N/A
6130-02-00   Mileage                                        N/A
6140-00-00   Trustee Fees                                   N/A
6141-00-00   Bond Remarketing Fee                           N/A

                                                                      Tenant Services
6210-70-00   Contract Tenant Services                       N/A
6210-80-00   Services - St. Francis                         N/A

                                                                         Utilities
6310-00-00   Water                                          Budget is based on the 2010 actual quarterly billings plus increase of 8%
6312-00-00   Electricity                                    N/A
6314-00-00   Gas                                            N/A
6320-00-00   Garbage                                        N/A
6321-00-00   Cable TV                                       N/A
6325-00-00   Sewer                                          N/A
6360-00-00   Turnover Utilities                             N/A

                                                                  Maintenance Materials
6420-08-00   Maint Mtrls- Furniture                         N/A
6420-20-00   Maint Mtrls - Cleaning                         Anticipated cleaning supplies needed for common areas, pocket parks, etc.
6420-25-00   Maint Mtrls - Electrical                       Anticipated amount is for bulbs and one visit by a vendor per month to replace common-area lighting
                                                            in pocket parks.
6420-33-00   Maint Mtrls - Fountain/Pool                    N/A
6420-40-00   Maint Mtrls - Hardware                         Small parts for common area repairs (bolts for park benches, locks for maintenance storage areas,
                                                            etc.)
6420-43-00   Maint Mtrls - Heating & Air Cond               N/A
6420-50-00   Maint Mtrls - Other                            N/A
6420-55-00   Maint Mtrls - Painting                         N/A
6420-60-00   Maint Mtrls - Plumbing                         N/A
6420-70-00   Maint Mtrls - Uniforms                         N/A
6420-75-00   Maint Mtrls - Landscape                        Small amount is budgeted monthly for flags and various sprinkler parts.
             Equipment/Products

                                                           Maintenance Contracts and Services                                                                        Advertising & Promotion   Advertising & Promotion   Advertising & Promotion
6430-05-00   Maint Contracts - Alarm                        N/A
6430-10-00   Maint Contracts - Appliance Repair             N/A
6430-14-00   Maint Contracts - Carpentry / Fence Repair     N/A
6430-15-00   Maint Contracts - Carpeting/Viny l Cleaning    N/A

6430-20-00   Maint Contracts - Drapery /Blind               N/A
             Clean/Replace
6430-22-00   Maint Contracts - Door/Window                  N/A
             Replacement & Repair
6430-25-00   Maint Contracts - Electrical                   N/A
6430-27-00   Maint Contracts - Elevator                     N/A
6430-29-00   Maint Contracts - Exterminating                N/A
6430-33-00   Maint Contracts - Fountain/Pool                N/A
6430-35-00   Maint Contracts - Fire Exting/Sprinklers       N/A
6430-40-00   Maint Contracts - Gutters                      N/A
6430-50-00   Maint Contracts - Heat & Air                   N/A
6430-55-00   Maint Contracts - Landscape                    Budget is based on anticipated Landscaping contract for 2011. 74% of common area maintenance is
                                                            paid for by NCOA
6430-56-00   Maint Contracts - Janitorial/Cleaning          N/A
6430-58-00   Maint Contracts - Misc.                        N/A
6430-64-00   Maint Contracts - Plumbing                     N/A
6430-80-00   Maint Contracts - Windows Cleaning             N/A

                                                                         Turnover                                                                                    Advertising & Promotion   Advertising & Promotion   Advertising & Promotion
6470-05-00   Turnover - Appliances Parts                    N/A
6470-15-00   Turnover - Carpet/Viny l Cleaning              N/A
             Contract/Supplies
6470-20-00   Turnover - Drapery /Blind Clean/Replace        N/A
6470-50-00   Turnover - Parts                               N/A
6470-54-00   Turnover - Painting Contract/Supplies          N/A
6470-56-00   Turnover - Cleaning Contract/Supplies          N/A
6470-66-00   Turnover - Resurfacing Contract                N/A

                                                                     General Expenses                                                                                Advertising & Promotion   Advertising & Promotion   Advertising & Promotion
6610-10-00   Insurance - General Liability & Property       Amount is based on 2010 actual. Policy effective Oct - September - projected 9% increase beginning
                                                            in Sept.
6610-50-00   Insurance - Errors & Omissions                 N/A
6622-00-00   Pay ments In Lieu Of Taxes                     N/A
6624-00-00   Misc. Taxes, Licenses, Permits                 N/A
6626-00-00   Property Taxes                                 $780 budgeted based on deeded common area for 2010 - this may be able to be appealed
6660-20-00   Interest Expense - Mortgage                    N/A
6660-30-00   Int Expense - Bond                             N/A
6660-40-00   Int Expense - Other                            N/A
6670-00-00   Depreciation Expense - Misc                    N/A
6675-00-00   Amortization Expense                           N/A
6681-00-00   Land Lease Expense (Hamilton West and          N/A
             New Columbia)
6731-20-00   Utility Allowance Reimbursement                N/A

                                                                  Non-Recurring Expenses                                                                             Advertising & Promotion   Advertising & Promotion   Advertising & Promotion
6910-01-00   Appliances                                     N/A
6910-02-00   Maintenance Equipment
6910-03-00   Office Equipment
6910-04-00   Exterior Building Improvements                 N/A
6910-05-00   Interior Building Improvements                 N/A
6910-06-00   Sy stem Building Improvements                  N/A
6910-07-00   Door and Window                                N/A
6910-09-00   Floor Coverings                                N/A
6910-10-00   Land Improvements                              N/A
6910-11-00   Paint Exterior                                 N/A
6910-12-00   Pavement & Walkway s                           N/A
6910-13-00   Roofing & Gutter Repair                        N/A

             Reserve deposits                               $74,000 for 2011 based on updated Reserve Study - $7.27 per unit, per month
Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion




Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion




Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion




Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion
Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion




Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion




Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion




Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion   Advertising & Promotion
                                                                               Chart of Accounts
Rental Income
4110-05-00 Apartment Rents                                 Residential Rent, whether paid by tenant, voucher, or RASP, etc. Includes site staff apartments at full value; see acct #5760-00-00 for staff
                                                           discounts.
4310-13-00 HUD Subsidy                                     Section 8 Subsidy at Rosenbaum, Unthank, Grace Peck, Multhomah Manor, Plaza, and St. Johns Woods.
4130-00-00 Commercial Rental Income                        Rent from commercial tenants incuding special needs organizations that rent space.
4199-00-00 Total Rental Income                             Total

Vacancies
4205-02-00 Apartment Vacancies                             Residential Rent loss for vacant apartments. Does not include Commercial vacancy.
4210-02-00 Rent Concessions                                Rent concessions for residential and commercial tenants. Recognized one-time, or spread over period of the lease. Also used to compensate
                                                           residents for disruptions to normal occupancy.
4229-00-00 Less Vacancies                                  Total
4299-00-00 Net Rental Income                               Total

Non-Rental Income
4820-00-00 Other Income                                    If all else fails…. Should not be used unless there is no other identified account.
4832-00-00 Interest Income - Bank Accounts                 Interest income earned on all bank accounts: Operating, security deposit, replacement reserves, etc.
4832-10-00 Interest Income - Bond Funds                    Interest income earned on funds held by a bond trustee
4913-00-00 Utility Allowance Revenue                       Utility assistance payments from HUD to be passed through to Tenants at Rosenbaum, Unthank, Grace Peck, Multnomah Manor, Plaza, and St.
                                                           Johns Woods. See acct #6731-20-00 for payment to tenants.
4914-00-00 Tenant Utility Income                           Direct utility rebill income from Tenants. (Sub-metering or RUBS - Ratio Utility Billing) For Civic and St Johns Woods only.
4942-00-00 Vending & Phone Income                          Vending and payphone receipts. Does not include commissions on telephone of cable contracts, see acct #4944-40-00.
4943-00-00 Laundry Income                                  Laundry Receipts.
4944-10-00 Parking Income                                  Rent on garage, parking space, inside parking structure, carports (if separate rentable item)
4944-40-00 Commercial Communications Income                Commissions on telephone, cable TV contracts, and cell phone tower contracts.
4944-50-00 Commercial Reimbursement Income                 Reimbursement from commercial tenants for owner-paid expenses: property taxes, utilities, etc.
4945-00-00 NSF & Late Charges                              Charges to tenants, residential or commercial, for late payment of rent or for NSF checks.
4947-00-00 Damages & Cleaning Charges                      Move out charges for damages in excess of ordinary wear and tear. Includes legal fees for evictions.
4953-00-00 Tenant Screening Charges                        Screening Charges collected from prospective tenants.
4955-00-00 Bad Debt Recovery                               Net receipts from collection agents on bad debt.
4989-00-00 Total Non-Rental Income                         Total
4999-00-00 Total Income                                    Total

Payroll
5601-10-00 Manager Salary & Wages                          Manager Salary and approved overtime only.
5601-20-00 Assistant Manager Salary & Wages                Assistant Manager Salary and approved overtime only.
5601-30-00 Leasing Consultant Salary & Wages               Leasing Agent salary and approved overtime only.
5601-40-00 Desk Help Salary & Wages                        Help Desk salary and approved overtime only.
5610-10-00 All Admin Payroll Taxes                         Payroll taxes for all Administrative employees (manager, assistant manager, leasing consultant, desk help)
5611-10-00 All Admin Employee Benefits                     Employee Insurance, retirement contributions, and other property-paid benefits.
5612-10-00 All Admin Workers Compensation                  Workers Comp for all Administrative employees (manager, assistant manager, leasing consultant, desk help)
5619-99-00 Total Outside Administrative Payroll Expenses   Total

5621-10-00 Maintenance Salary & Wages                      Maintenance and assistant maintenance staff salary and approved overtime only.
5621-30-00 Groundskeeper Salary & Wages                    Groundskeeper hired solely to maintain the landscaping and perform no other duties.
5621-40-00 Housekeeper Salary & Wages                      Housekeeper hired primarily to clean common area & units.
5621-50-00 Painter Salary & Wages                          Painter hired solely to paint and perform no other duties. Time spent painting by other employees does not fall into this category.
5630-10-00 All Main Payroll Taxes                          Payroll taxes for all Maintenance, groundskeeping, janitorial and painting employees.
5631-10-00 All Maint Employee Benefits                     Employee Insurance, retirement contributions, and other property-paid benefits.
5632-10-00 All Maint Workers Compensation                  Workers compensation for all Maintenance employees.
5639-99-00 Total Outside Maintenance Payroll Expenses      Total
5700-00-00 Temporary Help                        Charges for temporary staff.
5755-00-00 Employee Bonuses                      Employee bonuses or incentives. Must be pre-approved and budgeted.
5760-00-00 Apartment Value Compensation          All full or partial rent credits for site staff.
5999-00-00 Total Labor Expense                   Total


Administrative Expense
6030-20-00 Audit Expense                         Any charges by an outside auditing firm for financial audits. Does not include compliance audits.
6035-30-00 Advertising                           Any advertising, whether aimed at renting vacant units or hiring staff. This can include printed or electronic advertising. Includes helium tank
                                                 rentals & balloons, as well as A-board sign design.
6055-09-00 Software                              Licensing or purchase of software packages or renewing software maintenance contracts.
6043-00-00 Bad Debt Expense                      Used to write off unrecoverable tenant receivables as they are sent to collection agents.
6062-00-00 Courtesy Patrol/Protective Services   Professional security services or police officers under HAP contract.
6067-00-00 Equipment Rental - Office/Furniture   Copy machines, desk / chairs, if rented. Does not include maintenance equipment or model unit furniture rental.
6068-00-00 Office Equipment/Furniture            Purchased office equipment, including computer equipment, desks and chairs, file cabinets, book shelves, telephones, pages, two-way radios.
                                                 Note: individual items that cost over $150 should be coded to 6910-03-00.
6069-00-00 Equipment Maintenance - Office        Maintenance services for office equipment. Examples include copier maintenance or monthly copier maintenance contracts, computer equipment
                                                 repairs, fax machine repairs.
6080-00-00 HAP Management Fee                    Monthly payments to HAP as a management fee.
6084-00-00 Investor Service Fee                  Tax Credit properties only. Monthly accrual of annual Limited Partner fees.
6087-00-00 Legal Expense                         Legal fees, including FEDs.
6088-00-00 LIHTC Assessment                      Tax Credit properties only. Monthly accrual of annual fees to State of Oregon for tax credit monitoring.
6088-10-00 OAHTC Admin Fee                       Rockwood Landing and Gladstone. Monthly accrual of annual fees to State of Oregon for program monitoring.
6093-00-00 Office Supplies\Postage\Printing      Supplies purchased for administrative purposes. Examples include: pens, printer paper, office decorations, stamps, UPS, copy services,
                                                 business cards, newsletters, etc.
6095-00-00 Other Administrative Expense          Cost of forms, employee screening, tenant events, surveillance video tapes, Polaroid film or film developing.
6097-00-00 Other Professional Services           Administrative services performed by outside contractors such as ADP, hazardous materials inspection & testing firms, engineering studies, etc.

6105-00-00 Outside Management Fees               Monthly charges for management services performed by an outside property management firm.
6108-00-00 General Partnership Admin Fee         Tax Credits properties only. Monthly accrual of annual HAP General Partner fees.
6120-03-00 Telephone\Answering Service\Pagers    Monthly phone services. Includes answering services, cell phones, pager service, elevator emergency phone, internet, etc.
6125-00-00 Tenant Screening                      Screening charges from 3rd party screening agents.
6128-00-00 Employee Training                     Tuition and materials costs of attending pre-approved employee training. Includes meal not provided in training events
6130-02-00 Mileage                               Mileage and parking reimbursement.
6140-00-00 Trustee Fees                          Bond Trustee fees.
6199-00-00 Total Administrative Expense          Total

Tenant Services
6210-70-00 Contract Tenant Services              Payments to HAP for time spent by HAP Housing Services employees for tenant programs.
6210-80-00 Services - St. Francis                St Francis only. Payments to HAP as General Partner for services provided to tenants.
6299-00-00 Total Tenant Services                 Total

Utilities
6310-00-00 Water                                 Charges for water only. Sewer charges must be separated when bills involve both utilities.
6312-00-00 Electricity                           Residential and commercial electricity for common areas, office, etc, including occupied unit electricity if impounded in rent.
6314-00-00 Gas                                   Natural Gas only. Gasoline for maintenance is coded to account 6420-75-00.
6320-00-00 Garbage                               Standard service and additional unscheduled pickups/drop boxes.
6321-00-00 Cable TV                              For common area only.
6325-00-00 Sewer                                 Charges for sewer and stormwater management only. Water charges must be separated when bills involve both utilities.
6360-00-00 Turnover Utilities                    For period when unit is unoccupied only. For electric and gas utility bills.
6399-00-00 Total Utilities                       Total

Routine Maintenance
Maintenance Materials                                           Cost of materials, supplies, and expendable equipment used to maintain property with staff labor.
6420-08-00 Maint Mtrls- Furniture                               Purchase of common area (indoor and outdoor) furniture and apartment furnishings (beds, tables, chairs)
6420-20-00 Maint Mtrls - Cleaning                               Cleaning supplies, including vacuum bags or buffing pads, toilet paper, hand towels, etc.
6420-25-00 Maint Mtrls - Electrical                             Electrical fixtures, switches/plates, wire, ceiling fans, smoke alarms, etc. (Code light bulbs to 6420-40-00)
6420-33-00 Maint Mtrls - Fountain/Pool                          Any supplies specifically for fountains or swimming pools. Chemicals, vacuums, signs, etc.
6420-40-00 Maint Mtrls - Hardware                               Includes general hardware, window screens, locksets & keys, light bulbs, smoke detector batteries, electronic access cards.
6420-43-00 Maint Mtrls - Heating & Air Cond                     Supplies to maintain heating and air conditioning equipment and ductwork.
6420-50-00 Maint Mtrls - Other                                  If all else fails…. Includes signage for applications other than swimming pools.
6420-55-00 Maint Mtrls - Painting                               Paint, brushes, rollers, masking tape, sprayer nozzles, texture spray, ventilator masks, etc.
6420-60-00 Maint Mtrls - Plumbing                               Pipe, toilets and tanks, wax seals, faucets, sinks, disposals, etc.
6420-70-00 Maint Mtrls - Uniforms                               Maintenance shirts, photo name badges.
6420-75-00 Maint Mtrls - Landscape Equipment/Products           Equipment and fuel: leaf blowers, lawn mowers, hedge trimmers, pruning shears or saws, seed/fertilizer spreaders. Includes lawn chemicals,
                                                                fertilizer, pesticides, hoses, lawn sprinklers, flowers for outdoor gardens/planters, etc. Equipment greater than $1
6420-99-00 Total Maint Mtrls                                    Total

Maintenance Contracts & Services                                Costs of materials and labor incurred when maintenance duties are hired out to contractors/vendors. Staff labor is not included in
                                                                these accounts. Note: some major maintenance items may be coded to accounts in the 6910-01-00 through 6910-14-00 range. S

6430-05-00 Maint Contracts - Alarm                              Repair, maintenance and monitoring of fire alarm and security systems. Note: dedicated phone lines coded to 6120-03-00, "Telephone".
                                                                (Purchase and installation of new alarms coded to 6910-06-00.)
6430-10-00 Maint Contracts - Appliance Repair                   Repair of refrigerators, stoves, microwaves, dishwashers, laundry machines in units or common areas, etc.
6430-14-00 Maint Contracts - Carpentry/ Fence Repair            General carpentry, including drywall repair under $150. Major rehab should be coded to 6910-05-00. Code major fence repair or installation,
                                                                over $500, to 6910-04-00.
6430-15-00 Maint Contracts - Carpeting/Vinyl Cleaning           Cleaning, repair, dying, water extraction in office, common area or occupied units. Note: code turnover cleaning to 6470-15-00.
6430-20-00 Maint Contracts - Drapery/Blind Clean/Replace        Cleaning or replacement of window coverings in office, common area, or occupied units.
6430-22-00 Maint Contracts - Door/Window Replacement & Repair   Windows and entry/passage/closet doors in units, common area, office. Includes locksets and kickplates.
6430-25-00 Maint Contracts - Electrical                         Any minor work performed by an electrician, including installation of smoke detectors.
6430-27-00 Maint Contracts - Elevator                           Costs of repairing or maintaining an elevator, including monthly maintenance contract fees . Dedicated phone lines are not included in this
                                                                account. See account 6120-03-00, "Telephone/Answering Service/Pagers".
6430-29-00 Maint Contracts - Exterminating                      Any costs billed by a professional exterminator, regardless of scope of work.
6430-33-00 Maint Contracts - Fountain/Pool                      Any costs associated with repair or maintenance of swimming pools or fountains less than $500. Costs greater than $500 should be coded to
                                                                6910-04-00.
6430-35-00 Maint Contracts - Fire Exting/Sprinklers             Monitoring or recharging fire extinguishers, or repairs and maintenance of fire sprinkler system. Includes purchase of signage related to location
                                                                of fire extinguishers. Overhauls of a fire sprinkler system should be coded to 6910-06-00.
6430-40-00 Maint Contracts - Gutters                            Cleaning or minor maintenance of gutters. Purchase and installation of new gutters should be coded to account #6910-13-00.
6430-50-00 Maint Contracts - Heat & Air                         Repairs or maintenance of central heating or air conditioning systems. Note: repair or removal/installation of individual unit electrical heaters
                                                                (Cadet type) should be coded to 6430-25-00 "Maint Contracts - Electrical". Note: Building wide overhauls to
6430-55-00 Maint Contracts - Landscape                          Routine lawn care or lawn sprinkler maintenance or repair. Installation of new sprinkler systems should be coded to 6910-10-00.
6430-56-00 Maint Contracts - Janitorial/Cleaning                Cleaning services performed on common areas or offices. Repair or maintenance of cleaning equipment such as vacuums, floor buffers, etc.

6430-58-00 Maint Contracts - Misc.                              If all else fails…. Signage repairs under $150 or playground repairs under $500. Parking lot sweeping, Painting of Occupy Units
6430-64-00 Maint Contracts - Plumbing                           Any work performed by a plumber. Also includes gas line repairs or modification.
6430-80-00 Maint Contracts - Windows Cleaning                   Exterior or interior window cleaning by an outside contractor.
6430-99-00 Total Maint Contracts & Services                     Total


Turnover                                                        Any costs associated with repairs or cleaning necessary to prepare an apartment. Some turnover items of an extraordinary nature
                                                                may be coded to 6910-05-00. Note: any appliances that are replaced should be coded to account #6910-01-00. Note: if total

6470-05-00 Turnover - Appliances Parts                          Drip pans, range hoods, new power cords, ice trays, etc.
6470-15-00 Turnover - Carpet/Vinyl Cleaning Contract/Supplies   Services hired or supplies purchased to clean flooring, including cleaning fluid for carpet cleaning machines.
6470-20-00 Turnover - Drapery/Blind Clean/Replace               Cleaning or replacing window treatments.
6470-50-00 Turnover - Parts                                     If all else fails….
6470-54-00 Turnover - Painting Contract/Supplies                Services hired or supplies purchased to paint a unit being turned. Includes drop cloths, masking tape, rollers, brushes, paint, primer, texture
                                                                spray, etc.
6470-56-00 Turnover - Cleaning Contract/Supplies            Services hired or supplies purchased to clean a unit, other than cleaning flooring (see account #6470-15-00).
6470-66-00 Turnover - Resurfacing Contract                  Services hired to resurface tubs, showers, sinks, countertops, etc in a unit being turned.
6470-99-00 Total Turnover                                   Total
6499-00-00 Total Routine Maintenance and Turnover           Total

General Expenses
6610-10-00 Insurance - General Liability & Property         Accrual for insurance contracts for property, liability, or specific equipment items like boilers.
6610-50-00 Insurance - Errors & Omissions                   Accrual for insurance contracts for Errors & Omissions insurance.
6622-00-00 Payments In Lieu Of Taxes                        Monthly accrual of PILOT expenses. Applies to Rosenbaum, Unthank, Grace Peck, and Fairviews only.
6624-00-00 Misc. Taxes, Licenses, Permits                   Some examples would be business permits, elevator inspections and permits fees, swimming pool permits, A-Board sign permits, backflow
                                                            testing fees, boiler permits, fire & life safety inspections, etc.
6626-00-00 Property Taxes                                   Accrual of property taxes to be paid out at a future date for commercial spaces.
6660-20-00 Interest Expense - Mortgage                      Interest related to mortgage financing packages. Please consult with HAP accounting staff for amounts and timing.
6660-30-00 Int Expense - Bond                               Interest related to bond financing packages. Please consult with HAP accounting staff for amounts and timing.
6660-40-00 Int Expense - Other                              Interest related to other financing obligations. Please consult with HAP accounting staff for amounts and timing.
6670-00-00 Depreciation Expense - Misc                      Tax Credits properties only
6670-12-00 Depreciation Expense - Site Improvements         Depreciation of value in account #1612-00-00 only.
6670-20-00 Depreciation Expense - Dwelling Structures       Depreciation of value in account #1620-00-00 only.
6670-25-00 Depreciation Expense - Dwelling Equipment        Depreciation of value in account #1625-00-00 only.
6670-30-00 Depreciation Expense - Non Dwelling Structures   Depreciation of value in account #1630-00-00 only.
6670-35-00 Depreciation Expense - Non Dwelling Equipment    Depreciation of value in account #1635-00-00 only.
6675-00-00 Amortization Expense                             Amortization of various intangible assets. Please consult with HAP accounting staff for amounts and timing.
6681-00-00 Land Lease Expense                               Currently only Hamilton West
6731-20-00 Utility Allowance Reimbursement                  Payment to tenants of utility assistance payments from HUD to tenants at Rosenbaum, Unthank, Grace Peck, Multnomah Manor, Plaza, and St.
                                                            Johns Woods. See acct #4913-00-00 for receipt of payment from HUD.
6699-00-00 Total General Expenses                           Total

Non- Recurring Expenses
6910-01-00 Appliances                                       Any and all appliance replacement, including water heaters, for individual units or common areas. Parts or repairs should be coded to 6430-10-
                                                            00 or 6470-05-00.
6910-02-00 Maintenance Equipment                            Any tools or equipment that individually cost over $150.
6910-03-00 Office Equipment                                 Any office equipment from account #6068-00-00 that individually costs over $150.
6910-04-00 Exterior Building Improvements                   Examples include new siding or siding repairs, outdoor lighting projects, new fencing.
6910-05-00 Interior Building Improvements                   Remodeling or rehabilitation of units on a project basis exceeding $500 per unit. Also includes extraordinary Turnover (see turnover definitions
                                                            for extraordinary items).
6910-06-00 System Building Improvements                     Installation or building wide repairs or upgrades to cable TV wiring or roof top TV antennae, fire & life safety systems, intercoms, surveillance
                                                            equipment, electronic lock systems, heating & cooling systems, etc.
6910-07-00 Door and Window                                  Replacing front door, or multiple closet, bathroom or bedroom doors, etc, in a single unit, including new locksets if purchased as a set with the
                                                            doors. This account also includes all turnover window replacement.
6910-09-00 Floor Coverings                                  Replacement of all carpeting and vinyl in common areas or units.
6910-10-00 Land Improvements                                Non-capitalizable landscaping projects. Examples are installation of new lawn sprinkler system, tree removal projects, drainage landscaping
                                                            projects, garbage enclosures, car ports, etc.
6910-11-00 Paint Exterior                                   Major painting projects. Also includes signage projects. Signage repair should be coded to #6430-58-00. Small projects or single signs can be
                                                            coded to 6420-50-00.
6910-12-00 Pavement & Walkways                              Repairs, on a project basis, of sidewalks, parking lots, striping, and curbs.
6910-13-00 Roofing & Gutter Repair                          Purchase and Installation of new gutters, or major gutter repair projects, and roofing repairs.
6959-00-00 Total Non-Recurring Expense                      Total
8799-00-00 Total Expenses                                   Total
8999-00-00 Net Income                                       Total

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:5/15/2012
language:
pages:18
fanzhongqing fanzhongqing http://
About