Governmental Asset & Investments Dashboard

Welcome to the "Governmental Assets & Investments Dashboard." This dashboard was created for the Governmental Assets and Investments Taskforce to enable an informed discussion on governmental entity cash reserves, investments, assets, and other related policy research metrics.

This an evolving dashboard that may look different depending on the needs of the taskforce. If you have questions or recommendations please contact:

  • Alex Nielson | alexnielson@utah.gov | Data Science Manager
  • Marcie Mortensen | msmortensen@utah.gov| Data Analyst
Pages
  • Overview: Displays a statewide look at deposit and investment information.
  • Single Entity Explorer: Displays key ratios, and deposit and investment information over any selected entity name.
  • Statewide Explorer: Displays government level metrics and ratios on a goverment level selection.
  • Outlier Explorer: Displayes tend tables for unrestricted cash, containts box plot to display outliers in data.
  • Bank Explorer: Displays investment and deposit information with a focus on specific banks.
Interactive Components
  • Filters: The 'Single Entity Exploer', 'Statewide Explorer', 'Outlier Explorer', and the 'Bank Explorer' pages have filters on the left hand side of the page. The filters on the left side of the page can be used to select government levels, entity names, and specific time periods.
  • Charts: You can use your mouse to hover or click on chart points to learn more about the data you see.
  • Buttons: Use your mouse to click the 'Adjust for Inflation' button to convert all graph values to 2024 dollar amounts. You can also click the 'View Inflation Table' button to display the corresponding table.
  • Description: This dashboard is to help the Governmental Asset and Investments Taskforce report to the legislature on how much cash and other relevant reserves each governmental entity has in the State.
  • Sources: Deposit and Investment Reports, ACFRs, and Report Reviews.
  • Timespan: Fiscal Years 2017-2025

Data Sources

  • Deposit and Investment Reports: Governmental entities submit deposits and investment data to the Office of the State Treasurer in June and December. Additional information can be found at https://treasurer.utah.gov/for-government/deposit-and-investment-reporting/
  • Annual Financial Reports: Governmental entities submit annual financial reports and statements to the Office of the State Auditor each fiscal year. Additional information can be found at https://auditor.utah.gov/local-government/explanations-checklists-and-templates/forms-manuals-guides/
  • Report Reviews: Office of the State Auditor staff manually review submitted reports for errors and typos. Begining in 2018, staff began manually extracting and storing key financial statement information as a part of the report review process.
  • Inflation Adjustments: Inflation adjustments were made using the average annual CPI-U from the Bureau of Labor Statistics.
  • Bank Level Designation: Bank levels such as national, regional, and local were determined through various searches based on the geographic coverage of each institution.

Security Types

