27.3 Financial Statement Trend and Comparative Analysis

Financial Statement Trend and Comparative Analysis

Financial statement analysis in the public sector enables finance directors, auditors, oversight bodies, and credit rating agencies to assess financial condition, track structural operational trends, and identify fiscal distress before it results in insolvency. Unlike commercial financial analysis, which centers on profitability and earnings per share, governmental financial analysis focuses on interperiod equity, budgetary compliance, service sustainability, and debt solvency.

Horizontal (Trend) Analysis and Base-Year Indexing

Horizontal analysis compares financial statement line items across multiple consecutive fiscal years to determine absolute dollar changes and percentage growth rates. This multi-year perspective is critical because single-year changes in governmental accounting often reflect non-recurring events, such as one-time federal stimulus grants, capital bond issuances, or extreme weather expenditures.

$\text{Percentage Change} = \left( \frac{\text{Current Year Amount} - \text{Prior Year Amount}}{\text{Prior Year Amount}} \right) \times 100\%$

For multi-year trajectory analysis spanning five to ten years, base-year percentage analysis sets an initial fiscal year as the baseline (100.0%) and expresses subsequent years as an index relative to that base:

$\text{Base-Year Index} = \left( \frac{\text{Year } t \text{ Amount}}{\text{Base Year Amount}} \right) \times 100$

By comparing the base-year index trajectories of revenues against expenditures, analysts uncover structural deficits—scenarios where recurring operating expenditures systematically outpace organic revenue growth, signaling an unsustainable fiscal model even if current fund balances appear adequate.

Vertical Analysis and Common-Size Financial Statements

Vertical analysis converts each item on a financial statement into a relative percentage of a common base figure within the same fiscal period, creating common-size financial statements:

• Statement of Net Position / Balance Sheet: Individual asset and liability accounts are expressed as a percentage of Total Assets (or Total Assets plus Deferred Outflows). Fund balance components (Nonspendable, Restricted, Committed, Assigned, Unassigned) are evaluated as percentages of Total Fund Balance and Total Expenditures.
• Statement of Activities / Operating Statement: Functional expenses (e.g., General Government, Public Safety, Health and Human Services) are expressed as a percentage of Total Expenses. On the revenue side, each tax revenue category (property, sales, income) and intergovernmental grant stream is evaluated as a percentage of Total Revenues.

Vertical analysis eliminates distortion caused by government size, permitting meaningful comparative benchmarking across peer entities of differing populations or budgets.

---

Public Sector Financial Ratio Analysis

Financial ratios condense complex governmental financial statements into standardized performance indicators categorized into liquidity, solvency, debt burden, and operational stability.

Liquidity Ratios: Assessing Short-Term Resilience

Liquidity measures a government's capacity to satisfy immediate cash commitments, payroll obligations, and debt maturities without emergency borrowing or asset liquidation:

1. Current Ratio: $\text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}}$ Measures short-term coverage in proprietary funds or modified accrual balance sheets. A ratio above 1.5x to 2.0x generally indicates sound liquidity.

2. Quick Ratio (Acid-Test Ratio): $\text{Quick Ratio} = \frac{\text{Cash and Cash Equivalents} + \text{Current Investments} + \text{Taxes/Accounts Receivable}}{\text{Current Liabilities}}$ A more conservative measure that strips out illiquid inventories and prepaid expenditures.

3. Days of Operating Cash (Days Cash on Hand): $\text{Days Cash on Hand} = \frac{\text{Unrestricted Cash and Cash Equivalents} \times 365}{\text{Total Operating Expenditures} - \text{Depreciation Expense}}$ Widely monitored by credit rating agencies (Moody's, S&P, Fitch). The Government Finance Officers Association (GFOA) recommends maintaining at least 60 to 90 days of operating cash in the General Fund, whereas highly rated municipalities frequently maintain 150 to 250 days to buffer against economic shocks.

Solvency and Debt Burden Ratios

Solvency addresses a government's capacity to support long-term debt liabilities and fulfill contractual obligations without jeopardizing public services:

1. Debt Service Coverage Ratio (DSCR): Critical for municipal revenue bonds (e.g., water and sewer authorities, toll systems, public airports). Bond indentures establish statutory covenants requiring net operating revenues to cover annual debt service by a defined safety margin: $\text{DSCR} = \frac{\text{Gross Operating Revenues} - \text{Operating Expenses (excluding Depreciation and Amortization)}}{\text{Annual Principal and Interest Debt Service}}$ CGFM Benchmark: Legal covenants typically mandate a minimum DSCR of 1.20x to 1.35x. A drop below 1.0x indicates that enterprise operating cash is insufficient to service debt, threatening bond covenant default and triggering reserve fund invasions.

2. Debt to Assets Ratio: $\text{Debt to Assets} = \frac{\text{Total Liabilities}}{\text{Total Assets}}$ Evaluates financial leverage on the government-wide Statement of Net Position.

3. Debt per Capita: $\text{Debt per Capita} = \frac{\text{Net General Obligation Bonded Debt}}{\text{Total Resident Population}}$ Normalizes municipal tax-supported debt burden against demographic size. High debt per capita indicates potential taxpayer resistance to future millage rate increases.

4. Debt as a Percentage of Assessed Property Valuation: $\text{Debt to Assessed Valuation} = \left( \frac{\text{Net General Obligation Debt}}{\text{Total Taxable Assessed Valuation}} \right) \times 100\%$ Measures outstanding debt against the tax base legally pledged to retire it. State constitutions and municipal charters routinely impose legal debt limits expressed as a percentage of taxable assessed valuation (typically between 5% and 10%).

Operating and Financial Independence Ratios

1. Operating Margin Ratio: $\text{Operating Margin} = \frac{\text{Total Revenues} - \text{Total Expenditures}}{\text{Total Revenues}}$ Positive margins indicate operational surplus and replenishment of reserves; persistent negative margins reflect structural deficits.

2. Net Position Trend Ratio: $\text{Net Position Trend} = \left( \frac{\text{Ending Total Net Position} - \text{Beginning Total Net Position}}{\text{Beginning Total Net Position}} \right) \times 100\%$ Measures whether a government became financially stronger or weaker over the fiscal year on an economic resources measurement focus.

3. Own-Source Revenue Ratio: $\text{Own-Source Revenue Ratio} = \frac{\text{Taxes, User Charges, Licenses, and Local Fees}}{\text{Total Revenues}}$ Gauges fiscal autonomy. Entities that rely heavily on intergovernmental grants (low own-source ratios) face heightened vulnerability to state or federal budget reductions.

---

Strategic Sourcing Analysis

Strategic sourcing uses spend analytics across agencies, categories, vendors, and contracts to identify fragmented purchasing and evaluate government-wide acquisition alternatives. Analysts establish a clean spend baseline, normalize vendor names and commodity codes, separate addressable from non-addressable spend, evaluate demand and total cost of ownership, and assess competition, small-business, socioeconomic, resilience, and mission constraints. The recommended strategy may consolidate volume, standardize specifications, use shared contracts, or deliberately retain multiple suppliers to control concentration and supply-chain risk. Savings claims should compare like-for-like prices and quantities, subtract transition and contract-management costs, and distinguish negotiated price reductions from demand reduction or cost avoidance.