Loading...
HomeMy WebLinkAbout2011-07-26 HRA AGENDA PACKETHOUSING & REDEVELOPMENT AUTHORITY AGENDA 7:OOPM Tuesday July 26, 2011 Parkview Villa Community Room A 965 40 "' AVE NE 1. Call to Order 2. Roll Call Tammera Diehm, Chair Bruce Nawrocki Bobby Williams, Vice Chair Donna Schmitt Gary Peterson, Secretary /Treasurer 1. Pledge of Allegiance CONSENT AGENDA 2. Approve Minutes of May 24, 2011 special meeting. 3. Approve Financial Report and payment of bills for the months of May and June 2011, Resolution 2011 -05, Motion: Move to approve consent agenda items as listed. BUSINESS ITEMS 4. Report of Management Company 5, Resident Council Minutes 6. Citizen Forum" 7. Other Business a. Update on Aeon Transaction The next regular HRA meeting will be Tuesday, October 25, 2011 at Parkview Villa. "At this time, citizens have an opportunity to discuss with the HRA items not on the regular agenda. The citizen is requested to limit their comments to five minutes. Please note the public may address the HRA regarding specific agenda items at the time the item is being discussed.) HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE SPECIAL MEETING OF May 24, 2011 1. Call to order— The meeting was called to order by Chair Diehm at 7:00 pm 2. Oath of Office- Irene Sufka could not be sworn in as she was not present at this meeting. 3. Roll Call — Members present: Bruce Nawrocki, Gary Peterson, Donna Schmitt, Tammera Diehm, and Bobby Williams. Staff Present: Executive Director -Walt Fehst, Community Development Director -Scott Clark, Assistant Community Development Director - Sheila Cartney, and Secretary - Shelley Hanson Parkview /CommonBond staff: Laura Sheak, Jennifer Eels, Laura Frost, and Lisa Wilcox - Erhart. 4. Pledge of Allegiance - Recited CONSENT AGENDA 5. Approve Minutes from January 25, 2011(regular and special meeting) and the special meeting of April 7, 2011. 6. Approve Financial Report and Payment of Bills for January, February, March and April 2011 on Resolution 2011 -03. Questions from members: There were no questions. Motion by Williams, seconded by Nawrocki, to approve the consent agenda items as listed and to adopt Resolution 2011 -03, Resolution of the Columbia heights Housing and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills for the months of January, February, March, and April 2011. All Ayes. MOTION PASSED. BRA RESOLUTION 2011 -03 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JANUARY, FEBRUARY, MARCH AND APRIL, 2011 AND PAYMENT OF BILLS FOR THE MONTHS OF JANUARY, FEBRUARY, MARCH, AND APRIL 2011. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (HRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the BRA to examine the statement and treasurer's vouchers or bills and if correct, to approve them by resolution and enter the resolution in its records; and HRA Minutes Page 2 May 24, 2011 WHEREAS, the financial statement for the months of January, February, March, and April of 2011 and the list of bills for the months January, February, March, and April 2011 are attached hereto and made a part of this resolution; and WHEREAS, the HRA has examined the financial statement and the list of bills and finds them to be acceptable as to both form and accuracy. NOW, TI3EREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that it has examined the attached financial statements and list of bills, which are attached hereto and made a part hereof, and they are found to be correct, as to form and content; and BE IT FURTHER RESOLVED the financial statements are acknowledged and received and the list of bills as presented in writing are approved for payment out of proper funds; and BE IT FURTHER RESOLVED this resolution and attachments are to be made a part of the permanent records of the Columbia Heights Housing & Redevelopment Authority. Passed this 24 ° i clay of May, 2011 7. Report of the Management Company Laura asked if there were any questions on the newsletter items or on the maintenance reports. Nawrocki asked what the status was for hiring an architect for the second floor remodeling. Lisa explained that CommonBond went to BWBR who has done the previous floors to see if they would adjust their price. They came back with the same fee as last year. So CommonBond put it out for bids which resulted in four companies bidding on the project. Two came in higher and one came in approximately $3,500 lower than BWBR. The contract has not been awarded yet since Lisa wanted to discuss this with the HRA Commission members. The low bidder was WAI Continuum. Staff has been reviewing the bids and she will do a "I -IUD scan" on the company also before proceeding to award the bid. She stated they have found BWBR very good to work with, but wanted feedback from the Board on whether they wanted to award the second floor to the low bidding company. Nawrocki stated if they are qualified, then the decision should be to go with the low bidder. Peterson said he felt comfortable going with the low bidder also since the scope of the project is basic updating that has already been defined. Schmitt asked if the HUD scan does show anything detrimental about the new company if we could just go back to BWBR without re- bidding. Lisa said yes, they would go back to BWBR and that the amount of this project for the architectural services is within CommonBond's limit for entering into a contract. HRA Minutes Page 3 May 24, 2011 Nawrocki then asked about the number of police calls recorded for April. He said the report indicated an increase that month. Laura stated that two of the calls were welfare checks on residents and a report was made on property damage, but the details of that are unknown. She also noted that police calls generally increase in the warmer months once residents have their windows open and call about noise coming from the Star Bar's bands. 8. Resident Council Minutes Rita Nelson reviewed the minutes from the Resident Council Meeting with HRA members. She also introduced the other officers of the current Resident Council and said things around the building seemed to have settled into place. 9. Citizen Forum Verne Harper -Unit 4408- asked if the building was for sale. Dielim explained that the City opened a dialogue with various companies to establish what interest there is for the possible sale of the buildings. She said they will be entering into a Memo of Understanding later in the meeting with Aeon to further explore this possibility. Diehm told residents that this is a complicated process due to many HUD requirements and the HRA wants to ensure the transition is as smooth as possible for the tenants. Perry Miller -Unit #803 -asked what the ramifications are for residents if the building is sold. Diehm said the Board set goals in the Memo of Understanding to limit the impact on residents. She reviewed them with the residents. She stated this a priority for the City and that the company they have chosen to partner with is in agreement with this goal. Lyn Miner -Unit #202 - Residents are concerned that they be kept informed as the process moves forward. They don't want to receive move out notices without prior warning. Diehm assured her that would not happen. She said this will be openly discussed at the meetings and that residents will be kept up to date. She encouraged residents to call staff or Board members with any questions or concerns. She reminded residents that rumors get started, and often times they are false, and she doesn't want any residents to get upset or panic about the process the City is exploring. Clark introduced Winifred Smith and James LehnhofT, representatives from Aeon, and explained they will be present at future meetings and also strive for a smooth transition if the ownership changes. I-Ie said it may take up to two years for this to be complete, but communication with the residents is a priority. Diane Powell -Unit 4905 -told members she had served on the entertainment committee for the building and had arranged for several outings that never happened because she couldn't get 90% vote to approve. She said it is because many residents don't come to the meetings and don't want to get involved, but that limits the entertainment options for those who do want planned activities. She asked for suggestions on how to change this. HRA MINUTES PAGE MAY 24, 2011 Nawrocki responded that is a Resident Council issue and that they may have to change the by -laws to possibly adjust the percent needed for approval or change the language to reflect that a majority of those present would decide. Diehm encouraged people to participate in activities in the building and also through the City's Senior Center. Barb Camp -Unit #608 - believes CommonBond has been very good managers and their staff is wonderful. She would like to see them kept on. Lois Pap -Unit #323 -asked who the residents make the rent checks out to. Diehm said nothing has changed, and they continue to make them out to the City of Columbia Heights. Ken Bloch -Unit 4315 -He said there will probably be more calls about the noise from the Star Bar now that it is warmer out. Clark said he will be in contact with the Police Chief and if this becomes a constant problem, staff will contact the owner since there is a mitigation plan in place with him. 10. Procurement Policy, Resolution 2011 -04 HUD has brought to our attention that "PHAs are required to establish and follow a written procurement policy that is consistent with 24 CFR 85.36" And furthermore, "The policy need not contain detailed working -level procedures, but should require establishment of such procedures to carry out the policy." HUD provided a sample procurement policy and sample supplemental forms that will ensure that the policies in the HRA procurement policy are followed in a consistent manner. Management staff has made the revisions to the HUD sample form that will be submitted to HUD for approval after a board resolution is passed. This is formalizing the procedures currently being followed as required by HUD. A copy of the proposed procurement policy and the supplemental forms were provided to members. Clark said the HRA attorney had reviewed the plan and found no issues with it. Questions from members: Schmitt asked about page 5- evaluation -she wanted to know who the evaluation committee was. Lisa said that refers to the management staff who make the initial evaluations of situations. She then asked about page 6- justification -who is responsible Contracting Officer? Lisa said that she would be the point of contact, but that Mr. Fehst would be the final signatory on any documents. Nawrocki commented on page 3- Adminstration Costs -he said he hopes there would be a savings in this category. Lisa told members that I -IUD had provided a sample policy and once this one was prepared, they reviewed it and suggested it be approved. This will fulfill the obligation as required. She further explained that the guidelines that we currently have in place will continue. This document is only a supplement to our present policies. HRA Minutes Page 5 May 24, 2011 Motion by Peterson, seconded by Williams, to move to waive the reading of Resolution 2011 -04, there being ample copies available to the public. All ayes. MOTION PASSED. Motion by Peterson, seconded by Williams, to move to approve Resolution 2011 -04, being a Resolution ofthe Columbia Heights Housing and RedevelopmentAuthority approving the HRA Procurement Policy dated May 24, 2011. HRA RESOLUTION 2011 -04 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY APPROVING THE PROCUREMENT POLICY Whereas, the City of Columbia I- (eights Housing and Redevelopment secures goods and services as part of its operation as a Public Housing Agency; and Whereas, the Department of Housing and Urban Development (I -IUD) , who provides operational subsidy to Parkview Villa North, seeks to memorialize a procurement policy per their established guidelines; and Whereas, past operations at Parkview Villa North have been consistent with these guidelines; and Whereas, in order to satisfy 1 -IUD's regulatory and policy requirements. Now Therefore Be It Resolved, The Columbia Heights Housing and Redevelopment Authority adopts a Procurement Policy dated May 24, 2011 and authorizes its submittal to the Department of Housing and Urban Development. Passed this 24th day of May, 2011. Motion by: Peterson Seconded by: Williams Ayes: All ayes Chair Secretary 11. Memorandum of Understanding between Aeon and City of Columbia Heights In 2010, the Housing and Redevelopment Authority gave staff direction to determine if there was private market interest for the purchase of Parkview Villa North and South. Interest was very limited since the dissolution of the PfIA status to Parkview Villa North is controlled by the Department of Housing and Urban Development, meaning a third party could negate an otherwise successful negotiation. In the end, two parties elected to answer a Request for Proposal that clearly spelled out the uncertainty of this transaction. HRA Minutes Page 6 May 24, 2011 On April 7, 2011 the HRA conducted interviews with the two firms that submitted a IUQ proposal, Aeon and CommonBond. After the interviews, there was unanimous consensus to partner with Aeon based on a number of considerations. The next step in this process is to mutually agree to a Memorandum of Understanding (MOU) that is attached for review and action by the Board. The MOU outlines the desired outcomes, establishes that each party is reasonable for their own costs, each party may terminate the process without cause and that there is no recourse for termination actions. Clark read the goals set by the Board that are included in the MOU as follows: 1. Maintaining the property as a strong vibrant senior community, 2. Protecting the existing rental price point for a particular period of time, 3. A long term convenant of maintaining the property as senior, 4. Need for the sale to be at a market price, 5. Maintaining a Columbia Heights residency priority Clark also assured those present that CommonBond will be retained as managers of this site and things will stay just as they are during this process. He recognized the fantastic job they have done since taking over as managers. If approved by the Board, the next step will be HRA staff and Aeon developing a master plan in terms of all of the necessary steps, processes, etc. necessary to complete this transaction. As part of this action, there is a second motion to appropriate $7,500 from the Parkview Villa South fund balance for the use of expert and professional services as commissioned by the I -IRA for the subject negotiations. As usual, all individual expenditures from this appropriation will be acted on as part of the monthly financial review. Staff is recommending approval of the Memorandum of Understanding as written. Questions from members: Nawrocki asked if the numbers discussed during the Executive Session were still confidential? Diehm stated they were. Nawrocki then went on to say he didn't want this to turn into a "make work" situation for staff. He doesn't believe this process will take two years or more to complete. He's concerned that the longer it goes on the harder it will be to get a fair value for the building. He addressed several issues such as the EMV of the building, the fund balances on the buildings, and the affect it will have on tenants to drag it out too long. Williams said he was satisfied with the terms of the Memo of Understanding and this is the first step in the process. Schmitt said not to put too much weight on the Estimated Market Value. It is only a figure. In reality, the building is only worth what someone is willing to pay for it. HRA Minutes Page 7 May 24, 201 l Peterson said we need to go to first base before we can go to second. This Memo of Understanding is necessary to gather information so decisions can be made for the sake of both parties. This doesn't lock either party into anything at this point. This is a step process, and we need to take the first step to see if it can be accomplished or not. Diehm agreed with Peterson. If it's a profit we're looking at, we could raise rents and make it a more lucrative deal, but the Board has already decided to protect the residents and maintain the rent structure as much as possible. Williams said that as stated in the Memo of Understanding, each party is responsible for their own costs, and that the Agreement can be terminated at any time by either party if it is deemed to be a non- workable deal. Therefore, there is no reason not to move forward with this agreement. Motion by Williams, seconded by Schmitt, to approve the Memorandum of Understanding between Aeon and the City of Columbia Heights housing and Redevelopment Authority dated May 24, 2011. All ayes. MOTION PASSED. Motion by Peterson, seconded by Schmitt, to approve an appropriation of $7,500 from the Parkview Villa South find balance (Fund 213) to be used for expert andprofessional services as part of the Aeon negotiations. All ayes. MOTION PASSED. MEMORANDUM OF UNDERSTANDING BETWEEN AEON AND THE CITY OF COLUMBIA HEIGHTS HOUSING AND REDEVLOPMENT AUTHORITY THIS MEMORANDUM OF UNDERSTANDING is made by and between AEON and the CI'T'Y OF COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY ( "HRA ") to outline the parties' understanding concerning their joint efforts to establish a process for the anticipated sale of two nmlti -unit residential housing facilities within the City of Columbia Heights subject to the express goals of the HRA. RECITALS WHEREAS, the HRA owns and oversees operations of Parkview Villa South and Parkview Villa North, which are attached multi -unit residential housing facilities located at 965 40 °i Avenue NE in Columbia Heights, Minnesota (collectively "the Subject Properties ") ; and WHEREAS, Parkview Villa South is a senior 45 -unit residential facility with a current minimum age requirement of 55; and WHEREAS, Parkview Villa North is a 9 story, 101 -unit residential Public Housing Agency ( "PHA ") facility; and WHEREAS, the HRA issued a Request for Qualifications and Interest ( "RFQ ") seeking established housing development entities, for profit or non- profit, that have the ability to perform the following as part of the sale of the Subject Properties: (1) technical expertise to partner with the FITLA in a submittal to the Department of Housing and Urban Development's ( "HUD ") Special Application Center for the dissolution of Parkview Villa North's PHA status; (2) demonstration of ability to obtain new financing for both facilities; and (3) meet and maintain the established goals of the I -IRA for the Subject Properties; and HRA Minutes Page 8 May 24, 2011 WHEREAS, the RFQ specifically identified the following goals of the HRA in connection with the sale of the Subject Properties: a) Maintaining the property as a strong vibrant senior community, b) Protecting the existing rental price point for a particular period of time C) A long term covenant of maintaining the property as senior d) Need for the sale to be at a market price e) Maintaining a Columbia Heights residency priority; and WHEREAS, the RFQ specifically advised applicants for consideration that the HRA retained the right to terminate the process until the signing of a purchase agreement, with no recourse against the HRA for time and /or materials expended in responding to the RFQ; and WHEREAS, on or about March 18, 2011, Aeon submitted a Statement of Qualification for the purchase of Parkview Villa South and North in response to the RFQ issued by the I -IRA; and WHEREAS, after due consideration of all the applicants in response to the RFQ, the HRA identified Aeon as a qualified party of interest for purchasing the Subject Properties subject to parties establishing a process for the sale of the Subject Properties consistent with the expressed goals of the HRA in the RFQ; and WHEREAS, the parties wish to enter into a Memorandum of Understanding which outlines the goals and expectation of each of the parties during the process leading up to the execution of a purchase agreement for the sale of the Subject Properties by the I IRA. NOW THEREFORE, parties agree and understand the following: 1. Subject to the termination provisions of paragraph 5, the parties will cooperate and exercise reasonable efforts in establishing a process and entering into a purchase agreement and any other related documents for the sale of the Subject Properties to Aeon, or an entity managed by Aeon, pursuant to the expressed goals of the HRA in the RFQ. In particular, Aeon will provide technical expertise to the HRA in connection with the submission for the dissolution of Parkview Villa North's PHA status through HUD's Special Application Center. 2. The parties will identify and pursue alternative means of financing for proposes of completing the sale of the Subject Properties pursuant to the 1 -IRA's expressed goals. 3. The I-IRA reserves the right to clarify, modify and /or add to its expressed goals and objectives to be achieved by the sale of the Subject Properties. Modifications and /or additions to the HRA's expressed goals resulting from the sale of the Subject Properties shall be communicated to Aeon in writing as soon as practicable. 4. Unless otherwise agreed in writing, each party to this Memorandum of Understanding shall be responsible for their own costs, time and materials expended in pursuing the parties' mutual interest in establishing a process for the eventual sale of the Subject Properties. 5. Upon written notice to the other party, either Aeon or the HRA may terminate this Memorandum of Understanding and cease all its efforts to establish and pursue a process for the eventual sale of the Subject Properties. Upon the termination of this Memorandum of Understanding, neither party will be entitled to receive or permitted to seek compensation from the other party for any time, materials or moneys expended in connection with their efforts for establishing and pursuing a process for the sale of the Subject Properties. I-IRA MINUTES Page 9 May 24, 2011 6. Aeon agrees to immediately report to the HRA any requests from third parties for information relating to this Memorandum of Understanding, or services provided hereunder. The HRA agrees to promptly respond to inquiries from Aeon concerning data requests. 7. Any notice authorized or required under this Memorandum of Understanding shall be in writing and shall be sent by certified mail to the other party as follows: To Aeon: To the HRA: Aeon City of Columbia Heights Attn: Alan Arthur Attn: Scott Clark 822 3" Street, Suite 300 590 40 ° i Avenue NE Minneapolis, MN 55415 Columbia Heights, MN 55428 8. This Memorandum of Understanding may be modified by mutual agreement of the parties in writing AEON By: Alan Arthur Its: President CITY OF COLUMBIA HEIGHTS HOUSING AND I2EDEVELOPMENT AUTHORITY By: Walt Fehst Its: Executive Director 12. Other Business The next regular HRA meeting is scheduled for July 26, 2011 at Parkview Villa. The meeting adjourned at 7:58 pm. Respectfully Submitted, Shelley Hanson Recording Secretary COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) Meeting of: July 26, 2011 AGENDA SECTION: Consent Agenda ORIGINATING EXECUTIVE NO: 3 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Financial Report and Payment of Bills BY: Laura Frost BY — Resolution 2011 -05 DATE: July 20, 2011 BACKGROUND: A copy of the Financial Reports for the months of May and June 2011 are attached. RECOMMENDATION: Management staff will be available to answer specific questions. If the report is satisfactorily complete, we recommend the Board take affirmative action to receive the Financial Report and approve the payment of bills. RECOMMENDED MOTION: MOTION: Move to waive the reading of Resolution 2011 -05, there being ample copies available to the public. Motion: Move to approve Resolution 2011 -05, Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills for the months of May and June 2011. Haammencs: HRA ACTION: HRA RESOLUTION 2011 -05 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR MAY AND JUNE OF 2011 AND PAYMENT OF BILLS FOR THE MONTHS OF MAY AND JUNE 2011. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (HRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the HRA to examine the statement and treasurer's vouchers or bills and if correct, to approve them by resolution and enter the resolution in its records; and WHEREAS, the financial statement for the months of May and June of 2011 and the list of bills for the months May and June 2011 are attached hereto and made a part of this resolution; and WHEREAS, the HRA has examined the financial statement and the list of bills and finds them to be acceptable as to both form and accuracy. NOW, THEREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that it has examined the attached financial statements and list of bills, which are attached hereto and made a part hereof, and they are found to be correct, as to form and content; and BE IT FURTHER RESOLVED the financial statements are acknowledged and received and the list of bills as presented in writing are approved for payment out of proper funds; and BE IT FURTHER RESOLVED this resolution and attachments are to be made a part of the permanent records of the Columbia Heights Housing & Redevelopment Authority. Passed this 26 day of July 2011 MOTION BY: SECONDED BY: AYES: Chair Attest by: Shelley Hanson, Secretary Jul. 20. 2011 1 :26PM Common$ond C Oat M UNIT If ® Years of Stnble domes & Snon,, Pnhires. July 20, 2011 Scott Clark Columbia heights HRA City of Columbia Heights 590 -40th Ave Northeast Columbia Heights MN 55421 RE: Columbia heights HRA Parkview Villa - Monthly Financials Reporting Date May 2011 Dear Ivlr. Clark, I enclose copies of the May 2011 financial reports for Parkview Vi➢a Nord /South. Included in the report: HRA Expenditures (Expense Summary) Financial Overview -PV(t North Budget Comparison -PW North Income Statement -PW North Balanee Sheet -PW North General ledger Detail -PV V North Aged Payables -PW North Check Register /Bank Reconciliation -PW North Financial Overview -PW South Budget Comparison -PW South Income Statement•PW South Balance Sheet -PW South General ledger -PW South Aged payables -PW South Check Register /Bank Reconcil ation -PW South Copies of all Invoices -PW North and South No.0479 P. 2 32d Kd1ogg Blvd w St. Rwl \t, i 55102 651- 291 -1750 651 -291 -1003 FAX www.commonbond.org Please feel free to contact me at 651 -310 -9278 if you should have any questions regarding this month's financial report S�hicceerel�y, e L% " c'° Laura Frost Regional Manager CommonBond Housing Jul. 20. 2011 1 :26PM 1Parkview Villa North Financial Statement Overview May 2011 Ytevenue: No. 0419 P. 3 Occupancy for the month of May 2011 was 100% occupied; there were no vacant units as of 5/31/2011. Total Revenue was under budgeted amount (unfavorable). No Grant Income was recognized in the month of May. All other revenue was over budgeted amount (favorable). Administrative Expenses: Administrative costs for the North are under budget (favorable), Other Renting ] Expenses were under budget (favorable), and reflect minimum applicant screening needed due to low turnover. Office Salary line shows the staffing portion for North per contract, both office and maintenance staff. Office Supply expenses are under budget (favorable). Legal Expenses Project was over budget (unfavorable), and reflects cost incurred for legal representation in resident lease termination process. Audit Expenses was under budget (favorable). Telephone, Answering Service and Internet expenses are under budget (unfavorable), and reflect costs associated with telephone, answering service, internet and office of enterprise technology, Had Debts reflect rent receivables that were written off from past residents that owed rent damages at the time of move out. Management has filed these with collections in an attempt to recapture these fees. Utilities: Utilities Expenses are under budget (favorable). Water / Sewer are quarterly billings; Gas and Electric are both under budget. Operating and Maintenance Expense (sunulies)• N Jul, 20, 2011 1 :27PM No. 0479 P. 4 Operating and Maintenance Expenses are over budget (unfavorable). Janitor and Cleaning Supplies are under budget (favorable). Janitor Contract expenses were under budget (favorable), and reflect cost associated with drain cleaning and floor cleaning. Exterminating Contract is over budget (unfavorable). Garbage and Trash are under budget (favorable); this reflects a quarterly billing. Security Contract is over budget (unfavorable), and reflects cost incurred for follow -up maintenance on fire extinguishers, phone entry repairs and panel repairs. Grounds Contract is over budget (unfavorable), and reflects cost incurred for grounds maintenance and for tree trimming. Repairs Material costs were under budget (favorable). Repairs Contract expenses were under budget (favorable), Elevator Maintenance Contract is over budget (unfavorable), and reflects the cost of monthly maintenance and major repairs including TorQmax drive and parts Decorating Contract and Supplies were under budget (favorable). I Jul, N. 2011 1;27PM Parkview vmd-num, tarot Balance Sheet May 2011 Books = Acctual Assets 10100 Cash Balance 10200 Pelty Cash 10400 1nve5UneAtS 11300 Rent Receivable 11500 Accounts Recevable 13200 Due From Olivet Government Unlls Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Total Liabilities Fund Balance 25300 Fund Balance Total Fund Balance Total Liabilities and Fund Balance No. 0479 P. 5 May -11 138,039.87 457.00 810,925.08 2,578.64 555.00 2,165.58 954,721.17 15,996.37 8,972.24 551.74 11,076.63 7,704.43 4,028.57 54,329.98 .. 900,39119 900,391.19 954,721,17 q Ju I. 20. 2011 1; 27PM No. 0479 Parkview Villa -North (165) Income Statement For The Period Ending May 2011 Banks = Accrual Month to Dale Year to Dare Revenue 1.47 1,215.92 0.81% 970.00 3.39% - 0100% 200.23 01000/4 33160-46330 Federal Grant 1.75% 344.31 1,20 1,576.28 36220-4633D Gen. Govemment Rents 27,393.00 95.64% 144,510.41 95.71% 36225 -46330 Noodwelling Rents 310A0 1.08% 1,503.00 1.OS% 3629016330 Other Miscellaneous Revenue 865.25 3.02% 4,224.91 2180% 3912046330 Recovery Damage City Property 75,00 0.26% 665,25 0.44% 15.05% 28,643.25 100.00 150,981.57 100.00 Total Revenue 1.32 0 /9 1,857.56 1.23% - Expenses 101.61 0.07% 1,829.58 639% Personal Services 5.94% 3,712,28 12.96% 15,523.63 300046330 Accrued Salaries 8,357.00 29.18% 41,785.DO 27.68% Total Personal Services 8,357.00 29.18 41,185.00 27.68 Supplies 2000-46330 Office Supplies 2010-46330 Minor Equipment 216046330 Malnt. & Construct Materials 2171-46330 General Supplies 228046330 Vehicle Parts Total Supplies Other Services & Charges 304046330 legal Fees 3050-46330 Expert and Professional Services 3060 -46330 Management Services 3100 -46330 Protective Services 3210 -46330 Telephone &Telegraph 343046330 Advertising Other 36OD-46330 insurance & Bonds 3810-46330 Electric 382046330 Water 3B30 Gas 384046330 Refuse 385046330 Sewer 9000.46330 Repair & Malnt. Services 41OD•46330 Rents & Leases 4300-46330 Miscellaneous charges 431546330 PILOT 9390.46330 Taxes & Licenses 450046330 Administrahve Expon$05 485D.46330 Interest on Deposits Total other Services & Charges 420.41 1.47 1,215.92 0.81% 970.00 3.39% 1,490,82 0.95% 200.23 0.73% 2,617.80 1.75% 344.31 1,20 1,576.28 1.04% 35.80 0.12% 35.80 0.02% 1,978.75 6.91 0 /0 6,916.70 4.58 0 /4 2,356.42 8.23% 4,305.42 2.90% O.OD 0.00% 0.00 0.00% 4,545.00 15.67% 22,725.00 15.05% 305.67 1.07% 3,855.85 2.55% 378.60 1.32 0 /9 1,857.56 1.23% - 0.0011. 101.61 0.07% 1,829.58 639% 8,972.24 5.94% 3,712,28 12.96% 15,523.63 30.28% 0.00 0.00% -49.94 -0.03% 4,167.76 14.55% 28,061.21 18.59% 113.16 0.40 3,533.26 2.34% 0.00 0.001/6 76.94 0.05% 4,204.71 19.68 49,945.37 33.08% 0.00 0.00% 318.67 0.21% 34.08 0.12% 75.58 0.05% 1,653.92 5.77% 8,269.60 5.40 0 /4 0.00 0,00% 1,403.38 0.93% 3438 0.12% 680.31 0.45% 13.17 0.05% 62.78 0.04% 23,346.53 81.51 149,198,47 99.22% I Jul. . 2011 1; 28PM Caplta vuu 2 a, 0 512046330 Ouiiding & Improvements Total Capital Outlay Total Expense Excess (beficit) Revenue over Expense No. 0479 P. 7 0. 00% 0.00% 0.00 0.00 0.00 0.00 33,664.20 117.60 198,500.17 131,47% - 5,041.03 - 17.60% - 47,518.60 - 31.47 up J I. 20. 2011 1; 28PM No. 0479 P. 8 Parkview Villa -North (165) Cash Flow Statement Period = May 2011 Book = Accrual Revenue 33160 Federal Grant 36220 Gen. Government Rents 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Expenses Personnel Services 1000 Accrued Salaries Total Personnel SorvlceS Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Malnt. & Construct Materials 2171 General Supplies 2280 Vehicle Parts Total Supplies Other Services It charges 3040 Legal Fees 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Elechic 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Malnt. Services 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits 5120 Building & Improvement Total Other Services & Charges Total Expenses excess (Deficit) Revenue over Expenses Adjustments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 20200 Accounts Payable 20210 Accrued Other Expenses 220DO Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Month to Date 0.00 27,393.00 310.00 665.25 75.00 28,643.25 8,357.00 8,357.00 420.41 970.00 208.23 344.31 35.80 1,970.75 2,356.42 4,545.00 305.67 378.60 0.00 1,829.58 3,712.28 0.00 4,167.76 113.16 0.00 4,204.71 0.00 34.08 1,653.92 0.00 34.18 13.17 23,348.53 33,684.28 - 5,041,03 1,826.00 43.OD 11,143.00 458.80 1,829.58 198.97 - 18,758.26 1,559.OD Jul, 20. 2011 1; 28PM No. 0419 P. 9 Parkview Villa -North (165) Cash Plow Statement Period = May 2011 Book = Acrrual Month to Date Total Adjustments (2,897.85) Cash Flow (7,930.88) beg Cash End Cash Differe 10100 Cash balance 145,978.75 138,039.87 (7,938.88) 10200 Petty Cash 457.00 457.00 10400 Investments 725,325.08 725,325.08 - Total Cash 871,760.83 863,821.95 (7,938.88) I Ju I. 20. 2011 1: 28PM No.0479 P. 10 6114120112:40 PM General Ledger (AtUthal) PAtltvl6W Villa -North - (165) Months: May 2012 propekty Dale Wind Description control Refer Debit Credit Balance Remarks 100 0 -4 6 33 0 Acwed Sahries 33,428.00 a Beglenlg Oalance= 165 S/31/201105111 (:Recur 339);P051Retumng M- riblf")'105558 RC 6,357.00 41,785.00 WC CHIC PR MOml fee NetChange= 8,357.00 41,785.00 a Ending Balance = 2000.46330 Office Supplies 79551 = BapimMB Balance= 16S 4/20/2011 05111 (p IDS) I3Wa Sheak P-230576 pcO42011 112.06 908.37 We, Photo finishhg 165 4RB1201105111 (1011101)l ffler Companies, Inc P- 276054 IZ41876M 149.81 1 canm coplee svc 4 1265125 165 412912011 OS111 (olfi) Office Depot P- 228616 562632Et11 55,38 1,113.56 mstebasket, paper etc. 165 5/17/201105111 (010) Office Depot P- 230575 S.64778E +11 01.26 1,194,83 enWom, battery etc. 165 5/261201105/11 (chc) CemmonBord Housing P- 229703 51930 8.60 1,20392 Poslage5111 165 5131/261105/11 (ncc) CwroanBond Housing P- 230013 51983 12.5D 1,215.92 Computer Support5/13 Hetcheow 420.41 1,215.94 = Ending Balance= 2010 -46330, Mina Equipment 470.02 = Beginning Balance 165 51101201105J12 (all) All Inc. P-RZ9069 5159656.001 472,50 943.32 fags -2/11421,512 165 5113/201105111 (all) All Inc. P- 229279 S1259965.001 491.50 1,440.82 Ing(1) -205 NetChange= 970,01) 1,440.02 = Ending Balance = 2160.40330, Malnt. BCanswn. Materials 2,9965 = OMWf11g Balance - 165 4/2012011 05111 (W1651i) Cum Shack P- 230576 PL041011 14.11 2,453.76 (Oar plates, patch repair 165 4/2912DII 05/11 (home7) HD Supply Facilities Mamkt P- 228614 91OW73177 16.03 2,469.79 and sockets 165 5/10/201105111 (home]) HD Supply FadBpes Malntena P- 229061 9100S3B139p7 155.98 2,625.77 rod socket, odml lot etc. 165 5/1712011 05/11 (KonMJ2) Horne Depot Credo Servlces P- 230572 0568772 22.11 2,647.88 seals, begs etc. N4IChenge= 208.23 2,647.08 = Ending Balance = 201-4633 General Supplies 1,231.97 - Beginning Balance = 165 4/20/20110$)11 (pet165h) Laum Sheak P- 230526 poD0011 27,87 1,259.84 My, 409 cleaner 165 4720/201185/11 (WIISSh) 14uro Sheak P- 230576 PrD4611 16.03 1,275.81 had 165 4120DIt 01711 (hopw7) HD Supply FaCIEDeS Malntena 1' 22805S 910022332Spv 106.65 1,382.52 tenets, gloves, Cash liners 165 512/20105111 (sher411(l) ShawimWiilm" CO, 11224615 40696 118.59 1,501.11 palm 165 5/6/20105111 (homa7) HD Supply Pa6Mk5 Malahma P- 229OS9 9108496465 11,54 1,512.65 plum 165 511aJ201105111 (hom32) Home Depot GeOit Ser+lOes P-230571 7320570M 63.63 1,576.28 hose, wpvwl etc, NetChange• 344.31 1,576.28 .Ending ealance = 2280 -46330 venkle, Parts 0.00 = Deg Balance. 165 41201201105/11 (110116510 faun Sheak P- 230576 PM2011 35.80 35.a0 lawn brat supplies NetChange= 35.80 35.60 = Ending Balance = 3040.46330 Legal Peen 2,0,29.00 - Beglmltg8ahnm= 165 412012011 05111 (Kenn) Ken" 5 Gann, Chartered P428298 C1.160.00064a 1,495.42 3,524.42 UD action- C2amch 165 5/24/2011 D5111 (keno) Kennedy & Graven, Chartered P-230569 10231910511 661.00 4,38542 legal - OM - OUNUC hcushg NetChange= 2,356.42 4,385.42 = Ending Be)adee e 3060.46330 Management Sennoes 16,180.00 - Beginnhg Bahnre= 165 y3112011 05111 (dc) Comf hWd Hogsing 0 52053 12,902.00 31,082.00 Mgmt Fees 5/11 16S 5/311201105/11 ( ;Reevr339):Posuwcurdng Monthly")- 105550 RC 8,357.00 22,725.00 R/C OHC PR Mont Fee NetChange= 4,545.00 22,725.00 = Ending Balaneg• 3100.46330 Protective Services 3,550.16 - Beglmmng Balance= 165 5151201105111 (situp) SiMPIV Gdnnea P429056 6GS754S4pan 305.67 3,855.85 2nd floor art detector cvc. NetC)ange- 305.67 3,055.05 = Ending Balance = 3110 -46330 Telephone It Telegraph 1,478.96 = &glmm�9 Balance = 165 511)201105/11 (answ) Answaali" LLC P- 226593 1.1885E+11 3Dd7 1,509.23 mmnc 5/11 155 5121201105111 (COM0601) CunICa$t P- 227403 0.77211E+11 44,02 1,554.05 Inkvnet svc 5 111 -6)10 165 50)2011 OS /LL (gwes9115) Qvrebt P429OSS 7639801978/0 35.77 1,592.82 phone WE 5/074/06 165 5/11/201105/11 (mcic1718) MCI COn3035eNKE P- 229283 7637883970/0 24.12 1,616.91 pbone svc 4 /193/06 165 5/18/201105111 (0(0650) OfAw of EnwpdmTechnDlo,P- 229205 2DOBON8710S 240.62 1,857.56 Phone sue - pa end 4/30 NetChange= 379.66 1,B57.55 = Ending Balance e 3430.46330 Mrerdsirg Direr 101,61 = Beginning Balance = NetChange =0.00 101.61 oEnding Balance = 3600 -46330 freamoce & Bonds 7,142.66 = BegrnNng Balance = 165 51311201105111 (:Raur 335):PosiRea Monthly")- 105558 RZ 1,829.50 0,972.24 Cof Columbla HetghU7n5Ae NetChange= 1,829.58 8,972.24 • Ending balance = Page 1 t Ju1.20, 2011 1:29PM No. 0479 P. 11 6/14/20112.48 PM General Leci (Accrual) Parkvlew VIIIB -Nouth - (165) Months: May 2011 Property Pale Period Description Control Relef Debit Credit Balance Remarks 3010 -4633D Electric 11,011.3$ = Ba0'n.6rg Balance = 165 51111201105111 (XC0 Xsel Energy P- 228455 515044155310 3,712.19 15,523.63 elm we 4105-5/07 Retchapgt= 3,71228 15,523.63 = Ending Balance= 3020 -46330 Water 449,94) = BegaginB Balance a NetChange =0.00 (49.94) =Ending BDIONC 3030.46330 Gas 23.893.45 - Beglnni g Balance = 165 S /512011 05111 (cem) CemerPalnl Energy P-227S66 55199657/051 4,167.76 28,061.21 Gas m 3/344/29 NetChange- 4,167.76 26,061,21 = Ending Balance= 3840.46330 Refuse 3,42010 = BegiMing Mime= 155 5/19/201105/11 (metrgM9) Metro App"Ne Mgc P- 230573 580431 113.16 3,533.26 Trash m 5/19 NetChange= 113.16 3,533.26 a Ending Balance = 38SO.46330 Sewer 76.94 a Begmnlrg Balance = Retchange- 0.00 76.94 . Ending Balance = 4000 -46330 Repair & Maid. Services 45,740.66 = Beginnng Balance = 165 4/8/201105/11 (0817740) Dunn King, Im P-220065 72327 252.00 45,992.66 pibo VC 9311,312, 102 165 4)2912011 05111 hbPm) LBP Megunkal, NC P-225052 W15512 197.50 46,190.16 Wall heaterm 4/11 165 41291201105111 (Ibpm) LOP Mechanical, Inc 0- 228053 W15520 1,559.02 47,74938 Wall healerm 4111 165 5/1/201105111 (eagil) Cagle Elevator Cory. P1226753 107351 -kry 655.40 48,404.56 prat mains 5111 165 5/41201105111 (dra11740) Omh King, IN P42B619 79894 123.00 48,527.50 Drain limn 1/04 165 51 (gardL086) Gardner Plumbing, LLC P-228062 2244 8000 40,601.50 obit s #908 165 5/ry201105111 (011m2138) All Metro Lam fit Snow, LL P-230574 160" 615.48 49,22306 Apnl lawn sere 165 $19/201105/11 (adarp) Allan's Pest Control, Ins. P- 729178 612646pm 48.97 49,272.03 Pest m5111 165 5 /10 /Mll D5111 (Cu315M4) c.nom AppharCe SCMIM L P- 229051 6890 6010 49,352.D3 Cempessor wo #512 165 $1151201105/11 (prad) Prada's Maintenance, Inc. P-219050 3896 294.59 49,696.62 floor m *205 165 5120/201105/11 (bpm) LOP Mechanical, IN 0.230570 W15620 29835 49,945.37 Plumbing we 99115 /11.5119 NetChange= 4,204.71 49,945.37 a Ending Balance = 4100 -45330 Regis & Leases 318.67 = SmInning Balance - NetChange =0.09 318.67 = Ending Botanic - 4300-46330 Mbcellanepus Charges 41.50 = Beglming Balance = 165 41287201105/11 (CW0054) City wide tmMMIUM19, Inc P228D66 129241 34.00 75.50 keys NctCban9e. 34.00 75.58 = Ending Balance = 4315.46330 PILOT 6,615.66 = 6e91nning Bala - 16S 5131720/1 05111 (: Recur 339) :PmiRennnng MmOty n]a05556 RC 1,653.92 0,269.60 Anoka Cry Nape y"Fox hw NetChange= 1,653.92 6,269.60 . [aging Balance = 4390.48330 TaM & LIcmW 1,403.30 = BeglM9,g Balance . NetChange= 0.00 1,40139 - Ending Balance = 4500 -46330 AdmiMsNehv4 &Penn 646.13 = 04ginnm9 Balance = 165 4120/201105/11 (saes) LOVM FAOX P- 228056 042011pcn 918 655.31 Mileage 4120 165 5/1.3201105111 (10004053)feck P-226744 05021IMn 25.00 680.31 Revnsal- contltrmvl duo BetOUnge -34.11 690.31 = EndingBalatim= 4150 -46330 Interest on Deposits 49.61 = Beginning Bala. = 165 5131/201105/11 S. Dap ideresl accrual 1. 105737 M1 13.17 67.78 Sec Del interest aroma NetChange. 13.17 62.71 = Eftlmg Balance = 42,041,28 8,357.00 Page 2 (V Jul. 20. 2011 1:29PM 5016456 Balance Per Bank Statement as of 05131/2011 09119/2006 297 10004005 - Grooms 02/0912011 1199 court325- Court Administration 02/092011 120D wurt325 - Court Adminlsimllon 051112011 1$12 t0004053- Fleck 05/1812011 131 gard1086 - Gardner Plumbing, LLC 0512512011 1328 odi - Office Depot 052512011 1330 gwes9115 - Owast 05/252011 1331 sher4110 - Sherwin- Williams Co. Less: Outstanding Checks Balance per GL as of 05/31/2011 Difference Cleared Items: Cleared Checks Date Tren N 04/27/2011 1204 04272011 1205 04272011 1288 04272011 1287 04272011 1286 04272011 1289 04272011 1200 04272011 1291 0427/2011 1292 04272011 1293 04272011 1294 04272011 1295 04272011 1298 04272011 1297 04/27/2011 1296 05/042011 1299 05/042011 1300 No. 0479 P. 12 Parkview Villa North Bank Reconciliation Report 05/31/2011 $138,832.61 100.00 55.00 320.00 25.00 60.00 65.36 36.77 110.59 812111 $792.74 $138,039.87 $136,039.87 $138,039.87 0.00 Reconciled Bank Balance Reconciled Balance Per GIL Notes Amount Dale Cleared bfbp- BFB Painting, Inc. 510.00 05/3112011 chc - CommonSond Housing 6,25 0513112011 ciss - CLS Services, LLC 214.25 05/3112011 colu - City of Columbia Heighls 3,553.08 0513112011 cumm - Cummins NPowor LLC 1,015.60 05/312011 homa32- Home Depot Credit Services 116.84 05131/2011 lerrl- Jerry's Floor Store 506.05 05/31/2011 Ibpm - LBP Mechanical, Inc 6,758.58 051312011 Itgh3326 - Lighting Plastics of MN INC 134.10 0513112011 mcic3718 - MCI Comm Seryloo 19.49 0513112011 parkl - Park Supply of Amorka, Inc. 225.10 05/3112011 gwes9115 -Owest 38.77 051312011 ryco - Ryce Supply company 59.49 05/312011 stc1604 - SI Cloud Refligorallon 541.15 05/312011 xmi - Xcel Energy 3,300.28 05/3112011 adam - Adam's Pest Control, Inc. 177.02 05/31/2011 chc - Commonaond Housing 12,936.38 06/31/2011 Jul, 20. 2011 1:30PM. 5016456 Parkview Villa North Bank Reconciliation Report 05131!2011 No. 0479 P. 13 612/11 0510412011 1301 cue15044 - Cuslom Appliance Sorvioo LLC 200.00 0513112011 05/0412011 1302 dr817740 - Drain King, Inc. 177.00 05/31/2011 05/0412011 1303 home32 - Home Depot Credit Services 31.64 05/31/2011 0510412011 1304 Ingsp - MGS Professional Bldg Metal Sow mo 274.29 05/31/2011 05/0411011 1305 na1 11035 - National Automatic Sprinkler Cc 880.00 05131/2011 05/042011 1308 offi658 - Office of Enterprise Technology 244.15 05131/2011 0510412011 1307 taxa - Anoka Courtly _ 20,412.18 0513112011 05/11/2011 1308 anew - AnsweiLlve LLC 30.27 05/3112011 05/112011 1309 ous15044 - Custom Appliance Service LLC 192.09 05/3112011 05/112011 1310 eagll - Engle Elevator Carp. 655.40 05/3112011 05/112011 1311 lerri - Jerry's door Store 425.00 05131/2011 OS /1812011 1313 cent- Cr101erpolm Energy 4,187,70 05/31/2011 05/1812011 1314 c1ty4054 - City Wits Looksmlthing, Inc. 34.08 05/31/2011 0511812011 1315 COMC3001 - Comcasl 44.82 05/31/2011 05110/2011 1316 dra17740 - Drain King, Inc. 252.00 05131/2011 05/10/2011 1318 home7 - HD Supply Facilities Maintenance 106.65 0513112011 05/1812011 1319 kenn - Kennedy& Graven, Chartered 1,495.42 '05131/2011 05/1812011 1320 Ibpm- LOP Mechanical, Inc 1,758.52 05/3112011 05/1812011 1321 Io01101- LaMar Companies, Inc 149.81 0513112011 05118/2011 1322 shoe - Laura Shook ' - 9,18 05/3112011 05118/2011 1323 10003092 - Honeyrord 23714 05/3112011 052512011 1324 all - A9Inc. 472.50 05/31/2011 05252011 1325 cus15044 - Custom Appliance Service LLC 80.00 05/31/2011 05252011 1326 dra17740 -Drain King, Inc. 123.00 05!31/2011 05252011 1327 homa7 - HD Supply Facilities Maintenance 183.55 .:06/31/2011 05252011 1329 prod - Pmda's Maintenance, Inc. 294.59 05/31/2011 05/2512011 1332 simp - Simplex Grinnell 305.67 0513MOl l 0512512011 1333 xcel -Xcel Energy - 3,712.28 05/31/2011 Total $67,140.12 Cleared Deposits Data Tram 1t Notes Amount Dale Cleared 05102/2011 288 operating awl 9,771.00 05131/2011 05/0512011 289 370.00 05/312011 05/0512011 289 rent deposits' 13,621.00 05 05106/2011 290 operating 516111 3,907.00 051312011 . 05/102011 291 rent deposits 1 0513112011 05/132011 297 rent deposit 261.00 058112011 DSM012011 202 refit deposit 884.00 05812011 05/172011 203 rani deposit 805.00 051312011 05262011 298 laundry receipt 367.25 05/312011 Total $31,296.25 Cleared Other Items Date Tian is 05/05/2011 JE 105736 Total Notes NE13 Oper Subsidy receipl Amount Dale Cleared 11,143.00 058112011 $11,143,00 (2 Jul. 20. 2011 1:30PM Northeast B ank Member FDIC No. 0479 P. 14 Date 5/31/11 Page 1 Primary Account Ending 6456 Enclosures 52 77 Broadway SL N.E., Minneapolis, MN 55413 612 - 370.88 •24 hour telephone banking 651.626 -0807 - Visit OW wabslta al www, norlheaslbank- mn.com k %c *nc** * * * *b* *AUTO * *3 -DIGIT 551 732 1.1660 AT 0,490 6 1 12 HRA OF COLUMBIA HEIGHTS PARKVI£W VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG 'BLVD WEST ST PAUL MN 55102 --1900 1111611111111 ....1,II G A C C O U N T .S -- EFFECTIVE JULY 15, 2011, NON- SUFFICIENT FUNDS PAID ITEM FEES AND NON - SUFFICIENT FUNDS RETURNED ITEM FEES WILL INCREASE TO $30 PER ITEM, MEMBER FDIC NORTHEAST PUBLIC FUNDS ACCT Account Number Previous Balance 9 Deposits /credits 45 checks /Debits Service Charge Interest Paid Ending Balance Number of Images 52 Ending @+W Statement Dates 5/01/11 thru 5/31/11 163,533..48 Days in the statement Period 31 42,439.25 Average Ledger 159,605 67,140.12 Average collected 158,685 ,00 ,00 138,832.61 Deposits and Credits Date Description Amount 5102 DDA REGULAR DEPOSIT 9,771,00 5/05 m1sc PAY HUD TREAS 303 11,143.00 CR 5/09 3031036218 05/05/11 541,75 5/04 ID #- 000009646860103 116.84 5/04 TRACE #- 031036210495590 510.00 5 /05 DDA REGULAR DEPOSIT 13 ,991.00 °— 5/09 DDA REGULAR DEPOSIT 3,907.00 5/10 DDA REGULAR DEPOSIT 1,530.00 5/16 DDA REGULAR DEPOSIT 864.00 S /17 DDA REGULAR DEPOSIT 605.00 5/26 Xfer from PUB FUND 0002 261.00 5/26 DDA REGULAR DEPOSIT . 367,25 Checks in serial order Date Check# Amount Date Check# Amount 5/09 95 541,75 5/04 1289 116.84 5/04 1284* 510.00 5/03 1290 506.05 5/02 1285 6.25 S /03 1291 6,758.68 5/04 1286 214.25 5/06 1292 134.10 5/03 1287 3,553.06 5/06 1293 19,49 5/03 1288 1,015.60 5/04 1294 225.10 * indicates skip in check numbers_ 760958 - 541 I1� Jul. 20. 2011 1:31PM J& Northeast 1_)(lllk No. 0419 P. 15 Date 5/31/11 Page 2 Primary Account Ending 64" Enclosures 5. NORTHEAST PUBLIC FUNDS ACCT Ending 44" (continued) checks Date in serial order Check# Amount Date check# Amount 5/04 1295 38.77 5/25 1314 34.08 5/03 1296 59.49 5/26 1315 44.82 5/03 1298* 3,380.28 5/26 1316 252,00 S /09 1299 177.02 5/25 1318" 146.65 5/06 1300 12,936.38 5/24 1319 1,495.42 5/16 1301 200.00 5/27 1320 1,756.52 5/20 1302 177.00 5/24 1321 149.81 5/10 1303 31.64 5125 1322 9.18 5/19 1304 274.29 5/31 1323 237.14 5/11 1305 880.00 5/27 1324 472.50 5112 1306 244.15 5/31 1325 80.00 5/18 1307 20,412.18 5/31 1326 123.00 S/18 1308 30.27 5/31 1327 183.55 5 13 655.40 5/3 1332* 305.67 5/17 1311 425.00 5/27 1333 3,712.28 5/25 1313 4,167,76 * indicates skip in check numbers _........ *bb kfi.fifi.b:,- A *:t *x*a*WWtW WWaaaWWlraxWaaxaxbaxaxxx baaaxabbaaababaabbabdbbdbb Daily Date Balance section Balance Date Balance Date Balance S /01 163,533.48 5/10 173,650,71 5120 151,821.42 5/02 173,298.23 5/11 172,770.71 5/24 150,176.19 5/03 158,025.05 5/12 172,526.56 5/25 145,666.43 5/04 156,920.09 5/16 173,190.56 5/26 145,997.86 5/05 182,054.09 5/17 172,715.16 5/27 140,056.56 5/06 168,964.12 5 /18 152,272.71 5/31 138,832,61 5/09 172,15235 5/19 151,998.42 * ** E N D O F S T A T E M E N T ° 760958 - 547 Jul, 20. 2011 1:31PM No. 0419 P. 16 Payment Summary Bank= 165Dpr ANO mm /yy -05 /2011. 05/2011 AND All CheckS =Yes AND Include Voids =All Checks 50,378.13 J/ Check Post Total Bank Check# Vendor Date MoNh Amount �� 165opr , Parkview Villa North ...,.u,.. 1199 m adam�Adam's Pest Control, Inc. �5/04J201 i 05/2017 177.112 165opr - Parkview Villa North 1300 chc - Commonflond Housing 05/0412011 05/2011 12,936.3B 1650pr - Parkview Villa North 1301 dust3044 - Custom Appliance Service LLC 05/04/2011 05/2011 200.00 1650pr - Parkview Villa North 1302 dral7740 - Drain King, Inc. 05/04/2011 05/2011 177.00 165opr - Parkview Villa North 1303 home32 - Home Depot Credit Services 05/04/2011 05/2011 31.64 1650pr - Parkview Villa North 1304 mgsp - MGS Professional Bldg Maint Sew Inc 05/04/2011 05/2011 274.29 1650pr - Parkview Villa North 1305 nat1103S - National Automatic Sprinkler Cc 05/04/2011 05/2011 880.00 165opr - Parkview Villa North 1306 of0658 - Office of Enterprise Technology 05/04/2011 05/2011 244.15 1650pr - Parkview Villa North 1307 Over - Anoka County 05/04/2011 05/2011 20,412.18 1650pr Parkview Villa North 1308 answ - AnSWen LLC 05/11 /2011 05/2011 30.27 165opr - Parkview Villa North 1309 custSO44 - Custom Appliance Sevice LLC 05/11/2011 0512011 192.09 165opr - Parkview Villa North 1310 eagll - Eagle Elevator Corp. 05/11/2011 05/2011 655.40 165opr - Parkview Villa North 1311 1err1 - lefty's Floor Store OS/11/2011 05/2011 425.00 165opr - Parkview Villa North 1312 t0D04053 - Fleck 05/11/2011 05/2011 25.00 1650pr - Parkview Villa North 1313 cent - CenlerPoint Energy 05/1812011 05/2011 4,167.76 165opr - Parkview Villa North 1314 cay4054 - City Wide LOCksrnllhin9, Inc. 05/18/2011 05/2011 34.08 1650pr - Parkview Villa North 1315 COMC3001 - Comeast 05/18/2011 0512011 44.82 165opr - Parkview Villa North 1316 dral7790 - Drain King, Inc. 05/19/2011 05/2011 252.00 165opr - Parkview Villa North 1317 gardIO86 - Gardner PlUmbing, LLC 05/18/2011 0512011 80.00 165opr - Parkvlew Villa North 1318 home? - HD Supply Faeilithi; Maintenance 05/18/2011 05/2011 106.65 165opr - Parkview Villa North 1319 kern - Kennedy A, Graven, Chartered 05/18/2011 05/2011 ,1,495.42 165opr - Parkvlew Villa North 1320 Ihpm - LBP Mechanical, Inc 05/10/2011 05/2011 1,756.52 165opr - Parkview Villa North 1321 Iof1II01 • LofOer Companies, Inc 05/18/2011 05/2011 149.81 165opr- Parkvlew Villa North 1322 shea - Laura Shack 05 /lO /2011 0512011 ,9118 165opr- Parkvlew Villa North 1323 t0003992- Heneyford 0611912011 0512011 237,14 165opr- Parkvlew Villa North 1324 all- All Inc. 05/25/2011 05/2011 472.50 165opr - Parkvlew Villa North 1325 custSO44 . Custom Appliance Service LLC 05/25/2011 05/2011 80.00 165opr- Parkvlew Villa North 1326 dra17740 - Drain King, Inc. 05/25/2011 05/2011 123.00 1650pr - Parkvlev Villa North 1327 home? - HO Supply Facilities Maintenance 05/2512011 05/2011 183.55 165opr - Parkview Villa Nora 1328 riff - Office Depot 05/25/2011 05/2011 55.30 165opr- Parkvlew Villa North 1329 prad - Prada's Maintenance, Inc. 05/25/2011 05/2011 294,59 165ODr - Parkvlew Villa North 1330 gW0591IS - Qwest 05/25/2011 05/2011 39.77 165otir - Parkvlew VOta North 1331 sher4l t0 - Sherwin - Williams Co. 05/25/2011 05/2011 118.59 165opr - Parkvlew Vita North 1332 sump - Simplex Grinnell 05/25/2011 05/2011 305.67 165opr - Parkvlew Villa North 1333 xcel - xcel Energy 05125/2011 05/2011 3,712,20 50,378.13 J/ c m o w e m W W I Q a S 6f c tO W O a m =, y c m o w e m I Q maa m 6f -.moo tO W O a m =, y Nw 3 e A W a ib — N S 0 v fn oOOI WU my o�im ri ooamvi m 3 F N 2 PO< I m w o n N F m < n_ g c 1 d www _i mow Ipgl' N 10 V I A O A I Q m A0A VAN tO W O a ' y o J O N e A W a NiT+ A O m oo 0 d0 oOOI Al0 o�im ri ooamvi 1 d www _i mow Ipgl' N 10 V I A O a a c m N N W — O D { � � O W N F W o v � N N y �C d 0 i i �Allir -i iin7 'n7,inr W c I Q m A0A VAN tO W O m ' 0 o J O N p�D O f1�o+no 0 O A A O m oo 0 a a c m N N W — O D { � � O W N F W o v � N N y �C d 0 i i �Allir -i iin7 'n7,inr to m po N N A N� N N� rn p�D O f1�o+no A ppp� oo mco d0 oOOI Al0 a a c m N N W — O D { � � O W N F W o v � N N y �C d 0 i i �Allir -i iin7 'n7,inr Jul 20, 2011 1:32PM No. C @ � Fawn'$@ 3 � �lak � fill a�gIDi ggp� gpa� �M W Ea + hh PP �S NOPOm �AOSo HG�SN g ynv N }A C UU o k �hh y Q iNN t 6 WP4 hid W�OOONNOOOU��� 8�1F866,'�888868�m y, m e N q � q w & O N�NUOOOONO 8 W8 $8ti °mn; e��000��o °e��wo 6_lsssaNss6s�'s�w NCO NAB N Hn�g�.�°o'>; AA o y g ibo p OO b b ` B `pp b m' i t p1 .�OOOOOYtlOWOUd N� 0000000�oaogooa e�L IJON m �iN �S�B g6s m � 9 �a8 419 P. 18 .e8w X38 R R � N ID G y � O N n py p�q 5 � �OMDC l.�le m o ll o JJ �Pi my G Cts� 6's W�OOONNOOOU��� 8�1F866,'�888868�m y, m e N q � q w & O N�NUOOOONO 8 W8 $8ti °mn; e��000��o °e��wo 6_lsssaNss6s�'s�w NCO NAB N Hn�g�.�°o'>; AA o y g ibo p OO b b ` B `pp b m' i t p1 .�OOOOOYtlOWOUd N� 0000000�oaogooa e�L IJON m �iN �S�B g6s m � 9 �a8 419 P. 18 11 N y p NO my G Cts� 6's W >: 8y x 9 P F3N W N iffi°o Poi4 a ' � 38$8 80 ° o � 11 Jul, 20. 2011 112PM Y .l5 ���ppp ey • � m 4 i mm� -- Q�1} p�6 yE MMI aa @@ F r A g g rr 8d 53a 8� m N b I N I A 0 N B Ir 8� o A a S w I o ms �' tl 8� No. 0419 P. 19 5 5 ��rr w a N N O {? y aRoM�M�A. �m lS NwR Ud' }:8800�dm8H68em +�8kEn &�8i !cc N s� Wu° m °�� wii ° ° ° oo ° 88$Bln ° o ueH }n6 ° w ° o o N -A 6fp+ �NBBgkLoo8u�B8GNNmkk I �i$aiiwg��$�N i68��s�k 'I pp �} yy{ m 77 ryry JJ �� {W u � ,�N U pwp�� NSeO1Sr6i u PAH y'. �v w�y oT' ��sS�o`o�sk$w�'ok'& &9� (n p, NN q / 1 w p y t. P ONO O°T.{.�NA H L§g 888a8Mkkk88kk 8$$882 41 jj(( . $$ N QQ Sl N J g y p , N OU�pW G� (p y�'i oo o abbb k',HP8�8�6i�dH�b1o, Olt Dvbnyw$ + y $i ° oNBy�ODyy I LL �y ��N p ,mope ° o >bOOO ° o i56$ao�o u88 $ ° o ° °k�B8H8o ° 00$888 ° ° ° w ° o IiI J 1.20. 2011 1; 32PM No. 0479 P. 20 4 p I 6 E m � in ,u > y 7 V 5 5 s, mE u I Jul.20. 2011 1:33PM No. 0479 P. 21 Parkview Villa South Financial Statement Overview May 2011 Revenue: Occupancy for the month of May 2011 was 100% occupied; there were no vacant units as of 5/3112011. Total Revenue was over budgeted amount (favorable). Administrative Expenses:. Administrative costs for the South are under budget (favorable). Other Renting Expenses were slightly over budget (unfavorable), and reflect applicant screening costs Office Salary line shows the staffing portion for North per contract, both office and maintenance staff. Office Supply expenses are under budget (favorable). Legal Expenses Project was under budget (favorable), and reflects cost incurred for legal representation in resident lease termination process. Audit Expenses was under budget (favorable), Telephone, Answering Service and Internet expenses are under budget (unfavorable), and reflect costs associated with telephone, answering service, internet and office of enterprise technology. Had Debts reflect rent receivables that were written off from past residents that owed rent damages at the time of move out. Management has filed these with collections in an attempt to recapture these fees. Utilities: Utilities Expenses are under budget (favorable). Water / Sewer are quarterly billings; Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses are slightly over budget (unfavorable). RM Ia�J Ju1.20. 2011 1:33PM No.0479 P. 22 Janitor and Cleaning Supplies are under budget (favorable). Janitor Contract expenses were under budget (favorable), and reflect cost associated with drain cleaning and floor cleaning. Exterminating Contract is under budget (favorable). Garbage and Trash are over budget (unfavorable); this reflects a quarterly billing. Security Contract is over budget (unfavorable), and reflects cost incurred for Panel system repairs and main power supply Grounds Contract is over budget (unfavorable), and reflects cost incurred for grounds maintenance and for tree trimming. Repairs Material costs were under budget (favorable). Repairs Contract expenses were under budget (favorable). Elevator Maintenance Contract is slightly over budget (unfavorable), and reflects the cost of monthly maintenance Decorating Contract and Supplies were over budget (unfavorable) and reflect cost of unit turnovers. V Jul, 20. 2011 11 33PM No. 0479 P. 23 Balance Sheet May 2011 Books = Accrual may-11 Assets 11,053.94 20210 Accrued Other Expenses 83,731.74 10100 Cash Balance 9,253.42 10200 Petty Cash 93.00 22210 Revenue Collected 'n Advance 567,570.36 10400 Investments 31,632.97 11300 Rent Receivable 61'77 11500 Accounts Receivable 0.00 Total Assets 651,456.87 Llabllllles 20200 Accounts Payable 11,053.94 20210 Accrued Other Expenses 4,214.00 22.000 Deposits 9,253.42 22200 Accrued PILOT 4,679.44 22210 Revenue Collected 'n Advance 2,431.67 Total Liabilities 31,632.97 Fund Balance 25300 Fund Balance 619,823.90 Total Fund Balance 619,823.90 Total Liabilities and fund Balance 651,456.87 Jul 20. 2011 1:33PM No. 0479 P. 24 Pavkvte Income Statement For The Period Ending May 2011 8onks 4 Accntal north to onto % Year to Dale % Revenue 177.41 0.68% 567.26 0.43% 3622046340 Gen. Government Rents 25,150.33 95.81 126,433.81 96.35% 36225.46340 Nondwelling Rents 465.00 1.77% 2,387.00 1.82 0 10 36290 - 46340 Other Miscellaneous Revenue 636.25 2.42% 2,408.25 1.84% Total Revenue 26,251,58 100.00 131,229.06 100.00 Expenses Personal Services 100046340 Accrued Salaries 3,723.00 14.18% 18,615.00 14.19% Total Personal Services 3,723.00 14.10 18,615.00 14.19% Supplies 2000-46340 Office Supplies 177.41 0.68% 567.26 0.43% 2010 -46340 Minor Equipment 1,367.50 5.21% 2,621.55 2.00 6 /0 216046340 Malnt. & Construct Materlals 243.56 0.93% 561.09 0.44% 2171 -46340 General Supplies 147.10 0.56% 329.33 0.25% Total Supplies 1,935.67 7.37 4,099.23 3.12% Other services & charges 3040-46340 Legal Fees 0.00 0.00% 0.00 0.00% 305046340 Expert BE Professional Services 0.00 0.00 0.00 0.00% 3060-46340 Management Services 2,025.00 7.71% 10,125.00 7.72% 3100 -46340 Protective Services 1,317.33 5.02% 4,506.96 3.43% 3210 -46340 Telephone & Telegraph 169.96 0165 - 834.24 0.614% 343046340 Advertising Other 0.00 0.00% 318.28 021% 36011 -46340 lnseranCO & Bonds 842.80 311 4,214.110 3.21% 3BIO-16310 Electric 1,964.53 5.56% 4,520.07 3.44% 382046340 Water 0.00 0100% 1,100.40 0.81% 31330 -46340 Gas 1,281.04 4.88 12,273.98 9.35% 3840 -46340 Refuse 3,008.27 11.46 3,039.44 2.32% 3B50.46340 Sower 0.00 0 -00% 536.44 0.41% 400046340 Repair & Maint. Services 1,051.34 4.00% 11,860.71 9.Dq% 410046340 Rents & Leases 15.00 O.D6 192.50 0.15% 430046340 Miscellaneous Charges 0.00 0.00 °/4 99.74 0.08% 4315 -46340 PILOT 986.67 3.76 4,933.35 3.76% 439046340 Taxes & Licenses 0.00 0.00 558.62 0.43% 450046340 Administrative Expenses 8.16 0.03% 727.20 0.55% 4850 46340 Interest on Deposits 7.45 0.03% 35.33 0.03% Total other Services & Charges 12,177.55 46.39% 59,876.26 45.63% Z� Jul, 20. 2011 1 :34PM 5120 -46340 Building & Improvements Total Capital Outlay - 0.00 0.00 1 /0 0.00% No. 0419 P. 25 - 0.00 0.00% 0.00% Total Expense 17,836.22 67.94% 82,590.49 62.94% Excess (Detlelt) Revenue over Expense 8,416.36 32,06 48,638.57 3706% 2 1 Jul, 20. 2011 1:34PM No. 0479 P. 26 Parkview Villa South (166) Gash HOW Statement Period = May 2011 Revenue 36220 Gen. Government Rents 36225 Nondwellln9 Rents 36290 Other Miscellaneous Revenue Total ReVenUe Personnel Services 1000 Accrued Salaries Total Personnel Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Malnl. & Construct Materials 2171 General Supplies Total Supplies Other Services & Charges 3040 Legal Fees 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Server 4000 Repair & Maint. Services 4100 Rent & Leases 4315 PILOT 4390 Taxes & Licenses 450D Administrable Expenses 4850 interest on Deposits Total Other Services & Charges Total Expenses Excess(Derldt) Revenue ever Expenses Adjustments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Total Adjustments Cash NOW Month to Date 25,150.33 465.01) 636.25 26,261.58 3,723.00 3,723.00 177.41 1,367.50 243.50 147.18 3,935.67 0.00 2,025.00 1,317.33 169.96 0.00 842.80 1,464.53 0.00 1,281.04 3,008.27 0.00 1,051.34 15.00 986.67 0.00 816 7.45 12,177.55 17,836.22 5,415.36 8.00 0.00 0.00 3,108.96 842.80 205.97 (11,107.23) 643.67 (6,297,83) 2,117.53 2� MAO. 2011 1:34PM No. 0479 P. 27 ►m Parkview Villa South (166) Cash Flow Statement Period = May 2011 Month to Data Beg Cash End Cash Difference 10100 Cash Balance 81,614.21 83,731.74 2,117.53 10200 Petty Cash 93.00 93.00 10400 investments 482,070.36 482,070.36 - Tetal Cash 563,777.57 565,895.10 2,117.53 ►m Jul. 20. 2011 1:34PM No.0479 P. 28 6/14/2011 2:46 tm General Ledger (Accrual) Park9im Villa South - (1116) Months: May 2011 P p r1y W6 pedad Omblplma Control Refer Debit Cracit galena Remark. 1000-4634 0 Rutted Saladet 14,692.00 - 900411x-9 Blame = 166 5/31/2011 05111 (mecv 360 ?O56teaning ReaMng1105559 RC 3,723.00 18,615.00 I7/C CHC PR M9mt Fee Nctchang9= 3011110 18,615.9 = Ending balance n 200046340 OIFre Supplies 309.85 = Bwlnoing BalaMe= 166 4 12apall D5111 066,101) corner Compaolet, Inc P- 220076 124076p'+s 67.31 957.16 Caron copra, m4/26-5/2S 166 4129/1011 D5 1 11 (0111)016CC Pop0t P- 228618 5.6282E *11 24.00 48244 paper, peas 166 511712011 05/11 (am) Omca depot P- 230929 5.647786+11 36.51 518.55 envelopes, peen etc. 1% 5/29/201165/11 (petl60s) Lam Sheak P -23080 M052511 98.71 567.16 0110 NelChange = 177.41 567.26 = 6ndln00alanee= 201046340 mno, Egoipmam 1,254.05 Is"InWO 601011vo 166 SlIOV2011 05111 (0) All lac P- 229060 51259656.001 472.50 1 fags - 2/0421,512 166 5/131201105111 (all) All I P-129286 S12S9966,002 895,00 2,621.55 1695(2) - 219,324 Hetcharril 1,367.50 2,621.65 = Ending Balance e 2160 -461 Mont. a C6mw[t. "atonal, 337,51 - Beginning Balance = 166 412112011 OS/11 (h6me7) ND SPppty Fo018de , Maimena P228078 9106223325pv 0.92 385,4) towels, gloves, bath liners 166 5/10/201105111 ( home]) HD Supply Fad69cs Maimela P379069 91063)8139W 70.08 455.51 red sodels, 0-run kit etc, 166 5/12/2011 05/11 (holacN) Name Depot AedH SmiCOP-229208 3141269 89.61 545.12 kwik spin etc. 166 S/251201105111 (pe116NS) taum Sneak P1230830 PCO52312 35.97 581.9 WO, bmpc- foundry mach NelChange= 243.56 581.09 = Ending Balance= 2171 -46340 Gen &al Supplias 182.15 -&glnnkl0Ea%Acc= 166 S/IB/201105/11 (home32) Name L3mol Gedt SCAa$P-2301s25 7320457M 2059 . 2(074 hose, lop mil etc. 166 5123/201105111 nna[4110) Shermwsailllams Co. P-230824 56000 118.59 32933 pant matchange= 147.18 329.33 = 9odlnrl Balance= 3060 -46140 I4anag0ment Serous 0,100.00 - &ghnbg aaVna = 166 51311201105111 (da) Comm0nbmd Housing P-230120 52054 5,749.00 13.8411.00 Mgmt Fees 5/11 166 5/3112011 OS /ll (:Rm21380)~uOUmn9 ftttuadn0 }105559 RC 3,723.00 10,125.08 P/C CHC PR 6lgmt Fan NelChange= 2,025.00 10,125.00 = Ending Balance = 3A0046340 NotaRMC Sen,lm 3,10963 .. &ghming Baima= . 166 4 /JO/2011 OS/11 (,AW) Olsen Fka lnspa900, irw. P-210417 21104091 955.8 4,144.63 0001latldarin51a1Wlbns 41 166 5/51201105111 (slurp) Sgnpler&Anne11 P-229063 6695454pvs 137.33 4,201.96 2nd 0, co deteclortx 166 5116/2011 05111 (0150) OLSen Fke IMPe41101), 141. P22928) 532x1 225.00 4,506.96 Rusty finding we 5/02 NelChange= 1,317.33 4,511 - ending Balantt a . 3310.46340 Tck08me &Te"n,sch 6606 -Becirm1in9Balanav 166 5/1/201305111 (msw)AnmcMe LLC P-216595 1J040setil 13.19 677.76 Anmt 5111 166 5/2/201105111 ([arn:3001) Contuse P-22701 8.7)211E411 70.13 697.69 Inul et avc 5 /114/10 166 517/201165/11 (4wts9119) Qwesl P1229D62 7637083978/0 17.42 715.31 phoha sec 5 /07.6/06 166 5/11/201105111 (10,10718) MCI Comm Senke P- 229290 7637881979/O 10.03 725.14 phom yvc 4 /195/06 166 511BI2011 05111 (0111658) Om[e d tnce[pA's Te[hnIXO 8229191 200800167105 108.10 034.24 prone m •per and 4/30 He { cMnge= 169.96 034.34 n Ending valence = 3430 -46340 Warning Other 318.28 = BeglAmgBdance- NelChange =0.00 318.28 = 021(1!219 balance= 3600 -46340 1a50raACe11, 1 1 31371.20 segmmn9900210= 166 $131 13011 051 (:RMm 360) :PWIRmwdng RcOn6fl9)-105559 RC M1.80 4,214.00 C of Collmbaa Heights Ins R NsdChanBee 847.00 4,214.00 = Ending Ralancee 381046340 Ele[91t 3,055.$4 =Boijlm gBalance= 166 5 /11fm 05111 (Kon) Ael Energy P228156 515(1411553/0 Ig64.53 4,520.07 ehc svc 4 105.5107 HctChan96= 7,464.53 4,520.07 = Ending 8a1nnos n 3820.46340 Water 4100.'8 =Seam,, lame= NelChange= 0.00 !,100.40 = Ending Balance= 3630 -45340 pl 10,992.94 - WinnM90acnce= 166 5161101105/11 (tent) Cencupnlnl Erltrgy P-2ZW9 55271324/051 1,201.4 12.273.98 gat we 4101.51DI Hetchan00a 1,261.04 12,773.98 = Ending Balance e 31149.46340 Refuse 31.17 = WpNnu Balance = 166 5119/201105/11 (metr 9149) Metro Appian[e Rety=ing, P230527 5110434pni 50.84 62.01 Trash rmvl 5/19 Pale 1 m Jul. 20. 2011 1:34PM No. 0479 P. 29 6/14/20112!46 PM General ledger (Accrual) Parkvltw Vlila South - (166) Months; May 2011 Prope Dale period DMCII116R C9nhal Refee Oa611 [retlll Beranm Remarks 166 5123poll 05111 (on) PeAMew "Al north P•229202 052311av1 2,957.43 3,039.44 Reim ovs u(h PO by pm - 10 166 5123p011 05111 ban) paded w Was Nunn P- 229201 052311pvs 2,957.43 82.01 P.exn Pus Irate Pd by Om • 10 166 512)12011 05111 (M) pawaw Was rlone P 229202 052311pvs ,957A3 3,039.94 Rehr Pus Iran ad by Pun 10 N61C6arge= 3,008 3,039.44 = Ending Balance= 3850.46340 Sewwr $36.44 WanAIA9 bm me Hatchawle =0.00 $36.44 = Indin90alen(a= 40 6340 Repair & NeN1. $eMas 10,509.37 = k9hWng Balem(e = 166 512/ 05/11 (MIJ) EWIC Eleyeler Corp. P226754 107351im 29496 11,103.03 pay maim 5111 166 5/81201105/11 (a8(n2136) AN Hea6 lawn& Snow, Lb P230628 1604pvs 276.52 11,300.35 pods malot 4111 166 5191201105/11 (adam) Adam's Pen Canr7ol, Mc. P¢29179 642a/6pvs 22.00 11,40,35 Pest svc *403 166 51131201105/11 ((ustsw4) Custom Appliance Se im 6 229065 6901 262.06 11,605.21 drW mre(alr• la",yr 166 5/16/201305121 (emill) Emppe Doer &Class Co. P-22%(A 114S10-IN 15550 11,76071 WeenS-9123 1% S/23/2011 OSp1 (OOM0425)Dlamondsh the Puwoh P-230026 052311pa4 10000 11,660.71 Door sets, W, Inn - Del Nai6han9e= 1,051.34 11,960.71 n Ending Balsa. = 4100 -46340 Ream & leases 177.50 - ONIAWAg eaiance - 166 4110)201105/11 (multi) Molahwang C tCOn061 P-229067 /1040109 15.00 192.50 bckgmdrysa /Il Helcha6ge= 15.00 192.50 = Ending Balan e = 430046340 Nixdlaneox canoes 99.74 = Begmn(Ag Balance = NetChan9en 0.00 99.74 = Ending Belan(4 4116.46340 PILOT 3,946.60 = pglnNng Bue ea w 166 5131/201105/11 (:Re , 360) �PovtpxwriA9 Raunlr,pT105559 RC %6.67 4,93115 Armles Ch Puop4ttty 3 Att N9tchamw 98$.62 4,933.35 = Ending Balance = 4399 -46340 laves & "census 558.62 -. negfereI g 0a161Re - NelChange= am 550.62 = Eplroo 9alance= 450046340 Adramisuatin Expenses 719.04 - Uafting Balance - 166 5/9/2011 05111 (shin) Laura Sheak P- 228067 050911pv3 0.16 70.20 1111W 5/9 Nelehange= 9.16 727.20 = EndRa9 Balance= 485046140 IAlereal M DCwails 27.05 = Bwlnn'ng Balan(e= to 5/3)(101105/11 sm Dw lm,amt accrual 3-105733 0)l 7.45 35.33 Sec Dep interest a( A NWhange= 7.45 39.73 * 60dlnp Balance 21,516.65 6, 630.43 Page 2 ZI Ju1.20. 2011 1:35PM No. 0479 P. 30 Parkview Villa South 612111 Bank Reconciliation Report 05/31/2011 5016464 Balance Per Bank Statement as of 05131/2011 $83,779.51 02/112009 389 mole- MCI Comm Service 5 0512512011 1009 of0. Office Depot 24.88 0512512011 1091 gwe59115 -Qwest 17.42 Less: Outstanding Checks $47.77 Reconciled Bank Balance $83,731.74 Balance per GL as of 05/31/2011 $83,731.74 Reconciled Balance Per G/L $83,731.74 Difference 0.00 Cleared Items: Cleared Checks Date Tran k Notes Amount Dale Cleared 04/1312011 1054 chc - CommonBond Housing 87.00 05/3112011 0427/2011 1061 all • All I= - 475.50 0513112011 042712011 1062 baye - Bayer Electric 220.00 051312011 04272011 1063 bibp -13FB Painting, Inc. 80.00 05/312011 04212011 1064 chc - CommonBond Housing 6.25 051312011 0427/2011 1065 colu - City of Columbia Heights 1,878.28 05/3112011 04/272011 1088 Ibpm Mechanical, Inc 609.23 05131/2011 04/272011 1067 mcic3718 • MCI Comm Service 8.75 05131/2011 04/2712011 1088 gwes9115 - gwest 17.42 051312011 04127/2011 1080 ryco - RycoSupplyCompany 26.73 05)3112011 0427/2011 1070 slci504 - 51 Cloud Refrlgeralion 243.40 05/3112011 04/270011 1071 xcel - Xcel Energy 1,377.66 05/3112011 0510412011 1072 chc - CommonBond Housing - 5,763.05 0513112011 0510412011 1073 na81035- National Automatic Sprinkler Co 1,770.00 05/3112011 0510412011 1074 of5658. Office of Enterprise Technology 109.69 05/3112011 05/04/2011 1076 laxa - Anoka County 12,093.90 0513112011 05/11/2011 1076 answ • Answed.Ne LLC 13.48 05/3112011 05111/2011 1077 eagh- Eagle Elevator Corp. 294.46 0513112011 051182011 1078 wmc3001- Comcast 20.13 051312011 05/1812011 1079 home? • HD Supply racltilies Maintenance 47.92 051312011 05/162011 1080 loffl101 - Lof6or Companies, Inc 67.01 05/312011 Ju1.20, 2011 1;35PM Parkview Villa South No. 0479 P. 31 6 1 2111 Bank Reconciliation Report 05/31/2011 5016464 05/10/2011 1081 shed - Laura Shook 616 06131/2011 0511812011 1082 (0607592 • Houle 396.48 05131/2011 05/25/2011 1063 oil - All Inc. 472.50 05/31/2011 05/25/2011 1084 cent - CanterPoinl Energy 1,281.D4 06131/2011 05/2512011 1085 Cus16044 - Custom Appgance Service L!_C 202.88 05131/2011 05/25/2011 1088 ampl - Empire Door & Glass Co. 15550 05/31/2011 05125/2011 1087 home7 - HD Supply Facilities Maintenance 70.00 05/31/2011 05252011 1088 multi , Muillhousing Credit Control 15.00 05/31/2011 05/25/2011 1090 olse • Olson Fire Inspection, Inc. 855.00 05/31/2011 0525/2011 1092 strop - Stmplex Grinnell 137.33 05/31/2011 051252011 1093 zcel - Xcel Energy 1,484.63 05/31/2011 Total $30,168.64 Cleared Deposits Date Tran# Notes Amount Dale Cleared 05/022011 230 operating 52111 13,579.60 05/31/2011 05/052011 231 operations - pvs 9,254.00 05131/2011 05/08/2011 232 operating 516111 2,421.00 - 05/3112011 05/13/2011 293 rent deposit 1,201.60 05/31/2011 05/172011 234 rent deposit 676.00 05/31/2011 05127/2011 237 Laundry receipts 367.25 05/312011 Total $27,498.25 Ju1.20. 2011 1:35PM No. 0479 P. 32 ft"Ir Northeast Date 5/31/11 Page 1 B ank ttem6CrFDlc Primary Account Ending 6464 Enclosures 39 77 Broadway 81. N.E., M;nneapolis, MN 55413 612 -319 -9811 • 24 hour telephone banking 651628.9807 Visit our webslle at www. norlheastbank•mn.com * * * * * * ** * * * * ** *AUTO * *3 -DIGIT 551 733 1.1660 AT 0.490 6 1 13 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONBONO COMMUNITIES 328 KELLOGG BLVD WEST 51 PAUL MN 55102 -1900 II'II uIl'u u1�11n,ailia r11111 n�lll r�'1 E IICII Ku 1I N�I A C C O U N T S -- EFFECTIVE )ULY 15, 2011, NON- SUFFICIENT FUNDS PAID ITEM FEES AND NON SUFFICIENT FUNDS RETURNED ITEM FEES WILL INCREASE TO $30 PER ITEM. MEMBER FDIC NORTHEAST PUBLIC FUNDS ACCT Account Number Ending 6"4 Previous Balance 86,449.90 7 Deposits /Credits 27,759.25 33 Checks /Debits 30,429,54 Service charge 100 Interest Paid .00 Ending Balance 03,779.51 Number of, Images 39 statement Dates 5/01/11 thru 5/31/11 Days in the Statement Period 31 Average Ledger 93,899 Average collected 93,178 wd* A* xxAkx#x xddRR** dd* wwwwwwwwxw* w* x*# A# AR# Rtrtrdd trRRdw * * *+d + * #x,A� *_ *Ad * * *xw * *w Deposits and Credits Date Description Date Amount 5/02 DDA REGULAR DEPOSIT 13,579,00 5/0S DDA REGULAR DEPOSIT 9,254.00 5/09 DDA REGULAR DEPOSIT 2,421.00 5/13 DDA REGULAR DEPOSIT Z61.00 5/13 ODA REGULAR DEPOSIT 1,201.00 5/17 DDA REGULAR DEPOSIT 676.00 5/26 DDA REGULAR DEPOSIT 367.25 x** AA# xtrdtrdtrtrtrdtr** aww* da**** xd* d**## d#+ trA+ tr*** a * *w * * * * * * *AAGGkAddddx * * *a * * * *t# charges and Debits ^' Date Description 5/26 Xfer to PUB FUND 0001 Amount 261.00 wR * # *w * # * # * *tr *# dddd****** ww* wd* aad*##* Ad# dd' kAdd *d * * #wdww #*xxkfiRAAxRxdRRRRRwwww checks in serial order Date Check# Amount Date Check# Amount 5/23 82 396.46 5/04 1063 60.00 5/27 90* 955.06 5/02 1064 6.25 5/16 1054* 87,00 5/03 1065 1,676.26 5/03 1061* 475.50 5/03 1066 609.23 5/10 1062 220.00 5/06 1D67 8.75 * Indicates skip in check numbers 76D9S9 - S45 R Jul. 20. 2011 :36PM rtheast SW Dank No. 0479 P. 33 Date 5/31/11 Page 2 Primary Account Ending WW Enclosures 39 NORTHEAST PUBLIC FUNDS ACCT Ending COW (Continued) Checks in serial order Date Check# Amount Date check# Amount 5/04 1068 17.42 5/26 1079 47,92 5/03 1069 26.73 5/24 1080 67.31 5/09 1070 243,40 5125 1081 8.16 5/03 1071 1,377.66. 5/27 1083" 472.50 5/06 1072 5,763.05 5/31 1084 1,281,04 5/11 1073 1,770.00 5/31 1085 202.86 5/12 1074 109 69 5/27 1086 155.50 5/18 1075 12,093.90 5/31 1087 70.08 5/18 1076 13.48 5/27 1088 15,00 5/17 1077 294.46 5/31 1092* 137.33 5/27 1078 20.13 5/27 1093 1,464.53 * indicates skip in check numbers x* w* GGxGGxxxxx4WY /xx* *����GGGGxxxnxx xxi+. tGS: F: GAGGGWk *xWLwa< #dG *GGxxGwww,�w4 >: -R:** Daily Balance section Date Balance Date Balance Date Balance 5/01 86,449.90 5/10 101,197.63 5/23 88,570.62 5/02 10.0,022.65 5/11 99,427,63 5/24 88,503.31 5/03 95,855.25 5/12 99,317.94 5/25 88,495.15 5104 9S,757.83 S/13 100,779.94 5/26 88,553.48 5 /OS 105,011.83 5/16 100,692.94 5127 85,470.82 S /06 99,240.03 5/17 101,074,48 5/31 83,779.51 5/09 101,417.63 5/18 88,967,10 -** E N D O F S T A T E M E N T °* W 760959 - 546 Jul, 20• 2011 1:36PM No. 0419 P. 34 Payment Summary Dank- 166opr AND mm/yy= 05/2011- 05/2011 AND All Checks -Yes AND IACIUde Voids -A8 [necks r�� check Post T61a1 Dole Rook check# Vendor Date Month Amount Remnclled 1660pr - Parkvlew villa Sovlh 1072 cnc - [0mmoneond HOUSInp OS /On /x011 05/2011 5,763.05 05/11/ ;011 166opr- Parkvlew Villa South 1071 ne1i1035- National AUVIAIR Spalnkfar CO 05/04/2011 05/2011 1.770.00 05 /31/2011 166opr • Parkvlew Villa South 1074 offi659 - office of Enterprise Technology 05/04/2011 0512011 109.69 OS/3112011 1660pr - Parkvitw Villa South 1075 lake - Anoka County 0510411011 0512011 12,093.90 05/3112011 166opr- Parkvlew Villa south 1076 anew - Answen.roe LLC 05/1112011 05/2011 1146 05/3112011 1660pr- Parkvlew Villa South 1077 sport - Eagle Elevator Corp. 05111/2011 05/2011 294.46 05/31/2011 166OPe - ParlCview Wits South 1076 COMC3001 - ComCast 05/18 /;Ott 0512011 20.13 05/31/2011 166opr - ParkVlew Villa South 1079 home? - HD Supply FacOties Maintenance 05/18/2011 05/2011 47.93 05/11/2011 1660pr . Parkvlew Villa South 1080 16!11101 - Lo10et Companies, Inc 05/16/2011 05/2011 67.31 D5/31/2011 166opr- Parkvite, Villa South 1081 Shea- Laura Shook Os /111 /;Oil 05 /2011 0.16 05131/2011 166opr - Parkvlew Villa South 1087 t0007592 - Houle 05/18/2011 05/2011 396.48 05131/2011 166opr - Parkvlew Vista south 1083 all - All fnc. 05125/2011 0512011 472.5 05131/2011 lesope - Parwow Villa South 1084 cent - CenterPoinl Energy 05125/2011 OS /2011 1,281.04 05/31/2011 166opr- Parkvlew Villa South 1085 cvsISO44• Custom Appliance Service LLC 05/2512011 0512011 Z02.a6 05/31/2011 166opr - Parkvlew wits South 1086 emle - empire Door 0 Glass Co. OSd25 /Z011 05/2011 155.5 OSIII 12011 I660PV - Parkvlew Villa South 1097 home? - HD Supply Facilities Maintenance 05/25/2012 0512011 70.08 05/31 /2011 166opr Parkvlew Villa South 1008 multi - Muldhousing credit C061101 05125/2011 0512011 15 05/31/2011 166opr Parkvew Ville South 1089 off) - Office Depot 05/25/201L 0512011 24.88 166ope - Parkvlew Villa South 1090 else - Olsen Fire 1115Dec00h, IAC. 05/25/2011 05/2011 95S 05/31 /2011 166opr- Parkvlew Villa South 1091 aw659115 -Qwest 05/25/2011 05/2031 17.42 166opr- Parkvew Vila South 1092 slime- Slmplek Grinnell OS/25 /2011 0512011 137.33 05132/2D11 11ssopr- Pa.kvtew Villa South 1093 kcel - Ncel Energy _.... .. �.. ..__,..,,am.o........�..._._.., 05/25/2011 05/2011 ter.._..._._....,......_,- 1,464.53 05/31 /2011 �..._- .«out. «._ ........_. �.._...._...__.. �,,, m+. e .. ..............._— ......�. -...__ 25,780.73 r�� Jul, 20. 2011 1:36PM No OH .f ��6 ���� S �$gE vs0 O {F $pxd�a�a ��e 5®' �y �� �� 3 amm p� 78 pp it ¢� yI6� gp a m w .p 9 $ @m 3 p $ B uos a�H� s N A N p o NO$d0. Q� ObON ��N M4-i moose � �so� 5rn a wi A ass s ,4s B V O 8 M.o ?,a.�Op' 88u�8H888$892$68 r m J 0ql q� ,V. O,KAI�pb�l�yv�NN N�H��O VIDOO$NHGO �UAP�go Ci l+(IaHSb G�GG.+Yn�S&$oa 83 e0000 88Y o Ns W; U8$$ >$$$$ M a 8 `y�' Two Ye $oR o%6 +8oia 9 m�u� w ffia$9$$8sos$Hffi� e ��� y m y 8 g e$8 y��y � y��4 � 4++ o e,a yy , NNw�U��SH0 N�eOOO N�t NNyy i ,� u t gg - s4peo ®o23?14�8av $88sae888$e$'s88 pp R� N pppp m $8C m88 479 P. 35 . 00 6 i5 Q " } � 9 1888 w°OO; by NSA 888 S�a ��e �y "w88 m B $8$ $ uos a�H� �a YnSP �tioo �Sk3 FE 1888 w°OO; by Ju1.20. 2011 1 37P No. 0479 P. 36 ti • s �+ a a �z p � gFF RI w y g J So- 2x B— ea �P 1 ad3Sd a - f 8 �; s cy L Re g-+ GP PLO 9- 1 11 8 P° =2b I y ffi � a� g 8 m Gv j o i A M5 e oe ia h <�s�aos�5roxuome��� V 'yA^�S[ R yy WqP ((N Fp.S ;u�q ym a NQ y_, O )e)��G QN q yH V bAbbbNO TPq Wyp a Q a � g G q O°O� o O LIN o So �(nUYn HNSSSSOEi I�NONNNI�I�O$� I8" ° '� v W p b yy N JJ y y yy�� LLIS�WHHPAUV�IN N�IW NNOO 1 $$ p °° u °G.NP b GG 8 ° °wvo` ° "8 a C' 88 9 $e a�N� Y ai^�i >8'ao'�6�98C'a8W �yA O NPR A k � 8$ Yd8 �o N >�8b:dH Ct`$88 ?N A b q P Y! P O f W �R N ���� V O1�OONOP +WB� $ 1 I$ I b$ 8$$� b bI $I °b vl �� 6I��� >I >u c7A Y gb f 'b 1 �° °O �im�j ➢UW 1 I i Al Ii S$8 � P' 8 B $8 9 8 « °8N _$ 88a888888$$88oe 3� Jul, 20. 2011 1:37PM OO OO p No. yN�d�w 3 �p R a3�5 .n , ad� s w oil a� E�j N Q vp6y 8 Y ! S O60 y G�1 $$0041 8 16BN$V i Y 8r °®5 $$ooffi ry $oo�N i i08°t8RS ° L E u $ 8 �8m$$ z ME i u g ff55 pp y 1,, p P4$o a�°V(y�OOpNCOO�NNW y! u ID q B � ! N �, y B � ,1°3 , OG J G ✓.d tl41 N$NNN +NOUSp �i Y11p$$d V} NP gi Nf{$$° N � bA ° °r m .A SSSS S Y$ ° m oiiyS I L in ➢ ffi $ffi'sa G °o4,ue688$$$$9t$$ffi YY�O ZiOiyO +w ofSB� $$ffi$$ffi>^ffiUOe i�.$iS$ Nd' j V + �ig $i g W J &'i6o� �$f�inN��'oubio o���a$ow v,& mo o, se's° $okpp P o:1k S p N q Lib' =R� �p4"�b"p8t3�88p$ odi4$ )479 P. 37 a 0 � s u r� ° 3 O m W � Itl S$N mb m3 VW ° Q W pP osel �$Wffi �i °6m �°5y+ ❑ C 4 $$In m $ b O b W W Ll oo ° sm rs 8eW 8 i'i E1 K � ¢ v 8$0 9$Sp m Ju1.20, 2011 117PM No C P. 36 Ip y e �Bg g E A � g e g HER- BE nc u' w R @3 gy"> g R g g F T ° 9 dm m ;a f E4 6 w &� 9 6�H � a n @B Egg ° a Y NE e B $ E x E w o W 0 J a N O I L a ym N N �bt p � P , �d ss yy How IN G�g� �H HNOOeOHgInUO���NOOU AUO�mHHRSu �iN4WNNNA b s��� ?r+eHw"b$d�Fm bucygq$Do +�� 1;3 bB°tnpg��si� °wW « H�48.hsdBTn'13o O pp�O ys E(R�pOggq G� Dp p 0 y H UHppoSUNRpN���$pN0 /� p0.r�(yy(p� H NN V y N y ,W S U1��,I NAAN,,iq J�J ew$VbO�SSNW NIEY }{ ra r�- Nw,'sa o��sp�e�8sioop�8s$ s$oaasss000�aHApi� Jul. 20. 2011 1;30PM No. 0419 P. 39 July 20, 2011 Scott Clark Columbia Heights HRA City of Columbia Heights 590 -40th Ave Northeast Columbia Heights MN 55421 CommonBond E 0/76161 UN ITI E5 13 yowl of 5table Homes & Snong rntuNs. "' Kellogg Blvd W St. 16N 55102 p 651 - 29 Y � 651 -291 -1003 003 N;1x ww vrom onboM.org RE-. Columbia heights HRA Parkview Villa - Monthly Financials Reporting Date June 2011 Dear Mr. Clark, I enclose copies of the June 2011 financial reports for Parkview Villa North /South. Included in the report: BRA Expenditures (Expense Summary) Financial Overview -PW North Budget Comparison -PW North Income Statement -PW North Balance Sheet -PVV North General ledger Detail -PW North Aged Payables -PW North Check Register /Bank Reconciliation -PW North Financial Overview -PW South Budget Comparison -PW South Income Statement -PW South Balance Sheet -PVV South General ledger -PW South Aged payables -PW South Check Register /Bank Reconciliation -PW South Copies of all Invoices -PW North and South Please feel free to contact me at 651 -310 -9276 if you should have any questions regarding this month's financial report. Sincerely, Laura Frost Regional Manager CommonBund Housing Ju1.20. 2011 1;3BPM No. 0479 P. 40 Parkview Villa North Financial Statement Overview June 2011 Revenue: Occupancy for the month of May 2011 was 100% occupied; there were no vacant units as of 5/31/2011. Total Revenue was tinder budgeted amount (unfavorable). Less Grant Income was recognized in the month of June than budgeted. All other revenue was over budgeted amount (favorable). Administrative Expenses: Administrative costs for the North are under budget (favorable). Other Renting Expenses were under budget (favorable), and reflect minimum applicant screening needed due to low turnover. Office Salary line shows the staffing portion for North per contract, both office and maintenance staff. Office Supply expenses are under budget (favorable). Legal Expenses Project was over budget (unfavorable), and reflects cost incurred for legal representation in resident lease termination process. Audit Expenses was under budget (favorable). Telephone, Answering Service and Internet expenses are under budget (unfavorable), and reflect costs associated with telephone, answering service, internet and office of enterprise technology. Bad Debts reflect rent receivables that were written off from past residents that owed rent damages at the time of move out. Management has filed these with collections in an attempt to recapture these fees. Utilities: Utilities Expenses are under budget (favorable). Water / Sewer are quarterly billings; Gas and Electric are both under budget. Operating and Maintenance Expense (supplies): W Jul, 20. 2011 1:38PM Operating and Maintenance Expenses are over budget (unfavorable). Janitor and Cleaning Supplies are under budget (favorable). Janitor Contract expenses were slightly over budget (unfavorable), Exterminating Contract is over budget (unfavorable). No. 0479 P. 41 Garbage and Trash are under budget (favorable); this reflects a quarterly billing. Security Contract is over budget (unfavorable), and reflects cost incurred for power supply replacement and smoke detector panel service. Grounds Contract is over budget (unfavorable), and reflects cost incurred for grounds maintenance and for tree trimming. Repairs Material costs were under budget (favorable). Repairs Contract expenses were under budget (favorable). Elevator Maintenance Contract is over budget (unfavorable), and reflects the cost of monthly maintenance and major repairs including TorQmax drive and parts Decorating Contract and Supplies were under budget (favorable). 0 Jul, 20. 2011 1:39PM No. 0479 P. 42 Parkview Villa -North (165) Balance Sheer June 2011 Dcoks = Accrual Sun -11 Assets 10100 Cash Balance 166,643.66 10200 Petty Cash 457.00 10400 Investments 810,925.08 11300 Rent Receivable 4,255.64 11900 Accounts Receivable 560.00 13200 Due Fram Other Government Units, 0.00 Total Assets 982,861,38 Liabilities 20200 Accounts Payable 16,166.55 20210 Accred Other Expenses 10,801.82 20220 Due to Resident Council 551.74 22.000 Deposits 16,879.67 22200 Accrued PILOT 9,358.35 72210 Revenue Collected in Advance 6,083.00 Total Liabilities 59,641,33 Fund Balance 25300 Fund Balance 923,020.05 Total Fund Balance 923,020.05 Total Liabilities and Fund Balance 982,861.38 A Jul, 20, 2011 k39PM Parkview 1 018-1 , 100 (165) Income Statement For The Period Ending June 2011 (looks = Accrual No.0479 P. 43 supplies 200046330 Office Supplies Month to Date % Year to Date % Revenue 0.00 0.00 0 /0 1,440.82 0.71% 33160.46330 Federal Grant 22,146.57 43.27% 22,146,98 10.96% 3622046330 Gen. Government Rents 27,941.00 54.59% 172,451.00 85.30 36225.46330 Nondwelling Rents 310.00 0.61% 1,891.00 0.94% 3629046330 Other Miscellaneous Revenue 782.32 1.53% 5,007.23 2.48% 39120 -46330 Recovery Damage City Property 0.00 0.00% 665.25 0.33% Total Revenue S1,179.09 100.00% 202, ;61.46 100.00 1:xpenses 0.00 0.00 -49.94 -0.02% Personal Services 2,059.09 4.02 0 10 30,120.30 14.90% 1000.46330 Accrued Salaries .8,357.00 16.33% 50,142.00 24.80% Total Personal Services 6,357.00 16.33 50,142.00 24,80 supplies 200046330 Office Supplies 91.45 0.18% 1,307.37 0.65% 201046330 Miner Equipment 0.00 0.00 0 /0 1,440.82 0.71% 216046330 Maint. & Construct Materials 297.80 0.58% 2,945.68 1.46 2171 -46330 General Supplies 29.37 0.06 0 /0 1,605.65 0.79% 228046330 Yehlcle Parts 0.00 0.00 0 /0 35.80 0.02% Total Supplies 418.62 0.82 0 /0 7,335.32 3,63% Other Services & Charges 3040-46330 Legal Fees 0100 0.00% 4,385.42 2.17% 3050 -46330 Expert and Professional Services 0.00 0.00 0.00 0.00% 3060.46330 Management Services 4,545.00 0.88% 27,270.00 13.49% 3100 -46330 ProtWtve Services 0.00 0.00 3,855.85 1191% 3210 -46330 Telephone & Telegraph 305.44 0.75 0 /9 2,243.00 1,11 0 /0 3430 -46330 Advertising Other 33.77 0.07% 135.38 0.07 3600 -46330 Insurance & floods 1,678.77 3.67°% 10,851.01 5.37% 3810 -46330 Electric 4,038.04 7.89% 19,562.47 9.68% 3820 -46330 Water 0.00 0.00 -49.94 -0.02% 3830-46330 Gas 2,059.09 4.02 0 10 30,120.30 14.90% 3840 -46330 Refuse - 2,957.43 -5.70% 575.83 0.28°% 3850 -46330 Sewer 0.00 0.00% 76.94 0.04% 4000.46330 Repair & Maint. Services 6,046.92 11.82% 55,992.29 27.70% 4100.46330 Rents & Leases 0.00 0.00% 318.67 0116 0 /0 4300 -46330 Miscellaneous Charges 27.75 0.05 103.33 0105°% 4315-46330 PILOT 1,653.92 3.23% 9,923.52 4.91% 4390 -46330 Taves & Licenses 0.00 0.00°% 1,403.38 U5 0 /0 4500 -46330 Administrative Expenses 25.00 0105 0 /6 705.31 0.35% 4850 -46330 Interest on Deposits 12,44 0.02% 75.22 0.04% Total Other Services & Charges 17,749.51 34.68 167,547.98 82,88 v Jul.20. 2011 1,39PM NoAM P. 44 Capital Outlay 512046330 Building & Improvements 2,025.90 3.96% 2,025.90 1.00% Total capital Outlay 2,025.90 3.96% 2,025.90 1.00% Total Expense 28,551.03 55.79% 227,051.20 112.31 Excess (Deficit) Revenue over Expense 22,626.86 44.21 • 24,889.74 •12,31 N Jul, 20. 2011 1:39PM No. 0419 P. 45 Parkvlew Vllla -North (165) Cash Plow Statement Period = June 2011 Book = Accrual Revenue 33160 Federal Grant 36220 Gen. Government Rents 36225 Nondwell" Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Expenses Personnel services 1000 Accrued Salaries Total Personnel Services supplies 2600 office Supplies 2010 Minor l:guipment 2160 Maint. & Construct Materials 2171 General Supplies 2280 Vehicle Parts Total Supplies other Services & Charges 3040 Legal Fees 3060 Mariagemeht Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertlsing Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Malnt. Services 4100 Rent& Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & licenses 4500 Adminislra8ve Expenses 4850 Interest on Deposits 5120 Building & Improvement Total other services & Charges Total Expenses Excess (Deficit) Revenue over Expenses Adjustments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due Front Omer Government Units 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Month to Date 22,146.57 27,941.00 310.00 782.32 0.00 51,179.89 8,357.00 8,357.00 91.45 0.00 297.80 29.37 0109 418.62 0.00 4,545.00 0.00 385.44 33.77 1,878.77 4,038.84 0.00 2,059.09 - 2,957.43 0.00 6,046.92 0.00 27.75 1,653.92 0,00 25.00 12.44 2,025.90 19,775.41 28,551.03 22,628,66 - 1,687.00 -25.00 2,165.58 110.18 1,829.58 - 196.76 1,653.92 2,064.43 2 Jul, 20. 2011 1 :39PM Total AdjUstetents Cash Flow 10100 Cash Balanco 10200 Petty Cash 10400 InVestmente Total Cash No.0479 P. 46 ParWew Villa -North (165) Cash Flow Statement Period = )one 2011 Book = Accrual Month to Date 5,974.93 26 ,603.79 Beg Cash End Cash Difference 138,039.87 166,643.66 28,603.79 457.00 457.00 725,325.08 725,32S.08 - 663,021.95 892,425.74 28,60 J Ju 1.20. 2011 1 :40PM No. 0419 P. 41 1/14120112:00 PM General Ledger(Alclual) Pe,Nvlew 91"9 -North • (165) Montle, tun A011 P pe-ty Ulm pealed 0A.0 fqD C 0 1 R.( Debit cwlt gale.. Rempd,e 1000.46330 Atwell Saline$ 41,765.00 = Beginning Brenta` 165 6/301201106111 (!R Jl9)fPoSWnuCug NodhgJ -Iwlm RC 8,357.00 50,142.00 WC CMC PR Mgmt 449 Hatchings - 8,357.00 50,142.0 = EM1698.10ne lnnn - 463 Me Seppiles 1,21S,92 - Bgsihnln08abnte 165 6)161201106711 (din) WIM Dapa 11235601 5.6910H11 15.71 1 notes, co,rtctace 165 6127/201106111 (CM)CwM isond HOUgn9 P- 133978 5270 15.30 1,306.93 Cnmpe SOp HI.99 612W 165 (d,c)COmmo08ond N slfni P2345S6 53071 D -44 1,307.37 Postage Cyp . 6/30/2011065 1 11 Natcha,9e- 01.45 1,307.37 = EMb,99818noe = 2010-46330 Kw Egviptmt 440,02 - 9epn,nln, Silence . Retchan'. =0.00 1,440.81 = EndirsoNlante- 1160-46330 Mann. q Cdnstlid Materials 2,611.80 &"Inning eabn 165 5/27/101106111 (home]) NO SWpry I'a01dle5 Malnn F , 232695 9108071665(. 9933 2.197.21 b2lAN5, blades elf. 165 601 201106 /t1 (hOw7) HO SWNV fsdlitles MdlnN P-23J801 9100983301 196.97 2,945.66 drip 0ow1,&Hower nose etf. Match..,.= 297.80 1,943.68 = Oft0n99aiance 3171 -46330 6a0eTa15dppiies 1,52626 = &"Inning fiil e 165 6)9/101106111 (hdmB32) Hare Dext Cledil Sena P -21SWO 532760111. 2907 1,605.65 Mwete "Whan0e =M.37 4,605.65 - EndingSlem 2280 vehvlc Pans 35.80 = ROglnnlrg wlance` Nelchange= 0.00 3S.80 . wing galar,p = 3ng0.46330 Legal Fees 4,305.42 , +Is"Innls"Blance= 11.0--saw 0.00 4,365.41 a ending Sai811ce= 3060.46330 Management Stevlta3 22,725.00 = 6eginnb9 B ranch` 165 6110/201306111 (M) Cm Allsid HOming P- 134734 53161 12,902.0 35,627.00 Mgmtfees b/ll 165 61301201106/11 (:Rm1)39)IPaMg Idng Monlh21J 1072N RC 81357.00 27,270.00 RIC CHIC PR Mgmt Fee Machines- 4,50.06 37,271,00 = EMInglinihm= 3100- 463311 Pretedhe Ga e4 3 =602lnninowlante= NMlhed9e =0.00 3,655.83 = lode"Salem- 3210-46330 YelephaM, Anmenng 5 ke and lMesod 1,857.36 = Be"Nnlg NDn(e= 165 6/4101106111 (anm) Amwulbh LLC P -23901 140505=411 30.21 1,807.63 anm m 6111 165 6/2/201100/11 (0aae3001) COmC4q P @3226) 0.77211E411 "Az 1,932.65 Inturet M 6 /11-7110 165 61712011 Mill (gwe$9115l gwed P-2)3791 76378839)8/0 3877 1,971.42 phony m 6 /07-7/06 165 6111RO1106111 (ro0637111) MCI lnmm SeMOe P-235597 7070113978/0 33.46 2,002.69 phonesc5/20010 165 6/15/201106/11 ( 001659) Office of Entesp,Ve Tacha P-2337M 200800197106 240.12 2,24100 fNnawc petmd57il Nelahange =395.4 2,243.00 = EMIn9981an4,= 3430.46330 AheV,,,g(lhe 401.61 ` Beginning Balance+ 165 6)2272011 Mill (9M) CAIN,an96nd ffMiq P-233350 $1745 33.77 135.30 Its IT= Ad Jww/)OI12011 NelChed9e =33.7 135.38 =lMin9 Balanp= 3600 -46330 Insurance g lands 8,972.74 ., dsglnnlaq W1ante = 165 61301201106111 (Am 339) ;POSNawtlne MOdhl, 3.10297 RC 1,61950 10,601.82 ( of Cdumbla Heights ins Ac 165 61301201106111 (:Rx Monthh3- 107291 BC 49.19 10,851.02 IMA CAme IniVRnce NelCheage= 1,978.77 10,1151.01 = lMk,O ealaawe e 3820 -4633D EmCnic 15,523.63 = Beglnnlnq 119?aft = 165 61131101106/11 (xfei) 2te) EnMgR P- 233523 SISWI55310 4,039,84 19,562.97 dec we 05 /07-06106 NelChan9e= 4,030.04 19,561,47 - Endingaalance= 3820.46330 Wald (49.94) =BO91nn1n9W1aah- NelChenge =0.00 (49.4) = Ending Salem - 3930 -45330 Gas 28,06111 = ee"inning Baance= 165 617/101106111 ([mo CuAeltoint EntugY P- 232269 551996577061 2,059.09 J0,12050 gas wt 4/1 ?6/02 Net4hange- 2,059.09 30,120.30 . tnd(Ro llahm = 3840.46330 RPNde 3,533.26 = &9inNng Blhnc4 ` 165 (519712Di106/11 NEONS reanb 10/109/11w }107959 0 2,957.43 575.83 NEB NS reline 1011HIIJ try NelCMnge= -2,957,43 575.63 =Ending Balance= 3950 -46330 5t5+V 76.94 - liNti ning Balance = NeKhae94 =0.00 )6.94 • Ending details,= 4000 Repab 6 Maint SerJaes 99,995]7 = B,3inMng WW,ce` NBC 1 E Ju 1.20. 2011 1 :40PM No, 0479 P. 48 7114/20112:00 PM General Ledger (Accrual) ParuvieW Villa -N.M • (165) M9athd130n 2011 Pr late Pednd Dm,i tl9n (ontrol A9fa 0!611 C edit Balance nemarlu 165 4/)0/201106111 (oft) BPD Pannin9, IN. P- 237270 41011M 60000 50.595.37 perking- 1205,109,905 165 5127 /201106/11 (pd) NW, Malnnnamc, UK. P-232269 3930 291.59 50,839.96 ladmm$606 165 531/201106111 (e8m2116)AII Mand Iewn1 SOWW,, P- 232694 1618px9 234.42 54074.38 Lawn m 5111 165 s31/20110631 (wagnSI50) Wa9he. W Cn Rq, P- 2326% I1d142pm 1492 S1,01,130 614ys, damps 165 53U201106/11 (Aglp) me Pawling, (M. P -23SSW 053111pm 740.00 51,B2D. o pals" 205,5o6 165 (41/201106/11 (mm) Cemmme NPWwv LLC pW6W 10031574 997.35 52,826.05 9rxb, Mir nJArh dc. 165 611/103106111 (w910 Cagla Elovato, Own.. PQ322H 10MO -Ipm 65540 53,461.45 and maid -6 /11 165 63/201106/11 (mph) zephyr hW. a IN P272691 385 30000 53,781.45 Norm damage, water leak WC 165 63/201106111 (,ph) 2epryr Seadma int. P432690 386 362.00 54,143,45 OWUId6 IM, Paladin act. 165 6f6/2011 06111 (dire) DIrMt HW(ae Applanre Senlo P- 232693 060611pxn 336.82 54,410.27 wa,be, metor, beit 165 6n /291106 /11 (dam) Adam, POn COn"l, Inc. P- 233796 6493660M 4 &97 54,529,24 perm- 403,315.)17 165 618/101106/11 (cpmm) Cummins flkw LLO P- 233798 100-32730 "1.94 54,971.18 hwa, le* WC 16S 6191201106/ Im.)Cummlos wow tut P @33799 100.32739 699.74 55,670.92 Neater Pepk7nnl3 165 6127/201106/11 (rod) prda's Main{6nanre, Im, P- 135599 3991 321.37 55,99239 Awm 4507 ratchange= 6,046.92 55,991.19 - Ending Dalanee = 4100 -46390 Dentsb,Leam 310.67 = Beglnnlygabme= Rochang. -0.00 310.6Y = ending Mutate= 4.300.46]10 a9Ye11de0Yf 331gn 75.58 - DcglnnNg Balance+ 165 5126/201106/11 (nty4054) CAy Wide 1pc hlg, IMM92 129372 27.75 101.33 Oe Net6hange= 27.75 103.33 = Ending Balanlg - AJ1AA.iJ1Q PILOT 0,269.60 - eapndng 611ance= 165 630120110W11 (:Rexw 339):POdBxvrmg HOnN0J 10)281 RC 1.653.92 9,91).52 Anoka ClY PtopedY Tax km 9elChtn0e= 1,653.92 9,921.51 = Ending Balance= 4390 -45330 Taaee&tlLensee 1,903.38 = beginning 6Han¢= NotChan9ae 0.00 1,403.38 = Ending Balance = 4800 -46330 AOmdrdsOame Eayeates 680.31 = !ginning Balance" 165 6/29/201106/11 (dH) Comnon9Wnd Hausing P234090 52109 25.00 705.31 Tmst[d 6dgmd pis 3/11 114IChan9w 75.00 705.31 = Endng OMAN* - 4150.45330 Intadt on 0epodls 67.78 = BB)InnMq ealantt= IDS 613012011 06111 $a RP uideriecaual J-10818S G71 12." X22 Sec Min w4ennt wMal Neto.nge= 11.44 75.22 a Ending Balance = 5110-46330 OD309 & Impm unerRa 0.00 = Beginning 14bmo 165 6/21/201106111 (0110 Oon,"na0m HOUS09 PMIN 52531 2,025.90 2.025.90 EM Neale NO) (Id detaip Nal(htnge 4035.90 7,025.90 = Emkv aH.hbe = 39,865.46 11,319.4) Page 2 iml Jul.20. 2011 1 :40PM No.0479 P. 49 Parkview Villa North 716111 Bank Reconciliation Report 06/30/2011 5016458 Balance Per Bank Statement as of 06130/2011 $173,885.85 0911612008 297 10004005 - Greens 100.00 02109/2011 1199 court325 -Court Administration 55.00 02109/2011 1200 courI325 -Court Administration 320.00 0612212011 1352 clty4054 - CI1y Wide Locksmllhing, Inc. 27.75 0612212011 1355 dire - Direct Home Appliance Services 336.82 06122/2011 1360 zeph- Zephyr Services Inc. 662.00 00129/2011 1361 adam - Adam's Pest Control, Inc. 48.97 06129/2011 1362 chc • CommonBond Housing 33.77 06/2912011 1363 cumin - Cummins NPowel LLC 1,141.68 00129/2011 1304 home? - HD Supply Faclll(les Molnlenon00 198.47 06/29/2011 1365 afl1658 - Office of Enterprise Technalogy 240.12 06/29/2011 1366 gwes9116 -Qwost 38.77 06/29/2011 1367 xcel - Xcel Energy 4,038.84 Less: Outstanding Checks 1339 $7, 2 4 2.19 616,48 Reconciles! Bank Balance $165,643.66 Balance per GL as of 06/30/2011 $166,643.66 Reconciled Balance Per G/L $166,643.66 Difference 0.00 Cleared Items! Cleared Checks Dale Tran N Notes Amount Dale Cleared 05/1112011 1312 10004053 -Fleck 25,00 06130/2011 0511812011 1317 gard1066 - Gardner Plumbing, LLC 80.00 06/30/2011 0512512011 1328 offi - Office Depot $5,38 06/3012011 0512512011 1330 gwes9ll5. Olwest 38.77 06/3012011 05/25/2011 1331 sher4110 - Sherwin-Williams Go. 118.59 06/3012011 06102/2011 1334 edam - Adam's Paul Control, Inc. 48.97 0613012011 0610212011 1335 all - All lnc, 497.50 0613012011 06102/2011 1336 chc - Common9ond Housing 12,923.10 06/3012011 06102/2011 1337 m*3716 - MCI Comm Service 24.12 06130/2011 06/0212011 1338 offi650 - Office of Enterpriso Technology 240.62 06/30/2011 06/09/2011 1339 allm2138 - All Metro Lawn d Snow, LLC 616,48 06/30/2011 06/09/2011 1340 answ - AnswerLive LLC 30.27 06/30/2011 N Jul, 20. 2011 1:41 PM Notes No. 0479 P. 50 06102/2011 300 Parkview Villa North 26,210.00 0613012011 0611412011 305 Sank Reconciliation Report 2,498.00 06130/2011 06/2112011 301 06/30/2011 605.00 06130/2011 5016456 307 165 reapply 67.00 06130/2011 06/0912011 1341 home32 - Home Depot Credit ServICBe 85.74 06130/2011 06/09/2011 1342 kenn - Kennedy & Graven, Chartered 861.00 06/30/2011 0610912011 1343 Ibpm - LV Mechanical, Inc 296.75 06/30/2011 0610912011 1344 me1r9149 - Metro Appliance RacyCling, Inc. 113.16 0613012011 06/0912011 1345 oPo - OBrce Depot 81.26 0613012011 06/09/2011 1346 pe116513 -Laura Shaak 206.67 0613012011 0611512011 1347 t0004026 - MUJcIc 456.20 06130/2011 06/2212011 1348 allm2138 - All Metro Lawn & Snow, LLC 234.42 06/3012011 0612212011 1349 bfbp - BFB Painting, Inc. 600.00 06130/2011 06122/2011 1350 cent - CenterPoInt Energy 2,059.09 0613012011 06/22/2011 1351 chc- CommonBond Housing 49.19 0613012011 06/2212011 1353 comc3001- ComCasl 44.82 0613012011 06122/2011 1364 cumm - Cummins NPower Li 997.35 0613012011 06122/2011 1356 eagll - Eagle Elevator Corp. 855.40 08130/2011 0812212011 1357 holna7 - HD Supply Facilities Maintenance 99.33 0013012011 06/2212011 1358 prad • PradWs Maintenance, Inc. 294.59 0613012011 06122/2011 1359 wagn8150 - Wagner Sod Company, Inc. 14.32 06/30/2011 Total $21,649.09 Cleared Deposits Date Pon 0 Notes Amount Date Cleared 06102/2011 300 rent deposits 26,210.00 0613012011 0611412011 305 rent deposit$ 2,498.00 06130/2011 06/2112011 301 rent deposit 605.00 06130/2011 06/3012011 307 165 reapply 67.00 06130/2011 0613012011 306 laundry recalpls 232.75 0613012011 Total $29,632.75 Cleared Other Range Date Tran C Notes Amount Dale Cleared 08/00/2011 JE 107025 HUD Eloccs Opr Fund receipt 22,286.25 0513012011 06/2412011 JE 107926 HUD Eloccs Capital Fund receipt 2,025.00 08/30/2011 06127!2011 JE 107959 NEB PVS reimb 10110-4111 trash 2,957.43 06130/2011 Total $27,269.58 7/6111 MAO. 2011 1:41PM Aft Northeast B ank Me,nber FDIC No. 0479 P. 51 Date 6/30/11 Page 1 Primary Account Ending 6456 Enclosures 34 77 BI'oadway SI. N.E., Minneapolis, MN 55413 (812) 379.8611 - 24 hour telephone banking 651 - 6288607 Visit our websile at www. norlheastbank -mnRom ***** *x***** ** *AUTO° *3 -DIGIT 551 2998 0.8860 AT 0.365 23 1 14 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 326 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 lr lrlu l,�u ullllurulrlu i��� rlul11 uH�rE u 1, tY11411 A C C 0 U N T S - - -- WE ARE PROUD TO HOST THE IMUKA CHOIR FEATURING A NORTHEAST BANK FORMER EMPLOYEE, SMART BAITANI. THE CHOIR WILL PERFORM AT THE MINNEAPOLIS OFFICE THURSDAY, JULY 14 FROM 2- 2:30PM. NORTHEAST PUBLIC FUNDS ACCT Account Number Previous Balance 8 Deposits /credits 29 checks /Debits service Charge Interest Paid Ending Balance Number of Images 34 Ending Mv Statement Dates 6/01/11 thru 6/30/11 138,832.61 Days in the Statement Period 30 56,902.33 Average Ledger 165,584 21,849.09 Average collected 164,703 .00 .00 173,885.85 * w* * ww* www** wwwwwwb* w* r** w* ww* w*** w www******** ** * * * *w * * * **ww * * **wwww *w * * * *vrw ww Deposits and credits Date Description Amount 6/07 DDA REGULAR DEPOSIT 26,210.00 6/09 MISC PAY HUD TREAS 303 22,286.25 cR 6/03 3031036216 06/09/11 55.38 6/14 1312* ID #- 000009646860103 6/02 1330" TRACE #- 031036210903944 6/03 1317 6/14 DDA REGULAR DEPOSIT 2,498.00 �^ 6/21 DDA REGULAR DEPOSIT 605.OU 6/24 MISC PAY HUD TREAS 303 2,025,90 CR 3031036218 06/24/11 ID #- 000009646860103 TRACE #-031036211127830 6/27 Xfer from PUB FUND 0002 2,957.43 Reimb North for Trash bill 6/30 DDA REGULAR DEPOSIT 87.00 6/30 DDA REGULAR DEPOSIT 232.75 x* axxxxxx, rxa; ex** w* a* x*** xaw* rr *»wawww *wr **wwrr* * +r * *w *w *. wr, *w* *** *e **aaaa*a*xa** checks in serial order Date check# amount Date check# Amount 6/29 353 44.82 6/03 1328° 55.38 6/14 1312* 25.00 6/02 1330" 38.77 6/03 1317 80.00 6/01 1331 118.59 * indicates skip in check numbers Y69192 - 421 E Jul. 20. 201171 r 11:41PM „ t4l No.0479 P. 52 Date 6/30/11 Page 2 Primary account ending MW Enclosures 34 NORTHEAST PUBLIC FUNDS ACCT ending SM (continued) checks Date in serial order check# Amount Date check# Amount 6/07 1334* 48.97 6/17 1346 206.67 6/07 1335 497.50 6/24 1347 456.20 6/07 1336 12,923.10 6/28 1348 234.42 6/10 1337 24.12 6/28 1349 600.00 6/13 1338 240.62 6/28 1350 2,059.09 49.19 6/17 6/14 1339 1340 615.48 30.27 6/27 6/28 1351 1354* 997.35 6/15 1341 85.74 6/27 1356= 655.40 6/13 1342 861.00 6/28 1357 99.33 6/16 1343 296.75 6/27 1358 294.59 6/21 1344 113.16 6/28 1359 14.32 6/21 1345 81.26 # Indicates skip in check numbers *frdd #frfrd # *# * # * * * *w # # +rw Yr+ iwiiiddd ** *d5kk *dkG*Rk # # # # # #H #rt�r.v +ew wre to # #trww *dwd iLbww*dd Daily Date Balance section Balance Date Balance Date Balance 6/01 138,714.02 6/13 172,440.81 6/24 175,657.18 6/02 138,675.25 6/14 174,883.54 6/27 177,615.43 6/03 138,539.87 6/15 174,797.80 6/26 173,610.92 6/07 151,280.30 6/16 174,499.05 6/29 173,566.10 6/30 173,885.85 6/10 173,542.43 6/21 114,OB7.48 — ** w E N D 0 E S T A T E M E N T a d 769792 - M 6` Jul.20, 2011 1 :42PM No.0479 P, 53 Payment Summary Bark= 1650pr AND mm /yy= 06/2011 06/2011 AND All CheekS =Yes AND Include Voids.All Checks 28,298:54 �ti Check Post Total Dank Checks! Vendor Date Month Amount 1650pr - Parkvlew Villa North 1334 adam - Adam's Pest Control, Inc. 06/02/2011 06/2011 48.97 1650pr - ParkView Villa North 1335 all - All Inc. 06/02/2011 06/2011 497.50 1650pr - ParkVieW Villa North 1336 chc - Commoneord Housing 06/02/2011 06/2011 12,923.10 1650pr - ParKView Villa North 1337 mc1c3718 - MCI Comm Service 0610212011 06/2011 24.12 ' 1650pr - PArkweW Villa North 1338 of8658 - Office of Enterprise Technology 06/02/2011 06/2011 240.62 1650pr - PArkVk;w Villa North 1339 Alim2138 - All Metro Lawn & Snow, LLC 06109/2011 06/2011 615.48 1650pr - Parkvlaw Villa North 1340 answ - AnSwerilve LLC 06/09/2011 06/2011 30.27 16501)r - PArKVkw Villa North 1341 home32 - Home Depot Credit Services 06/09/2011 06/2011 85.74 165opr - ParkvleW Villa North 1342 Kenn - Kennedy & Graven, Chartered 06/0912011 06/2011 861.00 165opr - ParkvleW Villa North 1343 Ibpm - LBP Mechanical, Inc 0610912011 06/2011 298.75 I6Sopr - ParkvleW Villa North 1344 metr9149 - Metro Appliance Recycling, Inc. 06/0912011 06/2011 113.16 I6Sopr - ParkvleW Villa North 1345 air, - Office Depot 06/09/2011 06/2011 61.26 165opr - ParkVlew Villa North 1346 petl65ls • Laura Shenk 06/09/2011 06/20 206.61 1650pr - Parkvlew Villa North 1347 10004026 - Munic 06/158011 06/2011 456.20 I6Sopr - Parkvlew Villa North 1348 allln2138 - All Metro Lawn & Snow, LLC 06/22/2011 06/2011 234.42 I65opr - ParkvleW Villa North 1349 bfbp - BF8 Painting, Inc. 06/22/2011 06/2011 600,00 I65opr - PatkvIew Ville North 1350 cent • ConterPoint Energy 06/22/2011 06/2011 2,059.09 165opr - Parkvlew Villa North 1351 chc - CommonSond Housing O6/22/2D11 06/2011 49.19 165opr - Parkvlew Villa North 1352 city4054 • City Wide Locksmlthln9, Inc. 06/228011 0612011 21.75 165opr - Parkvlew Villa North 1353 comc3001 - ComiCast 06122/2011 0612011 44,02 165opr - Parkwew Villa North 1354 cumm - Cummins NPower LLC 06/22/2011 06/2011 997.35 165opr - ParkvleW Villa North 1355 dire - Direct Home Appliance Services 06/2212011 06/2011 336.82 165opr - Parkvlew Villa North 1356 eAgil • Eagle Elevator Corp. 06/22/2011 06/2011 655.40 165opr - Parkvlew Villa North 1357 home7 - HO Supply Facilities Maintenance 06122/2011 06/2011 99.33 165opr - Parkvlew Villa North 1358 prad • Prada's Maintenance, Inc. 06122/2011 0612011 294.59 165opr - Parkvlew Villa North 1359 wagn8150 -Wagner Sod Company, Inc, 06/22/2011 06/2011 14,32 165opr - Parkvlew Will North 1360 xeph - Zephyr Services Inc. 06/2212011 06/2011 662.00 I65opr - Parkvlew Villa North 1361 adam - Adam's Past Control, Inc. 06/2912011 06/2011 48.97 165opr - Parkvlew 0018 North 1362 chc - Commoneend Housing 06129/2011 06/2011 33.77 165opr - PafkVlew Villa North 1363 cumm - Cummins NPower LLC 06/29/2011 0612011 1,141.66 165opr - Parkvlew Villa North 1364 home7 - HD Supply Facilities Maintenance 06/2912011 06/2011 198.47 165opf - ParkvleW Villa North 1365 010658 - Office 61 Enterprise Technology 06/29/2011 0612011 240.12 1659pr - Parkvlew Ville North 1366 gweg9115 - Qwest 06/29/2011 06/2011 38.77 165opr - Parkvlew Villa north 1367 xcel - kcal Energy 06/29/2011 06/2011 4,038.84 28,298:54 �ti 6�b I ILA 'All NA76; 167 V, Inf n ip w A A s OI O O 6�b I ILA 'All NA76; 167 V, Inf Pi R N 7 W o a c m � d 2 bNN�no fJ W Am N oOO tnN O� �'D O d n x EF Q 8' � ^ T L � 6 C p) . O , ulO Oi W N < tD F S d 2 0 O V N � VI a of � D N V N OID V c I ( W N W S b AO t W0 , WWA y V V 1N O NG 11 OG+OO O A D OI 0 0 OI O A 6�b I ILA 'All NA76; 167 V, Inf W y7d N W NN bNN�no fJ W Am N oOO tnN 6�b I ILA 'All NA76; 167 V, Inf Jul. 20. 2011 1:42PM ua1nn a PRAPHIll Eli; s uo8�IX 8I hi m8 &$R t4 i38CL6 fig. l; W Sgt u8S i }CdBBffi +a uk 8 ��66dH i P W � wHVy V N 8 i wHbb t ' - a J g_1'iJ �o wo, ° om ° o R r PPI� a� 8BB86 $ 8888$ 1N ooy000 �' uoou�mfw' H BH8H"k'8898�w M N68 $bb�$bbooeob u�$��u� �8 y s y,,y 9 y,,yy W�Q o+bmouoo�oSd6Z'Q H B818Np Bo:WmY e�moo8�Ha88�e$� 4 Ooti000��m 8'°$B88Na�88889m u Sd98�Sbs8o8o88°0 s�b���oBoH�NH�'k 8T S8M, -1 BSC ONWOOONODO IOONY P NH± °0 0 0 0 0 0 ....00000a. N"a 6,. sa iSoe I�w 6b� y ( u ( Loo lS 88 N N NN mm0 N �1V m jog �8b 419 P. 55 p j X S. boo r: B u Ju1.20, 2011 1 43p No.l y y H Mgl �v y Mj� 493 gp y '� T90 gp 00009 R N 2111 $ �l LI M . &220 nn II A EW a {. a } y z g. n m a S e F f u �im 1 'o y 4/9 Y. h6 y 6 � p goo w °w ypp mom � 6g� Y b )H B N 9k i� I 0 N �w a w eY s� { 06P �,000eomoNgas�sas000 • yo. s it evo���L'HSas�om��.e�� �1'a gD ➢'D �SYy oo ° � +�a�i�� ° vo�m y m,�m 6{do}BY �u•�j'i Y '�+'o Sxe.o. �o N OOOOO60gONbmNHH000 ��oo:oeoe'sa�o�y &�e�m �� ° oFDFyS Y�'J S:,r�Y'n ab�m� l ° °ooe$$886$$�00000 Jul, 20, 2011 1 :43PM e a �o No. 0479 P, 57 C a, VS Jul. 20. 2011 1:43PM Parkview Villa South Financial Statement Overview June 2011 R evenue: No. 0479 P. 58 Occupancy for the month of May 2011 was 100% occupied; there were no vacant units as of 5/31/2011. Total Revenue was over budgeted amount (favorable). Administrative Expenses: Administrative costs for the South are under budget (favorable). Other Renting Expenses were under budget (favorable), and reflect minimum applicant screening needed due to low turnover. Office Salary line shows the staffing portion for North per contract, both office and maintenance staff. Office Supply expenses are under budget (favorable). Legal Expenses project was under budget (favorable), and reflects cost incurred for legal representation in resident lease termination process. Audit Expenses was under budget (favorable). Telephone, Answering Service and Internet expenses are under budget (unfavorable), and reflect costs associated with telephone, answering service, internet and office of enterprise technology. Bad Debts reflect rent receivables that were written off from past residents that owed rent damages at the time of move out. Management has filed these with collections in an attempt to recapture these fees. Utilities; Utilities Expenses are under budget (favorable). Water / Sewer are quarterly billings; Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses are under budget (favorable). on Ju1.20, 2011 1 :43PM No.0419 P. 59 Janitor and Cleaning Supplies are under budget (favorable). Janitor Contract expenses were slightly over budget (unfavorable), Exterminating Contract is over budget (unfavorable). Garbage and Trash are over budget (unfavorable); however this reflects a quarterly billing. Security Contract is over budget (unfavorable), and reflects cost incurred for power supply replacement and smoke detector panel service. Grounds Contract is under budget (favorable), and reflects cost incurred for grounds maintenance and for tree trimming. Repairs Material costs were under budget (favorable). Repairs Contract expenses were under budget (favorable). Elevator Maintenance Contract is slightly over budget (unfavorable), and reflects the cost of monthly maintenance Decorating Contract and Supplies were under budget (favorable). M.N. 2011 1 :44PM No. 0479 P. 60 Parkview Villa $both (166) ealance Sheet June 2011 Books G Accrual Jun-11 Assets 10100 Cash Balance 93,711.72 10200 Petry Cash 93.00 10400 Inveslnenls 567,570.36 11300 Rent Recelvable 36.00 11500 Accounts Receivable 0.00 Total Assets 661,411.08 Liabilities 20200 Accounts Payable 7,256.66 20210 Accrued Other Expenses 5,056.80 22000 Deposits; 9,250.67 22200 Accrued PILOT 5,666.11 22210 Revenue Collected In Advance 3,077.39 Total Liabilities 30,315.63 Fund Balance 25300 Fund Balance 631,095.45 Petal Fund Balance 631,095,45 Total Liabilities and Fund Balance 661,411.08 m Jul, 20. 2011 1 :44PM Parkview Villa -South (166) Income Statement For The Period Ending June 2011 Books c Accrual No. 0479 P. 61 Month to Date 1 10 Year to Date qy Revenue 34.01 0.13% 601.27 0.38% 36220 -46340 Gen. Government Rents 25,358.00 96.32% 151,791.81 96.34% 36225.46340 flondwelling Rents 465.00 1.77% 2,852.00 1,81% 36290-46340 Other Miscellaneous Revenue 503.75 1.91% 2,912.00 1.85% Total Revenue 26,326.75 100,00 157,5$5,81 100.00 Expenses Personal Services 1000.46340 Accrued Salanes 3,723.00 14.14 22,338.00 14.18% Total Pet501381 SerVICeS 3,723.00 14.14% 22,338.00 14.18% Supplies 2000 -46340 Office 5upplles 34.01 0.13% 601.27 0.38% 2010 -46340 Minor Equipment 502.50 1.91% 3,124.05 1,98% 2160 -46340 Maint. & Construct Materials 44.62 0.17 625.71 0.40% 2171.46340 General 5uppheS 15.97 0.06% 345.30 0.22% Total Supplies 597.10 2.27 4,696.33 2.98% Other Services & Charges 3040.46340 Legal Fees 0.00 0.00 0.00 0.00 0 /0 3050.46340 Expert & Professional Services 0.00 0.00% 0100 0.00 306046340 Management Services 2,025.00 7.69% 12,150.00 7.71% 3100.46340 Protective Services 0.00 0.00% 4,506.96 2.86% 3210 -46340 Telephone & Telegraph 173.05 0.66 0 /0 1,007.29 0.64 3430 -46340 AdverbsIng Other 15.05 0.06 0 /0 333.33 0.21% . 3600.46340 Insurance & Bonds 860.76 3.27% 5,074.76 3.22% 3810 - 46340 Electric 1,904.80 7.24% 6,424.87 4.08% 3820.46340 Water 0.00 0.00% 1,100.40 0.70% 3830 -46340 Gas 566.16 2.15% 12,840.14 8.15% 3840 -46340 Refuse 0.00 0.00% 3,039.44 1.93% 385046340 Sewer 0.00 0.00016 536.44 014% 4000-46340 Repair & Malnt. Services 4,171.63 15.85% 16,032.34 10.18 410046340 Rents & Leases 0100 0.00 0 /0 192.50 0.12% 4300-46340 Miscellaneous Charges 0.00 0.00% 99.74 0.06% 4315 -46340 PILOT 986.67 3.75 6 /b 5,920.02 3,76 1 /0 4390 -46340 Taxes & Licenses 0.00 0.00 0 /0 558.62 0.35% 4500.46340 Admhi(strative Expenses 25.00 0.09% 752.20 0.48% 4850 -46340 Interest on Deposits 6.90 0.03% 42.31 0.03% Total Other Sarvlces &Charges 10,735.10 40.76% 70,611.36 44.82% 0 Jul. 20. 2011 1 :44PM Capital Outlpy 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense No. 0479 P. 62 0.00% 0,00"/0 0.00 0.00 0.00 0.00% 15,055.20 57,19 97,645,69 61.98sb 11,271.55 42.81 59/!1'0.12 30,02 �Ql Ju1.20. 2011 NOM No.0419 P. 63 Parkvlew Villa South (166) Cash Flow Statement Period = 3une 2011 Revenue 36220 Gen. Government Rena 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue Total Revenue Personnel Services 1000 Accrued Salaries Total Personnel Services Supplies 2000 01111ce Supplies 2010 Minor Equipment 2160 Malnt. & Construct Materials 2171 General Supplies Total Supplies Other Sarvlces & charges 3040 Legal Fees 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Adverli Other 3600 Insurance & Bonds 3810 Electric 3020 Water 3830 Gas 3840 Refuse - 3850 SeWer 4000 Repair & Maint. Services 4100 Rent& Lease$ 4315 PILOT 4390 Taxes &Iloensas 4500 Administrative Expenses 4850 interest on oeposlts Total Other Services & Charges Total Expenses Excess (Deficit) ReVenlle over Experts" Adjustments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Total Adjustments cash Flow Month to Date 25,358.00 465.00 503.75 26,326.75 3,723.00 3,723.00 34.01 502.50 44.62 15.97 597,10 0.00 2,025.00 0.00 173.05 15.05 860.76 1,904.80 0.00 566.16 0.00 0.00 4,171.63 0.00 986.67 0.00 25.00 6.96 10,735.10 15,055.20 11,271.55 25.77 0.00 0.00 (3,797.26) 842.80 4.95 986.67 645.52 (1,291.57) 9,979.98 1� Jul. 20. 2011 1 :44PM 10100 cash Balance 10200 Petty Cash 1040D 1nVeslaledtS Total Cash No.0479 P. 64 Parkview Villa South ( 166) Cash Flow Statement Period = June 2011 Month to Date Beg Cash End Cash Difference L 83,731.74 93,711.72 9,979.98 93.06 93.00 482,070.36 482,070.36 - 565 895.16 575,875.08 9,979.98 POLIO Jul, 20• 2011 1:45PM No. 0479 P. 65 7114120113:09 PM G6narB111dget(ACCW0B1) PBrllvlew 1011IR South - (166) MDnlhe! Sun 2011 PN,.A7 Da te Podod Oacd Don Control Refer Debit Ctelit Balance RemerW 1000.96340 A((Ned$uanes 16,615.00 +NVAMm) wpm - 166 6/30/201106/11 (:Rehr 360):Postp Vrnng fb A'ni}10J2% RC 3,711.00 22,336.00 RIC CHC PR M9ml Fee NatChallge =3,773.00 21,33B.00 = Ending Balance= 2000.46340 Office Suppbo, 567.26 - Oeglnning Balance - 166 6/16/201106)11 (Om)OmR Dew p-235W2 5.6926)Ei11 34.01 601.77 notes, COff"a Netthange. 3401 601.27 - Ending Balance= 2010.46340 Minor Equipment 2,621,65 .. gp &dame -. 166 5/271201106/11 (014 An InC, P -72159 51260612001 502.50 3,124.05 (49 - 1 - *316 Helthanua• SOMA) 3,124.05 . Ending Balanrx = 2160.46340 Malnt.& CaPSWA. Malenal6 581.09 - ReolnNlg balanto 1% 5/27/2011 06111 (Oome7) NO Sdppty Facilities Mali w232162 9100071665pv 44.62 625.71 OxPM, badkeO ON . 14P1Chon9e= 44.42 423.71 = Fndln9 Balance - 2171.46340 General 5Lpp11in 32933 - 6auming Mance•. 166 61012011 as/11 (home32) Name DeW Credit Semc P- 235603 9322604 15.07 345.30 Bowe' NetChngn= 16.97 34330 = Ending Mtance - 3050 -46340 Management Services 20,125.00 -Beginning Balance - 166 6/30120110(1!11 ((M) Wrnmoneand Housing w2303S 53164 5,240.60 15,873.00 Mgmt Fe,16111 166 6/30/201106111 (:Raw 380):PoItR an)g Re 67.107296 Re 3,723.00 12,15000 RIC CHC PR Mgint ice Ne1Chonge= 2,025.OD 12,150,00 = Ending Balance = 3100.46340 Pmtecthe SeMces 4.506.96 - BegnMOMance- NetCh4,ge =000 4,506.96 = Fdding Balance= 3210 -46340 Toephom & Tekgnph 834.24 = MgNn419 Uia = 166 611/2011 06111 (arim) A7awa0(9 LAC P-23MI 1.10505E+11 13,40 847.)2 arm sc 6111 166 6/4201106111 (004100Dl) COmCa9 P- 232112 8.77211Cr11 20.13 867.65 Internet we- W11.7/1D 166 6/71201/ 06111 (gym69115) Qwest P- 233802 76)7883978(0 17,42 885.27 Rhone avc 6/O7.71D6 166 6/11/2011 0011 (22"0716) MCI COmm Service P235605 1611883076/0 14.14 B".41 phone ett 5 /206/10 166 6)151201106/11 (pi8658) OBke of Entapdse TahiN P- 233805 200800187106 102,08 1,007.29 phone set - per end 5131111 Net"aage= 173.05 1,007.29 - Ending Balance = 343(t.46340 Advervirr1g Other 318.28 . Negpm=ng eaAm'e= 166 6/721101106111 (ft) COMMOnROnd HOUdng NUM51 52746 15.05 333.33 Ita Tma Ad JPPe1)ON 2011 NatChanpe= 15.05 333,31 = Ending Balance - 3600 -46340 2nsurame 84 Banda 4,214,00 - Beginning Balance - 166 6/301201106111 (,Rear 310)'POnPtturdng RKWNI- 107296 RC 642.80. 5,056.10 C 0 CBIOmWa Heights Ina Ac 166 W301201106111 (:Raw 380):PmlRearring Ru ni,3- 107296 RC 17.96 5,074.76 IM Cerra Insurance NetChange= 160.76 5,074.76 = finding B.Innce = 3R111,461 Ek we 4,520.07 a Beginning Balance = 166 6113(201106111 (X(d)XW Eno9y PD3624 5150441553/0 1,9044D 6,424.07 clot avc 05 /07 NaMbOpe= 1,904.60 6,424.67 = Ending Balance = 382046340 Water 1,100.48 = Beggadng BaUrae = NatChanpe =0.00 1,10OA0 =FnOtrig Wants = 3630 -46340 Gas A7,273 98 =B MA9 a0AOM 166 6120/20/1 06111 (rent) CwWrPM431 Anew P-233860 5527M41061 566,16 IL840.14 gas svc 51046102, fills( auM Netthange= 966.16 12,140.14 = Fading Balan4a = 384046340 Rek, 3,039.44 = &gsn6g altana = 166 6110/201106111 (psn) PmW" Villas Roft P.M278 052311M -23 2,957.3 82.01 Reim prs mhpd by Awn 10 166 6 /10/2011 06111 (pm) ParWew Was North P -71276 05711Pa -7 2,957.43 (1,275.42) Reim Ain M Pd Wry pvn -10 166 6110/201106/11 uwn) Pa&lew Vibe North P-231278 05231104'-13 2,957.4) 82.01 Reim pw bah pd by Pvn - 10 166 61271201106111 MM WN ror shared trash ell I- ID7942 CI 2,957.43 3,D39.44 At"PVN V eWnd 000 Netthange. 100 3,039.44 a Ending Balance - 3050 -46340 Sewer $36.44 -&0llnlsgBalance- NetChanBe =0.00 536.44 = Ending Entente= g000d5'+40 ReOf B Maln1. S 1(26 11,160.71 = WMWPg UW(e = 166 5131120110W1I (a1m3138) All Mebp t "8, Snow, P- 212160 16 10532 11,966.03 lawn mint 5 /11 Palle i o Ju1.20, 2011 1,45PM No. 0419 P. 66 7/14/20113'-09 PM Geder4l Ledger (ACGual) Parkgiew Villa South - (166) Months) Jun 2011 P. Date Period O"cri tlnn control Relay Debit credit balance Remaraf 166 5131120// 06111 (w40n8150) Wagner Sod Qmpamy, 0.232163 11- 1142tam 6.44 11,972.47 Partf - Ong syf 5/24 166 51311201106111 (Wrap) era Finding, an. 0 05311111Vs 415.00 12,07.47 palPtlng 6316 165 51111201105111 ((ertl) 3eny's Floor Same P- 23380) )(622943 1,19120 13,58817 tap lnst 4116 166 61112011 06111 (cu ma) Cummins Ni atlo LLC P -032161 100-31574pvs 519.62 14,128.29 Ann switc)n/gndr malnt ag2o 165 6111201106111 (will Eagk Eketpr Corp. Pd32161, 1079204pH 294.46 14,422.75 me meld -6112 166 6/l/ 2011 06111 ()&m) 3errys Floor Store P432158 X628944 90529 15,328,4 vinyl, appilam #316 166 6/7/2011 06111 (adam) Adam's Pest Control, Inc. P- Z33604 MM66M 2220 15,35104 post wf #403, 315, 317 166 619/20u 06111 (home3l) Nome Depot Credit SWC0¢ 23%04 5327602pvs 13.20 15,363.74 Rovers I66 6/1312011 06111 (wakn74) Worker R.eng P 234100 11330 412.00 15,77514 All eamNlge 7epa6 166 WzW2D1106113 (oiMe) on Demand Professional Mut P•235607 7 128.55 15,903.79 deanMg 6119 ISIS 6126/201106/11 (ondd) On Demand Pmfa69Ma1 MN P135600 a 125.55 16,032.34 DaaiWlg 6126 NeIChsn6e= 4,171.63 16,032.34 = Ending Sulam- 4100 Rots& Wsas 192.50 -Fieprimpanlame- Ne3Chamga- 0.00 192.50 = Ending a9ladee = 43a0.46Y40 Miscellaneous chapoes 99.74 = BWAM9 galas( .-, NetChanye= 0.00 09.74 a ending salamis 4315 -44340 PILOT 4,933.35 = 0aglnnme Balance= 166 6/30/201106111 (:Recor380):P96tP<egMng BeNndy107296 RC 986.67 5,920.OZ Anoka Cry Propeity 73x how . Netchenge= 986.67 5,920.02 = Ending flacon. _ �300.4R340 trayiFs nsas 550.62 = 9eg10n1n09aledfe= t).Khahge= 0.00 558.62 n Ending Wan. n 4500 -46340 Admnisbowe Eavpenses 717.20 =Peglp fne Salamis 166 6/20/201106JI3 (Lhc) Comm.6ond Noi3O9 P- 234091 52010 25.80 752.2011usted &Pgm0 Cis 3111 NeRhange= 25.00 152.20 = Ending Balance = 4850.46340 inicrast an Deppg65 35.31 eeglnnmp Balance. 165 6/301201106111 Sec Dap Interest awual 3108191 031 638 42.31 Spec cep lnmreft iux,um Nelchinge =6.99 42.31 =Ending Galan.= 1469346 9,637.B6 Page 2 6 Jul, 20. 2011 1:45PM No. 0479 P. 67 Parkview Villa South 7/14111 Bank Reconciliation Report 06/30/2011 50'16464 Balance Per Bank Statement as of 06/3012011 $97,531.70 02/11/2009 309 mac - MCI Comm Service 5.47 06/2912011 1120 adam - Adam's Pest Control, Inc. 22.00 06/29/2011 1121 cent - CenmrP01n1 Energy 566,16 06120/2011 1122 chc - CommonBond Housing 15.05 0629/2011 1123 lent - Jerry's Floor Store 1,181.20 08/2912011 1124 offiUll - Offico 01 Entorprise Technology 107.88 0612912011 1125 gwes9115- owes[ 17.42 0612912011 1126 Ycel•Xcel Energy 1,904.80 . Less: Outstanding Checks 1098 $ 3,819.98 10.83 Reconciled Bank Balance $93,71132 Balance per GL as of 06/30/2011 $93,711.72 Reconciled Balance Per GIL $93,711.72 Difference 0.00 Cleared Items: Cleared Checks Date Tran 1f Notes Amount Dale Cleared 05/2512011 1089 offi - Office Depot 24.88 00/30/2011 05/2512011 1091 gwes9116 -Cwasl 17.42 06/30/2011 06/02/2011 1094 adam - Adam's Pest Control, Ina. 22.00 _ 06/302011 06/02/2011 1095 all - All Inc. 895.00 0813012011 06/02/2011 1096 chc - CommonBond Housing 5,748.00 0613012011 06/0212011 1097 home32 - Home Depot Credit Servlcas 89.61 06/3012011 0610212011 1098 mcic3718 - MCI Comm Servica 10.83 06!30/2011 06/022011 1099 oMB58 - Office of Enterprise Technology 108,10 06/30/2011 06/02/2011 1100 olse - Olsen rife Inspection, Inc. 225.00 067302011 06/09/2011 1102 allm2138 - All Metro Lawn & Snow, LLC 278.52 061302011 06/09!2011 1103 answ - AnswerLive LLC 13.48 06/302011 06/09/2011 1104 dlam8425 - Diamonds in the Rough 100.00 06/30/2011 06/09/2011 1105 home32 - Home Depot Credit Services 28.59 06/30/2011 06/09/2011 1106 met( 9149 - Metro Appliance Recycling, Inc. 50.84 06/3012011 06/092011 1107 off - Office Depot - 38.51 06/30/2011 06109/2011 1108 peti661s -Louis Sheak - 04.68 0613072011 06109/2011 1109 sher4110 - Shewn-W iliiams Co. 118.59 06/302011 U Jul, 20. 2011 1:46PM No, 0479 P. 68 Parkview Villa South 7/1011 Bank Reconciliation Report 06/30/2011 5016464 06/1512011 1110 chc- Commonsond Housing 17.96 06/3012011 0611512011 1111 10003800 - Kleine 208.03 0613012011 06/2212011 1112 all -All Inc. 602.50 0613012011 06122/2011 1113 allm2138 - All Metro LaWn & Snow, LLC 105.32 06Y30/2011 M22/2011 1114 eomc3001 - ComCast 20.13 06/3012011 06122/2011 1116 cumm - Cummins NPowar LLC 539.62 061302011 06/22/2011 1118 eagll - Eagle Elevator Corp. 294.46 06/3012011 0622/2011 1117 home7 - HD Supply Facilliles Maintenance 44,62 06/3012011 0612212011 1118 jerri - Jerrys Floor Store 906,20 0613012011 06122/2011 1119 wagn8150 - Wagner Sod Company, Inc. 6.44 0613012011 Total $10,494.42 Cleared Deposits Dale Tmn H Notes Amount Dale Cleamd 08/9212011 238 rent deposits 26,147.00 06130/2011 06/21/2011 239 rent deposit 1,440.29 06/30/2011 06/302011 241 lanudry racelpt$ 232.75 0613012011 Total $27,820.04 Cleared Other Items Data Tran N Notes Amount Date Cleared 06/102011 RC 619362 Returned Item t0003809 - 616.00 06/302011 06/272011 J6 107942 Rein PVN for shared trash sery - 10/104/11 - 2.957.43 06/30/2011 Total - $3,573.43 v"A MAO. 2011 1;46PM Northeast Bank Mcmber FDIC No. 0479 P. 69 Date 6/30/11 Page 1 Primary Account Ending 6464 Enclosures 30 77 Broadway St. N.E., Minneapolis, MN 55413 (612) 3798611 - 24 hour telephone banking 651 - 620 -9807 Visit our Wobsile at www. nadheaslbank- mn.com * *a * * * ** * * * * ** *AUTO * *3 -DIGIT 551 2999 0.8860 AT 0.365 23 1 15 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 IJ, I, Jdrn[III ltnI, I , III III IJtJC HI'E "c'IIK'IzhNIIG A C C O U N T 5 - - -- WE ARE PROUD TO HOST THE IMUKA CHOIR FEATURING A NORTHEAST BANK FORMER EMPLOYEE, SMART 8AITANI. THE CHOIR WILL PERFORM AT THE MINNEAPOLIS OFFICE THURSDAY, JULY 14 FROM 2- 2:30PM. NORTHEAST PUBLIC FUNDS ACCT Account Number Ending 64" Previous Balance 83,779.51 3 Deposits /Credits 27,820.04 29 Checks /Debits 14,067.85 service Charge .00 Interest Paid ,00 Ending Balance 97,531.70 Number of Images 30 Statement Dates 6/01/11 thru 6/30/11 Days in the statement Period 30 Average Ledger 98,021 Average collected 97,367 Deposits and Credits Date Description Amount 6107 DDA REGULAR DEPOSIT 26,147.00 6/21 DDA REGULAR DEPOSIT 1,440.29 6/30 DDA REGULAR DEPOSIT 232,75 d.vbx }d * * *ddkkvkkxw }ddddd * ** ddd* dx} xGx***** d* dxtxxGq * * *}*dpxxwW } * *d#kd* }dx * * * ** charges and Debits Date Description Amount 6/10 RETURN ITEM DEBIT 616.00 6/27 Xfer to PUB FUND 0001 2,957.43 '— Reimb North for Trash bill checks in serial order Date Check# Amount Date check# Amount 6/29 4 20.13 6/13 1098 10.83 6/03 1089* 24.88 6/13 1099 108.10 6/03 1091 17,42 6/08 1100 225,00 6/07 1D94* 22,00 6/17 1102} 216.52 6/07 1095 895.00 6/15 1103 13,48 6/07 1096 5,748.00 6/14 1104 100,00 6/08 1097 89,61 6/16 1105 28.59 * indicates skip in check numbers 769793 - 430 9' No. 0479 P. 70 Date 6/30/11 Page 2 erimary Account Ending AWI- Enclosures 30 NORTHEAST PUBLIC FUNDS ACCT Ending (Continued) Checks in serial order Date 6/21 check# 1106 Amount 50.84 Date 6/26 Check# 1113 Amount 105.32 6/20 1107 36.51 6/28 1115* 539.62 6/17 1108 84.69 6/27 1116 294.46 6/16 . 1109 118.59 6/28 1117 44.62 6/17 1110 17.96 6127 1118 905.29 6127 1111 208.03 6/28 1119 6.44 6/28 1112 502.50 * Indicates skip in check numbers } WWdW 4 dddwd*: cfii' ddd yW* Wkdddd* wd}** bd} bdWddk ?b } }dddbdfibdWwd }Wdd #d} *wpW}A*} Daily Balance section Date Balance Date Balance Date Balance 6/01 83,779.51 6/14 102,069.67 6127 98,517.58 6/03 83,737.21 6/15 102,056.19 6/28 97,319.08 6/07 103,219,21 6/16 101,909.01 6/29 97,298,95 6 /08 102,904.60 6/17 101,529.85 6/30 97,531.70 6/10 102,288.60 6/20 101,493.34 6/13 102,169.67 6/21 102,882.79 *** E N D O F S T A T E M E N T 769793 - 431 Vl/\ Jul, 20. 2011 1:46PM No. 0479 P. 71 Payment Summary bank= 166opr AND mm /yy- 06/2011.06/2011 AND All Checks= Yes AND Include Votds =All Checks 14,266.63 -1-P Chatit Past Total Bank Check# Vendor Date Month Amount 166opr - Parkvlew Villa South 1094 adam - Adam's PeSt Control, Inc. 06/02/2011 0612011 22.00 166upr - Parkvlew Villa South 1095 all • All Inc. 06/02/2D11 06/2011 895.00 166opr - Parkvlew Villa South 1096 chc - Commoni and Housing 06702/2011 0612011 5,748.00 166opr - Parkvlew Villa South 1097 home32 - Home Depot Credit Services 06102/2011 0612011 69.61 166apr - Parkvlew Villa South 1098 mcic3718 • MCI Comm Service 06/02/2011 06/2011 10.83 166opr- Parkview Villa South 1099 ofp6s8 - Office of Enterprise Technology 06/02/2011 06/2011 108,10 166opr • Parkvlew Villa South 1100 else • Olsen Fire Inspection, Inc. 06/0212011 06/2011 225.00 166opr - Parkvlew Villa South 1101 pvn • Parkvlew Villas North 0610212011 06/2011 2,957.43. 166opr • Parkvlew Villa South 1101 pvn - Parkview Villas North 06/03/2011 06/2011 (2,957.43) 166opr • Parkvlew Villa South 1102 al1m2138 - All Metro Lawn & SeOw, LLC 06/09/2011 06/2011 276.52 I66opr • Parkvlew Villa South 1103 answ - Answerl-Ne LLC 06/09/2011 06/2011 13.48 1660pr - Parkvlew Villa South 1104 OIAM8425 • Diamonds In the Rough 06/0912011 06/2011 100.00 166opr - Parkvlew Vila South 1105 home32 - Home Depot Credit Services 06109/2011 06/2011 28,59 I660pr • Parkview Villa South 1106 met,9149 • Metro Appllonce Recycling, Inc. 06/09/2011 06/2011 SO.84 1660pr- Parkview Villa South 1107 orn - Office Depot 06/09/2011 ,06/2011 36.51 1660pr = Parkview Villa South 1106 pet1661s • Laura Shook 06/09/2011 06/2011 84.68 1660pr - Parkview Villa South 1109 sheM110. Sherwln- Wllllams Co. 06/09/2011 0612011 118.59 1660pr - Parkview Villa South 1110 chc - Commun fond Housing 06/15/2011 06/2011 17.96 1660pr - Parkview Villa South 1111 10003000 • Kleine 06/t5/2031 06/2011 208.03 1660pr - Parkview Villa South 1112 all - All lot. 06/22/2011 06/2011 502,50 1660pr - Parkview Villa South 1113 31Im2138 - All Metro Lawn & Snow, LLC 06/22/2011 06/2011 105.32 1660pr - Parkview Villa South 1114 comc3001 • ComCa6t 06122/2011 06/2011 20.13 166opr • Parkview Villa South 1115 cumm - Cummins NPower LLC 06/22/2011 06/2011 539.62 1660pr - Parkview Villa South 1116 eaoll - Eagle Elevator Corp. 06/22/2011 0612011 294.46 1660pr - Parci iew Villa South 1117 home? - HD Supply Fadildes Maintenance 06/22/2011 06/2011 44.62 1660pr - Parkview Villa South 1118 Petri - Jerry's Floor Store 0602/2011 06/2011 905.29 I660pr - Parkview Villa South 1119 R'ag08150 • Wagner Sod Company, Inc. 06/22/2011 06/2011 6,44 1660pr - PArkVlOw, Villa South 1120 edam - Adam's Pest Control, Inc. 06/29/2011 06/2011 22.00 1660pr - Parkview Villa South 1121 cent - Centr int Energy 06129/2011 06/2011 566.16 I660pr - Parkvlew Villa South 1122 chc - CommonBond Housing 06/29/201 L 06/2011 15.05 1660pr - Parkview Vela South 1123 Jerrl - Jerry's Floor Store 06/29/2011 06/2011 1,181.20 1660pr - Parkvlew Villa South 1124 ofP658 - Office of Enterprise Technology 06/29/20L1 06/2011 107,88 1660pr - ParKNew Villa south 1125 gwes9115 - Qwest 06/2912011 05/2011 17.42 166opr - Parkview Villa South 1126 xcel - Kcel Energy 06/29/2011 06/2011 1,904.80 14,266.63 -1-P Jul, 20. 2011 1 :47PM p x C R g ¢ 'r1 D m Emb ¢Q � R m � e �� 193 �� s � 3RD a BB��L a �a H a a � P B i m le b b 0 ID ;I o s� �p a� g �r �N 13� Bq No.0479 P. 72 g N � ��Q 9 mW xnNMaEo9 A ptp Aga e�8ira�a��o�Wmo +VN 08o ° °ooWmNOmN »;86 11 N � t uo� &a tl& yy @ , @ � y p� jso - N�in M WJjftygq v N � BWBp ° o8 °o'&wE$ °a w Pi�NgoN p ogwa�e +or m�iyi nr . 3e a� b Y'w DDmsuoo m w+ w 'y u oiSO Sa 8888¢$Zq$o °�� °y 000 ° 000 ° o oe ° oee8888B88 �, N 1` Jul, 20. 2011 1:47PM No. 0 r me ygr V o l F JU Q$ f^a I HRO a�on5 lit 6�a BRA gmp 9 m q a g as a n �� w � � ° o oam aNa a88 &F: i w � f$ °aa f WEE emu p p � gGS�G W$YWW o I s : 88888 �.L� laesxN�sa's$soo��o� G N �78bi BSSS$BWM,w°°oeuR °SH NN ? �sN� Bkk^ L9ooRuem{.4mo�ox..eS9 ', I W CSm& �I eS .n y 688 1a p °ems .� " �i ebeubu$gSSa88�8f+ N+W A N N.8WN 1�8Z: 81588R�F3l�$oaNmoeo �NW Oy�yI y yY fJ pNp��p�Wy�y����pp pOp Z pp I IV. � C{ �pp ( uu ( ��pp� $ARV �$O{AU VPNWO60N�00Y : Rd�y 8)o ° NTNSSSoAao�gf= 888 88 ° 0 ° 0 ° 0 ° 0 ° 00 ° 0000$5866 419 P. 13 80 p > ,, 2 � � 5 Lp � a d _ .m Siob� p wA jS 5S' a m °em $bb�i N Y 0o K ad S$o� e A sa$ W em Y°a! 0H WON 'NOL }N O O°OI OI V� 000 �SS� I$ 4" Parkview Villa Apartments 965 40 °i Avenue NE, Columbia Heights, MN 55421 Owned by the City of Columbia Heights HRA Managed by CommonBond Communities Management report for Parkview Villa for the month of June 2011 Prepared by Laura Sheak, Property Manager Police Report There were no police calls for the month of June. Wait List 40 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicant for Parkview Villa North (employed in C.H.) 31 applicants for Parkview Villa North (non - resident, elderly, handicapped) (updated) 16 applicants for Parkview Villa North (no preference) 04 applicants for Parkview Villa South (resident C.H.) 06 applicants for Parkview Villa South (non- resident) 01 applicant for Parkview Villa South 2BR (resident) 00 applicant for Parkview Villa South 213R (non- resident) Occupancy North is 101 out of 101 (100% occupancy) (caretaker unit included in total number of units) South is 45 out of 45 (100 % occupancy) Move Outs # 507 6/18 Move INS # 316 6/01 # 506 6/01 Maintenance Report (See attached) �E �E 3;E L� , 'J Mahler's 4th Symphony, June 5, Sunday 4:00 p.m. Board Meeting Monday, June 6, 7:00 p.m. Resident Council Meeting— Monday, June 13, 7:00 p.m. U �E Fathers young, fathers old Remembering good times are our gold. Value earned through guidance given Helping us go forth in living'. Each father adding to our trove A treasure chest of love untold. Remembering father in our lives Taking time to realize. Fatherly love brings wealth to living Remembering this we go forth in giving. Fathers young, fathers old We remember you all As life unfolds. Ragini F mm 4 r i 16 .` LL t H 3 d F C O 2 C 0 0 0 o S o M N V N N 'n ti P. N N � N y Y y M v W ti W 0.1 ry 0.1 Fi n qz z z z q tq� a 0 4o ° ° , m 0.l m fA m GI m fA epo � egg �°'S N U U V rTi roa�g aa�'g "ado aa�o a��g .- /. 0\ W N W I. D\ W N ^ F. O• � N N S.. D, � N N /. 0` W N (J� O M a M o o '>pq` M W O In U A O tlj O a o OG � p q E3rg 0 U O o � v e z w d z ry d S a o o Q o Ir u rr °6: w V B: o O p '5 a A ro u ro e n V v. U v U v+ �i U W b ro ry Urn irm a d d V C l6 C C . G f6 3 d Y L CL E O Y Z @ O O a N @ O` "O C N N@ G U C C O L" Y O C Y {o O E N O 3 Y E C O 4 N o L E N LL c N v LL N a) 0 C L 3 O L@ N > O 0 N T Y @ O E ._ T O E @ >@ .L. @ >( s = m =(a > p@ C U E N Y> Z U) (9 Z 0 Q Mi � MMJ0 J 0)2mU 2 n. �(� >(D 1w J(n Qd () r 0 00 — Il- W 00 (D W O (o 00 O M d' N M M = 't M f-- O O O O M r 0 .- fl- Cl) M M N M M N M W V M M= M M M. I� C 7 r r p� � g _ o_aaaaao . o _ aaaadn . n.o_aao_a 'q' LOOM I- W W O O O N N M M co co W (D W (D W W..I. = ` NN NNNNN a!M (O((o(D((o00(Dw0(O co W (D(D0 co W I✓ A 0 y ANN M(D CD (fJ (D C (D �1� W 00�0� d LOS I� N O W OO NN d (D(D 0 ((D ( \ D (D (o(D W m(D(D 0(D0 0(D (D (D(D(D E O O O O o O O O O O o 0 o O O O O O O o 0 0 0 0 0 0 0 o O o 0 0 0 U 0 a vi N T U @ N N d L T m 3 N o m a C u E N O @ C 3 Q Y Y O 0 O N C d @ @ @ L ' °d YE m �0E 3 O > E L N @ N y y a�j .O aj Y y G C co co O 0 E S °o` w~ Y-o °— Co Co a3 EL ' — @ �. N .O N O V @@ U ° U 'O 'O 2 m 3 U 0 U O d 'O O d 0 O (o }� cu c .o 0) E d S 'p O .0 N C 0I U E ' 'O L d O Y d d U@ E 3 O C m 'O O N 0 0 0 O C L (0 O �' (� p �' �< y o. oi .0 0 C N O N O y _O U C N U C Q(D Z' Q @( N 0 n U@ O aj E d O N O N a@ N O E d @@ d N 0 O 4 @ w m@ d `a a) o n K d o 0 U >. L > 'p m a m .LU. O Co .D @ U 'O = C N U a L N O C� 7 0 N a N N a) C@ a O C O O =_ U N C p NE Y Y _ X 'O U 3 O @ . 3O O n O �_ 0) a7 U m 0 N 0 LL @ Ol C K V! C 0 0 ""' 0 0 O C p +' p a @ C O d a 0� U E ..N. - Y N 'O O) y 0 N m O Y= C C O d U U _N 0 U >i Y U1 >' N N O O E O) N C N m 0 .N N O N L N U (n V. Y N U E O 'O d d L C C N O Y O N N N O U C C 'c0 � N E O G m N Y O L O O N N A N O@ O) "� d 0) 0) @ 0) C C O U 0) L U E N 4/ 'O N N 0) E L O �- , O. Co O M N p ." _� L O 'O U O "' a3 E 0 _ C C p O C C N C . O y `u E 3 L 3 E o m E rn �_0. m �-0 3� E a s c m r a) � 3 a 0) O L � @ p 01 @ �' �"p m , 0) L E 3 0 � � L N @ O =' L O @ L O o .m L Q(n�MH2 JJ�Q Q l :7j (A S co U)cr m YY I—Y m(nl— irm a d d V C l6 C C . G f6 3 d Y L CL E O Y Z @ O O a N @ O` "O C N N@ G U C C O L" Y O C Y {o O E N O 3 Y E C O 4 N o L E N LL c N v LL N a) 0 C L 3 O L@ N > O 0 N T Y @ O E ._ T O E @ >@ .L. @ >( s = m =(a > p@ C U E N Y> Z U) (9 Z 0 Q Mi � MMJ0 J 0)2mU 2 n. �(� >(D 1w J(n Qd () r 0 00 — Il- W 00 (D W O (o 00 O M d' N M M = 't M f-- O O O O M r 0 .- fl- Cl) M M N M M N M W V M M= M M M. I� C 7 r r p� � g _ o_aaaaao . o _ aaaadn . n.o_aao_a 'q' LOOM I- W W O O O N N M M co co W (D W (D W W..I. = ` NN NNNNN a!M (O((o(D((o00(Dw0(O co W (D(D0 co W I✓ A 0 I 0 0 0 Cl) M m m 0 0 0 0 0000 0 l0 0 0 m O m m� 03 � ai-a— d N O x L 'C � LL N N N d O @ O O C w 'O O C O U O C d N a E E w = 0 o Y 3 M is m m m m 2 E O O L IO N N � (n J N N O N Lo - V Z Z (n Z n.an.a 0000 M M M M co Parkview villa Apartments 965 40` Avenue NE, Columbia Heights, MN 55421 Owned by the City of Columbia Heights HRA Managed by CommonBond Communities Management report for Parkview Villa for the month of May 2011 Prepared by Laura Sheak, Property Manager Police Report There were two police calls for the month of May. Call type: Noise residential, and Check welfare. Wait List 42 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicant for Parkview Villa North (employed in C.H.) 31 applicants for Parkview Villa North (non- resident, elderly, handicapped) (updated) 16 applicants for Parkview Villa North (no preference) 03 applicants for Parkview Villa South (resident C.H.) 06 applicants for Parkview Villa South (non - resident) 01 applicant for Parkview Villa South 2BR (resident) 00 applicant for Parkview Villa South 2BR (non- resident) Occupancy North is 101 out of 101 (100% occupancy) (caretaker unit included in total number of units) South is 45 out of 45 (100 % occupancy) Move Outs #316 5/31 #506 5/31 Move INS #123 5/1 #205 5/4 Maintenance Report (See attached) NEWSLETTER Managed by CommonBond Communities Owned by the City of Columbia Heights Management Office: 763 - 706 -3800 Hours: Monday through Friday 8:00 a.m. to 4:30 p.m. After Hours Maintenance Emergency: 651 -291 - Upcoming Events! Board Meeting Monday, May 2, 7:00 p.m. Resident Council Meeting— Monday, May 9, 7:00 p.m. 90th Birthday Party - Wednesday, May 18 Your Mother Is Always With You... Your mother is always with you... She's the whisper of the leaves as you walk down the street. She's the smell of bleach in your freshly laundered socks. She's the cool hand on your brow when you're not well. Your mother lives inside your laughter She's crystallized in every tear drop. She's the place you came from, your first home... She's the map you follow with every step that you take. She's your first love and your first heart break... and nothing on earth can separate you. Not time, Not space... Not even death... will ever separate you from your mother... You carry her inside of you... Author Unknown L ` h C a C T 9 VO f�A J 1 �F� b O W P W I N b J CI. `L N J .p p pp o m � S !� d Rf gy�pp �' or yr Ry 8 Ali O O F7 J H S O� O O g 0 8 g o J JJ S pJ O O pJ S •+ H b W A ' r • 'y s � j 13 g 'e L ` h C a C T 9 VO f�A J 1 �F� O M O M (O C) (O (O ON O O O O � M M N N L- ((O W o0 O M V' Ln V Lo V' N Lo Lo (f) Lo In Ln Ln In Ln N ll') Ln l(') Ln Ln Ln Ln (n Lo Lo Lo In N E 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O 0 O O O O 0 0 0 0 0 0 0 0 0 O U rn c_ T E � a E N N o O N 0 _ a) m O 0 N L O a C U ` p > cu a`) 0) n a r Z` o o c a cl C: c m Y o a m m o 1_1 a 0 U o m `o o O c ai cr c c a- L ai E -° o v n U a E2 m e d.a m Y o m a d'3 c o a oZCL0 a m� m 0E o na m O L a) a L a O C a m (6 Co a m o a E a a o@ c 3 0 r� �o W a) o� ° °-� d -° o m� Q 0 n o m O ( b a r a m �' a >, O Y O ~ ) o 'La o. o o C, N m D C� m 0 J a 7 o o) a C M c 00 o N 0 �' ( (D 00' .. W C 3 �. C N= 7 41+. w .t -L2G :�. - mY (D ~(D .D 7 N@ a W C N a� > 7 m C C' c - <7 o m. c a C o ( m c m m E n° c o s a c E 4) o a o> c m m a o LY N 0 N p 3 m C c ai c o .N a m c 0 d c o a 05'a (U a> o 3 Y o 0 a o a 0 3 0 c o 0 0 Q) � m E m a s N'c m 3 o o c 3 Y Co o mo 0 m o rn 3 m 3 ` a c N . @@ � m 0 0 a Y u v o v o N o a c w 3 E y o `o c L E o c Y -> oCOm�a m rn.c C O L �c�.am�"�`�5 0= o 0 0 0 0 L) y a a 4 m y v@ a a j am L N m o N E m 3 a c a a a s m m ay '� E o o o" o m ° o L N v o a' a m y N o ° o o a 0 ° c v c .m'm v `o s a a U Y E L 3 .m m a a a 3 a L o n 3 m o d L N a) 0@ 'O 0 O> m a) m L N N N m a) L C (0 E L m O '> O Z' O Uof d' JO_MF- U (n 0JmJ (o w0.ZZJT (o m 1� O Q d V C l0 C .4+ C 3 d Y L M E o J L E 5 3 c co m e E m t o c �c �c 3 r o U E [L c ua m O c p U 0= p U m p m m T Y O O L O L O a C T m c L O C C Z 1: U) 1: �(n SO LL IL U) F- CO m d� Z� m (n 2 m Zr. F-d'YN 7 7 M 0 V M M f- L(1 to (O LO LO LO O) O) M It N O .- V O W (D N N N O N O O 0 C) O O O O O O O N O N N LO It r t` t0 W 'd' V' M • C 7 r r 0) T� ( n (nmzwzZZZZZZ(nzzzzzzzzwzzZZZ(n( wz 10 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > �g aaaaaaaaaaan.aaaaaaaan . aaaaaaaaaa m O N LO LO LO W d' V L\ O CO CO (- O O O O O N N N Lo 0 0 (O h M W O a) V d ' d ' d ' V d ' LO N In Ln In ll') In N Ln In In In Ln O O O O O O O L D In Ln Ln M 0 0000(n N N N N NNmmom N N N N N N N N O M mom N O m Lo m� N N h N O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C 7 E C 0 � L � a 7 a 3 o E C O J L z @ -0 vi ai 7 �ai a) a) E3 @a c U c p) O a) a U C O o C 0 L 7 N O' 70 L'O L X00 y @a -C N a d DO U@ 'O w a) � 7 E C 7 0 Y N o 0 0-0 D. U V O O w 7 @ N c0 N 'O L C m N W m a) N `1 @ 'O L L a) a) U a Q Y .O p@ N V O@ U 8 O N o o o a �0 3 J E a) 0 m e c c .� Z c c a Of o N 7 (u � o o a a Y m o p) -® E E a ° c E o N N cc N o L ' C C N N a) N C 0)r c a m E c c c a) o Y c 7 O@ 0 O 7 C' Y a) O O 0 cp p N E y w- d m C O ' d d Y c !� `) o Y N a O O) CL c U) U 0) C y ¢ d d C 'O N "O N o C a o m a L Y L O) Y L L 0@ O) O) N O O to O C) r • C O C_ O) O) C L O O` S a) O L@ 3 Y J Y U d 0 J J x U a a z z 0 (n 2 I- O O co 0 N n Y Y to 7@ N N C C t d CL N U w tq 7 E d C L L 0) C L L N O U O E D O> 0 0— U U@ a) 'C U a) E (n C) Z) m U. 0 (n 0 = Y (n (n (L m Q (n z (n O) co O) N O) r O O W M (O (D M O � M 0 00 co of It M M O O N O t 0, 0 z(nz(n(nz(n(nz(nz(nz(n adaaaaaaao�.n�.aaa O O O O M M M 0 4] (O f- r )` )` O N N N N N N N N N N N N N N M M M M (1) (O 0 i0 N h N Ni?5 N 0 m 0 to (n to U) Attention all resident of Parkview North and South: Maelc your calendars for the next resident council meeting on June 13 7 pm. In attendance will be four member of the property management team coming from Aeron. Winifred Smith V R and Chief Operating Officer. wsmith aco mnn.or James Lehnhoff Sr. Project manager ilehnhofUaeommn.org They would like to address some of your questions about their potential purchase of our buildings. They stated if you have a computer you can e -mail your concerns and question to them at the above address. Otherwise, you can write you question down and bring them to the meeting on June 13 Aeron team is hopeful that by coming they will be able to help ease some of the anxiety levels about the potential sale of the property. Thank you, this should be a great meeting. Let us see as many people as possible come out for this meeting. Remember that the resident council is here to represent you. Without input from you, we are not able to address any question or get the answers After all; we are all in this together and have some great ideas as well as questions. Rheta Nelson President, Resident Council Parkview Villa North/South RESIDENT COUNCIL MEETING MINUTES - JUNE 13, 2011 Meeting was called to order at 7:00 p.m. Adam led the Pledge of Allegiance. Reports were given by: Secretary's report by DeAnne ( in Perry's absence) ❖ Treasurer's report & Petty Cash by Ken Bloch ❖ Sunshine report by Cecile •:t Bingo report by Jackie Resignations were received from: ❖ Terry White - Vice President ❖ Perry M. - Secretary both stating health reasons as their deciding factor. Nominations were received as follows: Shirley Benitez - #421 - for Vice President ❖ No nominations were received for Secretary; and Barb Camp nominated herself. In Terry White's absence, gave the Welcome to new residents: Becky - #709 Joan B. - #316 & Randy & Patrick - #123 A complaint was received on the spotting on the carpeting from the "B" room, into the hallway, to the Library. This is from residents taking coffee or beverages out of the "B" room WITHOUT A COVER. THIS IS NOT ALLOWED. ALL BEVERAGES MUST HAVE A LID ON THEM. A NAPKIN or PAPER PLATE IS NOT ACCEPTABLE. A sign will be put up stating any coffee /tea /beverage leaving the "B" room MUST HAVE A. LID secured on it, OR you drink, it in. the "B" Room before you. leave._ The meeting was turned over to HRA's Scott & Sheila to answer questions along with the AEON Company. AEON will send a print out of these questions and answers for all residents & they will be posted. $5 Drawing Winners: John Arthur; Al Gilbert; Ruth Hillestad; Cecelia Rothbauer. The meeting was adjourned. 4 00/w /feC w ..l 1 yam; �� �5 .� ✓ () JUT . --YtzV 1. . ..... 1 .0 RN .. ......... . (ITS" ` 7�% QAA ts7A� ILS , .. ......... . (ITS" ..... ...... CN sk , r jt . ........ 9: Zed K. �;V6%4 G Chair: Tommera Dichm Cmnmissioners: Gary Peterson Bruce Nawrocki Bobby Williams Donna Schmitt Executive Director Waller R. Pehst COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY DATE: July 20, 2011 TO: HRA Commissioners Walt relnst, HRA Executive Director PROM: Scott Clark, Community Development Director RE: Update on Aeon Transaction Memo #1 In an attempt to keep the HRA Commissioners informed as to the status of negotiations between the HRA and Aeon, HRA staff will be periodically providing status memos to the Commissioners. The first two months have been spent in due diligence work. Simply put, no negotiations for the building can commence until a number of key factors are understood. The first of these is the history of the building, contracts in place and what is the condition of the building. Based on this the following has transpired: May 13, 2011- HRA staff and Aeon met to develop a strategy session on how to proceed, information needed, milestones, etc. May 24, 2011- HRA approves a Memorandum of Understanding with Aeon. June 13, 2011- HRA staff and Aeon attended a Resident Council Meeting at Parkview Villa for a question and answer session (60 residents in attendance). June 13, 2011- HRA staff prepares a letter for the HRA Executive Director and Mayor to send to Federal, State and County elected representatives informing them of the HRA's action and intent to sell. June 2011- HRA staff reviews all existing files to determine pertinent information (e.g. contracts with HUD, site information, previous building contracts, etc.) Two full boxes of files are shipped to Aeon for review. June /July 2011- Aeon reviews all of the past HRA files in addition to utility bills to determine consumption, rent roles, budgets, etc. June 2011- Aeon orders title work and survey. July 2011- Aeon and HRA staffs finalize a written copy of answers to questions that were verbally stated at the July 13 Resident Council meeting. July 2011- Aeon orders four inspections to occur, these inspections will assist them to develop capital improvement plans and information needed for financing. Inspections are (1) Environmental Phase 1 (2) Lead and Asbestos Survey (3) Physical and Capital Needs Assessment and (4) Energy Audit. Early August 2011- Aeon acquisition team will tour Parkview villa to assess the building in detail Parkview Villa aeon. FREQUENTLY ASKED QUESTIONS Homes for Generations I. Who is Aeon? Aeon is a non - profit developer, owner and manager of affordable apartment homes in the Twin Cities. We were created 25 years ago by a group of faith based groups and housing advocates committed to providing the highest quality affordable rental apartment homes. 2. Why is Aeon proposing to purchase and operate Parkview Villa? What is the incentive to purchase the building? As part of the City of Columbia Heights decision to investigate a possible sale of Parkview Villa, the City sought out a responsible, reputable, and committed organization that would operate the property and support the residents. Through a Request for Proposal (RFP) process, they have asl<ed Aeon to work with them to explore the possible transition of ownership and operations so that Parkview Villa can be an excellent place to live for residents for the long -term. As a non - profit, Aeon is focused on investing in the community to create and preserve affordable and high - quality apartment homes for generations to come. 3. Will I still be able to live here? Aeon's vision is that every person has a home and is interconnected within community. It is our goal to worl<with all responsible residents who want to remain at Parkview Villa. 4. Will my rent go up? Will it still be affordable? If not what will Aeon do to help those that are not able to continue to live here? Aeon's mission is to create and sustain quality affordable homes that strengthen lives and communities. Our primary goal in working with the Columbia Heights HRA and the U.S. Department of Housing and Urban Development is to maintain the affordability and quality of Parl<view Villa North and South. Aeon worl<s to Keep rents affordable and manageable for all of our residents, but still provide high - quality homes and services. Rents usually go up a little every year in any rental property, even in assisted properties, because the cost of responsible operations increases (utility costs, maintenance, etc.). We plan to I<eep rents as low as possible and still operate Parkview Villa responsibly. 5. Will Parkview Villa change back to an all senior building? It is increasingly important to make sure our community has enough quality, affordable apartment homes for seniors, but many other people in the community also need a decent home. It was a federal rule that changed Parkview Villa from being all- senior to a mixed -age property. The issue of resident qualifications will be discussed as we go through this process and the type of financing may affect the outcome. In any case, we will work with the Columbia Heights HRA, HUD and residents to make it a great place to live, no matter who lives here. b. Will current residents have to go through another background check to see if we fit into the new management model when they buy this property? Under normal circumstances Aeon will not require existing Parkview Villa residents to submit to a new background check. It is possible that HUD may have that requirement, but it is unlikely. If we find out that they do, we will let you know. 7. Will we lose services and activities that currently exist here? Will there be social services provided in- house? Will you think about securing an emergency card for each apartment that would go directly to 911? We look forward to working with residents to understand and evaluate the services desired and needed. Aeon provides a wide variety of services at our properties, and we partner with other supportive service organizations to provide high - quality services and activities. 8. Will there still be a resident council or a way to advice new management? Whether Parkview Villa has a resident council is up to the residents. Our door is always open to residents, and we would continue to support the residents' decision to have a council. 9. If the property is sold, will there be a new site manager or caretakers? Our property management team will include a new site manager and caretaker that will build upon the work of the current management team. Providing high - quality, on -site management is very important to Aeon. We currently manage all of our properties with our in -house property management team, which helps us provide consistent performance and responsiveness to meet the needs of our residents. 10. Will either building be able to stay in the HUD system and keep rents at no more than 113 of income after a sale? Whether or not the building remains in the HUD system, the Columbia Heights Housing and Redevelopment Authority (HRA) and Aeon share the goal of retaining affordable rents at Parkview Villa. 11. How will the south building be affected if the property is sold? A primary goal of this process is to keep rents affordable and provide high quality services at Parkview Villa. This goal applies to both the south and north building. 12. How will the South Building be affected if the new company applies for the Transforming Rental Assistance (TRA) program through HUD? HUD's Transforming Rental Assistance (TRA) program is fairly new, and we will explore that program along with many others to help meet the HRA's long -term goals at Parkview Villa. All potential programs will need to be reviewed and evaluated along with the HRA before final program use decisions are made. 0) 13. How will (Aeon) handle the loud music that comes from the Star Bar? This diminishes the quality of life for those of us that live on that side of the South building. The issue of the Star Bar is an immediate issue. According to City staff, they have met with the owner to discuss ways of solving this issue. City Staff emphasize that if problems occur, residents should call 91 1 to alert the police. 14. How will you handle the smoking area outside the building? Will smoking be permitted in the individual apartments if the property is no longer owned by the HRA? As you know, there are rules about where smokers can smoke. When we manage we will work to understand the problems and appropriately and reasonably address any issues that reduce livability for residents. I S. How long will this process take? What will occur during this process? Due to the complexity of the HUD process, we don't know exactly how long it will take but the research and investigation will occur over several months. Due to the complexity of financing, the acquisition process may extend into 2012. Aeon will work with the HRA to research the HUD processes and other financing opportunities. As part of that process, there will be some inspections at the building to help us better understand the condition of the building and mechanical systems. 16. How can I stay informed about what will happen during this process? Along with the HRA, we are committed to keeping everyone informed throughout this process. As we move forward together, we will provide updated information at the building, attend resident meetings, and be available to answer questions. In addition, City staff will provide an update at the quarterly HRA meetings and are available for any questions. Before any sale occurs, information will be provided to residents and there will be an opportunity for a public meeting at Parkview Villa to answer questions. 17. Will there still be a Housing and Redevelopment Authority (HRA) if Parkview Villa is sold? According to City staff, probably not since the HRAs' sole authority and role is the ownership and management of Parkview Villa. 18. Who do I contact with questions? All day to day operations, maintenance, and rent questions should continue to go to the on- site manager at Parkview Villa. For questions about the potential sale process, you may contact James Lehnhoff at Aeon at 612- 746 -0522. At the City, you may contact Scott Clark at 763 - 706 -3672 or Sheila Cartney at 763 - 706 -3675. 3