Loading...
HomeMy WebLinkAboutComprehensive Annual Financial Report (CAFR) for Fiscal Year 2006-2007 Commission Memorandum REPORT TO: Honorable Mayor and City Commission FROM: Brian LaMeres, City Controller and Chris Kukulski, City Manager (to be presented by Merrilee Glover of J.C.C.S.) SUBJECT: Comprehensive Annual Financial Report (CAFR) for Fiscal Year 2006-2007 MEETING DATE: January 22, 2008 BACKGROUND: Section 2-7-503 MCA requires that a financial report be prepared for every fiscal year. The statute requires a biannual audit of the accounts, financial records, and transactions of all administrative departments of the City by independent certified accountants selected by the City Commission. It has historically been the belief of the City Commission and City Administration that an annual audit assures a higher level of financial management and fiscal responsibility than a biannual audit. This policy, along with the legal reporting requirement, has been followed for fiscal year 2007, and the clean unqualified opinion expressed by the auditor firm of Junkermeir, Clark, Campanella & Stevens, PC has been included in the accompanying report. The City’s Audit Committee has reveiwed and accepted the CAFR and the accompanying letter to management. RECOMMENDATION: The City Commission accepts the CAFR and accompanying reports. FISCAL EFFECTS: A clean unqualified audit opinion on the City’s financial statements is viewed favorably by investment analysts and strengthens the City’s ability to issue bonds or other debt at a lower interest cost. ALTERNATIVES: As suggested by the City Commission. Respectfully submitted, Brian LaMeres, City Controller Approved by: Chris A. Kukulski, City Manager Attachments: Comprehensive Annual Financial Report, Auditor’s Letter to Management. Report compiled on January 16, 2007 173 CITY OF BOZEMAN, MONTANA COMPREHENSIVE ANNUAL FINANCIAL REPORT JUNE 30, 2007 Prepared by the City of Bozeman Finance Department 174 CITY OF BOZEMAN, MONTANA COMPREHENSIVE ANNUAL FINANCIAL REPORT JUNE 30, 2007 TABLE OF CONTENTS I. INTRODUCTORY SECTION Letter of Transmittal ........................................................................................................................................................................................................ 1-15 Governmental Financial Officers’ Association Certificate of Achievement ...................................................................................................................... 16 Organizational Chart ........................................................................................................................................................................................................... 17 City Elected Officials and Officers ................................................................................................................................................................................ 18-19 II. FINANCIAL SECTION INDEPENDENT AUDITOR’S REPORT ..................................................................................................................................................................... 20-21 A. MANAGEMENT’S DISCUSSION AND ANALYSIS ................................................................................................................................................ 22-31 B. BASIC FINANCIAL STATEMENTS Government Wide Financial Statements Statement of Net Assets ............................................................................................................................................................................................... 32 Statement of Activities ................................................................................................................................................................................................. 33 Fund Financial Statements Governmental Fund Financial Statements Balance Sheet – Governmental Funds .............................................................................................................................................................. 34-35 Reconciliation of the Balance Sheet to the Statement of Net Assets – Governmental Funds ............................................................................... 36 Statement of Revenues, Expenditures, and Changes in Fund Balances – Governmental Funds ........................................................................... 37 Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statement of Activities – Governmental Funds ............................................................................................................................................... 38 Proprietary Fund Financial Statements Statement of Net Assets – Proprietary Funds ................................................................................................................................................... 39-40 Statement of Revenues, Expenses, and Changes in Fund Net Assets – Proprietary Funds ................................................................................... 41 Statement of Cash Flows – Proprietary Funds .................................................................................................................................................. 42-43 Fiduciary Fund Financial Statements Statement of Fiduciary Net Assets – Fiduciary Funds ........................................................................................................................................... 44 Notes to Financial Statements ........................................................................................................................................................................................ 45-80 176 CITY OF BOZEMAN, MONTANA COMPREHENSIVE ANNUAL FINANCIAL REPORT JUNE 30, 2007 TABLE OF CONTENTS (CONTINUED) C. REQUIRED SUPPLEMENTARY INFORMATION OTHER THAN MANAGEMENT DISCUSSION AND ANALYSIS Schedule of Revenues, Expenditures, and Changes in Fund Balances - Budget to Actual – General Fund General Fund ................................................................................................................................................................................................................ 81 Street and Fire Impact Fee Special Revenue Fund ....................................................................................................................................................... 82 Notes to Required Supplementary Information Other Than Management Discussion and Analysis .......................................................................... 83 D. SUPPLEMENTAL INFORMATION Combining and Individual Fund Statements and Schedules Combining Balance Sheet – Non-Major Governmental Funds ............................................................................................................................... 84-89 Combining Statement of Revenue, Expenditures, and Changes in Fund Balance – Nonmajor Governmental Funds ........................................... 90-95 Budget-to-Actual Schedule – Other Major Funds Schedules of Revenues, Expenditures, and Changes in Fund Balances - Budget to Actual - Other Major Funds SID Sinking Fund ......................................................................................................................................................................................................... 96 Capital Projects Fund ................................................................................................................................................................................................... 97 Note to Budget-to-Actual Statements – Other Major Funds ........................................................................................................................................ 98 Budget-to-Actual Schedules- Nonmajor Funds Schedules of Revenues, Expenditures, and Changes in Fund Balances - Budget to Actual – Nonmajor Governmental Funds Non-Major Governmental Funds .......................................................................................................................................................................... 99-111 Internal Service Funds Statements Combining Statements of Net Assets – Internal Service Funds ................................................................................................................................. 112 Combining Statements of Revenues, Expenses, and Changes in Fund Net Assets – Internal Service Funds ............................................................ 113 Combining Statements of Cash Flows ................................................................................................................................................................ 114-115 Agency Funds Combining Statements of Fiduciary Net Assets ......................................................................................................................................................... 116 Combining Schedules of Changes in Assets and Liabilities – Agency Funds .................................................................................................... 117-118 177 CITY OF BOZEMAN, MONTANA COMPREHENSIVE ANNUAL FINANCIAL REPORT JUNE 30, 2007 TABLE OF CONTENTS (CONTINUED) III. STATISTICAL SECTION Financial Trends Section Net Assets by Component .......................................................................................................................................................................................... 119 Changes in Net Assets ......................................................................................................................................................................................... 120-121 Fund Balances of Governmental Funds ..................................................................................................................................................................... 122 Changes in Fund Balances, Governmental Funds ...................................................................................................................................................... 123 Revenue Capacity Section Assessed value of Taxable Property ........................................................................................................................................................................... 124 Direct and Overlapping Property Tax Rates .............................................................................................................................................................. 125 Principal Property Tax Payers .................................................................................................................................................................................... 126 Property Tax Levies and Collections ......................................................................................................................................................................... 127 Water Sold by Type of Customer ............................................................................................................................................................................... 128 Water and Sewer Rates............................................................................................................................................................................................... 129 Debt Capacity Section Ratios of Outstanding Debt by Type ................................................................................................................................................................... 130 Ratios of General Bonded Debt Outstanding ............................................................................................................................................................. 131 Direct and Overlapping General Bonded Debt Outstanding ...................................................................................................................................... 132 Legal Debt Margin Information ................................................................................................................................................................................. 133 Pledged Revenue Coverage ........................................................................................................................................................................................ 134 Demographics and Economic Section Demographic and Economic Statistics ....................................................................................................................................................................... 135 Principal Employers ................................................................................................................................................................................................... 136 Operating Section Full-time Equivalent City Government Employees by Function/Program ................................................................................................................ 137 178 CITY OF BOZEMAN, MONTANA COMPREHENSIVE ANNUAL FINANCIAL REPORT JUNE 30, 2007 TABLE OF CONTENTS (CONTINUED) IV. REPORTS OF INDEPENDENT PUBLIC ACCOUNTANTS AND SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AS REQUIRED BY OMB CIRCULAR A-133 Schedule of Expenditures of Federal Awards ................................................................................................................................................................... 138 Notes to Schedule of Expenditures of Federal Awards .................................................................................................................................................... 139 Independent Auditor’s Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based On an Audit of Financial Statements Performed in Accordance with Government Auditing Standards ......................................................................................................................................................................... 140-141 Independent Auditor’s Report on Compliance with Requirements Applicable to Each Major Program and Internal Control Over Compliance in Accordance with OMB Circular A-133........................................................................................................................................................................................... 142-143 Schedule of Findings and Questioned Costs .............................................................................................................................................................. 144-145 Current Status of Prior Year Recommendations ............................................................................................................................................................... 146 179 PART I INTRODUCTORY SECTION 180 1 December 26, 2007 To the Citizens of the City of Bozeman, Montana The Comprehensive Annual Financial Report of the CITY OF BOZEMAN, MONTANA for the fiscal year ended June 30, 2007 is hereby submitted. Responsibility for both the accuracy of the data, and the completeness and fairness of the presentation, including all disclosures, rests with the City. To the best of our knowledge and belief, the enclosed data are accurate in all material respects and are reported in a manner designed to present fairly the financial position and results of operations of the various funds of the City. All disclosures necessary to enable the reader to gain an understanding of the City's financial activities have been included. The comprehensive annual financial report is presented in four sections: introductory, financial, statistical, and single audit. The introductory section includes this transmittal letter, the government's organizational chart and a list of principal officials. The financial section includes management’s discussion and analysis, the basic financial statements and the required supplementary information and other supplemental information, as well as the auditor’s reports on the basic financial statements. The financial section begins with management’s discussion and analysis, which provides users of the basic financial statements with a narrative introduction, overview, and analysis of those statements. The statistical section includes selected financial and demographic information, generally presented on a multi-year basis. The City is required to undergo an annual single audit in conformity with the provisions of the Single Audit Act of 1984 and the Office of Management and Budget Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations. Information related to the single audit, including the Schedule of Expenditures of Federal Awards and the Auditor’s Reports on Basic Financial Statements and Supplementary Schedule of Expenditures of Federal Awards, Internal Control over Financial Reporting and Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards, and Compliance with Requirements Applicable to Each Major Program and Internal Control over Compliance in Accordance with OMB Circular A-133, are included in the single audit section of this report. This report includes all funds of the government. The government provides a full range of services. These services include police and fire protection; sanitation services; the construction and maintenance of streets and infrastructure; recreational activities; cultural events; planning and zoning; and general administrative services. The City, as a primary government, is supported or works closely with certain entities to provide these services to the citizens of the City of Bozeman. Of these entities, Bozeman Public Library Foundation, Inc. is considered a component unit subject to the requirements for inclusion as a discretely presented component unit. The Library Board of Trustees and the City Planning Board are presented as blended component units. The Senior Advisory Council and the Parking Commission are excluded from presentation in these financial statements, since their relationship with the City is strictly advisory in nature at this time. 182 2 ECONOMIC CONDITION AND OUTLOOK The Bureau of Business and Economic Research (BBER) is the research and public service branch of the University of Montana’s School of Business Administration. The Bureau is regularly involved in a wide variety of activities, including economic analysis and forecasting. Excerpts from the Bureau’s forecasts contained in the Spring 2007 issue of the Montana Business Quarterly relating to the United States, Montana in general, as well as Gallatin County and Bozeman, are restated below. Montana Outlook There is a little chill in the air for the U.S. economy. GDP growth should average just 2 percent from mid-2006 to mid-2007 compared to 3 percent to 4 percent from 2004 to 2006. The two causes of the slowdown are: (1) a plummeting housing market and (2) a more cautious consumer. The Federal Reserve may start cutting interest rates, bringing to an end the tight monetary policy and rising interest rates. Top 10 Economic Predictions for 2007 (Courtesy of Global Insight Inc.) 1. Sluggish growth for the U.S. economy. The American economy will grow only 2.2 percent during 2007. 2. Eurozone and Japan to slow (again). Eurozone to grow 2 percent in 2007, down from 2.6 percent in 2006. Japan to decelerate from 2.7 percent to 1.8 percent. 3. Once again, China and India will be star performers. China’s growth will slow(!) to 9.5 percent. India continues at about 8 percent. 4. Oil prices to remain in $60-65 range for the next three to four years and then gradually ease. The longer term price relief will come as high prices encourage new supplies of both conventional and nonconventional fuels. 5. Core inflation will ease. The record high oil prices have had very little impact on core inflation. Slower increases in housing costs will ease overall upward pressure on prices. 6. The Federal Reserve will cut rates as other central banks tighten rates. Slower GDP growth and less price pressures will lead the Fed to cut federal funds rates back to 4.5 percent. But the European Central Bank, the Bank of Japan, and the People’s Bank of China will raise rates. 7. Housing will keep dampening U.S. growth and could become a threat elsewhere. In a weak-growth environment, strong home price appreciation is unlikely to be sustained anywhere. Already a housing crunch in U.S. and booming markets in Ireland, U.K., Spain, and Australia may be heading for a cliff. 8. Current account imbalance will ease a bit. A combination of (1) weaker domestic demand, (2) stronger growth elsewhere in the world, and (3) booming U.S. exports are finally bringing about the long desired correction in global imbalances. 9. Continued downward pressure on the dollar. With growth slowing and interest rate cuts expected, the forces on the dollar are uniformly downward. 10. No recession without all (or most) of the following: higher oil prices, higher inflation, and higher interest rates. Most likely recession scenario: deeper housing recession and higher inflation and interest rates (with a disruption in oil supplies) would probably push U.S. and world economies into a recession. 183 3 Montana Forecast Montana’s economic boom is spreading, with all major sectors of the economic base now participating. Growth has taken place in manufacturing, nonresident travel, agriculture, mining, and the federal government. Buoyant conditions in construction and real estate may add a short-term boost in certain parts of the state. The metal (mostly copper) and energy-related sectors of mining have received much of the attention. This natural resources boom is caused by long-term worldwide demand conditions rather than short-term supply interruptions, like those associated with past oil price peaks. The growth rates during this boom appear to be less than those during previous ones, but this boom may last longer. Montana continues to buck national trends when it comes to construction, real estate, and house prices. Despite more than two years of rising interest rates, the state’s construction industry remains at record levels. Flathead and Gallatin counties especially are benefiting from vibrant construction activity and expanding real estate employment. The latest data (Table 1) confirm the often heard claim – at least around Bozeman – that, the state’s highest home prices are in Gallatin County. Missoula County is a close second. The bust in home prices has not yet hit Montana. During the third quarter of 2006, Montana home price increases (Table 2) continued above the national average, with the exception of Yellowstone County. 184 4 185 5 Risks There are always concerns about the weather, insects, and volatile agricultural prices. But worldwide geopolitical events that dampen the fast growth in developing countries could quickly slow the natural resources boom – such as financial crises or political turmoil. Certain areas, Flathead and Gallatin counties in particular, have become (some may say dangerously) dependent on the construction and real estate industries. Nationwide, both the construction and real estate industries have slowed. Outlook for Gallatin County Gallatin County has been one of the fastest-growing counties in Montana. Bozeman has developed into a trade and service center. Growth in state government (mostly research at MSU), the federal government, and nonresident travel have also been major contributors to the trends since 2001. The Bozeman area is home to much of the state’s high- tech industry, and this sector grew rapidly prior to the 2001 recession. Following national trends, this industry suffered significantly during the recession but has now regained its 2001 level. Newly released Census Bureau data show the 2005 Gallatin County median home price was $216,000, the highest in the state. Construction and real estate are the wild cards impacting the short-term outlook for Gallatin County. The construction-real estate boom began in 2005, as reflected in the almost 10 percent growth in nonfarm labor income that year. There may be a distinct deceleration if these industries start reflecting the cooling reported in the national data. 186 6 For the Year Water Conservation. The City Commission recognizes that an educational program is a critical first step in promoting water conservation. The Commission also acknowledges that finding an alternative source of water may become essential in upcoming years, possibly groundwater in the aquifer in the hills south of Bozeman. The Commission has chosen to delay the replacement of Mystic Dam as long as possible, without jeopardizing the City’s stored water rights. In March, 2002 a Water Conservation Study was prepared by independent consultants and formally adopted by the City thereafter. This study intended to guide policy making decisions regarding water conservation practices by projecting the affects recommended conservation programs would have upon future planning and capitalization of Bozeman’s water supply and distribution systems. Water & Wastewater Rate Structuring. In anticipation of funding the major improvements listed in the Facility Plans on page 7 and also incorporating recommendations of the Water Conservation Study where appropriate, the City implemented a 10% increase in Water Rates early in the year which generated approximately $420,000 in additional revenue for the water fund’s capital reserve. For the average residential customer, monthly bills increase by $2.94 to a monthly total of $32.34. A similar 10% increase was implemented for Wastewater Rates, which generated approximately $358,000 for the wastewater fund’s capital reserve. For the average residential customer, monthly bills will increase by $1.93, to a monthly total of $21.25 Road Construction - General Obligation Bond. The last of the $5 million general obligation bond issue for transportation projects was spent this year on improvements to Durston Road from North 7th Avenue to North 19th Avenue. Road Construction – SID & Impact Fee Funded. Projects funded by Special Improvement District Bonds and Street Impact fees which were completed or substantially completed this year include ―Durston West‖, Durston Road west of North 19th to Fowler Avenue (total cost $5.05 million), Valley Center Road/North 19th Avenue road construction and signalization (total cost $4.4 million), and West Babcock Street ($3.5 million). Bozeman Public Library. The library project gained the needed approvals through the planning process, and approval of the soil contamination remediation efforts was obtained from the Montana Department of Environmental Quality. The Library Foundation continued with its fundraising efforts for the construction of a new library on East Main Street and was able to raise funds sufficient to allow the City Commission to authorize the award of a construction contract. Facility construction began in the Spring 2005 and was completed in the Fall of 2006. The Library opened its new doors in November 2006 after years of hard work and dedication by the Library Trustees, staff, Foundation, Friends, City of Bozeman, and most importantly, the community. Donations of $7.4 million collected from the community and a $4 million general obligation bond were the largest sources of funds for the $16.9 million new Library project. Bozeman Solvent Site. In 1989, contaminants (mainly PCE) were discovered in and near a sewer line on the Buttrey’s Shopping Center property. While voluntary remediation efforts were completed several years ago, the City continues to incur the costs of monitoring. Annexations. Annexations and growth, of course, continue to be critical issues for the City, as Bozeman is one of the fastest growing communities in Montana. During this fiscal year, several annexations were completed, and several more are in process. Impact Fees. In December 1995, the City Commission voted to implement impact fees for streets, fire, water, and wastewater, with an effective date of March 23, 1996. The lawsuit filed by the Southwest Montana Building Industry Association (SWMBIA) was settled in 2005 for $5.1 million. The combined balance in the impact fee funds after payout of this settlement was slightly over $21.7 million. Fee collections and interest income over the subsequent years, netted against spending on eligible projects, brought the balance $ 23.9 million at the end of this fiscal year. The City Commission has budgeted approximately $8.5 million from those monies in the upcoming fiscal year for capacity expanding projects. Unified Development Ordinance. City Planning staff prepared a Unified Development Ordinance (UDO), which combines the zone code and subdivision regulations and is designed to expedite review processes and eliminate conflicts in regulations. On November 24, 2003, the City Commission adopted the new 187 7 (UDO) by a super-majority vote. The City Commission chose to provide an opportunity for members of the community to propose revisions to the document. Interested persons had a sixty (60) day period, which ended October 15, 2004, during which they submitted proposals for revisions and edits to the UDO. Additional amendments will be made in the future to address edits not already completed. Pay for Performance. During Fiscal Year 2001, City management instituted a pay for performance system for the management and mid-management positions. This program was temporarily suspended for Fiscal Year 2006 pending the outcome and findings of a study conducted by an outside consulting firm under the direction of a volunteer Management Compensation Committee representing a broad cross-section of management-level City employees. The study was completed this year, and a new compensation and performance evaluation system was implemented for City management. HB124. The 2001 Legislature dramatically revised the State’s funding mechanisms for local government. This bill included the combining of several State funding sources into a single entitlement program, with the revenues being distributed back to cities on a quarterly basis. This bill remained intact through the 2007 Legislature, despite several efforts to eliminate the inflationary increase. For the Future Water & Wastewater Facility Plans. In 2004 the City undertook the task of planning for the future of its water and wastewater infrastructure in order to meet the needs of its rapidly growing population. Independent consultants and engineers were contracted to prepare 20-year Water and Wastewater Facility Plans to evaluate the condition of existing water and sewer systems, analyze alternatives for improvements, and make recommendations along with providing estimated costs. Recommendations from the Water Conservation Study of 2002 were incorporated into these facility plans. Earlier this year the Commission adopted these plans, which call for investing $95 million in water system expansion and improvements and $55 million in wastewater expansion and improvements. The top water priority is the planning, design, and construction of a new Water Treatment Plant to be online in 5-8 years, estimated at $25.4 million. The plan also outlined an additional water storage, supply, and distribution projects that should be undertaken over the next 20 years. The plan identifies the design and construction of a new BNR (Biological Nutrient Removal) Wastewater Treatment Plant (initial phases estimated at roughly $33M) as the City’s highest wastewater priority. Comprehensive Water & Wastewater Rate Studies. In April of 2007, consulting engineers completed Water and Wastewater Rate studies which analyzed the revenue requirements, costs of service, and utility rate design for implementation of financing of the proposed Facility Plan improvements, including determining what portions would likely be funded with impact fees. Recommendations from these studies will be incorporated into the water and sewer rate structures for fiscal year 2008. Workforce Housing Ordinance On February 12, 2007, the Workforce Housing Task Force (WHTF) presented a workforce housing ordinance proposal to the City Commission. On February 22, 2007, the WHTF and the City Commission met in a special meeting in which the language, content, and methodology of the proposed ordinance were discussed. Staff was directed to determine the effects of the proposed ordinance on the Unified Development Ordinance. As of the end of this fiscal year the proposed ordinance had not been passed and was still under review. Landfill. Last year the Bozeman City Commission voted to discontinue commercial usage of the City landfill, including usage by the City’s own garbage trucks, and to limit usage of the landfill to just City residents. City garbage trucks therefore were required to haul trash to the County landfill in Logan. City Collection customers saw an 18% rate increase to cover the hauling costs and tipping fees at the County Landfill, more than 20 miles away. This year an Interlocal Agreement regarding the City joining the County Solid Waste Management District was signed by the City, County Commission, and Solid Waste Management District Board. This Agreement stipulates that the City’s landfill on Story Mill Road will close by June 30, 2008. In order to fill the remaining 188 8 airspace that exists at the City landfill, the Agreement stipulates that the City of Bozeman collection division will be permitted to divert Class II garbage, collected within the City, to the City Landfill. This will allow the landfill cell to be filled and the asset fully utilized prior to closing. Parking Structure. Last year the City approved a proposal for a downtown development that includes the design and construction of a three-story parking structure on the City’s parking lot at the intersection of North Tracy Avenue and East Mendenhall Street. The City has secured a variety of funding sources, including tax increment monies, a federal transportation appropriation, and City funds. The City advertised for and received bids on the Bozeman Intermodal Facility in the spring of this year, and the contract was subsequently awarded. Construction of the $9.2 million facility will commence in August of 2007 and is expected to continue for approximately one year. The City has advertised for and received bids on the Bozeman Intermodal Facility. Facility Timeline & Finance Plan. Several other large and important facility projects loom on the horizon, including relocation of the existing City Hall to the old library property, design and construction of a third Fire Station, a new Police and Court facility, a new City Shops Complex, and an Outdoor Aquatics Facility. 189 9 DEPARTMENTAL FOCUS Each year the City selects a department to highlight for its efforts and accomplishments. In 2007, the Bozeman Police Department has been selected for review. Bozeman Police Department The police department utilizes both patrol and investigative divisions to detect, prevent, and suppress crime and the enforcement of criminal and traffic codes of the state and local governments. The Parking and Animal Control officers within the Support Services Division provide enforcement of all parking and animal related offenses within the city limits of Bozeman. Bozeman’s size and population are growing at an unprecedented pace. The need for additional public safety professionals increases as the City expands. A 2007 staffing analysis identified the need for 13 additional officers in Bozeman to handle the growing demand based on increases in service population (32,360 in 2001 to over 41,000 in 2006), annexations into the city (13.7 square miles in 2001 to over 18 square miles in 2006) and calls for service (29,700 in 2001 to over 40,000 in 2006). Adequate staffing will increase and improve proactive police work, with an end goal that each officer is able to dedicate more of their time to proactive law enforcement. Increased officer visibility and availability deters violent crimes, reduces property crimes and maintains and improves a feeling of safety and security throughout neighborhoods and the business community. Adequate staffing also allows for consistent deployment of professional police officers directly into neighborhoods and business districts. Implementing police beats permits more balanced, flexible and effective deployment of patrol officers, thus enhancing officers’ relationships with the neighborhoods they serve and the unique challenges of each of the areas throughout the City of Bozeman. Response times to calls for service will be reduced. 190 10 Patrol Division Marty Kent is the Deputy Chief of Patrol. The Patrol Division of the Bozeman Police Department is comprised of 33 sworn, highly trained, professional police officers. They serve 24 hours a day, 7 days a week, providing the law enforcement emergency response needs for the citizens of Bozeman. The officers work (4) 10 hour shifts, working varying, overlapping hours to cover the busier days and busier times of the day. The current Field Training Evaluation Program consists of 15 weeks of training. All new police officers complete this program along with 12 weeks at the Montana Law Enforcement Academy. This ensures all new officers are fully capable and comfortable in performing their duties independently, legally and safely. K9 Patrol Over the past few years, the Bozeman Police Department K9's have contributed immensely in solving and deterring crime in Bozeman. Our K9 Officers and their K9's routinely assist in drug searches, building searches and tracks. Their experience and success are well-known and their skills are utilized by the Montana Highway Patrol, Gallatin County Sheriff's Office, Montana State University Police Department and Belgrade Police Department. K9 officers face a busy schedule. In addition to handling calls, they need to constantly train and maintain their K9 partners. A K9 needs 10-15 hours per week of continual training to keep their skills at the highest levels. Baths, runs and vet visits keep the K9 officer busy, much of the time done during the officer's day off. The K9's live with their partners and a true bond is developed between them. 191 11 Motorcycle Patrol The Bozeman Police Department's Motorcycle Patrol focuses on traffic enforcement and crash investigations. The Motorcycle Patrol also serves as traffic escorts at parades and other special events. The Motorcycle Patrol consists of four Motor Officers riding Harley Davidson Police Motorcycles. Each Motor Officer is trained by completing an 80 hour Police Motorcycle Operator School. Police Motorcycles are effective in congested traffic areas and are used extensively for speed limit enforcement in Bozeman. Motorcycle officers are instrumental in giving our department extra emphasis on enforcing traffic regulations, particularly around Bozeman schools. Investigation Division Mark Lachapelle is the Deputy Chief of Investigations. The primary responsibility of the Investigation Division is to investigate felony criminal matters and to assist other agencies on criminal investigations. Other general duties include, but are not limited to: background checks on individuals hired by the Bozeman Police Department and City of Bozeman, internal investigations, public talks and community education in various field ranging from forgery or robbery seminars, identity theft issues and dangerous drug educational classes. The Investigation Division currently consists of a Deputy Chief, a Detective Sergeant, six detectives, two School Resource Officers, one evidence technician and two full-time secretaries. 192 12 Special Response Team The goal of the Special Response Team (SRT) is to provide for the safety and protection of the people it serves by providing a highly coordinated, efficient response, directed toward concluding extraordinary or critical incidents in the safest manner possible. SRT's primary mission is to save lives. The team responds to critical incidents that may exceed the capabilities of patrol units such as armed barricaded suspects, hostage situations, and high risk warrant service. SRT conducts tactical training on a regular basis and many of the team members are certified instructors in their specialized areas of assignment. The SRT is an important asset to the police department and the community. Without this resource, our community would be dependent on teams from other distant cities for response to critical incidents. Congratulations to our SRT Members! In 2007, the Bozeman Police/Gallatin County SRT competed in the annual Mountain States Tactical Officer Association (MSTOA) team competition in Helena, Montana and placed first out of sixteen teams from our surrounding region. The competition consisted of physical agility, endurance, marksmanship and other tactical skills scored by highly skilled instructors. The competition was a serious test of the team's dedication, training, physical fitness and overall tactical abilities. After the MSTOA competition, the SRT was invited to the National SWAT Competition in Colorado. Our team took 6th place out of 10 other western United States tactical teams, including Dallas SWAT!! 193 13 Animal Control The Bozeman Police Department currently has 1 full time Animal Control Officer, Connie Lien, with some part-time assistance from a Parking officer, Kathy Middleton. Our approach to animal control is to utilize problem solving and education in handling animal complaints. When an animal is found at large or mistreated, we take the time to educate the pet owner in an effort to help develop respect for animal welfare. Connie has completed 30 years of outstanding service to the City of Bozeman as our full‐time Animal Control Officer. Connie has been instrumental in working relationships with the Heart of the Valley shelter, has handled hundreds of nuisance animal complaints, cruelty complaints and lost/found animals. Each year the circus comes to town, Connie is there to ensure the animals are being treated humanely, have adequate medical attention and are being fed. CONTACT THE BOZEMAN POLICE DEPARTMENT - bccf@bozeman.net DIRECTOR OF PUBLIC SAFETY Mark Tymrak mtymrak@bozeman.net DEPUTY CHIEF – PATROL DIVISION Marty Kent mkent@bozeman.net DEPUTY CHIEF – INVESTIGATIVE DIVISION Mark Lachapelle mlachapelle@bozeman.net Bozeman Police Department 615 South 16th Avenue Bozeman, Montana 59715 Phone: 406-582-2000 Mailing Address P.O. Box 1230 Bozeman, Montana 59971 Fax: 406-582-2002 194 14 FINANCIAL INFORMATION Management of the City is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the City are protected from loss, theft or misuse and to ensure that adequate accounting data are compiled to allow for the preparation of financial statements in conformity with generally accepted accounting principles. The internal control structure is designed to provide reasonable, but not absolute, assurance that these objectives are met. The concept of reasonable assurance recognizes that: (1) the cost of a control should not exceed the benefits likely to be derived; and (2) the valuation of costs and benefits requires estimates and judgments by management. Budgeting Controls In addition, the City maintains budgetary controls. The objective of these budgetary controls is to ensure compliance with legal provisions embodied in the Montana Code Annotated and the annual appropriation resolution approved by the City Commission. All fund types are included in the appropriation ordinance. The level of budgetary control (that is, the level at which expenditures cannot legally exceed the appropriated amount) is established at the fund group level. Cash Management Cash temporarily idle during the year was invested in short-term deposits, obligations of the U.S. Treasury, repurchase agreements and the state's short-term investment pool (STIP). The average yield on investments during the year was 4.55 percent. The City earned interest revenue of $2,704,003 on all investments for the year ended June 30, 2007. The City invests all funds in accordance with State law. Risk Management The City of Bozeman joined with over 100 other Montana cities and towns to form a self-insurance pool offering workers' compensation and liability coverage. Liability limits of $750,000 per person and $1.5 million per incident were obtained through the insurance pool. The pool, (renamed the Montana Municipal Insurance Authority (the Authority)), issued $4.41 million in tax-exempt bonds to fund the program's liability reserves. The City signed a note with the Authority for $289,304, its pro rata share of the debt, in order to help secure the bonds. In September 1990, the pool issued $7.61 million in tax-exempt bonds to fund the program's workers' compensation reserves. The City signed a note with the Authority for $402,114, its pro rata share of the debt, in order to help secure the bonds. The debt service on the bonds was expected to be paid through insurance premiums of the Authority. A refunding of the liability bonds was completed in 1993 and a refunding of the workers’ compensation bonds was completed in 1994. In December of 2006 the City received notice from the Authority that the 1993 refunding liability bonds had been completely retired. OTHER INFORMATION Independent Audit The State of Montana requires a biannual audit of the books of accounts, financial records, and transactions of all administrative departments of the City by independent certified accountants selected by the City Commission. It is the belief of the City Commission and Executive staff that an annual audit assures a higher level of financial management and fiscal responsibility. This policy, along with the legal requirements, has been complied with and the auditors' opinion of Junkermier, Clark, Campanella & Stevens P.C., has been included in this report. 195 15 Awards The Government Finance Officers' Association (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of Bozeman for its comprehensive annual financial report for the fiscal year ended June 30, 2006. This was the 23nd consecutive year that the City has received this prestigious award. In order to be awarded a Certificate of Achievement, the City published an easily readable and efficiently organized comprehensive annual financial report. This report satisfied both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. We believe our current comprehensive annual financial report continues to meet the Certificate of Achievement Program's requirement and we are submitting it to the GFOA to determine its eligibility for another certificate. Acknowledgements The preparation of the Comprehensive Annual Financial Report on a timely basis was made possible by the dedicated service of the entire staff of the Finance Department. Each member of the department has our sincere appreciation for the contributions made in the preparation of this report. In closing, without the leadership and support of the governing body of the City, preparation of this report would not have been possible. Sincerely, Chris Kukulski Anna Rosenberry, CPA Brian LaMeres, CPA City Manager Director of Finance City Controller 196 16 CITY OF BOZEMAN, MONTANA GOVERNMENT FINANCE OFFICERS’ ASSOCIATION CERTIFICATE 197 17 CITY OF BOZEMAN, MONTANA ORGANIZATIONAL CHART CITY CLERK CITY COMMISSION MUNICIPAL JUDGE VOTERS of THE CITY OF BOZEMAN DEPARTMENT OF FINANCE DEPARTMENT OF LAW DEPARTMENT OF PUBLIC SAFETY DEPARTMENT OF PUBLIC SERVICE DEPARTMENT OF PUBLIC WELFARE ASSISTANT CITY MANAGER CITY MANAGER 198 18 CITY OF BOZEMAN, MONTANA CITY ELECTED OFFICIALS AND OFFICERS ELECTED OFFICIALS Legislative Jeffrey Krauss Mayor Kaaren Jacobsen Commissioner Steven Kirchhoff Commissioner Sean Becker Commissioner Jeff Rupp Commissioner Judicial Karl Seel Municipal Judge OFFICERS Executive Chris Kukulski Brit Fontenot City Manager City Clerk Department of Law Paul J. Luwe City Attorney Susan Wordal Assistant City Attorney Timothy A. Cooper Assistant City Attorney Patricia Day-Moore Assistant City Attorney Department of Finance Anna Rosenberry, CPA Director of Finance Brian LaMeres, CPA Controller Laurae Clark Treasurer 199 19 CITY OF BOZEMAN, MONTANA CITY ELECTED OFFICIALS AND OFFICERS (CONTINUED) OFFICERS (CONTINUED) Department of Public Safety Mark Tymrak Director of Public Safety-Police Mark Lachapelle Assistant Director of Public Safety-Police Support Marty Kent Assistant Director of Public Safety-Police Patrol Chuck Winn Director of Public Safety-Fire Greg Megaard Assistant Director of Public Safety-Fire Inspections Department of Public Service Debra H. Arkell Director of Public Service Rick Hixson City Engineer John Alston Superintendent of Water and Waste Water Operations John Van Delinder Superintendent of Street Operations Steve Johnson Superintendent of Sanitation Operations Rick Moroney Superintendent of Water Treatment Plant Thomas Adams Superintendent of Waste Water Plant James Goehrung Superintendent of Facilities Department of Public Welfare Ron Dingman Sue Harkin Superintendent of Parks, Recreation & Cemetery Recreation Operations Superintendent Andrew Epple Director of Planning & Community Development Alice Meister Director of Library 200 PART II FINANC IAL SECTION 202 20 INDEPENDENT AUDITORS’ REPORT Honorable Mayor, City Commissioners, and City Manager of the City of Bozeman, Montana: We have audited the accompanying financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the City of Bozeman, Montana (the City), as of and for the year ended June 30, 2007, which collectively comprise the City’s basic financial statements as listed in the table of contents. These financial statements are the responsibility of the City of Bozeman's management. Our responsibility is to express opinions on these financial statements based on our audit. We additionally audited the 2006 financial statements of the Bozeman Public Library Foundation, Inc. (a discretely presented component unit of the City), which represents 100% of the assets and revenues of the discretely presented component unit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinions. In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business-type activities, each major fund, the aggregate remaining fund information and the discretely presented component unit of the City of Bozeman, Montana, as of June 30, 2007, and the respective changes in financial position and cash flows, where applicable, thereof for the year then ended in conformity with accounting principles generally accepted in the United States of America. In accordance with Government Auditing Standards, we have also issued our report dated December 26, 2007 on our consideration of the City of Bozeman's internal control over financial reporting and our tests of its compliance with certain provisions of laws, regulations, contracts and grant agreements and other matters. The purpose of that report is to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on the internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Audit Standards and should be considered in assessing the results of our audit. 204 21 The accompanying Management’s Discussion and Analysis and Budgetary Comparison Information, as listed on the table of contents, are not a required part of the basic financial statements but are supplementary information required by accounting principles generally accepted in the United States of America. We have applied certain limited procedures, which consisted principally of inquiries of management regarding the methods of measurement and presentation of the required supplementary information. However, we did not audit the information and express no opinion on it. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City of Bozeman, Montana’s basic financial statements. The combining and individual non-major fund financial statements and other schedules, listed in the table of contents as supplementary information, are presented for purposes of additional analysis and are not a required part of the basic financial statements. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by the U. S. Office of Management and Budget Circular A-133, Audit of States, Local Governments, and Non-Profit Organizations, and is not a required part of the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and, in our opinion, is fairly stated in all material respects in relation to the basic financial statements taken as a whole. The accompanying introductory and statistical sections, as listed in the table of contents, are presented for purposes of additional analysis and are not a required part of the basic financial statements. This information has not been subjected to the auditing procedures applied in the audit of the basic financial statements and, accordingly, we express no opinion on them. Junkermier Clark Campanella & Stevens P.C. Bozeman, Montana December 26, 2007 205 A. MANAGEMEN T ’S DISCUSSION AND ANALYSIS 206 22 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS Our discussion and analysis of the City of Bozeman’s financial performance provides an overview of the City’s financial activities for the fiscal year ended June 30, 2007. Please read it in conjunction with the transmittal letter on page 1 and the City’s financial statements, which begin on page 32. USING THIS ANNUAL REPORT This annual report consists of a series of financial statements. The Statement of Net Assets and the Statement of Activities (on pages 32 and 33) provide information about the activities of the City as a whole and present a longer-term view of the City’s finances. Fund financial statements start on page 34. For governmental activities, these statements tell how these services were financed in the short term as well as what remains for future spending. Fund financial statements also report the City’s operations in more detail than the government-wide statements by providing information about the City’s most significant funds. The remaining statements provide financial information about activities for which the City acts solely as a trustee or agent for the benefit of those outside of the government. Reporting the City as a Whole The Statement of Net Assets and the Statement of Activities Our analysis of the City as a whole begins on page 24. One of the most important questions asked about the City’s finances is, ―Is the City as a whole better off or worse off as a result of the year’s activities?‖ The Statement of Net Assets and the Statement of Activities report information about the City as a whole and about its activities in a way that helps answer this question. These statements include all assets and liabilities using the accrual basis of accounting, which is similar to the accounting used by most private-sector companies. All of the current year’s revenues and expenses are taken into account regardless of when cash is received or paid. These two statements report the City’s net assets and changes in them. You can think of the City’s net assets, the difference between assets, what the citizens own, and liabilities, what the citizens owe, as one way to measure the City’s financial health, or financial position. Over time, increases or decreases in the City’s net assets are one indicator of whether its financial health is improving or deteriorating. You will need to consider other nonfinancial factors, however, such as changes in the City’s property tax base, income tax base, and the condition of the City’s capital assets (roads, buildings, water and sewer lines) to assess the overall health of the City. In the Statement of Net Assets and the Statement of Activities, we divide the City into two kinds of activities: Governmental activities—Most of the City’s basic services are reported here, including police, fire, public works, parks, and general administration. Property taxes, state shared revenues, court fines, and recreation fees finance most of these activities. Business-type activities—The City charges a fee to customers to help it cover all or most of the cost of certain services it provides. The City’s water, sewer, and solid waste systems are reported here. 207 23 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) Reporting the City’s Most Significant Funds Fund Financial Statements Our analysis of the City’s funds begins on page 28. The fund financial statements begin on page 34 and provide detailed information about the most significant funds, not the City as a whole. Some funds are required to be established by State law and by bond covenants. However, the City Commission establishes many other funds to help it control and manage money for particular purposes (like Street Maintenance District Funds) or to show that it is meeting legal responsibilities for using certain taxes, grants, and other money (like grants received from the Environmental Protection Agency). The City’s two kinds of funds, governmental and proprietary, use different accounting approaches. Governmental funds--Most of the City’s basic services are reported in governmental funds, which focus on how money flows into and out of those funds and the balances left at year-end that are available for spending. These funds are reported using an accounting method called modified accrual accounting, which measures cash and all other financial assets that can readily be converted to cash. The governmental fund statements provide a detailed short-term view of the City’s general government operations and the basic services it provides. Governmental fund information helps you determine whether there are more or fewer financial resources that can be spent in the near future to finance the City’s programs. We describe the relationship (or differences) between governmental activities (reported in the Statement of Net Assets and the Statement of Activities) and governmental funds in reconciliation on pages 36 and 38 of the fund financial statements. Proprietary funds--When the City charges customers for the services it provides, whether to outside customers or to other units of the City, these services are generally reported in proprietary funds. Proprietary funds are reported in the same way that all activities are reported in the Statement of Net Assets and the Statement of Activities. In fact, the City’s enterprise funds (a component of the proprietary funds) are the same as the business-type activities we report in the government-wide statements but provide more detail and additional information, such as cash flows, for proprietary funds. We use internal service funds (the other component of proprietary funds) to report activities that provide supplies and services for the City’s other programs and activities, such as the Vehicle Maintenance Fund and Health Insurance Fund. Internal service fund activity is reported as governmental activity in the government-wide statements since this activity, the financing of goods and services for other funds of the government, is more governmental than business-type in nature. The City as Trustee Reporting the City’s Fiduciary Responsibilities The City is the trustee, or fiduciary, for other funds, including the Municipal Court Fund and the Montana Arts Council funds for the Montana Ballet, the Bozeman Symphony Orchestra and the Big Sky Association for the Arts. It is also responsible for other assets that, because of a trust arrangement, can be used only for the trust beneficiaries. The guidelines for the administration of these funds are contained in applicable financial agreements and/or City ordinances. These documents contain the rules governing the receipt, expenditure, and management of the City’s fiduciary funds. All of the City’s fiduciary activities are reported in the Statement of Fiduciary Net Assets on page 44 and in the Combining Statement of Changes in Assets and Liabilities-Agency Funds on pages 117-118. As the statements reflect, the financial activity during the year for these funds is nominal. We exclude these activities from the City’s other financial statements because the City cannot use these assets to finance its operations. The City is responsible for ensuring that the assets reported in these funds are used for their intended purposes. 208 24 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) THE CITY AS A WHOLE The City’s combined net assets increased by $186.1 million this year as compared to a $15.2 million increase last year. The primary reason for this large increase over last year is the addition of infrastructure required under GASB Statement 34 which had previously not been booked. Refer to Note 27 on page 80 in the Notes to the Financial Statements for more information. Beyond that, looking at the net assets of governmental and business-type activities separately, two slightly different stories emerge. Our analysis focuses on the net assets (Table 1) and changes in net assets (Table 2) of the City’s governmental and business-type activities. Net assets of the City’s governmental activities increased by 98.8% ($106.7 million compared to $53.7 million). Unrestricted net assets of governmental activities, the part of net assets that can be used to finance day-to-day operations without constraints established by debt covenants, enabling legislation or other legal requirements, increased to $20.7 million. The net assets of our business-type activities increased by 243.5%, ($187.9 million compared to $54.7 million) in 2007. These net assets cannot be used to make up for deficits reported by governmental activities in the event any such deficits were reported. The City generally can only use the net assets of business-type activities to finance the continuing operations of the water, sewer and solid waste operations. 2007 2006 2007 2006 2007 2006 Current and Other Assets 33.5$ 36.7$ 37.7$ 30.4$ 71.2$ 67.1$ Capital Assets 90.3 36.6 154.5 29.1 244.7 65.7 Total Assets 123.8$ 73.3$ 192.2$ 59.5$ 316.0$ 132.8$ Long-term Debt Outstanding (12.2) (13.4) (15.3) (3.3) (27.5) (16.7) Other Liabilities (4.9) (6.2) (6.1) (1.5) (11.0) (7.7) Total Liabilities (17.1)$ (19.6)$ (21.4)$ (4.8)$ (38.5)$ (24.4)$ Net Assets: Invested in Capital Assets, net of related debt 77.7 23.0 154.2 28.4 232.0 51.4 Restricted for capital projects 7.8 4.7 18.2 12.5 25.9 17.2 Restricted for debt service - - 0.9 0.9 0.9 0.9 Restricted for parking projects - - - - - - Restricted for cemetery care 0.5 0.5 - - 0.5 0.5 Unrestricted 20.7 25.5 14.6 12.9 35.3 38.4 Total Net Assets 106.7$ 53.7$ 187.9$ 54.7$ 294.6$ 108.4$ Governmental Activities Table 1 Net Assets (in Millions) Total Primary Government Business-type Activities 209 25 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) The City’s total revenues (excluding special items) increased by 78.5% ($42.3 million). The total cost of all programs and services increased by 34.3%, or $13.3 million. The City was again able to cover the year’s costs in both governmental activities and business-type activities. Our analysis below separately considers the operations of governmental and business-type activities. 2007 2006 2007 2006 2007 2006 Revenues Program revenues: Charges for Services 11.8$ 13.4$ 18.1$ 16.4$ 29.9$ 29.8$ Federal Grants 1.0 1.9 0.3 1.6 1.3 3.5 General Revenues Property Taxes 11.8 11.1 - - 11.8 11.1 Unrestricted Grants & Contributions 5.1 5.2 - - 5.1 5.2 Other General Revenues 21.9 4.3 26.2 - 48.1 4.3 Total Revenues 51.6 35.9 44.6 18.0 96.2 53.9 Program Expenses General Government 5.3 5.1 - - 5.3 5.1 Public Safety 10.5 9.9 - - 10.5 9.9 Public Service 8.5 4.2 - - 8.5 4.2 Public Welfare 5.5 5.5 - - 5.5 5.5 Other 0.4 0.6 - - 0.4 0.6 Interest and Fiscal Fees 0.5 0.5 - - 0.5 0.5 Water - - 10.5 4.8 10.5 4.8 Waste Water - - 7.4 4.6 7.4 4.6 Solid Waste - - 3.3 3.5 3.3 3.5 Total Expenses 30.8 25.8 21.2 12.9 52.0 38.7 Excess (deficiency) before special items and transfers 20.8 10.1 23.4 5.1 44.2 15.2 Prior Period Adjustments 31.7 - 110.2 - 141.9 - Transfers 0.5 1.8 (0.5) (1.8) - - Increase (decrease) in net assets 53.0$ 11.9$ 133.1$ 3.3$ 186.1$ 15.2$ Activities Activities Primary Government Table 2 Changes in Net Assets (in Millions) Governmental Business-type Total 210 26 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) Governmental Activities Revenues for the year from governmental activities increased 43.9% ($15.7 million), and total expenses increased by 19.5% ($5.0 million). The increase in net assets for governmental activities was $53.0 million in 2007. This compares to a $11.9 million increase in net assets in 2006. Property Tax collections increased by $631,793, or 5.6%, from $11,222,034 last year to $11,853,827 this year. This is due primarily to an increase in the City’s taxable value due to new construction and the continuing effects of the reappraisal conducted by the State of Montana. Intergovernmental revenues decreased significantly by $930,342 or 13.2%, from $7,046,039 last year to $6,115,697 this year. This decrease was due primarily to an decrease in federal grant revenue. Prior year grant revenues that did not reoccur in the current year include the Story Mansion Exterior Rehabilitation grant, the CDBG Reach Work Center grant, and the Section 8 housing grant for Accessible Space Incorporated. Fines and forfeitures increased by $284,815, or 19.5% from $1,461,398 last year to $1,746,213 this year. This increase reflects the continued impact of the Police Officer staffing level returning to normal after the department suffered major personnel shortages in 2004 years ago due to Iraq war call-ups. Fines and forfeitures were $435,000 less in 2004 than this year. Interest on Investments increased significantly by $219,893, or 25.9%, from $848,909 last year to $1,068,802 this year. This increase is attributable to a continuing increase in interest rates over the past two years. Interest rates on investment income averaged 4.6% this year compared to 4.2% last year and 2.3% in the prior year. The cost of all governmental activities this year was $30.8 million compared to $25.8 million last year. However, as shown in the Statement of Activities on page 33, the amount that our taxpayers ultimately financed for these activities through City taxes was only $17,997,702 because some of the cost was paid by those who directly benefited from the programs ($11,802,284) or by other governments and organizations that subsidized certain programs with operating and capital grants and contributions ($1,019,974). Overall, the City’s revenues from governmental activities, including intergovernmental revenues and charges for services increased significantly in 2007 from $35.9 to $51.6 million. Charges for services increased significantly due to increased street impact fee revenue, investment income increased significantly due to higher interest rates, and fine revenue continued to increase due to a return to full police staffing levels. However, the large increase was due mostly to the retroactive booking of pre-2003 infrastructure as per GASB Statement 34. Table 3 presents the cost of each of the City’s six largest programs—Police, Fire, Public Service, Library, Parks and Recreation—as well as each program’s net cost (total cost less revenues generated by the activities). The net cost shows the financial burden that was placed on the City’s taxpayers by each of these functions. 211 27 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) 2007 2006 2007 2006 Police 5.1$ 4.6$ 3.3$ 2.8$ Fire 3.3 3.0 3.1 2.4 Public Service 8.5 4.2 5.2 2.0 Library 1.2 1.2 0.7 0.7 Parks 1.5 1.0 1.5 1.0 Recreation 1.0 0.8 0.5 0.3 All Others 10.1 11.0 3.7 1.2 Totals 30.8$ 25.8$ 18.0$ 10.6$ of Services of Services Table 3 Governmental Activities (in Millions) Total Cost Net Cost Business-type Activities Revenues of the City’s business-type activities (see Table 2) increased by 147.5% ($44.6 million in 2007 compared to $18.0 million in 2006) and expenses increased by 64.0% ($21.2 million in 2007 compared to $12.9 million in 2006). The factors driving these results include: The City’s water system revenues have steadily increased over the past decade as a result of an increase in the customer base and as a result of regular rate changes, including a 10% increase this year. Operating revenues for the year amounted to $6,124,533. In addition, water impact fee revenues amounted to $1,592,670. Operating expenses totaled $10,467,420. Major projects completed during the year include completing the Water Facility Plan and the replacement of the obsolete concrete-based Hyalite Water Transmission Main with a state-of-the-art Transmission Main, which will not only allow more water to flow from the reservoir to the treatment plant, but will also decrease the amount of sediment and contaminants that had accumulated in this water due to the composition of the old main. Grant revenues totaling $280,000 were received this year to help offset the cost of this project. Other projects, some ongoing, include updating the water capital improvement program, over $300,000 spent on general water system renovations, and several studies, including a Water Rate study and a Water Impact Fee study. The City’s wastewater system revenues have similarly increased due to a growing customer base in addition to increases attributable to the rate changes in prior years that were necessary in order to restore the financial position of the wastewater fund caused by remediation of the Solvent Site groundwater contamination. Additionally, a 10% rate increase was implemented this year. Operating revenues for the year amounted to $4,262,052. In addition, impact fee revenues amounted to $1,959,935. Wastewater operating expenses totaled $7,376,348. Major projects during the year included the completion of the Wastewater Facility Plan and spending over $250,000 on upgrades to the Wastewater Treatment Plant. Other projects, some ongoing, include updating the wastewater capital improvement program and several studies, including a Wastewater Rate study and a Wastewater Impact Fee study. 212 28 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) The City’s solid waste collection and disposal system revenues have declined steadily over the past couple years due to a policy change that excludes all commercial dumping at the landfill and limits landfill customers to just City residents. However, as discussed on page 76, there has been a change in this policy which could affect revenues for next year. Operating revenues for the year amounted to $2,037,349. Operating expenses totaled $3,283,135. Fortunately revenues over the prior decade had increased steadily due to an increasing customer base and Bozeman’s economic growth, and this allowed for revenues in excess of operating costs to accumulate for the purpose of meeting the City’s obligation with respect to the EPA requirements for landfill closure and post-closure care. Any additional excess revenues will be used to provide an alternative to the existing landfill operation, which will be reaching full capacity and closing at the end of next year. THE CITY’S FUNDS As the City completed the year, its governmental funds (as presented in the balance sheet on pages 34-35) reported a combined fund balance of $20,572,698. Included in this year’s total change in fund balance is a positive General Fund balance of $4,370,538. The primary reasons for the General Fund’s surplus are highlighted further below. In addition, these other causes of changes in fund balances should be noted: Capital Outlay expenditures decreased by $6,977,286, or 37.9%, from $18,374,651 last year to $11,397,365 this year. This decrease was due primarily to major projects in the prior year being completed and not recurring this year, including the purchase of right-of-way property and re-construction of Durston Road, West Babcock road construction, the completion of the new Public Library building, and road improvements and signal installation along Valley Center Road and North 19th Avenue. Public Welfare expenditures decreased significantly by $784,787 or 15.4%, from $5,099,873 last year to $4,315,086 this year. However, most of this decrease was due two federal grant projects which had activity last year but none this year. Approximately $913,000 was spent last year on the CDBG Reach Work Center project and the Accessible Space Section 8 housing project with nothing being spent this year. However, all of this spending last year was reimbursed by federal grant revenue, so there was no effect on fund balance – both expenditures and revenues decreased by the same amount this year. General fund budgetary highlights The City’s general fund balance increased from $4,008,287 in fiscal year 2006 to $4,370,538 this year. Some of this $362,251, or 9%, increase was due to personnel vacancy savings in the Recreation Department and some of it was due to the Bogert Park Pavilion rehabilitation being funded by an insurance reimbursement instead of money from the general fund. This year’s fund balance of $4,370,538 represents 28.3% of general fund operating revenues of $15,981,556 which is in compliance with the City Charter and GFOA recommendations. Other reasons for the increase in general fund balance include an increase in all revenues associated with the growing community. This includes property taxes, discussed on page 26, which were affected not just by new construction, but also by an increase the City’s population and mill value. The mill value increased 8.9%, from $58,063 last year to $63,249 this year. Other community related general fund revenues also showed gains, including licenses and permits, fines and forfeitures, and recreational revenues. 213 29 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) Also contributing to the increased General Fund balance is the utilization of conservative budgetary practices. Conservative, yet realistic, revenue estimates, combined with departments operating within their original budgets, naturally has a favorable effect on the bottom line. Maintaining adequate reserves has several internal and external benefits. Internally, reserves can provide for cash flow needs until property tax revenues are received, reducing or eliminating the need for cash flow borrowing; provide funds to leverage state or federal grants; and provide for the unexpected. Externally, reserves tend to be viewed favorably by investors, rating agencies, and local banks with which we do business, thus benefiting rating and the potential need for lines of credit. The City’s General Fund balance was the primary focus during the bond rating for the 2003 refinancing of the City’s General Obligation Transportation Bonds and the remaining bonds issued in 2003 for the new Library. It was also the focus of the pooled 2007 Special Improvement District (SID) bonds for Valley Center Road and North 19th Avenue. In each of these instances, bond analysts looked favorably on the amount and trend of the City's General Fund balance in determining the City’s bond rating. CAPITAL ASSET AND DEBT ADMINISTRATION Capital Assets As shown in Table 4, at the end of 2007 the City had $244.7 million invested in a broad range of capital assets, including police and fire equipment, buildings, park facilities, roads, and water and sewer lines. This amount represents a net increase (including additions and deductions) of roughly $179.0 million, or 272.5% over last year. As discussed, this dramatic increase is due mainly to the required booking of infrastructure as per GASB Statement 34. 2007 2006 2007 2006 2007 2006 Land 7.8$ 7.1$ 4.6$ 4.6$ 12.4$ 11.7$ Water Rights - - 0.3 0.3 0.3 0.3 Buildings 22.8 19.0 10.0 9.7 32.8 28.7 Other Structures and Improvements 1.2 1.1 30.3 30.0 31.5 31.1 Machinery & Equipment 7.4 6.8 5.9 5.6 13.3 12.4 Property under Capital Lease 0.2 0.2 - - 0.2 0.2 Vehicle 2.7 2.2 1.7 1.8 4.4 4.0 Infrastructure 95.7 27.3 203.1 17.9 298.8 45.2 Subtotal 137.7 63.7 256.0 69.9 393.7 133.6 Accumulated Depreciation (47.4) (27.1) (101.5) (40.8) (149.0) (67.9) Total Capital Assets 90.3$ 36.6$ 154.5$ 29.1$ 244.7$ 65.7$ Totals Table 4 Capital Assets at Year-end (in Millions) Governmental Activities Business-type Activities June 30, 2006 Additions Disposals June 30, 2007 Governmental Activities: Land 7,144,251$ 605,948$ -$ 7,750,199$ Buildings 18,977,773 3,831,092 - 22,808,865 Other structures and improvements 1,115,579 85,497 - 1,201,076 Machinery and equipment 6,794,105 598,678 - 7,392,783 Property under capital lease 154,992 - - 154,992 Vehicles 2,231,651 428,340 - 2,659,991 Infrastructure 27,258,409 68,476,421 - 95,734,830 Total 63,676,760 74,025,976 - 137,702,736 Accumulated depreciation (27,103,451) (20,333,812) - (47,437,263) Total governmental activities 36,573,309$ 53,692,164$ -$ 90,265,473$ Business-type Activities: Land 4,631,358$ -$ -$ 4,631,358$ Water rights 263,494 - - 263,494 Buildings 9,720,973 302,353 - 10,023,326 Other structures and improvements 30,027,302 315,567 - 30,342,869 Machinery and equipment 5,545,487 401,483 - 5,946,970 Vehicles 1,771,229 52,574 (117,136) 1,706,667 Infrastructure 17,933,215 185,134,001 - 203,067,216 Total 69,893,058 186,205,978 (117,136) 255,981,900 Accumulated depreciation (40,776,631) (60,868,411) 117,136 (101,527,906) Total business-type activities 29,116,427$ 125,337,567$ -$ 154,453,994$ Total capital assets 65,689,736$ 179,029,731$ -$ 244,719,467$ 214 30 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) This year’s major additions and projects underway include: Streets & other Street Infrastructure - contributed by Developers 18,328,625$ Wastewater Lines & other Wastewater Infrastructure - contributed by Developers 13,772,623 Water Lines & other Water Infrastructure - contributed by Developers 12,411,654 New Bozeman Public Library Facility - completion of project 3,140,988 Durston Road Special Improvement District construction - west of North 19th Avenue 2,542,010 Durston Road GO Transportation Bond reconstruction: 7th Avenue - North 19th Avenue 2,344,135 Bogert Park Pavilion repair, rehabilitation, and sprinklerization 508,253 Acquisition and consultant costs of new City Property, including 214 East Lamme 464,840 Valley Center Road & North 19th Avenue improvements and signalization - completion of project 392,987 Gas Tax Road Improvements 355,143 Hyalite Transmission Main - completion of project 309,322 54,570,580$ The City’s fiscal year 2008 capital budget calls for the City to spend over $18.5 million on capital equipment and capital projects. Some of the major projects include: Construction of new downtown Intermodal Parking Facility ($9,200,000); Impact Fee funded street improvements ($1,460,000); and Water System improvements on Lamme Street ($1,000,000). More detailed information about the City’s capital assets is presented in Note 7 to the financial statements. Debt At year-end, the City had $12.9 million in bonds and notes outstanding versus $14.7 million last year – a decrease of 12.4% – as shown in Table 5. General obligation debt consists of $2,575,000 in refinanced 1995 Transportation Project bonds and $ 3,265,000 in Library Project bonds. There was no new general obligation debt or special improvement debt issued during the fiscal year. The City’s general obligation bonds continue to maintain a rating of A2 from Moody’s Investor Service. According to Moody’s, the A2 rating reflects the City's stable tax base and local economy, healthy financial operations, and manageable debt burden. Moody's expects the City to maintain a healthy financial position, given the City's historical performance and management's commitment to maintaining satisfactory reserve levels. As expressed in the fiscal year 2008 budget document, City officials expect to end next fiscal year with general fund reserves of at least 15.85% of operating revenues, which exceeds the minimum requirements of the City Charter and the recommendations of GFOA. Property taxes are the are the City's primary general revenue source (35.1%), followed by charges for services (21.9%), intergovernmental (18.1%), and special assessments (5.5%). Moody's expects the City to maintain a moderate debt position given current moderate debt burdens, above average principal payout, and expected tax base growth. More detailed information about the City’s long-term liabilities is presented in Note 9 to the financial statements. 215 31 CITY OF BOZEMAN, MONTANA MANAGEMENT’S DISCUSSION AND ANALYSIS (CONTINUED) 2007 2006 2007 2006 2007 2006 General obligation bonds (backed by the City)5.8$ 6.3$ -$ -$ 5.8$ 6.3$ Special Improvement District Debt 6.7 7.0 - - 6.7 7.0 Notes Payable 0.1 0.2 - - 0.1 0.2 Lease Payable - - - - - - Water Revenue Bonds (backed by specific fee revenues)- - 0.2 1.2 0.2 1.2 Totals 12.7$ 13.5$ 0.2$ 1.2$ 12.9$ 14.7$ Totals Table 5 Outstanding Debt, at Year-end (in Millions) Governmental Activities Business-type Activities ECONOMIC FACTORS AND NEXT YEAR’S BUDGETS AND RATES The City’s elected and appointed officials considered many factors when setting the fiscal year 2006-2007 budget, tax rates, and fees that will be charged for the business-type activities. Some of these factors includes: capital improvements identified in the City’s Capital Improvement Program; inflation rates, the City’s collective bargaining units, the local economy, and the citizen’s ability to pay. For the year, inflation rates continued to remain at relatively low levels. Inflation in the first half of calendar year 2007 has averaged a moderate 2.6% compared to 2.5% in 2006. However, inflation has risen in the second half of the year and this could adversely impact the cost of City capital projects. When evaluating the cost of living, the City utilizes the national CIP indexes. The City adopted its first fully-funded Capital Improvements Program approximately eight years ago and it is currently in the process of being updated. In order to finance the needed improvements, the City enacted a number of ―higher than normal‖ rate changes to provide the funding for these improvements. These rate changes are now contained in the current rate structures and only modest rate changes are anticipated in the foreseeable future, in order to keep pace with rising costs. CONTACTING THE CITY’S FINANCIAL MANAGEMENT This financial report is designed to provide our citizens, taxpayers, customers, and investors and creditors with a general overview of the City’s finances and to show the City’s accountability for the money it receives. If you have questions about this report or need additional information, contact the City’s Finance Director or Controller, at the City of Bozeman, 411 East Main Street, Bozeman, Montana 59715. 216 B. BASIC FINANCIAL STATEMENTS 217 GOVERNMENT - WIDE FINANCIAL STATEMENTS 219 32 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF NET ASSETS JUNE 30, 2007 Primary Government Component Unit Governmental Activities Business-typeActivities Total Bozeman Public Library Foundation ASSETS Cash and investments 12,444,323$ 16,889,028$ 29,333,351$ 587,352$ Restricted cash and investments 7,815,285 19,086,533 26,901,818 - Accrued interest 79,730 204,901 284,631 - Receivables, net 10,895,944 1,537,656 12,433,600 453,244 Notes receivable 1,082,992 36,000 1,118,992 - Prepaid expenses 1,157,276 - 1,157,276 6,079 Deferred charges 91,938 - 91,938 - Capital assets Non-depreciable land 7,750,199 4,631,358 12,381,557 - Other capital assets, net of depreciation 82,515,274 149,822,636 232,337,910 13,165 Total capital assets 90,265,473 154,453,994 244,719,467 13,165 Total assets 123,832,961$ 192,208,112$ 316,041,073$ 1,059,840$ LIABILITIES Accounts payable and accrued expenses 2,447,674$ 845,339$ 3,293,013$ 1,460$ Fiduciary fund payable 11,566 - 11,566 - Unearned revenue 643,260 - 643,260 - Current portion of long-term liabilities Compensated absences payable 795,000 256,000 1,051,000 - Capital leases 83,256 - 83,256 - Bonds and notes 914,898 82,867 997,765 - Long-term liabilities, due in more than one year Compensated absences 433,134 118,167 551,301 - Solvent site remediation liability - 435,000 435,000 - Closure and post-closure care costs - 2,449,511 2,449,511 - Bonds and notes 11,741,000 143,593 11,884,593 - Total liabilities 17,069,788$ 4,330,477$ 21,400,265$ 1,460$ NET ASSETS Invested in capital assets, net of related debt 77,734,584$ 154,227,534$ 231,962,118$ -$ Restricted for expendable purposes:- Restricted for impact capital projects - 16,171,146 16,171,146 - Restricted for debt service - 928,720 928,720 - Restricted for parking capital projects 19,694 - 19,694 - Restricted for cemetery care 527,222 - 527,222 - Restricted for library operations and capital outlay - - - 834,969 Unrestricted 28,481,673 16,550,235 45,031,908 223,411 Total net assets 106,763,173$ 187,877,635$ 294,640,808$ 1,058,380$ 221 33 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF ACTIVITIES Year Ended June 30, 2007 Net (Expense) Revenue and Changes in Net Assets Operating Capital Component Unit Charges for Grants and Grants and Governmental Business-type Bozeman Public Expenses Services Contributions Contributions Activities Activities Total Library Foundation Primary Government: Governmental activities: General government 5,322,040$ 2,023,362$ 57,750$ 30,688$ (3,210,240)$ (3,210,240)$ Public safety 10,488,873 3,712,280 351,513 - (6,425,080) (6,425,080) Public service 8,511,308 5,361,852 - 300,079 (2,849,377) (2,849,377) Public welfare 5,536,741 704,790 - - (4,831,951) (4,831,951) Other 411,331 - - - (411,331) (411,331) Interest and fiscal fees 549,667 - - - (549,667) (549,667) Total governmental activities 30,819,960 11,802,284 409,263 330,767 (18,277,646) (18,277,646) Business-type activities: Water 10,490,811 8,604,498 - 279,944 (1,606,369)$ (1,606,369) Waste water 7,376,348 7,052,987 - - (323,361) (323,361) Solid waste 3,283,135 2,428,230 - - (854,905) (854,905) Total business-type activities 21,150,294 18,085,715 - 279,944 (2,784,635) (2,784,635) Total primary government 51,970,254$ 29,887,999$ 409,263$ 610,711$ (18,277,646) (2,784,635) (21,062,281) Component Unit: Bozeman Public Library Foundation 3,099,095$ -$ -$ 270,213$ (2,828,882)$ General revenues: Property taxes 11,836,748 - 11,836,748 - Unrestricted grants and contributions 5,375,807 3,182 5,378,989 152,683 Investment earnings 1,093,115 - 1,093,115 83,903 Miscellaneous 1,940,156 - 1,940,156 - Donated capital assets 18,363,608 26,184,278 44,547,886 Sale of capital assets 490,637 - 490,637 - Transfers 489,780 (489,780) - - Total general revenues and transfers 39,589,851 25,697,680 65,287,531 236,586 Change in net assets 21,312,205 22,913,045 44,225,250 (2,592,296) Net assets, beginning of the year 53,768,028 54,777,821 108,545,849 3,650,676 Prior period adjustment 31,682,940 110,186,769 141,869,709 - Net assets, end of the year 106,763,173$ 187,877,635$ 294,640,808$ 1,058,380$ Functions/Programs Primary Government Program Revenues 222 FUND FINANCIAL STATEMENTS 223 GOVERNMENTAL FUND FINANCIAL STATEMENTS 225 MAJOR GOVER N MENTAL FUNDS General Fund – this fund accounts for the financial operations of the City which are not accounted for in any other fund. Principal sources of revenue are property taxes, state and local shared revenues, licenses and permits, and charges for services provided to other funds. Principal expenditures in the general fund are made for police and fire protection, public works, and general government. SID Sinking Debt Service Fund – Accounts for the accumulation of resources and payment of special assessment bond principal and interest related to general improvement, sidewalk, and curb construction projects. General Improvements Capital Projects Fund – Accounts for the construction of general improvement projects financed by special assessments other than those financed by proprietary funds. 227 34 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. BALANCE SHEET GOVERNMENTAL FUNDS June 30, 2007 Street and Fire SID Other Total General Impact Fees Sinking Capital Governmental Governmental Fund Special Revenue Debt Service Projects Funds Funds ASSETS Cash and investments 2,502,048$ -$ 1,399,887$ 939,411$ 7,519,378$ 12,360,724$ Receivables: Property taxes 863,528 - - - 317,237 1,180,765 Accrued interest 12,740 45,135 - 21,855 - 79,730 Customers, net 561,638 - - - 62,585 624,223 Special assessments 198 - 8,204,032 - 127,526 8,331,756 Other governments 63,839 - - - 683,028 746,867 Prepaid expenditures 3,000 - - - 522,750 525,750 Due from other City funds 2,247,401 - 10,695 - 2,888 2,260,984 Notes receivable - - - - 1,082,992 1,082,992 Restricted cash and investments - 7,770,591 - - 44,694 7,815,285 Total assets 6,254,392$ 7,815,726$ 9,614,614$ 961,266$ 10,363,078$ 35,009,076$ (continued) 229 35 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. BALANCE SHEET GOVERNMENTAL FUNDS (CONTINUED) June 30, 2007 Street and Fire SID Other Total General Impact Fees Sinking Capital Governmental Governmental Fund Special Revenue Debt Service Projects Funds Funds LIABILITIES AND FUND BALANCES Liabilities: Accounts payable 1,136,442$ 7,374$ 40,624$ 779,979$ 404,534$ 2,368,953$ Accrued employee benefits 19,515 - - - 18,150 37,665 Deferred revenue 687,914 - 8,119,470 - 1,274,180 10,081,564 Escheat property payable 28,417 - - - 626 29,043 Due to other City funds 11,566 - - 499,609 1,407,978 1,919,153 Total liabilities 1,883,854 7,374 8,160,094 1,279,588 3,105,468 14,436,378 Fund balances: Reserved for: Cemetery perpetual care - - - - 527,222 527,222 Park development - - - 353,886 353,886 Debt service - - 1,454,520 - 572,334 2,026,854 Prepaid items 3,000 - - - 522,750 525,750 Unreserved 4,367,538 - - (318,322) - 4,049,216 Unreserved, reported in nonmajor Special revenue funds - 7,808,352 - - 5,396,976 13,205,328 Debt service funds - - - - (115,558) (115,558) Total fund balances 4,370,538 7,808,352 1,454,520 (318,322) 7,257,610 20,572,698 Total liabilities and fund balances 6,254,392$ 7,815,726$ 9,614,614$ 961,266$ 10,363,078$ 35,009,076$ 230 36 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. RECONCILIATION OF THE BALANCE SHEET TO THE STATEMENT OF NET ASSETS - GOVERNMENTAL FUNDS As of June 30, 2007 Fund balances - total governmental funds 20,572,698$ Amounts reported for governmental activities in the statement of net assets are different because: Capital assets used in governmental activities are not financial resources and therefore are not reported in the governmental funds. Governmental capital assets 137,702,736$ Less: accumulated depreciation (47,437,263) 90,265,473 Internal service funds are used by management to charge the costs of certain activities to individual funds. The assets and liabilities of the internal service funds that are reported in the governmental activities: Net assets 385,759 Less: capital assets included in governmental activities (169,172) Plus: accumulated depreciation included in governmental activities 136,101 Plus: compensated absences included in governmental activities 9,360 362,048 Deferred revenue in the governmental funds are reported on the full accrual method in the government-wide financial statements.9,890,246 Bond issuance costs are expensed in the governmental funds. They are deferred charges for the government-wide financial statements and amortized over the life of the issuance. Bond issuance costs 115,859 Less: amortization (23,921) 91,938 Impact fee credits do not affect current financial resources and therefore are not reported in the governmental funds.(451,942) Capital lease obligations not recorded in the governmental funds are reported in (83,256) the entity-wide financial statements. Long-term liabilities, are not due and payable in the current period and therefore are not reported in the governmental funds. Bonds and notes payable (12,655,898) Compensated absences (1,228,134) (13,884,032) Net assets of governmental activities 106,763,173$ 231 37 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES-GOVERNMENTAL FUNDS For the Year Ended June 30, 2007 Street and Fire SID Other Total Impact Fees Sinking Capital Governmental Governmental General Special Revenue Debt Service Projects Funds Funds REVENUES Taxes 8,035,738$ -$ -$ -$ 3,818,134$ 11,853,872$ Special assessments 142 - 1,428,084 - 438,491 1,866,717 Licenses and permits 281,948 - - - 1,480,138 1,762,086 Intergovernmental 4,190,780 - - - 1,924,917 6,115,697 Charges for services 1,855,735 2,943,645 1,603 - 2,602,756 7,403,739 Fines and forfeitures 1,337,098 - - - 409,115 1,746,213 Interest on investments 90,444 354,841 67,023 272,470 284,024 1,068,802 Loan repayment - - - - 10,193 10,193 Other 189,671 - - 1,231,262 519,223 1,940,156 Total revenues 15,981,556 3,298,486 1,496,710 1,503,732 11,486,991 33,767,475 EXPENDITURES Current General government 4,019,330 - - 51,497 923,390 4,994,217 Public safety 8,040,649 26,560 - 21,561 2,071,521 10,160,291 Public service 604,736 214,522 - 147,808 2,093,606 3,060,672 Public welfare 3,320,367 - - - 994,719 4,315,086 Other 381,518 - 88,685 - 113,390 583,593 Capital outlay 1,022,734 - - 8,705,134 1,669,497 11,397,365 Debt service Principal payments 80,089 - 268,069 - 485,000 833,158 Interest and fiscal fees 6,618 - 309,119 - 233,930 549,667 Total expenditures 17,476,041 241,082 665,873 8,926,000 8,585,053 35,894,049 Revenues over (under) expenditures (1,494,485) 3,057,404 830,837 (7,422,268) 2,901,938 (2,126,574) OTHER FINANCING SOURCES (USES) Transfers in 2,817,720 489,780 130,846 505,711 621,839 4,565,896 Transfers out (621,498) (496,393) (130,846) - (2,827,379) (4,076,116) Sale of capital assets 489,702 - - - 935 490,637 Total other financing sources (uses)2,685,924 (6,613) - 505,711 (2,204,605) 980,417 Net change in fund balances 1,191,439 3,050,791 830,837 (6,916,557) 697,333 (1,146,157) FUND BALANCE, beginning of year 3,179,099 4,757,561 623,683 6,598,235 6,560,277 21,718,855 FUND BALANCE, end of year 4,370,538$ 7,808,352$ 1,454,520$ (318,322)$ 7,257,610$ 20,572,698$ 232 38 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES - GOVERNMENTAL FUNDS For the Year Ended June 30, 2007 Net change in fund balances - total governmental funds (1,146,157)$ Amounts reported for governmental activities in the statement of activities are different because: Governmental funds report capital outlays as expenditures. In the statement of activities, the cost of these assets is depreciated over the assets' useful lives. Expenditures for capital assets 11,397,365$ Less: current year depreciation (7,759,203) 3,638,162 Bond proceeds provide current financial resources in the governmental funds, but issuing debt increases long-term liabilities in the statement of net assets. Repayment of principal is an expenditure in the governmental funds, but this repayment reduces long-term liabilities in the statement of net assets. Amortization of bond issuance costs (7,175) Principal payments on bonds and notes 833,158 Principal payments on capital leases 13,831 839,814 Deferred revenue in the governmental funds are reported on the full accrual method in the government-wide financial statements. Property taxes (17,122) Notes receivable (301,824) Special assessments (1,043,765) Fines 67,294 (1,295,417) Governmental funds do not report a liability for compensated absences. The change in the liability is a current period expense.167,529 Governmental funds do not report impact fee credits. The change in these credits during the year are charged to the statement of activities.529,270 Governmental funds do not report donated assets which are reported as assets and revenue in the statements of activities and net assets.18,363,608 Internal service funds are used by management to charge the costs of certain activities to individual funds. The net revenue (expense) of the internal service funds is reported in the governmental activities. Net revenue 195,164 Current year depreciation expense included in governmental activities 18,741 Change in compensated absences included in governmental activities 1,491 215,396 Change in net assets of governmental activities 21,312,205$ 233 PROPRIETARY FUNDS FINANCIAL STATEMENTS 235 PROPRIETARY FUNDS These funds are used to account for the financing, acquisition, operation and maintenance of water, sewer, and solid waste facilities, which are supported by user charges. Enterprise Funds – Water Fund – Accounts for the City’s water utility operations and to collect and administer water impact fees. Waste Water Fund – Accounts for the City’s sewer utility operations and to collect and administer waste water impact fees. Solid Waste Fund – Accounts for the City’s garbage service operations. Internal Service Funds – used to account for the goods and services provided by one department to other departments of the City on a cost-reimbursement basis. 237 39 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF NET ASSETS PROPRIETARY FUNDS June 30, 2007 Governmental Activities Waste Solid Internal Water Fund Water Fund Waste Fund Total Service Funds ASSETS Current assets Cash and investments 6,566,944$ 6,474,848$ 3,847,236$ 16,889,028$ 83,599$ Receivables Accrued interest 87,239 99,482 18,180 204,901 - Customers, net 471,068 361,291 214,891 1,047,250 12,333 Special assessments - - 180 180 - Other governments 340,226 150,000 - 490,226 - Prepaid expenses - - - - 631,526 Total current assets 7,465,477 7,085,621 4,080,487 18,631,585 727,458 Non current assets Other assets Notes receivable 36,000 - - 36,000 - Restricted cash and investments 8,312,801 10,773,732 - 19,086,533 - Total other assets 8,348,801 10,773,732 - 19,122,533 - Property, plant and equipment Nondepreciable: Land 162,518 754,263 3,714,577 4,631,358 - Depreciable: Water rights 263,494 - - 263,494 - Buildings 3,275,285 6,287,390 460,651 10,023,326 - Other structures and improvements 13,424,508 14,763,061 2,155,300 30,342,869 - Machinery and equipment 1,054,256 1,880,410 3,012,304 5,946,970 131,175 Vehicles 380,472 692,323 633,872 1,706,667 37,997 Infrastructure 128,062,704 75,004,512 - 203,067,216 - Accumulated depreciation and amortization (58,770,290) (37,644,126) (5,113,490) (101,527,906) (136,101) Net property, plant and equipment 87,852,947 61,737,833 4,863,214 154,453,994 33,071 Total non current assets 96,201,748 72,511,565 4,863,214 173,576,527 33,071 Total assets 103,667,225$ 79,597,186$ 8,943,701$ 192,208,112$ 760,529$ (continued) Business-type Activities Enterprise Funds 239 40 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF NET ASSETS PROPRIETARY FUNDS (CONTINUED) June 30, 2007 Governmental Activities Waste Solid Internal Water Fund Water Fund Waste Fund Total Service Funds LIABILITIES Current liabilities: Accounts payable and accrued expenses 391,298$ 245,230$ 208,811$ 845,339$ 12,013$ Compensated absences payable 101,000 95,000 60,000 256,000 9,360 Due to other City funds - - - - 353,397 Bonds, notes, and loans payable 82,867 - - 82,867 - Total current liabilities 575,165 340,230 268,811 1,184,206 374,770 Noncurrent liabilities Closure and post-closure care costs - - 2,449,511 2,449,511 - Revenue bonds due after one year 143,593 - - 143,593 - Compensated absences payable 70,994 8,894 38,279 118,167 - Solvent site remediation liability - 435,000 - 435,000 - Total noncurrent liabilities 214,587 443,894 2,487,790 3,146,271 - Total liabilities 789,752 784,124 2,756,601 4,330,477 374,770 NET ASSETS Invested in capital assets, net of related debt 87,626,487 61,737,833 4,863,214 154,227,534 33,071 Restricted for impact capital projects 5,522,547 10,648,599 - 16,171,146 - Restricted for debt service 928,720 - - 928,720 - Unrestricted 8,799,719 6,426,630 1,323,886 16,550,235 352,688 Total net assets 102,877,473 78,813,062 6,187,100 187,877,635 385,759 Total liabilities and net assets 103,667,225$ 79,597,186$ 8,943,701$ 192,208,112$ 760,529$ Enterprise Funds Business-type Activities 240 41 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS - PROPRIETARY FUNDS For the Year Ended June 30, 2007 Governmental Activities Waste Solid Internal Water Fund Water Fund Waste Fund Totals Service Funds OPERATING REVENUES Charges for services 6,124,533$ 4,262,052$ 2,037,349$ 12,423,934$ 3,205,407$ OPERATING EXPENSES Salaries and benefits 1,467,601 1,281,507 1,055,391 3,804,499 164,666 Materials and supplies 680,938 231,125 308,543 1,220,606 290,853 Repairs and maintenance 104,645 172,051 219,493 496,189 7,010 Utilities 122,559 308,873 351,663 783,095 623 Administrative charges 384,755 375,680 308,793 1,069,228 31,436 Insurance claims - - - - 2,438,637 Other expenses 353,555 423,038 530,772 1,307,365 76,197 Depreciation and amortization 7,353,367 4,584,074 568,848 12,506,289 18,741 Changes in estimated closure and post- closure care costs - - (60,368) (60,368) - Total operating expenses 10,467,420 7,376,348 3,283,135 21,126,903 3,028,163 Operating income (loss)(4,342,887) (3,114,296) (1,245,786) (8,702,969) 177,244 NONOPERATING REVENUES (EXPENSES) Interest income 685,856 782,317 143,925 1,612,098 24,313 Interest expense (23,391) - - (23,391) (6,533) Other income 188,366 30,338 25,419 244,123 140 Grant income 281,181 1,090 855 283,126 - Impact fees 1,592,670 1,959,935 - 3,552,605 - Transfers out (146,010) (343,770) - (489,780) - Contributions of infrastructure 12,411,654 13,772,624 - 26,184,278 - Gain on disposal of assets 13,073 18,345 221,537 252,955 - Total nonoperating revenues 15,003,399 16,220,879 391,736 31,616,014 17,920 Change in net assets 10,660,512 13,106,583 (854,050) 22,913,045 195,164 NET ASSETS, beginning of year 20,705,332 27,031,339 7,041,150 54,777,821 190,595 Prior period adjustment 71,511,629 38,675,140 - 110,186,769 - NET ASSETS, end of year 102,877,473$ 78,813,062$ 6,187,100$ 187,877,635$ 385,759$ Enterprise Funds Business-type Activities 241 42 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF CASH FLOWS - PROPRIETARY FUNDS For the Year Ended June 30, 2007 Governmental Activities Waste Solid Internal Water Fund Water Fund Waste Fund Total Service Funds Cash Flows from Operating Activities Receipts from customers 6,409,971$ 4,452,421$ 1,983,221$ 12,845,613$ 3,963,575$ Receipts from others 604,472 (119,662) 25,419 510,229 140 Operating loans from other funds - - - - (94,550) Payments to suppliers (1,262,861) (1,122,772) (1,341,140) (3,726,773) (1,237,886) Payments to employees (1,457,126) (1,271,533) (1,061,963) (3,790,622) (2,601,812) Payments to internal service funds and administrative fees (384,755) (375,680) (308,793) (1,069,228) (31,436) Net Cash Flows From Operating Activities 3,909,701 1,562,774 (703,256) 4,769,219 (1,969) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (800,511) (333,309) (296,863) (1,430,683) (7,452) Principal paid on bonds, interfund loans, loans and leases (473,952) - - (473,952) - Receipts from Federal grants 281,181 1,090 855 283,126 - Interest paid on bonds, interfund loans, loans and leases (23,391) - - (23,391) (6,533) Transfers to other funds for capital outlay (146,010) (343,770) - (489,780) - Impact fees received 1,592,670 1,959,935 - 3,552,605 - Proceeds from sale of property, plant and equipment 13,073 18,345 221,537 252,955 - Net Cash Flows from Capital and Related Financing Activities 443,060 1,302,291 (74,471) 1,670,880 (13,985) Cash Flows from Investing Activities Interest on investments 655,872 767,639 167,597 1,591,108 24,313 Net Cash Flows from Investing Activities 655,872 767,639 167,597 1,591,108 24,313 Net Increase (Decrease) in Cash and investments 5,008,633 3,632,704 (610,130) 8,031,207 8,359 Cash and investments, beginning of year 9,871,112 13,615,876 4,457,366 27,944,354 75,240 Cash and investments, end of year 14,879,745$ 17,248,580$ 3,847,236$ 35,975,561$ 83,599$ Classified as: Cash and investments 6,566,944$ 6,474,848$ 3,847,236$ 16,889,028$ 83,599$ Restricted cash and investments 8,312,801 10,773,732 - 19,086,533 - Totals 14,879,745$ 17,248,580$ 3,847,236$ 35,975,561$ 83,599$ Noncash transactions: donated infrastructure 12,411,654$ 13,772,624$ -$ 26,184,278$ Enterprise Funds Business-type Activities 242 43 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF CASH FLOWS - PROPRIETARY FUNDS (CONTINUED) For the Year Ended June 30, 2007 Governmental Activities Waste Solid Internal Water Fund Water Fund Waste Fund Total Service Funds Operating income (loss)(4,342,887)$ (3,114,296)$ (1,245,786)$ (8,702,969)$ 177,244$ Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities Depreciation and amortization 7,353,367 4,584,074 568,848 12,506,289 18,741 Change in estimated closure and post-closure care costs - - (60,368) (60,368) - Other income 188,366 30,338 25,419 244,123 140 Change in Assets and Liabilities: (Increase) Decrease in: Accounts receivable 285,438 190,369 (54,128) 421,679 758,168 Other governments receivable 416,106 (150,000) - 266,106 Prepaid expenses - - - - (631,526) Increase (Decrease) in: Accounts payable (1,164) 12,315 69,331 80,482 (231,677) Accrued employee benefits payable 10,475 9,974 (6,572) 13,877 1,491 Total adjustments 8,252,588 4,677,070 542,530 13,472,188 (179,213) Net cash provided (used) by operating activities 3,909,701$ 1,562,774$ (703,256)$ 4,769,219$ (1,969)$ Enterprise Funds Business-type Activities 243 FIDUCIARY FUND FINANCIAL STATEMENTS 245 FIDUCIARY FUNDS AGENCY FUNDS Agency funds are used to account for assets held by the City as an agent for individuals, private organizations, other governments and/or other funds. Montana Arts Council – Accounts for pass-through grant monies given for use by the Montana Arts Council for various programs. Municipal Court – Accounts for monies held for appearance bonds and restitution. 247 44 CITY OF BOZEMAN, MONTANA The Notes to Financial Statements are an integral part of the financial statements. STATEMENT OF FIDUCIARY NET ASSETS FIDUCIARY FUNDS June 30, 2007 Agency Funds ASSETS Cash and cash equivalents 233,963$ Customer receivables 5,520 Interfund receivable 11,566 Total assets 251,049 LIABILITIES Accounts payable 251,049 Total liabilities 251,049$ 249 NOTES TO FINANCIAL STATEMENTS 251 45 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Bozeman of Gallatin County, Montana (the City) was incorporated as a municipal corporation in 1883. The present City Code of Ordinances was adopted November 22, 1982. Under the charter, the City is governed by a mayor and commission members who comprise the City Commission. The day-to- day affairs of the City are conducted under the supervision of the City Manager, who is appointed by and serves at the pleasure of a majority of the City Commission. The accompanying financial statements of the City have been prepared in conformity with generally accepted accounting principles (GAAP) as prescribed by the Governmental Accounting Standards Board (GASB), the accepted standard-setting body for establishing governmental accounting and financial reporting principles. In June 1999 the GASB issued Statement 34 Basic Financial Statements-and Management’s Discussion and Analysis-for State and Local Governments (GASB 34). This Statement establishes new financial reporting requirements for state and local governments throughout the United States. It requires new information and restructures much of the information that governments have presented in the past. Comparability with reports issued in prior years is affected. The City adopted the provisions of GASB 34 for its fiscal year ended June 30, 2002. With the implementation of GASB 34, the City has prepared required supplementary information titled Management’s Discussion and Analysis which precedes the basic financial statements. Other GASB statements are required to be implemented in conjunction with GASB Statement 34. Therefore, the City implemented the following GASB statements in the year ended June 30, 2002: Statement 33 Accounting and Financial Reporting for Nonexchange Transactions, Statement 36 Recipient Reporting for Certain Shared Nonexchange Revenues, Statement 37 Basic Financials Statements-and Management’s Discussion and Analysis-for State and Local Governments: Omnibus, and Statement 38 Certain Financial Statement Note Disclosures. The accompanying financial statements present the financial position of the City and the various funds and fund types, the results of operations of the City and the various funds and fund types, and the cash flows of the proprietary funds. The financial statements are presented as of June 30, 2007, and for the year then ended. The more significant accounting policies of the City are described below. Reporting Entity The City has considered all potential component units for which it is financially accountable and other organizations for which the nature and significance of their relationship with the City are such that exclusion would cause the City’s financial statements to be misleading or incomplete. The Governmental Accounting Standards Board has set forth criteria to be considered in determining financial accountability in Statement 14 The Financial Reporting Entity and Statement 39, Determining Whether Certain Organizations are Component Units, an amendment to Statement 14. These criteria include appointing a voting majority of an organization's governing body and (1) the ability of the City to impose its will on that organization or (2) the potential for the organization to provide specific financial benefits to, or impose specific financial burdens on the City. 253 46 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Reporting Entity (Continued) Discretely Presented Component Units Component units are entities which are legally separate from the City, but are financially accountable to the City, or whose relationships with the City are such that exclusion would cause the City’s financial statements to be misleading or incomplete. The following entity is discretely presented as a component unit of the City as of June 30, 2007. Bozeman Public Library Foundation, Inc. (the Foundation) - A legally separate non-profit corporation whose activities directly benefit the City. The Foundation’s purpose is to support the Bozeman Public Library (the Library) through raising, receiving, administering, and disbursing funds, grants, bequests, and gifts for the benefit of the Library. Although the City does not control the timing or amount of receipts from the Foundation, the majority of the resources, or income thereon, that the Foundation holds and invests are restricted to, or designated for, the activities of the Library. Because these resources are used for the benefit of the City, the Foundation is considered a component unit of the City and is discretely presented in the City’s financial statements. The Foundation is a private nonprofit organization that presents its financial statements under standards set forth by the Financial Accounting Standards Board. As such, certain revenue recognition criteria and presentation features are different from GASB revenue recognition criteria and presentation features. No modifications have been made to the Foundation’s financial information in the City’s presentation of this information. The accompanying financial information for the Foundation is for the organization’s most recent fiscal year, which ended December 31, 2006. Complete financial statements for the Foundation may be obtained by contacting the City’s Finance Director or Controller, at the City of Bozeman, 411 East Main Street, Bozeman, Montana 59715. Although the following entities meet the requirements of Statement 14 and Statement 39, they are strictly advisory in nature. Therefore, the government-wide financial statements do not include the financial information of the following entities and their omission does not cause the City’s financial statements to be misleading or incomplete. Should there develop a financial element at some point in the future, the City shall include these entities on its government-wide financial statements. Senior Center Advisory Council - This council is advisory in nature on senior issues and on how to run the City-owned Senior Center building. The City is responsible for the maintenance and operation of the building. Parking Commission - The City Commission appoints the governing board of the Parking Commission, which was created by ordinance. The City owns the parking lots, collects the rents and assigns the lots to the individuals. The Parking Commission acts only in a volunteer advisory capacity to the City Commission on setting rates. 254 47 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Reporting Entity (Continued) Blended Component Units The following have been presented as blended component units since their governing bodies are substantially the same as the primary government’s government body and because their services are provided entirely or almost entirely to the primary government. Library Board of Trustees - The City Commission appoints all five trustees of the Library Board of Trustees. The Library is not a legally separate entity. City Planning Board - The agreement forming the City Planning Board holds that it will submit its budget to the City Commission for approval and the City provides all accounting functions and is responsible for the issuance of debt. It is presented with the Special Revenue Funds. Basis of Accounting/Measurement Focus The accounts of the City are organized on the basis of funds, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self-balancing accounts that comprise its assets, liabilities, fund equity, revenues and expenditures or expenses, as appropriate. Governmental resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled. Government-Wide Financial Statements The Government-Wide Financial Statements (the Statement of Net Assets and the Statement of Activities) present information of all the non-fiduciary activities of the primary government and its component units. These statements present summaries of Governmental and Business-Type Activities for the City accompanied by a total column. These statements are presented on an ―economic resources‖ measurement focus and the accrual basis of accounting. Accordingly, all of the City’s assets and liabilities, including capital assets and long-term liabilities, are included in the accompanying Statement of Net Assets. The City will retroactively include infrastructure in its assets at a point within the prescribed 4-year implementation period. For the current fiscal year, no infrastructure assets existing prior to July 1, 2001 have been included. The Statement of Activities presents changes in net assets. Under the accrual basis of accounting, revenues are recognized in the period in which they are earned while expenses are recognized in the period in which the liability is incurred. The types of transactions reported as program revenues for the City are reported in three categories: 1) charges for services, 2) operating grants and contributions, and 3) capital grants and contributions. Certain eliminations have been made as prescribed by GASB 34 in regards to inter-fund activities, payables and receivables. All internal balances in the Statement of Net Assets have been eliminated except those representing balances between the governmental activities and the business-type activities, which are presented as internal balances and eliminated in the total primary government column. In the Statement of Activities, internal service fund transactions have been eliminated; however, those transactions between governmental and business-type activities have not been eliminated. 255 48 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Basis of Accounting/Measurement Focus (Continued) The City applies all applicable GASB pronouncements (including all National Council on Governmental Accounting Statements and Interpretations currently in effect) as well as the following pronouncements issued on or before November 30, 1989, unless those pronouncements conflict with or contradict GASB pronouncements: Financial Accounting Standards Board (FASB) Statements and Interpretations, Accounting Principles Board (APB) Opinions, and Accounting Research Bulletins (ARB) of the Committee on Accounting Procedure. In addition, the City applies all applicable FASB Statements and Interpretations issued after November 30, 1989, except those that conflict with or contradict GASB pronouncements to its business-type activities. Governmental Fund Financial Statements Governmental Fund Financial Statements include a Balance Sheet and a Statement of Revenues, Expenditures, and Changes in Fund Balances for all major governmental funds and nonmajor funds aggregated. An accompanying schedule is presented to reconcile and explain the differences in fund balances and changes in fund balances as presented in these statements to the net assets and changes in net assets presented in the Government-Wide Financial Statements. The City has presented all major funds that met those qualifications. All governmental funds are accounted for on a spending or ―current financial resources‖ measurement focus and the modified accrual basis of accounting. Accordingly, only current assets and current liabilities are included on the Balance Sheets. The Statement of Revenues, Expenditures, and Changes in Fund Balances present increases (revenues and other financing sources) and decreases (expenditures and other financing uses) in net current assets. Under the modified accrual basis of accounting, revenues are recognized in the accounting period in which they become both measurable and available to finance expenditures of the current period. Accordingly, revenues are recorded when received in cash, except that revenues subject to accrual (generally 60 days after year-end) are recognized when due. The primary revenue sources which have been treated as susceptible to accrual by the City are property taxes, intergovernmental revenues, and other taxes. Expenditures are recorded in the accounting period in which the related fund liability is incurred. The City has elected to apply the early recognition option of recognizing debt services expenditures provided by GASB Interpretation No. 6, Recognition and Measurement of Certain Liabilities and Expenditures in Governmental Fund Financial Statements. Under this option, an expenditure and a liability are recorded in debt service funds in the current year for amounts due early in the following year, for which resources have been provided during the current year. Proprietary Fund Financial Statements Proprietary Fund Financial Statements include a Statement of Net Assets, a Statement of Revenues, Expenses and Changes in Net Assets, and a Statement of Cash Flows for each major proprietary fund. The City has no nonmajor proprietary funds. A column representing internal service funds is also presented with the Proprietary Fund Financial Statements. Internal service balances and activities, however, have been combined with the governmental activities in the Government-Wide Financial Statements. Proprietary funds are accounted for using the ―economic resources‖ measurement focus and the accrual basis of accounting. Accordingly, all assets and liabilities (whether current or noncurrent) are included on the Statement of Net Assets. The Statement of Revenues, Expenses and Changes in Net Assets presents increases (revenues) and decreases (expenses) in total net assets. Under the accrual basis of accounting, revenues are recognized in the period in which they are earned while expenses are recognized in the period in which the liability is incurred. 256 49 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Basis of Accounting/Measurement Focus (Continued) Operating revenues in the proprietary funds are those revenues that are generated from the primary operations of the fund. All other revenues are reported as non-operating revenues. Operating expenses are those expenses that are essential to the primary operations of the fund. All other expenses are reported as non- operating expenses. Fiduciary Fund Financial Statements Fiduciary Fund Financial Statements include a Statement of Net Assets. The City’s Fiduciary Funds represent Agency Funds, which are custodial in nature (assets equal liabilities) and do not involve measurement of results of operations. Therefore, Agency Funds do not have a measurement focus. These funds are accounted for using the accrual basis of accounting. The following Agency Funds are included in the Fiduciary Fund financial statements: Montana Arts Council – Accounts for pass-through monies received from the State of Montana to fund local chapters of cultural enhancement activities such as the Bozeman Symphony Orchestra, Montana Ballet, Mandolin Society, Intermountain Opera Association, and the Emerson Cultural Center. Municipal Court – Accounts for monies held for appearance bonds and restitution related to criminal arrests and reimbursement for damage caused. Internal Service Funds Internal Service Funds are used to account for goods and services provided by one department to other departments of the City on a cost-reimbursement basis. These direct costs and certain indirect costs are included as part of the program expense reported for the individual functions and activities of these other departments. The following Internal Service Funds are included in the Proprietary Fund Financial Statements: Vehicle Maintenance Shop – Accounts for the maintenance and repair of vehicles used in the operation of City services. Medical Health Insurance – Accounts for insurance premium revenues received from the various City departments and retirees, and the related costs of health, vision, and dental claims incurred by City employees and retirees which are in-turn paid to the City’s insurance program coordinator. Funds As mentioned, the Governmental Fund Financial Statements include a Balance Sheet and a Statement of Revenues, Expenditures, and Changes in Fund Balances for all major governmental funds and nonmajor funds aggregated. The following major funds are presented in separate columns on the Governmental Funds Financial Statements, and the Proprietary Funds Financial Statements, respectively: Governmental Funds General Fund – this fund accounts for the financial operations of the City which are not accounted for in any other fund. Principal sources of revenue are property taxes, state and local shared revenues, licenses and permits, and charges for services provided to other funds. Principal expenditures in the General Fund are made for police and fire protection, public works, and general government. SID Sinking Debt Service Fund – Accounts for the accumulation of resources and payment of special assessment bond principal and interest related to general improvement, sidewalk, and curb construction projects. General Improvements Capital Projects Fund – Accounts for the construction of general improvement projects financed by special assessments other than those financed by proprietary funds. Street and Fire Impact Fees Special Revenue Fund – on January 22, 1996, the City Commission adopted fire, street, water, and waste impact fees in Ordinance Number 1414. This fund accounts for the collection and expenditures associated with the fire and street impact fees. 257 50 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Funds (continued) Proprietary Funds Water Fund - Accounts for the City's water utility operations and to collect and administer water impact fees. Waste Water Fund - Accounts for the City's sewer utility operations and to collect and administer waste water impact fees.. Solid Waste Fund - Accounts for the City's garbage service operations. Use of Restricted/Unrestricted Net Assets When an expense is incurred for purposes for which both restricted and unrestricted net assets are available, the City’s policy is to apply restricted net assets first. Cash and Investments Cash and investments are under the management of the City's Treasurer and consist primarily of investments in U.S. Government Bonds and the Montana State Short-Term Investment Pool (STIP). Interest income earned as a result of pooling of City deposits is distributed to the appropriate funds utilizing a formula based on the average balance of cash and investments of each fund. Montana State statutes authorize the City to invest in interest-bearing savings accounts, certificates of deposits, and time deposits insured up to $100,000 by the Federal Deposit Insurance Corporation or fully collateralized, U.S. government and U.S. agency obligations, STIP and repurchase agreements where there is a master repurchase agreement and collateral held by a third party. According to GASB Statement No. 31, ―Accounting and Financial Reporting for Certain Investments and External Investments Pools‖, STIP is considered an external investment pool. An external investment pool is defined as an arrangement that pools the monies of more than one legally separate entity and invests, on the participants’ behalf, in an investment portfolio. STIP is also classified as a ―2a7-like‖ pool. A 2a7-like pool is an external investment pool that is not registered with the Securities and Exchange Commission (SEC) as an investment company, but has a policy that it will, and does, operate in a manner consistent with the SEC’s Rule 2a7 of the Investment Company Act of 1940. If certain conditions are met, 2a7-like pools are allowed to use amortized cost rather than fair value to report net assets to compute unit values. The Board of Investments, the regulatory agency which oversees the pool, has adopted a policy to treat STIP as a 2a7-like pool. Accordingly, the investment in STIP is valued at amortized cost as of June 30, 2007. The fair value of the position in the external investment pool is the same as the value of the pool shares as of June 30, 2007. 258 51 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Cash and Investments (continued) Investing in STIP allows the City to obtain the highest possible return, yet maintain a highly liquid position whereby funds may be invested for relatively short periods of time, one day or more, depending on the participant’s anticipated use of the funds. Accordingly, the City’s investment in STIP is classified as a cash equivalent. The STIP portfolio includes asset-backed and variable interest rate securities to provide diversification and competitive rate of return. These securities are described below: Asset-backed Securities are debt securities collateralized by a pool of mortgage and non-mortgage assets such as trade and loan receivables, equipment leases and credit cards, etc., pledged by the issuer. Asset-backed securities have one or more forms of credit enhancement to raise the quality of the security. Examples of credit enhancement include, but are not limited to, letter of credit, reserve fund, or senior/subordinate arrangements. Variable Rate (Floating-Rate) Securities provide many advantages of short-term bonds because they are designed to minimize the investor’s interest rate risk. As with variable rate loans issued by banks, the interest rate paid by the issuer of these securities is reset periodically depending on market conditions. The value of these securities will usually remain at or near par because their interest rates are reset to maintain a current market yield. STIP’s variable rate securities float to either the Prime Rate or the London Interbank Offering Rate (LIBOR), which is similar to the European Federal Funds Rate. For the year ended June 30, 2005, the City implemented a new accounting standard issued by GASB, Statement No. 40, Deposit and Investment Risk Disclosures. Statement No. 40 amends Statement No. 3, Deposits with Financial Institutions, Investments (including Repurchase Agreements), and Reverse Repurchase Agreements. Statement No. 40 revises the existing requirements regarding disclosure regarding credit risk, concentration of credit risk, interest rate risk, and foreign currency risk. Restricted Cash and Investments Certain proceeds of enterprise fund revenue bonds, as well as certain resources set aside for their repayment, are classified as restricted assets on the balance sheet because their use is limited by applicable bond covenants. Impact fees collected and line-oversizing fees are restricted for applicable use. Payments in lieu of parking are restricted by code for future parking related capital projects. Use of Estimates The preparation of financial statements in conformity with generally accepted accounting principles requires management to make estimates and assumptions that affect certain reported amounts and disclosures. Accordingly, actual results could differ from those estimates. Eliminations and Reclassifications In the process of aggregating data for the Statement of Net Assets and the Statement of Activities, some amounts reported as inter-fund activity and balances in the funds have been eliminated or reclassified. Internal service fund activity has also been eliminated in the Statement of Activities to remove the ―doubling- up‖ effect. 259 52 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Capital Assets The City’s assets are capitalized at historical cost or estimated historical cost. City policy has set the capitalization threshold for reporting capital assets at $5,000. Gifts or contributions of capital assets are recorded at fair market value when received. Depreciable capital assets are reported on the Statement of Net Assets, net of applicable accumulated depreciation. Capital assets which are not depreciable, such as land, and construction in progress are reported separately. Depreciation expense is reported in Statement of Activities and is calculated using the straight-line method based on the assets estimated useful life. Depreciation is recorded on a straight-line basis over the useful lives of the assets as follows: Vehicles 5 years Machinery and equipment 5 to 30 years Buildings 20 to 50 years Other structures and improvements 10 to 25 years Infrastructure 25 to 50 years In June 1999, GASB issued Statement No. 34 (GASB 34) which requires the inclusion of infrastructure capital assets in local governments’ basic financial statements. According to GASB 34, the City must record infrastructure assets prospectively from the date of implementation and has four years to include infrastructure acquired prior to implementation. The City defines infrastructure as the basic physical assets that allow the City to function. The assets to be recorded will include the street system, water purification and distribution system, sewer collection treatment system; park and recreation lands and improvement system, storm water conveyance system, and buildings combined with the site amenities such as parking and landscaped areas; and streets, sidewalks, curbs, and street lights. The costs of normal maintenance and repairs that do not add to the value of the asset or materially extend asset lives are not capitalized. Improvements are capitalized and depreciated over the remaining useful lives of the related capital assets, as applicable. Compensated Absences Payable Earned but unpaid vacation and sick pay is included as a liability in the proprietary fund types and Government-Wide Financial Statements. The portion relating to the governmental fund types not expected to be paid with expendable and available resources is not reported in the governmental fund statements unless the liability has matured (i.e., unused reimbursable leave still outstanding following an employee's resignation or retirement). Inter-fund Receivables and Payables During the course of operations, numerous transactions occur between individual funds that may result in amounts owed between funds. Those short-term loans related to goods and services type transactions are classified as ―due to and from other funds‖. Long-term inter-fund loans (noncurrent portion) are reported as ―advances to and from other funds‖. Inter-fund receivables and payables between funds are eliminated in the Statement of Net Assets. 260 53 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) On-Behalf Payments for Fringe Benefits On-behalf payments for fringe benefits are direct payments made by one entity to a third-party recipient for the employees of another legally separate entity. On-behalf payments include pension plan contributions. The State's pension contribution is recorded as intergovernmental revenue with an offsetting public safety or general government expenditures in the Pension Special Revenue Fund. (See Note 14) Budgets Each year, the City Manager must submit to the City Commission a proposed operating budget for all budget units within the City for the fiscal year commencing July 1. This operating budget includes proposed expenditures and the means of financing them. Public hearings are conducted to obtain citizen comments on the proposed budget. The budget is then legally adopted through passage of the appropriation resolution by the City Commission, but not before the second Monday in August. Budgets are legally required for all governmental fund types. These budgets are prepared on the same basis and using the same accounting practices as are used to account and prepare financial reports for the funds. Budgets presented in this report for comparison to actual amounts are presented in accordance with generally accepted accounting principles. Annual appropriated budgets are adopted for all funds and all appropriations lapse at year end. The level of budgetary control (that is the level at which expenditures cannot legally exceed the appropriated amount) is established at the fund type level. The City Commission may amend the budget during the course of the fiscal year, within each fund type. Any accruing revenue of the municipality not appropriated and any balance at any time remaining after the purpose of an appropriation has been satisfied or abandoned may from time to time be appropriated to other uses that do not conflict with any uses for which specifically the revenue was accrued. A public hearing is required for an overall increase in appropriation authority, except in the case of an emergency. The City Commission delegated in its annual appropriation resolution, budget amendment authority to the City Manager, for the expenditure of funds from any or all of the following: debt service funds, enterprise funds, internal service funds, trust funds, federal and state grants accepted and approved by the governing body, special assessments, and donations. In all other funds, the City Manager may, without approval from the City Commission, make budget amendments as long as the total appropriation for the fund group is not exceeded. Spending control is established by the total amount of expenditures budgeted for the fund type, but management may exercise control at budgetary line items. NOTE 2. CASH AND INVESTMENTS At June 30, 2007, the carrying amount of the City's deposits in local banks is $1,272,047 and the bank balance is $1,848,944. Of the bank balance, $100,000 was covered by federal depository insurance and up to $4,800,000 was covered by collateral held by the pledging bank's agent in the City's name. 261 54 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 2. CASH AND INVESTMENTS (CONTINUED) The City’s cash and investments are reported as follows: Unrestricted Restricted Total Governmental activities 12,444,323$ 7,815,285$ 20,259,608$ Business-type activities 16,889,028 19,086,533 35,975,561 Fiduciary funds 233,961 - 233,961 29,567,312$ 26,901,818$ 56,469,130$ Custodial credit risk for deposits is the risk that in the event of a financial institution failure, the City’s deposits may not be returned or the City will not be able to recover the collateral securities in the possession of the outside party. The City minimizes custodial credit risk by restrictions set forth in City policy and state law. The City’s policy requires deposits to be 102 percent secured by collateral valued at market value. The City Treasurer maintains a listing of financial institutions, which are approved for investment purposes. Types of securities that may be pledged as collateral are detailed in Section 17-6-103 of the Montana Code Annotated (MCA). City policy requires that specific safeguards against risk of loss be evidenced when the City does not physically hold the securities. On June 30, 2007, the book value approximated the fair value of the investments, therefore no unrealized gain or loss was recorded for the year. At June 30, 2007, the City had investments in the State Short-Term Investment Pool (STIP), in non-negotiable repurchase agreements, and in various United States government bonds, as allowed by State law. The following table provides information about the interest rate risks associated with the City’s deposits and investments. Investment Maturities Credit Risk Rating Fair Value State Short-Term Investment Pool N/A Not Rated 37,200,000$ U.S. Government bonds Jul 2007 - Jun 2008 AAA 8,991,903 U.S. Government bonds Jul 2008 - Jun 2009 AAA 8,499,800 U.S. Government bonds Jul 2009 - Jun 2010 AAA 500,000 Non-negotiable repurchase agreements N/A N/A 1,454,798 Demand deposits N/A N/A (182,753) Petty cash N/A N/A 5,382 56,469,130$ Credit risk is defined as the risk that an issuer or other counterpart to an investments will not fulfill its obligation. The above credit risk rating indicates the probability that the issuer may default in making timely principal and interest payments. The credit ratings presented in the previous tables are provided by Standard and Poor’s Corporation (S&P). The City’s investment policy is to hold investments to maturity with the contractual understanding that these investments are low risk, locked in to a guaranteed rate of return, are therefore not impacted significantly by changes in short term interest rates. 262 55 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 3. PROPERTY TAX CALENDAR Real property taxes are assessed and collected each fiscal year according to the following property tax calendar: Lien Date December 1 for the 1st installment and June 1 for the 2nd installment Levy Date November 1 Due Dates November 30 for the 1st installment and May 31 for the 2nd installment Personal property taxes are assessed on January 1 of each year and billed in May and November, with payment due within thirty days. Gallatin County collects all property taxes on behalf of the City and remits collections, including penalties and interest, on a monthly basis. The County assesses a delinquency penalty of 2%. If taxes become delinquent the County tax collector may sell the property to collect taxes due plus .83% per month interest. In the fund financial statements, the City accrues as receivable all property taxes received during the first sixty (60) days of the new fiscal year from Gallatin County, in accordance with the modified accrual basis. In the government-wide financial statements, all taxes billed, but not yet collected are accrued in accordance with the full accrual basis of accounting, as described in Note 1. NOTE 4. SPECIAL ASSESSMENTS RECEIVABLE/DEFERRED REVENUES Special assessments receivable represent the uncollected amounts levied against benefited property for the cost of local improvements. Assessments are payable over a period of 18 to 20 years and bear interest of 2.5% to 5.75% per annum. Recognition of the revenues from these assessments has been deferred until both measurable and available in governmental funds. In the Government-Wide Financial Statements, however, these amounts are reported as revenues in the period they are levied. Once received, the monies will be used to meet the annual debt service requirements on related bonds. Deferred revenues in the General Fund represent outstanding general property taxes at June 30, 2007. Again, these amounts are reported as revenue in the Government-Wide Financial Statements in the period in which they are levied. Deferred revenues in Special Revenue Funds represent either revenues received but not considered earned or amounts to be received in the future that are recorded as receivables but not yet earned. The deferred revenues in Debt Service Funds represent future assessments to be received to meet the related debt obligation. 263 56 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 5. PREPAID RENT (OPERATING LEASE) On October 22, 1992, the City signed a memorandum of understanding with Gallatin County, Montana, in which the City agreed to lease space from the County's Law and Justice Center for the City Police Department and Municipal Court. The City paid to the County $765,000 during the renovation of the building which started 1993. The $765,000 constitutes rent for four rental terms of ten years each. During the term of the lease and renewal of the lease, the principal balance of $765,000 will be decreased by equal annual rental payments in the amount of $19,125. If the City and County mutually agree to terminate the lease after the second ten year term, the County will refund $382,500, to the City for the unused portion of the rent. The lease began when renovations were complete on November 1, 1994. For the year ended June 30, 2007, rent expenditure was $19,125 regarding this lease. NOTE 6. NOTES RECEIVABLE The City had the following loans in Special Revenue Funds: Special Revenue Funds: Housing Revolving Loan Fund 97,083$ Economic Development Loan Fund 936,404 Community Housing Fund 47,766 Consolidated Parking Districts 1,739 Enterprise Funds Water Fund Note receivable related to water main extension to a low cost housing project. The original note was for $70,000, due in semiannual principal payments, with interest accruing at 10%, only if payments are not made in a timely manner.36,000$ 264 57 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 7. CAPITAL ASSETS In accordance with GASB 34, the City has reported all capital assets, with the exception of pre-July 1, 2001 infrastructure in the Government-Wide Statement of Net Assets. The assets are reported whereby accumulated depreciation and depreciation expense have been recorded. For the year ended June 30, 2007, depreciation expense on capital assets was charged to the functions and programs as follows: Governmental Activities: General Government 359,103$ Public Safety 409,751 Public Services 6,025,305 Public Welfare 965,044 Total depreciation expense - governmental activities 7,759,203$ Business-type Activities: Water 7,311,241$ Waste Water 4,584,074 Solid Waste 568,848 Total depreciation expense - business-type activities 12,464,163$ 265 58 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 7. CAPITAL ASSETS (CONTINUED) All capital assets of the City are depreciable with the exception of land. Capital assets activity of the City for the year ended June 30, 2007, consisted of the following: June 30, 2006 Additions Disposals June 30, 2007 Governmental Activities: Non-depreciable Land 7,144,251$ 605,948$ -$ 7,750,199$ Depreciable Buildings 18,977,773 3,831,092 - 22,808,865 Other structures and improvements 1,115,579 85,497 - 1,201,076 Machinery and equipment 6,794,105 598,678 - 7,392,783 Property under capital lease 154,992 - - 154,992 Vehicles 2,231,651 428,340 - 2,659,991 Infrastructure 27,258,409 68,476,421 - 95,734,830 Total 63,676,760 74,025,976 - 137,702,736 Accumulated depreciation (27,103,451) (20,333,812) - (47,437,263) Total governmental activities 36,573,309$ 53,692,164$ -$ 90,265,473$ Business-type Activities: Non-depreciable Land 4,631,358$ -$ -$ 4,631,358$ Water rights 263,494 - - 263,494 Depreciable Buildings 9,720,973 302,353 - 10,023,326 Other structures and improvements 30,027,302 315,567 - 30,342,869 Machinery and equipment 5,545,487 401,483 - 5,946,970 Vehicles 1,771,229 52,574 (117,136) 1,706,667 Infrastructure 17,933,215 185,134,001 - 203,067,216 Total 69,893,058 186,205,978 (117,136) 255,981,900 Accumulated depreciation (40,776,631) (60,868,411) 117,136 (101,527,906) Total business-type activities 29,116,427$ 125,337,567$ -$ 154,453,994$ Total capital assets 65,689,736$ 179,029,731$ -$ 244,719,467$ 266 59 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 7. CAPITAL ASSETS (CONTINUED) Changes in accumulated depreciation are as follows for the year ended June 30, 2007: Accumulated Depreciation: June 30, 2006 Additions Disposals June 30, 2007 Governmental Activities: Buildings (5,471,907)$ (1,026,939)$ -$ (6,498,846)$ Other structures and improvements (593,199) (66,445) - (659,644) Machinery and equipment (5,402,761) (536,809) - (5,939,570) Property under capital lease (105,727) (32,844) - (138,571) Vehicles (1,676,053) (352,352) - (2,028,405) Infrastructure (13,853,804) (18,318,423) - (32,172,227) Total governmental activities (27,103,451)$ (20,333,812)$ -$ (47,437,263)$ Business-type Activities: Buildings (4,426,317) (676,233) - (5,102,550) Other structures and improvements (20,891,344) (1,743,249) - (22,634,593) Machinery and equipment (3,810,593) (713,244) - (4,523,837) Vehicles (1,593,278) (60,731) 117,136 (1,536,873) Infrastructure (10,055,099) (57,674,954) - (67,730,053) Total business-type activities (40,776,631)$ (60,868,411)$ 117,136$ (101,527,906)$ Total accumulated depreciation (67,880,082)$ (81,202,223)$ 117,136$ (148,965,169)$ 267 60 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 8. COMPENSATED ABSENCES The City’s policy relating to compensated absences is described in Note 1. As shown in the table below, the long-term portion of the debt, amounting to $433,134 for governmental activities and $118,167 for business-type activities at June 30, 2007, is expected to be paid in future years from future resources. Historically, compensated absences have been liquidated primarily by the general fund and the proprietary funds. The total amounts outstanding at June 30, 2007, were $1,228,134 for governmental activities and $374,167 for business-type activities. Balance June 30, 2006 Incurred Satisfied Balance June 30, 2007 Compensated absences Governmental Activities $ 1,395,663 $ 627,216 $ (794,745) $ 1,228,134 Business-type Activities 360,290 269,798 (255,921) 374,167 Total compensated absences 1,755,953$ 897,014$ (1,050,666)$ 1,602,301$ Due within one year Due after one year Total Compensated absences Governmental Activities $ 795,000 $ 433,134 $ 1,228,134 Business-type Activities 256,000 118,167 374,167 Total compensated absences 1,051,000$ 551,301$ 1,602,301$ NOTE 9. LONG-TERM DEBT Governmental Activities Long Term Debt The following is a summary of long-term debt transactions of the City’s governmental activities for the year ended June 30, 2007: Balance June 30, 2006 Issuances Repayments Balance June 30, 2007 General obligation bonds $ 6,325,000 $ - $ (485,000) $ 5,840,000 Special assessment debt 7,004,769 - (268,069) 6,736,700 Notes payable 159,287 - (80,089) 79,198 Totals 13,489,056$ -$ (833,158)$ 12,655,898$ 268 61 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 9. LONG-TERM DEBT (CONTINUED) Governmental Activities Long Term Debt (Continued) The above long-term debt of the City’s governmental activities is presented in the accompanying Statement of Net Asset as follows: Current Portion (Due within one year) Long-term Portion (Due after one year) Total Long Term Debt General obligation bonds $ 495,000 $ 5,345,000 $ 5,840,000 Special assessment debt 340,700 6,396,000 6,736,700 Notes payable 79,198 - 79,198 914,898$ 11,741,000$ 12,655,898$ General Obligation Bonds - The City issues general obligation bonds to provide funds for the acquisition and construction of major capital facilities. General obligation bonds are direct obligations of the City and are backed by the full faith and credit of the City. General obligation bonds currently outstanding are as follows: Interest Rate Amount Due within one year Transportation Project Refunding Bonds, Series 2003b serial maturities through 2014 1.30%-3.75%2,575,000$ 325,000$ Library Project Bonds, Series 2002 serial maturities through 2022 3.50%-5.00%1,860,000 95,000 Library Project Bonds, Series 2003a serial maturities through 2021 1.25%-4.40%1,405,000 75,000 Total general obligations bonds 5,840,000$ 495,000$ 269 62 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 9. LONG-TERM DEBT (CONTINUED) Governmental Activities Long Term Debt (Continued) Annual debt service requirements to maturity for general obligation bonds are as follows: Principal Interest Total Year ending June 30, 2008 $ 495,000 $ 221,202 $ 716,202 2009 530,000 207,202 737,202 2010 540,000 191,622 731,622 2011 565,000 173,676 738,676 2012 590,000 154,198 744,198 2013-2017 1,565,000 452,598 2,017,598 2018-2022 1,555,000 144,388 1,699,388 5,840,000$ 1,544,886$ 7,384,886$ Special Assessment Debt - Special assessment bonds are payable from the collection of special assessments levied against benefited property owners within the special improvement district. To the extent that such special assessment collections are not sufficient to make the required debt service payments, the City is obligated to levy and collect a general property tax on all taxable property in the City to provide additional funding for the debt service payments. The cash balance in the SID Revolving Fund must equal at least 5% of the principal amount of bonds outstanding. If the cash balance is less than 5%, a levy is required to bring the cash balance to the required minimum. The City has issued various special assessment bonds with various maturities through 2025 at interest rates ranging from 2.5% to 5.75%. In addition, the City has issued three notes payable to finance special assessment projects. The following is a schedule of changes in special assessment debt: Balance June 30, 2006 Issuances Repayments Balance June 30, 2007 Special assessment bonds 6,476,869$ -$ (226,869)$ 6,250,000$ Note Payable to Montana Board of Investments 42,400 - (21,200) 21,200 Note Payable to Department of Natural Resources and Conservation, #WRF-05067 92,500 - (5,000) 87,500 Note Payable to Department of Natural Resources and Conservation, #SRF-05132 393,000 - (15,000) 378,000 7,004,769$ -$ (268,069)$ 6,736,700$ 270 63 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 9. LONG-TERM DEBT (CONTINUED) Governmental Activities Long Term Debt (Continued) Annual debt service requirements to maturity for special assessment notes payable are as follows: Notes Payable Year ending June 30,Principal Interest Total 2008 30,700$ 17,568$ 48,268$ 2009 20,000 15,913 35,913 2010 21,000 15,163 36,163 2011 22,000 14,856 36,856 2012 22,500 13,522 36,022 2013-2017 126,000 54,179 180,179 2018-2022 154,000 27,312 181,312 2023-2027 90,500 384 90,884 486,700$ 158,897$ 645,597$ Annual debt service requirements to maturity for special assessment bonds are as follows: Year ending June 30,Bonds 2008 310,000$ 2009 370,000 2010 370,000 2011 370,000 2012 370,000 2013-2017 1,845,000 2018-2022 1,955,000 2023-2027 660,000 6,250,000$ Substantially all special assessment bonds mature eighteen to twenty years after the date of issuance but are redeemable at the option of the City whenever cash is available in the respective funds for each issue. The City follows the policy of early redemption on these bonds. Accordingly, a schedule of future interest payments through maturity of the bonds is deemed to be not meaningful and has been excluded. 271 64 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 9. LONG-TERM DEBT (CONTINUED) Governmental Activities Long Term Debt (Continued) The net revenues of the water fund have been pledged as collateral to secure the debt service related to SID 665. This collateral is subordinate to commitments made prior to July 12, 1993 to pledge this collateral as a guarantee of the payment of other debt. In the event that the resources available to service debt related to SID 665 are insufficient, the City shall transfer amounts from the water fund to satisfy this obligation. The District will be under no obligation to reimburse the water fund for any such transfer. At this time, the City does not anticipate the need to make any such transfers. Notes Payable - Notes payable at June 30, 2007 are as follows: Due within one year Due after one year Total Note payable to Montana Board of Investments in uneven semi-annual installments including interest at variable rates through February 2008 79,198$ -$ 79,198$ Business-type Activities Long Term Debt Revenue Bonds - The City also issues bonds where the City pledges income derived from the acquired or constructed assets to pay debt service. Revenue bonds outstanding at June 30, 2007 are as follows: Balance June 30, 2006 Issuances Repayments Balance June 30, 2007 Revenue bonds $ 700,412 $ - $ (473,952) $ 226,460 272 65 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 9. LONG-TERM DEBT (CONTINUED) Business-type Activities Long Term Debt (continued) Revenue bonds consist of the following as of June 30, 2007: Interest Rate Amount Water System Refunding Revenue Bonds, Series 1995, serial maturities through December 2006 4.0%-6.5%-$ Water System Refunding Revenue Bonds, Series 1995, serial maturities through 2014 4.9%118,456 Water System Refunding Revenue Bonds, Series 1995, serial maturities through 2022 4.9%108,004 Total revenue bonds 226,460$ Shown on the accompanying financial statements as: Revenue bonds due within one year 82,867$ Revenue bonds due after one year 143,593 226,460$ Revenue bond debt service requirements to maturity are as follows: Principal Interest Total Year ending June 30, 2008 $ 82,867 $ 10,094 $ 92,961 2009 86,979 5,983 92,962 2010 27,622 2,440 30,062 2011 28,992 1,069 30,061 226,460$ 19,586$ 246,046$ The revenue bond ordinance specifies that the City shall establish various restricted asset accounts and distribute the net revenues for the water fund to the restricted asset accounts and set user rates at levels which will generate minimum net revenues, as defined. The revenue bond ordinances specify that City management and/or the City Commission shall take corrective actions to bring the City into compliance with the revenue bond ordinances, if necessary, and that bondholders shall have the right to institute proceedings, judicial or otherwise, to enforce the covenants of the revenue bond ordinances. The City is in compliance with applicable covenants as of June 30, 2007. 273 66 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 9. LONG-TERM DEBT (CONTINUED) Industrial Revenue and Private Activity Bonds The City issues tax exempt industrial revenue and private activity bonds to finance construction of facilities within the City which it sells on installment contracts to the facilities' users. The bonds and the interest payable thereon are not obligations of the City and do not constitute or give rise to a pecuniary liability or contingent liability of the City or a charge against the general credit or taxing power of the City. The bonds are issued under and collateralized by the indentures and are payable solely from the payments to be made pursuant to the loan agreements between the City and the facilities users. The bonds are not a lien on any of the City’s properties or revenues, other than the facilities for which they were issued. The City authorized the issuance of $1,600,000 of industrial development first mortgage revenue bonds (Montana Farm Bureau Federation - Mountain West Farm Bureau Nutak Insurance Company, Inc. Joint Venture Partnership Project), series 1981 dated August 1, 1981. The bonds have an interest rate of eleven percent per annum. The purpose of the bonds was to construct a state headquarters and commercial office facility at 502 South 19th Avenue, Bozeman, Montana. The final bond and interest payment is to be made on August 1, 2006. The City authorized the issuance of $1,100,000 of Limited Obligation First Mortgage Revenue bonds (Montana State University Foundation, Inc. Project), series 1995 dated March 15, 1995. The purpose of the bonds was to provide for the acquisition and construction of administrative, educational and related facilities, which is located contiguous to and is treated as part of the campus of Montana State University at 1501 South 11th Avenue, Bozeman, Montana. The bonds have interest rates ranging form 3.4% to 5.9%. The final bond and interest payment date is March 15, 2009. To provide financial assistance for the acquisition and improvements of the building occupied by a private elementary school, the City has issued a Private Activity Revenue Bond. This bond is secured by the property financed and is payable solely from payments received on the underlying mortgage loan. Upon repayment of the bond, ownership of the acquired facility transfer to the private-sector entity served by the bond issuance. Neither the City nor any political subdivision thereof is obligated in any manner for repayment of the bond. Accordingly, the bond is not reported as a liability in the accompanying financial statements. As of June 30, 2007, the Revenue Bond outstanding had an aggregate principal amount payable of $400,000. NOTE 10. CAPITAL LEASE OBLIGATIONS On May 8, 2004 the City entered into a lease for a Caterpillar grader. The lease term is five years payable in five consecutive annual installments with a balloon payment at maturity including interest at 4.0%. The total amount capitalized of $154,992 represents the present value of the future lease payments. The payments for this obligation are being recorded in the street maintenance fund. On June 1, 2002, the City entered into a lease for a Caterpillar 963C tractor loader. The lease term is three years payable in three consecutive annual installments with a balloon payment at maturity including interest at 5.2%. The total amount capitalized of $233,126 represents the present value of the future lease payments. The asset and capital lease obligation has been recorded in the solid waste fund. The lease obligation was satisfied during the year ended June 30, 2007. On June 1, 2004, the City entered into a lease for a Caterpillar Wheel Loader. The lease term is three years payable in three consecutive annual installments with a balloon payment at maturity including interest at 4.0%. The total amount capitalized of $199,164 represents the present value of the future lease payments. The asset and capital lease obligation has been recorded in the solid waste fund. The lease obligation was satisfied during the year ended June 30, 2007. 274 67 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 10. CAPITAL LEASE OBLIGATIONS (CONTINUED) The capital lease balance outstanding for governmental activities at June 30, 2007 is as follows: Balance June 30, 2006 Issuances Repayments Balance June 30, 2007 Capital lease $ 97,087 $ - $ (13,831) $ 83,256 The following is a schedule, by year, of future minimum lease payments under capital lease, together with the present value of minimum lease payments at June 30, 2007: Governmental Activities Year ending June 30, 2008 $ 86,725 Less amount representing interest (3,469) Present value of future minimum lease payments 83,256$ NOTE 11. CLASSIFICATION OF NET ASSETS In the Government-Wide Financial Statements, net assets are classified in the following categories: Invested in Capital Assets, Net of Related Debt – This category groups all capital assets, including infrastructure in future years, into one component of net assets. Accumulated depreciation and the outstanding balances of debt that are attributable to the acquisition, construction or improvement of these assets reduces this category. Restricted Net Assets – This category presents external restrictions imposed by creditors, grantors, contributors or laws or regulations of other governments and restrictions imposed by law through constitutional provision or enabling legislation. Additionally, this category presents restrictions placed on the categories of Capital Projects, Debt Service, and specific projects and programs established by the City Commission. Unrestricted Net Assets – This category represents the net assets of the City which are not restricted for any project or other purpose. 275 68 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 11. CLASSIFICATION OF NET ASSETS (CONTINUED) In the Fund Financial Statements, reserves and designations segregate portions of fund balance that are either not available or have been earmarked for specific purposes. The various reserves and designations are established by actions of the City Commission and Management and can be increased, reduced or eliminated by similar actions. As of June 30, 2007, reservations of governmental fund balance are described below: General Fund Prepaid items $ 3,000 Special Revenue Funds Prepaid items 522,750 Park development 353,886 Debt Service Funds Debt service payments 2,026,854 Permanent Fund Endowment 527,222 Total reserved fund balance 3,433,712$ NOTE 12. DEFICIT FUND BALANCES At June 30, 2007, the funds listed below had fund balance deficits. The deficit balances do not represent any type of legal violation, and it is the City management's opinion that the deficits will be eliminated by additional grant funding, collection of long-term receivables, or transfers from other funds. Debt Service Funds General Obligation Bonds Debt Service 115,558$ Capital Project Funds Combined Capital Projects 318,322 Special Revenue Funds Pension 30,097 Community Transportation 34,195 Street Lighting 86,264 276 69 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 13. DEFERRED COMPENSATION PLAN The City offers its employees a deferred compensation plan created in accordance with Internal Revenue Code Section 457. The plan, available to all City employees, permits them to defer a portion of their salary until future years. The deferred compensation is not available to employees until termination, retirement, death, or unforeseeable emergency. In accordance with Governmental Accounting Standards Board Statements No. 32, the City has removed the balances related to the deferred compensation plan as of June 30, 1998, as these amounts represent neither assets nor liabilities to the City, and the plan is administered by an independent third party. NOTE 14. EMPLOYEE BENEFIT PLANS Plan Description and Provisions - All City of Bozeman full-time employees participate in one of three statewide cost-sharing multiple-employer retirement benefit plans administered by the Public Employees Retirement Division (PERD). Contributions to the three plans are as required by State statute. Fiscal years 2007 and 2006 total payroll and covered payroll for all retirement plans were $14,232,073 and $13,458,764 respectively. Financial information for all three plans is reported in the Public Employees' Retirement Board's published Comprehensive Annual Financial Report for the fiscal year end. It is available from the PERD at 100 North Park Avenue, Suite 220, P.O. Box 200131, Helena, MT 59620-0131. The authority to establish, amend and provide cost of living adjustments to all three plans is assigned to the State legislature. The authority to establish and amend contribution rates to all three plans is also assigned to the State legislature. Public Employees' Retirement System (PERS) All City employees, except firefighters and police officers, are provided pension benefits by this multi-employer plan. Funding is provided by participating units of government and their covered employees. The City's contributions to this plan for the years ended June 30, 2007, 2006, and 2005 were $667,101, $633,185 and $620,459 respectively. One hundred percent of required contributions were made for all three years. Plan members are required to contribute 6.9% of their compensation. The City is also required to contribute 6.8% of members' compensation. The State is required to contribute .1% of members’ compensation, which was $9,810. Covered payroll for the year ended June 30, 2007 was $9,810,313. Defined Benefit Retirement Plan (DBRP) - Participants become eligible for benefits after age 60 and 5 years of service, after age 65 regardless of service, or 30 years of service regardless of age. The benefit is 1/56 of the final compensation for each year of credited service, paid as a modified cash refund annuity. A participant is eligible for early retirement benefits after age 50 and 5 years of service or after 25 years of service regardless of age. Rights become vested after 5 years of service. Defined Contribution Retirement Plan (DCRP) – Participants may elect the defined contribution plan, in which the contributions into the plan are known, but the benefit is not. The retirement benefit received is based upon account balance, which is determined by contributions made plus investment earnings, or losses, less administrative costs. The total number of participating employees in both the defined benefit and defined contribution plans at the City at June 30, 2007 is 211. 277 70 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 14. EMPLOYEE BENEFIT PLANS (CONTINUED) Firefighters' Unified Retirement System (FURS) Funding is provided by units of local government, their covered employees and the State of Montana. The City's contributions to this plan for the years ended June 30, 2007, 2006, and 2005 were $275,516, $256,686 and $225,176, respectively. One hundred percent of required contributions were made for all three years. Plan members are required to contribute 10.7% of monthly compensation, since all employees have elected to be covered under the guaranteed annual benefit adjustment (GABA). The City is required to contribute 14.36% of members' compensation. The State is required to contribute 32.61% of members' compensation, which was $625,667 for fiscal 2007. Covered payroll for the year ending June 30, 2007 was $1,918,634. Participants are eligible for benefits after 5 years of service and age 50. The benefit for participants hired prior to July 1, 1981 who have attained 50 years of age and 20 years of service is 50% of the monthly salary last received by the participant. Also, an additional 1% for each year of service in excess of 20 years, not to exceed a maximum of 60% of the recipient's latest monthly salary. A participant hired on or after July 1, 1981, or who retires prior to completion of 20 years of service, receives a benefit equal to 2.5% of average salary for each year of service, not to exceed 60%. Salary is averaged over the last 36 months for those hired on or after July 1, 1981. Rights become vested after 5 years of service. The total number of participating employees at the City of Bozeman at June 30, 2007 is 31. Municipal Police Officers' Retirement System (MPORS) Funding is provided by local units of government, their covered employees, and the State of Montana. The City's contributions to this plan for the years ended June 30, 2007, 2006, and 2005 were $360,701, $340,035, and $311,298, respectively. One hundred percent of required contributions were made for all three years. Plan members are required to contribute 9% of their compensation. The City is required to contribute 14.41% of members' compensation. The State is required to contribute 29.37% of members' compensation, which was $735,168. Covered payroll for the year ended June 30, 2007 was $2,503,127. Participants are eligible for retirement benefits after 20 years of service and age 50. The minimum age requirement does not apply to participants first employed prior to July 1, 1975. The benefit is 1/2 of average monthly salary during the highest 36 consecutive months of earnings plus 1% of average monthly salary for each additional year of service in excess of 20 years, to a maximum of 60%. Benefits are paid as a modified cash refund annuity. Rights become vested after 5 years of service. The total number of participating employees at the City at June 30, 2007 is 43. NOTE 15. POST-EMPLOYMENT BENEFITS In addition to providing a deferred compensation plan, the City allows its retired employees to continue their medical, dental and vision care coverage through the City's group health plan until death. The City's contract with Blue Cross/Blue Shield details the plan eligibility. MMIA is the administrator of the benefit plan. When an employee retires, they may continue coverage for themselves and their covered eligible dependents if they are eligible for public employees' retirement by virtue of their employment with the City of Bozeman. To continue coverage, they are required to pay the full cost of the benefits. The City also allows terminated employees to continue their health care coverage for 18 months past the date of termination as required by the Consolidated Omnibus Budget Reconciliation Act of 1985 (COBRA). For the fiscal year ended June 30, 2007, the City has 42 retired employees with premiums cost of $269,968. The City's current labor contracts do not include any obligations for payments to retirees. 278 71 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 16. JOINT VENTURE AGREEMENTS Joint ventures are legal entities or other organizations that result in a contractual arrangement, and that are owned, operated, or governed by two or more participants. Each participant retains both an ongoing financial interest and an ongoing financial responsibility. Joint ventures are legal entities or other organizations that result in a contractual arrangement, and that are owned, operated, or governed by two or more participants. Each participant retains both an ongoing financial interest and an ongoing financial responsibility. As of June 30, 2007, the City has entered into two joint venture contractual arrangements, as described below. 911 Communication Center The City and Gallatin County, Montana (the County) have entered into an inter-local agreement for the purposes of establishment of the operation and financing of a 911 communication services division (the Division) for dispatch and records services, to define the relationship of the Administrative Board with the City and County, and to establish the line of authority for personnel furnishing the communication services to the City and County and others who may contract for the services. Though the City has no equity interest in the Division, the City has indirect access to the joint venture’s resources, as the Division’s purpose is of direct interest to the City, and the City has the ability to influence the management of the Division. In addition, the City and County have agreed to pay 45% and 55% of the Division expenditures, respectively. The agreement expired December 19, 2005, and automatically renewed until terminated by either party. Financial information regarding the Division can be obtained by contacting Shelley Vance, Gallatin County, Clerk and Records Office, 311 West Main, Bozeman, MT 59715. City-County Drug Forfeitures The City and Gallatin County, Montana (the County) have entered into an inter-local agreement for the purposes of establishment of a joint drug forfeiture account funded from drug related forfeitures, seizures and prosecutions of City and County law enforcement cases and to establish an equitable means of distributing those funds to continue drug interdiction activities. The goal of the agreement is to make the City and County Drug Enforcement operations less reliant on the general and public safety fund monies of the City and County. The original term of the agreement was for a period of one year, beginning September 20, 2004 and automatically renews for a period of one year until terminated by either party with written notice of intent to terminate. Financial information regarding the joint drug forfeiture account can be obtained by contacting the City of Bozeman Department of Finance, 411 East Main Street, Bozeman, MT 59715. 279 72 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 17. RESTRICTED ASSETS At June 30, 2007, the balances of restricted asset accounts are as follows: Business-Type Activities Governmental Activities Water Fund Waste Water Fund Total Restricted by revenue bond covenants For debt service -$ 499,990$ -$ 499,990$ For bond reserve - 158,230 - 158,230 For operations - 270,500 - 270,500 Restricted by ordinance Cash in lieu of parking 19,694 - - 19,694 Cemetery perpetual care 527,222 - - 527,222 Impact fees 7,770,591 5,522,547 10,648,599 23,941,737 8,317,507$ 6,451,267$ 10,648,599$ 25,417,373$ NOTE 18. INTERFUND TRANSFERS AND ASSETS/LIABILITIES A summary of interfund transfers reported in the fund financial statements for the year ended June 30, 2007 follows: Transfers From Governmental Funds Proprietary Funds General Fund Impact Fees SID Sinking Nonmajor Governmental Water Waste Water Solid Waste Total General Fund -$ -$ 130,846$ 2,686,874$ -$ -$ -$ 2,817,720$ Impact Fees - - - - 146,010 343,770 - 489,780 SID Sinking - - - 130,846 - - - 130,846 Capital Projects - 496,393 - 9,318 - - - 505,711 Nonmajor Governmental 621,498 - - 341 - - - 621,839 621,498$ 496,393$ 130,846$ 2,827,379$ 146,010$ 343,770$ -$ 4,565,896$ Transfers To 280 73 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 18. INTERFUND TRANSFERS AND ASSETS/LIABILITIES (CONTINUED) Transfers are used to (1) move revenues from the fund that statute or budgets requires to collect them to the fund that statute or budgets require to expend them, (2) use unrestricted revenues collected in the general fund to finance various programs accounted for in other funds in accordance with budgetary authorizations, and (3) to transfer non-restricted interest income from the permanent fund to the general fund. A summary of due from/to other funds at June 30, 2007, is as follows: Due From Due To Major Funds: General Fund 2,247,401$ 11,566$ SID Debt Service 10,695 - Construction - 499,609 Nonmajor Funds: Special Revenue Funds Departmental Special Revenues - 334,592 Insurance - 98,983 Pension - 112,710 Drug Forfeiture - 33,447 Parking Districts - 34,615 Community Transportation - 306,810 Street Lighting - 141,959 Debt Service Funds SID Revolving 2,888 - GO Bonds - 344,862 Internal Service Medical Health Insurance - 353,397 Fiduciary Funds Municipal Court 11,566 - 2,272,550$ 2,272,550$ Interfund balances reported as due from or due to other funds are a result of transfers for reporting purposes to cover negative cash balances within a fund. These transfers are reversed as cash becomes available in a fund where cash previously had been in a deficit. 281 74 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 19. RISK MANAGEMENT The City faces a considerable number of risks of loss, including a) damage to and loss of property and contents, b) employee torts, c) professional liability (i.e. errors and omissions), d) environmental damage, e) workers' compensation (i.e. employee injuries), and f) medical insurance cost of employees. A variety of methods are used to provide insurance for these risks. Commercial policies, transferring all risks of loss except for small deductible amounts, are purchased for property and content damage and professional liabilities. The City participates in two state-wide public risk pools operated by the Montana Municipal Insurance Authority, for workers' compensation and for tort liability. Employee medical insurance is provided through a privately-administered, partially self- insured plan. Given the lack of coverage available, the City has no coverage for potential losses from environmental damages. Commercial Policies Coverage limits and the deductibles on the commercial policies have stayed relatively constant for the last several years. The premiums for the policies are allocated between the City's Enterprise Funds and the General Fund. Premiums are subsidized through a special purpose property tax levy, based on total appropriations. Settled claims resulting from these risks did not exceed commercial insurance coverage during the three years ended June 30, 2007, 2006, and 2005. Public Entity Risk Pools In 1986, the City joined together with other Montana cities to form the Montana Municipal Insurance Authority which established a workers' compensation plan, and a tort liability plan. Both public entity risk pools currently operate as common risk management and insurance programs for the member governments. The liability limits for damages in tort action are $750,000 per claim and $1.5 million per occurrence, and $2.5 million per occurrence for any claim that is not subject to the limitations on governmental liability, as described in Montana Code Annotated Section 2-9-108 (the Statute) or any successor stature, either as matter of law, by operation of the Stature, or by a judicial determination that the Statute is inapplicable or is otherwise invalid, with $11,250 deductible per occurrence. State tort law limits the City's liability to $1.5 million. The City pays premiums for its employee injury insurance coverage, which is allocated to the employer funds based on total salaries and wages. The agreements for formation of the pools provide that they will be self-sustaining through member premiums. The tort liability plan and workers' compensation program issued debt of $4.41 million and $6.155 million, respectively, to immediately finance the necessary insurance reserves. All members signed a contingent note for a pro rata share of this liability in case operating revenues were insufficient to cover the debt service. At June 30, 2007, the City's share is $129,337 for workers' compensation; based on the plan's current financial position, the City doesn't expect to make any payment on these notes. The City also owns a policy with MMIA for loss or damage to property. This is an all risk policy, essentially all property owned by the City being insured for 100% of replacement cost, subject to a $5,000 deductible per occurrence. MMIA reinsures their property insurance with a national municipal pool, Public Entities’ Property Insurance. 282 75 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 19. RISK MANAGEMENT (CONTINUED) Self- Insurance Starting in 1992, the City has provided medical insurance coverage for its employees via a partially self-insured plan administered by Blue Cross/Blue Shield. It provides medical, dental, and vision benefits and is operated as an Internal Service Fund. Rates are determined in consultation with Blue Cross/Blue Shield based on past claim experience for the coming year plus an administrative fee. The rates include a premium for a commercial "stop-loss" policy for when individual claim exceeds $75,000 in covered charges during a year. A reconciliation of claims payable follows: June 30, 2007 June 30, 2006 Claims payable, beginning of year 225,031$ 120,404$ Claims incurred during year 2,213,607 2,531,393 Claims paid during year (2,438,638) (2,426,766) Claims payable, end of year -$ 225,031$ On July 1, 2006 the City began purchasing employee health insurance from the Montana Municipal Insurance Authority’s Employee Health Benefits program; as of that date the City was no longer self-funded for health insurance claims. The fiscal year ending June 30, 2006 was the last year that the City was self- funded for employee health insurance claims. Over the course of the next months, the City paid claims that had been incurred but not reported as of June 30, 2006. On May 22, 2007, the City’s self-funded program administrator informed the City that they were closing out administration of Bozeman’s FY06 Self- Insured Health Benefits fund. The fund was closed because all incurred claims under the self-funded plan had been reported and paid. Going forward, as a purchaser of health insurance coverage, the City will have not ―incurred but not reported‖ liabilities. NOTE 20. CONTINGENCIES Jewel v. City of Bozeman / State of Montana v. City of Bozeman This action was filed in the United States District Court for the District of Montana. The multi-count complaint reduced itself to a cost recovery action under the Federal Superfund (CERCLA) and State Superfund (CECRA). On July 8, 1999, the City, Jewel Food Stores, Inc. and the other parties reached a final settlement agreement in this action. The settlement, in part, required Jewel Food Stores, Inc. to pay the City of Bozeman $1,200,000, the City and Jewel to extend alternative water supply to businesses and residents in the North 19th Avenue area of the City; and Jewel and the City to share specified remediation costs on an equal basis (50% each) up to a cumulative amount of $4,000,000, and for eligible costs in excess of that amount, to be shared 70% by Jewel and 30% by the City. The City is reimbursed by insurers for 23% of the City’s expenditures for these purposes. As of the June 30, 2007, the only remaining work at the site is the final plume monitoring of the wells and remedial activity within the plume area. It is reasonably possible that the City will incur remediation costs as outlined in the settlement, however, the amount of costs for which the City is contingently liable cannot be reasonably estimated at this time. Accordingly, no liability has been recorded in the accompanying financial statements. 283 76 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 20. CONTINGENCIES (CONTINUED) Montana Public Employees Retirement Administration (MPERA) In 2005, MPERA alleged that the City’s cafeteria plan was not compliant with regard to both IRS and Montana standards with regard to the treatment of pre-tax contributions to the plan by highly compensated employees. It is expected that MPERA will at some time audit the City with regard to compliance with new MPERA standards surrounding salary deferrals and compensation. The City is vigorously defending these allegations. At this time, the City’s exposure is not known. Accordingly, no liability has been recorded in the accompanying financial statements. Potential Liable Party from the Montana Department of Environmental Quality The City of Bozeman received a letter dated November 22, 2006, naming the City a potential liable party from the DEQ concerning the property surrounding the library for remediation and cleanup of asbestos. The City is current reviewing the impact of this action. At this time, the City’s exposure is not known, but the cost of remediation by the City may be significant. The City is involved with numerous other lawsuits which arise out of the normal course of operations by the City. Management of the City intends to vigorously defend each claim and believes no material losses will be incurred on such claims. NOTE 21. CONSTRUCTION COMMITMENT On November 8, 1995, the citizens of Bozeman approved a $5,000,000 bond issue to finance a series of transportation projects contained in the Bozeman Urban Transportation Plan Update. At the close of fiscal 2007, $6,558,224 had been spent on these construction projects from bond proceeds and accumulated fund investment earnings. NOTE 22. SOLID WASTE LANDFILL CLOSURE AND POST-CLOSURE CARE COSTS State and Federal laws and regulations require the City to place a final cover on its landfill site when it stops accepting waste and to perform certain maintenance and monitoring functions at the site for 30 years after final closure. The $2,449,511 reported as landfill closure and post-closure care liability at June 30, 2007, represents the cumulative amount reported to date based on the use of 95% of the total capacity of the landfill. This amount represents a $60,368 decrease from the $2,509,879 liability reported last year. These amounts are based on what it would cost to perform all closure and post-closure care in 2007. The City expects to close the landfill in 2009. In 2007, the City budgeted for, and funded, landfill closure and post-closure care liability through normal operations and is in compliance with EPA requirements. 284 77 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 23. SEGMENT INFORMATION FOR WATER ENTERPRISE FUND The City’s Water Fund accounts for the City’s water utility operations and collection and administration of water impact fees. Segment information for the utility operations, excluding impact fees, is as follows: Condensed Statement of Net Assets Current assets 7,432,315$ Capital assets 87,710,173 Other assets 2,826,254 Total assets 97,968,742$ Current liabilities 603,242$ Noncurrent liabilities 143,592 Total liabilities 746,834 Invested in capital assets, net of related debt 87,483,713 Restricted for debt service 865,513 Unrestricted 8,872,682 Total net assets 97,221,908 Total liabilities and net assets 97,968,742$ 285 78 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 23. SEGMENT INFORMATION FOR ENTERPRISE FUND (CONTINUED) OPERATING REVENUES AND EXPENSES Operating revenues 6,124,531$ Operating expenses Depreciation 7,339,793 Other operating 3,033,243 Total operating expenses 10,373,036 Operating loss (4,248,505) NONOPERATING REVENUES (EXPENSES) Interest income 425,138 Interest expense (23,391) Grant income 281,181 Contributions of infrastructure 12,411,654 Other income 201,439 Total nonoperating revenues 13,296,021 Change in net assets 9,047,516 NET ASSETS, beginning of year 16,662,763 prior period adjustments 71,511,629 NET ASSETS, end of year 97,221,908$ Net cash provided by operating activities 3,792,304$ Net cash flows from capital and related financing activities (497,343) Net cash flows from noncapital and financing activities 469,547 Net cash flows from investing activities (375,375) Net increase (decrease) in cash flows 3,389,133 Beginning cash and equivalents 5,968,065 Ending cash and equivalents 9,357,198$ 286 79 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 24. IMPACT FEES On January 22, 1996, the City Commission adopted fire, water, waste water and street impact fees in Ordinance number 1414. The impact fees were first effective on March 23, 1996. Impact fees were set at a percentage of the cost of the impact, as follows: Original, as of March 23, 1996 Change as of May 10, 1998 Change as of January 15, 1999 Change as of July 15, 1999 Fire impact fee 90%90%90%90% Water impact fee 35%50%90%90% Waste water impact fee 35%50%90%90% Street impact fee 10%10%75%90% An applicant may obtain an Impact Fee Credit by dedication of non-site-related land or construction of non-site-related improvements. Credits must be made before the beginning of improvement construction, must comply with the City’s Capital Improvements Program, and must be approved by the City Commission. Credits may be used only for like-type impact fees. The full provisions for impact fee credits are contained in Chapter 3.24 of the Bozeman Municipal Code. For proprietary type funds, the City records a liability for the impact fee credit and capitalizes the underlying asset. For governmental type funds the credits are only disclosed in the footnotes. For government-wide financial reporting the outstanding credits are reported as unearned revenue. The Water Impact Fee Fund, Street Impact Fee Fund, and Wastewater Impact Fee Fund have recorded impact fee credits amounting to $39,987, $451,942, and $21, respectively, as of June 30, 2007. The Fire Impact Fee Fund does not have any outstanding credits. The following impact fee revenues were collected and expensed/expended during fiscal year 2007: Beginning balances Impact fees Other income Expenses, expenditures and transfers Ending balances Fire 1,829,360$ 343,448$ 100,142$ (26,560)$ 2,246,390$ Water 4,042,573 1,592,670 260,718 (240,395) 5,655,566 Waste water 8,971,708 1,959,935 497,670 (449,491) 10,979,822 Streets 2,928,200 2,600,196 744,479 (710,914) 5,561,961 Total 17,771,841$ 6,496,249$ 1,603,009$ (1,427,360)$ 24,443,739$ 287 80 CITY OF BOZEMAN, MONTANA NOTES TO FINANCIAL STATEMENTS (CONTINUED) JUNE 30, 2007 NOTE 25. COMPONENT UNIT COMMITMENT As of December 31, 2004, the Bozeman Public Library Foundation had made a commitment to raise $4,000,000 for the construction of the new Bozeman Public Library. In February 2005, the Foundation passed a motion that authorized a $4,850,000 grant to the City of Bozeman. Upon groundbreaking for the new library facility, the Foundation began distributing the grant as follows: $200,000 per month that began in April 2005 and extends through September 2006. The Foundation released an additional $500,000 to the City when a donor's condition was met to break ground prior to June 1, 2005. The Foundation also adopted a goal to raise an additional $1,000,000 through a community campaign. During the year ended June 30, 2007, the Foundation contributed $1,000,000 to the City for construction of the new Library, and is presented on the Statement of Activities as Miscellaneous Income. NOTE 26. SUBSEQUENT EVENT On November 30, 2007, the City removed $39.4M from the State’s Short Term Investment Pool. Of that amount, $11.3 million was deposited with US Bank in a 100% pledged Municipal Investor Account, $27.6 Million was invested in a ladder of agency bonds, and $500,000 was retained in the City’s operating bank account. NOTE 27. PRIOR PERIOD ADJUSTMENTS The proprietary funds reflect a prior period adjustment to record contributed fixed assets from prior periods. The entries debited infrastructure and credited net assets for $71,511,629 and $38,675,140 in the water and waste water funds, respectively. The City also has two prior period adjustments to the governmental funds on the Statement of Activities entity-wide statements. The first entry is to record infrastructure prior to the implementation of GASB 34. It consists of a debit of $5,702,919 to infrastructure, net of depreciation, and a credit to net assets. The second entry is to record donated infrastructure from July 1, 2003 to June 30, 2007. It is a debit of $25,980,021 to infrastructure, net of depreciation, and a credit to net assets. 288 C. REQUIRED SUPPLEMENTARY INFORMATION OTHER THAN MANAGEMENT DISCUSSION AND ANALYSIS 289 81 CITY OF BOZEMAN, MONTANA SCHEDULE OF REVENUE, EXPENDITURES, AND CHANGES IN FUND BALANCES – BUDGET TO ACTUAL GENERAL FUND Year Ended June 30, 2007 Variance with Actual Final Budget Original Final Amounts Positive (Negative) Budgetary fund balance, July 1 3,179,099$ 3,179,099$ 3,179,099$ -$ Resources (inflows): Taxes 8,043,442 8,043,442 8,035,738 (7,704) Special assessments - - 142 142 Licenses and permits 260,750 260,750 281,948 21,198 Intergovernmental 4,321,293 4,321,293 4,190,780 (130,513) Charges for services 1,770,533 1,770,533 1,855,735 85,202 Fines and forfeitures 1,346,500 1,346,500 1,337,098 (9,402) Sale of assets - - 489,702 489,702 Interest on investments 70,000 70,000 90,444 20,444 Transfers from other funds 2,809,580 2,809,580 2,817,720 8,140 Other 135,500 135,500 189,671 54,171 Amounts available for appropriation 21,936,697 21,936,697 22,468,077 531,380 Charges to appropriations (outflows): Current General government 4,430,372 4,430,372 4,019,330 411,042 Public safety 7,108,456 8,061,456 8,040,649 20,807 Public service 690,856 690,856 604,736 86,120 Public welfare 3,739,470 3,591,470 3,320,367 271,103 Other 1,932,000 921,000 381,518 539,482 Capital outlay 395,189 1,024,189 1,022,734 1,455 Debt service 162,055 162,055 86,707 75,348 Transfers to other funds 652,013 652,013 621,498 30,515 Total charges to appropriations 19,110,411 19,533,411 18,097,539 1,435,872 Budgetary fund balance, June 30 2,826,286$ 2,403,286$ 4,370,538$ 1,967,252$ Budgeted Amounts 291 82 CITY OF BOZEMAN, MONTANA SCHEDULE OF REVENUE, EXPENDITURES, AND CHANGES IN FUND BALANCES – BUDGET TO ACTUAL STREET AND FIRE IMPACT FEE SPECIAL REVENUE FUND Year Ended June 30, 2007 Variance with Actual Amounts Final Budget Original Final Budgetary Basis Positive (Negative) Budgetary fund balance, July 1 4,757,561$ 4,757,561$ 4,757,561$ -$ Resources (inflows): Charges for services 2,550,000 2,550,000 2,943,645 393,645 Interest on investments 190,000 190,000 354,841 164,841 Transfers from other funds - - 489,780 489,780 Amounts available for appropriation 7,497,561 7,497,561 8,545,827 1,048,266 Charges to appropriations (outflows): Current Public safety - - 26,560 (26,560) Public service 6,200,000 6,200,000 214,522 5,985,478 Transfers to other funds - - 496,393 (496,393) Total charges to appropriations 6,200,000 6,200,000 737,475 5,462,525 Budgetary fund balance, June 30 1,297,561$ 1,297,561$ 7,808,352$ 6,510,791$ Budgeted Amounts 292 83 CITY OF BOZEMAN, MONTANA NOTES TO REQUIRED SUPPLEMENTARY INFORMATION OTHER THAN MANAGEMENT DISCUSSION AND ANALYSIS Year Ended June 30, 2007 General Impact Fund Fees Sources/inflows of resources Actual amounts (budgetary basis) "available for appropriation" from the budgetary comparison schedule 22,468,077$ 8,545,827$ Differences - budget to GAAP: The fund balance at the beginning of the year is a budgetary resource but is not a current-year revenue for financial reporting purposes.(3,179,099) (4,757,561) Transfers from other funds are inflows of budgetary resources but are not revenues for financial reporting purposes.(2,817,720) - The proceeds from the sale of assets are budgetary resources but are regarded as a special item, rather than revenue, for financial reporting purposes (489,702) (489,780) Total revenues as reported on the statement of revenues, expenditures, and changes in fund balances - governmental funds 15,981,556$ 3,298,486$ Uses/outflows of resources Actual amounts (budgetary basis) "total charges to appropriations" from the budgetary comparison schedule 18,097,539$ 737,475$ Differences - budget to GAAP: Transfers to other funds are outflows of budgetary resources but are not expenditures for financial reporting purposes.(621,498) (496,393) Total expenditures as reported on the statement of revenues, expenditures, and changes in fund balances - governmental funds 17,476,041$ 241,082$ 293 D. SUPPLEMENTAL INFORMATION 294 COMBINING AND INDIVIDUAL FUND STATEMENTS AND SCHEDULES 295 NONMAJOR GOVERNMENTAL FUNDS SPECIAL REVENUE FUNDS Departmental Special Revenues – Accounts for monies received and expended for projects relating to various City departments. City Planning Board – Accounts for monies received from various sources including property taxes, fees, and County revenues. Expenditures are for short-term and long-term planning of City and adjacent County zones. Section 76-1-102 MCA provides that the purpose of City planning is to encourage local governments to improve the present health, safety, convenience, and welfare of the citizens. Insurance – Accounts for property tax revenues received and transferred to the general fund for premiums and deductibles on group insurance coverage for City employees and City’s property and liability insurance other than for proprietary funds. (The accounting for self insurance activities are captured in the Internal Service Funds.) Pension – Accounts for property tax revenues received and transferred to other funds for the City’s share of entitlement benefits for the police officers, firefighters, and other City employees, under regulation of the State government. The City is the Agent/Employer for this program, which is administered by the State. Gas Tax Apportionment – Accounts for revenues from State gasoline taxes apportioned from the State of Montana Department of Highways. Drug Forfeitures – Accounts for monies received from fines and forfeitures of drug-related criminal prosecution, to be expended on drug law enforcement and education. City-County Drug Forfeitures – Accounts for monies received from fines and forfeitures of drug-related criminal prosecution, from an inter-local agreement with Gallatin County, to be expended on drug law enforcement and education. Beautification of Bozeman– Accounts for monies for special beautification projects throughout Bozeman. Street and Tree Maintenance – Accounts for special assessment revenues levied, received, and expended for street and tree maintenance provided to specific property owners. Consolidated Parking Districts– Accounts for receipts and revenues and related expenditures for the various parking districts, in accordance to Title 7, Chapter 14 MCA. Law and Justice Center – Accounts for the receipt and expenditure of monies earmarked by the City Commission for the City’s share of the Law and Justice Center renovation. Special Projects – Accounts for the receipt and expenditure of Valley Unit Special Improvement District funds which are in excess of the amounts required to retire the outstanding SID indebtedness. Community Transportation – Accounts for federal funding for highways, mass transit, and alternative transportation programs as defined by the Intermodal Surface Transportation Efficiency Act (ISTEA). Money is distributed on a per-capita basis. Building Inspection – This fund was established to account for all activity of enforcing the building regulations adopted by the City. It includes all the money and staff associated with executing any aspect of the code enforcement program. Section 50-60-101 MCA established the code enforcement program requirement. 296 Highway Safety Improvement Projects – Accounts for grants, other revenues, and expenditure related to the U. S. Department of Transportation funded program to reduce number and severity of traffic accidents. Economic Development Revolving Loan Fund – Accounts for revenues received and expended relative to loans made in accordance with the Community Development Block Grant Program, for economic development purposes. Housing Revolving Loan Fund – Accounts for revenues received and expended relative to loans made in accordance with the Community Development Block Grant Program, for housing development purposes. Community Housing – Accounts for money set aside by the City Commission and related expenditure for the establishment of safe, decent and affordable housing for low and moderate-income citizens. Downtown Improvement District – In November 1995, the City adopted an Urban Renewal Plan for the downtown area. This fund accounts for the revenue and expenditures associated with the district. Street Lighting – Accounts for special assessment revenues levied, received and expended for street and public highway lighting provided to specific property owners. Park Land – Accounts for monies donated for the purpose of acquiring and developing City Parks. Municipal Court Restitution – Accounts for checks that were canceled on the restitution checking account, per MCA 46-18-250. DEBT SERVICE FUNDS Special Improvement District (SID) Revolving – Accounts for property tax revenues received and expended for the payment of special improvement district bond principal and interest. General Obligation Bonds Debt Service Fund – Accounts for the debt service payments associated with the Library and Transportation general obligation bonds. PERMANENT FUNDS Perpetual Cemetery Care- Accounts for 15% maintenance fee received from the sale of City cemetery plots which is to be used for perpetual care. The interest income from the trust is transferred to the general fund for use in maintaining the City’s cemetery. 297 84 CITY OF BOZEMAN, MONTANA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS June 30, 2007 Special Revenue Funds Special Revenue Funds Departmental City Special Planning Gas Tax Revenues Board Insurance Pension Apportionment ASSETS Cash and cash equivalents 1,955,249$ 356,120$ 5,018$ 36,480$ 258,261$ Receivables Property taxes 7,803 10,462 163,823 66,622 - Accrued interest - - - - - Customers, net 14,329 126 - - 497 Special assessments - - - - - Other governments 342,001 - - - - Due from other City funds - - - - - Prepaid expenditures - - - - - Notes receivable - - - - - Restricted cash and cash equivalents 25,000 - - - - Total assets 2,344,382 366,708 168,841 103,102 258,758 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable 81,961 104,994 - - 1,639 Escheat property payable - - - - - Accrued employee benefits payable - 416 - - - Deferred revenue 3,126 3,804 50,194 20,489 - Due to other City funds 334,592 - 98,983 112,710 - Total liabilities 419,679 109,214 149,177 133,199 1,639 Fund balances: Reserved for: Park development - - - - - Prepaid items - - - - - Unreserved 1,924,703 257,494 19,664 (30,097) 257,119 Total fund balances 1,924,703 257,494 19,664 (30,097) 257,119 Total liabilities and fund balances 2,344,382$ 366,708$ 168,841$ 103,102$ 258,758$ 298 85 CITY OF BOZEMAN, MONTANA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) June 30, 2007 Special Revenue Funds Special Revenue Funds City-County Beauti-Street and Consolidated Law and Drug Drug fication Tree Parking Justice Forfeitures Forfeitures of Bozeman Maintenance Districts Center ASSETS Cash and cash equivalents -$ 261,895$ 4,486$ 674,881$ 102,609$ -$ Receivables Property taxes - - - - - - Accrued interest - - - - - - Customers, net 1,659 - - 21,836 - - Special assessments - - - 81,878 15,494 - Other governments 44,063 7,915 - - - - Due from other City funds - - - - - - Prepaid expenditures - - - - - 522,750 Notes receivable - - - - 1,739 - Restricted cash and cash equivalents - - - - 19,694 - Total assets 45,722 269,810 4,486 778,595 139,536 522,750 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable 2,934 - 288 89,210 13,458 - Escheat property payable - - - - - - Accrued employee benefits payable - - - 1,548 - - Deferred revenue - - - 48,866 1,739 - Due to other City funds 33,447 - - - 34,615 - Total liabilities 36,381 - 288 139,624 49,812 - Fund balances: Reserved for: Park development - - - - - - Prepaid items - - - - - 522,750 Unreserved 9,341 269,810 4,198 638,971 89,724 - Total fund balances 9,341 269,810 4,198 638,971 89,724 522,750 Total liabilities and fund balances 45,722$ 269,810$ 4,486$ 778,595$ 139,536$ 522,750$ (continued) 299 86 CITY OF BOZEMAN, MONTANA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) June 30, 2007 Special Revenue Funds Special Revenue Funds Economic Housing Special Community Building Highway Development Revolving Projects Transportation Inspection Safety Revolving Loan Loan Fund ASSETS Cash and cash equivalents 275,149$ -$ 1,078,343$ 20,032$ 24,285$ 92,034$ Receivables Property taxes - - - - - - Accrued interest - - - - Customers, net - - 18,667 - - - Special assessments - - - - - - Other governments - 274,049 - - 15,000 - Due from other City funds - - - - - - Prepaid expenditures - - - - - - Notes receivable - - - - 936,404 47,766 Restricted cash and cash equivalents - - - - - - Total assets 275,149 274,049 1,097,010 20,032 975,689 139,800 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable 4,765 1,434 42,607 - 38,234 - Escheat property payable - - - - - - Accrued employee benefits payable - - 16,186 - - - Deferred revenue - - - - 936,404 47,766 Due to other City funds - 306,810 - - - - Total liabilities 4,765 308,244 58,793 - 974,638 47,766 Fund balances: Reserved for: Park development - - - - - - Prepaid items - - - - - - Unreserved 270,384 (34,195) 1,038,217 20,032 1,051 92,034 Total fund balances 270,384 (34,195) 1,038,217 20,032 1,051 92,034 Total liabilities and fund balances 275,149$ 274,049$ 1,097,010$ 20,032$ 975,689$ 139,800$ (continued) 300 87 CITY OF BOZEMAN, MONTANA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) June 30, 2007 Special Revenue Funds Downtown Community Improvement Street Park Municipal Court Housing District Lighting Land Restitution ASSETS Cash and cash equivalents 145,229$ 520,291$ 45,325$ 353,886$ 1,644$ Receivables Property taxes - - - - - Accrued interest - - - Customers, net - - - - - Special assessments - 2,227 27,927 - - Other governments - - - - - Due from other City funds - - - - - Prepaid expenditures - - - - - Notes receivable 97,083 - - - - Restricted cash and cash equivalents - - - - - Total assets 242,312 522,518 73,252 353,886 1,644 LIABILITIES AND FUND EQUITY Liabilities: Accounts payable - 10,349 11,661 - 1,000 Escheat property payable - - - - 626 Accrued employee benefits payable - - - - - Deferred revenue 97,083 2,626 5,896 - - Due to other City funds - - 141,959 - - Total liabilities 97,083 12,975 159,516 - 1,626 Fund balances: Reserved for: Park development - - - 353,886 - Prepaid items - - - - - Unreserved 145,229 509,543 (86,264) - 18 Total fund balances 145,229 509,543 (86,264) 353,886 18 Total liabilities and fund balances 242,312$ 522,518$ 73,252$ 353,886$ 1,644$ 301 88 CITY OF BOZEMAN, MONTANA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) June 30, 2007 Total ASSETS Cash and cash equivalents 6,211,217$ Receivables Property taxes 248,710 Accrued interest - Customers, net 57,114 Special assessments 127,526 Other governments 683,028 Due from other City funds - Prepaid expenditures 522,750 Notes receivable 1,082,992 Restricted cash and cash equivalents 44,694 Total assets 8,978,031 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable 404,534 Escheat property payable 626 Accrued employee benefits payable 18,150 Deferred revenue 1,217,993 Due to other City funds 1,063,116 Total liabilities 2,704,419 Fund balances: Reserved for: Park development 353,886 Prepaid items 522,750 Unreserved 5,396,976 Total fund balances 6,273,612 Total liabilities and fund balances 8,978,031$ 302 89 CITY OF BOZEMAN, MONTANA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) June 30, 2007 Permanent Debt Service Fund Fund Total Nonmajor SID G.O.Cemetery Governmental Revolving Bonds Total Care Funds ASSETS Cash and cash equivalents 569,446$ 182,121$ 751,567$ 556,594$ 7,519,378$ Receivables Property taxes - 68,527 68,527 - 317,237 Accrued interest - - - - Customers, net - - 5,471 62,585 Special assessments - - - - 127,526 Other governments - - - - 683,028 Due from other City funds 2,888 - 2,888 - 2,888 Prepaid expenditures - - - - 522,750 Notes receivable - - - - 1,082,992 Restricted cash and cash equivalents - - - - 44,694 Total assets 572,334 250,648 822,982 562,065 10,363,078 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable - - - - 404,534 Escheat property payable - - 626 Accrued employee benefits payable - - - - 18,150 Deferred revenue - 21,344 21,344 34,843 1,274,180 Due to other City funds - 344,862 344,862 - 1,407,978 Total liabilities - 366,206 366,206 34,843 3,105,468 Fund balances: Reserved for: Cemetery perpetual care - - - 527,222 527,222 Park development - - - - 353,886 Debt service 572,334 - 572,334 - 572,334 Prepaid items - - - - 522,750 Unreserved - (115,558) (115,558) - 5,281,418 Total fund balances 572,334 (115,558) 456,776 527,222 7,257,610 Total liabilities and fund balances 572,334$ 250,648$ 822,982$ 562,065$ 10,363,078$ 303 90 CITY OF BOZEMAN, MONTANA COMBINING STATEMENT OF REVENUE, EXPENDITURES, AND CHANGES IN FUND BALANCE- NONMAJOR GOVERNMENTAL FUNDS Year Ended June 30, 2007 Departmental City Special Planning Gas Tax Revenues Board Insurance Pension Apportionment REVENUES Taxes 70,869$ 128,261$ 1,719,546$ 697,405$ -$ Special assessments - - - - - Licenses and permits - - - - - Intergovernmental 356,595 61,410 78,682 283,040 583,784 Charges for services 4,006 517,193 - - - Fines and forfeitures 86,167 - - - - Interest on investments 75,162 15,523 - 408 11,178 Loan repayment - - - - - Other 160,779 15,253 - - - Total revenues 753,578 737,640 1,798,228 980,853 594,962 EXPENDITURES Current General government 25,832 897,558 - - - Public safety 344,740 - - - - Public service - - - - 166,355 Public welfare 75,881 - - - - Other 64,790 - - - - Capital outlay 150,708 24,441 - - 413,984 Debt service Principal - - - - - Interest and fiscal fees - - - - - Total expenditures 661,951 921,999 - - 580,339 Revenues over (under) expenditures 91,627 (184,359) 1,798,228 980,853 14,623 OTHER FINANCING SOURCES (USES) Transfers in 250,339 245,000 - - - Transfers out (9,658) - (1,804,458) (989,123) - Sale of capital assets - - - - - Total other financing sources and uses 240,681 245,000 (1,804,458) (989,123) - Net change in fund balance 332,308 60,641 (6,230) (8,270) 14,623 FUND BALANCES, beginning of year 1,592,395 196,853 25,894 (21,827) 242,496 FUND BALANCES, end of year 1,924,703$ 257,494$ 19,664$ (30,097)$ 257,119$ Special Revenue Funds 304 91 CITY OF BOZEMAN, MONTANA COMBINING STATEMENT OF REVENUE, EXPENDITURES, AND CHANGES IN FUND BALANCE- NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds City-County Beauti-Street and Consolidated Law and Drug Drug fication Tree Parking Justice Forfeitures Forfeitures of Bozeman Maintenance Districts Center REVENUES Taxes -$ -$ -$ -$ -$ -$ Special assessments - - - 6,051 - - Licenses and permits - - - 28,876 62,462 - Intergovernmental 110,642 - - 1,357 2,124 - Charges for services - - - 2,005,079 - - Fines and forfeitures 64,962 120,263 - - 137,723 - Interest on investments - 11,335 194 29,325 4,444 - Loan repayment - - - - - - Other 36,473 - 4,050 - - - Total revenues 212,077 131,598 4,244 2,070,688 206,753 - EXPENDITURES Current General government - - - - - - Public safety 198,559 40,975 - - 206,343 19,125 Public service - - - 1,608,268 - - Public welfare - - - 263,429 - - Other - - 1,211 - - - Capital outlay - 14,500 - 126,211 - - Debt service Principal - - - - - - Interest and fiscal fees - - - - - - Total expenditures 198,559 55,475 1,211 1,997,908 206,343 19,125 Revenues over (under) expenditures 13,518 76,123 3,033 72,780 410 (19,125) OTHER FINANCING SOURCES (USES) Transfers in - - - - - - Transfers out - - - - - - Sale of capital assets - - - 935 - - Total other financing sources and uses - - - 935 - - Net change in fund balances 13,518 76,123 3,033 73,715 410 (19,125) FUND BALANCES, beginning of year (4,177) 193,687 1,165 565,256 89,314 541,875 FUND BALANCES, end of year 9,341$ 269,810$ 4,198$ 638,971$ 89,724$ 522,750$ (continued) 305 92 CITY OF BOZEMAN, MONTANA COMBINING STATEMENT OF REVENUE, EXPENDITURES, AND CHANGES IN FUND BALANCE- NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Economic Housing Special Community Building Highway Development Revolving Projects Transportation Inspection Safety Revolving Loan Loan Fund REVENUES Taxes -$ -$ -$ -$ -$ -$ Special assessments - - - - - - Licenses and permits - - 1,388,800 - - - Intergovernmental - 300,079 57,990 - 52,250 - Charges for services - - 64,272 - - - Fines and forfeitures - - - - - - Interest on investments 11,908 - 23,189 867 1,051 3,983 Loan repayment - - - - - 5,193 Other - - 16 - - - Total revenues 11,908 300,079 1,534,267 867 53,301 9,176 EXPENDITURES Current General government - - - - - - Public safety - - 1,261,779 - - - Public service - 26,584 - - - - Public welfare - - - - 375,715 14,400 Other 32,464 - - - - - Capital outlay 429,311 351,887 143,055 - - - Debt service Principal - - - - - - Interest and fiscal fees - - - - - - Total expenditures 461,775 378,471 1,404,834 - 375,715 14,400 Revenues over (under) expenditures (449,867) (78,392) 129,433 867 (322,414) (5,224) OTHER FINANCING SOURCES (USES) Transfers in - - - - - - Transfers out - - - - - - Sale of capital assets - - - - - - Total other financing sources and uses - - - - - - Net change in fund balance (449,867) (78,392) 129,433 867 (322,414) (5,224) FUND BALANCES, beginning of year 720,251 44,197 908,784 19,165 323,465 97,258 FUND BALANCES, end of year 270,384$ (34,195)$ 1,038,217$ 20,032$ 1,051$ 92,034$ (continued) 306 93 CITY OF BOZEMAN, MONTANA COMBINING STATEMENT OF REVENUE, EXPENDITURES, AND CHANGES IN FUND BALANCE- NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Downtown Municipal Community Improvement Street Park Court Housing District Lighting Land Restitution REVENUES Taxes -$ 487,199$ -$ -$ -$ Special assessments - 104,371 328,069 - - Licenses and permits - - - - - Intergovernmental - 34,620 - - - Charges for services - - - - - Fines and forfeitures - - - - - Interest on investments 6,286 22,518 1,962 15,316 8 Loan repayment 5,000 - - - - Other - - - 302,652 - Total revenues 11,286 648,708 330,031 317,968 8 EXPENDITURES Current General government - - - - - Public safety - - - - - Public service - - 292,399 - - Public welfare 66,625 198,669 - - - Other - - - - - Capital outlay - 15,400 - - - Debt service Principal - - - - - Interest and fiscal fees - - - - - Total expenditures 66,625 214,069 292,399 - - Revenues over (under) expenditures (55,339) 434,639 37,632 317,968 8 OTHER FINANCING SOURCES (USES) Transfers in 126,500 - - - - Transfers out - - - - - Sale of capital assets - - - - - Total other financing sources and uses 126,500 - - - - Net change in fund balance 71,161 434,639 37,632 317,968 8 FUND BALANCES, beginning of year 74,068 74,904 (123,896) 35,918 10 FUND BALANCES, end of year 145,229$ 509,543$ (86,264)$ 353,886$ 18$ 307 94 CITY OF BOZEMAN, MONTANA COMBINING STATEMENT OF REVENUE, EXPENDITURES, AND CHANGES IN FUND BALANCE- NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Totals REVENUES Taxes 3,103,280$ Special assessments 438,491 Licenses and permits 1,480,138 Intergovernmental 1,922,573 Charges for services 2,590,550 Fines and forfeitures 409,115 Interest on investments 234,657 Loan repayment 10,193 Other 519,223 Total revenues 10,708,220 EXPENDITURES Current General government 923,390 Public safety 2,071,521 Public service 2,093,606 Public welfare 994,719 Other 98,465 Capital outlay 1,669,497 Debt service Principal - Interest and fiscal fees - Total expenditures 7,851,198 Revenues over (under) expenditures 2,857,022 OTHER FINANCING SOURCES (USES) Transfers in 621,839 Transfers out (2,803,239) Sale of capital assets 935 Total other financing sources and uses (2,180,465) Net change in fund balance 676,557 FUND BALANCES, beginning of year 5,597,055 FUND BALANCES, end of year 6,273,612$ (continued) 308 95 CITY OF BOZEMAN, MONTANA COMBINING STATEMENT OF REVENUE, EXPENDITURES, AND CHANGES IN FUND BALANCE- NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Debt Service Funds Permanent Fund Total Nonmajor SID G.O.Cemetery Governmental Revolving Bonds Totals Care Funds REVENUES Taxes -$ 714,854$ 714,854$ -$ 3,818,134$ Special assessments - - - - 438,491 Licenses and permits - - - - 1,480,138 Intergovernmental - 2,344 2,344 - 1,924,917 Charges for services 7,452 - 7,452 4,754 2,602,756 Fines and forfeitures - - - - 409,115 Interest on investments 17,345 7,882 25,227 24,140 284,024 Loan repayment - - - - 10,193 Other - - - - 519,223 Total revenues 24,797 725,080 749,877 28,894 11,486,991 EXPENDITURES Current General government - - - - 923,390 Public safety - - - - 2,071,521 Public service - - - - 2,093,606 Public welfare - - - - 994,719 Other - 14,925 14,925 - 113,390 Capital outlay - - - - 1,669,497 Debt service Principal - 485,000 485,000 - 485,000 Interest and fiscal fees - 233,930 233,930 - 233,930 Total expenditures - 733,855 733,855 - 8,585,053 Revenues over (under) expenditures 24,797 (8,775) 16,022 28,894 2,901,938 OTHER FINANCING SOURCES (USES) Transfers in - - - - 621,839 Transfers out - - - (24,140) (2,827,379) Sale of capital assets - - - - 935 Total other financing sources and uses - - - (24,140) (2,204,605) Net change in fund balance 24,797 (8,775) 16,022 4,754 697,333 FUND BALANCES, beginning of year 547,537 (106,783) 440,754 522,468 6,560,277 FUND BALANCES, end of year 572,334$ (115,558)$ 456,776$ 527,222$ 7,257,610$ 309 BUDGET TO ACTUAL SCHEDULES – OTHER MAJOR FUNDS 310 96 CITY OF BOZEMAN, MONTANA SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL OTHER MAJOR FUNDS – SID SINKING FUND Year Ended June 30, 2007 Variance with Actual Amounts Final Budget Original Final Budgetary Basis Positive (Negative) Budgetary fund balance, July 1 623,683$ 623,683$ 623,683$ -$ Resources (inflows): Taxes - - - - Special assessments 1,500,000 1,500,000 1,428,084 (71,916) Licenses and permits - - - - Intergovernmental - - - - Charges for services - - 1,603 1,603 Fines and forfeitures - - - - Interest on investments - - 67,023 67,023 Transfers from other funds - - 130,846 130,846 Proceeds from long term debt - - - - Other - - - - Amounts available for appropriation 2,123,683 2,123,683 2,251,239 127,556 Charges to appropriations (outflows): Current General government - - - - Public safety - - - - Public service - - - - Public welfare - - - - Other - - 88,685 (88,685) Capital outlay - - - - Debt service 3,400,000 1,900,000 577,188 1,322,812 Transfers to other funds - - 130,846 (130,846) Total charges to appropriations 3,400,000 1,900,000 796,719 1,103,281 Budgetary fund balance, June 30 (1,276,317)$ 223,683$ 1,454,520$ 1,230,837$ Budgeted Amounts 312 97 CITY OF BOZEMAN, MONTANA SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL OTHER MAJOR FUNDS – CAPITAL PROJECTS FUND Year Ended June 30, 2007 Variance with Actual Amounts Final Budget Original Final Budgetary Basis Positive (Negative) Budgetary fund balance, July 1 6,598,235$ 6,598,235$ 6,598,235$ -$ Resources (inflows): Taxes - - - - Special assessments - - - - Licenses and permits - - - - Intergovernmental 3,081,200 3,081,200 - (3,081,200) Charges for services - - - - Fines and forfeitures - - - - Interest on investments - - 272,470 272,470 Transfers from other funds 3,100,000 3,100,000 505,711 (2,594,289) Proceeds from long term debt 4,622,065 4,622,065 - Other 2,575,000 2,575,000 1,231,262 (1,343,738) Amounts available for appropriation 19,976,500 19,976,500 8,607,678 (6,746,757) Charges to appropriations (outflows): Current General government - 51,500 51,497 3 Public safety - 22,000 21,561 439 Public service 71,500 148,000 147,808 192 Public welfare - - - - Other - - - - Capital outlay 6,362,150 8,712,150 8,705,134 7,016 Bond issuance costs - - - - Transfers to other funds - - - - Total charges to appropriations 6,433,650 8,933,650 8,926,000 7,650 Budgetary fund balance, June 30 13,542,850$ 11,042,850$ (318,322)$ (6,739,107)$ Budgeted Amounts 313 98 CITY OF BOZEMAN, MONTANA NOTE TO BUDGET TO ACTUAL SCHEDULE - OTHER MAJOR FUNDS June 30, 2007 SID Capital Sinking Projects Sources/inflows of resources Actual amounts (budgetary basis) "available for appropriation" from the budgetary comparison schedule 2,251,239$ 8,607,678$ Differences - budget to GAAP: The fund balance at the beginning of the year is a budgetary resource but is not a current-year revenue for financial reporting purposes.(623,683) (6,598,235) Proceeds of long term debt are inflows for budgetary purposes, but are not revenues for financial reporting purposes.- - Transfers from other funds are inflows of budgetary purposes, but are not revenues for financial reporting purposes.(130,846) (505,711) Total revenues as reported on the statement of revenues, expenditures, and changes in fund balances - Other nonmajor governmental funds 1,496,710$ 1,503,732$ Uses/outflows of resources Actual amounts (budgetary basis) "total charges to appropriations" from the budgetary comparison schedule 796,719$ 8,926,000$ Differences - budget to GAAP: Bond issuance costs are outflows for budgetary purposes, but are not expenditures for financial reporting purposes.- - Transfers to other funds are outflows of budgetary purposes, but are not expenditures for financial reporting purposes.(130,846) - Total expenditures as reported on the statement of revenues, expenditures, and changes in fund balances - Other nonmajor governmental funds 665,873$ 8,926,000$ 314 BUDGET TO ACTUAL S CHEDULES – NONMAJOR FUNDS 316 99 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes 113,250$ 70,869$ (42,381)$ 126,498$ 128,261$ 1,763$ Special assessments - - - - - - Licenses and permits - - - - - - Intergovernmental 175,000 356,595 181,595 79,100 61,410 (17,690) Charges for services 5,000 4,006 (994) 450,050 517,193 67,143 Fines and forfeitures 45,000 86,167 41,167 - - - Interest on investments 31,950 75,162 43,212 4,950 15,523 10,573 Loan repayment - - - - - - Other 392,500 160,779 (231,721) - 15,253 15,253 Total revenues 762,700 753,578 (9,122) 660,598 737,640 77,042 EXPENDITURES - BUDGET UNIT 2,497,537 661,951 1,835,586 1,151,003 921,999 229,004 Revenues over (under) expenditures (1,734,837) 91,627 1,826,464 (490,405) (184,359) 306,046 OTHER FINANCING SOURCES Transfers in 250,000 250,339 339 245,000 245,000 - Transfers out - (9,658) (9,658) - - - Sale of capital assets - - - - - - Total other financing sources 250,000 240,681 (9,319) 245,000 245,000 - Revenues and other sources over (under) expenditures (1,484,837)$ 332,308 1,817,145$ (245,405)$ 60,641 306,046$ FUND BALANCES, beginning of year 1,592,395 196,853 FUND BALANCES, end of year 1,924,703$ 257,494$ (continued) Departmental Special Revenues City Planning Board 318 100 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes 1,730,434$ 1,719,546$ (10,888)$ 704,626$ 697,405$ (7,221)$ Special assessments - - - - - - Licenses and permits - - - - - - Intergovernmental 74,024 78,682 - 284,562 283,040 (1,522) Charges for services - - - - - - Fines and forfeitures - - - - - - Interest on investments - - - - 408 408 Loan repayment - - - - - - Other - - - - - - Total revenues 1,804,458 1,798,228 (10,888) 989,188 980,853 (8,335) EXPENDITURES - BUDGET UNIT - - - - - - Revenues over (under) expenditures 1,804,458 1,798,228 (6,230) 989,188 980,853 (8,335) OTHER FINANCING SOURCES Transfers in - - - - - - Transfers out (1,804,458) (1,804,458) - (989,122) (989,123) (1) Sale of capital assets - - - - - - Total other financing sources (1,804,458) (1,804,458) - (989,122) (989,123) (1) Revenues and other sources over (under) expenditures -$ (6,230) (6,230)$ 66$ (8,270) (8,336)$ FUND BALANCES, beginning of year 25,894 (21,827) FUND BALANCES, end of year 19,664$ (30,097)$ (continued) Insurance Pension 319 101 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Positive Budget Actual (Negative) REVENUES Taxes -$ -$ -$ Special assessments - - - Licenses and permits - - - Intergovernmental 568,000 583,784 15,784 Charges for services - - - Fines and forfeitures - - - Interest on investments - 11,178 11,178 Loan repayment - - - Other - - - Total revenues 568,000 594,962 26,962 EXPENDITURES - BUDGET UNIT 610,500 580,339 30,161 Revenues over (under) expenditures (42,500) 14,623 57,123 OTHER FINANCING SOURCES Transfers in - - - Transfers out - - - Sale of capital assets - - - Total other financing sources - - - Revenues and other sources over (under) expenditures (42,500)$ 14,623 57,123$ FUND BALANCES, beginning of year 242,496 FUND BALANCES, end of year 257,119$ Gas Tax Apportionment 320 102 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ -$ -$ -$ -$ -$ Special assessments - - - - - - Licenses and permits - - - - - - Intergovernmental 98,000 110,642 12,642 - - - Charges for services - - - - - - Fines and forfeitures 50,000 64,962 14,962 50,000 120,263 70,263 Interest on investments - - - - 11,335 11,335 Loan repayment - - - - - - Other 5,000 36,473 31,473 - - - Total revenues 153,000 212,077 59,077 50,000 131,598 81,598 EXPENDITURES - BUDGET UNIT 216,695 198,559 18,136 210,966 55,475 155,491 Revenues over (under) expenditures (63,695) 13,518 77,213 (160,966) 76,123 237,089 OTHER FINANCING SOURCES Transfers in - - - - - - Transfers out - - - - - - Sale of capital assets - - - - - - Total other financing sources - - - - - - Revenues and other sources over (under) expenditures (63,695)$ 13,518 77,213$ (160,966)$ 76,123 237,089$ FUND BALANCES, beginning of year (4,177) 193,687 FUND BALANCES, end of year 9,341$ 269,810$ (continued) Drug Forfeitures City-County Drug Forfeitures 321 103 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ -$ -$ -$ -$ -$ Special assessments - - - - 6,051 6,051 Licenses and permits - - - 15,000 28,876 13,876 Intergovernmental - - - - 1,357 1,357 Charges for services - - - 2,016,626 2,005,079 (11,547) Fines and forfeitures - - - - - - Interest on investments - 194 194 15,000 29,325 14,325 Loan repayment - - - - - - Other - 4,050 4,050 10,000 - (10,000) Total revenues - 4,244 4,244 2,056,626 2,070,688 14,062 EXPENDITURES - BUDGET UNIT 1,211 1,211 - 2,333,790 1,997,908 335,882 Revenues over (under) expenditures (1,211) 3,033 4,244 (277,164) 72,780 349,944 OTHER FINANCING SOURCES Transfers in - - - - - - Transfers out - - - - - - Sale of capital assets - - - - 935 935 Total other financing sources - - - - 935 935 Revenues and other sources over (under) expenditures (1,211)$ 3,033 4,244$ (277,164)$ 73,715 350,879$ FUND BALANCES, beginning of year 1,165 565,256 FUND BALANCES, end of year 4,198$ 638,971$ (continued) Beautification of Bozeman Street and Tree Maintenance 322 104 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ - - -$ - - Special assessments - - - - - - Licenses and permits 46,500 62,462 15,962 - - - Intergovernmental - 2,124 2,124 - - - Charges for services - - - - - - Fines and forfeitures 196,500 137,723 (58,777) - - - Interest on investments 6,850 4,444 (2,406) - - - Loan repayment - - - - - - Other - - - - - - Total revenues 249,850 206,753 (43,097) - - - EXPENDITURES - BUDGET UNIT 256,736 206,343 50,393 20,000 19,125 875 Revenues over (under) expenditures (6,886) 410 7,296 (20,000) (19,125) 875 OTHER FINANCING SOURCES Transfers in - - - - - - Transfers out - - - - - - Sale of capital assets - - - - - - Total other financing sources - - - - - - Revenues and other sources over (under) expenditures (6,886)$ 410 7,296$ (20,000)$ (19,125) 875$ FUND BALANCES, beginning of year 89,314 541,875 FUND BALANCES, end of year 89,724$ 522,750$ (continued) Consolidated Parking Districts Law and Justice Center 323 105 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ - - -$ - - Special assessments - - - - - - Licenses and permits - - - - - - Intergovernmental - - - - 300,079 300,079 Charges for services - - - - - - Fines and forfeitures - - - - - - Interest on investments 20,000 11,908 (8,092) - - - Loan repayment - - - - - - Other - - - - - - Total revenues 20,000 11,908 (8,092) - 300,079 300,079 EXPENDITURES - BUDGET UNIT 740,250 461,775 278,475 378,515 378,471 44 Revenues over (under) expenditures (720,250) (449,867) 270,383 (378,515) (78,392) 300,123 OTHER FINANCING SOURCES Transfers in - - - 30,515 - (30,515) Transfers out - - - - - - Sale of capital assets - - - - - - Total other financing sources - - - 30,515 - (30,515) Revenues and other sources over (under) expenditures (720,250)$ (449,867) 270,383$ (348,000)$ (78,392) 269,608$ FUND BALANCES, beginning of year 720,251 44,197 FUND BALANCES, end of year 270,384$ (34,195)$ (continued) Special Projects Community Transportation 324 106 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ - - -$ - - Special assessments - - - - - - Licenses and permits 1,010,860 1,388,800 377,940 - - - Intergovernmental - 57,990 57,990 - - - Charges for services 14,000 64,272 50,272 - - - Fines and forfeitures - - - - - - Interest on investments 25,000 23,189 (1,811) - 867 867 Loan repayment - - - - - - Other - 16 16 - - - Total revenues 1,049,860 1,534,267 484,407 - 867 867 EXPENDITURES - BUDGET UNIT 1,404,885 1,404,834 51 18,100 - 18,100 Revenues over (under) expenditures (355,025) 129,433 484,458 (18,100) 867 18,967 OTHER FINANCING SOURCES Transfers in - - - - - - Transfers out - - - - - - Sale of capital assets - - - - - - Total other financing sources - - - - - - Revenues and other sources over (under) expenditures (355,025)$ 129,433 484,458$ (18,100)$ 867 18,967$ FUND BALANCES, beginning of year 908,784 19,165 FUND BALANCES, end of year 1,038,217$ 20,032$ (continued) Building Inspection Highway Safety 325 107 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ - - -$ - - Special assessments - - - - - - Licenses and permits - - - - - - Intergovernmental - 52,250 52,250 - - - Charges for services - - - - - - Fines and forfeitures - - - - - - Interest on investments 7,500 1,051 (6,449) 500 3,983 3,483 Loan repayment 215,000 - (215,000) 8,000 5,193 (2,807) Other - - - - - - Total revenues 222,500 53,301 (169,199) 8,500 9,176 676 EXPENDITURES - BUDGET UNIT 376,000 375,715 285 14,400 14,400 - Revenues over (under) expenditures (153,500) (322,414) (168,914) (5,900) (5,224) 676 OTHER FINANCING SOURCES Transfers in - - - - - - Transfers out - - - - - - Sale of capital assets - - - - - - Total other financing sources - - - - - - Revenues and other sources over (under) expenditures (153,500)$ (322,414) (168,914)$ (5,900)$ (5,224) 676$ FUND BALANCES, beginning of year 323,465 97,258 FUND BALANCES, end of year 1,051$ 92,034$ (continued) Economic Development Revolving Loan Fumd Housing Revolving Loan Fund 326 108 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ - - 495,000$ 487,199 (7,801) Special assessments - - - - 104,371 104,371 Licenses and permits - - - - - - Intergovernmental - - - 34,620 34,620 - Charges for services - - - - - - Fines and forfeitures - - - - - - Interest on investments - 6,286 6,286 2,000 22,518 20,518 Loan repayment 3,500 5,000 1,500 - - - Other - - - 104,000 - (104,000) Total revenues 3,500 11,286 7,786 635,620 648,708 13,088 EXPENDITURES - BUDGET UNIT 200,000 66,625 133,375 599,000 214,069 384,931 Revenues over (under) expenditures (196,500) (55,339) 141,161 36,620 434,639 398,019 OTHER FINANCING SOURCES Transfers in 126,500 126,500 - - - - Transfers out - - - - - - Sale of capital assets - - - - - - Total other financing sources 126,500 126,500 - - - - Revenues and other sources over (under) expenditures (70,000)$ 71,161 141,161$ 36,620$ 434,639 398,019$ FUND BALANCES, beginning of year 74,068 74,904 FUND BALANCES, end of year 145,229$ 509,543$ (continued) Community Housing Downtown Improvement District 327 109 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ - - -$ - - Special assessments 170,000 328,069 158,069 - - - Licenses and permits - - - - - - Intergovernmental - - - - - - Charges for services - - - - - - Fines and forfeitures - - - - - - Interest on investments - 1,962 1,962 - 15,316 15,316 Loan repayment - - - - - - Other - - - - 302,652 302,652 Total revenues 170,000 330,031 160,031 - 317,968 317,968 EXPENDITURES - BUDGET UNIT 293,000 292,399 601 - - - Revenues over (under) expenditures (123,000) 37,632 160,632 - 317,968 317,968 OTHER FINANCING SOURCES Transfers in - - - - - - Transfers out - - - - - - Sale of capital assets - - - - - - Total other financing sources - - - - - - Revenues and other sources over (under) expenditures (123,000)$ 37,632 160,632$ -$ 317,968 317,968$ FUND BALANCES, beginning of year (123,896) 35,918 FUND BALANCES, end of year (86,264)$ 353,886$ (continued) Park LandStreet Lighting 328 110 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Special Revenue Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ - - 3,169,808$ 3,103,280 (66,528) Special assessments - - - 170,000 438,491 268,491 Licenses and permits - - - 1,072,360 1,480,138 407,778 Intergovernmental - - - 1,313,306 1,922,573 609,267 Charges for services - - - 2,485,676 2,590,550 104,874 Fines and forfeitures - - - 341,500 409,115 67,615 Interest on investments - 8 8 113,750 234,657 120,907 Loan repayment - - - 226,500 10,193 (216,307) Other - - - 511,500 519,223 7,723 Total revenues - 8 8 9,404,400 10,708,220 1,303,820 EXPENDITURES - BUDGET UNIT - - - 11,322,588 7,851,198 3,471,390 Revenues over (under) expenditures - 8 8 (1,918,188) 2,857,022 4,775,210 OTHER FINANCING SOURCES Transfers in - - - 652,015 621,839 (30,176) Transfers out - - - (2,793,580) (2,803,239) (9,659) Sale of capital assets - - - - 935 935 Total other financing sources - - - (2,141,565) (2,180,465) (38,900) Revenues and other sources over (under) expenditures -$ 8 8$ (4,059,753)$ 676,557 4,736,310$ FUND BALANCES, beginning of year 10 5,597,055 FUND BALANCES, end of year 18$ 6,273,612$ Municipal Court Restitution Total 329 111 CITY OF BOZEMAN, MONTANA SCHEDULES OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- BUDGET TO ACTUAL NONMAJOR GOVERNMENTAL FUNDS (CONTINUED) Year Ended June 30, 2007 Debt Service Funds Variance Variance Positive Positive Budget Actual (Negative)Budget Actual (Negative) REVENUES Taxes -$ -$ -$ 718,100$ 714,854$ (3,246)$ Intergovernmental - - - - 2,344 2,344 Interest on investments 30,000 17,345 (12,655) - 7,882 7,882 Total revenue 30,000 24,797 (5,203) 718,100 725,080 6,980 EXPENDITURES Other - - - 16,000 14,925 1,075 Debt service Principal - - - 475,000 485,000 (10,000) Interest and fiscal fees - - - 243,182 233,930 9,252 Total expenditures - - - 734,182 733,855 327 Revenues over (under) expenditures 30,000 24,797 (5,203) (16,082) (8,775) 7,307 OTHER FINANCING SOURCES (USES) Operating transfers in - - - - - - Operating transfers out - - - - - - Total other financing sources (uses)- - - - - - Revenues and other sources over (under) expenditures 30,000$ 24,797 (5,203)$ (16,082)$ (8,775) 7,307$ FUND BALANCES, beginning of year 547,537 (106,783) FUND BALANCES, end of year 572,334$ (115,558)$ G.O. BondsSID Revolving 330 INTERNAL SERVICE FUNDS STATEMENTS 331 INTERNAL SERVICE FUNDS Internal Service Funds are used to account for the goods or services provided by one department to other departments of the City on a cost-reimbursement basis. Vehicle Maintenance Shop – Accounts for the maintenance and repair of vehicles used in the operation of City services. Medical Health Insurance – Accounts for insurance premium revenues received from the various City departments and retirees, and the related costs of health and dental claims incurred by city employees and retirees which are in-turn paid to the City’s insurance program coordinator. 333 112 CITY OF BOZEMAN, MONTANA COMBINING STATEMENT OF NET ASSETS INTERNAL SERVICE FUNDS June 30, 2007 Vehicle Medical Maintenance Health Shop Insurance Total ASSETS Current assets Cash and equivalents 83,599$ -$ 83,599$ Customer receivables, net - 12,333 12,333 Prepaid expenses - 631,526 631,526 Total current assets 83,599 643,859 727,458 Machinery and equipment 131,175 - 131,175 Vehicles 37,997 - 37,997 Less: accumulated depreciation (136,101) - (136,101) Net machinery and equipment 33,071 - 33,071 Total assets 116,670 643,859 760,529 LIABILITIES Current liabilities Accounts payable 12,013 - 12,013 Accrued employee benefits 9,360 - 9,360 Due to other City funds - 353,397 353,397 Total current liabilities 21,373 353,397 374,770 NET ASSETS Invested in capital assets, net of related debt 33,071 - 33,071 Unrestricted 62,226 290,462 352,688 Total net assets 95,297$ 290,462$ 385,759$ 335 113 CITY OF BOZEMAN, MONTANA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS For the Year Ended June 30, 2007 Vehicle Medical Maintenance Health Shop Insurance Total OPERATING REVENUES Charges for services 526,852$ 2,678,555$ 3,205,407$ OPERATING EXPENSES Salaries and benefits 164,666 - 164,666 Materials and supplies 290,842 11 290,853 Repairs and maintenance 7,010 - 7,010 Utilities 623 - 623 Administrative charges 31,436 - 31,436 Insurance claims - 2,438,637 2,438,637 Other expenses 15,085 61,112 76,197 Depreciation 18,741 - 18,741 Total operating expenses 528,403 2,499,760 3,028,163 Operating income (loss)(1,551) 178,795 177,244 NON-OPERATING REVENUES (EXPENSES) Interest income 3,636 20,677 24,313 Interest expense - (6,533) (6,533) Other income 140 - 140 Total non-operating revenue (expenses)3,776 14,144 17,920 Change in net assets 2,225 192,939 195,164 NET ASSETS, beginning of year 93,072 97,523 190,595 NET ASSETS, end of year 95,297$ 290,462$ 385,759$ 336 114 CITY OF BOZEMAN, MONTANA INTERNAL SERVICE FUNDS COMBINING STATEMENTS OF CASH FLOWS For the Year Ended June 30, 2007 Vehicle Medical Maintenance Health Shop Insurance Total CASH FLOWS FROM OPERATIONS: Receipts from customers 526,852$ 3,436,723$ 3,963,575$ Receipts from others 140 - 140 Operating loans from other City funds - (94,550) (94,550) Payments to suppliers (320,206) (917,680) (1,237,886) Payments to employees (163,175) (2,438,637) (2,601,812) Payments to Internal Service Funds and administrative fees (31,436) - (31,436) Net Cash Provided (Used) by Operating Activities 12,175 (14,144) (1,969) CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Additions to property, plant and equipment (7,452) - (7,452) Interest paid on bonds, interfund loans, loans and leases - (6,533) (6,533) Net Cash Flows from Capital and Related Financing Activities (7,452) (6,533) (13,985) CASH FLOWS FROM INVESTING ACTIVITIES: Interest on investments 3,636 20,677 24,313 Net Increase (Decrease) in Cash and Cash Equivalents 8,359 - 8,359 CASH AND EQUIVALENTS, beginning of year 75,240 - 75,240 CASH AND EQUIVALENTS, end of year 83,599$ -$ 83,599$ 337 115 CITY OF BOZEMAN, MONTANA INTERNAL SERVICE FUNDS COMBINING STATEMENTS OF CASH FLOWS (CONTINUED) For the Year Ended June 30, 2007 A reconciliation of operating loss to cash provided by (used in) operating activities follows: Vehicle Medical Maintenance Health Shop Insurance Total OPERATING INCOME (1,551)$ 178,795$ 177,244$ Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities Depreciation 18,741 - 18,741 Other income 140 - 140 Changes in assets and liabilities: (Increase) Decrease in: Customer receivables - 758,168 758,168 Prepaid expenses - (631,526) (631,526) Increase (Decrease) in: Accounts payable (6,646) (225,031) (231,677) Accrued employee benefits payable 1,491 - 1,491 Interfund borrowings - (94,550) (94,550) Total adjustments 13,726 (192,939) (179,213) Net cash provided (used) by operating activities 12,175$ (14,144)$ (1,969)$ 338 AGENCY FUNDS STATEMENTS 339 116 CITY OF BOZEMAN, MONTANA AGENCY FUNDS COMBINING STATEMENT OF FIDUCIARY NET ASSETS June 30, 2007 Total Montana Municipal Agency Arts Council Court Funds ASSETS Cash and cash equivalents 2$ 233,961$ 233,963$ Customer receivables - 5,520 5,520 Interfund receivable - 11,566 11,566 Total assets 2 251,047 251,049 LIABILITIES Accounts payable 2 251,047 251,049 Total liabilities 2$ 251,047$ 251,049$ 341 117 CITY OF BOZEMAN, MONTANA AGENCY FUNDS COMBINING STATEMENTS OF CHANGES IN ASSETS AND LIABILITIES Year Ended June 30, 2007 Montana Arts Council Balance June 30, 2006 Additions Deletions Balance June 30, 2007 ASSETS Cash and cash equivalents 502$ 8,850$ (9,350)$ 2$ Total assets 502 8,850 (9,350) 2 LIABILITIES Accounts payable 502 8,850 (9,350) 2 Total liabilities 502$ 8,850$ (9,350)$ 2$ 342 118 CITY OF BOZEMAN, MONTANA AGENCY FUNDS COMBINING STATEMENTS OF CHANGES IN ASSETS AND LIABILITIES (CONTINUED) Year Ended June 30, 2007 Municipal Court Balance June 30, 2006 Additions Deletions Balance June 30, 2007 ASSETS Cash and cash equivalents 153,914$ 80,047$ -$ 233,961$ Customer receivables 5,904 - (384) 5,520 Interfund receivable 3,914 7,652 - 11,566 Total assets 163,732 87,699 (384) 251,047 LIABILITIES Accounts payable 163,732 87,699 (384) 251,047 Total liabilities 163,732$ 87,699$ (384)$ 251,047$ 343 PART III STATISTICAL SECTION 345 CITY OF BOZEMAN, MONTANA Statistical Section This part of the City of Bozeman's comprehensive annual financial report presents detailed information as a context for understanding what the information in the financial statements, note disclosures and required supplementary information says about the government's overall financial health. Contents Page Financial Trends These schedules contain trend information to help the reader understand how the government's financial performance and well-being have changed over time. 118 Revenue Capacity These schedules contain information to help the reader assess the government's most significant local revenue source, the property tax. 123 Debt Capacity These schedules present information to help the reader assess the affordability of the government's current levels of outstanding debt and the government's ability to issue additional debt in the future. 129 Demographic and Economic Information These schedules offer demographic and economic indicators to help the reader understand the environment within which the government's financial activities take place. 134 Operating Information These schedules contain service and infrastructure data to help the reader understand how the information in the government's financial report relates to the services the government provides and the activities it performs. 136 Sources: Unless otherwise noted, the information in these schedules is derived from the City of Bozeman comprehensive annual financial reports for the relevant year. Note: The City of Bozeman implemented GASB Statement 34 in Fiscal Year 2002, therefore the data for prior years are not shown; schedules presenting government-wide information include information beginning in that year. 346 FINANCIAL TRENDS SECTION 347 119 CITY OF BOZEMAN, MONTANA Unaudited statistical section. NET ASSETS BY COMPONENT Past Six Fiscal Years 2002 2003 2004 2005 2006 2007 Governmental activities Invested in capital assets, net of related debt 13,675,868 (1,618,282) 5,197,117 8,409,053 22,987,166 77,734,584 Restricted 5,508,776 6,890,530 10,615,720 12,343,248 5,242,903 8,317,507 Unrestricted 7,495,002 24,396,920 17,345,961 21,077,779 25,537,959 20,750,890 Total governmental activites net assets 26,679,646$ 29,669,168$ 33,158,798$ 41,830,080$ 53,768,028$ 106,802,981$ Business-type activities Invested in capital assets, net of related debt 13,008,835 19,960,910 25,174,352 28,124,307 28,416,015 154,534,657 Restricted 7,747,249 967,939 13,357,348 11,041,147 13,462,443 19,086,533 Unrestricted 10,725,406 19,412,803 9,174,747 12,284,379 12,899,363 14,263,569 Total business-type activities 10,725,406$ 40,341,652$ 47,706,447$ 51,449,833$ 54,777,821$ 187,884,759$ Primary government Invested in capital assets, net of related debt 26,684,703 18,342,628 30,371,469 36,533,360 51,403,181 232,269,241 Restricted 13,256,025 7,858,469 23,973,068 23,384,395 18,705,346 27,404,040 Unrestricted 18,220,408 43,809,723 26,520,708 33,362,158 38,437,322 35,014,459 Total primary government net assets 58,161,136$ 70,010,820$ 80,865,245$ 93,279,913$ 108,545,849$ 294,687,740$ Fiscal Year 349 120 CITY OF BOZEMAN, MONTANA Unaudited statistical section. CHANGES IN NET ASSETS Past Six Fiscal Years 2002 2003 2004 2005 2006 2007 Expenses Governmental Activities: General government 3,488,562 3,847,265 4,404,421 4,758,743 5,092,865 5,322,040 Public Safety 7,114,922 8,027,193 8,078,120 8,834,875 9,858,055 10,488,873 Public Service 2,847,989 3,182,445 3,096,273 3,475,067 4,163,644 8,511,308 Public Welfare 3,433,991 3,542,608 4,017,654 4,372,959 5,477,065 5,536,741 Other 826,944 1,248,136 23,255 227,670 573,204 411,331 Interest and fiscal fees 696,303 672,243 667,118 709,178 550,296 549,667 Total governmental activities expenses 18,408,711 20,519,890 20,286,841 22,378,492 25,715,129 30,819,960 Business-type activities: Water 2,948,638 2,924,951 3,782,726 4,292,503 4,824,505 10,487,249 Wastewater 2,880,228 2,556,245 3,353,567 4,246,156 4,586,959 7,372,786 Solid waste 2,206,010 1,955,939 2,462,291 2,720,738 3,547,902 3,283,135 Total business-type activities expenses 8,034,876 7,437,135 9,598,584 11,259,397 12,959,366 21,143,170 Total primary government expenses 26,443,587$ 27,957,025$ 29,885,425$ 33,637,889$ 38,674,495$ 51,963,130$ Program Revenues Governmental activities: Charges for services: General government 3,554,700 1,230,771 793,529 1,261,652 1,496,818 2,023,362 Public Safety 1,907,548 2,586,058 2,390,179 1,898,531 1,984,642 3,712,280 Public Service 3,070,566 4,084,641 3,934,801 10,302,583 9,217,198 5,361,852 Public Welfare 553,842 812,909 865,910 567,471 718,162 704,790 Operating grants and contributions 653,567 461,355 878,713 360,980 502,198 409,263 Capital grants and contributions 168,480 61,675 37,538 513,034 1,380,553 610,711 Total governmental activities program revenues 9,908,703 9,237,409 8,900,670 14,904,251 15,299,571 12,822,258 Business-type activities Charges for services: Water 4,621,617 5,503,363 5,842,122 6,547,228 7,434,574 8,604,498 Wastewater 5,067,571 5,626,790 5,765,594 6,074,615 6,430,206 7,052,987 Solid waste 3,282,979 3,632,183 3,884,723 3,648,930 2,582,437 2,428,230 Operating grants and contributions 155,033 14,643 35,396 36,129 - - Capital grants and contributions:- 1,520,318 1,585,544 1,595,805 1,624,237 283,126 Total business-type activities program revenues 13,127,200 16,297,297 17,113,379 17,902,707 18,071,454 18,368,841 Total primary government program revenues 23,035,903$ 25,534,706$ 26,014,049$ 32,806,958$ 33,371,025$ 31,191,099$ Fiscal Year 350 121 CITY OF BOZEMAN, MONTANA Unaudited statistical section. CHANGES IN NET ASSETS (CONTINUED) Past Six Fiscal Years 2002 2003 2004 2005 2006 2007 Net (Expense) / Revenue Governmental activities (8,500,008) (11,282,481) (11,386,171) (7,474,241) (10,415,558) (17,997,702) Business-type activities 5,092,324 8,860,162 7,514,795 6,643,310 5,112,088 (2,774,329) Total primary government net expense (3,407,684)$ (2,422,319)$ (3,871,376)$ (830,931)$ (5,303,470)$ (20,772,031)$ General Revenues and Other Changes in Net Assets Governmental activities: Taxes Property taxes 7,597,346 8,028,832 9,104,945 10,437,702 11,137,006 11,836,748 Intergovernmental shared revenue 4,382,091 4,732,127 4,327,489 4,910,306 5,163,288 5,095,723 Unrestricted investment earnings 493,348 417,156 344,013 606,120 852,222 1,093,115 Miscellaneous 732,532 1,093,888 979,820 2,422,805 3,416,890 1,980,104 Donated capital assets 18,363,608 Sale of capital assets 490,637 Transfers - - 150,000 - 1,784,100 489,780 Extraordinary items (2,231,410) Total governmental activities 13,205,317 14,272,003 14,906,267 16,145,523 22,353,506 39,349,715 Business-type activities: Donated capital assets 26,184,278 Transfers - - (150,000) (1,784,100) (489,780) Extraordinary items (2,899,924) Total business-tupe activities - - (150,000) (2,899,924) (1,784,100) 25,694,498 Total primary government 13,205,317$ 14,272,003$ 14,756,267$ 13,245,599$ 20,569,406$ 65,044,213$ Change in Net Assets Governmental activities 4,705,309 2,989,522 3,520,096 8,671,282 11,937,948 21,352,013 Business-type activities 5,092,324 8,860,162 7,364,795 3,743,386 3,327,988 22,920,169 Total primary government 9,797,633 11,849,684 10,884,891 12,414,668 15,265,936 44,272,182 Fiscal Year 351 122 CITY OF BOZEMAN, MONTANA Unaudited statistical section. FUND BALANCES OF GOVERNMENTAL FUNDS Past Six Fiscal Years 2002 2003 2004 2005 2006 2007 General Fund Reserved - - - 11,687 5,725 3,000 Unreserved 3,600,359 3,083,832 3,345,541 3,996,600 3,173,374 4,367,538 Total general fund 3,600,359 3,083,832 3,345,541 4,008,287 3,179,099 4,370,538 All Other Governmental Reserved 2,247,538 7,965,826 7,315,275 1,606,904 2,164,698 3,112,390 Unreserved, reported in: Special revenue funds 8,598,213 11,993,869 14,362,029 16,296,309 9,776,823 13,205,328 Capital projects funds 2,505,735 3,656,555 2,037,255 4,545,867 6,598,235 (115,558) Debt service funds 1,899,540 Total all other governental funds 15,251,026 23,616,250 23,714,559 22,449,080 18,539,756 16,202,160 Fiscal Year 352 123 CITY OF BOZEMAN, MONTANA Unaudited statistical section. CHANGES IN FUND BALANCES, GOVERNMENTAL FUNDS Past Six Fiscal Years 2002 2003 2004 2005 2006 2007 Revenues Taxes 7,164,366 7,940,777 9,274,923 10,480,668 11,222,034 11,853,872 Special assessments 1,168,813 1,234,119 1,164,151 2,478,024 1,931,261 1,866,717 Licenses and permits 817,263 1,138,801 1,120,864 1,566,812 1,653,546 1,762,086 Intergovernmental 5,204,138 5,255,157 5,243,740 5,784,320 7,046,039 6,115,697 Charges for service 4,756,114 5,637,618 5,246,608 5,818,566 6,347,087 7,403,739 Fines and forfietures 1,080,546 1,305,536 1,188,706 1,443,468 1,461,398 1,746,213 Interest on investments 463,199 413,212 342,979 545,805 848,909 1,068,802 loan repayment 266,683 211,936 183,987 426,076 291,338 10,193 Other 709,203 1,037,347 901,696 2,421,201 3,412,410 1,940,156 Total revenues 21,630,325 24,174,503 24,667,654 30,964,940 34,214,022 33,767,475 Expenditures General government 3,339,981 3,554,871 4,071,391 4,493,124 4,794,940 4,994,217 Public safety 6,723,263 7,232,374 7,661,421 8,535,646 9,494,622 10,160,291 Public service 2,094,552 2,028,864 2,115,856 2,363,585 2,276,802 3,060,672 Public welfare 3,538,748 3,430,983 4,154,228 4,320,299 5,099,873 4,315,086 Other 229,342 298,593 335,186 513,862 514,697 583,593 Capital outlay 4,649,508 3,536,045 4,824,965 6,417,671 18,374,651 11,397,365 Debt service Principal 926,547 850,119 1,448,320 6,788,969 989,041 833,158 Interest 696,303 672,243 667,118 709,178 550,296 549,667 Bond Issuance Costs - - - - 20,064 - Total expenditures 22,198,244 21,604,092 25,278,485 34,142,334 42,114,986 35,894,049 Excess of revenues over (under) expenditures (567,919) 2,570,411 (610,831) (3,177,394) (7,900,964) (2,126,574) Other Financing Sources (Uses) Proceeds from borrowing 3,460,602 5,271,000 - 4,804,467 1,376,869 - Transfers in 1,962,695 3,012,716 3,137,517 5,497,553 17,619,744 4,565,896 Transfers out (1,962,695) (3,013,286) (2,987,517) (5,497,553) (15,835,644) (4,076,116) Sales of capital assets 7,856 820,849 1,604 1,483 490,637 Total other financing sources (uses)3,460,602 5,278,286 970,849 4,806,071 3,162,452 980,417 Extraordinary items (2,231,410) Net change in fund balances 2,892,683$ 7,848,697$ 360,018$ (602,733)$ (4,738,512)$ (1,146,157)$ Debt service as a percentage of 5.3%4.7%7.1%24.5%4.2%3.4% noncapital expenditures Fiscal Year 353 REVENUE CAPACITY SECTION 354 124 CITY OF BOZEMAN, MONTANA Unaudited statistical information. ASSESSED VALUE OF TAXABLE PROPERTY Past Six Fiscal Years Fiscal Total Total Year Taxable Direct Ended Residential Commercial & Agricultural Assessed Tax June 30,Property Industrial Property Property Value Rate 2002 23,772,000 16,131,000 2,547,000 42,450,000 145.21 2003 25,790,800 17,500,900 2,763,300 46,055,000 154.21 2004 27,753,040 18,832,420 2,973,540 49,559,000 163.31 2005 29,671,600 20,134,300 3,179,100 52,985,000 171.99 2006 32,515,280 22,063,940 3,483,780 58,063,000 168.26 2007 35,419,440 24,034,620 3,794,940 63,249,000 163.42 Source: Based on information provided by Gallatin County and Department of Revenue Note: Property is assessed by the State Department of Revenue every six years. 356 125 CITY OF BOZEMAN, MONTANA Unaudited statistical information. DIRECT AND OVERLAPPING PROPERTY TAX RATES Past Six Fiscal Years (rate per $1,000 of assessed value) Fiscal General Total Year Obligation Direct Bozeman Ended Basic Debt Tax School Gallatin State of June 30,Rate Service Rate District County Montana 2002 136.21 9.00 145.21 248.06 61.48 46.00 2003 139.95 14.26 154.21 252.94 63.04 46.00 2004 154.09 9.22 163.31 266.43 66.46 46.00 2005 158.67 13.32 171.99 264.68 67.32 46.00 2006 155.89 12.37 168.26 265.55 71.26 46.00 2007 152.07 11.35 163.42 182.74 101.70 46.00 357 126 CITY OF BOZEMAN, MONTANA Unaudited statistical information. PRINCIPAL PROPERTY TAX PAYERS Current and Nine Years Ago Percentage Percentage of Total City of Total City Taxable Taxable Total Taxable Assessed Assessed Assessed Assessed Taxpayer Value Rank Value Value Rank Value Northwestern Corp Transmission & Distribution 3,291,272 1 2.01%- 0.00% Qwest Corporation 1,462,577 2 0.89%- 0.00% Harry Daum - Gallatin Mall 518,025 3 0.32%478,083 3 1.27% Bozeman Deaconess Foundation 422,509 4 0.26%275,822 5 0.73% Wal-Mart Stores 389,417 5 0.24%244,920 6 0.65% Highgate Bozeman LLC 317,174 6 0.19%- 0.00% Bomont LLC 294,798 7 0.18%- 0.00% Costco Wholesale Corporation 283,730 8 0.17%317,124 4 0.84% Bridger Peaks LLC 275,786 9 0.17%- 0.00% Montana Rail Link 304,394 10 0.19%165,153 0.44% Montana Power 2,353,684 1 6.26% U.S. West 1,931,644 2 5.14% First Security 218,870 7 0.58% Arcadia Gardens Apartments 207,892 8 0.55% Idaho Pole/McFarland Cascade 180,243 9 0.48% Cowdrey, Marvin & Judy 179,076 10 0.48% Total 7,559,682$ 4.63%6,552,511$ 17.44% Source: Gallatin County Assessor's Office 2007 1998 358 127 CITY OF BOZEMAN, MONTANA Unaudited statistical information. PROPERTY TAX LEVIES AND COLLECTIONS Past Six Fiscal Years Fiscal Year Taxes Levied Collections Ended for the Percentage in Subsequent Percentage June 30,Fiscal Year Amount of Levy Years Amount of Levy 2002 6,164,165 6,115,656 99.21%32,431$ 6,148,087 99.74% 2003 7,102,142 6,688,829 94.18%174,883$ 6,863,712 96.64% 2004 8,093,480 7,536,498 93.12%283,760$ 7,820,258 96.62% 2005 9,112,890 8,825,662 96.85%197,333$ 9,022,994 99.01% 2006 9,769,893 9,490,225 97.14%51,557$ 9,541,783 97.67% 2007 10,336,467 10,227,386 98.94%-$ 10,227,386 98.94% Source: Fiscal Year 2007 City of Bozeman Comprehensive Annual Financial Reports Collected within the Fiscal Year of the Levy Total Collections to Date 359 128 CITY OF BOZEMAN, MONTANA Unaudited statistical information. WATER SOLD BY TYPE OF CUSTOMER Past Six Fiscal Years (in hundreds of cubic feet “HCF”) 2002 2003 2004 2005 2006 2007 Type of Customer Residential 1,194,801 1,224,671 1,255,288 1,286,670 1,318,837 1,437,114 Government 25,041 25,667 26,308 26,966 27,640 62,913 MSU 267,365 274,049 280,901 287,923 295,121 298,352 Commercial 644,926 661,049 677,576 694,515 711,878 659,831 Total 2,132,133.0 2,185,436.3 2,240,072 2,296,074 2,353,476 2,458,209 Total direct rate 1,544.74$ 1,653.23$ 1,790.77$ 1,753.67$ 2,055.72$ 2,396.70$ per 1,000 HCF Source: 2006 City of Bozeman Water Facility Plan & 2007 City Records Fiscal Year 360 129 CITY OF BOZEMAN, MONTANA Unaudited statistical information. WATER AND SEWER RATES Past Six Fiscal Years Fiscal Year Monthly Rate per Monthly Rate per Ended Base 1,000 Base 1,000 June 30,Rate Gallons Rate Gallons 2002 9.36 15.15 10.74 17.8 2003 9.92 16.06 10.74 17.8 2004 9.92 17.24 10.74 17.8 2005 10.42 16.83 8.59 14.2 2006 11.46 18.53 9.88 16.3 2007 12.60 19.74 10.87 18.0 * For Residential Customers, using 5/8 inch meter size. Water Sewer 361 DEBT CAPACITY SECTION 362 130 CITY OF BOZEMAN, MONTANA Unaudited statistical information. RATIOS OF OUSTANDING DEBT BY TYPE Past Six Fiscal Years Fiscal Year General Special Less:Water Less:Total Percentage Ended Obligation Notes Assessment Capital Revenue Capital Primary of Personal Per June 30,Bonds Payable Bonds Leases Bonds Leases Government Income Capita 2002 6,110,000 443,880 5,515,000 - 2,390,631 (178,530) 14,280,981 1.88%497.47$ 2003 10,960,000 377,761 5,152,000 - 1,995,578 (292,329) 18,193,010 2.40%633.75$ 2004 10,565,000 308,397 4,149,800 - 1,582,299 (210,972) 16,394,524 2.16%571.10$ 2005 6,800,000 235,628 6,065,600 - 1,150,633 (90,385) 14,161,476 1.87%493.31$ 2006 6,325,000 159,286 7,004,769 - 700,412 - 14,189,467 1.87%464.31$ 2007 5,840,000 79,198 6,736,700 (83,256) 226,460 - 12,799,101 1.69%394.86$ Business-Type ActivitiesGovernmental Activities 364 131 CITY OF BOZEMAN, MONTANA Unaudited statistical information. RATIOS OF GENERAL BONDED DEBT OUTSTANDING Past Six Fiscal Years Percentage of Fiscal Actual Year General Special Taxable Ended Obligation Assessment Value of Per June 30,Bonds Bonds Total Property Capita 2002 6,110,000 5,515,000 11,625,000 27.4%404.95$ 2003 10,960,000 5,152,000 16,112,000 35.0%561.26$ 2004 10,565,000 4,149,800 14,714,800 29.7%512.59$ 2005 6,800,000 6,065,600 12,865,600 25.2%448.17$ 2006 6,325,000 7,004,769 13,329,769 23.0%464.34$ 2007 5,840,000 6,736,700 12,576,700 19.9%388.00$ General Bonded Debt Outstanding 365 132 CITY OF BOZEMAN, MONTANA Unaudited statistical information. DIRECT AND OVERLAPPING GENERAL BONDED DEBT OUTSTANDING Past Two Fiscal Years Applicable Applicable As of to City of As of to City of June 30, 2007 Bozeman June 30, 2006 Bozeman City of Bozeman, Montana General obligation debt 5,840,000$ 6,325,000$ Less: Debt Service Fund balance (deficit)(115,558) (106,783) Net general obligation debt 5,955,558$ 100%6,431,783$ 100% Overlapping Bonded Indebtedness Gallatin County: Various issues 11,620,000$ 34%12,100,000$ 34% Bozeman School District #7: Various issues 55,095,000 70%9,290,000 70% Total overlapping bond indebtedness 66,715,000$ 21,390,000$ Sources: City Hall, Bozeman, Montana Gallatin County Assessor's Office Bozeman School District #7 366 133 CITY OF BOZEMAN, MONTANA Unaudited statistical information. LEGAL DEBT MARGIN INFORMATION Past Six Fiscal Years 2002 2003 2004 2005 2006 2007 Debt limit*17,643,745 21,560,620 23,737,036 26,559,967 29,591,000 34,755,653 Total net debt applicable to limit (6,424,838) (7,747,833) (7,588,181) (3,750,411) (6,568,569) (5,595,558) Legal debt margin 11,218,907$ 13,812,787$ 16,148,855$ 22,809,556$ 23,022,431$ 29,160,095$ Total net debt applicable to the limit 36.4%35.9%32.0%14.1%22.2%16.1% as a percentage of debt limit *1.51% of total market value of taxable property of $2.302 Billion Fiscal Year 367 134 CITY OF BOZEMAN, MONTANA Unaudited statistical information. PLEDGED REVENUE COVERAGE Past Six Fiscal Years Fiscal Year Utility Less:Special Ended Service Operating Assessment June 30,Charges Expenses Principal Interest Coverage Collections Principal Interest Coverage - 2002 3,556,447 (2,326,317) (376,978) (120,747) 732,405 979,283 (709,000) (336,405) (66,122) 2003 3,935,636 (2,271,120) (395,052) (103,613) 1,165,851 1,050,180 (479,000) (270,202) 300,978 2004 4,359,299 (2,440,762) (413,280) (85,391) 1,419,866 932,771 (997,200) (250,571) (315,000) 2005 4,429,294 (2,647,507) (431,666) (65,963) 1,284,158 588,887 (2,951,200) (364,814) (2,727,127) 2006 5,401,069 (2,866,140) (450,220) (45,317) 2,039,392 1,472,058 (437,700) (297,876) 736,482 2007 6,124,533 (3,114,053) (473,952) (23,391) 2,513,137 1,428,084 (268,069) (309,099) 850,916 Water Revenue Bonds Special Assessment Bonds Debt Service Debt Service 368 DEMOGRAPHI C S AND ECONOMIC SECTION 370 135 CITY OF BOZEMAN, MONTANA Unaudited statistical information. DEMOGRAPHIC AND ECONOMIC STATISTICS Past Six Fiscal Years Fiscal Per Residents Year Capita with Bachelors K-12 Ended Personal Personal Average Degree or School Unemployment June 30,Population Income Income Age Higher Schooling Enrollment Rate 2002 28,707 534,242,581$ 18,610$ 31.79 yrs 41.0%5,124 3.4% 2003 30,753 615,242,946$ 20,006$ 31.79 yrs 41.0%5,101 3.3% 2004 30,869 663,880,909$ 21,506$ 31.79 yrs 41.0%5,086 3.2% 2005 32,412 749,345,172$ 23,119$ 31.79 yrs 41.0%5,198 2.8% 2006 33,535 833,456,347$ 24,853$ 31.79 yrs 41.0%5,332 2.0% 2007 35,061 927,082,962$ 26,442$ 31.79 yrs 41.0%5,356 1.5% Sources: Bureau of Economic Analysis Gallatin County National Center of Education Statistics US Census Bureau 372 136 CITY OF BOZEMAN, MONTANA Unaudited statistical information. PRINICPAL EMPLOYERS Current and Nine Years Ago Private Employer Private Employer Employers Class Employers Class By Class Size By Class Size Bozeman Deaconess Hospital 8 Bozeman Deaconess Hospital 7 Home Care Services 8 Home Care Services 7 Kenyon Noble Lumber & Hardware 7 Wal-Mart 7 RightNow Technologies 7 Barnard Construction 6 Wal-Mart 7 Big Sky Carvers 6 Albertson’s 6 Big Sky Publishing 6 Bozeman Daily Chronicle 6 Costco 6 Community Food Co-Op 6 Gibson Guitar 6 Costco 6 Gran Tree Inn 6 First Security Bank 6 Holnam Inc 6 JTL Group Inc. - Belgrade 6 Kenyon Noble Lumber & Hardware 6 Laidlaw Transit 6 Kmart 6 Martel Construction 6 Life Link International 6 McDonald's 6 Louisiana Pacific 6 Murdoch's Ranch & Home Supply 6 Martel Construction 6 Ressler Chevrolet Cadillac & Toyota 6 Personnel Leasing 6 Simkins-Hallin Lumber 6 Powerhouse Technologies 6 Town and Country Foods 6 Big R Ranch & Home Supply (Murdoch's)6 Williams Plumbing & Heating 6 Simkins Hallin Lumber 6 Zoot Enterprises 6 Video Lottery Cons 6 Public Employer Employer Employers Class Class By Class Size By Class Size Montana State University 9 Montana State University 9 School District #7 8 School District #7 8 City of Bozeman 7 Gallatin County 7 Gallatin County 7 City of Bozeman 7 Class 6 - 100 to 249 Employees Class 7 - 250 to 499 Employees Class 8 - 500 to 999 Employees Class 9 - 1,000+ Employees 2007 1998 373 OPERATING SECT ION 374 137 CITY OF BOZEMAN, MONTANA Unaudited statistical information. FULL-TIME EQUIVALENT CITY GOVERNMENT EMPLOYEES BY FUNCTION/PROGRAM Past Six Fiscal Years 2002 2003 2004 2005 2006 2007 General Government City commission 4.00 4.00 4.00 4.00 2.10 2.10 City manager 5.50 6.50 7.50 7.50 9.50 9.50 Municipal court 5.00 5.00 6.00 6.00 6.00 6.00 City attorney 6.00 6.00 6.00 6.00 6.00 6.00 Finance 16.75 16.00 16.00 16.00 16.00 16.00 Office of planning & community development 11.70 12.70 12.70 12.70 12.70 12.70 Zoning - - - - - - Building maintenance 0.55 0.55 1.55 2.55 2.55 2.55 Total general government 49.50 50.75 53.75 54.75 54.85 54.85 Public Safety Police department 48.25 48.25 48.25 49.75 52.75 54.75 Fire department 28.75 29.75 29.75 29.25 29.25 31.25 Building inspection 10.05 10.55 10.55 15.05 15.05 15.55 Parking 1.75 2.75 2.75 2.75 2.75 3.75 9-1-1 - - - - - - Total public safety 88.80 91.30 91.30 96.80 99.80 105.30 Public Services Public services administration 7.15 7.15 7.15 7.15 7.15 7.15 Streets 13.62 13.62 13.62 13.62 13.62 15.62 Water plant 9.27 9.27 9.27 9.27 9.27 9.27 Water operations 13.12 14.12 14.12 14.12 14.62 14.62 Wastewater operations 6.75 7.75 7.75 7.75 9.25 9.25 Wastewater plant 15.87 15.87 14.87 14.87 14.87 14.87 Solid waste collection 10.74 10.74 10.74 11.74 11.74 12.74 Solid waste disposal 7.66 7.66 7.66 7.66 7.66 7.66 Vehicle maintenance 2.50 2.50 2.50 3.50 3.50 4.00 Total public services 86.68 88.68 87.68 89.68 91.68 95.18 Public Welfare Cemetery 5.25 5.25 5.25 5.25 5.25 5.25 Parks 11.95 11.95 11.95 11.95 11.95 12.95 Forestry 3.60 3.60 3.60 3.60 3.60 4.60 Library 19.66 19.66 19.66 19.66 19.66 19.66 Recreation 14.65 14.65 14.65 14.65 14.65 14.65 Community development - 1.00 1.00 1.00 1.00 1.00 Total public welfare 55.11 56.11 56.11 56.11 56.11 58.11 Total all funds 280.09 286.84 288.84 297.34 302.44 313.44 Fiscal Year Ended June 30, 376 PART IV REPORTS OF INDEPENDENT PUBLIC ACCOUNTANTS AND SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AS REQUIRED BY U.S. OFFICE OF MANAGEMENT AND BUDGET CIRCULAR A-133, AUDITS OF STATE AND LOCAL GOVERNMENTS AND NON-PROFIT ORGANIZATIONS 378 138 CITY OF BOZEMAN, MONTANA SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS FOR THE YEAR ENDED JUNE 30, 2007 Grant Grant Federal Grant Balance Revenue Revenue Total Awards Balance CFDA Award June 30, 2006 Received Accrued Revenue Expended June 30, 2007 U.S. Department of Justice New Rural Domestic Assistance Grant Fund 140 16.589 173,968 - - 173,968 173,968 173,968 -$ Passed through Gallatin County: Missouri River Drug Task Force 16.579 77,014 - 60,909 16,105 77,014 77,014 -$ U.S. Department of Transportation Passed through MT Dept. of Transportation: Highway Traffic Safety Bozeman Occupant Protection: 00-03-09-02 20.600 16,471 - 16,471 - 16,471 16,471 -$ CTEP Community Transportation Enhancement Projects MDT STPE 16(34) - Soroptimist Park 20.205 163,703 - - 163,703 163,703 163,703 -$ MDT STPE 1299(18) - Milwaukee Railroad Trail 20.205 136,376 - 26,030 110,346 136,376 136,376 -$ U.S. Department of Interior Passed through the Historical Society: Historic Preservation 15.904 5,500 - 5,500 - 5,500 5,500 -$ Federal Emergency Management Agency 2001-03-6400-6400-4101-D-Supplement Fire Prevention 83.554 84,060 - - 84,060 84,060 84,060 -$ U.S. Environmental Protection Agency STAG Grant - Hyalite Water Transmission Line 66.606 279,944 - 89,718 190,226 279,944 279,944 -$ U.S. Department of Housing & Urban Development Passed through MT Department of Commerce: #MT-CDBG-EDPG-06-02 - Tech Ranch 14.228 15,000 - - 15,000 15,000 15,000 -$ #MT-BSEDTF-01-07-03 - CDI-Aerospace 14.228 37,250 - 37,250 - 37,250 37,250 -$ City of Bozeman / Story Mansion HUD EDI-SP #B-04-SP-MT-0425 14.246 50 - - 50 50 50 -$ HUD EDI-SP #B-05-SP-MT-0425 14.246 30,638 - - 30,638 30,638 30,638 -$ Total Federal Financial Assistance 1,019,974$ - 235,878 784,096 1,019,974 1,019,974 -$ FEDERAL GRANTOR 380 139 CITY OF BOZEMAN, MONTANA NOTES TO SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS June 30, 2007 NOTE 1. REPORTING ENTITY The City of Bozeman’s reporting entity is defined in Note 1 of the City’s financial statements. Expenditures of federal awards received directly from federal agencies as well as federal awards passed through other government agencies are included in the accompanying schedule. NOTE 2. BASIS OF ACCOUNTING The accompanying Schedule of Expenditures of Federal Awards is presented using the modified accrual basis of accounting, which is described in Note 1 of the City’s financial statements. NOTE 3. NON-CASH TRANSACTIONS The City had no non-cash transactions in the accompanying schedule of expenditures of federal awards. 381 140 INDEPENDENT AUDITOR’S REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS Honorable Mayor, City Commissioners, and City Manager of the City of Bozeman, Montana: We have audited the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the City of Bozeman, Montana, as of and for the year ended June 30, 2007, and have issued our report thereon dated December 26, 2007. We additionally audited the 2006 financial statements of the Bozeman Public Library Foundation, a discretely presented component unit of the City. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Internal Control over Financial Reporting In planning and performing our audit, we considered the City of Bozeman’s internal control over financial reporting as a basis for designing our auditing procedures for the purpose of expressing our opinion on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control over financial reporting. Accordingly, we do not express an opinion on the effectiveness of the City’s internal control over financial reporting. Our consideration of internal control over financial reporting was for the limited purpose described in the preceding paragraph and would not necessarily identify all deficiencies in internal control over financial reporting that might be significant deficiencies or material weaknesses. However, as discussed below, we identified certain deficiencies in internal control over financial reporting that we consider to be significant deficiencies. A control deficiency exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent or detect misstatements on a timely basis. A significant deficiency is a control deficiency, or combination of control deficiencies, that adversely affects the entity’s ability to initiate, authorize, record, process, or report financial data reliably in accordance with generally accepted accounting principles such that there is more than a remote likelihood that a misstatement of the entity’s financial statements that is more than inconsequential will not be prevented or detected by the entity’s internal control. We consider the deficiencies described in the accompanying schedule of findings and responses to be significant deficiencies in internal control over financing reporting (2007-1, 2007-2, and 2007-3). A material weakness is a significant deficiency, or combination of significant deficiencies, that results in more than a remote likelihood that a material misstatement of the financial statements will not be prevented or detected by the entity’s internal control. Our consideration of the internal control over financial reporting was for the limited purpose described in the first paragraph of this section and would not necessarily identify all deficiencies in the internal control that might be significant deficiencies and, accordingly would not disclose all significant deficiencies that are also considered to be material weaknesses. However, of the significant deficiencies described above, we consider item 2007-1 to be a material weakness. 382 141 Compliance and Other Matters As part of obtaining reasonable assurance about whether the City of Bozeman’s financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts and grants, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit and, accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance that is required to be reported under Government Auditing Standards, as noted in the Schedule of Findings and Questioned Costs. This report is intended solely for the information and use of the City of Bozeman’s management, Board of Commissioners, the Montana Department of Administration, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. Junkermier, Clark, Campanella, Stevens, P.C. Bozeman, Montana December 26, 2007 383 142 INDEPENDENT AUDITOR’S REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 Honorable Mayor, City Commissioners, and City Manager of the City of Bozeman, Montana: Compliance We have audited the compliance of the City of Bozeman with the types of compliance requirements described in the U.S. Office of Management and Budget (OMB) Circular A-133 Compliance Supplement that are applicable to its major federal programs for the year ended June 30, 2007. The City of Bozeman’s major federal programs are identified in the summary of auditor’s results section of the accompanying schedule of findings and questioned costs. Compliance with the requirement of laws, regulations, contracts and grants applicable to the major federal programs is the responsibility of the City of Bozeman’s management. Our responsibility is to express an opinion on the City of Bozeman’s compliance based on our audit. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and OMB Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations. Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes examining, on a test basis, evidence about the City of Bozeman’s compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal determination of the City of Bozeman’s compliance with those requirements. In our opinion, the City of Bozeman complied, in all material respects, with the requirements referred to above that are applicable to its major federal programs for the year ended June 30, 2007. Internal Control Over Compliance The management of the City of Bozeman is responsible for establishing and maintaining effective internal control over compliance with requirements of laws, regulations, contracts and grants applicable to federal programs. In planning and performing our audit, we considered the City of Bozeman’s internal control over compliance with requirements that could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance but not for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of the City of Bozeman’s internal control over compliance. 384 143 A control deficiency in an entity’s internal control over compliance exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent or detect noncompliance with a type of compliance requirement of a federal program on a timely basis. A significant deficiency is a control deficiency, or combination of control deficiencies, that adversely affects the entity’s ability to administer a federal program such that there is more than a remote likelihood that noncompliance with a type of compliance requirement of a federal program that is more inconsequential will not be prevented or detected by the entity’s internal control. A material weakness is a significant deficiency, or combination of significant deficiencies, that results in more than a remote likelihood that material noncompliance with a type of compliance requirement of a federal program will not be prevented or detected by the entity’s internal control. Our consideration of internal control over compliance was for the limited purpose described in the first paragraph of this section and would not necessarily identify all deficiencies in internal control that might be significant deficiencies or material weaknesses. We did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses. This report is intended solely for the information and use of the City of Bozeman’s management, Board of Commissioners, the Montana Department of Administration, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. JUNKERMIER CLARK CAMPANELLA & STEVENS, PC Bozeman, Montana December 26, 2007 385 144 SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ended June 30, 2007 SUMMARY OF AUDIT RESULTS The auditor’s report expresses an unqualified opinion on the financial statements. Three significant deficiencies, one of which is a material weakness, disclosed during the audit of the financial statements are reported in the report on compliance and on internal control over financial reporting based on an audit of financial statements performed in accordance with Government Auditing Standards. No instances of noncompliance material to the financial statements of the City of Bozeman were disclosed during the audit. No significant deficiencies relating to the audit of the major federal awards programs are reported in the report on compliance with requirements applicable to its major programs and internal control over compliance in accordance with OMB Circular A-133. The auditor’s report on compliance for the major federal awards programs for the City of Bozeman expresses an unqualified opinion on the major programs. The audit did not disclose any audit findings which the auditor is required to report under OMB Circular A-133. The major programs are: Soroptimist Park, CFDA number 20.205 and Milwaukee Railroad Trail, CFDA number 20.205. The threshold for distinguishing Types A and B programs was $300,000. The City of Bozeman was determined to be a low-risk auditee. FINDINGS AND QUESTIONED COSTS - MAJOR FEDERAL AWARD PROGRAM AUDIT None reported. 386 145 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (CONTINUED) Year Ended June 30, 2007 FINDINGS AND SIGNIFICANT DEFICIENCIES - FINANCIAL STATEMENTS AUDIT 2007-1 Criteria: The City is required to record donated infrastructure in enterprise funds and the entity-wide governmental statements in the year of donation. Condition: Donated infrastructure was not recorded subsequent to implementation of Governmental Accounting Standards Board Statement 34 in the entity- wide governmental funds. Donated infrastructure in the water and sewer funds was not recorded in the year of donation. Effect: The City’s financial statements for the year ended June 30, 2007 reflect material prior period adjustments to record the prior year’s donated infrastructure, net of accumulated depreciation. Recommendation: The City’s Finance Department needs to be given the value of donated infrastructure from the City’s engineers on a timely basis. Further, the infrastructure should be recorded in the proper period. 2007-2 Criteria: The City’s Finance Department is responsible for timely closing the books at yearend and providing accurate financial reporting. Condition: The process to close the books is time consuming, the Finance Department suffered from staff shortages much of the year, and the majority of the reporting duties are the Controller’s alone. Effect: The City’s financial statements for the year ended June 30, 2007 were not closed to the point of being ready for audit until December 2007. Management does not have access timely and accurate financial information, and additionally, the City is experiencing difficulty making the December 31 deadline for the GFOA reporting certificate. Recommendation: Closing procedures should be stream-lined and appropriate staffing levels and training should be maintained. 2007-3 Criteria: For effective cash management, the City’s cash and investment accounts should be reconciled with the financial institution on a timely and accurate basis. Condition: Due to the conditions mentioned in Finding 2007-2, Finance Department personnel were not reconciling significant bank account balances on a monthly basis. Effect: City personnel spent an inordinate amount of time reconciling the June 30, 2007 statements to verify that yearend balances were not materially misstated. Recommendation: The City’s Finance Department should develop a procedure to simplify matching of deposits made at the bank with the method the deposits are recorded in HTE. 387 146 CURRENT STATUS OF PRIOR YEAR RECOMMENDATIONS Year Ended June 30, 2007 There were no findings, questioned costs, or reportable conditions with regard to federal award programs for the year ended June 30, 2006. 388 390 391 392 393 394 395 396 397 398 399