ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Title:
2021 Fiscal Plan Model
2
3
Prepared by:
Economic Research Group
4
5
Date:11/3/2021
6
7
Purpose:The purpose of this model is to demonstrate impacts of various revenue and spending options. These impacts are shown over a 10 year period.
8
9
10
Instructions:To interact with this model first enable macros, then use the drop down menu to select one of the two complexity settings, "detailed" or "simple." The two options reflect the same spending and revenue numbers, but the "detailed" model allows the user to edit with greater granularity. The displayed sheet will automatically switch to the selected model and allow revenue and spending options to be changed. Descriptions of the options can be found in the Revenue & Spending Description sheet. The user can review the effects of changes made on the Summary sheet. To reset the model to the default options return to this page and click the "Reset Button."
11
12
13
14
15
16
17
18
19
The tabs entitled either "Simple Model" or "Detailed Model" allows the user to enter fiscal inputs such as oil prices, new revenues, budget adjustments and other fiscal assumptions. The colorized header will change from Red in the case of an unsuccessful fiscal plan to Yellow (borderline) to Green (successful plan) as assumptions are changed. The basis of the color is whether the savings balance maintains a minimum of $1.0 billion, or minimum buffer for cash flow and emergency needs.

The tab entitled "Summary Table" provides a numeric summary of the fiscal outcomes entered on the previous tab including savings balances, Permanent Fund balances and the size of the PFD.

The Tab entitled "Summary Graph" provides a graphical display of the fiscal outputs and a numeric summary of the options that the user has selected to solve the state's fiscal imbalance.

The Tab entitled "Revenue & Spending Descriptions" contains a glossary of terms for each model option.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
Contact:For questions about this model please contact Brian Fechter at 907-269-1034 or Brian.Fechter@alaska.gov
39
40
41
Disclaimer:This model provides estimates based on current information available and is subject to change.
42
43
All numbers are for demonstrative purposes only and might not reflect actual changes in revenue or spending.
44
45
This model will be updated as new information becomes available.
46
The Department of Revenue is in the process of reviewing and updating the data on which this analysis is based. As a result, future analysis could have different results.
47
48
Numbers may not add exactly due to rounding.
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100