Progressive Financial Model

• Total assets: Approximately $110 billion to $120 billion.
• Key asset categories: The vast majority of assets are Investments (fixed maturities and equities), followed by Premiums Receivable, Reinsurance Recoverables, and Deferred Acquisition Costs (DAC).
• Goodwill & intangibles as % of total assets: Very low (under 2%), as Progressive relies on organic growth rather than M&A.
• Working capital profile:
• Standard working capital metrics (DSO, DIO, DPO) do not apply to insurers.
• The company operates with massive negative working capital in a traditional sense, as it collects cash upfront (Unearned Premiums) and pays claims later (Loss Reserves). This generates the float.
• PP&E: Minimal. Consists of corporate headquarters, claims centres, and IT equipment.
• Right-of-use assets / operating leases: Immaterial relative to the investment portfolio.

• Capex as % of revenue: Less than 1%.
• Maintenance capex vs. growth capex: Almost entirely IT infrastructure, data centre maintenance, and capitalised software development for pricing algorithms.
• Major capex programmes underway or planned: Continuous investment in the Snapshot telematics programme and cloud infrastructure.
• Capitalised software / development costs if material: Present but small relative to the overall asset base.
• M&A pattern: Strictly an organic grower. The only notable historical acquisition was ARX Holding Corp (Property) to bundle home and auto.
• Typical acquisition multiple paid: Not applicable for current modelling.

• Total debt: Approximately $6 billion to $7 billion.
• Debt/EBITDA ratio: Insurers use Debt-to-Total-Capital. Progressive targets a ratio below 30% and currently operates around 16%.
• Credit rating: Highly rated (typically AA- or equivalent for operating subsidiaries).
• Key debt instruments: Senior notes and a $300 million revolving credit facility.
• Maturity profile: Well-laddered with no major maturities until 2027.
• Interest rate profile: Predominantly fixed-rate senior notes.
• Covenants: Standard financial covenants on the credit facility, which the company easily clears.
• Share repurchase programme: Active but opportunistic. The company repurchases shares to offset equity award dilution and return excess capital.
• Dividend policy: Progressive uses a unique variable dividend policy. The board declares an annual variable dividend based on excess capital generated (e.g. $13.50 per share in January 2026).

• Operating cash flow conversion: Extremely high. OCF consistently exceeds Net Income due to the growth in unearned premiums and loss reserves.
• Free cash flow margin: Not a standard metric for insurers. Analysts focus on Statutory Capital Generation and Comprehensive Income.
• Major non-cash items that bridge net income to OCF: Depreciation, amortisation of DAC, changes in loss reserves, and changes in unearned premiums.
• Working capital cash flow impact: Premium growth is a massive source of cash flow as the company collects cash before providing the insurance coverage.
• Capex intensity: Extremely low.
• Cash tax rate vs. GAAP effective tax rate: Generally aligned around 21%, though tax-advantaged investments (municipal bonds) can lower the effective rate.

1. Assumptions: Hardcoded inputs for PIF growth, rate increases, loss ratios, expense ratios, and investment yields.
2. Policies in Force (PIF): Roll-forward of policy counts for Agency Auto, Direct Auto, Special Lines, Property, and Commercial Lines.
3. Premiums: Calculation of Net Premiums Written (NPW) and Net Premiums Earned (NPE) based on PIF and average premiums.
4. Underwriting: Segment-level breakdown of Losses & LAE, Underwriting Expenses, and the resulting Combined Ratio.
5. Investment Portfolio: Schedule of fixed maturities and equities, calculating interest, dividends, and realised/unrealised gains.
6. Income Statement: Consolidated GAAP P&L down to Net Income and Comprehensive Income.
7. Balance Sheet: GAAP balance sheet highlighting Investments, DAC, Unearned Premiums, and Loss Reserves.
8. Cash Flow Statement: Standard 3-statement cash flow, heavily driven by reserve changes.
9. Statutory Capital & Dividends: Calculation of statutory surplus, premiums-to-surplus ratio, and the resulting variable dividend payout.
10. Valuation: Dividend Discount Model (DDM) and Excess Return on Equity model, which are standard for financial institutions.

