{"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":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,1,4,11],[6,1,6,11],[8,1,8,11],[14,1,14,11],[10,1,10,11],[14,15,14,23],[20,1,20,11],[22,1,22,11],[24,1,24,11],[26,1,26,11],[16,1,16,11],[18,1,18,11]]}
[]
[null,"How CBO projects discretionary budget authority and outlays"]
[null,"using the interactive waterfall model"]
[]
[null,"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 and 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."]
[]
[null,"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. In cost estimates for spending subject to appropriation, budget authority may be explicitly stated in legislation or estimated by CBO."]
[]
[null,"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)."]
[]
[null,"The inflation factors used in the model correspond to those in CBO’s Apri 2018 economic forecast. As specified by section 257 of the Balanced Budget and Deficit Control Act of 1985, the two inflators that CBO must use in projections are:"]
[null,null,"•","The employment cost index (ECI) for wages and salaries (called wages in the model), and"]
[null,null,"•","The chain-weighted gross domestic product (GDP) price index for all other types of budgetary resources (for nonwages)."]
[]
[null,"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, the effects of 10 years of inflation from the base year are shown."]
[]
[null,"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."]
[]
[null,"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. "]
[]
[null,"How quickly budget authority translates to outlays varies significantly by the type of spending. Analysts 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 and that unobligated budget authoity reverts to the Treasury and thus does not result in outlays. "]
[]
[null,"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."]
[]
[null,"Outlays from prior years’ budget authority are typically included in baseline projections but normally are not 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. "]
[]
[null,"The interactive model allows users to enter outlays—if any—that stem from budget authority provided in prior years."]
[]
[null,"CBO wants to hear about your experience using this interactive resource. Send your feedback to communications@cbo.gov."]