When governmental entities in Utah report their investment data to the Office of the State Treasurer, they utilize various security types to categorize their holdings. Understanding these categories is crucial for accurate reporting and effective treasury management. Here's an explanation of each type in this context:

  • Agency

    Definition: These are debt securities issued by government-sponsored enterprises (GSEs) or federal government agencies. Examples include securities issued by Fannie Mae, Freddie Mac, or Ginnie Mae. While backed by the full faith and credit of the U.S. government (for some), others have implied or explicit government backing.

    Reporting Context: Governmental entities might invest in Agency securities for their relative safety and potential for slightly higher yields compared to direct U.S. Treasuries.

  • CP (Commercial Paper)

    Definition: Commercial Paper is a short-term, unsecured promissory note issued by corporations to finance short-term debt obligations. It typically has a maturity of less than 270 days and is used for working capital needs, inventory financing, and accounts payable.

    Reporting Context: While less common for direct investment by governmental entities due to its unsecured nature and corporate issuer, sophisticated treasury operations might consider highly-rated CP from extremely stable corporations as a short-term cash management tool.

  • Corp Note (Corporate Note/Bond)

    Definition: These are debt instruments issued by corporations to raise capital. They represent a loan from the bondholder to the corporation, with the corporation promising to repay the principal amount on a specific maturity date and usually pay periodic interest (coupons).

    Reporting Context: Governmental entities may invest in Corporate Notes to achieve higher yields than government-backed securities. However, due diligence regarding the financial health and creditworthiness of the issuing corporation is paramount.

  • Equities (Stocks)

    Definition: Equities represent ownership in a corporation, giving the shareholder a claim on the company's assets and earnings. Common stock provides voting rights, while preferred stock typically offers fixed dividends but no voting rights.

    Reporting Context: Investment in equities by governmental entities is generally more restricted due to their higher volatility and risk compared to fixed-income securities. If permitted by investment policy, it would likely be through diversified vehicles like mutual funds or ETFs rather than individual stocks.

  • Municipal Bonds

    Definition: These are debt securities issued by state and local governments or their agencies to finance public projects such as schools, highways, and hospitals. They are often considered attractive due to their tax-exempt interest income at the federal level and sometimes at the state and local levels.

    Reporting Context: Governmental entities within Utah might invest in municipal bonds issued by other governmental entities for diversification and yield enhancement, especially if the interest is tax-exempt for them as well.

  • Mutual Fund

    Definition: A mutual fund is a type of financial vehicle made up of a pooled portfolio of stocks, bonds, or other securities. Investors buy shares in the fund, and the fund's assets are managed by a professional fund manager.

    Reporting Context: Mutual funds offer diversification and professional management, making them a popular investment vehicle for governmental entities seeking to spread risk across various underlying assets. Reporting would specify the name of the mutual fund, its investment objective (e.g., money market, bond fund, balanced fund), and the value of the investment.

  • Negotiable Brokered CD (Certificate of Deposit)

    Definition: A Negotiable Brokered CD is a time deposit offered by banks, typically with a fixed interest rate and maturity date. The "negotiable" aspect means it can be bought and sold in the secondary market before maturity, unlike a standard CD. They are often purchased through a broker.

    Reporting Context: Governmental entities might invest in Negotiable Brokered CDs for their relative safety and predictable returns. The ability to sell them in the secondary market offers some liquidity.

  • Qualified Bank CD (Certificate of Deposit)

    Definition: A Qualified Bank CD is a time deposit offered by a bank. The term "qualified" often implies adherence to specific regulatory or investment policy requirements, such as being FDIC-insured up to certain limits or meeting specific maturity and yield criteria deemed acceptable for public funds.

    Reporting Context: These are generally considered very safe investments for governmental entities. The "qualified" designation ensures they meet the stringent standards set by the Utah State Treasurer's Office or the entity's own investment policy for safeguarding public funds.

  • Treasury

    Definition: This refers to debt securities issued by the U.S. Department of the Treasury. The most common types include Treasury Bills (T-Bills) with maturities of one year or less, Treasury Notes (T-Notes) with maturities of 2 to 10 years, and Treasury Bonds (T-Bonds) with maturities of 20 to 30 years. These are considered among the safest investments globally, backed by the full faith and credit of the U.S. government.

    Reporting Context: Treasury securities are a cornerstone of many governmental investment portfolios due to their unparalleled safety and liquidity.

Dashboard Wide Filters

Inflation

To help standardize large increases in dollar amounts (due to record breaking inflation), we allow users to adjust dollar values to 2024 dollar values. Charts elements will include the inflation adjusted value in the tooltips, but to show the inflation adjusted values in tables and charts, please click the above switch.

Deposit and Investments - Reporting Period

Deposit and Investment reports are submitted twice a year to the State Treasurer's Office. Annual Financial Reports will correspond to a government entity's fiscal year, which may end in a different month than the Deposit and Investment Report submitted by the entity.

Comparing Deposits and Investments by Year Cohort
Comparing Change (2019-2025) Deposits and Investments Cohort
Year-Over-Year (YOY) Change Deposits and Investments by Cohort
Year-Over-Year (YOY) Percent Change Deposits and Investments by Cohort

Comparing Demographics

Demographics Trends

Deposit Information

Loading...
Loading...
Loading...
Loading...

Investment Info

Loading...
Loading...
Loading...
Loading...

Key Ratios

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...

Keyword Filters

Automated Textual Analysis

This page enables users to analyze Survey Respones. The first section is involves a feature co-occurance network. Keywords that occur together are connected with thicker lines, and you are enabled to filter the keywords you want to see displayed. A supplementary frequency bar chart and table provide another way of analzing answers by what words were most used. The final section shows the raw responses as rows in a table.

Keyword Network

Keyword Frequency

Keyword Network (Stems)

Keyword Frequency (Stems)

Deposit Information

Loading...
Loading...
Loading...
Loading...

Investment Info

Loading...
Loading...
Loading...
Loading...

Key Ratios

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Outlier Detection Explanation

This page attempts to highlight entities that are a different from similar government types. If an entity is an "outlier" it does not necessarily mean they are doing anything good or bad. The task force is interested in identifying these entities so we can better understand their unique situation. This is the first attempt at outlier detection, and it is likely certain government types may need further stratefication such as "Local and Special Service Districts" due to the wide variety of sizes and government functions.