HomeMy WebLinkAbout[04b] Finance Report EDA Agenda Item 4 b
MEETING DATE: January 20, 2016
AGENDA ITEM: Finance Report
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE/COUNCIL RECOMMENDATION: N/A
PREVIOUS EDA ACTION: None
BACKGROUND INFORMATION: Enclosed you will find the reconciled financial reports through
December 31, 2015. The balances do not include accruals to be booked for the financial audit. The EDA
received 99%and expended 87%of the budget(excluding the DEED grant activity). Project spending
includes revolving loans,fagade grants, business development and demolition grants.The EDA
underspent in 2015 due to the resignation of MDG. The EDA has a fund balance of$86,333; $23,380
undesignated.
The other funds reported include the TIF funds and the Revolving Loan fund. The TIF funds with deficit
balances will be covered by the EDA until TIF revenue is received to cover the deficits. The EDA has four
outstanding revolving loans; one will be completed in 2016. The current revolving loan balance is
$12,045 for future loans.
The Check Register includes November and December payments. The following TIF proceeds and
Abatement payment were paid in December. Property tax and tax increment has been received to
cover these payments.
Coborn's Abatement $50,000.00
TIF 2-1 Millstream Shops/Lofts $13,296.72
TIF 2-2 Meat Market $1,878.57
BUDGET/FISCAL IMPACT: For Information Only
ATTACHMENTS: Request for EDA Action—Financial Reports
Summary Treasurer's Report
EDA Balance Sheet
EDA Check Register
EDA Revenue Report
EDA Expenditure Report
EDA Summary CIP
REQUESTED BOARD ACTION: Consider accepting the financial reports and approve December
accounts payables as presented.
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
December 2015
Fund 150, EDA Balance as of December 31, 2014 (Audited) 103,522.49
Year to Date Revenue:
Interest Earnings 1,051.08
TIF/MIF Deposit (unused returned to Bayou Blues) (10,751.78)
DEED Housing Grant Proceeds 142,007.50
Ad Valorem Taxes 94,734.70
Transfers from Other Funds 9,134.00
Total Revenue 236,175.50
Year to Date Expenditure Total by Prosect:
Market Development 3,715.10 **
Business Development 23,683.88 **
Organizational Development 3,169.15 **
Infrastructure Development 1,016.70 **
Workforce Development - **
31,584.83
Year to Date Expenditures by Object:
Board Stipends (385.00)
Staff Salaries (1,651.23)
Workers Comp Premium (3.61)
Software Support/Office Supplies (591.17)
Municipal Development Group (23,030.79)
Legal/Engineering Fees (1,583.80)
Telephone (733.36)
Greater St. Cloud Development Investment (5,000.00)
Business Round Table Outreach -
Marketing (2,612.68)
Advertising (194.91)
Coborn's Abatement (50,000.00)
CM Housing Grant Reimbursement (139,691.00)
EDA Programs (19,936.59)
Transfer to Other Funds (7,951.00)
Total Expenses (253,365.14)
Fund Summaries as of December 31,2015:
EDA Fund Balance - Fund 150 - unaudited 86,332.85
Designated for Capital Programs 62,583.81
Designated for DEED Housing Projects 368.57
Undesignated 23,380.47
TIF 3-1 Central MN Credit Union Fund Balance - Fund 152 (5,596.51)
TIF 2-1 Millstream Shops and Lofts Fund Balance - Fund 157 17,170.04
TIF 2-2 St. Joseph Meat Market Fund Balance - Fund 158 (256.04)
TIF 2-3 Bayou Blues &Alley Flats Fund Balance - Fund 159 (4,262.70)
Revolving Loan Fund Balance -Fund 250 12,045.17
*'Detail available upon request
EDA Balance Sheet
Current Period:December 2u1s
YTD YTD Current
FUND Descr Account Descr __��Yr Debit Cred it Balance
FUND 15oEconomic Development
Economic Development G 150-10100 Cash $189,**3.65 $258,389.86 $292,928.66 $7*,832.85
Economic Development G 150-10450 Interest Receivable $215.58 $8.80 $215.58 $8.80
Economic Development G 150-10700 Taxes Receivable oe|mqven $1,316.15 $8.88 $1,316.15 $8.80
Economic Development Gzs8'z3zz3Due From other Gov tUnits $8.80 $8.80 $8.88 $8.80
Economic Development G zs8'zss8UDue From Other Fund $588.80 $11,800.80 $8.88 $11,580.88
Economic Development G 150-20200 Accounts pnynU|e -$6,601.0 $6,601.0 $8.88 $8.80
Economic Development G zs8'2828zSalaries Payable -$35.83 $35.83 $8.80 $8.80
Economic Development G 158'22284 Deferred Inflow ofResources -$1,316.15 $1,316.15 $8.80 $8.80
Economic Development G 158'2**15 Design. Fd Bal [npno| pnoj -$53,841.94 $8.88 $8.80 -$53,841.94
Economic Development G 150-25310 Appropriated Fund Balance
FUND 15oEconomic Development $8.80 $578,398.83 $578,398.83 $8.80
FUND 152TIF 3-1 CMCu
TIF 3-1 CMCu G 152-10100 Cash $8.80 $6,800.88 $5,596.51 $*83.*9
TIF 3-1 CMCu G 152-10450 Interest Receivable $8.80 $8.80 $8.80 $8.80
TIF 3-1 CMCu G 152-20200 Accounts pnynU|e $8.80 $8.88 $8.80 $8.80
TIF 3-1 CMCu G 152-28580 Due ToOther Fund $8.88 $8.80 $6,880.80 -$6,880.80
TIF 3-1 CMCu G 152-25310 Appropriated Fund Balance
FUND 152TIF 3-1 CMCu $8.80 $17,596.51 $17,596.51 $8.80
FUND 157TIF 2-1 Millstream
TIF 2-1 Millstream G 157-10100 Cash $17,951.81 $36,55*.17 $37,335.94 $17,178.84
TIF 2-1 Millstream G 157-10450 Interest Receivable $29.72 $8.80 $29.72 $8.80
TIF 2-1 Millstream G 157-25310 Appropriated Fund Balance
FUND 157TIF 2-1 Millstream $8.80 $73,919.83 $73,919.83 $8.80
FUND 158TIF 2-2 Meat Market
TIF 2-2 Ment Market G 158-10100 Cash $116.36 $3,96*.*8 $3,836.88 $2*3.96
TIF 2-2 Ment Market G 158-10450 Interest Receivable $8.25 $8.88 $8.25 $8.80
TIF 2-2 Ment Market G 158-28281 Salaries Payable -$17.52 $17.52 $8.80 $8.80
TIF 2-2 Ment Market G 158-28580 Due ToOther Fund -$580.80 $8.80 $8.80 -$588.80
TIF 2-2 Ment Market G 158-25310 Appropriated Fund Balance
FUND 158TIF 2-2 Meat Market $8.80 $7,819.13 $7,819.13 $8.80
FUND 15yTIF 2-3 Bayou Blues/Alley Flat
TIF 2-3 Bayou a|ve$A|| G 159-10100 Cash $8.80 $5,800.88 $*,262.78 $737.38
TIF 2-3 Bayou a|ve$A|| G 159-10450 Interest Receivable $8.88 $8.80 $8.80 $8.80
TIF 2-3 Bayou a|ve$A|| G 159-20200 Accounts pnynU|e $8.88 $8.80 $8.80 $8.80
TIF 2-3 Bayou a|ve$A|| G 159-28580 Due ToOther Fund $8.80 $8.80 $5,800.80 -$5,808.80
TIF 2-3 Bayou a|ve$A|| G 159-25310 Appropriated Fund Balance
FUND 15yTIF 2-3 Bayou Blues/Alley Flat $8.80 $1*,262.78 $1*,262.78 $8.80
FUND 25oRevolving Loan Fund
Revolving Loan Fund G2s8'z8z8UCash $39,*69.77 $21,93*.68 $*9,359.28 $12,845.17
Revolving Loan Fund G2s8'z84s8Interest Receivable $63.29 $8.80 $0.29 $8.80
Revolving Loan Fund G2s8'zz9UUNotes Receivable $21,723.72 $8.88 $21,723.72 $8.80
Revolving Loan Fund G 258-22284 Deferred Inflow ofResources -$21,723.72 $21,723.72 $8.80 $8.80
Revolving Loan Fund G 250-25310 Appropriated Fund Balance
FUND 25oRevolving Loan Fund $8.80 $93,888.97 $93,888.97 $8.80
$8.80 $777,877.97 $777,877.97 $8.80
CITY OF ST. JOSEPH
r
CHECK
# Search Name Comments FUND DEPART Amount
049876 CENTURYLINK TI line/20 sets 229 #'s 150 46500 $49.03
049877 CENTURYLINK BUSINESS SERVICES Oct long distance telephone 150 46500 $3.40
049923 CENTRAL MN HOUSING PARTNERSHIP CRAP Draw#29 admin 150 46500 $3,750.00
049952 CENTURYLINK BUSINESS SERVICES Nov long distance telephone 150 46500 $4.30
049954 COBORN S INC 2015 abatement 150 46500 $50,000.00
049986 BRAND BUILT HOMES, INC. CRAP Grant Draw #30 [Stock] 150 46500 $4,568.00
049989 CENTURYLINK Dec Ti line/20 sets 229 #'s 150 46500 $49.03
050017 MINNWEST BANK 2nd half Millstream Shops TIF 157 46500 $13,296.72
050019 PFANNENSTEIN, HARVEY&CAROL 2nd half Meat Market TIF pay 158 46500 $1,878.57
050054 CENTURYLINK BUSINESS SERVICES Dec long distance telephone 150 46500 $3.65
$73,602.70
Current Period:December 2u1s
2815 December 2815
FUND Descr SOURCE SOURCE Descr YTD Bud2et 2015 Amt YTD Amt
FUND zs8Economic Development
Economic Development 31818 Current Ad Valorem Tams $94,595.80 $*5,371.95 $94,73*.78
Economic Development 33160 Federal Grants Other $8.80 $*,568.80 $1*2,807.58
Economic Development 3*158 TzRMzpoeposit $8.80 $8.88 -$18,751.78
Economic Development 3*280 DEED Housing Re|mUvmem $8.88 $8.80 $8.80
Economic Development 36218 Interest Earnings $1,800.88 -$128.87 $1,851.88
Economic Development 39281 Transfers from Other Funds
pumo zs8Economic Development $95,595.80 $*9,811.88 $236,175.58
pumo zs2TIF 3-z CMCu
TIF 3-1 CMCu 31858 Tax Increment $8.80 $8.88 $8.80
TIF 3-1 CMCu 36218 Interest Earnings $8.80 $8.80 $8.88
TIF 3-1 CMCu 39281 Transfers from Other Funds
pumo zs2TIF 3-z CMCu $8.88 $8.88 $8.80
FUND zs7TIF 2-1 Millstream
TIF 2-1 Millstream 31858 Tax Increment $8.80 $1*,77*.13 $36,221.17
TIF 2-1 Millstream 36218 Interest Earnings
FUND zs7TIF 2-1 Millstream $8.88 $1*,7*9.6* $36,*12.21
FUND zs8TIF 2-2Meat Market
TIF 2-2 Ment Market 31858 Tax Increment $8.80 $1,977.** $3,958.85
TIF 2-2Meat Market 36218 Interest Earnings $8.80 -$8.2* $3.*8
TIF 2-2 Ment Market 39281 Transfers from Other Funds
FUND zs8TIF 2-2Meat Market $8.88 $1,977.28 $3,962.25
pumo zs9TIF 2-3 Bayou a|ve$A||ey Flat
TIF 2-3 Bayou a|ve$A||eyRn 31858 Tax Increment $8.88 $8.80 $8.80
TIF 2-3 Bayou a|ve$A||eyRn 36218 Interest Earnings $8.80 $8.80 $8.88
TIF 2-3 Bayou Blues/Alley Rn 39281 Transfers from Other Funds
pumo zs9TIF 2-3 Bayou a|ve$A||ey Flat $8.88 $8.80 $8.80
FUND 2s8Revolving Loan Fund
Revolving Loan Fund 36218 Interest Earnings $380.88 -$zs.zz $268.83
Revolving Loan Fund 39281 Transfers from Other Funds $8.88 $8.88 $7,951.80
Revolving Loan Fund 39328 Revolving Loan Principal $7,895.80 $1,83*.5* $9,918.*2
Revolving Loan Fund 39321 Revolving Loan Interest $985.80 $1*9.62 $1,238.89
Revolving Loan Fund 39322 Revolving Loan Origination
FUND 2s8Revolving Loan Fund $8,388.88 $1,169.85 $19,838.3*
$183,975.80 $67,787.77 $296,388.38
CITY OF ST. JOSEPH
Expenditure r
Current Period:December 2015
2015 December 2015
Account Descr YTD Budget 2015 Amt YTD Amt
FUND 150 Economic Development
E 150-46500-101 Salaries $4,000.00 $0.00 $1,533.90
E 150-46500-103 Legislative Bodies $1,260.00 $0.00 $385.00
E 150-46500-121 PERA Contributions $0.00 $0.00 $0.57
E 150-46500-122 FICA Contributions $0.00 $0.00 $94.98
E 150-46500-123 Deferred Comp-Employer $0.00 $0.00 -$0.43
E 150-46500-125 Medicare Contributions $0.00 $0.00 $22.21
E 150-46500-130 H S A- Employer Contribution $0.00 $0.00 $0.00
E 150-46500-131 Health Insurance $0.00 $0.00 $0.00
E 150-46500-132 Dental Insurance $0.00 $0.00 $0.00
E 150-46500-133 Life Insurance $0.00 $0.00 $0.00
E 150-46500-134 Disabilty Insurance $0.00 $0.00 $0.00
E 150-46500-151 Workers Comp. Insur. Prem. $10.00 $0.00 $3.61
E 150-46500-171 Clothing Allowance $0.00 $0.00 $0.00
E 150-46500-200 Office Supplies $500.00 $0.00 $68.84
E 150-46500-215 Software Support $540.00 $0.00 $522.33
E 150-46500-300 Professional Services $28,000.00 $0.00 $23,030.79
E 150-46500-303 Engineering Fee $2,000.00 $0.00 $1,151.80
E 150-46500-304 Legal Fees $1,000.00 $0.00 $432.00
E 150-46500-321 Telephone $785.00 $56.98 $733.36
E 150-46500-322 Postage $350.00 $0.00 $0.00
E 150-46500-328 Marketing $3,000.00 $0.00 $2,612.68
E 150-46500-331 Travel&Conference Expense $150.00 $0.00 $0.00
E 150-46500-340 Advertising $500.00 $0.00 $194.91
E 150-46500-433 Dues&Memberships $5,000.00 $0.00 $5,000.00
E 150-46500-582 Computer Software $0.00 $0.00 $0.00
E 150-46500-588 EDA Programs $33,500.00 $4,568.00 $159,627.59
E 150-46500-622 TIF/Abatement Payments $50,000.00 $50,000.00 $50,000.00
E 150-49300-720 Transfers to Other Funds $0.00 $0.00 $7,951.00
FUND 150 Economic Development $130,595.00 $54,624.98 $253,365.14
FUND 152 TIF 3-1 CMCU
E 152-46500-300 Professional Services $0.00 $0.00 $4,579.51
E 152-46500-301 Audit&Accounting Services $0.00 $0.00 $0.00
E 152-46500-340 Advertising $0.00 $0.00 $0.00
E 152-46500-622 TIF/Abatement Payments $0.00 $0.00 $0.00
E 152-49300-720 Transfers to Other Funds $0.00 $0.00 $1,017.00
FUND 152 TIF 3-1 CMCU $0.00 $0.00 $5,596.51
FUND 157 TIF 2-1 Millstream
E 157-46500-101 Salaries $420.00 $0.00 $0.00
E 157-46500-121 PERA Contributions $30.00 $0.00 $0.00
E 157-46500-122 FICA Contributions $25.00 $0.00 $0.00
E 157-46500-123 Deferred Comp-Employer $10.00 $0.00 $0.00
E 157-46500-125 Medicare Contributions $5.00 $0.00 $0.00
E 157-46500-131 Health Insurance $60.00 $0.00 $0.00
E 157-46500-132 Dental Insurance $10.00 $0.00 $0.00
E 157-46500-133 Life Insurance $5.00 $0.00 $0.00
E 157-46500-134 Disabilty Insurance $5.00 $0.00 $0.00
E 157-46500-300 Professional Services $0.00 $0.00 $312.51
E 157-46500-301 Audit&Accounting Services $0.00 $0.00 $0.00
E 157-46500-340 Advertising $0.00 $0.00 $45.32
E 157-46500-622 TIF/Abatement Payments $0.00 $13,296.72 $32,599.06
E 157-49300-720 Transfers to Other Funds $0.00 $0.00 $4,266.81
CITY OF ST. JOSEPH
Expenditure r
Current Period:December 2015
2015 December 2015
Account Descr YTD Budget 2015 Amt YTD Amt
FUND 157 TIF 2-1 Millstream $570.00 $13,296.72 $37,223.70
FUND 158 TIF 2-2 Meat Market
E 158-46500-101 Salaries $420.00 $0.00 $3.83
E 158-46500-121 PERA Contributions $30.00 $0.00 $0.29
E 158-46500-122 FICA Contributions $25.00 $0.00 $0.17
E 158-46500-123 Deferred Comp-Employer $10.00 $0.00 $0.05
E 158-46500-125 Medicare Contributions $5.00 $0.00 $0.04
E 158-46500-131 Health Insurance $60.00 $0.00 $5.37
E 158-46500-132 Dental Insurance $10.00 $0.00 $0.89
E 158-46500-133 Life Insurance $5.00 $0.00 $0.07
E 158-46500-134 Disabilty Insurance $5.00 $0.00 $0.44
E 158-46500-300 Professional Services $0.00 $0.00 $0.00
E 158-46500-301 Audit&Accounting Services $0.00 $0.00 $0.00
E 158-46500-340 Advertising $0.00 $0.00 $45.32
E 158-46500-622 TIF/Abatement Payments $0.00 $1,878.57 $3,760.91
FUND 158 TIF 2-2 Meat Market $570.00 $1,878.57 $3,817.38
FUND 159 TIF 2-3 Bayou Blues/Alley Flat
E 159-46500-300 Professional Services $0.00 $0.00 $412.51
E 159-46500-301 Audit&Accounting Services $0.00 $0.00 $0.00
E 159-46500-340 Advertising $0.00 $0.00 $0.00
E 159-46500-622 TIF/Abatement Payments $0.00 $0.00 $0.00
E 159-49300-720 Transfers to Other Funds $0.00 $0.00 $3,850.19
FUND 159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $0.00 $4,262.70
FUND 250 Revolving Loan Fund
E 250-46500-300 Professional Services $0.00 $0.00 $434.23
E 250-46500-304 Legal Fees $0.00 $0.00 $0.10
E 250-46500-317 Other fees $0.00 $0.00 -$108.10
E 250-46500-434 Certification Fee $0.00 $0.00 $0.00
E 250-46500-455 Revolving Loan Proceeds $0.00 $0.00 $47,000.00
FUND 250 Revolving Loan Fund $0.00 $0.00 $47,326.23
$131,735.00 $69,800.27 $351,591.66
0 5 _ w
u u L >
u 0 9 i
V �
l7 cc m Y
O O� W O W w 0000 O
Ln m � O O n m M m
00
Ln U O^ m ON v n lN0 00 Ln
2 c-I m 00 w N O to I�
N Lb LD
CO
a-ICp
rn
O� Gl Om O W Lail Ln O
Oi
a-I = Ln1� 00 w O N W CO Ol
4 Ln ci LCl Ql L.CI LO
bb Q. N v LCl ci N n Lr N Ol
3 CA ci N M
s
o
\ 0 Ln
Ul N 1-1 00 C
NO
a-I Ln m Ol l0 00
L Ln a-1 m W 11 O
b L N
O H
0 �
LJJ O O OO
C O O O O O
m O O O ' O N
Ln
4 Ln O O LCl �
G CO N m (Yl M
y +' N ci ci rn
>_ C 4, 0 CO
N alb N
E
C >
O 3 s_
y m v
X CL Q_ �"� y O O N Cl W Ln rH rn to O
W U v N u O Ln Lnm rH ' tD r O
f6 f6 (U 41 n N W n N Ln ci 0) w M
C6UQ. N Q N
Ln U O
-0 N O
N Li Q E E
Q
f6 LL 2 N O
i N n O N
C
y O N O >
C7 E o o co .o J O o 0
3
> Fn a
O LL )
. O 3
a E J a) O
LU0 w > U
0 m C O CO m
Z o U) � U N 0
E �n .� rn < cQ m
o Z) c`o Z) LL a> CO
U Jm0- CO m � U N
T N f- h O Cl) I LO CA
O O O O O O O O O
Cl) M M M M M M M M
a` Z D coca 0 o 0 0
W W W W W W W W W
v 00 00
O
0 U? U?
V oO
+ O o
Ln Ln
O � �
V
QLO Lr)
OO 0-
C)U
c Q
+. v 0
£ W
X
i
0 J
It CL 0) 0 0 ~
Ol W W