Loading...
HomeMy WebLinkAbout20160304_HRA_PacketCH COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY AGENDA March 14, 2016 6:30 pm 1. Call to Order 2. Roll Call 3. Pledge of Allegiance City Hall City Council Chambers 590 401h Avenue NE Columbia Heights, MN 55421 CONSENT AGENDA 4. Approve minutes of July 28, 2015 S. Approve Financial Report and Payment of Bills for July -December, 2015 -Resolution 2016 -01 Motion: Move to approve Consent Agenda as presented. OTHER BUSINESS 6. Approve Repayment of North Building Operating Grant to HUD 7. Parkview Villa Construction Update 8. Proposed New HRA Format Discussion 9. Adjourn The next regular HRA meeting will be January 3, 201 7 at City Hall. HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE MEETING OF JULY 28, 2015 I. Call to order —The meeting was called to order by Chair Diehm at 7:00 pm. 2. Roll Call — Members present: Bruce Nawrocki, Gary Peterson, Donna Schmitt, John Murzyn Jr, Tammera Diehm, and Rheta Nelson. Staff Present: Executive Director -Walt Fehst, Community Development Director- Joseph Hogeboom, and Secretary- Shelley Hanson. Legal Counsel- Martha Ingram, Kennedy & Graven CommonBond Staff- Laura Frost. Aeon Representative -James Lenhoff 3. Pledge of Allegiance — Recited CONSENT AGENDA 4. Approve Minutes of April 28, 2015 5. Approve Financial Report and Payment of Bills for April, May, and June 2015 on Resolutions 2015 -06 Questions from members• There were no questions from members. Motion by Peterson, seconded by Nawrocki, to approve items on the Consent Agenda as presented. All ayes. MOTIONPASSED. HRA Minutes Page 2 July 28, 2015 HRA RESOLUTION 2015 -06 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR APRIL, MAY, AND JUNE, 2015 AND PAYMENT OF BILLS FOR THE MONTHS OF APRIL, MAY, AND JUNE, 2015. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (HRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the HRA to examine the statement and treasurer's vouchers or bills and if correct, to approve them by resolution and enter the resolution in its records; and WHEREAS, the financial statement for the months of April, May and June, 2015 and the list of bills for the months of April, May and June, 2015 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 28th day of July, 2015. MOTION BY: Peterson SECONDED BY: Nawrocki AYES: All ayes Chair Attest by: Shelley Hanson, Secretary HRA Minutes Page 3 July 28, 2015 6. Approve 60 day Extension to Management Agreement for Parkview Villa North and South with CommonBond Housing on Resolution 2015 -07 Hogeboom explained that the current contract with CommonBond Housing for the management of Parkview Villa expires on July 31, 2015. When the last extension of the contract was approved in January of 2015, it was anticipated that the sale of the property would close in the spring. Due to unforeseen issues, the sale of Parkview Villa has been delayed. If the sale is approved this evening, closing is expected to occur by August 14. Staff is recommending extending the management contract with CommonBond Housing until September 30, 2015 should any additional unforeseen issues arise. Once the sale occurs, this contract retains the services of CommonBond housing to complete bill payment, HUD reporting and other administrative duties associated with the property prior to the time of closing. Staff recommends adopting Resolution 2015 -07 approving the extension of the Management Agreement with CommonBond Housing for Parkview Villa North and South. Questions from members: Schmitt asked who would be performing the audit after the sale is complete. Hogeboom stated that the financial reports are those required by HUD and will be completed by CommonBond. The annual year end audits will be done by the Auditors the City uses as it has been in the past. Diehm asked if September 30`b is enough time to get all the outstanding bills paid and the financial reports done. Frost and Hogeboom both thought it should be adequate. Motion by Peterson, seconded by Nawrocki, to waive the reading of Resolution 2015 -07, there being ample copies available to the public. All ayes. MOTIONPASSED. Motion by Peterson, seconded by Nawrocki, to adopt Resolution 2015 -07, being a Resolution of the Housing and Redevelopment Authority in and for the City of Columbia Heights, approving an extension to the Management Agreement for Parkview Villa North and South and authorizing the Chairperson and Executive Director of the HRA to execute the contract. All ayes. MOTION PASSED. HRA Minutes Page 4 July 28, 2015 BRA RESOLUTION NO. 2015-07 RESOLUTION APPROVING 60 -DAY EXTENSION TO MANAGEMENT AGREEMENT FOR PARKVIEW VILLA NORTH AND SOUTH WITH COMMONBOND HOUSING BE IT RESOLVED BY the Board of Commissioners ('Board ") of the Housing and Redevelopment Authority in and for the City of Columbia Heights (the "Authority ") as follows: Section 1. Recitals. 1.01. The Authority previously entered into a Management Agreement dated February 1, 2008 (the "Agreement') with CommonBond Housing (the "Agent') for the management of a housing facility known as Parkview Villa North and South (the "Property "). 1.02. The original term of the Agreement has expired, and the Authority has previously entered into four one -year extensions and one six-month extension of the Agreement, the latest of which terminates on July 31, 2015. 1.03. The parties have agreed to an additional sixty -day extension of the Agreement (the "Extension "), to allow for continued management of the Property by the Agent until the Property is conveyed to a third party, which conveyance is expected to take place in August 2015. The termination of the management services described in the Agreement shall be the date of closing on the conveyance. 1.04. The parties have further agreed to incorporate the terms of a Letter of Understanding between the Authority and the Agent as revised on June 9, 2015, into the Extension, providing for additional financial and accounting services to be performed by the Agent after closing on the conveyance of the Property, which additional services shall terminate on September 30, 2015. Section 2. Extension AWroved. 2.01. The Extension as presented to the Board is hereby in all respects approved, subject to modifications that do not alter the substance of the transaction and that are approved by the Chair and Executive Director, provided that execution of the Extension by such officials shall be conclusive evidence of approval. The Chair and Executive Director are hereby authorized to execute, on behalf of the Authority, the Extension. Adopted by the Board of Commissioners of the Housing and Redevelopment Authority in and for the City of Columbia Heights, this 28th day of July, 2015. Chair ATTEST: Secretary HRA Minutes Page 5 July 28, 2015 2ND EXTENSION OF MANAGEMENT AGREEMENT FOR PARKVIEW VILLA NORTH AND SOUTH THIS AGREEMENT, made as of the 28`s day of July, 2015, by and between the HOUSING AND REDEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS, a public body corporate and politic (the "Owner"), established pursuant to Minnesota Statutes, Sections 469.001 to 469.047 (hereinafter referred to as the "Act"); and CommonBond Housing, a Minnesota nonprofit corporation ( "Agent "). WITNESSETH WHEREAS, on January 23, 2008 the Owner approved a Management Agreement with Agent, dated February 1, 2008 (the "Contract "), for the management of a housing facility known as Parkview Villa North and South (the "Property "), which among other terms, provided for a five -year term; and WHEREAS, the Department of Housing and Urban Development ( "HUD ") denied the ability of the Owner to enter into a five -year contract based on a previously approved 1969 Annual Contributions Contract which limits all contracts to two years; and WHEREAS, in order to meet the spirit and intent of the originally approved Contract, both HUD and the Owner agreed to an amended Contract term of an initial two -year period with three one -year extensions; and WHEREAS, this language is memorialized in Section 1.3 of the Contract as approved by the Owner on April 22,2008; and WHEREAS, the parties agreed to an additional one -year extension of the Contract in January 2014, and the Owner approved such extension by Resolution No. 2014 -04 on January 28, 2014; and WHEREAS, the parties agreed to an additional six -month extension of the Contract in January 2015, and the Owner approved such extension by Resolution No. on January 26, 2015; and WHEREAS, the parties agree and understand that the Owner has entered into a purchase agreement pursuant to which the Owner will convey the Property to Aeon, with an expected closing in August 2015 ( "Closing "); and WHEREAS, the parties desire to enter into an additional extension of the Contract, to allow for the continued management of the Property by Agent until the date of Closing and for continued financial and accounting services to be performed by Agent through September 30, 2015 (the "Financial and Accounting Services "), as provided in the Letter of Understanding between the Authority and the Agent, dated as of June 9, 2015, which is attached to this Agreement and fully incorporated by reference (the "Letter of Understanding "). NOW, THEREFORE, in consideration of the premises and the mutual obligations of the parties hereto, each of them does hereby covenant and agree with the other as follows: HRA Minutes Page 6 July 28, 2015 1. The Contract is hereby extended for a sixty -day period, commencing August 1, 2015 and terminating September 30, 2015 (the "Termination Date "). The Agent shall provide the management services described in the Contract through the date of Closing, and shall provide the Financial and Accounting Services described in the Letter of Understanding through the Termination Date. 2. Section 10.2 of the Contract shall be amended to read, "This Agreement shall terminate upon the sale of the Premises or in the case of building demolition caused by natural or man- made causes; provided that the Financial and Accounting Services shall terminate on September 30, 2015." 3. The Contract, as amended by the extension thereto approved January 26, 2015 and by this Agreement, remains in full force and effect, and is not modified except as expressly provided herein. IN WITNESS WHEREOF, the Owner has caused this Agreement to be duly executed in its name and behalf and its seal to be hereunto duly affixed and the Agent has caused this Agreement to be duly executed in its name and behalf as of the date first above written. HOUSING AND REDEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS By _ Its Chair By Its Executive Director COMMONBOND HOUSING By Its 1080 Montreal Avenue St. Paul, MN 55116 651.291.1750 (P) 651,291.1003(F) EXHIBIT A Walter Fehst Columbia Heights Housing and Redevelopment Authority 590 - 40th Ave NE Columbia Heights MN 55421 Dear Mr. Fehst, This is a letter of understanding between the Columbia Heights Housing and Redevelopment Authority, owner of Parkview Villa North and Parkview Villa South, and CommonBond Housing, Management Agent for the Parkview Villas to address the duties and tasks that CommonBond housing has agreed to perform under a separate agreement with the City of Columbia Heights post sale of the Parkview Villas. Phis list is not meant to be exhaustive but rather a general guideline from which to work. Below please find a list of tasks and duties that ConunonBond Housing will perform post - closing of the sale of the Parkview Villas. • Management Agent will compile information for, and report at July Board Meeting for Quarter 2 financials • Management Agent will prepare summary list of 1099 recipients and reportable amounts, after 8/312015 and make available to the City of Columbia Heights • Management Agent will provide CRPs for January through June 2015, provided to the City of Columbia Heights by January 20, 2016 • Management Agent will provide archived information to the City for the years of management • Management Agent will provide Final Financial Reports and Year end accounting • Management Agent will work with HUD to close PIC system and other decommissioning of HUD related systems • Management Agent will handle Accounts Payable thru August 310 2015 • Management Agent will be available to assist and advise City of Columbia Heights on additional matters that are not listed in this document CommonBond Housing proposes the following fee for this ongoing administration through September 30 ", 2015 (includes the January CRPs), one lump sum of $7,038. This amount is the difference between our current contract minus the salaries. Best Regards, 1 'Liss Wilcox- Erhardt Executive Vice President Housing and Services Revised 6/9/15 STABLE HOMES. STRONG FUTURES, VBRANT COMMUNII IFS. An rgRnloppm,wuq 6n�irwmbv,rr+imi mgmx uu /.e +nxronGmnl n,,p NelghborW Ills• CNARTIRID M!M!!R HRA Minutes Page 8 July 28, 2015 7. Sale Update from Aeon Hogeboom explained the sale has been a very complex and long process since there are actually two separate entities and two sets of accounts to consider. Getting approval from HUD to sell the north building took much longer than the Commission thought it would. The proposed closing date of May 15`h was also delayed several times because not all of the financing was secured. James Lenhoff, Director of Housing Development for Aeon, told those present that the financing is finally in place now and Aeon has made plans to start remodeling immediate after the closing date. He said 4 million dollars of improvements will be done in the next 9 -10 months. The community space will be remodeled, so that a game room and fitness center will be added, upgrades will be made to the kitchen and the salon areas, and the remaining community space will be updated. Lenhoff said a sun porch will also be constructed along the front of the building. He thanked City Officials, the commission members, the residents at Parkview Villa and the management company for being so patient during this long process. Nawrocki asked if the parking area would be affected or if it would be expanded. Lenhoff said there are no plans to change the parking area for the building and there is no room to expand the lot. PUBLIC HEARING 8. Resolution 2015 -08: Conveyance of 965 40th Avenue NE — Parkview Villa North and South to Aeon In 2011, the Housing and Redevelopment Authority initiated a process to transfer ownership of Parkview Villa to a private entity. Aeon, a local non -profit affordable housing provider, was selected to be the purchaser of the property. In 2014, the United States Department of Housing and Urban Development (HUD) approved the method of "voluntary conversion" for the sale of the property, allowing the public housing units in Parkview Villa North to be converted to Section 8 -based housing. The HRA will continue to receive revenue from the roof -top antenna until 2027. The HRA will have to remain in place, at least into the foreseeable future, in order to perform audit and bookkeeping activities related to its time as owner of the property. Martha Ingram from Kennedy & Graven stated that the Commission is being asked to approve the amended and restated Purchase and Development Agreement to allow the closing to move forward. Staff recommends adopting Resolution 2015 -08 approving the conveyance of 965 40th Avenue NE — Parkview Villa North and South — to Aeon. HRA Minutes Page 9 July 28, 2015 Comments /Ouestions from members: Nawrocki asked about what happens to the fund reserve balances. Ingram told members that the fund balance for the north building must go back to HUD. Some of it will be used to pay outstanding bills and legal fees. Once that is all reconciled, the balance will be paid to HUD as required. The fund balance of $885,000 for the south building will be retained by the City. Ingram also told members that negotiations are still being finalized on the terms of the antenna lease as an additional fund source to the City for a period of 11 years. Ingram told members that the Purchase and Development Agreement has been amended several times as one of the investors, a limited partner who purchased the tax credits, had several revisions to the legal terms of the Agreement. Nawrocki asked who the investors were. Lenhoff said the MN Housing Finance Agency helped coordinate some of the financing and was instrumental in overseeing the sale of the tax credits. US Bank is the investor who required changes to the agreement and as a result has postponed the closing. Nawrocki asked how the note would be paid back and wanted details about the terms of the sale price. Ingram explained that the buildings are being sold for 7.4 million. The City will receive $885,000 at the time of closing and will also receive the antenna lease revenues for 11 years. There is a Promissory Note in the amount of 6.585 million dollars payable by Aeon in 30 years to the HRA. The Note is at zero percent interest, and payable in full at the end of the 30 years. No monthly payments are required during this 30 year time frame. Out of the 6.585 million, 5.2 million must be paid back to HUD at the end of the 30 years. The HUD letter of approval dictates this amount based on the figure of the appraisal done in 2012. The HRA would retain the difference of 1.385 million, along with the initial cash payment. Nawrocki asked what happens if Aeon isn't in business 30 years from now. How do we get our money? He felt an amount should be set aside along the way or put in escrow towards the pay off at the end of the term. Ingram responded that we can't force them to set aside funds, nor can we control their accounting practices. This was discussed during the negotiation process, but Aeon agreed to the antenna lease revenue going to the City in lieu of partial payments of the note itself. Ingram stated the HRA's security is the Assignment of Mortgage and that if necessary, the HRA can foreclose on the mortgage and take the building back. Lenhoff said that if Aeon ever went out of business or sold the building, the new owner would inherit whatever debt and payoffs that are attached to the building. HRA Minutes Page 10 July 28, 2015 Schmitt asked what happens if the HRA disbands between now and then. Ingram said the HRA will remain intact for the time being as there will be many loose ends to tie up. Research is being done on whether the HRA can transfer its responsibilities to the EDA. If not, then the HRA must remain in effect until the 30 years is up. Schmitt said to make sure the language is accurate because she came across a typo in the legal description. Ingram said "Tract C" will also be added to the property description. Nawrocki questioned some of the restrictions in the Memo of Understanding. Ingram stated they are the same requirements that are in place now. Public Hearing Opened: No one wished to speak on this. Public Hearing Closed. Motion by Peterson, seconded by Murzyn, to waive the reading of Resolution 2015 -08, there being ample copies available to the public. All ayes. MOTIONPASSED. Motion by Peterson, seconded by Murzyn, to adopt Resolution 2015 -08 approving the conveyance of land and the housing facility known as Parkview Villa thereon, located in the City of Columbia Heights, Minnesota and legally described as follows, to Aeon: That part of the South 112 of Lot 13, lying Northwesterly of thefollowing line: Beginning at the Northeast corner of the South 112 of Lot 13; thence Southwesterly to a point on the South line of said Lot 13, said point being 2 feet Easterly of the Southwest Corners of Lot 13; the South 241 feet of Lot 14; then south 112 ofLot 15; Lot 39 except the West 30 feet thereof- Lots 40, 41, 42 and 43 and the West 112 of Lot 44, all in Block 5 Reservoir Hills, Columbia Heights, Anoka County, Minnesota; And the East 40 feet of the South 112 of Lot 16, Block 5, Reservoir Hills, Columbia Heights, Anoka County, Minnesota. All Ayes- MOTION PASSED. HRA Minutes Page 11 July 28, 2015 HOUSING AND REDEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS RESOLUTION NO. 2015-08 RESOLUTION APPROVING AN AMENDED AND RESTATED PURCHASE AND DEVELOPMENT CONTRACT (INCLUDING THE SALE OF LAND AND PROVISION OF A LOAN) BETWEEN THE HOUSING AND REDEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS AND AEON BE IT RESOLVED By the Board of Commissioners (the `Board ") of the Housing and Redevelopment Authority in and for the City of Columbia Heights (the "Authority") as follows: Section 1. Recitals. 1.01. The Authority is authorized to exercise the powers of a housing and redevelopment authority, pursuant to Minnesota Statutes, Sections 469.001 to 469.047, as amended (the "HRA Act "). 1.02. The Authority and Aeon (the "Buyer ") have proposed to enter into an Amended and Restated Purchase and Redevelopment Contract (the "Contract "), setting forth the terms and conditions of sale and redevelopment of certain property owned by the Authority, located at 965 40`s Avenue NE and described on Exhibit A attached hereto (the "Property"), including the housing facility known as Parkview Villa (the "Facility"). 1.03. Pursuant to the Contract, the Buyer will acquire the Property and will construct certain improvements to the Facility's critical building systems, including HVAC, plumbing, elevator, and fire alarms, along with other improvements as provided in the Contract. 1.04. The Authority has on this date conducted a duly noticed public hearing regarding the sale of the Property to the Buyer, at which all interested persons were given an opporhmity to be heard. 1.05. The Authority finds and determines that conveyance of the Property to the Buyer has no relationship to the City's comprehensive plan, in that no amendment or modification of the comprehensive plan is required for the conveyance or redevelopment of the Property and the Facility will continue to be operated as a rental housing facility for low- to moderate - income persons. The activities of the parties under the Contract implement housing goals of the City's Comprehensive Plan: "Provide a variety of life -cycle housing opportunities within the community." Page 12 1.06. Pursuant to the HRA Act, the Authority is authorized to provide loans, interest rate subsidies, or assistance in any form to private development consisting of the construction or substantial rehabilitation of buildings and ancillary facilities for low- to moderate - income housing facilities. The Authority hereby finds and determines that it is in the best interests of the Authority to provide a Loan to the Buyer for the purpose of financing a portion of the Purchase Price of the Facility, all as such terms are defined in the Contract. 1.07. The Board has reviewed the Contract and finds that the execution thereof and performance of the Authority's obligations thereunder, including conveyance of the Property and provision of the Loan, are in the public interest and will further the objectives of its general plan of economic development and redevelopment, because it will fiuther the above - stated housing goals. Section 2. Authority Approval-, Further Proceedings. 2.01. (a) The Contract as presented to the Board, including the sale of the Property described therein and provision of the Loan, is hereby in all respects approved, subject to modifications that do not alter the substance of the transaction and that are approved by the Chair and Executive Director, provided that execution of the Contract by such officials shall be conclusive evidence of approval. (b) Pursuant to the Contract, the Authority will loan to the Buyer the Loan in the principal amount of $6,585,000, evidenced by a promissory note (the "Note ") and secured by a Collateral Assignment of Note and Mortgage (the "Assignment') to be executed and delivered to the Authority by the Buyer in substantially the forms attached hereto as Exhibit B and Exhibit C. The Loan shall not bear interest. 2.02. The Chair and Executive Director are hereby authorized to execute on behalf of the Authority the Contract and any documents referenced therein requiring execution by the Authority, including without limitation the deed, and to carry out, on behalf of the Authority, its obligations thereunder. 2.03. Authority and City staff are authorized and directed to take all actions to implement the Contract. Section 3. Effective Date. This resolution shall be effective upon approval. Approved by the Board of Commissioners of the Housing and Redevelopment Authority in and for the City of Columbia Heights this _ day of 2015. Chair ATTEST: Secretary HRA Minutes Page 13 July 28, 2015 Tract A: Exhibit A Property That part of the South 1/2 of Lot 13, lying Northwesterly of the following line: Beginning at the Northeast comer of the South 1/2 of Lot 13; thence Southwesterly to a point on the South line of said Lot 13, said point being 2 feet Easterly of the Southwest Comers of Lot 13; the South 241 feet of Lot 14; then south 1/2 of Lot 15; Lot 39 except the West 30 feet thereof, Lots 40, 41, 42 and 43 and the West 1/2 of Lot 44, all in Block 5 Reservoir Hills, Columbia Heights, Anoka County, Minnesota (Abstract) Tract B: The East 40 feet of the South 1/2 of Lot 16, Block 5, Reservoir Hills, Columbia Heights, Anoka County, Minnesota. HRA Minutes Page 14 July 28, 2015 Exhibit B PROMISSORY NOTE $6,585,000 2015 Aeon ( "Maker "), for value received, hereby promises to pay to the Housing and Redevelopment Authority in and for the City of Columbia Heights, a public body corporate and politic under the laws of Minnesota, or its assigns (collectively referred to herein as "Holder "), at its designated principal office or such other place as the Holder may designate in writing, the principal sum of Six Million Five Hundred Eighty -Five Thousand and no /100°i Dollars ($6,585,000.00), in any coin or currency that at the time or times of payment is legal tender for the payment of private debts in the United States of America. This Note shall not bear interest. The principal of this Note is payable as follows: 1. The entire unpaid balance of principal shall be due and payable upon the earlier of the following: (i) thirty (30) days (or such longer period as is set forth in the Agreement) after written notification by Holder to Maker of the occurrence of an Event of Default as defined in the Amended and Restated Purchase and Development Contract between the Maker and the Holder, dated as of , 2015 (the "Agreement ") not timely cured thereunder; or (ii) 2045. This Note may be prepaid, at any time or from time to time, in full or in part, without notice, penalty or premium. 2. This Note is secured by a Collateral Assignment of Note and Mortgage (the "Assignment ") given to the Holder on the date hereof, pursuant to which Maker provides an assignment of a certain Promissory Note from Parkview Villa Limited Partnership, a Minnesota limited liability partnership, in favor of Maker (the "Parkview Note "), and the Mortgage securing the Parkview Note (the "Parkview Mortgage," and together with the Parkview Note, the "Pledged Documents "). All of the agreements, conditions, covenants, provisions, and stipulations contained in the Agreement and the Assignment are hereby made a part of this Note to the same extent and with the same force and effect as if they were fully set forth herein. It is agreed that time is of the essence of this Note. If an Event of Default occurs under the Agreement, the Assignment, or any other instrument securing this Note, then the Holder of this Note may at its right and option, in accordance with the terms hereof, declare immediately due and payable the principal balance of this Note and interest accrued thereon, together with reasonable attorneys' fees and expenses incurred by the Holder of this Note in collecting or enforcing payment hereof, whether by lawsuit or otherwise, and all other sums due hereunder or any instrument securing this Note. The Maker of this Note agrees that the Holder of this Note may, without notice to and without affecting the liability of the Maker, accept additional or substitute security for this Note, or release any security or any party liable for this Note or extend or renew this Note. This Note is contingent upon Maker's receipt of principal payments under and pursuant to the Parkview Note, and the sole recourse of Holder for repayment of the principal balance of this Note shall be the exercise of its rights against the Pledged Documents and related security thereunder. 3. The remedies of the Holder of this Note as provided herein, and in the Agreement, the Assignment, or any other instrument securing this Note, shall be cumulative and concurrent and may be pursued singly, successively, or together, and, at the sole discretion of the Holder of this Note, may be exercised as often as occasion therefor shall occur; and the failure to exercise any such right or remedy shall in no event be construed as a waiver or release thereof. The Holder of this Note shall not be deemed, by any act of omission or commission, to have waived any of its rights or remedies hereunder unless such waiver is in writing and signed by the Holder and then only to the extent specifically set forth in the writing. A waiver with reference to one event shall not be construed as continuing or as a bar to or waiver of any right or remedy as to a subsequent event. This Note may not be amended, modified, or changed except only by an instrument in writing signed by the party against whom enforcement of any such amendment, modifications, or change is sought. 4. If any term of this Note, or the application thereof to any person or circumstances shall, to any extent, be invalid or unenforceable, the remainder of this Note, or the application of such term to persons or circumstances other than those to which it is invalid or unenforceable shall not be affected thereby, and each term of this Note shall be valid and enforceable to the fullest extent permitted by law. 5. If the Maker causes an Event of Default to occur, and if the Holder engages legal counsel or others in connection with advice to the Holder or the Holder's rights and remedies under the Agreement or this Note, the Maker shall pay all reasonable expenses incurred by the Holder for such persons, irrespective of whether any suit or other proceeding has been or is filed or commenced. Any such expenses, costs and charges shall constitute additional principal, payable upon demand, and subject to this Note and the Assignment. 6. It is intended that this Note is made with reference to and shall be construed as a Minnesota contract and is governed by the laws thereof. Any disputes, controversies, or claims arising out of this Note or the Agreement shall be heard in the state or federal courts of Minnesota, and all parties to this Note and the Agreement waive any objection to the jurisdiction of these courts, whether based on convenience or otherwise. 7. The performance or observance of any promise or condition set forth in this Note may be waived, amended, or modified only by a writing signed by the Maker and the Holder. No delay in the exercise of any power, right, or remedy operates as a waiver thereof, nor shall any single or partial exercise of any other power, right, or remedy. IT IS HEREBY CERTIFIED AND RECITED that all conditions, acts, and things required to exist, happen, and be performed precedent to or in the issuance of this Note do exist, have happened, and have been performed in regular and due form as required by law. IN WITNESS WHEREOF, the Maker has caused this Note to be duly executed as of the _ day of 2015. AEON By: Its Page 16 Exhibit C COLLATERAL ASSIGNMENT OF NOTE and MORTGAGE THIS COLLATERAL ASSIGNMENT OF NOTE AND MORTGAGE (the "Assignment ") is made effective as of the _ day of , 2015, by AEON, a Minnesota nonprofit corporation (the "Borrower "), in favor of THE HOUSING AND REDEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS, a public body corporate and politic and political subdivision of the State of Minnesota (the "HRA"). WHEREAS, Borrower has provided to HRA a certain Promissory Note dated as of 2015, pursuant to which Borrower promises to pay to HRA the principal sum of $6,585,000 in accordance with the terms thereof (the "Note "); and WHEREAS, to secure payment and performance of the obligations of Borrower under the Note, HRA has required that Borrower execute and deliver to HRA this Assignment to collaterally assign to HRA Borrower's right, title and interest in and to (a) that certain Promissory Note dated , 2015, made by Parkview Limited Partnership, a Minnesota limited partnership ( "Partnership ") to the order of Borrower in the original principal amount of $6,585,000 (as it may be amended, restated, replaced or otherwise modified from time to time, the "Partnership Note "); and (b) that certain Mortgage, dated 2015, executed and delivered by Partnership and filed for record on or about the date hereof, with Anoka County Office of Registrar of Titles and Office of the Recorder, securing the Partnership Note and covering, among other things, real estate legally described on Exhibit A attached hereto and hereby made a part hereof (as it may be amended, restated, replaced or otherwise modified from time to time, the "Partnership Mortgage "). NOW THEREFORE, in consideration of the foregoing, for and in consideration of the sum of One Dollar ($1.00) and other good and valuable consideration, the receipt and sufficiency of which is hereby acknowledged, Borrower agrees as follows: 1. Collateral Assignment. Borrower hereby collaterally assigns and transfers to HRA, and grants a security interest in, all right, title and interest of Borrower in and to the Partnership Note and the Partnership Mortgage (collectively, the "Pledged Documents "), including all cash, proceeds, interest or other income or property, accrued and hereafter accruing, received, receivable or otherwise distributed in respect of, in exchange for or upon the sale or other disposition of the Pledged Documents, for the purpose of securing the Note. 2. Performance of Oblijzations. Borrower agrees to promptly, faithfully and diligently observe, perform and discharge each and every term, condition, obligation, covenant and agreement which Borrower is now, or hereafter becomes, liable to observe, perform or discharge under this Assignment and the Pledged Documents; to give prompt written notice to HRA of any notice of default received by Borrower under the Pledged Documents on the part of any party thereunder, together with an accurate and complete copy of any such notice; and, at the sole cost and expense of Borrower, to enforce or secure the performance of each and every obligation, covenant, condition and agreement to be performed by Partnership under any of the Pledged Documents. 3. Actions Arising out of the Pledged Documents. Borrower shall, at Borrower's sole cost and expense, appear in and defend any dispute, action or proceeding against Borrower or HRA arising under, growing out of or in any manner connected with or affecting any of the Pledged Documents, or the obligations, duties or liabilities of Borrower or Partnership thereunder, and shall pay all costs and expenses of HRA, including attorneys' fees (prior to trial, at trial and on appeal) in connection with any such dispute, action or proceeding in which HRA may appear or with respect to which it may otherwise incur costs or expenses, whether or not HRA prevails therein. 4. HRA's Right to Perform. Should Borrower fail to make any payment or to do any act as herein provided, then HRA may, but without obligation to do so, without notice or demand to or upon Borrower, and without releasing Borrower from any obligation hereof, make or do the same in such manner and to such extent as HRA may deem necessary or desirable to protect the security hereof, including specifically, without limiting its general powers, appearing in and defending any action or proceeding purporting to affect the security hereof or the rights or powers of HRA, and observing, performing and discharging all or any of the obligations, covenants and agreements of Borrower in the Pledged Documents. In exercising any such powers, HRA may pay its costs and expenses, employ counsel and incur and pay reasonable attorneys' fees (prior to trial, at trial and on appeal). Borrower hereby grants to HRA an irrevocable power of attorney, coupled with an interest, to perform all of the acts and things provided for in this section as Borrower's agent and in Borrower's name. 5. No Modification Without Consent. Each of Borrower and Partnership agrees not to modify, amend, extend, waive, subordinate or in any manner alter the terms of either of the Partnership Note or the Partnership Mortgage, or reduce the indebtedness secured thereby; not to waive, excuse or condone any default by the other party under either of the Partnership Note or the Partnership Mortgage; and not to in any manner release or discharge the other party of or from any obligation, covenant, condition or agreement by Partnership or Borrower, as applicable, to be performed under either of the Partnership Note or the Partnership Mortgage. Any attempt on the part of Borrower or Partnership to exercise any such right, power or authority without the prior written consent of HRA shall be a nullity and shall be a default hereunder. 6. Borrower's Representations, Warranties and Covenants. Borrower represents and warrants to HRA that: a. Borrower has good right and lawful authority to grant, transfer, set over and assign the Pledged Documents to HRA. b. This Assignment has been duly authorized, executed and delivered by and on behalf of Borrower so as to constitute the valid and binding obligations of Borrower, enforceable in accordance with the terms hereof. C. Borrower has not performed or committed any act or executed any instrument, and is not bound by any law, statute, regulation, order, pledge agreement, indenture, contract or agreement, which might prevent HRA from operating under any of the terms and conditions hereof, or which would limit HRA in such operation. d. Borrower has not executed or agreed to, shall not execute or agree to, and shall not permit to occur by operation of law any other assignment, alienation, pledge, encumbrance or transfer of any its of right, title or interest in, to or under any of the Pledged Documents. e. The Pledged Documents are in full force and effect; neither of the Pledged Documents has been amended or modified; and there is no default by Borrower nor by Partnership now existing under any of the Pledged Documents, nor has any event occurred which, with the passage of time and/or the giving of notice, would constitute a default thereunder. f. Borrower has delivered or will deliver to HRA fully executed originals of the Pledged Documents, and such documents have not been modified, amended or canceled. g. The Pledged Documents each constitute a valid, genuine and legally enforceable obligation, subject to no defense, set off or counterclaim of Partnership. In. The Partnership Mortgage has been duly executed and delivered, and will be recorded or otherwise properly perfected in Anoka County, Minnesota. i. The outstanding principal balance on the Partnership Note as of the date hereof of is $6,585,000. 7. Present Assignment. Subject to the terms and conditions set forth herein, this is a perfected, absolute and present assignment by Borrower to HRA of the Pledged Documents. During the pendency and effectiveness of this Assignment, Borrower shall have no authority to collect or receive, as and when due and payable or otherwise, any payments of principal, interest or other sums under the Partnership Note, and any and all such payments of principal, interest or other sums if and to the extent so received by Borrower shall be held in trust by Borrower for the benefit of HRA, and shall be promptly paid over and delivered by Borrower to HRA to be applied to the secured obligations. At any time after the occurrence and during the continuance of an Event of Default (as defined below), Borrower hereby authorizes and directs Partnership to pay amounts secured by the Partnership Mortgage directly to HRA in an amount up to the amount of the secured obligations. Failure of HRA to collect, or discontinuance by HRA from collecting, at any time, and from time to time, any amounts secured by the Partnership Mortgage shall not in any manner affect the rights of HRA to thereafter collect the same. Borrower hereby authorizes HRA to file UCC financing statements and amendments to financing statements with respect to the Pledged Documents consistent with the terms of this Agreement in such form and substance as HRA, in its sole discretion, may determine. 8. Events of Default. The occurrence of one or more of the following shall constitute an 'Event of Default" within the meaning of this Assignment, provided, however, that such event shall not be an Event of Default unless and until written notice of such failure shall have been given to Borrower and such failure shall not have been cured before expiration of (i) the period of thirty (30) days next following the giving of such notice or (ii) if cure cannot reasonably be effected within such thirty (30) day period, then such longer period as shall be reasonably needed to cure such event if Borrower timely commences cure and diligently prosecutes cure to completion: a. Borrower shall fail to abide or observe any term or condition of this Assignment, or any representation made by Borrower was materially false when made; b. an event of default shall occur under the Note, or any of the other related documents (together with the Note, the "HRA Loan Documents "), or Borrower shall otherwise fail to abide by the terms and conditions of any of the HRA Loan Documents; C. a petition commencing a proceeding under the United States Bankruptcy Code or any similar state law is filed by or against Borrower; or a receiver, custodian, assignee, or trustee is appointed for Borrower or any of their respective assets; or d. any third party seizes or pursues repossession, foreclosure, replevin or liquidation of any property of Borrower. 9. HRA Rights Upon Default. a. Upon or at any time after the occurrence of any Event of Default under this Assignment, HRA may, at its option, but without obligation to do so, and without notice to or consent of Borrower, sell, assign or transfer to itself or any third party purchaser all of Borrower's right, title and interest in, to and under the Pledged Documents subject to the terms and conditions hereof; make, execute, enforce, modify, alter, cancel, release or satisfy the Partnership Mortgage, in its own name or in the name of Borrower; and/or pursue all other remedies available at law or in equity, including all remedies available under the Uniform Commercial Code. Borrower shall in every way facilitate the transfer of its interests in, to and under the Partnership Mortgage and the proceeds of the Partnership Note, including without limitation executing and recording any and all additional instruments necessary to evidence the transfer of the Pledged Documents. Borrower hereby grants to HRA an irrevocable power of attorney, coupled with an interest, to perform all of the acts and things provided in this section as Borrower's agent and in Borrower's name. b. If any Event of Default shall occur, then HRA may, at its option, declare the secured obligations due and payable as set forth in the Note and other HRA Loan Documents, and, in addition to making available to HRA any remedies for default herein set forth, such Event of Default shall, at HR-A's option, constitute and be deemed to be an event of default under the Note and other HRA Loan Documents, entitling HRA to every and all rights and remedies therein contained, in addition to those rights and remedies herein set forth, without regard to the adequacy of security for the indebtedness secured hereby, the commission of waste or the insolvency of Borrower. 10. Release Upon Payment in Full. Upon the payment in full of the Note, this Assignment shall become and be void and of no further effect and, upon request of Borrower, HRA shall execute a release hereof or an assignment to Borrower of the Pledged Documents. 11. Construction According to Applicable Law. All rights, powers and remedies provided herein may be exercised only to the extent that the exercise thereof does not violate any applicable law, and they are intended to be limited to the extent necessary so that they will not render this Assignment invalid, unenforceable or not entitled to be recorded, registered or filed under any applicable law. If any term of this Assignment shall be held to be invalid, illegal or unenforceable, the validity, legality and enforceability of the other terms hereof shall be in no way affected thereby. HRA shall be entitled to all rights and remedies available under this Assignment, under the Note, under the other HRA Loan Documents, at law, in equity or under any statute in existence now and/or at the time of exercise thereof, even though such rights and remedies were not available on the date first above written, and all such rights and remedies may be exercised at any time and from time to time concurrently, separately, successively and in any order of preference, at HRA's sole discretion. 12. Successors and Assigns. The covenants and agreements herein contained shall bind, and the rights hereunder shall inure to, the respective successors and assigns of Borrower, Partnership and HRA. 13. Additional Security. HRA shall not be required to resort first to the security of this Assignment or of any of the other HRA Loan Documents before resorting to the security of the other, and HRA may exercise its rights hereunder, under this Assignment and any of the other HRA Loan Documents concurrently or independently and in any order of preference; all rights and remedies of HRA set forth herein, in the Note, any of the other HRA Loan Documents, at law, in equity, under statute and by contract being cumulative. No failure by HRA to avail itself of any of the terms, covenants or conditions of this Assignment for any period of time shall be deemed to constitute a waiver thereof. 14. Notices. Any notice or other communication to any party in connection herewith shall be deemed to have been given on the date the same is deposited in the United States mail, registered or certified, return receipt requested, postage prepaid, or deposited with Federal Express, Airborne or another reputable overnight carrier, addressed to the party to which the notice is to be given at the address specified below, or at such other address as such party shall have specified to the other party hereto in writing and not less than ten (10) days prior to the effective date of the address change: To Borrower: Aeon Attn: Eric Schnell, Chief Operating Officer 901 North Third Street, Suite 150 Minneapolis, MN 55401 With a copy to USBCDC: U.S. Bancorp Community Development Corporation Attn: Director of LIHTC Asset Management 1307 Washington Avenue, Suite 300 St. Louis, Missouri 63103 To HRA: Columbia Heights HRA Attn: Executive Director 590 40`x' Avenue Northeast Columbia Heights, Minnesota 55421 15. Governing Law; Waiver of Jury Trial. This Assignment, the rights of the parties hereunder and the interpretation hereof shall be governed by, and construed in accordance with, the laws of the State of Minnesota, in all respects. Any disputes related to this Assignment or any of the other Loan Documents shall be resolved in either Hennepin County, Minnesota or the United States District Court, District of Minnesota. THE PARTIES HEREBY WAIVE ANY RIGHT TO TRIAL BY JURY AND ANY RIGHT EACH MAY HAVE TO OBJECT TO PERSONAL JURISDICTION, ASSERT THE DOCTRINE OF FORUM NON CONVENIENS, OR OBJECT TO VENUE ON ANY BASIS WHATSOEVER IN ANY ACTION ARISING FROM OR RELATING TO THIS ASSIGNMENT. 16. Further Assurances. Borrower shall, at the request of HRA, at any time and from time to time following the execution of this Assignment promptly execute and deliver, or cause to be executed and delivered, to HRA all such further documents and instruments and take all such further action as may be reasonably necessary or appropriate to confirm or carry out the provisions and intent of this Assignment. 17. Headings. The headings or captions of the sections set forth herein are for convenience only, are not a part of this Assignment and are not to be considered in interpreting this Assignment. 18. Recitals Incorporated. The recitals to this Assignment are incorporated into and constitute an integral part of this Assignment. IN WITNESS WHEREOF, Borrower has caused this Assignment to be duly executed as of the day and year first above written. AEON M Its STATE OF MINNESOTA ) SS.- COUNTY OF ) The foregoing instrument was acknowledged before me this day of 2015, by I the of Aeon, a Minnesota nonprofit corporation, on behalf of the corporation. Notary Public ACKNOWLEDGMENT OF PARKVIEW LIMITED PARTNERSHIP Partnership hereby acknowledges, agrees with and consents to the foregoing Assignment and agrees to comply with the covenants of the Partnership set forth in Section 5 of the Assignment. Partnership represents and warrants to the Borrower and HRA that (a) this Assignment has been duly authorized, executed and delivered by and on behalf of Partnership so as to constitute the valid and binding agreement of the Partnership, enforceable in accordance with the terms hereof; (b) the Pledged Documents each constitute a valid, genuine and legally enforceable obligation of the Partnership, enforceable in accordance with its applicable terms; none of the Pledged Documents has been amended or modified; and, to its knowledge, there is no default by Borrower or by Partnership now existing under either of the Pledged Documents; and (c) the outstanding principal balance on the Partnership Note as of the date hereof of is $6,585,000. Partnership hereby acknowledges that HRA is relying upon the foregoing in connection with HRA entering into certain HRA Loan Documents with Borrower. Dated effective as of 2015. PARKVIEW LIMITED PARTNERSHIP, a Minnesota limited partnership By: Aeon, a Minnesota nonprofit corporation Its: General Partner By: Its: HRA Minutes Page 23 July 28, 2015 EXHIBIT A TO ASSIGNMENT Legal Description Tract A: That part of the South 1/2 of Lot 13, lying Northwesterly of the following line: Beginning at the Northeast corner of the South 1/2 of Lot 13; thence Southwesterly to a point on the South line of said Lot 13, said point being 2 feet Easterly of the Southwest Comers of Lot 13; the South 241 feet of Lot 14; then south 1/2 of Lot 15; Lot 39 except the West 30 feet thereof; Lots 40, 41, 42 and 43 and the West 1/2 of Lot 44, all in Block 5 Reservoir Hills, Columbia Heights, Anoka County, Minnesota (Abstract) Tract B: The East 40 feet of the South 1/2 of Lot 16, Block 5, Reservoir Hills, Columbia Heights, Anoka County, Minnesota. (Torrens) Tract C: To be added C -17 HRA Minutes Page 24 July 28, 2015 9. Report of Management Company Management has notified residents that the august rent checks should be made out to the City of Columbia Heights. They also have notified all contractors that their services will expire august 31, 2015. This meets the required 30 day notice. Frost also reported that the garden area has been cleaned up by the residents of the building and they did a nice job. 10. Resident Council Update No one was present to give a report. 11. Citizen Forum Edward Blue #411 asked if air conditioners will be provided by the new owners. He said it gets very hot for residents, especially on the upper floors. Frost told members that it is up to residents to obtain their own air conditioners. Tom, the maintenance person, does help service them but several have gone out this year. Residents were told to contact ACCAP to see if they qualify for help in obtaining a unit through energy assistance or emergency assistance programs they administer. The next regular HRA meeting will be October 27, 2015, and will be held at City Hall. This will be the last meeting held at Parkview Villa. The meeting was adjourned at 8:00 pm. Respectfully submitted, Shelley Hanson Secretary Parkview Villa North Financial Statement Overview July 2015 Revenue: Occupancy for the month of July 2015 was 100% occupied; Rent Revenue was under budget (unfavorable) Total Revenue for July was over budget (favorable) Grant Income was recieved Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Resident Bad Debt was over budget (unfavorable) and reflects the uncollectable accounts sent to collections agency Utilities: Utilities Expenses were over budget (unfavorable) Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects June billing Gas was under budget (favorable) and reflects June billing Water was over budget (unfavorable) and reflects a quarterly billing Sewer was over budget (unfavorable) and reflects a quarterly billing l Operatine and Maintenance Expense (supplies): Operating and Maintenance Expenses were over budget (unfavorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflects cost of contract cleaning Maintenance Supplies was under budget (favorable) Garbage and Trash was over budget (unfavorable) and reflects refuse charges, taxes and fees Grounds Contract was over budget (unfavorable) and reflects invoices from June and July for grounds pick up Repairs contract was under budget (favorable) Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs was under budget (favorable) Decorating Contract was under budget (favorable) G1 D W i j a 3 m —' �• m 9 m 3 N N Ol N O W O O! O N m N m 0 N b O N N N tp i tp m A o m o B g m mb' 3 m N '.. i rD 3 N= m J C O m m m G 310 N T N O N p N J 6 � W p A G A + to O C W V O O O 0 0 0 O O O S O S O o W N A O N W PON W (p 0 0 V cVp N A O ONO V W V V O N N O O ja �fp f0 O A O A 61 GI fp (P i Z S O O O N m 0 S S N V V A W 0 0 m W O O V S ONi W O A 'd N N N V O + O OJ W + + N Of qW SAO W O AW W fWlt N J tNT � W f1Jil f�D + J O O m OW1 OVO O 1Vp 11OT V V w o S O 0 0 W V D N N + V V W N Lm T P y + T N V tJ N N O A A t0 A m ro N O O O N pp V N A O tJ o O O O N O N O N N Sn >° T O C A A? O O G G S O 0 0 � 0 0 Co OD W O O O O O cc 'm D W i j a 3 m —' �• m 9 m 3 u ww w w dw� w ww mrnpp� p� w w 00 www w m wrn' a s ww N�OOW N V O VO OOOO A +00, < 13 n Ln m m m Cl) �o °m 2 m a 9 d MK d O) O v X ? J M J d d y d C m J d aD d D.Ji. d d C d d J 0 d d O mas ° 3 an d 3 _ d (A d O a d d N d FD- 0 J 6 d d X 'ap J fG 41 it 4 Q d 3 C O O m A O two A N lA.t O V O w A 4wi 00 A N tN0 0 () ow O O C O O O W A+ (p V V O O O N N w O O O V w O O m w A w A w N N N ip A IV W Cu V W N m N V+ w (O V fT V tp W W N + w O w w w w N C w O O lD w w A O A O A O to O w w O O N 6 Co A VJ O w c> Go + O N w + O A O W O C O O 0 O m V N W O w V V V V O w w V O N O W O O O O O ..� w W + + m A V V pp tNO tr A w m A N + O O + O V m• tT T A w N N tit W w O O N � IJ id w A O w a O Go + A ++ O w 0 Ot O W O V V w .m W _d W O G G {•� N O O w N w w N N b O N O N W O jaE O O tD N V w tD Z W O (D Z w Z 0 0 w N N O O O W IV V UI w C W C O (.J w O O 0 w O O A w+ V N W tD N N A N+ 0 V N G + <T <O w W N + 0 N O + A A 0 w f0 O V w w w V O w w c0 O N Ds W V V + w Ol w N N Gi O w N A + O O N N N W w O w N N W W O N O N w w (P O O O w O V w o w N w A w tD + w O O w N + 0 0 0 O w O w ppW QO O W V m tD pp A A O 0) A G W V !J w Im t+p w V W w w 0 q A V O A w w O O W w A w O f0 RJ w w W W w V C G1 td w O IV A W w+ O V O] + O O W O G O O A t0 A + O W tp N tD W O N td O A O+ O Coco ..r A tp w w 0 td A w 0 W 'd w tJ A w O w 0 V V tp w w A A N W O w (0 0 N «) V w W O+ O O N N N w N N W O tD + O A V T le n w W t0 V w tp w 0 O w tJ w O O w w N w W N pp w+ O O O O W O O O di W td OV! D D N m •T tJ ++ O •2 O W W W O w w m A N N m W N+ y IJ G V O In C I a 0 N + w G '0 W w O O 'm m N 00 O 00 g O O O N O 0 o w V N 0 0 0 O O N O J 0 0 O O 0 0 0 0 0 0 0 0 0 0 p S O O O O O O w O O N 0 0 m 0 O O A O Ip O O O O Im 3 to O o 0 o O O o 0 0 0 o O O o 0 0 o 0 0 0 0 v u Oi N W lJ t+. W P W O W V o r V V N + w A A OAo j Z N a D N OD + O fVT A too W tp W c0 W O W w O w r i N + W n A O i3 a n T 0 O S V V m y C G a O O O p � a O 0 0 N W W tV.f N O O O W WW O T A NI N W fT W m m O W W V C W w m O V W W +W IWJf d) W N O A V V m j O d 9 W d d d d a J o a R G W 9 o d d C O O no O od Od d O a A dd ?. o do F '_. 0Gy y c c c Q d d n y y d Om OR no O O C O (n (i mOm m.@ndo nm mR�N Oi ± O b k AI N A V W O O m 0 0 0 W 0 0 O O O W O O W AI O O O W 0 0 O O O O o O N CO O O O O O O O O W M o n O t0 + W Ot W O O W O W O A V O W O N A + N W N W d N O V V W O O W p fWD I N W n W W O OWi OWO N N N V O tJ O (O V O 0I al A O Ut W N W O W O N W O V V W W O W O m N N O d) m m pWo O t0 W W o w W t0 O Y N V � d mI Ow VI C nnOV nD n n0wnO dID O g'm0 -0 33 do 1 �� 3 W + N VAi OWO + W A W N W O 4l IV + y C r y y N y m 0 A V N <O o• r m d m � y fA O Oi N W lJ t+. W P W O W V o r V V N + w A A OAo j Z N a D N OD + O fVT A too W tp W c0 W O W w O w r i N + W n A O i3 a n T 0 O S V V m y C G a O O O p � a O 0 0 N W W tV.f N O O O W WW O T A NI N W fT W m m O W W V C W w m O V W W +W IWJf d) W N O A V V m j O d 9 W d d d d a J o a R G W 9 o d d C O O no O od Od d O a A dd ?. o do F '_. 0Gy y c c c Q d d n y y d Om OR no O O C O (n (i mOm m.@ndo nm mR�N Oi ± O b k AI N A V W O O m 0 0 0 W 0 0 O O O W O O W AI O O O W 0 0 O O O O o O N CO O O O O O O O O W M o n O t0 + W Ot W O O W O W O A V O W O N A + N W N W d N O V V W O O W p fWD I N W n W W O OWi OWO N N N V O tJ O (O V O 0I al A O Ut W N W O W O N W O V V W W O W O mI Ow VI WWI nnOV nD n n0wnO dID W + N VAi OWO + W A W N W O 4l IV + fJ W w N A m 0 A V N <O W A tT tO V tT W W. N O fT V W N 0 6� W W N V W W 0 w 0 O N W O w w O W W + A N OWO + N N N N W d) t0 N W W O N O N + n A O OWi A tV.l T 0 6 n + O m bo WO W+ cW0 tli O n A (Nl� O w ( OOi O O O N V W O OA1 O p� A N A W V W W+ V+ W Vi u f0 A W N A pW m N V A N O V OAO t00 t00 IWJ lWJ t0 N A A N O N A W w A O n a° W m W m dl A V W W O+ W 0 N O W W O P W iO A W fp G O + A o A o Mw a G Kw) W O tP V W A W O tD W N a0 V O+ W I� (OB�I + N N N + + V N W W V wA+ W W n n O O A O N N O n O O 00 fOT A A O O O W 00 O 0 0 0 W tNJ O w O O A IV.1 gy No d 8 O O O O n n n n n n n n n n n n n M, w C v C - m m m m V V V m m dD A O O O m w Qt w O tmp m N V W O W N pmo N V^ < — °— O i z + s3 o = > °m� am °mc m �� a� °��, o m0 m (n wZ wm mo y r w� m?1 H� X01 H� O m rJn� Ta J m m of m 3 O z y N m o 30 �a n w 3 y o Z m �-�^ C� 3 O m o y CO $,� v m �^ a 3 R v H N m m m N 3 m J J O fN N J O V p O O <n N O O 0 0 (Wji m O V m rn w O m Vii O O O O � ppj p m N LmA] < mLJ O V O O O O V V O O A 00 A O m w o D D Z D o m a A N N N N A m D V O O O O m O m m O O O O O O p m O) r N W O O m m O AO tW0 O O O tW0 t00 m S w m m k 6 A z z z z < A _ _ N W N N N N O A O UI O O O O N O J M, Parkview Villa -North Balance Sheet July 2015 Books = Accrual Assets 10100 Cash Balance 181,471.90 10200 Petty Cash _ 457.00 10400 Investments 898,424.28 11300 Rent Receivable 644.30 11500 Acounts Receivable 342.00 Total Assets 1,081,339.48 Liabilities 20200 Accounts Payable 17,157.15 20210 Accrued Other Expenses 11,130.09 20220 Due to Resident Council 551.74 22000 Deposits 19,582.95 22200 Accrued PILOT 11,841.34 22210 Revenue Collected in Advance 1,317.87 Total Liabilities 61,581.14 Fund Balance 25300 Fund Balance 1,019,758.34 Total Fund Balance 1,019,758.34 Total Liabilities and Fund Balance 1,081,339.48 8/11/201511:17 AM Parlonew Villa -North income Statement July 2015 Books = Accrual Other Services & Charges 3040 -46330 Legal Fees Month to Date % Year to Date % Revenue 0.00 0.00% 0.00 0.00% 33160 -46330 Federal Grant 29,519.50 50.75% 161,065.26 42.80% 36220 -46330 Gen. Government Rents 27,700.00 47.63% 208,133.36 55.30% 36225 -46330 Nondwelling Rents 374.00 0.64% 2,414.00 0.64% 36290 -46330 Other Miscellaneous Revenue 568.00 0.98% 4,326.27 1.15% 39120 -46330 Recovery Damage City Property - 0.00% 405.00 0.11% Total Revenue 58,161.50 100.00% 376,343.89 100.00% Expenses 2,072.17 3.56% 3,862.01 1.03% personal Services 544.69 0.94% 21,572.39 5.73% 1000 -46330 Accrued Salaries 8,929.00 15.35% 62,503.00 16.61% Total Personal Services 8,929.00 15.350/a 62,503.00 16.61% Supplies 9,894.77 17.01% - 61,796.67 16.42% 2000 -46330 Office Supplies 79.60 0.14% 624.66 0.17% 2010 -46330 Minor Equipment 0.00 0.00% 931.89 0.25% 2160 -46330 Maint. & Construct Materials 0.00 0.00% 4,517.03 1.20% 2171 -46330 General Supplies 194.43 0.33% 2,529.19 0.67% Total Supplies 274.03 0.47% 8,602.77 0.34% Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 0.00 0.00% 305096330 Expert and Professional Services 0.00 0.00% 0.00 0.00% 306096330 Management Services 4,866.00 8.37% 34,062.00 9.05% 310096330 Protective Services 0.00 0.00% 11,991.18 3.19% 321096330 Telephone &Telegraph 283.73 0.49% 2,211.51 0.59% 343096330 Advertising Other 0.00 0.00% 0.00 0.00% 360096330 Insurance & Bonds 1,588.81 2.73% 11,128.75 2.96% 381096330 Electric 5,343.57 9.19% 29,655.28 7.88% 3820 -46330 Water 2,072.17 3.56% 3,862.01 1.03% 383096330 Gas 544.69 0.94% 21,572.39 5.73% 384096330 Refuse 4,089.20 7.03% 5,818.19 1.55% 385096330 Sewer 1,089.91 1.87% 2,106.56 0.56% 4000 -46330 Repair & Maint. Services 9,894.77 17.01% - 61,796.67 16.42% 4050 -46330 Garage, Labor 0.00 0.00% 0.00 0.00% 410096330 Rents & Leases 0.00 0.00% 1,426.75 0.38% 430096330 Miscellaneous Charges 0.00 0.00% 599.38 0.16% 4315 -46330 PILOT 1,730.56 2.98% 12,113.92 3.22% 439046330 Taxes & Licenses 0.00 0.00% 1,267.53 0.34% 4500 -46330 Administrative Expenses 114.12 0.20% 1,425.85 0.38% 485096330 Interest on Deposits 15.35 0.03% 102.36 0.03% Total Other Services & Charges 31,632.88 54.39% 201,140.33 53.45% Page 3 of 10 a 8/111201511:17 AM Capital Outlay 5120-46330 Building & Improvements 0.00 0.00% - 0.00 Total Capital Outlay 0.00 0.00% 0.00 0.00% Toni Expense 40,835.91 70.21% 272,246.10 72.34% Excess (Deficit) Revenue over Expense 17,325.59 29.79% 104,097.79 27.66% Page 4 of 10 IN 8/11/2015 11:17 AM Cash Flow Statement Month to Date Revenue 33160 Federal Grant 29,519.50 36220 Gen. Government Rents 27,700.00 36225 Nondwelling Rents 374.00 36290 Other Miscellaneous Revenue 568.00 39120 Recovery Damage City Property 0.00 Total Revenue 58,161.50 Expenses Personnel Services 1000 Accrued Salaries 8,929.00 Total Personnel Services 8,929.00 Supplies 2000 ice Supplies 79.60 2010 Minor Equipment 0,00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 194.43 Total Supplies 274,03 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services 0.00 3060 Management Services 4,866.00 3100 Protective Services - 0.00 3210 Telephone & Telegraph 283.73 3430 Advertising Other 0.00 3600 Insurance & Bonds 1,588.81 3810 Electric 5,343.57 3820 Water 2,072.17 3830 Gas 544.69 3840 Refuse 4,089.20 3850 Sewer 1,089.91 4000 Repair & Maim. Services 9,894.77 4050 Garage, Labor Burd. 0.00 4100 Rent & Leases 0.00 4300 Miscellaneous Charges 0.00 4315 PILOT 1,730.56 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 114.12 4850 Interest on Deposits 15.35 5120 Building & Improvement 0.00 Total Other Services & Charges 31,632.88 Total Expenses 40,835.91 Excess (Deficit) Revenue over Expenses 17,325.59 Page 5 of 10 ID Parkvimv Villa -North (165; Cash Flow Statement Period - July 2015 Book _ Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 8/11/2015 11:17 AM Month to Date 0.00 0.00 2,161.62 -31.00 0.00 0.00 0.00 1,960.65 1,590.15 0.00 15.35 1,730.56 273.50 7,700.83 25,026.42 Cash End Cash Difference 10100 Cash Balance 156,445.48 181,471.90 25,026.42 10200 Petty Cash 457.00 457.00 - 10400 Investments 898,424.28 898,424.28 - Total Cash 1,055,326.76 1,080,353.18 25,026.42 Page 6 of 10 Parkview Villa -North (165) General Ledger Period = Jul 2015 Book Accrual; Tree = ysi_tb Proper Date Person/ Description ReferenceF>eF >a�b�# 1000 -46330 Accrued Salaries 165 7/31/2015 :PostRecurring Monthly recurrirRC 8,929.00 Net Change= 8,929.00 2000 -46330 Office Supplies 165 6/29/2015 HD Supply Facilities Maintenam9138507088 165 7/21/2015 Common Bond Housing (chc) 072115compsupp Net Change =79.60 2010 -46330 Minor Equipment Net Change =0.00 2160 -46330 Maint. & Construct Materials Net Change =0.00 2171 -46330 General Supplies 165 7/17/2015 Buckeye Cleaning Centers(buc902640 165 7/21/2015 HD Supply Facilities Maintenanc9139029913 Net Change= 194.43 42.93 36.67 86.27 108.16 Credit Balance Remarks 53,574.00 = Beginning Balance = 0.00 62,503.00 R/C CHC PR Mgmt Fee 62,503.00 = Ending Balance = 545.06 = Beginning Balance = 0.00 587.99 magnet clip 0.00 624.66 computer support 06/25- 07/21, 624.66 = Ending Balance = 931.89 = Beginning Balance = 931.89 = Ending Balance = 4,517.03 = Beginning Balance = 4,517.03 = Ending Balance = 2,334.76 = Beginning Balance = 0.00 2,421.03 roll towel 0.00 2,529.19 TP /twls /cleaners 2,529.19 = Ending Balance = 3060 -46330 Management Services 165 7/2/2015 Ahmann -Martin Company (ahm132758sites 0.00 165 7/31/2015 165 7/30/2015 Common Bond Housing (chc) 073015mgmt 13,795.00 3810 -46330 0.00 165 7/31/2015 : PostRecu rring Monthly recurrirRC 0.00 Net Change = 5,343.57 8,929.00 Net Change= 4,866.00 3100 -46330 Protective Services Net Change =0.00 3210 -46330 Telephone & Telegraph 165 6/30/2015 Popp.com (popp) 992273322 222.44 0.00 165 7/212015 Comcast(c6mc3517) 877210505019618 61.29 0.00 Net Change= 283.73 3600 -46330 Insurance & Bonds 165 7/2/2015 Ahmann -Martin Company (ahm132758sites 0.00 165 7/31/2015 :PostRecurring Monthly recurrh RC 1,590.15 Net Change= 1,588.81 3810 -46330 Electric 165 7/13/2015 Xcel Energy (xcel) 5150441553 07/1_ 5,343.57 Net Change = 5,343.57 3820 -46330 Water 165 7/10/2015 City of Columbia Heights (colu) 31802500001 07/1 1,914.12 165 7/10/2015 City of Columbia Heights (colu) 31802500001 07/1 132.18 165 7/16/2015 City of Columbia Heights (colu) 31802450001 07/1 25.87 Net Change= 2,072.17 3830 -46330 Gas 165 7/9/2015 CenterPoint Energy (cent) 55199657 07/09/1 544.69 Net Change= 544.69 3840 -46330 Refuse 165 7/16/2015 City of Columbia Heights (colu) 31802450001 07/1 3,898.28 165 7/16/2015 City of Columbia Heights (colu) 31802450001 07/1 190.92 Net Change = 4,089.20 3850 -46330 Sewer 29,196.00 = Beginning Balance = 42,991.00 mgmt fee 07/15 34,062.00 R/C CHC PR Mgmt Fee 34,062.00 = Ending Balance = 11,991.18 = Beginning Balance = 11,991.18 = Ending Balance = 1,927.78 = Beginning Balance = 2,150.22 phone /net- 06/01- 06/30/15 2,211.51 net - 07/11- 08/10/15 2,211.51 = Ending Balance = 9,539.94 = Beginning Balance = 1.34 9,538.60 benefits consulting 07/15 0.00 11,128.75 C of Columbia Heights Ins Accrl 11,128.75 = Ending Balance = 24,311.71 = Beginning Balance = 0.00 29,655.28 E- 06/06- 07/07/15 29,655.28 = Ending Balance = 1,789.84 = Beginning Balance = 0.00 3,703.96 w 3/27 - 6/29/15 0.00 3,836.14 late fee 0.00 3,862.01 w 3/27 - 6/29/15 3,862.01 = Ending Balance = 21,027.70 = Beginning Balance = 0.00 21,572.39 G- 06/05- 07/07/15 21,572.39 = Ending Balance = 1,728.99 = Beginning Balance = 0.00 5,627.27 refuse 3/27- 6/29/15 0.00 5,818.19 late fee 5,818.19 = Ending Balance = 1,016.65 = Beginning Balance = 165 7/10/2015 City of Columbia Heights (colu) 31802500001 07/1 952.92 0.00 1,969.57 s 3/27 - 6/29/15 165 7/16/2015 City of Columbia Heights (colu) 31802450001 07/1 136.99 0100 2,106.56 s 3/27- 6/29/15 Net Change= 1,089.91 2,106.56 = Ending Balance = 4000 -46330 Repair & Maint. Services 51,901.90 = Beginning Balance = 165 1/29/2015 Direct Home Appliance Service! 12915165166 130.41 0.00 52,032.31 laundry appliance repair 165 6/12/2015 Drain King, Inc.(drai7740) 96211 454.71 0.00 52,487.02 cable /jet line- 06/15/15 165 6/19/2015 Integrity Cleaning Solutions (in 61920153 935.34 0.00 53,422.36 land care 165 6/19/2015 Drain King, Inc.(drai7740) 95775 233.22 0.00 53,655.58 drain line clear - 06/18/15 165 6/25/2015 K O Cleaning and Remodeling, 3456 51.75 0.00 53,707.33 crack repair 165 6/25/2015 K O Cleaning and Remodeling, 3457 621.00 0.00 54,328.33 paint/finish /replace sheet rock 165 6/25/2015 K O Cleaning and Remodeling, 3455 172.50 0.00 54,500.83 painting 165 6/26/2015 Integrity Cleaning Solutions (in 6262015 574.85 0.00 55,075.68 caretaking- 06/23- 06/26/15 165 6/26/2015 Integrity Cleaning Solutions (in 62620152 222.53 0.00 55,298.21 groundskeeping- 06/23 - 06/26/1 165 7/1/2015 Integrity Cleaning Solutions (in 70120151 203.98 0.00 55,502.19 cleaning 165 7/1/2015 Integrity Cleaning Solutions (in 70120152 218.81 0.00 55,721.00 cleaning 165 7/3/2015 Integrity Cleaning Solutions (in 70320152 611.94 0.00 56,332.94 caretaking- 06/29- 07/03/15 165 7/3/2015 Integrity Cleaning Solutions (in 7032015 222.53 0.00 56,555.47 groundskeeping - 06/29- 07/03/1 165 7/10/2015 Integrity Cleaning Solutions (in 71020151 574.86 0.00 57,130.33 caretaking- 07/06- 07/10/15 165 7/10/2015 Integrity Cleaning Solutions (in 710201518 222.53 0.00 57,352.86 groundskeeping- 07/06 - 07/10/1 165 7/14/2015 Integrity Cleaning Solutions (in 71420151 185.27 0.00 57,538.13 cleaning 165 7/14/2015 Integrity Cleaning Solutions (in 71420152 185.27 0.00 57,723.40 cleaning 165 7/17/2015 Integrity Cleaning Solutions (in 7172015 574.86 0.00 58,298.26 caretaking- 07/13- 07/19/15 165 7/1712015 Integrity Cleaning Solutions (in 71720152 222.53 0.00 58,520.79 groundskeeping- 07/13- 07/17/1 165 7/23/2015 Integrity Cleaning Solutions (in 7232015 2,181.78 0.00 60,702.57 misc grounds svcs -69 % 165 7/24/2015 Integrity Cleaning Solutions (in 72420153 259.62 0.00 60,962.19 cleaning *801 165 7/24/2015 Integrity Cleaning Solutions (in 72420151 574.86 0.00 61,537.05 caretaking-69% 7/20- 24/2015 165 7/24/2015 Integrity Cleaning Solutions (in 72420152 259.62 0.00 61,796.67 groundskeeping 07/20- 07/24/1 Net Change = 9,894.77 61,796.67 = Ending Balance = 4100 -46330 Rents & Leases 1,426.75 = Beginning Balance = Net Change =0.00 1,426.75 = Ending Balance = 4300 -46330 Miscellaneous Charges 599.38 = Beginning Balance = Net Change =0.00 599.38 = Ending Balance = 4315 -46330 PILOT 10,383.36 = Beginning Balance = 165 7/31/2015 :PostRecurring Monthly recurrirRC 1,730.56 0.00 12,113.92 Anoka Cty Property Tax Accrual Net Change= 1,730.56 12,113.92 = Ending Balance = 4390 -46330 Taxes & Licenses 1,267.53 = Beginning Balance = Net Change =0.00 1,267.53 = Ending Balance = 4500 -46330 Administrative Expenses 1,311.73 = Beginning Balance = 165 7/9/2015 Ronning (1:0013612) 114.12 0.00 1,425.85 Past tenant balance due Net Change= 114.12 1,425.85 = Ending Balance = 4850 -46330 Interest on Deposits 87.01 = Beginning Balance = 165 7/31/2015 Sec dep interest accrual G31 15.35 0.00 102.36 Sec dep interest accrual Net Change =15.35 102.36 = Ending Balance = 49.766.25 8,930.34 03 5016456 Parkview Villa North Bank Reconciliation Report 07/31/2015 Balance Per Bank Statement as of 07/31/2015 02/04/2014 2327 t0008445- Schuster 06117/2014 2446 t0013260 - Vig 08/19/2014 2488 10004040 -Camp 01/1412015 2634 cent2000 - Central Lock 8 Safe 06/24/2015 2809 t0010795 - Ruiz 06/25/2015 2812 t0009235 - Colon 06/25/2015 2814 t0009778 - LaMonica 07/29/2015 2827 cent- CenterPoint Energy 07129/2015 2828 chc - Common Bond Housing 07/29/2015 2829 colu - City of Columbia Heights 07129/2015 2830 home7 - HD Supply Facilities Maintenance, Ltd. 07/29/2015 2831 inte929 - Integrity Cleaning Solutions 0712912015 2832 xcel - Xcel Energy Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 07/31/2015 Difference Cleared Items: Cleared Checks Date Tran # 06124/2015 2804 06/24/2015 2805 06/24/2015 2808 06/25/2015 2811 06125/2015 2813 07101/2015 2815 07/0112015 2816 07/08/2015 2817 07/08/2015 2818 07/08/2015 2819 07115/2015 2820 07/15/2015 2821 Reconciled Balance Per G/L $197,981.20 419.94 0.65 276.52 125.00 194.84 29.00 215.00 544.69 35.33 7,251.28 108.16 1,965.32 5,343.57 $16,509.30 $181,471.90 8/3/15 $181,471.90 $181,471.90 Notes Amount Date Cleared adam - Adam's Pest Control, Inc. 51.91 07/31/2015 cent - CenterPoint Energy 1,174.40 07/31/2015 Ibpm - LBP Mechanical, Inc 295.84 07/31/2015 t0005163- Holmberg 100.00 0713112015 t0009593 - Hembroff 114.00 07131/2015 home7 - HD Supply Facilities Maintenance, Ltd. 295.69 07/3112015 inte929 - Integrity Cleaning Solutions 764.60 07/31/2015 chc - CommonBond Housing 13,816.20 07/3112015 home7 - HD Supply Facilities Maintenance, Ltd. 99.37 07/31/2015 sher4110- Sherwin-Williams Co. 220.64 07/31/2015 dire - Direct Home Appliance Services 130.41 07/31/2015 drai7740 - Drain King, Inc. 687.93 07/3112015 ) Lt BE 5016456 07/15/2015 07/22/2015 07/22/2015 07/22/2015 07/22/2015 Total Cleared Deposits Parkview Villa North Bank Reconciliation Report 07/31/2015 2822 home7 - HD Supply Facilities Maintenance, Ltd. 42.93 2823 comc3517 - Comcast 61.29 2824 inte929 - Integrity Cleaning Solutions 2,989.98 2825 koc17025- K O Cleaning and Remodeling, Inc. 845.25 2826 Popp - Popp.com 222.44 Date Tran # 07/0112015 741 07107/2015 742 07107/2015 743 07/07/2015 744 07/10/2015 747 07110/2015 748 07/20/2015 749 Total Cleared Other Items Date Tran # 07106/2015 JE 237827 07/07/2015 JE 239316 07/10/2015 JE 239238 07/10/2015 JE 239617 Total $21,912.88 07/31/2015 07/31/2015 07/31/2015 07/31/2015 07/31/2015 Notes Amount Date Cleared 9,282.00 07/31/2015 9,370.00 07/31/2015 1,371.00 07/31/2015 8,962.00 07/31/2015 1,186.00 07/31/2015 115.00 07/31/2015 646.00 07/31/2015 $30,932.00 Notes Amount Date Cleared ELoccs - Operating Fund Grant 17,490.50 0713112015 ELoocs- Operating Fund Grant 12,029.00 07/3112015 07/10/2015 Payroll 178.63 07/31/2015 07110/2015 Payroll - 178.63 07/31/2015 $29,519.50 8/3/15 1C_-- [J HRA OF COLUMBIA HEIGHTS Date 7/31/15 PARKVIEW VILLA NORTH Primary Account C/O COMMONBOND COMMUNITIES Enclosures 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 DID YOU KNOW THAT YOU CAN DO YOUR BANKING ON THE GO? USING YOUR MOBILE PHONE,PERSONAL DIGITAL ASSISTANT, OR TABLET IS SAFE AND CONVENIENT. SPEAK WITH YOUR PERSONAL-BANKER TODAY TO GET STARTED WITH MOBILE BANKING! MEMBER FDIC NORTHEAST PUBLIC FUNDS Account Number Previous Balance 10 Deposits /Credits 17 Checks /Debits 1 Electronic Debit Service Charge Interest Paid Ending Balance ACCT @XXXXX @6456 159,442.58 61,089.50 21,912.88 638.00 .00 .00 197,981.20 Page 1 @XXXXX @6456 25 Number of Images 25 Statement Dates 7/01/15 thru 7/31/15 Days in the Statement Period 31 Average Ledger 198,172 Average Collected 197,111 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Deposits and Credits Date Description Amount 7/01 DDA REGULAR DEPOSIT 9,282.00 7/06 MISC PAY HUD TREAS 310 17,490.50 CR 9101036151 07/06/15 ID #-411269646860103 TRACE #- 101036150642216 7/07 DDA REGULAR DEPOSIT 1,371.00 7/07 DDA REGULAR DEPOSIT 8,962.00 7/07 DDA REGULAR DEPOSIT 9,370.00 7/09 MISC PAY HUD TREAS 310 12,029.00 CR 9101036151 07/09/15 ID #- 411269646860103 TRACE #- 101036151038120 7/10 DDA REGULAR DEPOSIT 115.00 7/10 DDA REGULAR DEPOSIT 638.00 7/10 DDA REGULAR DEPOSIT 1,186.00 7/20 DDA REGULAR DEPOSIT 646.00 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Charges and Debits Date Description 7/17 Xfer to PUB FUND 0002 Amount 638.00 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx l Date 7/31/15 Page 2 Primary Account @XXXXX @6456 Enclosures 25 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 7/01 2804 51.91 7/21 2819 220.64 7/02 2805 1,174.40 7/29 2820 130.41 7/01 2808* 295.84 7/22 2821 687.93 7/08 2811* 100.00 7/22 2822 42.93 7/03 2813* 114.00 7/31 2823 61.29 7/08 2815* 295.69 7/28 2824 2,989.98 7/09 2816 764.60 7/29 2825 845.25 7/14 2817 13,816.20 7/29 2826 222.44 7/17 2818 99.37 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 7/01 168,376.83 7/09 215,150.64 7/22 202,230.57 7/02 167,202.43 7/10 217,089.64 7/28 199,240.59 7/03 167,088.43 7/14 203,273.44 7/29 198,042.49 7/06 184,578.93 7/17 202,536.07 7/31 197,981.20 7/07 204,281.93 7/20 203,182.07 7/08 203,886.24 7/21 202,961.43 * * * E N D O F S T A T E M E N T I Parkview Villa North Payment Summary Jul -15 35,425.08 Check Bank Check# Vendor Date Amount 165opr - Parkview Villa North 2815 home7 - HD Supply Facilities Maintenance, Ltd. 07/01/2015 295.69 165opr - Parkview Villa North 2816 Inte929 - Integrity Cleaning Solutions 07/01/2015 764.6 165opr - Parkview Villa North 2817 chc - Commonl3ond Housing 07/08/2015 13,816.20 165opr - Parkview Villa North 2818 home7 - HD Supply Facilities Maintenance, Ltd. 07/08/2015 99.37 165opr - Parkview Villa North 2819 sher4110 - Sherwin- Williams Co. 07/08/2015 220.64 165opr - Parkview Villa North 2820 dire - Direct Home Appliance Services 07/15/2015 130.41 165opr - Parkview Villa North 2821 drai7740 - Drain King, Inc. 07/15/2015 687.93 165opr - Parkview Villa North 2822 home7 - HD Supply Facilities Maintenance, Ltd. 07/15/2015 42.93 165opr - Parkview Villa North 2823 comc3517 - Comcast 07/22/2015 61.29 165opr - Parkview Villa North 2824 Inte929 - Integrity Cleaning Solutions 07/22/2015 2,989.98 165opr - Parkview Villa North 2825 koc17025 - K O Cleaning and Remodeling, Inc. 07/22/2015 845.25 165opr - Parkview Villa North 2826 Popp - Popp.com 07/22/2015 222.44 165opr - Parkview Villa North 2827 cent - CenterPoint Energy 07/29/2015 544.69 165opr - Parkview Villa North 2828 chc - Commonl3ond Housing 07/29/2015 35.33 165opr - Parkview Villa North 2829 colu - City of Columbia Heights 07/29/2015 7,251.28 165opr - Parkview Villa North 2830 home7 - HD Supply Facilities Maintenance, Ltd. 07/29/2015 108.16 165opr - Parkview Villa North 2831 inte929 - Integrity Cleaning Solutions 07/29/2015 1,965.32 165opr - Parkview Villa North 2832 xcel - Xcel Energy 07/29/2015 5,343.57 35,425.08 Parkview Villa North Financial Statement Overview August 2015 Revenue: Occupancy for the month of August 2015 was 100% occupied; Rent Revenue was over budget (favorable) reflects collections from July Total Revenue for August was under budget (unfavorable) No Grant Income was received Administrative Expenses: Administrative costs for the North were slightly over budget (unfavorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Computer Equipment. Software, Supplies was over budget (unfavorable) and reflects cost of computer support needed for system Resident Bad Debt was over budget (unfavorable) and reflects the uncollectable accounts sent to collections agency Misc.Admin Expense was over budget (unfavorable) and reflects cost of new coffeemaker purchased for community room Utilities: Utilities Expenses were under budget (favorable) Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects July billing Gas was under budget (favorable) and reflects June billing Water and Sewer were under budget (favorable) and reflects a quarterly billing 1/ Sewer was over budget (unfavorable) and reflects a quarterly billing Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflects cost of contract cleaning Maintenance Supplies was under budget (favorable) Garbage and Trash was over budget (unfavorable) and reflects refuse charges, taxes and fees Grounds Contract was over budget (unfavorable) and reflects invoices from July and August for grounds pick up Repairs contract was under budget (favorable) Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs was under budget (favorable) Decorating Contract was under budget (favorable) ;'v W W ME W W W m N W W W E T N m o m W N N o V V T o 0 N O O O w W V N O O + O+ W V O O N O O 0 m Q z W D 3 W N, N N = � O m � O O O O N O O .0 O N O (T O O O O O O O O O O O O O SS A O O 0 0 b b O O A O O O O O O p O O A O O O O Q O O O n 0 1 O m n m m f a CL c v m a D r < 2 . n m k .0 0 v m „ N 421( o m o m A s S m m m �< rn 8 a7 > m 3 m rs ? m� A d6 T 3 m? 'm ? m m a m n o 3 < c b M m H g < w< m m w 3 m < QO 3 8 m 0 �' m m o m m ^ w w w w V A W V O V N W O O O p W W W V (OD A N G C O G O O C G O 0 O 0 0 0 O O O O O co O W N N N W m W W tD tp W + W W V V A N A W A� N A O N N A W w O O � W W W U U V fVD N A O � V tWJ V V O bl dJ W fD N W VV Co WW N N W A WV A A (fN�n m 1.N N a 0 m V W W fwif V O V A w Z O O O N W O m OD W W +� N N N two N IV V N W A O C C V N A O lVJ (AT � UOi N w w m N W N N N W A A V V w V l0 IV w G) W W W lJ w" rn o u m m o o w too t0 fp � rD (T fn tJ O (J Of G1 G C 4t G1 V V N O V A N O O W W m W N VW N O N W D fVlf O 0 m V O W W A N NN O J W O O N N ptD N m AW O O O O O O O O O n 0 1 O m n m m f a CL c v m a D r < 2 . n m k .0 0 v m „ N 421( a CL (rnT U N N idT ppp� A A A A .rn4 A pp� W trnJ W W W W tWJ W w w W F N+ O O J W p fJ tD W W rn rn N O W N+ 0 0 W O N 4D V f0 O rn V V O rn 0 A N 0 0 0 0 rn_ A + O O H D (D R? < 2 ° a " -0 o z '• 3 qC O II m (D 0 �W 9m SO a 0i c Z 3 d H d J� C g m O N BC 6C m CQ KdJ� 0 G) W O ? 2. 2 N n p5 NC(D �. jN 3A nNNN v N6f0jO(�Ojd m m O , n C W ^ y. = m » q m p 0 O g O' �C N q y N 6 m N j D (p N» $$ q m X 9 J m N 6 % n m Q q O 3 C � F q o D » J q � J q N � m q q rn O� A W p OW W W rn V 444111 O O O O rn N W W O O rn mw n J W W O tO fD m j IJ O w C m O <T C m V O O O O A O O O m V tD N V O w O w O w m V O N O O O ro O) O O jp W O O V p m rn rn A 0 AAA O A O rn O W rn O O N W 6 4f O O O O G m V N W O W V J V V O N w V O N O W O O O O O L.w i N W N Im rn A OO�� A W tO W N N O O W W V N V to 0 <ON f0 W IJ rn V 0 41 N + V P O m O A N O G,$ O W W W + V W V+ O W N 00 O O W O W A 0 0 W W V W N O f0 O GO W W V V V O O O W Z N V .L W Z O V A W O O rn O IV O V O O O tO V 0 0 W N N A W O W O+ D W rn D OI D O O rn W N 0 Im � O O A,N W O V rn �D .A. + W 9) V W W rn W N V O rn V V W rn O O W N W N W O tD W m fJN (T V G+ O V IJ W W (Jf O O C W IJ C V O +' V lJ O W W w W O S m + O mw A O O O d W W P w W O W O W W W w O W W W W w O V A rn W + w O W W O O) W O O W O fJ fJ WW m O AO A <J w 41 w O rnWrnrnO O O W w O W O W O o 0 0 0 m a rno rnoao 0000,.. N A mp+ N W m+ w N S V t0 N tli V T S yy mp a N'n Orni N p W A V W f0 W N tJ m C N m IJ W W O m O i0 V W W W W O W t!1 O O fO V W W O A D W W O W p OI W W N rn W V W O O O (J tp O O Z N 111 N N O O T P N a tJl IJ O �l O (T ,O IJ O N + W O fly W rn O O N O A rn 0 W O O O W O W V N O O b O O N O h 9 O 60 N O O N O 6 O 6 O O A O OI O O 0 O Im ¢ m mm m W m m o m W m m m m m m mm m M M M M M m- g m �Vp J V V W m m p W m W N m p mppp N N mm K (AO� N N N N D Ol ONi O W W t0 o w N V O A m 0 fAp pAO A tAT N V m m m '> < gfn c>i�c B�O�v�c m� o'O> > > v+ y v mm -j ag v w �� > w = 8 8 00� CO =m o<Uo a o n m o m r 3 wm m go ;0 o A - m l m . m R o n » O v m w° `n � m P> n m o � o C d _ _OO v N N N Q P O UI O O O O 99 W m O w .0 .0 O n N o N W O m m N 0 0 0 0 O O N O O m O w O m N N OO m O A A N + C tT WW N A co A � IJ Cu N W N m N m m W O V N O+ m t0 N N+ N m e m O m O m W V W N W O O W O m W O N N [L W O D7 O W 41 CI W O V O V G V W N V O W O N N O V V W O O W O V J fn fO N V � V N O+ N N N N+ aO m'�• >W O W yO V N ml N W O O W O N W W W N N O1 O m A V V V W O w O N (Vl� O N V ONO tWD O (WT O Z m m A N O O O O O Z O N O+ O N O G iNil D w N O w OWl o 0 o o O D A 0 o m o N 0 N N W O +W m A mA A tND w N A A V m V A A D OD fp0 N+ O W O m V W W v7 O W m ,O{. O� A O w� (tml�l A m tW0 w O o N lmt O W N O W tc lmj 41 W G lJ � W f0 m C N A W+ fJ tJ W G+ W A m W W O W m O W O N O m N O W W W O O N m C W O W O W W N W O m 0 W O O W W W O O mN W 6 m O m O m A O m O A O m O O m m A o o A o 4O W W W mWm O m O W A yVy O O+ G1 4t ! m fgWqT + OW1 m fJ N U m O A N N O m A T p w o m O ppm A w fWD V m VVi OmO N 0 V A O pAO V T+ N o N w 68 O O A N A O+ tN0 O m A 0 m N'� N Z IJ WW N Fc A N + O V m O U A O W O m !� W D A W A W W A O N m 0 O mI O O W w 40 0 W T P d+ •2 V V V N N m V W A N N W A N m+ A m ° 0 0 0 0 o qOq pW O A O N N O o N m NO N lNJ W 15 N O O O O o o A A O O O N N O O o W 6 0 A N'C °o °o $ °o o °o °o °o co o °o o °o °o °o o ',m m W Co O 0 f0 m V J V V V T W O) x a (O O tOO m N V m O w N N V D ^' < - 'o z z- 3 m% z m �_ c A mo m 9 T mg v�` m v -� mo m y mm m o r .0 Vim, m m0 HT 0, H9 O mJ ? c TN mT w a 30 3a w z m ?: m m y j m in� m m0 J mm n C m O d_ O pe m J T T o m N N N N m W O W V V V V V f0 W O A m O O O O m m G m) N tD O O O O tNp � m J 0 O N O O o V V O O O O m m C Off! O m W W � N O N N N N m m O V V V V V O W m Y] p O V V V V V ? d 0 V N O � O O O O rn O Ol {pmp m W N N N N N O A o vt o 0 0 o ut o J m Parkview Villa -North Balance Sheet August 2015 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Acounts Receivable 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 184,676.10 457.00 898,424.28 2,066.60 56.00 1,085,679.98 17,095.74 12,720.24 551.74 19,598.22 13,571.90 999.87 64,537.71 1,021,142.27 1,021,142.27 1,085,679.98 iI 9111/2015 10:41 AM Parkview Villa -North Income Statement August 2015 Books = Accrual Supplies 2000 -46330 Office Supplies Month to Date % Year to Data % Revenue 0.00 0.00% 931.89 0.23% 33160 -46330 Federal Grant - 0.00% 161,065.26 39.45% 36220 -46330 Gen. Government Rents 31,092.00 97.34% 239,225.36 58.59% 36225 -46330 Nondmiling Rents 374.00 1.17% 2,788.00 0.68% 36290 -46330 Other Miscellaneous Revenue 477.00 1.49% 4,803.27 1.18% 39120 -46330 Recovery Damage City Property - 0.00% 405.00 0.10% Total Revenue 31,943.00 100.00% 408,286.89 100.00% Expenses 0.00 0100% 3,862.01 0.95% personal Services 401.39 1.26% 21,973.78 5.38% 1000-46330 Accrued Salaries 8,929.00 27.95% 71,432.00 17.50% Total Personal Services 8,929.00 27.95% 71,432.00 17.50% Supplies 2000 -46330 Office Supplies 400.54 1.25% 1,025.20 0.2S% 2010 -46330 Minor Equipment 0.00 0.00% 931.89 0.23% 2160 -46330 Maint. & Construct Materials 85.97 0.27% 4,603.00 1.13% 2171 -46330 General Supplies 107.41 0.34% 2,636.60 0.65% Total Supplies 593.92 1.860/0 9,196.69 0.61% Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 0.00 0.00% 305046330 Expert and Professional Services 0.00 0.00% 0.00 0.00% 3060 -46330 Management Services 4,866.00 15.23% 38,928.00 9.53% 3100 -46330 Protective Services 156.98 0.49% 12,148.16 2.98% 321046330 Telephone &Telegraph 285.02 0.89% 2,496.53 0.61% 343046330 Advertising Other 0.00 0.00% 0.00 0.D0% 360046330 Insurance & Bonds 1,590.15 4.98% 12,718.90 3.12% 3810 -46330 Electric 6,141.88 19.23% 35,797.16 8.77% 382046330 Water 0.00 0100% 3,862.01 0.95% 383046330 Gas 401.39 1.26% 21,973.78 5.38% 384046330 Refuse 0.00 0.00% 5,818.19 1.43% 385046330 Sewer 0.00 0.00% 2,106.56 0.52% 400046330 Repair & Maint. Services 5,215.15 16.33% 67,011.82 16.41% 405046330 Garage, labor 0.D0 0.00% 0.00 0.00% 4100 -46330 Rents & Leases 0.00 0.00% 1,426.75 0.35% 430046330 Miscellaneous Charges 0.00 0.00% 599.38 0.15% 431546330 PILOT 1,730.56 5.42% 13,844.48 3.39% 439046330 Taxes & Licenses 69.00 0100% 1,336.53 0.33% 450046330 Administrative Expenses 564.75 1.77% 1,990.60 0.49% 485046330 Interest on Deposits 15.27 0.05% 117.63 0.03% Total Other Services & Charges 21,036.15 65.86% 222,176.48 54.42% Page 2 of 9 a �r Capital Outlay 5120 -46330 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00 0.00 0.00 0.00% PA Will &SWEliiI_\ &I 0.00 30,559.07 95.67% 302,805.17 74.16% 1,383.93 4.33% 105,481.72 25.84% Page 3 of 9 Parkmev; Villa - North (if5) Cash Flow Statement Period = Augr:st 2015 5cok 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 Total Supplies Other Services & Charges 3040 Legal Fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maint. Services 4050 Garage, Labor Burd. 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits 5120 Building & Improvement Total Other Services & Charges Total Expenses Excess (Deficit) Revenue over Expenses Page 4 of 9 9/11/201510:41 AM Month to Date 0.00 31,092.00 374.00 477.00 0.00 31,943.00 8,929.00 8,929.00 400.54 0.00 0.00 193.38 593.92 0.00 0.00 4,866.00 156.98 285.02 0.00 1,590.15 6,141.88 0.00 401.39 0.00 0.00 5,215.15 0.00 0.00 0.00 1,730.56 69.00 564.75 15.27 0.00 21,036.15 30,559.07 1,383.93 FM Cash Flow Statement Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Page 5 of 9 9/11/2015 10:41 AM Month to Date 0.00 0.00 - 1,422.30 286.00 0.00 0.00 0.00 -61.41 1,590.15 0.00 15.27 1,730.56 - 318.00 1,820.27 3,204.20 Beg Cash End Cash Difference 181,471.90 184,676.10 3,204.20 457.00 457.00 - 898,424.28 898,424.28 - 1,080,353.18 1,083,557.38 3,204.20 M Parkview Villa -North (165) General Ledger Period = Aug 2015 Book = Accrual; Tree = ysi_tb Proper Date Person /Description Reference 1000 -46330 Accrued Salaries 165 8/31/2015 :PostRecurring Monthly recurrin RC Net Change= 8,929.00 Debit Credit Balance Remarks 62,503.00 = Beginning Balance = 8,929.00 0.00 71,432.00 R/C CHIC PR Mgmt Fee 71,432.00 = Ending Balance = 2000 -46330 Office Supplies 624.66 = Beginning Balance = 165 7/29/2015 HD Supply Facilities Maintenanc 9139253007 53.46 0.00 678.12 paper;pens;ink rollers -69% 165 7/31/2015 Erica Rogers (rogere) 073115sites 7.48 0.00 685.60 Comp support mileage 7/20 -7/3 165 8/17/2015 US Bank(usba790) 448559455559124 9.60 0.00 695.20 TERRI L KANISTARGET 000220C 165 8/27/2015 CommonBond Housing (chc) 082715compsupp 330.00 0.00 1,025.20 computer support 07/22- 08/27/ Net Change= 400.54 1,025.20 = Ending Balance = 2010 -46330 Minor Equipment Net Change =0.00 2160 -46330 Plaint. & Construct. Materials 165 8/24/2015 HD Supply Facilities Maintenanc 9139884782 Net Change =85.97 2171 -46330 General Supplies 165 8/24/2015 HD Supply Facilities Maintenanc 9139884782 Net Change= 107.41 3060 -46330 Management Services 165 8/28/2015 Common Bond Housing (chc) 082815mgmt 165 8/31/2015 :PostRecurring Monthly recurrin RC Net Change= 4,866.00 3100 -46330 Protective Services 165 8/18/2015 Summit Fire Protection (summ) 1078876 Net Change= 156.98 931.89 = Beginning Balance = 931.89 = Ending Balance = 4,517.03 = Beginning Balance = 85.97 0.00 4,603.00 blbs /flppr /sup line /sz insrt 4,603.00 = Ending Balance = 2,529.19 = Beginning Balance = 107.41 0.00 2,636.60 cleaner /gloves 2,636.60 = Ending Balance = 34,062.00 = Beginning Balance = 13,795.00 0.00 47,857.00 mgmt fee 08/15 0.00 8,929.00 38,928.00 R/C CHIC PR Mgmt Fee 38,928.00 = Ending Balance = 156.98 3210 -46330 Telephone & Telegraph 165 7/31/2015 Popp.com (popp) 992279737 223.73 165 8/2/2015 Comcast(comc3517) 877210505019618 61.29 Net Change= 285.02 3600 -46330 Insurance & Bonds 165 8/31/2015 :PostRecurring Monthly recurrin RC 1,590.15 Net Change= 1,590.15 3810 -46330 Electric 165 8/11/2015 Xcel Energy (xcel) 5150441553 08/11 6,141.88 Net Change = 6,141.88 3820 -46330 Water Net Change= 0.00 3830 -46330 Gas 165 8/7/2015 CenterPoint Energy (cent) 55199657 08/07/1 309.54 165 8/10/2015 CenterPoint Energy (cent) 55271324 08/10/1 91.85 Net Change= 401.39 3840 -46330 Refuse Net Change =0.00 3850 -46330 Sewer Net Change =0.00 4000 -46330 Repair & Maint. Services 165 7/31/2014 LBP Mechanical, Inc(Ibpm) W20827 113.85 11,991.18 = Beginning Balance = 0.00 12,148.16 troubleshoot alarm- 08/07/15 12,148.16 = Ending Balance = 2,211.51 = Beginning Balance = 0.00 2,435.24 phone -69% 8/15 0.00 2,496.53 internet -69% 8/11- 9/10/15 2,496.53 = Ending Balance = 11,128.75 = Beginning Balance = 0.00 12,718.90 C of Columbia Heights Ins Accrl 12,718.90 = Ending Balance = 29,655.28 = Beginning Balance = 0.00 35,797.16 E- 07/07 - 08/05/15 35,797.16 = Ending Balance = 3,862.01 = Beginning Balance = 3,862.01 = Ending Balance = 21,572.39 = Beginning Balance = 0.00 21,881.93 G- 07/07- 08/05/15 0.00 21,973.78 G- 07/08- 08/06/15 21,973.78 = Ending Balance = 5,818.19 = Beginning Balance = 5,818.19 = Ending Balance = 2,106.56 = Beginning Balance = 2,106.56 = Ending Balance = 61,796.67 = Beginning Balance = 0.00 61,910.52 fuse replace- 07/23- 07/30/14 30 165 6/30/2015 Adam's Pest Control, Inc. (adan 1130770 06/30/15 48.99 0.00 61,959.51 pest control 165 7/31/2015 Integrity Cleaning Solutions (int 73120151 611.94 0.00 62,571.45 caretaking- 07/27- 07/31/15 165 7/31/2015 Integrity Cleaning Solutions (int73120152 296.70 0.00 62,868.15 groundskeeping -69 % 7/27 -31/2 165 8/1/2015 Kone Inc.(kone) 949058377 738.10 0.00 63,606.25 maint- 08/01- 08/31/15 165 8/7/2015 Integrity Cleaning Solutions (int80720151 611.94 0.00 64,218.19 caretaking - 08/03- 08/07/15 165 8/7/2015 Integrity Cleaning Solutions (int80720152 296.70 0.00 64,514.89 groundskeeping -69% 8/3 -7/201 165 8/15/2015 Integrity Cleaning Solutions (int81520153 1,569.75 0.00 66,084.64 lawn care /mulch /till 165 8/21/2015 integrity Cleaning Solutions (mi:82120151 611.94 0.00 66,696.58 caretaking 165 8/21/2015 Integrity Cleaning Solutions (ImS2120152 315.24 0.00 67,011.82 groundskeeping Net Change = 5,215.15 67,011.82 = Ending Balance = 4100 -46330 Rents & Leases 1,426.75 = Beginning Balance = Net Change =0.00 1,426.75 = Ending Balance = 4300 -46330 Miscellaneous Charges 599.38 = Beginning Balance = Net Change =0.00 599.38 = Ending Balance = 4315 -46330 PILOT - 12,113.92 = Beginning Balance = 165 8/31/2015 :PostRecurring Monthly recurrin RC 1,730.56 0.00 13,844.48 Anoka Cty Property Tax Accrual Net Change= 1,730.56 13,844.48 = Ending Balance = 4390 -46330 Taxes & Licenses 1,267.53 = Beginning Balance = 165 8/2/2015 MN Dept of Labor & Industry (aALR0052866I 69.00 0.00 1,336.53 elevator fee Net Change =69.00 1,336.53 = Ending Balance = 4500 -46330 Administrative Expenses 1,425.85 = Beginning Balance = 165 8/10/2015 Smith (1:0011360) 377.70 0.00 1,803.55 Past resident over 90 days due 165 8/10/2015 Schwitters (1:0012701) 3.00 0.00 1,806.55 No 30 day notice of increase 165 8/10/2015 Peterson (t0009566)- 4.00 0.00 1,810.55 No 30 day notice of increase 165 8/20/2015 Dan Cunningham (1timel5z) 82015165 46.05 0.00 1,856.60 Exp reimburse - coffee maker 165 8/25/2015 Hanson (1:0004060) 134.00 0.00 1,990.60 No 30 day notice of increase - It Net Change = 564.75 1,990.60 = Ending Balance = 4850 -46330 Interest on Deposits 102.36 = Beginning Balance = 165 8/31/2015 Sec dep interest accrual G11 15.27 0.00 117.63 Sec dep interest accrual Net Change= 15.27 117.63 = Ending Balance = 39,488.07 8,929.00 - 31 5016456 Parkview Villa North 9/1/15 Bank Reconciliation Report 08/31/2015 Balance Per Bank Statement as of 08/31/2015 $193,403.49 02/04/2014 2327 t0008445 - Schuster 419.94 06/1712014 2446 t0013260 - Vg 0.65 08/19/2014 2488 t0004040 - Camp 276.52 011142015 2634 cent2000 - Central Lock & Safe 125.00 06/242015 2809 t0010795 - Ruiz 194.84 0625/2015 2812 t0009235 - Colon 29.00 08262015 2838 1timel5z -Dan Cunningham 46.05 08/262015 2839 cent - CenterPoint Energy 401.39 0826/2015 2841 cemc3517- Comcast 61.29 08262015 2843 kone - Kone Inc. 738.10 0826/2015 2844 mndpl - MN Dept of Labor & Industry 69.00 0826/2015 2845 Popp - Popp.com 223.73 0826/2015 2846 xcel - Xcel Energy 6,141.88 Less: Outstanding Checks 2836 $8,727.39 48.99 Reconciled Bank Balance $184,676.10 Balance per GL as of 08/31/2015 $184,676.10 Reconciled Balance Per G/L $184,675.10 Difference 0.00 Cleared Items: Cleared Checks Date Tran # Notes Amount Date Cleared 06252015 2814 10009778 - LaMonica 215.00 08/31/2015 07292015 2827 cent - CenterPoint Energy 544.69 08131/2015 0729/2015 2828 chc - CommonBond Housing 35.33 08/312015 07/292015 2829 celu - City of Columbia Heights 7,251.28 08/312015 07292015 2830 home7 - HD Supply Facilities Maintenance, Ltd. 108.16 08/31/2015 07292015 2831 inte929 - Integrity Cleaning Solutions 1,965.32 08/312015 07/29/2015 2832 xcel - Xcel Energy 5,343.57 08/312015 08/052015 2833 buck&411 - Buckeye Cleaning Centers 86.27 081312015 08/052015 2834 chc - CommonBond Housing 13,795.00 08/3112015 08/05/2015 2835 inte929 - Integrity Cleaning Solutions 3,275.88 08131/2015 08/12/2015 2836 adam - Adam's Pest Control, Inc. 48.99 08/312015 08/122015 2837 home7 - HD Supply Facilities Maintenance, Ltd. 53.46 08131/2015 3v ' Parkview Villa North Bank Reconciliation Report 08/31/2015 5016456 08/26/2015 2840 chc- Common8ond Housing 7.48 08131/2015 08/26/2015 2842 inte929 - Integrity Cleaning Solutions 1,817.28 08/31/2015 Total $34,547.71 Cleared Deposits Date Tran # 08/03/2015 750 08/03/2015 751 08/03/2015 752 08/04/2015 753 08/06/2015 754 08/10/2015 755 08/14/2015 757 08119/2015 758 Total Cleared Other Items Date Tran # 08112/2015 RC 1326206 Total Notes Notes Returned item 10009559 Amount Date Cleared 10,040.00 08/3112015 8,864.00 08/31/2015 3,052.00 08/3112015 4,094.00 08/31/2015 2,932.00 08/31/2015 584.00 - 08/31/2015 524.00 08/31/2015 225.00 08/31/2015 $30,315.00 Amount Date Cleared - 345.00 08/31/2015 - $345.00 9/1/15 33 HRA OF COLUMBIA HEIGHTS Date 8/31/15 Page 1 PARKVIEW VILLA NORTH Primary Account @XXXXX @6456 C/0 COMMONBOND COMMUNITIES Enclosures 22 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 PLEASE JOIN US FOR OUR COMMUNITY PICNIC: FRIDAY,SEPT. 11TH FROM 11 AM TO 1 PM AT OUR MINNEAPOLIS OFFICE. FREE BRATS, HOT DOGS, POP AND COOKIES WILL BE SERVED ALONG WITH LIVE MUSIC! PLEASE CONSIDER BRINGING A NON - PERISHABLE FOOD DONATION FOR THE ESNS FOOD SHELF. NORTHEAST PUBLIC FUNDS Account Number Previous Balance 8 Deposits /Credits 14 Checks /Debits 1 Electronic Debit Service Charge Interest Paid Ending Balance ACCT @XXXXX @6456 197,981.20 30,315.00 34,547.71 345.00 .00 .00 193,403.49 Number of Images 22 Statement Dates 8/01/15 thru 8/31/15 Days in the Statement Period 31 Average Ledger 197,983 Average Collected 197,019 Deposits and Credits Date Description Amount 8/03 DDA REGULAR DEPOSIT 3,052.00 8/03 DDA REGULAR DEPOSIT 8,864.00 8/03 DDA REGULAR DEPOSIT 10,040.00 8/04 DDA REGULAR DEPOSIT 4,094.00 8/06 DDA REGULAR DEPOSIT 2,932.00 8/10 DDA REGULAR DEPOSIT 584.00 8/14 DDA REGULAR DEPOSIT 524.00 8/19 DDA REGULAR DEPOSIT 225.00 ++**+++++++++++++**++++++++++++++++++++++++++++ + + + + + + + + + + * * + + + * + + + ** + * + + + + * + *+ Charges and Debits Date Description Amount 8/31 Xfer to PUB FUND 0002 345.00 Bank error NSF'd to wrong Checks in serial order Date Check# Amount Date Check# Amount 8/04 2814 215.00 8/04 2832 5,343.57 8/06 2827* 544.69 8/11 2833 86.27 8/03 2828 35.33 8/07 2834 13,795.00 8/04 2829 7,251.28 8/11 2835 3,275.88 8/05 2830 108.16 8/21 2836 48.99 8/03 2831 1,965.32 8/18 2837 53.46 * Indicates skip in check numbers 3 L- Date 8/31/15 Page 2 Primary Account @XXXXX @6456 Enclosures 22 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 8/31 2840* 7.48 8/31 2842* 1,817.28 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 8/01 197,981.20 8/07 197,704.85 8/19 195,622.24 8/03 217,936.55 8/10 198,288.85 8/21 195,573.25 8/04 209,220.70 8 /11 194,926.70 8/31 193,403.49 8/05 209,112.54 8/14 195,450.70 8/06 211,499.85 8/18 195,397.24 * * * E N D O F S T A T E M E N T Payment Summary Bank= 1650pr AND mm /yy= 08/2015- 08/2015 AND All Checks =yes AND Include Voids =All Checks August 2015 Check Total Bank Check# Vendor Date Amount 1650pr - Parkview Villa North 2833 buck8411 - Buckeye Cleaning Centers 08/05/2015 86.27 165opr - Parkview Villa North 2834 chc - CommonBond Housing 08/05/2015 13,795.00 1650pr - Parkview Villa North 2835 Inte929 - Integrity Cleaning Solutions 08/05/2015 3,275.88 165opr - Parkview Villa North 2836 adam - Adam's Pest Control, Inc. 08/12/2015 48.99 - 1650pr - Parkview Villa North 2837 home? - HD Supply Facilities Maintenance, Ltd. 08/12/2015 53.46 1650pr - Parkview Villa North 2838 Stimel5z - Dan Cunningham 08/26/2015 46.05 165opr - Parkview Villa North 2839 cent - CenterPoint Energy 08/26/2015 401.39 1650pr - Parkview Villa North 2840 chc - CommonBond Housing 08/26/2015 7.48 165opr - Parkview Villa North 2841 comc3517 - Comcast 08/26/2015 61.29 1650pr - Parkview Villa North 2842 inte929 - Integrity Cleaning Solutions 08/26/2015 1,817.28 165opr - Parkview Villa North 2843 kone - Kone Inc. 08/26/2015 738.1 165opr - Parkview Villa North 2844 mndpl - MN Dept of Labor & Industry 08/26/2015 69 165opr - Parkview Villa North 2845 Popp - Popp.com 08/26/2015 223.73 165opr - Parkview Villa North 2846 xcel - Xcel Energy 08/26/2015 6,141.88 26,765.80 3to Parkview Villa North Financial Statement Overview September 2015 Revenue: Occupancy for the month of September 2015 was 96% occupied Rent Revenue was under budget (unfavorable) due to vacancies requested and agreed upon by parties to the sale Total Revenue for September was under budget (unfavorable) No Grant Income was received, accounting month ended on Sept. Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Resident Bad Debt was over budget (unfavorable) and reflects the uncollectable accounts sent to collections agency Utilities: Utilities Expenses were under budget (favorable) Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects August billing Gas was under budget (favorable) and reflects August billing Water and Sewer were under budget (favorable) and reflects a quarterly billing 37 Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were over budget (favorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflects cost of contract cleaning Maintenance Supplies was under budget (favorable) Garbage and Trash was over budget (unfavorable) and reflects charges for hazardous waste disposal, dumpster rental and hauling; cleaning out abandoned unit Grounds Contract was over budget (unfavorable) and reflects invoices from August and September for grounds pick up Repairs contract was over budget (unfavorable) and reflects cost of dryer repairs ($580), Elevator Maintenance Contract is over budget (unfavorable) and reflects invoices from July and August Furniture and Fixtures was over budget (unfavorable) and reflects the cost of Counter Top and Door Replacement 3� 8 W d m m S a W ( A m m o m m m t m A N v (P f+l, fQn rn O E °CL Ao o ni g mom m o+° good 1 T A 1 A A A 9 T = c 3 A Z y g N � m m� m ICi� i m w N. N m t{pp W N f0 t0 m O O fop A O O rn O O W W O O A O O O O O O rn m w V �l A N 6 rnW 61 N Co m + (P m 0 tr 74 W W W W O O W N ,�• N O W O O V cm N rn V O O fT ffpp N Z m (Op O + p+p�l t0 i� 00 W rnm N N�pOp A N !J C H + O O O iWT N A N rn O N W W N+ 0 o in moo w o rn W a orn _ I pp Nm N N N O m 0 0 iVJ iVlt t00 N N (NA N '6 O O pJ Orni O N W V foil W tOJ O '..0n N O AA fJ m (OI, A A N OWO m m trn0 (T O VI CO O OJ (D N W W O W O o + rn 0 c0 V tm W W W rn I oo V m � T m V O yy A+ y I 0 Fang �N �� m &ana�'a $' rn mrn rnrnmrn rnarnrn,'., n m - L0< 0 - 0 z 4wm ° m0 •iv 0 2 $a N•" of 1 c m�i „,. n mm �3 ' m m Da N K 0 5 w m c m 3 m� O O N p � obi >> m m= 2 m �$ m m m w m a 5 N° m a m o o w a m O 3. m o'm a m �vv m �' a' 0Q) a w YJ V 3 a N@ MO >' Im w w w N OI m V1 A � A N W V VA A O �p NN N W O f0 O W O (l� O N O A A 0 0 OOi 0 0 0 0 �3 D) IJ W W tJ t° fJ O m 0 tJ O 0 O <P O W O O D O O O O Cm O N 1V O W O (0 0 p O W O V O O O O O O O W A t0 V tP V (O N O O N tp OI A A O fAJ N O A O Qo O p (n O W m fP N N N O O N lT i 6 N W N m W (O N W N f0 N Ol N N O O N Vt Ut N �� t0 O (° N ttOO O� V W O j O O W O W O O O N N E (O + Sa O tp O1 OJ O IJ O m q w w W O Of O O C lJ O N O O O O O O S W C o c o i N W J + W N O w O V W O N O O O O o 0 A m N N + O Opi O W N N N D A N V W m m V N N 0 O ffDD V W N O O O A (AO lAJ N N N O� 2 D) + O (T V (T 01 O (T O W N W 0 0 0 fp N O J W W V (D W O + (T O N D) N 0000 O�OI AN NVWN +O W � + A WV AN V+.m W N T V t0 (T (T O N C N QJ V O p N O N O V O OJ V V O CO O A A O O W (P 6 W W V O N W W W w p N v W O W O V O O O O o wN + EC tD V W V A G N f° fN Oi + W W p fp A W Oo N O lm � N V O A m N V V W W V N W O - O m O m W Oi N j Cp A A O O O Ol J O� w do I m i W W O� V A A t0 W A tT lJ O A W w m 0 V Oi t° W Z + O t0 Z O V No O m V (° fJ W m G D O O w T 0 C C O •2 O W W W O tT + W A N N m W m O N W N O o cn y m Q O O O 0 0 0 0 0 0 O O O O tp tT O O N 0 0 N O `� O O A O� v O 0 O O C 0 0 0 0 0 0 p O 00 O O O a O O O O m Cf O O O O p O O O O O p O co O O O O O I in in N O O O O O 0 O cn A A WW O W V O J V V tyJ O W W O W N Z N A A W A two N N �l v W O O W O W Cm + O N A m N Z N � a c m oZ V r m y O O O W 0 O too + O + V O V NI N W W W O W W 8 I V tWJ W & O V V W W V V A A 0 W A W O &I 0 0 81 m A N • N N W � O + W jU W V IT O A O O 0 O O m! O W V (D N A N Calon 0W N W N w o 0 V N N Q O O `EJ O O O O O N a W W J WI V W W W W 8 n < t01� O N N 00 O 0 W N 0N n m O T W W W A N N V O W U T (o A A W w W 1 b 1 O N 5 t0 O W O W m O 3 O J N m v m Q m g°, $ C `mG N � •m` �' M � •G m w V V O W N (D O W m O O N O w S°S c m y m r o ka O V O W J W W N O O V 2 O m;[ 0ONm d0m00m —sS�Jg _.c m m 2.88 4 Jm m m in in N O O O O O 0 O cn A A WW O W V O J V V tyJ O W W O W N Z N A A W A two N N �l v W O O W O W Cm + O N A m N Z N � a c m oZ V r m y O O O W 0 O too + O + V O V NI N W W W O W W 8 I V tWJ W & O V V W W V V A A 0 W A W O &I 0 0 81 m A N • N N W � O + W jU W V IT O A O O 0 O O m! O W V (D N A N Calon 0W N W N w o 0 V N N Q O O `EJ O O O O O N a W W J WI V W W W W 8 n < t01� O N N 00 O 0 W N 0N n m O T W W W A N N V O W U T (o A A W w W 1 b 1 O N (O t0 O W O W (O C O W W N O w rt a N m Q m � o V W V V O W N (D O W W O W O O O N N 0+ V W V O N Ut A tC S°S o W O V O W J W W N O O V 2 O m;[ 0ONm d0m00m —sS�Jg _.c m m 2.88 4 Jm m m . m. O— J m J m. m e 9; m Nm a] R^(c N+ N 41 O V O N m (T �m � w w m m a o P' o m- 0 M 0 m o o c V N+ 0 W W W N W W O O W A O w9 ONa @ O N N+ N 8 0 m c a m �. d ii+ 0 O (70 m y n T T U W o N m w ^ � fWi� m m m I V w A 0 w A 6 m+ A W f�l t0 O V W O A O O (P N O (T W s N 0000 O WO O O O O O 0 W OWOOA W a NJ ^' 8 O O O O O O O O O O C O O'er O O O O O O O O O O O O O im fD O O O A O O V OVi OW V O ut W' W O A W O O O W N W t0 O W V 01 O V N O O O N O W W O W UI l� E + V O W V tT O W W O O W O W W t0 (T N (T W O N N W a V V 6 0 W O 000 Iw 111 W N tJ A G + IJ ip 1a em O 0 V t0 W W O (O f0 O + W A V O w Oi N t0 O� V !O O A W N fT O N W tP W O V (li g eanAiw °oD � mwco °o °J m yl OD b N N J O m A N N V O W V W W N N O N (O t0 O W O W (O C O W W N O O N N V W V V O W N (D O W W O W O O O N N 0+ V W V O N Ut A tC W O V O W N O W W N O O V O 4 N � V� N+ N 41 O V O N W fT (T W A (NJ !�• V W W W W A N W V N W N E V N+ 0 W W W N W W O O W A ONa + V A O N N+ N 8 0 A N O 0W V o o T T U W o N m t00 fWi� I V w A 0 w A 6 m+ A W f�l t0 O V W O A O O (P N O (T W s N 0000 O WO O O O O O 0 W OWOOA W a NJ ^' 8 O O O O O O O O O O C O O'er O O O O O O O O O O O O O im yl /§ 2/ § CL G P< - J, ! 7 7 Q! ® ,, !• - ! \ \ |f (( wl f \2E)f 0 k\ ƒ - E \\ / }/ \ �} / / } ) ƒ ( £ |! 7 ■ � ; : ` � ) ee � ) \\ § § /§ d \ k \§ § ; §\ § § | $ ! .! # - \ 2 \/ \ 0 \\ 2 w t E §2 q § §/ ( k .! } 2 \ \ k \ �� Parkview Villa -North Balance Sheet September 2015 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Acounts Receivable 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 153,454.30 457.00 898,424.28 1,418.60 2,906.00 1,056,660.18 13,795.00 14,807.27 551.74 19,290.50 15,302.46 1,097.37 64,844.34 991,815.84 991,815.84 1,056,660.18 113 10/15/2015 1:12 PM Parkview Villa -North Income Statement September 2015 Books = Accrual Page 2 of 9 r 1 Month to Date % Year to Date % Revenue 33160 -46330 Federal Grant - 0.00% 161,065.26 36.50% 36220 -46330 Gen. Government Rents 28,826.00 87.49% 268,051.36 60.75% 36225 -46330 Nondwelling Rents 374.00 1.14% 3,162.00 0.72% 3629D -46330 Other Miscellaneous Revenue 874.06 2.65% 5,677.33 1.29% 39120 -46330 Recovery Damage City Property 2,875.00 8.73% 3,280.00 0.74% Total Revenue 32,949.06 100.00% 441,235.95 100.00% Expenses Personal Services 1000 -46330 Accrued Salaries 8,929.00 27.10% 80,361.00 18.21% Total Personal Services 8,929.00 27.10% 80,361.00 18.21% Supplies 2000 -46330 Office Supplies 0.00 0.00% 1,025.20 0.23% 2010 -46330 Minor Equipment 940.47 2.85% 1,872.36 0.42% 2160 -46330 Maint & Construct Materials 141.68 0.43% 4,744.68 1.08% 2171 -46330 General Supplies 138.24 0.42% 2,774.84 0.63% Total Supplies 1,220.39 3.70% 10,417.08 Other Services & Charges 3040 -46330 Legal Fees - 0.00 0.00% 0.00 0.00% 3050 -46330 Expert and Professional Services 19,125.00 58.04% 19,125.00 4.33% 3060 -06330 Management Services 4,866.00 14.77% 43,794.00 9.93% 310096330 Protective Services 265.66 0.81% 12,413.82 2.81% 321046330 Telephone &Telegraph 284.37 0.86% 2,780.90 0.63% 3430 -46330 Advertising Other 0.00 0.00% 0.00 0.00% 360046330 Insurance & Bonds 1,590.15 4.83% 14,309.05 3.24% 3810 -46330 Electric 6,015.39 18.26% 41,812.55 9.48% 382096330 Water 0.00 0.00% 3,862.01 0.88% 383046330 Gas 463.83 1.41% 22,437.61 5.09% 384046330 Refuse 1,983.75 6.02% 7,801.94 1.77% 385046330 Sewer 0.00 0.00% 2,106.56 0.48% 4000 -46330 Repair & Maint. Services 15,689.86 47.62% 82,701.68 18.74% 405096330 Garage, Labor 0.00 0.00% 0.00 0.00% 410046330 Rents & Leases 0.00 0.00% 1,426.75 0.32% 430096330 Miscellaneous Charges 0.00 0.00% 599.38 0.14% 4315 -46330 PILOT 1,730.56 5.25% 15,575.04 3.53% 439046330 Taxes & Licenses 69.00 0.D0% 1,405.53 0.32% 4500-46330 Administrative Expenses 28.00 0.08% 2,018.60 0.46% 4850 -46330 Interest on Deposits 14.53 0.04% 132.16 0.03% Total Other Services & Charges 52,126.10 158.20% 274,302.58 62.17% Page 2 of 9 r 1 10115120151:12 PM Capital Outlay 5120 -46330 Building & Improvements 0.00 0.00 % - 0.00% Total Capital Outlay 0.00 0.000/0 0.00 0.000/0 Total Expense 62,275.49 189.01% 365,080.66 82.740/a Excess (Deficit) Revenue over Expense - 29,326.43 - 89.01 -/0 76,155.29 17.26% Page 3 of 9 Paikvier Cash Flow Statement 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 Total Supplies Other Services & Charges 3040 Legal Fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services . 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maint. Services 4050 Garage, Labor Burd. 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits 5120 Building & Improvement Total Other Services & Charges Total Expenses Excess (Deficit) Revenue over Expenses Page 4 of 9 10115/20151:12 PM Month to Date 0.00 28,826.00 374.00 874.06 2,875.00 32,949.06 8,929.00 8,929.00 0.00 940.47 0.00 279.92 1,220.39 0.00 19,125.00 4,866.00 265.66 284.37 0.00 1,590.15 6,015.39 0.00 463.83 1,983.75 0.00 15,689.86 0.00 0.00 0.00 1,730.56 69.00 28.00 14.53 0.00 52,126.10 62,275.49 - 29,326.43 Cash Flow Statement Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Page 5 of 9 10/15120151:12 PM Month to Date 0.00 0.00 648.00 - 2,850.00 0.00 0.00 0.00 - 3,300.74 2,087.08 0.00 - 307.77 1,730.56 97.50 (1,895.37) (31,221.80) Beg Cash End Cash Difference 184,676.10 153,454.30 (31,221.80) 457.00 457.00 - 898,424.28 898,424.28 - 1,083,557.38 1,052,335.58 (31,221.80) 47 Parkview Villa -North (165) General Ledger Period = Sep 2015 Book = Accrual; Tree = ysl_tb Proper Date Person /Description Reference Debit Credit Balance Remarks 1000 -46330 Accrued Salaries 71,432.00 = Beginning Balance = z165 9/30/2015 :PostRemrrin9 Monthly recurrin RC 8,929.00 0.00 80,361.00 R/C CHC PR Mgmt Fee Net Change = 8,929.00 80,361.00 = Ending Balance = 2000 -46330 Office Supplies 1,025.20 = Beginning Balance = Net Change =0.00 1,025.20 = Ending Balance = 2010 -46330 Minor Equipment 931.89 = Beginning Balance = 2165 8124/2015 Project One Construction, Inc. (2.015E+12 940.47 0.00 1,872.36 counter /door replace z165 8/24/2015 Project One Construction, Inc. (2.015E+15 940.47 0.00 2,812.83 counter /door replace z165 8/24/2015 Project One Construction, Inc. ( 201500060016516, 0.00 940.47 1,872.36 counter /door replace Net Change= 940.47 1,872.36 = Ending Balance = 2160 -46330 Maint. & Construct Materials 4,603.00 = Beginning Balance = z165 9/1/2015 HD Supply 800007135 0.00 128.16 4,474.84 z165 9/10/2015 Park Supply of America, Inc. (p:61222100 149.53 0.00 4,624.37 drain clear /gloves z165 9/11/2015 HD Supply Facilities Malntenanc9140331350 21.80 0100 4,646.17 auger z165 9/11/2015 HD Supply Facilities Maintenanc9140331348 68.33 0.00 4,714.50 sockets /bib hldrs/bibs z165 9/17/2015 HD Supply Facilities Maintenanc 9140479662 30.18 0.00 4,744.68 bulbs Net Change= 141.68 4,744.68 = Ending Balance = 2171 -46330 General Supplies 2,636.60 = Beginning Balance = z165 9/8/2015 Sherwin - Williams Co. (sher411(9487 110.32 0.00 2,746.92 paint/recycle fee z165 9/11/2015 HD Supply Facilities Maintenanc9140331348 27.92 0.00 2,774.84 towels Net Change = 138.24 2,774.84 = Ending Balance = 3050 -46330 Expert & Professional Services 0.00 = Beginning Balance = z165 9/9/2015 Columbia Heights HRA (coluhra 20141a 19,125.00 0.00 19,125.00 servicing fees 01/15-09/15 Net Change= 19,125.00 - 19,125.00 = Ending Balance = 3060 -46330 Management Services 38,928.00 = Beginning Balance = z165 9/29/2015 CommonBond Housing (chc) 092915mgmt 13,795.00 0.00 52,723.00 mgmt fee 09/15 2165 9/30/2015 :PostRecurring Monthly recurrin RC 0.00 8,929.00 43,794.00 R/C CHC PR Mgmt Fee Net Change = 4,866.00 43,794.00 = Ending Balance = 3100-46330 Protective Services 12,148.16 = Beginning Balance = z165 9/1/2015 Trans -Alarm Inc(tran) RMR025683 265.66 0.00 12,413.82 monitoring- 09/01/15 - 08/31/16 Net Change = 265.66 12,413.82 = Ending Balance = 3210 -46330 Telephone & Telegraph 2,496.53 = Beginning Balance = z165 8/31/2015 Popp.com (popp) 992286168 223.08 0.00 2,719.61 phone/net- 08/01- 08/31/15 z165 9/2/2015 Comcast(comc3517) 877210505019618 61.29 0.00 2,780.90 net - 09/11- 10/10/15 Net Change= 284.37 2,780.90 = Ending Balance = 3600 -46330 Insurance & Bonds 12,718.90 = Beginning Balance = 2165 9/30/2015 :PostRecurring Monthly recu rrin RC 1,590.15 0.00 14,309.05 C of Columbia Heights Ins Accrl Net Change= 1,590.15 140309.05 = Ending Balance = 3810 -46330 Electric 35,797.16 = Beginning Balance = 2165 9/11/2015 Xcel Energy (xcel) 5150441553 09/11 5,923.26 0.00 41,720.42 E- 08 /05- 09/06/15 2165 9/11/2015 Xcel Energy (xcel) 5150441553 09/11 92.13 0.00 41,812.55 late fee Net Change = 6,015.39 41,812.55 = Ending Balance = 3820 -46330 Water 3,862.01 = Beginning Balance = Net Change =0.00 3,862.01 = Ending Balance = 3830 -46330 Gas 21,973.78 = Beginning Balance = 2165 9/8/2015 CenterPoint Energy (cent) 55199657 09/08/21 320.04 0.00 22,293.82 G- 08/05- 09/03/15 z165 9/8/2015 CenterPoint Energy (cent) 55199657 09/08/1: 463.83 0.00 22,757.65 G- 08/05-09/03/15 z165 9/9/2015 CenterPoint Energy (cent) 55271324 09/09/1: 89.38 0.00 22,847.03 G- 08/06- 09/04/15 z165 9/18/2015 CenterPoint Energy (cent) 55199657 09/08/21 0.00 320.04 22,526.99 G- 08 /05- 09/03/15 z165 9/1812015 CenterPoint Energy (Cent) 55271324 09/09/1' 0.00 89.38 22,437.61 G- 08 /06- 09/04/15 Net Change = 463.83 22,437.61 = Ending Balance = /' 3840 -46330 Refuse 5,818.19 = Beginning Balance = z165 9/11/2015 Integrity Cleaning Solutions (in1911201512 1,983.75 0.00 7,801.94 trash service Net Change = 1,983.75 7,801.94 = Ending Balance = 3850 -46330 Sewer 2,106.56 = Beginning Balance = Net Change =0.00 2,106.56 = Ending Balance = 4000 -46330 Repair -& Maint. Services 67,011.82 = Beginning Balance = z165 7/1/2015 Kone Inc.(kone) 949033543 738.10 000 67,749.92 maint- 07/01- 07/31/15 z165 7/29/2015 Adam's Pest Control, Inc. (adan2259021 75.23 0.00 67,825.15 exterior treatment- 07/29/15 2165 8/14/2015 Integrity Cleaning Solutions (in18142015 611.94 0.00 68,437.09 caretaking- 08/10- 08/14/15 z165 8/14/2015 Integrity Cleaning Solutions(In181420152 296.70 0.00 68,733.79 groundskeeping- 08 /10- 08/14/1: z165 8/18/2015 Direct Home Appliance Services BI815165166 455.64 0.00 69,189.43 dryer repairs z165 8/21/2015 Integrity Cleaning Solutions (In162020151 1,891.47 0.00 71,080.90 pressure wash z165 8/21/2015 Integrity Cleaning Solutions (in182020152 2,707.39 0.00 73,768.29 grounds work z165 8/21/2015 Integrity Cleaning Solutions (in18202015 1,688.97 0.00 75,477.26 caulking /sealing z165 8/28/2015 Integrity Cleaning Solutions (in18282015 630.49 0.00 76,107.75 cleaning- 08124- 08/28/15 2165 8/28/2015 Integrity Cleaning Solutions(in182820152 611.94 0.00 76,719.69 caretaking- 08/24 - 08/28/15 z165 8/28/2015 Integrity Cleaning Solutions(in182820151 333.79 0.00 77,053.48 groundskeeping- 08/24- 08/28/1' z165 8/28/2015 Kone Inc.(kone) 949082090 738.10 0.00 77,791.58 maint- 09/01- 09/30/15 z165 9/1/2015 Direct Home Appliance Services 90115165166 124.74 0.00 77,91632 dryer repair z165 9/4/2015 Integrity Cleaning Solutions(In1904201510 611.94 0.00 78,528.26 caretaking- 08/31 - 09/04/15 z165 9/4/2015 Integrity Cleaning Solutions(inI90420151 296.70 0.00 78,624.96 groundskeeping- 08/31- 09/04/1' z165 9/5/2015 Integrity Cleaning Solutions (in1904201512 259.62 0.00 79,084.58 cleaning z165 9/5/2015 Integrity Cleaning Solutions (in1904201511 482.14 0.00 79,566.72 window detail z165 9/5/2015 Drain King, Inc. (dai7740) 97065A 120.75 0.00 79,687.47 line clear z165 9/9/2015 Drain King, Inc. (dai7740) 97175 97.98 0.00 79,785.45 auger toilet z165 919/2015 Drain King, Inc. (dra17740) 97176 120.75 0.00 79,906.20 sink clear z165 9/10/2015 K O Cleaning and Remodeling, 13603 207.00 0.00 80,113.20 paint/patch z165 9/10/2015 K O Cleaning and Remodeling, 13602 207.00 0.00 80,320.20 paint/patch z165 9/11/2015 Integrity Cleaning Solutions(In1911201510 611.94 0.00 80,932.14 caretaking- 09/07- 09/11/15 z165 9/11/2015 Integrity Cleaning Solutions(In1911201511 296.70 0.00 81,226.84 groundskeeping- 09/07 - 09/11/1' z165 9/11/2015 HD Supply Facilities Maintenanc9140331348 77.32 0.00 81,306.16 pleated filters z165 9/15/2015 Integrity Cleaning Solutions (in191520157 500.68 0.00 81,806.84 full unit detail z165 9/18/2015 Integrity Cleaning Solutions(in191820151 598.14 0.00 82,404.98 caretaking- 09/14- 09/18/15 2165 9/18/2015 Integrity Cleaning Solutions(in191820152 296.70 0.00 82,701.68 groundskeeping- 09/14- 09/18/1' Net Change = 15,689.86 82,701.68 = Ending Balance = 4100 -46330 Other Renting Expenses 1,426.75 = Beginning Balance = Net Change =0.00 1,426.75 = Ending Balance = 4300 -46330 Miscellaneous Charges 599.38 = Beginning Balance = Net Change =0.00 599.38 = Ending Balance = 4315 -46330 PILOT 13,844.48 = Beginning Balance = z165 9/30/2015 :PostRecurring Monthly recurrin RC 1,730.56 0.00 15,575.04 Anoka Cty Property Tax Accrual Net Change= 1,730.56 15,575.04 = Ending Balance = 4390 -46330 Taxes & Licenses 1,336.53 = Beginning Balance = z165 9/1/2015 MN Dept of Labor & Industry In ALR0053890I 69.00 0.00 1,405.53 elevator fees Net Change =69.00 1,405.53 = Ending Balance = 4500 -46330 Administrative Expenses 1,990.60 = Beginning Balance = z165 9/14/2015 Robbins ([0004062) 8.00 0.00 1,998.60 No 30 day notice of Increase - 8 .165 9/14/2015 Aus (t0003983) 4.00 0.00 2,002.60 No 30 day notice of increase z165 9/14/2015 Flagg ([0013176) 8.00 0.00 2,010.60 No 30 day notice of Increase - 8 z165 9/14/2015 Reddy (t0006137) 8.00 0.00 2,018.60 No 30 day notice of increase - 8 Net Change =28.00 2,018.60 = Ending Balance = 4850 -46330 Interest on Deposits 117.63 = Beginning Balance = z165 9/30/2015 Security deposit Interest accrua GJ2 14.53 0.00 132.16 Security deposit interest accrua Net Change= 14.S3 132.16 = Ending Balance = 72,682.54 10,407.05 Y 5016456 Parkview Villa North Bank Reconciliation Report 09/30/2015 Balance Per Bank Statement as of 09/30/2015 02104/2014 2327 t0008445 - Schuster 06/17/2014 2446 10013260 - Vig 08119/2014 2488 t0004040 - Camp 01/14/2015 2634 cent2000 - Central Lock & Safe 06124/2015 2809 t0010795 - Ruiz 06125/2015 2812 t0009235 -Colon 09/1712015 2857 dire - Direct Home Appliance Services 09/23/2015 2865 adam - Adam's Pest Control, Inc. 09/2312015 2867 home7 - HD Supply Facilities Maintenance, Ltd. 0912312015 2871 proj - Project One Construction, Inc. 09/3012015 2874 cent - CenterPoint Energy 09/3012015 2875 home7 - HD Supply Facilities Maintenance, Ltd. 09/3012015 2876 inte929 - Integrity Cleaning Solutions Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 09/30/2015 Difference Cleared Items: Cleared Checks Date Tran # 08/2612015 2838 08/26/2015 2839 08/26/2015 2841 08/26/2015 2843 08/26/2015 2844 08/26/2015 2845 09/0212015 2847 09102/2015 2848 09102/2015 2849 09/0212015 2850 09102/2015 2851 0910912015 2852 Reconciled Balance Per G/L $160,164.98 419.94 0.65 276.52 125.00 194.84 29.00 580.38 75.23 195.37 940.47 463.83 30.18 3,379.27 $6,710.68 $153,454.30 10/1/15 $153,454.30 $153,454.30 Notes Amount Date Cleared 1timel5z - Dan Cunningham 46.05 09/30/2015 cent - CenterPoint Energy 401.39 09/30/2015 comc3517 - Comcast 61.29 09/30/2015 kone - Kone Inc. 738.10 09/30/2015 mndpl - MN Dept of Labor & Industry 69.00 09/30/2015 Popp - Popp.com 223.73 09/30/2015 chc - CommonBond Housing 14,125.00 09130/2015 home7 - HD Supply Facilities Maintenance, Ltd. 193.38 09/3012015 inte929 - Integrity Cleaning Solutions 2,496.93 09130/2015 Ibpm - LBP Mechanical, Inc 113.85 09130/2015 summ - Summit Fire Protection 156.98 09/30/2015 chc - CommonBond Housing 9.60 0913012015 Cleared Deposits Date Tran # Parkview Villa North Amount Date Cleared 09/01/2015 760 Bank Reconciliation Report 294.00 09/30/2015 09/01/2015 761 09/30/2015 9,487.00 09/30/2015 5016456 762 HD Supply Reimburse 128.16 09/30/2015 09/09/2015 2853 kone - Kone Inc. 738.10 09/30/2015 09/11/2015 2854 xcel - Xcel Energy 6,141.88 09/30/2015 09/17/2015 2855 coluhra - Columbia Heights HRA 19,125.00 09/3012015 09117/2015 2856 comc3517 - Comcast 61.29 09/30/2015 09/17/2015 2858 inte929 - Integrity Cleaning Solutions 8,734.12 09130/2015 09/17/2015 2859 koc17025 - K O Cleaning and Remodeling, Inc. 414.00 09/3012015 09/17/2015 2860 mndpl - MN Dept of Labor & Industry 69.00 09/30/2015 09117/2015 2861 Popp - Popp.com 223.08 09/30/2015 09117/2015 2862 sher4110 - Sherwin - Williams Co. 110.32 09/30/2015 09117/2015 2863 t0003983 - Aus 110.80 09/30/2015 09/17/2015 2864 tran - Trans -Alarm Inc 265.66 09/30/2015 09/23/2015 2866 drai7740 - Drain King, Inc. 339.48 09/30/2015 09123/2015 2868 inte929 - Integrity Cleaning Solutions 2,597.61 09/30/2015 09123/2015 2869 kone - Kone Inc. 738.10 09/30/2015 09123/2015 2870 parkt - Park Supply of America, Inc. 149.53 09/3012015 09123/2015 2872 t0005325- Loadbe 100.00 09130/2015 09123/2015 2873 xcel - Xcel Energy 6,015.39 09/30/2015 Total $64,568.66 Cleared Deposits Date Tran # Notes Amount Date Cleared 09/01/2015 760 Laundry 294.00 09/30/2015 09/01/2015 761 9,487.00 09/30/2015 0910112015 762 HD Supply Reimburse 128.16 09/30/2015 0910312015 763 14,235.00 09/30/2015 09108/2015 764 4,956.00 09/3012015 09111/2015 765 716.00 09/30/2015 09/17/2015 767 901.00 09/30/2015 09/23/2015 769 371.00 09/30/2015 09/23/2015 770 116.06 09/30/2015 Total $31,204.22 Cleared Other Items Date Tran # 09/1012015 JE 247214 09125/2015 RC 1342819 Total Notes NEB #2849 check clearing difference Returned item 10009559 Amount Date Cleared 496.93 09/30/2015 - 371.00 09/3012015 $125.93 10/1/15 HRA OF COLUMBIA HEIGHTS Date 9/30/15 Page 1 PARKVIEW VILLA NORTH - Primary Account @XXXXX @6456 C/O COMMONBOND COMMUNITIES Enclosures 38 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C 0 U N T S - - -- Date NORTHEAST BANK'S ANNUAL PRIVACY NOTICE Date IS AVAILABLE ON OUR WEBSITE AT WWW.NORTHEASTBANK- MN.COM 9/01 OR YOU MAY REQUEST A COPY BE MAILED TO YOU 9/02 9/01 BY CALLING 612 - 379 -8811. 294.00 NO CHANGES HAVE BEEN MADE TO OUR PRIVACY NOTICE THIS YEAR. DDA REGULAR DEPOSIT MEMBER FDIC 9/03 NORTHEAST PUBLIC FUNDS ACCT Number of Images 38 Account Number @XXXXX @6456 Statement Dates 9/01/15 thru 9/30/15 Previous Balance 193,403.49 Days in the Statement Period 30 9 Deposits /Credits 31,204.22 Average Ledger 196,163 30 Checks /Debits 64,442.73 Average Collected 197,072 Electronic Debit .00 DEPOSIT 116.06 Service Charge .00 DDA REGULAR DEPOSIT Interest Paid .00 Ending Balance 160,164.98 Deposits and Credits Amount Date Check# Date Description 2838 Amount 9/01 DDA REGULAR DEPOSIT 128.16 9/02 9/01 DDA REGULAR DEPOSIT 294.00 193.38 9/01 DDA REGULAR DEPOSIT 9,487.00 9/10 9/03 DDA REGULAR DEPOSIT 14,235.00 2843* 9/08 DDA REGULAR DEPOSIT 4,956.00 9/11 DDA REGULAR DEPOSIT 716.00 2851 9/17 DDA REGULAR DEPOSIT 901.00 223.73 9/23 DDA REGULAR DEPOSIT 116.06 * Indicates skip 9/23 DDA REGULAR DEPOSIT 371.00 Charges and Debits Date Description 9/25 RETURN ITEM DEBIT Amount 371.00 Checks in serial order Date Check# Amount Date Check# Amount 9/02 2838 46.05 9/04 2847* 14,125.00 9/02 2839 401.39 9/10 2848 193.38 9/03 2841* 61.29 9/10 2849 2,000.00 9/01 2843* 738.10 9/09 2850 113.85 9/01 2844 69.00 9/09 2851 156.98 9/02 2845 223.73 9/14 2852 9.60 * Indicates skip in check numbers w- I Date 9/30/15 Page 2 Primary Account @XXXXX @6456 Enclosures 38 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 9/15 2853 738.10 9/25 2863 110.80 9/25 2854 6,141.88 9/25 2864 265.66 9/25 2855 19,125.00 9/30 2866* 339.48 9/29 2856 61.29 9/28 2868* 2,597.61 9/26 2858* 8,734.12 9/30 2869 738.10 9/26 2859 414.00 9/29 2870 149..53 9/24 2860 69.00 9/29 2872* 100.00 9/25 2861 223.08 9/29 2873 6,015.39 9/29 2862 110.32 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 9/01 202,505.55 9/10 204,374.88 9/24 205,662.24 9/02 201,834.38 9/11 205,090.86 9/25 179,424.82 9/03 216,008.09 9/14 205,081.28 9/28 167,679.09 9/04 201,883.09 9/15 204,343.18 9/29 161,242.56 9/08 206,839.09 9/17 205,244.18 9/30 160,164.98 9/09 206,568.26 9/23 205,731.24 * * * E N D O F S T A T E M E N T Payment Summary Bank= 1650pr AND mm /yy= 09/2015- 09/2015 AND All Checks =yes AND Include Voids =All Checks 1 Check Total Bank Check# Vendor Date Amount 165opr - Parkview Villa North 2846 xcel - Xcel Energy 09/11/2015 (6,141.88) 165opr - Parkview Villa North 2847 chc - CommonBond Housing 09/02/2015 14,125.00 165opr - Parkview Villa North 2848 home7 - HD Supply Facilities Maintenance, Ltd. 09/02/2015 193.38 165opr - Parkview Villa North 2849 inte929 - Integrity Cleaning Solutions 09/02/2015 2,496.93 165opr - Parkview Villa North 2850 Ibpm - LBP Mechanical, Inc 09/02/2015 113.85 165opr - Parkview Villa North 2851 summ - Summit Fire Protection 09/02/2015 156.98 165opr - Parkview Villa North 2852 chc - Common and Housing 09/09/2015 9.60 165opr - Parkview Villa North 2853 kone - Kone Inc. 09/09/2015 738.10 165opr - Parkview Villa North 2854 xcel - Xcel Energy 09/11/2015 6,141.88 165opr- Parkview Villa North 2855 coluhra - Columbia Heights HRA 09/17/2015 19,125.00 165opr - Parkview Villa North 2856 comc3517 - Comcast 09/17/2015 61.29 165opr - Parkview Villa North 2857 dire - Direct Home Appliance Services 09/17/2015 580.38 165opr - Parkview Villa North 2858 inte929 - Integrity Cleaning Solutions 09/17/2015 8,734.12 165opr - Parkview Villa North 2859 koc17025 - K O Cleaning and Remodeling, Inc. 09/17/2015 414.00 165opr - Parkview Villa North 2860 mndpl - MN Dept of Labor & Industry 09/17/2015 69.00 165opr - Parkview Villa North 2861 Popp - Popp.com 09/17/2015 223.08 165opr - Parkview Villa North 2862 sher4110 - Sherwin- Williams Co. 09/17/2015 110.32 165opr - Parkview Villa North 2863 1:0003983 - Aus 09/17/2015 110.80 165opr- Parkview Villa North 2864 tran - Tans -Alarm Inc 09/17/2015 265.66 165opr- Parkview Villa North 2865 adam - Adam's Pest Control, Inc. 09/23/2015 75.23 165opr- Parkview Villa North 2866 drai7740 - Drain King, Inc. 09/23/2015 339.48 165opr- Parkview Villa North 2867 home7 - HD Supply Facilities Maintenance, Ltd. 09/23/2015 195.37 165opr- Parkview Villa North 2868 inte929 - Integrity Cleaning Solutions 09/23/2015 2,597.61 165opr- Parkview Villa North 2869 kone - Kone Inc. 09/23/2015 738.10 165opr- Parkview Villa North 2870 parkl - Park Supply of America, Inc. 09/23/2015 149.53 165opr- Parkview Villa North 2871 proj - Project One Construction, Inc. 09/23/2015 940.47 165opr- Parkview Villa North 2872 t0005325 - Loadtra 09/23/2015 100.00 165opr- Parkview Villa North 2873 xcel - Xcel Energy - 09/23/2015 6,015.39 165opr- Parkview Villa North 2874 cent - CenterPoint Energy 09/30/2015 463.83 165opr- Parkview Villa North 2875 home7 - HD Supply Facilities Maintenance, Ltd. 09/30/2015 30.18 165opr - Parkview Villa North 2876 inte929 - Integrity Cleaning Solutions 09/30/2015 3,379.27 62,551.95 1 213.46340 Parkview Villa South City of Columbia Heights HRA Expenditures for Fiscal Year 2015 - Parkview Villa North & South 36,108 4,012 48,144 as of September 2015 Supplies 6,721 183 Account Object Code Classification Actual YTD Actual MTD Budget Balance 182,700 203.46330 Parkview Ville North Capital Outlays 0 0 0 Personnel Services 80,361 8,929 107,148 26,787 Supplies 10,417 1,220 25,431 15,014 Other Services & Charges 274,303 52,126 390,923 116,620 Capital Outlays 0 - 0 0 Totals 203.46330 365,081 62,275 523,502 158,421 213.46340 Parkview Villa South Personnel Services 36,108 4,012 48,144 12,036 Supplies 6,721 183 15,941 9,220 Other Services & Charges 116,448 24,108 182,700 66,252 Capital Outlays 0 0 0 0 Totals 213.46340 159,277 28,303 246,785 87,508 (S-S Parkview Villa South Financial Statement Overview July 2015 Revenue: Occupancy for the month of July was 84% occupied Total Revenue was under budget (unfavorable) and reflects occupancy Administrative Expenses: Administrative costs for South were under budget (favorable). General Office Supplies were under budget (favorable) Utilities: Utilities Expenses were under budget (favorable); however, this reflects some quarterly billings Electric was slightly over budget (unfavorable) and reflects June invoices Gas was under budget (favorable) and reflects June billing Water was over budget (unfavorable) and reflects quarterly billing Sewer was over budget (unfavorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflects contract cleaning Maintenance Supplies was under budget (favorable) Grounds Contract was over budget (unfavorable) reflects June and July invoices §2§ } §§ I § § {/§ § B , 'm § $ 2 @ 0, co || 77$ \F� \| °7 ` ( �� k - 2 § ) ) e §-! _ k k /� � Bak \ , = § k m - \ /§) / @ (2§R k a§ m � § § \/ k k Ie@E@ k& m ! } \ /j\ t\\ \ \ § § \) \ O) N N O V N j n a 3 m 0 1 a . W °-�'. � J R o 0 $ m G) 0 _ z_ J o O O< W d K >> W d y W m J d n N o- N W W C W d Moo 0 N W a C d N m 0 a J ffi N W � N N A + N W N p V NPN N N � Ja (4(�f1 0 0 O O W O V O O w O O O O O A Ol N m (O N lVJ (VJ O m O N O O O O (p Cm N A A m m tp V O m N W (T W W M O N O O M O O W (T W N IO O V A T f.J W m Cl O O G1 O C C D) O O O O O 6I O IIIIIIII0000 OJ N N V W W V V O O V O (D O V O O CD I N ! N O) A A W V A O !p A O) A N O N Co N+ W V A Wl W N O O V O O O N W N O N I O O O O O N W pt V� O W O O O O O 0 0 0 O A W t0 N N A Qr O Z N O O O O O O O O O W V W O Co N Cu C1 O O� t9 O G G O UN :6< O O O O O W O OI N N N N faJ O N D N O O O O V; V N A O tO N + tWD ap O pmp N N V tW0 V UNi �p1 O 0) OD W V V V+ W N O A W+ N W+ N Ol V A N O 0) O N po A W O W V ro V ;'. ;,a A+ V+ W W N O 0) O V O T o O N W N 16 N N t0 T W W OI Ol O O D) O OI O go O N O O Z O R O) N A t0 + t0 ID O O [p O 41 O tp O O O) O O (p OR N O Oo A V O) O 01 t0 fJ N V W O V f0 N N N V 0) W IV fN N N W D7 N <l� G Ja tP C O m V t`� 0) W V N 0 O V O N V N 0) IV W W O A D7 O O O O WWW j I O t0 + N y O O] O] 01 V V OJ (tl (O CO T 2 2 (W�� ppD1 P W N O W (O O M� fp + C1 O N A N N <!N O N UI y N N N 91 0 0 O O O O O O V N m W O O O jS V ro N N N O O O O O O O O O (J O O O O V O O) O O T C O O O O 00 m 3a o0 000 00 00 00 00 0 0j. v 3 0 m W T C Of D) N N N W A A Q A M W p� p� p� p p� C W w W W w W IO C W W N N t ++ M W W W W W W W 1 11 I t0 N 3 d 9 W a C pm �.ppmi rn rn� N q rnrn mm N rn m A A rn A m rnm A A W O s CL o�� N V fWfppi W O iJ f0 O foil V (N O T O) n Nn 3 C d q m y 0 d d O 00 1 d j 3 m m w n 0 m d t�' Q of Li' a Pf 0 j C d > j X M M d y n m o d a^ 0 '00 d o o T d_; C O n y n 90 n WO o 41 o tA.1 Ol N O O O m o O O O o O o � o VJ A ^! O C G 0 O O O .OWi,;2 O ip V Cm fd m oo v to o000 00 0 o a) � A O O A A O W tNT O W N Omi O W fAJ N A Ilk" V 8 o V V 8 IJ lf� A O o O o O O O O O) O V O O Oo V tT !J fT O a0 i� C O O O O A m yq �l 4 O W W V N A OVD ANT M O tND OOO ro V V O A (O 0 0 0 0 J O fmnl N (V cNp 0 I i m al N m 54 741 V f5i,f�ll A w A N oa po 000kao o? o O N V f1D 0 0 0 W O D O O+ A (m (A O O W tp fA (O A W D7 O W fn tD N t!t !. pAA i + Ijj(( N fT t>t V V m W N N N V +V l0 V IJ !J V V O m p� + p1 Cn Cf W po IU IJ A ? R1 !O p W O N fp N O f0 A A V (T V N W V fA O W (T G p O m O 0 V 0 0 0 0 A 0 O O ONi 0 0 0 _ _ i I f0 �O iT lT tO W O A O 4l tp W f0 tli O O� A (T (A Co W (:u W W N A O O Oi N + 'm (� ffO�� yNyf I O (D V f�l + N °o A N V O i� y (5 t!t O W V N m A A W O N O+ A e m O N j� T I Y y S� N t0 t0 y + N - i3 p (J) fA + a + W (ll N N N O o IV G W A W 01 <!t <l� df V fP tD V N y O p O O O O 0 O O oN O O O O O O O O O O O fJ m O O O O O O O O O 0 0 0,— m ti J 2 o Y V S mtpp +� A � � O O O t00 o t f0 �O�OppD OJ N V S O N � m f0J T 2 m m im 00 m WS- � m W rn nZ mm �6 1OO m� 00 O 5 am 29 mp1 R 93 G T6 3 ^T Z m m N^ Z m 3C m N T ? f0 W W W twp y y Q m m G 0 m a m V V p m O O S O N m N c m m g m op - n '3 J 9 - O a T m m im O uNi m' 0 0 0 0 w n m N N N G o W O o O o N m N N f0 W W W twp O T C C G O G m V V p m O O S O N m N rn m a cm in � W m N o m W w w w m < V V fA O) dD W OVl A O S O N a m O O O O O N m fNT N m w vwi m a m m W 001 tNT N UNi m S A O O O 5D 0 0 O O A O O O O O S m - n '3 J 9 - O a L 0 O N L Z 3 m L Y m � a�aN S L O 2, E N o ° � o U > y ° m m N `o N d C OJ Q W Q S N N N d N 67 y coror c v�Om m ao OJ r M V M N � V m y �vio Q1 O N m '6 J m m v M M A a M M (O O �y N v 1 C O L U - O y Z N tp w � � N U > ° � 3 L U x u a7 N O. (n u a O > )c N N d N � � L a u7 O L S O y o m M N r N o m o0 v °o m r tD N N V � m N r r o O � OMJ V N V N r O V � N N N N W N m N L U U m m U d � rn O Ell c M � ° u v v u ri ri a N N o m M N r N o m o0 v °o m r tD N N V � m N r r o O � OMJ V N V N r O V � N N N N W N m N L U U m m U d � rn O Ell ParkviewMlla -South Balance Sheet July 2015 Books = Accrual Assets 10100 Cash Balance 143,339.11 10200 Petty Cash 93.00 10400 Investments 839,752.82 11300 Rent Receivable 1,853.43 11500 Accounts Receivable 31.00 13100 Due From Other Funds 0100 Total Assets 985,069.36 Liabilities 20200 Accounts Payable 7,690.51 20210 Accrued Other Expenses 6,042.80 22000 Deposits 8,566.25 22200 Accrued PILOT 6,606.60 22210 Revenue Collected in Advance 383.38 Total Liabilities 29,289.54 Fund Balance 25300 Fund Balance 955,779.82 Total Fund Balance 955,779.82 Total Liabilities and Fund Balance 985,069.36 Parkview Villa -South Income Statement July 2015 Books = Accrual Month to Date % Year to Date % Revenue 36220 -46340 Gen. Government Rents 25,256.00 97.03% 180,712.45 97.19% 36225-46340 Nondwelling Rents 470.20 1.81% 3,602.20 1.94% 36290 -46340 Other Miscellaneous Revenue 303.00 1.16% 1,625.25 0.87% 39120 -46340 Recovery Damage City - 0.00% 250.21 0.00% Total Revenue 26,029.20 100.000/0 185,939.90 100.00% Expenses Personal Services 1000 -46340 Accrued Salaries 4,012.00 15.41% 28,084.00 15.10% Total Personal Services 4,012.00 15A1078 28,084.00 15.10% Supplies 2,168.00 8.33% 15,176.00 8.16% 2000 -46340 Office Supplies 19.29 0.07% 250.21 0.13% 2010 -46340 Minor Equipment 0.00 0.00% 0.00 0.00% 2160 -46340 Maint. & Construct Materials 0.00 0.00% 2,744.72 1.48% 2171 -46340 General Supplies 87.36 0.34% 3,427.63 1.84% Total Supplies 106.65 0.41% 6,422.56 3A5% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 0.00 0.00% 3050 -46340 Expert & Professional Services 0.00 0.00% 0.00 0.00% 3060 -46340 Management Services 2,168.00 8.33% 15,176.00 8.16% 3100 -46340 Protective Services 0.00 0.00% 76.72 0.04% 3210 -46340 Telephone & Telegraph 127.46 0.49% 993.56 0.53% 3430 -46340 Advertising Other 0.00 0.00% 2,112.00 1.14% 3600 -46340 Insurance & Bonds 820.08 3.15% 5,740.56 3.09% 381046340 Electric 2,400.73 9.22% 13,100.34 7.05% 3820 -46340 Water 1,177.02 4.52% 2,199.34 1.18% 3830 -46340 Gas 254.69 0.98% 8,996.43 4.81% 3840 -46340 Refuse 0.00 0.00% 2,528.17 1.36% 3850-46340 Sewer 593.28 2.289/6 1,111.08 0.60% 4000 -46340 Repair &Maint Services 4,445.39 17.08% 22,837.08 12.28% 4100 -46340 Rents & Leases 0.00 0.00% 120.00 0.06% 4300 -46340 Miscellaneous Charges 0.00 0.000/0 229.77 0.12% 4315.46340 PILOT 943.80 3.63% 6,606.60 3.55% 4390 -46340 Taxes & Licenses 0.00 0.00% 569.47 0.31% 4500 -46340 Administrative Expenses 0.00 0.00% 99.37 0.05% 4850 -46340 Interest on Deposits 6.98 0.03% 50.27 0.03% Total Other Services & Charges 12,937.43 49.700/0 82,546.76 44.39% me 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 17,056.08 65.53% 117,053.32 62.950/0 8,973.12 34.47% 68,886.58 37.050% Parkview Villa South (166) Cash Flow Statement Period = July 2015 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 Malnt. & Construct Materials 2171 General Supplies 2175 Food Supplies Total Supplies Other Services & Charges 3040 Legal Fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maim. Services 4050 Garage, Labor Burd. 4100 Rents & 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 25,256.00 470.20 303.00 0.00 26,029.20 4,012.00 4,012.00 19.29 0.00 0.00 87.36 0.00 106.65 0.00 0.00 2,168.00 0.00 127.46 0.00 820.08 2,400.73 1,177.02 254.69 0.00 593.28 4,445.39 0.00 0.00 0.00 943.80 0.00 0.00 6.98 12,937.43 17,056.08 /0 Parkview Villa South (166) Cash Flow Statement Period = July 2015 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 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 8,973.12 0.00 (75,000.00) (532.43) (6.00) 0.00 0.00 880.93 820.08 (423.31) 943.80 (222.00) (73,538.93) (64,565.81) Beg Cash End Cash Difference 207,904.92 143,339.11 (64,565.81) 93.00 93.00 - 839,752.82 839,752.82 1,047,750.74 983,184.93 (64,565.81) Parkview Villa South (166) General Ledger Period = Jul 2015 Book = Accnial ; Tree = ysi_to Proper Date Person /Description Reference Debit 1000 -46340 Accrued Salaries 166 7/31/2015 :PostRecurring Recurring RC 4,012.00 Net Change= 4,012.00 2000 -46340 Office Supplies 166 6/29/2015 HD Supply Facilities Maintenancn9138507088 19.29 38.77 48.59 Credit Net Change =19.29 2160 -46340 Maint. & Construct Materials 0.00 Net Change =0.00 2171 -46340 General Supplies 166 7/17/2015 Buckeye Cleaning Centers (buck902640 166 7/21/2015 HD Supply Facilities Maintenance 9139029913 Net Change =87.36 3060 -46340 Management Services 166 7/30/2015 CommonBond Housing (chc) 073015mgmt 166 7/31/2015 :PostRecurring Recurring RC 0.00 Net Change= 2,168.00 3100 -46340 Protective Services Net Change =0.00 3210 -46340 Telephone & Telegraph 166 6/30/2015 Popp.com (popp) 992273322 166 7/2/2015 Comcast(comc3517) 877210505019618 0.00 Net Change= 127.46 3430 -46340 Advertising Other Net Change =0.00 3600 -46340 Insurance &.Bonds 166 7/31/2015 :PostRecurring Recurring RC Net Change= 820.08 3810 -46340 Electric 19.29 38.77 48.59 Credit Balance Remarks 24,072.00 = Beginning Balance 0.00 28,084.00 R/C CHC PR Mgmt Fee 28,084.00 = Ending Balance = 0.00 230.92 = Beginning Balance 0.00 250.21 magnet clip 250.21 = Ending Balance = 2,744.72 = Beginning Balance = 2,744.72 = Ending Balance = 3,340.27 = Beginning Balance 0.00 3,379.04 roll towel 0.00 3,427.63 TP /twls /cleaners 3,427.63 = Ending Balance = 0.00 13,008.00 = Beginning Balance 6,180.00 0.00 19,188.00 mgmt fee 07/15 0.00 4,012.00 15,176.00 R/C CHC PR Mgmt Fee 99.93 27.53 820.08 166 7/13/2015 Xcel Energy (xcep 5150441553 07/13 2,400.73 Net Change= 2,400.73 3820 -46340 Water 166 7/10/2015 City of Columbia Heights (colu) 31802650001 07/1 1,177.02 Net Change = 1,177.02 3830 -46340 Gas 166 7/10/2015 CenterPoint Energy (cent) 55271324 07/10/1 254.69 Net Change= 254.69 /U\ 15,176.00 = Ending Balance = 76.72 = Beginning Balance = 76.72 = Ending Balance = 866.10 = Beginning Balance 0.00 966.03 phone /net - 06/01 - 06/30, 0.00 993.56 net- 07/11 - 08/10/15 993.56 = Ending Balance = 2,112.00 = Beginning Balance = 2,112.00 = Ending Balance = 4,920.48 = Beginning Balance 0.00 5,740.56 C of Columbia Heights Ir 5,740.56 = Ending Balance = 10,699.61 = Beginning Balance 0.00 13,100.34 E- 06/06- 07/07/15 13,100.34 = Ending Balance = 1,022.32 = Beginning Balance 0.00 2,199.34 w 3/27- 6/29/15 2,199.34 = Ending Balance = 8,741.74 = Beginning Balance 0.00 8,996.43 G- 06/08- 07/08/15 8,996.43 = Ending Balance = /U\ 3840 -46340 Refuse 2,528.17 = Beginning Balance - Net Change =0.00 2,528.17 = Ending Balance = 3850 -46340 Sewer 517.80 = Beginning Balance- 166 7/10/2015 City of Columbia Heights (colu) 3180265000107/1 593.28 0.00 1,111.08 s 3/27 - 6/29/15 Net Change = 593.28 1,111.08 = Ending Balance = 4000 -46340 Repair & Maint. Services 18,391.69 = Beginning Balance - 166 1/29/2015 Direct Home Appliance Services 12915165166 58.59 0.00 18,450.28 laundry appliance repair 166 6/12/2015 Drain King, Inc.(drai7740) 96211 204.29 0.00 18,654.57 cable /jet line- 06/15/15 166 6/19/2015 Integrity Cleaning Solutions lint 61920153 420.23 0.00 19,074.80 land care 166 6/19/2015 Drain King, Inc. (drai7740) 95775 104.78 0.00 19,179.58 drain line clear- 06/18/1: 166 6/25/2015 K 0 Cleaning and Remodeling, 13456 23.25 0.00 19,202.83 crack repair 166 6/25/2015 K O Cleaning and Remodeling, 13457 279.00 0.00 19,481.83 paint/finish /replace shee 166 6/25/2015 K 0 Cleaning and Remodeling, 13455 77.50 0.00 19,559.33 painting 166 6/26/2015 Integrity Cleaning Solutions (int 6262015 258.27 0.00 19,817.60 caretaking - 06/23- 06/26, 166 6/26/2015 Integrity Cleaning Solutions (int 62620152 99.97 0.00 19,917.57 groundskeeping- 06/23 -( 166 7/1/2015 Integrity Cleaning Solutions lint 70120151 91.64 0.00 20,009.21 cleaning 166 7/1/2015 Integrity Cleaning Solutions lint 70120152 98.31 0.00 20,107.52 cleaning 166 7/3/2015 Integrity Cleaning Solutions (int 70320152 274.93 0.00 20,382.45 caretaking- 06/29- 07/03, 166 7/3/2015 Integrity Cleaning Solutions (int 7032015 99.97 0.00 20,482.42 groundskeeping- 06/29 -( 166 7/10/2015 Integrity Cleaning Solutions (int 71020151 258.26 0.00 20,740.68 caretaking- 07/06- 07/10, 166 7/10/2015 Integrity Cleaning Solutions lint 710201518 99.97 0.00 20,840.65 groundskeeping- 07/06 -C 166 7/14/2015 Integrity Cleaning Solutions lint 71420151 83.23 0.00 20,923.88 cleaning 166 7/14/2015 Integrity Cleaning Solutions (int 71420152 83.23 0.00 21,007.11 cleaning 166 7/17/2015 Integrity Cleaning Solutions (int 7172015 258.26 0.00 21,265.37 caretaking- 07/13- 07/19, 166 7/17/2015 Integrity Cleaning Solutions lint 71720152 99.97 0.00 21,365.34 groundskeeping - 07/13 -C 166 7/23/2015 Integrity Cleaning Solutions (int 7232015 980.22 0.00 22,345.56 misc grounds svcs -31% 166 7/24/2015 Integrity Cleaning Solutions lint 72420153 116.63 0.00 22,462.19 cleaning #801 166 7/24/2015 Integrity Cleaning Solutions (int 72420151 258.26 0.00 22,720.45 caretaking -31% 7/20 -24 166 7/24/2015 Integrity Cleaning Solutions (int 72420152 116.63 0.00 22,837.08 groundskeeping 07/20 -C Net Change = 4,445.39 22,837.08 = Ending Balance = 4100 -46340 Rents & Leases 120.00 = Beginning Balance Net Change =0.00 120.00 = Ending Balance = 4300 -46340 Miscellaneous Charges 229.77 = Beginning Balance Net Change =0.00 229.77 = Ending Balance = 4315 -46340 PILOT 5,662.80 = Beginning Balance = 166 7/31/2015 :PostRecurring Recurring RC 943.80 0.00 6,606.60 Anoka Cty Property Tax Net Change = 943.80 6,606.60 = Ending Balance = 4315 -46340 Taxes & Licenses 569.47 = Beginning Balance : Net Change =0.00 569.47 = Ending Balance = 4500 -46340 Adminstrative Expenses 99.37 = Beginning Balance = Net Change =0.00 99.37 = Ending Balance = 4850 -46340 Interest on Deposits 43.29 = Beginning Balance = 166 7/31/2015 Sec dep interest accrual Cil1 6.98 0100 50.27 Sec dep interest accrual Net Change =6.98 50.27 = Ending Balance = 21,068.08 4,012.00 13 Parkview Villa South Payment Summary Jul -15 14,786.81 Check Total Bank Check# Vendor Date Amount 166opr - Parkview Villa South 2432 home7 - HD Supply Facilities Maintenance, Ltd. 07/01/2015 132.85 1660pr - Parkview Villa South 2433 inte929 - Integrity Cleaning Solutions 07/01/2015 343.52 166opr - Parkview Villa South 2434 chc - Common Bond Housing 07/08/2015 6,189.44 1660pr - Parkview Villa South 2435 home7 - HD Supply Facilities Maintenance, Ltd. 07/08/2015 44.64 166opr - Parkview Villa South 2436 sher4110 - Sherwin- Williams Co. 07/08/2015 99.13 166opr - Parkview Villa South 2437 10003802 - Larson 07/08/2015 382.52 166opr - Parkview Villa South 2438 dire - Direct Home Appliance Services 07/15/2015 58.59 166opr- Parkview Villa South 2439 drai7740 - Drain King, Inc. 07/15/2015 309.07 166opr - Parkview Villa South 2440 home7 - HD Supply Facilities Maintenance, Ltd. 07/15/2015 19.29 166opr - Parkview Villa South 2441 comc3517 - Comcast 07/22/2015 27.53 1660pr- Parkview Villa South 2442 inte929 - Integrity Cleaning Solutions 07/22/2015 1,343.32 166opr - Parkview Villa South 2443 koc17025 - K O Cleaning and Remodeling, Inc. 07/22/2015 379.75 166opr - Parkview Villa South 2444 Popp - Popp.com 07/22/2015 99.93 166opr- Parkview Villa South 2445 cent- CenterPoint Energy 07/29/2015 254.69 166opr - Parkview Villa South 2446 colu - City of Columbia Heights 07/29/2015 1,770.30 1660pr - Parkview Villa South 2447 home7 - HD Supply Facilities Maintenance, Ltd. 07/29/2015 48.59 166opr - Parkview Villa South 2448 inte929 - Integrity Cleaning Solutions 07/29/2015 882.92 166opr - Parkview Villa South 2449 xcel - Xcel Energy 07/29/2015 2,400.73 14,786.81 Parkview Villa South Financial Statement Overview August 2015 Revenue: Occupancy for the month of July was 84% occupied Total Revenue was under budget (unfavorable) and reflects occupancy Administrative Expenses: Administrative costs for South were under budget (favorable). General Office Supplies were under budget (favorable) Utilities: Utilities Expenses were under budget (favorable); however, this reflects some quarterly billings Electric was slightly over budget (unfavorable) and reflects July invoices Gas was under budget (favorable) and reflects June billing Water was under budget (favorable) and reflects quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflects contract cleaning Maintenance Supplies was under budget (favorable) Grounds Contract was over budget (unfavorable) 1.5 A O N O O O O O O O O O O O W W i W N N N W W Ot O A IV O O N W O N N N O W W W O A N O O N W O O O O N O O O tOJ O O O N N O + t0 N + W O O N O O O O O O O O A O O W N W O W V O O O (u O O O W O O A o W O V O N O W O O O W O N W N O O N m 2 W A V O N A W O i s o 0 0 0 N (tW 8 0 0 O O W A pO O P O o O O O 0 O 0 tWii o N N O W W W Oi O O N O C C O O O 0 0 0 O O L V Z Z O N V O D D O N N V V N V V N A 4V1 OWI O W O O 0 O N N (qNJ + O O O O O O O O O O A W V A O V N fn O� o fV11 O O N O f0 N Z W O m N + + pp 0 0 00 0 O O N N A A V m m W S S O O O O O O W W W IJ N A V A A o w OI OI V (WJ CI GI O O. I tNil I N V 81 �� W W W W I OII O A W W A N fA0 I �N A A 4l 41 W m W W N A W W O N Np N N 0 O O fD W W N (O W W W O O S rn A NI N A fffJJJ IIIIJJO tmm0 N S S Aa b 61 61 a N T � � N A A m OWi OI xI O A O A A O E m b r Ice m? pp I F a CL W W A N pQ (p (((pD (pO� O p a Co £ O O O O N S f0 wow W V W V O O N O 2 < T 2.0= N c m ia v y� m gig m m .. G 9l „ 3 m g c n' m z IWii F' 3 0 vZi m '� A 6 » A Z gN N A N N m Z_ `Z O C n � 3 N m » A O N O O O O O O O O O O O W W i W N N N W W Ot O A IV O O N W O N N N O W W W O A N O O N W O O O O N O O O tOJ O O O N N O + t0 N + W O O N O O O O O O O O A O O W N W O W V O O O (u O O O W O O A o W O V O N O W O O O W O N W N O O N m 2 W A V O N A W O i s o 0 0 0 N (tW 8 0 0 O O W A pO O P O o O O O 0 O 0 tWii o N N O W W W Oi O O N O C C O O O 0 0 0 O O L V Z Z O N V O D D O N N V V N V V N A 4V1 OWI O W O O 0 O N N (qNJ + O O O O O O O O O O A W V A O V N fn O� o fV11 O O N O f0 N Z W O m N + + pp 0 0 00 0 O O N N A A V m m W S S O O O O O O W W W IJ N A V A A o w OI OI V (WJ CI GI O O. I tNil I N V 81 �� W W W W I OII O A W W A N fA0 I �N A A 4l 41 W m W W N A W W O N Np N N 0 O O fD W W N (O W W W O O S rn A NI N A fffJJJ IIIIJJO tmm0 N S S Aa b 61 61 a N T � � N A A m OWi OI xI O A O A A O E m b r Ice OM i N N VNi tNT N > (AlNi N N O m lW0 V A tWT A N W W W N N+ C f001 p N N mow V N 4 1 W N + O W N V O V O O 0 0 0 A+ V W N N A 00 am" A OJ am O m O V N 0N am— t N N N A j W m . N W N W W T C V A OI u tJ C� W N N V W W V N A" A a" A O W A A W W N N N O) N am O T V + A O lD O A O A O O lIN (J O Of O N (O N V M" N A N V N N O O J W t0 W N N O A V fOJ N V A N W + W V (WT ONi � OOi N W rn o W W rn m w A O m m A A A N W + IV G N W N N V O W A W N N N N N N V N V A m N J N W N A M 3 0 o a N O o < wG 3 N+ N 0 W cc y ^ 6 w w w N+ q O IV O V W O O N 0 c� �� m ow t6 O 9 U O w N 0 0 0 T V fa+ P FD w tNp N V W N N A 00 am" A OJ am O m O V N 0N am— t N N N A j W m . N W N W W T C V A OI u tJ C� W N N V W W V N A" A a" A O W A A W W N N N O) N am O T V + A O lD O A O A O O lIN (J O Of O N (O N V M" N A N V N N O O J W t0 W N N O A V fOJ N V A N W + W V (WT ONi � OOi N W rn o W W rn m w A O m m A A A N W + IV G N W N N V O W A W N N N N N N V N V A m N J N W N m O S N O m 'mv C C 03 N . = Q y N M O. w j 0 N N O V Vm O O O N O � O w f0 A + N p+p� UJ O W O V O O V O O J + N N N cp N t0 OIIO A T W O V V w 41a O M O W O (O O N8 O W O O r O m m w O V w W V (o N P W V + A N O) G A A W m W O O W O (wp o o w o (O N W N N N + t0 O! W N W Ja W W W A O N d N V N N W N NN O N W N fjV1 A V T O O O O O O O O O O O g0 0 0 0 o 0 0 0 m m o ' Sq m mw y�K ET ;u --I> m000+ o 02- 91 m° w' m w .. o x W C+x w w p,m c m m D o w o m Ol W N ifs�� O N+ N 0 W y -4 O V t0 N O N+ q O IV O V W O O O O N N N t0 A A Y O OJ W N 0 0 0 T V fa+ P I tNp N 2 A O m CO A O O �G N (J + ID n N O W O N+ A m'ID W a O O O O o N N N O O O O �m o 0 000 °o a° m O S N O m 'mv C C 03 N . = Q y N M O. w j 0 N N O V Vm O O O N O � O w f0 A + N p+p� UJ O W O V O O V O O J + N N N cp N t0 OIIO A T W O V V w 41a O M O W O (O O N8 O W O O r O m m w O V w W V (o N P W V + A N O) G A A W m W O O W O (wp o o w o (O N W N N N + t0 O! W N W Ja W W W A O N d N V N N W N NN O N W N fjV1 A V T O O O O O O O O O O O g0 0 0 0 o 0 0 0 m m o ' Sq m mw y�K ET ;u --I> m000+ o 02- 91 m° w' m w .. o x W C+x w w p,m c m m D o w o m Ol W N ifs�� m N W + + 00 fOJ O m W O O m O m V W O ro A O O C O C O W _ID N O OJ W N 0 0 0 O N O W N p N N N A O a 00 fOJ A l W O (O A N W N'C O N O O W N W N N c N o b b b o m o V fa+ I tNp N W W A O m CO A O O �G N (J + ID OL) O O+ +� W lNll O A m'ID W O W A co G O O C) m O + W N W O O V W I� iqJ O O A Z N D N O O O + O O O O V �w O A N kq E S V 1 I W N' C f 0 V mw m 0 0 0 O W NI V S Z rn, ° o, ° 0 0 o j.G m N ro D - 0 0 0 O N m fJ I N + T + y J AW W W m O O O O S m a W a xan� 11 II W _03 0 u m R WI O 00 OJON 00= G O an O G O O 0 0 m / O O O O O O O O 0 0 _ W N W O W W O N N N A O a 00 OD O W O O A O W w N o OWi o O A o 0 O V fa+ tNp N W W A O m CO A O O W N W+ (W� W fNJ tWp W N A 0 0 m V S Z rn, ° o, ° 0 0 o j.G m N ro D - 0 0 0 O N m fJ I N + T + y J AW W W m O O O O S m a W a xan� 11 II W _03 0 u m R WI O 00 OJON 00= G O an O G O O 0 0 m / O O O O O O O O 0 0 _ T P 2 � o m V V V m m Ol N V tVp p W O W fWp W N O W r O O O O (N O p O 0 0 W V A V V O O ti V O O o 0 9. x 0 A o c 00 � "1 N i 3 w % Jg 3 00 o m w m d T O O Nm po NN c d d om d it c of of fkiJC A a0, v o y a Jl Jm mo 3 mQ""'� o. P. iJa N N 0 N < N O o d. ? j! _T OO J d,� M. d � r m y amS pe N dOi � i J ry N W + I y dd dl N OOH A pOq� A V J O +:O fAJ A W m W m N W O O O O O O O O O O O O N T C A O m W O O m °o o m S O m Oo W + N O N N N O 8 e W d CL � C �% N O m �3 F a ry ai m m m m m m rn m W m! m m m m A A A A A W N O O O O O (N O p O 0 0 W V A V V O O V V O O o 0 9. m m 0 A o c O o o big dap 0 m 00 o m w m d T O O Nm po NN c d d om d m c of of fkiJC A a0, v o y a Jl Jm mo 3 mQ""'� o. P. iJa N N 0 N < N O o d. ? j! _T OO J d,� M. O A A N A N Q N dOi � i J ry N d " W + I O O O N OOH A pOq� A V J O +:O fAJ A m m W m N W O O O O O O O O O O O O N T C A O m W O O W m S O W m O W + N O N N m O W W N A 16 <T W O O O O O O O O m O O m O m V 0 W ,f0 N O t0 w (�dw 1 i + + (pm�1 + OO o pp N b W N m A pN A W O w A O W O O O O O m O O W iT O O O O O Z A N O N m O 00D <n V V N tNJ N (Id W A tVJ N N � 8 e W d CL � C �% N O m �3 F a ry ai m m m m m m rn m W m! m m m m A A A A A W N O O O O O (N O p O 0 0 W V A V 0 0 0 0 0 0 0 0 O N Op J V N dpi N N O O': 0 0 o 0 9. m m 0 0000 o c O o o big dap 0 0 00 0 0 QJ d T O O m V (A d 2 w m it e nip NN c d d Jd J JN d m c of of fkiJC A a0, v o y a Jl Jm mo 3 mQ""'� o. P. iJa N N 0 N < N O o d. ? j! _T OO J d,� M. p On N dOi � i J ry N d " W I IV N +:O W i 0 0 0 0 0 0 0 o w W O O O O O O O O O O O O N T C A O m W !O VO N+ W W V G W W + N O N N m O W W N A 16 <T W O O O O O O O O m O O m O m V 0 W ,f0 N O t0 w (�dw 1 i + + N W Oi O N U N O A O !4'6 J , N N '.? O N O O O O O W O w A O W O O O O O m N O O lyE iT O O O O O Z A N O N m °0000000 00D °o rn(m A N N A N N AAA W A m m N V N W O i W N N N t0 V W A N W i W m O W V N W O W C IJ O V 41 N Ji O O N m <lN (O N W 'I fJ O O O O O V m N O N':I 0000 00 OOA� O O O O O O A O O N L W + + i W m m � [NO VNi i W O O N ONO M VA i V W V O O W O W J N NI W+ m O ja m V N N A V j O A A O A N d m A O m w w w m i m N N N O m m t0 [O m � M N O O O O O (N O p O 0 0 W V A V 0 0 0 0 0 0 0 0 O N Op J V N dpi N N O O': 0 0 o g o 0 0 0 0000 o c O o o big 0 0 0 00 0 0 0000 00 0 000;! M y C o � /q a 3 z 05 $z �m m 0W mb 'ma c T wH m mo w m N> yO O c o z C m m O N N w O m Q c m m � m o m N � a m m is O iD V N Vt N U + W tT m O O O O O 6 A lT G tNp O fO O O O O nmn A tNp CO O O o (mV� O O O ON O O O O lVJ ,fVJ J O O O O W m ttWnn A N o w m a a m m w c a pmpt� pwpff mmrn�� NaNb� fOT a A (wii .P A A m A (PN T N O O S O O o A 00 m W � NA N u u a m m m m A O d O O O O O v /q I C)Ocnv o D w w � °m n rn o w w � A W � O O _. N ry O I C)Ocnv -q C)Ocn-0 N C D O m c m O 91 _. N ry O — N 0 O m N m N 'm �...= cn o =- Cl) g N N z N N ?, G 90 F C) N fD W n VNi Ip' O 0 D o 0 Z N m o 0 x o � n C (D N O � C) N � � n � N 91 0 o < n D > m 0 n O N 3 C C O D W N y Cl1 d N O N N N (O p am 00 m V W 00 <U C N Z 0 c � m 90 RD CD 1 0 co C w A N (w0 N O CL to N UI W W O (11 J 1D o A A o N W A ca d N 91 � ocom o mrnowi W A O W J N J R m O A 0 A W m O O A W V O m A D7 WE Parkvlew Villa -South Balance Sheet August 2015 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 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 157,382.35 93.00 839,752.82 684.00 0.00 0.00 997,912.17 7,514.65 6,862.88 8,573.23 7,550.40 215.00 30,716.16 967,196.01 967,196.01 997,912.17 0211 Parkview Villa -South Income Statement August 2015 Books = Accrual Month to Date % Year to Date % Revenue 36220 -46340 Gen. Government Rents 24,736.00 97.63% 205,448.45 97.24% 36225 -46340 Nondwelling Rents 443.00 1.75% 4,045.20 1.91% 36290 -46340 Other Miscellaneous Revenue 157.00 0.62% 1,782.25 0.84% 39120 -46340 Recovery Damage City - 0.00% 2,744.72 0.00% Total Revenue 25,336.00 100.00% 211,275.90 100.00% Expenses Personal Services 1000 -46340 Accrued Salaries 4,012.00 15.84% 32,096.00- 15.19% Total Personal Servces 4,012.00 15.84% 32,096.00 15.190/b Supplies 0.00 0.00% 0.00 0.00% 2000 -46340 Office Supplies 28.32 0.11% 278.53 0.13% 2010 -46340 Minor Equipment 0.00 0.00% 0.00 0.00% 2160 -46340 Maint. & Construct Materials 0.00 0.00% 2,744.72 1.30% 2171 -46340 General Supplies 86.87 0.34% 3,514.50 1.66% Total Supplies 115.19 0.45% 6,537.75 3.09% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 0.00 0.00% 3050 -46340 Expert & Professional Services 0.00 0.00% 0.00 0.00% 3060 -46340 Management Services 2,168.00 8.56% 17,344.00 8.21% 3100 -46340 Protective Services 70.52 0.28% 147.24 0.07% 3210 -46340 Telephone & Telegraph 128.05 0.51% 1,121.61 0.53% 3430 -46340 Advertising Other 0.00 0.00% 2,112.00 1.00% 3600 -46340 Insurance & Bonds 820.08 3.24% 6,560.64 3.11% 3810 -46340 Electric 2,759.39 10.89% 15,859.73 7.51% 3820 -46340 Water 0.00 0.00% 2,199.34 1.04% 3830 -46340 Gas 180.33 0.71% 9,176.76 4.34% 3840 -46340 Refuse 0.00 0.00% 2,528.17 1.20% 3850 -46340 Sewer 0.00 0.00% 1,111.08 0.53% 4000 -46340 Repair & Maint. Services 2,343.04 9.25% 25,180.12 11.92% 4100 -46340 Rents & Leases 0.00 0.00% 120.00 0.06% 4300 -46340 Miscellaneous Charges 0.00 0.00% 229.77 0.11% 4315 -46340 PILOT 943.80 3.73% 7,550.40 3.57% 4390 -46340 Taxes & Licenses 31.00 0.12% 600.47 0.28% 4500 -46340 Administrative Expenses 341.43 1.35% 440.80 0.21% 4850 -46340 Interest on Deposits 6.98 0.03% 57.25 0.03% Total Other Services & Charges 9,792.62 38.65% 92,339.38 43.71% / ..A Capital Outlay 5120 -46340 Building &Improvements Total Capital Outlay Total Expense 0.00% - 0.00% 0.00 0.000% 0.00 0.000/0 13,919.81 54.94% 130,973.13 61.99% Excess (Deficit) Revenue over Expense 11,416.19 45.06% 80,302.77 38.01% oZ3 Parkview Villa South (166) 0.00 Cash Flow Statement 0100 Period = August 2015 2,168.00 3100 ProteLtive Services Month to Date Revenue 128.05 36220 Gen. Government Rents 24,736.00 36225 Nondwelling Rents 443.00 36290 Other Miscellaneous Revenue 157.00 39120 Recovery Damage City Property 0.00 Total Revenue 25,336.00 Personnel Services 0.00 1000 Accrued Salaries 4,012.00 Total Personnel Services 4,012.00 Supplies 0.00 2000 Office Supplies 2832 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 86.87 2175 Food Supplies 0.00 Total Supplies 115.19 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services 0100 3060 Management Services 2,168.00 3100 ProteLtive Services 70.52 3210 Telephone & Telegraph 128.05 3430 Advertising Other 0.00 3600 Insurance & Bonds 820.08 3810 Electric 2,75939 3820 Water 0.00 3830 Gas 180.33 3840 Refuse 0.00 3850 Sewer 0.00 4000 Repair & Maint. Services 2,343.04 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 0.00 4300 Miscellaneous Charges 0.00 4315 PILOT 943.80 4390 Taxes & Licenses 31.00 4500 Administrative Expenses 341.43 4850 Interest on Deposits 6.98 Total Other Services & Charges 9,792.62 Total Expenses 13,919.81 aiy Parkvlew Villa South (166) Cash Flow Statement Period = August 2015 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 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 11,416.19 0.00 0.00 1,169.43 31.00 0.00 0.00 (175.86) 820.08 6.98 943.80 (168.38) 2,627.05 14,043.24 Cash End Cash 143, 339.11 157, 382.35 14,043.24 93.00 93.00 - 839,752.82 839,752.82 - 983,184.93 997,228.17 14,043.24 A5 2010 -46340 Maint. & Construct Materials Net Change =0.00 2171 -46340 General Supplies 166 8/24/2015 HD Supply Facilities Maintenana9139884782 166 8/24/2015 HD Supply Facilities Maintenano9139884782 Net Change =86.87 3060 -46340 166 8/28/2015 166 8/31/2015 3100 -46340 166 8/18/2015 Management Services CommonBond Housing (chc) 082815mgmt :PostRecurring Recurring RC Net Change = 2,168.00 Protective Services Summit Fire Protection (summ) 1078876 Net Change =70.52 321"6340 Telephone &Telegraph 166 7/31/2015 Popp.com (popp) 992279737 166 8/2/2015 Comcast(comc3517) 877210505019618: Net Change= 128.05 3430 -46340 Advertising Net Change =0.00 3600 -46340 Insurance & Bonds 166 8/31/2015 :PostRecurring Recurring Net Change= 820.08 3810 -46340 Electric 166 8/11/2015 Xcel Energy (xcel) Net Change= 2,759.39 3820 -46340 Water Net Change =0.00 RC 9/11/2015 10:44 AM Balance Remarks 28,084.00 = Beginning Balance = 32,096.00 RIC CHIC PR Mgmt Fee 32,096.00 = Ending Balance = 250.21 = Beginning Balance = 274.23 paper;pens;ink rollers -31% 278.53 TERRI L KANISTARGET 0002 278.53 = Ending Balance = 2,744.72 = Beginning Balance = 2,744.72 = Ending Balance = 3,427.63 = Beginning Balance = 48.25 0.00 3,475.88 cleaner /gloves 38.62 0.00 3,514.50 bibs /Rppr /sup line /sz insrt 3,514.50 = Ending Balance = 6,180.00 0.00 0.00 4,012.00 70.52 0.00 100.52 0.00 27.53 0.00 820.08 515044155308/11, 2,759.39 3830 -46340 Gas 166 8/7/2015 CenterPoint Energy (cent) 55199657 08/07/1` 139.07 166 8/10/2015 CenterPoint Energy (cent) 55271324 08/10/1`. 41.26 Net Change= 180.33 3840 -46340 Refuse Net Change= 0.00 Page 6 of 8 15,176.00 = Beginning Balance = 21,356.00 mgmt fee 08/15 17,344.00 R/C CHC PR Mgmt Fee 17,344.00 = Ending Balance = 76.72 = Beginning Balance = 147.24 troubleshoot alarm- 08/07/1'. 147.24 = Ending Balance = 993.56 = Beginning Balance = 1,094.08 phone -31% 8/15 1,121.61 internet -31% 8/11- 9/10/15 1,121.61 = Ending Balance = 2,112.00 = Beginning Balance = 2,112.00 = Ending Balance = 5,740.56 = Beginning Balance = Parkview Villa South (166) 6,560.64 C of Columbia Heights Ins A< 6,560.64 = Ending Balance = General Ledger 13,100.34 = Beginning Balance = 0.00 15,859.73 E- 07/07- 08/05/15 Period = Aug 2015 15,859.73 = Ending Balance = 2,199.34 = Beginning Balance = Book = Accrual; Tree = ysi_tb 2,199.34 = Ending Balance = Proper Date Person /Description Reference Debit Credit 1000 -46340 Accrued Salaries 9,176.76 = Ending Balance = 166 8/31/2015 :PostRecurring Recurring RC 4,012.00 0.00 Net Change= 4,012.00 2000 -46340 Minor Equipment 166 7/29/2015 HD Supply Facilities Maintenann9139253007 24.02 0.00 166 8/17/2015 US Bank(usba790) 448559455559124' 4.30 0.00 Net Change =28.32 2010 -46340 Maint. & Construct Materials Net Change =0.00 2171 -46340 General Supplies 166 8/24/2015 HD Supply Facilities Maintenana9139884782 166 8/24/2015 HD Supply Facilities Maintenano9139884782 Net Change =86.87 3060 -46340 166 8/28/2015 166 8/31/2015 3100 -46340 166 8/18/2015 Management Services CommonBond Housing (chc) 082815mgmt :PostRecurring Recurring RC Net Change = 2,168.00 Protective Services Summit Fire Protection (summ) 1078876 Net Change =70.52 321"6340 Telephone &Telegraph 166 7/31/2015 Popp.com (popp) 992279737 166 8/2/2015 Comcast(comc3517) 877210505019618: Net Change= 128.05 3430 -46340 Advertising Net Change =0.00 3600 -46340 Insurance & Bonds 166 8/31/2015 :PostRecurring Recurring Net Change= 820.08 3810 -46340 Electric 166 8/11/2015 Xcel Energy (xcel) Net Change= 2,759.39 3820 -46340 Water Net Change =0.00 RC 9/11/2015 10:44 AM Balance Remarks 28,084.00 = Beginning Balance = 32,096.00 RIC CHIC PR Mgmt Fee 32,096.00 = Ending Balance = 250.21 = Beginning Balance = 274.23 paper;pens;ink rollers -31% 278.53 TERRI L KANISTARGET 0002 278.53 = Ending Balance = 2,744.72 = Beginning Balance = 2,744.72 = Ending Balance = 3,427.63 = Beginning Balance = 48.25 0.00 3,475.88 cleaner /gloves 38.62 0.00 3,514.50 bibs /Rppr /sup line /sz insrt 3,514.50 = Ending Balance = 6,180.00 0.00 0.00 4,012.00 70.52 0.00 100.52 0.00 27.53 0.00 820.08 515044155308/11, 2,759.39 3830 -46340 Gas 166 8/7/2015 CenterPoint Energy (cent) 55199657 08/07/1` 139.07 166 8/10/2015 CenterPoint Energy (cent) 55271324 08/10/1`. 41.26 Net Change= 180.33 3840 -46340 Refuse Net Change= 0.00 Page 6 of 8 15,176.00 = Beginning Balance = 21,356.00 mgmt fee 08/15 17,344.00 R/C CHC PR Mgmt Fee 17,344.00 = Ending Balance = 76.72 = Beginning Balance = 147.24 troubleshoot alarm- 08/07/1'. 147.24 = Ending Balance = 993.56 = Beginning Balance = 1,094.08 phone -31% 8/15 1,121.61 internet -31% 8/11- 9/10/15 1,121.61 = Ending Balance = 2,112.00 = Beginning Balance = 2,112.00 = Ending Balance = 2,528.17 = Beginning Balance = 2,528.17 = Ending Balance = U-11 5,740.56 = Beginning Balance = 0.00 6,560.64 C of Columbia Heights Ins A< 6,560.64 = Ending Balance = 13,100.34 = Beginning Balance = 0.00 15,859.73 E- 07/07- 08/05/15 15,859.73 = Ending Balance = 2,199.34 = Beginning Balance = 2,199.34 = Ending Balance = 8,996.43 = Beginning Balance = 0.00 9,135.50 G- 07/07 - 08/05/15 0.00 9,176.76 G- 07/08 - 08/06/15 9,176.76 = Ending Balance = 2,528.17 = Beginning Balance = 2,528.17 = Ending Balance = U-11 Page 7 of 8 9/11/2015 10:44 AM Parkview Villa South (166) General Ledger Period = Aug 2015 Book = Accrual; Tree = ysi_tb Proper Date Person /Description Reference Debit Credit Balance Remarks 3850 -46340 Sewer- 1,111.08 = Beginning Balance = Net Change= 0.00 1,111.08 = Ending Balance = 4000 -46340 Repair & Maint. Services 22,837.08 = Beginning Balance = 166 7/31/2014 LBP Mechanical, Inc ill W20827 _ 51.15 0.00 22,888.23 fuse replace- 07/23 - 07/30/1, 166 6/30/2015 Adam's Pest Control, Inc. (adam 1130770 06/30/15 22.01 0.00 22,910.24 pest control 166 7/31/2015 Integrity Cleaning Solutions(inb 73120151 274.93 0.00 23,185.17 caretaking- 07/27- 07/31/15 166 7/31/2015 Integrity Cleaning Solutions(int173120152 133.30 0.00 23,318.47 groundskeeping -31% 7/27 -3 166 8/1/2015 Kone Inc.(kone) 949058377 331.61 0.00 23,650.08 maint - 08/01- 08/31/15 166 8/7/2015 Integrity Cleaning Solutions (inb80720151 274.93 0.00 23,925.01 caretaking - 08/03- 08/07/15 166 8/7/2015 Integrity Cleaning Solutions(inb80720152 133.30 0.00 24,058.31 groundskeeping -31% 8/3 -7/ 166 8/15/2015 Integrity Cleaning Solutions (int181520153 705.25 0.00 24,763.56 lawn care/mulch /till - 166 8/21/2015 Integrity Cleaning Solutions (inb82120151 274.93 0.00 25,038.49 caretaking 166 8/21/2015 Integrity Cleaning Solutions(inb82120152 141.63 0.00 - 25,180.12 groundskeeping Net Change= 2,343.04 25,180.12 = Ending Balance = 4100 -46340 Rents & Leases 120.00 = Beginning Balance = Net Change=0.00 120.00 = Ending Balance = 4300 -46340 Miscellaneous Charges 229.77 = Beginning Balance = Net Change =0.00 229.77 = Ending Balance = 4315 -46340 PILOT 6,606.60 = Beginning Balance = 166 8/31/2015 :PostRecurring Recurring RC 943.80 0.00 7,550.40 Anoka Cty Property Tax Accr Net Change= 943.80 7,550.40 = Ending Balance = 4390 -46340 Taxes & Licenses 569.47 = Beginning Balance = 166 8/2/2015 MN Dept of Labor & Industry (m ALR0052866I 31.00 0.00 600.47 elevator fee - Net Change =31.00 600.47 = Ending Balance = 4500 -46340 Administrative Expenses 99.37 = Beginning Balance = 166 8/10/2015 Nelson (t0011178) 341.43 0.00 440.80 Deceased Net Change= 341.43 440.80 = Ending Balance = 4850 -46340 Interest on Deposits 50.27 = Beginning Balance = 166 8/31/2015 Sec dep interest accrual G31 6.98 0.00 57.25 Sec dep interest accrual Net Change =6.98 57.25 = Ending Balance = 17,931.81 4,012.00 Page 7 of 8 5016464 Parkview Villa South Bank Reconciliation Report 08/31/2015 Balance Per Bank Statement as of 08/31/2015 04/2912014 2062 t0011071 -Johnson 082612015 2455 cent- CenterPoint Energy 08262015 2456 MM03517- ComCast 0826/2015 2458 kone - Kone Inc. 08/262015 2459 mndpl - MN Dept of Labor & Industry 08262015 2460 Popp - Popp.com 0826/2015 2461 xoel - Xcel Energy Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 08/31/2015 Difference Cleared Items: Cleared Checks Date Tran # 07/082015 2437 07292015 2445 0729/2015 2446 07292015 2447 0729/2015 2448 07292015 2449 08/052015 2450 08/052015 2451 08/052015 2452 08/12/2015 2453 08/1212015 2454 08262015 2457 Total Reconciled Balance Per G/L $161,045.69 232.96 180.33 27.53 331.61 31.00 100.52 2,759.39 $3,663.34 $157,382.35 9/1/15 $157,382.35 $157,382.35 Notes Amount Date Cleared t0003802 - Larson 382.52 08/312015 cent - CenterPoint Energy 254.69 08/312015 colu - City of Columbia Heights 1,770.30 08/312015 home7 - HD Supply Facilities Maintenance, Ltd. 48.59 08131/2015 inte929 - Integrity Cleaning Solutions 882.92 08/312015 xcel - Xcel Energy 2,400.73 08/312015 buck8411 - Buckeye Cleaning Centers 38.77 08/312015 chc - CommonBond Housing 6,180.00 081312015 inte929 - Integrity Cleaning Solutions 1,471.74 08/31/2015 adam - Adam's Pest Control, Inc. 22.01 08/31/2015 home7 - HD Supply Facilities Maintenance, Ltd. 24.02 08/31/2015 inte929 - Integrity Cleaning Solutions 816.46 08/3112015 $14,292.75 wo m Parkview Villa South Bank Reconciliation Report 08/31/2015 5016464 Cleared Deposits Date Tran # Notes Amount Date Cleared 08/03/2015 580 19,683.62 08/3112015 08/03/2015 581 2,653.00 0813112015 08/04/2015 582 650.00 08/31/2015 08/06/2015 583 828.00 08/3112015 08110/2015 584 709.00 08/3112015 08/14/2015 586 1,503.00 0813112015 Total $26,026.62 9/1/15 i I HRA OF COLUMBIA HEIGHTS Date 8/31/15 Page 1 PARKVIEW VILLA SOUTH Primary Account @XXXXX @6464 C/O COMMONBOND COMMUNITIES Enclosures 18 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 3� - - -- C H E C K I N G A C C O U N T S - - -- PLEASE JOIN US FOR OUR COMMUNITY PICNIC: FRIDAY,SEPT. 11TH FROM 11 AM TO 1 PM AT OUR MINNEAPOLIS OFFICE. FREE BRATS, HOT DOGS, POP AND COOKIES WILL BE SERVED ALONG WITH LIVE MUSIC! PLEASE CONSIDER BRINGING A NON - PERISHABLE FOOD DONATION FOR THE ESNS FOOD SHELF. NORTHEAST PUBLIC FUNDS ACCT Number of Images 18 Account Number @XXXXX @6464 Statement Dates 8/01/15 thru 8/31/15 Previous Balance 149,311.82 Days in the Statement Period 31 7 Deposits /Credits 26,371.62 Average Ledger 161,689 13 Checks /Debits 14,637.75 Average Collected 160,653 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 161,045.69 Deposits and Credits Date Description Amount 8/03 DDA REGULAR DEPOSIT 2,653.00 8/03 DDA REGULAR DEPOSIT 19,683.62 8/04 DDA REGULAR DEPOSIT 650.00 8/06 DDA REGULAR DEPOSIT 828.00 8/10 DDA REGULAR DEPOSIT 709.00 8/14 DDA REGULAR DEPOSIT 1,503.00 8/31 Xfer from PUB FUND 0001 345.00 Bank error NSF'd to wrong Charges and Debits Date Description Amount 8/12 RETURN ITEM DEBIT 345.00 Checks in serial order Date Check# Amount Date Check# Amount 8/27 2437 382.52 8/11 2450 38.77 8/06 2445* 254.69 8/07 2451 6,180.00 8/04 2446 1,770.30 8/11 2452 1,471.74 8 /05 2447 48.59 8/21 2453 22.01 8/03 2448 862.92 8/18 2454 24.02 8/04 2449 2,400.73 8/31 2457* 616.46 * Indicates skip in check numbers 3� Date 8/31/15 Page 2 Primary Account @XXXXX @6464 Enclosures 18 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Daily Balance Section Date Balance Date Balance Date Balance 8 /01 149,311.82 8/07 161,589.21 8 /18 161,921.68 8/03 170,765.52 8/10 162,298.21 8/21 161,899.67 8/04 167,244.49 8 /11 160,787.70 8/27 161,517.15 8/05 167,195.90 8/12 160,442.70 8/31 161,045.69 8/06 167,769.21 8/14 161,945.70 * * * E N D O F S T A T E M E N T 3� Parkview Villa South Payment Summary Aug -15 11,983.38 3� Check Bank Check# Vendor Date Amount 166opr- Parkview Villa South 2450 buck8411 - Buckeye Cleaning Centers 08/05/2015 38.77 166opr - Parkvlew Villa South 2451 chc - CommonBond Housing 08/05/2015 6,180.00 166opr - Parkview Villa South 2452 inte929 - Integrity Cleaning Solutions 08105/2015 1,471.74 166opr - Parkview Villa South 2453 adam - Adam's Pest Control, Inc. 08/12/2015 22.01 166opr - Parkview Villa South 2454 home7 - HD Supply Facilities Maintenance, Ltd. 08/12/2015 24.02 I66opr- Parkview Villa South 2455 cent- CenterPoint Energy 08/26/2015 180.33 166opr - Parkview Villa South 2456 comc3517 - Comcast 08/26/2015 27.53 166opr - Parkview Villa South 2457 inte929 - Integrity Cleaning Solutions 08/26/2015 816.46 166opr - Parkview Villa South 2458 kone - Kone Inc. 08/26/2015 331.61 166opr - Parkview Villa South 2459 mndpl - MN Dept of Labor & Industry 08/26/2015 31 166opr - Parkview Villa South 2460 Popp - Popp.com 08/26/2015 100.52 166opr- Parkview Villa South 2461 xcel- Xcel Energy 08/26/2015 2,759.39 11,983.38 3� Parkview Villa South Financial Statement Overview September 2015 Revenue: Occupancy for the month of July was 84% occupied Total Revenue was under budget (unfavorable) and reflects occupancy Administrative Expenses: Administrative costs for South were under budget (favorable). General Office Supplies were under budget (favorable) Utilities: Utilities Expenses were under budget (favorable); however, this reflects some quarterly billings Electric was slightly over budget (unfavorable) and reflects August invoices Gas was under budget (favorable) and reflects June billing Water was under budget (favorable) and reflects quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operatine and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflects contract cleaning Maintenance Supplies was under budget (favorable) Grounds Contract was over budget (unfavorable) and reflects invoices from July and August 33 213.46340 Parkvlew Villa South City of Columbia Heights HRA Expenditures for Fiscal Year 2015 - Parkview Villa North & South 32,096 0 48,144 as of September 2015 Supplies - 6,721 183 Account Object Code Classification Actual YTD Actual MTD Budget Balance 203.46330 Parkvlew Villa North 64,967 Capital Outlays 0 0 Personnel Services 71,432 0 107,148 35,716 Supplies 10,417 1,220 25,431 15,014 Other Services & Charges 278,004 55,827 390,923 112,919 Capital Outlays 0 0 0 Totals 203.46330 359,853 57,047 523,502 163,649 213.46340 Parkvlew Villa South Personnel Services 32,096 0 48,144 16,048 Supplies - 6,721 183 15,941 9,220 Other Services & Charges 117,733 25,393 182,700 64,967 Capital Outlays 0 0 0 0 Totals 213.46340 156,550 25,576 246,785 90,235 3� 35, 2K§ \ �\ § K § /2 f § \§ § , ƒ 2 $ ] ( ;Z( ET / � C \ \(�\ ] (k) j \ ) ( \ \ & 6K, : k $ q \ q B § ) 2 � I § /§§ a a §; j ( ■ s ba , § )2§ j ± 2 ;§q ■ �:@ w ; § & (( k kae# § B*B k § B ■ er � \ $iz \ % : I & ¥\ ( ( ¢ $ () k i { 35, 00 mom mm W &i0m0 Mm m m m N m (Q� A A A Mm m O l0 V m 4l W N N O m A N W N m A A W W tp N m m W W O V A T W W T m m N V W W J m A N V N cA0 m O W �O m O W m O A N O O W O A m m O N O (WWO (O W m O m X00 A N N� W N m N A W A m O ro N A m A (O m N N W t0 O J A A N m W m m N t0 m N m W lOJ V V (OJ N W (O m mW N A O O m N (O m W V m N m A+ N V A _ W O 0 A V W y O m A tli m t0 V m O (lN V W f0 + O V O O A A W Y T v v y N ut N m O O O O a g i m o o °o °o °o 00 °o i' w w ww wwww ww ga 'y' n m �;3 m Z W 0 0 0 3 m m o W D A o 0 0 O ° N 2 N + ONi A N m m O V W W m O W O O O O V O m 00 00 °O 00 00 ° o0 0 m c O O y a J O N N p� N (� A m + (O V N W + O + m m N O 4I w O m IJ fJ N N+ W IJ IP V m m A N W N m A A W W tp N m m W W O V A T W W T m m N V W W J m A N V N cA0 m O W �O m O W m O A N O O W O A m m O N O (WWO (O W m O m X00 A N N� W N m N A W A m O ro N A m A (O m N N W t0 O J A A N m W m m N t0 m N m W lOJ V V (OJ N W (O m mW N A O O m N (O m W V m N m A+ N V A _ W O 0 A V W y O m A tli m t0 V m O (lN V W f0 + O V O O A A W Y T v v y N ut N m O O O O a g i m o o °o °o °o 00 °o i' w w ww wwww ww ga 'y' n m �;3 m Z W 0 0 0 A m m o W D A o 0 0 m_ mG)�mpp� N _ y N ry N � N N m V N O c0 O N O O m O <lN f0 O W O m A N J O O J O OIJ V A O m m O m N RB A m m OD O V V m O t0 O !J O N O W V O O O (m0 r + m + OOi S N S OW w A w N W A Oo W m N O [O V V O O O m m O O O OIO O O O 41 O O W O m W b W (WO O lWJ Opl W W O V W N + N + N N A m Ol l0 N W + D A m J V (A� m m A t0 WIN � W N m O N O O O O O o 0 0 s1osoCD 1m y° iO Nm m v NNNy ma'o�'°c3 �. o N N w O x y N a° N m N N O D m N T C N j D NI N O OI N m IyV O m O V O O m W O O O m O 00 00 W N w a co A v m O m 0 O W m W O O m O O O O O f0 O V O O W O O A N A m A N m O 0 0 N W m 0 W I O O O A O 0 0 W O W O O O O O Z N O O O m O N D m co N + 8 N J W W lA° O O N NI 8 (D O O O O V m N W O W O O N O O al VI N W W O V m O W W N W W N O O v O O i j N C°J m 6 � O W V O A N T O V O O O O O O O N V O W O LmJ ,O m m;6 O O 0 W O'w m V a ice• O A W V 3 I O m� O A� m m O O C G IC T 3� OIN m Z W 0 0 0 A m t0 O O O o W D A o 0 0 W N + ONi A N m m O V W W m O W O O O O V O m 00 00 °O 00 00 ° o0 0 O v O O i j N C°J m 6 � O W V O A N T O V O O O O O O O N V O W O LmJ ,O m m;6 O O 0 W O'w m V a ice• O A W V 3 I O m� O A� m m O O C G IC T 3� m m W T F C x m �� mmmm mom W m� mmmm mm m mmo a CL O N c0 V W m N O W � G p t0 p m t0 m m m m A A A A A W O OOII O W N �a3 0 s a d K 9 0 d N d c A m2 O OF > o o m no m_ v m n 3' f m > > fA Jm J m m x mm m m 0 3 m flO 3 n 0 9� m 0 0 0 c� X N - % 0 mO -UJ @ y m m J aim of W W N N W O + Q t0 O o m A N N O t0 m O O A W N t0 2 OWD Om � �m O O O V � W O m 0 O O A N N m OOi .9 A O 4 A V 8 O O O + O Ol fn A m m O W O� O O O O O O O O W O W N A 6 V N N O V V O A V O O O O O O m (T O (O V V OI V N W V (WO m V m S m O W (�• �v O O Uf W m m V V O fP tp O O m O f0 UI GO G m O V 41 + cp O m <lN O A O O G W m N W m V O W W O A O 00 A W W m 1 rn �o tJ �c O onNi IJ S fO oomm lJ A z m !J oo A W A V m A (D O + O N O U1 O D D m m j A W W yyV V V V O f0 N A N + W N W A V W W A m V V it m V W m T V i0 I+ O O Ol V W A V A N A m N O W j m O m A A m tAO N N VO V w V O S S O N O O A W 0 m � tWO tNi 0 y Cl V V V ID O bl m N + (N J 0 m tV 0 o m 0 O O V V O G NN N UNi 0 V O W 1 UI W •O O O (J� fT O S m O O O O O O V V 01 V O W W O V O O O O O+ N m m N N N W m+ Q O f1 W m p V W V V N N O 01 V W t0 im W O W O W O V m m !O (T fD OOODDD N O V N m N O m A t0 m N (O m V N V N m W O m W N m (T O W O N A fl1 N A m0' O V Om +O OW A mNm tD i0 �+. W N im m m O A N m m ti m Gf V m W O GI t0 O O P m N 0 N A W A m m Otm W A tp m t0 N +01N N O W O m V N W V yGm + 0;9 9 T P •2 N N W c0 W + N W m Q m+ A + W m N N m O O m N m O O o O O O O OD V Oa V O O O O 0 0 0 O N O O V V N OI N "J 9 0 0 0 $ 00 0 0 6 0000 00 0 000; _ w 3 7 ti m 2 o Y Z O�pp O c lD O tm (n O O O f0 W O (p Oo N V S O W N m �, 'o — v ym� ym� ym� N v bm- ry mmo mo m� m� m9 O W m=. mm� 0 O ._ qJ 'nN qT 3� ma y y. N Jc m in In m m 3 J Co m o V W Ql Cl W OD � D � N tNli fN1l N N V O S S S O O u0i V m N cu N N ut N N O C W co Ut N N N N W L V W W W O O ' m (Oil lmJ w V Eppo Appl Appl ro < Ol tp A A A A A j. WN N V V V V tV0 J 01 Ol W W Ol W G O O 0 0 W m 0 0 � cVp J W W W O fAm oUI (NIl fNT N cNn O N C A O O 0 0 A m N OV1 A A A A � w N Cl Cl W m fT W W [O tT tT O V W V W V W V O W C 6 t� m Ol m W W W W N G O V V V tO.o W V W fail tOJ w O [] V (J O O O m O S NO N W W fT T O1 O m N m y S N N N S v A O O O O O p O J Parkview Villa-South Balance Sheet September 2015 Books = Accrual Assets 10100 Cash Balance 154,800.03 10200 Petty Cash 93.00 10400 Investments 839,752.82 11300 Rent Receivable 1,112.00 11500 Accounts Receivable 0.00 13100 Due From Other Funds 0.00 Total Assets 995,757.85 Liabilities 20200 Accounts Payable 6,180.00 20210 Accrued Other Expenses 7,682.96 22000 Deposits 8,579.93 22200 Accrued PILOT 8,494.20 22210 Revenue Collected in Advance 176.00 Total Liabilities 31,113.09 Fund Balance 25300 Fund Balance 964,644.76 Total Fund Balance 964,644.76 Total Liabilities and Fund Balance 995,757.85 317 Parkview Villa -South Income Statement September 2015 Books = Accrual Month to Date % Year to Date % Revenue 36220 -46340 Gen. Government Rents 24,736.00 96.05% 230,184.45 97.11% 36225 -46340 Nondwelling Rents 443.00 1.72% 4,488.20 1.89% 36290 -46340 Other Miscellaneous Revenue 573.06 2.23% 2,355.31 0.99% 39120 -46340 Recovery Damage City - 0.00% 3,697.82 0.00% Total Revenue 25,752.06 100.00% 237,027.96 100.00% Expenses Personal Services 1000 -46340 Accrued Salaries 4,012.00 15.58% 36,108.00 15.23% Total Personal Services 4,012.00 15.58% 36,108.00 15.23% Supplies 2000 -46340 Office Supplies 0.00 0.00% 278.53 0.129% 2010.46340 Minor Equipment 0.00 0.00% 0.00 0.00 0k 2160 -46340 Maint. & Construct Materials 0.00 0.00% 2,744.72 1.16% 2171 -46340 General Supplies 18132 0.71% 3,697.82 1.56% Total Supplies 183.32 0.71% 6,721.07 2.84% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 0.00 0.00% 3050 -46340 Expert & Professional Services 8,625.00 33.49% 8,625.00 3.64% 3060 -46340 Management Services 2,168.00 8.42% 19,512.00 8.23% 3100 -46340 Protective Services 119.35 0.46% 266.59 0.11% 3210 -46340 Telephone &Telegraph 127.76 0.50% 1,249.37 0.53% 3430 -46340 Advertising Other 0.00 0.00% 2,112.00 0.89% 3600 - 46340- Insurance & Bonds 820.08 3.18% 7,380.72 3.11% 3810 -46340 Electric 2,702.56 10.49% 18,562.29 7.83% 3820 -46340 Water 0.00 0.00% 2,199.34 0.93% 3830 -46340 Gas 129.53 0.50% 9,306.29 3.93% 3840 -46340 Refuse 891.25 - 3.46% 3,419.42 1.44% 3850 -46340 Sewer 0.00 0.00% 1,111.08 0.47% 4000 -46340 Repair & Maint. Services 7,120.43 27.65% 32,300.55 13.63% 4100 -46340 Rents & Leases 0.00 0100% 120.00 0.05% 4300 -46340 Miscellaneous Charges 422.53 0.00% 652.30 0.28% 4315 -46340 PILOT 943.80 3.66% 8,494.20 3.58% 4390 -46340 Taxes & Licenses 31.00 0.12% 631.47 0.27% 4500 -46340 Administrative Expenses 0.00 0.00% 440.80 0.19% 4850 -46340 Interest an Deposits 6.70 0.03% 63.95 0.03% Total Other Services & Charges 24,107.99 93.62% 116,447.37 49.13% Im Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.001 0.00% 1.000 /a 0.00 0.00% 28,303.31 109.910/0 159,276.44 67.20% - 2,551.25 - 9.910/0 77,751.52 32.80% 1 Parkview Villa South (166) 0.00 Cash Flow Statement 0.00 Period = September 2015 0.00 2171 General Supplies Month to Date Revenue 0.00 36220 Gen. Government Rents 24,736.00 36225 Nondwelling Rents 443.00 36290 Other Miscellaneous Revenue 573.06 39120 Recovery Damage City Property 0.00 Total Revenue 25,752.06 Personnel Services 1000 Accrued Salaries 4,012.00 Total Personnel Services 4,012.00 Supplies 2000 Office Supplies 0.00 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 183.32 2175 Food Supplies 0.00 Total Supplies 183.32 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services 8,625.00 3060 Management Services 2,168.00 3100 Protective Services 119.35 3210 Telephone & Telegraph 127.76 3430 Advertising Other 0.00 3600 Insurance & Bonds 820.08 3810 Electric 2,702.56 3820 Water 0.00 3830 Gas 129.53 3840 Refuse 891.25 3850 Sewer 0.00 4000 Repair & Maint. Services 7,120.43 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 0.00 4300 Miscellaneous Charges 422.53 4315 PILOT 943.80 4390 Taxes & Licenses 31.00 4500 Administrative Expenses 0.00 4850 Interest on Deposits 6.70 Total Other Services & Charges 24,107.99 Total Expenses 28,303.31 Parkview Villa South (166) Cash Flow Statement Period = September 2015 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 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 - 2,551.25 0.00 0.00 (428.00) 0.00 0.00 0.00 (1,334.65) 820.08 6.70 943.80 (39.00) (31.07) (2,582.32) End Cash Difference 157,382.35 154,800.03 (2,582.32) 93.00 93.00 - 839,752.82 839,752.82 - 997,228.17 994,645.85 (2,582.32) Proper Date Person/ Description 1000 -46340 Accrued Salaries z166 9/30/2015 :PostRecurring Recurring Net Change= 4,012.00 2000 -46340 Office Supplies Net Change =0.00 Parkview Villa South (166) General Ledger Period = Sep 2015 Book = Accrual; Tree = ysi_tb Reference Debit RC 2010 -46340 Minor Equipment z166 8/24/2015 Project One Construction, Inc. (12.015E+15 z166 8/24/2015 Project One Construction, Inc. (1201500060016516f Net Change =0.00 - 4,012.00 422.53 0.00 10115/2015 1:18 PM Credit Balance Remarks 32,096.00 = Beginning Balance = 0.00 36,108.00 R/C CHC PR Mgmt Fee 36,108.00 = Ending Balance = 278.53 = Beginning Balance = 278.53 = Ending Balance = 2,744.72 = Beginning Balance = 0.00 3,167.25 counter /door replace 422.53 2,744.72 counter /door replace 2,744.72 = Ending Balance = 2171 -46340 General Supplies z166 9/11/2015 HD Supply Facilities Maintenancr9140331348 12.55 0.00 z166 9/8/2015 Sherwin - Williams Co. (sher4110 9487 49.56 0.00 z166 9/10/2015 Park Supply of America, Inc. (pa 61222300 67.17 0.00 z166 9/11/2015 HD Supply Facilities Maintenancn9140331350 9.78 0.00 z166 9/11/2015 HD Supply Facilities Maintenance9140331348 30.70 0.00 z166 9/17/2015 HD Supply Facilities Maintenana9140479662 13.56 0.00 1,249.37 net - 09/11 - 10/10/15 Net Change= 183.32 Net Change= 127.76 3050 -46340 Servicing Fees z166 9/9/2015 Columbia Heights HRA (coluhra)20142a Net Change= 8,625.00 3060 -46340 Management Services z166 9/29/2015 Commoneond Housing (chc) 092915mgmt z166 9/30/2015 :PostRecurring Recurring RC Net Change= 2,168.00 8,625.00 0.00 3,514.50 = Beginning Balance = 3,527.05 towels 3,576.61 paint/recycle fee 3,643.78 drain clear /gloves 3,653.56 auger 3,684.26 sockets /blb hldrs /blbs 3,697.82 bulbs 3,697.82 = Ending Balance = 0.00 = Beginning Balance = 8,625.00 servicing fees 01/15 -09/15 8,625.00 = Ending Balance = 17,344.00 = Beginning Balance = 6,180.00 0.00 23,524.00 mgmt fee 09/15 0.00 4,012.00 19,512.00 R/C CHC PR Mgmt Fee 19,512.00 = Ending Balance = 3100-46340 Protective Services 147.24 = Beginning Balance = z166 9/1/2015 Trans -Alarm Inc (tran) RMR025683 119.35 0.00 266.59 monitoring- 09/01/15- 08/31, Net Change= 119.35 266.59 = Ending Balance = 3210 -46340 Telephone & Telegraph 1,121.61 = Beginning Balance = z166 8/31/2015 Popp.com (popp) 992286168 100.23 0.00 1,221.84 phone /net- 08/01- 08/31/15 z166 9/2/2015 Comcast(comc3517) 877210505019618: 27.53 0.00 1,249.37 net - 09/11 - 10/10/15 Net Change= 127.76 1,249.37 = Ending Balance = 3430 -46340 Advertising Other 2,112.00 = Beginning Balance = Net Change =0.00 2,112.00 = Ending Balance = 3600 -46340 Insurance & Bonds 6,560.64 = Beginning Balance = z166 9/30/2015 :PostRecurring Recurring RC 820.08 0.00 7,380.72 C of Columbia Heights Ins A Net Change = 820.08 7,380.72 = Ending Balance = 3810 -46340 Electric 15,859.73 = Beginning Balance = z166 9/11/2015 Xcel Energy (xcel) 5150441553 09/11, 2,661.17 0.00 18,520.90 E- 08/05- 09/06/15 z166 9/11/2015 Xcel Energy (xcel) 5150441553 09/11, 41.39 0.00 18,562.29 late fee Net Change = 2,702.56 18,562.29 = Ending Balance = Page 6 of 9 1 1 Proper Date Person/ Description 3820 -46340 Water Net Change =0.00 Parkview Villa South (166) General Ledger Period = Sep 2015 Book = Accrual ; Tree = ysi_tb Reference Debit 10/15/2015 1:18 PM Credit Balance Remarks 2,199.34 = Beginning Balance = 2,199.34 = Ending Balance = 3830 -46340 Gas 25,180.12 9,176.76 z166 = Beginning Balance = z166 9/8/2015 CenterPoint Energy (cent) 55199657 09/08/2( 143.79 maint- 07/01- 07/31/15 0.00 9,320.55 Adam's Pest Control, Inc. (adam2296279 G- 08/05- 09/03/15 z166 9/9/2015 CenterPoint Energy (cent) 55271324 09/09/1` 40.15 8/14/2015 0.00 9,360.70 G- 08/06- 09/04/15 z166 9/9/2015 CenterPoint Energy (cent) 55271324 09/09/1` 129.53 133.30 0.00 9,490.23 25,995.19 G- 08/06- 09/04/15 z166 9/18/2015 CenterPoint Energy (cent) 55199657 09/08/2( 0.00 0.00 143.79 9,346.44 dryer repairs G- 08/05- 09/03/15 z166 9/18/2015 CenterPoint Energy (cent) 55271324 09/09/1` 0.00 40.15 9,306.29 8/21/2015 G- 08/06- 09/04/15 1,216.36 Net Change= 129.53 28,266.03 grounds work z166 8121/2015 9,306.29 758.80 = Ending Balance = 3840 -46340 Refuse caulking /sealing z166 8/28/2015 Integrity Cleaning Solutions (inb8282015 2,528.17 = Beginning Balance = z166 9/11/2015 Integrity Cleaning Solutions (intc911201512 z166 891.25 Integrity Cleaning Solutions (inb82820152 0.00 3,419.42 0.00 trash service caretaking- 08/24- 08/28/15 Net Change= 891.25 8/28/2015 Integrity Cleaning Solutions (inb82820151 149.96 0.00 3,419.42 = Ending Balance = 3850 -46340 Sewer Utilities Net Change =0.00 1,111.08 =Beginning Balance= 1,111.08 = Ending Balance = 4000 -46340 Repair & Maint. Services 25,180.12 = Beginning Balance = z166 7/1/2015 Kone Inc. (kone) 949033543 331.61 0.00 25,511.73 maint- 07/01- 07/31/15 z166 8/5/2015 Adam's Pest Control, Inc. (adam2296279 75.23 0.00 25,586.96 exterior treatment- 08/05/15 z166 8/14/2015 Integrity Cleaning Solutions (inte8142015 274.93 0.00 25,861.89 caretaking- 08 /10- 08/14/15 z166 8/14/2015 Integrity Cleaning Solutions (int,81420152 133.30 0.00 25,995.19 goundskeeping-08/10-08/1 z166 8/18/2015 Direct Home Appliance Services 81815165166 204.70 0.00 26,199.89 dryer repairs z166 8/21/2015 Integrity Cleaning Solutions (1082020151 849.78 0.00 27,049.67 pressure wash z166 8/21/2015 Integrity Cleaning Solutions (int,82020152 1,216.36 0.00 28,266.03 grounds work z166 8121/2015 Integrity Cleaning Solutions (inb8202015 758.80 0.00 29,024.83 caulking /sealing z166 8/28/2015 Integrity Cleaning Solutions (inb8282015 283.26 0.00 29,308.09 cleaning- 08/24- 08/28/15 z166 8/28/2015 Integrity Cleaning Solutions (inb82820152 274.93 0.00 29,583.02 caretaking- 08/24- 08/28/15 z166 8/28/2015 Integrity Cleaning Solutions (inb82820151 149.96 0.00 29,732.98 groundskeeping - 08/24 -08/2 z166 8/28/2015 Kone Inc.(kone) 949082090 331.61 0.00 30,064.59 maint- 09/01- 09/30/15 z166 9/1/2015 Direct Home Appliance Services 90115165166 56.03 0.00 30,120.62 dryer repair z166 9/4/2015 Integrity Cleaning Solutions (inb 904201510 274.93 0.00 30,395.55 caretaking- 08/31- 09/04/15 z166 9/4/2015 Integrity Cleaning Solutions (inb90420151 133.30 0.00 30,528.85 groundskeeping -08/31 -09/0 z166 9/5/2015 Integrity Cleaning Solutions (int19O4201512 116.63 0.00 30,645.48 cleaning z166 9/5/2015 Integrity Cleaning Solutions (inb904201511 216.61 0.00 30,862.09 window detail z166 9/5/2015 Drain King, Inc.(drai7740) 97065A 54.25 0.00 30,916.34 line clear z166 9/9/2015 Drain King, Inc.(drai7740) 97175 44.02 0.00 30,960.36 auger toilet z166 9/9/2015 Drain King, Inc.(drai7740) 97176 54.25 0.00 31,014.61 sink clear z166 9/10/2015 K O Cleaning and Remodeling, 13603 93.00 0.00 31,107.61 paint/patch z166 9/10/2015 K O Cleaning and Remodeling, 13602 93.00 0.00 31,200.61 paint/patch 2166 9/11/2015 Integrity Cleaning Solutions (inb911201510 274.93 0.00 31,475.54 caretaking - 09/07- 09/11/15 z166 9/11/2015 Integrity Cleaning Solutions (in6911201511 133.30 0.00 31,608.84 groundskeeping- 09/07 -09/1- z166 9/11/2015 HD Supply Facilities Maintenanc,9140331348 34.74 0.00 31,643.58 pleated filters z166 9/15/2015 Integrity Cleaning Solutions (mb91520157 224.94 0.00 31,868.52 full unit detail z166 9/18/2015 Integrity Cleaning Solutions (inti91820151 298.73 0.00 32,167.25 caretaking- 09/14 - 09/18/15 z166 9/18/2015 Integrity Cleaning Solutions (inb91820152 133.30 0.00 32,300.55 gmundskeeping -09/14 -09/1 Net Change = 7,120.43 32,300.55 = Ending Balance = 4100 -46340 Rents & Leases Page 7 of 9 120.00 = Beginning Balance = Page 8 of 9 10/15/2015 1:18 PM Parkview Villa South (166) General Ledger Period = Sep 2015 Book = Accrual; Tree = ysi_tb Proper Date Person /Description Reference Debit Credit Balance Remarks Net Change =0.00 120.00 = Ending Balance = 4300 -46340 Miscellaneous Charges 229.77 = Beginning Balance = 2166 8/24/2015 Project One Construction, Inc. (I 2.015E +12 422.53 0.00 652.30 counter /door replace Net Change= 422.53 652.30 = Ending Balance = 4315 -46340 PILOT 7,550.40 = Beginning Balance = z166 9/30/2015 :PostRecurring Recurring RC 943.80 0.00 8,494.20 Anoka Cty Property Tax Aco Net Change= 943.80 8,494.20 = Ending Balance = 4390 -46340 Taxes & Licenses 600.47 = Beginning Balance = z166 9/1/2015 PIN Dept of Labor & Industry (m ALR00538901 31.00 0.00 631.47 elevator fees Net Change =31.00 631.47 = Ending Balance = 4500 -46340 Administrative Expenses 440.80 = Beginning Balance = Net Change =0.00 440.80 = Ending Balance = 4850 -46340 Interest on Deposits 57.25 = Beginning Balance = z166 9/30/2015 Security deposit interest accrual 332 6.70 0.00 63.95 Security deposit interest acc Net Change =6.70 63.95 = Ending Balance = 32,921.78 4,618.47 Page 8 of 9 5016464 Parkview Villa South Bank Reconciliation Report 09/30/2015 Balance Per Bank Statement as of 09/30/2015 04/29/2014 2062 t0011071- Johnson 0911712015 2472 dire - Direct Home Appliance Services 09123/2015 2479 adam - Adam's Pest Control, Inc. 0912312015 2481 home7 - HD Supply Facilities Maintenance, Ltd. 09/23/2015 2485 proj - Project One Construction, Inc. 09130/2015 2487 cent - CenterPoint Energy 09!30/2015 2488 home7 - HD Supply Facilities Maintenance, Ltd. 09/30/2015 2489 inte929 - Integrity Cleaning Solutions Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 09/30/2015 $157,570.56 232.96 260.73 75.23 87.77 422.53 129.53 13.56 1,548.22 $2,770.53 $154,800.03 10/1/15 $154,800.03 Reconciled Balance Per G/L $154.800.03 Difference 0.00 Cleared Items: Cleared Checks Date Tran # Notes Amount Dale Cleared 08126/2015 2455 cent - CenterPoint Energy 180.33 09130/2015 08/26/2015 2456 comc3517- Comcasl 27.53 09130/2015 08/26/2015 2458 kone - Kone Inc. 331.61 09/30/2015 08/26/2015 2459 mndpl - MN Dept of Labor & Industry 31.00 09/30/2015 08/26/2015 2460 Popp - Popp.com 100.52 09/30/2015 09102/2015 2462 chc - CommonBond Housing 6,180.00 09/30/2015 09/0212015 2463 home7 - HD Supply Facilities Maintenance, Ltd. 86.87 09/30/2015 09/022015 2464 inte929 - Integrity Cleaning Solutions 1,121.81 09/30/2015 09/022015 2465 Ibpm - LBP Mechanical, Inc 51.15 091302015 09/022015 2466 summ - Summit Fire Protection 70.52 09/302015 09/09/2015 2467 chc - CommonBond Housing 4.30 09/302015 09/092015 2468 kone - Kone Inc. 331.61 09130/2015 09/11/2015 2469 xcel - Xcel Energy 2,759.39 09/30/2015 091172015 2470 coluhra - Columbia Heights HRA 8,625.00 09/302015 09/172015 2471 comc3517- Comcast 27.53 09/302015 09117/2015 2473 inte929 - Integrity Cleaning Solutions 3,923.99 09/30/2015 09/17/2015 2474 koc17025 - K O Cleaning and Remodeling, Inc. 186.00 09/30/2015 'f-7 10/1/15 Parkview Villa South Bank Reconciliation Report 09/30/2015 5016464 09/17/2015 2475 mndpl - MN Dept of Labor & Industry 31.00 0913012015 09/17/2015 2476 Popp - Popp.com 100.23 09/30/2015 0911712015 2477 sher4110 - Sherwin- Williams Co. 49.56 09/30/2015 09/1712015 2478 tran - Trans -Alarm Inc 119.35 09/30/2015 09/2312015 2480 drai7740 - Drain King, Inc. 152.52 09/3012015 09/23/2015 2482 inte929 - Integrity Cleaning Solutions 1,167.03 09/30/2015 09123/2015 2483 kone - Kone Inc. 331.61 09/30/2015 09/2312015 2484 parkl - Park Supply of America, Inc. 67.17 09/30/2015 09/23/2015 2486 xcel - Xoel Energy 2,702.56 09/30/2015 Total $28,760.19 Cleared Deposits Date Tran # Notes Amount Date Cleared 0910112015 587 Laundry 294.00 0913012015 09/01/2015 588 11,872.00 09/3012015 09/03/2015 589 9,254.00 09/30/2015 09108/2015 590 1,774.00 09/30/2015 09/11/2015 591 1,975.00 09130/2015 09123/2015 592 116.06 09/3012015 Total $25,285.06 10/1/15 HRA OF COLUMBIA HEIGHTS Date 9/30/15 Page 1 PARKVIEW VILLA SOUTH Primary Account @XXXXX @6464 C/O COMMONBOND COMMUNITIES Enclosures 32 328 KELLOGG BLVD WEST Amount ST PAUL MN 55102 -1900 9/01 DDA REGULAR DEPOSIT - - - -- C H E C K I N G A C C O U N T S - - -- 294.00 NORTHEAST BANK'S ANNUAL PRIVACY NOTICE 9/01 IS AVAILABLE ON OUR WEBSITE AT WWW.NORTHEASTBANK- MN.COM OR YOU MAY REQUEST A COPY BE MAILED TO YOU 9/03 BY CALLING 612 - 379 -8811. NO CHANGES HAVE BEEN MADE TO OUR PRIVACY NOTICE THIS YEAR. 9/08 MEMBER FDIC NORTHEAST PUBLIC FUNDS ACCT Number of Images 32 Account Number @XXXXX @6464 Statement Dates 9/01/15 thru 9/30/15 Previous Balance 161,045.69 Days in the Statement Period 30 6 Deposits /Credits 25,285.06 Average Ledger 174,158 26 Checks /Debits 28,760.19 Average Collected 173,010 Electronic Debit .00 Checks in serial order Service Charge .00 Interest Paid .00 Date Check# Ending Balance 157,570.56 Date Check# xxxx+ x+ x++++ xx+++ xxxxxxxxxxxxxxxxxx+++ x++++++++ + + + + + + +xxxxxxxxxxx +x + + +x + + + + + ++ Deposits and Credits Date Description Amount 9/01 DDA REGULAR DEPOSIT 294.00 9/01 DDA REGULAR DEPOSIT 11,872.00 9/03 DDA REGULAR DEPOSIT 9,254.00 9/08 DDA REGULAR DEPOSIT 1,774.00 9111 DDA REGULAR DEPOSIT 1,975.00 9/23 DDA REGULAR DEPOSIT 116.06 ++ x+ xxxxxxxxxxxxxxxxx+++++++++++ xxxxxxxxxxxxxxxxx +xx +xx +x + +x + + +x +xxxxxxxxxxxxx Checks in serial order Date Check# Amount Date Check# Amount 9/02 2455 180.33 9/25 2470 8,625.00 9/03 2456 27.53 9/29 2471 27.53 9/01 2458* 331.61 9/28 2473* 3,923.99 9101 2459 31.00 9/28 2474 186.00 9/02 2460 100.52 9/24 2475 31.00 9/04 2462* 6,180.00 9/25 2476 100.23 9/10 2463 86.87 9/29 2477 49.56 9110 2464 1,121.81 9/25 2478 119.35 9/09 2465 51.15 9/30 2480* 152.52 9/09 2466 70.52 9/28 2482* 1,167.03 9/14 2467 4.30 9/30 2483 331.61 9/15 2468 331.61 9/29 2484 67.17 9/25 2469 2,759.39 9/29 2486* 2,702.56 * Indicates skip in check numbers T! Date 9/30/15 Page 2 Primary Account @XXXXX @6464 Enclosures 32 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Daily Balance Section Date Balance Date Balance Date Balance 9/01 172,849.08 9/10 176,058.35 9/25 166,178.53 9/02 172,568.23 9/11 178,033.35 9/26 160,901.51 9/03 181,794.70 9/14 178,029.05 9/29 158,054.69 9/04 175,614.70 9/15 177,697.44 9/30 157,570.56 9/08 177,388.70 9/23 177,813.50 9/09 177,267.03 9/24 177,782.50 * * * E N D O F S T A T EM E N T WI Parkview Villa South Payment Summary Sep -15 27,867.38 S Check Bank Check# Vendor Date Amount 166opr- Parkview Villa South 2461 xcel- Xcel Energy 09/11/2015 (2,759.39) 166opr- Parkview Villa South 2462 chc - CommonBond Housing 09/02/2015 6,180.00 166opr - Parkview Villa South 2463 home7 - HD Supply Facilities Maintenance, Ltd. 09/02/2015 86.87 166opr- Parkview Villa South 2464 inte929 - Integrity Cleaning Solutions 09/02/2015 1,121.81 166opr - Parkview Villa South 2465 Ibpm - LBP Mechanical, Inc 09/02/2015 51.15 166opr - Parkview Villa South 2466 summ - Summit Fire Protection 09/02/2015 70.52 166opr - Parkview Villa South 2467 chc - Common Bond Housing 09/09/2015 4.30 166opr - Parkview Villa South 2468 kone - Kone Inc. 09/09/2015 331.61 166opr - Parkview Villa South 2469 xcel - Xcel Energy 09/11/2015 2,759.39 166opr- Parkview Villa South 2470 coluhra - Columbia Heights HRA 09/17/2015 8,625.00 166opr - Parkview Villa South 2471 comc3517 - Comcast 09/17/2015 27.53 166opr - Parkview Villa South 2472 dire - Direct Home Appliance Services 09/17/2015 260.73 166opr- Parkview Villa South 2473 inte929 - Integrity Cleaning Solutions 09/17/2015 3,923.99 166opr - Parkview Villa South 2474 koc17025 - K O Cleaning and Remodeling, Inc. 09/17/2015 186.00 166opr - Parkview Villa South 2475 mndpl - MN Dept of Labor & Industry 09/17/2015 31.00 166opr - Parkview Villa South 2476 Popp - Popp.com 09/17/2015 100.23 166opr- Parkview Villa South 2477 sher4110 - Sherwin- Williams Co. 09/17/2015 49.56 166opr- Parkview Villa South 2478 tram - Trans -Alarm Inc 09/17/2015 119.35 166opr - Parkview Villa South 2479 adam - Adam's Pest Control, Inc. 09/23/2015 75.23 166opr- Parkview Villa South 2480 dra17740 - Drain King, Inc. 09/23/2015 152.52 166opr - Parkview Villa South 2481 home7 - HD Supply Facilities Maintenance, Ltd. 09/23/2015 87.77 166opr- Parkview Villa South 2482 inte929 - Integrity Cleaning Solutions 09/23/2015 1,167.03 166opr - Parkvlew Villa South 2483 kone - Kone Inc. 09/23/2015 331.61 166opr - Parkview Villa South 2484 parkl - Park Supply of America, Inc. 09/23/2015 67.17 166opr - Parkview Villa South 2485 proj - Project One Construction, Inc. 09/23/2015 422.53 166opr - Parkview Villa South 2486 xcel - Xcel Energy 09/23/2015 2,702.56 166opr- Parkview Villa South 2487 cent- CenterPoint Energy 09/30/2015 129.53 166opr - Parkview Villa South 2488 home7 - HD Supply Facilities Maintenance, Ltd, 09/30/2015 13.56 166opr- Parkview Villa South 2489 inte929 - Integrity Cleaning Solutions 09/30/2015 1,548.22 27,867.38 S Parkview Villa /HRA Additional Financial Reports Submitted by: City Finance Department U W X KC a H [Y. �o a H VN wN �O HO a ri V Oo V> ro wma �w Ooo .ti o E-4,4 0 H � HOD N H O a • .n o N \ O O N O W N77 H O U i4 N f04 t� H N 7 y N H H H N y U/ Sl S4 •o z sr o o 0 y N O N \ p x p \ s, v v a ro N }{ ❑ ... .... wH o : ... ........ w C O m WN 11 rt . .. . . . . : . : . . . OW ao E ry Nu�i F : : rtb : . . . . . . . . � 11 ❑ H > 0 OH O P4 7 mSaHH ••O •Nv \ti �v H H v v a •• o mo • v i w v • w • rd v �tv v yuH .+ N OQ W Ww . . •o . ❑ro ••p❑ w a(u �4wro FCo H rtU 7 : v : W N ro H ❑ N z v N N W H\ H VI � 10 rd U (d 0 U Id • v N W W W C'i Cl, w0 H k O 0 ❑ u o X O o w o -H 4 Ul000 •A ro i1 7a� 0 H0 o 410 Hk0 -0 O V ro tiro o N\ a a, Uq 0 8 00 0 H r OR >Ng7H Utt v a zo 9 04 �c000u My 0fu w 0s4 a rjo W 0 Hw Um77U a >Haw >xu H a x c� x w H f� a N ao Om O o� YI o Fc H If1 U a C7 S4 0 a 0 o ll m .N x tl q E GI S1 A N Q i N WN E •• m .. m ao u\0 H O z N N \ w O H m \ Vm Q O w FO O(U Q� z� a ❑ 0.1 H W \ m w u m W w 0 W yt O a W U H N u £ W H 40 la a ua 0 0 0 0 0 0 H N H N H H m w vml mn y m tmn W N W W W W W w a w w w w w o a o 0 0 0 0 a o m H w o a o a a 04 0 o o a 0 Wo Ewm FGN .7 m EW m Ewm EW E. m E mwEm w o W o r1 o W o W o W O W O W O am zm (9m am a m am am am W � Ow Iw4w we W � W Imo ww ww C m m m m m sr H. m mm rim .,4 mm rim Hm OmOm O o 00 Ho HO 00 0 0 0000 a" ON ON ON ON ON O N O N O�O O O x O� O x O O h4 h4 m rm mm rm \Om mm O W Om 10 m If1 O H C 1p lD r m c In a to r r I I I I I I I O H 1(1 mn Nr r mr111r H O H Ho HO HO O O H H O N O N O N£ H Z H£ N£ H£ N£ H£ H£ H N w W r n m m 0m 0 oa Oa Oa Oa oaoa I I I I I I ❑1n qIn ❑w ❑o pin qo gmgm r H o 10 r e o 0 c m H m H 111 1n N N 0 O H N H O O O H O 0 O O 0 0 0 0 0 0 0 0 0 0 N O m H m N m Ift H 1(1 01 N n 1(1 H c m o o yl y. IP m O H lD r O 01 1p 1p 1l1 m N n 14 r N N H W H 1p H 1p H H u z z z a z a 0 0 0 o a Emil tmn Vm1 o-DI Vml E C4 °a 04 w 0w a a a a W N 18M W 14 z H !m > a O O O O O N O 00 O E- " a� a� a" a" mN iX W o W O W o W O W O • l0 go am am am am am zm am w� w� DQ EE, w� 00 WWI d C N C C O C O N 10 m O O 1I1 r i m O m O m N m N m w m N m 0 0 Ho 00 00 00 00 00 O N O N O N O N O N O N O N O� O� O_ O� O� O� O mm H m mm m W N m H m m m O N O N m m q O O N m m m m 1 I I I I I I N r If1 r H O r I(1 111 n H H H r H O H O H H H O H O m£ O£ H£ Oz N£ NZ N£ m O H N N N N O a H a H a H H a H H qm ❑w qm ❑ ❑m ❑ ❑ 0 0 o m 1n m In m O O O O 0 0 0 0 0 0 o O w m r 1n m 1n 1n m N m H m H H N r m N r C r 0 r r m O N O H EH H H H H H H U W x V F 1(1 O m O m O m m m O l0 O 1p m n O m O O O 10 m 1n m �0 10 n m m 1n H N 01 b m m r n 14 N m 1n C m r N 111 m T m O O C In dl m m N m at tP Ill m H b H H H N m m H H m O N W U IN, zA OH > ❑ w 0 z W W RC U W x V m H H N Ill r r H 1(1 H F w El N W U H V El M DQ w z ti m a H FIC r7+ £ m Q E, rlyy to ao a0 z �m aP Q zaza ory 40 > uz w o`� u >>w O W� 00 U°w7 0 a0 u0 Z qU �o 14 W �tl W �E �F Qa a'u cWr� 0 am Qa Wa'W W O W 0 w❑a wo '/W�H xX W o x� H tmi Wa £x �Gn ww au :4N 0 0 o m o 1n o 0 m If1 01 N m N 01 OI N Ill N m 1(1 m N N N C m m N 14 m m H H 1n ul v1 m m m m m H N H H H H N H m H O W In N N N N H H N H N H H \ \ \ \ \ \ \ m m H N 10 l0 r r m O O O O O O O O m m m m m H IP 14 O If1 N m 1p M m m f0 r H N Ill l0 m m 1n In r r r r r r N Ill 1f1 1l1 III Ill 1(1 14 H H H H H H H H Q w m El El DQ a5 0a4 z rmi mS a� w m o ww a z W z z m W q W E 014 004 0 a Dq 014 0 04 0 > i+pUo an 14H .tl tan W w0 .aa m D1] 3 al rC y Nw E 0 WW 73 W ❑ W O W0 tCH RCW ,W EI0-1 n �iia oO as u 0 0 o m o v1 0 m m m m H m H N N N N O N N m m m N C C H N N N 1n 111 m 1l1 In 1(1 H H H H H H H o r H m m m m m O H O N N N \ \ H \ \ \ \ O1 O H N N N N O N H H H H H N N N N m 10 C N O d� 1p m tT O In m o m 1n m iP m m m m m m m 1l1 N 111 In Ifl Ill In H H H H H H H 0 w N E W 0 H w x w a c� H � gma ww O7 o [z EE w 0 O Oi POV H U � E H 1I1 va q u z�N a x q w H w hx \w w V m W O N u O a w • V N • O a, > is z O H a E v a Ew u H'] o ua N m �M x G S O v E N RC A W .ti q a wu z0 as O H 00 z W W > q P4 [0] w N q E •• W UI M > yN RHC a zVe q ao zN H \ YL W O � H U N \ W KC o U C N •I M r+i N O E a O a W a N M O O O O q w E z H P4 a m q a 0 w a INI m w xa c� a Ha wa xu w aw H WN i O a m Oo U amx 000 e a Noon U u i i I I 0 0 I I � � I E I w w w � E N N N S4 W H H W ti O U1 .-I rl V] ri y m z l H I U H H Q ❑ N E H .. a I U/ •• � u uz�o a m a wl u H 7 H \ [i� ❑ A (� z U m P4 .N O a N •i m W W a 0 E a i i I I x I I � � I E I w o z y m z l H I U H .. a I w •• � u uz�o a u� a wl u H \ [i� ❑ a (� z U P4 R� O N [y N FI [q M m a N •i m W W a 0 E a "' ) w 64, x H P4 w > ua N a �o uN H N O H O u 0> U > m 000 - M O my a i o m H Faa o HOD N H u \ o aw • ri o m o • H N N O W MN H o U N H yy N W W S4 i4 l4 574 Y7i to W 11 L 11 11 11 11 L L 11 11 11 11 11 11 ro H N z °>1 o x O o 0 � N O m \ O M N O x o \ 11 H � o v E � W .ti m m H 0 a m "° ..... ....... qo q..... ....... wH o )" . . . . . . . r o m y . . . . . . .N q W :: ::: 0 o o Po N F N . . . . . . . . . . . U U b b N m 1 q H .r o pp ao N q :>, >, : : :v : :v : P4 Q U a 7 ' m N H H • . •ro .11 W \H 11 W H Uw (U W w •• O U 4) 1111 W N b 11 W U❑❑ ,H W w z Wror q.0 1l0 wwe • • . O ❑ Id ❑ •ro %U wx 7 q sum o w 04 mu v w 11w 2i N Itl H q Z H\ 11 q UI atl W Id b U M U 0 W m W ro W 9 V ao S4 O ❑ X u 0qx w0 -H= •.0 NM 711 H± 0 .-� O -.a aro 0S4 p 6'U - ro0uxUWm .-IN O v z� ° a 4000 C s o w vC 7mWU q S4 /.�o a 0 Ha uwh �)u a >Ham >a'u Hu a E H 4 Q a � Q a 4 a Q m z z z z z z z z z z aq z DQ H o 0 o a o 0 0 0 0 0 0 o w w H H H w H H H H H H H (a H a x m m m m x m m m ti w y w w m W y m W V1 E m m m m w m m .] m F o w w w w w w w w w z wa w o 0 o a 0 o 0 0 0 0 0 0 0 0 N a d W W W W W W W W W ,10 z F o o m .-I o w In W o 0 0 0 0 0 0 o W o o w O 2 w In w to n W In w w W w W In . m W M W m w o . m b m z ri U m P O O .i O W O W O O O O O O O O O N O pO O o O Fm Em N EM m M Fm Em EmEm Em Em Em xM Em C7ry a> v a a a.7.7 a a a •a a a a a a N E- 0 ou wo wo wo w0 FCO r10 wo wo wo WO N wo w0 w0 wo •w a Urt as am za 04 ac 04 aaaa 04 zm X m X m mm X m w m W m X m X m X m X M X m X m X M mm X m W. EC RC �tl W w ww (7w W w 0 .7w W w W w ww W w W w W w ww Ew Ww Do H N C C C C C C W C T C dl C C s+ C O U rl W OI w dl m n N N C H M H w w H C) W M m U I m r m m M I (1 m M m MM r H im Om O O m N m N M C m z O H OH OH OH OH H H H H OH O H O H O H H H OH CH OH OH H ON ON ON ON ON ON ON ON O N O N ON ON ON ON ON ON .1 yz og� oyz 0my 0� oyz oy� oz ozzz oz oyz 0z oz oyz Ogx ozz oz RC FC a 4 a Q Q FC a 4 4 4 Q 4 FC q [q m w of w r w m m W m w m w n w w [0 o w O w m w H m m m w N w H w H w H M Ot m W O H w w O N O N m m \ i n aD m Ol M C 1(1 w r r O O N M M M W I I I I I I h X H r H r 1(1 H r H r I(1 n H n 1(1 r I(1 O N r H r H n I(1 r H H r H \ )q H O H O H H O H O HO H O HO H O H O H O H O HO H H O H W m H H H M O dl N N N O r H O1 M M V O) N£ H£ H HE H£ H£ N£ H£ H£H£ ME O£ H£ OZi N£ Nz H m N N M N w w n m m O H N N 000 o oao o N 04 Ha H m❑i N QI m I I I I I I r o Q,N-I Qo Q o ❑o ❑w Q Qo Qo Qo Q o Qo ❑ Q m ❑ w m m u) u1 m u) a m m In v1 m M i! N O N O O O H N O O O O O O O O O H O O O O O O O O O O O a O o 0 0 0 0 0 0 0 o O o 0 0 N O m H w M N U m O N m m H N O1 W 01 r w 01 If1 • H H N p m y� m O N 1I1 H O) N m H m H • O C N OI 1(1 I(1 O O w 0 w m I-7 N r m N n dl 1I O C H C 1(1 r O w w E, r r m O N O Si III N m N N N r 1II N N N N N H N N H V H H m H H H w H H H E H H H H H H a H fJ U o uua e° u m x• O O 1(1 C O O C N w w C O m n O O m O N 01 O m m at r C M m m w O • O n r N C H 01 OI N M M n H m n N w w N£ 111 M r N H m m 1(1 n N n N n w w n FI � Q H N O O� N dl O N w w a1 N H H 0 •ri Q E m ❑ a IE-1 E- D W O H .] H a H Z P aEl m m a UI O E Vl >W m w 3 FC H > o m S W 1, pa Q > VJ o [ai rt a s ao zm O za z z Q a❑ zaza zw z z w w ❑�C o > as >w >m > ww o� >a >a >w >m > u° El Fz wu QH CN mo 0z � 0� mw oo 040 a � N ZO m �w wa xE z o .a w wFwE .aw o m w0 ga �00s ww Wµ au ow qqm Wm w� Fw Wg of Wqw Woo Wom m0 `pyw 03 Hz DQ >O as x� .x wo Xa aGq ww P4 N0 QM Y' XHn Hn Uo a cw a P4 o 0 o O 0 0 m o 0 O 0 0 o m o n O m m In m m m N m m m m m m m H m £ N ❑ N N 1I1 N N N m l(1 ry N N N N N O H FH M sM M M M I71 M M M M M H N m C 'N N w •• � � � N N N � N N N N w N � w � m H H H H H H H H H H H H H H H H Uw ❑ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ H H N N M 1(1 w w r m m OI O H N N N 7i N O O O O O O O O O O O H H H H H H\ tC m m m w r m m m w w N N N N M w NO x O III m r n N m w m m N O C w m m H U w n r O n H N N m m 1(1 w O M N 1(1 rn \ w In In In w w r r r r r m m m m a w U M x U1 III N 1(1 I11 1I1 1f1 N 1I1 N 1(1 1(1 III 111 1(1 III 4� 0 U H H H H H H H H H H H H H H H H N w N U E H W a H W W U1 x E w E CG F z Wa w H N W F '40 z o OUm 2F Pi h3 O wa w0 OQ E O� OW WzE 9A vix 0 WC o ., £ N ❑ am H I(1 W ua 0 • [J W N M Z o H m •• H O N m az og� 17 o Q FC gtl1 mfA H H 01 Uw \ � M ei W I O hx w� %y N \W Ho W m W U m N £ N U1 \ W N O � W ❑ a O a w • u � • H 'i • O t� lJ N it N O H H a E N U W £w H7 H a O U M L 0 rl x a E O � v £ m A m •A O C�- E Z W £ W a E E W m W W U W F haw �� Zq Pi h3 OQ E O� WzE 9A vix W o o ., £ N ❑ N m •• in m H 17 o W \ H � N Uw q \ ei N O N %y N W U1 \ W rn C�- m� E x c� H w x w �a ao zH Um EFz6 D4 > P U O OU No UFl� F a C w H ua q H w a Aa H w Fn \w w Um N O m 0 O a w PH Q �4 O M Pr E N U a Ew H 0 0 0 a o a m .ti x F q 0 w w A m .N A a wu dew z as 0 H 0 r z E wW >❑ a 0 W H 7 F •• W N N , y .. m RC o F zU� q z o N w o se .. u m\ w �o u 0 0 m H E a O a w a H 0 0 0 0 W z a w a a 0 w a ►w Em ww F C7 �a Ha wa x U w aW H w N O a m 00 U> Ooo 10 m YI o In H (9 C7 U N I I I 1 1 I I I I I x 0 O I I I m m 0 v o 0 F 0 0 W o 0 2 0 0 W I W H W m m W aND m O U] m m fq m m u Ui C z r1 w H H w H H x m m •• w m H I !(J H � Q Q yi W E v N z Q a a it u N Q Q 1 � yiyi V A ti O r�zi I rYyi /� F m 4 .ti R ry' o W w 1 N Q m rn w I w E I I I 1 1 I I I I I x I I I a I I o I m I � N 1 I Ui C z n O � m •• H m I !(J a o El . 3 I yi H\ z Q a a z l u N Q Q 1 � yiyi V i ti O r�zi I rYyi /� F 1\i 4 R ry' o W w 1 N F m rn w I w E w W Ha a H w a x> wN HOU U> N O H O aH U O o U > m w W q w 000 0 No u N o o a o n E u l W N C7U H u 0 aw ronN 00 zzrz W NN HH Q>1 U N l'i 31 iV ri 'i A N N m 0 N .aH 00 a C7 N N off t+1H s z 4 m H .ti W : :: :: • ti A w E 04 as K ooh w o o w . W F H H O E q m m N N W 0 .N p 1qq� w wNN Nw .+x o•ri N W 30. Iml mO W 0 U w0 ❑m H d 4m .M O L[Q W mw mU m •• O OI o q H m > a tiro G m .H as m rd 10 .a to -H Orom O N o .i a r v ro u u a 0 H FC U w' u a w w > a ❑ U U W u w m q H H OI 9 � H ,-mi m fin' ,ti 16 m m 14 O 1� H 0 m o H m i o m o y > ro ro H ro a o A z N .N O 9 9 m .a O i+ a q m H� a, m 1 H 0 mm 0 Cq atP w o H a r W ti .i 3> ❑ .1 U .� m H ,Q a .i O �a W mro ON E H RC fL 0 Um Cw 4C VU as £ WW —O 0 a 0 W H a m H H H I I 1 I I I I I I I I I I I I I 11 I m N 1 I I I I I I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 'E O 11 1 I I I I I I I I I I I I I 1 I I 1 I I I I 1 a m I I I 1 I I 1 1 I I I U °> m m C m O m W N O O m O M N O O IO O m C M n O m O m O m N m C C W W F nn Mm CN a anmm lOHmanlo .- Imamnmmmm m 00 U m N N H H H m m m N a l m m m m �H m F a 1 1 1 1 H U 00 O w O N W N 0 0 0 0 N C 0 0 C n n b M m m m N m n C C H M M U 0 0 m M O M N O O O O O m M O 9M m m N m r m r lO H C M m C el el C 9 mm C N O l (1 N O O O O m m m O O M M 1(1 I f 1 tl 10 O b I (1 C C r r O m 1 f f Z W I n n r n O l (1 r H n O O m n r H N O n W m t D M O 1 f 1 N m M m M r C m m H 1 MM mmlo MN N mn HH r H mIOH r nmtpmCm m m0 HM m m H bb H H mm C NN m0; W C CmCHr H n N Iom ID N C N rl dl N ID W w W I I ❑! q I 00 l p O m C m O O O O N 1 D O O l p n M C M 1 f 1 m I (1 m m M W I O m r r ww F w 00 NMOIO m OOOOm IDOO mm C rmN m n MH W MH Nm 111 . . W U 1(1111 mN O C r m OOOIOM mOOm H C CIDM 0 mIOC C nN r N N 1(1 0 1 H N N r Cr'i NN rH0 N M rI M IUmNN mM OMMN r n H a a I H H O m r r C N N C m M C N r l0 M W C m m C O H m M M o a N ❑ I mm HH CNO C111NN HCIONHMIDH rHN C C C N H I ri rH rH rl rl rl C N 'H m rH C n n N M E zQ 1 w Q ❑ m I 00 O M O m C m N O N O N 0 0 0 C r M C m m m m m m M C l0 0 m m E w ; 00 ry MOlpm O r OOOmmOOMm C nNN Mr M 11. . . r. . . M . . rTi 0 MU. 1( N 111 N O C C n O O M N H W OOH H CCOM H1pmN m nNrm m O O I "N N n C r M N m N H m M r I M n m M N m n O M M m M M W O a a I '�'� o m r e el W a N c r a N n m M r c m N a o H M m m r W ❑ m m H H C N O C N m N N C IO N H 1 111 H H N M N N NN i H H H N H H C N H m m H H F N M M ro F °yI N 00 000000 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0 0 0 O 0 ill ❑ i o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0;00; 0 0 0 0 0 0 0 0 0 0 0 0 0 O . . iio ai 00 000000 00000000000000000000000 0 Ga wl vD �1 a u 1 x zl m I I O a w l 0O 00000 0 00000000000000000000000 0 , '�'�r'�.JJJ�oi o0 000000 00000000000000000000000 0 P IQ I o0 000000 000- c c 1n o00000,V omo 1no00oaom m a P 00 O 00m m O M HMN MOOMOO MOr m o 1()wm 111 w w m t11 O Ip .H m IO If1m CNIO rI I00N 0111 n 0111 C O N.H M M x Q I mm M O O C N H M C C r O H H IO m m H N H H H F W. N N H H N IO H C H m r m C C m 1 H M C C a H DQ W W I al 1 > INS 1 W FC w > W H W a O F C W 9 a m U w Cw9 11.�� a4 ralw > zw H DI a z ZwFCw wam w I>HtMHH W W W Q W W mo kaz z U[, U W Haw Vm »ax z W a 9 4 HZ H w'Zia E H m I waa wwE"l0 Fm wrA m 1 a a> W> H w a W a w W W W W E Om z w m Z> O W a w M 0 1 a a W $.. a a F a z a U w o m en a H m W W H u a a E•• I H H w F w a a p O a H W W . a W G. a KC C 9 U f H Z H H H "1 > >mpp;;m aHmU❑ >mamEw >z w H O >> > RC QP m Ww z >w Hw a aka a W •• a g g a g a W m d W w m w w >1 18 w H z 9 m u U .a F F w S g m H w w a R H �- C I !E W .�' 1 1 H �C H aL ❑ W 1 / . w H a a H W w U "WOW H w U a E F m w m F w H a u w w w W m z a W O w a w m a H O a z w a w o O w 4 F Mw O w 4 F U o w H UUD❑ a E a a W z FH z a M a F m w m a z w o Z F S -a moE u oi o Ea - wZNp 99aaaEa 1qZOWaz °Qax °qZ m El " W o H > Y� H m\ 1 1 M M M o n fE � o o oH oN om H r E lj c C m Io o H H M o H N M C m o o n 0 0H000000000000000 m o UMW 00 o F[ f[ O f E a a 1 N C ri E N N N N N F M M M M M M M M M M M M M M C C C C C C C F E F EN W W x� Ha N am U> I wa 00 N �a UO w N 0 N N M V W Q x ❑ NO as -1 x NF v ro r.D o N 41 La 'a H a1 0 �M gg q FC m 0 H a W a w x F a O N a x E F r° o w H H tiu'•a m H � w u�o❑ H ow z N O H\ W O W w \> aMa F I U I al 0 z H zz� W w a ❑ w Ww E W w U 00 as a Ez 'N H E y❑g Q 4 W w E W wU 00 as a P f. H U2 0.' RCC Q w P4 W U z w qapzw 4 00 I P 1 W ❑ I W I w I H 1 > I w. a1 00 00000 00O000000000000000000000 O 00 00000 O O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O O O OOO w 111 OOO n d oONOOOOO IIf o r 000000m M M 00 o o O M M 0 H 01 m n o o O o "On O m Mm M III w w w O n n w w N N 111 O N O M H O M N d o n HH N dNm N M N H01 IIIm wNl0 N 1p l0 N w H H r 1(1 m O O H N N > w W w a Iw0Q E W0 a w U W (w9 2mwqa a W P P F U H a m 0 W 4 oz W a H V P ❑ O Ow law w > W H VC1W 04 w xw O 0 In w W tC W W❑w .a HxwHHwa F4 C) wW O W w w UEU wHa W UEw » E W lax z a gq H z H W .1 F H w I ow a a W0 0 E w W w W w >w> Ha w.] W W a W W E Ow z ww z >❑ W 14 a a i a la m z a u w I o w w a H w w W H u a a H H W H W 04 o a H W a W W 0 .11 4 U E Z H H H > >wa w awUQ >wawaF W >z W Hrrtt O >> > FC ❑ w aw w z >W Hw .7 14a a 8 3aaa wwax m WWNwWWHz�ME) Ib FF w$ 3 w w ZC W 4z W W W w w w w X E O E+ Hz�. H IM U x w w w W W �aEa wm H a x4° a z� oac NDIJw' �'aP,OwHWW N maHm mo° gym oa�aw�xwE ° aHwa�a�aaEa �Ho O d OIf OOOHR( OHw000000000000000wO00t(Ij rj M M rF oNIOnF dddwlOOHHMOHNMdln000HmowFE F H w O O O O H H O O O O O O H N M d Ip m m m m m O H M M M N m O O O N d HE. N N N N F M M M M M M M M M N M N M M M d d d d d d d E F F I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 I III I(1 mOml(1n OOO.i OOIn OONm001d n001 n 0100101n n n n n H IoM n Innmw plot dmlo n to plH 01 wmmn n r .i N 01 rl 01 N OI m m M m m mm m m 00 n Om e-I 0000001 I(1000N IIf Nri t01I10001 MN Itlr m m 00 . d ONW lO N 00000 NN OOOOIOmOMOOMr wNpld w 111 I(11II N OOOMt0 l0 m III N t+IOO.i nr N ONHmOIMn d . d n n om(1 N O o 0 m m N 1N O M n W, N O v M M N N H H H H N H 1 I(1 1; O 1 N N 01 N t O I O N N d d d 00 M O N d 0I 0 0 0 0 0 O 1 1 f 1 O O O m l (1 III O I d w 0 0 01 n N I I1 M N N 00 . . w 0 n f O m O O O O O w n O O O O O I m t n 1 p N O M n d N O I w d d w w m O d CI N O O O O m ls� H O N n 01 m H n N B O N N H OI M O m . m NN n dO W HIOMNNdMlpNwnMdIpmN N 1010 m N nr m M W NM MIpNM H IOn NddI00IH 1OM IDd OI d d m m N M l O N N N N 1(1 O t M O t M N M O I d O O If1 N M d 1p Ip H H H 00 M O N d N d O N M 0 m n 0 0 0 m I (1 I f 1 N d N 0 0 0 r N 1(1 I O I (1 I I I 00 . w O n rm O\OdOO wM0000 mm dlon OMO dNOIH H . H I( m m OdtD 01 . . . . . . . . . . . . . m 0 0 w mI0 m ON 001 OI N OIN NON0HOIMN IO tp NN n d 01 N H d m o w d H M N H H M W N m M d W m M M WIZ, N nnm OI MI0I0NN H rNddIDt0Hl l0d Nn n m m N Ml0 N H H H N mM01MHM dN CI N w H M H N N N H N 00 00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 00 . 00000 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 00 00000 000000000000000000000000 . 0 00 00000 00O000000000000000000000 O 00 00000 O O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O O O OOO w 111 OOO n d oONOOOOO IIf o r 000000m M M 00 o o O M M 0 H 01 m n o o O o "On O m Mm M III w w w O n n w w N N 111 O N O M H O M N d o n HH N dNm N M N H01 IIIm wNl0 N 1p l0 N w H H r 1(1 m O O H N N > w W w a Iw0Q E W0 a w U W (w9 2mwqa a W P P F U H a m 0 W 4 oz W a H V P ❑ O Ow law w > W H VC1W 04 w xw O 0 In w W tC W W❑w .a HxwHHwa F4 C) wW O W w w UEU wHa W UEw » E W lax z a gq H z H W .1 F H w I ow a a W0 0 E w W w W w >w> Ha w.] W W a W W E Ow z ww z >❑ W 14 a a i a la m z a u w I o w w a H w w W H u a a H H W H W 04 o a H W a W W 0 .11 4 U E Z H H H > >wa w awUQ >wawaF W >z W Hrrtt O >> > FC ❑ w aw w z >W Hw .7 14a a 8 3aaa wwax m WWNwWWHz�ME) Ib FF w$ 3 w w ZC W 4z W W W w w w w X E O E+ Hz�. H IM U x w w w W W �aEa wm H a x4° a z� oac NDIJw' �'aP,OwHWW N maHm mo° gym oa�aw�xwE ° aHwa�a�aaEa �Ho O d OIf OOOHR( OHw000000000000000wO00t(Ij rj M M rF oNIOnF dddwlOOHHMOHNMdln000HmowFE F H w O O O O H H O O O O O O H N M d Ip m m m m m O H M M M N m O O O N d HE. N N N N F M M M M M M M M M N M N M M M d d d d d d d E F F W rr E x c� H ww x� as H w N O U> 00 N N w Fa H [7 U N H 0 N rl V A x c7 mo as .a E N b N N 00 N W JJ O �M aFa �7 X w� w 0 od H W a w x F P4 0 N a x £m F w N o U]HH vi I"• a a COQ U coq H zNo H \ woa Hw m\> VNw a a U i al z zWl H u I Z � I H I WWI a I ❑w1 E. WN EI 0 U 1 001 aa1 a1 E 'N H H I E z❑z 1 � a ❑ U1 I W E W I W I mu1 02 a 1 FZI 2: H I E g❑g rC FC a w V z F-1 ❑ W U H w a i I I I I I m H O O m N H m O O m a M N rt N r m N w M I 0 O 0 w m � a m w E 2 H a a m 0 0 U w a a E O o a F W ❑ a E 0 F r Ww � E � Ha a �o H u >, W N 00 U U > m wya Ooo No IfI N o o a 7.o ui N u HOD H u 0 aW goti °O z2\2 v N N Sai ti ti N N H O> ti H H 00 x o� MH £ z>. FCC z q ro W 0 0 m 00 a �•❑ o as o W H O •_ W �.0 >� a NOH ~ wNN 0W .aiX 0-H m wN a m0 0 0 ao Wow m m•• o ma a v >arnro m .N a s m ro ro O r1 0 11 ro o .-I J� a v m 11 U a o '0 Fi �H N a U a n1W Na omr 0 ue H mF F N u H 0 a ,. ro H ro ro ao a a .,9 H0ro a S4 0 W O W > roro 11 W N 0 ro a❑ ro m z N .ri 0 a 9 m '-I 0 1� a W H\ 1� mro M 00 WW a1, a aIT' wo H as a HH 3> ❑ .N UFO Haa H O .i7 a ro ro 0 E pxr1a O NW--o ah !J'. O a H a WH x �w x� 4 0 H N a o W 0 I as Oo N N � Ea H � U 0 N H In U W 0 aOa�� Nx qF ri roti .I o 'a N V � O N Cy T ❑ 0 H a w a W a 0 a a WN� r�H W •• a W H I� Q a W UWq ZNO H \ a0a w Ur1 W Q a E I U al I I I H H U z I N Q I I W W I a I q W I W W I E W wu a1 F2 F ❑ I a � 1 ❑ W I W W I E W 00 I aal Nl H F y❑y I 4 4 .] F Q W pq1 a 1 W I H I D I wl al E I W I [� 1 B w 1 I W E a of ❑I Q I 1 I I I I I I I I I I I I 1 1 1 I I I I I I I 1 1 1 1 1 1 11 I I I I I I I 11 11 I 1 I I I I I I 1 I I I I 1 1 1 1 I m m y m m m m p mmnlcmmmo 0 0 m m m m I I 1 I I l0 O r O t+1 C O N N N l0 (+1 O m O O l(1 1(1 It) m 1p N r1 10 1l1 W m W H n O 10 N O N N orlommnco 0 HNOH 1+ C r n •i w o m O r C O N N Nm1000001l1 W N t0 m N .i l0 I(1 1+1 t+1 lD r1 r10 C.i O1(1 N O r r H r r C H H 10 l0 I(1 W m 10 0 M 0 n C O N N N 10 H O O n 0 N N I(1 l0 O N .-1 C Ill 1(1 111 1DH r'110C W OI"1 N onr.- Incwrl N •-I N r N ll1 o O O ID 10 M H H N N C C 00000000 0 Oo00oo00 O O O 10 C I(1 O O W If1 Il) 1p O N N c m r H H H c m 10 to W m m N M M 00000000 O o O O O O O O O O a 0 W a F a 2 `m ppEl O ��aa77 za"m ZQ V O 2 9 E 2> q w Z I F4 z V4 14 Fz�HWasX 14 > a�o�dzuWq > IWW�Z HWO W HH W W 7L1 E- W zo W awHO0zO o4w OOO W ON OIj I.a m N N N m O N Q Q 0 orHi lNO"e 1NOm m0 O N oNln 1+11n r1 nrNF E v, 1(1wO N N 1 m n N H .-i c m 10 10 M N M a 0 W a F a 2 `m ppEl O ��aa77 za"m ZQ V O 2 9 E 2> q w Z I F4 z V4 14 Fz�HWasX 14 > a�o�dzuWq > IWW�Z HWO W HH W W 7L1 E- W zo W awHO0zO o4w OOO W ON OIj I.a m N N N m O N Q Q 0 orHi lNO"e 1NOm m0 O N oNln 1+11n r1 nrNF E v, E N W W x� rC w H w N O 00 U> I as O o N �a N ti 0 N N m V W A O a qF N .a o � N 0 �o 91 O a a W E a O w a En E El W N O W H H N m m •• a m H uwo j o a z N O H \ a o W �ma E I V I a I 0 zz�, H y a om W W E W W U 00 as al P z l H I E2A 4� O m I W N 1 El F4 M U 0a a al Hz E z❑ I Q I aEl CJ I w. m I H I > I W I al E I W I 0 I B. (n 1 I W E N I r O m FC a a > S w N I I I 1 I I I 1 11 I I I 1 i I I I I 1 I I I 1 I N t} rmr n m w m r m m oolnH W Nmamin l p m m m N m min lnm N r N N 0 oomn w m N I (1 m C m m C m H C w w m l o V m N m C d N C N N H C N N In o In m .I W N 1(1 (+1 m mmsNw y� amwrlm N C 1I1 N O m W NI(1N N H N N N 00000 00000 w m O o a WON m NNW m mom m O H N m 00000 00000 w m o o a OWN m N N m m m 1 n M m o H m m m E WWp cWl Ez >❑ z W W W waax ySy H a Z V a WHmVI >aHm o ow 14E >zzsZ� z0z °oc�a O M O H N N m o 7 N N N r E o w w w m o o m m m m E I I I I n r a m N m m C ti w m In C N H m C 0 N 0 0 Im+l m rHi 0 0 m 1+1 m m O m RC a a > S w .a� F E Fm H x c� FC w w N £ O am 00 V9 Oo N �a H V U m 0 N eI M U W x c� 0 0 Nx 9 E+ .ti .-I v In vH -.I o � N G o v T, Q 0 H a w a w x F a 0 m 0 Q a WN O F •• W H H y N a m H Q E H W U e q H O ZNO H \ a O W U m W � a H UI m al I N I O I z w i o H V I o H I ID I w w I a I Qml m wml m E W I m V I w 02 I H aaI w al Q I m E ❑ I I I q m I N W m I H E W I m U I o 00 N a a al q ti E 7. I N F 22❑ I 4 Q 7 E I o rC W I o I q i m Q H w I ul I ❑ I � wl m m I 1D H I I W I P4l E I o W I o (f I ❑ I m D I H W I 1(1 I r{ W I m F I m al of ❑I I I z � H a I a I O P4 I p I U W I a r a F O o a E gpw 2 U' 7 O F HRA RESOLUTION 2016 -01 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JULY, AUGUST, AND SEPTEMBER, 2015 & PAYMENT OF BILLS FOR THE MONTHS OF JULY, AUGUST, AND SEPTEMBER, 2015 AND APPROVING DISBURSEMENTS, EXPENDITURE GUIDELINES AND REVENUE REPORTS. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (HRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the HRA to examine the statement and treasurer's vouchers or bills and if correct, to approve them by resolution and enter the resolution in its records; and WHEREAS, the financial statement for the months of July, August and September, 2015 and the list of bills for the months of July, August and September 2015, & Disbursement Reports, Expenditure Guidelines and Revenue Reports are attached hereto and made a part of this resolution; and WHEREAS, the HRA has examined the financial statement, the list of bills and the corresponding reports 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, and financial reports which are attached hereto and made a part hereof, anc 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 14`h day of March, 2016. MOTION BY: SECONDED BY: AYES: Chair Attest by: Shelley Hanson, Secretary COLUMBIA CN HEIGHTS AGENDA SECTION OTHER BUSINESS ITEM NO. 6 MEETING DATE MARCH 14, 2016 COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY- HRA LETTER ITEM: APPROVE REPAYMENT OF NORTH BUILDING OPERATING GRANT TO HUD DEPARTMENT: Finance EXECUTIVE DIRECTO S APPROVAL: BY /DATE: Joseph Kloiber /March 10, 2016 BY /DATE:3 IZ BACKGROUND: Under the terms of the sale of Parkview Villa to Aeon, the HRA must repay to the U.S. Department of Housing and Urban Development (HUD) the remaining unused portion of the HUD operating grant received as a rent subsidy for the North building. This operating grant was received by the HRA in annual installments over many years. During the years of operation, the HRA was allowed to retain the unused portion as a reserve to cover possible large or unexpected building expenses of the North building. The repayment is due to HUD by March 24, 2016. After payment of all final expenses allocable to the North building, the remaining unused portion is $927,139. This is roughly equivalent to 18 months of operating budget for the North building. The final expenses are included in the financial report dated December 31, 2015, provided in this agenda packet. The final expenses were determined by combining: • Routine expenses recorded by the management company CommonBond. • Amounts paid through the title company at closing, such as closing fees and prorated utilities. • Certain items paid through the City finance department and charged to the HRA, such as the final audit and legal costs. The $927,139 repayment of the operating grant to HUD is in addition to the $5,200,000 the HRA has agreed to pay HUD from the sale of the North building and land. That $5,200,000 payment is not due however, until the HRA collects the sales price from the buyer Aeon in 30 years. Lastly, no part of this HUD repayment relates to the reserve from the South building, as HUD has no participation in the South building. The remaining reserve from the South building is $1,008,450; and it is limited to purposes related to housing. STAFF RECOMMENDATION: Staff recommends approval of the following motion. RECOMMENDED MOTION: Move to approve the repayment of the unused operating grant to U.S. Department of Housing and Urban Development, in the amount of $927,139. HRALetter 031416Meeting_Agendaltem6.docx COLUMBIA HEIGHTS AGENDA SECTION OTHER BUSINESS ITEM NO. 7 MEETING DATE MARCH 14, 2016 CITY OF COLUMBIA HEIGHTS - HOUSING AND REDEVELOPMENT AUTHORITY ITEM: Parkview Villa Construction Update DEPARTMENT: Housing and Redevelopment Authority EXECUTIVE DIRECTOR'S APPROVAL: BY /DATE: Joe Hogeboom, February 26, 2015 BY /DATE: Walter Fehst, Aeon Housing began a massive construction and remodeling project at Parkview Villa immediately following the sale of the property in late September, 2015. The scope of work involves extensive renovations to the building's interior public spaces and some of the dwelling units, reconfiguration of and an addition to ground floor public spaces, new windows, updating /replacement of building mechanical and electrical systems and installation of new siding to the "south" building. Outdoor gathering areas will also be reconfigured. The project is approximately half complete. Most public spaces in Parkview Villa are currently temporarily closed due to construction. The project is expected to be complete in the fall of 2016. City of Columbia Heights - HRA Letter CH COLUMBIA HEIGHTS AGENDA SECTION OTHER BUSINESS ITEM NO. 8 MEETING DATE MARCH 14, 2016 CITY OF COLUMBIA HEIGHTS — HOUSING AND REDEVELOPMENT AUTHORITY ITEM: Proposed New HRA Format Discussion DEPARTMENT: Housing and Redevelopment Authority EXECUTIVE DIRECTOR'S APPROVAL: BY /DATE: Joe Hogeboom, February 26, 2015 BY /DATE: Walter Fehst, Tonight's HRA meeting will serve as the last regular meeting of the Housing and Redevelopment Authority (HRA). Because the HRA technically needs to exist as a legal entity if there are outstanding contracts with the U.S. Department of Housing and Urban Development (HUD), the HRA may not be dissolved. Staff and the EDA /HRA Attorney discussed the future of the HRA, and came up with a proposal to amend the bylaws of both the EDA and the HRA to allow the same members of the EDA to serve as members of the HRA. Under this new arrangement, the HRA would have to convene at least once a year to discuss HUD - related business. However, meetings could occur adjacent to EDA meetings and involve the same people. If the HRA is amenable to this course of action, staff will bring proposed bylaw changes to an upcoming EDA meeting. Staff seeks direction from the HRA in moving forward with changes that would allow EDA members to serve as members of the HRA. City of Columbia Heights - HRA Letter