Spreadsheet: 14985151-5f85-4062-a24a-8d05b2a09ec3
Sheet: DENR Fiscal Note Table

This worksheet calculates the costs and benefits for proposed rule changes. Enter values in the first table, using one line for each affected entity - federal government, state government, local governments, DOT, private citizens etc. Write the name of the entity in the Cost1, Cost2 etc boxes. Each entity should have a line in both the cost and benefits section.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               You may or may not choose to use an inflation factor. Usually we would use inflation if we are examining a long period of time or if we expect the prices in our model to increase at a rate faster (or lower) than the general economy.  If you choose to use inflation, make sure to multiply each value in the cost and benefit fields by the inflation rate in the corresponding column. For example the value for  cost1 in year 2015-16 should be multiplied by 0.08 (G5) The default inflation rate is 2 percent.  The second table takes the values from the previous one and adjusts them with a 7 percent discount rate. This is done to reflect peoples' time preference to have money today versus in the future.                                                                                                                                                                                                                                You may select how many years of analysis are sufficient to accurately represent the impacts of the rule change. Usually people consider 5-7 years or more if the rule has long term impacts or is significant. Label your final tables with a descriptive title such as "Net Cost and Benefits of Proposed Rule X by Affected Party" and center it above your analysis.                                                                                                                                                                                                                                                                                   This worksheet is not locked so you may make changes for your particular rule. If you have questions, please call [NAME] at [PHONE].
 | Fiscal Year | 2011-12 | 2012-13 | 2013-14 | 2014-15 | 2015-16 | 2016-17 | 2017-18 | 2018-19 | 2019-20 | 2020-21 | 2021-22 | 2022-23 | 2023-24 | 2024-25 | 2025-26 | 2026-27 | 2027-28 | 2028-29 | 2029-30 | 2030-31 | 2031-32
 | Year Number | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Inflation |  | 0.02
 | Costs
 | Cost1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Cost2
 | Cost3
 | Cost4
 | Cost5
 | Cost6
 | Cost7
 | Cost8
 | Total Costs
 | Benefits
 | Benefit1 |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | Benefit2
 | Benefit3
 | Benefit4
 | Benefit5
 | Benefit6
 | Benefit7
 | Benefit8
 | Total Benefits
 | Net Impact (benefits-costs)
 | Total Impact (benefits+costs)
 | Net Present Value
 | Fiscal Year | 2011-12 | 2012-13 | 2013-14 | 2014-15 | 2015-16 | 2016-17 | 2017-18 | 2018-19 | 2019-20 | 2020-21 | 2021-22 | 2022-23 | 2023-24 | 2024-25 | 2025-26 | 2026-27 | 2027-28 | 2028-29 | 2029-30 | 2030-31 | 2031-32
 | Year Number | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Discount Rate |  | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07
 | Costs
 | Cost1
 | Cost2
 | Cost3
 | Cost4
 | Cost5
 | Cost6
 | Cost7
 | Cost8
 | Total Costs
 | Benefits
 | Benefit1
 | Benefit2
 | Benefit3
 | Benefit4
 | Benefit5
 | Benefit6
 | Benefit7
 | Benefit8
 | Total Benefits
 | Net Present Value by Year
 | Net Present Value