{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["About the Model","Instructions","Interactive Model","SpendoutRates"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"About the Model","index":0,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[16,14,16,22],[22,0,22,10],[24,0,24,10],[26,0,26,10],[28,0,28,10],[18,0,18,10],[20,0,20,10],[6,0,6,10],[8,0,8,10],[10,0,10,10],[16,0,16,10],[12,0,12,10]]}
["This workbook supplements CBO's May 2022 report The Budget and Economic Outlook: 2022 to 2032."]
["www.cbo.gov/publication/57950"]
[]
[]
["CBO's Waterfall Model for Projecting Discretionary Spending, August 2022"]
[]
["This interactive waterfall model is a simplified version of a model used by CBO analysts to develop the agency's baseline projections of discretionary spending, as well as cost estimates for legislation that authorizes discretionary spending. It is called a \"waterfall\" model because it allows the user to see how projections of outlays flow from each year's estimated budget authority. This model is designed to illustrate the methodology CBO uses to project discretionary spending. The budget authority and outlay data generated by the model do not constitute a CBO estimate."]
[]
["Budget authority is provided by law to allow an agency to incur financial obligations that will result in future outlays (or cash disbursements). In CBO’s baseline projections, discretionary budget authority over the baseline projection period, typically 10 years, generally is estimated by adjusting the appropriation provided for the current year to account for inflation projected for future years. By contrast, CBO's cost estimates of spending subject to appropriation are based on amounts explicitly stated in legislation or estimated by CBO."]
[]
["The interactive model allows a user to choose whether to enter budget authority for each year or only for the current year of the projection period (in which case the model extrapolates future years’ budget authority by adjusting the current-year amount for inflation)."]
[]
["The inflation factors used in the model correspond to those in CBO’s May 2022 economic forecast. As specified by section 257 of the Balanced Budget and Deficit Control Act of 1985, CBO must use two main inflators in its projections of discretionary funding: "]
["•  The employment cost index (ECI) for wages and salaries (called wages in the model), and"]
["•  The chain-weighted gross domestic product (GDP) price index for all other types of budgetary resources (for nonwages)."]
[]
["Inflation weights are used to adjust the application of inflation factors according to the share of budget authority that is allocated to federal wage and nonwage amounts for a given account. The amounts are cumulative and, by the end of the projection period, show the effects of 10 years of inflation from the base year."]
[]
["The interactive model allows users to choose from illustrative inflation weights, which adjust the proportion of budget authority to be inflated using the ECI or the GDP price index according to broad trends for similar budget activities. Alternatively, users could enter their own weights."]
[]
["Outlays consist of cash disbursements to pay federal obligations. For most discretionary spending, projected outlays are calculated by applying spendout rates—the rates at which the funds are actually disbursed—to budget authority. "]
[]
["How quickly budget authority translates to outlays varies significantly by the type of spending. Analysts usually construct individual rates for each account on the basis of historical patterns. For example, outlays for an agency's salaries and administrative expenses generally occur fairly quickly; most of the budget authority is disbursed in the year for which funds are appropriated. Outlays for construction of infrastructure or weapon systems, by contrast, can occur over several years. In many cases, some portion of budget authority may be unobligated at the end of a period in which agencies may legally obligate funds; that unobligated budget authority typically reverts to the Treasury and thus does not result in outlays. "]
[]
["The interactive model allows users to choose from illustrative spendout rates that are not specific to a particular account but instead indicate broad trends among similar functions. Alternatively, users may enter their own rates. In no case can more than 100 percent of the budget authority be spent."]
[]
["Outlays from prior years’ budget authority are typically included in baseline projections but are not normally included in cost estimates, which focus on the potential effects of new authorizations. Analysts calculate outlays from the unspent balances of prior years’ budget authority, if applicable, using detailed information from the Treasury, including amounts of unspent budget authority in each account at the beginning of a fiscal year and the extent to which those amounts are obligated. "]
[]
["The interactive model allows users to enter any outlays that stem from budget authority provided in prior years."]
[]
["CBO wants to hear about your experience using this interactive resource. Send your feedback to communications@cbo.gov."]

