{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["SBE Budget Template 2026"],"not_rendered":{"images":1,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"SBE Budget Template 2026","index":0,"n_rows":70,"n_cols":6,"rows_kept":70}
["State-Based Exchange Budget\nFY 2025-2026\nCCIIO/SMIPG\n\nThis document is the 2026 SBE Budget Template. It contains five sections, A through E. Table A begins at cell B 6. Table B begins at cell B 15. Table C begins at cell B 20. Table D begins at B 35, and Table E starts at B 61. Users need to fill in data from each table, and totals automatically populate."]
[]
["Users need to fill in data for each table, and totals automatically populate on rows 13, 17, 33, 36, 41, 49, 54, 59, and 66."]
[]
[]
["Section A is the General Information section. It includes rows 6-13, beginning with cell B6 and ending with cell D13.","A. General Information","Details","Notes (if needed)"]
[null,"State","Select Your State"]
["Cell C8 is a required field.","State Budget Year (indicate if Calendar or Fiscal)"]
["Cell C9 is a required field.\nFiscal Budget Year example: Oct. 1-Sept. 30 ","If State Budget Year is Fiscal, indicate the date range"]
["Cell C10 is a required field.\nTotal Full Time Equivalents engaged in the Individual Marketplace activities.","Total Marketplace FTE"]
["Cell D11 is a required field.","Does the state require issuers to pay a carrier assessment (user fee)? If yes, is it a broad or market wide assessment?"]
["Cell C12 is a required field.","Carrier Assessment (User fees) This is carrier assessment for the individual Marketplace and should not include outside of Marketplace values. If a flat dollar amount, please estimate in the notes how it might translate to  a percentage of premiums"]
[null,"General Notes/Comments (if needed)"]
[]
["Section B is the Marketplace Effectuated Enrollment section and includes rows 15-17, beginning with cell B15 and ending with cell E17.\n","B. Marketplace Effectuated Enrollment","2025 Actual","2026 Projected","Notes (if needed)"]
["Cells C16 and D16 are required fields.","Total QHP Enrollment for Plan Year"]
["Member Months are the count of accumulated members over the 12 month period for Individual Marketplace enrollment. This row is auto-calculated and no entry is required.","Member Months",{"$f":"C16*12","v":{"v":0,"d":"0 "}},{"$f":"D16*12","v":{"v":0,"d":"0 "}}]
[]
[]
["Section C is Revenue and includes rows 20-33, beginning with cell B20 and ending with cell F33.","C. Revenue","Definition/Details","2025 Actual $","2026 Projected $","Notes (if needed/as requested)"]
["Cells D21 and E21 are required fields.","Total Marketplace Carrier Assessment Collected","Indicate sources in the Notes column."]
["Cells D22 and E22 are required fields.","Revenue or Reimbursement from Medicaid/CHIP","Include Federal and state together."]
["If there are no carrier assessments collected or other state funding sources, then a note is required describing how operations are funded.","Other State Revenue Sources (list sources below)"]
{"$rows_empty":9}
["Row 33 auto-calculates the totals for Section C (Revenue) and no entry is required.","Total $ Revenue",null,{"$f":"SUM(D21:D32)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E21:E32)","v":{"v":0,"d":"$0"}}]
[]
["Section D is Marketplace Expenditures and includes rows 35-59, beginning with cell B35 and ending with cell F59. This section is broken down into four sub-sections: General, External Marketing & Outreach, Call Center, and IT Platform.","D. Marketplace Expenditures (total revenue and expenditures should balance out)","Definition/Details","2025 Actual $","2026 Projected $","Notes (if needed/as requested)"]
["Row 36 auto-calculates the totals for the General Totals sub-section and no entry is required.","General Totals",null,{"$f":"SUM(D37:D40)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E37:E40)","v":{"v":0,"d":"$0"}}]
["Cells D37 and E37 are required fields.","Personnel and Fringe","Officer and director salaries, temporary help, etc. "]
["Cells D38 and E38 are required fields.","Indirect Costs","Travel, supplies, etc. "]
["Cells D39 and E39 are required fields.","Facility and Other Non-IT Administrative","Rent, utilities, repairs, printing, etc."]
["Cells D40 and E40 are required fields.","Other (list items in Notes column)","Vendor costs should be built into other lines items."]
["Row 41 auto-calculates the totals for the External Marketing & Outreach Totals sub-section and no entry is required.","External Marketing & Outreach Totals",null,{"$f":"SUM(D42:D47)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E42:E47)","v":{"v":0,"d":"$0"}}]
["Cells D42 and E42 are required fields.","Navigators/IPAs","Grants or fees."]
["Cells D43 and E43 are required fields.","Direct Marketing & Outreach to Consumers","Consumer-facing education, training, outreach activities, and materials."]
["Cells D44 and E44 are required fields.","Education & Outreach to Agents/Brokers and Issuers","Agent/broker and issuer-facing education, training, outreach activities, and materials ."]
["Cells D45 and E45 are required fields.","Paid Media/Advertising","Paid media, TV, Radio, etc."]
["Cells D46 and E46 are required fields.\nExample of non-paid media include development of outreach materials, graphic design, marketing content on websites, and campaigns.","Non-Paid Media/Advertising","Efforts dedicated to engaging consumers, alliances, etc., social media."]
["Cells D47 and E47 are required fields.","Other (list items in Notes column)","Training support materials, communications, research, website, event management."]
["Cells D48 and E48 are required fields.\nThis should be entered as a number between 1 and 100.","% of Total External Marketing & Outreach Allocated to Contractors","Contractor allocation."]
["Row 49 auto-calculates the totals for the Call Center Totals sub-section and no entry is required.\nIf call center totals are $0, then please provide a note detailing why.","Call Center Totals",null,{"$f":"SUM(D50:D52)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E50:E52)","v":{"v":0,"d":"$0"}}]
["Cells D50 and E50 are required fields.\nInclude fixed and variable cost in the the Maintenance and Operations total.","Maintenance and Operations ","Labor, back office labor, technology, operations, etc."]
["Cells D51 and E51 are required fields.","DDI","Efforts associated with development and enhancements."]
["Cells D52 and E52 are required fields.","Other (list items in Notes column)","Other."]
["Cells D53 and E53 are required fields.\nThis should be entered as a number between 1 and 100.","% of Total Call Center Allocated to Contractors","Contractor allocation."]
["Row 54 auto-calculates the totals for the Call Center Totals sub-section and no entry is required.\nIf IT platform totals are $0, then please provide a note detailing why.","IT Platform Totals",null,{"$f":"SUM(D55:D57)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E55:E57)","v":{"v":0,"d":"$0"}}]
["Cells D55 and E55 are required fields.\nInclude fixed and variable cost in the the Maintenance and Operations total.","Maintenance and Operations ","Labor, back office labor, technology, operations, etc."]
["Cells D56 and E56 are required fields.","DDI","Efforts associated with development and enhancements."]
["Cells D57 and E57 are required fields.","Other (list items in Notes column)","Other."]
["Cells D58 and E58 are required fields.\nThis should be entered as a number between 1 and 100.","% of Total IT Platform Efforts Allocated to Contractors","Contractor allocation."]
["Row 59 auto-calculates the totals for Section D (Marketplace Expenditures) and no entry is required.","Total $ Expenditures",null,{"$f":"SUM(D36,D41,D49,D54)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E36,E41,E49,E54)","v":{"v":0,"d":"$0"}}]
[]
["Section E is Net Gain/(Loss) and includes rows 61-66, beginning with cell B61 and endding with F66.","E. Net Gain/(Loss)","Definition/Details","2025 Actual","2026 Projected","Notes (if needed)"]
[null,"Legislative Authority to have a reserve (Select Yes/No from drop-down choices)","N/A"]
["Cells D63 and E63 are required fields.","Total Reserve ","N/A"]
["Cells D64 and E64 are required fields.\nIf the Exchange has a reserve limit, provide a note detailing what the minimum and maximum reserve amount or months are and the total reserve the Exchange is allowed to maintain.","Number of Months of Reserve","Number of Months currently available for reserve."]
["Cells D65 and E65 are required fields.","Number of Months of Allowable Reserve","Number of Months allowed to have reserve available for."]
["Row 66 calculates totals for Section E (Net Gain/(Loss)) and no entry is required. If the Exchange has a net loss with not enough Total Reserve to cover the loss, then a note detailing how the loss will be covered is required in cell F66.","Total $ Net Gain/(Loss) ","Indicate in Notes if reserves/other funding source covers any loss.",{"$f":"D33-D59","v":{"v":0,"d":"$0"}},{"$f":"E33-E59","v":{"v":0,"d":"$0"}}]
[]
[null,"INFORMATION NOT RELEASABLE TO THE PUBLIC UNLESS AUTHORIZED BY LAW: This information has not been publicly disclosed and may be privileged and confidential. It is for internal government use only and must not be disseminated, distributed, or copied to persons not authorized to receive the information. Unauthorized disclosure may result in prosecution to the full extent of the law.\nPRA Disclosure Statement: According to the Paperwork Reduction Act of 1995, no persons are required to respond to a collection of information unless it displays a valid OMB control number.  The valid OMB control number for this information collection is 0938-1119 (05/31/2025).  This is mandatory information collection.  The time required to complete this information collection is estimated to average 14 hours per response, including the time to review instructions, search existing data resources, gather the data needed, and complete and review the information collection.  If you have comments concerning the accuracy of the time estimate(s) or suggestions for improving this form, please write to: CMS, 7500 Security Boulevard, Attn: PRA Reports Clearance Officer, Mail Stop C4-26-05, Baltimore, Maryland 21244-1850. \n****CMS Disclosure****\nPlease do not send applications, claims, payments, medical records or any documents containing sensitive information to the PRA Reports Clearance Office.  Please note that any correspondence not pertaining to the information collection burden approved under the associated OMB control number listed on this form will not be reviewed, forwarded, or retained. If you have questions or concerns regarding where to submit your documents, please contact Tiffany Animashaun."]
[]
[null,"Note: Information Collection is estimated at 14hrs but may be less with recent streamlining and changes."]