The URL can be used to link to this page

Home My WebLink About04-22-2014 HRA AgendaHOUSING & REDEVELOPMENT AUTHORITY AGENDA 7:00 P.M. April 22, 2014 Parkview Villa, Community Room B, 965 40 "' AVE., COLUMBIA HEIGHTS, MN 1. Call to Order 2. Roll Call Tammera Diehm, Chair Bruce Nawrocki Bobby Williams, Vice Chair Donna Schmitt Secretary/Treasurer Rheta Nelson Gary Peterson 3. Pledge of Allegiance CONSENT AGENDA 4. Approve minutes of January 28, 2014 5. Resolution 2014 -06 —Approve Financial Report and Payment of Bills for January, February and March, 2014 Motion: Move to approve consent items as listed. BUSINESS ITEMS 6. Repot of Management Company 7. Resident Council Minutes 8. Citizen Forum* 9. Resolution 2014 -07 — Aeon Purchase Agreement Extension Motion: Move to waive the reading of Resolution 2014 -07 there being ample copies available to the public. Motion: Move to Adopt Resohttion 2014 -07 Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) Approving First Amendment to Purchase Agreement Dated April 22, 2014 for the Sale of Parkview Villa North and South to Aeon. 10. Administrative Update The next HRA meeting will be July 22, 2014 at Parkvienv Villa. *At this time, citizens have an opportunity to discuss with the I -IRA ite ins not on the regular agenda. The citizen is requested to limit their conmrents to five minutes. Please note the public may address the HRA regarding specific agenda items at the time the item is being discussed. COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) Meeting of: April 22, 2014 AGENDA SECTION: Consent Agenda ORIGINATING EXECUTIVE NO: 5 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Financial Report and Payment of Bills BY: Joe Hogeboom BY:ki *Z — Resolution 2014 -03 DATE: April 16, 2014 BACKGROUND: A copy of the Financial Reports for the months of January, February and March 2014 is attached. RECOMMENDATION: Parkview Villa and City staff will be available to answer specific questions about the Financial Reports. Following questions (if any), it is recommended that 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 2014 -06, there being ample copies available to the public. Motion: Move to approve Resolution 2014 -06, Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills for the months of January, February and March 2014. HRA ACTION: RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JANUARY, FEBRUARY AND MARCH, 2014 AND PAYMENT OF BILLS FOR THE MONTHS OF JANUARY, FEBRUARY AND MARCH, 2014. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (HRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the HRA to examine the statement and treasurer's vouchers or bills and if correct, to approve them by resolution and enter the resolution in its records; and WHEREAS, the financial statement for the months of January, February and March, 2014 and the list of bills for the months of January, February and March, 2014 are attached hereto and made a part of this resolution; and WHEREAS, the HRA has examined the financial statement and the list of bills and finds them to be acceptable as to both form and accuracy. NOW, THEREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that it has examined the attached financial statements and list of bills, which are attached hereto and made a part hereof, and they are found to be correct, as to form and content; and BE IT FURTHER RESOLVED the financial statements are acknowledged and received and the list of bills as presented in writing are approved for payment out of proper funds; and BE IT FURTHER RESOLVED this resolution and attachments are to be made a part of the permanent records of the Columbia Heights Housing & Redevelopment Authority. Passed this 22 "d day of April 2014 MOTION BY: SECONDED BY: AYES: Chair Attest by: Shelley Hanson, Secretary 0 EA I Parkview Villa North Financial Statement Overview January 2014 Revenue: Occupancy for the month of January 2014 was 96% occupied; Rent Revenue was under budget (unfavorable) due to vacancy Total Revenue for January was under budget (unfavorable) due to no grant income drawn down Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Legal Services was under budget (favorable) Misc. Admin Expenses was under budget, (favorable) Utilities: Utilities Expenses were over budget (unfavorable) Fuel Oil was under budget (favorable) Electric was under budget (favorable) Gas was over budget (unfavorable) and reflects December billing Water was over budget (unfavorable) and reflects a quarterly billing Sewer was under budget (favorable) and also reflects quarterly billing Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable) Janitor Supplies was over budget (unfavorable) Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract was under budget (favorable) Garbage and Trash was under budget (favorable); however, this is a quarterly billing Security Contract is under budget (favorable). Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs is over budget (unfavorable) and reflects the cost of boiler repairs Snow Removal Contract was over budget (unfavorable) Account 203.46330 City of Columbia Heights HRA Expenditures for Fiscal vlew Villa North & South a Actual Y'fO Actual MTO Object Code Classification Parkvlew Villa North 8,752 8,752 Personnel Services 314 314 Supplies 24$17 24,317 Other Services & Charges Budget Balance 105,024 96,272 24,690 24,376 379,537 355,220 Parkvlew Villa South 3,932 47,184 43,252 213.46340 3,932 15,477 14,138 Personnel Services 1,339 1,339 164,546 Supplies 12,833 12,833 177,379 35,000 Other Services &Charges 95,000 nen 256,93fi Parkview Villa -North Balance Sheet January 2014 Books = Accrual tan -14 Assets 85,380.79 10100 Cash Balance 457.00 10200 Petty Cash 891,214.11 10400 Investments 3,162.83 11300 Rent Receivable 218.12 11500 Accounts Receivable 4,260.06 13100 Due From Other Funds 984,692.91 Total Assets Liabilities 14,775.66 20200 Accounts Payable 1,424.58 20210 Accrued Other Expenses 551.74 20220 Due to Resident Council 17,761.94 22000 Deposits 26,691.19 22200 Accrued PILOT 3,657.12 22210 Revenue Collected in Advance 64,862.23 Total Liabilities Fund Balance 919,830.68 25300 Fund Balance 919,830.68 Total Fund Balance 984 692 91 Total Liabilities and Fund Balance -- Parkview Villa -North income Statement For The Period Ending January 2014 Books = Accrual Revenue 33160 -46330 Federal Grant 36220 -46330 Gen, Government Rents 36225 -46330 Nondwelling Rents 36290 -46330 Other Miscellaneous Revenue 39120 -46330 Recovery Damage City Property Total Revenue Expenses Personal Services 1000.46330 Accrued Salaries Total personal Services Supplles 2000.46330 Office Supplies 2010 -46330 Minor Equipment 2160 -46330 Malm, & Construct Materials 2171 -46330 General Supplies Total Supplies Other Services & Charges 3040 -46330 Legal Fees 3050 -46330 Expert and Professional Services 3060-46330 Management Services 3100 -46330 Protective Services 3210 -46330 Telephone &Telegraph 3430 -46330 Advertising Other 3600 -46330 Insurance & Bonds 3810-46330 Electric 3820 -46330 Water 3830.46330 Gas 3840 -46330 Refuse 3850.46330 Sewer 4000 -46330 Repair & Maint. Services 4100 -46330 Rents &Leases 4300 -46330 Miscellaneous Charges 4315 -46330 PILOT 4390.46330 Taxes & Licenses 4500 -46330 Administrative Expenses 4850.46330 Interest on Deposits Total Other Services & Charges 2/13/2014 2:49 PM o/ Year to Date Month to Date Page 3 of 9 .00% 0 0.00% 97.37% 29,158.00 97.37% 29,158.00 1.10% 330.00 1.10% 330.00 459.10 1.53% 459.10 1.53% 0.00% - o.ao ro 100.000/0 29,947.10 100.000/0 29,947.10 29.22% 8,752.00 29.22 % 8,752.00 29.22% 8,752.00 29.220/0 8,752.00 -0.45% - 134.84 -0.45% - 134.84 0.00% 0.00 0.00% 0.00 49.95 0.17% 49.95 0.17% 1.33% 398.57 1.33% 398.57 313.68 1.05 ° /a 313.68 0.00 0.00% 0.00 0.00% 0.00% 0.00 0.00% 0.00 15.93% 4,772.00 15.93% 4,772.00 0.00 0.00% 0.00 0100% 0.21% 62.73 0.21% 62.73 0.00 0.00% 0.00 0.00% 4.76% 1,424.58 4.76 % 1,424.58 10.60% 3,173.34 10.60% 3,173.34 7.070/ 2,117.06 7.07% 2,117.06 26.44% 7,916.78 26.44% 7,916.78 0.00% 0.00 0.00% 0.00 3.02% 904.43 3.02 % 904.43 6.36% 1,904.01 6.36% 1,909.01 20.00 0.07% 20.00 0.07% 0.05% 13.93 0.05% 13.93 6.86% 2 ,053.17 6.86% 2,053.37 0.00% 0.00 0.00% 0.00 -59.09 -0.20% -59.09 -0.20% 13.66 0.05% 13.66 0.05% 81.20% 24,316.60 81.20% 24,316.60 Page 3 of 9 2113/2014 2:49 PM Capital Outlay 0.00 5120 -46330 Building & Improvements 0.00 0.00 °% - 0.00% 0.00 0.00% 0.00 Total Capital Outlay 33,382.28 111.47% 33,382.28 111.47% Total Expense - 3,435.18 - 1147% - 3,435.1 8 - 11.47% EXCeeS (Deficit) Revenue over Expense Page 4 of 9 2113/2014 2:49 PM Parkview Villa -North (165; Cash Flow Statement Pei led = January 2014 Book = Accrual Month to Date Revenue 0.00 33160 Federal Grant 29,158.00 36220 Gen. Government Rents 330.00 36225 Nondwelling Rents 459.10 4 59 36290 Other Miscellaneous Revenue 0.00 39120 Recovery Damage City Property 29,947.10 Total Revenue Expenses Personnel Services 8,752.00 1000 Accrued Salaries 8,752.00 Total Personnel Services supplies -134.84 2000 Office Supplies 0.00 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 448.52 2171 General Supplies 0.00 2280 Vehicle Parts 313.68 Total Supplies Other Services & Charges 0.00 3040 Legal Fees 0.00 3050 Expert & Professional Services 4,772.00 3060 Management Services 0.00 3100 Protective Services 62.73 3210 Telephone & Telegraph 0.00 3430 Advertising Other 1,924.58 3600 Insurance & Bonds 3,173.34 3810 Electric 2,117.06 3820 Water 7,916.78 3830 Gas 0.00 3840 Refuse 904.43 3850 Sewer 1,904.01 4000 Repair & Maint. Services 0.00 4050 Garage, Labor Burd. 20.00 4100 Rent & Leases 13.93 4300 Miscellaneous Charges 2,053.17 4315 PILOT 0.00 4390 Taxes & Licenses -59.09 4500 Administrative Expenses 13.66 4850 Interest on Deposits 0 0 5120 Building & Improvement 24,316.660 Total Other Services & Charges 33,382.28 Total Expenses - 3,435.18 Excess (Deficit) Revenue over Expenses Page 5 of 9 Padcviev, Villa -North (165) Cash Flow Statement Period = January 2014 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash 2113/2014 2:49 PM Month to Date 0.00 0.00 - 492.50 86.00 0.00 0.00 14,091.91 - 6,728.71 -79.15 2,053.17 - 308.94 8,621.78 5,186.60 Beg Cash End Cash Difference 80,194.19 85,380.79 5,186.60 871.00 871.00 ' 891,214.11 891,214.11 - 972,279.30 977,465.90 5,186.60 Page 6 of 9 Parkview Villa -North (165) General Ledger Period = Jan 2014 1000 463363i 0 Accrued Salaries 9,752.00 0.00 8,752.00 R/C CMG PR Mgmt Fee 165 1/31/2014 01/2014 PostRecurring Monthly recurring RC 8,752.00 = Ending Balance = Net Change = 8,752.00 0.00 = Beginning Balance = 2000.46330 Office supplies Office Depot(offi8804) 6.894E+11 19.38 0.00 19.38 creamer notes;tls 165 12118/2013 01/2014 Office Depot(off18804) 6.894E +11 24.23 0.00 122.12 copier ellocationup 165 12/11/2013 01/2014 City of Columbia Heights (colu) 4563 43.61 12/13 exp Inv to 1/14 - Col 165 12/31/2013 01/2014 01/2014 12/13 exp Inv to 1/14 - :Reversal of 0.00 78.51 0.06 exp Inv toe 1/14 - Df81 165 1/1/2014 01/2014 12/13 exp Inv to 1/14 - :Reversal of 0.00 43.61 manual 20 3 140.06 165 1/112014 01/2014 Common6ond Housing (chc) 0.0 - 134.84 shipments 1/9-1/15/14011314maO( 165 1/13/2014 1/22/2014 01/2014 FedEx(fedex) 253594628( 8.22 - 134.84 = Ending Balance = 165 Net Change=- 134.84 0.00 = Beginning Balance = Maint. & Construct Materials 15.06 payment discrepancy 0.00 Y 2160 -46330 01/2014 HD Supply Facilities Maintenance 1.804E+09 15.06 0.00 28.96 late late 165 12/6/2013 01/2014 Home Depot Credit Services (lion FCH005184c- 13.80 77.61 toilet 165 12124/2013 01/2014 HD Supply Facilities Maintenance 909 40.00 57.61 12/13 exp Inv to 1/14 - Ada 165 12/30/2013 01/2014 12/13 exp Inv to 1/14 - Reversal 20.00 63.81 -6.20 12/13 exp Inv to 1/14 - HD 165 1/1/2014 0112014 12/13 exp Inv to 1/14 - :Reversal of 0.00 13.80 -20.00 12/13 exp Inv to 1/14 - Hon 165 1/1/2014 1/1/2014 ;Reversal of 01/2014 12/13 exp Inv to 1/14 - iRe ersR 0.00 37.82 0.00 17.82 poly tape;heat tape 165 1/2/2014 01/2014 Frattalone's /Metro Ace (frat) 32.13 0.00 49.95 valve /bulb /handle 165 165 1/7/2014 01/2014 HD Supply Facilities Maintenance 9.127E +09 49.95 = Ending Balance = Net Change =49.95 0.00 = Beginning Balance = 2171 -46330 General supplies 196.98 toilet trash baus;ppr 37.63 0.00 239.61 disposable gloves 165 1/15/2014 01/2014 HD Supply Facilities Maintenance 9.127E +09 163.96 0.00 398.57 green seal /towels 165 1/17/2014 01/2014 Buckeye Cleaning Centers (buck8 790835 398,57 = Ending Balance = Net Change= 398.57 0.00 = Beginning Balance = 3060.46330 Management Services 13,524.00 0.00 13,524.00 mgmt fees 01 1 165 1/30/2014 01/2014 CommonB Ond Housing (chc) 013014n 0.0 0 8,752.00 4,772.00 R/C CHC PR Mgmt Fee 165 1/31/2014 01/2014 :PostRecurring Monthly recurring RC 4,772.00 = Ending Balance = Net Change = 4,772.00 0.00 = Beginning Balance = Telephone & Telegraph 0.00 221.28 phone- 12/01 -12/31 1 3210 -46330 12/31/2013 01/2014 POPP.COm (Popp) 992156094 221.28 0.00 221.28 0.00 12/13 exp Inv to 1/14 - POP[ 165 01/2014 12/13 exp Inv to l/14- :Reversal of 0.00 56.55 net- 01/11- 02/10/14 165 1/1/2019 01/2014 Comcast (comc3422) 8772105050 56.55 0.00 62.07 late fee 165 1/2/2014 01/2014 Comcast(comc3422) 8772105050 5.52 0.00 62.73 N- 01/11- 02/10/14 165 1/2/2014 1/2/2014 01/2014 Comcast(comc3422) 877 2105050 0.66 62,73 = Ending Balance = 165 Net Change =62.73 0.00 = Beginning Balance = 3600.46330 Insurance & Bonds 1,424.58 0.00 1,424.58 C of Columbia Heights Ins A 165 1131/2014 01/2014 :PostRecurring Monthly recurring RC 1,424,58 = Ending Balance = Net Change= 1,424.58 0.00 = Beginning Balance = 3810 -46330 Electric 5150441553 3,183.59 0.00 3,183.59 a 12/6/13-1/7/14 165 1/13/2014 01/2014 Xcel Energy (xcel) 5150441553 0.00 10.25 3,173.34 e- refund -69% 165 1/13/2014 01/2014 Xcel Energy (xcel) 3,173.34 = Ending Balance = Net Change= 3,173.34 0.00 = Beginning Balance = 3820 -46330 Water 1 170 0 1 ty 0.00 1 , 701.93 penalty 165 1/9/2014 01/2014 City of Columbia Heights (colu) 3180250000 12/27/13 145.03 O.OD 117.06 penalty 1/912014 01/2014 City of Columblia Helights (colu) 3180245000 = ndl 2,117.06 =Ending Balance = , 165 Net Change= 2,117.06 0.00 = Beginning Balance = 3830 -46330 Gas 551996570 7,916.78 0'00 1= = 165 1/8/2014 01/2014 CenterPolnt Energy (cent) 7,916.78 Ending Balance Net Change = 7,916.78 0.00 = Beginning Balance = 3850 -46330 Sewer City of Columbia Heights (colu) 3180250000 766.44 0.00 766.44 S- 09/27 -12/27 165 1/9/2014 0112014 01/2014 City of Columbia Heights (colu) 3180245000 137.99 0.00 904.43 = En/ding Balance = 165 1/9/2014 Net Change= 904.43 0.00 = Beginning Balance = Repair & Maint. Services 716.82 0.00 716.82 elev maint- 01/01 - 01/31/14 165 1/1/2014 165 1 1/20 01/2014 Ronelnhanicae) 221363779 375.26 0.00 1,092.08 heater repair 165 1/15/2014 01/2014 LBP Mechanical, Inc (Ibpm) W19776 0.00 1,510.02 MUA repair 165 1115/2014 01/2014 LBP Mechanical, Inc (Ibpm) W19777 417.94 0.00 1,552.11 Ice melt 165 1/7/2014 0112014 HD Supply Facilities Maintenance 9.127E +09 42.09 0.00 165 1/15/2014 01/2014 High Profile Grounds Maintenance 28750 351.90 11,9 4.01 =l End ,02Balance = Net Change =0.00 0.00 = Beginning Balance = 4100 -46330 Rents & Leases 20.00 0.00 resident l2 /13 165 12/31/2013 01/2014 Multihousing Credit Control (mult 13120343 20.00 nce Ending Balance Net Change =20.00 0.00 = Beginning Balance = 4300 -46330 Miscellaneous Charges 20.89 0.00 20.89 keys 165 12/27/2013 01/2014 City Wide Locksmithln9, Inc. (cit) 1678 0.00 2]8.04 locks &repairs 165 12/27/2013 01/2014 City Wide Locksmithing, Inc.(Gty 3810 257.15 p Inv to 1/14 -City IGS 111/2014 01/2014 12/13 exp Inv to 1/14 - sal of 27 0.00 13 93 cut keys 165 1/14/2014 01/2014 City e Locksmithing, Inc. (clt13654 Wide 13.93 13.93 = Ending Balance = Net Change =13.93 0.00 = Beginning Balance = 4315 -46330 PILOT 2,053.17 0.00 2 ,053 Anoka Property Tax ccr 165 1/31/2014 01/2014 :PostRecurring Monthly recurring RC 17 ty Bolan a Net Change = 2,053.17 0.00 = Beginning Balance = 4500 -46330 Administrative Expenses 0.00 59.09 manual = 165 1113/2014 0112014 CommonBond Housing (chc) 011314mam .59.09 Ending Balance Net Change = -59.09 0.00 = Beginning Balance = Ineterest on Deposits 13.66 0.00 13.66 Sec Dep Interest accrual 165 1/31/2014 16S 1 31/2 01/2014 Sec Dep Interest accrual GIS 13.66 = Ending Balance = Net Change =13.66 w43,065.73 9,683.45 Parkview North Payment Summary Bank= 165opr AND mm /yy= 01/2014- 01/2014 AND All Checks =Yes AND Include Voids =All Checks Check Post Total Bank Check* Vendor Date Month Amount 202.15 165opr - Parkview Villa North 2296 chc - CommonBOnd Housing 01/07/2014 01/2014 01/2014 20.89 165opr - Parkview Villa North 2297 clty4054 - City Wide Locksmithing, Inc. 01/07/2014 01/2014 37.82 165opr - Parkview Villa North 2298 frat - Frattalone's /Metro Ace - HD Supply Facilities Maintenance, Ltd. 01/07/2014 01/07/2014 01/2014 327.77 1650pr - Parkview Villa North 2299 home7 kenn - Kennedy & Graven, Chartered 01/07/2014 01/2014 664.70 1650pr - Parkvlew Vllla North 2300 2301 city4054 -City Wide Locksmithing, Inc. 01/14/2014 01/2014 257.15 165opr -Parkvlew Villa North - City of Columbia Heights 01/14/2014 01/2014 1,888.01 165opr - Parkview Villa North 2302 2303 Cole home7 - HD Supply Facilities Maintenance, Ltd, 01/14/2014 01/2014 94.79 1650pr - Parkview Villa North 2304 home9055 - Home Depot Credit Services 01/14/2014 01/2014 72,84 165opr - Parkvlew Villa North 2305 IUpm - LBP Mechanical, Inc 01/14/2014 01/2014 337.61 165opr -Parkview Villa North multi - Multihousing Credit Control 01/14/2014 01/2014 20.00 165opr - Parkvlew Villa North 2306 01/14/2014 01/2014 43.61 165opr - Parkview Villa North 2307 off6804 - Office Depot 01/21/2014 01/2014 51.91 165opr - Parkvlew Villa North 2308 adam - Adam's Pest Control, Inc. 01/21/2014 01/2014 13.93 165opr - Parkview Villa North 2309 clty4054 - City Wide Locksmithing, Inc. 01/21/2014 01/2014 62.73 165opr - Parkview Villa North 2310 comc3422 - Comcast high8236 - High Profile Grounds Maintenance, I 01/21/2014 01/2014 351.90 165opr - Parkvlew Villa North 2311 home7 - HD Supply Facilities Maintenance, Ltd. 01/21/2014 01/2014 15.06 1650pr - Parkvlew Villa North 2312 kocl - K.O. Cleaning and Restoration LLC 01/21/2014 01/2014 1,000.00 165opr - Parkvlew Villa North 2313 01/21/2014 01/2014 996.23 165opr - Parkview Villa North 2314 Ibpm - LeP Mechanical, Inc 01/21/2014 01/2014 397.44 165opr - Parkvlew Villa North 2315 else - Olsen Fire Protection, Inc. 01/21/2014 01/2014 221.28 165opr - Parkview Villa North 2316 pope - Popp.com 01/21/2014 01/2014 205.93 165opr -Parkvlew Villa North 2317 sher4110 - Sherwin- Wlllia ms Co. 01/28/2014 01/2014 163.96 165opr - Parkview Villa North 2318 buck8411 - Buckeye Cleaning Centers 01/28/2014 01/2014 7,916.78 165opr - Parkview Villa North 2319 Energy cent - City 01/28/2014 01/2014 5,785.61 165opr - Parkvlew Villa North 2320 of Columbia Cole -City of Columbia Heights - HD Supply Facilities Maintenance, Ltd. 01/28/2014 01/2014 48.75 165opr - Parkview Villa North 2321 home7 01/28/2014 01/2014 205.71 165opr - Parkvlew Villa North 2322 t0030792 - Oswald 01/28/2014 01/2014 3,173.34 165opr -Parkview Villa North 2323 zcel - Xcel Energy 24,577.90 Parkview Villa South Financial Statement Overview January 2014 Revenue: Occupancy for the month of January 2014 was 80 % occupied Total Revenue was lower than budget amount (unfavorable) and reflects occupancy and rent concession paid in Jan Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were over budget (unfavorable) and reflect costs of marketing Other renting expenses were under budget (favorable) Office Supplies was under budget (favorable) Legal Expenses were under budget (favorable) Audit Expense was over budget (unfavorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were over budget (unfavorable); however, this reflects some quarterly billing Electric was under budget (favorable) Gas was over budget (unfavorable) and reflects December billing Water was over budget (unfavorable) and reflects a quarterly billing Sewer was over budget (unfavorable) and reflects a quarterly billing Operatine and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Maintenance Supplies was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Heating and Cooling Maintenance and Repairs were over budget (unfavorable) and reflect cost to replace regulator Furniture and Fixtures was over budget (unfavorable) and reflects cost of replacing refrigerator and range Parkview Villa South (166) Balance January 2014 Books = Accrual Jan -14 Assets 121,463.98 10100 Cash Balance 93.00 10200 Petty Cash 729,970.36 10400 Investments 4,054.11 11300 Rent Receivable 211.00 11500 Accounts Receivable 1,913.94 13100 Due From Other Funds Fund Balance 857,706.39 Total Assets 825,708.90 Liabilities 8,049.88 20200 Accounts Payable 1,928:39 20210 Accrued Other Expenses 8,598.87 22000 Deposits 12,905.98 22200 Accrued PILOT 514.37 22210 Revenue Collected In Advance 31,997.49 Total Liabilities Fund Balance 825,708.90 25300 Fund Balance 825,708.90 Total Fund Balance 857,706.39 Total Liabilities and Fund Balance Parkview Villa -South (166) -67.38 -0.29% -67.38 -0.29% Income Statement 1,068.00 4.62% 1,068.00 4.62% For The Period Ending January 2014 0.00 0.00% 0.00 0.00% Books = Accrual Month to Date % Year to Date o /o Revenue 1,338.52 5.79% 1,338.52 5.79% 36220 -46340 Gen. Government Rents 22,400.00 96.82% 22,400.00 96.82% 36225 -46340 Nondwelling Rents 561.00 2.42% 561.00 2.42% 36290 -46340 Other Miscellaneous Revenue 174.00 0.75% 174.00 0.75% 3100 -46340 Protective Services - 0.00% - 0.00% 39120 -46340 Recovery Damage City 127.60 0.55% 127.60 0.55% 3430 -46340 Advertising Other 23,135.00 100.000/0 23,135.00 100.000/0 Total Revenue 720.22 3.11% 720.22 3.11% Expenses 943.12 4.08% 943.12 4.08% Personal Services 1,129.38 4.88% 1,129.38 4.88% 1000 -46340 Accrued Salaries 3,932.00 17.00% 3,932.00 17.00% Total Personal Services 3,932.00 17.000y. 3,932.00 17.00% Supplies 2000 -46340 Office Supplies -67.38 -0.29% -67.38 -0.29% 2010 -46340 Minor Equipment 1,068.00 4.62% 1,068.00 4.62% 2160 -46340 Maint. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 337.90 1.46% 337.90 1.46% Total Supplies 1,338.52 5.79% 1,338.52 5.79% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 0.00 0.00% 3050 -46390 Expert &Professional Services 3060 -46340 Management Services 517.00 2,126.00 2.23% 9.19% 517.00 2,126.00 2.23% 9.19% 3100 -46340 Protective Services 178.56 0.77% 178.56 0.77% 3210 -46340 Telephone & Telegraph 127.60 0.55% 127.60 0.55% 3430 -46340 Advertising Other 192.00 0.83% 192.00 0.83% 3600 -46340 Insurance & Bonds 720.22 3.11% 720.22 3.11% 3810 -46340 Electric 943.12 4.08% 943.12 4.08% 3820 -46340 Water 1,129.38 4.88% 1,129.38 4.88% 3830 -46340 Gas 4,306.68 18.62% 4,306.68 18.62% 3840 -46340 Refuse 0.00 0.00% 0.00 0.00% 3850 -46340 Sewer 526.68 2.28% 526.68 2.28% 4000 -46340 Repair & Maint. Services 1,121.64 4.85% 1,121.64 4.85% 4100 -46340 Rents & Leases 0.00 0100% 0.00 0.00% 4300 -46340 Miscellaneous Charges 0.00 0.00% 0.00 0.00% 4315 -46340 PILOT 992.77 4.29% 992.77 4.29% 4390 -46340 Taxes & Licenses 0.00 0.00% 0.00 0.00% 4500 -46340 Administrative Expenses -55.29 - 0.24% -55.29 -0.24% 4850 -46340 Interest on Deposits 6.64 0.03% 6.64 0.03% Total Other Services & Charges 12,833.00 55.47% 12,833.00 55.470/a Capital Outlay 0.00 /o ° .. 0.00% - 5120 -46340 Building & Improvements 0.00 0.00% 0.00 0.00% Total Capital Outlay 18,103.52 78.25 o 18,103.52 78.250/a Total Expense 5,031.48 21.75% 5,031.48 21.750/. Excess (Deficit) Revenue over Expense Parkvlew Villa South (166) Cash Flow Statement Period = January 2011 Month to Date Revenue 36220 Gen. Government Rents 22,400.00 561.00 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 174.00 0.00 39120 Recovery Damage City Properly 23,135.00 Total Revenue Personnel Services 3,932.00 1000 Accrued Salaries Total Personnel Services 3,932.00 Supplies -67.38 2000 Office Supplies 1,068.00 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 337.90 2171 General Supplies 0.00 2175 Food Supplies 1,338.52 Total Supplies 720.22 Other Services & Charges 517.00 3050 Expert & Professional Services 2,126.00 3060 Management Services 178.56 3100 Protective Services 127.60 3210 Telephone & Telegraph 192.00 3430 Advertising Other 720.22 3600 Insurance & Bonds 943.12 3810 Electric 1,129.38 3820 Water 4,306.68 3830 Gas 0.00 3840 Refuse 526.68 3850 Sewer 1,121.64 4000 Repair & Maint. Services 0.00 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 0.00 4300 Miscellaneous Charges 992.77 4315 PILOT 0.00 4390 Taxes & Licenses (55.29) 4500 Administrative Expenses 6.64 4850 Interest on Deposits 12,833.00 Total Other Services & Charges 18,103.52 Total Expenses Parkvlew Villa South (166) Cash Flow Statement Period = ]anuary 201-1 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 5,031.48 0.00 0.00 90.00 (95.00) 0.00 5,405.65 720.22 106.64 992.77 (680.00) 6,540.28 11,571.76 Beg Cash End Cash Difference 109,892.22 121,463.98 11,571.76 279.00 279.00 ' 729,970.36 729,970.36 840,141.58 851,713.34 11,571.76 Parkview Villa South (166) General Ledger Period = San 2014 Book Accrual Tree ysi_tb ' ^_ Be1Qn0e`RBtndrk8 3 Pr4pfQAte Perl`ad, Parse ---- CpnErdl - ;Reference ,Rabik, :`CreAR , OA0 - Beginning Balance = 166 Accrued Salaries 3,932.00 0.00 3,932.00 PR Fee 1/3340 166 1/31/2014 01/2014 :POet RC = E din Balance 3,932.00 = Ending Balance = Change=3,639 Net Change= 3,932.00 moo = Beginning Balance = Office Supplies 8.70 0.00 8.70 creamer 166 12/18/2013 0112014 Office Depot P- 365104 6.8937E +11 166 1 /18/ notes;tissc 166 12/18/2013 01/2014 Office Depot P- 365104 6.8937E +11 0.00 513.26 copier allocation City o Colo P- 366178 4264 166 12/31/2013 01/2014 City 38.68 -75.60 manual ck postage 2013 m 166 3/13/2014 01/2014 Commoneoi P- 366836 011314manckpol 0.00 133.86 /9- 1/15/14 shiipments 166 1/22/2014 01/2014 FedEx (fede P- 368817 253594628sites 8.22 0.00 - 6].38 a Net Change= 67.38 0.00 = Beginning Balance = 2 010 -46340 Minor Equipment 1,068.00 0.00 f 166 1/16/2014 01/2014 All Inc. (all) P-367662 53327981001 1;68.00 =I Ending Balance= Net Change = 1,068.00 0.00 = Beginning Balance = 6340 General Supplies 6.77 0.00 6.77 payment discrepancy 166 12/6/2013 166 1 01/2014 HD Supply F P- 366894 1803503575 12.97 late fee 166 12/24/2013 01/2014 Home Depot P-365768 FCH005184943 6.20 0.00 toilet 166 12/30/2013 01/2014 HD Supply I P- 365090 9126954947 tbowl 0.00 51.86 heat tape 166 1/2/2014 01/2014 Frattalone's, P- 365109 017319R 16 99 0.00 66.30 valve /bulb /ha` 166 1/7/2014 01/2014 HD Supply I P- 366173 9127068317 14.44 trash bags;Pp tow toilet p{ 166 1/16/2014 01/2014 HD Supply l P- 367606 9127269995 88.50 0.00 154.80 /towels 166 1/16/2014 01/2014 HD Supply IP- 367506 9127269995 6.9 0,00 245.38 disposable 166 1/17/2014 01/2014 Buckeye Cie P- 368369 790835 73.67 0.00 337.90 paint 166 10/7/2013 01/2014 Sherwin -WII P- 366855 16040 92.52 337.90 =Ending Balance = Net change= 337.90 0.00 = Beginning Balance = 340 Expert & Professional Services 517.00 audit fees 166 1 166 12// 01/2014 City of Coln P- 366178 4264 517.00 0 .00 517.00 = Ending Balance = Net change= 517.00 0.00 = Beginning Balance = 3060 - Management Services 166 1/30/2/30/2 014 01/2014 CommonBOr P- 368905 013014mgmtl 6,058.00 3,932.00 2,126.00 R/C CHC PR Mgmt Fee 166 1/31/2014 01/2014 :POet RC 000 2,126.00 = Ending Balance = Change=2,639 Net change= 2,326.00 0.00 = Beginning Balance = Protective Services 178.56 0.00 178.56 pipe repair 166 1 2//340 166 131/2013 01/2014 Olsen Fire PP-367253 57279 178.56 = Ending Balance = Net Change= 178.56 0.00 = Beginning Balance = 340 Telephone & Answering Services 0.00 99.42 phone- 12/01- 12/31/13 166 12//31/2013 166 1 01/2014 Popp.com ( {P- 356713 992156894 99.42 0.00 124.82 net - 01/11 - 02/10/14 166 1/2/2014 01/2014 Comcast(cc P- 366712 8772105050196: 25.40 127.30 late fee 166 1/2/2014 01/2014 Comcast(cc P- 366712 8772105050195: 2.48 0.00 166 1/2/2014 01/2014 Comcast(a P- 366712 8772105050196: 0.30 0.00 127.50 = Ending Balance = Net Change =127.60 0.00 = Beginning Balance = Advertising Other 0.00 192.00 display ads - 01/15/14 Ifi6 1/1]/2014 166 1/17/2 01/2014 Northeaster 79372 192.00 192.00 = Ending Balance = e=19 .0 Net change= 192.00 0.00 = Beginning Balance = 3600 -46340 & Bonds Insurance on 0.00 720.22 C of Columbia Heights Ins Acc 166 1/31/2014 0112014 :po,tRecurfll- 186639 RC 720,22 720,22 = Ending Balance = Net Change= 720.22 0.00 = Beginning Balance = 3810.46340 Electric 5150441553 01/ 947.73 0.00 94].73 a 12/4/13- 1/7/14 166 1/13/2014 01/2014 Xcel Energy P- 367582 0.00 4'61 I66 1/13/2014 01/2014 Xcel Energy P- 367682 5150441553 01/ 943.12 = Ending Balance = Net Change= 943.12 0.00 = Beginning Balance = 3820 -46340 Water 1,040.52 0.00 1,040.52 W-09 /27- 12/27/13 166 1/9/2014 01/2014 City of Col, P- 367045 31802650001 01 0.00 166 1/9/2014 01/2014 City of Cam P- 367045 31802650001 01 88.86 111 9.38 =eEnlding Balance = Net Change=1,129.38 0.00 = Beginning Balance = 3630 -46340 Gas 01/09, 4,277.43 0.00 4,277.43 G- 12/05/13- 01/07/14 166 1/9/2014 01/2014 Center Point P- 367321 55271324 166 1/9/2014 01/2014 CenterPolnt P- 367321 55271324 01/09, 29.25 0.00 4,306.68 late fee 4,306.68 = Ending Balance = Net Change= 4,306.68 0.00 = Beginning Balance = 3850 -46340 Sewer 01 526.68 0.00 _ /ding 166 1/9/2014 01/2014 City of COW P- 367045 31802650001 526.68 = En Balance = Net Change= 526.68 0.00 = Beginning Balance = 4000 -46340 Repair and Maint. Services 0.00 23.32 exterm serv- 12/16/13 166 12/16/2013 01/2014 Adam's Pest P- 366891 850884 23,32 0.00 345.37 elev 166 1/1/2014 01/2014 Kone Inc, (1k P- 368663 221363779 322.05 49].05 valve nsta110- 12/12 - 12/24/13 166 12/30/2013 01/2014 LBP Mechan P- 366000 W19739 151.68 0.00 fuse replacement 166 12/31/2013 01/2014 LBP Mechan P- 367252 W19761 0 00 756.86 166 1/15/2014 01/2014 LBP Mechan P- 367306 W19776 168.59 0.00 944.63 MUA repair 166 1/15/2014 01/2014 LBP Mechan P- 367307 W19777 167 77 lt Ice me9-02/14 166 1/7/2014 01/2014 HD Supply IP- 366173 9127068317 0.00 1,121.54 166 1/15/2014 01/2014 High Profile P- 367309 28750 158.10 1,121.64 =Ending Balance = Net Change= 1,121.64 0.00 = Beginning Balance = 4315 -46340 PILOT 992.77 0.00 992.77 Anoka Cty Property Tax term 166 1/31/2014 01/2014 :PostRecurril- 186639 RC 992.77 = Ending Balance = Net Change= 992.77 0.00 = Beglnning Balance = 4500 -4634 Administrative Expenses 55.29 manual = 166 1/13/2014 01/2014 CommonBoi P- 366835 011314manual 0.00 .55.29 Ending Balance Net Change= -55.29 0.00 = Beginning Balance = 4850 -46340 lots reston Deposits 0.00 6.64 Sec Dep interest accrual 166 1131/2014 01/2014 Sec Dep Inn3- 186586 G31 6.64 6.64 = Ending Balance = Net Change =6.64 22,229.28 4,125.76 Parkview Villa South Bank Reconciliation Report 01131/2014 5016464 Balance Per Bank Statement as of 01/3112014 Outstanding Checks Check date Check number 06/18/2013 1788 01/28/2014 1974 0112812014 1975 01/28/2014 1976 01/28/2014 1977 01128/2014 1978 Less: Outstanding Checks 128,698,37 Payee Amount !0011071- Johnson 232.96 buck11411 - Buckeye Cleaning Centers 73.67 cent - CenlerPcinl Energy 4,306.88 colu - City of Columbia Heights 1,656.06 home7 - HD Supply Facilities Maintenance, Ltd. 21.90 xcel -Xcel Energy 943.12 Reconciled Bank Balance 7,234.39 02/0412014 121,463.98 Balance per GL as of 01131/2014 121,463.98 Reconciled Balance Per GIL 121,463.98 Difference Reconciled Bank Balance And Reconciled Balance Per G /L) 0,00 Cleared Items Cleared Checks Date Tran # 12130/2013 1946 12/3012013 1947 12/3012013 1948 12/30/2013 1949 12/30/2013 1950 12/30/2013 1951 12130/2013 1962 12/30/2013 1953 12/30/2013 1954 12/30/2013 1955 01/07/2014 1956 01/0712014 1957 01/07/2014 1958 01/07/2014 1959 01/14/2014 1960 Amount Dale Cleared Notes chc - Common8ond Housing 6,058.00 01/3112014 comc3422- Comcast 28.19 01/31/2014 fret - Fraltalone's/Metro Ace 20.81 01/31/2014 home - Hamernlck Decorating Center 3,492.19 01/3112014 high8236 - High Profile Grounds Maintenance, Inc. 158.10 01/31/2014 kone - Kona Inc. 314.50 01/31/2014 Ibpm - LBP Mechanical, Inc 988.08 01/31/2014 non2844 - Northeaster and NorthNews 192.00 01/31/2014 of08804 - Office Depot 35.24 01/31/2014 xcel - Xcel Energy 1,880.68 01/31/2014 cent - CenlerPoint Energy 1,950.23 01!31/2014 chc - Commonsond Housing 189.15 01/3112014 frat - Fratlalone's /Metro Ace 16.99 01131!2014 home7 - HD Supply Facilities Maintenance, Ltd. colu - City of Columbia Heights 555.68 01/3112014 02/04/2014 Parkview Villa South Bank Reconciliation Report 0113112014 5016464 Cleared Checks Cleared Deposits Dale Tran # 01/08/2014 421 01/13/2014 422 01117/2014 424 Total Cleared Deposits Notes Amount Dale Cleared 21,654.00 01/31/2014 620.00 01/31/2014 614.00 01/3112014 22,888.00 Amount Date Cleared Dale Tran # Notes Supply Facilities Malnlenance ,Ltd. 42.59 01/31720 01/1412014 1981 homa7 -HD homow6ti - Home Depot Credit Services 32.73 01131/2014 01/14/2014 1962 Ibpm - LBP Mechanical, Inc 151.68 01/31/2014 0111412014 1983 19.58 01/31/2014 01114/2014 1984 of88804 - Office Depot 23.32 01/3172014 01/21/2014 1965 adam- Adam's Pest Control, Inc. 2818 0113112014 01/2112014 1966 comc3422- Comca8l High Pro81e Grounds Maintenance, Inc. 156 77 01/21/2014 1967 high8236 - HD Supply Facilities Maintenance , Ltd. 01/31/2014 01121/2014 1968 hom07 - Ibpm - LBP Mechanical, Inc 44758 01/31/2014 01/2112014 1969 non2844 - Nodheaster and NorlhNows 192 00 01/31/2014 01/21/2014 1970 also- Olson Fire Protection, Inc. 178.56 01/31/2014 01/21/2014 1971 99 ,42 01/31/2014 01/21/2014 1972 POP P ° PopP•com 92.52 01/3112014 1973 sher4110- Shervin- Williams Co. 01/21/2014 17,482.60 Total Cleared Checks ^ --- Cleared Deposits Dale Tran # 01/08/2014 421 01/13/2014 422 01117/2014 424 Total Cleared Deposits Notes Amount Dale Cleared 21,654.00 01/31/2014 620.00 01/31/2014 614.00 01/3112014 22,888.00 Date 1/31/14 Page 1 Primary Account QXXXXX ®6434 Enclosures BRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONSOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C O U N T S - - -- NON YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPRONE OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING APP! YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID GOGGLE STORES. MOBILE BANKING. NORTHEAST PUBLIC FUNDS ACCT Number of Images 31 Account Number ®XXXXXO6464 Statement Dates 1/01/14 thru 1/31/14 Previous Balance 123,292.87 Days in the Statement Period 126,731 3 Deposits /Credits 17,482.50 Average Collected 1 ?.6,068 28 Electronic De 00 Electronic Debit ,00 Service Charge .00 Interest Paid 128,698.37 Ending Balance Deposits and credits Amount Date Description 21,654.00 1/08 DDA REGULAR DEPOSIT 620.00 1/13 DDA REGULAR DEPOSIT 614,00 1/17 DDA REGULAR DEPOSIT Checks in serial order Checkik Amount Date Check# Amount 16.99 Date 1/02 1946 6,058.00 1/13 1/13 1958 1959 129.73 1/08 28.19 20.81 1/21 1960 555.68 42.59 1/07 1/03 1948 1949 3,492.19 1/22 1/21 1961 1962 32.73 1/06 1950 158.10 314.50 1/22 1963 151.8 1%03 1951 988.08 1/27 1964 19.558 23.32 1/09 1953 192.00 1/27 1/29 1965 1966 28.18 1/13 1954 35 24 1,880.58 1/28 1967 158.10 6.77 1/03 1/17 1955 1,950.23 1/28 1/28 1968 1969 447.58 /Indicates19kip 189.15 * in check numbers Date 1/31/14 Page 2 Primary Account ®XXXXX ®6431 Enclosures NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Checks in serial order Checks! Amount Date Check$ Amount gg 42 Date 1/30 1970 192.00 178.56 1/29 1972 1/30 1973 92.52 1/27 1971 * Indicates skip in check numbers xxxxxxxwwxxxxxxxxxwxxwwxxwxxwxxwwwwxwwwwwxxwxwwxxwxwwxwwwwxwxxxxxxwwwwwwwxxxxx Daily Balance Section Date Balance Date Balance Date 1/22 Balance 129,944.40 101 123,292 87 1/06 1/09 132,006.42 131,625.27 1/27 129,722.94 1/02 117,234.87 129 110.49 1/17 130,727.08 1%29 128,982.89 1/06 110,401.42 1/21 130,138.67 1/30 128,698.37 1/07 110,380.61 w w x E N D O F S T A T E M E N T * * * Parkview South Payment Summary Bank= 166opr AND mm /yy= 01/2014 - 01/2014 AND All Checks—Yes AND Include Voids =All Checks Check Post Total Bank Check# Vendor Date Month Amount 166opr - Parkview Villa South 1956 cent - CenterPoint Energy 01/07/2014 01/2014 1,950.23 166opr - Parkview Villa South 1957 chc - Common Bond Housing 01/0712014 01/2014 189.15 166opr- Parkview Villa South 1958 frat- Frattalone's /Metro Ace 01/07/2014 01/2014 16.99 166opr - Parkview Villa South 1959 home7 - HD Supply Facilities Maintenance, Ltd. 01/07/2014 01/2014 129.73 166opr - Parkview Villa South 1960 coin - City of Columbia Heights 01/14/2014 01/2014 555.68 166opr - Parkview Villa South 1961 home7 - HO Supply Facilities Maintenance, Ltd, 01/14/2014 01/2014 42.59 166opr - Parkview Villa South 1962 home9055 - Home Depot Credit Services 01/14/2014 01/2014 32.73 1660pr - Parkview Villa South 1963 Ibpm - LBP Mechanical, Inc 01/14/2014 01/2014 151.68 166opr - Parkview Villa South 1964 offi8804 - Office Depot 01/14/2014 01/2014 19.58 166opr - Parkview Villa South 1965 adam - Adam's Pest Control, Inc. 01/21/2014 01/2014 23.32 166opr - Parkview Villa South 1966 comc3422 - Comcast 01/21/2014 01/2014 28.18 158.10 166opr - Parkview Villa South 1967 high8236 - High Pro01e Grounds Maintenance, I 01/21/2014 01/2014 166opr - Parkview Villa South 1968 home7 - HD Supply Facilities Maintenance, Ltd. 01/21/2014 01/2014 6.77 166opr - Parkview Villa South 1969 Ibpm - LBP Mechanical, Inc 01/21/2014 01/2014 447.58 166opr - Parkview Villa South 1970 nort2844 - Northeaster and North News 01/21/2014 01/2014 192.00 166opr - Parkview Villa South 1971 olse - Olsen Fire Protection, Inc. 01/21/2014 01/2014 178.56 166opr - Parkview Villa South 1972 Popp - Popp.com 01/21/2014 01/2014 99.42 92.52 166opr - Parkview Villa South 1973 sher4110 - Sherwin- Williams Co. 01/21/2014 01/2014 166opr - Parkview Villa South 1974 buck8411 - Buckeye Cleaning Centers 01/28/2014 01/2014 73.67 166opr - Parkview Villa South 1975 cent -. CenterPoint Energy 01/28/2014 01/2014 4,306.68 166opr - Parkview Villa South 1976 coin - City of Columbia Heights 01/28/2014 01/2014 1,656.06 166opr - Parkview Villa South 1977 home7 - HD Supply Facilities Maintenance, Ltd, 01/28/2014 01/2014 21.90 1660pr - Parkview Villa South 1978 xcel - Xcel Energy 01/28/2014 01/2014 943.12 11,316.24 i • Parkview Villa North Financial Statement Overview February 2014 Revenue: Occupancy for the month of February 2014 was 96% occupied; Rent Revenue was under budget (unfavorable) due to occupancy Total Revenue for February was under budget (unfavorable) due to no grant income drawn down Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Legal Services was under budget (favorable) Misc. Admin Expenses was under budget (favorable) Utilities: Utilities Expenses were over budget (unfavorable), however this reflects some quarterly billing Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects January Billing Gas was over budget (unfavorable) and reflects January Billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Security Contract was over budget (unfavorable) and reflects cost of smoke detector replacement Repairs Contract was under budget (favorable) Garbage and Trash was under budget (favorable); however, this is a quarterly billing Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs was over budget (unfavorable) and reflects cost of zone valve replacement and replacing wall heater at entrance City of Columbia Heights HRA Eupenditures for Fiscal Year 2014 - Parkview Villa North & South as of February, 2014 Account Object Cade Classification Actual YTD Actual MTD Budget Balance Personnel Services 203.46330 Parkvlew Villa North 17,681 8,929 105,024 87,343 Personnel Services 946 632 24,690 23,744 Supplies 51,980 27,663 379,537 327,557 Other Services B Charges 14,548 275,040 89,000 89,000 Ca Ila1 Outlays 0 70,606 37,224 698,251 527,646 Totals 203.46330 213.46340 Parkview Villa South 7,944 4,012 47,184 39,240 Personnel Services 408 -931 15,477 15,069 Supplies 24,298 11,465 177,379 153,081 Other Services & Charges 0 35,000 35,000 Ca Ila1 Outlays 0 32,649 14,548 275,040 242,391 Totals 213.46340 Parkview Villa -North Balance Sheet February 2014 Books = Accrual Feb -14 Assets 81,179.55 10100 Cash Balance 457.00 10200 Petty Cash 895,256.27 10400 Investments 2,869.45 11300 Rent Receivable 241.12 11500 Accounts Receivable 980,003.39 Total Assets Liabilities 10,632.38 20200 Accounts Payable 2,849.16 20210 Accrued Other Expenses 20220 Due to Resident Council 551.74 18,374.70 22000 Deposits 28,744.36 22200 Accrued PILOT 2,705.34 22210 Revenue Collected In Advance 63,857.68 Total Liabilities Fund Balance 916,145.71 25300 Fund Balance 916,145.71 Total Fund Balance 980,003.39 Total Liabilities and Fund Balance Parkview Villa -North Income Statement For The Period Ending February 2014 Books = Accrual Revenue 33160 -46330 Federal Grant 36220 -46330 Gen. Government Rents 36225 -46330 Nondwelling Rents 36290 -46330 Other Miscellaneous Revenue 39120 -46330 Recovery Damage City Property Total Revenue Expenses Personal Services 1000 -46330 Accrued Salaries Total Personal Services Supplies 2000 -46330 Office Supplies 2010 -46330 Minor Equipment 2160 -46330 Maint. & Construct Materials 2171 -46330 General Supplies Total Supplies Other Services & Charges 3040 -46330 Legal Fees 3050 -46330 Expert and Professional Services 3060 -46330 Management Services 3100.46330 Protective Services 3210 -46330 Telephone &Telegraph 3430 -46330 Advertising Other 3600 -46330 Insurance & Bands 3810.46330 Electric 3820 -46330 Water 3830 -46330 Gas 3840 -46330 Refuse 3850 -46330 Sewer 4000 -46330 Repair & Malm. Services 4100.46330 Rents & Leases 4300.46330 Miscellaneous Charges 4315 -46330 PILOT 4390 -46330 Taxes & Licenses 4500 -46330 Administrative Expenses 4850.46330 Interest on Deposits Total Other Services & Charges 3/712014 2:54 PM Month to Date % Year to Date 29.74% - 0.00% - 0.00% 28,672.00 97.20% 57,830.00 97.28% 330.00 1.12% 660.00 1.11% 495.00 1.68% 954.10 1.61% - 0.00% 639.78 0.00% 29,497.00 100.00°/0 59,444.10 100.00% 8,929.00 30.27% 17,681.00 29.74% 8,929.00 30.270/0 17,681.00 29.74% 131.92 0.45% -2.92 0.00% 0.00 0.00% 0.00 0.00% 259.07 0.88% 309.02 0.52% 241.21 0.82% 639.78 1.08% 632.20 2.14% 945.88 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.0D% 4,866.00 16.50% 9,638.00 16.21% 786.45 2.67% 786.45 1.32% 358.09 1.21% 420.82 0.71% 0.00 0.00% 0.00 0.00% 1,424.58 4.83% 2,849.16 4,79% 4,784.01 16.22% 7,957.35 13.39% 0.00 0.00% 2,117.06 3.56% 7,549.45 25.59% 15,466.23 26.02% 0.00 0.00% 0.00 0.00% 0.00 0.00% 904.43 1.52% 4,459.62 15.12% 6,363.63 10.71% 115.25 0.39% 135.25 0.23% 10.17 0.03% 24.10 0.04% 2,053.17 6.96% 4,106.34 6.91% 1,243.38 0.00% 1,243.38 2.09% 0.00 0.00% -59.09 -0.10% 12.76 0.04% 26.42 0.04% 27,662.93 93.78% 51,979.53 87.44% Page 3 of 9 3/7/2014 2:54 PM capital Outlay 0.00 o.00 o.00 ro ° 512046330 Building & Improvements 0.00 0.00% 0.00 0.00 % Total Capital Outlay 37,224.13 126.20% 70,606.41 118.78% Total Expense - 7,727.13 •26.20 ^ /0 —1-1,1'62.31-18.780/. Excess (Deficit) Revenue over Expense c-- ---- -- Page 4 of 9 Parkview Villa -North (165) Cash NOW Statement Period = February 2014 Book = Accrual Month to Date 3/7/2014 2:54 PM Revenue 0.00 33160 Federal Grant 28,672.00 36220 Gen. Government Rents 330.00 36225 Nondwelling Rents 495.00 36290 Other Miscellaneous Revenue 0.00 39120 Recovery Damage City Property 29,497.00 Total Revenue Expenses Personnel Services 8,929.00 1000 Accrued Salaries 8,929.00 Total Personnel Services Supplies 131.92 2000 Office Supplies 0.00 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 500.28 2171 General Supplies 0.00 2280 Vehicle Parts 632.20 Total Supplies Other Services & Charges 0.00 3040 Legal Fees 0.00 3050 Expert & Professional Services 4,866.00 3060 Management Services 786.45 3100 Protective Services 358.09 3210 Telephone & Telegraph 0.00 3430 Advertising Other 1,424.58 3600 Insurance & Bonds 4,784.01 3810 Electric 0.00 3820 Water 7,549.45 3830 Gas 0.00 3840 Refuse 0.00 3850 Sewer 4,459.62 4000 Repair & Maint. Services 0.00 4050 Garage, Labor Burd. 115.25 4100 Rent & Leases 10.17 4300 Miscellaneous Charges 2,053.17 4315 PILOT 1,243.38 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 12.76 4850 Interest on Deposits 0.00 5120 Building & Improvement 27,662.93 Total Other Services & Charges 37,224.13 Total Expenses .7,727.13 Excess (Deficit) Revenue over Expenses Page 5 of 9 Parkvie;w Villa -North (165) Cash Flow Statement Period = February 2014 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash 3/712014 2:64 PM Month to Date 0.00 0.00 293.38 -23.00 4,260.06 0.00 - 4,143.28 1,424.58 612.76 2,053.17 - 951.78 3,525.89 (4,201.24) Beg Cash End Cash Difference 85,380.79 81,179.55 (4,201.24) 871.00 871.00 - $91,214.11 891,214.11 - 977,465.90 973,264.66 (4,201.24) Page 6 Of 9 Parkvlew Vdia -North (165) General Ledger Period = Feb 2014 ,nl, a Accmal :Tree - vsl_ 1000 -46330 Accrued bmanes 8,929.00 0.00 17 R/C CHC PR Fee 165 2/2812014 :PostRecuning Monthly recurring entry RC 1],66881.00 3.00 = Ending Balance = Net Change = 8,929.00 - 134.84 = Beginning Balance = 2000 -46330 Office Supplies 0.00 -114.05 office supplies 165 1/2312014 Office Depot(of,8804) 6.91971E +11 20.]9 0.00 -98.30 office supplies 165 1/23/2014 Office Depot(oN18804) 6.91972E +11 15.75 0.00 -48.38 office supplies 165 1/29/2014 Office Depot(ofFl8804) 6.92703E +11 49.92 0.00 -2.92 office supplies 165 1/29/2014 Office Depot (offi8804) 6.92703E +11 45.46 -2.92 = Ending Balance = Net Change= 131.92 49.95 = Beginning Balance = 2160-46330 Maint. & Construct Materials 0.00 64.28 aVC 165 1/29/2014 HD Supply Facilities Maintenance, Ltd. 9127527036 14.33 waste 6'. 63.43 PVC waste elndl 165 1/29/2014 HD Supply Facilities Maintenance, Ltd. 9127527836 19.35 0.00 as y;s t.r; 268.74 pndl assy;s stmr; m: shwr 165 2/4/2014 HO Supply Facilities Maintenance, Ltd, 9127632817 185.31 0.00 309.02 mile plaint supplies-69% 165 215/2014 Home Depot Credit Services (home90` 3193039 40.28 0.00 = Ending 309.02 = Ending Balance = Net Change= 259.07 398.57 = Beginning Balance = 2171 -46330 General Supplies 232.75 0.00 631.32 165 12/16/2013 Sherwin- Williams Co.(sher4310) 66297 0.00 vacuum a 165 1/29/2014 HD Supply Facilities Maintenance, Ltd. 9127527836 8.46 639.78 = Ending Balance = Net Change= 241.21 41]]2.00 = Beginning Balance = 3060 -46330 Management Services 13,795.00 0.00 18,56].00 mgmt tees 0Mgm 165 2/28/2014 CommonBond Housing (Chc) 022814mgmtl 8,929.00 9,638.00 WC CHC PR Mgm[ Fee 165 2/28/2014 :POSIRecuMnq Monthly recurring entry RC 0.00 9,638.00 = Ending Balance = Net Change= 4,866.00 0.00 = Beginning Balance = 3100 -46330 Protective Services 0.00 ]86.45 replace smoke detector 165 2/10/2014 Simplex Grinnell (simp) 69812769 786.95 786.45 = Ending Balance = Ne[Change= ]86.45 62.73 = Beginning Balance = 3210 -46330 Telephone & Telegraph 0.00 287.41 phone -2/1 2/19 165 1/31/2014 Popp.cam (Popp) 992163463 224.68 0.00 363.93 phone 2/19 165 2/1/2014 Level On.(leve) 0386005114 76.52 0'00 1= tending % 2/1 /10/14 165 2/2/2014 Camcast(comc3474) 877210505019618 56.89 420,82 e3 Net Change= 358.09 1,424.58 = Beginning Balance = 3600 -46330 Insurance &Bonds 0.00 2849.16 C of Columbia Heights Ins Aced 165 2/28/2014 :PostRecumng Monthly recurring entry RC 1,429.58 2,849.16 = Entling Balance = Net Change = 1,424.58 31173.34 = Beginning Balance = 3810-46330 Electric 4,784.01 0.00 7,957.35 a -69% 1/7- 215/14 165 2/11/2014 Xcel Enemy(xcel) 5150441553 ],95].35 = Ending Balance = Net Change= 4,784.01 2,117.06 = Beginning Balance = 3820 -46330 Water 2,117.06 = Ending Balance = Net Change =0.00 7,916.78 = Beginning Balance = 3830 -46330 Gas 55199657 02/06/1 7,549.45 0.00 15,466.23 9 1 /&2 /ao 165 2/6/2014 CenterPoInt Energy (cent) 6.23 Ending e = Net Change= 7,549.45 904.43 = Beginning Balance = 3850 -46330 Sewer 904.43 = Ending Balance = Net Change=0.00 1,904.01 = Beginning Balance = 4000 -46330 Repair & t Services 51.91 0.00 1,955.92 pest control-69% 1/22/14 165 1/22/2014 Adam's Pest st Control, Inc. (atlam) 856085 0.00 2,111.17 snow removal -69% 165 1/27/2014 High profile Grounds Maintenance, Inc. 2B914 155.25 2,257.80 zone valve Mr 1/24 - 28/2014.6! 165 1/29/2014 LBP Mechanical, Inc(Ibpm) W19930 146.63 0.00 0.00 3,577.61 rplc cbnt wall htr 01/16- 28/201 165 1/29/2014 LBP Mechanical, Inc (Ibpm) W19911 1,319.81 0.00 3,647.76 tnenon melt-69% 165 1/29/2014 HD Supply Facilities Maintenance, Ltd. 9127527836 70.15 3,782.76 unclog k sink #308 1/30/14 165 1/3012014 Draln King, Inc. (dral7740) 90270 135.00 0.00 0.00 4,499.58 elev main -69% 2/14 165 2/1/2014 Kone Inc. (kone) 221388855 716.82 0.00 4,892.02 snow removal -69% 165 2/10/2014 High Profile Grounds Maintenance, Inc. 29060 392.44 0.00 5,592.02 painting #611 365 2/12/2014 K.O. Cleaning and Restoredon LLC (ko, 1667 700.00 0.00 5,643.93 pest control 2/17/14 165 2/17/2014 Adam's Pest Control, (atlam) 862009 51.91 0,01) 5,995.83 snow removal-69% 3114 165 /2014 2/17/2014 Mai High Profile Grounds Maintenance, Inc 29096 351.90 0.00 6,078.63 fixed connection to photo eye 165 2/18/2014 All Seasons Garage Door Company (all 39138 82.80 0.00 6,363.63 unclog kitchen sink 2124/14 365 2/24/2014 Drain King,Ie=4,459.62) 90639 285.00 61363.63 = Ending Balance = Not Change= 4,459.62 4100 -46330 Rents & Leases 20.00 = Beginning Balance = 165 1/31/2014 Multihousing Credit Control (multi) 14010330 95.00 0.00 115.00 resident screening 1/14 165 2/11/2014 Talx the Work Number (taix) 1524170 20.25 0.00 135.25 ee verify 1/14 Net Change= 115.25 135.25 = Ending Balance = 4300 -46330 Miscellaneous Charges 13.93 = Beginning Balance= 165 2/10/2014 Fattalone's /Metro Ace (fat) 0176468 10.17 0.00 24.10 keying garage handle lock -69% Net Change =10.17 24.10 = Ending Balance = 4315 -46330 PILOT 2,053.17 = Beginning Balance = 165 2/28/2014 :PostRecurdng Monthly recurring entry RC 2,053.17 8.00 41106.34 Anoka Cty Property Tax Accrual Net Change = 2,053.17 4,106.34 = Ending Balance = 4390 -46330 Taxes & Licenses 0.00 = Beginning Balance = 165 2/18/2014 Columbia Heights Fire Dept (colu825) 21814165 1,243.38 0.00 1,243.38 annual rental license Net Change= 1,243.38 1,243.38 = Ending Balance = 4500 -46330 Adminstrative Expenses -59.09 = Beginning Balance = Net Change =0.00 -59.09 = Ending Balance = 4850 -46330 Interest on Deposits 13.66 = Beginning Balance = 165 2/28/2014 Sec Dep Interest accrual G11 12.76 0.00 26.42 Sec Dep Interest accrual Net Change =12.76 26.42 = Ending Balance = Parkview Villa North Bank Reconciliation Report 02/28/2014 5016456 Balance Per Bank Statement as of 02128/2014 97,299.61 outstanding Checks Check date Check number Payee Amount 419.94 02/04/2014 2327 t0006445 - Schuster 716.82 02/19/2014 - 2339 kone- Kone Inc. 82.60 02/25/2014 2343 alls2529 -All Seasons Garage Door Company 0212512014 2344 cent - CenlerPoInt Energy 7,649.45 02/25/2014 2345 colu825- Columbia Heights Fire Dept 1,243.38 02125/2014 2346 hlghB236 - High Pro61e Grounds Maintenance, Inc. 351.90 02/25/2014 2347 homo7 - HD Supply Facilities Maintenance, Ltd. 185.31 02/25/2014 2348 simp - Simplex Grinnell 786.45 02/25/2014 2349 xcel - Xcel Energy 4,784.01 Less: Outstanding Checks 16,120.06 Reconciled Bank Balance Balance per GL as of 02128/2014 Difference Cleared Items : Cleared Checks Dale 12/17/2013 12/30/2013 12130/2013 12/30/2013 12/30/2013 1 213 0/2 01 3 12/30/2013 12130/2013 12/30/2013 12/3012013 01/07/2014 01/07/2014 Reconciled Balance Per G/L (Reconciled Bank Balance And Reconciled Balance Per G /L) Tran # 2280 2287 2288 2289 2290 2291 2292 2293 2294 2295 2296 2297 81,179.55 Notes Amount gard1086 - Gardner Plumbing, LLC 105.27 cent- CenlerPoint Energy 4,901.45 chc- CommonBond Housing 13,524.00 comc3422- Comcast 62.74 frat - Frattalone's /Metro Ace 46.32 hlgh8236 - High Profile Grounds Maintenance, Inc, 351.90 kone - Kone Inc. 700.01 Ibpm - LBP Mechanical, Inc 1,696.01 offi8804. Office Depot 78.41 4,185.81 202.15 20.89 xcel - Xcel Energy chc - CommonBond Housing city4054 - City Wide Locksmilhing, Inc. 03/03/2014 81,179.55 81,179.55 0.00 pP Data Cleared 01/31/2014 01/31/2014 01131/2014 01/3112014 01/31/2014 0 1131 /2 01 4 01/31/2014 01/31/2014 01/31/2014 01/31/2014 01/31/2014 01/31/2014 Cleared Deposits Dale Tran 0 Notes Amount Data Cleared 0110812014 550 29,081.50 01/31/2014 01/08/2014 568 100.00 01/31/2014 Parkview Villa North 03/03/2014 Bank Reconciliation Report 02/28/2014 5016456 Cleared Checks Date Tran k Notes Amount Date Cleared 01/07/2014 2298 frat- Frattalone'sfMalro Ace 37.82 01/31/2014 01107/2014 2299 home7 - HD Supply Facilities Maintenance, Ltd. 327.77 01/31/2014 01/07/2014 2300 kern - Kennedy & Graven, Chartered 664.70 01/31/2014 0111412014 2301 ci1y4054 - City Wide Locksmilhing, Inc. 257.15 01/31/2014 01/14/2014 2302 colu - City of Columbia Heights 1,888.01 01/31/2014 01114/2014 2303 home7 - HD Supply Facilities Maintenance, Ltd. 94.79 01/31/2014 01/14/2014 2304 home9055 - Home Depot Credit Services 72.84 01/31/2014 01114/2014 2305 Ibpm - LBP Mechanical, Inc 337.61 01/31/2014 01/14/2014 2306 multi - Multlhousing Credit Control 20.00 01/31/2014 01/14/2014 2307 oMB804 -Office Depot 43.61 01/31/2014 01121/2014 2308 adam - Adam's Pest Control, Inc. 51.91 01/31/2014 01/21/2014 2309 city4054 -City Wide Locksmilhing, Inc. 13.93 01/31/2014 01/21/2014 2310 comc3422- Comcast 62.73 01/31/2014 01/21/2014 2311 high8236 - High Profile Grounds Maintenance, Inc. 351.90 01/31/2014 01/21/2014 2312 home7 -HD Supply Facilities Maintenance, Ltd. 15.06 01/31/2014 01/21/2014 2313 kocl - K.O. Cleaning and Restoration LLC 1,000.00 01/31/2014 01/21/2014 2314 Ibpm - LBP Mechanical, Inc 996.23 01/31/2014 01/21/2014 2315 olse - Olsen Fire Protection, Inc. 397.44 01/31/2014 01/21/2014 2316 Popp - Popp•com 221.28 01/31/2014 0112112014 2317 sher4110- Sherwin - Williams Co. 205.93 01/31/2014 01/28/2014 2318 buck8411 - Buckeye Cleaning Centers 163.96 02/28/2014 01/28/2014 2319 cent - CenlerPoint Energy 7,916.78 02/28/2014 01/28/2014 2320 colu - City of Columbia Heights 5,785.61 02/2812014 01/28/2014 2321 home7 -HD Supply Facilities Maintenance, Ltd, 48.75 02128/2014 01/28/2014 2322 10010792 - Oswald 205.71 02/2812014 01/1812014 2323 xcel - Xcel Energy 3,173.34 02/28/2014 02/04/2014 2324 chc- Commori Housing 13,330.07 0212812014 02/04/2014 2325 home7 - HD Supply Facilities Maintenance, Ltd. 74.22 02/28/2014 02/04/2014 2326 kone - Kona Inc. 716.82 02/28/2014 02/11/2014 2328 adam - Adam's Pest Control, Inc. 51.91 02128/2014 02111/2014 2329 high8236 - High Profile Grounds Maintenance, Inc. 155.25 02/28/2014 0211112o14 2330 home7 - HD Supply Facilities Maintenance, Ltd. 234.61 02/28/2014 02111/2014 2331 Ibpm - LBP Mechanical, Inc 1,466.44 02/26/2014 02/11/2014 2332 [eve - Level One 76,52 02/28/2014 02/11/2014 2333 ofii8804 -Office Depot 131.92 02/28/2014 02/1912014 2334 comc3474- Comcast 56.89 02/28/2014 02/19/2014 - 2335 dra17740- Drain King, Inc. 135.00 02/28/2014 02/i 9/2014 2336 (rat - Fralta[one's/Metro Ace 10.17 02128/2014 02119/2014 2337 high8236 - High Profile Grounds Maintenance, Inc. 392.44 02)28/2014 02/19/2014 2338 home7- HD Supply Facilities Maintenance, Ltd. 112.09 02/28/2014 02119/2014 2340 multi - Multlhousing Credit Control 95.00 02/28/2014 02/19/2014 2341 Popp - Popp.com 224.68, 02/28/2014 02/19/2014 2342 sher4110- Sherwin - Williams Co. 232.75 02/28/2014 Total Cleared Checks 67,726,60 Cleared Deposits Dale Tran 0 Notes Amount Data Cleared 0110812014 550 29,081.50 01/31/2014 01/08/2014 568 100.00 01/31/2014 Cleared Deposits Date Tran # 01/13/2014 551 02/03/2014 553 02/03/2014 554 02/03/2014 555 02/04/2014 557 02/05/2014 556 02/07/2014 559 02/10/2014 560 02111/2014 561 Total Cleared Deposits Cleared Other Items Dale Tran M 02/0712014 RC 1061402 Total Cleared Other Items Parkview Villa North Bank Reconciliation Report 0212812014 5016456 Notes 03/03/2014 Amount Date Cleared 583.00 01/31/2014 5,432.00 02/28/2014 1,843.00 02128/2014 13,756.60 0212812014 3,932.00 02/28/2014 2,772.00 02/28/2014 1,637.00 02/28/2014 89.00 02128/2014 19.00 02/28/2014 59,245.10 Notes Amount Date Cleared Returned item 10004015 -65.00 02/28/2014 -65.00 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - -- C H E C K I N G Date 2/28/14 Primary Account Enclosures A C C O U N T S - - -- Page I @XXXXX @6456 31 NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING APP! YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID APPS FROM THE APPLE OR GOOGLE PLAY APP STORES. YOUR NETTELLER CREDENTIALS WILL ALLOW ACCESS TO MOBILE BANKING. NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXX @6456 Previous Balance 102,674.94 8 Deposits /Credits 29,480.60 24 Checks /Debits 34,855.93 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 97,299.61 Number of Images 31 Statement Dates 2/01/14 thru 2/28/14 Days in the Statement Period 28 Average Ledger 100,958 Average Collected 99,981 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Deposits and Credits Amount Date Description 1,843.00 2/03 DDA REGULAR DEPOSIT 5,432.00 2/03 DDA REGULAR DEPOSIT 1 3,756.6 2/03 DDA REGULAR DEPOSIT .60 3,9320 2/04 DDA REGULAR DEPOSIT 2,772.00 2/05 DDA REGULAR DEPOSIT 89.00 2/10 DDA REGULAR DEPOSIT 1,637.00 2/10 DDA REGULAR DEPOSIT 19.00 2/11 DDA REGULAR DEPOSIT *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Charges and Debits Date Description 2/07 RETURN ITEM DEBIT Amount 65.00 Checks in serial order Amount Date Check# Amount Date Check# 2/03 2318 163.96 2/03 2319 7,916.78 * Indicates skip in check numbers Date 2/28/14 Page 2 Primary Account @XXXXX @6456 Enclosures 31 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Check# Amount Date Check# Amount Date 2/03 2320 5,785.61 2/18 2332 76.52 131.92 2/03 2321 48.75 205.71 2/28 2/25 2333 2334 56.89 2/10 2/03 2322 2323 3,173.34 2/27 2335 135.00 2/06 2324 13,330.07 2/25 2336 10.17 392.44 2/14 2325 74.22 716.82 2/26 2/25 2337 2338 112.09 2/13 2/19 2326 2328* 51.91 2/26 2340* 95.00 2/21 2329 155.25 234.61 2/25 2/25 2341 2342 224.68 232.75 2/19 2330 2/19 2331 1,466.44 * Indicates skip in check numbers *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Balance Section Balance Date Balance Date Balance Date 2/01 102,674.94 2/10 1.01,447.32 2/21 98,690.55 2/03 106,618.10 2/11 101,466.32 2/25 2/26 98,053.97 97,566.53 2/04 110,550.10 2/13 2/14 100,749.50 100,675.28 2/27 97,431.53 2/05 2/06 113,322.10 99,992.03 2/18 100,598.76 2/28 97,299.61 2/07 99,927.03 2/19 98,845.80 * * * E N D O F S T A T E M E N T Payment Summary Bank= 165opr AND mm /yy= 02/2014- 02/2014 AND All Checks =Yes AND Include Voids= All Checks Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkvlew Villa No 2324 chc - Commoneond Housing 02/04/2014 02/2014 13,330.07 165opr - Parkvlew Villa No 2325 home7 - HD Supply Facilities Maintenance, Ltd. 02/04/2014 02/2014 74.22 165opr - Parkvlew Villa No 2326 kone - Kone Inc. 02/04/2014 02/2014 716.82 165opr - Parkvlew Villa No 2327 [0008445 - Schuster 02/04/2014 02/2014 419.94 165opr - Parkview Villa No 2328 adam - Adam's Pest Control, Inc. 02/11/2014 02/2014 51.91 165opr - Parkview Villa No 2329 high8236 - High Profle Grounds Maintenance, I 02/11/2014 02/2014 155.25 165opr - Parkvlew Villa No 2330 home7 - HD Supply Facilities Maintenance, Ltd. 02/11/2014 02/2014 234.61 165opr - Parkview Villa No 2331 Ibpm - LBP Mechanical, Inc 02/11/2014 02/2014 1,466.44 165opr - Parkview Villa No 2332 leve - Level One 02/11/2014 02/2014 76.52 165opr - Parkvlew Villa No 2333 offi8804 - Office Depot 02/11/2014 02/2014 131.92 165opr - Parkview Villa No 2334 comc3474 - Con-cast 02/19/2014 02/2014 56.89 165opr - Parkview Villa No 2335 dral7740 - Drain King, Inc. 02/19/2014 02/2014 135.00 165opr- Parkview Villa No 2336 frat- Frattalone's /Metro Ace 02/19/2014 02/2014 10.17 165opr - Parkvlew Villa No 2337 high8236 - High Profle Grounds Maintenance, I 02/19/2014 02/2014 392.44 165opr - Parkvlew Villa No 2338 home7 - HD Supply Facilities Maintenance, Ltd. 02/19/2014 02/2014 112.09 165opr - Parkview Villa No 2339 kone - Kone Inc. 02/19/2014 02/2014 716.82 1650pi - Parkvlew Villa No 2340 muhl - Muldhousin9 Credit Control 02/19/2014 02/2014 95.00 165opr - Parkvlew Villa No 2341 Popp - Popp.com 02/19/2014 02/2014 224.68 165opr - Parkvlew Villa No 2342 sher4110 - Sherwin- Williams Co. 02/19/2014 02/2014 232.75 165opr - Parkvlew Villa No 2343 alls2529 - All Seasons Garage Door Company 02/25/2014 02/2014 82.80 165opr- Parkview Villa No 2344 cent- CenterPoint Energy 02/25/2014 02/2014 7,549.45 165opr - Parkvlew Villa No 2345 colu825 - Columbia Heights Fire Dept 02/25/2014 02/2014 1,243.38 165opr - Parkvlew Villa No 2346 high8236 - High Profle Grounds Maintenance, I 02/25/2014 02/2014 351.90 165opr - Parkvlew, Villa No 2347 home7 - HD Supply Facilities Maintenance, Ltd. 02/25/2014 02/2014 185.31 165opr - Parkvlew Villa No 2348 simp - Simplex Grinnell 02/25/2014 02/2014 786.45 165opr - Parkvlew Villa No 2349 xcel - Xcel Energy 02/25/2014 02/2014 4,784.01 33,616.84 Parkview Villa South Financial Statement Overview February 2014 Revenue: Occupancy for the month of February was 78 % occupied Total Revenue was lower than budget amount (unfavorable) and reflects occupancy Administrative Expenses: Administrative costs for South were under budget (favorable). Advertising costs were over budget (unfavorable) and reflect cost of ongoing marketing Other renting expenses were under budget (favorable) Office Supplies was under budget (favorable) Legal Services was under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were over budget (unfavorable); however, this reflects some quarterly billings Fuel Oil was under budget (favorable) Electric was slightly over budget (unfavorable) and reflects January billing Gas was over budget (unfavorable) and reflects January billing Water was under budget (favorable) and reflects quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor Supplies were over budget (unfavorable) and reflect cost of goods Exterminating Contract was under budget (favorable) Maintenance Supplies was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Snow contract was over budget (unfavorable) Decorating Contract was under budget (favorable) Furniture and Fixtures was over budget (unfavorable) and reflects cost of two units vinyl and carpet replacement Parkview Villa South (166) Balance February 2014 Books = Accrual Feb -14 Assets 10100 Cash Balance 125,980.80 10200 Petty Cash 93.00 10400 Investments 739,280.12 11300 Rent Receivable 4,742.11 11500 Accounts Receivable 157.00 Total Assets 870,253.03 Liabilities 20200 Accounts Payable 4,870.23 20210 Accrued Other Expenses 1,440.44 22000 Deposits 8,374.55 22200 Accrued PILOT 13,898.75 22210 Revenue Collected in Advance 323.00 Total Liabilities 28,906.97 Fund Balance 25300 Fund Balance 841,346.06 Total Fund Balance 841,346.06 Total Liabilities and Fund Balance 870,253.03 Parkview Villa -South (166) 39.69 0.19% -27.69 -0.06% Income Statement - 1,068.00 -5.12% 0.00 0.00% For The Period Ending February 2014 0.00 0.00% 0.00 0.00% Books = Accrual 97.38 0.47% 435.28 0.99% Total Supplies Month to Date % Year to Date 0.93% Revenue 392.97 1.88% 584.97 1.33% 36220 -46340 Gen. Government Rents 20,294.00 97.23% 42,694.00 97.01% 36225 -46340 Nondwelling Rents 396.00 1.90% 957.00 2.17% 36290 -46340 Other Miscellaneous Revenue 183.00 0.88% 357.00 0.81% 39120 -46340 Recovery Damage City - 0.00% - 0.00% Total Revenue 20,873.00 100.000/0 44,008.00 100.000/0 Expenses 0.00 0.00% 526.68 1.20% Personal Services 1,484.17 7.11% 2,605.81 5.92% 100046340 Accrued Salaries 4,012.00 19.22% 7,944.00 18.05% Total Personal Services 4,012.00 19.22% 7,944.00 18.05% Supplies 200046340 OfOCe Supplies 39.69 0.19% -27.69 -0.06% 201046340 Minor Equipment - 1,068.00 -5.12% 0.00 0.00% 216046340 Maim. & Construct Materials 0.00 0.00% 0.00 0.00% 217146340 General Supplies 97.38 0.47% 435.28 0.99% Total Supplies - 930.93 -4.46% 407.59 0.93% Other Services & Charges 304046340 Legal Fees 0.00 0.00% 0.00 0.00% 305046340 Expert & Professional Services - 517.00 -2.48% 0.00 0.00% 306046340 Management Services 2,168.00 10.39% 4,294.00 9.76% 310046340 Protective Services - 178.56 -0.86% 0.00 0.00% 321046340 Telephone & Telegraph 61.47 0.29% 189.07 0.43% 343046340 Advertising Other 392.97 1.88% 584.97 1.33% 360046340 Insurance & Bonds 720.22 3.45% 1,440.44 3.27% 381046340 Electric 2,149.34 10.30% 3,092.46 7.03% 382046340 Water 0.00 0.00% 1,129.38 2.57% 383046340 Gas 3,585.41 17.18% 7,892.09 17.93% 384046340 Refuse 0.00 0.00% 0.00 0.00% 385046340 Sewer 0.00 0.00% 526.68 1.20% 400046340 Repair & Maim. Services 1,484.17 7.11% 2,605.81 5.92% 410046340 Rents & Leases 36.75 0.18% 36.75 0.08% 430046340 Miscellaneous Charges 4.57 0.00% 4.57 0.01% 431546340 PILOT 992.77 4.76% 1,985.54 4.51% 439046340 Taxes & Licenses 558.62 2.68% 558.62 1.27% 450046340 Administrative Expenses 0.00 0.00% -55.29 -0.13% 485046340 Interest on Deposits 5.80 0.03% 12.44 0.03% Total Other Services & Charges 11,464.53 54.93% 24,297.53 55.21016 Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00 0.00% 0.00% 14,545.60 69.690/0 32,649.12 74.19% 6,327.40 30.31% 11,358.88 25.81% ParkView villa South (166) Cash Flow Statement Period = Fobnrary 2019 Month to Date Revenue 36220 Gen. Government Rents 20,294.00 36225 Nondwelling Rents 396.00 36290 Other Miscellaneous Revenue 183.00 39120 Recovery Damage City Property 0.00 Total Revenue 20,873.00 Personnel Services 1000 Accrued Salaries 4,012.00 Total Personnel Services 4,012.00 Supplies 2000 Office Supplies 39.69 2010 Minor Equipment - 1,068.00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 97.38 2175 Food Supplies 0.00 Total Supplies •930.93 Other Services & Charges 3050 Expert & Professional Services (517.00) 3060 Management Services 2,168.00 3100 Protective Services (178.56) 3210 Telephone & Telegraph 61.47 3430 Advertising Other 392.97 3600 Insurance & Bonds 720.22 3810 Electric 2,149.34 3820 Water 0.00 3830 Gas 3,585.41 3840 Refuse 0.00 3850 Sewer 0.00 4000 Repair & Maint. Services 1,484.17 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 36.75 4300 Miscellaneous Charges 4.57 4315 PILOT 992.77 4390 Taxes & Licenses 558.62 4500 Administrative Expenses 0.00 4850 Interest on Deposits 5.80 Total Other Services & Charges 11,464.53 Total Expenses 14,545.60 Rif kview Vila South (1.6() Cash Flow Statement Period February 2014 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 6,327.40 0.00 0.00 (688.00) 54.00 1,913.94 (3,179.65) (487.95) (224.32) 992.77 (191.37) (1,810.58) 4,516.82 Cash End Cash 121,463.98 125,980.80 4,516.82 279.00 279.00 - 729,970.36 729,970.36 - 851,713.34 856,230.16 4,516.82 Parkview Villa South (166) General Ledger Period = Feb 2014 Book = Accrual; Tree= ysl_to P {oaerpaie, , Parson /Gesc7ptien , ,,, , .- Ratgrgnce nadd tetldi[ `;Bahama RemOrk9 1000 -46340 Accrued Salaries 3,932.00 = Beginning Balance = 166 212812014 :PostRecurring Recurring RC 4,012.00 0.00 2,944.00 RIC CHC PR Mgmt Fee Net Change = 4,012.00 7,944.00 = Ending Balance = 2000 -46340 Office Supplies -67.38 = Beginning Balance = 166 1/23/2014 Office Depot (offi8804) 6.91971E +11 9.34 0.00 -58.04 office supplies 166 1/23/2014 Office Depot (offi8804) 6.91922E +11 7.08 0.00 -50.96 office supplies 166 1/29/2014 Office Depot (offi8804) 6.92203E +11 22.43 0.00 -28.53 office supplies 166 1/29/2014 Office Depot (offi8804) 6.92203E +11 20.42 0.00 -8.11 office supplies 166 2/1/2014 Rev 12/31 exp Inv. to 1/14 - RE2 0.00 19.58 -27.69 Rev 12/31 exp Inv. to 1/14 - Office Be Net Change =39.69 -22.69 = Ending Balance = 2010 -46340 Minor Equipment 1,068.00 = Beginning Balance = 166 2/12/2014 All Inc. (all) 53327983001 -1- 0.00 1,068.00 0.00 fridge electric range Net Change=- 1,068.00 0.00 = Ending Balance = 2171 -46340 General Supplies 337.90 = Beginning Balance = 166 12/16/2013 Sherwin- Williams Co. (sher4110) 66297 104.57 0.00 442.47 paint -31% 166 1/29/2014 HD Supply Facilities Maintenance, Ltd. (h,9127527836 3.80 0.00 446.27 vacuum bags -31% 166 1/29/2014 HD Supply Facilities Maintenance, Ltd. (h,9127527836 6.44 0.00 452.21 anchors -31% 166 1/29/2014 HD Supply Facilities Maintenance, Ltd. (1,9127527836 8.61 0100 461.32 PVC waste elbw /kit;snk stror -31% 166 2/1/2014 Rev 12131 exp Inv. to 1/14 - RE2 0100 92.52 368.80 Rev 12/31 exp Inv, to 1/14 - Sherwin 1 166 2/1/2014 Rev 12131 exp Inv. to 1/14 - RE2 0.00 20.62 340.13 Rev 12/31 exp Inv, to 1114 - HD Suppl 166 2/1/2014 Rev 12/31 exp Inv. to 1/14 - RE2 0.00 6.20 333.93 Rev 12/31 exp Inv. to 1114 - Home De 166 2/412014 HO Supply Facilities Maintenance, Ltd. (h,9127632817 83.25 0.00 417.18 shwr hndl;spndl assy;s strnr;msc 166 2/5/2014 Home Depot Credit Services (home9055) 3191039 18.10 0.00 435.28 mist meant supplas -31% Net Change =97.38 435.28 = Ending Balance = 3050 -46340 Expert & Professional Services 517.00 = Beginning Balance - 166 2/1/2014 Rev 12/31 exp Inv. to 1/14 - RE2 0.00 517.00 0.00 Rev 12/31 exp Inv. to 1/14 - C of Col I Net Change =- 517.00 0.00 = Ending Balance = 3060 -46340 Management Services 2,126.00 = Beginning Balance = 166 2/28/2014 CommonBond Housing chc) 022814mgmtl 6,180.00 0.00 8,306.00 mgmt fees 02/14 166 2/28/2014 :PostRecurring Recurring RC 0.00 4,012.00 4,294.00 R/C CHC PR Pemt Fee Net Change= 2,168.00 4,294.00 = Ending Balance = 3100 -46340 Protective Services 178.56 = Beginning Balance = 166 2/1/2014 Rev 12/31 exp Inv. to 1/14 - RE2 0.00 178.56 0.00 Rev 12/31 exp Inv. to 1/14 - Olsen HIP Net Change =- 178.56 0.00 = Ending Balance = 3210 -46340 Telephone & Telegraph 127.60 = Beginning Balance = 165 1/31/2014 P.Roccm (Popp) 992163463 100.95 0.00 228.55 phone -31% 2/14 166 2/1/2014 Level One Cleve) 0386005IN 34.38 0100 262.93 phone 2/14 166 2/1/2014 Rev 12131 exp Inv. to 1/14 - RE2 0100 99.42 163.51 Rev 12/31 exp Inv. to 1/14 - Popp 166 2/2/2014 Commet(comc3474) 8222105050191 25.56 0100 189.07 Internet -31% 2/11- 3/10/14 Net Change =61.47 189.07 = Ending Balance = 3430 -46340 Advertising Other 192.00 = Beginning Balance = 166 1/3112014 Classified Ventures LLC (clas) APf1139541 8.97 0.00 200.97 advertising 1/14 166 2/20/2014 Northeaster and NorthNews(nort2844) 79467 384.00 0.00 584.92 advertising 2/5- 19/2014 Net Change= 392.97 584.97 = Ending Balance = 3600 -46340 Insurance & Bonds 720.22 = Beginning Balance = 166 2/28/2014 :PostRecurring Recurring RC 720.22 0.00 1,440.44 C of Columbia Heights Ins Accrl Net Change = 720.22 1,440.44 = Ending Balance = 3810 -46340 Electric 943.12 = Beginning Balance = 166 2/11/2014 Xcel Energy (xcel) 5150441553 2,149.34 0.00 3,092.46 a -31% 1/7- 2/5/14 Net Change = 2,149.34 31092.46 = Ending Balance = 3820 -46340 Water 1,129.38 = Beginning Balance = Net Change =0.00 1,129.38 = Ending Balance = 3830 -46340 Gas 4,306.68 = Beginning Balance = 166 2/7/2014 Comerford Energy (cent) 55221324 02/0 3,585.41 0.00 7,892.09 9 117. 2/4/14 Net Change =3,585.41 7,892.09 = Ending Balance = 3850 -46340 Sewer 526.68 = Beginning Balance = Net Change -0.00 526.68 = Ending Balance = 4000 -46340 Repair & Maint. Services 1,121.64 = Beginning Balance = 166 1/22/2014 Adam's Pest Control, Inc. (adam) 856085 23.32 0.00 1,144.96 pest contro1-31% 1/22/14 166 1/27/2014 High Profile Grounds Maintenance, Inc. (128914 69.75 0.00 1,214.71 snow removal -31% 166 1/29/2014 LBP Mechanical, Inc (Ibpm) W19930 65.87 0.00 1,280.58 zone valve rpr 1/24 - 28/2014 -31% 166 1/29/2014 LBP Mechanical, Inc (Ibpm) W19911 592.96 0.00 1,873.54 rplc cbnt wall htr 01/16- 28/2014 166 1/29/2014 HD Supply Facilities Maintenance, Ltd. (1,9127527836 31.51 0.00 1,905.05 traction melt -31% 166 2/1/2014 Rev 12/31 exp Inv. to 1/14 - RE2 0.00 23.32 1,881.73 Rev 12/31 exp Inv. to 1/14 - Adam's P 166 211/2014 Kane Inc. (kone) 221388855 322.05 0.00 2,203.78 elev main! -31% 2/14 166 2/1/2014 Rev 12/31 exp Inv, to 1/14 - RE2 0.00 242.90 1,960.88 Rev 12/31 exp Inv. to 1/14 - LBP Mach 166 2110/2014 High Profile Grounds Maintenance, Inc. (129060 176.31 0.00 2,137.19 snow removal -31% 166 2/12/2014 K.O. Cleaning and Restoration LLC (kocl) 1668 250.00 0.00 2,387.19 touch -ups #417 166 2/17/2014 Adam's Pest Control, Inc. (adam) 862009 23.32 0.00 2,410.51 pest control 2117/14 166 2/17/2014 High Profile Grounds Maintenance, Inc. (129096 158.10 0.00 2,568.61 snow removal -31% 3/14 166 2118/2014 All Seasons Garage Door Company (alls2!39118 37.20 0.00 2,605.81 fixed connection to photo eye Net Change= 1,484.17 2,605.81 = Ending Balance = 4100 -46340 Rents & Leases 0.00 = Beginning Balance = 166 1/31/2014 Multihousing Credit Control (multl) 14010331 30.00 0.00 30.00 resident screening 1/14 165 2/11/2014 Talx the Work Number (tali) 1524170 6.75 0100 36.75 ee verify 1/14 Net Change =36.75 36.75 = Ending Balance = 4300 -46340 Miscellaneous Charges 0.00 = Beginning Balance = 166 2/10/2014 Frattalone's /Metro Ace (frat) 017646R 4.57 0.00 4.57 keying - garage handle lock -31% Net Change =4.57 4.57 = Ending Balance = 4315 -46340 PILOT 992.77 = Beginning Balance - 166 2/2812014 :PostRecurring Recurring RC 992.77 0.00 1,985.54 Anoka Cty Property Tax Accrual Net Change= 992.27 1,985.54 = Ending Balance = 4390 -46340 Taxes & Licenses 0.00 = Beginning Balance = 166 2/1812014 Columbia Heights Fire Dept (colu825) 21814165 558.62 0.00 558.62 annual rental license Net Change = 558.62 558.62 = Ending Balance = 4500 -46340 Administrative Expenses -55.29 = Beginning Balance = Net Change =0.00 -55.29 = Ending Balance = 4850 -46340 Interest on Deposits 6.64 = Beginning Balance = 166 2/28/2014 Sec Dep interest accrual G)1 5.80 0.00 12.44 Sec Dep Interest accrual Net Change =5.80 12.44 = Ending Balance = 28,489.53 13,943.93 Parkview Villa South Rank Reconciliation Report 02128/2014 5016464 Balance Per Bank Statement as of 0212812014 Outstanding Checks Check dale Check number Payee 06/18/2013 1786 t0011071- Johnson 0210412014 1982 10012426 - Maughan 02/19/2014 1095 kone - Kona Inc. 0212512014 1999 alls2529- All Seasons Garage Door Company 02/25/2014 2000 cent - CenterPoint Energy 02/25/2014 2001 colu825 - Columbia Heights Fire Dept 02/26/2014 2002 high8236 - High Profile Grounds Maintenance, Inc. 02/25/2014 2003 home7 - HD Supply Facilities Maintenance, Ltd. 02/25/2014 2004 nor12844 - Northeaster and NonhNews 02/25/2014 2005 xcel - Xcel Energy Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 02128/2014 Difference Cleared Items : Cleared Checks Reconciled Balance Per GIL 133,829.73 (Reconciled Bank Balance And Reconciled Balance Per G /L) Date Tran # 01/2812014 1974 01/28/2014 1975 01/2.812014 1976 01/28/2014 1977 01/28/2014 '1978 02/04/2014 1979 02/04/2014 1980 02/04/2014 1981 02/11/2014 1883 02/11/2014 1984 0211112014 1986 Amount 232.96 338.00 322.05 37.20 3,585.41 558.62 168.10 83.25 384.00 2,149.34 7,848.93 125,980,80 Notes Amount buck8411 - Buckeye Cleaning Centers 73.67 cent - CenterPoInl Energy 4,306.68 colu - City of Columbia Heights 1,656.06 home7 - HD Supply Facilities Maintenance, Ltd. 21.00 xcel -Xcel Energy 943.12 chc - CommonBond Housing 5,877.07 home7 - HD Supply Facilities Maintenance, Ltd. 33.35 kone - Kona Inc. 322.05 adam - Adam's Pest Control, Inc. 2132 high8236 - High Profile Grounds Maintenance, Inc. 69.75 home7 - HD Supply Facilities Maintenance, Ltd. 105.41 03/03/2014 125,980.80 125,980,80 0.00 ASP �X tjl�l 3/3 Date.Cleared 02/28/2014 02/28/2014 02/28/2014 02/28/2014 02/28/2014 02/2812014 02/28/2014 02/28/2014 02126/2014 02/28/2014 02J2812014 Cleared Checks Date 'Tran # 02/11/2014 1986 02111/2014 1987 02111/2014 1988 02/11/2014 1989 02119/2014 1990 02/19/2014 1991 62119/2014 1992 02/19/2014 1993 0211912014 1994 02/19/2014 1996 02/19/2014 1997 02/19/2014 1998 Total Cleared Checks Cleared Deposits Dale . Tran # 02/03/2014 425 02/0312014 426 02/04/2014 427 02/05/2014 428 02/1112014 429 Total Cleared Deposits Cleared Other Items Date Tran # 02/10/2014 RC 1065654 Total Cleared Other Items Parkview Villa South 0310312014 Bank Reconciliation Report 02/28/2014 5016464 Notes Amount Date Cleared Ibpm - LBP Mechanical, Inc 658.83 02128/2014 [eve - Level One 34.38 02/28/2014 of08804 - Office Depot 59.27 02/28/2014 10009526 - Parker 19712 02/26/2014 clas - Classified Ventures LLC 8.97 02/28/2014 comc3474 - Comcast 25.56 02128/2014 trat - Frattalone's/MelroAce 4.57 02/2812014 hlgh8236 - High Profile Grounds Maintenance, Inc. 176.31 02/28/2014 home7 - HD Supply Facilities Maintenance, Ltd. 50.36 02128/2014 multi - Mullihousing Credit Control 30.00 0212812014 Popp - Popp.com 100.95 02/28/2014 sher4110- Sherwin-Williams Co. 104.57 02/28/2014 14,883.27 Notes Amount Date Cleared 12,946.48 02/28/2014 3,978.00 02/28/2014 1,892.00 02/28/2014 1,198.15 02/28/2014 614.00 02128/2014 20,628.63 Notes Amount Date Cleared Returned Item 10011238 - 614.00 0212812014 - 614.00 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G Date 2/28/14 Primary Account Enclosures A C C 0 U N T S - - -- Page 1 @XXXXX @6464 28 NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING APP! YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID APPS FROM THE APPLE OR GOGGLE PLAY APP STORES. YOUR NETTELLER CREDENTIALS WILL ALLOW ACCESS TO MOBILE BANKING. NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXX @6464 Previous Balance 128,698.37 5 Deposits /Credits 20,628.63 24 Checks /Debits 15,497.27 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 133,829.73 Number of Images 28 Statement Dates 2/01/14 thru 2/28/14 Days in the Statement Period 28 Average Ledger 135,132 Average Collected 134,457 Deposits and Credits Date Description Date Amount 2/03 DDA REGULAR DEPOSIT 3,978.00 2/03 DDA REGULAR DEPOSIT 12,946.48 2/04 DDA REGULAR DEPOSIT 1,892.00 2/05 DDA REGULAR DEPOSIT 1,198.15 2/11 DDA REGULAR DEPOSIT 614.00 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Charges and Debits Date Description 2/10 RETURN ITEM DEBIT Amount 614.00 Checks in serial order Date Check# Amount Date Check# Amount 2/03 1974 73.67 2/03 1978 943.12 2/03 1975 4,306.68 2/06 1979 5,877.07 2/03 1976 1,656.06 2/14 1980 33.35 2/03 1977 21.90 2/13 1981 322.05 * Indicates skip in check numbers Date 2/28/14 Page 2 Primary Account @XXXXX @6464 Enclosures 28 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 2/19 1983* 23.32 2/25 1991 25.56 2/21 1984 69.75 2/25 1992 4.57 2/19 1985 105.41 2/26 1993 176.31 2/19 1986 658.83 2/25 1994 50.36 2/18 1987 34.38 2/26 1996* 30.00 2/28 1988 59.27 2/25 1997 100.95 2/20 1989 197.12 2/25 1998 104.57 2/24 1990 8.97 * Indicates skip in check numbers *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Balance Section Date Balance Date Balance Date Balance 2/01 128,698.37 2/11 135,834.50 2/21 134,390.29 2/03 138,621.42 2/13 135,512.45 2/24 134,381.32 2/04 140,513.42 2/14 135,479.10 2/25 134,095.31 2/05 141,711.57 2/18 135,444.72 2/26 133,889.00 2/06 135,834.50 2/19 134,657.16 2/28 133,829.73 2/10 135,220.50 2/20 134,460.04 * ** E N D O F S T A T E M E N T Payment Summary Bank= 166opr AND mm /yy= 02/2014- 02/2014 AND All Checks =Yes AND Include Voids =All Checks Check Post Total Bank Check# Vendor Date Month Amount 166opr - Parkview Villa SOL 1979 chc - Common Bond Housing 02/04/2014 02/2014 5,877.07 166opr - Parkview Villa SOL 1980 home7 - HD Supply Facilities Maintenance, Ltd. 02/04/2014 02/2014 33.35 166opr - Parkview Villa SOL 1981 kone - Kone Inc. 02/04/2014 02/2014 322.05 166opr - Parkview Villa SOL 1982 10012426 - Maughan 02/04/2014 02/2014 338 166opr - Parkview Villa SOL 1983 adam - Adam's Pest Control, Inc. 02/11/2014 02/2014 23.32 166opr - Parkview Villa Sol 1984 h1gh8236 - High Profile Grounds Maintenance, In 02/11/2014 02/2014 69.75 166opr - Parkview Villa SOL 1985 home7 - HO Supply Facilities Maintenance, Ltd. 02/11/2014 02/2014 105.41 166opr - Parkview Villa SOL 1986 Ibpm - LBP Mechanical, Inc 02/11/2014 02/2014 658.83 166opr - Parkview Villa SOL 1987 leve - Level One 02/11/2014 02/2014 34.38 166opr - Parkview Villa SOL 1988 offi8804 - Office Depot 02/11/2014 02/2014 59.27 166opr - Parkview Villa SOL 1989 1:0009525 - Parker 02/11/2014 02/2014 197.12 166opr - Parkview Villa SOL 1990 clas - Classified Ventures LLC 02/19/2014 02/2014 8.97 166opr - Parkview Villa SOL 1991 comc3474 - Contrast 02/19/2014 02/2014 25.56 166opr - Parkvlew Villa SOL 1992 frat - Frattalone's /Metro Ace 02/19/2014 02/2014 4.57 166opr - Parkview Villa SOL 1993 high8236 - High Profile Grounds Maintenance, In 02/19/2014 02/2014 176.31 166opr - Parkview Villa SOL 1994 home7 - HD Supply Facilities Maintenance, Ltd. 02/19/2014 02/2014 50.36 166opr - Parkview Villa Sot 1995 kone - Kone Inc. 02/19/2014 02/2014 322.05 166opr - Parkview Villa Sot 1996 multi - Multihousing Credit Control 02/19/2014 02/2014 30 166opr - Parkview Villa SOL 1997 Popp - Popp.com 02/19/2014 02/2014 100.95 166opr - Parkview, Villa Sot 1998 sher4110 - Sherwin- Williams Co. 02/19/2014 02/2014 104.57 166opr - Parkview Villa SOL 1999 alls2529 - All Seasons Garage Door Company 02/25/2014 02/2014 37.2 166opr - Parkview Villa Sot 2000 cent - CenterPolnt Energy 02/25/2014 02/2014 3,585.41 166opr - Parkview Villa SOL 2001 colu825 - Columbia Heights Fire Dept 02/25/2014 02/2014 558.62 166opr - Parkview Villa SOL 2002 high8236 - High Profile Grounds Maintenance, In 02/25/2014 02/2014 158.1 166opr - Parkview Villa SOL 2003 home7 - HD Supply Facilities Maintenance, Ltd. 02/25/2014 02/2014 83.25 166opr - Parkview Villa SOL 2004 nort2844 - Northeaster and North News 02/25/2014 02/2014 384 166opr - Parkview Villa SOL 2005 xcel - Xcel Energy 02/25/2014 02/2014 2,149.34 15,497.81 Parkview Villa North Financial Statement Overview March 2014 Revenue: Occupancy for the month of March 2014 was 96 % occupied; Rent Revenue was under budget (unfavorable) and reflects occupancy Total Revenue for March was under budget (unfavorable) as no grant income was drawn down Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Legal Services was under budget (favorable) Utilities: Utilities Expenses were over budget (unfavorable) and some reflect quarterly billings Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects February billing Gas was over budget (unfavorable) and reflects February billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Security Contract was over budget (unfavorable) and reflects cost of Alarm repairs Garbage and Trash was under budget (favorable); however, this is a quarterly billing Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs was over budget (unfavorable) and reflects the cost of Heating repairs and hallway exhaust repairs Snow contract was over budget (unfavorable) Furniture and Fixtures was over budget (unfavorable) and reflects the cost of replacement flooring and stove 213.46340 Parkvlew Villa South Personnel Services 11,956 4,012 47,184 35,228 Supplies 1,107 699 15,477 14,370 Other Services & Charges 43,673 19,376 177,379 133,7`06 City of Columbia Heights HRA Expenditures for Fiscal year 2014 - Parkvlew Villa North & South as of March, 2014 Account Object Code Classification Actual YTD Actual MITI) Budget Balance 203.46330 Parkvlew Villa North 26.610 8,929 105,024 78,414 Personnel Services 3,576 2,630 - 24,690 21,114 Supplies Other Services & Charges 93,958 _ 41,978 379,537 205,579 213.46340 Parkvlew Villa South Personnel Services 11,956 4,012 47,184 35,228 Supplies 1,107 699 15,477 14,370 Other Services & Charges 43,673 19,376 177,379 133,7`06 Parkview Villa -North Balance Sheet March 2014 Books = Accrual Mar -14 Assets 79,821.57 10100 Cash Balance 457.00 10200 Petty Cash 895,256.27 10400 Investments 1,819.76 11300 Rent Receivable 213.12 11500 Accounts Receivable 977,567.72 Total Assets Liabilities 30,101.56 20200 Accounts Payable 4,273.74 20210 Accrued Other Expenses 551.74 20220 Due to Resident Council 18,149.48 22000 Deposits 30,797.53 22200 Accrued PILOT 4,280.52 22210 Revenue Collected in Advance 88,154.57 Total Liabilities Fund Balance 889,413.15 25300 Fund Balance 689,413.15 Total Fund Balance 977,567.72 Total Liabilities and Fund Balance Parkview Villa-North Income Statement For The Period Ending March 2014 Books = Accrual Revenue 33160 -46330 Federal Grant 36220 -46330 Gen. Government Rents 36225 -46330 Nondwelling Rents 36290 -46330 Other Miscellaneous Revenue 39120 -46330 Recovery Damage City Property Total Revenue Expenses Personal Services 1000 -46330 Accrued Salaries Total Personal Services 4/4/2014 11:08 AM Month to Date %o Year to Data o70 0.13% 0.00% 0.00 0,00% 26,145.00 97.54% 83,975.00 97.36% 317.00 1.18% 977.00 1.13% 343.14 1.28% 1,297.24 1.50% 0.00% - 0.00% 26,805.14 100.00% 86,249.24 100.000/0 8,929.00 33.31% 26,610.00 30.85% 8,929.00 33.31% 26,610.00 30.850/0 supplies 115.60 0.43% 112.68 0.13% 2000 -46330 Office Supplies 0.00 0.00% 1,805.24 2 09% 3040 -46330 Legal Fees 1,805.24 6.73% 12,750.00 14.78% 2010.46330 Minor Equipment 12,750.00 47.57 0.78 % 366.62 1.37% 675.64 2160 -46330 Malnt. & Construct Materials 2,116.80 2,45% 342.85 1.28% 982.63 1.14% 2171 -46330 General Supplies 0 3,576.19 0.90% 2,630.31 9.81 /o Total Supplies 0 00°/ Other Services & Charges 0.00% 0.00 0.00% 0.00 3040 -46330 Legal Fees °% 12,750.00 14.78% 3050.46330 Expert and Professional Services 12,750.00 47.57 16.82% 4,866.00 18.15% 14,504.00 3060 -46330 Management Services 2,116.80 2,45% 1,33035 4.96% 3100 -46330 Protective Services 778.02 0.90% 357.20 1.33% 3210 -46330 Telephone &Telegraph 0 00°/ 0.00 0.00 °% 0.00 3430 -46330 Advertising Other 4,273.74 4.96% 1,424.58 5.31% 3600 -46330 insurance & Bonds 12,988.07 15.06 % 5,030.72 18.77% 3810 -46330 Electric 2.45% 0.00 0.00% 2,117.06 3820-46330 Water 25,012.13 29.00% 9,595.90 35.61% 3830 -46330 Gas 0.00 0.00% 0.00 0.00% 3840 -46330 Refuse 0.00% 904.43 1.05% 3850 -46330 Sewer 0.00 16.76% 10,855.40 12.59% 4000.46330 Repair &Maim, Services 4,491.77 0.20% 40.00 0.15% 175.25 4100-46330 Rents & Leases 34.41 0.04 % 1031 0.04% 4300 -46330 Miscellaneous Charges 6,159.51 7 14 2,053.17 7.66% 4315 -46330 PILOT 0.00% 1,24338 1 44% 4390 -46330 Taxes & Licenses 0.00 5.22 0.01% 64.31 0.24% 4500 -46330 Administrative Expenses 0.05 % 14.08 0.05% 90.50 4850 -46330 Interest on Deposits 93,957.92 108.94% 41,978.3 9 156.61% Total Other Services &Charges Page 3 of 9 4/4/2014 11:08 AM Capital Outlay 0.00% - 0.00% 5120 -46330 Building & Improvements 0.00 0.00 0.000/0 0.00 0.00% Total Capital Outlay 53,537.70 199.73% 124,144.11 143.94% Total Expense •26,732.56 •99.73% - 37,894.87 - 43.94% Excess (Deficit) Revenue over Expense Page 4 of 9 Parkview Villa -North (1.65) Cash Flow Statement Period = March 2014 Book = Accrual Month to Date 4/4/2014 11:08 AM Revenue 0.00 33160 Federal Grant 26,145.00 36220 Gen. Government Rents 317.00 36225 Nondwelling Rents 343.14 36290 Other Miscellaneous Revenue 0.00 39120 Recovery Damage City Property Total Revenue Expenses Personnel Services 8,929.00 1000 Accrued Salaries 8,929 00 Total Personnel Services Supplies 115.60 2000 Office Supplies 1,805.24 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 709.47 2171 General Supplies 0.00 2280 Vehicle Parts ---- 2 630 31 Total Supplies Other Services & Charges 0.00 3040 Legal Fees 12,750.00 3050 Expert & Professional Services 4,866.00 3060 Management Services 1,330.35 3100 Protective Services 357.20 3210 Telephone & Telegraph 0.00 3430 Advertising Other 1,424.58 3600 Insurance & Bonds 5,030.72 3810 Electric 0.00 3820 Water 9,545.90 3830 Gas 0.00 3840 Refuse 0.00 3850 Sewer 4,491.77 4000 Repair & Maint. Services 0.00 4050 Garage, Labor Burd. 40.00 4100 Rent & Leases 10.31 4300 Miscellaneous Charges 2,053.17 4315 PILOT 0.00 4390 Taxes & Licenses 64.31 4500 Administrative Expenses 14.08 4850 Interest on Deposits 0,00 5120 Building & Improvement 41,978-39 Total Other Services & Charges 53,537.70 Total Expenses -- 2— 6 732 56 Excess (Deficit) Revenue over Expenses Page 6 of 9 414/201411:08 AM Parkview Villa -North ( 1G5) Cash Flow Statement Period = March 2014 Book = Accrual Month to Date Adjustments 0.00 10200 Petty Cash 0100 10400 Investments 1,049.69 11300 Rent Receivable 28.00 11500 Accounts Receivable 0,00 13100 Due From Other Funds 0.00 15510 Prepaid Insurance 19,469.18 20200 Accounts Payable 1,424.58 20210 Accrued Other Expenses -225.22 22000 Deposits 2,053.17 22200 Accrued PILOT 1,575.18 22210 Revenue Collected In Advance --25,374.58 Total Adjustments Cash Flow ---�— Page 6 of 9 Beg Cash End cash Difference 81,179.55 79,821.57 (1,357.98) 10100 Cash Balance 871.00 871.00 ' 10200 Petty Cash 891,214.11 891,214.11 - 10400 Investments 973,264.66 971,906.66 (1,357.98) Total Cash Page 6 of 9 Parkview Villa -North (165) General Ledger Pariod = Mar 2014 Book Accrual I Tree Ysl tb ?Debit ^. Cradlt Balance Remarks y, _- Date PerseO /DescriQHOn a 0dittrol, Re(erer,ce - 17,681.00 - Beginning Balance = Prope 1000 -46330 WAccrued Salaries 8,929.00 0.00 26,610.00 RIC CHC PR Mgmt Fee 165 3/31/2014 :pOstRecuning Monthly recurring entr 3- 191340 RC 26,610.00 = Ending Balance = Net Change= 8,929.00 -2.92 = Beginning Balance = 2000 -46330 Office supplies 6.98864E +1i 17.63 0.00 14.]1 ens -69% 165 2/20/2014 Office Depot(ofFl8804) P-374468 19.31 step stp 0.00 34.02 step stool -69% 165 2/20/2014 Office Depot (o(BBB04) P- 3]9968 6.98864E +11 0.00 71.70 copy paper -69% 3/5/2014 office Depot (OM8804) P- 375194 6.95312E +11 37.68 0.00 85.18 planne /a 165 3/5/2014 Office Depot (of BB04) P- 3]5198 6.95312E +11 13.48 0.00 -PPP 3 /19/14 165 165 3/1912014 Comon6ond Housing (chc) m P- 376132 031914sites 27.50 112.68 =o Ending Net Change= 115.60 0.00 = Beginning Balance = 2010 -46330 Minor Equipment CG402343 1, 066.84 0.00 1,066.84 Install vinyl #104 165 3/13/2014 Hamernick Decorating Center (home) P- 375551 69 ] 165 3/13/2014 HD Supply Facilities Maintenance, Ltd. P_376216 0.00 1,805.24 stove Install 165 3/1812014 All Inc (all) 51331505OD2 707.25 1,805.24 = Ending Balance = Net Change= 1,805.24 309.02 = Beginning Balance = 2160 -46330 Me Int. & Construct Maters is 43.86 0.00 352.BB drip bowls;range hood Btm- 165 2/24/2014 HD Supply Facilities Mainanance, Ltd. P- 372973 9128023210 26.8] 0.00 3]9.75 smoke 2/24/2014 HD Supply Facllitles Maintenance, Ltd. P- 372973 9128023210 nod Ockts;Shi 0.00 408.83 closet and scktrshlf bmktr- 165 2/24/2014 HD Supply FIniitles Maintenance, Ltd. P- 372973 9128023210 29.08 0.00 435.91 light bulbs 165 2124/2014 HD Supply Facilities Maintenance, Ltd. P- 3]29]3 9128023210 27.08 ;'11c 0.110 4 .74.12 door stops;misc malnt supp 165 3/6/2014 Home Depot Credit Services (hOme90 P- 375542 4140792 38.21 0.00 489.88 drip bowls -69% 165 3/13/2014 HD Supply Facllitles Maintenance, Ltd. P- 375666 9126400214 15.76 0.00 550.81 165 3/13/2014 HD Supply Facllitles Maintenance, Ltd. P- 375666 9128400214 66.93 0.00 mi hbulbsr;cln rdg;mis 165 3/13/2014 HD Supply Facilities Maintenance, Ltd. P- 375666 9128400214 116.83 675.64 = Ending Balance 165 Net Change= 366.62 639.78 = Beginning Balance = 2171 -46330 General Supplies 108.83 00.00 2/25/2014 Park Supply of America, Inc. (parkl) P-373318 ]55.]8 scrub sponges 69 °/a scrub spo 165 165 3/5/2014 Office Depot (oB18804) - 3]5194 6195312E I1 21827 0.00 9]4.05 165 3/5/21114 Sherwin - Williams Co. (sher4110) P- 374469 96267 8.58 0.00 vacuum _ 165 3/13/2014 HD Supply Facilities Maintenance, Ltd. P- 375666 9128400214 982.63 Ending Balance = Net Change = 342.85 0.00 = Beginning Balance = 3050 -46330 Expert & Professional Services 12, .750.00 0.00 servicing fees = 165 3/17/2014 Columbia Heights HIM (COhma) P- 376495 2013 -3 12 ]50.00 Ending Balanc = Net Change=12,750.00 9,638.00 = Beginning Balance = 3060-46330 Management Services P- 377094 033114m9m[1 13, .790.00 165 3/31/2014 CommonBOnd Housing (chc) 8,929 00 14,504.00 R/C CHC PR Mgmt Fee 165 3/31/2014 :PostRecurring Monthly recurring entr 1- 191340 RC 14,504.00 = Ending Balance = Net Change = 4,866.00 786.45 = Beglnning Balance = 3100-46330 Protective Services 1,330.35 0. 316.80 security alarm malnt -69 00 165 2/21/2014 Simplex Grinnell (situp) P-373548 69850741 2 116.80 = Ending Balance = Net Change = 1,330.35 420.82 = Beginning Balance = 3210 -46330 Telephone & Telegraph 223.79 0.00 644.61 e-69% 3/14 165 2/28/2014 POPP.COm (Popp) P- 3]5179 992169986 76.52 answering 0.00 ]21.13 answering service 3114 165 3/1/2014 Level One (love) P- 3J3M1JJ 0392970IN 56.89 0.00 l- 69% 1 165 312/2014 Comcdst(COmc3474) P- 3]5176 87]2105050196 ]18.62 Net Change= 357.20 2,849.16 = Beginning Balance = 3600 -46330 insurance & Bonds 1,424.58 0.00 4,2]3.]4 C c! Columbia Heights Ins A 165 3/31/2014 :POStRecurring Monthly recurring entr ]- 191340 RC 41273.74 = Ending Balance = Net Change = 1,424.58 7,957.35 = Beglnning Balance = 3810-46330 Electric P- 376093 5150441553 031 5,009.66 0.00 12,967.01 a 2/5-3/8 165 3/11/2014 Xcel Energy (Xcel) 03, 21.06 0.00 12,988.07 e-69% 2/5- 3/7/14 165 3/1112014 Xcel Energy(xcel) P- 3]6093 5150441553 12,988.07 = Ending Balance = Net Change= 5,030.72 2,117.06 = Beginning Balance = 3820 -46330 Water 2,117.06 = Ending Balance = Net Change =0.00 15,466.23 = Beginning Balance = 3830 -46330 Gas P-375940 5519965] 03/03 9,545.90 0.00 25,012.13 G-02/04- 03/06114 165 3/7/2014 CenterPolnt Energy (cent) 25,012.13 = Ending Balance = Net Change= 9,545.90 904.43 = Beginning Balance = 3850-46330 Sewer 904.43 = Ending Balance = Net Change =0.00 - 6,363.63 = Beginning Balance = 4000-46330 Repair & Maint. Services 294,98 0.00 6,658.61 snow malnt-02 /19/14 165 2/21/2014 High profile Grounds Maintenance, ln( P- 3]3546 29152 0.00 35.00 6,694.46 V-1cells-69% 165 2/24/2014 HD Supply Facllltles Maintenance, Ltd. P- 372973 9128023210 0 00 6,699.46 V- belts-69 6,636.65 2/27/2014 HD Supply Facilities Maintenance, Ltd. P- 3]361] 9128121393 0.00 heat repair-69% 12/29/13 -1 165 165 2/28/2014 LBP Mechanical, Inc (Ibpm) P- 3]44]0 W20191 1,937.19 716.82 0.00 9, 353.47 elev maint -69 %3/14 165 3/112014 Inc. (kone) P- 3]4946 223411571 189.29 0.00 9,542.86 snow /ice removal 2/24/14 165 3/5/2019 High Profile Grountls Maintenance, Inc P- 375015 High a Grounds 29255 35.07 0.00 5]].83 fraction melt -69 °/0 3/13/2014 HD Supply Facilities Maintenance, Lttl. P 0 00 9,]64.13 expansion tank repair -69% 165 3/1812014 LBP Mechanical, Inc (Ibpm) P- 3]6388 W20163214 186.30 0.00 10,855.40 hallway exhaust tan repair 165 165 3/20/2014 LBP Mechanical, Inc (Ibpm) 376388 w20189 1,091.2) 10,855.40 = Ending Balance = Net change = 4,491.77 135.25 = Beginning Balance = 4100-46300 Renls & Leases 40.00 0.00 175.25 resident screening 2/14 165 2/28/2014 Multihousing Credit Control (multi) P- 3]4]74 14020342 175.25 = Ending Balance = Net Change =40.00 24.10 = Beginning Balance = 4300-46330 Miscellaneous Charges 10.31 O.OD 34.41 padlocks;draw locks -69% 165 3/21/2014 Frattalone's /Metro Ace (trat) p- 376474 0179928 34.41 = Ending Balance = Net Change =10.31 4,106.34 = Beginning Balance = 4315 -46330 PILOT 2,053.17 0.00 6,159.51 Anoka Cty Property Tax Acc 165 3/31/2014 :POStRecurring Monthly recurring en[r ]- 191340 RC 6,159.51 = Ending Balance= Net Change= 2,053.17 1,243.38 = Beginning Balance = 4390 -46330 Taxes & Licenses 1,243.38 = Ending Balance = Net Change =0.00 -59.09 = Beginning Balance = 4500-46330 Administrative Expenses 55.64 0.00 -3.45 mileage 2/4-6/201 2/6/2014 Heidi Mindestrom (mind965) P- 3]5153 20614165166 0.00 52.19 14 165 Mindestrom (mind965) P- 375336 20614165 55.64 expreimburse 3/5- / 60.86 ezp reimburse 3/5-3/6/14 165 2/6/2014 3/7/2014 Heidi Held[ Mindestrom (mind965) P- 374259 30714165166 8.68 0.00 55.64 mileage lance 165 3/17/2014 Heidi Mindestrom (mind965) P- 3]5528 020614165166- O .OD 5,22 Bal = 165 Net Change =64.31 26.42 = Beginning Balance = 4850 -46330 Inetrest on Deposits 14.08 0.00 40.50 Sec dep interest accrual 165 3/31/2014 Sec dep interest a¢rual 3- 191620 G31 40.50 = Ending Balance = Net Change =14.08 62 522.34 8,984.64 0 4101/2 014 Parkview Villa North Bank Reconcillation Report 03131/2014 5016466 81,262.05 Balance Per Bank Statement as of 0313112014 Outstanding Checks Amount Check -014 _ Check number „ Payee 10000445- Schuster 419.94 /2 02/0412014 27 2327 kocl • K.O. Cleaning and Restoration LLC 76.80 03/0412014 2353 eomo3474- CoMmsl 566.89 03125/2014 2369 home? - HD Supply Faalli6es Maintenance, Ltd. 167.74 03/25/2014 2370 o(58804 - Office Depot 9561 03/2512014 2372 1,440.46 Outstanding Checks Less: 79,821.67 Reconciled Bank Balance . 79,821.57 Balance per GL as of 0313112014 79,821.67 Reconciled Balance Per GIL 0.00 (Reconciled Bank Balance And Reconciled Balance Per G /L) �.-- Difference (1�gff Cleared Items Cleared Checks Amount Date Cleared oafs__ Tmn # moles 716.62 03/31/2014 02/19/2014 2339 kone - Kona Inc. Seasons GaraOe Door Company 8280 0313112014 0212512614 2343 e1192529- All - 764945 03/31/2014 02/2512014 2344 cent• GenlefPoint Energy Columbia Heights Fire Dept 1 243 38 03/31/2014 0212512014 2345 co1u825- Prorile Grounds Maintenance, Inc. 351.90 03131/2614 0212512014 2346 high8236 - High HD Supply Fsclli6es Maintenance, Ltd. 185.31 03/31/2014 0212512014 2347 hame7- simp - Simplex Grinnell 788.45 0 3131 /2 014 03131/2014 02125/2014 2348 2349 Xmi - Xcel Energy 478401 5191 03/31/2014 02/2512014 2350 adam- Adam§ Pest Control, Inc. 0,555.19 03/31/2014 03104/2014 2351 chc- CommonBond Housing 285.00 0313112014 03104/2014 2352 dret7740 -Grain King, Inc. 294.88 03131/2014 0310412014 high8236 • High Profile Grounds Maintenance, Inc. 03131/2014 0311112014 235 4 home9055- Home Depot Credit Services 40.26 03/31/2014 03111/2014 2355 2356 - lava - Level One 7652 6.67 03131/2014 03/1112014 2357 mind965 -Holdl MlndWI= 1,330,35 03/3112014 03111/2014 strap. Simplex Grinnell 03/1112014 2358 Cleared Checks Data Tran # 03/11/2014 2359 0311812014 2360 03/18/2014 2361 03/1812014 2362 0311812014 2363 03/1812014 2364 0311612014 2365 03/16/2014 2366 03125/2014 2367 03/2512014 2360 03125/2014 2371 03/2512014 2373 03125/2014 2374 Total Cleared Checks Cleared Deposits Parkvlew Villa North Bank Reconciliation Report 0313112014 6016456 Notes t00ae131 -Allou hlgh8236 - High Profile Grounds Maintenance, Inc. kone - Kone Inc, Iopm - LBP Mechanical, Inc minuses - Heidi Mindestram multl - Mu]Uheusing Credit Control Popp - PopP.com 10000235 - Colon cent - CrudorPoInl Energy chc • GommonBond Housing homego65 - Horne Depot Credit Services park/ - Park Supply of America, Inc. xcel - Xcel Energy 45,487.53 04/01/2014 Amount Dole Cleared 204.60 03131/2014 189.20 03/31/2014 716.82 03/31/2014 1,937.19 03/31/2014 55,84 03/31/2014 40.00 03/3112014 223.79 03/3112014 26,86 03/31/2014 9,645.90 03/31/2014 27.50 03/31/2014 - 38.21 03/31/2014 108.19 03131/2014 5,030.72 03/3112014 Cleared Other Items Amount Dale Cleared Date Tran# Notes 03/31/2013 JE 191776 9113 deposit recelpled In 2014, recorded In 5990 In 201: - 100.00 03131/2014 •477.00 03131/201A 03/21/2014 RC 1085078 Returned item t0008243 .577,60 Total Cleared Other Items Amount Dale Cleared Dale Tran# Notes 100.00 03/31/2014 09106/2013 570 18,144.87 03/31/2014 0310312014 564 5,824.00 03131/2014 03/0512014 585 4,755.00 03131/2014 03107/2014 666 771.00 03/31/2014 03/1812014 568 432.00 03131/2014 03/2012014 589 30,026.97 Total Cleared Deposits Cleared Other Items Amount Dale Cleared Date Tran# Notes 03/31/2013 JE 191776 9113 deposit recelpled In 2014, recorded In 5990 In 201: - 100.00 03131/2014 •477.00 03131/201A 03/21/2014 RC 1085078 Returned item t0008243 .577,60 Total Cleared Other Items Date 3/31/14 Page 1 Primary Account @XXXXX @6434 Enclosures HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - _ - _ C H E C K I N G A C C O U N T S - - -- NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE APP! YOU CAN OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING VIEW RECENT TRANSACTIONS, PAY BILLS, CHECK ACCOUNT BALANCES, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR STORES. APPLE TOAPP 'ALLOW ACCESS PLAY ANDROID MOBILE BANKING. LLERAPPS CREDENTIALS WILL NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 Number of Images Statement Dates 3/01/14 thru 34 3/31/14 Account Number 97,299.61 Days in the Statement Period 31 99,724 Previous Balance 5 Deposits /Credits 29,926.97 Average Ledger Collected 98,527 30 Checks /Debits 45,964.53 Average Electronic Debit .00 Service Charge .00 Interest Paid .00 81,262.05 Ending Balance * * ** * * * * * * * * * * * * * * * * * * * * * * * * * ** *********************************************** Deposits and Credits Amount Date Description 18,144.97 3/03 DDA REGULAR DEPOSIT 5,824.00 3/05 DDA REGULAR DEPOSIT 4,755.00 3/07 DDA REGULAR DEPOSIT 771.00 3/18 DDA REGULAR DEPOSIT 432.00 3/21 DDA REGULAR DEPOSIT Charges and Debits Amount Date Description 477.00 3/21 RETURN ITEM DEBIT * * * * * * * ** * * * * * * * * * * * * * ** * * * * * ** *********************************************** Checks in serial order Amount Date Check# Amount Date Check# 716.82 3/04 2339 3/07 2346 351.90 185.31 3/04 2343 * 82,80 3/05 2347 3/07 2348 786.45 3/06 2344 7,549.45 1,243.38 3/04 2349 4,784.01 3/04 2345 * Indicates skip in check numbers Date 3/31/14 Page 2 Primary Account @XXXXX @6434 Enclosures NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Check# Amount Check# Date 2362 Amount 1,937.19 Date 3/10 2350 51.91 9'285.00 3/25 2363 55.64 40.00 3/06 3/10 2351 2352* 3/24 3/24 2364 2365 223.79 3/17 2354 294.98 40.28 3/26 2366 26.66 9,545.90 3/17 3/17 2355 2356 78.67 3/31 2367 2368 27.50 3/17 2357 1,330.35 3/31 2371* 38.21 108.19 3/18 3/17 2358 2359 204.60 3/31 3/31 2373* 2374 5,030.72 3/27 2360 189.29 716.82 3/31 * Indicates 2361 skip in check numbers Daily Balance Section Balance Date Balance Date 3/24 Balance 98,882.53 Date 3/01 97,299.61 3/07 3/10 100,768.27 100,431.36 3/25 96,945.34 3/03 115,444.58 108,617.57 3/17 9980631 ,. 3/26 3/27 96,918.68 96,729.39 3/04 3/05 114,256.26 3/18 3/21 99,246.96 99,201.96 3/31 81,262.05 3/06 97,151.62 * ** E N D O F S T A T E M E N T * *" Parkview Villa North Payment Summary Bank= 165opr AND mm/yy = 03/2014 - 03/2014 AND All Checks =Yes AND Include Volds =All Checks Check Post Total Vendor - Date Month Amount Bank Check# 2350 adam -Adam's Pest Control, Inc. 03/04/2014 03/2014 51.91 1651pr - Parkview Villa North - Common8ond Housing 03/04/2014 03/2014 9,555.19 165opr - Parkview Villa North 2351 chic 03/04/2014 03/2014 285 165om - Parkview Villa North 2352 drai7740 - Drain King, Inc. LLC 03/04/2014 03/2014 700 165opr - Parkview Villa North 2353 kocl - K.O. Cleaning and Restoration Grounds Maintenance, 1 03/11/2014 03/2014 294.98 165opr - Parkview Villa North 2354 high8236 - High Profile Home Depot Credit Services 165opr - Parkview Villa North 2355 home9055 - 03/11/2014 03/2014 76.52 1650pr - Parkview Villa North 2356 leve - Level One 03/11/2014 03/2014 8.67 165opr - Parkview Villa North 2357 mind965 - Heidi Mindestrom 03/11/2014 03/2014 1,330.35 165opr - Parkview Villa North 2358 situp - Simplex Grinnell 03/11/2014 03/2014 204.6 165opr - Parkview Villa North 2359 t0006131 - Aliou -High Profile Grounds Maintenance, I 165opr - Parkview Villa North 2360 high8236 03/18/2014 03/2014 716.82 165opr - Parkview Villa North 2361 kone - Kone Inc. 03/18/2014 03/2014 1,937.19 1650pr - Parkview Villa North 2362 Ibpm - LBP Mechanical, Inc 03/18/2014 03/2014 55.64 165opr - Parkview Villa North 2363 mind965 - Heidi Mindestrom Credit Control 03/18/2014 03/2014 40 165opr - Parkview Villa North 2364 multi - Multihousing 03/18/2014 0312014 223.79 165opr - Parkview Villa North 2365 Popp - Popp.com 03/18/2014 03/2014 26.66 1650pr - Parkvlew Villa North 2366 t0009235 - Colon 03/25/2014 03/2014 9,545.90 165opr - Parkvlew Villa North 2367 cent - CenterPoint Energy 03/25/2014 03/2014 27.5 165opr - Parkvlew Villa North 2368 chc - Comm() nBOnd Housing 03/25/2014 03/2014 56.89 165opr - Parkvlew Villa North 2369 comc3474 - Comcast HD Supply Facilities Maintenance, Ltd. 03/25/2014 03/2014 167.74 1650pr - Parkview Villa North 2370 home7 - Home Depot Credit Services 165opr - Parkview Villa North 2371 home9055 - 03/25/2014 03/2014 95.91 1650pr - Parkview Villa North 2372 offi8804 - Office Depot Supply of America, Inc. 03/25/2014 03/2014 108.19 165opr - Parkview Villa North 2373 parkl - Park 03/25/2014 03/2014 030.72 5, 0.72 165oor - Parkvlew Villa North _ 2374 xcel - Xcel Energy 30,, 0 Parkview Villa South Financial Statement Overview March 2014 Revenue: Occupancy for the month of March was75 % occupied Total Revenue was lower than budget amount (unfavorable) and reflects occupancy Administrative Expenses: Administrative costs for South were slightly over budget (unfavorable) Advertising costs were over budget (unfavorable) and reflect cost of ongoing marketing Other renting expenses were over budget (unfavorable) and reflect cost of background screening for applicants Office Supplies was under budget (favorable) Legal Services was under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were over budget (unfavorable); however, this reflects some quarterly billings Fuel Oil was under budget (favorable) Electric was under budget (favorable) Gas was over budget (unfavorable) and reflects February billing Water was under budget (favorable) and reflects quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing nneratina and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor Supplies were under budget (favorable) Exterminating Contract was under budget (favorable) Maintenance Supplies was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Heating and Cooling Maintenance Contract is over budget (unfavorable) and reflects the cost of heater coil replacement Snow contract was under budget (favorable) Decorating Contract was under budget (favorable) Furniture and Fixtures was under budget (favorable) Parkview Villa South (166) Balance March 2014 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Total Liabilities Fund Balance 25300 Fund Balance Total Fund Balance Total Liabilities and Fund Balance Mar -14 137,475.94 93.00 739,280.12 2,769.11 1,212.32 880,830.49 349.13 42,261.42 838,569.07 838,569.07 880,830.49 16,943.99 2,462.90 7,613.88 14,891.52 349.13 42,261.42 838,569.07 838,569.07 880,830.49 Parkview, Villa -South (166) Income statement For The Period Ending March 2014 Books = Accrual Month to Date % Year to Date Revenue 19,076.78 89.52% 61,770.78 94.57% 36220 -46340 Gen. Government Rents 5,750.00 1.99% 3050 -46340 Expert &Professional Services 345.06 1.62% 1,302.06 0.51% 36225 -46340 Nondwelling Rents 2,168.00 10.17% 6,462.00 2.79% 3060 -46340 Management Services 1,468.36 6.89% 1,825.36 0.92% 36290 -46340 Other Miscellaneous Revenue 597.70 2.80% 3100 -46340 Protective Services 420.00 1.97% 420.00 0.00% 39120 -46340 Recovery Damage City 160.49 0.75% 99.360/. 21,310.20 100.000/0 65,318.20 1.69% Total Revenue 2,160.66 3.31% Expenses Personal Services 4,012.00 18.83% 11,956.00 18.30% 1000 -46340 Accrued Salaries Total Personal Services 4,012.00 18.83% 11,956.00 18.30% Supplies 48.76 0.23% 21.07 0.03% 2000 -46340 Office Supplies 5,750.00 8.80% 3050 -46340 Expert &Professional Services 331.75 1.56% 331.75 0.51% 2010 -46340 Minor Equipment 2,168.00 10.17% 6,462.00 0.00% 3060 -46340 Management Services 0.00 0.00 °r° o.00 0.92% 2160 -46340 Maint. &Construct Materials 597.70 2.80% 3100 -46340 Protective Services 318.77 1.50% 754.05 1.15% 2171 -46340 General Supplies 160.49 0.75% 1 94% 699.28 3.28% 1,106.87 1.69% Total Supplies 2,160.66 3.31% Other Services & Charges 0.00 0.00% 0.00 0.00% 3040 -46340 Legal Fees 5,750.00 8.80% 3050 -46340 Expert &Professional Services 5,750.00 26.98% 9.89% 2,168.00 10.17% 6,462.00 3060 -46340 Management Services 597.70 0.92% 597.70 2.80% 3100 -46340 Protective Services 349.56 0.54% 3210 -46390 Telephone &Telegraph 160.49 0.75% 1 94% 683.00 3.21% 1,267.97 3430 -46340 Advertising Other 2,160.66 3.31% 720.22 3.38% 3600 -46340 Insurance & Bonds 5,069.31 7.76% 1,976.85 9.28% 3810 -46340 Electric 1,129.38 1.73% 0.00 0.00% 3820 -46340 Water 20.56% 12,274.01 18.79% 4,381.92 3830 -46340 Gas 0.00% 0.00 0.00% .00 3840 -46340 Refuse 526 6.68 0.81% 0.00 0.00% 3850 -46340 Sewer 4,413.06 6.76% 1,807.25 8.46% 4000 -46340 Repair & Maint. Services 0.20% 95.00 0.45% 131.75 4100 -46340 Rents & Leases 9.20 0.01% 4.63 0.00% 4300 -46340 Miscellaneous Charges 4.56% 992.77 4.66% 2,978.31 4315 -46340 PILOT 558.62 0.86% 0.00 0.00% 4390 -46340 Taxes & Licenses -23.32 - 0.04% 31.97 0.15% 4500 -46340 Administrative Expenses 0.03% 6.11 0.03% 18.55 4850 -46340 Interest on Deposits 90.92-lo 43,673.44 66.86% Total Other Services & Charges 19,375.91 Capital Outlay 5120 -46340 Building &Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0100 u.uu in 0.00% 24,087.19 113.03% 56,736.31 86.86% - 2,776.99 - 13.03 0/a 8,581.89 13.14% Pat xview Villa SOUth (166) Cash Flow Statement Prriod - March 2014 Month to Date Revenue 19,076.78 36220 Gen. Government Rents 345.06 36225 Nondwelling Rents 1,468.36 36290 Other Miscellaneous Revenue 420.00 39120 Recovery Damage City Property 21,310.20 Total Revenue Personnel Services 4,012.00 1000 Accrued Salaries 4,012.00 Total Personnel Services Supplies 48.76 2000 Office Supplies 331.75 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 318.77 2171 General Supplies 0.00 2175 Food Supplies 699.28 Total Supplies Other Services & Charges 5,750.00 3050 Expert & Professional Services 2,168.00 3060 Management Services 597.70 3100 Protective Services 160.49 3210 Telephone & Telegraph 683.00 3430 Advertising Other 720.22 3600 Insurance & Bonds 1,976.85 3810 Electric 0.00 3820 Water 4,381.92 3830 Gas 0.00 3840 Refuse 0.00 3850 Sewer 1,807.25 4000 Repair & Malm, Services 0.00 4050 Garage, Labor Burd. 95.00 4100 Rents & Leases 4.63 4300 Miscellaneous Charges 992.77 4315 PILOT 0.00 4390 Taxes & Licenses 3197 4500 Administrative Expenses 6.11 4850 Interest on Deposits 19,375.91 Total Other Services & Charges 24,087.19 Total Expenses Parkview Villa South (166) Cash Flow Statement Period = March 1014 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow SOloo Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date - 2,776.99 0.00 0.00 1,973.00 (1,055.32) 0.00 12,376.00 720.22 (760.67) 992.77 26.13 14,272.13 11,495.14 Beg Cash End Cash Difference 125,980.80 137,475.94 11,495.14 279.00 279.00 ' 729,970.36 729,970.36 856,230.16 867,725.30 11,495.14 Parkview Villa South (166) General Ledger Period = Mar 2014 Book Accrual Tree ysl tb ';.'Credit - ` v `tfatanee PieperDeta Per4on(0esptlptyon , - Caiftr4l Itel�renca De6R Ramatk9,.= - „', 1000 -46340 Accrued Salaries 7,944 00 - Beginning Balance = 166 3/31/2014 :PostRecurring Recurring 1- 191341 RC 4,012.00 0.00 11,956.00 R/C CHC PR Mgmt Fee Net Change = 4,012.00 0 11,956.00 = Ending Balance = -27.69 = Beginning Balance = 2000-46340 Office Supplies 92.33 0.00 64.64 stunps;Tylerm;sugar;lm ch -L. 166 1/28/2014 Heidi Mlndestrom (petl66hm) P- 376144 PC012814166 166 2/20/2014 Office Depot(ofOBB04) P- 374467 6.98864E +11 7.92 0.00 72.56 candy;pens -31% 166 2/20/2014 Office Depot (ofn8804) P- 374468 6.98864E +11 8.68 0.00 81.24 step stool -31% 166 3/5/2014 Office Depot (offi8804) P- 375194 6.95312E +11 16.93 0.00 98.17 copy paper-31% 166 3/5/2014 Office Depot (offi8804) P- 375198 6.95312E4 11 6.06 0.00 104.23 planners -31% 166 3/19/2014 CommimBond Housing (chc) P- 376132 031914sites 9.17 0.00 113.40 comp support 2/20- 3/19/14 166 3/21/2014 Heidi Mlndestrom (pet166hm) P- 376371 PC012814166 -3i 0.00 92.33 21.07 stamps;Tylenol; sugar; l unch -L. Net Change =48.76 21.07 = Ending Balance = 2010 -46340 Minor Equipment 0.00 = Beginning Balance = 166 3/13/2014 HD Supply Facilities Maintenan<P- 375666 9128400214 14.00 0.00 14.00 roller shade -31 166 3/18/2014 All Inc. (all) P- 376216 51331505002 317.75 0.00 33135 fridge Install Net Change= 331.75 331.75 = Ending Balance = 2171 -46340 General Supplies 435.28 = Beginning Balance = 166 2/24/2014 HD Supply Facilities Maintenam P- 372973 9128023210 19.71 0.00 454.99 drip bowls;range hood Mrs-3 1°j 166 2/24/2014 HD Supply Fad bales Maintenam P- 372973 9128023210 12.07 0.00 467.06 smoke alarms -31% 166 2/24/2014 HD Supply Facilities Maintenam P- 372973 9128023210 13.07 0.00 480.13 closet rod sckts;shlf brckts -31 166 2/24/2014 HD Supply Facilities Malntenan<P- 372973 9128023210 12.17 0.00 492.30 light bulbs-31% 166 2/25/2014 Park Supply of America, Inc. (p P- 373318 81195500 48.60 0.00 540.90 drain cleaner -31 166 3/5/2014 Office Depot (offi8804) P- 375194 6.95312E +11 3.51 0.00 544.41 scrub sponges -3101. 166 3/5/2014 Sherwin - Williams Co. (sher4I It P- 374469 76767 98.07 0.00 642.48 paint -31% 166 3/6/2014 Home Depot Credit Services (hr P- 375542 4140792 17.17 0.00 659.65 door stops;misc maint supp -31' 166 3/13/2014 HD Supply Facilities Maintenam P- 375666 9128400214 3.86 0.00 663.51 vacuum bags -31% 166 3/13/2014 HD Supply facilities Maintenam P- 375666 9128400214 7.08 0.00 670.59 drip bowls -31 166 3/13/2014 HD Supply Facil hies Mai ntenant P- 375666 9128400214 30.97 0.00 701.56 light bulbs -31 166 3/13/2014 HD Supply Facilities Maintenam P- 375666 9128400214 52A9 0.00 754.05 hndhd shwr;clny crtrdg;misc -31 Net Change= 318.77 754.05 = Ending Balance = 3050 -46340 Expert and Professional Services 0.00 = Beginning Balance = 166 3/17/2014 Columbia Heights HRA (coluhra P- 376496 20134 5,750.00 0.00 5,750.00 2nd half 2013 servicing fees Net Change = 5,750.00 5,750.00 = Ending Balance = 3060 -46340 Management Services 4,294.00 = Beginning Balance = 166 3/31/2014 Cammontrond Housing (chc) P- 377094 033114mgmtl 6,180,00 OAD 10,474.00 mgmt fee 03/14 166 3/31/2014 :PostRecurring Recurring 3- 191341 RC 0.00 4,012,00 6,462.00 R/C CHC PR Mgmt Fee Net Change = 2,168.00 6,462.00 = Ending Balance = 3100 -4640 Security Contract 0.00 = Beginning Balance = 166 2/21/2014 Simplex Grinnell (simp) P- 373548 69850741 597.70 0.00 597.70 security alarm maint -31 Net Change = 597.70 597.70 = Ending Balance = 3210 -46340 Telephone & Telegraph 189.07 = Beginning Balance = 166 2/28/2014 Popp.com (popp) P- 375179 992169986 100.55 0.00 289.62 phone -31% 3/14 166 3/1/2014 Level One (level P- 373477 0392970IN 34.38 000 324.00 answering service 3/14 166 3/2/2014 Comcast(comc3474) P- 375176 8772105050196: 25.56 0.00 349.56 Internet-31% 3/11 - 4/10/14 Net Change= 160.49 349.56 = Ending Balance = 3430 -46340 Advertising Other 584.97 = Beginning Balance = 166 2/2812014 Classified Ventures LLC (clas) P- 375334 APF1151989 299.00 0.00 883.97 ad service 166 3/20/2014 Northeaster and NorthNews(no P- 376210 79569 384.00 0.00 1,267.97 advertising 3/5- 19/2014 Net Change= 683.00 11267.97 = Ending Balance = 3600 -46340 Insurance & Bonds 11440.44 = Beginning Balance = 166 3/31/2014 :PostRecurring Recurring 3- 191341 RC 720.22 0.00 2,160.66 C of Columbia Heights Ins Aced Net Change = 720.22 2,160.66 = Ending Balance = 3810 -46340 Electric 3,092.46 = Beginning Balance = 166 3/11/2014 Xcel Energy (xcei) P- 376093 5150441553 03/ 1,967.39 0.00 5,059.85 a 25-3/8 166 3111/2014 Xcel Energy (xcel) P- 376093 5150441553 03/ 9.46 0.00 5,069.31 e-31% 2/5- 3/7/14 Net Change = 1,976.85 5,069.31 = Ending Balance = 3820 -46340 Water Net Change =0.00 3830-46340 Gas 166 3/10/2014 Cente,POlnt Energy (cent) P- 375936 55271324 03110, 4,381.92 Net Change= 4,381.92 3650 -46340 Sewer Net Change =0.00 4000 -46340 Repair & Maint. Services 166 8/14/2013 Gardner Plumbing, LLC (gardlO P- 373320 2694 166 2/12/2014 K.O. Cleaning and Restoration IP- 372938 1669 166 2/21/2014 High Profile Grounds Malntenan P- 373546 29152 166 2/24/2014 HD Supply Facilities Malmenan<P- 372973 9128023210 166 2/27/2014 HD Supply Facilities Malntenam P- 373617 9128121393 166 2/28/2014 LBP Mechanical, Inc (Ibpm) P- 374470 W20141 166 3/1/2014 Kone Inc.(kone) P- 374946 221411571 166 3/5/2014 High Profile Grounds Maintenan P- 375015 29255 166 3/13/2014 HD Supply Facilities Malntenam P- 375666 9128400214 166 3/18/2014 LBP Mechanical, Inc(ibpm) P- 376388 W20163 Net Change= 1,807.25 4100 -46340 Rents & Leases 166 2/28/2014 Muldhousing Credit Control (ML P- 374928 14020343 Net Change =95.00 4300 -46340 Miscellaneous Charges 166 3/21/2014 Frattalone's /Metro Ace (fraL) P- 376474 0179928 Net Change =4.63 4315 -46340 PILOT 166 3/31/2014 :PostRecurring Recurring 3- 191341 RC Net Change = 992.77 4390-46340 Taxes & Licenses Net Change =0.00 4500 -46340 Administrative Expenses 166 2/6/2014 Heidi Mlndestrom (mind965) P- 375153 20614165166 166 2/6/2014 Heidi Mlndestrom (mind965) P- 375337 20614166 166 3/7/2014 Heldl Mlndestrom (mind965) P- 374259 30714165166 166 3/17/2014 Heidi Mlndestrom (mind965) P- 375528 020614165166 -3 Net Change =31.97 4850 -46340 Interest on Deposits 166 3/31/2014 Sec dep interest accrual 3- 191619 G31 Net Change =6.11 179.50 100.00 132.52 16.10 2.24 870.33 322.05 85.05 15.76 83.70 95.00 4.63 992.77 25.00 25.00 6.97 0.00 11129.38 = Beginning Balance = 1,129.38 = Ending Balance = 7,892.09 = Beginning Balance = 0.00 12,274.01 G- 02/04- 03105114 12,274.01 = Ending Balance = 526.68 = Beginning Balance = 526.68 = Ending Balance = 2,605.81 = Beginning Balance = 0.00 2,785.31 toilet repair 4115 8/13/13 0.00 2,885.31 sheet rock repair #215 0.00 3,017.83 snow maint- 02/19/14 0.00 3,033.93 V- 1helts -31% 0.00 3,036.17 V- belts -31% 0.00 3,906.50 heat repair -31% 12/24/13 -1/2f 0.00 4,228.55 elev maint -31% 3/14 0.00 4,313.60 snow /ice removal 2 /24/14 0.00 4,329.36 traction melt -31 0.00 4,413.06 expansion tank repair -31% 4,413.06 = Ending Balance = 36.75 = Beginning Balance = 0.00 131.75 resident screening 2/14 131.75 = Ending Balance = 4.57 = Beginning Balance = 0.00 9.20 padlocks;draw locks -31% 9.20 = Ending Balance = 1,985.54 = Beginning Balance = 0.00 2,978.31 Anoka CLy Property Tax Accrual 2,978.31 = Ending Balance = 558.62 = Beginning Balance = 558.62 = Ending Balance = -55.29 = Beginning Balance = 0.00 .30.29 mileage 2/4- 6/2014 0.00 -5.29 mileage - 02/04- 02/06/14 0.00 1.68 exp reimburse 3/5- 3/6/14 25.00 -23.32 mileage 2/4- 6/2014 -23.32 = Ending Balance = 12.44 = Beginning Balance = 6.11 0.00 18.55 Sec dep Interest accrual 18.55 =Ending Balance= 28216.52 4,129.33 3 Parkview Villa South Bank Reconciliation Report 0313112014 5016464 Balance Per Bank Statement as of 0 313 112 01 4 outstanding Checks Check date Check number 08/1812013 1766 03/0412014 2008 0311112014 2012 03/25/2014 2026 03/25/2014 2027 03125/2014 2030 Payee 10011071 - Johnson kocl - KO. Cleaning and Rosunation LLD kWI- KO. Cleaning and Restoration LLC comc3474- Comcast hom0 - HD Supply Facilities Maintenance, Ltd. 0108804 - Office Depot Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 0313112014 Difference Cleared Items : Cleared Checks Reconciled Balance Per GIL (Reconciled Bank Balance And Reconciled Balance Per GIL) Dale - Tran11 02/04/2014 1982 02/1912014 1895 02/2512014 1999 02/2512014 2000 02/2512014 2001 02125/2014 2002 02/2512014 2003 02/2512014 2004 0212512014 2005 03/04/2014 2000 03/04/2014 2007 0311112014 2009 03/11/2014 2010 03111/2014 2011 03111/2014 2013 04/01/2014 138,202.92 Amount Amount Notes 232.90 0313112014 250.00 100.00 25.56 03/31/2014 75,36 37.20 43.10 8119 25 29 - Al Seasons Garage Door Company 726.98 137,475.94 0313112014 137,476.94 137,476.94 558.62 0.00 hlgh0238- High Profile Grounds Maintenance, Inc. 158.10 0313112014 P y1 l Amount Dale Cleared Notes 338.00 0313112014 10012428- Maughan 322.05 03/31/2014 kone- Kona Inc. 37.20 03131/2014 8119 25 29 - Al Seasons Garage Door Company 3,585.41 0313112014 cent - CenlerPolnt Energy "1u825- Columbia Heights Fire Darn 558.62 0313112014 hlgh0238- High Profile Grounds Maintenance, Inc. 158.10 0313112014 homa7 - HD Supply Facilities Malmonence, Lid 83.25 03131/2014 non2844- Northeaster and NonhNews $04.00 03131/2014 2,149.34 03131/2014 zeal- Xcel Energy 23.32 0313112014 ,dam - Adam's Pest Control, Inc. chc - Commoneond Housing 4,272.01 0313112014 gerd1080- Gardner Plumbing, LLC 179.50 03/31/2014 hlgh6236 -High Profile Grounds Maintenance, Inc. 132.52 03/31/2014 homa9055- Home Depot Credit Services 18.10 03/31/2014 34.38 03/3112014 Love - Level One Parkview Villa South 04/01/2014 Bank Reconciliation Report 03/31/2014 6016464 Cleared Checks Tran# 03/03/2014 432 03/0512014 433 03/07/2014 434 Amount Date Cleared Date Pon Al Notes 8.97 0313112014 03/11/2014 2014 n11nd965 -Heltli MindeaVam 597.70 03/31/2014 03/1112014 2015 slmp - Simplex Grinnell 302.48 03131/2014 03/11/2014 2018 t0012427- Fortune 290.00 03131/2014 03/18/2014 2017 des- Classified Ventures LLC 85.05 03/31/2014 2018 h19h8236- High Proille Grounds Maintenance ,Inc. 03118/2014 322,05 0313112014 0311812014 2019 kone - Kona[no. 870.33 03/31/2014 03118/2014 2020 Ih m- LBP Mechanical, Inc P 25.00 03/31/2014 03M8/2014 2021 mind965- Held[ Mindesirom 05.00 03131/2014 03/1812014 2022 multi - Mullihousing Credit Control 100.55 0313t12014 03/18/2014 2023 Popp - POPPcom 161.76 03131/2014 03/1812014 2024 10011657 - Podlanoe 917 0313112014 03125/2014 2025 chc- Common8ond Housing 17.17 03131/2014 03/2612014 2028 home9056 -Home Depot Credit SOrvices 304.00 03/31/201A 2029 nod2844 - Northeaster and NorlhNms 03/2512014 48.80 0313112014 0312512014 2031 padd - Park Supply of Amedw, Ina 1,976.85 0313112014 03/25/2014 2032 xoal - Xcal Energy 17'060.28 Total Cleared Checks Cleared Deposits Date Tran# 03/03/2014 432 03/0512014 433 03/07/2014 434 03118/2014 437 0312012014 438 03/21/2014 430 Total Cleared Deposits Notes Amount Dale Cleared 14,776.00 03131/2014 5,194.00 03/31/2014 1,064.00 0313112014 411.37 03/31/2014 580.10 0313112014 18.00 03/31/2014 22,031.47 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G Date 3/31/14 Primary Account Enclosures A C C 0 U N T S - - -- Page 1 @XXXXX @6464 37 NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING APP! YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID APPS FROM THE APPLE OR GOOGLE PLAY APP STORES. YOUR NETTELLER CREDENTIALS WILL ALLOW ACCESS TO MOBILE BANKING. NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXX @6464 Previous Balance 133,829.73 6 Deposits /Credits 22,031.47 31 Checks /Debits 17,658.28 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 138,202.92 Number of Images 37 Statement Dates 3/01/14 thru 3/31/14 Days in the Statement Period 31 Average Ledger 142,182 Average Collected 141,409 *********************************************** * * * * * * * * * * * * * * * * * ** * * * * * * * * * * ** Deposits and Credits Date Description Date Amount 3/03 DDA REGULAR DEPOSIT 14,776.00 3/05 DDA REGULAR DEPOSIT 5,194.00 3/07 DDA REGULAR DEPOSIT 1,064.00 3/18 DDA REGULAR DEPOSIT 411.37 3/21 DDA REGULAR DEPOSIT 18.00 3/21 DDA REGULAR DEPOSIT 568.10 Checks in serial order Date Check# Amount Date Check# Amount 3/14 1982 338.00 3/10 2006 23.32 3/04 1995* 322.05 3/06 2007 4,272.81 3/04 1999* 37.20 3/24 2009* 179.50 3/06 2000 3,585.41 3/17 2010 132.52 3/04 2001 558.62 3/17 2011 18.10 3/07 2002 158.10 3/17 2013* 34.38 3/05 2003 83.25 3/17 2014 6.97 3/05 2004 384.00 3/18 2015 597.70 3/04 2005 2,149.34 3/14 2016 362.48 * Indicates skip in check numbers Date 3/31/14 Primary Account Enclosures NORTHEAST PUBLIC FUNDS ACCT QXXXXXQ6464 (Continued) Checks in serial order Check# Amount Date Check# Date 3/24 2017 299.00 3/24 2024 3/27 2018 85.05 3/31 2025 3/31 2019 322.05 3/31 2028* 3/25 2020 870.33 3/28 2029 3/24 2021 25.00 3/31 2031* 3/24 2022 95.00 3/31 2032 3/24 2023 100.55 * Indicates skip in check numbers Page 2 QXXXXXQ6464 37 Amount 181.76 9.17 17.17 384.00 48.60 1,976.85 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Date Balance Section Balance Date Balance Date 3/25 Balance 141,045.81 3/01 133,829.73 3/10 3/14 143,289.63 142,589.15 3/27 140,960.76 3/03 3/04 148,605.73 145,538.52 3/17 142,397.18 3/28 3/31 140,576.76 138,202.92 3/05 150,265.27 3/18 142,210.85 3/06 142,407.05 3/21 142,796.95 3/07 143,312.95 3/24 141,916.14 * ** E N D O F S T A T E M E N T Parkview Villa South Payment Summary Bank= 166opr AND mm /yy= 03/2014- 03/2014 AND All Checks =Yes AND Include Voids =All Checks Check Post Total Bank Check# Vendor Date Month Amount 166opr - Parkview Villa South 2006 adam - Adam's Pest Control, Inc. 03/04/2014 03/2014 23.32 166opr - Parkview Villa South 2007 chc - CommonBOnd Housing 03/04/2014 03/2014 4,272.81 166opr - Parkview Villa South 2008 kocl - K.O. Cleaning and Restoration LLC 03/04/2014 03/2014 250.00 166opr - Parkview Villa South 2009 gard1086 - Gardner Plumbing, LLC 03/11/2014 03/2014 179.50 166opr - Parkview Villa South 2010 high8236 - High Profile Grounds Maintenance, I 03/11/2014 03/2014 132.52 166opr - Parkview Villa South 2011 home9055 - Home Depot Credit Services 03/11/2014 03/2014 18.10 166opr - Parkview Villa South 2012 kocl - K.O. Cleaning and Restoration LLC 03/11/2014 03/2014 100.00 166opr - Parkview Villa South 2013 leve - Level One 03/11/2014 03/2014 34.38 166opr - Parkview Villa South 2014 mind965 - Heidi Mindestrom 03/11/2014 03/2014 6.97 166opr - Parkview Villa South 2015 simp - Simplex Grinnell 03/11/2014 03/2014 597.70 166opr - Parkview Villa South 2016 10012427 - Fortune 03/11/2014 03/2014 362.48 166opr - Parkview Villa South 2017 clas - Classified Ventures LLC 03/18/2014 03/2014 299.00 166opr - Parkview Villa South 2018 high8236 - High Profile Grounds Maintenance, I 03/18/2014 03/2014 85.05 166oar- Parkview Villa South 2019 kone - Kone Inc. 03/18/2014 03/2014 322.05 166opr - Parkview Villa South 2020 Ibpm - LBP Mechanical, Inc 03/18/2014 03/2014 870.33 166opr - Parkview Villa South 2021 mind965 - Heidi Mindestrom 03/18/2014 03/2014 25.00 166opr - Parkview Villa South 2022 multl - Multihousing Credit Control 03/18/2014 03/2014 95.00 166oar - Parkview Villa South 2023 Popp - Popp.com 03/18/2014 03/2014 100.55 166opr - Parkview Villa South 2024 1:0011657 - Pordance 03/18/2014 03/2014 181.76 166opr - Parkview Villa South 2025 chc - Common Bond Housing 03/25/2014 03/2014 9.17 166opr - Parkview Villa South 2026 comc3474 - Comcast 03/25/2014 03/2014 25.56 166opr - Parkview Villa South 2027 home7 - HD Supply Facilities Maintenance, Ltd. 03/25/2014 03/2014 75.36 166opr - Parkview Villa South 2028 home9055 - Home Depot Credit Services 03/25/2014 03/2014 17.17 166opr - Parkview Villa South 2029 nort2844 - Northeaster and North News 03/25/2014 03/2014 384.00 166opr - Parkview Villa South 2030 offi8804 - Office Depot 03/25/2014 03/2014 43.10 166opr - Parkview Villa South 2031 parkl - Park Supply of America, Inc. 03/25/2014 03/2014 48.60 166opr- Parkview Villa South 2032 xcel- Xcel Energy 03/25/2014 03/2014 1,976.85 10,536.33 Parkview Villa Apartments 965 40'x' Avenue NE, Columbia Heights, MN 55421 Owned by the City of Columbia Heights HRA Managed by CommonBond Communities Management report for Parkview Villa for the month of January 2014 Prepared by Heidi Mindestrom, Property Manager Police Report There were 5 calls for service. Wait List 36 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicants for Parkview Villa North (employed in C.H.) 18 applicants for Parkview Villa North (non- resident, elderly, handicapped) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 00 applicants for Parkview Villa South (non - resident) 00 applicant for Parkview Villa South 2BR (resident) 00 applicant for Parkview Villa South 2BR (non - resident) Occupancy North is 97 out of 101 (97% occupancy) (caretaker unit included in total number of units) South is 35 out of 45 (85 % occupancy) Move Outs #703 01/16/2014 #611 01/31/2014 Move INS Maintenance Report (See attached) Brrrrr. Parkview Villa Apartments Newsletter Phone 763 - 706 -3800 Hours 8 a.m. -4:30 p.m. After Hours Maintenance: PV North 866 - 962 -8896 PV South 866 - 962 -8897 Managed by Common Bona Owned by the City of Columbia Heights Communities . Office will be Closed on Monday January 20th - Martin Luther King Jr Day Board Meeting- Sunday January 5th @ 3pm Resident Council Meeting- January 13th @ 7pm Blood Pressure checks -B Comm Room Tuesdays @ 10am "Crafty Ladies" will be on the 3rd floor sitting room @ 3pm on Weds NAPS on Tuesday 14th -B Room REMINDER: The weather has taken that turn to blis- tery cold days. Remember to dress properly. If you decide to go outside make sure you cover all skin. Hat, gloves, scarf, boots. This is the season for frost bite skin. Stay warm, keep safe. Cold Ahead Birthday Meal January 29th 2014 ♦ Beef Pot Roast ♦ Mashed Potatoes /Gravy ♦ 2 tone beans ♦ Dinner Roll w /marg. ♦ Yellow Cake with Choc Frost- ing RCD: Unfrosted Please be sure to order your meal three days in advance with Joan. 763 - 789 -7018 As you all know there is smoking on the premises. Just Remem- ber to smoke at the Smoke Shack ONLY. Any smoking by the building, standing on the curb will result in Infractions. Please be considerate to others. Thank you for your understand- ing in this ongoing issue. Thanks to all of you for your co- operation in moving your cars during our snow removal proc- ess. This helps us keep the park- ing lot free of snow and minimize ice build up! When there is 2 or more inches of snow we will need you to move your vehicles. If you would like a copy of the Parking/ The 2nd reminder is about Pet Waste. Be mindful of other residents, guests and pets that reside here as well. Pick up af- ter your pets and make sure you are taking them to the park to handle their business. Thanks for considering every- one else in this matter. Thank you! Hot. Chocolate anyone... Snow removal Policy, please stop by the office and we will give you a copy. You can also find the snow removal policy in your handbook. If you do have any questions, feel free to contact the office for further clarification. m & � m Q 5 b J� s � \ � \ � / \, } ;{ \. » y \m- \ \ \` ( *\ �\ (� \� � . { ) � - K ( ( ( td 0 / *2 §p (\ ! *y 2» \\ ƒ 0 )[ \ y/ §; r « �\ \ �} \ /\ { � \ } m & � m Q 5 b J� s � \ � \ � / \, 1� O a v w C 16 C w M C m a Y O CL m N v 0 m m M m m M m m M M m M M M M M M M M = > 3 > > Q > � m > > > c > 'LC > > � > v o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (L '0 u L MM ° M U w w M M M o rq M M m M o w +u. > 0 � y w CL N ti w m o m N �o m rn m m rn o ti oo ao N M m .o �o 0 N \ \\ 0 N\ u L0 �° 0 c u 3 > L \ L C N N \ N N N \ N N N N N N N \ \ \ \ \ \ \ \ \ w ° 00 OZS o O O C L N O M zT l0 00 01 01 Ol 01 O O ti y L F_ H V7 Y w H N H N N H N N rl u C v u 0'a CU ci N N H o N N N N U c 0 OZj N CZ w N 0 0 v aj C 0 3 O O •0 w Y u c u Y L -° U w vy W � v Q w ai a 00 o o k 0 0 L: Y M > Y 7 0 Y m U N C O o ° c O 0 3 'Y al u m 5 m = C m Z w Z Z Z Z V1 VI E V) Z m V1 V1 Z Z Z m O o = > 3 > > Q > � m > > > c > 'LC > > � > Co Y m a w c a L U a O M a v (L '0 u L MM ° M U w w M M M o M M M m M o w +u. > 0 � y w CL N ti L u H N o O o 0 N 0 C 0 0 0 o 0 o C 0 w T c 0 u L0 �° 0 c u 3 > L \ L C Q ° 0 O a� \ i N N w w —°c 0 \ O E O. u C w ° 00 OZS o O O C L N O M zT l0 00 01 01 Ol 01 O L y L F_ m V7 Y w ly! 0 H \\ o Y >0 0 C v u 0'a CU ci N N H o N N N N U c 0 OZj N CZ N N \ \ .c \ \ \ \\ w H c a ^ �-I o 3 m u c s° v m N u m N 0 C a C Q1 N C U 'E C N N Y 0 C a 0 aw v ° Q a c Y m v O O L O H N c N Y v v m L O v C c O 0 ° C N c m ° ao M 3° w o° vi to aa) C U N a O C C Q 0 '^ C N '0 J y0 p w CL 'a) •C b L L VI = O fa � "O L C w0 C C Se 06 -0 > w °O oti "° = w u° o c `� � m O N m 2 E •D L U = w CL w a E w T M w C° m u W L M �- LO w L 0 v y C 3° obi m a a > L r o L Y to L C C E C 0 C 0 w M L in 0 ,a; C w to a o> w > > o 0 3 3 w L LO_ 9 ,� Y 0 M N C yVj C j C L 0 m u ° w C y W w O O O m L 7 c C L 0 O C O J D U 0 vl Q Q ro U F H E M Z L O Y LL •C L n w N 0 0 v aj C 0 3 O O •0 w Y u c u Y L -° U w vy W � v Q w ai a 00 o o k 0 0 L: Y M > Y 7 0 Y m U N C O o ° c O 0 3 'Y al u m 5 m = C m Z — Z Z Z Z V1 VI E V) Z m V1 V1 Z Z Z Z o = > 3 > > > > � > > > > c > > > > � > a m a w s a L U a O M a 0 wm (L '0 u L MM M MM M w M M M o M M M m M o w +u. � H� N CL N ti .-r u H N o O o 0 0 0 0 0 0 0 o 02S o C 0 o T o 0 L0 3 0 a u > \ \ '0 C C ° 0 O M \ 0 N w w —°c \ \ 0 E \ u ° a o O M zT l0 00 01 01 Ol 01 O L y L F_ m V7 Y w Y \ \ \\ o \\ c N 0 v w 0'a CU ci N N H o N N N N U c w OZj N CZ N N \ \ .c \ \ \ \\ v H m ° ^ �-I o N m > N s° N N m N c m N 0 0 C N C Q1 N C U 'E C N N 0 O O 0 ° Q a c Y a O O L O H N c N Y v v m L O v C c O 0 ° C N m C O •O w C vi C N o2i w — w w L C CL 'a) VI y VI VI Y O fa L LVI C C Y C C Se w N 0 0 v aj C 0 3 O O •0 w Y u c u Y L -° U w vy W � v Q w ai a 00 o o k 0 0 L: Y M > Y 7 0 Y m U N C O o ° c O 0 3 'Y al u m 5 m = C m Z Z Z Z Z Z V1 VI V V) Z V1 V1 V1 Z Z Z Z Z = > > > > > > > > > > > > > > > > > > > m a s a Q a a M a Q (L a u M MM M MM M M M M M M M M M M M M w � H� N H� N ti .-r ti H N o O o 0 0 0 0 0 0 0 o O o 0 0 o O o 0 \ \ \ \ \ \ \ \ \ N \ \ \ \ \ \ N M zT l0 00 01 01 Ol 01 O N N M V7 l0 \ \ \\ \\ N N ci rl rl ci N N H w N N N N N N N N N N N N \ \ \ \ \ \\ , H N N N �-I N N �-I N N N N N N N N N N N N M N N H N N N N N N N Q m m m m m m m m m m m m m 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ ko io r oa r ao 00 oa m m m ct Lo N N N N N N (14 N N N N N N a O C � N N vl a) to C C C af6- N O C C u L > O (U 3 m d = V K O > vYi 0- > t U O E c > O Z' '- N K > to ai O ai O •` N > O ai a C F C N o ai � o o a — L v m � U m O a) Q 4 >O N U C O a to + 0 ti u o c 3 c L v= > Y fl O O a) 3 a) +' O C a) a) O U 06 C].> > E 0) O �L v NO E �" m o C L ✓ O C C N Y O t .O _ O iG = E O N _ v .O v U 7 O C N N Y C N E bA 06 CL U w a) L O Y a) S Y L C aJ Q �- Y U — N L E aJ ua) .N '� C > Y O ` Y ..Y O O O. u O U °� 6 3 5 E L U .O E v Q> a v o w v aci E v Q °c o E 3 O �e ai �, L -o > L ai ai -Y ai '- v ai o v E o v t m Q= o v t o s o u r o m Y le > V) O H m F- m o L 0 0 a c N V) N Z Z (n V) 0 Vl Z Z Z Z Z a a d a a s a s a s d a a m m m m m m m m m m m m m N N H N N N ti N N ti ti 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ lO lO lO l0 I, r 00 W Ol m M d' w N N N N N N N N N N N N N N N rl N N a-I H N N N rl N N a-1 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 February 2014 Prepared by Heidi Mindestrom, Property Manager Police Report There were 3 calls for service. Wait List 39 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicants for Parkview Villa North (employed in C.H.) 18 applicants for Parkview Villa North (non- resident, elderly, handicapped) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 00 applicants for Parkview Villa South (non - resident) 00 applicant for Parkview Villa South 2BR (resident) 00 applicant for Parkview Villa South 2BR (non- resident) Occupancy North is 97 out of 101 (97% occupancy) (caretaker unit included in total number of units) South is 35 out of 45 (85 % occupancy) Move Outs #225 2/28/2014 #115 2/28/2014 Move INS Maintenance Report (See attached) Managed by CommonBond Communities .. to Parkview Villa Apartments Newsletter Off ice Info Phone 763 - 706 -3800 Hours 8 a.m. -4:30 p.m. After Hours Maintenance: PV North 866 - 962 -8896 PV South 866 - 962 -8897 Upcoming Events Resident Council Meeting February 10th 7pm -B Room Happy Valentines Day February 14th 2014 . Office closed on Presidents Day February 17th 2014 NAPS February 18th 2014 [lid you ; o That February is National Qs Awareness month? Take the time and be aware of what M you have, the great friends & family you have. Take the time to enjoy the snow & the blue skies. Take the time to smell the roses. It is also the month of Valentines Day. Show someone that they are "sweet" by a nice gesture. Birthday Meal February 26th 2014 e Beef Pot Roast e Roasted red potatoes e Green beans e Wheat dinner roll w/ Margarine Rainbow The 1 It has been mentioned that the Rainbow Foods on Central Ave- nue will be closing the beginning of January 2014. If you have lim- ited transportation, now is a good time to think about using Schwans Home Delivery as well as Rick, The Milkman. e Carrot Cake ♦ Please be sure to order your meal three days in advance with Joan. 763 - 789 -7018 3 Tablespoons of butter 1 onion, chopped 1 cup of celery 3 Tablespoons of all purpose flour 2 cups of diced chicken. Prepare rice according to package directions. Melt the butter in a large pot over medium heat. Add the onion and celery and saute for 5 -10 minutes Add the rice and the chicken and allow to heat through, about 10 minutes. Serve & enjoy! f i i Rainbow The 1 It has been mentioned that the Rainbow Foods on Central Ave- nue will be closing the beginning of January 2014. If you have lim- ited transportation, now is a good time to think about using Schwans Home Delivery as well as Rick, The Milkman. e Carrot Cake ♦ Please be sure to order your meal three days in advance with Joan. 763 - 789 -7018 3 Tablespoons of butter 1 onion, chopped 1 cup of celery 3 Tablespoons of all purpose flour 2 cups of diced chicken. Prepare rice according to package directions. Melt the butter in a large pot over medium heat. Add the onion and celery and saute for 5 -10 minutes Add the rice and the chicken and allow to heat through, about 10 minutes. Serve & enjoy! W C 3 c h! ,1 cn rt Ub �+ a a w � � n � N w � o a ° ro m o v •�.. m m o o rn o ny ^^' P, C (D 0 z td . 00 b p w P tl0 O^^ lC/ N x x w m o � ° m' y. 7y w p, rro to ° a o w 5 C] Eg w W lCl J ro o co M d C by ttl " CO n G o rn 0 C) n C7 0 o w ti o w w bW � rn rn W C 3 c h! ,1 cn rt Ub �+ a a r= a w m u c m c v Y e .m �o 5 'd Y d v v v v v v v v a v v v v a s v v 0 0 0 0 0 0 0 o O o 0 0 0 0 0 0 0 0 0 0 a1 N N N N N N N N N N N N N N N N N (N N aw \ \ \ \ \ \ \ \ \ \ \ \ \ \ M \ M \ V \ 00 \ a0 \ Ol a) M M 00 an (3) O M et to t0 e°i N N \ \ \ \ \ \ \ \ \ 0 u Y_ C C C y c (U 41 O O L O C v o u 3 0 c O O E � wm t a1 >O vOi OL O N •� vi f0 O �. a O w+ .0 Y 7 O C m u o v a a) o = v 3 0 v v v v r 0 0 c bb w 0 =' w u Q w '�^ 0 w 3 0 o 0 o 0 c Y " au c � a) c Y ,v, O m 0 J aA Q p a) al O y 'O O C +�' as 0 U a) > u w �4) O O O v U C' C. O ® 00 -D N O 0 a) N C. a+ O +' a) m H ly/1 VI VI m Y Q L N 0. N 1' •O co r. N U �- 4 O C c0 O a) LF, w 0 a) N C Y j 0 0) `m `O ++ K O Y (Lj .00 "O a) O C W O N 0 � C � al 0 E L .0 .6 O a) YO 3: E � N N> •O C 0 j al N 0 L (0 O 0 O~ j a) O •0 Q L Op +� (>p a s Ou 0 c 0 �- a) N ,3 O 0 CU v1 w c L O Y a) E O C c y .L ++ C. C C L a) — C T U in O 0 v Y (a a) C N 3 O m C >_ N ry— O 0 M LO_0 O C C •O. y— 'a 9 a) N 7 L V U 0 a+ >> to N u C �n Vim- �C O� L L O O O "O L OY! C 00 E u O O L O aL+ O ',�•� () ate+ O a) )a — C. a) a0 — -0 = N L a) C +' > u y L Y O �e u 0 = u 3 v E �"' Y L N c C E Y y O ,°�' o° 3 v` o c o 3 3> 0 u 3 c v r° w c d a v CL 0 YO N N w O1 N O N N aC' ~ U L N C u ++' 0 UV) yLi C Y U a) `� Cam. p 0 U L a) N C. C. O U C= L u U\ L a) L O C O no E= O O m Q 3 Q H N Q Y F- N .n Q Ln L F- in O O J J V) U O Y O +`+ Z m d' E z a, — m m Y � L c m � v) z z z z z z z z v) z z z z z z )n z )n —° > > > > > > > > > > > > > > > > > > > m a a a s a M a n. a a M fL a o. M n. a a a v c -1 t* <r v v v v �t v a v c v v v v v m H 14 ti N ti H ti H ti H N N N H ti r-i r-I ti 0 0 0 O o 0 0 0 0 0 0 0 o 0 0 o O o M N N N N N N N N N N N N N N N N N N M M a W 00 W y M \ 00 \\ Ol Ol \ O H M H N V1 H lD r7 N N N N N N N N N N N N y N o Q1 C 0 'co 0 L 3 0 a C f0 N 'O Q/ L Y C m C v a a a N 0 0 0 N N N N N N O\i 0) N N N M c I\�-I � ;- z z z a a a a a a N 0 0 0 0 0 N N N 0) O\ 8 N N tYl N N N G1 'O N c 3 � � r a 3 o v � u m n c CL) s G •� C 0 t C M ti C N Q) C U � rw L v 3 0 0 0 C C H 0 N (U L 06 e "O 'C Y Y C v C o V z bo to (U C ul Y C N N C �L -a�aro 0 z z z a a a a a a N 0 0 0 0 0 N N N 0) O\ 8 N N tYl N N N Parkview Villa Resident Council (Meeting Minutes from, March 21, 2014 The Meeting was called to order at 7PM. Pledge of Allegiance was said Last month's Minutes were read by Shirley Treasury report for February 2014 read by Rose Beginning balance $ 993.18. Ending balance $ 887.05 after expenses paid out for, Nurse, and Bingo Sunshine Club report given by Diann Powell, Bingo report given by Jackie Ovshak. MANAGER HEIDI REPORT. If you see a NON resident in the building and they are not with whom they are visiting, the Office needs to know. I will need to speak to that Resident. They are not allowed to roam the building alone. 2. Remember if anyone on North or South refers an applicant and they sign a lease you can get a gift card votes are back 54 were returned to the office 47 voted to stop giving out the $20.00. 7 to continue giving out the $20.00 or at least one $5.00. We will no longer pay people to attend their resident council meeting. Sandy is planning a Spring Fling night 4 -8 -14. Watch for signs. Things to speak to Manager Heidi: 1. Parking in the circle for longer than 5 min. 2. 10 miles per hour sign in the parking lot 3. Powdered soap being used in the laundry machine left over soap gets on the next persons wash. Bingo will be run different for the month of April (trial bases). We need to save money. We will play with the money that we collect each Thursday night. You can purchase 3 cards for $1.00 or 6 cards for $2.00. We will no longer give out the money to those seated by you. The Coverall or Special game will cost $.25 cents if you want to play. Each person that wants to play will get a ticket when they put their $.25 cents in the cup. Only those that give the $.25 cents can play coverall or special game. This is an experiment to see If we can save the $120.00 we have been paying out, so we can use it for other things. Meeting adjourned. COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meeting of: April 22, 2014 AGENDA SECTION: ORIGINATING EXECUTIVE NO: Business Items #9 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Resolution 2014 -07 Purchase BY: Scott Clark BY: Agreement Extension DATE: April 17, 2014 BACKGROUND: On August 27, 2012 the Housing and Redevelopment Authority (HRA) approved a Purchase Agreement with Aeon for the sale of Parkview Villa North and South. Based on terms of that Agreement the termination date, including Buyer extension provisions, ends on April 30, 2014. The attached resolution extends the Purchase Agreement, as written until the end of April 2015. This amended Agreement is written without any substantive changes to the original since it is understood, and written within the original Agreement, that major changes will occur once a final deal is agreed to with the Department of Housing and Urban Department. The economic structure between Aeon and the HRA will be driven by the ultimate contract rent allowance for the North building, which in turn, will determine key financial determinations such as the price for the South building, rehabilitation amounts, etc. The primary reason that the Agreement needs to be addressed now, and not have a period of time where there is no official contract in- place, stems from the fact that Aeon will be needing to extend their HOME fund appropriations from the MHFA, and an in -place and continuous signed Agreement is critical. Staff will be present for questions and if any HRA Commissioners desires answers to questions that may need some research time, please contact before the meeting. RECOMMENDATION: Approval of the extension as written. RECOMMENDED MOTION: Move to waive the reading of Resolution 2014 -07, there being ample copies available to the public. Move to adopt Resolution 2014 -07, being a Resolution Approving First Amendment to Purchase Agreement, Dated April 22, 2014, For the Sale of Parkview Villa and South. Attachments: First Amendment to Purchase Agreement Dated April 22, 2014 Resolution 2014 -07 Original Purchase Agreement Dated August 22, 2012 HRA ACTION: HRA RESOLUTION 2014 -07 COLUMBA HEIGHTS HOUSING AND REDEVLOPMENT AUTHORITY APPROVING FIRST AMENDMENT TO PURCHASE AGREEMENT, DATED APRIL 22, 2014 FOR THE SALE OF PARKVIEW VILLA NORTH AND SOUTH WHEREAS, the City of Columbia Heights Housing and Redevelopment Authority (HRA) has expressed a desire to sell Parkview Villa North and South, and WHEREAS, after a long search and an interview process the HRA identified Aeon, a major regional low and moderate income housing provider, as a potential Buyer, and WHEREAS, on April 16, 2011 the HRA approved a memorandum of understanding with Aeon that established the goals of the sale, and WHEREAS, to date Aeon has committed themselves to the sale of Parkview Villa through work including complete building analysis, grant applications, funding strategies, submittal of the Public Housing Agency dissolution application, resident meetings and a variety of other tasks, and WHEREAS, this work has been done in conjunction with the HRA staff and the HRA board itself, and WHEREAS, on August 27, 2012 the Housing and Redevelopment Authority approved and entered into a purchase agreement with Aeon, and WHEREAS, that Agreement has been formally extended by Aeon until April 30, 2014, and WHEREAS, all parties have acted in good faith and a need arises to extend the original Agreement until April 30, 2015. NOW THEREFORE BE IT RESOLVED: The Housing and Redevelopment Authority Approves First Amendment to Purchase Agreement, Dated April 22, 2014, For the Sale of Parkview Villa North and South Passed this 22nd day of April 2014 Motion by: Second by: Roll Call: Shelley Hanson, Secretary Tammera Diehm, Chair Qrdlg r;ld /%9reelmtt, PURCHASE AGREEMENT THIS PURCHASE AGREEMENT ( "Agreement ") is made as of this _ day of 12012 ("Effective Date ") between the CITY OF COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY, a Minnesota political subdivision, ( "Seller "), and AEON, a Minnesota non -profit corporation, ( "Buyer"). In consideration of this Agreement, Seller and Buyer agree as follows: 1. Sale of Property. Subject to compliance with the terns of this Agreement, Seller agrees to sell to Buyer, and Buyer agrees to buy from Seller, the following property (collectively, "Property "): a) Real Property. The project commonlly known as Parkview Villa North and Parkview Villa South located at 965 40t' Avenue Northeast in Columbia Heights, Anoka County, Minnesota, including the land legally described on Exhibit A attached hereto ( "Land ") together with (i) all buildings and improvements constructed or located on the Land ( "Improvements ") and (ii) all easements and rights benefiting or appurtenant to the Land, including Seller's rights in any vacated or existing public rights of way abutting the property ( "Appurtenances ") (the Land, Improvements, and Appurtenances are collectively the "Real Property "), subject only to Permitted Encumbrances (defined below). b) Personal Property. All of the equipment, furnishings, furniture, and other personal property owned by Seller and situated in or about the Real Property including, without limitation, those items described on the inventory attached to this Agreement as Exhibit B ( "Personal Property "). c) Leases. Seller's interests as lessor in all of the leases affecting any Real Property or Personal Property ( "Leases "), including without limitation, those described on the rent roll attached hereto as Exhibit D ("Rent Roll "), with the exception of the Cellular Antenna Lease, as defined in Section 17 of this Agreement. d) Contracts. Seller's interests in the service and maintenance contracts, equipment leases, and other contracts regarding the Real Property and Personal Property that Buyer agrees to assume in writing, along with any deposits related thereto ( "Contracts "). e) Permits. Seller's interests in the permits and licenses relating to the Real Property and the activities conducted thereon ( "Permits "). f) Warranties. Seller's interests in all assignable warranties and guaranties given to, assigned to or benefiting Seller or the Real Property or the Personal Property regarding the acquisition, construction, design, use, operation, management, or maintenance of the Real Property and the Personal Property ( "Warranties "). fb.us.8843595.06 g) Plans. All originals and copies of the as -built blueprints, plans, specifications, soil tests, and structural tests regarding the Real Property and the Personal Property, in possession of Seller, if any ( "Plans "). h) Records. Copies of the records of Seller regarding the Property, including the records and materials regarding management and leasing, utilities, real estate taxes and assessments, certificate of occupancy, inventory of equipment and personal property, insurance, tenants, marketing, advertising and promotions, maintenance, repairs, capital improvements and services, and tax returns and audits filed with respect to the Property for the three calendar years preceding the Effective Date and for the calendar year of the Effective Date through the Closing Date (as necessary for purposes of obtaining low income tax credits), but excluding such records that are not permitted by law to be disclosed or disseminated to Buyer, unless redactions may be made to such records in a manner that will allow them to be lawfully disclosed ( "Records "). i) Tenant Deposits. All unapplied security deposits, prepaid rents, and other tenant deposits and prepaid amounts under the Leases (including interest thereon at not less than the statutory rate), including valid transfers of any noncash security or documents held for such purposes ("Tenant Deposits "). j) Receivables. All accounts receivable and other receivables reflected on Seller's balance sheet on the Closing Date, whether payment on such receivables is due on or after the Closing Date ( "Receivables "). k) Accounts. All cash and funds in residual receipts accounts and all funds in real estate tax escrow and insurance escrow accounts which amounts shall be adequate to pay real estate taxes and insurance premiums prorated as of the Closing Date ("Transferred Accounts "). 2. Purchase Price and Manner of Payment. Buyer shall pay to Seller as arid for the purchase price for the Property the sum of Five Million Five Hundred Sixty Thousand and No /100 Dollars ($5,560,000.00) ("Purchase Price "), subject to Section 3(g) below, to be paid by Buyer to Seller as follows: a) Earnest Money. Concurrently with the execution of this Agreement, Buyer will pay to Seller cash in the amount of Ten Dollars ($10.00) ("Earnest Money "). b) Balance. Buyer will pay the balance of the Purchase Price by certified or cashier's check or wire transfer on the Closing Date. 3. Contingencies. The obligations of Buyer under this Agreement are contingent upon each of the following: a) Representations and Warranties. The representations and warranties of Seller contained in this Agreement must be accurate in all material respects now and on the Closing Date as if made on the Closing Date. Seller shall have delivered to W N.us.8843595.06 Buyer at Closing a certificate dated as of the Closing Date certifying that such representations and warranties are true as of the Closing Date ( "Update Certificate "). b) Title. On or before the Closing Date, title shall have been found acceptable, or been made acceptable, in accordance with the requirements and terms of Section 6 below. C) Performance of Seller's Obligations. On or before the Closing Date, Seller shall have performed all of the obligations required to be performed by Seller under this Agreement, as and when required by this Agreement. d) Testing and Environmental Investigation. Within 30 days following the Effective Date, Seller shall provide copies of all soil tests, engineering inspections, structural and mechanical inspections, environmental inspection reports, and any and all other reviews, tests, or studies of the Property in Seller's possession. Buyer shall have determined, on or before the Contingency Date (as defined below in this Section 3), that it is satisfied with the results of all matters disclosed by soil tests, engineering inspections, structural and mechanical inspections, environmental inspections, and any and all other reviews, tests, or studies of the Property, all such tests, inspections, and reviews to be obtained at Buyer's sole cost and expense. Buyer shall provide Seller with a copy of any reports, test results, or studies obtained by Buyer. Seller shall allow Buyer, and Buyer's agents, access to the Real Property without charge and at all reasonable times for the purpose of Buyer's investigation and testing the same. In performing such investigation and testing, Buyer shall attempt to minimize any interference with the operation of the Property or the Improvements. Buyer shall hold Seller and the Real Property harmless for all costs and liabilities relating to Buyer's activities on the Real Property except that Buyer shall not be responsible for any pre - existing contamination. This obligation will survive Closing or termination of this Agreement. Buyer shall further repair and restore any damage to the Real Property caused by or occurring during Buyer's activities and return the Real Property and Personal Property to substantially the same condition as existed prior to such entry. This obligation shall survive termination of this Agreement. Buyer shall consult with and obtain the consent of Seller, which consent shall not be unreasonably withheld or delayed, before cominencing invasive testing of the Real Property. e) Document Review. Within 30 days following the Effective Date, Seller shall provide true and correct copies of all of the following documents and information: Leases, Contracts, Permits, Warranties, Plans, Records, updated Rent Roll, insurance policies currently in force for the Property, all reports described in Section 3(d) above, any as -built survey of the Property, current title insurance policy, any certificates of occupancy for the Property, an inventory of the Personal Property, audits and income and expense reports for 2009 through 2011 ("Operating Statements "), and the Cellular Antenna Lease (as defined in Section 17 below) for Buyer's review and analysis, and Buyer shall have determined, on or before the Contingency Date, that it is satisfied with its review and analysis of the Leases, 3 t1.us.8843595.06 Contracts, Permits, warranties, Plans, Records, Rent Roll, and Operating Statements. From time to time, Buyer may request year -to -date financial data and updated Rent Rolls, which Seller shall provide. f) Appraisal. If deemed necessary by Buyer and at its own expense, Buyer shall have obtained au as -is property appraisal on or before the Contingency Date that supports the Purchase Price. g) Project Financing. On or before the Closing Date, Buyer shall have obtained financing necessary and sufficient in Buyer's sole and absolute discretion for the acquisition and rehabilitation of the Property and to make use of the Property as a residential apartment building ("Buyer's Intended Use "), at rates and on terms acceptable to Buyer, which financing shall include (but shall not be limited to) Seller financing of approximately $5,540,000 at a rate and on terms acceptable to Buyer (the "Seller Loan "). Seller and Buyer acknowledge and agree that if this contingency is not met because Buyer's project financing is not available in amounts and at rates and terms anticipated by and acceptable to Buyer, Buyer may request a renegotiation of the Purchase Price, to be accomplished by the parties cooperatively and in good faith in an amendment to this Agreement, or Buyer may terminate this Agreement pursuant to the last paragraph of this Section. Seller may also request a renegotiation of the Purchase Price in the event that it receives or does not receive additional financial resources that affect the amount of Seller financing that is available. h) Government Approvals. The obligations of Buyer and Seller to consunnnate the purchase transaction provided herein shall be subject to Buyer having obtained on or before the Closing Date, to Buyer's satisfaction and at Buyer's expense, (i) approval from HUD's Special Applications Center that allows Seller to dispose of the Property; (ii) an allocation of at least 100 tenant protection vouchers; (iii) conversion of all tenant protection vouchers to Project Based Section 8 Vouchers; and (iv) all other final governmental approvals necessary in Buyer's reasonable judgment in order to effectuate Buyer's Intended Use. Seller shall cooperate with Buyer in its efforts in obtaining the consents and approvals listed in this paragraph. i) Cellular Antenna Lease. On or before the Closing Date, Buyer shall be satisfied with the Cellular Antenna Lease, as defined in Section 17 below, including as renegotiated or re- executed, if applicable, and any and all amendments. j) Easement Agreement. On or before the Closing Date, Buyer and Seller shall have entered into the Easement Agreement, as defined in Section 17 below. k) Material Changes. There shall have been no material adverse changes in the operation or physical condition of the Property in the period between the Contingency Date and the Closing Date. M rv.us.8843595.06 The "Contingency Date" shall be December 31, 2013 (or such later date pursuant to Buyer's extension, if exercised, in accordance with Section 4 below). If any contingency set forth in this Section 3 has not been satisfied on or before the date set forth in such contingency, then this Agreement may be terminated, at Buyer's option, by written notice from Buyer to Seller. Such notice of termination must be given at any time not later than the Contingency Date or Closing Date, as the case may be. Upon such termination, the Earnest Money and any interest accrued thereon shall be released to Buyer. Neither party will have any further rights or obligations regarding this Agreement or the Property. All the contingencies set forth in this Section 3 are specifically stated and agreed to be for the sole and exclusive benefit of Buyer and Buyer shall have the right to unilaterally waive any contingency by written notice to Seller. 4. Closin . The consummation of the purchase and sale transaction contemplated by this Agreement ( "Closing ") shall occur on a date selected by Buyer ("Closing Date "), upon no less than 10 days prior written notice to Seller, on or before December 31, 2013; provided, Buyer may extend the Closing Date and the Contingency Date for up to four months upon written notice to Seller. The Closing shall take place at 10:00 a.m. local time at the office of Commonwealth Land Title Insurance Company ( "Title "), located at 7701 Prance Avenue South, Suite 120, Edina, Minnesota or at such other time and place as may be agreed to by the parties. Seller agrees to deliver possession of the Property to Buyer on the Closing Date subject to the Permitted Encumbrances (as defined below) and the rights of tenants under the Leases in their capacity as tenants. a) Seller's Closing Obligations. On the Closing Date, Seller shall execute and deliver to Buyer the following items which (in the case of documents) are referred to as "Seller's Closing Documents ". Seller's Closing Documents shall be duly executed and, where appropriate, be in recordable form. i) Deed. A Limited Warranty Deed, in form reasonably satisfactory to Buyer, conveying the Real Property to Buyer, free and clear of all encumbrances, except the Permitted Encumbrances. Bill of Sale. A Warranty Bill of Sale, in form reasonably satisfactory to Buyer, conveying the Personal Property to Buyer, free and clear of all encumbrances. Assignment of Leases. An Assignment of Leases, in form reasonably satisfactory to Buyer, conveying the Leases and any existing security deposits, prepaid rents or collections and guarantees regarding the Leases to Buyer, free and clear of all encumbrances. iv) Assi mment of Contracts Permits Warranties Plans and Records. An Assignment of Contracts, Permits, Warranties, Plans, and Records, in a form reasonably satisfactory to Buyer, assigning the Contracts, Permits, Warranties, Plans, and Records to Buyer, free and clear of all encumbrances t1.us.8843595.06 arising by, through or under Seller, together with the consent of all parties having a required right to consent to such Assignment. V) Tenant Deposits Receivables and Transferred Accounts. Evidence that the balance in the Tenant Deposits, Receivables, and Transferred Accounts as of the Closing have been transferred to Buyer. vi) Revised and Certified Rent Roll. A revised Rent Roll, certified by Seller as accurate as of the Closing Date. vii) Notices to Tenants. Notices to the tenants under the Leases, dated and delivered as of the Closing Date, in form reasonably satisfactory to Buyer, advising them of the sale of the Real Property and directing them to make future lease payments to Buyer at the place designated by Buyer. viii) Title Policy. The Title Policy (defined below), or a suitably marked up Commitment for Title Insurance initialed by Title, in the form required by this Agreement. ix) Seller's Affidavit. A standard form Affidavit by Seller indicating that on the Closing Date there are no outstanding, unsatisfied judgments, tax liens, or bankruptcies against or involving Seller or the Real Property; that there has been no skill, labor, or material furnished to the Real Property for which payment has not been made or for which mechanics' liens could be filed; and that there are no unrecorded interests, other than as set forth in this Agreement, in the Real Property, together with whatever standard owner's affidavit or indemnity (ALTA form) that may be required by Title to issue an Owner's Policy of Title Insurance with the standard exceptions waived. X) Update Certificate. The Update Certificate, as defined in section 3.a) herein. xi) Certificate(s) of Occupancy. One or more final certificates of occupancy (to the extent the same were issued by the appropriate governmental body) authorizing the use of the Real Property for the Buyer's Intended Use. xii) Original Documents. Original copies of the Leases, the Contracts, the Permits, the Warranties, the Plans, and the Records. xiii) FIRPTA Affidavit. A nonforeign affidavit, properly executed and in recordable form, containing such information as is required by IRC § 1445(b)(2) and its regulations. xiv) Abstract of Title or Duplicate Certificates of Title. If in Seller's possession or reasonably available to Seller, the abstract(s) of title and duplicate certificates of title regarding the Real Property. 6 [b.us.8843595.06 5. xv) IRS Reporting Form. The appropriate federal income tax reporting form, if any is required. xvi) Other All other documents reasonably determined to be necessary to transfer the Property to Buyer free and clear of all encumbrances except for the Permitted Encumbrances or as requested by Title. xvii) Tenant Files. Copies of Seller's existing file with respect to each tenant with a lease at the Property in effect as of the Closing Date. xviii) Possession. Possession of the Property, free of possession by others except with respect to the interest of tenants under the Leases and as permitted in the Permitted Encumbrances. xix) Keys. All originals and copies of keys to the Property, possessed by Seller, its employees, agents or contractors. xx) Underground Tank Affidavit. A storage tank affidavit if required by Minn. Stat. § 116.48(6). xxi) Wells. A well disclosure if required by Minn. Stat. § 103I. xxii) Easement Agreement. The Easement Agreement, as defined in Section 17. b) B Closing Obligations. On the Closing Date, Buyer will execute and deliver to Seller the following, which (in the case of documents) are referred to as "Buyer's Closing Documents ". Buyer's Closing Documents shall be duly executed and, where appropriate, be in recordable form. i) Title Documents. Such affidavits of Buyer, Certificates of Value, or other documents as may be reasonably required by Title in order to record the Seller's Closing Documents, where appropriate, and issue the Title Policy required by this Agreement. ii) Easement Agreement. The Easement Agreement, as defined in Section 17. iii) Purchase Price. The balance of the Purchase Price. Costs and Prorations. Seller and Buyer agree to the following prorations and allocation of costs regarding this Agreement: a) Title Insurance Closing Fee Taxes and Recording Costs. Seller shall pay the cost of obtaining the title commitment. Buyer shall pay the cost of the premium for an owner's policy of title insurance (including any endorsements thereto) and any lender's policy of title insurance (including any endorsements thereto). Seller shall pay all State Deed Tax regarding the deed to be delivered by Seller to Buyer. Buyer shall pay all Mortgage Registry Tax payable in connection with Buyer's 7 lb.us.9943595.06 financing. Seller shall pay the cost of recording all documents necessary to place record title to the Property in Seller in the condition required pursuant to Section 6, with the exception that Buyer shall pay the cost of recording the deed to be delivered by Seller to Buyer,. Buyer and Seller shall each pay one half of any closing or escrow fee or charge imposed by any closing agent or by Title with respect to the transaction contemplated by this Agreement. b) Real Estate Taxes and Special Assessments. Real property taxes including without limitation any installments of special assessments (including interest) payable with general real estate taxes in the tax year in which the Closing Date occurs shall be adjusted and apportioned as of the Closing Date between Seller and Buyer based on the assumption that Seller has possession on the Closing Date. Seller shall pay in full all catch -up or other deferred taxes applicable to any of the Property and all special assessments levied and pending with respect to the Property as of the Closing Date. c) Basic Rents. All rent and other charges under the Leases will be prorated as of the Closing Date. If at the Closing Date a tenant under any of the Leases is delinquent in any rent payments or is in violation of any other term of the Lease, then Buyer shall be responsible for collecting the unpaid rent or enforcing the Lease violation. In that event, Buyer shall be entitled to retain any of the impaid rent that it collects in order to compensate Buyer for its collection costs. Buyer shall not be entitled to any other compensation from Seller related to unpaid rent collection or enforcement of the Leases. d) Additional Tenant Amounts. Seller shall transfer to Buyer at the Closing Date and without additional charge all security deposits and interest thereon (including such interest is required by law or agreement to be paid to tenants) and prepaid rents. e) Other Costs. All other operating costs of the Property, including, but not limited to, utility charges shall be allocated between Seller and Buyer as of the Closing Date, so that Seller pays that part of such other operating costs payable on or before the Closing Date and Buyer is responsible for the payment of such operating costs payable from and after the Closing Date. f) Attorneys' Fees. Each of the parties will pay its own attorneys' fees, except that a party defaulting under this Agreement or any closing document will pay the reasonable attorneys' fees, court costs, and any and all other costs incurred by the nondefaulting party to enforce its rights regarding such default. 6. Title. a) Condition of Title. Seller shall be required to convey fee title to the Property to Buyer, subject to no liens, easements, encumbrances, conditions, reservations, or restrictions other than the Permitted Encumbrances (as defined below). U. ib.us.8843595.06 b) Title Evidence. Buyer shall, within 60 days after the Effective Date, arrange for the following (collectively, "Title Evidence "): i) Title Insurance Commitment. Buyer shall, at Seller's cost and expense, obtain a commitment ( "Title Commitment") from Title for a current ALTA Owner's Policy of Title Insurance (2011) ("Title Policy ") in the amount of the Purchase Price, including legible copies of any plats and all documents set out in the Title Commitment as exceptions to title, insuring title to the Real Property and otherwise in the form required by this Agreement. Title must agree to delete standard exceptions and provide affirmative insurance regarding zoning, contiguity, and any appurtenant easements. The Title Conunitment will commit Title to insure title to the Property at regular and customary rates subject only to the Permitted Encumbrances. ii) Survey. Buyer shall, at Buyer's cost and expense, cause the Real Properly to be surveyed by a registered land surveyor properly licensed to practice in Minnesota and reasonably acceptable to Buyer. Seller hereby grants Buyer and Buyer's representatives or consultants access to the Real Property. Buyer shall provide Seller with a copy of the survey. iii) UCC Searches. Buyer shall, at Buyer's cost and expense, obtain a report of UCC searches made of the Uniform Commercial Code records at the State of Minnesota Secretary of State and Anoka County, Minnesota done by a search firm acceptable to Buyer showing no UCC filings regarding any of the Property. c) Buyer's Objections. Within 30 days after receiving the last of the Title Evidence, Buyer will make written objections ( "Objections ") to the form and contents of the Title Evidence. Buyer's failure to make Objections within such time period will constitute waiver of Objections, except that Buyer shall not be deemed by virtue of failure to so object to have waived any proper objection relating to any consensual lien on the Property. Any matter set forth on Exhibit C or shown on such Title Evidence and not objected to by Buyer (other than such liens) shall be a "Permitted Encumbrance" hereunder. Seller shall have 30 days after receipt of the Objections to cure the Objections, during which period the Closing will be postponed as necessary. Seller shall use its best efforts to correct any Objections. If the Objections are not cured within such 30 day period, Buyer's sole options will be to do the following: i) Terminate this Agreement and receive a refund of the Earnest Money and the interest accrued and unpaid on the Earnest Money, if airy; or ii) Waive the Objections and proceed to close. 7. Operation Prior to Closing. During the period from Effective Date to the Closing Date ( "Executory Period "), Seller shall operate and maintain the Property in the ordinary course 9 th.us.8843595.06 of business in accordance with prudent, reasonable business standards, including the maintenance of liability insurance and insurance against loss by fire, windstorm, and other hazards, casualties, and contingencies, in the forms and amounts in place on the Effective Date including vandalism and malicious mischief and continuing normal repair and maintenance. During the Executory Period, Seller may use reserves to make ordinary and necessary repairs and replacements to the Property. Seller shall extend its reasonable efforts to maintain or increase occupancy at the Property. However, Seller shall execute no contracts, leases (other than to tenants in the ordinary course of business), or other agreements regarding the Property during the Executory Period that do not terminate on or before the Closing Date, without the written consent of Buyer, which consent may be withheld by Buyer in its sole discretion. 8. Representations and Warranties by Seller. Seller represents and warrants to Buyer as follows: a) Authori . Seller has the requisite power and authority to enter into and perform this Agreement and those Seller's Closing Documents signed by it; such documents have been duly authorized by all necessary action on the part of Seller and have been duly executed and delivered; such execution, delivery and performance by Seller of such documents does not conflict with or result in a violation of any judgment, order, or decree of any court or arbiter or any other agreements of any nature to which Seller is a party; such documents are valid and binding obligations of Seller, and are enforceable in accordance with their terms. b) Title to Real Property. Seller owns the Real Property, flee and clear of all encumbrances, except the Permitted Encumbrances. c) Title to Personal Property. Seller owns the Personal Property, free and clear of all encumbrances arising by, through, or under Seller. d) Leases. Seller has made or will make available to Buyer a correct and complete copy of each Lease and all its amendments. The information regarding the Leases contained in the Rent Roll, including but not limited to, the number and types of rental units, is correct and complete in all material respects as of the Effective Date. The Leases are in full force and neither Seller nor any tenant is in monetary or material nomuonetary default under the Leases, except as disclosed on the Rent Roll. With the exception of the Cellular Antenna Lease, defined in Section 17 of this Agreement, there are no other leases or possessory rights of others regarding the Real Property. Seller will not amend, modify, or terminate the Leases without the prior written consent of Buyer, except in the ordinary course of business. Alt security deposits are fully funded as to the principal amount and any interest due on such deposits in accordance with applicable law. e) Contracts. Seller has made or will make available to Buyer a correct and complete copy of each service and maintenance contract, equipment lease, and other contract relating to the Property and its amendments. These contracts are in fall force and 10 thus.8843595.06 neither Seller, nor to Seller's knowledge, any other party to those contracts, is in monetary or material nonmonetary default under the contracts. Seller will not amend, modify, or terminate those contracts without the prior written consent of Buyer. f) Permits. Seller has made or will make available to Buyer a correct and complete copy of each Permit and its amendments. The Permits are in full force, and Seller is not in default under the Permits. To the best of Seller's knowledge, no other permits are required from any governmental entity in order to operate the Property as it is now operated. g) Utilities. Seller has received no oral or written notice of actual or threatened reduction or curtailment of any utility service now supplied to the Real Property, which is serviced to the boundary line by public water and sewer and all necessary utilities in order to support Buyer's Intended Use. The utility services and HVAC systems serving the Real Property are contained entirely on the Real Property or by means of property owned or controlled by the utility provider. h) Roads. The Real Property has free, full, legal, valid, and perpetual access to and from all adjoining streets, roads, and highways, including specifically at the existing curb cuts or access points, and Seller has received no notice of, and has no knowledge of, any pending or threatened action which would impair such access. i) Certificates of Occupancy. Seller has been issued all certificates of occupancy required under applicable law with respect to the Improvements, and such certificates remain in full force and effect and are displayed at the Real Property in compliance with applicable law. Seller has received no oral or written notice of actual or threatened cancellation or suspension of any certificates of occupancy for any portion of the Real Property. j) Public Improvements. Seller has received no oral or written notice of plans to make public improvements which would be assessed against the Property. k) Environmental Laws. To the best of Seller's knowledge, Seller has operated the Real Property in compliance with all applicable federal, state, and local enviromnental laws, ordinances, rules and regulations, relating to the handling, storage and disposal of hazardous and toxic wastes and substances, petroleum products and other regulated substances. To the best of Seller's knowledge, no other party has engaged in any such use, storage, discharge, or release on the Real Property during the time that Seller has owned the Real Property. 1) Rights of Others to Purchase Property. Seller has not entered into any other contracts for the sale of the Property, nor are there any rights of first refusal or options to purchase the Property or any other rights of others that might prevent the consummation of this Agreement. 11 n,.tis.8843595.06 in) Seller's Defaults. Seller is not in monetary or material nomnonetary default concerning any of its obligations or liabilities regarding the Property. n) Operating Statements. The Operating Statements are correct and complete in all material respects and have been prepared in accordance with generally accepted accounting standards. o) FIKPTA. Seller is not a "foreign person, „"foreign partnership,” "foreign trust,' or "foreign state" as those terms are defined in § 1445 of the Internal Revenue Code. P) Proceedings. To the best of Seller's knowledge, there is no action, litigation, investigation, condemnation, or proceeding of any kind pending or threatened against Seller or any portion of the Property. To the best of Seller's knowledge, there are no applications, ordinances, petitions, resolutions, or other matters pending before any governmental agency which would adversely affect use of the Property as residential housing. To the best of Seller's knowledge, there are no environmental proceedings, applications, ordinances, petitions, court pleadings, resolutions, investigations by public or private agencies, or other matters pending which could prohibit, impede, delay, or adversely affect Buyer's Intended Use of the Property. To Seller's knowledge, there are no applications, ordinances, petitions, resolutions, or other matters pending before any governmental agency in regard to access routes, curb cuts, median strips, or other contemplated actions of public agencies which might tend to diminish or curtail the flow of traffic by the Property and access thereto. q) Agents and Employees. No management agents or other persomlel employed in connection with the operation of the Property have the right to continue such employment after the Closing Date. Buyer shall not have any obligations with respect to such agents or employees. There are no claims for brokerage commission or other payments with respect to the existing Property, including lease commissions, that will survive and remain unpaid after the Closing Date. r) Separate Tax Parcel. The Land constitutes a separate parcel of record for real estate tax assessment and conveyancing purposes, and complies with applicable law governing the platting and subdivision of real property. S) Condition of hnprovements and Personal Property. All parking and other Improvements required for or currently used in the operation of the Property are located on the Land. The Improvements are structurally sound. All mechanical, electrical, heating, air conditioning, drainage, sewer, water, telephone, conur unications, plumbing, and other facilities or utility systems of the Improvements are in working order. The Personal Property are in working order and good repair. t) Private Restrictions. There are no private restrictions affecting the uses that may be made of the Property that will not appear in the Title Commitment, including, but 12 lb.us.8843595.06 not limited to: size or cost of buildings or structures, limitations on use or restrictions in regard to fences, roofs, garages, and heights of buildings or structures; agreements to submit architectural plans to an association or other group; provisions requiring improvements; or provisions requiring the joining with others in group actions. u) Taxes. Seller shall not withdraw, settle, or otherwise compromise any tax protest or tax reduction proceeding affecting real estate taxes or special assessments against the Property for any fiscal period in which the Closing is to occur or any subsequent fiscal period without the prior written consent of Buyer. Real estate tax refunds and credits received after the date of Closing which are attributable to the fiscal tax year during daily basis s ohf the Closing Date,lafter deducting the between xpenses of collection Buyer thereof. V) v) Wells Storage Tanks. There are no wells or storage tanks located on the Property. W) Leal Action. Seller shall deliver to Buyer a written notice of the commencement of any legal action by any governmental authority or third party affecting the Property and will make no concessions or settlements with respect to any such action which would have a future continuing impact on the Property without Buyer's prior written consent. X) Violations. Seller shall cure all violations of law or municipal ordinances, orders or requirements affecting the Property, notices of which may be issued prior to the Closing Date by any state or municipal agency or department having jurisdiction over all or any part of the Property. n -Site Sewa,e Treatment System. [Check one of the y) Disclosure of Individual O following:] ❑x Seller certifies that Seller does not know of any individual on -site sewage treatment systems on the property. ❑ Individual on -site sewage treatment systems on the property are disclosed by Seller on the attached Disclosure form. z) Metham_ ph_ 1_ etamine• To the best of Seller's luiowledge, methamphetamine production has not occurred on the Property. Seller will indemnify Buyer, its successors and assigns against, and will hold Buyer, its successors and assigns harmless from, any expenses or damages, including reasonable attorneys' fees, that Buyer incurs because of the breach of any of the above representations and warranties, whether such breach is discovered before or after Closing. Each of the representations and warranties herein contained shall survive until 12 months after the Closing Date. Buyer must commence any action based on any breach of the representations or warranties on or before the first day of the eleventh month after the Closing Date. 13 (b.us.8843595.06 9. Representations and Warranties by Buyer. Buyer represents and warrants to Seller that Buyer has the requisite power and authority to enter into this Agreement and Buyer's Closing Documents signed by it; that such documents have been duly authorized by all necessary action on the part of Buyer and have been duly executed and delivered; that the execution, delivery, and performance by Buyer of such documents do not conflict with or result in violation of any judgment, order, or decree of any court or arbiter to which Buyer is a party; and that such documents are valid and binding obligations of Buyer, and are enforceable in accordance with their terms. Buyer will indemnify Seller, its successors and assigns against, and will hold Seller, its successors and assigns harmless from, any expenses or damages, including reasonable attorneys' fees, that Seller incurs because of the breach of any of the above representations and warranties, whether such breach is discovered before or after Closing. Each of the representations and warranties herein contained shall survive until 12 months after the Closing Date and Seller must commence any action based on any breach of the representations or warranties on or before the first day of the eleventh month after the Closing Date. 10. Name of Building. Seller agrees that it will relinquish and transfer to Buyer on the Closing Date, all rights to designate the name of the buildings located on the Real Property and agrees that Buyer shall have the right to continue the use of the present name. 11. Damage. If, prior to the Closing Date, all or any part of the Property is "substantially damaged" by fire, casualty, the elements, or any other cause, Seller shall innnediately give notice to Buyer of such fact and at Buyer's option (to be exercised within 30 days after Seller's notice), this Agreement shall terminate, in which event neither party will have any further obligations under this Agreement and the Earnest Money, together with any accrued interest, shall be refunded to Buyer. If Buyer fails to elect to terminate despite such damage, or if the Property is damaged but not "substantially damaged," Seller shall promptly commence to repair such damage or destruction and return the Property to its condition prior to such damage. If such damage is completely repaired prior to the Closing Date, then there shall be no reduction in the Purchase Price and Seller shall retain the proceeds of all insurance related to such damage. If such damage is not completely repaired prior to the Closing Date but Seller is diligently proceeding to repair, then Seller shall complete the repair after the Closing Date and shall be entitled to receive the proceeds of all insurance related to such damage after repair is completed; provided, however, Buyer shall have the right to delay the Closing Date until repair is completed. If Seller shall fail to diligently proceed to repair such damage, then Buyer shall have the right to require a closing to occur and the Purchase Price (and specifically the cash portion payable at the Closing Date) shall be reduced by the cost of such repair, or at Buyer's option, the Seller shall assign to Buyer all right to receive the proceeds of all insurance related to such damage plus the amount of any deductible which shall be paid by Seller and the Purchase Price shall remain the same. For purposes of this Section, the words "substantially damaged" mean damage that would cost $500,000.00 or more to repair. 12. Condemnation. If, prior to the Closing Date, eminent domain proceedings are commenced against all or any "substantial portion" of the Property, Seller shall immediately give notice to Buyer of such fact and at Buyer's option (to be exercised within 30 days after Seller's 14 N.us.8843595.0e notice), this Agreement shall terminate, in which event neither party will have further obligations under this Agreement and the Earnest Money, together with any accrued interest, shall be refunded to Buyer. If Buyer does not give such notice within 30 days, then there shall be no reduction in the Purchase Price, and Seller shall assign to Buyer at the Closing Date all of Seller's right, title, and interest in and to any award made or to be made in the condenmation proceedings. Prior to the Closing Date, Seller shall not designate counsel, appear in, or otherwise act with respect to the condemnation proceedings without Buyer's prior written consent, which consent shall not be delayed or withheld unreasonably. If less than a "substantial portion" of the Property is condemned, the Closing shall proceed and the Seller shall assign to Buyer at the Closing Date all of Seller's right, title, and interest in and to any award made or to be made in the condemnation proceeding. For purposes of this Section, the term "substantial portion" means condemnation proceedings involving 10 percent of either the value or square footage of the Property. 13. Broker's Commission. Seller and Buyer represent and warrant to each other that they have dealt with no brokers, finders, or the like in connection with this Agreement. Seller and Buyer agree to indemnify each other and to hold each other harmless against all claims, damages, costs, or expenses of or for any other such fees or commissions resulting from their actions or agreements regarding the execution or performance of this Agreement, and will pay all costs of defending any action or lawsuit brought to recover any such fees or commissions incurred by the other party, including reasonable attorneys' fees. 14. Assignment. mited partnership that has tBuyer or an affiliate of Buyer as general partnegoreto another its sole discretion assign its entity managed by Buyer. 15. Survival. Except as otherwise set forth herein, all of the terms of this Agreement will survive and be enforceable after the Closing and delivery of the deed to be delivered by Seller to Buyer, provided that any action by either party for breach of this Agreement or for any other claim related to this Agreement must be commenced on or before 12 months after the Closing. 16. Notices. Any notice required or permitted to be given by any party to the other shall be given in writing, and shall be (i) delivered to the receiving party (or any officer of such party), or (ii) mailed in a sealed wrapper by United States registered or certified mail, return receipt requested, postage prepaid, or (iii) properly deposited with a nationally recognized, reputable overnight courier, properly addressed as follows: If to Seller: City of Columbia Heights Housing and Redevelopment Authority Attn: Scott Clark 590 40`x' Avenue Northeast Columba Heights, MN 55421 Phone: (763) 706 -3600 Fax: (763) 706 -3601 15 m.us.8843595.06 If to Buyer: Aeon Attn: James Lelmhoff 901 North 3"" Street; Suite 150 Minneapolis, MN 55401 Phone: (612) 746 -0522 Fax: (612) 341 -4208 Notices shall be deemed effective on the earlier of the date of receipt or in the case of such deposit in the mail or overnight courier, on the third business day following such deposit. Any party may change its address for the service of notice by giving written notice of such change to the other party, in any manner above specified, at least 10 days prior to the effective date of such change. 17. Cellular Antenna Lease. The Columbia Heights Economic Development Authority has entered into a Site Lease Agreement with APT Minneapolis, Incorporated ( "APT ") dated December 4, 1996 (hereafter, the "Cellular Antenna Lease "). The Cellular Antenna Lease allows APT to place cell phone antennas and appurtenances on the roof of the Parkview Villa North building. At Closing, Seller and Buyer will enter into an Easement Agreement in the form attached hereto as Exhibit E (the " Ei asement Agreement ") granting Seller an easement over the premises leased to APT under the Cellular Antenna Lease, and pursuant to which Seller will be permitted to continue to lease the roof space to APT for the placement of cell phone antennas and appurtenances in accordance with the Cellular Antenna Lease. The Cellular Antenna Lease is scheduled to expire on December 31, 2016, but may be extended by Seller for a period of up to 7 additional years, provided any such extension agreement, amendment, assignment or other agreement affecting the Cellular Antenna Lease shall be subject to Buyer's approval, which shall not be unreasonable withheld. LEASEMENT AGREEMENT TO BE DRAFTED AND ATTACHED; EASEMENT AGREEMENT TO TERMINATE UPON THE TERMINATION OF THE CELLULAR ANTENNA LEASE, AS EXTENDED, IF AT ALL. 18. Restrictions. The following restrictions shall apply to the Property and shall survive the Closing: a. Until satisfaction in full of the Seller Loan, all occupants of the Parkview Villa South building must be 55 years of age or older. b. For a period of one year after the Closing, the amount of rent charged to existing tenants of the Parkview Villa South building must remain at the same amount as it is as of the Closing Date. After the date that is one year after the Closing and until satisfaction in full of the Seller Loan, Buyer may increase rent to the extent necessary to ensure stable building operations, as determined by Buyer in its sole discretion. After the satisfaction in full of the Seller Loan, Buyer shall be subject to no limitation on its ability to increase rent hereunder. C. Until satisfaction in full of the Seller Loan, no unit may be rented to a person who is not a current resident of the City of Columbia Heights unless at the time of rental, there are no current City of Columbia Heights residents who are interested and eligible. The foregoing restriction shall not apply to the extent it does not conform 16 fl m is.8843595.06 to fair housing laws, regulations and other such restrictions, and shall not apply to the extent such restriction negatively interferes with Buyer's funding approvals, as determined by Buyer in its sole discretion. 19. Captions. The paragraph headings or captions appearing in this Agreement are for convenience only, are not a part of this Agreement and are not to be considered in interpreting this Agreement. 20. Entire Agreement. This written Agreement constitutes the complete agreement between the parties and supersedes any and all other oral or written agreements, negotiations, understandings, and representations between the parties regarding the Property. There are no verbal or written side agreements that change this Agreement. 21. Amendment; Waiver. No amendment of this Agreement, and no waiver of any provision of this Agreement, shall be effective unless set forth in a writing expressing the intent to so amend or waive, and the exact nature of such amendment or waiver, and signed by all parties (in the case of amendment) or the waiving party (in the case of waiver). No waiver of a right in any one instance shall operate as a waiver of any other right, nor as a waiver of such right in a later or separate instance. 22. Binding Effect. This Agreement binds and benefits the parties and their successors and assigns. 23. Controlling Law. This Agreement has been made under the laws of the State of Minnesota, and such laws will control its interpretation and effect. 24. Remedies. If Buyer defaults under this Agreement, Seller shall have the right to terminate this Agreement by giving written notice to Buyer in the manner provided by law (except that the notice period shall in no event be less than 30 days). If Buyer fails to cure such default within 30 days of the date of such notice (or such longer period as is reasonable given the nature of the default, so long as Buyer is proceeding to cure the default diligently and in good faith), this Agreement will terminate and upon such termination, Seller will retain the Earnest Money as liquidated danlages. The termination of this Agreement and retention of Earnest Money will be the sole remedy available to Seller for such default by Buyer, and Buyer will not be liable for damages or specific performance. If Seller defaults under this Agreement, Buyer's sole options are to either bring an action for specific performance or to terminate this Agreement. 25. Counterparts. For the convenience of the parties, any number of counterparts hereof may be executed and each such executed counterpart shall be deemed an original, but all such counterparts together shall constitute one in the same Agreement. 26. Exhibits. All Exhibits referred to in this Agreement are attached to and shall be considered a part of this Agreement. [Signature Page Follows] 17 fb.us.9943595.06 SIGNATURE PAGE TO PURCHASE AGREEMENT Seller and Buyer have executed this Agreement as of the date first written above. SELLER Date of Signature: CITY OF COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY .2012 By: Name: Its: By: Name: Its: I R 1114 Di Date of Signature: AEON 2012 By: Alan Arthur, President and CEO 18 tb.us.8843595.06 FIRST AMENDMENT TO PURCHASE AGREEMENT This First Amendment to Purchase Agreement (the "First Amendment "), has been made and entered into effective as of this day of April, 2014, by and between the City of Columbia Heights Housing and Redevelopment Authority, a Minnesota political subdivision ( "Seller ") and AEON, a Minnesota non - profit corporation (`Buyer "). RECITALS WHEREAS, Seller and Buyer are parties to that certain Purchase Agreement, dated , 2012 (the "Purchase Agreement "); and WHEREAS, Seller and Buyer do hereby wish to amend the Purchase Agreement, all as hereinafter set forth. AGREEMENT NOW, THEREFORE, in consideration of the premises and for other good and valuable consideration, the receipt and sufficiency of which is hereby acknowledged, the parties hereto do hereby agree as follows: The first sentence of the second paragraph of Section 3(k) of the Purchase Agreement is hereby amended to read as follows: The "Contigeney Date" shall be April 30, 2015. 2. Section 4 of the Purchase Agreement is hereby amended to read as follows: The consummation of the purchase and sale transaction contemplated by this Agreement ( "Closing ") shall occur on a date selected by Buyer ( "Closing Date "), upon no less than 10 days prior written notice to Seller, on or before April 30, 2015. The Closing shall take place at 10:00 a.m. local time at the office of Commonwealth Land Title Insurance Company ( "Title "), located at 7701 France Avenue South, Suite 120, Edina, Minnesota or at such other time and place as may be agreed to by the parties. Seller agrees to deliver possession of the Property to Buyer on the Closing Date subject to the Permitted Encumbrances (as defined below) and the rights of tenants under the Leases in their capacity as tenants. Except with regard to the amendment set forth above, all other provisions of the Purchase Agreement shall remain unchanged. IN WITNESS WHEREOF, Seller and Buyer have caused this First Amendment to be signed and executed on their behalf as of the day and year first written above. Date of Signature: Date of Signature: SELLER CITY OF COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY 2014 By: Name: Its: By: Name: Its: BUYER AEON By: Name: Its: 2014