Study guide
27.3 Financial Statement Trend and Comparative Analysis
Certified Government Financial Manager CGFM
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Organization, Authority and Structure of Government — Part I
1.1 Levels, Branches, and Separation of Powers 1.2 Components of Government & Public Authorities 1.3 Subnational Governments: General-Purpose vs. Special-Purpose
2 Chapter 2: Organization, Authority and Structure of Government — Part II
2.1 Legal Authority, Charters, and Sovereign Powers 2.2 Tribal Sovereignty & Intergovernmental Relations 2.3 Categorical Grants vs. Block Grants
3 Chapter 3: The Government Financial Management Cycle & Legal Framework — Part I
3.1 The Seven Phases of the Financial Management Cycle 3.2 The Closed-Loop Feedback Architecture 3.3 The Constitutional Basis: The Power of the Purse
4 Chapter 4: The Government Financial Management Cycle & Legal Framework — Part II
4.1 Types of Legislative Appropriations 4.2 The Hierarchy of Budgetary Spending Controls 4.3 Legal Mechanisms Dedicating Public Revenues
5 Chapter 5: Government Revenues, Grants & Debt Financing — Part I
5.1 Public Tax Policy and Tax Structures 5.2 Wealth and Property Taxes 5.3 Intergovernmental Grants & the Uniform Guidance Lifecycle 5.4 The OMB Uniform Guidance Grant Lifecycle (2 CFR 200)
6 Chapter 6: Government Revenues, Grants & Debt Financing — Part II
6.1 User Charges, Cost Recovery, Leases & Public-Private Partnerships 6.2 Public Debt Issuance, Bond Types & Credit Ratings 6.3 Certificates of Participation (COPs) and Lease-Revenue Bonds
7 Chapter 7: Public Accountability, Transparency & Open Government — Part I
7.1 Legislative Frameworks for Accountability: IG Act & CFO Act 7.2 Government Management Reform Act (GMRA) of 1994 7.3 Assessing Fiscal Sustainability, Solvency & SEA Reporting
8 Chapter 8: Public Accountability, Transparency & Open Government — Part II
8.1 Net Pension Liability (NPL) Recognition 8.2 Open Government, DATA Act of 2014 & Citizen-Centric Reporting 8.3 Digital Open Checkbooks
9 Chapter 9: Public Sector Ethics & Digital Government — Part I
9.1 Public Service Ethics Principles & the AGA Code of Ethics 9.2 The Ethical Spectrum: The Ethical Floor vs. The Ethical Ceiling 9.3 Managing Conflicts of Interest, Due Care, Whistleblowing & Nepotism
10 Chapter 10: Public Sector Ethics & Digital Government — Part II
10.1 Post-Employment "Revolving Door" Prohibitions (18 U.S.C. § 207) 10.2 E-Government Services, Public Portals & NIST Cybersecurity Standards 10.3 Personally Identifiable Information (PII)
11 Chapter 11: Governmental Accounting Principles & Cost Allocation — Part I
11.1 Environmental Differences, Standard Setters & GAAP Hierarchies 11.2 Standard-Setting Bodies and Jurisdictional Framework 11.3 State and Local GAAP Hierarchy: GASB Statement No. 76 11.4 Measurement Focus, Basis of Accounting & Nonexchange Transactions
12 Chapter 12: Governmental Accounting Principles & Cost Allocation — Part II
12.1 The Four GASB Statement No. 33 Nonexchange Categories 12.2 Managerial Cost Accounting, SFFAS 4 & Intergovernmental Fee Establishment 12.3 Cost Allocation under OMB Uniform Guidance (2 CFR 200 Subpart E)
13 Chapter 13: Public Budgeting Concepts & Controls — Part I
13.1 Public Budget Formulation, Structures & Budgeting Approaches 13.2 Fund 13.3 Performance-Based Budgeting (PBB) 13.4 Capital Project Financing, Capital Budgets & Revenue/Expenditure Forecasting
14 Chapter 14: Public Budgeting Concepts & Controls — Part II
14.1 Public-Private Partnerships (P3s) 14.2 Budgetary Control Techniques & General Ledger Accounting Operations 14.3 Stock Statements vs. Flow Statements
15 Chapter 15: State & Local Fund Accounting & Budgetary Accounting — Part I
15.1 The Eleven State & Local Fund Types & Accounting Bases 15.2 Capital Projects Funds (CPF) 15.3 Custodial Funds 15.4 Modified Accrual Accounting: Revenues, Expenditures & Financing Sources
16 Chapter 16: State & Local Fund Accounting & Budgetary Accounting — Part II
16.1 Other Financing Sources (OFS) and Other Financing Uses (OFU) 16.2 Budgetary Integration, Encumbrance Entries & GASB 54 Fund Balance Classifications 16.3 Nonspendable Fund Balance
17 Chapter 17: State & Local Financial Reporting & Statements — Part I
17.1 Defining the State & Local Reporting Entity & Component Units 17.2 Pathway 3: Misleading to Exclude & Affiliated Organizations (GASB 39 & 90) 17.3 Joint Ventures 17.4 The Annual Comprehensive Financial Report (ACFR) Structure & RSI
18 Chapter 18: State & Local Financial Reporting & Statements — Part II
18.1 Required Supplementary Information (RSI Other than MD&A) 18.2 Government-Wide Financial Statements, Interfund Eliminations & Reconciliation 18.3 Internal Balances (Due To / Due From)
19 Chapter 19: Federal Budgetary Accounting & the USSGL — Part I
19.1 Federal Accounting Governance: FASAB, OMB, Treasury & GAO 19.2 Comparative Analysis: The Quadripartite Leadership 19.3 Federal Budgetary Terminology, the Budgetary Equation & Fund Types
20 Chapter 20: Federal Budgetary Accounting & the USSGL — Part II
20.1 General Fund of the United States Government 20.2 The U.S. Standard General Ledger (USSGL) & Dual-Track Budgetary Accounting 20.3 Milestone 2: OMB Apportionment (Form SF 132)
21 Chapter 21: Federal Proprietary Accounting & Financial Reporting — Part I
21.1 Federal Proprietary Accounting & Fund Balance with Treasury (FBWT) 21.2 Non-FBWT Budgetary Authority (Offsets) 21.3 Stewardship PP&E: Heritage Assets and Stewardship Land (SFFAS 29) 21.4 Federal Credit Reform Act (FCRA): Direct Loans, Loan Guarantees & Subsidy Accounting
22 Chapter 22: Federal Proprietary Accounting & Financial Reporting — Part II
22.1 The Liquidating Account (Budgetary - Pre-1992) 22.2 Federal Financial Reporting: AFR, PAR, Basic Financial Statements & the U.S. Consolidated Report 22.3 The Statement of Changes in Net Position (SCNP)
23 Chapter 23: Cash, Investment & Debt Operations — Part I
23.1 Government Cash Management, Collections, Lockboxes & Banking Controls 23.2 Fees vs. Compensating Balances: Strategic Analysis 23.3 Public Investment Policies, Safety-Liquidity-Yield, Prudent Person Rule & Risk Disclosures 23.4 Authorized Public Investment Instruments: Comparative Analysis
24 Chapter 24: Cash, Investment & Debt Operations — Part II
24.1 GASB Statement No. 40: Deposit and Investment Risk Disclosures 24.2 Electronic Payments, EFT, P-Cards & Disbursement Controls 24.3 Public Benefit Disbursements: EBT and Reloadable Debit Cards
25 Chapter 25: Procurement, Asset Stewardship & Operational Systems — Part I
25.1 Public Procurement Standards, Fair Competition & Contract Administration 25.2 Contract Types and Cost Risk Allocation 25.3 Capital Asset Stewardship, Property Disposal, Inventory & OM&S Controls 25.4 Environmental Compliance and Electronic Data Sanitization
26 Chapter 26: Procurement, Asset Stewardship & Operational Systems — Part II
26.1 Financial Management Information Systems (FMIS), ERP, Cloud Hosting & Automation 26.2 Development Methodologies: Waterfall vs. Agile 26.3 Shared Services Delivery & Public Sector Project Management 26.4 The PMBOK Five Process Groups
27 Chapter 27: Financial, Managerial & Forensic Analysis — Part I
27.1 Mathematical and Financial Foundations of Time Value of Money (TVM) 27.2 Internal Rate of Return (IRR) 27.3 Financial Statement Trend and Comparative Analysis
28 Chapter 28: Financial, Managerial & Forensic Analysis — Part II
28.1 Earned Value Management (EVM) for Capital Project Oversight 28.2 Public Sector Data Sources and Reliability Verification 28.3 Common Red Flags and Public Sector Fraud Schemes
29 Chapter 29: Internal Control Frameworks & Enterprise Risk Management — Part I
29.1 COSO Internal Control Integrated Framework & the GAO Green Book 29.2 Component 2: Risk Assessment 29.3 Internal Control Deficiencies, Corrective Action Plans & Management Reporting
30 Chapter 30: Internal Control Frameworks & Enterprise Risk Management — Part II
30.1 FMFIA Reporting Sections 30.2 Enterprise Risk Management (ERM) & OMB Circular A-123 Implementation 30.3 Core Elements of a Federal Risk Profile
31 Chapter 31: Performance Measurement, Government Auditing & the Single Audit — Part I
31.1 Performance Measurement, SEA Reporting, GPRA & Public Accountability 31.2 Baselines, Targets, Benchmarking, and Stakeholder Engagement 31.3 Government Auditing Standards: The Yellow Book & Auditor Independence 31.4 Quality Management and External Peer Review
32 Chapter 32: Performance Measurement, Government Auditing & the Single Audit — Part II
32.1 Performance Audit Fieldwork, Reporting & Auditee Responsibilities 32.2 Cause ("Why It Happened") 32.3 The Single Audit Act & Uniform Guidance (2 CFR 200 Subpart F) 32.4 Internal Control over Compliance Testing
27.3 Financial Statement Trend and Comparative Analysis
Key Takeaways Explain This Topic AI
Vital governmental financial ratios include Days of Operating Cash for liquidity, Debt Service Coverage Ratio (DSCR) for revenue bond solvency, and the Own-Source Revenue ratio for fiscal independence.
Horizontal trend analysis and vertical common-size statements normalize multi-year governmental financial data to reveal structural budgetary deficits and shifting functional resource allocations.
Cost Performance Index (CPI) and Schedule Performance Index (SPI) provide early-warning project efficiency indicators utilized to project final costs through Estimate at Completion (EAC).
Last updated: September 2026
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. Percentage Change = ( Current Year Amount − Prior Year Amount Prior Year Amount ) × 100 % \text{Percentage Change} = \left( \frac{\text{Current Year Amount} - \text{Prior Year Amount}}{\text{Prior Year Amount}} \right) \times 100\% Percentage Change = ( Prior Year Amount Current Year Amount − Prior Year Amount ) × 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: Base-Year Index = ( Year t Amount Base Year Amount ) × 100 \text{Base-Year Index} = \left( \frac{\text{Year } t \text{ Amount}}{\text{Base Year Amount}} \right) \times 100 Base-Year Index = ( Base Year Amount Year t Amount ) × 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.
Analytical Method Mathematical Reference Base Primary Public Sector Objective Key Diagnostic Insight
Horizontal Analysis Prior fiscal year or historical base year Measures growth rates over time Identifies structural revenue/expenditure imbalances and trajectory shifts.
Vertical (Common-Size) Total assets or total revenues/expenses Measures internal structural distribution Evaluates functional spending priorities and revenue concentration risks.
Cross-Sectional Ratio Peer municipal benchmark or rating quartile Measures comparative financial health Assesses credit rating standing, borrowing capacity, and fiscal vulnerability.
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:
Current Ratio : Current Ratio = Current Assets Current Liabilities \text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}} Current Ratio = Current Liabilities Current Assets
Measures short-term coverage in proprietary funds or modified accrual balance sheets. A ratio above 1.5x to 2.0x generally indicates sound liquidity.
Quick Ratio (Acid-Test Ratio) : Quick Ratio = Cash and Cash Equivalents + Current Investments + Taxes/Accounts Receivable Current Liabilities \text{Quick Ratio} = \frac{\text{Cash and Cash Equivalents} + \text{Current Investments} + \text{Taxes/Accounts Receivable}}{\text{Current Liabilities}} Quick Ratio = Current Liabilities Cash and Cash Equivalents + Current Investments + Taxes/Accounts Receivable
A more conservative measure that strips out illiquid inventories and prepaid expenditures.
Days of Operating Cash (Days Cash on Hand) : Days Cash on Hand = Unrestricted Cash and Cash Equivalents × 365 Total Operating Expenditures − Depreciation Expense \text{Days Cash on Hand} = \frac{\text{Unrestricted Cash and Cash Equivalents} \times 365}{\text{Total Operating Expenditures} - \text{Depreciation Expense}} Days Cash on Hand = Total Operating Expenditures − Depreciation Expense Unrestricted Cash and Cash Equivalents × 365
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:
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: DSCR = Gross Operating Revenues − Operating Expenses (excluding Depreciation and Amortization) Annual Principal and Interest Debt Service \text{DSCR} = \frac{\text{Gross Operating Revenues} - \text{Operating Expenses (excluding Depreciation and Amortization)}}{\text{Annual Principal and Interest Debt Service}} DSCR = Annual Principal and Interest Debt Service Gross Operating Revenues − Operating Expenses (excluding Depreciation and Amortization)
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.
Debt to Assets Ratio : Debt to Assets = Total Liabilities Total Assets \text{Debt to Assets} = \frac{\text{Total Liabilities}}{\text{Total Assets}} Debt to Assets = Total Assets Total Liabilities
Evaluates financial leverage on the government-wide Statement of Net Position.
Debt per Capita : Debt per Capita = Net General Obligation Bonded Debt Total Resident Population \text{Debt per Capita} = \frac{\text{Net General Obligation Bonded Debt}}{\text{Total Resident Population}} Debt per Capita = Total Resident Population Net General Obligation Bonded Debt
Normalizes municipal tax-supported debt burden against demographic size. High debt per capita indicates potential taxpayer resistance to future millage rate increases.
Debt as a Percentage of Assessed Property Valuation : Debt to Assessed Valuation = ( Net General Obligation Debt Total Taxable Assessed Valuation ) × 100 % \text{Debt to Assessed Valuation} = \left( \frac{\text{Net General Obligation Debt}}{\text{Total Taxable Assessed Valuation}} \right) \times 100\% Debt to Assessed Valuation = ( Total Taxable Assessed Valuation Net General Obligation Debt ) × 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
Operating Margin Ratio : Operating Margin = Total Revenues − Total Expenditures Total Revenues \text{Operating Margin} = \frac{\text{Total Revenues} - \text{Total Expenditures}}{\text{Total Revenues}} Operating Margin = Total Revenues Total Revenues − Total Expenditures
Positive margins indicate operational surplus and replenishment of reserves; persistent negative margins reflect structural deficits.
Net Position Trend Ratio : Net Position Trend = ( Ending Total Net Position − Beginning Total Net Position Beginning Total Net Position ) × 100 % \text{Net Position Trend} = \left( \frac{\text{Ending Total Net Position} - \text{Beginning Total Net Position}}{\text{Beginning Total Net Position}} \right) \times 100\% Net Position Trend = ( Beginning Total Net Position Ending Total Net Position − Beginning Total Net Position ) × 100%
Measures whether a government became financially stronger or weaker over the fiscal year on an economic resources measurement focus.
Own-Source Revenue Ratio : Own-Source Revenue Ratio = Taxes, User Charges, Licenses, and Local Fees Total Revenues \text{Own-Source Revenue Ratio} = \frac{\text{Taxes, User Charges, Licenses, and Local Fees}}{\text{Total Revenues}} Own-Source Revenue Ratio = Total Revenues Taxes, User Charges, Licenses, and Local Fees
Gauges fiscal autonomy. Entities that rely heavily on intergovernmental grants (low own-source ratios) face heightened vulnerability to state or federal budget reductions.
Ratio Category Ratio Name Formula Standard Public Sector Benchmark / Interpretation
Liquidity Current Ratio Current Assets / Current Liabilities \text{Current Assets} / \text{Current Liabilities} Current Assets / Current Liabilities 1.5 x − 2.0 x 1.5\text{x} - 2.0\text{x} 1.5 x − 2.0 x ; ensures short-term bills can be paid.
Liquidity Days Cash on Hand ( Unrestricted Cash × 365 ) / Operating Expenses (\text{Unrestricted Cash} \times 365) / \text{Operating Expenses} ( Unrestricted Cash × 365 ) / Operating Expenses Minimum 60–90 days (GFOA); 180+ days for AAA ratings.
Solvency Debt Service Coverage (DSCR) Net Operating Revenues / Annual Debt Service \text{Net Operating Revenues} / \text{Annual Debt Service} Net Operating Revenues / Annual Debt Service ≥ 1.20 x − 1.35 x \ge 1.20\text{x} - 1.35\text{x} ≥ 1.20 x − 1.35 x legally required for revenue bonds.
Debt Burden Debt to Assessed Value ( Net GO Debt / Taxable Assessed Value ) × 100 (\text{Net GO Debt} / \text{Taxable Assessed Value}) \times 100 ( Net GO Debt / Taxable Assessed Value ) × 100 Typically capped by statutory debt limits at 5%–10%.
Debt Burden Debt per Capita Net GO Debt / Resident Population \text{Net GO Debt} / \text{Resident Population} Net GO Debt / Resident Population Benchmarked against national median municipal peer groups.
Independence Own-Source Revenue Ratio Locally Generated Revenues / Total Revenues \text{Locally Generated Revenues} / \text{Total Revenues} Locally Generated Revenues / Total Revenues Higher ratio reflects lower dependence on state/federal transfers.
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.