Data & Reports
P&C Rate Filing
Health Insurance Rate Filings
California Rate Filing Spreadsheet
This spreadsheet is available in Excel spreadsheet format. Insurance Companies should use the Excel format when submitting rate filings.
California Rate Filing Spreadsheet, v. 1Company Name:Company ID number for this filing:SERFF ID number for this filing:
Text of form cells:
Column A: Policy Form Number.
Column B: Product Name.
Column C: Open or Closed?
Column D: Enrollment
Column E: Insured months in each policy form
Column F: Experience period on which rates are based
Column G: Period for which rates are to be effective
Column H: Total premium earned during the experience period on which the rates are based
Column I: Total dollar amount of claims incurred during the experience period on which the rates are based
Column J: Average rate increase (weighted average)
Column K: Comments
End of text of form cells.