{"sheet":"Instructions","index":1,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,0,15,15],[14,0,14,15],[10,0,10,15],[11,0,11,15],[12,0,12,15]]}
["This workbook supplements CBO's May 2022 report The Budget and Economic Outlook: 2022 to 2032."]
["www.cbo.gov/publication/57950"]
[]
[]
["***IMPORTANT: The budget authority and outlays generated by this model are illustrative and do not constitute a CBO estimate.***"]
[]
["Instructions for Using the Interactive Waterfall Model"]
["Make sure you have clicked “Enable Content” at the top of the worksheet to allow the model to run. "]
[]
["1. Using the dropdown menu on line 2, select the type of account you would like to model."]
["You may select from accounts that primarily fund salaries and expenses, grants, construction, or general discretionary expenses or choose a custom option."]
["For any of the first four options, the model will prefill the entries with illustrative inflation weights and spendout rates that are broadly representative of the weights and rates CBO analysts use for the various types of accounts."]
["The custom option allows you to specify the weight of the nonwage inflator and spendout rates. Spendout rates may not total more than 100 percent."]
[]
["2. Using the dropdown menu on line 15, select whether you would like the model to inflate the budget authority from the current year's amount to produce the budget authority for subsequent years or if you would like to specify the budget authority for each year."]
["When using the model to inflate budget authority from the current year's amount, enter budget authority for 2022 in the space provided on line 19. When\nspecifying budget authority for each year of the period, enter those amounts on line 20."]
[]
["3. On line 21, if desired, enter outlays that stem from budget authority appropriated in prior years."]

