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