1. "Ending PIF = Beginning PIF + New Policies Issued - Cancelled Policies"
2. "Net Premiums Written = Average PIF x Average Annual Premium per Policy"
3. "Net Premiums Earned = Net Premiums Written - Change in Unearned Premium Reserve"
4. "Losses and LAE = Net Premiums Earned x Loss Ratio (assumed at 65-70%)"
5. "Underwriting Expenses = Net Premiums Earned x Underwriting Expense Ratio (assumed at 20-22%)"
6. "Combined Ratio = Loss Ratio + Underwriting Expense Ratio"
7. "Underwriting Profit = Net Premiums Earned x (1 - Combined Ratio)"
8. "Investment Income = Average Investment Portfolio Balance x Portfolio Yield"
9. "Deferred Acquisition Costs (Asset) = Underwriting Expenses x (Unearned Premiums / Net Premiums Written)"
10. "Premiums-to-Surplus Ratio = Net Premiums Written / Statutory Surplus"
11. "Variable Dividend Pool = Comprehensive Income - Capital Required to Maintain Target Premiums-to-Surplus Ratio"

The Assumptions sheet drives the Policies in Force (PIF) schedule. The PIF schedule feeds the Premiums sheet to calculate NPW and NPE. NPE feeds the Underwriting sheet to calculate claims and expenses. The Underwriting sheet feeds the Income Statement (operating profit) and the Balance Sheet (Unearned Premiums and Loss Reserves). The Balance Sheet feeds the Investment Portfolio (investable assets), which calculates Investment Income and feeds back into the Income Statement. The Income Statement feeds the Statutory Capital & Dividends sheet, which determines the dividend payout that flows into the Cash Flow Statement and reduces Equity on the Balance Sheet. Circularity risk exists between the Investment Portfolio balance, Investment Income, Net Income, and Retained Earnings. This should be managed using an average balance calculation with a circuit breaker.

• Premiums and Revenues are entered and displayed as positive numbers.
• Losses, LAE, and Underwriting Expenses are entered as positive numbers in their supporting schedules but subtracted in the Income Statement.
• On the Cash Flow Statement, increases in assets are negative (uses of cash), and increases in liabilities are positive (sources of cash).
• Dividends paid and share repurchases are negative on the Cash Flow Statement.

• Applying the expense ratio to Net Premiums Written instead of Net Premiums Earned. Progressive calculates its combined ratio strictly on an earned basis.
• Mismodelling the variable dividend. Progressive does not pay a standard quarterly dividend; the model must calculate excess capital generated above the 3.0x premiums-to-surplus target to size the annual payout.
• Failing to account for catastrophe losses in the Property segment, which can push the segment combined ratio above 110% in severe weather years.
• Ignoring the float. The investment portfolio must grow in tandem with Unearned Premiums and Loss Reserves.
• Confusing GAAP equity with Statutory Surplus. Dividends are paid out of statutory capital, which excludes non-admitted assets and DAC.
• Overestimating investment yield. The portfolio duration is short (3.5 years), meaning it rolls over quickly and is highly sensitive to the short end of the yield curve.
• Double-counting comprehensive income. Unrealised gains on fixed maturities flow through Other Comprehensive Income (OCI), not Net Income, but they do impact book value and capital adequacy.
• Assuming linear PIF growth. Auto insurance is highly cyclical based on pricing; if the model assumes rate increases, PIF growth should naturally decelerate due to lower retention.

• "Combined ratio must be below 96.0% in the base case; flag if it exceeds management's stated target."
• "Debt-to-Total-Capital must remain below 30% per management guidance."
• "Premiums-to-Surplus ratio should hover between 2.8x and 3.2x; flag if the model implies the company is over-leveraged or under-utilising capital."
• "Total Assets = Total Liabilities + Shareholders' Equity in every period."
• "Operating Cash Flow must exceed Net Income due to the structural growth of the float."
• "Investment yield should align with the 3.5-year duration fixed-income portfolio (flag if yield exceeds 6%)."
• "Effective tax rate should be approximately 21%."

• Filings: SEC EDGAR for PGR 10-K and 10-Q filings. Progressive Investor Relations website for monthly earnings releases (Progressive is unique in reporting monthly results).
• Peers: The Allstate Corporation (ALL), Berkshire Hathaway / GEICO (BRK.B), The Travelers Companies (TRV).
• Industry Data: NAIC (National Association of Insurance Commissioners) for statutory data and industry combined ratio benchmarks.
• Consensus Estimates: FactSet or Bloomberg for forward combined ratio and PIF growth estimates.

• Progressive Corporation 2025 Annual Report to Shareholders and Form 10-K (investors.progressive.com)
• Progressive Q4 2025 Investor Relations Presentation and Earnings Call Transcripts
• Progressive Monthly Earnings Releases (December 2025 / January 2026)
• SEC EDGAR Database (sec.gov)