3.2. HRSR 08-28-2000 BALANCE SHEET
`" JUNE 30, 2000 Date: 07/06/00
Time: 10:47am
City of Elk River Page: 1
As of: 06/30/00 Balance
. 910 HRA
Assets
CURRENT ASSETS
1010 Cash 114,209.22
CURRENT ASSETS 114,209.22
Total Assets 114,209.22
Liabilities
CURRENT LIABILITIES
2070 Due To Other Funds 105,379.70
CURRENT LIABILITIES 105,379.70
Total Liabilities 105,379.70
Reserves/Balances
FUND EQUITY
2400 Fund Balance -150,971.53
2600 Change In Fund Balance 159,801.05
FUND EQUITY 8,829.52
Total Reserves/Balances 8,829.52
•
Total Liabilities & Balances 114,209.22
•
REVENUE/EXPENDITURE REPORT
JUNE 30, 2000 Date: 07/06/00
Time: 10:53am
Ci'Ey of Elk River Page: 1
For the Period: 06/01/00 to 06/30/00 Original Budget Amended Budget YTD Actual CURR MTH Encumbered YTD Unenc. Balance t Bud
Fund: 910 HRA
�
R es
rrent Ad Valorem Taxes 92,400.00 92,400.00 0.00 0.00 0.00 92,400.00 0.0
TAXES 92,400.00 92,400.00 0.00 0.00 0.00 92,400.00 0.0
INTERGOVERNMENTAL REVENUE
3322 Homestead Credit 5,600.00 5,600.00 0.00 0.00 0.00 5,600.00 0.0
INTERGOVERNMENTAL REVENUE 5,600.00 5,600.00 0.00 0.00 0.00 5,600.00 0.0
OTHER REVENUE
3621 Interest Income 2,000.00 2,000.00 2,138.37 0.00 0.00 -138.37 106.9
3910 Sale of Fixed Assets 0.00 0.00 175,000.00 0.00 0.00 -175,000.00 0.0
OTHER REVENUE 2,000.00 2,000.00 177,138.37 0.00 0.00 -175,138.37 -***.*
Revenues 100,000.00 100,000.00 177,138.37 0.00 0.00 -77,138.37 177.1
Sivenditures
Dept: 610.610 HOUSING & REDEVELOPMENT
PERSONAL SERVICES
4101 Regular Pay 16,350.00 16,350.00 4,151.30 1,580.65 0.00 12,198.70 25.4
4104 PERA 850.00 850.00 202.65 81.88 0.00 647.35 23.8
4105 PICA 1,050.00 1,050.00 265.52 81.68 0.00 784.48 25.3
4107 Medicare 250.00 250.00 61.99 19.04 0.00 188.01 24.8
4108 Insurance 1,400.00 1,400.00 446.24 193.50 0.00 953.76 31.9
4109 Workers Comp 0.00 0.00 6.73 16.38 0.00 -6.73 0.0
PERSONAL SERVICES 19,900.00 19,900.00 5,134.43 1,973.13 0.00 14,765.57 25.8
OTHER SERVICES & CHARGES
4304 Legal Fees 0.00 0.00 1,301.25 67.50 0.00 -1,301.25 0.0
4319 Other Professional Services 10,000.00 10,000.00 1,010.50 0.00 0.00 8,989.50 10.1
4322 Postage 0.00 0.00 4.50 0.00 0.00 -4.50 0.0
4349 Advertising/Marketing 2,000.00 2,000.00 21.22 0.00 0.00 1,978.78 1.1
4359 Publishing 0.00 0.00 119.06 29.47 0.00 -119.06 0.0
4361 Insurance 200.00 200.00 190.00 0.00 0.00 10.00 95.0
4440 Miscellaneous 0.00 0.00 9,556.36 9,481.44 0.00 -9,556.36 0.0
OTHER SERVICES & CHARGES 12,200.00 12,200.00 12,202.89 9,578.41 0.00 -2.89 100.0
0OUTLAY
nd 68,500.00 68,500.00 0.00 0.00 0.00 68,500.00 0.0
CAPITAL OUTLAY 68,500.00 68,500.00 0.00 0.00 0.00 68,500.00 0.0
TRANSFERS OUT
4721 Transfer-General Fund 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0
4735 Transfer-EDA 6,300.00 6,300.00 0.00 0.00 0.00 6,300.00 0.0
TRANSFERS OUT 7,300.00 7,300.00 0.00 0.00 0.00 7,300.00 0.0
HOUSING & REDEVELOPMENT 107,900.00 107,900.00 17,337.32 11,551.54 0.00 90,562.68 16.1
Expenditures 107,900.00 107,900.00 17,337.32 11,551.54 0.00 90,562.68 16.1
Net Effect for HRA -7,900.00 -7,900.00 159,801.05 -11,551.54 0.00 -167,701.05 -***.*
Change in Fund Balance: 159,801.05
II
EXPENDITURE DETAIL REPORT
YTD JUNE 30, 2000 Date: 07/06/00
Time: 10:55am
City of Elk River Page: 1
For the Period: 01/01/00 to 06/30/00 Original Budget Amended Budget YTD Actual YTD Actual Encumbered YTD Unenc. Balance t Bud
Fund: 910 HRA
E
itures
lt: 610.610 HOUSING & REDEVELOPMENT
SERVICES
410 Regular Pay
01/01/2000 RE EDA/HRA PAYABLE -570.05
02/14/2000 AP ELK RIVER/CITY OF// JANUARY REIMBURSEMENT 1,157.20 INV#: VENDOR#: 1744 9213
03/13/2000 AP ELK RIVER/CITY OF// FEBRUARY REIMBURSEMENT 1,983.50 INV#: VENDOR#: 1744 9798
06/26/2000 AP ELK RIVER/CITY OF// MARCH-MAY REIMBURSEMENT 1,580.65 INV#: VENDOR#: 1744 11428
Regular Pay 16,350.00 16,350.00 4,151.30 4,151.30 0.00 12,198.70 25.4
4104 PERA
02/14/2000 AP ELK RIVER/CITY OF// JANUARY REIMBURSEMENT 59.94 INV#: VENDOR#: 1744 9213
03/13/2000 AP ELK RIVER/CITY OF// FEBRUARY REIMBURSEMENT 60.83 INV#: VENDORS: 1744 9798
06/26/2000 AP ELK RIVER/CITY OF// MARCH-MAY REIMBURSEMENT 81.88 INV#: VENDORS: 1744 11428
PERA 850.00 850.00 202.65 202.65 0.00 647.35 23.8
4105 PICA
02/14/2000 AP ELK RIVER/CITY OF// JANUARY REIMBURSEMENT 66.31 INV#: VENDORS: 1744 9213
03/13/2000 AP ELK RIVER/CITY OF// FEBRUARY REIMBURSEMENT 117.53 INV#: VENDORS: 1744 9798
06/26/2000 AP ELK RIVER/CITY OF// MARCH-MAY REIMBURSEMENT 81.68 INV#: VENDOR#: 1744 11428
FICA 1,050.00 1,050.00 265.52 265.52 0.00 784.48 25.3
4107 Medicare
02/14/2000 AP ELK RIVER/CITY OF// JANUARY REIMBURSEMENT 15.49 INV#: VENDORS: 1744 9213
03/13/2000 AP ELK RIVER/CITY OF// FEBRUARY REIMBURSEMENT 27.46 INV#: VENDORS: 1744 9798
06/26/2000 AP ELK RIVER/CITY OF// MARCH-MAY REIMBURSEMENT 19.04 INV#: VENDORS: 1744 11428
Medicare 250.00 250.00 61.99 61.99 0.00 188.01 24.8
4108 Insurance
02/14/2000 AP ELK RIVER/CITY OF// JANUARY REIMBURSEMENT 126.72 INV#: VENDORS: 1744 9213
03/13/2000 AP ELK RIVER/CITY OF// FEBRUARY REIMBURSEMENT 126.02 INV#: VENDORS: 1744 9798
06/26/2000 AP ELK RIVER/CITY OF// MARCH-MAY REIMBURSEMENT 193.50 INV#: VENDORS: 1744 11428
Insurance 1,400.00 1,400.00 446.24 446.24 0.00 953.76 31.9
4109 Workers Comp
01/01/2000 RE EDA/HRA PAYABLE 16.60
03/13/2000 AP ELK RIVER/CITY OF// FEBRUARY REIMBURSEMENT -26.25 INV#: VENDORS: 1744 9798
06/26/2000 AP ELK RIVER/CITY OF// MARCH-MAY REIMBURSEMENT 16.38 INV#: VENDOR#: 1744 11428
• Workers Comp 0.00 0.00 6.73 6.73 0.00 -6.73 0.0
PERSONAL SERVICES 19,900.00 19,900.00 5,134.43 5,134.43 0.00 14,765.57 25.8
OTHER SERVICES & CHARGES
4304 Legal Fees
04/24/2000 AP GRAY,PLANT,MOOTY,MOOTY,BENNETT LEGAL FEES-KING/MAIN PROJECT 693.75 INV#: 237285 VENDORS: 2036 10437
05/08/2000 AP GRAY,PLANT,MOOTY,MOOTY,BENNETT LEGAL FEES 540.00 INV#: VENDORS: 2036 10672
06/12/2000 AP GRAY,PLANT,MOOTY,MOOTY,BENNETT LEGAL SERVICES 67.50 INV#: VENDORS: 2036 11204
Legal Fees 0.00 0.00 1,301.25 1,301.25 0.00 -1,301.25 0.0
4319 Other Professional Services
05/19/2000 CR Ref ID: CLOSING COSTS-KING/MAIN Rcd From: FIRST NATIONAL BANK 1,010.50 Receipt Type: MISC 136708
Other Professional Services 10,000.00 10,000.00 1,010.50 1,010.50 0.00 8,989.50 10.1
4322 Postage
03/06/2000 AP UNITED STATES POSTAL SERVICE POSTAGE FOR METER 4.50 INV#: VENDORS: 3533 9714
Postage 0.00 0.00 4.50 4.50 0.00 -4.50 0.0
4349 Advertising/Marketing
02/14/2000 AP E C M PUBLISHERS INC LEGAL NOTICES 21.22 INV#: VENDORS: 1700 9393
Advertising/Marketing 2,000.00 2,000.00 21.22 21.22 0.00 1,978.78 1.1
4359 Publishing
05/22/2000 AP E C M PUBLISHERS INC LEGAL ADV 89.59 INV#: VENDORS: 1700 10881
06/12/2000 AP E C M PUBLISHERS INC LEGAL NOTICE 29.47 INV#: VENDORS: 1700 11143
Publishing 0.00 0.00 119.06 119.06 0.00 -119.06 0.0
4361 Insurance
01/31/2000 AP BREHM GROUP INC/THE// PERSONAL ACCIDENT INS POLICY 51.00 INV#: VENDORS: 1245 9144
05/22/2000 AP LEAGUE OF MN CITIES-INS TRUST OPEN MEETING LAW-INSURANCE 139.00 INV#: VENDORS: 2383 10947
Insurance 200.00 200.00 190.00 190.00 0.00 10.00 95.0
4440 Miscellaneous
14/2000 AP CUB FOODSlillir
BOXED LUNCHES 74.92 INV#: VENDORS: 1555 9386
/2000 AP ELK RIVER/CITY OF// KING & MAIN LAND 9,481.44 INV#:
VENDORS: 1744 11429
Miscellaneous 0.00 0.00 9,556.36 9,556.36 0.00 -9,556.36 0.0
OTHER SERVICES & CHARGES 12,200.00 12,200.00 12,202.89 12,202.89 0.00 -2.89 100.0
CAPITAL OUTLAY
EXPENDITURE DETAIL REPORT
YTD JUNE 30, 2000 Date: 07/06/00
Time: 10:55am
City of Elk River Page: 2
For the Period: 01/01/00 to 06/30/00 Original Budget Amended Budget YTD Actual YTD Actual Encumbered YTD Unenc. Balance % Bud
Fund: 910 HRA
4E ditures
t: 610.610 HOUSING & REDEVELOPMENT
OUTLAY
45 Land
Land 68,500.00 68,500.00 0.00 0.00 0.00 68,500.00 0.0
CAPITAL OUTLAY 68,500.00 68,500.00 0.00 0.00 0.00 68,500.00 0.0
TRANSFERS OUT
4721 Transfer-General Fund
Transfer-General Fund 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0
4735 Transfer-EDA
Transfer-EDA 6,300.00 6,300.00 0.00 0.00 0.00 6,300.00 0.0
TRANSFERS OUT 7,300.00 7,300.00 0.00 0.00 0.00 7,300.00 0.0
HOUSING & REDEVELOPMENT 107,900.00 107,900.00 17,337.32 17,337.32 0.00 90,562.68 16.1
Expenditures 107,900.00 107,900.00 17,337.32 17,337.32 0.00 90,562.68 16.1
Net Effect for HRA 107,900.00 107,900.00 17,337.32 17,337.32 0.00 90,562.68 16.1
Grand Total Net Effect: 107,900.00 107,900.00 17,337.32 17,337.32 0.00 90,562.68 16.1
i
BALANCE SHEET
JULY 31, 2000 Date: 08/01/00
E Time: 2:44pm
City Of Elk River Page: 1
As of: 07/31/00 Balance
ssets
CURRENT ASSETS
1010 Cash 166,140.96
CURRENT ASSETS 166,140.96
Total Assets 166,140.96
Liabilities
CURRENT LIABILITIES
2070 Due To Other Funds 105,379.70
CURRENT LIABILITIES 105,379.70
Total Liabilities 105,379.70
Reserves/Balances
FUND EQUITY
2400 Fund Balance -150,971.53
2600 Change In Fund Balance 211,732.79
FUND EQUITY 60,761.26
Total Reserves/Balances 60,761.26
1111
Total Liabilities & Balances 166,140.96
•
REVENUE/EXPENDITURE REPORT
JULY 31, 2000 Date: 08/01/00
Time: 2:42pm
CZy of Elk River Page: 1
For the Period: 07/01/00 to 07/31/00 Original Budget Amended Budget YTD Actual CURB MTH Encumbered YTD Unenc. Balance 4 Bud
Fund: 910 HRA
rrent Ad Valorem Taxes 92,400.00 92,400.00 48,079.42 48,079.42 0.00 44,320.58 52.0
TAXES 92,400.00 92,400.00 48,079.42 48,079.42 0.00 44,320.58 52.0
INTERGOVERNMENTAL REVENUE
3322 Homestead Credit 5,600.00 5,600.00 2,807.00 2,807.00 0.00 2,793.00 50.1
INTERGOVERNMENTAL REVENUE 5,600.00 5,600.00 2,807.00 2,807.00 0.00 2,793.00 50.1
OTHER REVENUE
3621 Interest Income 2,000.00 2,000.00 3,183.69 0.00 0.00 -1,183.69 159.2
3910 Sale of Fixed Assets 0.00 0.00 175,000.00 0.00 0.00 -175,000.00 0.0
OTHER REVENUE 2,000.00 2,000.00 178,183.69 0.00 0.00 -176,183.69 -***.*
Revenues 100,000.00 100,000.00 229,070.11 50,886.42 0.00 -129,070.11 229.1
1111.4116/$4010
Dept: 610.610 HOUSING & REDEVELOPMENT
PERSONAL SERVICES
4101 Regular Pay 16,350.00 16,350.00 4,151.30 0.00 0.00 12,198.70 25.4
4104 PERA 850.00 850.00 202.65 0.00 0.00 647.35 23.8
4105 FICA 1,050.00 1,050.00 265.52 0.00 0.00 784.48 25.3
4107 Medicare 250.00 250.00 61.99 0.00 0.00 188.01 24.8
4108 Insurance 1,400.00 1,400.00 446.24 0.00 0.00 953.76 31.9
4109 Workers Comp 0.00 0.00 6.73 0.00 0.00 -6.73 0.0
PERSONAL SERVICES 19,900.00 19,900.00 5,134.43 0.00 0.00 14,765.57 25.8
OTHER SERVICES & CHARGES
4304 Legal Fees 0.00 0.00 1,301.25 0.00 0.00 -1,301.25 0.0
4319 Other Professional Services 10,000.00 10,000.00 1,010.50 0.00 0.00 - 8,989.50 10.1
4322 Postage 0.00 0.00 4.50 0.00 0.00 -4.50 0.0
4349 Advertising/Marketing 2,000.00 2,000.00 21.22 0.00 0.00 1,978.78 1.1
4359 Publishing 0.00 0.00 119.06 0.00 0.00 -119.06 0.0
4361 Insurance 200.00 200.00 190.00 0.00 0.00 10.00 95.0
4440 Miscellaneous 0.00 0.00 9,556.36 0.00 0.00 -9,556.36 0.0
OTHER SERVICES & CHARGES 12,200.00 12,200.00 12,202.89 0.00 0.00 -2.89 100.0
ivOUTLAY
nd 68,500.00 68,500.00 0.00 0.00 0.00 68,500.00 0.0
CAPITAL OUTLAY 68,500.00 68,500.00 0.00 0.00 0.00 68,500.00 0.0
TRANSFERS OUT
4721 Transfer-General Fund 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0
4735 Transfer-EDA 6,300.00 6,300.00 0.00 0.00 0.00 6,300.00 0.0
TRANSFERS OUT 7,300.00 7,300.00 0.00 0.00 0.00 7,300.00 0.0
HOUSING & REDEVELOPMENT 107,900.00 107,900.00 17,337.32 0.00 0.00 90,562.68 16.1
Expenditures 107,900.00 107,900.00 17,337.32 0.00 0.00 90,562.68 16.1
Net Effect for HRA -7,900.00 -7,900.00 211,732.79 50,886.42 0.00 -219,632.79 -***.*
Change in Fund Balance: 211,732.79
III
• •O •o U1 CO CO 1 0 0 1 n N1 N
U1 U1 ,iO O•0 O U1 M 1 in
O CU O W .O CO CO P Us-C0 l\
n1 I2
\,- N LM U1 in c- 1 1 Cr. O•
N 1 C
N 3 Ul in .-• U 'O '0
\f� 0 so NO a- l` 1,-
,0
.p E a- a- .-
O Q
CU CU CU
♦. E o)
C7..- C)
O H d
O 0 0 0 0 0 0 0
O 0 0 0 0 0 0 0 co C)
-0 •O VO•O VO•O•O VO O O
C) N N N N N N N N H H
3• co NO .0 vO VO b VO b•O 13 'O
0 0 O 0 0 0 0 0 0 0 C C
3 co
I- u_ L
2 [o
CU LU
U L E
CU 0.
E 0
>
> E J
C 7 W
.-• 2 >
LU
0
LU
Cr
ab
CO
2
r.
2 2 2 2 2 2 N
E E E E E E 0
C W W W W W W =
O c/7 C/1 U1 CO U) N
K K K CE CLQ Cd
1+ 0 C7 = = = = = = 0 CO
Q 2 a-1 CO CO CO CO CO CO 2
Q 0 22222X < 0 O
C- J I- J I-
0
U W W W W W W
CU 2 K CC CC OC OC Cd 2
W
0 Q » a > r a Q
a) E f f f GC X X X S
U ad ad
2 2 2 2 2 =
O co CD U U U U U CO
0 Z >1111111 - ¢¢ Q ¢ 6 QZ CE CE CE CC Cd CC ?
Y F E E E E E Y
00
CO CO CO CO CO CO CO
L co 0 0 0 0 0 0 0
C- Y C) y-
03 U.0
N E
J .0 3
U 2
J
Q
CO
0
CL
O.
Q
W
U_
0
2
... LU LU Ce K (X K W CC
LU > > > > > > >
CC K CL' K CL' ce CLQ CLQ
E J J J J J J J J
CO LU W W W W W W W
2
LI- LL_ LL_ U. LI- W la. U.
L 0 0 0 0 0 0 0 0 0
0
10 C >- r- - C- I- I- F r-
0
C)
> U U U U U U U U
L O.
CU a) E
E CU" O N >• C C C3
a.O 3 CO. O L- Ca
13 U. Q Q•.- 7 L U
CO- ¢ 0 C) W CU C L
I- C< a LL- E •-• 3E -
I
2
W
E
a
O
J
W
>
W
OCD
LLI
L 0 cd 0 0 Ul ts.03 Ch 0
0 0 0 0
> N 1 1 1 1 1 1 1
0
CY 0 2 0 0 0 0 0 0 0
0
J C O U)•O b'-O b•O VO'O
W C) •-• Q O O_0 0 0 0 0 0 0
o v- 4E+ 3 = 0 b•O b•O vO b b
O L O
a) 0 •• 4-'O i+0000000
> V 0_U -0 O.a- O.
Y C C) Q C CD Ch NUUO'OIO'UU
7 0 3 0 C]
U U. U.