Loading...
HomeMy WebLinkAbout2013-04-23 HRA AgendaHOUSING & REDEVELOPMENT AUTHORITY AGENDA 7:00 P.M. TUESDAY APRIL 23, 2013 PARKVIEW VILLA, COMMUNITY ROOM B, 965 40 "rr AVE., COLUMBIA IIEIGHTS, MN 1. Call to Order 2. Roll Call Tammera Diehm, Chair Bobby Williams, Vice Chair Rheta Nelson 3. Pledge of Allegiance CONSENT AGENDA Bruce Nawrocki Donna Schmitt, SecretaryfFreasurer Gary Peterson 4. Approve minutes of January 22, 2013 meeting and Special meeting of March 4, 2013 5. Approve Financial Report and payment of bills for January, February and March 2013 on Resolution 2013 -06. 6. Resolution 2013 -05, Interfund loan to City Motion: Move to waive the reading of Resolutions 2013 -05 and 2013 -06 there being ample copies available to the public. Motion: Move to approve consent agenda as presented. BUSINESS ITEMS 7. Report of Management Company 8. Resident Council Minutes 9. Citizen Forum* 10. Aeon Update (no attachments) 11. Other Business The next regular HRA meeting will be Tuesday. July 23, 2013 at Parkview, Villa. *At this time, citizens have an opportunity to discuss with the HRA items not on the regular agenda. 'Pile citizen is requested to limit their comments to live 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 MARCH 4, 2013 1. Call to order — The meeting was called to order by Chair Diehm at 6:30 pm. Bobby Williams took his Oath of Office. 2. Roll Call — Members present: Bruce Nawrocki, Gary Peterson, Donna Schmitt, Bobby Williams, Rheta Nelson, and Tammera Diehtn. Staff Present: Executive Director -Walt Fehst, Community Development Director -Scott Clark, and Assistant Community Development Director - Sheila Cartney. 3. Pledge of Allegiance — Recited PUBLIC HEARING 4. Amendment to the PHA Plan (including approval of Conversion Assessment and Conversion Plan) Resolution 2012 -04 Clark explained that the next steps in the sale of Parkview Villa is for the I -IRA to take action on a Conversion Assessment and Conversion Plan, in addition to a PHA Plan Amendment stating that the aforementioned action will be implemented. The Conversion Plan is a second try at the dissolution of the Public Housing Agency contract with the Department of Housing and Urban Development (HUD). The bottom line summary of these actions is 1) A Conversion Assessment illustrates, by the use of a HUD matrix, that the cost of operating the units as tenant -based housing ( meaning using project based section 8 as the form of assistance) is less than operating the facility as public housing with related assistance. The analysis, as shown on the Plan, illustrates a 11% cost saving to HUD 2) A Conversion Plan is the written process requirement for voluntary conversion of public housing to the voucher program described in item #1. The Plan describes the process, the maintaining of affordability, the use of net proceeds for renovation and the rationale for sale and conversion. Lastly, the other action is an amendment to the PHA Plan that simply states the above process. A 45 day review and comment period was held (the actual plan was reviewed at two community meetings) and no North residents formally commented on the Plan. One South resident did send a letter of inquiry and was responded to in kind. Staff recommends approval of the attached resolution. Note the resolution was developed through AEON's attorney to be in an appropriate form that HUD will accept. The passage of this resolution approves the PHA amendment and also approves and requests submission of the Conversion Assessment and Plan. Questions /comments from members: Nawrocki questioned if this is the second attempt at the dissolution, when was the first attempt made? Clark reminded him we did a Section 18 disposition process and that HUD changed their policy so the application was withdrawn and another path was taken. Nawrocki again asked for an explanation regarding the reserve funds of Parkview if approximately $1.5 million will be received for the sale. Clark explained that part of the $1.5 million includes the fund balances from the south building (approx. $100,000). The reserves for the north building would go into the rehab of that building and is a consideration in the overall sales process. Nawrocki wanted to know exactly what the funds would be used for. Clark told him that is a discussion for a different meeting since they have limited time for this special meeting. HRA Minutes Page 2 March 4, 2013 Nawrocki wanted to know why the Resolution came from Aeon's attorney. Clark told him that not many people have the expertise regarding I -IUD's dissolution process and for drawing up a Resolution that HUD will accept, and their attorney does. Nawrocki asked what Anoka County is giving us for this project? Clark stated that they have recommended giving Aeon some Home funds. Nawrocki then asked what the Resident Council's reaction was on this plan. Clark said they had no specific questions. Rheta Nelson stated that residents were not concerned with the details of the process. Nawrocki asked if this amendment changes what the Executive Director is allowed to sign off on. Clark told him clause #1 only pertains to minor changes, anything major would still be brought before the Board. Motion by Peterson, seconded by Williams, to vraive the reading of resolution 2013 -04 there being ample copies available to the public. All ayes. MOTIONPASSL'D. Motion by Peterson, seconded by Williams, to adopt Resolution 2013 -04, approving Resolution of the Columbia Heights Housing and Redevelopment Authority Confirming Approval and Significant Aniendniert to 5 -Year and Annual Plan. All Ayes. MOTION PASSES. HRA RESOLUTION 2013 -04 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) CONFIRMING APPROVAL AND SIGNIFICANT AMENDENT TO 5 -YEAR AND ANNUAL PHA PLAN WHEREAS, the Significant Amendment to 5 -Year and Annual PHA Plan (the Amendment) provides for the voluntary conversion to vouchers of the 101 -unit Parkview Villa North public housing development (the Development); and WHEREAS, the Amendment strikes current text in Section 7.0 of the 5 -Year Plan for fiscal years beginning January 1, 2010 and the Amoral Plan for the fiscal year beginning January 1, 2013 and substitutes the following: "The HRA is submitting a voluntary conversion to HUD for its 101 units of public housing under Section 22 of the United States Housing Act of 1937 and related requirements of the U.S. Department of Housing and Urban Development (HUD). The attached Conversion Assessment and Conversion Plan describe this action and the reasons for it. It is anticipated that, subject to fulfillment of all HUD requirements, the result will be a renovated development assisted by project -based vouchers with continued availability to current and future low - income households. In accordance with HUD requirements, the Conversion Assessment is submitted with the PHA's 5 -Year and Annual Plan as amended by this Significant Amendment and the Conversion Plan is made part of the 5 -Year and Annual Plan as amended by this Significant Amendment."; and WHEREAS, the Amendment's text was published for review and comment in the local newspaper and copies have been available for review at the local Public Library, administrative offices of the PHA, and the PHA development management office; and HRA Minutes Page 3 March 4, 2013 WHEREAS, }IRA staff met with the Resident Council of the Development, which also serves as the Resident Advisory Board, to review the Amendment, the Conversion Assessment and the Conversion Plan and received no written comments; and WHEREAS, the Board of Commissioners has reviewed the Amendment, the Conversion Assessment and the Conversion Plan and supports the contemplated actions as the best means of utilizing the Development to further long -term affordable housing in Columbia Heights; NOW, THEREFORE BE IT RESOLVED, by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that: (1) the Amendment to the 5 -Year and Annual Plan is adopted, provided that the Executive Director may make any necessary corrections or modifications to the Conversion Assessment and Conversion Plan prior to their submission to the U.S. Department of Housing and Urban Development (HUD); and (2) the Executive Director is authorized to take all actions necessary to provide for consideration and approval by HUD of the proposed voluntary conversion of the Development and otherwise to provide for the successful conversion, transfer of ownership and future use of the Development as proposed in the Conversion Assessment and Conversion Plan. ADOPTED THIS 01 Day of March, 2013 MOTION BY: SECONDED BY: ROLL CALL: HOUSING & REDEVELOPMENT AUTHORITY Chair- Tarmnera Dielmi Executive Director - Walter Fehst 5. Beautician Licensing Agreement Thespino Hamm, the beautician who worked at Parkview Villa for the past twenty years, retired at the end of January. The aforementioned position was not affiliated with the HRA in any employment sense. The role of the HRA was to give the beauty parlor space for no fee, in exchange for the service to the residents. Payments, bookkeeping and all aspects of the business were retained solely through the beautician, and this was memorialized in a contract that was signed in 2001. This service is important to the residents, and as such, staff wanted to get a new person in place immediately. Carmen Knake has done hair salon work in the community for over forty years and approached the staff regarding taking over this business, with the understanding that this would be a short term proposition due to the sale of the building. Staff had the HRA Attorney draft a new `Beautician Licensing Agreement' and all points have been agreed to by all parties. Ms. Knake is ready to take over immediately and has all of her insurances in place. IIRA Minutes Page 4 March 4, 2013 Staff recommends approval of the Agreement as written. Questions by members: Nawrocki asked if it was clear that this agreement would terminate at the completion of the sale. Clark stated, yes, it is detailed in the agreement and the new person is aware of this also. Motion by Peterson, seconded by Williams, to Approve "Beautician Licensing Agreement" Dated March 4, 2013, by and between the City of Columbia Heights Housing and Redevelopment Authority and Carmen Knake. All ayes. MOTION PASSED. Beautician Licensing Agreement This Licensing Agreement is made this 4th day of March, 2013, by and between the Housing and Redevelopment Authority of Columbia Heights (hereafter referred to as "the I -IRA ") located at 590 40th Avenue NE, Columbia Heights, Minnesota 55421, and Carmen Knake (hereafter referred to as "Consultant ") located at 965 40th Avenue NE, Columbia Heights. I. Obiectives The objectives of this agreement are as follows: Whereas, the HRA owns and manages multi- family housing facilities at 965 40 °i Avenue NE in Columbia Heights, Minnesota (hereafter referred to as "Parkview Villa "). Whereas, the HRA does not by its employees provide barber or beauty services for its residents at Parkview Villa, and desires to ensure that its residents have ready access to a licensed barber or beautician to maintain proper health and appearance on a regular basis; and Whereas, Consultant has the necessary qualifications and abilities to maintain a barber /beautician operation at Parkview Villa and is desirous of providing such an operation upon terms and conditions set forth below: Now therefore, in consideration of Consultant's use of the premises as well as the obligations outlined herein, it is hereby agreed by the parties as follows: IL Status of Parties The HRA and Consultant agree that their relationship is that of licensor /licensee and not of employer and employee or principal and agent. III. License Consultant is hereby licensed to provide barber and beautician services exclusively to residents of Parkview Villa on the premises as designated by the HRA. The barber and beautician services authorized by this agreement are limited to hair cutting and styling while expressly excluding other cosmetology services such as manicures, pedicures, facials, massages or any other services that beautify the skin or nails. The foregoing services will be conducted by the Consultant in a space designated by the HRA within Parkview Villa. Consultant will also be permitted to conduct limited retail sales of hair products to the residents within the designated area. HRA Minutes Page 5 March 4, 2013 IV. Insurance Consultant shall purchase and maintain general commercial liability insurance to protect against claims for damages because of injury to persons or damage /destruction of any tangible property arising out of the performance of Consultant's obligations under this agreement. The base limits for the general commercial liability insurance policy shall be at least $1,000,000. Consultant shall provide the HRA with evidence of the foregoing insurance in the form of a certificate from the insurer no later than ten (10) days after the execution of this agreement as well as when reasonably requested by the HRA thereafter. Consultant represents to the HRA that Consultant has no employees and will not employee any other person during the term of this agreement to provide the services at Parkview Villa as outlined herein. V. Credentials Consultant is responsible for insuring that appropriate licenses are obtained to render stated services at Parkview Villa. Consultant shall provide the HRA with a copy of said license at the start of the contract period and as updated thereafter. VI. Indemni Consultant shall defend, indemnify, and hold the HRA harmless against any and all claims, liabilities, damages or judgments asserted against, imposed upon or incurred by Consultant that arise out of acts or omissions, including malpractice, negligence or breach of this agreement by Consultant or any of its employees, agents or representatives in the discharge of its or their professional responsibilities to a resident under this agreement. VII. Discrimination Consultant will comply with all laws regarding discrimination on the basis of race, color, creed, religion, national origin, sex, sexual orientation, marital status, status with regard to public assistance, membership or activity in a local commission, disability or age. VIII. Confidentiality Consultant agrees to comply with the Minnesota Government Data Practices Act (the "Act") and all other applicable state and federal laws relating to data privacy or confidentiality. Contractor will immediately report to the HRA any requests from third parties for information relating to this Agreement, or the services provided hereunder. The HRA agrees to promptly respond to inquiries from the Consultant concerning data requests. All data created, collected, received stored, used, maintained or disseminated by Consultant in performing its obligations is subject to the requirements of the Act, and Consultant must comply with the requirements of the Act as if Contractor was a government entity. Any information regarding residents, clients, and the business of the HRA is considered confidential and must not be shared outside of the context of the service rendered or amongst residents living in Parkview Villa. IX. Consultant Obligations A. Provide barbering and /or beautician services to any male or female resident of Parkview Villa requesting same, upon a schedule or regular business hours sufficient to handle such requests. HRA Minutes Page 6 March 4, 2013 specific services to include but not limited to: shampoos, shampoo sets, haircuts, permanents, rinses, hair coloring, styling, etc. The barber and beautician services authorized by this agreement do not include other cosmetology services such as manicures, pedicures, facials, massages or any other services that beautify the skin or nails. (Consultant will not be required to provide services to a resident whose account with Consultant is in arrears, if applicable). B. Limit said treatment solely to residents of Parkview Villa and conduct no other business on the premises for other individuals. C. Furnish all supplies, tools, and items not otherwise provided by the HRA hereunder, necessary to conduct such operation in a professional manner, at Consultant's sole expense, specifically: shampoo, rinse /conditioner, hair rinse or colors, permanent solutions, curlers, curling irons, blow dryers, brushes, combs, clips, cleaning solutions and supplies. D. Post at all times, in a conspicuous place, Consultant's current charges for various services offered. Any change in charges must be pre - approved by the HRA. E. Comply in all aspects with standards and requirements of applicable State authority as to practices, procedures and conditions of the operation of barber /beauty shops. Arrange for qualified substitute personnel to maintain continuous operation in the event the Consultant is unavailable to operate shop on a regular basis, due to vacation, sickness, leave of absence or otherwise until Consultant's return. G. Follow State and Federal Resident Rights, State and Federal regulations related to infection control, MN Vulnerable Adult Law, and Parkview Villa Policies and Procedures. H. Sanitize all equipment (curlers, combs, brushes, etc.) after each such use in an approved disinfecting solution. As well as the laundering of any towels or linens used in conjunction of rendered services. L Maintain the work area, work station and supply storage areas in a clean and orderly manner at all times. J. Consultant will be held accountable and responsible for damages incurred to the HRA's property and /or equipment as a result of willful /malicious conduct with the intent to damage or damage incurred as a result of Consultant's negligent conduct. K. Consultant shall be solely responsible for the preparation of billing statements and collection of funds due from residents or clients for professional services rendered. The HRA shall not be responsible for any uncollectible accounts. L. Consultant's commerce to be limited to only customary barber /beauty services as outlined herein along limited retail sale of hair products. Consultant will not engage in any other business, trade or practice nor conduct marketing or sales for any other business, trade or practice while on the HRA's site. M. Consultant may market barber /beauty services that are offered by Consultant to the Parkview Villa residents. All marketing materials, communications, etc. will be produced and distributed at HRA Minutes Page 7 March 4, 2013 Consultant's expense. Marketing materials as well as means of distribution must be approved by the I-IRA prior to commencement of any marketing activities. O. Strictly comply with the HRA's non- smoking policy at Parkview Villa. X. HRA Obligations A. Space for Services The HRA agrees to provide Consultant with a designated space within Parkview Villa to adequately fulfill Consultant's obligations to provide barber and beautician services under this agreement. The HRA shall also provide necessary beating, air conditioning, water and electrical supply. The HRA also agrees to provide Consultant with the fixtures, items of equipment, and furnishings described in the attached Exhibit "A ". B. Supplies The HRA agrees to provide housekeeping services (floor care), maintenance services and office services (photocopying, faxes, etc.) within the space provided to Consultant for . C. Maintenance The HRA shall maintain designated space, fixtures and furnishings in good repair and working order, and provide necessary janitorial work. Consultant shall promptly report to the HRA any equipment or fixtures that are in need of repair. XI. Term of Agreement 1. This agreement will continence on the _ day of , 2013, and shall be in existence for a period of one year from and after the commencement date. Thereafter, this agreement will automatically renew on each anniversary date unless terminated by either party hereto. 2. This agreement may be terminated, at any time, by either party upon a written 30 -day notice to the other party. 3. This agreement may be terminated immediately by the HRA upon written notice to the Consultant in the event the health or safety of any resident of Parkview Villa deemed to be at risk. X11. Delegation /Assignment Neither party hereto shall delegate responsibilities nor assign rights acquired hereunder without the prior written approval of the other party. XIII. Amendments No amendments may be made to this agreement except in writing and executed in the same manner as this agreement. HRA Minutes Page 8 March 4, 2013 XIV. Notices Any notice or demand authorized or required under this Agreement shall be in writing and shall be sent by certified mail to the other party as follows: To Consultant: To the HRA: HOUSING AND REDEVELOPMENT AUTHORITY OF COLUMBIA HEIGHTS m Its: Date: CONSULTANT By: Its: Date: By: Its: Date: Exhibit A Fixtures, items of equipment, furnishings located in the barber /beauty shop at Parkview Villa that are the property of the BRA include the following: uanti Description 2 Each Chair with Hairdryer attached 1 Each Beauty Chair It is agreed between the undersigned that the equipment described above is the property of HRA. HOUSING AND REDEVELOPMENT AUTHORITY OF COLUMBIA HEIGHTS By: Its: Date: CONSULTANT Date: IN Its: Date: HRA Minutes Page 9 March 4, 2013 Diehm stated the next regular meeting is scheduled for Tuesday, April 23`d, 2013. The meeting was adjourned at 6:45 pm. Respectfully submitted, Sheila Cartney Acting Secretary HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE MEETING OF JANUARY 22, 2013 1. Call to order — The meeting was called to order by Chair Diehm at 7:00 pm. Gary Peterson and Bruce Nawrocki took their Oath of Office. 2. Roll Call — Members present: Bruce Nawrocki, Gary Peterson, Donna Schmitt, Rheta Nelson, and Tammera Diehm. Members Absent: 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: Lisa Wilcox - Erhart, Laura Frost, Jennifer Eells, and Jennifer Vota. 3. Pledge of Allegiance — Recited 4. Election of Officers- Motion by Peterson, seconded by Nawrocki to elect officers as follows: Chair- Diehm Vice Chair- Schmitt Secretary /Treasurer- Nawrocki All ayes. Motion Passed. CONSENT AGENDA 5. Approve Minutes from the meeting of October 23, 2012. 6. Approve Financial Report and Payment of Bills for October, November, and December 2012 on Resolution 2013 -01. HRA RESOLUTION 2013 -01 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR OCTOBER, NOVEMBER AND DECEMBER 2012 AND PAYMENT OF BILLS FOR THE MONTHS OF OCTOBER, NOVEMBER, AND DECEMBER 2012. 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 HR-A'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 HRA Minutes Page 2 January 22, 2013 WHEREAS, the financial statement for the months of October, November and December 2012 and the list of bills for the months of October, November and December 2012 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 22`1 day of January 2013. MOTION BY: Peterson SECONDED BY: Schmitt AYES: All ayes Chair Attest by: Shelley Hanson, Secretary 7. Approving Depository and Signatories Clark explained this is an annual function decided at the first meeting of each year. RESOLUTION NO. 2013-02 RESOLUTION DESIGNATING DEPOSITORY FOR THE COLUMBIA RE, IGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) WHEREAS, the City of Columbia Heights Housing and Redevelopment Authority (herein referred to as the "Corporation") has entered into a Management Contract with CommonBond Housing (herein referred to as "Management Company "), dated January 23, 2008, and amended on November 9, 2009 and extended on October 25, 2011 and January 22, 2013, and WHEREAS, by Minnesota Statutes the Corporation must establish a depository agency, and WHEREAS, the Corporation desires to have as authorized signatures both officers of the Corporation and the Management Company. HRA Minutes Page 3 January 22, 2013 IT IS HEREBY RESOLVED, that Northeast Bank, is hereby designated as a depository of the funds of this corporation. IT IS FURTHER RESOLVED, that checks, drafts, or other withdrawal orders issued against the funds of this corporation on deposit with said bank shall be signed by at least two of the following: HRA Executive Director Management Company CEO Management Senior Vice president Management Director of Administration And that said bank is hereby fully authorized to pay and charge to the account of this Corporation any checks, drafts, or other withdrawal orders. BE IT FURTHER RESOLVED, that the Northeast Bank, is designated depository of the Corporation and it is hereby requested, authorized and directed to honor checks, drafts or other orders for the payment of money drawn in this Corporation's name, including those drawn to the individual order of any person or person whose name or names appear thereon as signer or signers thereof, when hearing or purporting to bear the facsimile signatures of at least two of the following: Management Company CEO Management Company Senior Vice President Management Company Directors of Administration And that Northeast Bank shall be entitled to honor and to charge this Corporation for all such checks, drafts or other orders, regardless of by whom or by what means the facsimile signature or signatures thereon may have been affixed thereto, if such facsimile signature resembles the facsimile specimens duly certified to or filed with the Bank by the City Clerk or other officer of this Corporation. BE IT FURTHER RESOLVED, that any and all resolutions heretofore adopted by the Corporation and certified to as governing the operation of the Corporation's account(s) with it, be and are hereby continued in full force and effect, except as the same may be supplemented or modified by the foregoing part of this resolution. BE IT FURTHER RESOLVED, that all transactions, if any relating to deposits, withdrawals, re- discounts and borrowings by or on behalf of this Corporation with said bank prior to the adoption of this resolution be, and the same hereby are, in all things ratified, approved and confirmed. BE IT FURTHER RESOLVED, that any bank or savings and loan located in the State of Minnesota may be used as depositories for investment purposes so long as the investments comply with authorized investments as set forth in Minnesota Statutes. BE IT FURTHER RESOLVED, that any brokerage firm located in the State of Minnesota may be used as a depository for investment purposes so long as the investments comply with the authorized investments as set forth in Minnesota Statutes. Passed this 22 "`1 day of January, 2013 Offered by: Peterson Seconded by: Schmitt Roll Call: All ayes Chair Shelley Hanson- Secretary HRA Minutes Page 4 January 22, 2013 Questions from members: Nawrocki asked if we are getting interest on our accounts at NE Bank. Frost said we do not get interest on the Checking Account but we do on the Reserve Accounts. He stated that he still believes an officer should also be required to sign all checks. He doesn't think that management personnel should be the only signature on the checks. Clark stated that is the way it was established when the contract was drawn up. He reminded members that anything over $15,000 requires Walt's signature and that all expenditures are reviewed by the Board on a quarterly basis. Wilcox- Erhart stated this is common practice at the other entities they manage. This allows them to conduct the day to day business and emergency expenses as they arise in a timely manner. Motion by Peterson, seconded by Schmitt, to approve the consent agenda items as listed. All ayes. M077ON PASSED. 8. Report of the Management Company Lisa Wilcox- Erhart, Laura Frost and Jennifer Eells, from CommonBond, were present to answer any questions from the members. Frost gave a brief report. She stated we don't know exactly what the 2013 Capital Grant will be yet. It is usually awarded at the end of first quarter and should be approximately $19,000. We also don't know how much the operating grant will be for 2013. It could be as much as $30,000. Frost said the first floor modernization is moving forward. They took the HRA Board's and Aeon's recommendations to the architect from WAI. They are preparing the specs and will go out for bids in February and hope to begin the renovations in March. Frost also told the members that they have been notified that the Fire Panel for the buildings is outdated. They are operational for now, but are obsolete so repairs can no longer be made to the system. They are seeking bids for a new system. She said this was bid out a few years ago and the price at that time was around $80,000. Nawrocki asked what function the Fire Panel served. She explained that all smoke detectors and alarms are tied into the panel and if there is a fire it would activate the sprinkler systems. He asked what funds would be used to replace this system. She responded that it would probably have to come from several sources. If there are any funds leftover from the modernization project, they could be used, or they would have to look at the operating grant, the capital grant, or possibly a reserve account. Schmitt asked why the system wasn't replaced a few years ago when bids were taken. Staff said that would have to be researched as to why the Board did not proceed with the project at that time. Wilcox - Erhart gave a staffing update since Jennifer Eells is leaving at the end of the week. She stated that they have held interviews for the position of the on -site Manager and they will be offering the position to someone. Until she can start, Jennifer will be corning back one day a week, a roving Manager will be on site two days a week and Jennifer Vota will be present 5 days a week as before. Jennifer Fells thanked the residents and HRA Board and city staff for all their cooperation during her time at Parkview Villa. IIRA Minutes Page 5 January 22, 2013 Resident Council Minutes Leeann Miller is the new President of the Resident Council. She was introduced to members. She stated the only thing that has happened since she took office is some entertainment that took place this month for the residents. She said it wasn't very well attended, but was enjoyed by those who did. 10. Citizen Forum No one wished to speak at this time. 11. Management Contract with CommonBond Clark explained that the originally agreed to five year Management Agreement with Common -Bond is expiring on January 31, 2013. As such, CommonBond is seeking a one year management "extension" with the understanding that the sale of Parkview Villa will probably be occurring within this time line. As such, the attached resolution approves a new management period terminating on January 31, 2014 (with no increases) and that a 60 day termination notice can be given by the HRA at any time based upon the sale process. Staff recommends approval of Resolution 2013 -03 as written. Question from members: 'rhe Board asked if this had been reviewed and agreed to by CommonBond. Clark responded that it had. Motion by Peterson, seconded by Schmitt, to waive the reading of Resolution 2013 -03, there being ample copies available to the public. All ayes. MOTION PASSED. Motion by Peterson, seconded by Schmitt, to adapt Resolution 2013 -03, being a Resolution of the Housing and Redevelopment Authority in and for the City of Columbia Heights, approving an extension of the CommonBond Housing Management Contract until.Ianuary 31, 2014 for Management of Parkview Villa North and South. All ayes. MOTION PASSED. HRA Minutes Page 6 January 22, 2013 HRA RESOLUTION 2013 -03 EXTENSION OF COMMONBOND HOUSING MANAGEMENT CONTRACT UNTIL JANUARY 31, 2014 FOR MANAGEMENT OF PARKVIEW VILLA NORTH AND SOUTH WHEREAS, on January 23, 2008 the City of Columbia Heights's Housing and Redevelopment Authority (HRA) approved a management agreement with CommonBond Housing (CommonBond) which included a provision for a five -year contract, and WHEREAS, the Department of Housing and Urban Development (HUD) denied the ability of the HRA to enter into a five -year contract based on a previously approved 1969 Annual Contributions Contract which limits all contracts to two years, and WHEREAS, in order to meet the spirit and intent of the originally approved five year contract both HUD and the HRA agreed to a management contract term of an initial two year period with three one -year extensions, and WHEREAS, this language is memorialized in Section 1.3 of the final and approved contract approved by the HRA on April 22, 2008, and WHEREAS, a new contract period is desired with the understanding that the sale of the subject property is probable in 2013, and WHEREAS, the HRA is satisfied by the performance and competence of CommonBond and desire to extend the subject term until the time of the sale; NOW THEREFORE BE IT RESOLVED, 1) The HRA approves a one -year management contract extension running from February 1, 2013 to January 31, 2014 2) Section 10.2 shall be amended to read, "This Agreement shall be terminated upon the sale of the Premises or in the case of building demolition caused by natural or man -made causes. In the case of sale the Owner retains the right to give the Agent a 60 calendar day notice of termination at an ;mint in the sales process. 3) All other provisions of the contract dated April 22, 2008 Management Agreement between CommonBond and the HRA remains in place. Passed this 22nd day of January 2013. MOTION BY: Peterson SECONDED BY: Schmitt Chair Attest by: Shelley Hanson, Recording Secretary I-IRA Minutes Page 7 January 22, 2013 12. Update from Aeon James Lehnhoff, the Sr. Developer from Aeon and Miranda Walker, Project Manager were present at the meeting to update the members on recent events. Lehnhoff said that they were awarded the 1.5 million dollar funding from MIIFA to help with the gap financing. MHFA is very supportive of this project. Lehnhoff also told members that they held two meetings last week with residents to update them on the progress of the sale and to go over the general information notice that they had to give to residents again since the process to dissolve the PHA has changed. HUD required new signed slips since changing to a Voluntary Conversion Plan, The Voluntary Conversion Plan must prove to HUD through a cost analysis that it's more advantageous to HUD to convert these buildings. The Plan must detail the future use of the buildings and that they will be kept as affordable apartments. The Plan must provide an analysis of the market value, so the previous appraisal is being updated. This will also support the overall condition of the building to show its marketability. The Plan must detail the benefits to PHA such as the plans to remodel /update the building which will provide better housing options to the residents and its effect on the community as a whole. The Plan must also cover any relocation plans, however that is not applicable as Aeon has no plans to re- locate anyone. Once this Plan is submitted to HUD, they must review it. Lehnhoff still anticipates a closing before the end of the year. In the meantime, Aeon has hired architects and general contractors to coordinate future plans and renovations. During the next 4 -5 months they will be assessing the condition of the units and what improvements will be needed. Lehnhoff said they are also assessing the support services that would benefit the residents. Clark stated that Aeon has also applied for a grant of HOME Funds through Anoka County. We should know their final decision by April. Nawrocki asked if any of the residents had any questions they haven't had answered. No one present had any concerns. Lehnhoff also encouraged residents to ask any questions of him or staff and he will do his best to answer them. He wants this to be an open process for all parties involved. 13. Call a Special Meeting for Monday, March 4, 2013 Clark explained the only item on the agenda will be the Amendment to the PHA and the Resolution for the Voluntary Conversion and Assessment Plan. We need to hold the meeting so the process can move along. We have to wait until the end of the comment period before holding a meeting, so this is the first available date to approve these items. The meeting is scheduled for 6:30 pm before the Council Work Session. HRA Minutes Page 8 January 22, 2013 14. Other New Business Nawrocki asked whether there was any back up material for the meeting that will be held Thursday, January 24, 2013. Clark responded that this is not an HRA matter. He wanted to assure the residents present that the January 24th meeting has nothing to do with them or the sale. He then explained to Mr. Nawrocki that there is no backup material to give to members at this time. He told members that a small group of people will be making a presentation to discuss a conceptual idea, and how it could work, if the Council is interested in pursuing the idea further. No action will be taken at this meeting, they will just be asked to listen to see if this is a direction they may wish to consider further. Nawrocki asked who would be making this presentation. Clark told him Frank Dunbar from Dunbar Development—James Winkle from Amcon Construction— Stacie Kvilvang from Ehlers —and possibly an architect. Diehm stated the next regular meeting is scheduled for Tuesday, April 23'd 2013. The meeting was adjourned at 7:50 pm. Respectfully submitted, Shelley Hanson Recording Secretary COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) Meeting of: April 23, 2013 AGENDA SECTION: Consent Agenda ORIGINATING EXECUTIVE NO: 5 DEPARTMENT: HRA DIRECTOR APPROVALL ITEM: Financial Report and Payment of Bills BY: Laura Frost BY��! — Resolution 2013 -06 DATE: April 10, 2013 BACKGROUND: A copy of the Financial Reports for the months of January, February, and March 2013 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 2013 -06, there being ample copies available to the public. Motion: Move to approve Resolution 2013 -06, Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills for the months of January, February and March 2013. CIA ie�ItliTilp -111 M Ke.&PH i 1(19➢1/ 9 HRA ACTION: HRA RESOLUTION 2013 -06 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JANUARY, FEBRUARY AND MARCH 2013 AND PAYMENT OF BILLS FOR THE MONTHS OF JANUARY, FEBRUARY AND 2013. 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 January, February and March 2013 and the list of bills for the months of January, February and March 2013 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 23rd day of April 2013. MOTION BY: SECONDED BY: AYES: Chair Attest by: Shelley Hanson, Secretary Parkview Villa South Financial Statement Overview March 2013 Revenue: Occupancy for the month of March was 80% occupied Total Revenue was lower than budget amount (unfavorable) this is due to vacancy Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were under budget (favorable) Office Supplies was under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Misc. Admin Expenses were over budget (unfavorable) due to incorrect charges - reversed in March Utilities: Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing Electric was under budget (unfavorable) and reflects billing from February Gas was slightly over budget (unfavorable) and reflects billing from February Water and Sewer were not invoiced in March Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Maintenance Supplies was over budget (unfavorable) and reflects a stock up of supplies and parts Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Heating and Cooling Maint and Repairs was under budget (favorable) Snow Removal was over budget (unfavorable) and reflects invoices from February and March Misc Operating Expenses was over budget (unfavorable) and reflects cost of copier lease portion paid to the City of Columbia Heights rn Cam. Q n. 0 9� oFm Y 0 N 1 ml m O o c Eo m In O O N U N w > a m n a Z � � c a ft1 a m° K O o o sQU o O o o O O O ONO 0. 0 0 0 0 p a 1. O r N � N{ O, ON. W N p N a0r M cO NfO N m NN r NO>O V m0 N N N M N M M M Q N Q �m N OOI O (00"O 00100 V M V tp Z 1� CO m O r� tF N O m O m O N O O r m O] N q V V' O NI� W i N O V OON]ONOOm� 0 O N ' k a o Cd m N O O O O r r V O V O V W N N M Q) d: �jM aQaQ{{�� Nwmpj yrordovirnv of ri �o m s on V Omi m o�olm�, omrnoln�rnrnvm V o O I� V ONO V m N N N m O V m m mr m� 10 m�mNmr m N M V 1� rN��O� `01MNNNMON 1� I� f M rILI �-NtON N k m k k m O O O N O O O Om N M O O O O O O r O A N O O O O O O O O m m V r N w O 0) m m O O O w 1 n O W n O I D r O) M V' m 8 W M O' m w m1 M M— N m m M G O MW— 'D i vQ m m oW,m i omoaornoom r N Z 1f O O O O M V' N O m O M O N O O M r m d' O O (V O O (D (V �N N o Off.- ii `o a10 00 N M O m { m� f[00 O It m N N N O m f 0 N M O I� m V M N N i (p ,nmm O m m (D O m m (y O m M O m r M M m m m O O N m O m m CO (h O r O m r V n H —N V V MN v r N r m M N N N M N ii I O O O O O O O k m O O O 01 O O O O m m N O O O O O O O O O N O O O N O O O O W m p I M N I m 00 v 0 In y c LL y m m �' W v E v 6 (j y Q m m— a a N yp. > N N 7 I` NNN N Q C, m U� OE 0 % �� Eo E0 w m 0. 0 c a m E w Ill m H v" v v v ctY mvK m m�oE c Z j In- �a�iWtinm In 5g� m icyL°"c K > >E d— > m W >'I vm Ecm:ov m m v m m a m t $Q WK W v« m v v« .- KfLC7� m�� W�'' 'EQmOm U' CO) ��Q N O i$ M v A s a p ry 7 m z a rna Y � o a [O 1i d° 0 00000 oo00o0o0000000000o g oog X27 00000 000000000000000000 0o a (p VV d 0 0 M 0O 0t 0 00 0 0 N M NO .M I n 0r O J 0f D 0O O O 0I n 0(O 0c' 0 N OV O N N () O M (V g o O p O N o OD N10NMM �dNM1N W NNOJ V �(V m�[O n N ^c-s� n 6 T O onv, No 000 W OmO dNo00mowl N r Nr °) (O r�-fV tG 1()M t01nMdOZO V oroviO m(d Ic naoG n 0 (O O' N M n t0 ' M' N O b M d IA Lq N d N M N fD N N c N 0n00o mm oMMCOO M� Ooom1° 1n NM M O O N N N O O N n O O O o O m O O O I(l 1 f J M 0 0 0 1 n O d OO OO M (V O V N r N d N M r M 0 N N I n N M r M M �- - (V M (V - N - � CO M M M 1� N O N O' N O lD d d r O O O d O W O N O M m N W n N W (O N t m O d O m N O (O O O r m O M O N O W N ti N O f0 (p C6 W M O d W F O D) CJ (D N O O Ol V O (O O O m m w M W M MMdN W W MMMO `n M N da0m MM N W W N M M n W r O O N M N M 0 o r W n O W M M O O O O O O Z M O O o M M o O 0 O 0 O 0 O N OO On M OJ M n N M dO ' 0 C O N n M 0 V O O O iO O N O O o V' qaj N M O M O M M M '!1 N N M N O n r N M n O O O M W N m Mn M O M N p CWO M M M M M M M N d W n O d M m d d O O O M O V o M V O M n n O d o 4 - O d M N M '.� O o o o O M M r O N M N O n n N r r O o O M N N r r V 0 0 0 0 0 M M M O d r g o (O r m M W O O O M M M M W O O O O OO ("1 (") l O O 1 p OJ O O W I [ O f O O M 0 OJ 1(M� �C�}} l CV V c U O W NmN' W M -N (MDR Or V NOrN1M O M `OCY y O M O^ M O N N O O O O O O O M O O O O m (p M m N MOM o f0 O O M M o O O O o o O n o O O O M M O M M M N D70 t0011�� OOM N 0000000 y� 00001() (U Np W M r r (r0 m [° W N (MO V V r r V NO N c W �m $II Nxm ac Uemc cn '� Ncc M O ° m N C 2°2 a0 5 A 9 C @ ~ m N N v co�y w y �mUm MU UE =.2«U —Q, N O O v a p ° W O E .. o 2v O c a o. v a c o o€ p >> >'m m � 3 o `5 $� g 5 a 3� qE ° vmmg �.�.�'m mm °Om °'w ai0i °cmvaui �—°'� m2LF w 2(9 N C9 C7 ww x0 m 0 a m O of D r ~ ~ \�\\g ow /]!; \k /\ cli )k }d \\ \) k ) �\ 7 § m $ k \ § �( \ \ �\ ! � § # § \( 0 )k &d I pi ) § 7,| |! { !fE i]! !`§ \) \/ \( )2 \\ &% E |(k § ƒ] !!L ) ®/ � / \ \ \ �§ �§ § [ \ �\ / q �| } Gi m Ci k � q ) = 2 ( G\ / _ IL k ) \( 0 )k &d I pi ) § 7,| |! { !fE i]! !`§ \) \/ \( )2 \\ &% E |(k § ƒ] !!L ) ®/ � / \ \ \ �§ �§ § [ \ �\ / q �| } Gi m Ci k � q ) = 2 ( G\ / _ / ) ) �\ Parkview Villa South (166) Balance March 2013 Books - Accrual Mar -13 Assets 10100 Cast) Balance 66,303.12 10200 Petty Cash 186.00 10400 Investments 729,970.36 11300 Rent Receivable 1,032.93 11500 Accounts Recevable U0 Total Assets 797,492.41 Liabilities 20200 Accounts Payable 8,982.57 20210 Accred Other Expenses 2,825.99 22000 Deposits 7,581.58 22200 Accred PILOT 15,430.36 22210 Revenue Collected In Advance 45.00 Total Liabilities 34,865,50 Fund Balance 25300 Fund Balance 762,626.91 Total Fund Balance 762,626.91 Total Liabilities and Fund Balance 797,492.41 Parkvlew Villa -South (1(6) 17.29 0.080/0 45.08 0.07% Income Statement 0.00 0.00% 49.93 0.07% For The Period Ending March 2013 0.00 0.00% 0,00 0.000/0 Books = Accrual Month to Date % Year to Data 1.40% Revenue 683.19 3.23% 1,051.00 1.54% 36220-46340 Gen. Government Rents 20,261.00 95.896/0 65,695.00 96.290/0 36225 -46340 Nondwelling Rents 462.00 2.19% 1,386.00 2.03% 36290 -46340 Other Miscellaneous Revenue 406.01 1.92% 1,148.70 1.68% 39120.46340 Recovery Damage City - 0.00% - 0.009/0 Total Revenue 21,129.01 100.000/0 68,229.70 100.000% Expenses 1,976.33 9.35% 5,840.92 8.56% Personal Services 0.00 ' 66.04 0.100% 1000 -46340 Accrued Salaries 3,932.00 18.61% 11,796.00 17.29% Total Personal Services 3,932.00 18,63.-/. 11,796.00 17.29% Supplies 2000.46340 Office Supplies 17.29 0.080/0 45.08 0.07% 2010.46340 Minor Equipment 0.00 0.00% 49.93 0.07% 2160 -46340 Malnt. & Construct Materials 0.00 0.00% 0,00 0.000/0 2171 -46340 General Supplies 665.90 3.15°% 955.99 1.40% Total Supplies 683.19 3.23% 1,051.00 1.54% other services & Charges 3040 -46340 Legal Fees 0.00 0.000/0 0.00 0.000% 3050-46340 Expert & Professional Services 0.00 0.000 /a 0.00 0.000/0 3060.46340 Management Services 2,126.00 10.06% 6,378.00 9.35% 3100 -46340 Protective Services 0.00 0.000/° 502.67 0.74% 3210.46340 Telephone & Telegraph 157.98 0.75% 456.96 0.67% 3430 -46340 AdverUsing Other -95.28 -0.45% 160.28 0.23% 3600 -46340 Insurance & Bonds 841.25 3.980/0 2,523.75 3.70% 3810.46340 Electdc 1,679.34 7.95% 6,266.85 9.18% 0.00 0.000/0 -865.60 - 1.27% 3820 -46340 Water 3830.46340 Gas 1,976.33 9.35% 5,840.92 8.56% 0.00 0.00% 66.04 0.100% 3840-46340 Refuse 0.00 0.000/0 -24.00 -0,04% 3850 -46340 Sewer 4000.46340 Repair & Malnt. Services 945.07 4.470% 7,042.50 10.32°% 4100 -46340 Rents & Leases 80.00 0.38% 80,00 0.12% 4300.46340 Miscellaneous Charges 175.39 0.000/0 181.59 0.27% 4315 -46340 PILOT 1,028.69 4.87% 3,086.07 4.52% 4390 -46340 faxes & Licenses 558.62 2.64% 558.62 0.82°% 4500.46340 Administrative Expenses -71.95 -0.34% 229.43 0.34°% 4850 -46340 Interest on Deposits 6.18 0.030% 17.92 0.03% Total Other Services & Charges 9,407.62 44.52^% 32,502.00 47.64% Capital Outlay 512046340 Building & improvements - 0.00% Total Capital Outlay 0.00 0.000/0 0.00 0,000/0 Total Expense 14,022.81 66.37% 45,349.00 66.47% Excess (Deflcit) Revenue over Expense 7,106.20 33.63% 22,880.70 33,53% Parkvlew Villa South (166) Cash Flow Statement Period = March 2013 Month to Date Revenue 36220 Gen, Government Rents 20,261.00 36225 Nondwelling Rents 462.00 36290 Other Miscellaneous Revenue 406.01 39120 Recovery Damage City Property 0100 Total Revenue 21,129.01 Personnel Services 1000 Accrued Salaries 3,932.00 Total Personnel Services 3,932.00 Supplies 2000 Office Supplles 17.29 2010 Minor Equipment 0.00 2160 Malnt. & construct Materials 0,00 2171 General Supplies 665.90 2175 Food Supplies 0.00 Total Supplies 683.19 Other Services & Charges 3050 Expert & Professional Services 0100 3060 Management Services 2,126.00 3100 Protective Services 0.00 3210 Telephone & Telegraph 157.98 3430 Advertising Other (95.28) 3600 Insurance & Bonds 841.25 3810 Electric 1,679.34 3820 Water 0.00 3830 Gas 1,976.33 3840 Refuse 0.00 3850 Sewer 0.00 4000 Repalr & Malot. Services 945.07 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 80.00 4300 Miscellaneous Charges 175.39 4315 PILOT 1,028.69 4390 Taxes & Licenses 558.62 4500 Administrative Expenses (71.95) 4850 Interest on Deposits 6.18 Total Other Services & Charges 9,407.62 Totalexpenses 14,022,81 Parkview Villa South (166) Cash Flow Statement Period = March 2.013 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10,100 Investments 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 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 7,106.20 0.00 0.00 614.00 0.00 0.00 118.82 841.25 6.18 1,028.69 (17.00) 2,591.94 9,698.14 Belt Cash End Cash Difference 56,604.98 66,303.12 9,698.14 186.00 186.00 - 729 970.36 721970.36 - 786,761.34 796,459.48 9,698.14 R 4/8/201310:35 AM Pauftlesv Villa South (166) General Ledger Period - Fiar 2013 gook - Accrual l Tree , ysl_ib Be .... .. -:. Property UA. i- Period Paddipt-rt. _ Copirol Refera0ce Debit Crarlt 021pnG6 Renmrks 1000.46340 Arged Solerlas 7,864.00 Accrued = Beginning Balance . -� 166 3/31/2013 0312013 :PdaUlacurdrg Recusrdrg 3- 159903 RC 3,932.00 0.00 11,796.00 RIC CIIC PR FgmL fee Net Chmsge =3,932.00 11,796.00 - Surge, Balance v 2000.46340 grace Supplies 27.79 v Beginning Balance = 1" 3/20/2013 03/2013 Office DeNt(00804) P326625 6.49653E+11 17.29 0.00 45.08010ce Supplies Net Change= 17.29 45.08 . Ending Balance = 201046340 Minor Equipment _ 49.93 = Beginning Delano- _ Net Change-0.00 49.93 = Ending Balance = 2171 -4 53 40 General Supplies 290.09 w Beginning Balance a 166 3/1/2013 0312013 HD Supply Faceafird Maintenance, Ltd. (home P- 324069 9120829089 160.91 0.00 451.00 mamtsuppiles 166 3/4/2013 03/2013 HD Sap* Fadlitles Flalntenance, Ltd. (home P•324107 9120657207 106.29 0.00 557.29 malat supplies IM 3/0/2013 03/2013 Rattaloue -s /Metro Ace (fuel) P- 324640 0143478 13.43 0.00 570.72 malntsupplas 160 318/2013 0312013 IID Sup18Y Facadle. Malmenance, Ltd. (home P3249W 9/20081055 120.27 0100 690.99 main! supplies 166 3/11/2013 03/2013 HD Supply FadnNed Flamtenance, Ltd. (home P- 325145 9120998553 78.38 0.00 769.37 main[ supplies 166 3/1412013 0312013 HD Supply Fadiides Maintenance, Ltd. (home P- 325491 9121081043 10.08 0.00 779.45 Janitorial suPNIOS 166 3/1412013 0312013 IID Sup ply Fa01Ned Flalmenance, Ltd(Iwm4 P- 325493 9121081043 25.51 0.00 804.96 maintsuppges 106 3/25/2013 03/2013 HD Supply FadiBled Mmmenance, Ltd. (Im . P- 326672 9121271410 151.03 0.00 955.9 main supplies Net Chang= 665.90 965.99 a Ending aside'. 3060.46340 Management Services h252.00= Beginnldo Balance 166 3/2012013 0312013 COmmonond llausha) WX) P- 327018 03/16113 - 3/28113 It 61058100 0.00 10,310.0117996 mgmt(ees 3/13 166 3/31/2013 0312013 :Posmacurrin9 Recurring 3- 159903 RC 0.00 3,932.00 6,376.00 R/C CHC PR Ftgmt fee flat Chang- .2,126.00 6,376.00 = Ending Balance= 310046340 protective Servl <os 502.67 . Beginning Balance v Not Change =0.00 502,67 . Ending Balance= 3210.46340 Telephone & Telegraph 298.98 = B.'In it fng Balance. 166 2/26/2013 0312013 Popp.Cem(POPP) P- 324641 992000955 100.67 0.00 399.651ele dery chugs 3/1. 3131/13 166 3/1/2013 0312013 Level One (love) P- 324065 0302720IN 34,38 0.00 434.03 Ie!e sery rate plae 3/13 166 3/212013 03/2013 Comcast(comcM74) P- 324836 0772105050196183, 25.56 0.00 459.59 Internet 3 /114/10113 166 3/2/20(3 03/2013 Coemast(CoinC3474) P- 324816 877210SOSD196183� 0.0 2.63 456.96 previous balance Net Change =157.98 456.96 v Ending Balance - 3430.46340 Advertising Bihar 255.56 v Beginning Balance = 166 3/15/2013 03/2013 Sun 4ev"aper(snnn) P-125303 0113215071- 325303 0.00 95.28 160.28 ad clage 1/17/13 166 3/15/2013 03/2013 Sun Nan ,,, (sand) P- 325303 0113215071- 325303 95.28 0.0 255.56 ad Imps 1/17/13 166 3/1512013 03/2013 Sun Nev,speper(sunn) P•3253D3 011321M71. 325303 0.00 95.26 160.28 ad ChNiS 1 117113 Net Chrn90n -95.28 160.28 = Ending Balance = 3606.46340 lnsumnee &Bands 1,662.50. Beginning Balance v 166 3/3112013 0312013 :PoslRacuning Recurring 3- 159903 RC 841.25 0.00 2,523.75 C of Columba Heights Ins Not Change =041.25 2,523.75 . Ending Balance = Electric 4,587.51 . Beginning Balance = 381046340 166 3/1112013 03/2013 Xcel Energy(xcel) P- 325960 515044155303/11 /1 1,679.34 0.00 61266.85 CICC 2/5-3 16113 Net Chana4- 1,679.34 6,166.85 = Ending Balance = -865.60. Beginning Edirne -e 3020 -46340 Water -865.60 = Ending Balance - Net ChangewO.00 3,864.59 v Beginning Balance . 3830.46340 166 318/2013 03/2013 Be. CenlerP0lnt Energy (cent) P- 325232 5527132403108113 1,976.33 0.00 5,840.92 gas 215. 3/6113 Not Change= L,976.33 6,840.92 - Ending Balance n 3840.46340 Refuse 66.04 - Oeghming Bala=nce - Net Change-0.00 66.04 - Ending Balance. -24.00 = Beginning Balance = 385046340 ` Sewer -24.00 = Ending Balance = Net Chnnge.0.00 4000.46340 Repair& Hotel. Services 6,097.43 - Beginning Balance= 166 2/27/2013 03/2013 11191, profile Grounds Maintenance, Inc. (highs P- 323291 25093 133.30 0.00 6,230.73 slaw removal 2 /13- 210/13 Page 1 of 2 4/8/201310:35 AM rsd av, W1. South (166) General Ledger Parted! = bLir 2013 Page 2 of 2 18,441.00 4,419.19 Buse, - Alc,uM Tres -' YsUb pnapcq-tv.-� But il :Faed sloths Rci PC 4 It OC rqdlt Balance; Base a 166 3112/2013 030013 High ProfileGuournal,larnlensince, lac.highIP3251114 26037 159.65 UO 6,390.38 snoly fes,eval 315.316113 166 3/1312013 0/2013 Adam's Pest Control, Inc. (sound) P-326600 781659 23.32 0.00 (1 Past Central 1" 3/22/2013 03/2013 High Pieria Grounds Maintenance, Im. (high( P- 326801 26207 148.110 0100 6,56230 plawide Ire 03118 03119120 166 3/23/2013 0312013 P.O. Cleaning and RusionatJOV U-C (kcd) P-326689 1379 80.00 6.00 6,642.50 Shumpese carpet end 117 166 312312013 03/2013 K.O. Clean Ing and Restoration LLC (kocl) P-326690 1360 300.00 0.0 6,942.50 repair /paint mils unit 319 10 3/23/2013 0312013 K.O. Clearing and Rest-Han LLC (kesi) P326691 1381 iw.m 0.00 7,042.50 tapir bthrM CeHIM Milt 32' Net Charge - 945.07 7,042.50 - Ending Balance - 4100.46340 Birds a Lee.. 0.00= Beginning Balance 1" 212012013 03/200 r4ofilliousing Credit Control (Multi) P-324910 1:1020355 80.00 0160 80.00 mull bkg.d chka 2114.2/2S matchauloa=80.00 80.00 M Ending Balance" 43g0.46340 Mlscellaneava charge. 6.20= Beginning Balance= 166 212812013 03/2013 City of Columbia HekId$ (WO) P-323303 3909 58.46 Boo 64,66 .1sc relMb cents, a lidn 166 2/2014013 03/2013 Cld? of Columbia Heights (COIO P-321305 3908 116.93 0.0 101,59 mlsc nallub copier afictu NatCh.11a=175.30 481,59 . Ending Balance - 4315-46340 PILOY 2,057,38 = DeOffinhig Balance - 10 3/31/2013 03/2013 :P0,LRECO"IN RMIMal 1-159903 RC 1,028,60 0.00 3,0116.0 Anck. CtY PrePa'W Tax Am Net Clangs-1,028-69 3,086.07 - 0.01.9 Balance - 4390.46340 Teens & Licenses 0,00 . Oeglnnha0 Balance 166 3/612013 0312013 estuarine Heights Phe Dart (cclui,25) P-324257 30613166 558.62 01040 550.62 annual rental Ikensa Net CI ...... 558.62 358.62 - Ending Balance - 4500-46340 Administrative Expenses 301.30 - D.Uhmillig Balance 166 2120/2013 0312013 Oprean JeWerske debt) P-323117 22013166 22205 0.00 523.43 sulde.g. leg 1/11-200/13 166 3/28/2013 03/2013 Corannormod Idevshng (1hc) P321018 03/16/13 - 3128/1310 0.00 294.00 229.43 113780 2012 CRIPleult Net changaw-71.95 229.43 m Ending Balance m 4850.46340 I.WuMt on Dop"t. 1174 - Beginning Balance 166 3/31/2013 13/2013 Sun Dep Interest accrual 1460327 Gil 6.18 0.00 17.92 Stc DO interest accrual Net Changew6.18 17.92 = Ending Balance = Page 2 of 2 18,441.00 4,419.19 Parkview Villa South Bank Reconciliation Report 0313112013 5016464 Balance Per Bank Statement as of 0313112013 Outstanding Checks Check dale Check number Payee 03/19/2013 1719 comc3474- Comcast 03/26/2013 1725 homo7 - HD Supply Facilities Maintenance, Ltd. 03/26/2013 1726 xcel - Xcel Energy Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 03/3112013 Difference Cleared Items : Cleared Checks Reconciled Balance Per GIL (Reconciled Bank Balance And Reconciled Balance Per GIL) Dale Tran 8 02/20/2013 1701 02/20/2013 1706 o2/26/2013 1707 02/2612013 1708 02/26/2013 1709 03/0512013 Me 03/05/2013 1711 03/05/2013 1712 03/05/2013 1713 03/05/2013 1714 03/12/2013 1715 03/12/2013 1716 03/12/2013 1717 03/12/2013 1718 03/10/2013 1720 03/19/2013 1721 ' 03/19=13 1722 03/19/2013 1723 04/02/2013 68,166,30 Amount 22.93 160.91 1,679.34 1,863.18 66,303.12 66,303.12 66,303.12 0.00 Notes Amount Date Cleared dire - Direct Home Appliance Services 240.76 0313112013 simp - Simplex Grinnell 287.84 03/31/2013 homo7 - HD Supply Facilities Maintenance, Ltd. 49,93 03/31/2013 (0006414 - Pies 208.69 0313112013 xcal - Xcel Energy 4,215.51 03131/2013 adam - Adam's Pest Control, Inc. 23.32 03/31/2013 cent- CenterPoint Energy 2,525.90 03131/2013 chc- CommonBond Housing 6,058.00 03/31/2013 high8236 - High Profile Grounds Maintenance, Inc. 205.38 03131/2013 - labl - Doreen J,ablonske 222.05 03/31/2013 cola - City of Columbia Heights 175.39 03/31/2013 colu825 - Columbia Heights Fire Dept 558.62 03131/2.013 high8236 - High Profile Grounds Maintenance, Inc. 51.15 03131/2013 love - Level Ono 34.38 0313112013 frat - Frattalone's/Metro Ace 13.43 03/3112013 high8236 - High Profile Grounds Maintenance, Inc. 133.30 03/31/2013 home? - HD Supply Facilities Maintenance, Ltd. 78.38 03/31/2013 multi - Muitlhousing Credit Control 80.00 03/31/2013 Cleared Checks Dale Tran # 03/19/2013 1724 Total Cleared Checks Cleared Deposits Date Tran # 03/002013 364 03/05/2013 366 03/08/2013 366 03/2812013 368 Parkview Villa South Bank Reconciliation Report 03!3112013 5016464 Notes Popp - Popp.com Notes 04/02/2013 Amount Date Cleared 100.67 03/31/2013 16,260.70 Amount Date Cleared 19,611.00 03/31/2..013 659.00 03/31/2013 1,224.00 03/31/2013 232.01 03/31/2013 Total Cleared Deposits 21,726.01 Date 3/29/13 Page 1 Primary Account @XXXXX Enclosures 23 BRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C O U N T S - - -- HAVE YOU CONSIDERED RECEIVING YOUR STATEMENT ELECTRONICALLY? SOME OF THE BENEFITS INCLUDE: -SAME DAY DELIVERY OF STATEMENT - PASSWORD PROTECTED ' -EASY STORAGE CONTACT YOUR BANKER FOR DETAILS! NORTHEAST PUBLIC FUNDS ACCT Number of Images 23 Account Number @XXXX Statement Dates 3/01/13 thru 3/31/13 Previous Balance 61,700.99 Days in the Statement Period 31 4 Deposits /Credits 21,726.01. Average Ledger 69,533 19 Checks /Debits 15,260.70 Average Collected 68,850 Service Charge .00 Interest Paid .00 Ending Balance 68,166.30 Deposits and Credits Date Description Amount 3/04 -DDA REGULAR DEPOSIT 19,611.00 3/05 DDA REGULAR DEPOSIT 659.00 3/08 DDA REGULAR DEPOSIT 1,224.00 3/28 DDA REGULAR DEPOSIT 232.01 Checks in serial order Date Check# Amount Date Check# Amount 3/07 1701 240.76 3/18 1715 175.39 3/04 1706* 287.84 3/19 1716 558,62 3/04 1707 49.93 3/28 1717 51.15 3/19 1708 206.69 3/22 1718 34.38 3/04 1709 4,215.51 3/25 1720* 13.43 3/08 1710 23.32 3/25 1721 133.30 3/13 1711 2,525.90 3/25 1722 78.38 3/07 177.2 6,058.00 3/22 1723 80.00 3/25 1713 205.38 3/22 1724 100.67 3/18 1714 222.05 * Indicates skip in check numbers Date 3/29/13 Page 2 Primary Account @XXXXX Enclosures 23 NORTHEAST PUBLIC FUNDS ACCT @XXXXX (Continued) _ Daily Date Balance Section Balance Date Balance Date Balance 3/01 61,700.99 3/08 72,319.63 3/22 68,415.93 3/04 76,758.71 3/13 69,793.73 3/25 67,965.44 3/05 77,417.71 3/18 69,396.29 3/28 68,166.30 3/07 71,118.95 3/19 68,630.98 * * * E N D O v S T A T E M E N T Payment Summary. Bank =t66opr AND mm /yy- 03/2013-03/2013 AND All Checks —Yes AND Include Voids= All Checks Check Post Total Dank Check# vendor Data Month Amount t66opr - Parkvlew Villa South 1698 Bunn - Sun Newspaper 03/15/7.013 03/7 -013 (95.28) 166opr - Parkvlew Villa South 1710 adam - Adam's Pest Control, Inc. 03/0512013 03/2013 23.32 166opr - Parkvlew Villa South 1711 cent - CenterP0lnt Energy 03/05/2013 03/2013 2,525,90 166opr - Parkview Villa South 1712 chc - CommonBond Housing 03/05/2013 03/2013 6,058.00 166opr- Parkview Villa South 1713 hlgh0236 - High Profile Grounds Maintenance, it 03105/2013 0312013 205.38 166opr - Parkvlew Villa South 1714 )abl - Doreen Jablonske 03/05/2013 03/2013 222.05 166opr - Parkvlew Villa South 1715 Colu - City of Columbia Heights 03/12/2013 03/2013 175.39 166opr - Parkvlew Villa South 1716 co1u825 - Columbia Heights Fire Dept 03/12/2013 03/2013 558.62 166opr - Parkviev Villa South 1717 high8236 - High Profile Grounds Maintenance, Ir 03/12/2013 03/2013 51.15 166opr - Parkvlew Ville South 1718 teve - Level One 03/12/2013 0312013 34.38 166opr - Parkvlew Villa South 1719 comc3474 - Comcast 03/19/2013 0312013 22.93 166opr - Parkvlew Villa South 1720 frat - Frattalone's /Metro Ace 03/19/2013 03/2013 13.43 1660pr - Parkvlew Villa South 1721 hlgh8236 - High Profile Grounds Maintenance, Ir 03/19/2013 03/2013 133.30 166opr - Parkview Villa South 1722 home] - HD Supply Facilities Maintenance, Ltd. 03/19/2013 03/2013 78.38 166opr - Parkvlew Villa South 1723 euitl - Muillhousing Credit Control 03/19/2013 03/2013 KOO 166opr - Parkvlew Villa South 1724 popp - Popp.com 03/19/2013 03/2013 100.67 166opr - Parkvlew Villa South 1725 home7 - HD Supply Facilities Maintenance, Ltd. 03/26/2013 03/2013 160.91 166opr - Parkvlew Villa South 1726 xcel - Xcel Energy 03/26/2013 03/2013 _ 1,619.34 12,027:87 Parlcview Villa North Financial Statement Overview March 2013 Revenue: Occupancy for the month of March 2013 was 99% occupied; Total Revenue for March was under budget (unfavorable), however, we did draw down the operating grant in March Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Computer Equipment, Supplies and Maintenance was under budget (favorable) Legal Services was over budget (unfavorable) and reflects the cost of Jan. eviction and Feb. Beautician Contract Misc. Admin Expenses was over budget (unfavorable) and reflects an incorrect billing that is reversed in March Utilities: Utilities Expenses were under budget (favorable) Electric was under budget (favorable) reflects Feb. costs Gas was over budget (unfavorable) and reflects Feb costs Water and Sewer were not invoiced in March Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was over budget (unfavorable) and reflects a stock up of parts and supplies Repairs Contract was under budget (favorable) Garbage and Trash are under budget (favorable); however, this is a quarterly billing Security Contract is under budget (favorable). Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs is under budget (favorable) Snow Removal Contract was over budget (unfavorable) and reflects end of February and March costs m 3 m m Y z C m w o Q) a u a n ii �p i J m O M 3 °a z ET cm K0 G) U) Q 2. N Qm off$ m mmm N� N y z ET N 0 gyp, N N ^�. NN S [6n j�Tfl y J' l0 N J < N A » ^ N N N A N N'm yJ' C m3 O miJ B m ° m3 m 'm c c M�J IO < y 0 T c m 0 0 m ; � N m c N o a 8 0 fD m N f A m J m J O j J N N i r W A W w MV V WW ' ' p��I NN O "WA .Wa •r. LjNO m N N o O O A O O 0 W A O W O (000 N0000 N O W O N O O O O O O O W W N O O O O O O + O NI� l0 N N l0 (O p A W O W ?OWi W N(VTN�N ' N W AcwO W W Ol W m w W o 0 A N O t 0 N U t N O W W N W j N 1 V (p O A V N W O V 0O O O I 1 N V A V N —J I, % f 00—Om0000 �` N O(Al� N 94,W w W ZOI OIJ (OO W 0000 W D V o W w000000 1 00 O W CIO W oco (O m In -` W i O 'M- m 93 . Q0 90. O O W O 0 0 W W V 0O O O O i w W- O O N V O O 0 w o— o O o o (0 O O N O N N N 0) W W O W N V V W W 'W O N 'pAJ f0 A W O V N N (0 N N W W W O N V W V W N A A O W O O (P O poj O) O N O O O 00 V W W� W f0 V W 0 0 0 0 f C W W N N N O 0 W O PPP) VV W wA W N W V 0 m � O O OI A Z O t0 V O wD�000w� 000�l W -M - N a I ° YaW� n Yri NAB W �(TO w_<°n� O W w W W m o N l0 O W O Ol W W N oW O (ll N (0 O O N O 01 O N O O O O O O O O A O o O O A Owj O W o O O O O O O O O O O O O v O O O O O O O O O m 3 m m Y z C m w o Q) a u a n ii �p i J m v W v W 0 V V12mA 4)G) W G13 mm`m`' �m m �mc 9i u (i ° o 3 o » EE S .�5 3 • ° mc 0 W 0C cmco�v oO O v W WNm m 2, o 0 2�Nn y (� 0 " 3 NO •'m o n m m m n o N > Ej 3m�0 m 0 N m j cn w W (Aj N V w O O O O O W W O O O O O O A O N f0 O O J O W W O UI A O N -O A $ O W.00 w W OJ m ()1 w V 0000 O W [0000000(0 O W .Na O Ip (T (JI NPOJ A V �IJ W AAN1� N AOOO OW A OO A Oca G O 13 W O +O W O O W m O J V W O A V O W Ol O W 0 �OO O W w W •W N +� � + d Ot O N A W AN(J IJ W W 0)N N N W W 74 COO W V O W N W O O W W (O W O N W J V l0 W W W N N (ll W N V W W O O A O O W O N 0t W N J W O O J J N� V J A W W W w W w W T M O W m A 000 W ? W (P N N W O N O W O A m Ol O O O O O . (BO O O O O V W O w r lT - N W v r O O O w V O O o O O O o A O o Z O O O V N o 0 U 0 0 A G 1 O W O W O 0 W O A O J f 0 0 0 0 0 0 A I J 0 0 a o o 0 0 N D o 0 0 (0 w w o w w O V O W O w V o O o 0 o m w O O W O W W N A V W O O W N W W V J A N O A tV0 N �p NN�J N (4 V ..-1 O O O W O A <O O O W O) W W O A +0 000 � W W A OOOJ (O OJ ^� O W VI O W O O O N V A A O O W W V W O W UIN m 0CA I 0U� W (O <D O1N W U�J , N W O W W O O J f0 W N W N W fP W UI W (O 91 O O W (0 O O V W A fP Ol O O 1 V N 0 0 0 (O O (U O O O N O O QO N W 0p J N m O N O N O �00 w °o 000 Jw A W N W A O N A N O N A w O V O A( 0 J � (p0 o tW0 tp0 lAD A W N W 0) O N W N N W V J A A V N 10 N (0 W ( O Plo O W O t O moo 1000 W °o NI J V N lA0 mIW OOON N N o 0 0 0 i W + W O W (p ? wW A V W O W IJ �I wp W NN V A. W' SI pW N A N NW W N m m O W f0 0 00 dU tJ N r lT - N W v r p A W A N Ol IJ NNW W -` W W? V to W IV O W 01 8 W W W W O W W W W N W N (p W U W O W W (O O (O O V W J W O O N W tp w O W 0k3 IV -`A-+A OUI�OUI W O W J W w O O W O W W N A V W O O W N W W V Ja f0 m O A (O W O V ONO V O W W W 01 O W N O A W q (.J I 'O Z O4JO V O O W A OOJO W A 00 A (Ow (9 D O W O N W O N V A N + O W O A O N G o W o O W 'J N 10 O W V o lT O W O W J m p p W op O W O O O O o O O W ONO O O 'U 00 •O '000006 6 0000000000000 O O O O O O O O O O O O O O O O O O QO N W 0p J N m O N O N O �00 w °o 000 Jw A W N W A O N A N O N A w O V O A( 0 J � (p0 o tW0 tp0 lAD A W N W 0) O N W N N W V J A A V N 10 N (0 W ( O Plo O W O t O moo 1000 W °o NI J V N lA0 mIW OOON N N o 0 0 0 i W + W O W (p ? wW A V W O W IJ �I wp W NN V A. W' SI pW N A N NW W N m m O W f0 0 00 dU tJ a -4 ! /c ( 2 § �,§ 9 \ 4 ®kk M ! §: \§ E)7 k )) ( \ \ / \ §\ 2 § At a ®u / )! j ( ■ 2G ~ E/ } 4 ) \\ \ 2 ( \\ R ar \ \ \ co a/\ §./ � ( ■9 cc \[ (\ 1 \[ \\ \\ ( / F a \ } \ | § � ) \ (� \ q 2 \ $ § $ (!� [ �\ § \ F / ( §j cc ( §j § §) k )) } )\ § (} § § { k\ ƒ { ) E ( (( \/ \\ )\ \�k \ � \ k |r � ( ( � �e;f! � ( ( As— ® � ( � co / w | a } { / °(} \ \\ (� > / \ � ( ( As— / w | a } { / °(} \ \\ (� > / \ | a } { / °(} \ \\ (� > / \ Parkview Villa -North (165) Balance Sheet March 2013 Books = Accrual Mar -13 Assets 26,571.68 10100 Cash Balance 664.00 10200 Petty Cash 891,214.11 10400 Investments 11300 Rent Receivable 1,040.20 11500 Accounts Receivable 202.12 13200 Due From Other Government Units 23,847.09 943,539.20 Total Assets Liabilities 20200 Accounts Payable 22,699.60 20210 Accrued Other Expenses 5,225.25 20220 Due to Resident Council 551.74 18,633.14 22000 Deposits 30,407.23 22200 Accrued PILOT 22210 Revenue Collected in Advance 588.10 78,105.06 Total Liabilities Fund Balance 865,434.14 25300 Fund Balance Total Fund Balance 865,434.14 Total Liabilities and Fund Balance 943,539.20 Parkview, Villa -North (165) Income Statement For The Period Ending March 2013 Books = Accrual Supplies 2000 -46330 Office Supplies Month to Date % Year to Date % Revenue 0.00 0.00% 111.13 0.11% 33160 -46330 Federal Grant 11,036.00 25.539/a 11,036.00 10.53% 36220 -46330 Gen. Government Rents 31,010.00 71.74% 90,166.00 86.02% 36225 -46330 Nondwelling Rents 429.00 0.99% 1,287.00 1.23% 36290 -46330 Other Miscellaneous Revenue 752.08 1.74% 2,221.89 2.12% 39120 -46330 Recovery Damage City Property - 0.00% 105.00 0.10% Total Revenue 43,227.08 100.000/0 104,815.89 100.000/0 Expenses 0.06% 3600 -46330 Insurance & Bonds 1,741.75 Personal Services 5,225.25 4.99% 3810 -46330 1000 -46330 Accrued Salaries 8,752.00 20.25% 26,256.00 25.05% Total Personal Services 8,752.00 20.25% 26,256.00 25.05% Supplies 2000 -46330 Office Supplies 38.50 0.09% 579.52 0.55% 2010 -46330 Minor Equipment 0.00 0.00% 111.13 0.11% 2160 -46330 Mart. & Construct Materials 1,494.69 3.46% 2,608.87 2.49% 2171 -46330 General Supplies 22.43 0.05% 194.63 0.19% Total Supplies 1,555.62 3.60% 3,494.15 3.33% Other Services & Charges 3040 -46330 Legal Fees 3,656.95 8.46% 3,740.95 3.57% 3050 -46330 Expert and Professional Services 0.00 0.00% 0.00 0.00% 3060 -46330 Management Services 4,772.00 11.04% 14,316.00 13.66% 3100 -46330 Protective Services 0.00 0.00% 1,118.83 1.07% 3210 -46330 Telephone & Telegraph 351.66 0.81% 1,017.14 0.97% 3430 -46330 Advertising Other 0.00 0.00% 65.00 0.06% 3600 -46330 Insurance & Bonds 1,741.75 4.03% 5,225.25 4.99% 3810 -46330 Electric 3,737.90 8.65% 6,225.66 5.94% 3820 -46330 Water 0.00 0.00% 0.00 0.00% 3830 -46330 Gas 5,691.18 13.17% 12,212.98 11.65% 3840 -46330 Refuse 0.00 0.00% 146.99 0.14% 3850 -46330 Sewer 0.00 0.00% 0.00 0.00% 4000 -46330 Repair & Malnt. Services 2,601.35 6.02% 15,126.70 14.43% 4100 -46330 Rents & Leases 0.00 0.00% 0.00 0.00% 4300 -46330 Miscellaneous Charges 0.00 0.00% 0.00 0.00% 4315 -46330 PILOT 2,027.15 4.69% 6,081.45 5.80% 4390 -46330 Taxes & Licenses 1,243.38 0.00% 1,243.38 1.19% 4500 -46330 Administrative Expenses - 603.75 -1.40% 1,023.51 0.98% 4850 -46330 Interest on Deposits 14.42 0.03% 42.16 0.04% Total Other Services & Charges 25,233.99 58.38% 67,586.00 64.48% Capital Outlay 5120 -46330 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00 0.00% 437.26 0.42% 0.00 0.000/0 437.26 0.42% 35,541.61 82.22% 97,773.41 7,685.47 17.78% 7,042.48 6.72% Parkview Villa -North (165) Cash Flow Statement Period = March 2013 Book = Accrual Month to Date Revenue 33160 Federal Grant 11,036.00 36220 Gen. Government Rents 31,010.00 36225 Nondwelling Rents 429.00 36290 Other Miscellaneous Revenue 752.08 39120 Recovery Damage City Property Total Revenue 43,227.08 Expenses Personnel Services 1000 Accrued Salaries 8,752.00 Total Personnel Services 8,752.00 Supplies 2000 Office Supplies 38.50 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 1,517.12 2280 Vehicle Parts 0.00 Total Supplies 1,555.62 Other Services & Charges 3040 Legal Fees 3,656.95 3050 Expert & Professional Services 0.00 3060 Management Services 4,772.00 3100 Protective Services 0100 3210 Telephone & Telegraph 351.66 3430 Advertising Other 0.00 3600 Insurance & Bonds 1,741.75 3810 Electric 3,737.90 3820 Water 0.00 3830 Gas 5,691.18 3840 Refuse 0.00 3850 Sewer 0.00 4000 Repair & Maint. Services 2,601.35 4050 Garage, Labor Burd. 0.00 4100 Rent & Leases 0.00 4300 Miscellaneous Charges 0.00 4315 PILOT 2,027.15 4390 Taxes & Licenses 1,243.38 4500 Administrative Expenses - 603.75 4850 Interest on Deposits 14.42 5120 Building & Improvement 0.00 Total Other Services & Charges 25,233.99 Total Expenses 35,541.61 Excess (Deficit) Revenue over Expenses 7,685.47 Parkview Villa -North (165) Cash Flow Statement Period = March 2013 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 0.00 0.00 833.00 6.00 0.00 0.00 370.61 1,741.75 - 112.96 2,027.15 4,820.55 12,506.02 End Cash Difference 14,065.66 26,571.68 12,506.02 664.00 664.00 - 891,214.11 891,214.11 - 905,943.77 918,449.79 12,506.02 4/8/201310:36 AM PaHo 1 of 2 Po'kvIc.' VU.-U.,th (165) General Ledger Pareil - Ilar 2013 opek-= Atmal ; Tree - yslj1E pro ally. bale P-'i vi PmeOn /rtes <rlpllon '. Combat -�-Rb b no It -Cle t Be arc Remark. 1000.46330 -a Accrued Salaries 17,M04.00 . Beginning Balance - 165 1131/2013 03J2011 :Posthecurdr, blardidy recording entry 1. 159902 PC. 8,752.00 0.00 26,256.00 RtC CHC M Mqnnt Fee Net ChandhA-8,752.00 26,256.00 . Ending Balance . 2000.46330 Offl. Supplies 62.05 u BegfinnIng Balance = 165 3/20/2013 03/2013 Office Capri (01118804) P 326625 6.49553E"1 36.50 0100 101.45 Offt. Snpliles hot ch.n98 =58.50 101.49 - analog Data.. 2010-46330 Mfino, Eq.1p.,a.t 111.13 = Beginning Balance = Net chanige'0.00 111.13 " ending balance m 2160.46330 NEW. OlConstruct Itatedah; 1,314.18 . Beghurdeg Balance - 165 31112013 0312013 Frattalone'sItleno Ace (fiM) PJ23621 1429A 25.62 0.60 1,139.80 nnalat apples 165 311/2013 0312013 FW01.WsjMctro Ace ((,.I) P-323621 14299R LIM 25.62 1,114.18 ranint supplies 165 3/1/2013 0312013 r,stow.'simevo Ace (Nat) P-323621 14MR 25.62 BAD 1,139.00 MaInt SUppile, 165 3/1/200 03/2013 Frattalone'SIM(thO Ace (Got) P-324066 OW"R 25.62 GIN 1,165.42 malit supplies 165 3/1/2013 03/2013 jib So,], FadfilIeS Maintenance, Ltd. (honn.7) P-124069 9120829889 358.14 0.0 1,523.56 main in,11as 165 3/4/2013 03120❑ ED So,[, Facilities Maintenance, Ltd. (had%V) P-324107 9120857207 236.56 a.m 1,70.12 malAt supplies 165 3/8/2013 0312013 19D $UMIY FadIffleS MaInt8nan"o Ltd. (hM*7) P-32490 912016I65S 267.69 0.0 2,027.41 nPaind supplaS L65 3/11/2013 03/2013 ED Supply fadhklas Maintenance, Ltd. (hopaa7) P-325145 9120998553 174.47 0.00 2,20228 maInt supplies 165 3112/2013 03/2013 Frattalarr'sIhIctro Ace (ftat) P-325172 014385R 1166 0.00 2,215.94 malrd r.pplf. 165 3IL2/2013 0312013 rat0lard'slMotm Ace (lot) P-325172 014385R 0.00 0." 2,202.28 malpt supplies 165 3/1212013 03/2013 frattido..'sItWIL. Ace (frat) P-325172 01430SR 13.66 0.00 2,715.94 roatIt SUPPMes 165 311412013 03/2013 ED SV,,I, Fa'Ritln Maintenance, Ltd. (h...7) P-32S403 MENEM 56.78 0.00 2,272.72 ep.1rd supdl.v 165 3/2512013 03/2013 ED Supply Fa,Ihtics Maintenance, Ltd. (homfl) P-326672 9121271410 336.15 0.00 2,608.87 motor iP,,Ifes Net Cher'. .1, 494.69 2,608,67 . Ernie, Balance 2171-46330 General Supplies 172.20 - Ituale.1610 8.1a.co - 165 3/14/2013 03/2013 ED Supply FaCtIldn thlaidnenCe, Ltd. (horP07) P-325493 9121081043 22.43 am 194.63 J.nItodal su,pUss Net Changen22.43 194,63 - Ending Balance 3040.46330 Legal Fees 84.00 . Beginning Balance . 165 2127/2013 0312013 Knoricb, &Grove., Chartered (kern) P-323265 112909 1,533.95 0.0 1,6L7.95 legal svcs through 01/2013 E65 WE112013 03/2013 Kennedy & Driver, Cinnhudd Ikeda) P-326507 10124 2,123.00 0.00 3,740.95 Legal 4ebacel Hot Chango=3,656.95 3,740,95 m Ending Balance 3060-46350 Pl.pa'.Mmm ServRoas 0,544.00= Beginning Balance 165 3/20/2013 03/2013 Conamentiond Houslig (chc) P-127019 03116/13.7126/13 13,524.00 0.0 23,068.00 117995 010(At leas 3/13 165 3/31/200 0312013 %Pootfivurring Ilroubly recurring entry 1-159992 PC 0.00 8,752.00 14,316.00 R/C CHC M MgMt Fen flat Ch..,.-4,772,00 14,316.00 , Ending Balance= 3100.40930 Protective Services 1,118.83 - Begfil"Ind, Balance - net CI ...... =0.00 1,118.83 . Ending Balance = 321046330 Telephone & Telegraph 665.48 m Beginning Balance= 165 2/281200 03/2013 PoDuC0. (OPP) P-324641 02MMSS 221.0 0.00 889.58 trip sary ing, 3/1.3/31113 165 311/2013 0112013 Level One (]eve) P-324065 030272AIN 76.52 0100 966.10 WE sery rat. plan 3/13 165 3/212013 03/2013 C"calt (co,oc3474) P-324836 877210505019618* 56.69 DOG 1,022.99 Internet 3/11-4/10/13 165 312/2013 03/2013 Cmcast (comC3474) P-324636 8772105050196181 0.0 5.0 1.017.14 wvious We.. Net Change=351,66 IfG17.14 m Ending Balance 343046830 Advertising Other 65.00= DeghbIng Balance= Hot ch.mg.m0.00 69.00 . Ending 3600-46330 insurance a bibles 3,483.50 = Beginning Balance - 165 3/3112013 03/2013 EP.GrKublai Monthly racurd., ..U, 3-159902 Re 1,741.75 0.00 5,225.25 C 0 Coluanble Heights In, A( Net Change=10741.75 5,725.25 . Ending Balance - 3810.46330 Electric 2,482.76= Beginning Balance E55 3/11/2013 0312013 Kcal EnOrgy (xcel) P-125980 5150441553 03/11l 3,737.90 0.00 6,225.645 el. 215-316/13 Net ChEna.-3,737.90 6,215.66 . Berlin, Unne.ce 3830-46330 Go, 6,521.80 = Grgtrnnh"a Balance 165 317/2013 0312013 CenterPolit Energy (Card) P-324990 651996570310Y/i! 5,691.18 0.00 12,212.98 gas 2/4-3/5/13 Net Charge.5,69IJ8 12,111.98 . Ending n.le.c. 3840.46330 act... 340.99 . neginnfin, Balance PaHo 1 of 2 ParSA4 s Yqd -NOrth (165) General Ledger Petbd = Mor 2013 Wok - AC4Nal ; TfC0 - y9_ Page 2 of 2 4/8/2013 10:36 AM 19 n.Yy n ending avoti'0 = 12,529.35 = U.91tuang Oalanca = 296.70 0.00 12,822.05 snow removal 2 /134/14/13 1,566.19 0.00 14,380.24 Wor dery 355.35 0.00 14,74339 snow removal 3 153/6/13 51.91 0.00 14,395.50 past cantmi 331.20 0.00 15,126.20 plow /dc -ice 03110.03/10/20 15,126.70 = Ending Balance = 4,094.30 - Beglnning Balenco = 2,027.15 0.00 6,001.45 Anoka Cly Prapeny Tax Aecr 6,081.49 = Ending Balance = 0.00 - Beginning Balance - 1,243.38 0.00 1,243.38 annual rental license 1,243.38 = Ending Balance = 1,022.26 = Beglnning Balance - ON 603.25 1,023.51 113205 2012 Can fees 1,023.51 = Ending oalanca - 27.74 a 11e4lnning Balance = 14.42 0.00 42.16 Sec Oep interest ac.01 42.16 = ending BOianca n 437.26 - Beginning Balance - 0 0 437.26 = ending Balance = 44,942.49 9,400.88 Not Change =0.00 4000 -46330 Nepals& HOW, SCtVIcal 165 2/22/2013 03/2013 High Pto01e GnnuadS Maintenance, Inc.(h1gh02 P- 323291 25893 165 3/4/2013 031200 LOP 11.1hankal, Inc(Ibpm) P- 324300 W18313 165 3/12/2013 03/2013 High Pio01e Grounds Maintenance, Inc.(hlgh82 P- 325184 26032 165 3113/2013 0312013 Adam's Pest Contm, Inc (adam) P- 326600 283659 165 312212013 03/2013 High Profila Grounds Maintenance, Inc.(hlgh02 P- 326801 26207 Not Change =2,801.35 4315.46330 PILOT 165 31311200 03/2013 :PoslRecurring 6fadidy rocunlog entry J- 7.59902 Rc Net Chnngee2,027.15 4390.46330 Taxes &Licenses 165 3/612013 0312013 Columbfa l lelghts R. Oept(ccl.V5) P -324256 3067.3165 Net Ciro nqo= 1, 243.38 4500 -46330 AdnslnlstratlVO Expenses 165 3/28/2013 03/2013 Cmanuatond Homing (chc) P- 322019 03/16/13 -0128/13 Nat Change=-603 .75 4850.45330 Intencal On Oopoalts 165 3/31/2013 0312013 Sec Cop Ntemst accrual 3- 160324 Gal Net CIi00g4n 14.42 312046330 Oulidhigs &improvement Net Change=0A0 Page 2 of 2 4/8/2013 10:36 AM 19 n.Yy n ending avoti'0 = 12,529.35 = U.91tuang Oalanca = 296.70 0.00 12,822.05 snow removal 2 /134/14/13 1,566.19 0.00 14,380.24 Wor dery 355.35 0.00 14,74339 snow removal 3 153/6/13 51.91 0.00 14,395.50 past cantmi 331.20 0.00 15,126.20 plow /dc -ice 03110.03/10/20 15,126.70 = Ending Balance = 4,094.30 - Beglnning Balenco = 2,027.15 0.00 6,001.45 Anoka Cly Prapeny Tax Aecr 6,081.49 = Ending Balance = 0.00 - Beginning Balance - 1,243.38 0.00 1,243.38 annual rental license 1,243.38 = Ending Balance = 1,022.26 = Beglnning Balance - ON 603.25 1,023.51 113205 2012 Can fees 1,023.51 = Ending oalanca - 27.74 a 11e4lnning Balance = 14.42 0.00 42.16 Sec Oep interest ac.01 42.16 = ending BOianca n 437.26 - Beginning Balance - 0 0 437.26 = ending Balance = 44,942.49 9,400.88 Parkview Villa North 04/02/2013 Bank Reconciliation Report 03/31/2013 5016456 Balance Per Bank Statement as of 03/3112013 31,199.58 Outstanding Checks Check dale Check number Payee Amount 02/05(2013 2.012 dire - Direct Home Appliance Services 480.82 03/19/2013 2048 comc3474 - Comcasl 51.04 03126/2013 2053 home7- HD Supply Facilities Maintenance, Ltd. 358.14 03/26/2013 2054 xcel - Xcel Energy 3,737.90 Less: Outstanding Checks gard1086 - Gardner Plumbing, LLC 4,627.90 Other Items Date Notes Amount 03/08/2013 03/08/2013 Payroll 19.68 Plus /Minus: Other Items 19.68 Reconciled Bank Balance 26,591.36 Balance per GL as of 0313112013 26,691.36 Reconciled Balance Per GIL 26,591.36 Difference (Reconciled Bank Balance And Reconciled Balance Per GIL) 0.00 Cleared Items : Cleared Checks Dale Tran 8 Notes Amount Date Cleared 02/20/2013 2023 dire - Direct Home Appliance Services 205.41 03/31/2013 02/20/2013 2026 kocl - K.O. Cleaning and Restoration LLC 1,150.00 03/31/2013 02/20/2013 2031 slmp - Simplex Grinnell - 640.66 03/3112013 02/26/2013 2032 gard1086 - Gardner Plumbing, LLC 135.00 03/31/2013 02/26/2013 2033 homo7 - HD Supply Facilities Maintenance, Ltd. 111.13 03/3M013 02/2.612013 2034 Ibpm - LBP Mechanical, Inc 265.00 03/3112013 02/2612013 2035 xcel - Xcel Energy 1,635.46 03/3112013 03105/2013 2036 adain - Adam's Pest Control, Inc. 51.91 03/31/2013 03105/2013 2037 cent -, CenlerPoinl Energy 6,452.72 03/31/2013 Cleared Other Items Dale Tran # Notes Amount Dale Cleared 03/07/2013 RC 913395 Returned Item 10003971 - 258.00 03/31/2013 03/11/2013 JE 159346 ELoccs Operating Fund Program (OFND) expenditure r 061800 03/31/2013 Total Cleared Other Items 10,778.00 ParMew Villa North 04/02/2013 Bank Reconciliation Report 03/3112013 5016456 Cleared Checks Date Tran # Notes Amount Dale Cleared 03/05/2013 2038 cumm1600 - Cummins NPower LLC 690.15 03/31/2013 03/05/2013 2039 hlgh8236 - High Profile Grounds Maintenance, Inc. 457.12 03/31/2013 03/12/2013 2040 chc- Commonbond Housing 13,542.33 03/31/2013 03/12/2013 2041 colu825 - Columbia Heights Fire Dept 1,243.38 03/31/2013 ' 03/12/2013 2042 fral - Fratlalone's/Metro Ace 25.62 03/31/2013 03/12/2013 2043 hlgh8236 - High Profile Grounds Maintenance, Inc. 623.85 03/31/2013 03/12/2013 2044 home7 - HD Supply Facilities Maintenance, Ltd. 610.91 03/31/2013 03/12/2013 2045 kenn - Kennedy & Graven, Chartered 1,533.95 03/31/2013 03/12/2013 2046 Ibpm- LBP Mechanical, Inc 1,566.19 03/3112013 03/12/2013 2047 love - Level One 76.52 03/31/2013 03/19/2013 2050 hlgh8236 - High Pro91e Grounds Maintenance, Inc. 296.70 03/31!1013 03/19/2013 2061 home7 - HD Supply Facilities Maintenance, Ltd, 174.47 03/31/2013 03/19/2Q13 2052 popp - Popp.com 224.10 03/31/2013 Total Cleared Checks 31,612.58 Cleared Deposits Date Tran # Notes Amount Dale Cleared 03/04/2013 478 25,697.00 03131/2013 03/05/2013 479 4,235.00 03/31/2013 03/08/2013 480 - 2,062.00 03/31/2013 03/25/2013 481 1,019.00 03/31/2013 03/25/2013 481 100.00 03/3112013 03/28/2013 482 232.02 03/31/2013 Total Cleared Deposlts 33,345.02 Cleared Other Items Dale Tran # Notes Amount Dale Cleared 03/07/2013 RC 913395 Returned Item 10003971 - 258.00 03/31/2013 03/11/2013 JE 159346 ELoccs Operating Fund Program (OFND) expenditure r 061800 03/31/2013 Total Cleared Other Items 10,778.00 Payment Summary Back= 165opr AND mm /yy= 03/2013 - 03/2013 AND All Checks =Yes AND Include Volds =All Checks 31,617.UU Check Post Total Bank Check# Vendor Date Month Amount 165apr - Parkvlew- Villa North 2036adarn - Adam's Pest Control, Inc. 03/05/2013 03/2013 51.91 165opr - Parkvlew Villa North 2037 cent - CenterP0lnt Energy 03/05/2013 03/2013 6,452.72 165opr - Parkvlew Villa North 2038 cumm1600 - Cummins NPower LI-C 03105/2013 03/2013 S90.15 165opr - Parkvlmv Villa North 2039 high8236 - High Profile Grounds Maintenance, Ir 03/05/2013 03/2013 457.12 165opr - Parkvlew Villa North 2040 chc - Commonbond Housing 03/12/2013 03/2013 13,542.33 1650pr - Parkvlew Villa North 2041 colu825 - Columbia Heights Fire Dept 03/12/2013 03/2013 1;243.38 165opr - Parkvlew Villa North 2042 Prat - Frattalone -s /Metro Ace 03/12/2013 0312013 25.62 165opr - Parkvlew Villa North 2043 high8236 - High Pro01e Grounds Maintenance, it 03/12/2013 03/2013 623.85 165opr - Parkvlew Villa North 2044 home? - HD Supply Facilities Maintenance, Ltd. 03/12/2013 03/2013 610.91 165opr - Parkvlew Villa North 2045 kenn - Kennedy & Graven, Chartered 03112/2013 03/2013 I,S33.95 1650pr - Parkview Villa North 2046 Ibpm - I.SP Mechanical, inc 03/1212013 03/2013 1,566.19 165opr - Parkview Villa North 2047 leve - Level One 03/1212013 03/2013 76.52 165opr - Parkview Villa North 2048 comc3474 - Comcast 03/19/2013 0312013 51.04 165opr - Parkvlew Villa North 2049 frat - Frattalon&s /Metro Ace 03119/2013 03/2013 - 165opr - Parkvlew Villa North 2050 high8236 - High Profile Grounds Maintenance, Ir - 03/1912013 03/2013 296.70 165opr - Parkvlew Villa North 2051 home? - HD Supply Facilities Maintenance, Ltd. 03/19/2013 03/2013 174.47 165opr - Parkview Villa North 2052 Popp - Popp•com 03/19/2013 03/2013 224.10 16Sopr - Parkview Villa North 2053 home? - HD Supply Facilities Maintenance, Ltd. 03/2612013 03/2013 358.14 165opr - Parkview Villa North 2054 xcel - Xcel Energy _ 03/2612013 03/2013 3,737.90 31,617.UU HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G Date 3/29/13 Primary Account Enclosures A C C 0 U N T S - - -- HAVE YOU CONSIDERED RECEIVING YOUR STATEMENT ELECTRONICALLY? SOME OF THE BENEFITS INCLUDE: -SAME DAY DELIVERY OF STATEMENT - PASSWORD PROTECTED -EASY STORAGE CONTACT YOUR BANKER FOR DETAILSI NORTHEAST PUBLIC FUNDS ACCT Account Number OXXXXX Previous Balance 18,689.14 6 Deposits /Credits 44,381.02 23 Checks /Debits 31.,870.58 Service Charge .00 Interest Paid .00 Ending Balance 31,199.58 Pa e 1 27 Number. of Images 27 Statement Dates 3/01/13 thru 3/31/13 Days in the Statement Period 31 Average Ledger 36,061 Average Collected 34,929 Deposits and Credits Date Description Amount 3/04 DDA REGULAR DEPOSIT 25,697.00 3/05 DDA REGULAR DEPOSIT 4,235.00 3/08 DDA REGULAR DEPOSIT 2,062.00 3/11 MISC PAY HUD TREAS 310 11,036.00 CR 9101036151. 03/11/13 ID #- 411269646860103 TRACE i {-101036150638058 3/26 DDA REGULAR DEPOSIT 1,119.00 3/28 DDA REGULAR DEPOSIT 232.02 wwww * * * ** www * ** wwww *ww *wwwwwwwwww *wwwwwwwwwwwwwww ** *www * ** *www * ** *wwww * * * *ww ** Charges and Debits Date Description 3/07 RETURN ITEM DEBIT Amount 258.00 w *ww *wwwwww *wwwwww* wwww *wwwww *w * ** *www * *wwwwwww• wwwwwwww *www *•wwwwww *wwwww *w *•www Date 3/29/7.3 Page 2 Primary Account Enclosures 27 NORTHEAST PUBLIC FUNDS ACCT (Continued) Checks in serial order Date Checkik Amount Date Checkil Amount 3/07 2023 205.41 3/14 2040 13,542.33 3/05 2026* 1,150.00 3/19 2041 1,243.38 3/04 2031* 640.66 3/18 2042 25.62 3/06 2032 1.35.00 3/29 2043 623.85 3/04 2033 111.13 3/19 2044 61.0.91 3/05 2034 265.00 3/15 2045 1,533.95 3/04 2035 1,635.46 3/19 2046 1,566.19 3/08 2036 51.91 3/22 2047 76.52 3/13 2037 6,452.72 3/25 2050* 296.70 3/08 2038 590.15 3/25 2051 174.47 3/25 2039 457.12 3/22 2052 224.10 * Indicates skip in check numbers ***•• kk** k*• k***'{" k::*** 1hk***********• k' ki: * *ik * ** *i: * * * * * * * * * * * * *** * ** *•k k * * * * * * * * * * **:Y* Daily Balance Section Date Balance Date Balance Date Balance 3/01 18,689.14 3/1.1 56,676.42 3/22 31,400.70 3/04 41,998.89 3/13 50,223.70 3/25 30,472.41 3/05 44,818.89 3/14 36,681.37 3/26 31,591.41 3/06 44,683.89 3/15 35,147.42 3/28 31,823.43 3/07 44,220.48 3/18 35,121.80 3/29 31,199.58 3/08 45,640.42 3/19 31,701.32 * ** E N D O F S T A T E M E N T Parkview Villa South Financial Statement Overview February 2013 Revenue: Occupancy for the month of February was 80% occupied Total Revenue was lower than budget amount (unfavorable) this is due to vacancy Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were under budget (favorable) Office Supplies was under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Misc. Admin Expenses were over budget (unfavorable) due to incorrect charges - reversed in March Utilities: Utilities Expenses were over budget (unfavorable); however, this reflects a quarterly billing Electric was over budget (unfavorable) and reflects billing from January Gas was over budget (unfavorable) and reflects billing from January Water and Sewer were not invoiced in February Operatine and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was over budget (unfavorable) and reflects the cost of contract Maintenance and dryer motor Heating and Cooling Maint and Repairs was under budget (favorable) Decorating Contract and Supplies costs were under budget (favorable) Furniture and Fixtures were under budget (favorable) 000 O 0000 OOOONOo00o00N MS O p 0 O O 0 0 0 0 O O O O N O p 0 0 0 0 0 N E p. O NO V NOOON NN'O fp N G m o o OM O ry {y OrNm V 4 N W mm NlD 1 N NN�NNO V V g o oN N N �- M 16 � �- � N N fV lV m M M Q 1- N m M O- m w N O o O O O O O m N m m1�P i� OIL mm NOo0 ON00 V ql Lq > OV'WO Noo 0M oNoO r P no mo no r`oi m IO ION N or Io mo<oo V co to m NNm 01 U (q (q th O V (O ^N NNtOOmt1 (O tO7N V mm th NO) W Or IN N�p)pNrommv�i lm+IN ll�o(NO NO V m m N O N o m V O O O m 0 0 V m N N o m p tF M lO(O M O� mN ON(O Or M(Om NCO lfl C"1 W S (V .- v n m � m m V m NomM N�rntONmN. -NM�rP N N N N M N A N m V m y- m O 0 in N N r V d� o r o00 0 omom ( m000rn0000mamin o 0 0 0 o m o m N 0 o a} V W m OI�NIV It)00�t`O(V OO W � Q m N N N O m V N m N N N^ c0] O V O M M O P N ai o m M ooaN m00000rnoo Nom > rN OI 00 MM r; 00000 N 00 V q m m no LV M O O O O O (V O O O N Cl It) ae O O q fq Non O O O O No m m m m m O m r N N N m O N r M M m r O m U m m m m O N mfy 1� N m O m(O m m O N m mm O nc;^ O > (h vj of Mmm m omro ONMONrmmoomoP m m m m O N (O Cli O N m O m (O m M O 1` O N r O M 4 06 m r V N N N�Ndm' �OmiN V {�Nr(O MO M N � !E E fE m o o o o o o o o N m m w o O O O O O O O N O O O O O O O O m N m N O7 N o O V tF N O O N O O N O O m N OI F� N N N i M lV tp a i N m yy� ME W m "� LL u m N m C J W N W m C y E. � v E m c °I E m n � v w 36<Q' C C 8 N X f/1 6 N C m Q Iu 0 m Y m m E C _C W m l - La�km �mW � I L w m a Q vC 0 wm 00 E vx " W w �> L m° M y Ym n - S U rn O °LL a -C m m wm � s _ H IiJ w o5 ! �by c L° m v o 2 W m v :D m v w cl 0.0m U rn v mOmUU��W W Z Q 1°- 0�. O O O O O �+ G 00000 o ¢ oovvm (D O O N rymry�� ry M N M N 0 b W N N a O O O O O O O O O O O v 00000 O O m 4 m f0 O m M 10 A Q M r M W O D) o O m(n oN r N 4 V l V Q N m ro N V m N ONO v V O O O v.orn 0. n Om O C O0, N y y N (O N N CV N O o O O O O O O O O O p O O O O p Op� � n �ONiN V Ql �. r r N O O] O YU•• In O m O Q N � r V N f0 C C C O v Y y y D C w y r N —:2 m 06 j.2 U c70.o u Ol a' a i5 r x�o 0 v a 0]am 000000000000000000 o Ooo O O O O O O O O O O O O O O O O O O O o O ON� O O l m V O o N O f � V O(OOO (6 V N M N m fV N W d' � N Di .- (O N O (O O l N O Q (0 0 (0 0 M O l O O t 0 m u 1 0 f 0 U0 O O V N V O� Z N m ONO V O V r O m N O V (h O (O r N (V o f o N O O N fV Cl O r O N (nom(n rn(°o invo ogom(o d' m rn(OO W OM V O(°oa vNOr(o �' rovO N (O r N m m m O M V N 1� M N O O d' O M M m o A N N m I° t0 CC? 0 IO (p (O M O m N W O M (7 m M O O O (O r r (o m ri0oroori0 ui ri ri o o o(o� (�o (p l 0 M O O 7 M N m N M MONO N r M (O ro M O (O M O N �_ N � N N r O, N V r O O O V O M O N O M O W (O W o m M O 1 O I O (O O O r m O l0 O N O O) N m W M O m N N r V N fV N O w 00 o t000) o m 0 00000) Or t`{ It o O (V D 7 O (D o Z (O O C' I o o O o o (O r oo u 00 r MO X00 M M O OOO D70N MMM N NOMMNOr OOrM[+1 N m" M M o ry v rn a o 0 r rn m o o O M o m ci cio rnvi000vror o(o o-o rovi oJM N O)yy m.- N (00 cO 10N O m (O m MM (OON f000 D1r (O (OON O mm C1' 00 N MAN V (0 Or V N'-r� -uJ O oo(oro oorao�n000morn (n (oo 00�(OO rm'00��0�000�0I� N Nos Ld �0 O a' C N L = C _W 0 W N ? w °ww o c c ° � O w , o cv1co) N U N °tl m'o c m @ ~ c y m'[2 R S 30 0 y y o~ w �E c9 cn c9c�wwx0 aoow o a N � in 0 Q r a` N o N _ o Q a C IL 0 0 O N 0 0 0 0 O O N m X 0 0 O Cl! 0 0 0 0 O O r O o l V M O O o O O N GCG 6 �0 N O NIL OO ILm ppO N 0 0 M M mV V N M (ri 45 r r w It o 0 0 0 0 o N V d' 0• IN N f0• M M OO O O m m n a o m m 0 0- m N tNp t+N), ((OO, fm0 (d'1. c. V N N N N V lN0 fm0 O 10 m M r h M � �- V � N IN r N (O r❑ r Q r M fMO f0 r •� N fm m m 00 00 0 o m r r; ml N o 0 0 0 o O m m o 0 0 0 O O 0 �(r0 O O N m V V M N m• (O 0 In IA d' N 0 m OI � oc r .= N MM N(rm O O Ol (M')CMJ Imp N NINm tON A r n mmoo HOMO O (m mm mm m m p N Ol N N M M M c }} N o 0 J N N N a OD W m E •a c m � ° c c m a c um..�` c E •t3 otl m W a W m o. _ 0 M w m a ❑ �' a m' m `o �. W h m= m tl7 :a c W Q m e o r d c LL Fm- m R' Fo O o H o o a m am° F Z a` N o N _ o Q a C IL Parkview villa South (166) Balance February 2013 Books = Accrual 4. Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 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 Feb -13 56,604.98 186.00 713,970.36 1,646.93 9,165.99 1,682.50 7,575.40 14,401.67 62.00 3— 2,8 6 739,520.71 — 23— 8,-520 71 Parkview Villa -South (166) Income Statement 2010 -46340 Minor Equipment For The Period Ending February 2013 Books = Accrual 49.93 Revenue Month to Date 36220 -46340 Gen, Government Rents 36225 -46340 Nondwelling Rents 22,139.00 36290 -46390 Other Miscellaneous Revenue 462.00 39120 -46340 Recovery Damage City 174.00 Total Revenue 22,775.00 Expenses Personal Services 0.00 1000 -46340 Accrued Salaries 3060 -46340 Management Services Total Personal Services 3,932.00 3100 -46340 Protective Services 2,126.00 Supplies 3210 -46340 Telephone & Telegraph 2000 -46340 Office Supplies 2010 -46340 Minor Equipment 0.00 2160 -46340 Maint. &Construct Materials 49.93 2171 -46340 General Supplies 0.00 Total Supplies 150.79 200.72 Other Services & Charges 3040 -46340 Legal Fees 3050 -46340 Expert & Professional Services 0.00 3060 -46340 Management Services 0.00 3100 -46340 Protective Services 2,126.00 3210 -46340 Telephone & Telegraph 287.84 3430 -46340 Advertising Other 169.32 3600 -46340 Insurance & Bonds 95,28 0 3810 -46340 Electric 841.25 3 1820 -46340 Water 4,215.51 18 830 -46340 Gas 0.00 0,, 840 -46340 Refuse 2,525.90 11. 850 -46340 Sewer 0.00 0 )00 -46340 Repair & Maint. Services 0.00 0 100 -46340 Rents &Leases 2,129.36 9.3 300 -46340 Miscellaneous Charges 0.00 0.0k­ ... - - - •- ^� - -- �- :15 -46340 PILOT 0.00 0.0 90 -46340 Taxes &Licenses 1,028,69 4.5 00 -46340 Administrative Expenses 0.00 O.Ofz 50 -46340 Interest on Deposits 301.38 1.32 tal Other Services &Charges 5.28 0.02• 13,725.81 60.27 Payment Summary Bank= 1660pr AND mm /yy= 02/2013- 02/2013 AND All Checks =Yes AND Include Voids =All Checks 17,989.09 Check Post Totai Bank Check# Vendor Date Month Amount 1660pr - Parkvlew Villa South 1689 bmml -BMM Inc 02/05/2013 02/2013 341.62 166opr - Parkvlew Villa South 1690 cent - CenterPoint Energy 02/05/2013 02/2013 2,487.81 1660pr - Parkvlew Villa South 1691 chc - Commoneond Housing 02/05/2013 02/2013 6,141.00 1660pr - Parkvlew Villa South 1692 colu - City of Columbia Heights 02/05/2013 02/2013 1,594.58 1660pr - Parkvlew Villa South 1693 empi - Empire Door & Glass Co. 02/05/2013 02/2013 439.45 1660pr - Parkview Villa South 1694 adam - Adam's Pest Control, Inc. 02/12/2013 02/2013 —23.32 1660pr - Parkvlew Villa South 1695 bmml - BMM Inc 02/12/2013 02/2013 394.63 166opr - Parkview Villa South 1696 kone - Kone Inc. 02/12/2013 02/2013 145.94 166opr - Parkvlew Villa South 1697 leve - Level One 02/12/2013 02/2013 68.76 166opr - Parkvlew Villa South 1698 sunn - Sun Newspaper 02/12/2013 02/2013 95.28 166opr - Parkvlew Villa South 1699 hmml - BMM Inc 02/20/2013 02/2013 388.74 166opr - Parkview Villa South 1700 chc - CommonBond Housing 02/20/2013 02/2013 301,38 1660pr - Parkview Villa South 1701 dire - Direct Home Appliance Services 02/20/2013 02/2013 240.76 1660pr - Parkvlew Villa South 1702 frat - Frattalone's /Metro Ace 02/20/2013 02/2013 6.68 1660pr - Parkvlew Villa South 1703 home? - HD Supply Facilities Maintenance, Ltd. 02/20/2013 02/2013 144.11 1660pr - Parkview Villa South 1704 kone - Kone Inc. 02/20/2013 02/2013 - 314.50 1660pr - Parkview Villa South 1705 Popp - Popp,com 02120/2013 02/2013 100.56 166opr - Parkview Villa South 1706 sump - Simplex Grinnell 02/20/2013 02/2013 287.84 1660pr - Parkview Vllla South 1707 home7 - HD Supply Facilities Maintenance, Ltd, 02/26/2013 02/2013 49.93 166opr - Parkview Villa South 1708 10006414 - Pies 02/26/2013 02/2013 206.69 166opr - Parkvlew Villa South 1709 xcel - Xcel Energy 02/26/2013 02/2013 4,215.51 17,989.09 Parkview Villa -South (166) Income Statement For The Period Ending February 2013 Books = Accrual Month to Date Revenue Year to Date 36220 -46340 Gen. Government Rents 22,139.00 97.21% 45,434.00 96.46% 36225 -46340 Nondwelling Rents 462.00 2.03% 924.00 1.96% 36290 -46340 Other Miscellaneous Revenue 174.00 0.76% 742.69 1.58% 39120 -46340 Recovery Damage City - 0.00% - 0.00% Total Revenue 22,775.00 100.000/0 47,100.69 100.000/0 Expenses 169.32 0.74% 298.98 0.63% Personal Services Advertising Other 95.28 0.42% 255.56 1000 -46340 Accrued Salaries 3,932.00 17.26% 7,864.00 16.70% Total Personal Services 3,932.00 17.26% 7,864.00 16.700/b Supplies 4,587.51 9.74% 3820 -46340 Water 2000 -46340 Office Supplies 0.00 0.00% 27.79 0.06% 2010 -46340 Minor Equipment 49.93 0.22% 49.93 0.11% 2160 -46340 Malnt. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 150.79 0.66% 290.09 0.62% Total Supplies 200.72 0.880/0 367.81 0.78% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 0.00 0100% 3050 -46340 Expert & Professional Services 0.00 0.00% 0.00 0.00% 3060 -46340 Management Services 2,126.00 9.33% 4,252.00 9.03% 3100 -46340 Protective Services 287.84 1.26% 502.67 1.07% 3210 -46340 Telephone & Telegraph 169.32 0.74% 298.98 0.63% 3430 -46340 Advertising Other 95.28 0.42% 255.56 0.54% 3600 -46340 Insurance & Bonds 841.25 3.69% 1,682.50 3.57% 3810 -46340 Electric 4,215.51 18.51% 4,587.51 9.74% 3820 -46340 Water 0.00 0.00% - 865.60 - 1.84% 3830 -46340 Gas 2,525.90 11.09% 3,864.59 8.20% 3840 -46340 Refuse 0.00 0.00% 66.04 0.14% 3850 -46340 Sewer 0.00 0.00% -24.00 -0.05% 4000 -46340 Repair & Maint. Services 2,129.36 9.35% 6,097.43 12.95% 4100 -46340 Rents & Leases 0.00 0.00% 0.00 0.00% 4300 -46340 Miscellaneous Charges 0.00 0.00% 6.20 0.01% 4315 -46340 PILOT 1,028.69 4.52% 2,057.38 4.37% 4390 -46340 Taxes & Licenses 0.00 0.00% 0.00 0.00% 4500 -46340 Administrative Expenses 301.38 1.32% 301.38 0.64% 4850 -46340 Interest on Deposits 5.28 0.02% 11.74 0.02% Total Other Services & Charges 13,725.81 60.27% 23,094.38 49.03% Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense 0.00% 0.00% 0.00 0.000/0 0.00 0.000/0 17,858.53 78.41% 31,326.19 66.51% Excess (Deficit) Revenue over Expense 4,916.47 21.59% 15,774.50 33.490/a 3/14/2013 1:23 PM Parkvlew Villa South (166) General Ledger Period = Feb 2013 Book = Accrual ; Tree = ysi_tb Property Date Period Person / Descriptii Control Reference Debit Credit Balance Remarks 1000 -46340 Accrued Saiaries n 3,932.00 '= -Beginning Balance = 166 - 2/28/2013 02/2013 :PostRecurring Rea 3- 156871 RC 3,932.00 0.00 7,864.00 R/C CHIC PR Mgmt Fee Net Change= 3,932.00 7,864.00 = Ending Balance = 2000 -46340 Office Supplies 27.79 = Beginning Balance = Net Change =0.00 27.79 = Ending Balance = 2010 -46340 Minor Equipment 0.00 = Beginning Balance = 166 1/31/2013 02/2013 HD Supply Facilltie[P- 320872 9120284306 49.93 0.00 49.93 Countertop microwave Net Change =49.93 49.93 = Ending Balance = 2171 -46340 Maintenance Supplies 139.30 = Beginning Balance = 166 1/28/2013 02/2013 HD Supply FacIIItIe! P- 320920 9120189958 144.11 0.00 283.41 maint supplies 166 2/8/2013 02/2013 Frattalone's /Metro i P- 320608 014085R 6.68 0.00 290.09 maint supplies Net Change= 150.79 290.09 = Ending Balance = 3060 -46340 Management Services 2,126.00 = Beginning Balance = 166 2/28/2013 02/2013 CommonBond Hous P- 323000 02/16/13- 02/28/13 6,058.00 0.00 8,184.00 103039 mgmt fees 2/13 166 2/28/2013 02/2013 :PostRecurring Reci3- 156871 RC 0.00 3,932.00 4,252.00 R/C CHC PR Mgmt Fee Net Change= 2,126.00 4,252.00 = Ending Balance = 3100 -46340 Protective Services 214.83 = Beginning Balance = 166 1/25/2013 02/2013 Simplex Grinnell(si P- 319799 68592188 287.84 0.00 502.67 alarm /detection chrgs 1/24 -1/25 Net Change= 287.84 502.67 = Ending Balance = 3210 -46340 Telephone &Telegraph 129.66 = Beginning Balance = 166 1/1/2013 02/2013 Level One (leve) P- 319467 0290356in 34.38 0.00 164.04 1/13 tale rate plan chrgs 166 1/31/2013 02/2013 Popp.com (Popp) P- 320571 992084301 100.56 0.00 264.60 el svcs 02/2013 166 2/1/2013 02/2013 Level One (leve) P- 319350 0296410IN 34.38 0.00 298.98 2/13 tele rate plan chrgs Net Change= 169.32 298.98 = Ending Balance = 3430 -46340 Advertising Other 160.28 = Beginning Balance = 166 1/27/2013 02/2013 Sun Newspaper(su P- 319843 113215071 95.28 0.00 255.56 ad chrgs 1/17/13 Net Change =95.28 255.56 = Ending Balance = 3600 -46340 Insurance & Bands 841.25 = Beginning Balance = 166 2/28/2013 02/2013 :PostRecurring Reci3- 156871 RC 841.25 0.00 1,682.50 C of Columbia Heights Ins Accrl Net Change = 841.25 1,682.50 = Ending Balance = 3810 -46340 Electric Utilities _ 372.00 = Beginning Balance = 166 2/11/2013 02/2013 Xcel Energy (xcel) P- 321956 5150441553 02/11/ 4,215.51 0.00 4,587.51 elec 1/7- 2/5/13 Net Change= 4,215.51 4,587.51 = Ending Balance = 3820 -46340 Water -865.60 = Beginning Balance = Net Change =0.00 -865.60 = Ending Balance = 3830 -46340 Gas 1,338.69 = Beginning Balance = 166 2/7/2013 02/2013 CenterPoint Energy P- 320921 55271324 02/07/13 2,525.90 0.00 3,864.59 gas 1/7- 2/5/13 Net Change= 2,525.90 3,864.59 = Ending Balance = 3840 -46340 Refuse 66.04 = Beginning Balance = Net Change =0.00 66.04 = Ending Balance = 3850 -46340 Sewer -24.00 = Beginning Balance = Net Change =0.00 -24.00 = Ending Balance = Page 1 of 2 3/14/2013 1:23 PM 4300 -46340 4315 -46340 166 2/28/2013 02/2013 Miscellaneous Charges Net Change =0.00 PILOT PostRecurring Pee, 3- 156871 RC Net Change = 1,028.69 4500 -46340 Administrative Expenses 166 2/15/2013 02/2013 Common Bond Hous P- 321344 02/01/13- 02/15/13 166 2/15/2013 02/2013 CommonBond Tons P- 321344 02/01/13- 02/15/13 Net Change= 301.38 4850 -46340 Interest on Deposits 166 2/28/2013 02/2013 Sec Dep Interest ac 3- 157438 G31 Net Change =5.28 Page 2 of 2 6.20 = Beginning Balance = 6.20 = Ending Balance = 1,028.69 = Beginning Balance = 1,028.69 0.00 2,057.38 Anoka Cty Property Tax Accrual 2,057.38 = Ending Balance = 0.00 = Beginning Balance = 7.38 0.00 7.38 098069 2012 - 1099 /CRP Costs 294.00 0.00 301.38 098189 2012 CRP fees 301.38 = Ending Balance = 6.46 = Beginning Balance = 5.28 0.00 11.74 Sec Dep Interest accrual 11.74 = Ending Balance = 21,790.53 3,932.00 Parkview Villa South (166) - General Ledger Period = Feb 2013 Book = Accrual; Tree = ysi_[b Property Date Period Person /Descripti, Control Reference - Debit Credit Balance Remarks 4000 -46340 Exterminating Contract 3f 968.07 = Beginning Balance = 166 1/18/2013 02/2013 BMM Inc(bmml) P- 318987 25620 341.62 0.00 4,309.69 gen rprs /prev maint 1 /14- 1/18/1 166 1/22/2013 02/2013 Adam's Pest Contra P- 319494 773550 23.32 0.00 4,333.01 pest control 166 1/25/2013 02/2013 BMM Inc(bmml) P- 319888 25648 394.63 0.00 4,727.64 labor 1/21- 1/25/13 33.5hrs 166 1/29/2013 02/2013 Kone Inc.(kone) P- 319844 150789517 145.94 0.00 4,873.58 elvtr rpr 1/7- 1/9/13 166 2/1/2013 02/2013 BMM Inc (bmml) P- 320871 25654 388.74 0.00 5,262.32 labor 1/28- 2/1/13 33hrs 166 2/1/2013 02/2013 Kone Inc. (kone) P- 320859 221103787 314.50 0.00 5,576.82 eivtr maint 2/1- 2/28/13 166 2/6/2013 02/2013 High Profile Ground P- 320861 25580 103.08 0.00 5,679.90 snow removal 1/28- 1/29/13 166 2/7/2013 02/2013 High Profile Ground P- 320857 25650 102.30 0.00 5,782.20 de -I<Ing 2/2- 2/4/13 166 2/11/2013 02/2013 Direct Home Apple P- 321167 21113166 240.76 0.00 6,022.96 replace dryer motor 166 2/13/2013 02/2013 High Profile Ground P- 321787 25767 51.15 0.00 6,074.11 snow removal 2/11/13 166 2/19/2013 02/2013 Adam's Pest Contra P- 322593 778971 23.32 0.00 6,097.43 prevention plus 2/19/13 Net Change = 2129.36 6,097.43 = Ending Balance = 4300 -46340 4315 -46340 166 2/28/2013 02/2013 Miscellaneous Charges Net Change =0.00 PILOT PostRecurring Pee, 3- 156871 RC Net Change = 1,028.69 4500 -46340 Administrative Expenses 166 2/15/2013 02/2013 Common Bond Hous P- 321344 02/01/13- 02/15/13 166 2/15/2013 02/2013 CommonBond Tons P- 321344 02/01/13- 02/15/13 Net Change= 301.38 4850 -46340 Interest on Deposits 166 2/28/2013 02/2013 Sec Dep Interest ac 3- 157438 G31 Net Change =5.28 Page 2 of 2 6.20 = Beginning Balance = 6.20 = Ending Balance = 1,028.69 = Beginning Balance = 1,028.69 0.00 2,057.38 Anoka Cty Property Tax Accrual 2,057.38 = Ending Balance = 0.00 = Beginning Balance = 7.38 0.00 7.38 098069 2012 - 1099 /CRP Costs 294.00 0.00 301.38 098189 2012 CRP fees 301.38 = Ending Balance = 6.46 = Beginning Balance = 5.28 0.00 11.74 Sec Dep Interest accrual 11.74 = Ending Balance = 21,790.53 3,932.00 Parkview Villa South Bank Reconciliation Report 02/28/2013 emilow Balance Per Bank Statement as of 02/28/2013 Outstanding Checks Check dale Check number 02/12/2013 1698 02/20/2013 1701 02120/2013 1706 02/26/2013 1707 02/2612013 1708 02/26/2013 1709 Less: Outstanding Checks sunn - Sun Newspaper dire - Direct Home Appliance Services simp - Simplex Grinnell home? - HD Supply Facilities Maintenance, Ltd. t0006414 - Pies xcel - Xcel Energy Reconciled Bank Balance Balance per GL as of 02/2812013 Reconciled Balance Per G/L Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items Cleared Checks 03/04/2013 61,700.99 Amount 95.28 240.76 287.84 49.93 206.69 4,215.51 5,096.01 56,604.98 56,604.98 56,604.98 0.00 Date Tran # Notes Amount Date Cleared 01/15/2013 1672 t0010379 - Cassady 252.30 02/28/2013 01/24/2013 1674 bmmi - BMM Inc 736.25 02/28/2013 01/24/2013 1675 buck8411 - Buckeye Cleaning Centers - 77.37 02/2812013 01/24/2013 1677 high8236 - High Profile Grounds Maintenance, Inc. 158.10 02/2812013 01/24/2013 1678 kocl - K.O. Cleaning and Restoration LLC 250.00 02/28/2013 01/24/2013 , . 1679 Ibpm - _BP Mechanical, Inc 317.50 02/28/2613 01124/2013 1680 simp - Simplex Grinnell 149.42 02/28/2013 01124/2013 1681 sitz - Sitzmann Construction dba Sitzmann Elect 325.10 02/28/2013 01/24/2013 1682 sunn - Sun Newspaper 95.28 02/2812013 0112912013 1683 frat - Frattalone's /Metro Ace 26.69 02/28/2013 01129/2013 1684 gree1004 - Green Lights Recycling Inc 66.04 02/28/2013 01/29/2013 1685 kone - Kone Inc. 314.50 02/28/2013 01/29/2013 1686 offi8804 - Office Depot 27.79 02/28/2013 01/29/2013 1687 olse - Olsen Fire Protection, Inc. 302.25 02128/2013 01/29/2013 1688 xcel - Xcel Energy 1,859.92 02/28/2013 Total Cleared Checks 17,851.59 Cleared Deposits Date Tran # Parkview Villa South 360 03/04/2013 361 02/11/2013 Bank Reconciliation Report 02/28/2013 sallow Cleared Checks Date - Tran # Notes Amount Date Cleared 02/05/2013 1689 bmmi - BMM Inc 341.62 02/28/2013 02/05/2013 1690 - cent - CenterPoint Energy - 2,487.81 02/28/2013 02/05/2013 1691 chc - CommonBond Housing 6,141.00 02/28/2013 02/0512013 1692 colu - City of Columbia Heights 1,594.58 02128/2013 02/05/2013 1693 empi - Empire Door & Glass Co. 439.45 02/28/2013 02/12/2013 1694 adam - Adam's Pest Control, Inc. 23.32 02/28/2013 02/12/2013 1695 bmmi - BMM Inc 394.63 02/28/2013 02/12/2013 1696 kone - Kone Inc. 145.94 02/28/2013 02/12/2013 1697 leve - Level One 68.76 02/28/2013 02120/2013. 1699 bmmi - BMM Inc 388.74 02/28/2013 02/20/2013 1700 chc - CommonBond Housing 301.38 02/28/2013 02/20/2013 1702 frat - Frattalone's /Metro Ace 6.68 02/28/2013 02/20/2013 1703 home7 - HD Supply Facilities Maintenance, Ltd. 144.11 02/28/2013 02/20/2013 1704 kone - Kone Inc, 314.50 02/28/2013 02/20/2013 1705 Popp - Popp.com 100.56 02/28/2013 Total Cleared Checks 17,851.59 Cleared Deposits Date Tran # 02/04/2013 360 02/05/2013 361 02/11/2013 362 Total Cleared Deposits Notes J Amount 19,028.00 2,431.00 648.00 22,107.00 Date Cleared 02/28/2013 02/28/2013 02/28/2013 Date 2/28/13 Page 1 Primary Account @XXXXXAGNW Enclosures 33 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O CQMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C O U N T S - - -- IF YOU GET FEDERAL BENEFIT PAYMENT'S BY PAPER CHECK, YOU ARE REQUIRED BY LAW TO SWITCH TO ELECTRONIC PAYMENTS BY MARCH 1, 2013. TIME IS RUNNING OUT. SWITCH TO DIRECT DEPOSIT TODAY. VISIT ONE OF OUR BRANCHES FOR A PERSONAL BANKER TO ASSIST YOU, CALL (800)333 -1795 OR VISIT WWW.GODIRECT.ORG. NORTHEAST PUBLIC FUNDS ACCT Number of Images 33 Account Number @XXXXAPNIMJP Statement Dates 2/01/13 thru 2/28/13 Previous Balance 57,445.58 Days in the Statement Period 28 3 Deposits /Credits 22,107.00 Average Ledger 64,188 30 Checks /Debits 17,851.59 Average Collected 63,476 Service Charge .00 Interest Paid .00 Ending Balance - 61,700.99 *********************************************** * * * * * * * * * * * * * * * * * ** * * * * * * * ** * ** Deposits and Credits Date Description Amount 2/04 DDA REGULAR DEPOSIT 19,028.00 2/05 DDA REGULAR DEPOSIT 2,431.00 2/11 DDA REGULAR DEPOSIT 648.00 Checks in serial order Date Check# Amount Date Check# Amount 2/11 1672 252.30 2/05 1686 27.79 2/07. 1674* 736.25 2/04 1687 302.25 2/01 1675 77.37 2/04 1688 1,859.92 2/06 1677* 158.10 2/08 1689 341.62 2/22 1678 250.00 2/11 1690 2,487.81 2/01 1679 317.50 2/07. 1691 6,141.00 2/04 1680 149.42 2/11 1692 1,594.58 2/04 1681 325.10 2/08 1693 439.45 2/01 1682 95.28 2/19 1694 23.32 2/04 1683 26.69 2/19 1695 394.63 2/04 1684 66.04 2/19 1696 145.94 2/04 1685 314.50 2/19 1697 68.76 * Indicates skip in check numbers NORTHEAST PUBLIC FUNDS ACCT Checks in serial order Date 2/28/13 Primary Account Enclosures @XXXXX (Continued) Date Check# Amount Date Check# 2/26 1699* 388.74 2/26 1703 2/22 1700 - 301.38 2/27 1704 2/26 1702* 6.68 2/27 1705 * Indicates skip in check numbers 2/05 74,606.47 Page 2 @XXXXX 33 Amount 144.11 314.50 100.56 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Balance Section Date Balance Date Balance Date Balance 2/01 56,219.18 2/07 68,307.37 2/22 62,655.58 2/04 72,203.26 2/08 67,526.30 2/26 62,116.05 2/05 74,606.47 2/11 63,839.61 2/27 61,700.99 2/06 74,448.37 2/19 63,206.96 * ** E N D O F S T A T E M E N T Parlcview Villa North Financial Statement Overview February 2013 Revenue: Occupancy for the month of February 2013 was 99% occupied; Total Revenue for February was under budget (unfavorable). No grant income recognized Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Computer Equipment, Supplies and Maintenance was under budget (favorable) Misc. Admin Expenses was over budget (unfavorable) and reflects an incorrect billing that is reversed in March Utilities: Utilities Expenses were over budget (unfavorable) Electric was over budget (unfavorable) and reflects Jan. costs Gas was over budget (unfavorable) and reflects January costs Water and Sewer were not invoiced in February Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract is over budget (unfavorable) and reflects cost of a dryer motor replacement Garbage and Trash are under budget (favorable); however, this is a quarterly billing Security Contract is under budget (favorable). Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs is under budget (favorable) Snow Removal Contract was under budget (favorable) but reflects most of January costs Decorating Contract and Supplies were under budget (favorable) Furniture and Fixtures was under budget (favorable) mv_lm nv m w3�m��?. a W 'O N �. -� a .w. O K N N N IAU N N m C 0 0� N N vw` ,8'0, mERa 9@ $ m m3 <�'38 S d N N N 3 N O j N N on 0 = O N N 0 O �. m WN N 3 mn • N N i A W (p W J W V ({pa + O (WO m O A N N O N O O O ! N O O N O 6V W 0 0 0 N O O O O O i "Moo O A W W O O O V O O O O O I }a A W r O O W O O A Ul 01 O N N N O iJ O O+ W W O W O O N O W W W w N W O O V W W o J O O O O I W W W V W 3I 1 i O O 1 N W pl (wp bNJ A fwJN ONNO i OAN W W �4 W N V W W V V 0 0 0 0 Il! N O W (OO OOO (O ISO. p O Z A O +-' +00000 N (DO + A D N O W W A O O O O O N N O W O N 0) 0) W A J W O 0 0 p V OI O O J t 0 U t O A A W N A N A N J N O V V A 0000(00000 j N[w0 00 N O O (O W O W O W N O ± (lI O W t0 w O O W ++ O W A O OI m °o °oamrn °o �'OO °o °o0 � rnrnWn° I' o � o (O W W W+ W Ol N N t0 N tV0 W W O O W V N N N W - (O A W J V W O O O W fli w+ V N O J W <J W W O W 0 0 0 0 W A A W W W W N A 0) 0) V ID O O O O N O) J W O {3 3 3 3 3 3 w O (O V W O O W i 0 N m N O .Q W O O+ PIP O O O. o, w A W O O Z A O M W0 N 0 0 0 0 3 V A V+ (WO O W D W O W w J+ o 0 0 0 ! a I n v W +MW Wl0)1+ 1 Ww+ A N? - O N s (w0 O O N O W O O O W O( w N 0 0 0 0 0 0 0 0 A O O O O A -` O m 7 88088 O O O O 666 a a Z N D °l m N m q m w m° n O Z m w N< C J � < W < m w = w 0 N f tN0 N D tWp P fWp W A G O O O 0 O O O O O1 Ol W !J W + +)ww !a W W W O N W W W O N Nv! J r�n00 0 O O A O �D W W Owi OO (O A AW W Ec O 000 (WO t0 W � NW NW A V NO) Ol m mm 1R 0 o ;S 0 CWII NAB W A W D O) W W O 9 C O O O i z S w W �v y O ° 0 OW ON Wf A G6 GN ) 3 m M x mO c» 0N.n a + {N � wN m ,'S> NNmm C ry 0 n N N .j � N C �? �'�' M* � > w 3 • O O y `w N O R C^ PO NWj �C} J fl N p��j N > > CI IV ` m 0 N O O QO n" n W ry » N ^ G� O C C i 0 =i d ON W W _ O a 9 d N N ow m N N 0 2 B A mn [m n D B 0 o av oMm p� n $< _ fi n a N 0 ' w . ; No N'.3 m O fJ H + O V O UN W (O + O A m O W O V W 00 -0000 V A A 0000 W W 00 p O NOOI O V V }L} W O O O V A W V O O W O W N O O + O V O? O W ONO W O +l A W W O W N J O W O O r p + +A +A W +ip N ZT NA W A V >NCJ W WpJ N(nN p +W 00 41 W O W W W fD W 6 W W N V O W O? V O O) m 41 O fll m W O) A W o V V W O O V V V N V O W w O W W W N W O W W W N O W . W m w V W 10 V O W O N W O 24 m W W V A O W W W W A O (O W W O N O A O � W A O N N O O W O t0 W N - O N+ A A W O W IO N W V W W A OOOONIIi V W AA00 -� V W OJO V W W w W .P W N W V W D! J V W n 0 O O� + O W O O O N W N A 808i, W O O N O W O O O A(OO W Z O O A O O N O W O U O W O A O(OO 1 P A W a o(4w O A IO W OCO +oOOA(J OJ W o+o'A W Oo + O W 0 0 0 N W W ADO W o W W O O V OAO(OO W O W O N O W (O Wly O A A n + V N W N W t0 �@ O A O W W IJ W O- �OOONA A(000 W W A WON 00 O O O W W W? O O W ID -` W O N A A O O W[ W N O O !D W O bJ O J O W O O O W O (ll A O W L O O A W O W O O O V W W W r W + N N N + o O N N N N W N W O W W f0 N. M W W W W? W U1 W IJ 0) N O NOON W O W W W N W W W (O W O o W O+ O M (p 0— W (O fD J G 6 W W V W O W o O V O W W W O UI W w W O W O m O W W W LJ 41 W O W W OI m PD. + W W P W W fN O W O W N O W W O pJ O A O MO A O O A A W O O A A A A A O W O W W A W O W W W IN W O W W W (P + O N � W m WW (p fD (p + W W P W O W -+ m( m A O W N(OOVWWNNV NWAWWWN N O N A N(O V W V O O N O O W M W wo. A WWblOJ W W A A W A A O W O O V N W W ONO W N W (O (l� V O O OI W -+ O W W W O m W o W o W W W O W O W W (O W W O O A N O V O (O O A W O W W W O W W O N O N N W p W O N W W N O W N O W O W O fD ONO (O O V + A o O W 04 w W O O W O V O W O (P W W W 2 n N N V W 3 N W J N W A W W ? W W W V W O W W W W N IAO W N O (J O �1 W N(OO W J O4IO UIO W-+V N +(ll lJO IJ O A O N N O O O O O N O W O A O O 0 W M-0 W O O O m O W j- N O A W O O O N W O O O O O O O W O W O O N N O O O O l0 W O O O O O O O O O O O O O O O O O O O O O 0 0 0 0 0 0 N O O O O O O O O O O O O O O O O O O O O O 0 0 0 i z S Ci `a irI ° N 'S W -{ -{ -i Z ° -i ° ° O E A o � T -2hi i W Z k g 1 ? o m m O O ' u C c j N o N �L '9 - 0 Q. C V O S4. 2 'y N m =N r.Z N a n 9O 9�K O O 9m o Si. �• v (/1 N R+ m N d m m m N � a N N V O O O O 0 0 0 O O 0 O O f 0 10 V J pJ O O 00 00 O O N (11 A Ql Oo fl! T � OJ f0 OU N NW WW !mJ N INii Ol W W W W W FOOD W W O O O W W W W Ol f0 f0 V V N N W + N V J W � W cOJ N UNi T FOOD W W W W W W O O O OOO N O o 0 0 A N O W O O O 00 00 OJl Jppa p A t�pl <n A A (��a q O 00 � pNj pNj � 00 A m W N N J N � p OWi OWi (00 N W O1 W 0) o o N 01 V V °o °O °o a mrn m rn w mrn ID OCV N W J V N N tW0 V V A FO (p (O (p l0 0 o o V W A O N O O O O O N C 1 O! m m V V O o A A A A P VJ yV O 0 W O W T V V N U i �p A V 0 N N A O O 0 0 0 A A O 0 00 00 r1 0 �m O O O 0 0 0 0 O O 0 0 a o- Q y Il I { R n a - .0 Z N � N. U N 4l N W O wi A IJ O 0 N 08 N p � v c w O Parkview Villa -North (165) Balance Sheet February 2013 Books = Accrual Feb -13 Assets 10100 Cash Balance 14,065.66 10200 Petty Cash 664.00 10400 Investments 891,214.11 11300 Rent Receivable -. 1,873.20 11500 Accounts Receivable 208.12 13200 Due From Other Government Units 23,847.09 Total Assets 931,872.18 Liabilities 20200 Accounts Payable 22,328.99 20210 Accrued Other Expenses 3,483.50 20220 Due to Resident Council 551.74 22000 Deposits 18,746.10 22200 Accrued PILOT 28,380.08 22210 Revenue Collected in Advance 633.10 Total Liabilities 74,123.51 Fund Balance 25300 Fund Balance 857,748.67 Total Fund Balance 857,748.67 Total Liabilities and Fund Balance 931,872.18 Parkview Villa -North (165) Income Statement For The Period Ending February 2013 Books = Accrual Revenue 33160 -46330 Federal Grant 36220 -46330 Gen. Government Rents 36225 -46330 Nondwelling Rents 36290 -46330 Other Miscellaneous Revenue 39120 -46330 Recovery Damage City Property Total Revenue Expenses Personal Services 1000 -46330 Accrued Salaries Total Personal Services Supplies 2000 -46330 Office Supplies 2010 -46330 Minor Equipment 2160 -46330 Maint. & Construct Materials 2171 -46330 General Supplies Total Supplies other Services & Charges 3040 -46330 Legal Fees 3050 -46330 Expert and Professional Services 3060 -46330 Management Services 3100 -46330 Protective Services 3210 -46330 Telephone & Telegraph 3430 -46330 Advertising Other 3600 -46330 Insurance & Bonds 3810 -46330 Electric 3820 -46330 Water 3830 -46330 Gas 3840 -46330 Refuse 3850 -46330 Sewer 4000 -46330 Repair & Maint. Services 4100 -46330 Rents & Leases 4300 -46330 Miscellaneous Charges 4315 -46330 PILOT 4390 -46330 Taxes & Licenses 4500 -46330 Administrative Expenses 4850 -46330 Interest on Deposits Total Other Services & Charges Month to Date % Year to Date 28.42% - 0.000/0 - 0.000/0 29,465,00 95.54% 59,156.00 96.05% 429.00 1.39% 858.00 1.39% 840.12 2.72% 1,469.81 2.39% 105.00 0.34% 105.00 0.17% 30,839.12 100.000/0 61,588.81 100.000/0 8,752.00 28.38% 17,504.00 28.42% 8,752.00 28.38% 17,504.00 28.42% 395.57 1.28% 541.02 0.88% 111.13 0.36% 111.13 0.18% 946.55 3.07% 1,114.18 1.81% 0.00 0.00% 172.20 0.28% 1,453.25 4.71% 1,938.53 3.15% 84.00 0.27% 84.00 0.14% 0.00 0.00% 0.00 0.00% 4,772.00 15.47% 9,544.00 15.50% 640.66 2.08% 1,118.83 1.82% 376.88 1.22% 665.48 1.08% 0.00 0.00% 65.00 0.11% 1,741.75 5.65% 3,483.50 5.66% 1,635.46 5.30% 2,487.76 4.04% 0.00 0.00% 0.00 0.00% 6,452.72 20.92% 6,521.80 10.59% 0.00 0.00% 146.99 0.24% 0.00 0.00% 0.00 0,00% 7,501.73 24.33% 12,525.35 20.34% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 2,027.15 6.57% 4,054.30 6.58% 0.00 0.00% 0.00 0.00% 1,627.26 5.28% 1,627.26 2.64% 20.04 0.06% 27.74 0.05% 26,879.65 87.16% 42,352.01 68.77% Capital Outlay 5120 -46330 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00 0.00% 437.26 0.71% 1.00 0.00% 437.26 0.71% 37,084.90 120.250/b 62,231.80 101.04% - 6,245.78 - 20.25% - 642.99 -1.04% Parkview Villa -North (165) Cash Flow Statement Period = February 2013 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 Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Maint. & Construct Materials 2171 General Supplies 2280 Vehicle Parts Total Supplies Other Services & Charges 3040 Legal Fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maint. Services 4050 Garage, Labor Burd. 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 Month to Date 0.00 29,465.00 429.00 840.12 105.00 30,839.12 8,752.00 8,752.00 395.57 111.13 0.00 946.55 0.00 1,453.25 84.00 0.00 4,772.00 640.66 376.88 0.00 1,741.75 1,635.46 0.00 6,452.72 0.00 0.00 7,501.73 0.00 0.00 0.00 2,027.15 0.00 1,627.26 20.04 0.00 26,879.65 37,084.90 - 6,245.78 Parkview Villa -North (165) Cash Flow Statement Period = February 2013 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 0.00 0.00 - 664.54 660.00 0.00 7,171.47 - 79,818.25 113.24 2,027.15 295.10 (70,215.83) (76,461.61) Beg Cash End Cash Difference 90,527.27 - 14,065.66 (76,461.61) 664.00 664.00 - 891,214.11 891,214.11 - 982,405.38 905,943.77 (76,461.61) 3/14/2013 1:20 PM Parkview Villa -North (165) General Ledger Period = Feb 2013 Book = Accrual, Tree = ysl tb Prope Data Period. Persod /Oescription Control) Reference., Debit Credit - Balance Remarks 8,752.00 = Beginning Balance = 1000 -46330 Accrued Salaries 165 2128/2013 02/2013 : PostRecurfing Monthly recurring a 3- 156870 RC 8,752.00 0.00 17,504.00 R/C CHC PR Mgmt Fee 17,504.00 = Ending Balance = Net Change = 8,752.00 145.45 = Beginning Balance = 2000 -46330 Office Supplies 165 1/29/2013 02/2013 SHI International Corp (shli) P- 320555 800924269165 377.24 0.00 522.69 Orewall replacement po #333 165 2/28/2013 02/2013 CommonBOnd Housing (chc) P- 324233 02/16/13- 2/28/1 18.33 - 0.00 541.02 102808 comp supp 1/28 -2/1 541.02 = Ending Balance = Net Change= 395.57 - 0.00 = Beginning Balance = 2010 -46330 Minor Equipment 165 1/31/2013 02/2013 HD Supply Facilities Maintenance, P- 320872 9120284306 111.13 0.00 111.13 countertop microwave 111.13 = Ending Balance = Net Change= 111.13 2160 -46330 Maint. & Construct. Materials 167.63 = Beginning Balance = 165 1128/2013 02/2013 HD Supply Facilities Maintenance, P- 320920 9120189958 320.77 0.00 488.40 maint supplles 165 2/8/2013 02/2013 Fmttaione's /Metro Ace (frat) P- 320608 014085R 14.87 0.00 503.27 maint supplies 165 2/12/2013 02/2013 HD Supply Facilities Maintenance, P- 321799 9120500578 610.91 0.00 1,114.18 maint supplies Net Change= 946.55 1,114.18 = Ending Balance = 172.20 = Beginning Balance = 2171 -46330 General Supplies 172.20 = Ending Balance = Net Change =0.00 0.00 = Beginning Balance = 3040 -46330 Legal Fees 165 1/28/2013 02/2013 Kennedy & Graven, Chartered (kei P- 318825 112369 84.00 0.00 84.00 legal saw chrgs 12119/12 84.00 = Ending Balance = Net Change =84.00 4,772.00 = Beginning Balance = 3060 -46330 Management Services 165 2/28/2013 02/2013 Common Bond Housing(chc) P- 324233 02/16/13- 2/28/1 13,524.00 0.00 18,296.00 103038 mgmt fees 02/13 165 2/28/2013 02/2013 :PostRecurring Monthly recurring a 3- 156870 RC 0.00 8,752.00 9,544.00 R/C CHC PR Mgmt Fee Net Change = 41772.00 9,544.00 = Ending Balance = 478.17 = Beginning Balance = 3100 -46330 Protective Services 165 1/25/2013 02/2013 Simplex Grinnell (simp) P- 319799 68592188 640.66 0.00 1,118.83 alarm /detection chrgs 1/24 -1 11118.83 = Ending Balance = Net Change = 640.66 288.60 = Beginning Balance = 3210 -46330 Telephone &Telegraph 165 1/1/2013 02/2013 Level One (ieve) P- 319467 02903561n 76.52 0.00 365.12 1/13 tole rate plan chrgs 165 1/31/2013 02/2013 POPP -com (Popp) P- 320571 992084301 223.84 0.00 588.96 tai Svcs 02/2013 165 2/1/2013 0212013 Level One (leve) P- 319350 0296410IN 76.52 0.00 665.48 2/13 teie rate plan chrgs 665.48 = Ending Balance = Net Change= 376.88 3430 -46330 Advertising Other 65.00 = Beginning Balance = 65.00 = Ending Balance = Net Change =0.00 3600 -46330 Insurance & Bands 1,741.75 = Beginning Balance = 165 2/28/2013 02/2013 :PostRecurring Monthly recurring e1- 156870 RC 1,741.75 0.00 3,483.50 C of Columbia Heights Ins Ac Net Changep1,741.75 3,483.50 = Ending Balance = 852.30 = Beginning Balance = 3810 -46330 Electric 165 2/11/2013 02/2013 Xcei Energy(xcei) P- 321956 5150441553 02/ 1,635.46 0.00 2,487.76 elec 1/7- 2/5113 Net Change = 1,635.46 2,487.76 = Ending Balance = 69.08 = Beginning Balance = 3830 -46330 Gas 165 2/6/2013 02/2013 CenterPoint Energy (cent) P- 320922 55199657 02/06 6,452.72 0100 6,521.80 gas 1/4- 2/4/13 Net Change = 61452.72 6,521.80 = Ending Balance = 146.99 = Beginning Balance = 3840 -46330 Refuse 146.99 = Ending Balance = Net Change =0.00 4000 -46330 Repair & Plaint. Services 5,023.62 = Beginning Balance = 165 11/30/2012 02/2013 Nasseff Mechanical Contractors (m P- 321301 41213 45,000.00 0.00 50,023.62 106 toilet replacements Page 1 of 2 3/14/2013 1:20 PM Parkvlew Villa -North (165) General Ledger Period = Feb 2013 Book = Accrual ; Tree = yell 165 12/20/2012 02/2013 Nasseff Mechanical Contractors (n; P- 321302 41396 36,560.00 0.00 86,583.62 106 toilet replacements 165 1/18/2013 02/2013 BMM Inc (bmmi) P- 318987 25620 760.38 0.00 87,344.00 gen rprs /prev mount 1/14 -1/: 165 1/2212013 02/2013 Adam's Pest Control, Inc. (adam) P- 319494 773550 51.91 0.00 87,395.91 pest Control 165 1/25/2013 02/2013 BMM Inc(bmmi) P- 319888 25648 878.37 0.00 88,274.28 Tabor 1 /21- 1/25/13 33.5hrs 165 1/28/2013 02/2013 K.O. Cleaning and Restoration LLC P- 320646 1331 900.00 0.00 89,174.28 paint /repairs /Floor apt 806 165 1/28/2013 02/2013 K.O. Cleaning and Restoration LLC P- 320647 1332 100.00 0.00 89,274.28 repair water damage #105 165 1/28/2013 02/2013 K.O. Cleaning and Restoration LLC P- 320648 1333 150.00 0.00 89,424.28 repair cracks /wtr damage #1 165 1/28/2013 02/2013 Direct Home Appliance Services (d P- 321168 12813165 205.41 0.00 89,629.69 replace dryer motor 165 1/29/2013 02/2013 Kone Inc,(kone) P- 319844 150789517 324.82 0.00 89,954.51 elvtr pr 1 /7- 1/9/13 165 1/31/2013 02/2013 LBP Mechanical, Inc (Ibpm) P- 320873 W18201 442.54 0100 90,397.05 thermocouple rplmnt #4 bolli 165 2/1/2013 02/2013 BMM Inc (bmmi) P- 320871 25654 865.26 0.00 91,262.31 labor 1/28- 2/1/13 33hrs 165 2/1/2013 02/2013 RC 12/31 Nasseff Invoices Invoices 3- 15767.2 G33 0.00 36,560.00 54,702.31 RC 12/31 Nasseff Invoices In 165 2/1/2013 02/2013 RC 12/31 Nasseff Invoices Involcei)- 157672 G33 0.00 45,000.00 9,702.31 RC 12/31 Nasseff Invoices In 165 2/1/2013 02/2013 Kone Inc.(kone) P- 320859 221103787 700.01 0.00 10,402.32 elvtr maim 2 /1- 2/28/13 165 2/6/2013 02/2013 High Profile Grounds Maintenance, P- 320861 25580 229.42 0.00 10,631.74 snow removal 1/28 - 1/29/13 165 2/7/2013 02/2013 High Profile Grounds Maintenance, P- 320857 25650 227.70 0.00 10,859.44 de -Icing 2/2- 2/4/13 165 2/13/2013 02/2013 High Profile Grounds Maintenance, P- 321787 25767 113.85 0.00 10,973.29 snow removal 2/11/13 165 2/15/2013 02/2013 High Profile Grounds Maintenance, P- 321786 25834 351.90 0.00 11,325.19 snow plow chrgs 3/13 165 2/15/2013 02/2013 High Profile Grounds Maintenance, P- 321786 25834 158.10 0.00 11,483.29 snow plow chugs 3/13 165 2/19/2013 02/2013 Adam's Pest Control, Inc. (adam) P- 322593 778971 51.91 0.00 11,535.20 prevention plus 2/19/13 165 2/19/2013 02/2013 LBP Mechanical, Inc (Ibpm) P- 321785 W18234 265.00 0.00 11,800.20 pipe Insulate chrgs #510 165 2/21/2013 02/2013 Cummins NPower LLC (cumm160C P- 322595 10049556 590.15 0.00 12,390.35 replace stndby Nee batteries 165 2/22/2013 02/2013 Gardner Plumbing, LLC (gard1086: P- 322322 2603 135.00 0.00 12,525.35 plumbing sery call #106 Net Change = 7,501.73 12,525.35 = Ending Balance = 4315 -46330 PILOT 2f027.15 = Beginning Balance = 165 2/28/2013 02/2013 :PostRecurring Monthly recurring a 3- 156870 RC 2,027.15 0.00 4,054.30 Anoka City Property Tax Accn Net Change = 2,027.15 41054.30 = Ending Balance = 4500 -46330 Administrative Expenses 0.00 = Beginning Balance = 165 12/28/2012 02/2013 Johnson (1:0004025) C- 1102729 969.78 0.00 969.78 Over 90 days balance due -r 165 2/15/2013 02/2013 Common0oad Housing (chc) P- 321343 02/01/13 - 02/151 8.73 0.00 978.51 098068 2012 -1099 CRP cost 165 2/15/2013 02/2013 Common8ond Housing (chc) P- 321343 02/01/13 - 02/151 603.75 0.00 1,582.26 098188 2012 CRP fees 165 2/15/2013 02/2013 CommonBond Housing (chc) P- 321343 02/01/13- 02/15/ 45.00 0.00 1,627.26 098292 trusted bck grnd cks Net Charge= 1,627.26 1,627.26 = Ending Balance = 4850 -46330 Interest on Deposits 7.70 = Beginning Balance = 165 2/2812013 02/2013 Sec Dep Interest accrual 3- 157437 G32 20.04 0.00 27.74 Sec Dee Interest accrual Net Change =20.04 27.74 = Ending Balance = 5120 -46330 Building & Improvements 437.26 = Beginning Balance= Net Change =0.00 437.26 = Ending Balance = 127,396.90 90,312.00 Page 2 of 2 Parkview Villa North Bank Reconciliation Report 02/28/2013 5016456 Balance Per Bank Statement as of 02/28/2013 Outstanding Checks Check date Check number 02/05/2013 2012 02/2012013 2023 02/20/2013 2026 02120/2013 2031 02126/2013 2032 02/2612013 2033 02/26/2013 2034 02/2612013 2035 Less: Outstanding Checks Payee dire - Direct Home Appliance Services dire - Direct Home Appliance Services kocl- K.O. Cleaning and_Restoration LLC simp - Simplex Grinnell gardl 086 - Gardner Plumbing, LLC home7 - HD Supply Facilities Maintenance, Ltd Ibpm - LBP- Mechanical, Inc xcel - Xcel Energy Reconciled Bank Balance Balance per GL as of 02/28/2013 Reconciled Balance Per G/L Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items : Cleared Checks 03/05/2013 18,689.14 Amount 480.82 205.41 1,150.00 640.66 135.00 111.13 265.00 1,635.46 4,623.48 14,065.66 14,065.66 14,065.66 0.00 Date Tran # Notes Amount Date Cleared 01/24/2013 1995 bmmi - BMM Inc 1,638.75 02/28/2013 01/24/2013 1996 buck8411 - Buckeye Cleaning Centers 172.20 02128/2013 01/24/2013 1997 high8236 - High Profile Grounds Maintenance, Inc. 351.90 02/2812013 01124/2013 1998 home7- HD Supply Facilities Maintenance, Ltd. 22.49 02/2812013 01/24/2013 1999 kocl - K.O. Cleaning and Restoration LLC 150.00 02/28/2013 01/24/2013 2000 simp - Simplex Grinnell 332.58 02/2812013 01/24/2013 2001 sitz - Sitzmann Construction dba Sitzmann Elect 1,135.30 02128/2013 01/29/2013 2002 cent- CenlerPoint Energy 6,125.36 02128/2013 01/29/2013 2003 colu - City of Columbia Heights 1,377.75 0212812013 01/29/2013 2004 gree1004 - Green Lights Recycling Inc 146.99 02128/2013 01/29/2013 2005 home7 - HD Supply Facilities Maintenance, Ltd, 91.95 02128/2013 01129/2013 2006 kone - Kone Inc. 700.01 02128/2013 01129/2013 2007 off8804 -Office Depot 61.85 02128/2013 Parkview Villa North 03105/2013 Bank Reconciliation Report 02/2812013 5016456 Cleared Checks Date Tran # Notes Amount Date Cleared 0112912013 2008 olse - Olsen Fire Protection, Inc. 672.75 02/28/2013 01/29/2013 2009 xcel - Xcel Energy 4,139.82 02/28/2013 02/05/2013 2010 bmmi - BMM Inc 760.38 02/28/2013 02/05/2013 2011 chc - CommonBond Housing 13,672.60 02/28/2013 02105/2013 2013 kenn - Kennedy & Graven, Chartered 84.00 02/28/2013 02/05/2013 2014 Ibpm - LBP Mechanical, Inc 566.84 02/28/2013 02/05/2013 2015 waic - WAI Continuum 437.26 02/28/2013 02/12/2013 2016 adam - Adam's Pest Control, Inc. 51.91 02/28/2013 02/12/2013 2017 bmmi - 6MM Inc 878.37 02/28/2013 02112/2013 2018 - _ kone - Kone Inc. 324.82 - 02/28/2013 02/12/2013 2019 - leve - Level One 153.04 02/28/2013 02/1212013 2020 shii - SHI International Corp 377.24 02/28/2013 02/20/2013 2021 bmmi - BMM Inc 865.26 02/28/2013 02/20/2013 2022 chc - CommonBond Housing .657.48 02/28/2013 02120/2013 2024 Prat - Frattalone's /Metro Ace 14.87 02/28/2013 02/20/2013 2025 home? - HD Supply Facilities Maintenance, Ltd. 320.77 02/28/2013 02/20/2013 2027 kone - Kone Inc. 700.01 02/28/2013 02/20/2013 2028 Ibpm - LBP Mechanical, Inc 442.54 02/28/2013 02/20/2013 2029 nass - Nasseff Mechanical Contractors 81,560.00 02/28/2013 02/20/2013 2030 Popp - Popp.com 223,84 02/28/2013 Total Cleared Checks 119,210.93 Cleared Deposits Date Tran # Notes Amount Dale Cleared 02/04/2013 469 - 23,969.00 02/28/2013 02/04/2013 472 0.00 02/28/2013 02/05/2013 471 3,150.00 02/28/2013 02111/2013 474 2,312.10 02/28/2013 02111/2013 474 605.00 02/2812013 02115/2013 475 217.00 02/28/2013 Total Cleared Deposits 30,253.10 02/22/2013 JE 156545 02/2212013 Payroll -19.68 02/2812013 02/22/2013 JE 157246 Rev automated Yardi PR entry 19.68 02/28/2013 Date 2/28/13 Page 1 Primary Account @XXXXX@ Enclosures 37 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C 0 U N T S - - -- IF YOU GET FEDERAL BENEFIT PAYMENTS BY PAPER CHECK, YOU ARE REQUIRED BY LAW TO SWITCH TO ELECTRONIC PAYMENTS BY MARCH 1, 2013. TIME IS RUNNING OUT. SWITCH TO DIRECT DEPOSIT TODAY. VISIT ONE OF OUR BRANCHES FOR A PERSONAL BANKER TO ASSIST YOU, CALL (800)333 -1795 OR VISIT WWW.GODIRECT.ORG. NORTHEAST PUBLIC FUNDS ACCT Number of Statement Images Dates 2/01/13 thru 37 2/28/13 Account Previous Number @xXxxx@qbw Balance 107,646.97 Days in the Statement Period 28 4 Deposits /Credits 30,253.10 Average Ledger 96,522 95,454 33 Checks /Debits 119,210.93 Average Collected Service Charge .00 Interest Paid .00 Ending Balance 18,689.14 Deposits and Credits Amount Date Description 23,969.00 2/04 DDA REGULAR DEPOSIT 3,150.00 2/05 DDA REGULAR DEPOSIT 2,917.10 2/11 DDA REGULAR DEPOSIT 217.00 2/15 DDA REGULAR DEPOSIT Checks in serial order Check# Amount Date Check# Amount Date 2/01 1995 1,638.75 2/04 2006 700.01 2/01 1996 172.20 2/05 2007 61.85 672.75 2/06 1997 351.90 22.49 2/04 2/04 2008 2009 4,139.82 2/04 2/22 1998 1999 150.00 2/08 2010 760.38 2/04 2000 332.58 2/07 2011 13,672.60 84.00 2/04 2001 1,135.30 2/08 2013* 2/04 2002 6,125.36 2/14 2014 37.84 437.26 4 2/01 2003 1,377.75 2/13 2015 51.91 2/04 2004 146.99 2/19 2/19 2016 2017 878.37 2/06 2005 91.95 * Indicates skip in check. numbers Date 2/28/13 Page 2 Primary Account @XXXXXQANIW Enclosures 37 NORTHEAST PUBLIC FUNDS ACCT QXXXXX (Continued) Checks in Date serial order Check# Amount Date Check# Amount 2/19 2018 324.82 2/26 2025 320.77 2/19 2019 153.04 2/27 2027* 700.01 2/19 2020 377.24 2/26 2028 442.54 2/26 2021 865.26 2/26 2029 81,560.00 2/22 2022 657.48 2/27 2030 223.84 2/26 2024* 14.87 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 2/01 104,458.27 2/08 103,279.29 2/19 103,623.91 2/04 115,151.97 2/11 106,196.39 2/22 102,816.43 2/05 118,240.12 2/13 105,759.13 2/26 19,612.99 2/06 117,796.27 2/14 105,192.29 2/27 18,689.14 2/07 104,123.67 2/15 105,409.29 * ** E N D O F S T A T E M E N T Payment Summary Bank= 165opr AND mm /yy= 02/2013- 02/2013 AND All Checks =Yes AND Include Volds =All Checks check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa North 2010 bmmi -BMM Inc 02/05/2013 02/2013 760.38 165opr - Parkview Villa North 2011 chc - Common8ond Housing 02/05/2013 02/2013 13,672.60 165opr - Parkview Villa North 2012 dire - Direct Home Appliance Services 02/05/2013 02/2013 480.82 165opr - Parkview Villa North 2013 kenn - Kennedy & Graven, Chartered 02/05/2013 02/2013 84,00 165opr - Parkview Villa North 2014 Ibpm - LBP Mechanical, Inc 02/05/2013 02/2013 566.84 165opr - Parkview Villa North 2015 waic - WAI Continuum 02/05/2013 02/2013 437.26 165opr - Parkview Villa North 2016 adam - Adam's Pest Control, Inc. 02/12/2013 02/2013 51.91 165opr - Parkview Villa North 2017 bmmi - BMM Inc 02/12/2013 02/2013 878.37 165opr - Parkview Villa North 2018 kone - Kone Inc. 02/12/2013 02/2013 324.82 165opr - Parkview Villa North 2019 leve - Level One 02/12/2013 02/2013 153.04 165opr - Parkview Villa North 2020 shll - SHI International Corp 02/12/2013 02/2013 377.24 165opr- Parkview Villa North 2021 bmml - BMM Inc 02/20/2013 02/2013 - 865.26 165opr - Parkview Villa North 2022 chc - CommonBond Housing 02/20/2013 02/2013 657.48 165opr - Parkvlew Villa North 2023 dire - Direct Home Appliance Services 02/20/2013 02/2013 205.41 165opr - Parkvlew Villa North 2024 frat - Frattalone's /Metro Ace 02/20/2013 02/2013 14.87 165opr - Parkvlew Villa North 2025 home7 - HD Supply Facilities Maintenance, Ltd. 02/20/2013 02/2013 320.77 165opr - Parkvlew Villa North 2026 kocl - K.O. Cleaning and Restoration LLC 02/20/2013 02/2013 1,150.00 165opr - Parkview Villa North 2027 kone - Kone Inc. 02/20/2013 02/2013 700.01 165opr - Parkview Villa North 2028 Ibpm - LBP Mechanical, Inc 02/20/2013 02/2013 442.54 165opr - Parkview Villa North 2029 nass - Nasseff Mechanical Contractors 02/2012013 02/2013 81,560.00 165opr - Parkview Villa North 2030 Popp - Popp.com 02/20/2013 02/2013 223.84 165opr - Parkview Villa North 2031 slmp - Simplex Grinnell 02/20/2013 02/2013 640.66 165opr - Parkview Villa North 2032 gard1086 - Gardner Plumbing, LLC 02/26/2013 02/2013 135.00 165opr - Parkview Villa North 2033 home7 - HD Supply Facilities Maintenance, Ltd, 02/26/2013 02/2013 111.13 165opr - Parkvlew Villa North 2034 Ibpm - LBP Mechanical, Inc 02/26/2013 02/2013 265.00 165opr - Parkview Villa North 2035 xcel - Xcel Energy 02/26/2013 02/2013 1,635.46 106,714.71 Parkview Villa South Financial Statement Overview January 2013 Revenue: Occupancy for the month of January was 80% occupied Total Revenue was lower than budget amount (unfavorable) this is due to vacancy Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were over budget (unfavorable) and reflect advertising for apartment vacancy Other renting expenses were over budget (unfavorable) and reflect cost of processing background reports for applicants Office Supplies was under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing Electric was under budget (favorable) Gas was under budget (favorable) Water and Sewer were not billed in January Operatine and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Maintenance Supplies was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was over budget (unfavorable) and reflects the cost of contract Maintenance Heating and Cooling Maint and Repairs was under budget (favorable) Decorating Contract and Supplies costs were under budget (favorable) Furniture and Fixtures were under budget (favorable) am0 Oam°'p�m s =�.'. [fit (mil p .mn �, (nO ti N A N V�I < 0 z 0 'J m m Qo < m Rl 'O 0 0 i N 0 m C p iN m C 0 m p O-6 � sm��c -+'m m g3<C)8 m cm'c .mj (0l H m m i W W W m N J r r A J (p � M JO N N V W <O W J O V N m NOm W OOON)O V N000 � mOmO O X000 O A Oo000 �1000IJ (G O(D p O 000 (p O m W 0000 (0000 W �{ 1 I N N N V N W i m m m N N W V W W m J O V A W A N W N N W OD A W V V V W V W p -` N N O N N O Ul O m (DO J O W OJ 0100�m (JO N J W O Ol W W W 1 I ((�D� A J O W V A o m m N tO W P m wM l0 Ul 01 OO W 90 CV 0) O O O] IJ IJ i W O W W W W O N lO W W W J 0) O W m W , i O N O O O W O O N j W W O f p f 0 0 l0 O O W W O O N o W O O W O A O fll LI J m o m m 0 0 0 0 W GOO N i 3, N W W W W m V V A N O N N T O W v O V Np pn (NOopmO V NOOO j Om0 O OOO f0 O m m O O O O (O O O O W I m O W O O O O O N N N V N W 3 m m Ut N� � W O�INNN N N AW J W W A W r J V W J W N M N N m N N O W O m m W m +1 O W m W W W v m O W N O N J W m m W W O i I N N N l0 m A N N W pO W W J O ( p t 0 A (1 � A J O (D J W (0 A O m m Ny W W ID (ll m O O Gl W 01 O O CP N IJ A W W O m m W W W O N W m W W V m O W m W I O N O O O W O O N ! W (NO OP f O m 1 W (p O W W O p N O m o O O W ' O A O (11 41 J Ol (.J O V 8 O O N o w 0 0 0 iJ 3 W m N O O m m 0 0 (D O W O O O N i w m r W O N O N m N j N W m m m W p W W A [ O m m N m V � j O j O O y W m 0 A m (n J O A N IJ m Om m m000N A O m O •000 O 000 V W 1J O O o 0 O o O N o 0 0 0 0 o 0 o O O O O O � UI0000000(n OOOO i m m v, M m o�W Fa= =n �w N� 7 0 s N $ R R m A A 3 a a z 3 3 m m D m, m m v, M m o�W Fa= =n �w N� 7 0 s N m � W C ii ° f0 20 w3 d N 7 v i 0 5 d N 0 c p� O �*mC m w w m �' a m d vi o y W N° o a m 9 g g N o 3,m £�o�v. > > >.v C =�w0 `2 �'^��oo' C.IN 10 O N N C C w N Ual N p'j 7 1N m rR' 3 o mm m C n7 3 000 zv 0 j C 0 �T 0 < w v p vii H m a N w N ia a S O µ N O j ( C O 1J 0 O b O N 6 N � N Nw m@ d = 16 O 3 a no m c S A N �pT ffpp N UI W+V ITT V P W O O O N O A W G O AD) O O V �N W T V A W N N N 000 N0000O� 00 W A W 00 J (00 (000 10 pip W A (ll W W . p V N O O O A N j N (n N (n m TON A o m m W T O T O T O) J (O O O W N O T W W S O O O O O O W 40 0 0 Ol T [O -` T O:P V A O m W W UI W O O O J V N V V O N T N O J W W O O O O O O O O O A J V N 8m N T J T T W T 10 W T N T W A W VW NOUI T,T JANOO W (0N D) W T TA fPT jp 'T (p O O UN Ol T (O T N O A t0 CJ O T W O N J V N J N O N N T V V W T N O l4I OI O —0 0 0 N J W N + W O O J + O V T O N N O O T O A O N W O T W J O O V U O O N O O O T O V T T O O V w O W J wow 10 '— T O m O W (T GI Z A UI O O T O V O D7 10 O W- N O O O J O O V O O V p D O T V W O O D V T fJ 41 + 10 T N W T A N A T O O O T O A W O O A T O O J W T W W T J A T (ll N p W T 000 N 0000(p1100 W A W 00 V f000 (7000 p w j0� O O i P m O N N N N T T O N A MA N T W T A m A N i O T( P f0 J N O O p ..+ T A N W W W O (P OT9).-A (O O O W TOT W W O O O O O T OOOTT -+010 :P r A OQ w W N W O O O V V N V J o N Ut N O J W W 00000 O O O O O A J V N T T'w--A4 W A W W �-` W T N v T O O W T J T W TN(n W A T [O T N W OT WAW VW NOUN TWJANOOW(OWTWN WA TN O (p W IO 0 0 Ut T 01 (O T !J O A t0 W O T 41 (O W O O N V V N J W O N N T J V W T 10 O 4J T —0 O O m V W N + O N N N O O W O A O UI W O T W V O O O T O V N T O O V N W+ O W V J W O 41 (O N O J tom O LI V T O O N O O Z A TOO W O� O m w O N !J O O J O D O W J W O O T V OJ fJ -+ W —OM N W O T W O V O O V O O D W 01 � <O N� A T N N W W W N A W W W a 1 m 0 T (I N O O m W V T U- O C J O O T OW O O O O O l O U 1 O O N N A O O O O N O O m T A A O O N N O N O O O O O O O O W O O O W T T O O O O O O O O O aN 9 0 0 0 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O o O N O O O O O O O m � W C ii ° f0 20 w3 d N 7 v i 0 5 d N C a D W A N N � o w 0 1 m m o W z ?� M b m a � ?I -4. a po .N.. W l0 W 0 U N m < N a G) N U. N 3 N m j' N P j O w � O W O w W .+ W N � N O V W N N � O N N O 0 O O m o °w o w W N N N O V W N N � O A O N O w °o V O fT 0 0 w O O O O C G O O O O W N N OJ l0 cD N T T o V � W N N W f0 <D c�ii prn� m O V J O O O O O O O O o O 00 O 99 b bo 0 o O W N N N (O t0 u rnm o mm O V V W N N Ul f0 (O NpW O� O V J O 00 O O O AN N U n O O 0 0 °O O C O O O O � a '0 :2 a� 9 � O N N m 3 O PIP 00 N N W w W w W W Ww 0 0 O o O O o p0 p PO W w N (T Wm W w O O O O 0 0 O O a 0 O O 0 a b 0 w' m f0 O Vi m m � imp N 9 W A V m W OI O t00 Oi °w �IJ W rn V m W m (O .N, W N r N N m W v -1 �a 8 n cn 0 0 w_ y nn O C 0 W m r n� Q :3 0 N r rn ��Dw f(pO .G P VI UNI N � O W W C o wwa V W W d O NNI� M W � 8 0 O A A W W m r (�po A {II Ni� N Ww�W O W W C o ww4a d O N N'Fj W W m a 1p N V N a mm N N O O '`�p' V O OO�� 0 oola p OOH_ w Parkview Villa South (166) Balance January 2013 Books = Accrual Jan -13 Assets 20200 Accounts Payable 52,487.07 10100 Cash Balance 841.25 -20210 Accrued Other Expenses 186.00 10200 Petty Cash 7,957.88 22000 Deposits 713,970.36 10400 Investments 13,372.98 - 1,229.00 11300 Rent Receivable 143.00 12.00 11500 Accounts Receivable Fund Balance 767,884.43 Total Assets 734,604.24 Liabilities 20200 Accounts Payable 10,965.08 841.25 -20210 Accrued Other Expenses 7,957.88 22000 Deposits 13,372.98 22200 Accrued PILOT 22210 Revenue Collected in Advance 143.00 33,280.19 Total Liabilities Fund Balance 25300 Fund Balance 734,604.24 Total Fund Balance 734,604.24 Total Liabilities and Fund Balance 767,884.43 Parkview Villa -South (166) Income Statement For The Period Ending January 2013 Books = Accrual Month to Date 0/0 Revenue 27.79 0.11% 2010 -46340 Minor Equipment 36220 -46340 Gen, Government Rents 23,295.00 95.76% 36225 -46340 Nondwelling Rents 462.00 1.90% 36290 -46340 Other Miscellaneous Revenue 568.69 2.34% 167.09 0.69% - 0.00% 39120 -46340 Recovery Damage City 841.25 3.46% 372.00 24,325.69 100.000/0 Total Revenue Expenses Personal Services 1000 -46340 Accrued Salaries 3,932.00 16.16°/% Total Personal Services 3,932.00 16.16% Supplies 2000 -46340 Office Supplies 27.79 0.11% 2010 -46340 Minor Equipment 0.00 0.00% 2160 -46340 Maint. & Construct Materials 0.00 0.00 ° /u 2171 -46340 General Supplies 139.30 0.57% 2175 -46340 Food Supplies 0.00 0.00% 3210 -46340 Telephone & Telegraph 167.09 0.69% Total Supplies 160.28 0.66% Other Services & Charges 0.00 0.00°/% 3040 -46340 Legal Fees 3050 -46340 Expert & Professional Services 0.00 0.00% 3060 -46340 Management Services 2,126.00 8.74% 3100 -46340 Protective Services 214.83 0.88% 3210 -46340 Telephone & Telegraph 129.66 0.53% 3430 -46340 Advertising Other 160.28 0.66% 3600 -46340 Insurance & Bonds 841.25 3.46% 372.00 1.53% 3810 -46340 Electric - 865.60 -3.56% 3820 -46340 Water 1,338.69 5.50% 3830-46340 Gas 66.04 0.27% 3840 -46340 Refuse -24.00 - 0.10% 3850 -46340 Sewer 4000 -46340 Repair & Maint. Services 3,968.07 16.31% 4050 -46340 Garage, Labor Burd. 0.00 0.00% 0.00 0.00% 4100 -46340 Rents & Leases 4300 -46340 Miscellaneous Charges 6.20. 0.00% 1,028.69 4.23% 4315 -46340 PILOT 0.00 0.00% 4390 -46340 Taxes & Licenses 4500 -46340 Administrative Expenses 0.00 0.00% 4850 -46340 Interest on Deposits 6.46 0.03% Total Other Services & Charges 9,368.57 38.51% Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00 0.009 /0 13,467.66 55.36% 10,858.03 44.64% Parkview Villa South (166) Cash Flow Statement Period = January 2013 Revenue 36220 Gen. Government Rents 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Personnel Services 1000 Accrued Salaries Total Personnel Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Maint. & Construct Materials 2171 General Supplies 2175 Food Supplies Total Supplies other Services & Charges 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maint. Services 4050 Garage, Labor Burd. 4100 Rents & Licenses' 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits Total other Services & Charges Month to Date 23,295.00 462.00 568.69 0.00 24,325.69 3,932.00 3,932.00 27.79 0.00 0.00 139.30 0.00 167.09 0.00 2,126.00 214.83 129.66 160.28 841.25 372.00 (865.60) 1,338.69 66.04 (24.00) 3,968.07 0.00 0.00 6.20 1,028.69 0.00 0.00 6.46 9,368.57 Total Expenses 13,467.66 ParWew Villa South (166) Cash Flow Statement Period = January 2013 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 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 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 10,858.03 0.00 0.00 (239.00) (6.00) 0.00 (4,688.62) (12,486.40) (513.65) 1,028.69 15.00 (16,889.98) (6,031.95) Beg Cash End Cash Difference 58,519.02 52,487.07 (6,031.95) 186.00 186.00 713,970.36 713,970.36 - 772,675.38 766,643.43 (6,031.95) 2/15/2013 11:52 AM Parkview Villa South (166) General Ledger Period = ]an 2013 Page 1 of 2 Book = Accrual i Tree = ysl_W Prop, Property N m Date Period - ------ Parson/DescrIpten _ Control " Ref n Debit Credit Relate. - -6.,06- 0 00 Remarks 8 9177179 Balance - 3000 96340 A u a sdarl 0.00 l8 00 -18 00 Year end PR adjustment 166 P kview VIII South 1/1/2013 01/2013 Y end Mgmt Fee adjustment ] 156285 : Reversal of 153232 Villa South 1131/2013 01/2013 PostRecurrin9 Recurring ] 154209 RC 3,932.00 0 00 3,914 00 kgr eeJ CDC pct M9 [Po 166 Parkview G12 18.00 O.oO R/C CBC Mgmt Fee adj reversal RIC 166 Parkvlew V10a South 1/31/2013 01/2013 R/C CBC Mgmt Fee adj reversal 3- 156326 3,933,00 = Ending Balance = Ne[Lhen0e= 3,932.00 ,932.00 0.00 = Beginning Balance = 2000 -46340 Orim. Supplies 23.66 0.00 23.66 Jun -aug copler allocation 166 Parkvlew Villa South 12/31/2012 01/2013 Ciry of Columbia Heights(colu) P- 314992 3893 0,00 Accrue Col. Heights Copley All0c 166 Parkvlew Vde South 01/2013 Accrue Payables at 12/31 J- 156286 : Reversal of 153235 0100 23.66 166 Parkvlew Villa South .1/1/2013 1/15/2013 01/2013 Office Depot A.M8804) P- 317054 6.40878E +11 27.79 0.00 279 office supplies Net Chang -27 .79 27.79 Balance = 0.00 = Beginning Balance = 2010.46390 Minor Equipment 1,156.58 0.00 11156.58 carpet /vinyl unit 317 166 Parkvlew Villa South 12/2812012 01/2013 Hamernkk Decorating Center (hams P-319614 CG214072 At 12/31 166 parkview Villa South 111/2013 01/2013 Accrue Payables at 12/31 1- 156286 : Reversal of 153235 0.00 1,156.58 AccrueH Net Change =0.00 0.00 O Balance 0.00 = Beginning Balance = 21]1 -46390 General Supplies 15.50 0,00 15.50 paint reryding I66 Parkvlew Villa South 1/3/2013 01/2013 Fratlalone's /Metro Ace (fret) P- 315102 013716R 35,24 ..lot wmPlles 166 Parkvlew Vlpa South 1/412013 01/2013 Frattalone's /Metro Ace(frat) P- 315350 01373OR 19.74 0.00 166 Parkvlew Villa South 1/10/2013 01/2013 Buckeye Cleaning Centers (buck041 P- 316602 716028 77.37 0.00 112.61 cleaning supplies Parkview Villa South 1/23/2013 01/2013 Fraftalone's /Metro Ace(frat) P- 317822 013916R 26.69 RED 139.30 supplies = 166 Net Change= 139.30 lmt Balance = 0.00 = Beginning Balance = 3040 -46340 Legal Foes 5,239.4] 0.00 5,239.47 e Col expenses 166 Parkvlew Villa South 12/31/2012 01/2013 Ciry Of Columbia Heights(colu) P- 314992 3893 Accrue Allow 166 Parkvlew Villa South 1/t/2013 01/2013 Accrue Payables at 12131 1- 156286 :Reversal of 153235 0.011 5,239.4] 0.00 Endings Balance regal Net Change=0.00 O.OD = Beginning Balance = 3060 -46340 Management Services 0,00 18.00 080385 2012 m9mt fee adj 166 Parkvlew Villa South 1/31/2013 01/2013 CommonBond Housing (chc) P- 319216 01/12/2013- 01/31/2011 18.00 1 /13 1131/2013 01/2013 CommonDond Housing (cM1c) P- 319216 01/12/2013 - 01/31/201' 6,058.00 088 115 166 Parkview Villa South RC 0.00 3,932.00 2,0144.00 PR Mgml WC 166 Parkvlew Villa South 1/31/2013 01/2013 :PostRecurrin9 Recurring )- 154209 18.00 2,126.00 CBC M9ml Fee adJ reversal urat Fee 166 Parkvlew Villa South 1/3112013 01/2013 R/C CBC Mgmt Fee ad] reversal 1-156326 G32 0.00 6,00 = Ending = Net Change =2,126.00 2,,1 0.00 = Beginning Balance = 3100 -46340 Protective Services 47.43 0.00 47.43 labor sery chugs 12127/12 166 Parkview Villa South 12/28/2012 0112013 Trans -Alarm Inc(tran) P- 315185 SV131763 340.06 the repair 166 Parkvlew Villa South 12/2812012 0112013 Simplex Grinnell(slmp) P- 315974 68514550 292.63 0.00 642.31 panel sys to service 166 Parkvlew Villa South 12/31/2012 01/2013 Olsen Fire Protection, Inc.(olse) P-314868 55603 302.25 0.00 349.68 restore Accrue Simplex Grinnell- Fire P. 166 Parkvlew Villa South 1/1/2013 01/2013 Accrue Payables at 12/31 J- 156286 :Reversal of 153235 0.00 292.63 Alarm 12/31 Villa South 1/1/2013 01/2013 Accrue Payables at 12/31 1- 156286 :Reversal of 153235 0.00 47.43 302.25 Accrue Trans at 166 Parkvlew 3- 156286 : Reversal of 153235 0.00 302.25 0.00 Accrue Olsen Fire Protection all 166 Parkvlew Villa South 1/1/2013 01/2013 Accrue Payables at 12/31 0.00 65.41 alarm service 12/27/12 166 Parkvlew Villa South 1/9/2013 01/2013 Total Life Security LLC(OO1a321) P- 316319 1116 65.41 fault 166 Parkvlew, Villa South 1/9/2013 01/2013 Simplex Grinnell(slmp) P- 317428 68539166 149.42 0.00 OaEnd Net Change= 214.83 214.83 Balance 0.00 = Beginning Balance = 3210 -46340 Telephone &Telegraph 101.00 0.00 101.00 teisery 01/2013 166 Parkvlew Villa South 12/31/2012 01/2013 Pourcast (pope) P-316111 992077615 Internet /= 166 Parkvlew Villa South 1/2/2013 01/2013 CNet P- 316111 8772105050196183 01/ 28.66 0.00 Net Change=129,fi6 Chan,.= 129. 1129.66 Balance 0.00 = Beginning Balance = 3430 -46340 Advertising Other 95.28 0,00 95.28 Immediate openings ad 1/17/13 166 Parkvlew Villa South 1/20/2013 01/2013 Sun Newspaper(sunn) P- 317407 1418996 160.28 2011 amply 166 Parkvlew Villa South 1/31/2013 01/2013 Common0ond Housing (chc) P- 319216 01/12/2[)13- 01/31/201: 65.00 0.00 08776 Net Change= 160.28 ntaealanuca 0.00 = Beginning Balance = 3600 -46340 Insurance & Bonds 841.25 0.00 841,25 C of Columbia Heights Ins Accrl 166 Parkview, Villa South 1/31/2013 0112013 :PostRecurrin9 Recurring 1-154209 RC 841.25 = Ending Balance = Net CM1ange = 841.35 D.00 = Beginning Balance = 3810 -46340 Electric Accrue Payables at 12/31 J- 156286 :Reversal 3235 1,48).92 -1,472.92 Accrue Energy at 12/31 166 Parkvlew Villa South 1/112013 01/2013 9.92 1,859.92 0.00 4/1 lBalance 166 Parkvlew Villa South 1/11/2013 01/2013 XCel Ener9Y(xcel) P- 31]375 5150941553 01/11/13 150441553 0 373 00 Net Change= 372.00 = Ending = 0.00 = Beginning Balance = 3820 -46340 Water J- 156286 :Reversal of 153235 0.00 1,902.42 - 1,902.42 Accrue Center Point Energy at 166 Parvlew Villa South k 1/1/2013 01/2013 Accrue Payables at 12/31 ay 0.00 - 1,721.95 water 9 /27- 12/20/12 166 Parkvlew Villa South 1/9/2013 01/2013 City of Columbia Heights (colu) P-316726 31802700001 01/09113 30.47 9 /27- 12/27112 166 Parkvlew Villa South 119/2013 01/2013 City of Columbia Heights (cold) P- 316727 31802650001 01/09/13 1,101.26 0.00 - 770.69 water 12 /20112(credit) 166 Parkvlew Villa South 1/912013 01/2013 City of Columbia Heights (cola) P- 316958 31802600001 01/09/13 0.00 94.91 -865.60 water 9 /27- Net Change= -865.60 5.60 Page 1 of 2 Page 2 of 2 2/15/201311:52 AM Parkvlew VOIa South (166) General Ledger Period =Jan 2013 Book = Accrual; Tree = ysl tb Pro, Property Name Data Period P d/D ripN n Contra l Reference _ Beth Credit _.Brionce Remarks 0.00 = Beginning Balance = 3830 -46340 01/2013 Gas Accrue Payable, at 12/31 3- 156286 : Reversal of 153235 0.00 1,149.12 - 1,149.12 Accrue Col. Heights - Water At 166 Parkvlew Villa South 1/1/2013 0112013 CenlerPolat Energy (cent) P- 316575 55271324 01109113 2,487.81 0.00 1,338.69 gas 1215/12 - 1/2/13 166 Parkvlew Villa South 1/9/2013 1,338.69 = Ending Balance = Not Change= 1,338.69 0.06 = Beginning Balance = 4050 -46340 Relusa 66.04 0.00 66.04 recycle chrgs 166 Parkvlew Villa South 1/18/2013 01/2013 Green Lights Recycling Inc (greel((P- 318036 131305 Not Changa =66.04 66.04 = Ending Balance = 0.00 = Beginning Balance = 3850 -46340 Sewer 3- Reversal of 153235 0.00 581.76 - 581.76 Accrue Col. Heights - Water at 166 Parkvlew Villa South 1/1/2013 0112013 Accrue Payables at 12/31 156286 : sewer 9/27-12/22/12 166 Parkvlew Villa South 1/912013 01/2013 City of Columbia Heights (cola) P- 316727 3180265000101/09/13 557.76 too -24.00 Not Change= -24.00 .24.00 = Ending Balance = 0.00 = Beginning Balance = 4000 -46340 Repair & Mamt, Services 376.96 0.00 376.96 labor 12 /17- 12/21/12 32hrs 166 Parkvlew Villa South 12121/2012 01/2013 BMM Inc Hamm) P- 315367 25550 0.00 659.68 labor 12 /26- 12/28112 24hrs 166 Parkvlew Villa South 12/28/2012 01/2013 BMM Inc (brand) P- 315530 25571 282.72 166 Parkvlew Villa South 12128/2012 01/2013 Sherwin- Williams Co.(sher4110) P- 316457 96356 149.23 0.00 808.91 paint 166 Parkvlew Villa South 12/31/2012 01/2013 LOP Mechanical, In'(lema) P- 317432 W16085 317.50 0.00 1,126.41 heater repalr chrgs 166 Parkvlew Villa South 1/1/2013 01/2013 Accrue Payables at 12131 J- 156286 :Reversal of 153235 0.00 659.60 466.73 Accrue BMM Inc at 12/31 South 1/1/2013 01/2013 Kone Inc. (kne) P- 316329 221077649 314.50 0.00 781.23 elev malntcoverage 01/2013 166 Parkvlew Villa South 1/1/2013 01/2013 Accrue Payables at 12/31 )- 156286 :RevemplM 153235 0.00 317.50 463.73 Accrue LOP Mechanical at 12/31 166 Parkvlew Villa Accrue Payables at 12/31 3- 156286 : Reversal of 153235 0.00 149.23 314.50 Accrue Sherwin Williams At 12/-. 166 Parkvlew Villa South 1/1/2013 01/2013 0100 126.85 187.65 dryer repair floor 166 Parkvlew Villa South 1/2/2013 01/2013 Direct Home Appliance Services (air P- 314612 122012165- 314612 01/2013 BMM Inc (brand) P- 317009 25580 359.29 0.00 546.94 labor 12/31/12- 1/4/13 30.51brs 166 Parkvlew Villa South 1/3/2013 325.10 0.00 872.04 elec to, 5 /5- 12/18/12 #6101#5 166 Parkvlew Villa South 1/7/2013 01/2013 SHomann Construction dba SR4man P- 316652 579754 166 Parkvlew Villa South 1/9/2013 01/2013 KO. Cleaning and Restoration LLC I P- 317114 1315 250.00 0.00 1,122.04 paint unit 320 South 1/11/2013 01/2013 BMM Inc (brand) P- 317617 25605 376.96 0.00 1,499.00 labor 1 /7- 1/11/13 32hrs 166 Pareview Villa 1/15/2013 01/2013 High Profile Grounds Maintenance, I P- 317113 25429 158.10 0.00 1,657.10 plowing 0212013 166 Parkvlew Villa South South 1/18/2013 0112013 Hamernlck Decorating Cents,(hem, P- 317567 CG300326 1,871.52 0.00 3,528.62 carpet/vinyl /metal Install #220 166 Parkvlew Villa South 1/21/2013 01/2013 Empire Door& Glass Co. Perrot) P- 318109 0177618IN 439.45 0.00 3,968.07 door repair rings 166 Parkvlew Villa 3,968.07 = Ending Balance = Not Changa = 3,968.07 0.00 = Beginning Balance = 4300 -46340 Miscellaneous Charges 166 Parkvlew Villa South 12/24/2012 01/2013 Home Depot Credit Servlces (home: P- 315818 FCH004801564 6.20 0.00 6.20 late fee Net Change =6.20 6.20 = Ending Balance = 0.00 = Beginning Balance = 4315 -46340 PILOT 1,028.69 0.00 1,028.69 Anoka Cry Property Tax Accrual 166 Parkvlew Villa South 1/31/2013 01/2013 :PostRecurring Recurring 3- 154209 RC 1,028.69 = Ending Balance = Net Change= 1,028.69 0.00 = Beginning Balance = 4850 -46340 Interest on Deposits 6.46 0.00 6.46 Sec Oep interest accrual 166 Parkvlew Villa South 1/31/2013 01/2013 Sao Dep Interest accrual J- 155818 G31 Net Change =6.46 6.46 = Ending Balance = 30,967.07 17,499.41 Page 2 of 2 Parkview Villa South Bank Reconciliation Report 01/31/2013 5016464 Balance Per Bank Statement as of 01/3112013 outstanding Checks Check date Check number 01/15/2013 1672 01/24/2013 1674 01/2412013 1675 01/24/2013 1677 01124/2013 1678 01/24/2013 1679 01/24/2013 1680 01/24/2013 1681 01/24/2013 1682 01/29/2013 1683 01/2912013 1684 01/29/2013 1685 01/29/2013 1686 01/2912013 1687 01129/2013 1688 Less: Outstanding Checks Payee t0010379- Cassady bmmi - BMM Inc buck8411 - Buckeye Cleaning Centers high8236 - High Profile Grounds Maintenance, Inc. kocl - K.O. Cleaning and Restoration LLC Ibpm - LBP Mechanical, Inc simp - Simplex Grinnell sitz - Sitzmann Construction dba Sitzmann Elect Bunn - Sun Newspaper frat - Frattalone's /Metro Ace gree1004 - Green Lights Recycling Inc kone - Kone Inc. offi8804 - Office Depot olse - Olsen Fire Protection, Inc. xcel -Xcel Energy Reconciled Bank Balance Balance per GL as of 01/31/2013 Reconciled Balance Per G/L Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items : Cleared Checks 57,445.58 Amount 252.30 736.25 77.37 158.10 250.00 317.50 149.42 325.10 95.28 26.69 66.04 314.50 27.79 302.25 1,859.92 4,958.51 52,487.07 Date Tran # - Notes Amount 12/19/2012 1638 dete - Determan 210.00 01/0312013 1644 adam - Adam's Pest Control, Inc. 23.32 01/0312013 1645 bmmi - BMM Inc 801.04 01/0312013 1646 cent - CenterPoint Energy 1,388.20 01/03/2013 1647 chc- CommonBond Housing 6,358.67 01/0312013 1648 city4054 - City Wide Locksmithing, Inc. 16.54 02/1112013 52,487.07 52,487.07 0.00 Date Cleared 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 Parkview Villa South 02/11/2013 Bank Reconciliation Report 01/31/2013 5016464 Cleared Checks Date Tran # Notes Amount Date Cleared 01/03/2013 1649 comc3422- Comcast 28.19 01/31/2013 01/03/2013- 1650 dire - Direct Home Appliance Services 102.85 01/31/2013 01/03/2013 1651 frat - Frattalone's /Metro Ace 14.63 01/3112013. 01/03/2013 1652 kocl - K.O. Cleaning and Restoration LLC 746.75 01/31/2013 01/03/2013 1653 Ibpm- LBP Mechanical, Inc 3,530.57 01/31/2013 01/03/2013 1654 offi8804 -Office Depot 37.65 01/31/2013 01/03/2013 1655 Popp - Popp.com 101.09 01/3112013 01/03/2013 1656 sher4110- Sherwin-Williams Co. 149.23 01/31/2013 01/03/2013 1657 wilm - Wilmer 45.69 01/31/2013 01/0312013 1658 xcel - Xcel Energy 1,621.14 01/31/2013 01/0812013 1659 bmmi - BMM Inc - 659.68 01131/2013 01/08/2013 1660 colu - City of Columbia Heights 5,263.13 01/31/2013 01/08/2013 1661 frat - Frattalone's /Metro Ace 35.24 01/31/2013 01/08/2013 1662 hame - Hamernick Decorating Center 1,156.58 01/31/2013 01/0812013 1663 high8236 - High Profile Grounds Maintenance, Inc. 158.10 01/31/2013 01/0812013 1664 home7 - HD Supply Facilities Maintenance, Ltd. 97.23 01/31/2013 01/08/2013 1665 tran - Trans -Alarm Inc 47.43 01/31/2013 01115/2013 1666 comc3474- Comcast 28.66 01/31/2013 01/15/2013 1667 home32 - Home Depot Credit Services 6.20 01/31/2013 01/15/2013 1668 home7 - HD Supply Facilities Maintenance, Ltd, 3.72 01131/2013 01/15/2013 1669 Popp - Popp.com 101.00 01/31/2013 01/15/2013 1670 sher4110- Shemin-Williams Co. 149.23 01/31/2013 01/1512013 1671 simp- Simplex Grinnell 292.63 01/31/2013 01/15/2013 1673 tota321 -Total Life Security LLC 65.41 01131/2013 01/24/2013 1676 hame - Hamernick Decorating Center 1,871.52 01131/2013 Total Cleared Checks 25,111.32 Cleared Deposits Date Tran # Notes Amount Date Cleared 01/04/2013 354 - 22,070.00 01/31/2013 01/04/2013 354 646.00 01/31/2013 01/09/2013 355 754.19 01/31/2013 01/1712013 358 250.00 01131/2013 01/3112013 359 107.69 01/31/2013 Total Cleared Deposits 23,827.88 Date 1/31/13 Page 1 Primary Account @XXXXX Enclosures 35 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C 0 U N T S - - -- IF YOU GET FEDERAL BENEFIT PAYMENTS BY PAPER CHECK, YOU ARE REQUIRED BY LAW TO SWITCH TO ELECTRONIC PAYMENTS BY MARCH 1, 2013. TIME IS RUNNING OUT. SWITCH TO DIRECT DEPOSIT TODAY. VISIT ONE OF OUR BRANCHES FOR A PERSONAL BANKER TO ASSIST YOU, CALL (800)333 -1795 OR VISIT WWW.GODIRECT.ORG. NORTHEAST PUBLIC FUNDS ACCT @xxxxxaomw Number of Images Statement Dates 1/01/13 thru 35 1/31/13 Account Number Previous Balance 58,729.02 Days in the Statement Period 31 64,415 4 Deposits /Credits 23,827.88 Average Ledger Collected 62,593 31 Checks /Debits 25,111.32 Average Service Charge .00 Interest Paid .00 Ending Balance 57,445.58 _ Deposits and Credits Amount Date Description 1/04 DDA REGULAR DEPOSIT 22,716.00 1/09 DDA REGULAR DEPOSIT 754.19 250.00 1/17 DDA REGULAR DEPOSIT 107.69 1/31 DDA REGULAR DEPOSIT Checks in serial order Date Check# Amount Date Check# Amount 1/02 1638 210.00 1/09 1654 37.65 101.09 1/08 1644* 23.32 801.04 1/07 1/08 1655 1656 149.23 1/07 1645 1 /10 1646 1,388.20 1109 1657 45.69 1/04 1647 .6,358.67 1 /08 1658 1,621.14 659.68 1/07 1648 16.54 28.19 1/14 1/24 1659 1660 5,263.13 1/11 1649 1/16 1650 102.85 1/14 1661 35.24 1/09 1651 14.63 1 /11 1662 1,156.58 158.10 1/08 1652 746.75 1/15 1663 97.23 1/08 1653 3,530.57 1/15 1664 * Indicates skip in check numbers Date 1/31/13 Page 2 Primary Account @xxxxx@QwM 35 Enclosures NORTHEAST PUBLIC FUNDS ACCT @XXXXX (Continued) Checks in serial order Amount Date Check# Amount Date 1/14 Check# 1665 47.43 1/23 1670 149.23 292.63 1/23 1666 28.66 6.20 1/22 1/18 1671 1673* 65.41 1/22 1667 3.72 1/31 1676* 1,871.52 1/23 1/18 1668 1669 101.00 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date 1 /18 Balance 64,952.98 1/01 58,729.02 1 /10 1 /11 67,154.69 65,969.92 1/22 64,654.15 1/02 1/04 58,519.02 74,876.35 1/14 65,227.57 1/23 1/24 64,472.54 59,209.41 1/07 73,957.68 1/15 1/16 64,972.24 64,869.39 1/31 57,445.58 1/08 1/09 67,886.67 68,542.89 1/17 65,119.39 * ** E N D O F S T A T E M E N T Payment Summary Bank= 166opr AND mm /yy= 01/2013- 02/2013 AND All Checks =Yes AND Include Voids =All Checks Check Post Total Bank Check# Vendor _ Date Month Amount 166opr - Parkview Villa South 1644 adam - Adam's Pest Control, 01/03/2013 01/2013 23.32 166opr - Parkview Villa South 1645 bmml - BMM Inc 01/03/2013 01/2013 801.04 166opr - Parkview Villa South 1646 cent - CenterPoint Energy 01/03/2013 01/2013 1,388.20 166opr - Parkview Villa South 1647 chc - CommonBond Housing 01/03/2013 01/2013 6,358.67 166opr - Parkview Villa South 1648 city4054 - City Wide Locksmithing, Inc. 01/03/2013 01/2013 16.54 166opr - Parkview Villa South 1649 comc3422 - Comcast 01/03/2013 01/2013 28.19 166opr - Parkview Villa South 1650 dire - Direct Home Appliance Services 01/03/2013 01/2013 102.85 166opr - Parkview Villa South 1651 frat - Fratta lone's/ Metro Ace 01/03/2013 01/2013 14.63 166opr - Parkview Villa South 1652 kocl - K.O. Cleaning and Restoration LLC 01/03/2013 01/2013 746.75 166opr - Parkview Villa South 1653 Ibpm - LBP Mechanical, Inc 01/03/2013 01/2013 3,530.57 166opr - Parkvlew Villa South 1654 offi8804 - Office Depot 01/03/2013 01/2013 37.65 166opr- Parkview Villa South 1655 Popp - Popp.com 01/03/2013 01/2013 101.09 166opr - Parkvlew Villa South 1656 sher4110 - Sherwin- Williams Co. 01/03/2013 01/2013 149.23 166opr - Parkview Villa South 1657 wllm - Wilmar 01/03/2013 01/2013 45.69 166opr - Parkview Villa South 1658 xcel - Xcel Energy 01/03/2013 01/2013 1,621.14 166opr - Parkvlew Villa South 1659 bmmi - BMM Inc 01/08/2013 01/2013 659.68 166opr - Parkvlew Villa South 1660 coin - City of Columbia Heights 01/08/2013 01/2013 5,263.13 166opr - Parkvlew Villa South 1661 frat - Frattalone's /Metro Ace 01/08/2013 01/2013 35.24 166opr - Parkvlew Villa South 1662 home - Hamernick Decorating Center 01/08/2013 01/2013 1,156.58 166opr - Parkview Villa South 1663 high8236 - High Profile Grounds Maintenance, Ir 01/08/2013 01/2013 158.10 166opr - Parkvlew Villa South 1664 home7 - HD Supply Facilities Maintenance, Ltd. 01/08/2013 01/2013 97.23 166opr - Parkvlew Villa South 1665 tran - Trans -Alarm Inc 01/08/2013 01/2013 47.43 166opr - Parkview Villa South 1666 comc3474 - Comcast 01/15/2013 01/2013 28.66 166opr - Parkvlew Villa South 1667 home32 - Home Depot Credit Services 01/15/2013 01/2013 6.20 166opr - Parkvlew Villa South 1668 home7 - HD Supply Facilities Maintenance, Ltd. 01/15/2013 01/2013 3.72 166opr - Parkvlew Villa South 1669 Popp - Popp.com 01/15/2013 01/2013 101.00 166opr - Parkview Villa South 1670 sher4110 - Sherwin- Williams Co. 01/15/2013 01/2013 149.23 166opr - Parkvlew Villa South 1671 simp - Simplex Grinnell 01/15/2013 01/2013 292.63 166opr - Parkvlew Villa South 1672 10010379 - Cassady 01/15/2013 01/2013 252.30 166opr - Parkvlew Villa South 1673 tota321 - Total Life Security LLC 01/15/2013 01/2013 65.41 166opr - Parkvlew Villa South 1674 bmmi - BMM Inc 01/24/2013 01/2013 736.25 1660pr - Parkview Villa South 1675 buck8411 - Buckeye Cleaning Centers 01/24/2013 01/2013 77.37 166opr - Parkview Villa South 1676 hame - Hamernick Decorating Center 01/24/2013 01/2013 1,871.52 166opi - Parkview Villa South 1677 high8236 - High Profile Grounds Maintenance, Ir 01/24/2013 Oi1/2013 158110 166opr - Parkview Villa South 1678 kocl - K.O. Cleaning and Restoration LLC 01/2412013 01/2013 250.00 166opi - Parkview Villa South 1679 Ibpm - LBP Mechanical, Inc 01/24/2013 01/2013 317.50 166opr - Parkview Villa South 1680 simp - Simplex Grinnell 01/24/2013 01/2013 149.42 166opr - Parkview Villa South 1681 sitz - Sitzmann Construction dba Sitzmann Elect 01/24/2013 01/2013 325.10 166opi- Parkvlew Villa South 1662 sunn - Sun Newspaper 01/24/2013 01/2013 95.28 166opr - Parkvlew Villa South 1683 frat - Frattalone's /Metro Ace 01/29/2013 01/2013 26.69 166opr - Parkvlew Villa South 1684 gree1004 - Green Lights Recycling Inc 01/29/2013 01/2013 66.04 166opr - Parkvlew Villa South 1685 kone - Kone Inc. 01/29/2013 01/2013 314.50 166opr - Parkview Villa South 1686 offi8804 - Office Depot 01/29/2013 01/2013 27.79 166opr - Parkview Villa South 1687 olse - Olsen Fire Protection, Inc. 01/29/2013 01/2013 302.25 166opr - Parkview Villa South 1688 , xcel - Xcel Energy dl /29/2013 01/2013 1,859.92 166opr - Parkvlew Villa South 1689 bmmi - BMM Inc 02/05/2013 02/2013 341.62 166opr - Parkview Villa South 1690 cent - CenterPoint Energy 02/05/2013 02/2013 2,487.81 166opr - Parkview Villa South 1691 chc - CommonBond Housing 02/05/2013 02/2013 6,141.00 166opr - Parkview Villa South 1692 colu - City of Columbia Heights 02/05/2013 02/2013 1,594.58 166opr - Parkvlew Villa South 1693 empl - Empire Door & Glass Co. 02/05/2013 02/2013 439.45 166opr - Parkview Villa South 1694 adam - Adam's Pest Control, Inc. 02/12/2013 02/2013 23.32 166opr - Parkvlew Villa South 1695 bmmi - BMM Inc 02/12/2013 02/2013 394.63 1660pr - Parkview Villa South 1696 kone - Kone Inc. 02/12/2013 02/2013 145.94 166opr - Parkvlew Villa South 1697 leve - Level One 02/12/2013 02/2013 68.76 166opr - Parkview Villa South 1698 sunn - Sun Newspaper 02/12/2013 02/2013 95.28 41,592.22 Parkview. Villa North Financial Statement Overview January 2013 Revenue: Occupancy for the month of January 2013 was 99% occupied; Total Revenue for January was under budget (unfavorable). No grant income recognized Administrative Expenses: Administrative costs for the North were under budget (favorable). Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Computer Equipment, Supplies and Maintenance is slightly over budget (unfavorable) Telephone, Answering Service and Internet expenses was under budget (favorable) and reflects the cost of computer support service Utilities: Utilities Expenses are under budget (favorable), however, these are quarterly billings Fuel Oil was under Budget (favorable) Electric was under budget (favorable) Gas was under budget (favorable) Water and Sewer were not invoiced in January Operatine and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract is over budget (unfavorable) and reflects cost of office outlets added and GFI replacement in unit and contract maintenance service Garbage and Trash are under budget (favorable); however, this is a quarterly billing Security Contract is under budget (favorable). Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs is under budget (favorable) Decorating Contract and Supplies were under budget (favorable) Furniture and Fixtures was under budget (favorable) o Q m m o m W v a a � o m a �< LINO W D� (Zil Oori 0�$ m m pm m m m g' 0 w 3 »< 3�m�N.� m 5. 10 N 3 S 8 m <P.E] Dmumi -� °cm 71 m =m D m 3 lnF H my m m m 50 A El, m m o 0 1O o 0 J N N O N N N (O D O V w O N N N N 0 0 (m)1 (O N V O O Ol Om 00 O O O 10 000 O V 0000 N(00000 ( (O O f D O O O O O O O O O O O O O f T O O O O O 0 0 W 03 A W � W 0 W p A (ll N O N N N O W V W O 0 W 0 0 0 O N O w w w J N W W W O W W O .rt UI W O J W W O J O O O O. O O NN ism ,P A y N A SNAP (D W N N�� PP W O N N 0 f i OAO 0 IJ A 0 W W W 0 0 N A W W J N y J O m N W O J W W ONO 0 0 0 O A A O O O) V O O 0 0 P I O O •j� V I wNp N O N N(00 V W W 0(Vll 0 J O O O .L' O V 0 0 0 O N (O O O O O ( 0 0 0 0 0 t0 O f0 O O O O O O O O O O O O O O O N O O O O ? r O (O 10 P W W W O A 0 N O N N O W o J W O .4 W W •O 0 0 0 0 w w ONO V f W W W O U1 W O V W W O V O O o O O 3 ' N .Op O ..pp ppp111 0 0 m 0 10 A W W (l l J 0 V N 0 W W 0 N A W w V N V V V O (!1 W O V W W O N O O O O I 8A A 0 0 J O O W O N N O p— N p W 0 0 0 0 p N O O V O (O 0 0 '� . A N W N O O N N w O A W O O W 1 n { j N N N A W N W W N w W (Oil � I N f0 A A o- N (T O W W W 0 (ll O UN 0 W W O N t0 O W O (ll W W 0 N w !' N W 0 O UI N( p ONO UI O N O O O O O O O A O O O O A O N W O 0 N O O O O O 0 u 6 O O p O O O O O O O im 1 X R^ W � g c > ; G m m . NpN N m V O V 0 (0 01 O (T 10 N -• � 0 01 A b TOWN W O J w WO A W NOWi A W (W111 J N O W O m D O C O O A N N � V O V m o W 0 j r r O N O m N m (II W W fll O V W t0 u m a E m C o m W A O 1 J W O O W (O W A A? (D W W woo W O W W O N ? N W o Oi 0 "c 0 o -I O c W O W W N W o W W W W 0 = 01 w O O W W. O w) O W O W O A m w u N UI V N O m coo W O W O N N O W O) A O O O W P N V O n W O O� Ol A O O O f0 O A N A A O N V W 00. W O(O W AZO W W 000 PRO -w3 . m O A N O O O -+ Ow N D O W W O O N N p O P. no O 0 C gp OO_ C1 m 0 C O m aW j O 5, m m N �W � p � 10 o N W N W A W W A W W W V W O W W W N w J N (AO W m N N 3 N 0 W N O W V J W N OO W �IOOIO (!t O01�JU1 -�<l1 lJO O A O N N O O O O O w O W O A O O N m O O O W O m A p O A W iJ O O O W N O O O O O O O 0) O W O 0 a O O O O O O O O O O O O O O O O O O O O O O M-0000 0 0 0 0 O O w O O O O O O O O o O O O O O O O O O O O O O ut w O N N OW1 O fN11 J A W V N W lWi1 p?p D W O O O O O W O A O O W J O O N O O N O O ^W g 0 0 0 0 O � iW o W O O 0) 0 O W O � O O O O W O O J O O 4OOO C mom O O l N + � A ' A UO O O O O O W A w W 00 W UI W O O W O O) W O N 4-N W O O! (O O W W N W W W 10 O 6 W V O W o N W O J J W O O V V V N V O O N W O W W W W N N4 MA W W �iO Ol V N O W A t0 t0 N 01 10 J (O V f0 O N W V A N W V N O W O W A K N O W N V lJ OI W O O W W O W O P V -� W D7 N o Ol OI W O A 0I Pl O O W O N W O W W A O O o W A N V O G 41 t0 W O W A W N W W W ,W W W � A O O O (O O A N A A O N J W O O j W 0 0 0 -+ O f 0 N A Z O N W 0 0 o fj O t0 O V O O N O (O O W 01 o G. N Ooo V OBI J+�' 01 00 o O � 010010 -+0 A Vt W W O O O J O O W O o O O O W O A W N O 1O 0 O N O O m O O O O !J Ol O O O O O fD OJ O W (O + 0 0 0 0 0 0 4 -V 0 V w w 0 0 O O W o W W O V N L u m a E m C A O O W A O fT J W O O W (O W A A? (D W W woo W O W W O N ? N W o Oi O W O W W W t0 •O O W O .P V O W Ol O EP O] 0) W A D7 O 0] O W O N w O V V w W O O V J J N V O N W O W W N W o W W W W u m a E m pJ M q W (n N A W A W W N (O W O) N U� - V mom A (O t0 N � w f0 J m V O N W V A N W V O V O N N N O W O W A V N O w, N W W A Ol W W 0 01 w O O W W. O w) O W O W O A m w w ,W w W O W W W W UI V N O m coo W O W O N N O W O) A O O O W P N V O W N W W W w W O O� Ol A O O O f0 O A N A A O N V W 00. W O(O W AZO W W 000 PRO w O w O V o O W 000 •W •W O O A N O O O -+ Ow N D O W W O O N W O W O W O N N �G N W N W A W W A W W W V W O W W W N w J N (AO W W W N O W V J W N OO W �IOOIO (!t O01�JU1 -�<l1 lJO O A O N N O O O O O w O W O A O O N m O O O W O N A p O A W iJ O O O W N O O O O O O O 0) O W O "O O O O O O O O O O O O O O O O O O O O O O O O M-0000 0 0 0 0 O O w O O O O O O O O o O O O O O O O O O O O O O u m a E m / \ / 7 2 (z / ( ( ( o § / _ - �, # ( ! ( k 7 } \ / 0 bo , �.tl k ■ \ 2 /E( ,!a |±® )�7 §( )) (( )) \\ !/ a° 2!J J�\ � ! E §( §[ §( 0. / 4 a \ zo q� (/� §( \\ E0CD / \ CD 0 �!\/ / } J | / ( / 4 a \ zo q� (/� §( \\ E0CD / \ CD 0 �!\/ ^ 2 r m < \ � � \ $ ; , \\� \)\ � \\\} } \{ /)® \ \ z ^ 2 r m < \ � � \ $ ; , \\� \)\ � /)® z § \ : $ ;> e > 0 IL IL (0 0 00 }\\\) }\\\ 0 � \ , Parkview Villa -North (165) Balance Sheet January 2013 Books = Accrual Jan -13 Assets 10100 Cash Balance 90,527.27 - 664.00 10200 Petty Cash 891,214.11 10400 Investments 11300 Rent Receivable 1,208.66 11500 Accounts Receivable 868.12 13200 Due From Other Government Units 23,847.09 1,008,329.25 Total Assets Liabilities 20200 Accounts Payable 15,157.52 20210 Accrued Other Expenses 83,301.75 20220 Due to Resident Council 551.74 18,632.86 22000 Deposits 26,352.93 22200 Accrued PILOT 22210 Revenue Collected in Advance 338.00 144,334.80 Total Liabilities Fund Balance 25300 Fund Balance 863,994.45 863,994.45 Total Fund Balance Total Liabilities and Fund Balance 1,008,329.25 ParWew Villa -North (165) 145.45 0.47% Income Statement 0.00 0.00% For The Period Ending January 2013 0.00 0.00% Books = Accrual 339.83 1.11% Total Supplies Month to Date 1.580/0 Revenue 65.00 0.00% 33160 -46330 Federal Grant - 0.00% 36220 -46330 Gen. Government Rents 29,691.00 96.56% 36225 -46330 Nondwelling Rents 429.00 1.40% 36290 -46330 Other Miscellaneous Revenue 629.69 2.05% 39120 -46330 Recovery Damage City Property - 0.00% Total Revenue 30,749.69 100.000 /0 Expenses Personal Services 1000 -46330 Accrued Salaries 8,752.00 28.46% Total Personal Services 8,752.00 28.46% Supplies 2000 -46330 Office Supplies 145.45 0.47% 2010 -46330 Minor Equipment 0.00 0.00% 2160 -46330 Maint. & Construct Materials 0.00 0.00% 2171 -46330 General Supplies 339.83 1.11% Total Supplies 485.28 1.580/0 Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 3050 -46330 Expert and Professional Services - 0.00 0.00% 3060 -46330 Management Services 4,772.00 15.52% 3100 -46330 Protective Services 478.17 1.56% 3210 -46330 Telephone & Telegraph 288.60 0.94% 3430 -46330 Advertising Other 65.00 0.00% 3600 -46330 Insurance & Bonds 1,741.75 5.66% 3810 -46330 Electric 852.30 2.77% 3820 -46330 Water 0.00 0.00% 3830 -46330 Gas 69.08 0.22% 3840 -46330 Refuse 146.99 0,48% 3850 -46330 Sewer _, 0.00 0.00% 4000 -46330 Repair & Maint. Services 5,023.62 16.34% 4050 -46330 Garage, Labor Burd. 0.00 0.00% 4100 -46330 Rents & Leases 0.00 0.00% 4300 -46330 Miscellaneous Charges 0.00 0.00% 4315 -46330 PILOT 2,027.15 6.59% 4390 -46330 Taxes & Licenses 0.00 0.00% 4500 -46330 Administrative Expenses 0.00 0.00% 4850 -46330 Interest on Deposits 7.70 0.03% Total Other Services & Charges Capital Outlay 5120 -46330 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 15,472.36 50.32% 437.26 0.00% 437.26 1.42% 25,146.90 81.78 0/o' 5,602.79 18.22% Parkview Villa -North (165) Cash Flow Statement Period = January 2013 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 Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Maint. & Construct Materials 2171 General Supplies 2280 Vehicle Parts Total Supplies Other Services & Charges 3040 Legal Fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maim. Services 4050 Garage, Labor Burd. 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 Month to Date 0.00 29,691.00 429.00 629.69 30,749.69 8,752.00 8,752.00 145.45 0.00 0.00 339.83 0.00 485.28 0.00 0.00 4,772.00 478.17 288.60 65.00 1,741.75 852.30 0.00 69.08 146.99 0.00 5,023.62 0.00 0.00 0.00 2,027.15 0.00 0.00 7.70 437.26 15,909.62 25,146.90 5,602.79 Parkview Villa -North (165) Cash Flow Statement Period = January 2013 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 0.00 0.00 - 425.98 225.00 57,712.91 0.00 - 12,629.33 - 12,433.85 7.70 2,027.15 298.00 34,781.60 40,384.39 Beg Cash End Cash Difference 50,142.88 90,527.27 40,384.39 664.00 664.00 - 891,214.11 891,214.11 ° 942,020.99 982,405.38 40,384.39 2/15/2013 11:40 AM Parkview Villa -North (165) General Ledger Period = ]an 2013 mk = Accrual: Tree = vsl 1000 -46330 Accrued Salaries 0.00 = Beginning Balance = 165 Parkvlew Villa -North 1/31/2013 01/2013 :PostRecurring Monthly recur 3- 154208 RC 8,752.00 0.00 8,752.00 R/C CHC PR Mgmt Fee Net Change =81752.00 8,752.00 = Ending Balance = 2000 -46330 Office Supplies 0.00 = Beginning Balance = 165 Parkvlew Villa -North 12/31/2012 01/2013 City of Columbia Heights (col P- 314954 3892 48.05 0.00 48.05 Jun -aug copier allocation 165 Parkvlew Villa -North 1/1/2013 01/2013 Accrue December Invoices an 3- 156295 :Reversal of 153877 0.00 48.05 0.00 Accrue C of Col Heights - Copier. 165 Parkvlew Villa-North 1/15/2013 0112013 Office Depot (of08804) P- 317854 6.40878E F11 61.85 0.00 61.85 office supplies 165 Parkvlew Villa -North 1/31/2013 0112013 CommonBOnd Housing (chc) P- 319215 01/12/2013- 01/31/2013 1 1.10 0.00 62.95 087948 postage 1/13 165 Parkvlew Villa -North 1/31/2013 0112013 CommonBOnd Housing (chc) P- 319215 01/12/2013 - 01/31/2013 1 82.50 0.00 145.45 087911 comp supp 12/20/12 -1 /: Net Change= 145.45 145.45 = Ending Balance = 2171 -46330 General Supplies 0.00 = Beginning Balance = 165 Parkvlew VIIIa -North 1/10/2013 01/2013 Buckeye Cleaning Centers (Is P- 316602 716028 172.20 0.00 172.20 cleaning supplies 165 Parkvlew Villa-North 12/26/2012 01/2013 HO Supply FaCllltles Painters P- 315366 9119627274 22.49 0.00 194.69 maint supplies 165 Parkvlew Vil)a -North 1/1/2013 01/2013 Accrue December Invoices en]- 156295 :Reversal of 153877 0.00 22.49 172.20 Accrue HD Supply December Inv( 165 Parkvlew Villa -North 112/2013 01/2013 Frattalone's /Metro Ace(frat) P-315338 013704R 20.37 0.00 192.57 paint supplies 165 Parkview Villa -North 1/3/2013 01/2013 Frattalone's /Metro Ace (fint) P- 315102 013716R 34.50 0.00 227.07 paint recycling 165 Parkvlew Villa-North 1/4/2013 01/2013 HD Supply Facilities Malntena P- 316333 9119746754 91.95 0.00 319.02 maint supplies 165 Parkvlew Villa-North 1/7/2013 01/2013 Frat alone's /Metro Ace Umt) P- 315956 013762R 20.81 D.00 339.83 paint supplies Net Change = 339.83 339.83 = Ending Balance = 3060 -46330 Management Services 0.00 = Beginning Balance = 165 Parkvlew Villa -North 1/31/2013 01/2013 CommonBOnd Housing (chc) P- 319215 01/12/2013 - 01/31/2013 1 13,524.00' 0.00 13,524.00 088614 mgmt fees 1/13 165 Parkvlew Villa-North 1/31/2013 01/2013 :PostRecurring Monthly recur 3- 154208 RC 0.00 8,252.00 4,772.00 R/C CHIC PR Mgmt Fee Net Change = 4,772.00 4,772.00 = Ending Balance = 3100 -46330 Protective Services 0.00 = Beginning Balance = 165 Parkvlew Villa -North 12/28/2012 01/2013 Trans -Alarm Inc (tran) P- 315185 SV131763 105.52 0.00 105.57 labor sery chrge 12/27/12 155 Parkvlew Villa -North 12/28/2012 01/2013 Simplex Grinnell (simp) P- 315974 68514550 651.33 0.00 256.90 Ore panel repair 165 Parkvlew Villa -North 12/31/2012 01/2013 Olsen Fire Protection, Inc. (ol P- 314868 55603 672.75 0.00 1,429.65 restore sys to service 165 Parkvlew Villa-North 1 /1/2013 01/2013 Accrue December Invoices an 3- 156295 :Reversal of 153877 0.00 105.57 1,324.08 Accrue Trans -Alarm Decembe Im 165 Parkview Villa -North 1/1/2013 01/2013 Accrue December invoices an 3.156295 :Reversal of 153877 0.00 651.33 672.75 Accrue Simplex Grinnell Decembr 165 Parkvlew Villa-North 1/1/2013 01/2013 Accrue December Invoices on J- 156295 :Reversal of 153877 0.00 672.75 D.00 Accrue Olsen Fire Protection Invo 165 Parkvlew Villa-North 1/912013 01/2013 Total Life Security LLC (tota3 P- 316319 1116 145.59 0.00 145.59 alarm service 12127/12 165 Parkvlew Villa -North 1/9/2013 01/2013 Simplex Grinnell (simp) P- 317428 68539186 332.58 0.00 478.17 battery fault trouble Net Change = 478.17 478.17 = Ending Balance = 3210 -46330 Telephone & Telegraph 0.00 = Beginning Balance = 165 Parkvlew Villa -North 12/3112012 01/2013 Popp.com (popp) P- 315831 992027615 224.81 0.00 224.81 tel sery 01/2013 165 Parkvfew Villa -North 1/1/2013 01/2013 Level One (Ieve) P- 314860 0290356IN 110.90 0.00 335.71 maint /roll over plan 1 /2013 165 Parkview Villa -North 112/2013 01/2013 Comcast(comc3474) P- 316111877210505019618301 /0: 63.79 0.00 399.50 Internet 1 /11- 2/10/13 165 Parkvlew Villa -North 1/7/2013 0112013 Level One (Ieve) P- 315478 0290356IN- 315478 0.00 110.90 288.60 malnt/roll over plan 1/2013 Net Change= 288.60 288.60 = Ending Balance = 3430 -46330 Advertising Other 0.00 = Beginning Balance = 165 Parkview Villa -North 1/31/2013 01/2013 Common Bond Housing (chc) P- 319215 01/12/2013- 01/31/2013 1 65.00 0.00 65.00 082759 star tribune 2012 amply Net Change =65.00 65.00 = Ending Balance = 3600 -46330 Insurance & Bonds 0.00 = Beginning Balance = 165 Parkvlew Villa -North 1/31/2013 01/2013 :PostRecurring Monthly recur J- 154208 RC 1,741.75 0.00 1,741.75 C of Columbia Heights Ins Accrl Net Change =1,741.75 1,741.75 = Ending Balance = 3810 -46330 Electric 0.00 = Beginning Balance = 165 Parkvlew Villa-North 1/1/2013 01/2013 Accrue December Invoices an J- 156295 :Reversal of 153877 0.00 3,287.52 - 3,287.52 Accrue Xcel Energy Dec Invoice 165 Parkvlew Mlle -North 1/11/2013 01/2013 Xcel Energy (xcel) P- 317375 5150441553 01/11/13 4,139.82 0.00 852.30 elec 12/4/12 - 1/7/13 Net Change = 852.30 852.30 = Ending Balance = 3820.46330 Water 0.00 = Beginning Balance = 165 Parkvlew Villa-North 1/1/2013 01/2013 Accrue December invoicesen J- 156295 :Reversal of 153827 1,500.99 0.00 1,50D.99 Accrue C of Col Heights - Water 165 Parkvlew Villa-North 1/9/2013 01/2013 City of Columbia Heights (col P- 316728 3180250000101/09 /13 0.00 666.31 834.68 water 9/27- 12/20/12 165 Parkvlew Villa -North 1/9/2013 01/2013 City of Columbia Heights (col P- 316729 3180255000101/09/13 24.87 0.00 859.55 water 9/27. 12/20/12 165 Parkview Vllla -North 1/9/2013 01/2013 City of COlumbla Heights(col P- 3169653180245000101 /09/13 0.00 859.55 0.00 water 9 /27- 12/20/12 Net Change =0.00 0.00 = Ending Balance = 3830-46330 Gas Page 1 of 2 0,00 = Beginning Balance = 2/15/201311:40 AM Parkview Villa -North (165) General Ledger Period = )an 2013 Book = Accrual: Tree = Ysl_ Prof 165 rropertY' r Parkvlew Villa -North r.u, 1/1/2013 « ...n. 01/2013 • ____.,. __ .: Accrue December invoices en)- 156295 :Reversal of 153877 0.00 6,056.28 - 6,056.28 Accrue Center Points Energy Dec 165 Parkview Villa -North 1/8/2013 01/2013 CenterPolnt Energy (cent) P- 316568 55199657 01/08/13 6,056.28 0.00 0.00 gas 12/4/12- 1/4/13 165 Parkview Villa -North 1/8/2013 01/2013 CenterPolnt Energy (cent) P- 316568 55199652 01/08113 - 69.08 0.00 69.08 late fee 1/8/13 Net Change =69.08 69.08 = Ending Balance = 0.00 = Beginning Balance =- 3840 -46330 Refuse 165 Parkvlew Villa -North 111/2013 01/2013 Accrue December invoices on 1- 156295 :Reversal of 153877 0.00 3,516.34 - 3,518.34 Accrue C of Cut Heights- Refuse 165 Parkview Villa -North 1/9/2013 01/2013 City of Columbia Heights (col P- 316965 31SD2450001 01/09/13 3,518.34 0.00 0.00 garbage 9/22- 12/20/12 165 Parkview Villa -North 1/18/2013 01/2013 Green Lights Recycling Inc to P- 318036 131305 146.99 0.00 146.99 recycle chrgs Net Change= 146.99 146.99 = Ending Balance = 0.00 = Beginning Balance = 3850 -46330 Sewer 165 Parkview Villa -North 1/1/2013 01/2013 Accrue December Invoices an 3- 156295 :Reversal of 153827 639.60 0.00 639.60 Accrue C of Col Heights - Sewer 165 Parkvlew Villa -North 1/9/2013 01/2013 City of Columbia Heights (col P- 316728 3180250000101/09/13 0.00 328,27 311.33 sewer 9/27- 12120/12 165 Parkview Villa -North 1/9/2013 01/2013 City of Columbia Heights (cal P- 316965 31802450001 01/09/13 0.00 .311.33 0.00 sewer 9/27- 12/20/12 Net Change =0.00 0.00 = Ending Balance = 4000 -46330 Repair & Maint. Services 0.00 = Beginning Balance = 165 Parkview Villa -North 12120/2012 01/2013 Direct Home Appliance Servic P- 315449 122012165 126.85 0.00 126.85 dryer repair chrgs -0r 2 165 Parkview Villa -North 12/21/2012 01/2013 BMM Inc (bmml) P- 315367 25550 839.04 0.00 965.89 labor 12/17- 12/21/12 321hrs 165 Parkview Villa -North 12/28/2012 01/2013 BMM Inc harem) P- 315530 25521 629.28 0.00 1,595.17 labor 12 /26- 12/28/12 24hrs 165 Parkview Villa -North 12/28/2012 01/2013 Sherwin - Williams Co.(sher4: P- 316456 96463 79.89 0.00 1,675.06 paint 165 Parkvlew Villa -North 12/3112012 01/2013 LBP Mechanical, Inc (Ibpm) P- 315099 W18032 265.00 0.00 1,940.06 boiler repair 165 Parkview Villa-North 1/1/2013 01/2013 Accrue December Invoices an J- 156295 :Reversal of 153877 0100 126.85 1,813.21 Accrue Direct Home Appliance Dr 165 Parkvlew Villa -North 1/1/2013 01/2013 Accrue December Invoices an 3- 156295 :Reversal of 153877 0.00 1,468.32 344.89 Accrue BMM Inc December Involc 165 Parkview Vllla -North 1/1/2013 01/2013 Rome Inc.(kone) P- 316329 221072649 700.01 0.00 1,044.90 elev malnt coverage 01/2013 165 Parkview Villa -North 1/1/2013 0112013 Accrue December invoices an 1- 156295 : Reversal of 153877 0.00 265.00 729.90 Accrue _BP Mechanical invoices 165 Parkview Villa -North 1/1/2013 01/2013 Accrue December Invoices an J- 156295 :Reversal of 153877 0.00 79.89 700.01 Accrue Sherwin Williams Decemt 165 Parkview Vllia -North 1/3/2013 01/2013 BMM Inc(bmml) P- 317009 25580 799.71 0.00 1,499.72 labor 12/31/12- 1/4/13 30.5hrs 165 Parkview Villa -North 1/7/2013 01/2013 Sitzmann Construction dba S P- 316652 579254 1,135.30 0.00 2,635.02 electrical repairs 11126/12 165 Parkview Villa -North 1/9/2013 0112013 K.O. Cleaning and Restoratim P- 317115 1316 150.00 0.00 2,785.02 paint telling In library 165 Parkvlew VIIIa -North 1/1112013 01/2013 BMM Inc(bmml) P- 317617 25605 839.04 0.00 3,624.06 labor 1 /7- 1/11/13 32hrs 165 Parkview Villa -North 1/1512013 0112013 High Profile Grounds Malnten P- 312113 25429 351.90 0.00 3,97596 plowing 0212013 165 Parkview Villa -North 1/17/2013 01/2013 Direct Home Appliance Servic P- 318307 11713165 240.41 0.00 4,216.37 dryer repair 165 Parkvlew Villa -North 1/12/2013 01/2013 Direct Home Appliance Servic P- 318308 011713165. 240.41 0.00 4,456.78 dryer repair 165 Parkvlew Villa -North 1/25/2013 01/2013 LBP Mechanical, Inc (Ibpm) P- 318140 W18119 566.84 0.00 5,023.62 heating repairs apt 810 Net Change = 5,023.62 5,023.62 = Ending Balance = 4300 -46330 Miscellaneous Charges 0.00 = Beginning Balance = 165 Parkview Villa -North 12/24/2012 01/2013 Home Depot Credit Services i P- 315818 FCH004801564 13.80 0.00 13.80 late fee 165 Parkvlew Villa -North 1/1/2013 01/2013 Accrue December invoices an 3- 156295 : Reversal of 153872 0.00 13.80 0.00 Accrue Home Depot Credit Decer Net Change =0.00 0.00 = Ending Balance = 0.00 = Beginning Balance = 4315 -46330 PILOT 165 Parkvlew Villa -North 1/31/2013 01/2013 :Pm,tRecurring Monthly recur 1- 154208 RC 2,027.15 0.00 2,027.15 Anoka Cy Property Tax Accrual Net Change = 2,027.15 2,022.15 = Ending Balance = 4850 -46330 Interest on Deposits - 0.00 = Beginning Balance = 165 Parkvlew Villa -North 1/3112013 01/2013 Sec Dep interest accrual J- 155813 G)1 2.20 0.00 7.70 Sec Dep Interest accrual Net Change =7.70 7.70 = Ending Balance = 5120.46330 Building Is Improvements 0.00 = Beginning Balance = 165 Parkvlew Villa -North 1/21/2013 0112013 WAI Continuum (wale) P- 318322 11447 432.26 0.00 432.26 archlect Svcs through 1/20/13 Net Change= 437.26 437.26 = Ending Balance = 52,491.45 27,344.55 Page 2 of 2 Parkview Villa North Bank Reconciliation Report 01/31/2013 5016456 Balance Per Bank Statement as of 01/31/2013 Outstanding Checks Check date Check number Payee 01/24/2013 1995 bmmi - BMM Inc 01/24/2013 1996 buck841I - Buckeye Cleaning Centers 01/24/2013 1997 high8236 - High Profile Grounds Maintenance, Inc. 01/24/2013 1998 home7 - HD Supply Facilities Maintenance, Ltd. 01/24/2013 .1999 kocl - K.O. Cleaning and Restoration LLC 01/24/2013 2000 simp- Simplex Grinnell 01/24/2013 2001 sitz - Sitzmann Construction dba Sitzmann Elect 01/29/2013 2002 cent - CenterPoint Energy 01/29/2013 2003 colu - City of Columbia Heights 01/29/2013 2004 gree1004 - Green Lights Recycling Inc 01/29/2013 2005 home7 - HD Supply Facilities Maintenance, Ltd. 01/29/2013 2006 kone - Kone Inc. 01/29/2013 2007 offi8804 -Office Depot 01/2912013 2008 olse - Olsen Fire Protection, Inc. 01/29/2013 2009 xcel - Xcel Energy Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 0113112013 Reconciled Balance Per G/L Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items : Cleared Checks 02/11/2013 107,646.97 Amount 1,638.75 172.20 351.90 22.49 150.00 332.58 1,135.30 6,125.36 1,377.75 146.99 91.95 700.01 61.85 672.75 4,139.82 17,119.70 90,527.27 90,527.27 90,527.27 0.00 Date Tran# Notes Amount Date Cleared 12/12/2012 1951 t0004048- Ganyaw 102.92 01/31/2013 12/19/2012 1954 dete - Determan 210.00 01/31/2013 01/03/2013 1963 adam - Adam's Pest Control, Inc. 51.91 01/31/2013 01/03/2013 1964 bmmi - BMM Inc 1,820.96 01/31/2013 01/03/2013 1965 cent - CenterPoint Energy 4,605.16 01/31/2013 01/03/2013 1966 chc- CommonBond Housing 13,883.16 01/3112013 Parkview Villa North 02/11/2013 Total Cleared Deposits 30,846.71 Cleared Other Items Date Tran # Notes Amount Date Cleared 01/07/2013 JE 155812 ELoccs Capitla Fund Program receipt 57,712.91 01/31/2013 Total Cleared Other Items 57,712.91 Bank Reconciliation Report 01/31/2013 5016456 Cleared Checks Date Tran # Notes Amount Date Cleared 01/03/2013 1967 city4054- City Wide Locksmithing, Inc. 36.82 01/31/2013 01/03/2013 1968 comc3422- Comcast 62.74 01/31/2013 01/03/2013 1969 drai7740 -Drain King, Inc. 135.00 01/31/2013 01/0312013 1970 frat - Frattalone's /Metro Ace 49.64 01/31/2013 01/03/2013 1971 kern - Kennedy & Graven, Chartered 189.00 01/31/2013 01/03/2013 1972 kocl - K.O. Cleaning and Restoration LLC 783.25 01/31/2013 01/03/2013 1973 Ibpm - LBP Mechanical, Inc 1,085.01 01/31/2013 01/03/2013 1974 off 18804 - Office Depot 83.80 01131/2013 01/03/2013 1975 Popp - Popp.com 225.00 01/31/2013 01/03/2013 1976 sher4110- Shemin-Williams Co. 290.39 01/31/2013 01/03/2013 1977 wilm - Wilmer 101.69 01/31/2013 01/03/2013 1978 xcel- Xcel Energy 3,608.35 01/31/2013 01/08/2013 1979 bmmi - BMM Inc 1,468.32 01/31/2013 01/08/2013 1980 colu - City of Columbia Heights 48.05 01/31/2013 01/08/2013 1981 dire - Direct Home Appliance Services 126.85 01131/2013 0110812013 1982 frat - Frattalone's /Metro Ace 54.87 01/31/2013 01108/2013 1983 high8236- High Profile Grounds Maintenance, Inc. 351.90 01/3112013 01/08/2013 1984 home? - HD Supply Facilities Maintenance, Ltd. 216.43 01/31/2013 01/08/2013 1985 Ibpm - LBP Mechanical, Inc 265.00 01/31/2013 01/08/2013 1986 tran - Trans -Alarm Inc 105.57 01/31/2013 01/15/2013 1987 comc3474- Comcast 63.79 01/31/2013 01/15/2013 1988 frat - Fraltalone's /Metro Ace 20.81 01/31/2013 01/1512013 1989 home32 - Home Depot Credit Services 13.80 01/31/2013 01/15/2013 1990 home? - HD Supply Facilities Maintenance, Ltd. 206.64 01/31/2013 01/15/2013 1991 Popp - Popp.com 224.81 01/31/2013 01/15/2013 1992 sher4110- Sherwin-Williams Co. 79.89 01/31/2013 01115/2013 1993 simp- Simplex Grinnell 651.33 01/31/2013 01/15/2013 1994 tota321 -Total Life Security LLC 145.59 01/31/2013 Total Cleared Checks 31,368.45 Cleared Deposits Date Tran # Notes Amount Date Cleared 01/04/2013 465 - 25,467.00 01/31/2013 01/04/2013 465 640.00 01/31/2013 01/0912013 466 3,941.02 01/31/2013 01/17/2013 467 691.00 01/31/2013 01/31/2013 468 107.69 01/31/2013 Total Cleared Deposits 30,846.71 Cleared Other Items Date Tran # Notes Amount Date Cleared 01/07/2013 JE 155812 ELoccs Capitla Fund Program receipt 57,712.91 01/31/2013 Total Cleared Other Items 57,712.91 Date 1/31/13 Page 1 Primary Account @XXXXX Enclosures 38 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C O U N T S - - -- IF YOU GET FEDERAL BENEFIT PAYMENTS BY PAPER CHECK, YOU ARE REQUIRED BY LAW TO SWITCH TO ELECTRONIC PAYMENTS BY MARCH 1, 2013. TIME IS RUNNING OUT. SWITCH TO DIRECT DEPOSIT TODAY. VISIT ONE OF OUR BRANCHES FOR A PERSONAL BANKER TO ASSIST YOU, CALL (800)333 -1795 OR VISIT WWW.GODIRECT.ORG. NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXXONAW Previous Balance 50,455.80 5 Deposits /Credits 88,559.62 34 Checks /Debits 31,368.45 Service Charge .00 Interest Paid .00 Ending Balance 107,646.97 Number of Images 38 Statement Dates 1/01/13 thru 1/31/13 Days in the Statement Period 31 Average Ledger 99,085 Average Collected 96,718 Deposits and Credits Amount Date Date Description Amount 1951 1/04 DDA REGULAR'DEPOSIT 26,107.00 62.74 1/07 MISC PAY HUD TREAS 310 57,712.91 CR 1969 9101036151 01/07/13 1 /08 1963* 51.91 ID #- 411269646860103 1970 49.64 1/07 TRACE #- 101036150382421 1,820.96 1/07 1/09 DDA REGULAR DEPOSIT 3,941.02 1965 1/17 DDA REGULAR DEPOSIT 691.00 783.25 1/31 DDA REGULAR DEPOSIT 107.69 1/08 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Checks Date in serial order Check# Amount Date Check# Amount 1109 1951 102.92 1 /11 1968 62.74 1/02 1954* 210.00 1/07 1969 135.00 1 /08 1963* 51.91 1/09 1970 49.64 1/07 1964 1,820.96 1/07 1971 189.00 1 /10 1965 4,605.16 1/08 1972 783.25 1/04 1966 13,883.16 1/08 1973 1,085.01 1/07 1967 36.82 1/09 1974 83.80 * Indicates skip in check numbers Date 1/31/13 Page 2 Primary Account @XXXX Enclosures 38 NORTHEAST PUBLIC FUNDS ACCT @XXXXX (Continued) Checks Date in serial order Check# Amount Date Check# Amount 1/07 1975 225.00 1 /11 1985 265.00 1/08 1976 290.39 1/14 1986 105.57 1/09 1977 101.69 1/23 1987 63.79 1/08 1978 3,608.35 1/22 1988 20.81 1/14 1979 1,468.32 1/22 1989 13.80 1/24 1980 48.05 1/23 1990 206.64 1/16 1981 126.85 1/18 1991 224.81 1/14 1982 54.87 1/23 1992 79.89 1/15 1983 351.90 1/22 1993 651.33 1/15 1984 216.43 1 /18 1994 145.59 * Indicates skip in check numbers Daily Date Balance Section Balance Date Balance Date Balance 1/01 50,455.80 1 /10 110,954.67 1/18 108,623.59 1/02 50,245.80 1/11 110,626.93 1/22 107,937.65 1/04 62,469.64 1/14 108,998.17 1/23 107,587.33 1/07 117,775.77 1/15 108,429.84 1/24 107,539.28 1/08 111,956.86 1/16 108,302.99 1/31 107,646.97 1/09 115,559.83 1/17 108,993.99 * ** E N D O F S T A T E M E N T Payment Summary Bank= 165opr AND mm /yy= 01/2013- 02/2013 AND All Checks =Yes AND Include Volds =All Checks Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa North 1963 adam - Adam's Pest Control, lnc. 01/03/2013 01/2013 51.91 165opr - Parkview Villa North 1964 bmml - BMM Inc 01/03/2013 01/2013 1,820.96 165opr - Parkview Villa North 1965 cent - CenterPOlnt Energy 01/03/2013 01/2013 4,605.16 165opr - Parkvlew Villa North 1966 chc - CommonBond Housing 01/0312013 01/2013 13,883.16 165opr - Parkvlew Villa North 1967 city4054 - City Wide Locksmithing, Inc. 01/03/2013 01/2013 36.82 165opr - Parkvlew Villa North 1968 comc3422 - Comcast 01/03/2013 01/2013 62.74 165opr - Parkvlew Villa North 1969 drai7740 - Drain King, Inc. 01/03/2013 01/2013 135.00 165opr - Parkvlew Villa North 1970 frat - Frattalone's /Metro Ace 01/03/2013 01/2013 49.64 1650pr - Parkview Villa North 1971 kern - Kennedy & Graven, Chartered 01/03/2013 01/2013 189.00 165opr - Parkvlew Villa North 1972 kocl - K.O. Cleaning and Restoration LLC 01/03/2013 01/2013 783.25 165opr .. Parkview Villa North 1973 Ibpm - LBP Mechanical, Inc 01/03/2013 01/2013 1,085.01 165opr - Parkview Villa North 1974 off18804 .. Office Depot 01/03/2013 01/2013 83.80 165opr - Parkview Villa North 1975 Popp - Popp.com 01/03/2013 01/2013 225.00 165opr - Parkview Villa North 1976 sher4110 - Sherwin - Williams Co. 01/03/2013 01/2013 290.39 165opr - Parkview Villa North 1977 wllm - Wilmar 01/03/2013 01/2013 101.69 165opr - Parkview Villa North 1978 xcel - Xcel Energy 01/03/2013 01/2013 3,608.35 1650pr - Parkview Villa North 1979 bmmi - BMM Inc 01/08/2013 01/2013 1,468.32 1650pr - Parkview Villa North 1980 colu - City of Columbia Heights 01/08/2013 01/2013 48.05 1650pr - Parkview Villa North 1981 dire - Direct Home Appliance Services 01/0812013 01/2013 126.85 1650pr - Parkview Villa North 1982 frat - Frattalone's /Metro Ace 01/08/2013 01/2013 54.87 165opr - Parkview Villa North 1983 high8236 - High Profile Grounds Maintenance, If 01/08/2013 01/2013 351.90 165opr - Parkview Villa North 1984 home7 - HD Supply Facilities Maintenance, Ltd. 01/08/2013 01/2013 216.43 165opr - Parkview Villa North 1985 Ibpm - LBP Mechanical, Inc 01/08/2013 01/2013 265.00 165opr - Parkvlew Villa North 1986 Iran - Trans - Alarm -Inc 01/08/2013 01/2013 105.57 165opr - Parkvlew Villa North 1987 comc3474 - Comcast .01/15/2013 01/2013 63.79 165opr - Parkview Villa North 1988 frat - Frattalone's /Metro Ace 01/15/2013 01/2013 20.81 165opr - Parkview Villa North 1989 home32 - Home Depot Credit Services 01/15/2013 01/2013 13.80 165opr - Parkview Villa North 1990 home7 - FID Supply Facilities Maintenance, Ltd. 01/15/2013 01/2013 206.64 165opr - Parkvlew Villa North 1991 Popp - Popp.com 01/15/2013 01/2013 224.81 165opr - Parkview Villa North 1992 sher4110 - Sherwin - Williams Co. 01/15/2013 01/2013 79.89 165opr - Parkvlew Villa North 1993 simp - Simplex Grinnell 01/15/2013 01/2013 651.33 165opr - Parkvlew Villa North 1994 tota321 - Total Life Security LLC 01/15/2013 01/2013 145.59 165opr - Parkvlew Villa North - 1995 bmmi - BMM Inc - 01/24/2013 01/2013 1,638.75 165opr - Parkvlew Villa North 1996 buck8411 - Buckeye Cleaning Centers 01/24/2013 01/2013 172.20 165opr - Parkview Villa North 1997 high8236 - High Profile Grounds Maintenance, If 01/24/2013 01/2013 351.90 165opr - Parkview Villa North 1998 home7 - HD Supply Facilities Maintenance, Ltd. 01/24/2013 01/2013 22.49 165opr - Parkview Villa North 1999 kocl - K.O. Cleaning and Restoration LLC 01/24/2013 01/2013 150.00 165opr - Parkview Villa North 2000 simp - Simplex Grinnell 01/24/2013 01/2013 332.58 1650pr - Parkview Villa North 2001 -sitz - Sitzmann Construction dba Sitzmann Elect 01/24/2013 01/2013 1,135.30 165opr - Parkview Villa North 2002 cent - CenterPoint Energy 01/29/2013 01/2013 6,125.36 165opr - Parkview Villa North 2003 colu - City of Columbia Heights 01/29/2013 01/2013 1,377.75 1650pr - Parkvlew Villa North 2004 gree1004 - Green Lights Recycling Inc 01/29/2013 01/2013 146.99 165opr - Parkview Villa North 2005 home7 - HD Supply Facilities Maintenance, Ltd. 01/.29/2013 01/2013 91.95 1650pr - Parkvlew Villa North 2006 kone - Kone Inc. 01/29/2013 01/2013 700.01 165opr - Parkview Villa North 2007 offi8804 - Office Depot 01/29/2013 01/2013 61.85 165opi - Parkview Villa North 2008 olse - Olsen Fire Protection, Inc. 01/29/2013 01/2013 672.75 165opr - Parkview Villa North 2009 xcel - Xcel Energy 01/29/2013 01/2013 4,139.82 165opr - Parkview Villa North 2010 bmmi - BMM Inc 02/05/2013 02/2013 760.38 165opr - Parkview Villa North 2011 chc - CommonBond Housing 02105/2013 02/2013 13,672.60 165opr - Parkview Villa North 2012 dire - Direct Home Appliance Services 02/05/2013 02/2013 480.82 165opr - Parkview Villa North 2013 kern - Kennedy & Graven, Chartered 02/05/2013 02/2013 84.00 165opr - Parkview Villa North 2014 Ibpm - LBP Mechanical, Inc 02/05/2013 02/2013 566.84 165opr - Parkview Villa North 2015 waic - WAI Continuum 02/05/2013 02/2013 437.26 165opr - Parkview Villa North 2016 adam - Adam's Pest Control, Inc. 02/12/2013 02/2013 51.91 165opr - Parkview Villa North 2017 bmml - BMM Inc 02/12/2013 02/2013 878.37 165opr - Parkview Villa North 2018 kone - Kone Inc. 02/12/2013 02/2013 324.82 165opr - Parkview Villa North 2019 leve - Level One 02/12/2013 02/2013 153.04 165opr - Parkview Villa North 2020 shii - SHI International Corp 02/12/2013 02/2013 377.24 65,962.51 HOUSING AND REDEVELOPMENT AUTHORITY LETTER MEETING OF: April 23, 2013 AGENDA SECTION: CONSENT ORIGINATING DEPT: CITY MANAGER NO: 6 FINANCE APPROVAL ITEM: ADOPT RESOLUTION 2013 -5, BEING A BY: JOSEPH KLOIBER RESOLUTION APPROVING AND SPECIFYING THE TERMS OF AN INTER- DATE: April 4, 2013 FUND LOAN TO THE CITY OF COLUMBIA HEIGHTS Background Inter -fund borrowing is a routine method of managing cashflow and maximizing interest income. By about May of each year, the City has usually spent down its short -term cash from the past December's tax collections. The City then sells some of its medium or longer term investments to maintain sufficient cashflow until it receives the June tax collections. This typically results in the City earning less on the investments sold early, compared to what these investments would pay if held to full maturity. Currently, the HRH's Parkview Villa North Fund 203 has a significant cash balance of approximately $900,000 held in a savings account that is only paying about 0.35% arawal interest. This is held for long -term repair needs and not for current operations. This is not invested in longer -term assets paying a better interest rate because the HRA is in the process of selling the Parkview property. Analysis From the City's standpoint, if it received a sixty day loan from the HRA of $750,000 with a 1.0% per annum rate of interest, the City could hold more of its existing investments to full maturity, and repay the loan when the June tax collections are received. The interest paid to the HRA under these terms is less than the estimated interest penalty the City would incur to sell investments early. From the HRA's standpoint, issuing the loan provides a safe short -term investment at almost three times the rate of interest the HRA is currently earning on these funds. If some unexpected event was to occur, causing the HRA to need repayment of the loan sooner than sixty days, the loan provides the option to modify the terms by mutual resolution. Staff recommends that the I -IRA Board of Commissioners adopt the following motions: RECOMMENDED MOTION: Move to waive the reading of Resolution 2013 -5 there being ample copies available to the public. RECOMMENDED MOTION: Move to adopt Resolution 2013 -5, being a resolution approving and specifying the terms of an inter -fund loan to the City of Columbia Heights. JPK A ffarhmenf• Rnsnhrtinn 2013 -05 BOARD ACTION: HRA RESOLUTION 2013 -05 COLUMBIA I-IEIGI-ITS HOUSING AND REDEVELOPMENT AUTHORITY RESOLUTION APPROVING AND SPECIFYING TERMS OF INTER -FUND LOAN TO THE CITY OF COLUMBIA HEIGHTS RECITALS A. The City of Columbia Heights ( "City ") and its Housing and Redevelopment Authority ( "Authority ") desire to enter into a mutually- beneficial sixty (60) day inter -fund loan agreement. B. The Authority is currently undertaking to divest itself of all operations. Therefore it is impractical for the Authority to invest in long -term high - earning investments at this time. Consequently, the Authority's building repairs reserve for Parkview Villa North is currently invested in a demand deposit account with an interest rate of approximately 0.35 percent per annum. It would be advantageous for the Authority to safely earn a higher rate of interest for a sixty day period. C. The City receives two large payments of property taxes each year as its primary source of fiords. Therefore the City invests upon receiving these payments, and then liquidates the investments over the following six months until the next tax collection. It would be advantageous for the City to hold more of these investments to full maturity beyond the next tax collection date of June 20, 2013, instead of liquidating them in the current market. NOW, THEREFORE, BE IT RESOLVED by the Board of Commissioners of the Columbia FIeights Housing and Redevelopment Authority: 1. The Authority authorizes of a loan to the City in the maximum amount of $750,000 (the "Loan "), to be drawn from Fund 203 — Parkview Villa North. Such amount will be made available to the City at April 24 "i, 2013. 2. The outstanding principal balance of the Loan bears interest at the rate of 1.0 percent per annum. Interest accrues from April 24 "i, 2013. 3. The Loan is payable from the City's Investment Fund 886 and shall be due in full, including all accrued interest, on June 24°i 2013. 4. The principal sum and all accrued interest payable under the Loan are pre - payable in whole or in part at any time by the City without premium or penalty. All payments shall be applied first to accrued interest, and then to unpaid principal of the Loan. 6. The Authority and City may amend the terms of this Loan at any time by mutual resolutions. 7. The Authority authorizes and directs staff to take all actions and execute any documents necessary to carry out the intent of this resolution. Passed this 23" d day of April 2013 Attest: Shelley IHansen, Secretary Chair I 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 January 2013 Prepared by Jean Votta, Assistant Property Manager Police Report There are no service calls for January Wait List 36 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicants for Parkview Villa North (employed in C.H.) 18 applicants for Parkview Villa North (non- resident, elderly, handicapped) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 00 applicants for Parkview Villa South (non- resident) 00 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 40 out of 45 (89 % occupancy) Move Outs #222 1/21/13 #319 1/31/13 #806 1/31/13 Move INS Maintenance Report (See attached) Parkview Villa Apartments Newsletter i Phone 763- 706 -3800 Hours 8 a.m. -4:30 p.m. V � i Managed by CotmnonBond Owned by the City of Columbia Heights Communities Day—January New Year's Ist Office and senior dining closei� �. -- W4101 of -- WMEEMORAKamo Waa 01 0 1. 1 can be long or I can be short, I can be grown, and I can be bought, I can be painted or left bare, I can be round or square, what am I? 2. What can fill a room but takes up no space whatsoever? 3. What is in seasons, seconds, centuries, and minutes but not in decades, years, or days? 4. What starts with T, ends with T, and is full of T? 5. Until I am meas- ured I am not known yet, how you miss me when I have flown. Who am I? 6. 1 gave milk and have a horn, but I'm not a cow? Who am I? 7. The more you have of me, the less you see. Who am I? www.riddlesandanswers.org p � w N U U N 0o rt b o p ® d 6 6' r no p n R A ° a c ° O D b OdN, O N 97' O 0 In p, O 0 N P$trdJ E pa. t�U Np°o.� E pa.� o' n b I I b N .- O r y O� �• � O � y 0 t d t-1 tv.wy O �y G y ( o� C O �i G o C �' [n•+ d ryy op ~ � W D op ry� y� Ef p `� O� M °O OOFn Pwo AD. Pwa x P &wo Pw� Pw� � � Le'� B �y � o �. 'moo � o C"'. w o �• o C,_'. No x• x o ° o w A J O w J rTi J D �1 v O J p O G O G COC O y O d o rdi. W 11 td fD a:, 15 w 0 O O O O N N W A W T Q\ w P td tz Ir (/1 w a A R S C 9 R O CL cc Y C 10 C w a+ C A 3 w Y A a m �0 o w \ E O U m m m m m m m co m m M m m m m m m Z �A N N c � N N N N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o N N N N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ 00 \ \ \ \ Ol \ O 0 O m N m V co d' V r 11 n 00 11 W W Y L L u c N w L JO m m Q 0 N m m 0 c m ,O a; > m n N N 0 Z Z tw Z c Z w V1 Z V1 �A Z H � c � Z Z OV > C O > > N aj > m > > a L a > > w > > > p m v a= c a CL 3: s LL n. J a O c O 0 °. J J C O Y L L u c N w L JO m m Q 0 N m m 0 c m ,O a; > m w w w la s v on ai > > u w a v p 'o t aL-� 0 N 0 N 0 O o p w a w O D o L J 0 ` p H w N Y N N c N u N 3 3 ° in L C m L w iy 'E a U L: U H ii UA p C 'h v w m o oo O .`°o v N i 3 v° a E a + 0 c r u1 � N L O 00 V V w w> O — w p N U ° O `1 L u U 3 3 c m L V w v O a V d J M Y m 'o C 3 N= w O J w U O d9 °o C m cu > W OCj m L G 0 3 v E E 3 @ >0-0 N a Y L m= a C c J c0 G Oc 4 O 3• c c u 0 w w o- D y 'O E p in w u E w Lam, ti w u N p -O w O a+ 4 L u w c '� m o .` v m p= v `w ° w L 3 p o o m a 0 m w ° ° G O a 0 L ° O O ++ c u a. E Inv bn ,r L r O 0 w s L O c n c o w L 0 w o L u 3 w y L O _ ry w d o O` o ."c pc L w O F- 3 x LL a F H N S J Y E Y d O c y 00 V C H w f0 Y o ` E 00 E 0 m ro > U m m Z M a-1 h O V1 00 N� O O O � 00 CL 0 M C o � m n N N 0 Z Z Z Z c Z w V1 Z V1 Z Z H � 0 � Z Z OV > C O > > u 0 > m > > > L a > > w > > > p m v n. c a CL 3: s a n. J a O c O 0 °. O J C O Y L L u M N c JO m m Q 0 m m m J L ° m ,O a; > m w w la s u on ai > u C E u p W t aL-� 0 N 0 N 0 O o p w w 3 O p 0 L J 0 ` p H w N Q N N 0 N u N 3 3 ° L —° C N C iy 'E c U 'L° 0 H u ° v w 2 o 01 O .`°o v N i 3 v° a J a 0 W r u1 � N L O 00 V V w w> O — t0 p c vi ° E u c 3 3 c m no u° v E � ° = o° m 'o 3 a+ a ]e U O d9 °o C m v N W OCj m L G 0 3 v E E 3 0' >0-0 a a Y v m= a m 0 o$ 0 J c0 G m m T 3• h M .+= 0 c •� .c f0 D a 'O E -p p in u m ++ T w Lam, w ti w u N m w -O w L w a+ 4 L G ++ c N w `w `w `w ° w v " O c 0 0 0 Y a L U O L E E Inv L ,r L r O 0 w s L O I- O c n c t ac L 'i^ L �j 0 m w Z w S � Y o d C: m 00 o o 00 m m m 0 Z Z Z Z Z Z w V1 Z V1 Z Z H � 0 � Z Z > C > > > d > O > > > > > > > > > > m m n. c a CL 3: s a n. J a O c a °. a o. m m c M co c po m m v m 3 m m J L O) m ,O a; > m w w la s u ti E > C E u 0 0 0 0 0 0 0 0 `0 0 0 ; a' o O p 0 L J w w w N Q N N 0 N u N N N N E N C N iy 'E U H u ° v 3 2 01 01 O c-I N M 3 v° a a 0 W r � 3 O 00 E C — c p C ° E a`n o 3 n ° L w w bD v E v = o '> 'o a+ c0 ]e U J F- v c m a a m 0 J c0 G J J h M O 0 O 0 O d' I, M N 0 Z Z Z Z Z Z 0 V1 Z V1 Z Z Z 0 Z Z Z > > > > > > > > > > > > > > > > > > m m n. a a CL a s a n. a a a a a °. a o. m m c M co m m m m m m m m m m M m m M m N ti H 0 0 0 0 0 0 0 0 0 0 o O o 00 0 0 N N N N N N N N N N N N N N N N N iy W 01 01 O c-I N M M m m W w CC) m m m m m M m m m m m m m m m m m m m m m 0 0 0 0 0 0 0 0 O 0 0 o O O O o O O o O o 0 O O V d' tD CO W l0 1, n rl M rl N M ct V7 N V CA m m N N N N N rl N N N rl N N N N N N N N N N N N a) o c c o. o c ai E a o ai O o° .a a 06 — 06 b0 v c o v a) o a p Y 0 : > C C c O a) U bD C C p 0 aJ > °� N O s H j w O u -O N 0 (U O t Q -= L O `A u > '^ a s s w a o a v u a Q) -p OU a o c au w -° v v m U L 09 Y Y ° N O N� C u ❑. "°O N N N O ai a 0 Y O= M C N N N O N N L +-' pp L - �. Z U C C O Y a O G v w a= a) c O U a) E Y^ a s Y 3 u a) u c E L° '° - v r � J •`^ O E c a a > Eo v oZj u m —° v^ � v Y o � ° s "_' m � E o Y° to O _ m 3 a) a ° CL O C Y L a E N ? Q N p a a?} N c m E @ L O W3 w ' v 0 0 ° a m v ° v c o o °o o W oo m a v 1D v c Co 06 z ru o s m u Y v u o ,° E a) ai L V) L` Y— (U = b0 U .O m U C Q U O C ,_ > U N W C U U ti E "O Y c m u r J v '� O p a= c a a pp CZ O Y Y w O` OD Q c a v Y bA C C m QQ N 02 c O Y al al U O` r< O a�.� 3 O b0 O J b0 Y O OA O — E U Y Qy� Y ° a Y a a) w w Y U C.0 O O J J a L Y 7 U t+ W N 0 al N W U E Y Y L a) U N QU) 'o U OY1 Q C O a Q O C O A L N J = U c ° o Q t ° o p N •c o o. Dv o v o O a) y U aj - a O O C a L > c " V oQ w L v L v vO v v v u U u O m u Y m Mr- u O+ +0 a u a u L E b= b0 J U L O O Ql al t Y m Y O O U J dC : E Y m Y : Q Y 07$ 0 0 bb 0- O (n ° GO GO v O J 0) v O E Z Z Y *- L 2 W � Q Q fb Q Q E Q Q U to V1 m z Q a Z m Q O Q �! J Q Q u --! > = -: o Q > Q > 2 > c� D: z > oc > m > > VI lO 0 m N Ln V1 Ol VI N O I, O Ol d' w Ln N Ln V) O O O O N ti N O O ti N ri O ri O ri 0 O N LD LO N V1 N N 00 d' m p ch N Y O O w N L W Y I� Z Z Z Z Z 0 V1 Z Z Z VI N Z Z N Z VI V1 Z Z Z V1 a s a a a a a d a s m a a s a a a a a 0.. a 0.. m m m m m m m m m m m m m m m M m N m m m m O o 0 0 0 0 O O O O O O O O O o o O O O O O N N N N N N N N N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ 00 \ \ N \ N \ m \ M \ m \ M \ m m M \ m O co N V V d' t0 h 1, W CO 00 N N N N N �.I rd r� H rl H N H H rl N N N N A H H e's H H L 0 0 a c L 0 O v z C �T O Q' Y Q) ` c v c OC u u L u 7 J O u E w C p � p N u S "CA N a p L v a u a m o v w O a a z z z Q j w ko O 00 T 9 O J N N v n s o d a a v E ti en (U ti o vii rn m m o D E o UQ YL" G y tF rn L 0 0 a c L 0 O v z C �T O Q' Y Q) ` c v c OC u u L u 7 J O u E w C p � p N u S "CA N a p L v a u a m o v w O a a z z z Q j w ko O 00 T 9 O J N N v n s o d a a v E ti en (U ti w o D E o UQ YL" G y tF rn ti ti ti ff U1 O �S j C Y N C -O E O 'O ` y U C t 3 v Q c � Y c Y O `O p O u O L p ° 'o m Q 3 v L (U O •bCU ? n C C O Y L -0 V O CL Y Ln y ;O CL C a t0 n o C . y, � 'O v p v 4) c I M E ai d ' C� c o C „ �n c u 'c L � N m N N N s a d a a ti en ti N ti o vfi C; a rn ti ti ti ff N Parkview Villa Apartments 965 40`x' 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 February 2013 Prepared by Jenn Votta, Assistant Property Manager Police Report There were 3 calls for service. Wait List 39 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicants for Parkview Villa North (employed in C.H.) 18 applicants for Parkview Villa North (non - resident, elderly, handicapped) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 00 applicants for Parkview Villa South (non- resident) 00 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 40 out of 45 (89 % occupancy) Move Outs Move INS Maintenance Report (See attached) C 7 N C B N fl: rt W J � G n> cn p w � � .•. w p� .a 0 0 Ia4 ❑� c ^ � g n � G N ° w V � ~ tom• o C O 0 N w w o� C ca m 0 0 o o J J J C J O O O A O N � N N b l0 'tl N Ty N .d N C 7 N C B N fl: rt m 0° W W d f C DI m 7 m m 7 m n m A m 0 O 4 0 N N N N N N N N \ N \ N N \ \ N N \ \ N N N N N m \ \ \ \ \ \ \ V1 Vl A A W N N N N N N J dl In In \ A \ V1 \ (n \ \ \ \ \ \ \ \ \ \ \ \ N \ N \ N \ N N N A N N N N N N N N N N 0 N 0 N 0 0 O O O O O T 0 0 0 0 0 0 O O !-� O N N N N m N F) W W w W w W W w W LU W W w W w W W w W w W W 6 W w w w W W W < •O L •O < V W a V L < < < < < < < 0 Z N Z Z Z Z N N Z Z Z Z Z Oq to (n Z Z Z C 0 m e4 0 N W w N N Vi X A N J V1 00 m In O N O N O N 3 O O O O 00 O .p 00 W N l N V co PO fu n o V r n = v ZD a m fD 3 r N C Dr 0 N d m p d w N 6 c d H 07 ao s C jN. o? a ? c 3 N W -i -i O S> =r w 0 O OA (D 6 -, m n 0 m O W O .i d O S a m m O n m (D O m (n n o M c �• (D 0) 01 In i�-e DI O. rt M' n N< 6 0 N 6 d m O O (D '4 N rt< N 0 rt 3. Ort an CL 'M O 00 (D ti' C N S(D d 00_0. N O Od �. '� 0l d On" 7 w a go n (D .m+ 0 0 = m .+ C 7 6 f]. j Ort Q O 0 m 0D n d m N o d 6 W 0 m° m d ::r O ,m-« O o o o° s F D 3 m m o o m N F N < o o d(D q°a o CC w CL CL M, p m N as o N a aCO c m o, s •< �c a 3 m; n n ii •O c o 1 m N rl' G � „'F d ii %% m o d a >> o 3 d <.� o 0 o m CL 3 S ° rD <• a° a° m o a m 0° 3 o o (D a n '� v o w 'mo 0mm �vi m O N O (D " (D C n .+ °' N O n n n m a N O n (!0 N 0 d "NO m F N = C O c a (D (D ° m o O m° a 6 •,< n 0 0-0 d o v. °L m mo a w (DD a M s n O as m a n D a oo O 4 (°D n. W n ° p n' N 3 — 0 ° °- 0 0 (D d w m N N 3 m 6 O O p_ O' ((D a 0 °- d 0 d m a t°1 C m o 0 c 6 n (D n (D rt o (D 6 O' 0) m m . 7 n• �• m O W m O F 0 v 0 m v d m .°- v O. O 0 o 0° 0 0 _^ m RD m o ID o° (D S o o m (D m ° n 0 3 N N N N N N N N N \ N \ N \ N \ N \ N N N N N N a \ \ \ \ \ \ \ \ N N W N m F' N N N N J J In Vl Vt Vl m U) to �p �p �0 �p N N N N m N N N N N N N N N N N N N N 0 N 0 0 0 0 o a 0 0 0 0 0 0 O O O 0 0 0 0 w w w w w w w w w w w w w w w w w w w m 0° W W d f C DI m 7 m m 7 m n m A m 0 O 4 N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ \ 00 N N N N N N N N IO N F' 00 W 00 m U� In N O O to l0 LD l0 lD l0 V \ \ \ \ \ \ \ \ \ \ \ N \ N \ N \ N N O N O N O N O N O N O N O N O N O N O O O O O O N O O O O N O O O O N N O W w W W w W w w W W w W w W w W w W W w W W w W W W W W W W W W W W W W W W N lGn N Z N Z Z Z Z W N Z Z Z N N A LO _ < O T X M. 'm0 00 m n d Q O_ 0( m � O' o (D D � a N (D a a O. ° S O 0 rD m S CL m 0 0 O O O S � w 0 (D o m m 0 0 m m N C O. T A w w 00 W l0 N N to N V N ~0 ��+ 1�-' w to W A A 0 o in d W o(D c W W 3 0° o (D m (D c � _ r 0 (n 7C W fl G ,-« v� r W to r T n = c S Oq C S ;y or O m O S a O W (D 3 00 S .. O n " or 'Z m m S a 0 S v n p�j D m m o n n DO v O O v' -'7 n o m C N Q ryc , O O O 0 O i O M 0- g,(D° N , CL 3 0- r o 3 3 O n O h O O S m S O d :E O 04 a m m 0 O O O S M 'a0 d t< 01 £ O' N '0 W J 00qq O 0 Q N Q W` `� O m 00 c 0' d m rr 3 Q " m - (D •"' 70 S 7 d, QO C 0' lmi j ° O O N A N �< m 0 0= tm c c 3 r°D 3 is a s rc' c N °" 0' d im tdi 3 N m CL -. °' 0 O1 to m , 0. rD -O C O, m d m '� 3 w a N m0_ O O' n O. O. J 0' �i � C- I d 00 � A ((D (D (D S r+ 00 (D 6 M a m m -2 CL U 6 C M O 0 (D 3 — 0 a s '? -O c Q N m 0 Vmi Q rt j C ry 0 Q O O1 0 O (D S (D 0- 04 O O 0. 0 s 3 m = o --o -o, Cr E O rr m O_ N _: m 00 0 RO (D Q (D < a 3 Q • ;; S > > n Q° ° o o° c or ;• m (D n S(D m rD 0 m m e 0 0 0 o N m 0 o m a a 3 (D (D N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ \ 00 N N N N N N N N IO N F' 00 00 Qa 0) In In H O O l0 l0 lD lD W LD lD \ \ \ \ \ \ \ \ \ \ \ \ \ \ N N N N N N N N N N N N N N O O O O O O O O O O O O O O W W W W W W W W W W W W W W Parkview Villa Apartments 965 40`h 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 March 2013 Prepared by Jenn Votta, Assistant Property Manager Police Report There were 2 calls for service. Wait List 40 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicants for Parkview Villa North (employed in C.H.) 18 applicants for Parkview Villa North (non- resident, elderly, handicapped) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 00 applicants for Parkview Villa South (non- resident) 00 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 40 out of 45 (89 % occupancy) Move Outs #211 3/31/13 Move INS Maintenance Report (See attached) m C �D B.- 5 m VI M vi d W J a m ;dK qyx 'o°a7y� 'd a7y� C] CZ °p o � o y �pyo� yyo pC1� V+ IQ N P Vwi i� Vwi H p td a g td g W a $, 0 i,a ro iN ro w ro w� hi ttl tz o yr td ttl p Cs1 0 by Cil 0 �' x N N N by ttl ttl b7 Q b�G tl�0 W O O O O !/� N N 00 ro td ttl ny k rn Ci O O O O y' y by W d d Fil � U7 `<• `GG O� Oi W W MO P rO M m C �D B.- 5 m VI M vi d a m u C m C a! Y C m 2 m ,d a m m M m m m m m m m m m m m m m m m m v o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O O a) N N N N N N N N N N N N N N N N N N N Y 00 \ \ \ \ \ \ \ \ \ \ \ \ \ m \ 01 \ (3) 0 O \ O \ O a) 00 \ \ \\\\\ W W N H H H N H N H N H H H H N N N E M m m m m m m m m \\\ \\ \\ \ \\ m m m m m m m m m m m m 0 u a v Y a) al L 4) c o L L ° U N ~ 0 -O ° m = a c u ai z c oo o o o D v m m a c o a o Q ai o " o ° ° '� a s ai 0o u '° m 0 °/ m c ' n v a) a m Y a/ C m O '� G C C >O Y m +,,, =0 C O C v°'i m ai L v v � u m i w ° U cn 'L° u ° n a 3 L •a m L o N a ._ c 3 `� 0 o n o v N n c u" >° w e a a) m a v E c o u a a) °° u c v I o ° o " o m w C L u a a 3 U o C D u Z' ai CL +-� L m a) a I v L O LO Y O m -p 1 L C Y a N 1 O L O. Y u o o m u> C m do ao v° s u c '— w G t' 4- O T — M .0 F N— a m C .Q C by O !6 3 b0 I a m m .mC in c ai v o cz Q c ai p m ° C 3 C a, Y y H ai H O Y> C E F u C N of 0 O T O m O E N O O O a s C �[ O 0 t H Y C c E L C C C O O O fa a! Y L Y U L a) Y al Y Y ° C u C of CD o Z 0° a° a a° M me u as 3 m ° a) u 3 o a) m a C a E N E C wT E w C O w � Y� C 3 C 0 O L O ° ° ° ° +L.., a nu 0 o E o YF O C 0 C v G C C Y a) 3 L L L L v aj L m '^ v v v Y u m a) L Y Y Y 3 a m L L a a L aJ Y N w Y^ Lm u t >' m c m Z Z o = w ^ '^ �- •o °= w w v c r v C O O O ]C m Y d Y F Y= L 2- J Ln L 0 L w m oz m Y m c v C m C O O C = L C V�1 J Q V�1 E J 3 C al J f6 L m •L Y C d C C LL L a/ >. LL W N L L N O C L L m 2 Oc N VI U C V d O C G u VUl ,M J Z 0 J N J K N-zt G Q J Q V1 Q U J Y m H oo n w m N a w 0) vi 00 .-+ m n .� H O O O O O N N O O O H o N H H H 0) d' V V I, N H 00 W d' m N d' m a a a J J J ho � Z Z Z Z Z Z t/) Z t/1 Vl Z Z Z N Z N N Z > > > > > > > > > > > > > > > > > > > an d d d d d d d d d d d o. d o, d CL d d d m *- m m m m m m m m m m m M M m M m C O M H H H H H H H H H H H H H H H H H H H 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O o N N N N N N N N N N N N N N N N N N m M cf 00 h 00 of O H N N m 00 C71 CY) Ol Ol H H H H H H H H H H M m m m m m m m m m D m m 0 N N N CD N N N Ln N N M m N C O O/ v c r Y u U C 0 Q C v Y Y � t Y C6 Q N Y O O C Y > t � f u T O w O C � N u Y U (0 � N Y V 0 N O Q O O H H N bA f0 � c= Y C J m io o � v a Z n a d m m N 0 0 0 N N 4 N N N m m Meeting Jan. 14, 2013 Meeting started late at 7:45 with pledge To the flag. Managers report was given by Jennie. Mon. Office and dining closed for Martin Luther King Day. Certificate of rent paid will be out by end of week. A and B room may be rented at anytime any day for private parties as long as deposit is paid and rooms are available. Scott and Lisa will be here Tuesday night for HRA meeting Jennie is leaving January for a new opportunity with Common Bond we wish her luck and will miss her. Decision on who will take her place next week. David Allan is here Wednesday the 16th. Look for further news. Ken gave the checking report. The meeting was then turned over to new councel President �Avv Miller As of now there is no entertainment committee per say, I/you want to have an activity you are encouraged to chair it�we will be more than happy to get you volunteers to help. Also do an act of kindness for someone and pay it forward It feels good and makes someone else feel good Aeon is trying to keep all activities that are now here 99 they are now. Store to door was mentioned as a possible help for people here is is a home delivery Rheta is looking into getting the number. Meeting adjourned at 8:40P.M RESIDENT COUNCIL MEETING — February 11, 2013 LeAnn read former minutes. Celia read the Sunshine Report Jackie read the Bingo Report Rheta gave us info on speakers and an upcoming program about food. Since the bus to Cub no longer runs, alternatives were discussed. Some alternatives are: Store -to- Door, Coborns Delivers, and Rick the Milkman will also bring food from Cub, if you call him in advance. Physical Therapy will come and help people with balance problems. It's free. Fifteen and sixteen women want cookies and coffee. )'ti %�Q.e���ua Resident Council won't sponsor a phone list. Treasurer's Report: $2,815.37 Petty Cash: $56.75 $5.00 money winners: Jeannie Harshberger Rheta Celia Tom Lindskook