Loading...
HomeMy WebLinkAbout2012-04-24 HRA AGENDA PACKETHOUSING & REDEVELOPMENT AUTHORITY AGENDA 7:00 P.M. April 24, 2012 PARKVIEW VILLA, COMMUNITY ROOM B, 965 40"" AVE., COLUMBIA HEIGHTS, MN 1. Call to Order 2. Roll Call Tanunera Diehm, Chair Bobby Williams, Vice Chair 3. Pledge of Allegiance CONSENT AGENDA Bruce Nawrocki Donna Sclunitt, Secretary /Treasurer Gary Peterson 4. Approve minutes of January 24, 2012 and special meeting of March 5, 2012, Executive Session March 5, 2012 5. Approve Financial Report and payment of bills for January, February and March 2012 on Resolution 2012 -03. Motion: Move to approve consent items as listed BUSINESS ITEMS 6. Report of Management Company 7. Resident Council Minutes 8. Citizen Foram* 9. Approval of window analysis contract with Encompass 10. Other Business a. Aeon update (no attachments) The next regular HIUI meeting tvill be Tuesday, July 24. 2012 at Parkview Villa. *At this time, citizens have an opportunity to discuss with the IIRA items not on the regular agenda. The citizen is requested to limit their comments to five minutes. Please note the public may address the HRA regarding specific agenda items at the time the item is being discussed. HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE MEETING OF JANUARY 24, 2012 1. Call to order— The meeting was called to order by Chair Diehm at 7:00 pm 2. Roll Call — Members present: Bruce Nawrocki, Garry Peterson, Donna Schmitt, Bobby Williams, and'fammera Diehm. Staff Present: Community Development Director -Scott Clark, Assistant Community Development Director - Sheila Cartney, and Secretary - Shelley Hanson Parkview /CommonBond staff: Laura Sheak, Laura Frost, and Jennifer Ells. 3. Pledge of Allegiance - Recited 4. Election of Officers for 2012 Peterson nominated Diehm for President, Williams for Vice President, Schmitt for Secretary /Treasurer. No further nominations were made. Upon vote: All ayes. CONSENT AGENDA 5. Approve Minutes from October 25, 2011. 6. Approve Financial Report and Payment of Bills for October, November, and December 2012 on Resolution 2012 -01. uestions from members Nawrocki questioned the December reports and noted that Revenues were down a little, Expenses were up a little, and wondered why there wasn't an accounting of Interest on the Bank Account. Laura Frost said Revenues were less than anticipated because we have yet to receive a $29,971 grant payment from HUD. Once this amount is received, it would bring the total Revenues closer to the budgeted amount. She said we should receive the payment in the first quarter of 2012. As for expenses, Frost stated that some of the utility bills came in higher than projected and that legal fees were also higher during the year due to several tenant /policy issues. Schmitt noted that many appliances have been replaced. She asked what the average age was of the appliances. Laura Sheak said it varies, but the south building has had to have many of the appliance replaced since they were the original ones from 1990. The north building has been replacing appliances with the modernization of each floor, but the south building has not. HRA Minutes Page 2 7. Resolution 2012 -02 Designating Signatories The attached Resolution 2012 -02, designates Northeast Bank as the depository for all Columbia Heights HRA funds and authorizes signatories for accounts. uestions from members Nawrocki questioned who the signers would be. He thought that each check should be signed by one person from CommonBond and the HRA Executive Director. Clark explained that two signatures are required, but that two signatures from personnel at CommonBond also suffice. He said it has always been this way and that is why we have a management company. Nawrocki thought it would be better checks and balances if a City Staff person signed each check. Clark said the City and HRA Board receive copies of each check and the financial reports each quarter which serves as the checks and balances. He also pointed out that any expenditure over $15,000 requires pre - approval from the Board as stipulated in the contract with CommonBond. Nawrocki again asked for information about the interest paid to the City on the funds at NE Bank. Frost will check with the bank and report back to Clark and Nawrocki on this. Motion by Williams, seconded by Schmitt, to waive the reading of Resolution 2012 -01 & 2012 -02, there being ample copies available. All ayes. MOTION PASSED. Motion by Williams, seconded by Schmitt; to approve the minutes of October 25, 2011; to adopt Resolution 2012 -01, a Resolution of the Columbia Heights Housing and RedevelopmentAuthority (HRA) approving the Financial Statement and Payment of Bills for the months of October, November, and December 2012; and to Adopt Resolution 2012 -02, a Resolution Designating Depository for the Columbia Heights Housing and Redevelopment Authority (HRA). Motion by Nawrocki, to remove the Resolution Designating Depository for the Columbia Heights IIRA from the above motion. The motion died from lack of a second. Roll call vote on original motion: ayes- Williams, Schmitt, Peterson, Diehm Abstain- Nawrocki MOTION PASSED. HRA RESOLUTION 2012 -01 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR OCTOBER, NOVEMBER, AND DECEMBER, 2011 AND PAYMENT OF BILLS FOR THE MONTHS OF OCTOBER, NOVEMBER, AND DECEMBER, 2011. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (HRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the I -IRA's credits and assets and its outstanding liabilities; and I -IRA Minutes Page 3 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 it) its records; and WHEREAS, the financial statement for the months of October, November, and December 2011 and the list of bills for the months October, November, and December, 2011 are attached hereto and made a part of this resolution; and WHEREAS, the HRA has examined the financial statement and the list of bills and finds them to be acceptable as to both form and accuracy. NOW, THEREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia I- leights 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 paymeut out of proper funds; and BE IT FURTHER RESOLVED this resolution and attachments are to be made a part of the permanent records of the Columbia Heights Housing & Redevelopment Authority. Passed this 24" day of January, 2012. RESOLUTION NO. 2012-02 RESOLUTION DESIGNATING DEPOSITORY FOR THE COLUMBIA HEIGHTS 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 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. IT IS IiEREBY 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. HRA Minutes Page 4 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 Director 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 24th day of January, 2012 Offered by: Williams Seconded by: Schmitt Roll Call: Ayes - Williams, Schmitt, Peterson, Diehm Abstain- Nawrocki Chair Shelley Hanson- Secretary HRA Minutes Page 5 8. Report of the Management Company Laura Sheak asked if there were any questions on the newsletter items or on the monthly reports. Williams noted there weren't any police calls in December, which was encouraging. Nawrocki said contracts were approved for ductwork and the modernization of the second floor at the last meeting. He wanted to know the status of these projects. Frost said the ductwork project is about 1/3 done and will be finished in the spring, and the modernization project begins March 12`x'. He wanted to know what the delay was. Frost said Project One had to wait for specs from the Architect to order the doors, which has now been done. Jenny said the delay was because each door had to be individually measured and ordered due to settling of the building. Clark told members that he has had discussions with Laura Sheak regarding the bay windows in the south buildings that have been leaking. They are in the process of going out for bids for an Engineers Report on the 36 large windows, to assess the damage and find out what corrections /repairs will be necessary. 9. Resident Council Minutes Lyn Miner reviewed the resident council minutes from the last meeting with the Board members. Copies of the previous meetings were enclosed in the agenda packets. Lyn reported that the 2012 officers are: President - Vice President - Secretary- Treasurer- Member at Large - Sgt. At Arms- Lyn Miner Vivian Fagge Jessie Clmdek Ken Bloch Lee Ann Miller Matthew Kopacek Lyn stated that each resident is given a copy of the minutes to keep them informed. Diehm stated they appreciated receiving the minutes and being informed of resident activities. Clark also stated that staff appreciated working with Rheta Nelson during 2011 and looks forward to working with Lyn Miner in 2012. He feels communication has greatly improved over the last couple years. 10. Citizen Forum Barb Camp #608 -asked for a status report on the sale of Parkview. She said residents are concerned. HRA Minutes Page 6 Clark said the matter is progressing well. He said the entire process will probably take another 12 -15 months to complete. He said there will be another group meeting with residents in about 4 -5 weeks. Aeon is currently working on obtaining grants and financing to complete the purchase, and will have more information by the end of February. The date of the meeting will be posted and each resident will be notified individually. Dianne #905 -Asked how to identify people who are not supposed to be on our property. Sheak told her that any concerns about people in the building or on the grounds should be brought to management staff and they will deal with it. And no one should be letting people into the building. Anyone who belongs there will have access. If residents adhere to this policy, then they are safe. Jackie #707 -Asked if the laundry room on second floor will be closed during the modernization project. Sheak told her yes, it would be, but residents will be notified ahead of time. Ken Myhre #511 -If a friend comes in with him, is that ok? Sheak told him that, yes, that is ok, and that residents are allowed visitors. Barb Camp #608 -Told members that she appreciates the wonderful management team that has been in place during the last 5 years. Residents think they do a great job. Nawrocki asked residents how the new smoking shelter is working out. Most of the residents thought it was a huge improvement and has been helpful in resolving most of the issues. However, Lyn Miner, said she still hears a lot of noise and conversation coming from the shelter. Ken Bloch said that all the traits have some type of noise to deal with. On the other side of the building it is noise from the garbage trucks emptying the commercial dumpsters in the early morning. Shirley Bennitz #324 said she also hears the street /parking lots being swept during the middle of the night on her side. They both pointed out that noise cannot be eliminated completely since they live in an urban area. Malcolm Watson -1717 49 °1 Avenue- is interested in contacting James Lenhoff from Aeon regarding the appraisal that will be done on Parkview Villa. He asked Scott Clark for help in getting a hold of him as he would like to get the contract to do the appraisal of the buildings. 11. Confidentiality Agreement with Aeon Clark explained that in May of 2011 the Housing and Redevelopment Authority (HRA) entered into a memorandum of understanding with AEON to begin negotiations for the sale of Parkview North and South. As we progress, it has become clear that AEON will need access to HRA file information that is protected by the Minnesota Data Practices Act. The attached Confidentiality Agreement allows Aeon access to this information with the caveat that they must adhere to all applicable State and Federal laws, including holding the HRA harmless from any unlawful disclosure. This Agreement was written by the HRA Attorney and has been reviewed by AEON. Staff recommends approval this agreement. HRA Minutes Page 7 Question from members: Nawrocki asked what kind of information they are seeking that would require this agreement. Clark said an example would be the income levels of the residents that are needed for the grant applications. By entering into this agreement, they will have the right to see information but would have to adhere to the same Data Practices Rules that we do. They would be unable to share private information. They can take the data received and compile it in a generalized, group format but could not provide any specific information that would identify an individual. Resident Adam Alieu said he thought the information could be used to decide who Aeon keeps as residents versus those they want to get rid of. Diehm assured him that there are other separate agreements in place that protect residents from that happening. Motion by Peterson, seconded by Schmitt; to approve the Confidentiality Agreement with Aeon for purposes of'implementing the goals of the Memorandum of Understanding. All ayes. MOTION PASSED. CONFIDENTIALITY AGREEMENT BETWEEN AEON AND THE CITY OF COLUMBIA IIEIGHTS HOUSING AND REDEVLOPMENT AUTHORITY This CONFIDENTIALITY AGREEMENT is made by and between AEON and the CITY OF COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY ( "HRA ") for purposes of implementing the goals of the Memorandum of Understanding executed between the parties on January 24, 2012. RECITALS WHEREAS, the HRA owns and oversees operations of Parkview Villa South and Parkview Villa North, which are attached multi -unit residential housing facilities located at 965 40 °i Avenue NE in Columbia Heights, Minnesota (collectively "the Subject Properties ") ; and WHEREAS, the HRA has identified Aeon as a qualified party of interest for purchasing the Subject Properties subject to parties establishing a process for the sale consistent with the expressed goals of the HRA; and WHEREAS, the parties entered into the Memorandum of Understanding which outlines the goals and expectation of each of the parties during the process leading up to the execution of a purchase agreement for the sale of the Subject Properties by the PIRA; and WHEREAS, Aeon has requested access to documents and data in the possession of the HRA for purposes of implementing the goals and objectives of the HRA as identified in the Memorandum of Understanding; and WHEREAS, some of the documents and data sought by Aeon for review are classified as not public under the Minnesota Data Practices Act, Minn. Stat. § 13.01 et seq.; and HRA Minutes Page 8 WHEREAS, access to the documents and data requested by Aeon is reasonably necessary for Aeon to fulfill its obligations under the Memorandum of Understanding; and WHEREAS, the Memorandum of Understanding may be modified by mutual agreement of the parties in writing; NOW THEREFORE, the parties hereby agree to the following: 1. The HRA will provide Aeon access to documents aid data in the possession of the HRA that are reasonably necessary for purposes of Aeon implementing the goals and objectives of the HRA as identified in the Memorandum of Understanding. 2. Aeon agrees to comply with the Minnesota Government Data Practices Act and all other applicable state and federal laws relating to data privacy or confidentiality. All data created, collected, received stored, used, maintained or disseminated by Aeon in performing its obligations under the Memorandum of Understanding is subject to the requirements of the Act, and Aeon must comply with the requirements of the Act as if it was a government entity. Aeon also agrees to hold the I -IRA, HRA Board members and its employees harmless from any claims resulting from Aeon failure to disclose data maintained by Aeon and authorized for release by the HRA, and from Aeon's unlawful disclosure or use of data protected under state and federal laws. Any information, data, reports, records, contracts, work products or other materials given to or prepared or assembled by Aeon under the Memorandum of Understanding shall be kept confidential and Aeon shall not make any of this material available to any individual or organization without prior approval of the HRA. At the termination of Memorandum of Understanding, all information, data, repots, records, contracts, work products or other materials relating to the Aeon's assignment and duties under the Memorandum of Understanding shall remain the property of the HRA. AEON By: Alan Arthur Its: President Dated: CITY OF COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY By: Walt Fehst Its: Executive Director HRA Minutes Page 9 12. Appraisal One of the many steps involved in the AEON negotiations is a need to commission an appraisal that will satisfy a number of parties including the Minnesota Housing Finance Agency, tax credit investors and /or lending institutions. Due to the nature of this transaction AEON views that it is best that an appraisal be conducted by the Housing and Redevelopment Authority as the commissioning agency since we are the seller. Although the HRA would order the appraisal AEON agrees that this would be done at their expense. Staff views that to order an appraisal on AEON's behalf has no detrimental value to the FIRA, and is beneficial to have a third party opinion regarding value. If the HRA is not satisfied with the appraisal and AEON is, the HRA can always elect at a future date to expend funds to conduct a new appraisal. Clark clarified that Aeon will select the appraiser based on companies they know to have the expertise in dealing with these types of buildings and who are familiar with tax credits, fiord balances, and capital improvements. He said there are very few firms out there who can provide an accurate appraisal taking all these factors into consideration. He went on to explain this is not a binding appraisal for as or them. It is something they need in order to obtain their financing. Questions /Comments from members: Nawrocki said he knows appraisers can come up with a wide range of figures. What do we do if we disagree with the amount. Clark again stated this does not bind us to anything. It is an opportunity to get a first look at someone's opinion about what the property might be worth. He said nothing stops the HRA from getting another appraisal at a later date if we don't agree with the figure. Nawrocki thinks the City should be selecting the appraiser, not Aeon. Clark told them that Aeon will identify three appraisers who are qualified to do this type of appraisal and then will seek a RPP from them. Diehm agreed there is nothing stopping us from getting another appraiser to either review their findings or to do a whole separate appraisal if we choose to do so at a later time. Motion by Peterson, seconded by Schmitt, to authorize Aeon sta�f'lo select an appraiser, on beha f of the HRA for the purposes of an appraisal ofParkview Villa North and South wilh the understanding thatAEONwill he financially responsible for all costs associated with this action. Roll Call: All ayes. MOTIONPASSED. 13. Other Business Move to Executive Session at 8:00 pin -To discuss the status of negotiations with AEON for sale of the property at 965 40 °i Avenue NE. The Executive Session and Regular meeting were adjourned at 8:45 pin. The next regular HRA meeting is scheduled for Tuesday, April 24, 2012 at Parkview Villa. Respectfully Submitted, Shelley Hanson Recording Secretary HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE SPECIAL MEETING OF MARCH 5, 2012 1. Call to order— The meeting was called to order by Chair Dichm at 7:20 pm 2. Roll Call — Members present: Bruce Nawrocki, Gary Peterson, Dolma Schmitt, Bobby Williams, and Tammera Diehm. Staff Present: Executive Director Walt Fehst, Community Development Director -Scott Clark, and Secretary - Shelley Hanson Aeon Representatives - James Lehnhoff, Gina Ciganik, and Melody Bridgeman (Consultant from HM Collaborative). 3. Pledge of Allegiance - Recited Move to an Executive Session at 7:20 pin to discuss Status of Negotiations with Aeon. The Meeting re- convened at 8:13 pm. BUSINESS ITEMS 4. Acknowledgement of Disclosure Statement Notice was received that an attorney with Kennedy and Graven will be serving on the Board of Directors with Aeon. The subject attorney will not be working with any Columbia Heights HRA files and therefore does not create a conflict under the "Rules on Lawyers Professional Responsibility or as a practical matter...." Clark explained a motion is needed to acknowledge receipt of the notice dated February 23, 2012. Questions from members: No questions. Motion by Schmitt, seconded by Williams, to authorize the Executive Director to sign an Acknowledgment of Kennedy and Graven's Disclosure Letter dated February 23, 2012. All ayes. MOTION PASSED. 5. Resolution 2012 -03 Authorizing HRA to submit SAC application Clark explained that as part of the Special Application Center (SAC) process the HRA has to provide authorization to make the application for the disposition of Parkview Villa North. Thi,, Resolution provides that authorization. Staff recommends the HRA approve this Resolution. Clark said the language states we are moving ahead with the sale of Parkview Villa. HUD will not review anything that is not a bona fide application, so it has to contain this language and must name Aeon as the purchaser. Aeon wants to have this submitted by the end of March. Diehm said once the application is prepared, she wants to review a copy of it before it is sent out, so she requested it be forwarded to them at least two days prior to it being sent. Page 2 March 5, 2012 uestions from members: Nawrocki stated he doesn't like the language in the Resolution as he believes it commits the City to go through with the sale. He said he is not ready to commit to that since the final purchase price hasn't been determined yet. Diehm clarified the language issues to Nawrocki and told him it doesn't lock us in, just that we are supporting the process. Until there is a signed Purchase Agreement, either party can terminate at any time in the process. He wants it on record that he is not in favor of committing to the sale of Parkview until a sale price is negotiated in an acceptable amount. Schmitt said the Resolution language should be changed to say "low- income and disabled adults and seniors" (not just seniors). Motion by Peterson, seconded by Williams, to waive the reading of Resolution 2012 -03 there being ample copies available to the public. All ayes. MOTION PASSED. Motion by Peterson, seconded by Williams, to adopt Resolution 2012 -03 with changes as noted authorizing the HRA to submit application to HUD,for the disposition of Parkview Villa North. Ayes- Diehm, Schmitt; Williams, Peterson Nay - Nawrocki MOTION PASSED. RESOLUTION 2012 -03 COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY RESOLUTION AUTHORIZING THE HRA TO SUBMIT APPLICATION TO HUD FOR THE DISPOSITION OF PARKVIEW VILLA NORTH. WHEREAS the City of Columbia Heights Housing and Redevelopment Authority (hereafter "HRA ") currently owns Parkview Villa South, a 45 -unit residential building serving seniors; and WHEREAS, the HRA also owns Parkview Villa North, a 101 -unit high rise with Public Housing Authority designation serving low- income disabled adults and seniors; and WHEREAS, Parkview Villa North and Parkview Villa South, together called "Parkview Villa ", provide 146 units of affordable apartment homes in the City of Columbia Heights; and WHEREAS, Parkview Villa is the only property owned by the HRA; and WHEREAS, The HRA determined that it would be in the best interest of the property to transfer ownership to an entity that specializes in affordable housing rehabilitation, ownership, and management and has the capacity to effectively operate the buildings over the long -term; and WHEREAS, in Spring 2011 the HRA initiated a competitive selection process to identify a qualified affordable housing developer that would meet the following HRA goals for the sale of Parkview Villa: 1) Maintain the property as a strong and vibrant senior community; 2) Protect the existing rental price points for a pre - determined period of time; 3) Agree to a long -term covenant that requires the property to operate as a senior building; 4) Purchase the property at market price; and 5) Maintain a housing priority for Columba Heights residents; and WHEREAS, the HRA selected Aeon, a Minnesota 501(e)3 non -profit corporation, to own,rehabilitate, and manage Parkview Villa. Page 3 March 5, 2012 NOW THEREFORE BE IT RESOLVED, by the Columbia Heights HRA that the Authority expresses its support of the request to dispose of the Public Housing units with its accompanying relocation plan; and BE IT FURTHER RESOLVED, that the Executive Director is authorized to execute documents and provide certifications and submit to HUD for approval a request to dispose of the 101 unit Parkview Villa North, HUD project number MN 105000001. Passed this 5th day of March, 2012 Offered by: Peterson Seconded by: Williams Roll Call: ayes- Dichm, Schmitt, Peterson, & Williams Nay- Nawrocki Chair Shelley Hanson- Secretary 6. Update of Meeting regarding Notice to Residents- A meeting was held February 22i" to notify residents of the process for relocation, even if it is not needed. It is federally mandated to inform the residents and the language in the notice is cumbersome as written by HUD. Clark explained that many residents are still confused by the notice they received and the fact they have to sign a statement acknowledging receipt of the notice. Therefore, staff and Aeon are meeting with the residents again Tuesday, March 6 °i at noon to answer questions and alleviate any concerns they have. All residents have been personally notified of this meeting, as well as a notice being posted. Copies of the notice were given to the Board members in their packets. Clark told the members that the individual who sent the letter to the Board has not attended any of the meetings to date. Clark sent him a personal letter imploring him to attend the meeting on March 6a' so his misunderstandings can be addressed. Diehm said she felt the meetings were important and appreciates that Aeon is taking the time to explain the process to the residents. She asked to see a copy of the original notice that HUD required. Aeon will get that to Clark who will forward to each of the members. Diehm hopes that by appointing a member to the HRA from Parkview that some of these issues could be prevented. She understands that incorrect information can be very upsetting to some of the residents. Page 4 March 5, 2012 6. Discussion of PHA Representative Clark explained that the HRA has not had a PHA representative for over a year. The individual who was selected has been unable to serve and was never sworn in. Over the next month, staff will investigate filling the open position. If the individual cannot be sworn in at the April meeting, staff wants direction on whether the Board wants to select another candidate from the pool that was interviewed in 2011 or if they would like to restart the process. The goal is to have a selection by the April meeting. Comments from members: Diehm said she will contact the resident who was appointed last year to see if she is willing to serve and to be sworn in at the April meeting. If she is unable to do so, she is comfortable with appointing one of the other two applicants that were interviewed last year. Nawrocki agreed with Diehm and looks forward to appointing someone to fill the existing term at the April meeting. The next regular meeting will be Tuesday, April 24, 2012 at 7:00 pm at Parkview Villa. The meeting was adjourned at 8:40 pm. Respectfully submitted, Shelley Hanson Secretary COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) Meeting of: April 24, 2012 AGENDA SECTION: Consent Agenda ORIGINATING EXECUTIVE NO: 5 DEPARTMENT: HRA DIRECTOR APPRO AL ITEM: Financial Report and Payment of Bills BY: Laura Frost BY Alt 1/4 — Resolution 2012 -03 DATE: April 18, 2012 BACKGROUND: A copy of the Financial Reports for the months of January, February and March 2012 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 2012 -03, there being ample copies available to the public. Motion: Move to approve Resolution 2012 -03, Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills for the months of January, February and March 2012. zu'iz -us ana HRA ACTION: HRA RESOLUTION 2012 -03 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JANUARY, FEBRUARY, AND MARCH 2012 AND PAYMENT OF BILLS FOR THE MONTHS OF JANUARY, FEBRUARY AND MARCH, 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 HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the treasurer's vouchers or bills and if correct, resolution in its records; and HRA to examine the statement and to approve them by resolution and enter the WHEREAS, the financial statement for the months of January, February and March 2012 and the list of bills for the months January, February and March 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 24th day of April 2012. MOTION BY: SECONDED BY: AYES: Chair Attest by: Shelley Hanson, Secretary Parkview Villa Forth Financial Statement Overview March 2012 Revenue: Occupancy for the month of March 2012 was 100% occupied; Total Revenue was under budget amount (unfavorable). No Grant Income was recognized in the month of March Administrative Expenses: Administrative costs for the North were under budget (favorable). Other Renting Expenses were over budget (unfavorable), and reflect applicant screening needed due to turnover. Office Salary and Management fees are allocated incorrectly in February and March, however the total matches budget Office Supply expenses are under budget (favorable) Computer Equipment and Maintenance reflects credit from February over charge Legal Expenses was under budget (favorable). Telephone, Answering Service and Internet expenses are under budget (favorable). Utilities: Utilities Expenses are under budget (favorable), however, these are quarterly billings Electric was under budget (favorable) Gas was under budget (favorable) Water and Sewer were not invoiced in March Operatinz and Maintenance Expense (supplies): Operating and Maintenance Expenses are under budget (favorable). Janitor Contract expenses were under budget (favorable) Exterminating Contract is over budget (unfavorable) Maintenance Supplies is slightly over budget (unfavorable) Garbage and Trash are under budget (favorable); however, this is a quarterly billing Security Contract is under budget (favorable). Repairs Contract expenses were under budget (favorable) Elevator Maintenance Contract is under budget (favorable) Snow Removal is under budget (favorable). Decorating Contract and Supplies were under budget (favorable) Furniture and Fixtures is over budget (unfavorable) and reflects the replacement of 4 refrigerators, 4 ranges Z coos b O O 0 O D �m vNn o WboN � j ONOUI + N 0000 WOO +VI (n +NO AJZO NOWiJ U�AOm D A O O N O O wp. inv u O O O O O V 0 O J O O 0 O O O O O O O O W O p O O apses b b 00 00 N O 0 O W + U b N N ;I; S9900 m� 0 N OP+ IDW OI ONi N O P O P Y A O (A1JW J W Y O O O O E 0 m 10 e C 0 a 2 n d n� d C S A d + I N o X O o N00Ni V AN (Nil Wow °0 ooW +m�OO o mi°mo OO °o °oo�l� °oo m: m d3 n Maas �i moo Naameoo IOOJNOI i +N1lYN OW ONOOJ4WiN VOOVVioo p: aNOaJ � N IAmt N WN ON4WiN +IGN W000 O O A O W J N j 8 l J I m N o O P b O J O O O �fnTC Y. D 3.� m m c d OOd O�Da _. N m AOm OGI� A A� A q 0 m ^ z (� C N A N + A 'm o. ov°i0 - 000800 A a A+ aoaA.lo000om°no00 ion mdr'mm weowo0 i Z 1.2� �- cW i v AWn'. _ _.cc m °m 2.3' 00? WNW +(nNNNWN O`l -. N(NiI p0+4+ OJiW W W +OJOO(nY OIO T VO -.N -! OI OOi OViO l mm -nm -lo O N m O+ 1 mN J OmW NAIWiINN +bNWa j AO m NUi OO O(N1lJ JWWN +VA y'. O: llA+mo NWN NNm(n VAA�OJ�IAONPOOOOIOn qqN ppll N 7 m m� NH N P ? 0 2 F N o m m m m coos b O O 0 O D �m vNn o WboN � j ONOUI + N 0000 WOO +VI (n +NO AJZO NOWiJ U�AOm D A O O N O O wp. inv u O O O O O V 0 O J O O 0 O O O O O O O O W O p O O apses b b 00 00 N O 0 O W + U b N N ;I; S9900 m� 0 N OP+ IDW OI ONi N O P O P Y A O (A1JW J W Y O O O O E 0 m 10 e C 0 a 2 n d n� d C S A d + I N W A + O m Oma 00000 ONI N00Ni V AN (Nil Wow °0 ooW +m�OO o mi°mo OO °o °oo�l� °oo m: �. WNN�� +NO Maas �i moo Naameoo IOOJNOI i +N1lYN OW ONOOJ4WiN VOOVVioo p: aNOaJ � N N WN ON4WiN +IGN W000 O O A O W J N j 8 l J I coos b O O 0 O D �m vNn o WboN � j ONOUI + N 0000 WOO +VI (n +NO AJZO NOWiJ U�AOm D A O O N O O wp. inv u O O O O O V 0 O J O O 0 O O O O O O O O W O p O O apses b b 00 00 N O 0 O W + U b N N ;I; S9900 m� 0 N OP+ IDW OI ONi N O P O P Y A O (A1JW J W Y O O O O E 0 m 10 e C 0 a 2 n d n� d C S A d + I N m Oma 00000 (Nil (Nn WN W WP �. WNN�� +NO J_. A OW IOOJNOI i +N1lYN OW ONOOJ4WiN VOOVVioo p: aNOaJ � N O O A O W o o o o W W V S N o o N m N o O P b O J O O Z W Y. N O N D Ol O O J A+ N 0 0 0 A O O O 0 N A N + u °w 0o °o eao.Wn OlW.r -°•'u o. ov°i0 I 000800 A a A+ aoaA.lo000om°no00 ion Iw weowo0 i ' cW i v AWn'. w ... 0 WNW +(nNNNWN O`l -. N(NiI p0+4+ OJiW W W +OJOO(nY OIO T VO -.N -! OI OOi OViO l O N m O+ 1 mN J OmW NAIWiINN +bNWa j AO m NUi OO O(N1lJ JWWN +VA y'. O: llA+mo NWN NNm(n VAA�OJ�IAONPOOOOIOn qqN ppll N coos b O O 0 O D �m vNn o WboN � j ONOUI + N 0000 WOO +VI (n +NO AJZO NOWiJ U�AOm D A O O N O O wp. inv u O O O O O V 0 O J O O 0 O O O O O O O O W O p O O apses b b 00 00 N O 0 O W + U b N N ;I; S9900 m� 0 N OP+ IDW OI ONi N O P O P Y A O (A1JW J W Y O O O O E 0 m 10 e C 0 a 2 n d n� d C S A d + T ry o o A O 90 °Ei 'OO -3 O e � � c �' �v�" '^ o` �.y �a?1'0 p1'00 m non •' m � 3.w V.� =C _ 00 O ll N j j C i N� 9 O ✓ 'Q S '-` A °x of V N W N m V Q J�o O O N N + o O o (� V O A+ T. W O. m... X00 C1 O JJ � � . � � . � +mWO NN�OP N O O 100 O O O W N O O V N O O+ IOOd y N N O L W O� �W q + m o ' J +IJ 4a mNWNNN � O + + 4 +W VI 1Nli W W m N O VJ O m N W PP.. O m ONO W O O O � W m J 0 O W O J O J O W O O �1 J J N J O m W 0 N 1Ai1 J J O fJ +JNA +NdN +1+ >O1 �1i {n'1Nn W N 1010 d�mvi m�om�0 mWmm 10 +aN ulmm�`J'1n N- -Nm ?mw ,(Pn�'10 o 00 �W mm0 p A JOJJ +NOVW(11NOJ01A +JOWi VIWJ6 (�1' +A1 fn 00 O N mV1 6008 0 NObV0+1N0 A.1�2o OLiA ODD yO� C NN 'J+ p Y JA(o+ WOI fVnb TN0101i 41W D O O J ID N m A W O A )NO VNi A w N m W J Y .+ m O V N O V N J N 00 OO + W UI W IJN IJ W0W0 N N �OOtO .P+ NmiN OOJ(N11JOA +mNO N 1O m U1 1Jm A O LA 11N m NN V IJ PN -�U JiO ID m InmIIN V 1V11N J (NII 1D 10 1NliON 0 Wt0... 0000.OJ(n >U0100 VJ CN O. C� AO 1010 O00 V 00100 +.00+0000..0 41 1Nj1 °i W ID N i IJ INO � � p a O W W+.+W+N �+ W W NO�NO C�+IJN JIJ � O lY WG N 1 (VI1 1Jli O A V AA V b tA.1 N P V A A A (n W A NA N+ OA +�W �01N NmmJ +m 01N 1JJi 00 IJ V VI V'V AA IJ' +I O JtJ V IJ0 0< mN0 m106F - +Omm +bAN010DA ++ N1O 00 10 N OO m 10010 +OVVNDO•D 0m �J Obi O D p N N A N N N V P W A+ - W A N V m O W m W N W j O o .�JI)i+pNO y pm Vi °o 01 °o O O O M. 00AON00 O o 0 0 0 o O m ONO O v i 0 o bb °o IOIi c °o °0 W obbb000bbbbbbobb O N ° N ° �N oo m o 00 0 ............. OOOOO 00 O O O O 9 O O a 0 O O � z z DD D 0 S W o N O O O z 3 r r y o n D o 1 -1 m v W v pD -I 90 9 N m_ 0 W D y N z `- 4mi N H H �rm c 9 O 2 8 R v D y D c a c s n r m 00� O N N H GAAAA�' o b� O N a ti �O Z �9r na a�w �' WHO H �A ro a D�.�. ^ $D? (pne 00 O O O O 9 O O a 0 O O � z z DD D 0 S W o N O O O A J J N Z O O < aJ a :V I N [ a 5 o < IJ" 1 A -. 3 N a s p c o c mNm memo Ca V 000 OIO O O O O O O WW N N + W d 0 0 0 T W O zzz zzz DDD DDD nN o0 �wN 'n rnN O O O N N O P. z 3 n'D D D 0. A J J N Z O O < aJ a :V I N [ a 5 o < IJ" 1 A -. 3 N a s p c o c mNm memo Ca V 000 OIO O O O O O O WW N N + W d 0 0 0 T W O zzz zzz DDD DDD nN o0 �wN 'n rnN O O O N N O P. popp. POP 0. zzz zzz DDD D`DD 000 I w J 0 W', l w -- V o _ o y W, l G 00 2 A A 0 V V 0 W w W b mm G W (VJ d W W n 0 y� s N (Wn Ww O O.� C N N G A Y G � v � W y m a v W N N m - WW r. T m mu'Z C O m O O O O O O O O O O 6 m o om R m ..... 65m (n _a N N N N N lJ + G O; N VNI (Wli VI N G W ONi + � V J J O J A VI O O IJD ip A L N N VINO WW r. O m O O O O O O O O O O 6 ° ..... 65m (n _a N N N N N lJ + G O; N VNI (Wli VI N G W ONi + � V J J O J A VI O O IJD ip ZZ zzzzz �zG DDDDD D`Dm O N O N NI1�N00 AL N. s W o N �O_: N O 0 0 O O O O U O 000 J N: lS lU 0 W W O N N J N O 00 N NN(n00 AA0 z z z Z Z z G N D.D DD D DDDDD DD, n D A D N 9 p + O O O O O 0000 00 C .1. d L Parkview Villa -North (165) Balance Sheet March 2012 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 1.3200 Due From Other Government Units Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Liabilities Fund Balance 25300 Fund Balance Total Fund Balance Total Liabilities and Fund Balance Mar -12 52,857.53 664.00 988,425.08 263.00 83.00 21,651.03 1,063,943.64 18,335.57 5,225.25 551.74 17,959.89 27,754.54 461.00 70,287.99 993,655.65 993,655.65 1,063,943.64 Pat kview Villa -North (165) Income Statement For The Period Ending March 2012 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 Month to Date Year to Date 1 - 0.00% - 0.00% 29,900.00 97.30% 86,220.00 96.58% 352.00 1.15% 1,024.00 1.15% 478.25 1.56% 2,030.63 2.27% - 0.00% - 0.00% 30,730.25 100.000/0 89,274.63 100.000/0 1000 -46330 Accrued Salaries 9,147.60 29.77% 25,861.60 Total Personal Services 9,147.60 29.770/a 25,861.60 Supplies 2000 -46330 Office Supplies -811.90 -2.64% 598.67 2010 -46330 Minor Equipment 3,774.00 12.28% 3,774.00 2160 -46330 Maint. & Construct Materials 891.61 2.90% 2,500.25 2171 -46330 General Supplies 337.97 1.10% 876.08 Total Supplies 4,191.68 13.64% 7,749.00 Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00°70 0.00 3050 -46330 Expert and Professional Services 0.00 0.00% 0.00 3060 -46330 Management Services 4,353.50 14.17% 14,089.50 3100 -46330 Protective Services 0.00 0.00% 3,667.00 3210 -46330 Telephone & Telegraph 480.70 1.56% 1,049.43 3430 -46330 Advertising Other 0.00 0.00% -94.05 3600 -46330 Insurance & Bonds 1,741.75 5.67% 5,225.25 3810 -46330 Electric 3,496.50 11.38% 6,091.18 3820 -46330 Water 0.00 0.00% 0.00 3830 -46330 Gas 3,816.59 12.42% 8,683.98 3840 -46330 Refuse 279.21 0.91% 355.77 3850 -46330 Sewer 0.00 0.00% 0.00 4000 -46330 Repair & Maint. Services 2,713.96 8.83% 9,069.81 4050 -46330 Garage, Labor Burd. 161.15 0.52% 161.15 4100 -46330 Rents & Leases 186.75 0.61% 253.50 4300 -46330 Miscellaneous Charges 0.00 0.00% 25.00 4315 -46330 PILOT 1,850.30 6.02% 5,550.90 4390 -46330 Taxes & Licenses 0.00 0.00% 1,243.38 4500 -46330 Administrative Expenses - 100.80 -0.33% 6,804.64 4850 -46330 Interest on Deposits 13.79 0.04% 40.14 Total Other Services & Charges Capital Outlay 5120 -46330 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 950.14 3.09% 1,773.35 1.990/0 33,282.82 108.31% 97,600.53 109.330/a - 2,552.57 - 8.31% - 8,325.90 -9.33% 7 18,993.40 950.14 61.81% 0.00% 62,216.58 1,773.35 69.69% 1.99% 950.14 3.09% 1,773.35 1.990/0 33,282.82 108.31% 97,600.53 109.330/a - 2,552.57 - 8.31% - 8,325.90 -9.33% 7 Parkview Villa -North (165) Cash Flow Statement Period = March 2012 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 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, tabor 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,900.00 352.00 478.25 0.00 30,730.25 9,147.60 9,147.60 - 811.90 3,774.00 0.00 1,229.58 0.00 4,191.68 0.00 4,353.50 0.00 480.70 0.00 1,741.75 3,496.50 0.00 3,816.59 279.21 0.00 2,713.96 161.15 186.75 0.00 1,850.30 0.00 - 100.80 13.79 950.14 19,943.54 33,282.82 - 2,552.57 ■ Parkview Villa -North (165) Cash Flow Statement Period = March 2012 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 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 - 207.00 165,000.00 162.00 92.00 372.80 - 5,498.78 1,741.75 13.79 1,850.30 - 263.00 (166,736.14) (169,288.71) Beg Cash End Cash Difference 222,146.24 52,857.53 (169,288.71) 457.00 664.00 (207.00) 823,425.08 988,425.08 165,000.00 1,046,028.32 1,041,946.61 (4,495.71) 4/16/2012 3:54 PM General Ledger (Accrual) Paikvievv Villa -North - (165) Months: Mar 2012 Property Data Period Description Control Refer Debit Credit Balance Remarks 1000 -46330 Accrued Salaries 16,714.00 = Beginning Balance = 165 313112012 03/12 (:Recur 339) :PoslRecurring Month [- 3 - 133241 RC 8,357.00 25,071.00 WC CHIC PR Mgmt Fee 165 3/3112012 03/12 Adj and reallocate 2 -3/12 mg 3- 133995 :Reversed by 790.60 25,861.60 Adj and reallocate 2 -3112 mg NetChange= 9,147.60 25,861.60 = Ending Balance = 2000 -46330 Office Supplies 1,410.57 = Beginning Balance = 165 2122/2012 03/12 (offiBB04) Office Depot P -271072 5.96839E +ll 8.29 1,418.86 battery pk 165 2124/2012 03/12 (offiBB04) Office Depot P 272564 5.99436E +11 186.67 1,605.53 pens, shredder etc. 165 3/912012 03/12 (offiBB04) Office Depot P 273838 6.01382E +11 37.64 1,643.17 paper 165 3/14/2012 03/12 (chc) CommonBond Housing P- 272493 936636 9.46 1,652.63 on time delivery 02/12 165 3/21/2012 03/12 (offiBB04) Office Depot P- 274396 6.02616E +11 26.16 1,678.79 envelopes 165 3/27/201203/12 (chc) CommonBond Housing P- 274315 940918 1.55 1,68034 Postage 03/12 165 3/31/2012 03/12 Rev CHIC Comp Support billing 1- 133990 :Reversed by 1,081.67 598.67 Rev CHIC Comp Support billing NetChange= - 811.90 598.67 = Ending Balance = 2010 -46330 Minor Equipment 0.00 = Beginning Balance = 165 3/21/2012 03/12 (all) All Inc. P- 274780 51200201.001 3,774.00 3,774.00 fings(4), ranges (4) etc. NetChange= 3,774.00 3,774.00 = Ending Balance = 2160 -46330 Malnt. & Construct Materials 1,608.64 = Beginning Balance = 165 1/5/2012 03/12 (home7) HD Supply Facilities MaintE P- 271071 9/12756707 229.31 1,837.95 filter, tap gear 165 2/14/2012 03/12 (home32) Home Depot Credit Servl( P- 271068 5595107 106.38 1,944,33 kit faucet had, basscmft 165 2/24/2012 03/12 (home7) HD Supply Facilities Maink P- 271069 9113670130 91.05 2,035.38 angle stop, range hood etc. 165 2/28/2012 03/12 (wiim) Wilmar P- 272565 261575492 56.69 2,092.07 wrench, angle stop etc. 165 3/6/2012 03/12 (home7) HD Supply Facilities Maine P- 273295 9113858041pv 14.48 2,106.55 ice melt, pkg twist -n -lacks 165 3/12/2012 03/12 (home32) Home Depot Credit Semi( P-274397 821 27.87 2,134.42 vinyl tile, washers etc. 165 3/15/2012 03/12 (parki) Park Supply of America, Inc P- 273839 40746400 41.07 2,175.49 self tap screw 165 3/22/2012 03/12 (home7) HD Supply Facilities Malntc P- 274783 9114164643pv 324.76 2,500.25 bulbs etc. NetChange= 891.61 2,500.25 = Ending Balance = 2171-46330 General Supplies 538.11 = Beginning Balance = 165 3/9/2012 03/12 (home7) HD Supply Facilities Maintc P- 273285 9113932796pv SBb2 596.73 towels, gloves etc. 165 3/2112012 03112 (home7) HD Supply Facilities r intE P- 274782 911414481 68.02 664.75 cleaning prod 165 3121/2012 03112 (sher4110) Sherwin - Williams Co. P- 275409 78594 149.23 813.98 paint 165 3/23/2012 03/12 (peat) Peachtree Business Products P- 274779 P26632030001 62.10 876.08 Flags NetChange= 337.97 876.08 = Ending Balance = 3060 -46330 Management Services 9,736.00 = Beginning Balance = 165 313012012 03/12 (chc) CommonBond Housing P- 274931 941335 13,548.00 23,284.00 mgmt fee 03112 165 3/31/2012 03/12 (:Recur 339) :PostRecuning Monlhl)- 133241 RC 8,357.00 14,927.00 R/C CHC PR Mgmt Fee 165 3/31/2012 03/12 Adj and reallocate 2 -3112 mg 3- 133995 :Reversed by 837.50 14,089.50 Adj and reallocate 2-3/12 mg NetChange= 4,353.50 14,089.50 = Ending Balance = 3100 -46330 Protective Services 3,667.00 = Beginning Balance = NetChange= 0.00 31667.00 = Ending Balance = 3210 -46330 'telephone & Telegraph 568.73 = Beginning Balance = 165 1/18/201203/12 (of86S8) Office of Enterprise Techm P- 271074 W111206BI112 132.17 700.90 phone svc- per end 12 /31/11 165 3/1/2012 03/12 (leve) Level One P- 272560 229214 -INpvn 93.43 794.33 answ svc - set up fees 3/12 165 3/2/2012 03/12 (comc3474) Comcast P- 272108 8.77211E +11 49.99 844.32 Internet svc 3/11 -4/10 165 3/7/2012 03/12 (cent9115) Centuryl-ink P- 272750 7637083978/0 38.90 883.22 phone svc - due 3124 165 3/1112017 03112 (mcic3718) MCI Comm Service P- 273837 7637883978pv 32.74 915.96 ph 2113 -3/8 165 3/21/201203/12. (offi658) Office of Enterprise Techm P- 274398 200800187/02 133.47 1,049.43 phone svc - Per end 2 /29/12 NetChange= 480.70 1,049.43 = Ending Balance = 3430 -46330 Advedising Other (94.05) = Beginning Balance = NetChanye= 0.00 (94.05) = Ending Balance = 3600 -46330 Insurance & Bonds 3,483.50 = Beginning Balance = 165 3/31/201203/12 (:Recur 339):Posteecuning Monthh3- 133241 RC 1,741.75 5,225.25 C of Columbia Heights Ins Ac NetChange= 1,741.75 5,225.25 = Ending Balance = 3810 -46330 Electric 2,594.68 = Beginning Balance = 165 3/12/2012 03/12 (xce0 %cel Energy P- 273049 5150441553/0 3,496.50 6,091.18 elec svc 2/06 -3/06 NetChange= 3,496.50 6,091.18 = Ending Balance = 3830 -46330 Gas 4,86739 = Beginning Balance = 165 3/7/2012 03112 (cent) CenterPoint Energy P- 272248 55199657/021 3,816.59 8,683.98 gas svc 2/03 -3/06 NetChange= 3,816.59 8,683.98 = Ending Balance = 1 Page 1 General Ledger (Accrual) Parkview Villa -North - (165) Months: Mar 2012 Property Date Period Description Control Refer 3840 -46330 Refuse 355.77 trash Svc -03/02 165 312/2012 03/12 Qpolll Green Lights Recycling I 272763 12- 2084pvn 50.86 6,406.71 angle stop, range hood etc. NetChange= 279,21 6,463.64 sanding 2/28 4000 -46330 Repair & point. Services 65.55 165 2/24/2012 03112 (home7) HD Supply Facilities Mains P- 271069 9113670130 165 2/28/2012 03/12 (mgsp) MGS Professional Bldg Maim P- 272563 10396pvn 165 3/t/2012 03/12 leapt l) Eagle Elevator Corp. P-272757 113297 -Ipvn 165 3/3/2012 03/12 (a9sp)PIGS Professional Bldg Malnl P- 272562 10403pvn 165 3/3/2012 03/12 (mgsp) MG5 Professional Bldg MaInl P -272561 10419pvn 165 3/6/2012 03112 (dire) Direct Home Appliance Servlo P- 272752 030612pm 165 3/6/2012 03/12 (home7) HD Supply Facilities Maints P- 273295 9113858041pv 165 3/15/2012 03/12 RmI7740) Drain King, Inc. P- 275408 83633 165 3/1612012 03/12 (adam) Adam's Pest Control, Inc. P- 275406 707162 165 3119/2012 03/12 (adam) Adam's Pest Control, Inc. P- 275403 702932pvn 165 3/26/2012 03/12 (arbo) Arbor Barber, Inc. P- 274781 32612 165 3/27/2012 03/12 (cust5044) Custom Appliance Servlc P- 275407 8462 6,905.44 = Beginning Balance = 100.80 NetChange= 2,713.96 4050 -46330 Garage, Labor Boni. 13.79 165 3/2712012 03/12 (sign6160) Signs By RSG P- 275410 696pva 823.21 = Beginning Balance = 950.14 NetChange= 161.15 4100-46330 Rents & Leases 165 2/29/2012 03112 (mutt]) Multihousing Credit Control P- 273296 1202037/ 165 3/20/2012 03112 (chc) CommonBond Housing P- 273378 937075 NetChange= 186.75 4300 -46330 Miscellaneous Charges NetChange= 0.00 4315 -46330 PILOT 165 3131/2012 03/12 (a Recur339): PostRecurring Manthil- 133241 RC NetChange= 1,850.30 4390 -46330 Taxes & Licenses NetChange= 0.00 4500_46330 Administrative Expenses 165 12/31/2011 03/12 (10004027) Teague C- 937046 NetChange= - 100.80 4850 -46330 Interest on Deposits 165 3131/2012 03/12 Sec Dep interest accrual 3- 133243 G31 NetChange= 13.79 5120 -46330 Building & Improvement 165 3/19/2012 03/12 (wait) WAI Continuum P- 275411 11120 NetChange= 950.14 4/16/2012 3:54 PM Debit Credit Balance Remarks 76.56 = Beginning Balance = 278.21 355.77 trash Svc -03/02 355.77 = Ending Balance = 6,355.85 = Beginning Balance = 50.86 6,406.71 angle stop, range hood etc. 56.93 6,463.64 sanding 2/28 688.17 7,151.81 me malat -03112 65.55 7,217.36 snow ni 2/29 86.25 7,303.61 snow Ravi 3/01 84.00 7,387.61 washer repair 35.07 7,422.68 ice melt, pkg Nrisl -n -locks 215.00 7,637.68 plbg Svc -315 910.56 8,546.24 pest svc 3116 98.97 8,597.21 pest svc 3/19 295.32 8,892.53 om part per est - tree rmvl 177.28 9,069.81 oven we - 709 9,069.81 = Ending Balance = 0.00 = Beginning Balance = 161.15 161.15 bulbs, svc call 161.15 = Ending Balance = 66.75 = Beginning Balance = 180.00 246.75 bckgrnd cks 2/12 6.75 253.50 1 aix emply verif 02/12 253.50 o Ending Balance = 25.00 = Beginning Balance = 25.00 = Ending Balance = 3,700.60 = Beginning Balance = 1,850.30 5,55090 Anoka Cry Property Tax Accra 5,550.90 = Ending Balance = 1,243.38 = Beginning Balance = 1,243.38 = Ending Balance = 6,905.44 = Beginning Balance = 100.80 (1D0.80) Rev bad debt write off duet 6,804.64 = Ending Balance = 26.35 = Beginning Balance = 13.79 40.14 Sec pep interest accrual 40.14 = Ending Balance = 823.21 = Beginning Balance = 950.14 950.14 aKhttlactural rvc, to 03/18 1,773.35 = Ending Balance = 43,659.79 10,376.97 Page 2 5016456 Parkview Villa North 4/9/12 Bank Reconciliation Report 03/31/2012 Balance Per Bank Statement as of 03/31/2012 $53,744.88 02/09/2011 1199 court325 - Court Administration 55.00 02/09/2011 1200 coud325 - Court Administration 320.00 03121/2012 1640 dire - Direct Home Appliance Services 84.00 03121/2012 1644 mgsp - MGS Professional Bldg Maint Sery Inc 208.73 03/28/2012 1649 home7 - HD Supply Facilities Maintenance 108.17 03/28/2.012 1650 mcic3718 - MCI Comm Service 32.74 03/28/2012 1652 off i8804 - Office Depot 37.64 03/28/2012 1653 park/ - Park Supply of America, Inc. 41.07 Less: Outstanding Checks 1616 $887.35 48.97 Reconciled Bank Balance $52,857.53 Balance per GL as of 03/31/2012 chc - CommonBond Housing $52,857.53 Reconciled Balance Per G/L $52,857.53 Difference 0.00 Cleared Items: Cleared Checks Date Tran # Notes Amount Date Cleared 12/22/2011 1545 t0004004- Alunovic 120.55 03/3112012 02115/2012 1607 mgsp - MGS Professional Bldg Mainl Sew Inc 65.55 03131/2012 02/23/2012 1611 cent - CenterPoint Energy 4,86739 03/31/2012 02/23/2012 1614 park1 - Park Supply of America, Inc. 144.04 03131/2012 03101/2012 1616 adam - Adam's Pest Control, Inc. 48.97 03/31/2012 03101/2012 1617 chc - CommonBond Housing 1,118.33 03/31/2012 03/01/2012 1618 colu - City of Columbia Heights 6,303.75 03131/2012 03/01/2012 1619 colu825 - Columbia Heights Fire Dept 1,243.38 03/31/2012 03/01/2012 1620 eagll - Eagle Elevator Corp. 543.00 03/31/2012 03/01/2012 1621 mcic3718 - MCI Comm Service 24.83 03/31/2012 03/0112012 1622 multi - Mullihousing Credit Control 60.00 03/31/2012 03/0112012 1623 of J8804 - Office Depot 70.57 03/31/2012 03/07/2012 1624 buck8411 - Buckeye Cleaning Centers 84.33 03/31/2012 03/07/2012 1625 cent9115 - Centuryl-ink 38.90 03/31/2012 03/07/2012 1626 chc - CommonBond Housing 13,548.00 03/31/2012 03/07/2012 1627 cus15044 - Custom Appliance Service LLC 177.32 03/31/2012 03/07/2012 1628 drai7740 - Drain King, Inc. 135.00 03/31/2012 I I5 4/9/12_ Parkview Villa North Bank Reconciliation Report 03/31/2012 5016456 03/07/2012 1629 mgsp - MGS Professional Bldg Maint Sew Inc 65.55 03131/2012 03/07/2012 1630 offi658 - Office of Enterprise Technology 136.88 03131/2012 03107/2012 1631 waic - WAI Continuum 235.54 03/31/2012 03/1412012 1632 cent - CenterPoint Energy 3,816.59 03/31/2012 03/14/2012 1633 comc3474 - Comcast 49.99 03/31/2012 03114/2012 1634 home32 - Home Depot Credit Services 106.38 03/31/2012 03/14/2012 1635 home7 - HD Supply Facilities Maintenance 371.22 03/3112012 03/14/2012 1636 offi658 - Office of Enterprise Technology 132.17 03/31/2012 03/14/2012 1637 offi8804 - Office Depot 8.29 03/3112012 03/2112012 1638 cent9115- CenturyLink 38.90 0313112012 03/21/2012 1639 chc - CommonBond Housing 1,254.42 03/31/2012 03/2112012 1641 eagll - Eagle Elevator Corp. 688.17 03/31/2012 03/21/2012 1642 gree1004 - Green Lights Recycling Inc 279.21 03/3112012 03/21/2012 1643 love - Level One 93.43 03131/2012 03/2112012 1645 offi8804 - Office Depot 186.67 03/3112012 03/21/2012 1646 wilm - Wilmar 56.69 03/31/2012 03/21/2012 1647 xcel - Xcel Energy 3,496.50 03/31/2012 03128/2012 1648 chc - CommonBond Housing 378.23 03/31/2012 03/28/2012 1651 multi - Multihousing Credit Control 180.00 03/31/2012 Total $40,168.74 Cleared Deposits Date Tran # Notes Amount Date Cleared 03/02/2012 384 operations 19,532.00 03131/2012 03/0612012 385 operations 9,874.00 03131/2012 03/08/2012 386 operations 429.00 03/31/2012 03/09/2012 387 operations 236.25 03/31/2012 03/13/2012 388 operations 380.80 0313112012 03/16/2012 389 operations 370.00 03131/2012 Total $30,822.05 Cleared Other Items Date Tran # Notes Amount Date Cleared 03/14/2012 JE 133245 NEB transfer to City investment - 165,000.00 03/3112012 0313112012 JE 133244 NEB ei-OCCS Capital Fund Prog rec 372.80 03131/2012 Total - $164,627.20 I5 4/9/12_ Date 3/30/12 Page 1 Primary Account @XXXXX @6456 Enclosures 42 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 - - -- EFFECTIVE MAY 1, ALL AUTOMATIC FUNDS TRANSFERS (AFTS) WILL REDUCE YOUR AVAILABLE BALANCE AT THE START OF BUSINESS DAY ON THE SCHEDULED TRANSFER DATE. II' YOUR TRANSFER IS SCHEDULED FOR A MONDAY, THIS WILL AFFECT YOUR AVAILABLE BALANCE ON THE WEEKEND OR HOLIDAY. EARLY ACCOUNT CLOSING FEE OF $20 FOR HEALTH SAVINGS ACCOUNTS CLOSED PRIOR TO 3 MONTHS. NORTHEAST PUBLIC FUNDS ACCT Number of Images 42 Account Number @XXXXX @6456 Statement Dates 3/01/12 thru 3/31/12 Previous Balance 227,718.77 Days in the Statement Period 31 7 Deposits /Credits 31,194.85 Average Ledger 134,206 37 Checks /Debits 205,168.74 Average Collected 132,348 Service Charge .00 Interest Paid .00 Ending Balance 53,744.88 Deposits and Credits Date Description Amount 3/02 DDA REGULAR DEPOSIT 19,532.00 3/07 DDA REGULAR DEPOSIT 9,874.00 3/08 DDA REGULAR DEPOSIT 429.00 3/09 DDA REGULAR DEPOSIT 236.25 3/13 MISC PAY HUD TREAS 303 372.80 CR 3031036218 03/1.3/12 ID #- 411269646860103 TRACE 4- 031036210104343 3/13 DDA REGULAR DEPOSIT 380.80 3/16 DDA REGULAR DEPOSIT 370.00 Charges and Debits Date Description 3/1.4 Xfer to 0009 HRA OF CH SVGS Amount 165,000.00 Date 3/30/12 Page 2 Primary Account 9XXXXX @6456 Enclosures 42 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 3/07 2 60.00 3/15 1630 136.88 3/05 1545* 120.55 3/14 1.631 235.54 3/21 1607* 65.55 3/21 1.632 3,816.59 3/01 1611* 4,867.39 3/22 1633 49.99 3/02 1614'" 144.04 3/20 1634 106.38 3/06 1616* 48.97 3/20 1635 371.22 3/05 1617 1,118.33 3/23 1636 132.17 3/08 161.8 6,303.75 3/23 1637 8.29 3/09 1619 1,243.38 3/27 1638 38.90 3/06 1620 543.00 3/26 1639 1,254.42 3/13 1621 24.83 3/26 1641* 688.17 3/16 1623* 70.57 3/30 1642 279.21 3/13 1624 84.33 3/30 1643 93.43 3/13 1.625 38.90 3/30 1645* 186.67 3/09 1626 13,548.00 3/26 1646 56.69 3/26 1627 177.32 3/26 1647 3,496.50 3/1.2 1628 135.00 3/30 1648 378.23 3/21 1629 65.55 3/30 1651* 180.00 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date - Balance 3/01 222,851.38 3/12 229,657.61 3/22 60,714.88 3/02 242,239.34 3/13 230,263.15 3/23 60,574.42 3/05 241,000.46 3/14 65,027.61 3/26 54,901.32 3/06 240,408.49 3/15 64,890.73 3/27 54,862.42 3/07 250,222.49 3/16 65,190.16 3/30 53,744.88 3/08 244,347.74 3/20 64,712.56 3/09 229,792.61 3/21. 60,764.87 * * * F. N D O F S T A T E M E N T 1.17 Payment Summary Bank= 1650pr AND mm /yy= 03/2012 - 03/2012 AND Check Date = 03/01/2012 - 03/31/2012 AND All Checks =Yes AND Include Voids =All Checks 6 Check Post Total Date Bank Check# Vendor Date Month Amount Reconciled 165opr - Parkview Villa North 1616 Adam - Adam's Pest Control, Inc. 03/01/2012 03/2012 48,97 03/31/2012 165opr- Parkview Villa North 1617 chc - Common Bond Housing 03/01/2012 03/2012 1,118.33 03/31/2012 165opr - Parkview Villa North 1618 coiu - City of Columbia Heights 03/01/2012 03/2012 6,303.75 03/31/2012 165opr - Parkview Villa North 1619 coh -825 - Columbia Heights Fire Dept 03/01/2012 03/2012 1,243.38 03/31/2012 165opr Parkview Villa North 1620 eagll - Eagle Elevator Corp. 03/01/2012 03/2012 543 03/31/2012 165opr - Parkvlew Villa North 1621 mcic3718 - MCI Comm Service 03/01/2012 03/2012 24.83 03/31/2012 165opr - Parkview Villa North 1622 multi - Multihousing Credit Control 03/01/2012 03/2012 60 03/31/2012 165opr - Parkview Villa North 1623 offi8804 - Office Depot 03/01/2012 03/2012 70.57 03/31/2012 165opr- Parkview Villa North 1624 buck8411 - Buckeye Cleaning Centers 03/07/2012 03/2012 84.33 03/31/2012 165opr - Parkview Villa North 1625 cem9115 - CenturyLink 03/07/2012 03/2012 38.9 03/31/2012 165opr- Parkview Villa North 1626 chc- Common Bond Housing 03/07/2012 03/2012 13,548.00 03/31/2012 165opr- Parkview Villa North 1627 cust5044 - Custom Appliance Service LLC 03/07/2012 03/2012 177.32 03/31/2012 165opr- Parkview Villa North 1628 drai7740 - Drain King, Inc. 03/07/2012 03/2012 135 03/31/2012 165opr - Parkview Villa North 1629 mgsp - MGS Professional Bldg Point Sery Inc 03/07/2012 03/2012 65.55 03/31/2012 165opr - Parkview Villa North 1630 offi658 - Office of Enterprise Technology 03/07/2012 03/2012 136.88 03131/2012 165opr- Parkview Villa North 1631 wale - WAI Continuum 03/07/2012 03/2012 235.54 03/31/2012 165opr- Parkview Villa North 1632 cent- CenterPoint Energy 03/14/2012 03/2012 3,81659 03/31/2012 165opr- Parkview Villa North 1633 comc3474 - Comcast 03/14/2012 03/2012 49.99 03/31/2012 165opr - Parkview Villa North 1634 home32 - Home Depot Credit Services 03/14/2012 03/2012 106.38 03/31/2012 165opr- Par kvlew Villa North 1635 home7 - I ID Supply Facilities Maintenance 03/14/2012 03/2012 371.22 03/31/2012 165opr Parkview Villa North 1636 offi658 - Office of Enterprise Technology 03/14/2012 03/2012 132.17 03/31/2012 165opr - Parkview Vila North 1637 offi8B04 - Office Depot 03/14/2012 03/2012 8.29 03/31/2012 165opr Parkview Villa North 1638 cent9115 - CenturyLink 03/21/2012 03/2012 38.9 03/31/2012 165opr - Parkview Villa North 1639 chc - Common Bond Housing 03/21/2012 03/2012 1,254.42 03/31/2012 165opi - Parkview Villa North 1640 dire - Direct Home Appliance Services 03/21/2012 03/2012 84 165opr- Parkview Villa North 1641 eagit - Eagle Elevator Corp. 03/21/2012 03/2012 688.17 03/31/2012 165opr- Parkview Villa North 1642 gree1004 - Green Lights Recycling Inc 03/21/2012 03/2012 279.21 03/31/2012 165opr- Parkview Villa North 1643 [eve - Level One 03/21/2012 03/2012 93.43 03/31/2012 165opr Parkview Villa North 1644 mgsp - PIGS Professional Bldg Paint Sery Inc 03/21/2012 03/2012 208.73 165opr - Parkview Villa North 1645 ofO8B04 - Office Depot 03/21/2012 03/2012 186.67 03/31/2012 165opr - Parkview Villa North 1646 wllm - Wllmar 03/21/2012 03/2012 56.69 03/31/2012 165opr- Parkview Villa North 1647 xcel- Xcel Energy 03/21/2012 03/2012 3,496.50 03/31/2012 165opr- Parkview Villa North 1648 chc - Common Band Housing 03/28/2012 03/2012 378.23 03/31/2012 165opr- Parkview Villa North 1649 home7 - HD Supply Facilities Maintenance 03/28/2012 03/2012 108.17 165ofer - Parkview Villa North 1650 mcic3718 - MCI Comm Service 03/28/2012 03/2012 32.74 165opr- Parkview Villa North 1651 multi - Multihousing Credit Control 03/28/2012 03/2012 180 03/31/2012 165opr - Parkview Villa North 1652 offl8804 - Office Depot 03/28/2012 03/2012 37.64 165opr - Parkvlew Villa North 1653 parkl - Park Supply of America, Inc. 03/28/2012 03/2012 41.07 35,483.56 6 Parkview Villa South Financial Statement Overview March 2012 Revenue: Occupancy for the month of March was 93 % occupied Total Revenue was slightly lower than budget amount (unfavorable) Administrative Expenses: Administrative costs for South are over budget (unfavorable) Office Salaries and Management Pees were not allocated correctly, but total amount is correct per budget Advertising costs were over budget (unfavorable) and reflect the cost of ad for available units Office Supplies were under budget (favorable) There were no Legal Expenses billed out for March. Telephone, Answering Service and Internet expenses are over budget (unfavorable) and reflect payment of invoices from January and February Utilities: Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing Electric was under budget (favorable) Gas was over budget (unfavorable) Water and Sewer were not unvoiced this month Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable) Janitor and Cleaning Contracts was under budget (favorable) IG Exterminating Contract was under budget (favorable) Garbage and Trash Removal are under budget (favorable); however this is a quarterly billing and the amount billed is for recycling only Repairs Material and Contract costs were under budget (favorable). Grounds Contract is over budget (unfavorable) due to tree removal Elevator Contract is over budget (unfavorable) and reflects the cost of repair service Snow Removal costs were under budget (favorable) Heating and Cooling Maint and Repairs was under budget (favorable) Parking Lot Maint /Repairs was over budget (unfavorable) and reflects the cost of replacing light bulbs in the parking lot and the lift truck Decorating contract costs were over budget (unfavorable), and reflect cost associated with carpet installation, painting and repairs to restored unit 2 v V O a'OZd O] ANAA rv� C _ Nw S T m m c "� o�'°�" m F�310�<�8 m �d m ry N 3' T Fi EC q m o N N A x? N m x N O F z 8 ,� a N O p A O N m O m m 0 0 0 0 O O 0 0 0 0 V N O O N O N N O N d W N O A + .a OI (J �T ONi ONi b b + N➢ ~O b N Q N m A N J'� � b OOJJOW O o O m d m NNOiN Ip. NOm N (O NW 6 W NJO(JIiO mW� 00000 AmON(wJWN�l 1wJOWUIO w NmNOm �. UmjmOOO A >'J -P m r v r N e °o °Om °o v`.'OO °o °P �o +DOO W Wm➢ n Om J N N O J J (J A W O O V m O O J O O O O JON m .M1 W 0 0 J W J W b O A 0 .......... Jw �"` J Jt,Nli n+ 00000 +N Ooi (OA INIiNNJm� +OOWN P G � o 'O' NOO O'UNi 'O .Pm ➢'UJ ��D O ^I A" m0 +O(n0 m m�OW .� 00 00 Ui �D PID m! �o Jm O pm�aommo- +u,omJmN �o�nm (� N O (JJ N O N 0 A mip W W O O + O O+ O O J + N N Z m O !J N J N m ONO A w N+ N 0 0 0 O Oml JN O O W N N O� D W 9 ONI N w A i O D �j 4� INJ om� N N +NN N'J AN N A AN O O 0➢ N 0 O O A VIOA w oO wOONO , 9jO°o °0000 °oo °P °. P° N o OPOPO o..O o 00 V N J N N � m m VWl 0 CJ W N J V A O W O O 0 O Q D TR � N O V � 0 f°l1 A4 000 NOAib p W W fJ p'p O 7 O W fWJ J J O I l8il }tln0 h C MU J A N I[al A Y A IWO N mw um °ou a N oo a N A U W O V + OI N N W W 3 O J Jw JW q a O N a N.N N m NN W W _V p� - V1 Ili 41 y N O o Wbtl �3 n3�lo N? W= N� J N N O A � VI VN O ._-Nemvp � � W W p+ U > N J N N � m m VWl 0 CJ W N J V A O W O O 0 O Q D TR � N O J V ti _ _ O O W O O A O W O W O O A A O O b d ~V O p INiI O O O W° o O O W P O m J W � yG N d NNPN +mNbNOWa(Wli >JN (1 OWOOOIW (ll °J mNUJiWNJOL m Y N J OD N J W a W J O IO N O b D s N N v v O 41JN bNNN W OOI (n NA W O OOD - CO 0 >ONO 6 °on °o °o °o liOO �o� °om� °OO °om m �JipNNW +(NIIN +NAOAJW m A NN0 OWi OIm OOONNWN �+DI°OVTDJOP OI (NJDOONNObm O1 +1D N-�NWN WOr OIN 0000000 Nin +'o blo'O°'vb D . ONINl�Ol00 O � V � � f°l1 A4 000 NOAib N fJ p'p O +W O W fWJ J J O I l8il }tln0 h C MU J A N I[al A Y A IWO N mw um °ou a N oo a N A U W O V + OI N N W W OI W J Jw JW W N J ONCo N NN W W _V p� - V1 Ili 41 W O N O J J N N O A � VI VN O J V ti _ _ O O W O O A O W O W O O A A O O b d ~V O p INiI O O O W° o O O W P O m J W � yG N d NNPN +mNbNOWa(Wli >JN (1 OWOOOIW (ll °J mNUJiWNJOL m Y N J OD N J W a W J O IO N O b D s N N v v O 41JN bNNN W OOI (n NA W O OOD - CO 0 >ONO 6 °on °o °o °o liOO �o� °om� °OO °om m �JipNNW +(NIIN +NAOAJW m A NN0 OWi OIm OOONNWN �+DI°OVTDJOP OI (NJDOONNObm O1 +1D N-�NWN WOr OIN 0000000 Nin +'o blo'O°'vb D . ONINl�Ol00 O � � NOAib fJ p'p O +W V Nmin I l8il }tln0 h C MU J J V ti _ _ O O W O O A O W O W O O A A O O b d ~V O p INiI O O O W° o O O W P O m J W � yG N d NNPN +mNbNOWa(Wli >JN (1 OWOOOIW (ll °J mNUJiWNJOL m Y N J OD N J W a W J O IO N O b D s N N v v O 41JN bNNN W OOI (n NA W O OOD - CO 0 >ONO 6 °on °o °o °o liOO �o� °om� °OO °om m �JipNNW +(NIIN +NAOAJW m A NN0 OWi OIm OOONNWN �+DI°OVTDJOP OI (NJDOONNObm O1 +1D N-�NWN WOr OIN 0000000 Nin +'o blo'O°'vb D . ONINl�Ol00 O � J y 0 D o y ti e� W n O v w a o ❑D❑ o o y v d o O o D m n _ G g v �' y m z E n f? (p m G mm(n (no a D�' G ti y a pG2 DDD �Cl� ol^ oc DSO C. rmii m �° HN SS SG °m P y N�vC FF z y Y' Nm K' ''Gg m''° G o tzn 2 0 0 9 a Q N 1p N D F G .'!1 (pU (pU N f1 o J W N n W 0 m P v .1 n IFD N_ IAD N O N Po G o S G A N Ala 4 k N Nm 000 ��O OW1 O f1N O O O Ui C + a O boo 000 °o °o °° cc fWil W J W N N W o O o O O � mm o' zz�zz Zz I zi i DDD ➢D DD D:) W fWil W J W N N W W tN+�fn00 N(Wi� W. °0000 AA (WII ' ( 00 00000 00 0- -' O 000000 °° oao b °O A wWNwS O .w:.i 00 Nw iDO W O ob°o o °OO iaa i zzzzz 'nan 7 zl. N W W n'n an a' W b oO boo boo W 2 J c °o °o °O °O °o boo .o °o °O . 90 °oo OO p'. W fWil W J W Q n 00 fJli T(mO m +W NJ O O O�. °O A o O v 00 IaD iDO W O (J N W W W N O W b oO boo boo W J p mm J c °o °o °O °O °o boo .o °o °O . O oo o° boO mW.W (°i�N N U OAR 00 90o0 Wm0 OWiJ O O J6 K z z Z z � z Z 0. N O 8 6 v DD DD`D ➢DD ism °o °o O O ONi � 40i W OI O O O A °O 000 fIINO WW O O Od J IJ 2 N W � 00 O° 000 a00 OHO �O NYNI W O O° ON O b R o. o e z >z �Z� c c cy 'n 'n Dnn a'nD Poo w� o 0 °o °o °O n ob. W m o > C_ N O a u? fO NC7 as WT O z O uNN vm V A V J J N N N 0 � A N N +Ut 01O fAi1W d W O W m W O' O O O O O O P 0 �O �O O O O O O O O •W ..... v r � A J � 01 (Oii 0 nnnan 0 W n (A11 O O W W J N f 11 W W W p N J 0 NA O J W P Oo O o000o a ..bob m m A; 1O 1DON +01 W W W W O O W W NJ W A W, W W W W ANJO+ (d1 0 e Z L "L a rx/ o w n O N W / O O P. ..... . 9 O O C C 0 0 0 � N O�. V Parkview Villa South (166) Balance March 7.012 Books = Accrual 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 25 Mar -12 29,877.67 186.00 713,970.36 377.00 6.00 744,417.03 8,758.13 2,523.75 8,935.30 15,894.85 436.00 36,548.03 707,869.00 707,869.00 744,417.03 Parkview Villa -South (166) Income Statement For The Period Ending March 2012 Books = Accrual Month to Date % Year to Date Revenue 122.63 0.48% 201.59 0.26°6 I 2010 -46340 Minor Equipment 36220 -46340 Gen. Government Rents 24,620.42 96.35% 75,434.73 95.97% 36225 -46340 Nondwelling Rents 480.00 1.88% 1,533.00 1.95 0/a 36290 -46340 Other Miscellaneous Revenue 452.25 1.77% 1,632.93 2.080/c 39120 -46340 Recovery Damage City - 0.00% - 0.00% Total Revenue 3430 -46340 25,552.67 100.00 0/D 78,600.66 100.00% Expenses Personal Services 1000 -46340 Accrued Salaries 4,141.00 16.21% 11,587.00 14.740/c Total Personal Services 4,141.00 16.21% 11,587.00 14.740/c Supplies 2000 -46340 Office Supplies 122.63 0.48% 201.59 0.26°6 I 2010 -46340 Minor Equipment 1,071.00 4.19% 1,071.00 1.360/ 2160 -46340 Maint. & Construct Materials 0.00 0.00% 0.00 0.00 ° / 2171 -46340 General Supplies 398.96 1.56% 616.36 0.78°/ Total Supplies 1,592.59 6.23°7° 1,888.95 2.40 ° / Other Services & Charges z `{f 0.00 0.00% 0.00 0.000/ 3040 -46340 Legal Fees 3050.46340 Expert & Professional Services 0.00 0.00 0/D 0.00 0.000/ 3060 -46340 Management Services 1,940.00 7.59% 6,2.77.00 7.990/ 3100 -46340 Protective Services 0.00 0.00% 0.00 0.000/ 3210 -46340 Telephone & Telegraph 215.97 0.85% 388.06 0.490/ 3430 -46340 Advertising Other 820.00 3.21% 820.00 1.04 °, 3600 -46340 Insurance & Bonds 841.25 3.29% 2,523.75 3.21; 3810 -46340 Electric 1,415.79 5.54% 2,444.27 3.110, 0.00 0.00% 0.00 0.00; 3820 -46340 Water 3830 -46340 Gas 2,424.01 9.49% 4,889.08 6.22; 3840 -46340 Refuse 125.44 0.49% 159.83 0.209 0.00 0.00% 0.00 0.00°. 3850 -46340 Sewer 4000 -46340 Repair & Maint. Services 3,742.20 14.65% 13,149.00 16.73' 405046340 Garage, Labor Burd. 72.40 0.28% 72.40 0.091 4300 -46340 Miscellaneous Charges 0.00 0.00% 25.58 0.03( 4315 -46340 PILOT 1,059.66 4.15% 3,178.98 4.041 0.00 0.00% 558.62 0.711 4390 -46340 Taxes & Licenses 4500 -46340 Administrative Expenses 0.00 0.00% 3,232.74 4.11' 4850 -46340 Interest on Deposits 6.93 0.03% 21.57 0.031 Total Other Services & Charges 12,663.65 49.56°/° 37,740.88 48.02°. z `{f Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense � -7 0.00% 0.00 0.00% 0.00 0.00 % 1 18,397.24 72.00% 51,216.83 65.16% 7,155.43 28.00% 27,383.83 34.84 °k Parkview Villa South (166) 0.00 Cash Flow Statement 1,940.00 Period = March 2012 0.00 3210 Telephone & Telegraph Month to Date Revenue 820.00 36220 Gen. Government Rents 24,620.42 36225 Nondwelling Rents 480.00 36290 Other Miscellaneous Revenue 452.25 39120 Recovery Damage City Property 0.00 Total Revenue 25,552.67 Personnel Services 1000 Accrued Salaries 4,141.00 Total Personnel Services 4,141.00 Supplies 2000 Office Supplies 122.63 2010 Minor Equipment 1,071.00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 398.96 Total Supplies 1,592.59 Other Services & Charges 3050 Expert & Professional Services 0.00 3060 Management Services 1,940.00 3100 Protective Services 0.00 3210 Telephone & Telegraph 215.97 3430 Advertising Other 820.00 3600 Insurance & Bonds 841.25 3810 Electric 1,415.79 3820 Water 0.00 3830 Gas 2,424.01 3840 Refuse 125.44 3850 Sewer O.OD 4000 Repair & Maint. Services 3,742.20 4050 Garage, Labor But 72.40 4300 Miscellaneous Charges 0.00 4315 PILOT 1,059.66 4390 Taxes & Licenses 0.00 4500 Administrative Expenses D.00 4850 Interest on Deposits 6'93 Total Other Services & Charges 12,663.65 Total Expenses 18,397.24 Zg Parkview Villa South (166) Cash Flow Statement Period = March 2012 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 2.0200 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 W Month to Date 7,155.43 (93.00) (138,000.00) (369.00) (6.00) 0.00 (4,289.58) 841.25 (101.75) 1,059.66 171.00 (140,787.42) (133,631.99) Beg Cash End Cash Difference 163,509.66 29,877.67 (133,631.99) 93.00 186.00 (93.00) 575,970.36 713,970.36 (138,000.00) 739,573.02 744,034.03 (271,724.99) 4/16/2012 3:41 PM General Ledger (Accrual) ParlcvieW Villa South - (166) Months: Mar 2012 Page 1 Control Refer Debit Credit Balance Remarks Property Date Period Description 7,446.00 = Beginning Balance = 1000 -46340 Accrued Salaries 3,723.00 11,169.00 RJC CHC PR Mgmt Fee 166 3/3112012 03/12 (:Recur 380) :PoStRecurring Recurr J- 133248 RC 11,587.00 Adj and reallocate 2 -3/12 mg 166 3131/2012 03/12 Adj and reallocate 23/12 mg ]-133997 :Reversed by 418.00 11,587.00 = Ending Balance= NetChange= 4,141.00 78.96 = Beginning Balance = 2000 -46340 Office Supplies 83.86 162.82 pens, shredder etc 166 2/24/2012 03112 (offi8BO4) Office Depot P- 272576 5,99431 11 166 3/9/2012 03112 (of08809)O(Oce Depot P- 273842 6.01382E +11 19.91 1]9.]3 paper 189.19 on time delivery 02/12 166 3/1412012 03112 (chc) CommouBond Housing P- 272494 936637 9.46 200.94 envelopes 166 3/21/2012 03/12 (of08804)OfOce Depot P- 274401 6.02616E +11 11]5 201.59 postage 03 /l2 166 3/27/2012 03112 (chc) CommonBond Housing P- 274317 940919 0.65 201.59 = Ending Balance = NetChange= 122.63 0.00 = Beginning Balance = 2010 -46340 Minor Equipment P- 2]4403 512]9710.001 1,0]1.00 1,071.00 frig, range et..-nce 166 3/16/2012 03/12 (all) All Inc. 1,0]1.00 c Ending Balance = NnlCha 1,071.00 217.40 = Beginning Balance = 2171 -46340 General Supplies 149.23 366.63 paint 166 3/5/2012 03/12 (sher4110) ShOwin- Williams Co. P- 2]'2773 7207-6 3.4.14 ice melt, pkg twisPn -locks 3/6/2012 03/12 (home]) HD Supply Facilities Mainh P- 273296 9113858D91Pv 6.51 166 3/9/2012 03/12 (home]) HD Supply Facilities Main, P- 273297 9113932796pv 26.33 399.47 towels, gloves etc 166 3/12/2012 03/12 gula 2) Home Depot Credit Servi P- 274402 8217694pvs 12.52 411.99 vinyl tiles, washers etc. 166 3/20/2012 03/12 (pea.) Peachtree Business Praluc6 P- 274788 926632030001 27.90 439.89 Flags 166 3/2112012 03/12 (home]) HD Supply Facilities Mainb P- 274786 9114144816pv 30.56 470.45 cleaning supplies 166 3/22/2012 03/12 (home]) HD Supply Facilities Mainb P- 274787 9114164643pv 145.91 616.36 bbi etc. 166 NelChange= 398.96 61 36 Balance = 4,337.00 = Beginning Balance = 3060 -46340 Management Services 6,035.00 10,372.00 mount fee 03/12 166 3/30/2012 03/12 (chc) Commor-Bond Housing 9- 274932 941336 3,723.00 6,649.00 R/C CHC PR Mgmt Fee 166 3/31/2012 03/12 (:Recur 380) :PoslRescurring Recurr 3133246 RC 372.00 6,277.00 Adj and reallocate 2.1/12 mg 166 3/3112012 03/12 Adj and reallocate 2 -3112 mg 3- 133997 :Reversed by 6,277.00 = Ending Balance = NetChange= 1,940.00 172.09 Beginning Balance = 3210 -46340 Telephone &Telegraph 59.38 231.4] phone Svc par end l2 /31/11 166 1/18/2012 03112 (offi65B) Office of Enterprise Techn P- 271075 W11120681/12 273.45 answ Svc -set up fees 03/12 166 3/1/2012 03/12 (level Level One 9- 272577 2291214-INpv 41.98 295.91 Internet svc 3/11 -4110 166 3/2/2012 03112 (.00.3474) Comcast P -272111 8.77211E111 22.46 313.39 phone svc - due 3124 166 3/7/2012 03/12 (cen19115) Centuryl-ink P- 2]2]65 7637883978/0 17.48 328.10 ph 2/13 -318 166 3/11/2012 03112 (mcic3718) MCI Comm Service P- 273841 7637BB3978pv 14.71 388.06 phone svc - per end 2/29112 166 3/2112012 03/12 (of0658) Office of Enterprise Techn P- 274404 200BOO187/02 59.96 Ending Balance = NelChange= 215.97 388.06 = 0.00 = Beginning Balance = 3430 -46340 Advertising Other 820.00 820.00 Advertising 3/12-3/13 166 3111/2012 03/12 gra) Liturgical Publications, Inc. P- 271078 204370148/03 820.00 = E Ending Balance= NetChange= 820.00 1,682.50 = Beginning Balance = 3600 -46340 Insurance & Bonds 841.25 C of Columbia Ins Ac 166 3/31/2012 03/12 (:Recur 380) 9ostRecurring Recurr 3- 133298 RC lances 2,523.75 = Ending Balance = ,523.75 NetChange- 841.25 1,028.48 = Beginning Balance = 3810 -46340 Electric P- 273050 515044155310 1,415.]9 21,14.2] elecsvc2 /06-3an 166 3/12/2012 03/12 (xcel) Xcel Energy 2,444.27 = Ending Balance = NetChange= 1,415.79 2,465.07 = Beginning Balance = 3830 -46340 166 3/812012 03/12 Gas (cent) CenterPoint Energy P- 272585 552713241021 2,929.01 4,889.08 gas Svc 2/06 -3/06 41889,08 = Ending Balance = NelChange= 2,424.01 34.39 = Beginning Balance = 3840 -46340 166 3/2/2012 03/12 Refuse (gees 1004) Green Lights Recycling P- 272769 12- 2084pvs 125.44 159.81 trash svc 3/02 159.83 =Entling Balance = NetChange= 125.4 9,406.80 = Beginning Balance = 4000-46340 Repair & MaNt. Services 375.00 9,]81.80 painting, repairs 166 2/23/2012 03112 Fred) K.O. Cleaning and Restoratioi P- 271077 2048 9,807.38 snow rmvl - 02/28 166 2/28/2012 03/12 (mgsp) MGS Professional Bldg Main P -272575 10396pvs 25.58 10,116.56 me maint -3/12 166 3/1/2012 03/12 (eagll) Eagle Elevator Corp. P- 272767 113297 -Ipvs 309.18 10,146.01 snow rmvl - 02/29 166 3/3/2012 03/12 (mgsp) MGS Professional Bldg Main P- 272574 W403pas 29.45 10,184.76 snow rmyl - 03/01 166 3/312012 03/12 (mgsp) MGS Professional Bldg Main P- 272573 10419pvs 38.75 10,200.52 ice melt, pkg twist- n-laks 3/6/2012 03/12 (home]) HD Supply Facilities Mainb P- 273296 9113858041pv 15.76 166 318/2012 03]12 (hame)Hamemick Decorating Cent P -287/1 CG201977 1,399'20 11,599.72 carp lost 3/16/2012 03/12 (eagLL) Eagle Elevator Corp. P- 275413 113500 -IN 922'00 3/19 12,521.72 of svc /19 166 3/19/2012 03/12 (adam) Adam's Pest Control, Inc. P- 275412 702932pvs 22'00 12,543.72 pest Svc 166 3/19/2012 03/12 (home) Hamernick Decorating Cent P- 273890 CG202154 328.56 12,87228 concrete repair 129 166 P- 2]4]84 032612pvs 132.68 13,004.96 part per est- tree rmvl etc 166 3/26/2012 03/12 hub-) Arbor Barber, Inc. 144.04 13,149.00 Dryer svc- Floors 3 & 4 166 3/26/2012 03/12 (dire) Direct Home Appliance Scovk P- 274785 032612pvs 13,149.00 = Ending Balance = NetChange= 3,742.20 3 Page 1 4/16/2012 3:41 PM General Ledger (Accrual) Parkview Villa South - (166) Months: Mar 2012 Property Date Period Description Control - Re(e, Dehit Credit Balance Remarks 4050 -46340 Garage, Labor Bard. 0.00 = Beginning Balance = 166 3/27/2012 03/12 (slgn6160) Signs By RSG P- 275414 646Pvs 72.10 71A0 bulbs, we call NetChange =72.40 72.40 = Ending Balance= 4300-46340 Miscellaneous Charges 25.58 = Beginning Balance = NetChange= 0.00 25.56 c Ending Balance = 4315 -46340 PILOT 2,119.32 = Beginning Balance = 166 3/31/2012 03/12 (:Recur 380) :POStRecurring Recur, 3133248 RC 1,059.66 3,178.98 Anoka Cly Property Tax Acce, NetChange= 1,059.66 3,178.98 = Ending Balance = 4390 -46340 Taxes A, Licenses 558.62 = Beginning Balance = NetChange= 0.00 556.62 = Ending Balance = 4500 -46340 Adra nistra0ve Expenses 3,232.74 = Beginning Balance = NetChange= 0.00 3,232.74 = Ending Balance = 4850 -46340 Interest can Deposits 14.64 = Beginning Balance = 166 3/31/2012 03/12 Sec pep Interest accrual 3- 133251 G31 6.93 21.9 Sec Drip interest accrual NetChange= 6.93 21.57 = Ending Balance = 22,492.24 4,095.00 3 1 Page 2 5016464 Parkview Villa South 419/12 Bank Reconciliation Report 03/31/2012 Balance Per Bank Statement as of 03/31/2012 $30,057.14 0211112009 389 mcic - MCI Comm Service 5.47 03121/2012 1354 mgsp - MGS Professional Bldg Maint Sew Inc 93.78 03/28/2012 1360 home7 - HD Supply Facilities Maintenance 48.60 03/28/2012 1361 mcic3718 - MCI Comm Service 14.71 03/28/2012 1362 off i8804 - Office Depot 16.91 Less: Outstanding Checks $179.47 03/01/2012 Reconciled Bank Balance $29,877.67 Balance per GL as of 03/31/2012 Reconciled Balance Per G/L Difference Cleared Items: Cleared Checks $29,877.67 $29,877.67 Date Tran # Notes Amount Date Cleared 01/19/2012 1296 t0003793- Johnson 199.06 03/3112012 02/1512012 1321 mgsp - MGS Professional Bldg Maint Sew Inc 29.45 03/31/2012 02123/2012 1324 bfbp- BFB Painting, Inc. 280.00 03/31/2012 03/01/2012 1328 adam - Adam's Pest Control, Inc. 22.00 03/31/2012 03/01/2012 1329 bioc � Bio Corps, LLC 2,300.00 03/3112012 03101/2012 1330 colu - City of Columbia Heights 2,947.00 03/31/2012 03/01/2012 1331 colu825 - Columbia Heights Fire Dept 558.62 03/31/2012 03/01/2012 1332 home32 - Home Depot Credit Services 19.00 03/31/2012 03/01/2012 1333 mcic - MCI Comm Service 11.16 03/31/2012 03101/2012 1334 offi8804 - Office Depot 31.71 03/31/2012 03/07/2012 1335 buck8411 - Buckeye Cleaning Centers 37.89 03131/2012 03/07/2012 1336 cent9115 - Centuryl-ink 17.48 03/3112012 03/07/2012 1337 chc - CommonBond Housing 6,035.00 03/31/2012 03107/2012 1338 Ibpm - LBP Mechanical, Inc 449.67 03/31/2012 03/0712012 1339 mgsp - MGS Professional Bldg Maint Sew Inc 29.45 03/31/2012 03/07/2012 1340 offi658 - Office of Enterprise Technology 61.49 03/3112012 03/07/2012 1341 zeph- Zephyr Services Inc. 225.00 03/31/2012 03114/2012 1342 comc3474 - Comcast 22.46 03/31/2012 03/1412012 1343 kocl - K.O. Cleaning and Restoration LLC 375.00 03/3112012 03/14/2012 1344 litu - Liturgical Publications, Inc. 5 I�L 820.00 03131/2012 0.00 '53 4/9/12 Parkview Villa South Bank Reconciliation Report 03/31/2012 5016464 03/14/2012 1345 offi658 - Office of Enterprise Technology 59.38 03/31/2012 03/1412012 1346 t0005261 - Fouks 308.68 03/31/2012 03/21/2012 1347 cent - CenterPoint Energy 2,424.01 03/31/2012 03/21/2012 1348 cen19115- Centuryt-ink 17.48 03/31/2012 03/21/2012 1349 chc- CommonBond Housing 9.46 03/31/2012 03/21/2012 1350 eag11 - Eagle Elevator Corp. 309.18 03/31/2012 03/2112012 1351 gree1004 - Green Lights Recycling Inc 125.44 03/31/2012 03/21/2012 1352 home - Hamernick Decorating Center 1,399.20 03/31/2012 03/21/2012 1353 leve - Level One 41.98 03/31/2012 03/2112012 1355 offi8804 - Office Depot 83.86 03/31/2012 03/2112012 1356 sher4110 Sherwin- Williams Co. 149.23 03/31/2012 03/21/2012 1357 xcel - Xcel Energy 1,415.79 03/31/2012 03/2812012 1358 chc - Commonl3ond Housing 371.48 03131/2012 03/28/2012 1359 hame - Hamernick Decorating Center 328.56 03/31/2012 Total $21,515.17 Cleared Deposits Date Tran # Notes Amount Date Cleared 03/0212012 295 operations 18,898.00 03131/2012 03106/2012 293 operations 5,625.00 03/31/2012 03/08/2012 294 661.42 0313112012 03/08/2012 294 operations 128.00 03131/2012 03109/2012 296 operations 236.25 03131/2012 Total $25,548.67 Cleared Other Items Date Tran # Notes Amount Date Cleared 03114/2012 JE 133249 NEB transfer to City invest acct - 138,000.00 03/31/2012 Total - $138,000.00 '53 4/9/12 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 Date 3/30/12 Page 1 Primary Account @XXXXX @6464 Enclosures 38 A C C O U N T S - - -- EFFECTIVE MAY 1, ALL AUTOMATIC FUNDS TRANSFERS (AFTS) WILL REDUCE YOUR AVAILABLE BALANCE AT THE START OF BUSINESS DAY ON THE SCHEDULED TRANSFER DATE. IF YOUR TRANSFER IS SCHEDULED FOR A MONDAY, THIS WILL AFFECT YOUR AVAILABLE 3/02 BALANCE ON THE WEEKEND OR HOLIDAY. EARLY ACCOUNT CLOSING FEE 3/1.4 OF $20 FOR HEALTH SAVINGS ACCOUNTS CLOSED PRIOR TO 3 MONTHS. DEPOSIT NORTHEAST PUBLIC FUNDS ACCT 3/08 Number of Images 38 Account Number @XXXXX @6464 Statement Dates 3/01/12 thru 3/31/12 Previous Balance 1.64,023.64 Days in the Statement Period 31 4 Deposits /Credits 25,548.67 Average Ledger 96,783 35 Checks /Debits 1.59,515.17 3/02 Average Collected 95,306 Service Charge .00 1330 2,947.00 Interest Paid .00 29.45 3/09 Ending Balance 30,057.14 3/20 1324* Deposits and Credits Date Description Amount 3/02 DDA REGULAR DEPOSIT 18,898.00 3/1.4 3/07 DDA REGULAR DEPOSIT 5,625.00 138,000.00 3/08 DDA REGULAR DEPOSIT 789.42 in serial order 3/09 DDA REGULAR DEPOSIT 236.25 Charges and Debits Date Description Amount 3/1.4 Xfer to 0005 SAVINGS 138,000.00 Checks in serial order Date Check# Amount Date Check# Amount 3/02 1296 199.06 3/08 1330 2,947.00 3/21 1321* 29.45 3/09 1331 558.62 3/20 1324* 280.00 3/09 1332 19.00 3/06 1328* 22.00 3/13 1333 11.16 3/16 1329 2,300.00 3/14 1334 31.71 * Indicates skip in check numbers -5<�l Parkview Villa North Financial Statement Overview February 2012 Revenue: Occupancy for the month of February 2012 was 100% occupied; Total Revenue was under budget amount (unfavorable). No Grant Income was recognized in the month of February Administrative Expenses: Administrative costs for the North were over budget (unfavorable). This reflects 2011 servicing fee paid to the City Other Renting Expenses were under budget (favorable), and reflect minimum applicant screening needed due to low turnover. Office Salary and Management fee is allocated incorrectly in the month of February, however, the total matches budget Office Supply expenses are under budget (favorable) Computer Equipment and Maintenance was over budget (unfavorable) and reflects an error in billing. Credit will be issued. Legal Expenses was under budget (favorable). Telephone, Answering Service and Internet expenses are under budget (favorable). Utilities: Utilities Expenses are under budget (favorable), however, these are quarterly billings Electric was under budget (favorable) Gas was slightly over budget (unfavorable) Water and Sewer were not invoiced in February ®peratina and Maintenance Expense (sunnlies): Operating and Maintenance Expenses are under budget (favorable). Janitor Contract expenses were under budget (favorable) Exterminating Contract is under budget (favorable) Maintenance Supplies is under budget (favorable) Garbage and Trash are under budget (favorable); however, this is a quarterly billing Security Contract is under budget (favorable). Repairs Contract expenses were under budget (favorable) Elevator Maintenance Contract is slightly over budget (unfavorable), and reflects service call in February Snow Removal is under budget (favorable). Decorating Contract and Supplies were under budget (favorable) Furniture and Fixtures is under budget (favorable) FA OWi pO J O O b O NW O f3 W u + W � + W NViW OO+WOJOOC bOAAm0004Wi CIO 00C es�na �ASe °e�ege8ss 6)'m W b n� (n J P iWi (WO y W {Jli IWJ O O O O O °a mo O 4 O °o °ooWa A N J 4 O O N 10 N O O O N N V OWi000Wi0 IJ J O N + i Y W O W O 000(NiIO Q D V W J N IAD a � 000 + N 00000 N N 0 0 0 Ol NANO O N d O O J OWl O N O O O 41J00 WNO Ul W 0 0 0 W A 0 (Jil O Vl J O mNm N N NIiO W�+AO aONO °o °o amo °o S'lo °o °o °o , Wmb�D��O �OWNb �y O W Vl A N J P OWi O W O O UNi O N Ul W O O N W A W O WN O O O O J O O J O O O °o °o °oo °OO °o °om °o °o o° N W N � O f!I N A W o p W F. PD r IU V(NnN OOJ A fNil (Nil b VbON+ O J W O O A N NNN ID N(WilN00 N i J J + O A W oo °O> A b W 0 , bONOP W: NNO+00 W � W WJN_ +N OAi NNN p'IJ O O O O O O O J D O -ai m O A p1 N G O W i 1 O t] O q N b � m w O O m b l0 A p o v A b O u � O � .8 P D z O d a D � = G ° __ C C � E 3 m laic m � � •�• m a a _ NNG mev a D 7mCN�0 Nm N[N ¢in .�Dm'm N A OyOGIj pG1Ap >H - " m3���, � _ v N N m OWi pO J O O b O NW O f3 W u + W � + W NViW OO+WOJOOC bOAAm0004Wi CIO 00C es�na �ASe °e�ege8ss 6)'m W b n� (n J P iWi (WO y W {Jli IWJ O O O O O °a mo O 4 O °o °ooWa A N J 4 O O N 10 N O O O N N V OWi000Wi0 IJ J O N + i Y W O W O 000(NiIO Q D V W J N IAD a � 000 + N 00000 N N 0 0 0 Ol NANO O N d O O J OWl O N O O O 41J00 WNO Ul W 0 0 0 W A 0 (Jil O Vl J O mNm N N NIiO W�+AO aONO °o °o amo °o S'lo °o °o °o , Wmb�D��O �OWNb �y O W Vl A N J P OWi O W O O UNi O N Ul W O O N W A W O WN O O O O J O O J O O O °o °o °oo °OO °o °om °o °o o° N W N � O f!I N A W o p W F. PD r IU V(NnN OOJ A fNil (Nil b VbON+ O J W O O A N NNN ID N(WilN00 N i J J + O A W oo °O> A b W 0 , bONOP W: NNO+00 W � W WJN_ +N OAi NNN p'IJ O O O O O O O J D O -ai m O A p1 N G O W i 1 O t] O q N b � m w O O m b l0 A p o v A b O u � O � .8 P D z O d a Z y o U (JJ J Op 5 = 9 N A U ' p� ➢➢ J �1 pN� � N W N ➢ n O O W➢ m A V� O O O O m J O O N O� J O O N F... �A�pp yN N N O W -N+ O J O P V 0 W m u m m m N f0 ➢ J +� NP N N N N O m VNiN IJO N (WJW +mN O VJ (JI�WOOTOOm104WiO N� '+4iN0 N6 Po P Po U N A N N (li W W OPoi C 4Poi J+ O N 4Ni O 5 .. w f 8 � 10 P OO IJ AA' fn O, OIO OOOJJ J ONONOOi Wo 00 Oi + NN O(J JO�O IOGJ O 00�O OOOmO+ (OO ViT00 'O Vi 'O Lm 00 � N W WJ00000� O�O O'O NIJ (N�aO'OOfu (.� -� +WD �OOWNO➢ W.� YJ 0 WW A�W N W J ' Q 0 4 0 �p A A N J WA W P ip A WyWO �I P O W N V J A (J i0 IJ O1 A N m W ➢+ J O� J O �O W (Nii N OJ+ IOJOAOOJNW J(n D 00 0 00 mW0 W OE TOQO�UNiONOFJO000iPA0U Jd AA O J lJW W W + IJ N tO 41 N W 6� W lil _ (li W IJ O OI O m 0o a o mm uwo °° a'norn °o ow °u °m°HU�°'ow °° Vic k.'S°OO m TO°rn °Oaa °oa °O m°owwPAao e:�» A P Y + + � 4� -+ + + ➢ � IJ IJ ➢ C � N b W _N + fli 4� W W N i0 N (J O A A N ONNE O O W Y W O O O +ml y+y1 A 4 N d W N N N W W O N O O N W N O i W A °O WOOPoi PIJOANAOmib000PoimO0AVi NPF 00 > W W W D NN q w y A i N N NNO J A W ➢ +(li (a ➢(nW. 00W.W N '°°oo (n OHOOO(n0 0 NCO �D Ooo W Wo.ONOO °.Om (Ai�00 NJ ......... O O O O O O O O O O O N r r 1 nRnnn w N N - a - � TNm A N' o O O O O O O O 8 @888 Z D Z`ZZZZ D DDDT D e a:a,A s x &ses 0 00 00 D DID n ➢D D 3 o c •VV1 U IJ. 1 N � F � D' D b o °- o BIZ zzz DDDDD m �N mouum OIp 000 O O O O O O O O O O O i U 7'z zZZZ nn'n a g100000 o oo °OO °o IF � N � I, pp A � N 6 Oi OOl ww< O �Nn IJ N d N41� (J lJ W mmn NA P y� W W ? C P tt �Ne ro n A o w° o° Iv N 5 D vo 000 o c •VV1 U IJ. 1 N � F � D' D b o °- o BIZ zzz DDDDD m �N mouum OIp 000 O O O O O O O O O O O i U 7'z zZZZ nn'n a g100000 o oo °OO °o IF � N � I, pp A � N 6 Oi OOl ww< O �Nn IJ N d N41� (J lJ W mmn NA P y� W W ? C P tt �Ne ro n A o o° Iv N 5 � \ \ \\ ®® ( Rq q �( »( §) m G §m)Gi ) (`� ; � \ \ \\ G §m)Gi ; ;> \ ; !; ! ;;;;[ � Parkview Villa -North (165) Balance Sheet February 2012 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Liabilities Fund Balance 25300 Fund Balance Total Fund Balance Total Liabilities and Fund Balance Feb -12 222,146.24 457.00 823,425.08 425.00 175.00 22,023.83 1,068,652.15 23,834.35 3,483.50 551.74 17,946.10 25,904.24 724.00 72,443.93 996,208.22 996,208.22 1,068,652.15 I Parkview Villa -North (165) Income Statement For the Period Ending February 2012 Books = Accrual Expenses Personal Services 1000 -46330 Accrued Salaries 8,357.00 28.92% 16,714.00 28.55% Total Personal Services 8,357.00 28.92% 16,714.00 28.55% Supplies 2000 -46330 Office Supplies Month to Date % Year to Date 2.41% Revenue 0.00 0.00% 0.00 0.00% 33160 -46330 Federal Grant - 0.00% - 0.00% 36220 -46330 Gen, Government Rents 27,762.00 96.08% 56,320.00 96.20°70 36225 -46330 Nondwelling Rents 352.00 1.22% 672.00 1.15% 36290 -46330 Other Miscellaneous Revenue 781.38 2.70% 1,552.38 2.65% 39120 -46330 Recovery Damage City Property - 0.00% - 0.00% Total Revenue 28,895.38 100.000/0 58,544.38 100.000/0 Expenses Personal Services 1000 -46330 Accrued Salaries 8,357.00 28.92% 16,714.00 28.55% Total Personal Services 8,357.00 28.92% 16,714.00 28.55% Supplies 2000 -46330 Office Supplies 1,188.90 4.11% 1,410.57 2.41% 2010 -46330 Minor Equipment 0.00 0.00% 0.00 0.00% 2160 -46330 Maint. & Construct Materials 378.52 1.31% 1,608.64 2.75% 2171 -46330 General Supplies 250.85 0.87% 538.11 0.92% Total Supplies 1,818.27 6.290/D 3,557.32 6.08% Other Services & Charges 3040.46330 Legal fees 0.00 0.00% 0.00 0.00% 3050 -46330 Expert and Professional Services 0.00 0.00% 0.00 0.00% 3060 -46330 Management Services 5,191.00 17.96% 9,736.00 16.63% 3100 -46330 Protective Services 455.00 1.57% 3,667.00 6.26% 3210 -46330 Telephone & Telegraph 387.61 1.340/. 568.73 0.97% 3430 -46330 Advertising Other 0.00 0.00% -94.05 - 0.16% 3600 -46330 Insurance & Bonds 1,741.75 6.03% 3,483.50 5.95% 3810 -46330 Electric 2,594.68 8.98% 2,594.68 4.43% 3820 -46330 Water 0.00 0.00% 0.00 0.00% 3830 -46330 Gas 4,867.39 16.84% 4,867.39 8.31% 3840 -46330 Refuse 0.00 0.00% 76.56 0.13% 3850 -46330 Sewer 0.00 0.00% 0.00 0.00% 4000 -46330 Repair & Maint. Services 2,155.10 7.46070 6,355.85 10.86% 4100 -46330 Rents & Leases 60.00 0.21% 66.75 0.11% 4300 -46330 Miscellaneous Charges 25.00 0.09% 25.00 0.04% 4315 -46330 PILOT 1,850.30 6.40% 3,700.60 6.32% 4390 -46330 Taxes & Licenses 1,243.38 0.00% 1,243.38 2.12% 4500 -46330 Administrative Expenses 6,905.44 23.90% 6,905.44 11.80% 4850 -46330 Interest on Deposits 13.04 0.05% 26.35 0.05% Total Other Services & Charges 27,489.69 95.14% 43,223.18 73.83% Capital Outlay 5120 -46330 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 235.54 0.00% 523.21 0.89% !11.54 0.820/0 523.21 0.890/0 37,900.50 131.16% 64,017.71 109.35 0/a - 9,005.12 - 5,473.33 -9.350/. 91 Parkview, Villa -North (165) Cash Flow Statement Period = February 2012 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 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 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 27,762.00 352.00 781.38 0.00 28,895.38 8,357.00 8,357.00 1,188.90 0.00 0.00 629.37 0.00 1,818.27 0.00 5,191.00 455.00 387.61 0.00 1,741.75 2,594.68 0.00 4,867.39 0.00 0.00 2,155.10 60.00 25.00 1,850.30 1,243.38 6,905.44 13.04 235.54 27,725.23 37,900.50 - 9,005.12 I0 Parkview Villa -North (165) Cash Flow Statement Period = February 2012 Book = Accrual Adjustments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 20200 Accounts Payable 20210 Accrued Other Expenses 22.000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flaw 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 2,425.00 75.00 828.80 1,444.81 1,741.75 188.04 1,850.30 - 965.00 7,588.70 (1,416.42) Beg Cash End Cash Difference 223,562.66 222,146.24 (1,416.42) 457.00 457.00 - 725,325.08 725,325.08 - 949,344.74 947,928.32 (1,416.42) Pat kview Villa -North (165) 0.00 0.00% 0.00 0.00% Income Statement 1,188.90 4.11% 1,410.57 2.41% For The Period Ending February 2012 0.00 0.00% 0.00 0.00% Books = Accrual 378.52 1.31% 1,608.64 2.75% 2171 -46330 General Supplies Month to Date % Year to Date % Revenue 1,818.27 6.29% 3,557.32 6.080/a I 33160 -46330 Federal Grant - 0.00% - 0.00 %, 36220 -46330 Gen. Government Rents 27,762.00 96.08% 56,320.00 96.20% 36225 -46330 Nondwelling Rents 352.00 1.22% 672.00 1.15% 36290 -46330 Other Miscellaneous Revenue 781.38 2.70% 1,552.38 2.65% 39120 -46330 Recovery Damage City Property - 0.00% - 0.00% Total Revenue 28,895.38 100.000/0 58,544.38 100.000/0 Expenses Personal Services 1000 46330 Accrued Salaries 8,357.00 28.92% 16,714.00 28.55% i Total Personal Services 8,357.00 28.92% 16,714.00 28.55% Supplies 0.00 0.00% 0.00 0.00% 2000 -96330 Office Supplies 1,188.90 4.11% 1,410.57 2.41% 2010 -46330 Minor Equipment 0.00 0.00% 0.00 0.00% 2160 -96330 Maint. & Construct Materials 378.52 1.31% 1,608.64 2.75% 2171 -46330 General Supplies 250.85 0.87% 536.11 0.92% I Total Supplies 1,818.27 6.29% 3,557.32 6.080/a I Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 0.00 0.00% 3050 -46330 Expert and Professional Services 0.00 0.00% 0.00 0.00% 3060 -46330 Management Services 5,191.00 17.96% 9,736.00 16.63% 3100 -46330 Protective Services 455.00 1.57% 3,667.00 6.26% 3210 -46330 Telephone & Telegraph 387.61 1.34% 568.73 0.97% 3430 -46330 Advertising Other 0.00 0.00% -94.05 -0.16% 3600 -46330 Insurance & Bonds 1,741.75 6.03% 3,483.50 5.95% 3810 -46330 Electric 2,594.68 8.98% 2,594.68 4.43% 3820 -46330 Water 0.00 0.00% 0.00 0.00% 3830 -46330 Gas 4,867.39 16.84% 4,867.39 8.31% 3840 -46330 Refuse 0.00 0.00% 76.56 0.13% 3850 -46330 Sewer 0.00 0.00% 0.00 0.00% 4000 -46330 Repair & Maint. Services 2,155.10 7.46% 6,355.85 10.86% 4100 -46330 Rents & Leases 60.00 0.21% 66.75 0.11% 4300 -46330 Miscellaneous Charges 25.00 0.09% 25.00 0.04% 4315 -46330 PILOT 1,850.30 6.40% 3,700.60 6.32% 4390 -46330 Taxes & Licenses 1,243.38 0.00% 1,243.38 2.12% 4500 -96330 Administrative Expenses 6,905.44 23.90% 6,905.44 11.80% 4850 -46330 Interest on Deposits 13.04 0.05% 26.35 0.05% Total Other Services & Charges 27,489.69 95.14% 43,223.18 1 � 73.83% Capital Outlay 5120 -46330 Building & Improvements 235.54 0.00% 523.21 0.89% Total Capital Outlay 235.54 0.82% 523.21 0.890/c Total Expense 37,900.50 131.16% 64,017.71 109.350A I Excess (Deficit) Revenue over Expense - 9,005.12 - 31.16% - 5,473.33 -9.350/c [2-.� 3/13/2012 3:16 PM Parkvlew Villa -North (165) General Ledger Period = Feb 2012 Book = Accrual Data Period Person/ D rlp86ontrol Reference Debit Credit Balance Remarks Properly 1000 -46330 Accrued Salaries 8,357.00 = Beginning Balance = 165 2/2912012 02/2012 :POrlaccurring Mon)- 130482 RC 8,352.00 0.00 16,714.00 NC CHC PR Mgmt Fee Net Change= 8,357.00 16,714.00 = Ending Balance = 20DO -46330 Office Supplies 221.67 = Beginning Balance = 165 2/3/2012 02/2012 Office Depot(offiBE P- 268839 596838943001pvn 31.42 0.00 253.09 pope, deskpad etc. 165 2/8/2012 02/2012 Office Depot(oRBE P- 268838 5968393330D1pvn 39.15 0.00 292.24 cards etc. 165 212112012 02/2012 Common8ond Horn P- 268741 922175 1,118.33 0.00 1,410.57 romp support 1/20 -2/20 Net Charge= 1,188.90 1,410.57 = Facing Balance = 2160 -46330 paint. & Construct Materials 1,230.12 = Imunnl "g Balance = 165 1 /17 /2012 02/2012 HD Supply Faciftle!P- 267442 9/12972202 190.47 0.00 1,420.59 angle slap 165 1/22/2012 02/2012 HD Supply Facilltic P- 262446 91131689021vn 44.01 0.00 1,464.60 ice melt' mr,cri .riles etc. 165 2/312012 02/2012 Park Supply of Anne P- 268273 40264400 144.04 0,00 1,608.64 handle, bolts etc. Net Change = 378.52 1,608.64 = Ending Balance = 2171 -46330 General Supplies 287.26 = Staff nning Balance = 165 1/18/2012 02/2012 NO Supply r'aciftlm P- 267444 9112999196pvn 135.29 0.00 423.05 trash Ilners, specify etc. 165 1119/2012 02/2012 HD Supply Facilltie! P- 267443 9113025353pvn 30.73 0.00 453.78 glass cleaner, magic eraser 165 2/14/2012 02/2012 Ouckeye Claining(P- 270111 651311pvn 64.33 0.00 538.11 roll towel Net Change= 250.65 536.11 = Ending Balance = 3060 -46330 Malragement Services 4,545.00 = BeglnNng Balance 165 2/29/2012 02/2012 CommmBand How P- 269943 926294 13,548.00 0.00 18,093.00 meat fees 02/12 165 2/29/2012 02/2012 :POStRecomag MoN- 130487 RC 0.00 8,357.00 9,236.00 R/C CHC PR M9ml Fee Net Change = 5,191.0, 9,736.00 = Ending Balance = 3100 -46330 Protective Services 3,212.00 = Beginning Balance = 165 1/23/2012 02/2012 Simplex Grinnell Is P- 262476 62408341 455.00 0.00 3,662.00 Sec sys svc call -4th Boor Net Cbange=455.00 3,667.00 = Ending Balance = 3210 -46330 Telephone & Telegraph 181.12 = Beginning Balance = 165 211/2012 02/2012 Level One (level P- 267447 225222 -IN 135.41 0.00 316.53 ans, svc - set up fees 02/12 165 2/2/2012 02/2012 Comcan (comc347 P- 267440 077210505019618: 51.59 0.00 366.12 Internet svc 2/11 -3110 165 212/2012 02/2012 Ceatc,Uak((ent9 P-27D112 7637883978/02121 38.90 0.00 402.02 phone svc - due 2/25 165 2/11/2012 02/2012 MCI Comm Service P- 269200 7637803978/0212! 24.83 0.00 431.85 phone svc - due 3/03 165 2/15/2012 0212012 Office of Enterprise P- 269884 W12010671/0112P 136.88 0.00 568.73 phone svc- per end 1/31/12 Net Change= 387.61 568.73 = Ending Balance = 3430 -46330 Advertising Other -94.05 = Beglnning Balance = Net Change: 0.00 -94.05 = Endbrg Balance - 3600 -46330 I.e., an.. & Bonds 1,741.75 = Beginning Balance = 165 2/2912012 02/2012 :PostRecurung Mon)- 130487 RC 1,241.75 0.00 3,483.50 C of Columbia Heights Ins Aa Net Change = 1,741.75 3,483.50 = Ending Balance = Electric 0.00 = Beginning Balance = 3810 -46330 165 2/13/2012 02/2012 Xcel Energy (xcel) P- 266606 5150441553101121 3,997.76 0.00 3,997.76 else credit/svc 1/07 -2/06 165 2/1312012 02/2012 Xcel Energy (xcel) P- 268606 5150441553/01121 0.00 1,399.83 2,597.93 elec nedit/svc 1/07 -2/06 165 2/13/2012 02/2012 Xcei Energy (,cell P- 268606 5150441553/01121 O.DO 3.25 2,594.68 Net Change= 2,594.68 2,594.68 = Ending Balance = Gas 0.00 = Original", Balance = 3830 -46330 165 2/7/2012 02/2012 CenterPOlnt Energy P- 267951 5519965710112 4,867.39 0.01) 4,867.39 gas svc 1 /05 -2103 Net Cbange=4,867.39 4,867.39 = Ending Balance = 3840.46330 Refuse 76.56 = Beginning Balance = Net Change =0.00 76.56 - Ending Balance = Repair& Maine, Services 4,200.75 = Beginning Balance = 4000 -46330 165 1/18/2012 D2/2012 Adam's Pest Comic P- 268271 693236pvn 48.92 0,011 4,249.22 pest svc 1118 165 1/23/2012 02/2012 FIGS Professlonal B P- 267448 10361pvn 65.55 0.00 4,315.27 snow rmvl svc 1/23 165 1/22/2012 02/2012 HD Supply Facllitie!P- 267446 91131689D2pvn 35.07 0.01) 4,350.34 Ice melt, thermocouples etc. 165 1/31/2012 02/2012 LBP Mechanical, In P- 268272 W16456 347.50 0.00 4,697.84 HVAC svc (.1112/29 165 2/1/2012 02/2012 Eagle Elevator Carl P- 267441 112718 -Ipvn 688.17 0.00 5,386.01 mo main -2/12 165 2/8/2012 02/2012 AtlamY Pest COntrc P- 269173 698311pvn 48.97 0.00 5,434.98 pest svc 2/08 165 2/16/2012 0212012 Drain King, I.e.(d, P- 269092 82608 135.00 0.00 5,569.98 path, svc- 206 165 2/1612012 0212012 Custom Appliance'. P- 269904 8293 177.32 0.00 5,7473D oven sv( call -608 165 2/17/2012 02/2012 Eagle Elevator Carl P- 269175 112935 -IN 543.00 0.00 6,290.30 svc call 2/13 165 2121/2012 02/2012 MGS Professional B P- 269903 10378pvn 65.55 O.OD 6,355.85 snow crawl SVGS 2/21 Net Change= 2,155.10 6,355.85 = Ending Balance = 19 Page l oft Property Data Period 4100 -46330 165 1/31/2012 02/2012 4300 -46330 165 2/312012 02/2012 4315 -46330 020312pvn 25.00 165 2/29/2012 02/2012 4390 -46330 165 2/22/2012 D2/2012 4500 -46330 165 2/16/2012 02/2012 165 2/12/2012 02/2012 165 2/21/2012 02/2012 4850 -46330 165 2/2912012 02/2012 5120 -46330 921931 593.25 165 2/2D/2012 02/2012 Parkview Villa-NOrtI, (165) General Ledger Period - Feb 2012 Book = Accrual Person /DescNptbGOntrol Reference Dealt Rents & Leases Multihousing Credit P- 268036 120/0369 60.00 Net Cluenge=60,00 Miscellaneous Charges Schander(1000397 P- 262449 020312pvn 25.00 Net Chenge=25.00 PILOT POs ec.,na, Mon) - 130482 RC 1,050.30 Net Change=1,850.30 Taxes & Licenses Columbia Heights FP- 269632 022212pvn 1,243.38 Net Clmnge=1,243.38 Administrative Expenses Cournern nd Hour P- 266510 921039 8.44 CommonBOnd hour P- 268316 921931 593.25 City of Columbia in P- 269630 201lpvn 6,303.75 Net Change=6,905.44 Interest on Deposits Sec Del interest a,)- 131745 G32 13.04 Net Change =13.04 Credit 0.00 0.00 0.00 0.00 o.OD 0.00 0.00 0.00 Building & Improvements RC WAI#11094 AN- 131744 G)1 235.54 0100 Net Change =235.54 47,660.58 9,760.08 Page 2 of 2 3/13/2012 3:16 PM Balance Remarks 6.75 = Beginning Balance = 66.25 bck,rnd cks 1/12 66.75 = Ending Balance = 0.00 = Beginning Balance = 25.00 returned security card key 25.00 = Ending Balance = 1,850.30 = Beginning Balance = 3,200.60 Anoka Cry Property Tax Accry 3,700.60 = Ending Balance = 0.00 = Beginning Balance = 1,243.38 Prop rental license - pvn 1,243.38 = Ending Balance = O.DO = Beginning Balance = 8.44 2011- 1099 1CRP costs 601.69 2011 CRP fees 6,905.44 pvn 2011 servicing fees 6,905.44 = Ending Balance = 13.31 = Beginning Balance r 26.35 Sec Dan Interest accrual 26.35 = Entling, Balance = 587.67 = Beginning Balance = 623.21 RC WAI 411094 Arch Fee four 823.21 = Ending Balance = 15 5016456 Parkview Villa North Bank Reconciliation Report 02/29/2012 Balance Per Bank Statement as of 02/29/2012 $227,718.77 02/09/2011 1199 courl325 - Court Administration 55.00 02/09/2011 1200 court325 - Court Administration 320.00 12122/2011 '1545 t0004004 - Alunovic 120.55 02/1512012 1607 mgsp - MGS Professional Bldg Maint Sery Inc 65.55 02/23/2012 1611 cent - CenterPoint Energy 4,867.39 02/23/2012 1614 park! - Part< Supply of America, Inc. 144.04 Less: Outstanding Checks 237.53 $5,572.53 Reconciled Bank Balance Balance per GL as of 02/29/2012 Reconciled Balance Per G /1- Difference Cleared Items: Cleared Checks $222,146.24 3/12/12_ $222,146.24 $222,146.24 0.00 Date Tran 8 Notes Amount Date Cleared 0112512012 1572 cent - CenterPoint Energy 5,198.32 02/29/2012 01/25/2012 1575 gree1004 - Green Lights Recycling Inc 76.56 02/29/2012 1578 mgsp - MGS Professional Bldg Maint Sery Inc 12.2.48 02/29/2012 0112512012 1580 park! - Park Supply of America, Inc. 43.93 02/29/2012 01/25/2012 1581 pet1651s - Laura Sheak 237.53 02129/2012 01/25/2012 1584 zeph - Zephyr Services Inc. 478.45 02/2912012 01/2512012 1585 adam - Adam's Pest Control, Inc. 29.15 02/29/2012 02/01/2012 1586 bfbp - BFB Painting, Inc. 3,040.00 02/29/2012 02/01/2012 1587 cent9115 - Centuryl-ink 38.90 02/29/2012 0210112012 1588 dire Direct Home Appliance Services 84.00 02/29/2012 02/01/2012 1589 gard1086- Gardner Plumbing, LLC 868.86 02/29/2012 02/01/2012 1590 home? - HD Supply Facilities Maintenance 155.47 02/29/2012 02101/2012 1591 kocl - K.O. Cleaning and Restoration LLC 400.00 02/29/2012 02101/2012 1592 leve - Level One 50.00 02/29/2012 02/01/2012 02/01/2012 1593 mcic3718 - MCI Comm Service 17.13 02/2912012 1594 mgsp - MGS Professional Bldg Maint Sery Inc 131.10 02/29/2012 02/01/2012 1595 mndept64 - MN Dept Of Labor & Industry 305.00 02/29/2012 02/01/2012 1596 offi8804 - Office Depot 52.55 02/2912012 02/01/2012 Olsen Fire Inspection, Inc. 3,212.00 02129/2012 I 02/01/2012 1597 olse - 5016456 02/01/2012 02/01/2012 02/08/2012 02/08/2012 02/08/2012 02/15/2012 02/15/2012 02/15/2012 02/15/2012 02/15/2012 02/15/2012 02/23/2012 02/23/2012 02/23/2012 02/23/2012 Total Cleared Deposits 1598 1599 1600 1601 1602 1603 1604 1605 1606 1608 1609 1610 1612 1613 161.5 Date Tran # 02102/2012 377 02/02/2012 378 02103/2012 379 02/06/2012 380 02/0912012 382 02/14/2012 381 Total Cleared Other Items Date 02/14/2.012 Total Tran # JE 131743 Parkview Villa North Bank Reconciliation Report 02/29/2012 sher4110 - Sherwin - Williams Co. waic - WAI Continuum the - Commonl3ond Housing dra17740 - Drain King, Inc. home32 - Home Depot Credit Services comc3474 - Contrast eagll - Eagle Elevator Corp. home7 HD Supply Facilities Maintenance [eve - Level One simp - Simplex Grinnell t0003976 - Schander adam - Adam's Pest Control, Inc. chic - Commonl3ond Housing Ihpm - LBP Mechanical, Inc xcel - Xcel Energy Notes laundry receipts operations - pvn rent deposits operations dep dep Notes CFP Cap Fund Program receipt 275.10 02/29/2012 587.67 02/29/2012 12,902.00 02/29/2012 135.00 02/2912012 105.61 02/29/2012 51.59 02/29/2012 688.17 02/29/2012 436.07 02/29/2012 135.41 02/29/2012 455.00 02/29/2012 .25.00 02/29/2012 48.97 02/29/2012 601.69 02/29/2012 - 347.50 02129/2012 2,594.68 02/29/2012 $33,930.89 Amount Date Cleared 289.38 02/29/2012 11,726.00 02/29/2012 9,123.00 02/2912012 7,598.00 02/29/2012 1,264.00 02129/2012 605.00 02/2912012 $30,605.38 Amount Date Cleared 828.80 02/29/2012 $828.80 3/12/12 6-7 Date 2/29/12 Page 1 Primary Account @XXXXX @6456 Enclosures 40 EPA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - 1� - - - C H E C K I N G A C C O U N T S - - -- EFFECTIVE MARCH 1, 2012 WIRE TRANSFER FEES FOR OUTGOING DOMESTIC WIRES WILI, BE INCREASED TO $20 AND AN EARLY ACCOUNT CLOSING FEE OF $20 WILL BE CHARGED FOR DDA AND SAVINGS ACCTS CLOSED IN LESS THAN 3 MONTHS AND HEALTH SAVINGS ACCTS PRIOR TO 3 YEARS. THE MAXIMUM DAILY LIMIT FOR NSF PAID AND RETURNED ITEM FEES (CONSUMER ONLY) IS $120. NORTHEAST PUBLIC FUNDS ACCT Number of Images 40 Account Number @XXXXX @6456 Statement Dates 2/01/12 thru 2/29/12 Previous Balance 230,215.48 Days in the Statement Period 29 7 Deposits /Credits 31,434.18 Average Ledger 235,497 34 Checks/Debits 33,930.89 Average Collected 234,079 Service Charge .00 Interest Paid .00 Ending Balance 227,718.77 Deposits and Credits Date Description Amount 2/02 DDA REGULAR DEPOSIT 289.38 2/02 DDA REGULAR DEPOSIT 11,726.00 2/03 DDA REGULAR DEPOSIT 9,123.00 2/06 DDA REGULAR DEPOSIT 7,598.00 2/09 DDA REGULAR DEPOSIT 1,264.00 2/14 MISC PAY HUD TREAS 303 828.80 CR 3031036218 02/14/12 ID #- 411269646860103 TRACE #-031036210833043 2/14 DDA REGULAR DEPOSIT 605.00 Checks in serial order Date Check# Amount Date Check# Amount 2/02 1572 5,198.32 2/0'1 1584* 478.45 2/01 1575* 76.56 2/07 1585 29.15 2/27 1578* 122.48 2/07 1586 3,040.00 2/02 1580* 43.93 2/07 1587 38.90 2/01 1581 237.53 2/3.3 1588 84.00 * Indicates skip in check numbers 1� Date 2 /29/12 Page 2 Primary Account @XXXXX @6456 Enclosures 40 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Check# Amount Date Check# Amount Date 2/07 1589 868.86 2/13 1.601 135.00 2/07 1590 155.47 2/7.4 1602 105.61 2/08 1591 400.00 2/22 3.603 51.59 2/06 1592 50.00 2/21 1604 688.17 2/10 1593 17.3.3 2/23 1605 436.07 2/27 1594 131.10 2/22 1606 135.41 2/06 1595 305.00 2/22 1608* 455.00 2/10 1596 52.55 2/27 3.609 25.00 48.97 2/06 1597 3,212.00 275.10 2/27 2/27 1610 3.612* 601.69 2/07 2/16 1598 1599 587.67 2/28 1613 347.50 2/10 1600 12,902.00 2/27 1615* 2,594.68 * Indicates skip in check numbers Daily Balance Date Section Balance Date Balance Date Balance 2/01 229,901.39 2/09 245,806.59 2/22 232,026.26 2/02 236,674.52 2/10 232,834.91 2/23 231,590.19 2/03 245,797.52 2/13 232,615.91 2/27 228,066.27 2/06 249,828.52 2/14 233,944.10 2/28 227,718.77 2/07 244,942.59 2/16 233,356.43 2/08 244,542.59 2/21 232,668.26 * * * E N D O F S T A T E M E N T H Payment Summary Bank = l6Sopr AND mm /yy= 02/2012- 02/2012 AND All Checks =Yes AND Include Voids= All Checks 2o) Check Post Total Bank Check# Vendor Date Month Amount 16 1585 adam - Adam's Pest Control, Inc. 02/01/2012 02/2012 29.15 Sopr Parkview Villa North 165opr - Parkview Villa North 1586 bfbp - BFB Painting, Inc. 02/01/2012 02/2012 3,040.00 165opr - Parkview Villa North 1587 cent9115 - Centurylink 02/01/2012 02/2012 38.90 16Sopr - Parkview Villa North 1588 dire - Direct Home Appliance Services 02/01/2012 02/2012 84.00 165opr - Parkview Villa North 1589 gard1086 - Gardner Plumbing, LLC 02/01/2012 02/2012 868.86 16Sopr - Parkview Villa North 1590 home7 - HD Supply Facilities Maintenance 02/01/2012 02/2012 155.47 165opr - Parkview Villa North 1591 kocl - K.O. Cleaning and Restoration LLC 02/01/2012 02/2012 400.00 165opr - Parkview Villa North 1592 leve - Level One 02/01/2012 02/2012 50.00 165opr - Parkview Villa North 1593 mcic3718 - MCI Comm Service 02/01/2012 02/2012 17.13 1650pr - Parkview Villa North 1594 mgsp - PIGS Professional Bldg Maint Sery Inc 02/01/2012 02/2012 131.10 165opr - Parkvlew Villa North 1595 mndept64 - MN Dept Of Labor & Industry 02/01/2012 02/2012 305.00 165opr - Parkview Villa North 1596 offi8804 - Office Depot 02/01/2012 02/2012 52.55 16Sopr Parkview Villa North 1597 else - Olsen Fire Inspection, Inc. 02/01/2012 02/2012 3,212.00 165opr - Parkview Villa North 1598 sher4110 - Sherwin- Williams Co. 02/01/2012 02/2012 275.10 165opr - Parkview Villa North 1599 wale - WAI Continuum 02/01/2012 02/2012 587.67 16Sopr - Parkview Villa North 1600 chc - CommonBond Housing 02/08/2012 02/2012 12,902.00 165opr - Parkview Villa North 1601 drai7740 - Drain King, Inc. 02/08/2012 02/2012 135.00 165opr - Parkview Villa North 1602 home32 - Home Depot Credit Services 02/08/2012 02/2012 105.61 165opr - Parkview Villa North 1603 comc3474 - Comcast 02/15/2012 02/2012 51.59 165opr - Parkview Villa North 1604 eagll - Eagle Elevator Corp. 02/15/2012 02/2012 688.17 165opr - Parkview Villa North 1605 home7 - HD Supply Facilities Maintenance 02/15/2012 02/2012 436.07 165opr - Parkview, Villa North 1606 leve - Level One 02/15/2012 02/2012 135.41 165opr - Parkview Villa North 1607 mgsp - MGS Professional Bldg Maint Sery Inc 02/15/2012 02/2012 65.55 165opr - Parkview Villa North 1608 sirnp - Simplex Grinnell 02/15/2012 02/2012 455.00 165opr - Parkview Villa North 1609 1:0003976 - Schander 02/15/2012 02/2012 2.5.00 165opr - Parkvlew Villa North 1610 adam - Adam's Pest Control, Inc. 02/23/2012 02/2012 48.97 165opr - Parkvlew Villa North 1611 cent - CenterPoint Energy 02/23/2012 02/2012 4,867.39 165opr - Parkview Villa North 1.612 chc - CommonBond Housing 02/23/2012 02/2012 601.69 165opr .. Parkview, Villa North 1613 Ibpm - LBP Mechanical, Inc 02/23/2012 02/2012 347.50 165opr - Parkview Villa North 1614 parkl - Park Supply of America, Inc. 02/23/2012 02/2012 144.04 165opr - Parkvlew Villa North 1615 xcel - Xcel Energy ,. ,,.__:.....G..« ».,.., .....«,......._,... u.-.—...,-,.._. :.b..<«..,Tn,..m.,__..M.».:..., 02/23/2012 ..__..ame.,..:......, 02/2012 „... ,.,��. 2,594.68 ..,., ........:.....m,,.,,.,...,, ... .m..,....<.,,R,m._,........ ,..,.. ..z,.T®.- w....w«o...«...- .T.,:. 32,650.60 0 2o) Parkview Villa South Financial Statement Overview February 2012 Revenue: Occupancy for the month of February was 96% occupied Total Revenue was lower than budget amount (unfavorable) Administrative Expenses: Administrative costs for South are over budget (unfavorable) due to servicing fees paid out to the City of Columbia Heights Advertising costs were under budget (favorable). Office Supplies were under budget (favorable) There were no Legal Expenses billed out for February. Telephone, Answering Service and Internet expenses are under budget (favorable). Misc. Admin. Expenses is over budget and reflects the servicing fee Utilities: Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing Electric was under budget (favorable) Gas was over budget (unfavorable) Water and Sewer were not invoiced in February Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Garbage and Trash Removal are under budget (favorable); however this is a quarterly billing. Repairs Material and Contract costs were under budget (favorable). Elevator Contract is under budget (favorable) Z Snow Removal costs were under budget (favorable) Heating and Cooling Maint and Repairs was over budget (unfavorable) and reflects cost of Zone Valve replacements Decorating contract costs were over budget (unfavorable), and reflect cost associated with carpet installation and vinyl installation and paint in one unit ZZ N + b W N W 888 [�R�C�aO'SHU'� NJAOJ NtOliO V1 WJ0N +bbNON pm oln o.+ yy y01 11tO�ON 10aJRWWVIJNO W(NIiO WON WpONNS S,W 0�0iOSS (p OOWi �WW(OIiOSAORNS00 N + A m(Oii O J O m W + W O O O O O O A J P A N O O W N O O A.SSSSOISSSS P 4a J IWi1 + +Np�A ONION AJpON�i W p�N lP 0001010 >OWiO N00 AO+ OUZO (0)i 0101A�W1NN +N(N11 WSN NAA�N 0W+0Wn00�00 +O(PO+ N OOS O m OSNOO�OOJIN e o J N py.W �Sb0 LJ A o m W m WJW N NOJ ryO1 pJN O A of o m P D IJ p y 'o momlNii �n elJnw o c � � D� Omar � N p m O O S O N SOT V O� F �m �� m= �� � �C)� v m �3 B 2n g,m 1n v O N H O N + b W N W 888 [�R�C�aO'SHU'� NJAOJ NtOliO V1 WJ0N +bbNON pm oln o.+ yy y01 11tO�ON 10aJRWWVIJNO W(NIiO WON WpONNS S,W 0�0iOSS (p OOWi �WW(OIiOSAORNS00 N + A m(Oii O J O m W + W O O O O O O A J P A N O O W N O O A.SSSSOISSSS P 4a J IWi1 + +Np�A ONION AJpON�i W p�N lP 0001010 >OWiO N00 AO+ OUZO (0)i 0101A�W1NN +N(N11 WSN NAA�N 0W+0Wn00�00 +O(PO+ N OOS N N N Np�N +WN OSNOO�OOJIN (Nli�O V J10� J N py.W �Sb0 LJ 4JO W+ O WJW N NOJ ryO1 pJN O A of o m P D IJ p y 'o momlNii �n elJnw p N O m O O p m O O S O N p1 O P N O O 01 O O ONi O N O u N A N N N Np�N +WN W 0 (Nli�O V J10� J N py.W �Sb0 LJ 4JO W+ 0 WJW ➢�o °O m NOJ ryO1 pJN O A of o m P p N + IJ IJ p y 'o momlNii �n elJnw NIJ ONS PI OiIWW N m O N N N Np�N +WN W 0 q O O N N J N A aCJi Avis Z +O Ll WJW ➢�o °O m NOJ ryO1 pJN O A of v + O A A i i W O IOO W aCJi Avis �l�p1O NO {Ap N O O Ili O O ryO1 pJN O A of O O p goo O S O O 000 N NNQOi O W O 4 fJ A Z A O J W U D Nl1 O � O J N A A i i W AN N Avis �l�p1O NO {Ap N O O Ili O O ryO1 pJN O A of O O p goo O S O O d yro O R yG nd 0 b nV E N( V m m e j d Z3_ v O m J N J °O W A m yW A °0 0 o °o D 9 V a A m W O O V � O !n NZSON !n A N Pu A A A n b W O O O O O O O O O O O S O W m O O O O = O W W W j UI m W to m �0 o g+ m ui yO A m Iola O P O (jl O Ill (All A a umi a J J O N A O N W OO VN +N WW1 8 O O O O pO O O pO O O S A R_i of O m J N J °O W A m yW A °0 0 o °o D 9 V a A m W O O V � O r !n NZSON !n A N Pu A A A n b W O O O O O O O O O O O S O W m O O O O = O W W W j UI m W to m �0 o g+ m ui yO A m Iola O P O (jl O Ill (All A a umi a J J O r !n NZSON !n A N Pu A A A n b W O O O O O O O O O O O S O W m O O O O = O O O O O O O O O O S O O O O O O O d to m �0 o g+ m ui yO A m Iola O W N a A N A O N W OO VN +N 0-I kI o19 SIN N yT N O O Q O A (Oi1 b N O O O O m A O N 0 0 0 Oml W m 0 0 0 0 0� 0 0 0 W ��llII m b"In000 °m °m �o,'o mSom v'w OOOOO(Wi1WJSN(JIIJOJOW r. v G ONmOVWW�NbmOO mm AmpN�INI��,O fj1 OO +OAON�IONIJll �1 INJJOJ m OON OJiON� OOONIJJ ON+N � OOWD.W+NODOOO(Y�O�N bb N N N+ A y p O J A p O j O W 0 ONi O O O> A A O N + N + N m m P 4 O J OHO W W+ m °oo °000mmwoo`r�owlJilm 6 °o °o °o °o °O mrn ki OO �o`6'g k1 OOm ' m +IIIl��P AWJO� WOmNiO OONONOJIWpO��OmOJAVOI !D ,(NIIW O O+ O O Y O A O A O N O A O 001 o ++ N NZSON J Oi�2000O�b�WW G N OI +ION +NmNN WmmNN+ p� OOO OO�LImmO+O(P 0O 1JO O N N W O N O W O O O O O O O O O O O S O W m O O O O = O O O O O O O O O O S O O O O O O O d OAi 10 �0 � 0 10 yO A m m O W N a A O O W N W OO +N WW1 8 O O O O pO O O pO O O S yT N O O Q O A (Oi1 b N O O O O m A O N 0 0 0 Oml W m 0 0 0 0 0� 0 0 0 W ��llII m b"In000 °m °m �o,'o mSom v'w OOOOO(Wi1WJSN(JIIJOJOW r. v G ONmOVWW�NbmOO mm AmpN�INI��,O fj1 OO +OAON�IONIJll �1 INJJOJ m OON OJiON� OOONIJJ ON+N � OOWD.W+NODOOO(Y�O�N bb N N N+ A y p O J A p O j O W 0 ONi O O O> A A O N + N + N m m P 4 O J OHO W W+ m °oo °000mmwoo`r�owlJilm 6 °o °o °o °o °O mrn ki OO �o`6'g k1 OOm ' m +IIIl��P AWJO� WOmNiO OONONOJIWpO��OmOJAVOI !D ,(NIIW O O+ O O Y O A O A O N O A O 001 A N / o ++ N NZSON J Oi�2000O�b�WW G N OI +ION +NmNN WmmNN+ p� OOO OO�LImmO+O(P 0O 1JO O N N W O N O W O O O O O O O O O O O S O W m O O O O = O O O O O O O O O O S O O O O O O O d A N / C 55 O n o 0 �nomZ E�m�m �D R m y° i R ow AA 0000 OR bt m'o iR m R oz �� w aaG�a2m g A N SW (OWN O m� o 00 00000 0 �� �irass z gzzgz DD DDDDD 'm m Vn1No O o .1. O° U $$ $$$$$ t N 8. W N N O O + O N+ W W O O S 0 000 ,N O W N 1 Z Z :N' m i Oi O O° 10: S 000 (Ny Nf z al a I a';`; 0 0 $ $ P 8 NJI Nm 41 O (WWI O A m Ny d R W ` S cu_ gzzz gzzzz g a'nan a'n n ° o0o boob c O S O O O S 0 000 ,N O W N 1 Z Z :N' m i Oi O O° 10: S 000 (Ny Nf z al a I a';`; 0 0 $ $ P 8 NJI Nm 41 O (WWI O A m Ny d R W ` S cu_ D z D P m v � v 0 °o °o v 0 D m M o _p W OLT ^. G Elm n m D e I SAC P C c -o3 m y 3a r N3 Fn N m z a D � C_ 0 °o °o v 0 D m Parkview Villa South (166) Balance Sheet February 2012 Books = Accrual Feb -12 Assets 20200 Accounts Payable 163,509.66 10100 Cash Balance 1,682.50 20210 Accrued Other Expenses 93.00 10200 Petty Cash 9,037.95 22000 Deposits 575,970.36 10400 Investments 14,835.19 22200 Accrued PILOT 9.00 11300 Rent Receivable 265.00 11500 Accounts Receivable 0.00 Total Liabilities 739,582.02 Total Assets Liabilities 20200 Accounts Payable 12,745.47 1,682.50 20210 Accrued Other Expenses 9,037.95 22000 Deposits 14,835.19 22200 Accrued PILOT 22210 Revenue Collected in Advance 265.00 38,565.21 Total Liabilities Fund Balance 700,713.57 25300 Fund Balance 700,713.57 Total Fund Balance Total Liabilities and Fund Balance 739,278.78 ON Parkview Villa -South (166) Income Statement For The Period Ending February 2012 Books = Accrual Revenue 36220 -46340 Gen. Government Rents 36225 -46340 Nondwelling Rents 36290 -46340 Other Miscellaneous Revenue 39120 -46340 Recovery Damage City Total Revenue Expenses Personal Services 1000 -46340 Accrued Salaries Total Personal Services Supplies 2000 -46340 Office Supplies 2010 -46340 Minor Equipment 2160 -46340 Maint. & Construct Materials 2171 -46340 General Supplies Total Supplies Other Services & Charges 3040 -46340 Legal Fees 3050 -46340 Expert & Professional Services 3060 -46340 Management Services 3100 -46340 Protective Services 3210 -46340 Telephone & Telegraph 3430 -46340 Advertising Other 3600 -46340 Insurance & Bonds 3810 -46340 Electric 3820 -46340 Water 3830 -46340 Gas 3840 -46340 Refuse 3850 -46340 Sewer 4000 -46340 Repair & Maint. Services 4100 -46340 Rents & Leases 4300 -46340 Miscellaneous Charges 4315 -46340 PILOT 4390 -46340 Taxes & Licenses 4500 -46340 Administrative Expenses 4850 -46340 Interest on Deposits Total Other Services & Charges Month to Date % Year to Date 24,878.31 94.72% 50,814.31 95.79% 509.00 1.94% 1,053.00 1.98% 877.68 3.34% 1,180.68 2.23% - 0.00% - 0.00% 26,264.99 100.000/0 53,047.99 100.000/0 3,723.00 14.17% 7,446.00 14.04% 3,723.00 14.17% 7,446.00 14.04% 31.71 0.12% 78.96 0.15% 0.00 0.00% 0.00 0.00% 38.77 0.15% 104.70 0.20% 112.70 0.43% 112.70 0.21% 183.18 0.70% 296.36 0.56% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 2,312.00 8.80% 4,337.00 8.18% 0.00 0.00% 0.00 0.00% 113.31 0.43% 172.09 0.32% 0.00 0.00% 0.00 0.00% 841.25 3.20% 1,682.50 3.17% 1,028.48 3.92% 1,028.48 1.94% 0.00 0.00% 0.00 0.00% 2,465.07 9.39% 2,465.07 4.65% 0.00 0.00% 34.39 0.06% 0.00 0.00% 0.00 0.00% 5,412.68 20.61% 9,406.80 17.73% 0.00 0.00% 0.00 0.00% 0.00 0.00% 25.58 0.05% 1,059.66 4.03% 2,119.32 4.00% 558.62 2.13% 558.62 1.05% 3,232.74 12.31% 3,232.74 6.09% 7.17 0.03% 14.64 0.03% 17,030.98 64.84% 25,077.23 47.27% 174 Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00 0.00% 0.00% 20,937.16 79.72% 32,819.59 61.87% 5,327.83 20.28% 20,228.40 38.13% 2� Parkview Villa South (166) Cash Flow Statement Period = February 2012 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 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 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits Total Other Services & Charges Total Expenses Month to Date 24,878.31 509.00 877.68 0.00 26,264.99 3,723.00 3,723.00 31.71 0.00 0.00 151.47 183.18 0.00 2,312.00 0.00 113.31 0.00 841.25 1,028.48 0.00 2,465.07 0.00 0.00 5,412.68 0.00 0.00 1,059.66 558.62 3,232.74 7.17 17,030.98 20,937.16 Parkview Villa South (166) Cash Flow Statement Period = February 2012 Excess (Deficit) Revenue over Expenses Adjustments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 5,327.83 (2.00) 3.00 0.00 4,496.44 841.25 (230.54) 1,059.66 (923.71) 5,244.10 10,571.93 Cash End Cash Difference 152,937.73 163,509.66 50,571.93 93.00 93.00 - 575,970.36 575,970.36 - 729,001.09 739,573.02 10,571.93 �l 3/13/2012 3:12 PM Parkview Villa South (166) General Ledger Period = Feb 2012 Book = Accrual Property Data Period P I..n/Pescrlptl COhIml Reference Debit Credit Uniame. Remarks 1000 -46340 A cued Salaries 3,723.01) = Beginning Bala, 166 2/29/2012 02/2012 PostRecurrin9 Roc 1-130488 RC 3,223.00 0.00 2,446.00 VC CDC PR From i Net Change= 3,223.00 2,446.00 = Ending Balance 2000 -46340 Office Supplies 47.25 = Beginning Bala, 166 2/312012 02/2012 Office Depot(ofOBE P- 260840 596838943001pvs 14.12 0.00 61.37 Vape. deskped etc. 166 218/2012 02/2012 Office Depot (SOME P- 268837 596839333001pvs 17.59 0.00 28.96 cards etc. Net Change=31.71 78.96 = Ending Balance 3160.46340 Malnt. & Construct Materials 65.93 = Beginning Bala, 166 1/27/2012 02/2012 HD Supply Focilitle, P- 267459 91131689O2pvs 19.72 0.00 85.70 thermocouples, ice 166 1/30/2012 02/2012 Home Oepot Credit P- 268842 561094 19.00 0.00 104.70 bulbs etc. Net Chan9e=38.72 104.70 = Ending Balance 2121 -46340 General Supplies 0.00 = Beginning Bala, 166 1/18/2012 02/2012 HD Supply Pucllltiet P- 267453 9112999196pvs 61.O1 0.00 61.01 trash liners, sponge 166 1/19/2012 02/2012 HD Supply Facilltie!P- 267456 9113025353pvs 13.80 0.00 74.81 glass cleaner, magi 166 2/1412012 02/2012 Buckeye Cleaning ( P-26991D 651311 32.89 0.00 112.70 roll towel Net Change= 112.70 112.20 = Ending Balance 3060 -46340 Management Services 2,025.00 = Beginning Bala, 166 2/29/2012 02/2012 Commonlord Hom P- 269944 926295 6,035.00 0.00 8,060.00 argue fees 02/12 166 2/29/2012 02/2012 Patt8ecurring Rec 1- 130488 RC 0.00 3,723.00 4,332.00 PVC CDC PR MgmtI Net Change= 1,312.00 4,332.00 = Ending Balance 3210 -46340 Telephone & Telegraph 58.78 = Beglnning Bala, 166 2/2/2012 02/2012 ComCase(CU11c342 P- 267450 877210505019618: 23.18 0.00 81.96 Internet svc 2111 -3 166 217/2012 0212012 Centaryl.ink(ImArl P- 269900 7637883978/02121 17.48 0.00 99.44 phone svc 2/02 -3 /C 166 2/11/2012 02/2012 MCI Comm Service P- 269203 2637883978/02121 11.16 0.00 110.60 phone svc- due 3/1 166 2/15/2012 02/2012 Office of Enterprise P- 269905 W12010671/0112p 61.49 0.00 172.09 phone svc- perem Net Change= 113.31 172.09 = Ending Balance 3600 -46340 Insurance & Bonds 84135 = Beginning Balm 166 2/2912012 02/2012 :Post Recurring Rec J- 130488 RC 841.25 0.00 1,6112.50 C of Columbia H.191 Net Change=841.25 1,682.50 = Ending Balance 3810 -46340 Electric 0.00 = Beginning Bala, 166 2/13/2012 02/2012 Xfel Energy (xce0 P- 268607 5150441553101121 0.00 561.88 - 561.88 at., cmdV vc 1/07 166 2/13/2012 02/2012 Scel Energy (scar) P- 268607 5150441553/01121 1,590.36 0.00 1,028.48 tie, creft /svc 1/07 Net Change= 1,028.48 1,028.48 = Ending Balance 3830 -46340 Gas 0.00 = Beginning Bala1 166 2/8/2012 02/2012 Camewo nt Energy P- 267952 5527132410112 2,465.07 DAD 2,465.07 gas svc 1/06 -2 /06 Net Change= 2,465.02 2,465.02 = Ending Balance 3840 -46340 Refuse 34.39 = Beginning Balm Net Change =0.00 34.39 = Ending Balance 4000 -46340 Repair& Maine. Services 3,994.12 = Beginning Balm 166 1/18/2012 0212012 Adam's Pest COatrc P- 268269 693236pvs 22.00 0.00 4,016.12 pest svc 1/18 166 1/23/2012 02/2012 MGS Professional B P- 262463 10361pes 29.45 0.00 4,045.57 snow Inner svc 1/23 166 1/27/2012 02/2012 HD Supply Fadiitie!P- 267459 911316B902pvs 15 .76 0.00 4,061.33 thermocouples, Ice 166 1/31/2012 02/2012 USA Mechanical, Or P- 267462 W16439 843.66 0.00 4,904.99 Zone valve svc -41 166 1/3112012 02/2012 BFB Painting, Inc (P- 268270 1312012pvs 280.00 0.00 5,184.99 painting -415 166 2/1/2012 02/2012 Eagle Elevator Corr P- 267451 11271B rises 309.18 0.00 5,494.17 me mount 02/12 166 2/1/2012 02/2012 Jerry's Floor Store, P- 267460 X630778 180.98 0.00 5,625.15 vinyl inst -415 166 2/1/2012 02/2012 Jerry's Floor Store. P- 267461 X630769 705.53 0.00 6,380.68 last Carp- 415 166 2/6/2012 02/2012 Bio Corps, LLC(bio P- 269202 120201 2,300.00 0.00 8,680.68 2 tech, - bio clean 166 2/8/2012 02/2012 Adam's Pest Cmtw P- 269201 698311pvs 22.00 0.00 8,702.68 pest svc 2/08 166 2/16/2012 02/2012 LBP Mechanical, lm P- 269909 W16607 449.67 0.00 9,152.35 Zone valve service 166 2/21/2012 02/2012 MGS Professional P- 269906 1O378pvs 29.45 0.00 9,181.80 snow Omar svc 2/21 166 2/23/2012 02/2012 Zephyr Services lm P- 269907 427 225.00 0.00 9,406.80 Sfieetmck repair - : Net Change= 5,412.68 9,406.80 = Ending Balance 430046340 Miscellaneous Charges 25.56 = Beginning Saint Net Change=e.00 25.58 = Ending Balance 431546340 PILOT 1,O59.66 = Beginning Bala, 166 2/2912012 02/2012 :Post Recurring Rec J- 130488 RC 1,O59.66 0.00 2,119.32 Anoka Cry Property Net Change= 1,059.66 2,119.32 = Ending Balance Page 1 of 22 3113/2012 3:17 PM Parkvlew Villa South (166) General Ledger Period = Feb 2012 Book = Accrual Property Oat. Period Par son /DescriPtl Control Rot e...¢ Dealt Credit Balance R.nlarke 0.00 = Beginning Bala 4390-46340 Taxes& Us ... Ea 166 2/22/2012 02/2012 Columbia Heights FP- 269633 022212pvs 558.62 0.00 558.62 Prop rental license Net Clonge=558.62 558.62 = Ending Balance 0,00 = Beginning Bala, 4500 -46340 Administrative Expenses 166 2/16/2012 02/2012 Comman0onl Hom P- 268511 921840 2.49 0.00 7.49 2011- 1099 /CRP car 166 2/12/2012 02/2012 Common Bond Hom P- 268317 921932 228.25 0.00 285.24 2011 CRP lees 166 2/21/2012 02/2012 City of Columbia lh P- 269631 2Dltpvs 2,942.00 0.00 3,232.74 pvs 2011 servicing Net Change= 3,232.74 3,23274 = Ending Balance 4850 -46340 Interest On Deposits 7.47 = Beginning Baia, 166 2/29/2012 02/2012 Sec Dep interest a,3131747 G31 7.12 O.OD 14.64 See Den interest ac Net Change =7.17 14.64 = Ending Balance 25,22204 4,284.88 Page 2 of 22 �� 5016464 Parkview Villa South 3112/12 Bank Reconciliation Report 02/29/2012 Balance Per Bank Statement as of 02/29/2012 $164,023.64 02/1112009 389 mcic - MCI Comm Service 5.47 01/19/2012 1296 10003793 - Johnson 199.06 02/15/2012 1321 mgsp - MGS Professional Bldg Maint Sery Inc 29.45 02/23/2012 1324 bfbp - BFB Painting, Inc. 280.00 Less: Outstanding Checks $513.98 gree1004 - Green Lights Recycling Inc Reconciled Bank Balance $163,509.66 Balance per GL as of 02/29/2012 $163,509.66 Reconciled Balance Per G/L $163,509.66 Difference 0.00 Cleared Items: Cleared Checks Date Tran # Notes Amount Date Cleared 01/19/2012 1293 comc3474 - Comcast 20.13 02129/2012 01/25/2012 1297 cent - CenterPoint Energy 2,195.07 02/2912012 1299 gree1004 - Green Lights Recycling Inc 34.39 02/2912012 01125/2012 1301 mgsp - MGS Professional Bldg Maint Sery Inc 55.03 02/29/2012 01/25/2012 1304 pet1661s - Laura Sheak 64.21 02/2912012 01/25/2012 02/01/2012 1306 cent9115- Centuryl-ink 17.48 02/29/2012 02/01/2012 1307 gard1086 - Gardner Plumbing, LLC 201.50 02/29/2012 02101/2012 1308 home7 - HD Supply Facilities Maintenance 69.85 02/2912012 02/01/2012 1309 mcic3718 - MCI Comm Service 7.69 02/29/2012 1310 mgsp - MGS Professional Bldg Maint Sery Inc 58.90 02/29/2012 02/01/2012 1311 1nndpl - MN Dept of Labor & Industry 30.00 02/29/2012 02101/2012 1312 offi8804 - Office Depot 23.61 02/29/2012 02/01/2012 02/08/2012 1313 chc - CommonBond Housing 5,748.00 02/2912012 02108/2012 1314 eagl1 - Eagle Elevator Corp. 1,592.00 02/29/2012 1315 kocl - K.O. Cleaning and Restoration LLC 500.00 02/2912012 02/08/2012 1316 comc3474 - Comcast 23.18 02/29/2012 02/15/2012 1317 eagl1 - Eagle Elevator Corp. 309.18 02129/2012 0211512012 1318 home7 - HD Supply Facilities Maintenance 110.34 02/29/2012 02/15/2012 1319 lerrl - Jerry's Floor Store 886.51 02/2912012 02115/2012 Ibpm - LBP Mechanical, Inc 843.66 02129/2012 02/1512012 1320 02/29/2012 02/29/2012 02/29/2012 02/29/2012 02/29/2012 Date Cleared 02/29/2012 02/29/2012 02/29/2012 02/29/2012 02/29/2012 15 3/12/12 Parkview Villa South Bank Reconciliation Report 02/29/2012 5016464 02/15/2012 1322 10006372 - Field 332.11 02/23/2012 1323 adam - Adam's Pest Control, Inc. 22.00 02/23/2012 1325 cent - CenterPoint Energy 2,465.07 02/23/2012 1326 clic- CommonBond Housing 285.74 02/23/2012 1327 xcel - Xcel Energy 1,028.48 $16,924.13 Total Cleared Deposits Date Tian # Notes Amount 02/0212012 287 laundry receipt 289.39 02102/2012 288 rent deposit 16,423.00 02/03/2012 289 rent deposits 7,469.29 02106/2012 290 operations 596.00 02/14/2012 291 dep 659.00 $25,436.68 Total 02/29/2012 02/29/2012 02/29/2012 02/29/2012 02/29/2012 Date Cleared 02/29/2012 02/29/2012 02/29/2012 02/29/2012 02/29/2012 15 3/12/12 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 Date 2/29/12 Page 1. Primary Account @XXXXX @6464 Enclosures 32 A C C O U N T S - - -- EFFECTIVE MARCH 1, 2012 WIRE TRANSFER FEES FOR OUTGOING DOMESTIC WIRES WILL BE INCREASED TO $20 AND AN EARLY ACCOUNT CLOSING FEE OF $20 WILL BE CHARGED FOR DDA AND SAVINGS ACCTS CLOSED IN LESS THAN 3 MONTHS AND LIEALTH SAVINGS ACCTS PRIOR TO 3 YEARS. THE MAXIMUM DAILY LIMIT FOR NSY PAID AND RETURNED TM EMFEE(CONSUMER ONLY) IS$1220 . NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 Account Number Previous Balance 155,511.09 6 Deposits /Credits 25,446.68 26 Checks /Debits 16,934.1030 Service Charge .00 Interest Paid 164,023.64 Ending Balance Number of Images 32 Statement Dates 2/01/12 thru 2/29/12 Days in the Statement Period 29 Average Ledger 170,890 Average Collected 169,827 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Deposits and Credits Check# Amount Date Description 58.90 289 39 2/02 DDA REGULAR DEPOSIT 16,423.00 2/02 DDA REGULAR DEPOSIT 7,469.29 2/03 DDA REGULAR DEPOSIT 10.00 2/06 DDA REGULAR DEPOSIT 596.00 2/06 DDA REGULAR DEPOSIT 659.00 2/14 DDA REGULAR DEPOSIT *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Charges and Debits Amount Date Description 10.00 DR 2/03 DDA DEBIT MEMO *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Checks in serial order Date Check# 2/01 1 2/27 110* 2/01 1293* * Indicates skip in check Amount Date Check# 64.21 2/02 1297* 58.90 2/01 1299* 20.13 2/27 1301* numbers Amount 2,195.07 34.39 55.03 Date 2/29/12 Page 2 Primary Account @XXXXX @6464 Enclosures 32 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Checks in Date serial order Check# Amount Date Checkdk Amount 2/07 1306* 17.48 2/21 1317 309.18 2/07 1307 201.50 2/23 1318 110.34 2/08 1308 69.85 2/21 1319 886.51 2/10 1309 7.69 2/24 1320 843.66 2/06 1311* 30.00 2/24 1322* 332.11 2/09 1312 23.61 2/29 1323 22.00 2/10 1313 5,748.00 2/29 1325* 2,465.07 2/13 1314 1,592.00 2/27 1326 285.74 2/14 1315 500.00 2/27 1327 1,028.48 2/22 1316 23.18 * Indicates skip in check numbers *********************************************** * * * * * * * ** * * * * * * * * * * * * * * * * * * * * ** Daily Balance Section Date Balance Date Balance Date Balance 2/01 155,392.36 2/09 177,632.53 2/23 169,114.63 2/02 169,909.68 2/10 171,876.84 2/24 167,938.86 2/03 177,368.97 2/13 170,284.84 2/27 166,510.71 2/06 177,944.97 2/14 170,443.84 2/29 164,023.64 2/07 177,725.99 2/21 169,248.15 2/08 177,656.14 2/22 169,224.97 * * * E N D O F S T A T E M E N T 31 Payment Summary Bank= 166opr AND mm /yy= 02/2012- 02/2012 AND All Checks =Yes AND Include Volds =All Checks ■ Check Post Total Bank Check# Vendor Date Month Amount 166opr - Parkview Villa South 1306 cent9115 - Century Link 02/01/2012 02/2012 17.48 166opr - Parkview Villa South 1307 gard1086 - Gardner Plumbing, LLC 02/01/2012 02/2012 201.50 166opr - Parkview Villa South 1308 home? - HD Supply Facilities Maintenance 02/01/2012 02/2012 69.85 166opr - Parkview Villa South 1309 mc1c3718 - MCI Comm Service 02/01/2012 02/2012 7.69 166opr - Parkview Villa South 1310 mgsp - MGS Professional Bldg Maint Sery Inc 02/01/2012 02/2012 58.90 166opr - Parkvlew Villa South 1311 mndpl - MN Dept of Labor & Industry 02/01/2012 02/2012 30.00 166opr - Parkview Villa South 1312 off18804 - Office Depot 02/01/2012 02/2012 23.61 166opr - Parkview Villa South 1313 chc - CommonBond Housing 02/08/2012 02/2012 5,748.00 166opr - Parkview Villa South 1314 eag11 - Eagle Elevator Corp. 02/08/2012 02/2012 1,592.00 166opr- Parkview Villa South 1315 kocl- K.O. Cleaning and Restoration LLC 02/08/2012 02/2012 500.00 166opr - Parkview Villa South 1316 comc3474 - Comcast 02/15/2012 02/2012 23.18 166opr - Parkvlew Villa South 1317 eaglI - Eagle Elevator Corp. 02/15/2012 02/2012 309.18 166opr - Parkview Villa South 1318 home7 - HD Supply Facilities Maintenance 02/15/2012 02/2012 110.34 166opr - Parkview Villa South 1319 jerrl - Jerry's Floor Store 02/15/2012 02/2012 886.51 166opr - Parkview Villa South 1320 Ibpm - LBP Mechanical, Inc 02/15/2012 02/2012 843.66 166opr - Parkvlew Villa South 1321 mgsp - MGS Professional Bldg Maint Sery Inc 02/15/2012 02/2012 29.45 166opr - Parkview Villa South 1322 t0006372 - Field 02/15/2012 02/2012 332.11 166opr - Parkvlew Villa South 1323 adam - Adam's Pest Control, Inc. 02/23/2012 02/2012 22.00 166opr - Parkvlew Villa South 1324 bfbp - BFB Painting, Inc. 02/23/2012 02/2012 280.00 166opr- Parkvlew Villa South 1325 cent- CenterPoInt Energy 02/23/2012 02/2012 2,465.07 166opr - Parkvlew Villa South 1326 chc - CommonBond Housing 02/23/2012 02/2012 285.74 166opr - Parkvlew Villa South 1327 xcel - Xcel Energy 02 23 12 02/2012 1,028.48 14,864.75 ■ Parkview Villa North Financial Statement Overview January 2012 Revenue: Occupancy for the month of January 2012 was 100% occupied; Total Revenue was under budget amount (unfavorable). No Grant Income was recognized in the month of January. Administrative Expenses: Administrative costs for the North were under budget (favorable). Other Renting Expenses were under budget (favorable), and reflect minimum applicant screening needed due to low turnover. Office Salary line shows the staffing portion for North per contract, both office and maintenance staff. Office Supply expenses are under budget (favorable) Legal Expenses Project was under budget (favorable). Telephone, Answering Service and Internet expenses are under budget (favorable). Utilities: Utilities Expenses are under budget (favorable), however, these are quarterly billings No Utilities were invoiced or paid in the month of January. Oeeratine and Maintenance Expense (supplies): Operating and Maintenance Expenses are under budget (favorable). Janitor and Cleaning Supplies are under budget (favorable). Janitor Contract expenses were slightly over budget (unfavorable), Exterminating Contract is under budget (favorable) Maintenance Supplies is over budget (unfavorable) and reflects cost of replacement of 2 toilets Garbage and Trash are under budget (favorable); this reflects only recycling of appliances, regular trash removal invoices quarterly. Security Contract is over budget (unfavorable). This reflects the costs of replacing all sprinkler heads Repairs Contract expenses were under budget (favorable) Elevator Maintenance Contract is under budget (favorable). Snow Removal is under budget (favorable). Decorating Contract and Supplies were under budget (favorable) Furniture and Fixtures is under budget (favorable) Z O 0 0 Z A 6i 3 Z �' ° tCL m Wd�m 71 0d00 G1AA C D` `e a 3 z78 &' 3 S �^ m A O N � A N ?n m m m W P. O P O O O O O O O+ N 0 0 0 O J O UJi O UUi 0. O O O O O O O O O CCC- + A + A O O W A W Q N W N + A + P O O O W A W O N W W W P N W N 88888 O O O O O O O O O O + A + A O N N .0N.. + P + A i q O m �O(NI�W (Jli P +OPAJNiONN +N N O+ N O+ N N N O OOJW(NIiOJ0000 +pAN U� p O W+ Ili J O O U W N A mWW JWN000(I�OU + WN A W O O A O A A A O W AW 000OJi00N000 A N + W A N W W+ N +J M p a +N000OJ OIJIi0U0i p P W N O N N O N N O O O J W UNi O J O O O O bm'p&NJ'ooNmNg �OJWVNi000N0(01 O1N +� m miJ N T 01 A N u o m N N N o W mNT b U�NUWI O O O + O O O O N O N J VI VIN UNi 000 W ,NOW O O O O O O O P 8 C cea i a-a aa° d a•e p� N O> N + N O J qmo °o A N 00 °O Y N AIUWi INn 0A o � 0 0 0 0 0 e � � W O 0 mu A O m L ° iro O O O O O °oo °o °U °o mo °WP.`d... °oNo °oo D N O(JI�O (li AOOOOOVOOJO00 � N 00000 OIOOOOOOOONO00 O1N +� m miJ N T 01 A N u o m N N N o W mNT b U�NUWI O O O + O O O O N O N J VI VIN UNi 000 W ,NOW O O O O O O O P 8 C cea i a-a aa° d a•e p� N O> N + N O J qmo °o A N 00 °O Y N AIUWi INn 0A o � 0 0 0 0 0 e � � W O 0 mu A O m L ° iro pm� pKp�' 'o a o n w ia ia o$ fMi �T 8 d m 0o °'v o o M s T N S D O N V � � N i wpm wpm �mo0� om�o����o °omNOso (0J00010010 WW ONjP +NNO qN lm W O J J O J S W O O J J J N J S Oi W pp N W A N J N J W S O O 4Wi + N N W O p J J OI Ni � y y mob +1OW00W NOONTOOVwiO O{bE{ O .0o.. O S O 1N 0 0 0. N O S. S O' UNi WO. YyNOOIOm pw ON�P OIO N1 J O (wJ O J J S J S W O O I J N J O 001 R n J N A Ww (NO r NO W NWO�m OOi+O ONOSwNw W> N J N J (WJ 0 0 0 W� N N IWJ O r O �NOSOAJZOONO�i S(JO O pA� A (O •O 10 (b S N ffODJ 0 Oi W � WO OONSOO SOOQ�O (➢1100 N w JOJ b 01 00 A A is N N N O O S S B S S A }F fm0 b tO OI N NV W pLl m W J O Owl N (ll N 608 !D 4Ni SS YOJ W NN fll N(J)i 000 A l0 f"li W W j N N 0 S W W J V O wpm wpm �mo0� om�o����o °omNOso (0J00010010 WW ONjP +NNO qN lm W O J J O J S W O O J J J N J S Oi W pp N W A N J N J W S O O 4Wi + N N W O p J J OI Ni � y y mob +1OW00W NOONTOOVwiO O{bE{ O .0o.. O S O 1N 0 0 0. N O S. S O' UNi WO. YyNOOIOm pw ON�P OIO N1 J O (wJ O J J S J S W O O I J N J O 001 R n J N A Ww (NO r NO W NWO�m OOi+O ONOSwNw W> N J N J (WJ 0 0 0 W� N N IWJ O r O �NOSOAJZOONO�i S(JO O pA� A (O •O 10 (b S N ffODJ 0 Oi W � WO OONSOO SOOQ�O (➢1100 N JOJ b 01 00 A A is N N N O O S S B S S N wpm wpm �mo0� om�o����o °omNOso (0J00010010 WW ONjP +NNO qN lm W O J J O J S W O O J J J N J S Oi W pp N W A N J N J W S O O 4Wi + N N W O p J J OI Ni � y y mob +1OW00W NOONTOOVwiO O{bE{ O .0o.. O S O 1N 0 0 0. N O S. S O' UNi WO. YyNOOIOm pw ON�P OIO N1 J O (wJ O J J S J S W O O I J N J O 001 R n J N A Ww (NO r NO W NWO�m OOi+O ONOSwNw W> N J N J (WJ 0 0 0 W� N N IWJ O r O �NOSOAJZOONO�i S(JO O W A N W➢ (P O W J O w W _+ _W OJOp0 N OONSOO SOOQ�O (➢1100 N N o O O o O boo O O O O + O pO + O O UJi00 +�00 Z Z z � Z Z Z DDD DDDD J N W P O O O + O O N O O N+ O O ... O U O O O O O O O O O jNP al�0o 00 NOO �`�00 zzz z,, zzz DDD DDDD D o' n C D N o 0 m o 6I' o W n G ' D Er o E o o P R "-� z o P s a a < OO � 0 000 0000 O n m � N N y C� " VIII` - =nw g2c" 5D�8 a v, N8go °m ol�sy� -• duo i riw.Zr Q.nd x a000� CG.p ° Z N v oGH =A a'0 t{ P y y. o O z �o�� adv m R p�AA� m^o 0°mom � m A o O O o O boo O O O O + O pO + O O UJi00 +�00 Z Z z � Z Z Z DDD DDDD J N W P O O O + O O N O O N+ O O ... O U O O O O O O O O O jNP al�0o 00 NOO �`�00 N W N m OWi J W O O +1 O O W W N 01 J O O Z Z Z DDDD D N (NJ O W N W II 9Io o S U O 7 O W� W N mJ o °o DID D D tl O O O O 3 O O O O O A- O Ji � VI I� A O1 V J a J J dE 9 V J O W W Vp J N Omi N d W N yN 4i W i s 0n E V J +1 J dff N J V mm m w W W 6 W � m V J �O N N Nm8 N N e WO I N N O O C i 0001 W zzz z,, zzz DDD DDDD D o' v° D 0 0 � 0 000 0000 O � N 000 0000 O N W N m OWi J W O O +1 O O W W N 01 J O O Z Z Z DDDD D N (NJ O W N W II 9Io o S U O 7 O W� W N mJ o °o DID D D tl O O O O 3 O O O O O A- O Ji � VI I� A O1 V J a J J dE 9 V J O W W Vp J N Omi N d W N yN 4i W i s 0n E V J +1 J dff N J V mm m w W W 6 W � m V J �O N N Nm8 N N e WO I N N O O C i 0001 W ± / G) § ®§| ] - § \ \ / ®§� 4 ) ( t ± / G) p ; § ®§| ] / ®§� 4 p ; ;;# ƒ ( ƒ} Parkview Villa -North (165) Balance Sheet January 2012 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Liabilities Fund Balance 25300 Fund Balance Total Fund Balance Total Liabilities and Fund Balance Jan -12 223,562.66 457.00 823,425.08 2,850.00 250.00 22,852.63 1,073,397.37 22,389.54 1,741.75 551.74 17,758.06 24,053.94 1,689.00 68,184.03 1,005,213.34 1,005,213.34 1,073,397.37 I Parkview, Villa -North (165) Income Statement For The Period Ending January 2012 Books = Accrual Month to Date % Year to Date Revenue 0.00 0.00% 0.00 0.00% '.. 33160 -46330 Federal Grant - 0.00% - 0.00% 36220 -46330 Gen. Government Rents 28,558.00 96.32% 28,558.00 96.32% 36225 -46330 Nondwelling Rents 320.00 1.08% 320.00 1.08% 36290 -46330 Other Miscellaneous Revenue 771.00 2.60% 771.00 2.60% 39120 -46330 Recovery Damage City Property - 0.00% - 0.00% Total Revenue 29,649.00 100.000/0 29,649.00 100.000/0 Expenses Personal Services 1000 -46330 Accrued Salaries 8,357.00 28.19% 8,357.00 28.19% Total Personal Services 8,357.00 28.19"70 8,357.00 28.190/0 Supplies 0.00 0.00% 0.00 0.00% '.. 2000 -46330 Office Supplies 221.67 0.75% 221.67 i 0.75% 2010 -46330 Minor Equipment 0.00 0.00% 0.00 0.00% 2160 -46330 Maint. & Construct Materials 1,230.12 9.15% 1,230.12 4.15% 2171 -46330 General Supplies 287.26 0.97% 287.26 0.97% Total Supplies 1,739.05 5.87% 1,739.05 5.87016 Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 0.00 0.00% '.. 3050 -46330 Expert and Professional Services 0.00 0.00% 0.00 0.00% 3060 -46330 Management Services 4,545.00 15.33% 4,545.00 15.33% 3100 -46330 Protective Services 3,212.00 10.83% 3,212.00 10.83% 3210 -46330 Telephone & Telegraph 181.12 0.61% 181.12 0.61% 3430 -46330 Advertising Other -94.05 0.00% -94.05 - 0.32% 3600 -46330 Insurance & Bonds 1,741.75 5.87% 1,741.75 5.87% 3810 -46330 Electric 0.00 0.00% 0.00 0.00% 3820 -46330 Water 0.00 0.00% 0.00 0.00% 3830 -46330 Gas 0.00 0.00% 0.00 0.00% 3840 -46330 Refuse 76.56 0.26% 76.56 0.26% 3850 -46330 Sewer 0.00 0.00% 0.00 0.00% 4000 -46330 Repair & Maint. Services 4,200.75 14.17% 4,200.75 14.17% 4100 -46330 Rents & Leases 6.75 0.02% 635 0.02% 4300 -46330 Miscellaneous Charges 0.00 0.000% 0.00 0.00% 4315 -46330 PILOT 1,850.30 6.24% 1,850.30 6.24% 4390 -46330 Taxes & Licenses 0.00 0.00% 0.00 0.00% 4500 -46330 Administrative Expenses 0.00 0.00% 0.00 0.00% 4850 -46330 Interest on Deposits 13.31 0.04% 13.31 0.04% Total Other Services & Charges 15,733.49 53.07070 15,733.49 53.07% Capital Outlay 5120 -46330 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 587.67 0.00% 587.67 1.98% 587.67 1.980/0 587.67 1.980/0 26,417.21 89.10% 26,417.21 89.10% 3,231.79 10.900/0 3,231.79 10.900/0 I Parkview Villa -North (165) Cash Flow Statement Period = January 2012 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 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3620 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maint. Services 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits 5120 Building & Improvement Total Other Services & Charges Total Expenses Excess (Deficit) Revenue over Expenses Month to Date 0.00 28,558.00 320.00 771.00 0.00 29,649.00 8,357.00 8,357.00 221.67 0.00 0.00 1,517.38 0.00 1,739.05 0.00 4,545.00 3,212.00 181.12 -94.05 1,741.75 0.00 0.00 0.00 76.56 0.00 4,200.75 6.75 0.00 1,850.30 0.00 0.00 13.31 587.67 16,321.16 26,417.21 3,231.79 10 Parkview Villa -North (165) Cash Flow Statement Period = January 2012 Book = Accrual Adjustments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 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 - 357.00 - 150.00 63,336.50 - 20,246.64 1,741.75 201.91 1,850.30 460.00 46,836.82 50,068.61 Cash End Cash Difference 173,494.05 223,562.66 50,068.61 457.00 457.00 - 725,325.08 725,325.08 - 899,276.13 949,344.74 50,068.61 3/12/2012 3:18 PM Parkview Villa- North(165) General Ledger Period = ]an 2012 Book = Accrual Period Person/ Description Control Reference Debit Credit Balance Remarks Property :Date 0.00 = Beginning Balance = 1000 -46330 Accrued Salaries 8,357.00 0.00 8,357.00 R/C CHC PR Mgmt Fee 165 1/31/2012 01/2012 :POStRecurrl ng Monthly recurring enb 3- 128699 RC 8,357.00 = Ending Balance = Net Change= 8,357.00 0.00 = Beginning Balance = 2000 -46330 Office Supplies 169.12 0.00 169.12 postage, cards 165 1/4/2012 01/2012 Laura Shook (pet1651s) P- 263602 010412pvn 1/11/2012 01/2012 Office Depot(of88804) P- 264721 593407841001pvn 5255 0.00 221.67 paper, envelopes etc. 165 221.67 = Ending Balance = Net Change = 221.67 0.00 = Beginning Balance = 2160 -46330 Maim. & Construct Materials 0.00 56.25 wrap lens 16S 1/4/2012 01/2012 Laura Sheak(pet1651s) P- 263602 010412pvn 56.25 1/512012 01/2012 Gardner Plumbing, LLC (9ard1086) P- 264591 2388 868.86 0.00 925.11 wall hung water closets -. 165 01/2012 Park Supply of America, Inc. (parkl) P- 263600 39490300 43.93 0.00 969.04 wrench, Bush valve 165 3/6/2012 01/2012 HD Supply Facilities Maintenance (hoi P- 264594 9112865015pvn 113.38 0.00 1,082.42 spindle, steel chain etc. 165 1/11/2012 1/12/2012 01/2012 HD Supply Facilities Maintenance (ho, P- 264595 9112902652pvn 42.09 0.00 1,124.51 ice melt 165 1/19/2012 0112012 home Depot Credit Services (home3: P- 265899 1990873 105.61 0.00 wt thread seal etc. 165 1,2 0.12 Ending a Net Change= 1,230.12 0.00 = Beginning Balance = 2171 -46330 General Supplies 12.16 0.00 12.16 spry paint, potting soil 165 1/4/2012 01/2012 Laura Shook (pet1651s) P- 263602 010412pvn 165 1/12/2012 01/2012 Sherwin - Williams Co. (Sher4110) P- 264725 5327 -4 275.10 0.00 287.26 paint Net Change = 287.26 287.26 = Ending Balance = 0.00 = Beginning Balance = 3060 -46330 Management Services 12,902.00 0.00 12,902.00 mgmt fees 01/12 165 1/31/2012 01/2012 Comr-am and Housing (chc) P- 265228 911660 165 1/31/2012 01/2012 :POStRecurring Monthly recurring evil ]- 128699 RC 0.00 8,357.00 4,545.00 R/C CHC PR Mgmt Fee 41545.00 = Ending Balance = Net Change = 4,545.00 0.00 = Beginning Balance = 3100 -46330 Protective services 3,212.00 0.00 3,212.00 sprnklr head real- 87 165 1/23/2012 01/2012 Olsen Fire Inspection, Inc. (else) P- 264723 54373 3,212.00 = Ending Balance = Net Change = 3,212.00 0.00 = Beginning Balance = 3210 -46330 Telephone &Telegraph 0.00 30.27 answr Svc 01/12 165 1/1/2012 01/2012 AnswerLive LLC(answ) P- 262015 111204620101pvu 30.27 1/2/2012 01/2012 Comcast(comc3474) P- 262537 877210505019618 44.82 0.00 75.09 Internet Svc 1/11 -2/10 165 01/2012 Centur tink(cent9115) P- 264586 7637883978/0112, 38.90 0.00 113.99 phone Svc 01112 165 1/7/2012 Service(mcic3718) P- 264711 7637883978/12111 17.13 0.00 131.12 phone Svc 12/20 -01 /10 165 1/11/2012 01/2012 MCI Comm 0.00 181.12 set up fee answ Svc 165 1/19/2012 01/2012 Level One (love) P- 264705 219890 -IN 50.00 Net Change= 181.12 181.12 = Ending Balance = 0.00 = Beginning Balance = 3430 -46330 Advertising Other 94.05 -94.05 Ad 10/20 165 1/27/2012 01/2012 Sun Newspaper(sunn) P- 264393 1344053- 264393 0.00 165 1/27/2012 01/2012 Sun Newspaper(sunn) P- 264393 1344053- 264393 94.05 0.00 D.00 Ad 10120 1/27/2012 01/2012 Sun Newspaper(sunn) P- 264393 1344053- 264393 0.00 94.05 -94.05 Ad 10/20 165 -94.05 = Ending Balance = Net Change = -94.05 0.00 = Beginning Balance = 3600 -46330 Insurance & Bonds 1,741,75 0.00 1,741.75 C of Columbia Heights Ins 165 1/31/2012 01/2012 :PostRecurring Monthly recurring enb]- 128699 RC 1,741.75 = Ending Balance = Net Change = 1,741.75 0.00 = Beginning Balance = 3840 -46330 Refuse 76.56 0.00 76.56 appl recycling 1/05 165 1/5/2012 01/2012 Green Lights Recycling Inc (gree1004 P- 263587 12- 1039pvn 76.56 = Ending Balance = Net Change =76.56 0.00 = Beginning Balance = 4000 -46330 Repair & Maint. Services P 688.17 0.00 688.17 mo malnt - 01/12 165 111/2012 01/2012 Eagle Elevator Corp. (eag11) P- 263586 112124 -Ipvn 01/2012 K.O. Cleaning and Restoration LLC (k P- 262545 2031 400.00 0.00 1,088.17 painting etc. #211 165 1/3/2012 Cleaning and Restoration LLC (k P- 262545 2031 300.00 0.00 1,388.17 painting etc. 4211 165 1/3/2012 01/2012 K.O. Bldg Paint Sery Inc P- 263598 10333pvn 122.48 0.00 1,510.65 snow rmvl Svc 01/01 165 1/6/2012 01/2012 MGS Professional 263601 424 478.45 0.00 1,989.10 prey malnt- pre nspec 165 1/8/2012 01/2012 Zephyr Services Inc.(reph) P- 0.00 2,894.39 vinyl lost - 221 165 1/9/2012 01/2012 Jerry's Floor Store (jerrl) P- 263596 X630716 905.29 1/9/2012 01/2012 Jerry's Floor Store ( jerrl) P- 263597 X630714 556.26 0.00 3,450.65 vinyl lnst- 104 165 165 1/12/2012 01/2012 Drain King, Inc. (dral7740) P- 265896 82563 135.00 0.00 3,585.65 Plbg Svc - 502 1/13/2012 01/2012 Direct Home Appliance Services (dire P- 264590 011312p m 84.00 0.00 3,669.65 water repair Svc 16S Page Iof2 1 Z 3/12/2012 3:18 PM Parkview Villa -North (165) General Ledger Period = Ian 2012 Book = Accrual .._r 165 1/13/2012 01/2012 _ K.O. Cleaning and Restoration LLC (k P- 264597 _. 2032 225.00 0.00 3,894.65 bath wall repair 165 1/13/2012 01/2012 K.O. Cleaning and Restoration LLC (k P- 264698 2033 50.00 0.00 3,944.65 wall base Inst - 206 165 1/13/2012 01/2012 K.O. Cleaning and Restoration LLC (k P- 264701 2034 125.00 0.00 4,069.65 cab door reface 165 1/16/2012 01/2012 PIGS Professional Bldg Maint Sew Inc P- 264719 10340pvn 65.55 0.00 4,135.20 snow rmvl svc 01/20 165 1/20/2012 01/2012 PIGS Professional Bldg Plaint Sew Inc P- 264717 10347pvn 65.55 0.00 4,200.75 snow rmvl svc 01/20 Net Change = 4,200.75 4,200.75 = Ending Balance = 0.00 = Beginning Balance = 4100 -46330 165 1/13/2012 01/2012 Rents & Leases CommonBOnd Housing (chc) P- 263124 906310 6.75 0.00 6.75 Talx emply verif 12/11 6.75 = Ending Balance = Net Change =6.75 0.00 = Beginning Balance = 4315 -46330 1/31/2012 01/2012 PILOT :PostRecurring Monthly recurring enhl- 128699 RC 1,850.30 0.00 1,850.30 Anoka Cty Property Tax A( 165 Net Change= 1,850.30 1,850.30 = Ending Balance = 4850 -46330 Interest on Deposits 0.00 = Beginning Balance = 165 1/31/2012 01/2012 Sec Drip Interest accrual 1- 129296 G31 1331 0.00 13.31 Sec Dep interest accrual Net Change =13.31 13.31 = Ending Balance = 5120 -46330 Building &Improvements 0.00 = Beginning Balance = 165 1/16/2012 01/2012 WAI Continuum (walc) P- 264728 11068 587.67 0.00 587.67 archi services to 01/15/12 Net Change = 587.67 567.67 = Ending Balance = 34,962.31 8,545.10 Page 2 of 2 13 5016456 Parkview Villa North Bank Reconciliation Report 01/31/2012 Balance Per Bank Statement as of 01/31/2012 02/0912011 1199 court325 - Court Administration 02/09/2011 1200 court325 - Court Administration 12122/2011 1545 tOOD4004- Alunovic 01/25/2012 1572 cent - CenterPoint Energy 01/25/2012 1575 gree10D4 - Green Lights Recycling Inc 01/25/2012 1578 mgsp - MGS Professional Bldg Maint Saw Inc 01/25/2012 1580 park/ - Park Supply of America, Inc. 01125/2012 1581 pet1651s - Laura Sheak 01125/2012 1584 zeph - Zephyr Services Inc. Less: Outstanding Checks Reconciled Bank Balance Balance.per GL as of 01/31/2012 Difference Cleared Items: Cleared Checks Date Tran # 12114/2011 1531 12/22/2011 1541 12/2212011 .1542 12/22/2011 1544 12129/2011 - 1546 12129/2011 1547 12/2912011 1548 12/2912011 1549 12/29/2011 1550 12/29/2011 1551 12129QOI1 1552 12/29/2011 1553 12/2972011 1554 01/0512012 1555 01/05/2012 1556 01/05/2012 1557 Reconciled Balance Per G/L $230,215.48 55.00 320.00 120.55 5,198.32 76.56 122.48 43.93 237.53 478.45 $6,652.82 $223,562.66 2/16/12 $223,562.66 $223,562.66 0.00 Notes Amount Date Cleared gard1086 -Gardner Plumbing, LLC 135.00 01/31/2012 ligh3326 - Lighting Plastics of MN INC 134.10. 01/31/2012 mgsp - MGS Professional Bldg Maint Sew Inc 122.48 01/31/2012 offi8804 - Office Depot 60.94 01/31/2012 adam - Adam's Pest Control, Inc. 492.94 01/31/2012 cent9115 - Centuryl-ink 38.78 01/31/2012 chc- CommonBond Housing 110.00 01/31/2012 home7 - HD Supply Facilities Maintenance 521.36 01131/2012 keel - K.O. Cleaning and Restoration LLC 300.00 01/31/2012 moc3716 - MCI Comm Service 24.30 01/31/2012 park1 - Park Supply of America, Inc. 145.98 01/31/2012 xcel- Xcel Energy 3,509.24 01131/2012 zeph- Zephyr Services Inc. 7,289 -.00 01131/2012 all - All Inc. 460.50 01131/2012 dire - Direct Home Appliance Services 89.01 01/31/2012 jeml - Jerry's Floor Store 190.52 01/31/2012 Parkview Villa North Bank Reconciliation Report 01/31/2012 5016456 01/05/2012 1558 offi658- Office of Enterprise Technology 132.42 01/31/2012 01/05/2012 1559 zeph- Zephyr Services Inc. 505.00 01131/2012 01/11/2012 1560 chc - CommonBond Housing 13,161.31 01/31/2012 01/11/2012 1561 waic - WAI Continuum 3,729.24 01/31/2012 01/19/2012 1562 all - All Inc. 1,482.50 01/31/2012 01/19/2012 1563 answ - AnswerLive LLC 3027 01/31/2012 01/19/2012.. 1564 bfbp - BFB- Painting, Inc. 1,675.00 01/31/2012 01/19/2012 1565 colu - -City of Columbia Heights 7,217.81 01/31/2012 01/19/2012 1566 comc3474 - Comcast 44.82 01/31/2012 01/19/2012 - 1567 kocl - K.O. Cleaning and Restoration LLC 700.00 01/31/2012 01/1912012 1568 offi8804 -Office Depot 68.37 01/31/2012 01/19/2012 1569 parkl - Park Supply of America, Inc. 666.39 01/31/2012 01/19/2012 1570 sher4110 - Sherwin- Williams Co. 275.10 01/31/2012 01/19/2012 1571 t0003996- Piersak 211.40 01/31/2012 01/25/2012 1573 chc - CommonBond Housing 6.75 01/3112012 01/25/2012 1574 eagll - Eagle Elevator Corp. 688.17 01/31/2012 01/25/2012 1576 home32 - Home Depot Credit Services 110.56 01/31/2012 01/25/2012 1577 jerrl - Jerry's Floor Store 1,461.55 01/31/2012 01/25/2012 1579 multi - Multihousing Credit Control 125.00 01/31/2012 01/25/2012 1582 shea - Laura Sheak 17.76 01/31/2012 01/25/2012 1583 xcel. - Xcel Energy 4,157.22 01/31/2012 Total $50,090.79 Cleared Deposits Date Tran # Notes Amount Date Cleared 01/05/2012 367 dep - pvn - 01/05/12 25,692.00 01/31/2012 01/0912012 366 rent deposits 2,885.00 01/31/2012 01/11/2012 368 203.00 01/31/2012 01/11/2012 368 dep 617.00 01/31/2012 01/1312012 369 - op -pvn -01/12 605.00 01/31/2012 Total $30,002.00 Cleared Other Items Date Tran # Notes Amount Date Cleared 01/09/2012 JE 129300 ELoccs OFND Orr Fund receipt 63,336.50 01/31/2012 Total $63,336.50 2/16/12 1 '�) Northeast Ban k Member FDIC Date 1/31/12 Page 1 77 Broadway St. N.E., Minneapolis, MN 55413 612 - 379 -8811. 24 hour telephone banking 651- 628 -9807 Primary Account Ending 6456 Visit our website at www. northeastbank- nnn.com Enclosures 41 * * * * * * * * * ** * ** *AUTO * *3 -DIGIT 551 670 0.9740 AT 0.374 4 1 11 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 - - -- EFFECTIVE MARCH 1, 2012 WIRE TRANSFER FEES FOR OUTGOING DOMESTIC WIRES WILL BE INCREASED TO $20 AND AN EARLY ACCOUNT CLOSING FEE OF $20 WILL BE CHARGED FOR DDA AND SAVINGS ACCTS CLOSED IN LESS THAN 3 MONTHS AND HEALTH SAVINGS ACCTS PRIOR TO 3 YEARS. THE MAXIMUM DAILY LIMIT FOR NSF PAID AND RETURNED ITEM FEES (CONSUMER ONLY) IS $120. NORTHEAST PUBLIC FUNDS ACCT Account Number Ending 6456 Previous Balance 186,967.77 5 Deposits /credits 93,338.50 37 Checks /Debits 50,090.79 Service charge 100 Interest Paid .00 Ending Balance 230,215.48 Number of images 41 statement pates 1/01/12 thru 1/31/12 Days in the Statement Period 31 Average Ledger 231,680 Average collected 230,754 * {r kit it it it {r it kk irkkrtrtkk {rk kitrtrtrt *kirk itk kkir'h it it ir*ki: {rkkk kirkkkki:rt it {: tr *irk *kkit {r itkrtkrtk *kirk *kkk Deposits and credits Date Description Amount 1/05 DDA REGULAR DEPOSIT 25,692.00 1/09 DDA REGULAR DEPOSIT 2,885.00 1 /11 MISC PAY HUD TREAs 303 63,336.50 CR 1/05 3031036218 01/11/12 134.10 1/04 iD #- 411269646860103 300.00 1/06 TRACE #- 031036210387061 122.48 1 /11 DDA REGULAR DEPOSIT 820.00 1/13 DDA REGULAR DEPOSIT 605.00 rt{ r{ rkkkkkrt{ rkkkkkrtrtrtrtkkkirkk *kkkkkkrtirkkirkkrtrtk * {r k irrtrtrtkkrtkkrtkkkkkk * *irkkkkrt * *ir kirkrtkk cheeks in serial order Date check# Amount Date Check# Amount 1/09 1531 135.00 1/06 1549 521.36 1/05 1541* 134.10 1/04 1550 300.00 1/06 1542 122.48 1/06 1551 24.30 1/04 1544* 60.94 1/04 1552 145.98 1/04 1546* 492.94 1/03 1553 3,509.24 1/04 1547 38.78 1/05 1554 7,289.00 1/03 1548 110.00 1/09 1555 460.50 * indicates skip in check numbers I� 819695 - 623 l �l i <l Date 1/31/12 Page 2 Primary Account Ending 6456 Enclosures 41 NORTHEAST PUBLIC FUNDS ACCT Ending 6456 (continued) checks in serial order Date check# Amount Date check# Amount 1/17 1556 89.01 1/25 1569 666.39 1/10 1557 190.52 1/27 1570 275.10 1 /18 1558 132.42 1/25 1571 211.40 1/13 1559 505.00 1127 1573* 6.75 1/17 1560 13,161.31 1/30 1574 688.17 1/20 1561 3,729.24 1/31 1576* 110.56 1/24 1562 1,482.50 1/30 1577 1,461.55 1/25 1563 30,27 1/30 1579* 125.00 1/25 1564 1,675.00 1/31 1582* 17.76 1/27 1566* 44.82 1/30 1583 4,157.22 1/24 1567 700.00 1/24 4565* 7,217.81 1/30 1568 68.37 * Indicates skip in check numbers it ir*Yr Yrrt rtitrtrtrt *ir it *rtYr * *Yr Yr it irrt *rtrtir irrtrtrt *rt *Y:Y: Yr Yr it *rtrtrti: *rt*Yr Yr * * *irrt* *rtrtir *Yr *rtirrt irrtrtrt **ir *Yr *rtrt Daily Balance section Date Balance Date Balance Date Balance 1/01 186,967.77 1 /10 202,009.63 1/24 239,753.84 1/03 183,348.53 1 /11 266,166.13 1/25 237,170.78 1/04 182,309.89 1/13 266,266.13 1/27 236,844.11 1/05 200,578.79 1/17 253,015.81 1/30 230,343.80 1/06 199,910.65 1/18 252,883.39 1/31 230,215.48 1/09 202,200.15 1/20 249,154.15 * * * EN D O F S T A T E M E N T 61 819695 - 624 Payment Summary Bank= 165opr AND mm /yy= 01/2012- 01/2012 AND All Checks—Yes AND Include Voids =All Checks [Ito Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa North 1496 Bunn -Sun Newspaper 01/27/2012 01/2012 (94.05) 165opr - Parkview Villa North 1555 all - All Inc. 01/05/2012 01/2012 460.50 165opr - Parkview Villa North 1556 dire - Direct Home Appliance Services 01/05/2012 01/2012 89.01 165opr - Parkview Villa North 1557 jerrl - Jerry's Floor Store 01/05/2012 01/2012 190.52 165opr - Parkview Villa North 1558 offi658 - Office of Enterprise Technology 01/05/2012 01/2012 132.42 165opr - Parkview Villa North 1559 zeph - Zephyr Services Inc. 01/05/2012 01/2012 505.00 165opr - Parkview Villa North 1560 chc - Commoneond Housing 01/11/2012 01/2012 13,161.31 165opr - Parkview Villa North 1561 wait - WAI Continuum 01/11/2012 01/2012 3,729.24 165opr - Parkview Villa North 1562 all - All Inc. 01/19/2012 01/2012 1,482.50 165opr - Parkview Villa North 1563 answ - AnswerLive LLC 01/19/2012 01/2012 30.27 165opr - Parkview Villa North 1564 bfbp - BFB Painting, Inc. 01/19/2012 01/2012 1,675.00 165opr - Parkview Villa North 1565 colu - City of Columbia Heights 01/19/2012 01/2012 7,217.81 165opr - Parkview Villa North 1566 comc3474 - Comcast 01/19/2012 01/2012 44.82 165opr - Parkview Villa North 1567 kocl - K.O. Cleaning and Restoration LLC 01/19/2012 01/2012 700.00 165opr - Parkview Villa North 1568 offiB804 - Office Depot 01/19/2012 01/2012 68.37 1650pr - Parkview Villa North 1569 parkl - Park Supply of America, Inc. 01/19/2012 01/2012 666.39 165opr - Parkview Villa North 1570 sher4110 - Sherwin - Williams Co. 01/19/2012 01/2012 275.10 165opr - Parkview Villa North 1571 t0003996 - Piersak 01/19/2012 01/2012 211.40 165opr - Parkview Villa North 1572 cent - CenterPoint Energy 01/25/2012 01/2012 5,198.32 165opr - Parkview Villa North 1573 chc - Common Bond Housing 01/25/2012 01/2012 6.75 165opr - Parkview Villa North 1574 eagil - Eagle Elevator Corp. 01/25/2012 01/2012 688.17 165opr - Parkview Villa North 1575 gree1004 - Green Lights Recycling Inc 01/25/2012 01/2012 76.56 165opr - Parkview Villa North 1576 home32 - Home Depot Credit Services 01/25/2012 01/2012 110.56 165opr - Parkview Villa North 1577 Jeri I - Jerry's Floor Store 01/25/2012 01/2012 1,461.55 165opr - Parkview Villa North 1578 mgsp - MGS Professional Bldg Maint Sery Inc 01/25/2012 01/2012 122.48 165opr - Parkview Villa North 1579 multi - Multihousing Credit Control 01/25/2012 01/2012 125.00 165opr - Parkview Villa North 1580 parkl - Park Supply of America, Inc. 01/25/2012 01/2012 43.93 165opr - Parkview Villa North 1581 pet1651s - Laura Sheak 01/25/2012 01/2012 237.53 165opr - Parkview Villa North 1582 shea - Laura Sheak 01/25/2012 01/2012 17.76 165opr - Parkview Villa North 1583 xcel - Xcel Energy 01/25/2012 01/2012 4,157.22 165opr - Parkview Villa North 1584 zeph Zephyr Services Inc. 01/25/2012 01/2012 478.45 Po ...,.,,.W�.,.n _. ...... -.,,.. 43,269.89 [Ito Parkview Villa South Financial Statement Overview January 2012 Revenue: Occupancy for the month of January was 96% occupied Total Revenue was slightly higher than budget amount (favorable) Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were under budget (favorable). Office Supplies were slightly over budget (unfavorable) There were no Legal Expenses billed out for January. Telephone, Answering Service and Internet expenses are under budget (favorable). Utilities: Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing No Utilities were invoiced or paid in January Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Garbage and Trash Removal are under budget (favorable); however this is a quarterly billing. Repairs Material and Contract costs were under budget (favorable). Elevator Contract is over budget (unfavorable) and reflects the cost of the Elevator upgrade Snow Removal costs were under budget (favorable) Heating and Cooling Maint and Repairs was under budget (favorable) Decorating contract costs were over budget (unfavorable), and reflect cost associated with carpet installation and wall repairs in turnover units M O O O O O O S O S oS8 O O O ObnN O O O O O S 8888 S S O O O O Y N o $ W w W+ w + ° 0 o 00, O OP 00 S $00000000 6.88 (I 1 NS00 +JOSOJiO nN000 � � &eeSe.Lt ave k 8n aev av aaeks m N wpp OJJm(WJdN�ONfA IAN W O (Jli W S N Y W O W N O imp �JA O�Oyq�iiJ tOO (AAWN AOJJWWUNiJWO(Wi14Ni0 AD6'(Ii00A ,fA00S W S+ J O S UJi S A N S S O N UNi N J Oi P p� IA u W o m W J WViOA NA ONO ONO `4'OO °OO °0n °o °o °oa °o °o °o el �IG. P, I V, I N yp H O O O O S S O O O N N p 0 -i ti 3 -1 m A A ry W N (ON ��� NJONS OIWW W W °a0 F 3. C o N W N 6 ?. a i r S A 6i A z ii $ �p NAN N S O lNli O O O A N -cbobo 00000 g $$ °o c m �2' NG$ y O gmu o J,`�'oo�o�w000 W: oLm ° $oS$o o$�..S$o.o... 'o, $$008 g °$ d Vim' v n W ry m m u S N 0 0 J J m (J W+ O N w W N INO: W O (li I,PD N W �. O O S O O JOa A yW O O lJl� W W N J W O W U O ;W� N JON O W W W 1 00000 JOW�WyW 0 -� +WHO ()iWN JmWW. OOm OOSOO 1Np NOJJW W(IiJWOW(NI� Nii NWONS qO A F n�n 0 O O O O O O S O S oS8 O O O ObnN O O O O O S 8888 S S O O O O Y N o $ W w W+ w + ° 0 o 00, O OP 00 S $00000000 6.88 (I 1 NS00 +JOSOJiO nN000 � � &eeSe.Lt ave k 8n aev av aaeks m N wpp OJJm(WJdN�ONfA IAN W O (Jli W S N Y W O W N O imp �JA O�Oyq�iiJ tOO (AAWN AOJJWWUNiJWO(Wi14Ni0 AD6'(Ii00A ,fA00S W S+ J O S UJi S A N S S O N UNi N J Oi P p� IA u W o m W J WViOA NA ONO ONO `4'OO °OO °0n °o °o °oa °o °o °o el �IG. P, I V, I N yp H O O O O S S O O O mm N N N � m m m O OIOSN !D (ON ��� NJONS OIWW W W iJ� N W N A W N �. N WO IWJ S tJn S A OOH P J J mm 88 a o >o +DO °o m WAu � W W i N A O to •u rAp NAN N S O lNli O O O A N -cbobo 00000 g $$ °o m Z J q 6 qy y o a b ti o c o y ii g o $ a m -� 6 v a w o 6 A o o N N u) n v v x v 30 0. °@ --a.e Ae 6�Ny`gm�Sm''= Wq� 9 y % ] Ny •C 8 ?'bb�0 sld �OCjWA C. IiN� O c t - m° o d ry Q 8A'°y Aa o � po O S W J W N (W� J W S O O S 0 o °o N J W N m p O n D e u N � J O � O � N O A A pN� N W S OI N IAII A P O W W J Y O O O A O N VI� OOb + + d O W W J Y O 0 m N J m N pA S in IOC O Iy/W� � N O O O O O S O O O O A J y N OJOOOOPO4)OOSOIOWOOS dE N .Vy{ + O mp� +J WNJO V��OOWW W J0000000(JJONIJIiJOJ OIWJ PNONWOJSNPPO OO�OA°O1i J(WJ N ()(11 m 0 0 0 WJ N O N W OJ J O Y p °I J IYIi 0 IDN VI S 00 ....SSS Z A Z 0 p� IYIID S O SSWDNOOVID...O SSS A + O UNi W O N U� O+ O O O A N O O O b' +m' +0000 N W O O O O A O 0 ......... I�.�J WNOP rVI A(li ..�+ pl O N O O O S W O O S A O A J W SOOOS(Wi14 JONUJi�OJOW W (NIi pOWp�� VWNO OWOAN J(Wil J S S P Z W O S O Z O O W OW1 O O O � S °o mD� °o omDS °o lom000 W +ION +NWNN WO�OIN ......... N N INJ O O N O O O O O O O O O N N p O O O O S ........ S S S O O d 3 < o O _N3 ° V y V N z "zzzz z `D 'n Dnn'D'D n o + N pow �mos°o O O O O P.-PO �O �O O O O O O 9 P c ra o p n o D o m W w O v 9 a D o O (N� -1 q a s D Dn(Dio Or. a u 2�v. =m.�:.a8a m 0 l�1I' a58 ;'o R m 2 g ~ c. ti SN �i g .c d � A m I°ANNN J J +�DW NO 00 00 AA .P -'. m'. I�WW AOp O W- O O NN g JJ J�000 (NON 00 A OOP ,Np: p E W W! W m N O W � !O W O O O O O O O O O O Wo p O O O O O O O O O p O O0 p: O bob O O J +<p NN W (Nil F'. 01 P O.66 Op AA OVNiNO JNOOO JVOOO 00 -A', oNm ; O O Jm z "zzzz z `D 'n Dnn'D'D n o + N pow �mos°o O O O O P.-PO �O �O O O O O O a`Dan'D a ZD R z D 6N w °o °o °o Pi- 0 O O O O z a n 000 0 g °OO °o AI+ m: O N' J W.. a °0 G C N( V a W V V zzzz zzzzz a`Dan'D a D + m 0000 00000 R z D 6N w °o °o °o Pi- 0 O O O O z a n 000 0 g °OO °o AI+ m: O N' J W.. a °0 G C N( V a W V V y m o m va7 v CD `< F gnc A n e N 3 O � O A � c_ 7 n N � N o 9 N Z� Parkview Villa South (166) Balance Sheet January 2012 Books = Accrual Jan -12 Assets 10100 Cash Balance 152,937.73 841.25 10200 Petty Cash 93.00 13,775.53 10400 Investments 575,970.36 33,624.35 11300 Rent Receivable 6.00 695,385.74 11500 Accounts Receivable 3.00 729,010.09 Total Assets 729,010.09 Liabilities 20200 Accounts Payable 8,551.27 20210 Accrued Other Expenses 841.25 22000 Deposits 9,267.59 22200 Accrued PILOT 13,775.53 22210 Revenue Collected in Advance 1,188.71 Total Liabilities 33,624.35 Fund Balance 25300 Fund Balance 695,385.74 Total Fund Balance 695,385.74 Total Liabilities and Fund Balance 729,010.09 24 Parkview Villa -South (166) Income Statement For The Period Ending January 2012 Books = Accrual Month to Date % Year to Date Revenue 36220 -46340 Gen. Government Rents 25,936.00 96.84% 25,936.00 96.84% 36225 -46340 Nondwelling Rents 544.00 2.03% 544.00 2.03% 36290 -46340 Other Miscellaneous Revenue 303.00 1.13% 303.00 1.13% 39120 -46340 Recovery Damage City - 0.00% -0.00 0.00% Total Revenue 26,783.00 100.000/0 100.000/0 Expenses Personal Services 1000 -46340 Accrued Salaries 3,723.00 13.90% 3,723.00 13.90% Total Personal Services 3,723.00 13.90% 3,723.00 13.90% Supplies 2000 -46340 Office Supplies 47.25 0.18% 47.25 0.18% 2010 -46340 Minor Equipment 0.00 0.00% 0.00 0.00% 2160 -46340 Maint. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 65.93 0.25% 65.93 0.25% 113.18 0.42% 113.18 0.42% Total Supplies Other Services & Charges 0.00 0.00% 0.00 0.00% 3040 -46340 Legal Fees 3050 -46340 Expert & Professional Services 0.00 0.00% 0.00 0.00% 3060 -46340 Management Services 2,025.00 7.56% 2,025.00 7.56% 3100 -46340 Protective Services 0.00 0.00% 0.00 0.00% 3210 -46340 Telephone & Telegraph 58.78 0.22% 58.78 0.22% 3430 -46340 Advertising Other 0.00 0.00% 0.00 0.00% 3600 -46340 Insurance & Bonds 841.25 3.14% 841.25 3.14% 3810 -46340 Electric 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 3820 -46340 Water 0.00 0.00% 0.00 0.00% 3830 -46340 Gas 34.39 0.13% 34.39 0.13% 3840 -46340 Refuse 0.00 0.00% 0.00 0.00% 3850 -46340 Sewer 4000 -46340 Repair & Maint. Services 3,994.12 14.91% 3,994.12 14.91% 4100 -46340 Rents & Leases 0.00 0.000/0 0.00 0.00% 4300 -46340 Miscellaneous Charges 25.58 0.00% 25.58 0.10% 1,059.66 3.96% 1,059.66 3.96% 4315 -46340 PILOT 4390 -46340 Taxes & Licenses 0.00 0.00% 0.00 0.00% 4500 -46340 Administrative Expenses 0.00 0.00% 0.00 0.00% 4850 -46340 Interest on Deposits 7.47 0.03% 7.47 0.03% Total Other Services & Charges 8,046.25 30.04°70 8,046.25 30.04°70 25 Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00% 0.00 0.000/0 0.00 0.000/0 11,882.43 44.37% 11,882.43 44.37% 14,900.57 55.63% 14,900.57 55.63% � u Parkview, Villa South (166) Cash Flow Statement Period = January 2012 Month to Date Revenue 36220 Gen. Government Rents 25,936.00 36225 Nondwelling Rents 544.00 36290 Other Miscellaneous Revenue 303.00 39120 Recovery Damage City Property 0.00 Total Revenue 26,783.00 Personnel Services 1000 Accrued Salaries 3,723.00 Total Personnel Services 3,723.00 Supplies 2000 Office Supplies 47.25 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 65.93 Total Supplies 113.18 Other Services & Charges 3050 Expert & Professional Services 0.00 3060 Management Services 2,025.00 3100 Protective Services 0.00 3210 Telephone & Telegraph 58.78 3430 Advertising Other 0.00 3600 Insurance & Bonds 841.25 3810 Electric 0.00 3820 Water 0.00 3830 Gas 0.00 3840 Refuse 34.39 3850 Sewer 3,994.12 4000 Repair & Maint. Services 0.00 4100 Rent & Leases 0.00 4300 Miscellaneous Charges 25.58 4315 PILOT 1,059.66 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 0.00 4850 Interest on Deposits 7.47 Total Other Services & Charges 8,046.25 Total Expenses 11,882.43 Excess (Deficit) Revenue over Expenses 14,900.57 21 Parkview Villa South (166) Cash Flow Statement Period = January 2012 Adjustments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date (3.00) (3.00) 0.00 (5,442.30) 841.25 (435.77) 1,059.66 123.00 (3,860.16) 11,040.41 Beg Cash End Cash Difference 141,897.32 152,937.73 11,040.41 93.00 93.00 - 575,970.36 575,970.36 - 717,960.68 729,001.09 11,040.41 ral 3/12/2012 3:26 PM Page 1 of 1 v Parkview Villa South (166) 0.00 = Beginning Balance = 3600 -46340 General Ledger Insurance & Bonds BM11.25 0.00 841.25 C of Columbia Heights Ins A. 166 1/31/2012 01/2012 Period = Jan 2012 RC 841.25 = Ending Balance = Net Chang.= 841.25 Book Accrual - - Control Reference Debit . Credit Balance Remarks property: Date Period Person /Description 0.00 166 1/5/2012 0.00 = Beginning Balance = 1000-46340 12- 1039pvs Accrued Salaries 34.39 =p Elnding'Balance = 3,]23.00 0.00 3,723.00 R/C CNC PR Mgmt Fee 166 1/31/2012 01/2012 :postRecurring Recurring J- 12II]00 RC 3,723.00 = Ending Balance = 0.00 = Beginning Balance = Net Change= 3,723.00 Repair & Maint. Services P- 263604 112124 -s 309.18 0.00 309.18 prow maim 01/12 166 1/1/2012 01/2012 Eagle Elevator Corp.(eag11) 0.00 = Beginning Balance = 2000 -46340 1/6/2012 Office Supplies MGS Professional Bldg Meet Sew Inc R P-263609 23.64 0.00 postage 166 166 1/4/2012 01/2012 Laura Shenk(pet1661s) P- 263616 pc010412pv5 0.00 47. 5 paper, envelopes etc. 166 1/11/2012 01/2012 Office Depot(offi8804) P- 264778 593407841001 23.61 7.225 47.25 = Ending Balance = 166 Gardner Plumbing, LLC (gard1086) P- 264759 2387 Net change =47.25 0.00 1,872.67 snow Fool secs 1/14 166 1/16/2012 01/2012 MGS Professional Bldg Malnt Sew Inc (r P- 264774 29.45 0.00 3,464.67 slew upgrade 1/11 166 166 1/20/2012 01/2012 0.00 = Beginning Balance = 2171 -46340 1,592.00 0.00 General Supplies 1/20/2012 14.99 0.00 14.99 bolts, brace etc. 29.45 1/4/2012 01/2012 Laura Sneak (et1661s) p P- 263616 pc010912pvs K.O. Cleaning and Restoration LLC (kocl P- 265908 0.00 spindle, etc. 166 1/11/2012 01/2012 HD Supply Facilities Maintenance (home P- 2647]1 9112869112865012w, 50'94 300.00 65.93 =Ending Balance 166 Net Chang-=65.93 Net Change= 31994.12 0.00 = Beginning Balance = 0.00 = Beginning Balance = 3060 -46340 Miscellaneous Charges P- 263616 pc010412pvs Management Services 0.00 25.58 keys 5,748.00 0.00 5,748.00 mgmt fees 166 1/31/2012 01/2012 CommonBond Housing (chc) P- 265229 911661 3,723.00 PR Mgmt Fee 2,025.00 R=C Mgm 166 1/3112012 01/2012 :POStRecurting Recurring 1- 128700 RC 0.00 din 2,025.00 = Ending Balance = 0.00 = Beginning Balance = Net Change = 2,025.00 PILOT 1,059.66 0.00 1,059.66 Anoka Cty Property Tax Aco 166 1/31/2012 01/2012 :PostRecurring Recurring ]- 128700 RC 0.00 = Beginning Balance = 3210 -46340 Telephone & Telegraph 1348 0.00 13.48 aternetc 01/12 1/1/2012 01/2012 AnswerLive LLC(answ) P- 262016 111204620101 0.00 = Beginning Balance = 0.00 33.61 Internet sec 1/11 -2/10 166 1/2/2012 01/2012 Comcast (comc3474) P- 262539 8]3710505019 20.13 01/2012 51.09 phone Svc 01/12 166 1/7/2012 01/2012 Centuryt-ink (cent9115) P- 264756 763]883978/1 17.68 0.00 Ol /10 Svc 166 1/11/2012 01/2012 MCI Comm Service (mcic3718) P- 2697]6 ]637883978/1. 7.69 0.00 phone 58.78 = Ending Balance 166 Net change =58.78 Page 1 of 1 v 0.00 = Beginning Balance = 3600 -46340 Insurance & Bonds BM11.25 0.00 841.25 C of Columbia Heights Ins A. 166 1/31/2012 01/2012 :PostRecurring Recurring ]- 128700 RC 841.25 = Ending Balance = Net Chang.= 841.25 0.00 = Beginning Balance = 3840 -46340 Garbage & Trash Removal 34.39 0.00 166 1/5/2012 01/2012 Green Lights Recycling Inc (gree1004) P- 263606 12- 1039pvs 34.39 =p Elnding'Balance = Net Change =34.39 0.00 = Beginning Balance = 4000 -46340 Repair & Maint. Services P- 263604 112124 -s 309.18 0.00 309.18 prow maim 01/12 166 1/1/2012 01/2012 Eagle Elevator Corp.(eag11) 1/6/2012 01/2012 MGS Professional Bldg Meet Sew Inc R P-263609 0.00 1,622.81 Inst cap - 22101 166 166 1/9/2012 01/2012 Jerry's Floor Store (Jerrl) 63605 X6307p15s 1,258.60 t 166 1/12/2012 01/2012 LID Supply Facilities Maintenance (home P- 264772 9112902652pv 0.00 1,843 22 slower dram leak - 315 1/12/2012 0112012 Gardner Plumbing, LLC (gard1086) P- 264759 2387 201.50 0.00 1,872.67 snow Fool secs 1/14 166 1/16/2012 01/2012 MGS Professional Bldg Malnt Sew Inc (r P- 264774 29.45 0.00 3,464.67 slew upgrade 1/11 166 166 1/20/2012 01/2012 Eagle Elevator Corp.(eagll) P- 265903 112357 -[ 112357 -1 1,592.00 0.00 3,494,12 snow svrs 1/20 1/20/2012 01/2012 MGS Professional Bldg paint Sew Inc (r P- 264775 10347pvs 29.45 0.00 3,694.12 repairrwtrl dam/paint - 215 166 166 1/23/2012 01/2012 K.O. Cleaning and Restoration LLC (kocl P- 265908 2039 200.00 0.00 /Balance 166 1/30/2012 01/2012 K.O. Cleaning and Restoration LLC (Red P- 265906 2042 300.00 =0 3 994.12 =aEnding Net Change= 31994.12 0.00 = Beginning Balance = 4300 -46340 Miscellaneous Charges P- 263616 pc010412pvs 25.58 0.00 25.58 keys 166 114/2012 01/2012 Laura Shook (pet1661s) 25.56 = Entling Balance = Net Change =25.58 0.00 = Beginning Balance = 4315 -46340 PILOT 1,059.66 0.00 1,059.66 Anoka Cty Property Tax Aco 166 1/31/2012 01/2012 :PostRecurring Recurring ]- 128700 RC 1,059.66 = Ending Balance = Net Change= 1,059.66 0.00 = Beginning Balance = 4850 -46340 Interest on Deposits ] 47 0. 00 7.47 Sec Dep Interest accrual 166 1/31/2012 01/2012 Sec Dep interest accrual 3- 129312 GIL 7,47 = Ending Balance = Net Change =7.47 15,605.43 3,723.00 Page 1 of 1 v 5016464 Parkview Villa South Bank Reconciliation Report 01/31/2012 Balance Per Bank Statement as of 01/31/2012 02/11/2009 389 mcic - MCI Comm Service 01/19/2012 1293 comc3474 - Comcast 01/19/2012 1296 10003793 - Johnson 01/25/2012 1297 cent - CenterPoint Energy 01/25/2012 1299 gree1004 - Green Lights Recycling Inc 01/25/2012 1301 mgsp - MGS Professional Bldg Maint Sery Inc 01/25/2012 1304 pet166Is - Laura Sheak Less: Outstanding Checks Reconciled Bank Balance $155,511.09 5.47 20.13 199.06 2,195.07 34.39 55.03 64.21 $2,573.36 Balance per GL as of 01/31/2012 $152,937.73 2/10/12 $152,937.73 Reconciled Balance Per G/L $152,937.73 —j-51J 2111�) Difference 0.00 Cleared Items: Cleared Checks Date Tran ft Notes Amount Date Cleared ' 11/30/2011 1250 cent9115 - Centuryl-ink 17.43 01131/2012 12/2212011 1276 mgsp - MGS Professional Bldg Maint Sery Inc 55.03 01/31/2012 12/22/2011 1278 offi8804 - Office Depot 27.38 01/31/2012 12122/2011 1279 t0003808- Jankowski 107.18 01/31/2012 12/29/2011 1280 adam - Adam's Pest Control, Inc. 44.00 01/31/2012 12/29/2011 1282 chc - CommonBond Housing 18.33 01/31/2012 12/29/2011 1283 home7 - HD Supply Facilities Maintenance 19.31 01/31/2012 12/29/2011 1284 Ibpm - LBP Mechanical, Inc 2,552.25 01131/2012 12/29/2011 1285 mcic3718 - MCI Comm Service 10.92 01/31/2012 12/29/2011 1286 xcel - Xcel Energy 1,386.84 01/31/2012 01/05/2012 1267 dire - Direct Home Appliance Services 39.99 01/31/2012 01/0512012 ,1288 off1658 - Qffice of Enterprise Technology 59.50 01/31/2012 01/11/2012 1289 chc - CommonBond Housing 5,951.53 01131/2012 01/1912012 1290 answ - AnswerLive LLC 13.48 01131/2012 01119/2012 1291 bfbp - BFB Painting, Inc. 375.00 01131/2012 01/19/2012 1292 coin - City of Columbia Heights 3,306.41 01/31/2012 01/19/2012 1294 offi8804 -Office Depot 30.72 01/31/2012 01/19/2012 1295 t0003785 - Fransen 244.18 01131/2012 n 5016464 01125/2012 1298 01/2512012 1300 01/25/2012 1303 01/2512012 1305 Total 1,258.60 Cleared Deposits Date Tran # 01/05/2012 283 01/09/2012 284 01/1312012 285 Total Parkview Villa South Amount Bank Reconciliation Report dep - pvs - 01/05112 01/31/2012 0113112012 eagll - Eagle Elevator Corp. 309.18 jerr1 - Jerry's Floor Store 1,258.60 multi - Multihousing Credit Control 60.00 xcel - Xcel Energy 1,643.11 $17,530.37 01/31/2012 01/31/2012 01/31/2012 01/31/2012 Notes Amount Date Cleared dep - pvs - 01/05112 24,482.00 0113112012 rent deposits 2,402.00 01/31/2012 op- pvs -01/12 16.00 01/31/2012 $26,900.00 2/10/12 1�21 Northeast RLIV � L a/ Member FDIC 77 Broadway St. N.E., Minneapolis, MN 55413 Date 1/31/12 Page - 612- 379 -8811 • 24 hour telephone banking 651- 628 -9807 Primary Account Ending 6464 4 Visit our website at www. northeastbank- mn.com Enclosures 25 ** * * * * * * * * * * ** *AUTO * *3 -DIGIT 551 671 0.8140 AT 0.374 4 1 12 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 O U N T S - - -- EFFECTIVE MARCH 1, 2012 WIRE TRANSFER FEES FOR OUTGOING DOMESTIC WIRES WILL BE INCREASED TO $20 AND AN EARLY ACCOUNT CLOSING FEE OF $20 WILL BE CHARGED FOR DDA AND SAVINGS ACCTS CLOSED IN LESS THAN 3 MONTHS AND HEALTH SAVINGS ACCTS PRIOR TO 3 YEARS, THE MAXIMUM DAILY LIMIT FOR NSF PAID AND RETURNED ITEM FEES (CONSUMER ONLY) IS $120. NORTHEAST PUBLIC FUNDS ACCT Account Number Ending 6464 Previous Balance 146,141.46 3 Deposits /Credits 26,900.00 22 checks /Debits 17,530.37 Service charge .00 interest Paid .00 Ending Balance 155,511.09 Number of Images 25 statement Dates 1/01/12 thru 1/31/12 Days in the statement Period 31 Average 'Ledger 161,272 Average collected 160,424 wwi:w': it it trwwwir irwwwwwwir* wkww, Y irw*wwwwiriri: it ir. * *wrtirw w{rwWwwrtrtwwir irwwwirwwwrt '.rw {rw wi:wwwirwwww Deposits and credits Amount Date Description Amount 1/05 DDA REGULAR DEPOSIT 24,482.00 1/09 -DDA REGULAR DEPOSIT 2,402.00 1/13 DDA REGULAR DEPOSIT 16.00 rtwi:wwwrtirww w{r irw wirirwrtwww {rrt it *wwwwirwwwwir{r {rw irirwrtrtwwwwrtwwwirrtwwwwwrtwwww {rrtwwwwirwwwwwww checks in serial order Date check# Amount Date check# Amount 1/06 1276 55.03 1/12 1288 59.50 1 /10 1278* 27.38 1/17 1289 5,951.53 1/12 1279 107.18 1/25 1290 13.48 1/04 1280 44.00 1/25 1291 375.00 1/03 1281 17.43 1/24 1292 3,306.41 1/03 1282 18.33 1/27 1294* 30.72 1/06 1283 19.31 1/24 1295 244.18 1/04 1284 2,552.25 1/31 1298* 309.18 1/06 1285 10.92 1/30 1300* 1,258.60 1/03 1286 1,386.84 1/30 1303* 60.00 1/17 1287 39.99 1/30 1305* 1,643.11 * Indicates skip in check numbers 3Z 819696 - 627 LM Date 1/31/12 Page 2 Primary Account Ending 6464 Enclosures 25 NORTHEAST PUBLIC FUNDS ACCT Ending 6464 (Continued) rtkkk *kir it itk krti: it it i:rt * *kkkkirrtkrtkkkkkir it irk it itk'.:k kir irk rtirkrtkrtkkkkrtkrtkir iskkkkkit irk irkkkkrtrtirk Daily Balance Section Date Balance Date Balance Date Balance 1/01 146,141.46 1/09 168,921.35 1/24 159,201.18 1/03 144,718.86 1 /10 168,893.97 1/25 158,812.70 1/04 142,122.61 1/12 168,727.29 1/27 158,781.98 1/05 166,604.61 1/13 168,743.29 1/30 155,820.27 1/06 166,519.35 1117 162,751.77 1/31 155,511.09 * * * E N D O F S T A T E M E N T * ** 819696.- 628 Payment Summary 13ank= 166opr AND mm /yy= 01/2012- 01/2012 AND All Checks =Yes AND Include Voids =All Checks /54 Check Post Total Bank Check# Vendor Date Month Amount 166opr - Parkview Villa South 1287 dire Direct Home Appliance Services 01/05/2012 01/2012 39.99 166opr - Parkview Villa South 1288 offi658 - Office of Enterprise Technology 01/05/2012 01/2012 59.50 166opr - Parkview Villa South 1289 chc - Common8ond Housing 01/11/2012 01/2012 5,951.53 166opr - Parkview Villa South 1290 answ - AnswerLive LLC 01/19/2012 01/2012 13.48 166opr - Parkview Villa South 1291 bfbp - BFB Painting, Inc. 01/19/2012 01/2012 375.00 166opr - Parkview Villa South 1292 colu - City of Columbia Heights 01/19/2012 01/2012 3,306.41 166opi - Parkview Villa South 1293 comc3474 - Comcast 01/19/2012 01/2012 20.13 166opr - Parkview Villa South 1294 off18B04 - Office Depot 01/19/2012 01/2012 30.72 166opr - Parkview Villa South 1295 t0003785 - Fransen 01/19/2012 01/2012 244.18 166opr - Parkview Villa South 1296 t0003793 - Johnson 01/19/2012 01/2012 199.06 166opr - Parkview Villa South 1297 cent - CenterPoint Energy 01/25/2012 01/2012 2,195.07 166opr - Parkview Villa South 1298 eag11 - Eagle Elevator Corp. 01/25/2012 01/2012 309.18 166opr - Parkview Villa South 1299 gree1004 - Green Lights Recycling Inc 01/25/2012 01/2012 34.39 166opr - Parkview Villa South 1300 jerrl - Jerry's Floor Store 01/25/2012 01/2012 1,258.60 166opr - Parkview Villa South 1301 mgsp - MGS Professional Bldg Maint Sery Inc 01/25/2012 01/2012 55.03 166opr - Parkview Villa South 1302 mhfa - Minnesota Housing Finance Agency 01/25/2012 01/2012 150.00 166opr - Parkview Villa South 1302 mhfa - Minnesota Housing Finance Agency 01/27/2012 01/2012 (150.00) 166opr - Parkview Villa South 1303 multl - Multihousing Credit Control 01/25/2012 01/2012 60.00 166opr - Parkview Villa South 1304 pet1661s - Laura Sheak 01/25/2012 01/2012 64.21 166opr- Parkview Villa South 1305 xcel- Xcel Energy 01/25/2012 01/2012 1,643.11 15,859.59 /54 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 March 2012 Prepared by Jennifer Eells, Property Manager Police Report 1— Domestic family, 1— Tenant dispute Wait List 33 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicant for Parkview Villa North (employed in C.H.) 31 applicants for Parkview Villa North (non- resident, elderly, handicapped) (updated) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 02 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 42 out of 45 (93 % occupancy) Move Outs #502 3/31/12 #610 3/31/12 #216 3/31/12 #425 3/31/12 Move INS Maintenance Report (See attached) ParkVieW Villa Apartments Newsletter Q ice nJ'o Phone 763- 706 -3800 Hours 8 a.m. -4:30 p.m. After Hour Maintenance: PV North 866 - 962 -8896 PV South Managed by CommonBond Owned by the City of Columbia Heights Communities •�� • 11 s By Carol GOOdrow The lion and the Iamb may never run together. Dad blames it on their nature. Mom says it's just the weather. For when the month of March comes out, we hear the little chil- dren shout. "We're wet with snow. We're stuck with sleet. The wind is whipping at our feet. We cannot run too fast today. The Lion must be in our way." The Lion and the Iamb may never run together. Dad blames it on their nature. Mom says it'sjust the weather. But when we hear the season of spring, we hear the little children sing. "We're sprinkled with rain. We're warm with sun. A gentle breeze has just begun. We jump and sprint and run and play. The twin Iambs might be born today. " 0®! N N to U� 111 VI A P W N N N N N lD l0 W W V V 01 A W W N W om w w w w w w w w N w w w w w w w w w w w w w w N w w N Qa w �' • � G G<<<<< N Z Z Z �^ Z Z �^ (A Z(n N 0 Z Z Z Z Z Z Z Z Z Z °y c t0 l0 N w A un N N A m Ln N W A 00 W V U. O O O O O O F-` N N O O O O N H I-` O iP 01 w w A N N l0 W V 00 N A 01 Ul F' O w z (o c m c a i a °' ?• v v d m m vc,, c m d v= 3 v M > >> n a O a g m o is ° w c 3 CL CL O N 1 l O w p V 7C 7C N W 2 Q N A 7C o 2 z 05 m -1 -i 0 In v r N m� 7, n -1 •D G s c s �. m m M �+ m rD .. =n M s c v _ 7 O O O w '� O O�0 '-r w m O O 'O .•r O M, -� :n 7 w >> `� W 'O O 1 '< � O � N a' w 3' N _ O O Cr a• 'O O n �n. O — � v' G j O O :+ 3 N on rr .' D- v 3- w m° w °° °. w e m°n ov' m �o °. a c °w o c o �c • '< o O - n m a 9 > > C O� < D_ < x d 0Cj C N d4 C OU O N A O CL o m m y D- M s f+ �, c o D CL Z ', v m rD �, .°'. Ov, a• `� a°'o -wo c w o. O ro o• � o- < ° Z -woo o o oa < o c m n w M o o„ a o ° o m Lq as r 3 x m' '•' 3• m o' m c a o_ m 3 o1 °o � 3 M M. -mow o ! a uc°." c m m °- w 3 n '?. v °�' M o. T. D H a- m o_ w a• m w m o_ c y 0O M �. a 0n G O N w 3 C = a• N c " S O_ �' 0_ _ O pCj c N CL w N OCU j N O< a p ,w.° O D' c W d (U fl' 7' C Ott CL D m s 1 o m 0 z cC. o_ ° �° o ua a 3 3< m a. a d a d 0 GAl M ,�, w w' o M o n M s o m a E M _ o_ a CL o o o_ M D, CL a n a s m w 3 as a 3 CL m o ° ° 0 3 ?° awo M P d o CL G) N 6 N e -' O- i -p O M _. d N � s w rF N 0 G O O O C 0 0 O 0 3 • D v n m n w w w w w w w w w w w w w w w w w O \ \ \ \ \ \ \ \ \ \ \ \ \ \ w w w w w w w w w w w w \ \ \ M M Un M i� M 0 A W N N N W F�-� l\O W 0\0 W V V O\1 A W V N N 00 V l!� •O \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ N N N N N N N N N N N N N N N 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 O O O O O O O O O O O O O O O M N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N �i w n T N N d 1 ASV O1 d a a n f:0 D 13 0 �1 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N 00 00 Q1 dl Dl Ol O1 Ol N A W W N Oo 00 01 d DI N N Dl d N DI N Dl D/ 411 d O1 Dl D! d N D) D! 01 d N D) N D! N D! d N z < < z Z Z Z Z Z Z N Z N Z Z Z N N Z N W Z Z W W Z N Z Z N N N lD A A V V W V1 N W V1 a) A M N A M W A -P 01 A W lD A N N O O Ln O N v N N O 0 A V J A O O m In m W lD -I lD O N N r T 3 2= 2 fTl N = d N HFD' S = fD CR °..c d `t 0- 3 G1 r�D Dni w m 'J^ T J• J• o o N ov DD o o � o p —j ;;: d N d O O. `0 v '(D (D c ,00 O, O O � O-• d 3 v O. D � o a J 00 O m o o o ° o �o c Q • 'D O. (D 3' M N O (D 0 CL (D o O S O 7 7 S (m p Q O! J o o K �' ((Di C Ol C 0oQ d a J cr Oi to N (D a O J 7 !� ((DD N J 'a 'O O cr `* ~ j 'O i O a .� _ A 6 N O d = ri -i C Vi N p� o a vN, m 3 0. 3 0: °° '-c M ° m rt a v J n oo aJ O ,< °" J °°• m °_ 'c w •CO J (<D ((DD N O CL p FA 1 � � "" n F < (D � 3 �• 7' �' Q 'O. N m n J' ID a o S\ d N CL "" 1 N Vi n O J a O O p Q. o " O J "O O, o N N S .(: Q S j d O 3 -�i D(D n .Ci d Z. w 0. N N �. IDS• ,w C C (D O n! pq O N o O (-Di � a W rD C d O O 7c (D fD M d vi s ((DD 3 A (D 3 N > 0 (D O d .�•e w Dpi d N ti4 C' (D d O D (D a N O Q O N a N Q N D D(. 'O 3 O C F d O DD n ° = n d i (D N 'OO N a J Dl N (� J (D CL N d (D Q w J V� 'O Dp :* J (D 1 w O O �� a on p4 0 n S \ o n rh * W. .O J p c (D O J o Vf (D 1n (D = K O O n CL 6: 0 n 0" o (D a' m C C .+ (D O < Ian m a• < S Dl G 'O J 0! � N N d (D fD (D (D D l J J J O' O m n. a I y, _ Q p: a w N (D N C _ N 5 ID -� 0 N fD (D 6 (D ti C. W-o, N S O * O D D N C O 2 0 Q0 J N ? O J n (Dn a O i O J OJ w D ' d � N O a T. 0 0 J m 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 \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ 00 00 Q7 T Q1 dl dl a> Ol Dl N W N N F+ N N N F-� N N N O lD lD 1p O Vt 00 Ol \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ N N N N N N N N N N N N N N N N 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 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 N N N N N N N N 0 4 y m F- 0 E E E E r- 0 0 0 0 0 0 c a a ry A¢� A m Tm A m Tm ,om 1D am am d.,om ,,,,;nm CO M c0 Co .D .�+ CO 'O N co 10 m %D Ln c c E p w o W 0 ro opp m � E C9 E c T Ki LL O O U) vc M Vc O O O O O m Ell c m e m L m C mE mE mE co mE a w d y n d °• ,o O ,o O ,o 0 �o O �o 0 0 O O 00 0 .•+ = 1� N O N 2 f� X N S f� 8 � Y u E Y Y sQ a d E E L F- c a V`- o E - E E E w O D_ O - E° < O ti 3 E V m - E a 'C O u FCC o n O m u d 0 0 gp .29 W m u F N N N V u E u E E o E O ,c d M c m O E m OL M u E o0 0 U E 8 2 o g rn u E p G N C N O V O L N V H 0 1=/1 Q O V 0 0 0 cy,� 0 N O _ N o m 0 m =8g < m I m M m m Z a j co 6 m O C 6 d o m m m d O M c N cc d 6 C'i O c N G � E d U E C E 9. CL d 0 Co LO Z m R N .-� all! O O O O IIn c O � e E E u d M o v o 0 In u'� E E u r u' c E .o u E •o E ci E ci ID s s LO j, s s LO r view Villa 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 2012 Prepared by Jennifer Eells, Property Manager Police Report There were no police calls for service the month of February. Wait List 38 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicant for Parkview Villa North (employed in C.H.) 31 applicants for Parkview Villa North (non- resident, elderly, handicapped) (updated) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 02 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 42 out of 45 (93 % occupancy) Move Outs #414 2/29/12 #124 2/6/12 Move INS #320 2/1/12 Maintenance Report (See attached) r` IV IV FEBRUARY 2012 A IV NEWSLETTER Managed by CommonBond Communities Owned by the City of Columbia Heights IV IV Management lice: 763 - 706 -3800 IV Hours: Monday through Friday IV IV 8:00 a.m. to 4:30 p.m. IV After Hours Maintenance Emergency: IV V -1- 66 -962- 6- -1- 66- - Upcomin vents! Create Valentines - Wednesday, February 1, 2:00 -4:00 p.m. Simply Good Eating - Friday, February 3, 2:00 p.m. Board Meeting- Monday, February 6, 7:00 p.m. Resident Council Meeting- Monday, February 13, p.m. Heart Day Featuring David Allen- Wednesday, February 15, 7:00 p.m. Simply Good Eating- Friday, February 17, 2:00 p.m. Movie of the Month Dolphin Tale— Wednesday, February 22, 3:00 p.m. Thought for the Month IV "We find greatest joy, not in getting, but in expressing what we are. Men do IV not really live for honors or for pay; their gladness is not the taking and hold- ing, but in doing, the striving, the building, the living. It is a higher joy to teach than to be taught. It is good to get justice, but better to do it; fun to have things but more fun to make them. The happy man is he who lives the life of love, not IV for the honors it may bring, but for the life itself' R.J. Baughan a � w M M M M b b b �D �Iryp q T `= a W W ti Pl P7 fA Pa N (A Pa RI �y l� O N O N M --i nbpD 0pp9 id ro �w pap�� V V pa9 U 5 a� on Pa or �. N W U o ,w N a O '} T U U OO 'd p b (!1 g Qa � '�` f!1 � y .O+ �^ Vl � (!1 g Q y f!1 g N LG P. ti Pa P. N Pl fA P. N W P. po��" �] c (pV O d Npp w e � V F O euzm vat N N U d los h U U N U u a U u 0 N U N N N W W W W W N N N N H ® T W W m m W m W m V m 01 m m W W N N N N` N IL O O ID II V` N m ✓S m T T T T T m T m T T m T T T T T m T S O' O' O' 6 6 ✓S 0' O' 6 6 6 O' O' O' 0' Q O' 6 > > > 7 > > _ > > > N m m m W N z z Z Z N Z Z Z � Z z z Z Z W Z z Z Z N N Z N z Z Z a C N N N N A J W N w lD T W A V1 N w w N W N N N N In N M. N N O O N O O O N O O O O O N O F+ O O N O F+ O I O iP N W Ol V w VI O O w m N 1p A N N A Ot W N 4D w O V v In m -1 to D s d 3 m< (D c ° c° « c° c o m m a o a os m a m a '3° ° m 3 o o_ °� c a m O c°< o X i s 3 c D0 3 �c v1 w N p z 0 -1 ;I� m z n n D n n �+ p w cn v+ n z n n -o -1 � v �* N 3 (D C O .+ (D S N\ 0, S S (D "O S S O C S C d 0 3 a— 3 ,_, m s a°o p N m n �+ °(D° o m- s f D m n N fD i = 021 O :°+ .' (D N °- ' T` : °O .* Oil m m O N m F 00 0 � •O r-« (D O �' (D w o 3" (D m' 3 'm o m m a v s o 3 m° '^ �. S ::p n Q S to O' •' OU f0 0 � _ °; (D O (D a Dl M 00 (D 0 ` (D m 3 a °o v u> j s c° c N o m 3 S v m< D� _ ° m N (D �* .t n a O S 0, O S Crt O Vl a O• tl4 -Mi O '00 N ` d .* O C z O 7c a '� O N �' C O 3 -11 4n O "O O 'O n N S 0 m N 2. 0'0 m o m c n '^ ° ('D o v m a g , 3 (D ° o m n z6 F Q o c m? 3 m N° a 3 2 F° m a a 3 (D d w O ? (D 4v O 70 0 n '" 0 0 - (D w S a � •O m a p: w m >> (D tr O0 — (D 7 M N A 0 CL p -1 m (D O -0 O! d (D in "O N I (D .�. O fD N F 0 O S (D N 7 O' n O d CL c ° 0 n of O O- A p 3 fD Q C -O N vOi F N S d S = O 0 (D N O fD fD 0 (D o ID 0 °< ' m E '� o of o �,,° °< m o rD a ° (D O < N < v a a m c (D �m ° (D rD• ° m o a a 4v c '^ �,�n rD (D o. .. o m CL i *. 0 S S O a 021 =+ a 0 a M < m * (D n , O_ ° (D a (D I .< D ((D 3 q a - o - Y m < F = o m v 3 (D m ' 3 (D v \ D r o (D O — o � d C OO N (D 3 � 6 (D C) \ \ \ N N N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ N W W O 0000 0\0 0\0 00 00 N O\) 0\i 0\1 D\1 W W N O \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ N N N N N N N N N N N N N N N N N N N N N N N N N N N N N e 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m a N N N N N N N N N N N N N N N N N N N N N N N N N N N N N V d C C� G C Ol d 1 m O O a 7 n (D m O ml N N N N N N N N N N N N N W N N N N H N l0 00 V V V V 01 W N N N O V V V Ot Ot .P W W T T T T T T T T T T T T T T T T T 'fl T T /D fD fD fD fD fD fD fD fD fD fD fD (O fD fD fD fU fD fD fD a a a a a a a a a a a a s a a a a a a a G G G C < < G C Z Z N Z Z Z N N Z Z W Z Z Z Z Z Z Z Z 0) to V A l0 Vl lfl A N w W W N W A 0 O 0 0 O O O OOl O A 0 0 0 W ~i O 0 i ID fl N D S S r '^ W W T N v w r W r T c a* a a a on o F � r3< a ID O O O d O o m z m 3 3 _T J on O w J (D c N -I M O W !n N 7c m n o 0 '00 = - � n < ;o d 0 o n O J j •'i' .� �• JC Oq N J C N S � o m N o 3 O C o J J d Oil (D M -o a o ° fD o• W q'o wJ n 3 a o m c 0 Q p. a do '��' m O_ ln' N z .lD+ < M N _. Oil O O O (D .. .. n "O \ i Ol W, a Oq Ob J J N d -Oa x N x(D `N'� S N N 3 N N M CL S V' N 3 c CL o N � O S O ° ? d ° o CL c o N •O N d o V 0 3 a z J o D a o of d m a 3 , m G S a O O. C D n O o J O a- o"< N d S A ry o = a o o < n r x M J rD a o D n 3 F O1 N O M N = N O � N a O. j m °• �• F M Z • N a N D N n i^ o V� Dl N 0 d J d CL J F o — o w * o Q m o o C M m CL M M -17 ? x as ^� � c 3 M N N N N N N N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ N N N N N N N N N N N N N N N N N N N N l0 00 V V V V V W N N F+ W N W N 01 Ql Ql W W \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ N N N N N N 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 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 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 January 2012 Prepared by Laura Sheak, Property Manager Police Report There were no police calls for the month of January. Wait List 39 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicant for Parkview Villa North (employed in C.H.) 31 applicants for Parkview Villa North (non- resident, elderly, handicapped) (updated) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 03 applicants for Parkview Villa South (non- resident) 00 applicant for Parkview Villa South 2BR (resident) 01 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 43 out of 45 (96 % occupancy) Move Outs #320 1/31/12 Move INS #401 1/01/12 #211 1/05/12 Maintenance Report (See attached) ® -o rt � NJ J N J N N J N -� g J\ J J 2 A W.W NN V V D7 O) NNN NNNJ0000(O CO CO (O CO (O W O 65 Ot A`W ` C � G W < < G < < < < < < < < < < < < < < < < < < G < < < < < < < < < < o ZZZZZ(nZZZZZ(n (n UI ZZZfn ZZCn (n ZZZZZZZZZZ�� N (C i 3 N N C 7 f�D 0) W 00 f0 V N N W (O W (It N N 0 N N A au W A N O) V (P V O) 0 N N NJ N O C)�22D'n�W'O OOV fAO ow 1 3 0) W SwZ n ypy�wom °Fvi33�?om3�.a(ovw3= «°3x3 O <= N `G ° 0 0 7 n N = O O < i 1 0 ,< N ? 'O O O O 3 O a CD 0� 0 a c - 0) �. O °: 0 O, 0 ,D„1 a s °-'. m 0 O N 0 S d �' 0 D7 9�7 (D ° O N O 0 N 7 V1 S N O S .N. M D7 •O S O O CD d S (O 0 .< a O -� 7< D) 0 0 7 D) (0 O S� (i ° 7 5 7 0 0 N (D T. 7 7 0 7 0 0 0 4 0 � d O =' 7770 m m j 0 Qa '00, 3 am m 3 3� 3 0(D am 0 0 w.3 3 X33 o amp u° oo°o0-0-oxFv-°ox-- r - =N2mo m.°Qo� xmo CD x a '� O. O '< �° (°« O 'O N(D (D °-' -O. (D f/1 0 m f0 d O 0 S 0 d N d -� ° (a O 2. N O •O � (c0 d S M x S >> a 0' m o �.'- m S v0, ° 0 (o N U3 N 3 N 0 O N o (O O O (n (a 77 • f� O d O 7 7 7, Cr =n N N �: a. j' 3 o M o 0? 'N"' Cn m o(D m V m °< 3 0. 9 O 0 3 A x v C N N d 0 p 7 O T d (D Q 0 O) (F CCD C 7C (D O o o 'O p 7 S D7 O 7 d d 0 0. D) i 0 0 m° (D .O d 0��� M d v(D m n m n�0 � �' m �= A� m (0D m o� 0 C� v v ' N O O 0 O N 0 ?� G N 9 d °" 01 O' p'7 � (AD ((DD O m. c 0 N N -J N N °: N -fj 7 N S O = i n a) =(d 0 T 0 O' 'O .5. N (D -I O M X X K (� D N 0 Dj N 7. N o a a, N OT, o N m °. N O. a. j• N O CL (D CL O N a a- x o O c i m a m a. N �j ° O ' r n C a. ° 0' d CL w CL y� 7 T' C O Doi m 9-0 .0.. d O' N N c S F 0 O' a. N° o N ' C N 'O0 1 �a 7 a (D N 'O d 0 O rt 0- CL 0 �: O o -, Jd O 0:O 7 . y o° 3 m° °- °° 0) o N d o m a 5- w v o 0 1p c 0 cD d. o N 3 3 W c `< O 0 7 �' CL Cl F a y m x °o m m o No 3 °'N o �. (�D �' O <D w 0 C 0 N T = CD 0 = NO N J O 0 0 O J (D 7 J n 0 O 'O Co < F (n J j W N N 7c CD R1 n O 000000000000000000000000000000003 (�W AOe1 V V `��NNNN`J- �OOOJO00 (700(0 fO� W � W,O., J J J J J J J J J J J J! J! J N) J J J J J J J J J N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N a \ §)() &&i \k /\_)) CD W :3 0 -7i! CD CD —CL \ \ \ \77 o 3 \\ §4 % ¥= a CL CD ! \i \ x 0. ( §2\2 \3§\\ 0 LL Z h m d p P q � � q O M O m O M M z e e El n ai �p i O p 5 � W N LQ P] r N 09 qq a .c y❑ N N 8 N N �~p O N ❑ O � p b 0 U ^Mi Cl U a ON vl N U U N 0 U O O O O o �aa o a r O o a O o a h ],' U ti x U Q '.Lp' U ry '✓p' U y X U Xyy X U F F o q F o � F o gg la F o pp cn iCV U N V }Oi%n ,.ry O pp (y+glJ A Nr O N a O I N PQ O 0 z p O 99T O P7 _O O O A O O U O O y p u G ti O W W W a °i 0 Ca cV r Pi Si U � v In U b� U 6( U b( U aC co U m U N u N U • -,; =741 • • •' . • Jenny will check on POW flag for the • pole • front notice be posted when Jim Kordiak be coming to help with renters rebates Eff"TIS • • • oCan have Service or • •, • Parkview Villa hours, please call the Maintenance Emergency number If you •. like a copy of -mergency numbers, please stop by the office. 1. 2. 3. 4. 5. 6. 7. 8. Febru 2012 Resident Council Meetinq Hili Laura Sheak announced that she would be leaving Parkview Villa at the end of the month. If you smell cigarette smoke coming from any apartment in the building, report it to the office. If you have complaints about the food that SACA is giving us, do NOT call SACA; call our president, Lyn Miner. Her number 781 -1042. We welcomed our new resident, Pat Cassady, Apt.320. We thanked Shirley Benitez and her committee for the nice decorations. The VOA lunches are $3.50 per meal. The Resident Council voted to pay half for bird food. [32 yes, 2 no] Money winners were Jackie Ovshak, DeAnne Kunshier, Pat Cassady, and Arlene Peterson. RESIDENT COUNCIL MEETING I LI °T ® 1-9-12 1. Meeting was called to order by outgoing Council President, Rheta Nelson. 2. Jennifer Eels gave the Manager's Report on several subjects: Do not put grease down your sink or toilets, as it causes damage to the pipes. Dispose of grease properly. Laura is on vacation from January 12 to January 23. Pets are not allowed in the common areas of the building unless they are service or companion animals. Wrap your cat waste properly, so that it does not spill on the floor by the trash chute. Leave your recycle basket outside your door, Monday and Thursday mornings by 9:30 a.m. DO NOT set it out the night before! If the Manager's Office is closed, there will be no pick -up that day. If the VOA lunch in the "B" Room refrigerator does not have your name on it, do NOT take it. Do not let people into the building if you do not know them. A list of people who are banned from the property is on the bulletin board behind the glass, in the front lobby. If you see such a person on the property, contact the police. Let Management know if any resident gave access to the building to any person who is banned. The City of Columbia Heights has an excessive nuisance policy which could result in fines for residents /buildings if three nuisance calls are received in a 12 -month period. Copies of the policy are available for your viewing, in the office. 3. Ken Bloch gave the Treasurer's Report. 1. Terry introduced the new resident, Deb, in Apt. 211. 5. Cecelia gave the Sunshine Report. 30 get well cards were sent, and one sympathy card to Tom Pilarsk, as his mother passed away. 6. Rheta Nelson introduced the new Board Members: President — Lyn Miner Vice President —Vivian Fahey Secretary — Jessie Chudek Treasurer — Kenneth Bloch Member -at -Large — LeAnn Miller Sergeant -at -Arms — Matthew Kopacek 7. Lyn M. showed a thank -you page that will be framed and given to Joe and Mary Lou Goodman to thank them for all the help they give the Council. 8. $100 per month, from the Contingency Fund, can be authorized for purchases for unforeseen expenses. Check with the President, before buying anything. 9. HRA meeting is Tuesday, January 24 at 7 p.m. 10. A new telephone list will be out in the next two weeks. COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meetin of: April 24, 2012 AGENDA SECTION: Business Items ORIGINATING EXECUTIVE NO: 9 DEPARTMENT: HRA DIRECTOR APPROV ITEM: Window Analysis Bid - Encompass BY: Scott Clark BY: DATE: April 18, 2012 BACKGROUND: At the January 24, 2012 HRA meeting staff informed the HRA that a request for proposal was being prepared by CommonBond for analysis of the windows at Parkview Villa South. Over time it has become clear that a number of window envelopes have failed and that water intrusion is becoming an issue. As such, a request for proposal was originally sent out for analysis of the problem and contract preparation for bidding (similar to how the modernization plans and bids process works). Only two bids were received- Encompass at $22,820 and Inspec at $36,675 (tabulation enclosed). Staff realizes that the issue of actually correcting problems, coupled with the installation of windows, becomes complicated due to the potential sale to Aeon. In other words, does the HRA do window work in 2012 and negotiate that as part of the sales price? Is the issue at hand something that can wait until 2013 so the efficiencies of a total rehabilitation work, that Aeon is proposing, can be implemented? Based on these questions staff is recommending the following: 1) Staff asked Encompass to break their bid into two parts. Phase 1 ($9,660) is the analysis and Phase 11 ($13,160) is the plan preparation, bidding, etc. 2) Staff recommends the issuing of the Phase I portion of the bid at this time. The information derived from the analysis will serve as the foundation for discussions with all concerned parties as to what the next steps should be. Put in another way, you can't discuss a solution until you know what the problem is, and in this case, how big and extensive the issues possibly are. If approved, it is assumed that the Phase I work will be done in three months. Lastly, the Phase I will be funded thorough line item 5120, Capital Improvements, in the approved 2012 Parkview Villa South budget. RECOMMENDATION: Approval of the Phase I contract with Encompass in the amount of $9,660 for window analysis at Parkview Villa South. RECOMMENDED MOTION: Motion to Approve Phase I of the Encompass Contract dated March 30, 2012 in the amount of $9,660. 630 HRA ACTION: C.i>rnrnoni_iood CUnl >i U N I I lG, fj Memorandum DATE: March 15, 2012 TO: Laura Frost FROM: Brian Hon RE: Parkview Villa South Apartments Laura, below is the breakdown of the exterior architect /engineer services at Parkview Villa South— the proposals from vendors are attached: I would recommend Encompass, Inc. for the architect /engineer services for Parkview Villa South Apartments. WAI /Continuum, Encompass, Inspec Inc, Inc. Totats NIA $22,820.00 $36,675.00 Building Envelope N/A $4,640.00 $7,080.00 Investigation & Documentation Analysis of NIA $3,520.00 Included Conditions Contract N/A $7,840.00 $11,075.00 Documents & Bid Management Construction N/A $5,320.00 $16,760.00 Observation High Lift — Rental NIA $1,500.00 $1,760.00 equipment I would recommend Encompass, Inc. for the architect /engineer services for Parkview Villa South Apartments. Bonn1. engineering consultants forensic analysis March 30, 2012 Mr. Brian Hon CommonBond Communities 328 Kellogg Boulevard West St, Paul, MN 55102 Re: Professional Services Proposal Parkview Villa South 965 401h Avenue NE Columbia Heights, MN 55421 SCOPE OF SERVICES— PHASE I Encompass, Inc. proposes to provide the following services: 1.0 Building Envelope Investigation & Documentation The investigation will include documentation of existing conditions to assess and analyze exterior envelope deficiencies, the focus of investigation will be on water intrusion issues at window openings. Specifically, our investigation will include: 1.1 Document Review Review available pertinent documents provided by the owner. Desirable documents for review include design drawings, specifications, addenda, and other documents related to the original construction; building repairs; maintenance reports or work orders relative to the building envelope or any reported deficiencies. 1.2 Building Envelope Condition Documentation 1.2.1 Conduct an overall facade assessment to include a visual survey of the exterior envelope conditions via a high lift, focus will be on the condition of the windows. 1.2.2 Inspect available living units that are experiencing water intrusion and /or reporting interior moisture intrusion. 1.2.3 Perform invasive openings through the facade at window openings to determine wall construction configurations. Remove and re- install a window to analyze window configuration and performance. 1.2.4 Window Testing 1.2.4.1 Conduct an AAMA 502 water test at two windows. 1.2.4.2 Subject windows will be based upon visual observations, accessibility, and /or unit owner reports of window issues. 1.2.4.3 The purpose of testing will be to identify deficiencies with the window units and /or window flashing details that are causal to the reported water intrusion issues. 2.0 Analysis & Summary Report 2.1 Analyze field data and existing documentation and prepare a summary of findings from the investigation, including conclusions relative to causes of distress. 2.2 Determine repair scope to address the root cause of the problems in order to ensure the exterior envelope will resist moisture intrusion and reduce future maintenance costs. Multiple repair options and phasing of repairs will be considered, when possible and appropriate. 2.3 Discuss findings of investigation with owner and present repair options. COST OF ENGINEERING SERVICES— PHASE I The cost of the professional engineering services required for proposed Phase I of the exterior envelope review of the Parkview Villa South building is as follows: 1. Building Envelope Investigation & Documentation $4,640.00 2. Analysis & Summary Report $3,520.00 3. High Lift Rental $1,500.00 Total $9,660.00 These proposed costs are valid for 90 days. SCOPE OF SERVICES — PHASE II 3.0 Contract Documents 3.1 Encompass will produce restoration drawings /specifications and construction documents to be utilized for bidding as specified by our report recommendations; documents will include design drawings, summary of work, specifications, instructions to bidders, general conditions, a bid form, and an agreement to be used between owner and contractor. 3.2 Bid Management: Encompass will conduct a pre -bid meeting with bidding contractors, a post -bid meeting with the apparent low bidder, and a pre- construction meeting. This proposal and associated costs are based on bidding the project one time. Should the owner to bid the project multiple times, additional costs may apply. 4.0 Construction Observation 4.1 During the construction phase of the exterior restoration, Encompass will perform periodic on -site visits to observe construction activities. 4.2 Encompass will provide to the owner copies of all construction photographs and construction observation reports. 4.3 This proposal and associated costs are based on performing 5 hours of construction observation per week during an estimated construction duration of 6 weeks. Actual cost associated with construction observation services will depend on the actual duration of the construction project; should the construction project be longer than 6 weeks, additional construction observation costs may apply. COST OF ENGINEERING SERVICES — PHASE II The cost of the professional engineering services required for proposed Phase II of the exterior envelope review of the Parkview Villa South building is as follows: 1. Contract Documents & Bid Management $7,840.00 2. Construction observation $5,320.00 Total $13,160.00 These proposed costs are valid for 120 days. Thank you for the opportunity to present this proposal. Upon awarding of the contract, we will schedule the project and coordinate commencement of the investigation with you. Sincerely, Kent J. Jones, P.E. Vice President /Principal Encompass, Inc.