While many governments report only annually, the City of Fort Collins, Colorado, provides monthly financial reports on its Web site. Such information increases the accountability of government to its financial report users. One report provided by Fort Collins displays fund performance on a monthly basis. Using some of the data provided by Fort Collins, complete the requirements for this exercise.

Required
a. What was the trend in revenue relative to expenditures in 2010? Has any pattern been established in the first quarter of 2011?
b. Compare the monthly expenditures for 2010 to those in 2009.
c. What, if any, concerns or questions do you have about the trend data provided for the first quarter of2011?

Transcribed Image Text:

OVERALL FUND PERFORMANCE: General Fund Revenue vs Expenditures 2011 2011 Revenue 2011 Expenditures Monthly Variance $1,337,286 (5,295,270) 4,082,138 JAN FEB MAR APR MAY JUN JUL AUG SEP ост NOV DEC S 7,727,661 6,013,198 11,738,462 S 6,390,375 11,308,468 7,656,324 Totals S25,479,321 S25,355,167 S 124,154 14 12 10 2011 Revenue O 2011 Expenditures 2010 Expenditures 0