{"sheet":"Instructions","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[7,2,7,16],[8,2,8,16],[11,1,11,16]]}
[]
[null,"***IMPORTANT: The budget authority and outlays generated by this model are illustrative and do not constitute a CBO estimate***"]
[]
[null,"Instructions for using the interactive waterfall model"]
[null,"Make sure you have clicked “Enable Content” at the top of the worksheet to allow the model to run. "]
[]
[null,"1. Using the dropdown menu on line 2, select the type of account you would like to model."]
[null,null,"The user may select from accounts that primarily fund salaries and expenses, grants, construction, or general discretionary expenses, or may choose a custom option."]
[null,null,"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 used by CBO analysts for the various types of accounts."]
[null,null,"The custom option allows the user to input specific inflation weights and spendout rates. Spendout rates may not total more than 100 percent."]
[]
[null,"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."]
[null,null,"Enter budget authority in the spaces provided on line 19."]
[]
[null,"3. On line 21, if desired, enter outlays that stem from budget authority appropriated in prior years."]

{"sheet":"Interactive Model","index":2,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[16,15,16,17]]}
[]
[null,null,"Account Type"]
[null,null,"Inflation Rates",null,"Weights",2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
[]
[null,null,"Nonwages",null,0.3,0.02,2.1000000000000001E-2,2.3E-2,2.3E-2,2.3E-2,2.5000000000000001E-2,2.4E-2,2.4E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,null,"Wages",null,{"$f":"1-E5","v":0.7},4.3999999999999997E-2,4.3999999999999997E-2,4.5999999999999999E-2,4.5999999999999999E-2,4.5999999999999999E-2,4.7E-2,4.8000000000000001E-2,4.9000000000000002E-2,5.0999999999999997E-2,5.2999999999999999E-2]
[null,null,"Weighted Average",null,null,{"$f":"ROUND((F5 * E5) + (F6 * E6), 3)","v":3.6999999999999998E-2},{"$f":"ROUND((G5 * E5) + (G6 * E6), 3)","v":3.6999999999999998E-2},{"$f":"ROUND((H5 *E5) + (H6 * E6), 3)","v":3.9E-2},{"$f":"ROUND((I5*E5)+(I6*E6),3)","v":3.9E-2},{"$f":"ROUND((J5 * E5) + (J6 * E6), 3)","v":3.9E-2},{"$f":"ROUND((K5 * E5) + (K6 * E6), 3)","v":0.04},{"$f":"ROUND((L5 * E5) + (L6 * E6),3)","v":4.1000000000000002E-2},{"$f":"ROUND((M5 * E5) + (M6 * E6),3)","v":4.2000000000000003E-2},{"$f":"ROUND((N5 * E5) + (N6 * E6),3)","v":4.2999999999999997E-2},{"$f":"ROUND((O5 * E5) + (O6 * E6),3)","v":4.4999999999999998E-2}]
[null,null,"Cumulative Weighted Average",null,null,{"$f":"ROUND((F5 * E5) + (F6 * E6), 3)","v":3.6999999999999998E-2},{"$f":"ROUND(((G5+F5) * E5) + ((G6 +F6) * E6), 3)","v":7.3999999999999996E-2},{"$f":"ROUND(((H5+G5+F5) * E5) + ((H6 +G6+F6) * E6), 3)","v":0.113},{"$f":"ROUND(((I5+H5+G5+F5) * E5) + ((I6 +H6+G6+F6) * E6), 3)","v":0.152},{"$f":"ROUND(((J5+I5+H5+G5+F5) * E5) + ((J6 +I6+H6+G6+F6) * E6), 3)","v":0.191},{"$f":"ROUND(((K5+J5+I5+H5+G5+F5) * E5) + ((K6 +J6+I6+H6+G6+F6) * E6), 3)","v":0.23200000000000001},{"$f":"ROUND(((L5+K5+J5+I5+H5+G5+F5) * E5) + ((L6 +K6+J6+I6+H6+G6+F6) * E6), 3)","v":0.27200000000000002},{"$f":"ROUND(((M5+L5+K5+J5+I5+H5+G5+F5) * E5) + ((M6 +L6+K6+J6+I6+H6+G6+F6) * E6), 3)","v":0.314},{"$f":"ROUND(((N5+M5+L5+K5+J5+I5+H5+G5+F5) * E5) + ((N6 +M6+L6+K6+J6+I6+H6+G6+F6) * E6), 3)","v":0.35699999999999998},{"$f":"ROUND(((O5+N5+M5+L5+K5+J5+I5+H5+G5+F5) * E5) + ((O6 +N6+M6+L6+K6+J6+I6+H6+G6+F6) * E6), 3)","v":0.40200000000000002}]
[]
[]
[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 2018",0.1,0.9,0.08,0.02,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,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total, 2018-2028"]
[]
[null,null,"Budget Authority (BA)",null,1000,{"$f":"E19*VALUE(F8)+E19","v":1037},{"$f":"E19*G8+E19","v":1074},{"$f":"E19*H8+E19","v":1113},{"$f":"E19*I8+E19","v":1152},{"$f":"E19*J8+E19","v":1191},{"$f":"E19*K8+E19","v":1232},{"$f":"E19*L8+E19","v":1272},{"$f":"E19*M8+E19","v":1314},{"$f":"E19*N8+E19","v":1357},{"$f":"E19*O8+E19","v":1402},null,{"$f":"SUM(E19:O19)","v":13144}]
[null,null,"Budget Authority (BA)",null,50,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:O20)","v":50}]
[null,null,"Outlays from Pre-2018 BA"]
[]
[null,null,2018,null,{"$f":"$E$19*$E$13","v":900},{"$f":"$E$19*$F$13","v":80},{"$f":"$E$19*$G$13","v":20},{"$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,2019,null,null,{"$f":"$F$19*$E$13","v":933.30000000000007},{"$f":"$F$19*$F$13","v":82.960000000000008},{"$f":"$F$19*$G$13","v":20.740000000000002},{"$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,2020,null,null,null,{"$f":"$G$19*$E$13","v":966.6},{"$f":"$G$19*$F$13","v":85.92},{"$f":"$G$19*$G$13","v":21.48},{"$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,2021,null,null,null,null,{"$f":"$H$19*$E$13","v":1001.7},{"$f":"$H$19*$F$13","v":89.04},{"$f":"$H$19*$G$13","v":22.26},{"$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,2022,null,null,null,null,null,{"$f":"$I$19*$E$13","v":1036.8},{"$f":"$I$19*$F$13","v":92.16},{"$f":"$I$19*$G$13","v":23.04},{"$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,2023,null,null,null,null,null,null,{"$f":"$J$19*$E$13","v":1071.9000000000001},{"$f":"$J$19*$F$13","v":95.28},{"$f":"$J$19*$G$13","v":23.82},{"$f":"$J$19*$H$13","v":0},{"$f":"$J$19*$I$13","v":0},{"$f":"$J$19*$J$13","v":0}]
[null,null,2024,null,null,null,null,null,null,null,{"$f":"$K$19*$E$13","v":1108.8},{"$f":"$K$19*$F$13","v":98.56},{"$f":"$K$19*$G$13","v":24.64},{"$f":"$K$19*$H$13","v":0},{"$f":"$K$19*$I$13","v":0}]
[null,null,2025,null,null,null,null,null,null,null,null,{"$f":"$L$19*$E$13","v":1144.8},{"$f":"$L$19*$F$13","v":101.76},{"$f":"$L$19*$G$13","v":25.44},{"$f":"$L$19*$H$13","v":0}]
[null,null,2026,null,null,null,null,null,null,null,null,null,{"$f":"$M$19*$E$13","v":1182.6000000000001},{"$f":"$M$19*$F$13","v":105.12},{"$f":"$M$19*$G$13","v":26.28}]
[null,null,2027,null,null,null,null,null,null,null,null,null,null,{"$f":"$N$19*$E$13","v":1221.3},{"$f":"$N$19*$F$13","v":108.56}]
[null,null,2028,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19*$E$13","v":1261.8}]
[null,null,"Total Outlays",null,{"$f":"SUM(E21:E33)","v":900},{"$f":"SUM(F21:F33)","v":1013.3000000000001},{"$f":"SUM(G21:G33)","v":1069.56},1108.3600000000001,1147.32,1186.3200000000002,1227.1199999999999,1267.1799999999998,1309.0000000000002,1351.86,1396.6399999999999,null,{"$f":"SUM(E34:O34)","v":12976.66}]

{"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"]