{"sheet":"Interactive Model","index":2,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[16,15,16,17],[35,2,35,13]]}
[]
[null,null,"Account Type"]
[null,null,"Inflation Rates",null,"Weights",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032]
[]
[null,null,"Nonwages",null,0.45,1.0310983411287971,1.0536413522201422,1.0753039177699915,1.0974535943222097,1.1202414774309619,1.1436438698042417,1.1676425427558892,1.1922510665300452,1.2173256370470087,1.242797795463203]
[null,null,"Wages",null,{"$f":"1 - E5","v":0.55000000000000004},1.0612631962754224,1.1092683756957449,1.1560972494441164,1.2014139494278266,1.2472983509843742,1.2949351696051694,1.3430886288221071,1.393032722573486,1.4448340373951036,1.4971081328680587]
[null,null,"Weighted Average",null,null,{"$f":"(F5 * E5) + (F6 * E6)","v":1.047689011459441},{"$f":"(G5 * E5) + (G6 * E6)","v":1.0842362151317237},{"$f":"(H5 * E5) + (H6 * E6)","v":1.1197402501907603},{"$f":"(I5 * E5) + (I6 * E6)","v":1.1546317896302991},{"$f":"(J5 * E5) + (J6 * E6)","v":1.1901227578853388},{"$f":"(K5 * E5) + (K6 * E6)","v":1.226854084694752},{"$f":"(L5 * E5) + (L6 * E6)","v":1.264137890092309},{"$f":"(M5 * E5) + (M6 * E6)","v":1.3026809773539376},{"$f":"(N5 * E5) + (N6 * E6)","v":1.3424552572384609},{"$f":"(O5 * E5) + (O6 * E6)","v":1.3826684810358736}]
[]
[]
[]
[null,null,"Spendout Rates"]
[null,null,"Year",null,1,2,3,4,5,6,7,8,9,10,11,null,"Unspent","Total"]
[null,null,"Current Year 2022",0.1,0.8,0.15,0.05,0,0,0,0,0,0,0,0,null,{"$f":"1 - SUM(E13:O13)","v":0},{"$f":"SUM(E13:O13) + Q13","v":1}]
[]
[null,null,"Budget Authority and Outlay Waterfall"]
[]
[null,null,null,null,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,"Total, 2022-2032"]
[]
[null,null,"Budget Authority (BA)",null,1000,{"$f":"E19*F7","v":1047.689011459441},{"$f":"E19*G7","v":1084.2362151317238},{"$f":"E19*H7","v":1119.7402501907602},{"$f":"E19*I7","v":1154.6317896302992},{"$f":"E19*J7","v":1190.1227578853388},{"$f":"E19*K7","v":1226.8540846947519},{"$f":"E19*L7","v":1264.1378900923091},{"$f":"E19*M7","v":1302.6809773539376},{"$f":"E19*N7","v":1342.4552572384609},{"$f":"E19*O7","v":1382.6684810358736},null,{"$f":"SUM(E19:O19)","v":13115.216714712895}]
[null,null,"Budget Authority (BA)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:O20)","v":0}]
[null,null,"Outlays From Pre-2022 BA"]
[]
[null,null,2021,null,{"$f":"$E$19*$E$13","v":800},{"$f":"$E$19*$F$13","v":150},{"$f":"$E$19*$G$13","v":50},{"$f":"$E$19*$H$13","v":0},{"$f":"$E$19*$I$13","v":0},{"$f":"$E$19*$J$13","v":0},{"$f":"$E$19*$K$13","v":0},{"$f":"$E$19*$L$13","v":0},{"$f":"$E$19*$M$13","v":0},{"$f":"$E$19*$N$13","v":0},{"$f":"$E$19*$O$13","v":0}]
[null,null,2022,null,null,{"$f":"$F$19*$E$13","v":838.15120916755279},{"$f":"$F$19*$F$13","v":157.15335171891613},{"$f":"$F$19*$G$13","v":52.38445057297205},{"$f":"$F$19*$H$13","v":0},{"$f":"$F$19*$I$13","v":0},{"$f":"$F$19*$J$13","v":0},{"$f":"$F$19*$K$13","v":0},{"$f":"$F$19*$L$13","v":0},{"$f":"$F$19*$M$13","v":0},{"$f":"$F$19*$N$13","v":0}]
[null,null,2023,null,null,null,{"$f":"$G$19*$E$13","v":867.38897210537914},{"$f":"$G$19*$F$13","v":162.63543226975858},{"$f":"$G$19*$G$13","v":54.211810756586196},{"$f":"$G$19*$H$13","v":0},{"$f":"$G$19*$I$13","v":0},{"$f":"$G$19*$J$13","v":0},{"$f":"$G$19*$K$13","v":0},{"$f":"$G$19*$L$13","v":0},{"$f":"$G$19*$M$13","v":0}]
[null,null,2024,null,null,null,null,{"$f":"$H$19*$E$13","v":895.79220015260819},{"$f":"$H$19*$F$13","v":167.96103752861401},{"$f":"$H$19*$G$13","v":55.987012509538012},{"$f":"$H$19*$H$13","v":0},{"$f":"$H$19*$I$13","v":0},{"$f":"$H$19*$J$13","v":0},{"$f":"$H$19*$K$13","v":0},{"$f":"$H$19*$L$13","v":0}]
[null,null,2025,null,null,null,null,null,{"$f":"$I$19*$E$13","v":923.70543170423934},{"$f":"$I$19*$F$13","v":173.19476844454488},{"$f":"$I$19*$G$13","v":57.731589481514959},{"$f":"$I$19*$H$13","v":0},{"$f":"$I$19*$I$13","v":0},{"$f":"$I$19*$J$13","v":0},{"$f":"$I$19*$K$13","v":0}]
[null,null,2026,null,null,null,null,null,null,{"$f":"$J$19*$E$13","v":952.09820630827107},{"$f":"$J$19*$F$13","v":178.51841368280083},{"$f":"$J$19*$G$13","v":59.506137894266942},{"$f":"$J$19*$H$13","v":0},{"$f":"$J$19*$I$13","v":0},{"$f":"$J$19*$J$13","v":0}]
[null,null,2027,null,null,null,null,null,null,null,{"$f":"$K$19*$E$13","v":981.48326775580153},{"$f":"$K$19*$F$13","v":184.02811270421279},{"$f":"$K$19*$G$13","v":61.342704234737596},{"$f":"$K$19*$H$13","v":0},{"$f":"$K$19*$I$13","v":0}]
[null,null,2028,null,null,null,null,null,null,null,null,{"$f":"$L$19*$E$13","v":1011.3103120738474},{"$f":"$L$19*$F$13","v":189.62068351384636},{"$f":"$L$19*$G$13","v":63.206894504615462},{"$f":"$L$19*$H$13","v":0}]
[null,null,2029,null,null,null,null,null,null,null,null,null,{"$f":"$M$19*$E$13","v":1042.14478188315},{"$f":"$M$19*$F$13","v":195.40214660309064},{"$f":"$M$19*$G$13","v":65.134048867696876}]
[null,null,2030,null,null,null,null,null,null,null,null,null,null,{"$f":"$N$19*$E$13","v":1073.9642057907688},{"$f":"$N$19*$F$13","v":201.36828858576914}]
[null,null,2031,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19*$E$13","v":1106.1347848286989}]
[null,null,"Total Outlays",null,{"$f":"SUM(E21:E33)","v":800},{"$f":"SUM(F21:F33)","v":988.15120916755279},{"$f":"SUM(G21:G33)","v":1074.5423238242952},1110.8120829953389,1145.8782799894395,1181.2799872623539,1217.7332709201173,1254.8445626723271,1293.108169631734,1332.573246898475,1372.6371222821649,null,{"$f":"SUM(E34:O34)","v":12771.560255643799}]
[]
[null,null,"The inflation factors used in this model underlie CBO's May 2022 baseline budget projections."]

{"sheet":"SpendoutRates","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["NAME","SpendoutTypes"]
["Salaries and Expenses"]
["Grants"]
["Construction"]
["General Discretionary"]
["Custom (user enters inflation weights and spendout rates)"]
[]
["NAME","BATypes"]
["Enter BA for Current Year (model fills in subsequent years)"]
["Enter BA for All Years"]