HomeMy WebLinkAboutReport - Mail Packet - 4/23/2013 - Monthly Financial Report - March 20131 April 17, 2013
REPORT
MONTHLY
FINANCIAL
March 2013
POSITIVE
WARNING
NEGATIVE
= Positive variance or negative variance < 1% compared to seasonal trends.
= Negative variance of 1-4% compared to seasonal trends.
= Negative variance of > 4% compared to seasonal trends.
CURRENT MONTH YEAR TO DATE REFERENCE
GENERAL FUND
General Fund Exp vs. Rev POSITIVE POSITIVE Page 2
Overall Sales Tax Revenue (prior month activity) POSITIVE POSITIVE Page 3
Overall Use Tax Revenue POSITIVE POSITIVE Page 3
Property Tax Revenue POSITIVE POSITIVE Page 4
Other Revenues POSITIVE POSITIVE Page 4
Fees and Charges POSITIVE POSITIVE Page 5
YTD Revenues with Budget Line POSITIVE POSITIVE Page 6
General Fund Monthly Collection Comparison POSITIVE POSITIVE Page 6
YTD Expenditures with Budget Lines POSITIVE POSITIVE Page 7
General Fund Expenditure vs. Budget POSITIVE POSITIVE Page 7
PERFORMANCE AT A GLANCE
PERFORMANCE INDICATORS
The monthly Financial information for the Utility Funds is provided in a separate report
prepared by the City of Fort Collins Utilities.
*Numbers in this report are subject to change as items are posted into the period they occurred.
2 April 17, 2013
ECONOMIC INDICATORS:
2013
Revenue
2013
Expenditures
Monthly
Variance
JAN $173 8,700,$200 8,525,$973 174,
FEB 7,763,115 9,120,960 (1,357,845)
MAR 11,823,997 7,809,749 4,014,248
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Totals $285 28,287,$909 25,455,
-
2
4
6
8
10
12
14
2013 Revenue 2013 Expenditures 2012 Expenditures
NATIONAL ECONOMY
National GDP: GDP is defined as the output of goods and services produced by labor and property located in
the United States. The Bureau of Economic Analysis reported that the revised GDP for the fourth quarter of
2012 increased at a rate of 0.4%. In the third quarter of 2012 GDP increased at a revised rate of 3.1%.
Interest Rates: The Federal Open Market Committee met on January 30th, 2013 and the outcome of the
meeting was maintaining the Federal Funds interest rate to float between 0% and 0.25%.
Housing Starts: Housing Starts in March 2013 were at a seasonally adjusted rate of 1,036,000. This is 7.0%
above the revised February 2013 figure of 968,000 and is 46.7% above the March 2012 rate of 706,000.
National: The National unemployment rate for March 2013 decreased to 7.6% from the revised February 2013
rate of 7.7%.
State-wide: The Colorado unemployment rate for February 2013 decreased to 7.2% from the January rate of
7.3%.
Larimer County: The Fort Collins-Loveland area unemployment rate for February 2013 increased to 6.5% from
the January rate of 6.2%.
State-wide: Building permits for February 2013 numbered 1,815. This is a decrease from the January 2013 count
of 1,878.
Local: City Building and Zoning reported 440 Building Permits issued in March 2013 with a value of $39,188,485.
March 2012 had 688 building permits with a value of $38,989,945.
BUILDING ACTIVITY
March 2013 generated a positive cash flow month with revenues higher than expenditures by $4,014,248. During the month
revenues were 51.4% higher than expenditures. Historically revenues are greater than expenditures during the first half of the
year due to the timing of property tax collections.
GENERAL FUND REVENUE VS EXPENDITURES 2012
POSITIVE
OVERALL FUND PERFORMANCE:
UNEMPLOYMENT RATES
$ in Millions
3 April 17, 2013
2013* 2012
YTD
Variance
JAN $ 886,760 $ 755,296
FEB 795,525 505,069
MAR 871,426 924,745 16.87%
APR 974,447
MAY 1,052,169
JUN 1,076,791
JUL 956,803
AUG 1,092,886
SEP 969,331
OCT 1,255,345
NOV 1,681,663
DEC 1,556,565
TOTALS $ 2,553,711 $ 12,801,110
Use Tax Collections are for Sales in prior month.
-
2
4
6
8
10
12
2013
2012
2013 CURRENT BUDGET
2013 CURRENT BUDGET WITH ECONOMIC INCENTIVES
2013 2012 Budget
JAN $107 5,936,$879 5,716,$384 5,848,423503100.00% 4,106,186.00 4,722,398.00 4,391,884.00
FEB 4,327,214 4,126,638 4,235,031
MAR 4,162,413 4,011,513 4,106,186
APR 4,571,604 4,722,398
MAY 4,282,654 4,391,884
JUN 4,484,098 4,621,563
JUL 4,850,893 5,013,697
AUG 4,432,602 4,565,544
SEP 4,881,061 5,030,503
OCT 4,777,498 4,750,407
NOV 4,520,791 4,375,079
DEC 4,616,319 4,425,524
TOTALS $734 14,425,$550 55,272,$200 56,086,
Sales Tax collections are for Sales in prior month.
0
2
4
6
2013 2012 Budget
s
Sales Tax represents just over 50% of the General Fund Budget and serves as the primary funding source for the general
government. The General Fund allocation of sales tax remitted to the City in March and collected by merchants in February
experienced an increase of 3.8% compared to sales tax remitted in March 2012. Monthly collections by merchants were higher than the budgeted
amount by 1.4%. The year over year increase was primarily due to the increase in Building Materials, Garden Equipment & Supplies; Grocery,
Convenience, Liquor; and Restaurants, Caterers and Bars categories (up 91.3%, 4.1% and 2.4% respectively).
GENERAL FUND
REVENUE ANALYSIS:
GENERAL FUND SALES TAX 2012-2013 COMPARISON
POSITIVE
Use Tax represents approximately 10% of the General Fund Budget. Use tax is volatile because it is heavily dependent on
4 April 17, 2013
2013 2012
Monthly
Variance
JAN $ - $ - $ -
FEB 672,502 543,154 129,348
MAR 4,283,389 4,932,726 (649,337)
APR 1,175,644
MAY 3,787,492
JUN 2,141,459
JUL 3,834,248
AUG 170,823
SEP 161,731
OCT 55,431
NOV 37,760
DEC 124,073
TOTALS $ 4,955,891 $ 16,964,541
-
2
4
6
8
10
12
14
16
18
2013 YTD 2012 YTD
Property taxes represent 17% of the overall General Fund Budget. They are remitted in two installments due on February 28
and June 17 or they are paid in full by April 30. Whether paid by installment or in full by the April deadline, over 95% of the levy
has typically been remitted to the City by the end of July each year. Property tax collections for March 2013 were lower than 2012 by 13.2%.
PROPERTY TAXES 2012-2013 COMPARISON
REVENUE ANALYSIS (continued):
GENERAL FUND
POSITIVE
2013 2012
YTD
Variance
JAN $ 796,261 $ 971,873
FEB 885,379 821,372
MAR 1,421,147 1,160,684 5.0%
APR 1,113,608
MAY 1,381,831
JUN 1,391,221
JUL 909,492
AUG 1,355,406
SEP 1,762,430
OCT 8,846,325
NOV 1,082,063
DEC 652,315
TOTALS $ 3,102,787 $ 21,448,620
-
5
10
15
20
2013 YTD 2012 YTD
Other revenue consists of licenses (e.g., contractor license, liquor license), permits (e.g., building permits, street cut permits),
fines (e.g., court fines, camera radar fines), earnings on investments and miscellaneous. The volume of activity (i.e., building
permits and fines) will fluctuate month to month. Other revenue collections were higher than March 2012 by 22.4%.
5 April 17, 2013
2013 2012
YTD
Variance
JAN $ 1,081,046 $ 1,040,553
FEB 1,082,495 1,080,386
MAR 1,085,623 1,069,046 1.9%
APR 1,078,081
MAY 1,374,465
JUN 1,130,753
JUL 1,387,685
AUG 1,758,913
SEP 1,298,469
OCT 1,141,929
NOV 1,509,390
DEC 1,603,172
TOTALS $ 3,249,164 $ 15,472,842
-
2
4
6
8
10
12
14
2013 YTD 2012 YTD
Admin Charges-Light &
Power $96,871 (9%)
Admin Charges- Water
$71,949 (7%)
PILOT- Waste Water
$91,323 (8%)
PILOT- Water Fund
$89,680 (8%) PILOT- Light & Power
$486,154 (45%)
Remaining Fees &
Charges
$249,646 (23%)
REVENUE ANALYSIS (continued):
FEES AND CHARGES 2012-2013 COMPARISON
MARCH 2013 FEES & CHARGES
Fees and charges for services include the following: payments in lieu of taxes (“Pilot”) paid by the Utilities to the General Fund,
administrative charges, plan checking fees, PUD Subdivision & zoning fees, real estate service fees, custodial service fees,
project management service fees, and cable franchise fees. March 2013 Fees and Charges were 1.6% higher than March 2012.
GENERAL FUND
POSITIVE
$ in Millions
6 April 17, 2013
2013 2012
Monthly
Variance
JAN $ 8,700,173 $ 8,484,601 $ 215,572
FEB 7,763,115 7,076,619 686,496
MAR 11,823,997 12,098,714 (274,717)
APR 8,913,682
MAY 11,878,611
JUN 10,224,322
JUL 11,939,121
AUG 8,810,630
SEP 9,073,022
OCT 16,079,164
NOV 8,831,666
DEC 8,552,444
TOTALS $ 28,287,285 $ 121,962,596 0
10
20
30
40
50
60
70
80
90
100
110
120
2013
2012
2013 Original Budget of $112,205,909
2013 Current Budget of $112,205,909
Revenues for March 2013 were lower than March 2012 by $274,717. The difference is due to the decreased collections in
Property Tax.
REVENUE ANALYSIS (continued):
YTD REVENUES WITH ORIGINAL
(CURRENT) BUDGET 2012-2013 COMPARISON
REVENUE ANALYSIS (continued):
GENERAL FUND
POSITIVE
0
2
4
6
8
10
12
14
16
2013 2012 Budget
March 2013 General Fund revenue collections were lower than March 2012 by 2.3%. Compared to the budget revenues were
up 6.4%. The difference is due to the decreased collections in Property Tax.
GENERAL FUND REVENUE MONTHLY COLLECTION COMPARISON
POSITIVE
$ in Millions
$ in Millions
7 April 17, 2013
0
2
4
6
8
10
12
2013 2012 Budget
2013 2012 Variance
JAN $ 8,525,200 $ 7,700,004 $ 825,196
FEB 9,120,960 8,009,974 1,110,986
MAR 7,809,749 7,784,208 25,541
APR 8,309,531
MAY 10,405,193
JUN 10,218,868
JUL 8,107,921
AUG 8,753,156
SEP 8,347,630
OCT 9,925,588
NOV 9,340,042
DEC 9,986,666
TOTALS $ 25,455,909 $ 106,888,781
0
20
40
60
80
100
120
2013
2012
2013 Original Budget of $112,857,870
2013 Current Budget of $117,229,012
EXPENDITURE ANALYSIS:
2012-2013 YTD EXPENDITURES WITH BUDGET COMPARISON
Expenditures in March 2013 were slightly higher than March 2012.
2012-2013 MONTHLY EXPENDITURES WITH BUDGET LINE
Expenditures for March 2013 were slightly higher than March 2012, but were lower than the budget by 14.6%.
GENERAL FUND
POSITIVE
POSITIVE
$ in Millions
$ in Millions
OTHER REVENUE 2012-2013 COMPARISON
POSITIVE
$ in Millions
$ in Millions
building activity and vehicle sales. Overall Use Tax collections in March 2013 were down 5.8% compared to March 2012. The
decrease was due to decreased collections in Return Tax down 39.2%.
(*In 2013 economic incentives Use Tax is being tracked and in March collections equaled $79,064. These funds are eligible for reimbursement to the tax payer.)
GENERAL FUND USE TAX 2012-2013 COMPARISON
POSITIVE
$ in Millions
$ in Millions