Esyll Chapter 22: Aggregate Expenditure Model Use the quarterly data downloaded from excel during 1973 2023 to fill the number boxes and spaces in the figure and sentences below: Hints: AE AE=Y AE = + Y Y A B If actual GDP is equal 1o A, iis greater than and business inventories will If actual GDP is equal 1o B, is less than and business inventories will The autonomous expenditure multiplier estimated in this case is egual to If the government increases expenditure by 3500 million, eguilibrium GDP will increase by Three main assumption upon which this model relies are that thisis a run model where prices are and taxes, transfer payments and net factor income from abroad equal To estimate the economy's private consumption function, please see video CF_FwD_7. Total autonomous expenditure A is equal to the sum of autonomous private consumption, planned investment, government expenditure and net exports. Equilibrium GDF [Y*) iswhere AE=Yand AE=C+ 1"+ G+ NX. Quarter C G NX Y Q1:1973 825.033 4287.405 299.571 -1.400 1377.490 Q2:1973 840.533 4225.707 302.709 2.454 1413.887 Q3:1973 858.867 4109.954 304.189 6.437 1433.838 Q4:1973 873.900 4005.714 312.593 8.952 1476.289 Q1:1974 891.867 3896.533 324.586 6.394 1491.209 Q2:1974 920.400 3793.129 334.957 -2.714 1530.056 Q3:1974 949.267 3622.037 346.710 -6.972 1560.026 Q4:1974 959.067 3361.970 359.228 0.033 1599.679 Q1:1975 985.200 3162.284 370.138 16.481 1616.116 Q2:1975 1013.567 3045.131 373.408 21.582 1651.853 Q3:1975 1047.200 3101.051 385.394 12.043 1709.820 Q4:1975 1076.267 3125.419 395.571 13.801 1761.831 Q1:1976 1109.900 3204.648 401.291 4.650 1820.487 Q2:1976 1129.533 3173.358 400.985 -0.496 1852.332 Q3:1976 1158.800 3153.338 403.517 -4.073 1886.558 Q4:1976 1192.433 3198.483 410.818 -6.603 1934.273 Q1:1977 1228.200 3248.507 421.202 -21.079 1988.648 Q2:1977 1256.000 3347.935 431.362 -21.136 2055.909 Q3:1977 1286.900 3331.267 438.014 -20.579 2118.473 Q4:1977 1324.800 3296.159 446.749 -29.582 2164.270 Q1:1978 1354.033 3264.887 452.589 -38.681 2202.760 Q2:1978 1411.400 3442.449 472.288 -22.624 2331.633 Q3:1978 1442.233 3477.181 484.229 -23.760 2395.053 Q4:1978 1481.333 3483.894 496.241 -16.400 2476.94926 Q1:1979 1517.133 3409.675 501.818 -18. 159 2526.610 27 Q2:1979 1557.633 3338.053 516.508 -22.189 2591.247 28 Q3:1979 1611.867 3342.161 533. 106 -23.029 2667.565 29 Q4:1979 1655.067 3257.080 547.775 -26.802 2723.883 30 Q1:1980 1702.300 3177.026 568.781 -35.803 2789.842 31 Q2:1980 1704.700 2877.476 588.547 -15.211 2797.352 32 Q3:1980 1763.800 2826.436 592. 169 5.471 2856.483 33 Q4:1980 1831.867 2841.274 608.893 -6.682 2985.557 34 Q1:1981 1885.700 2806.389 633.350 -14.259 3124.206 35 Q2:1981 1917.567 2752.500 648.673 -13.508 3162.532 36 Q3:1981 1958.067 2693.227 657.774 -7.561 3260.609 37 Q4:1981 1974.433 2654.621 677.727 -14.750 3280.818 38 Q1:1982 2014. 133 2548.631 688.104 -16.276 3274.302 39 Q2:1982 2039.633 2460.450 703.093 -4.386 3331.972 40 Q3:1982 2085.633 2380.528 717.344 -29.647 3366.322 41 Q4:1982 2145.567 2372.187 737.351 -29.587 3402.561 42 Q1:1983 2184.600 2398.434 747.852 -24.548 3473.413 43 Q2:1983 2249.433 2456.187 761.061 -45.434 3578.848 44 Q3:1983 2319.900 2556.463 782.216 -65.200 3689. 179 45 Q4:1983 2372.500 2659.079 775.099 -71.385 3794.706 46 Q1:1984 2418.167 2711.491 794.021 -95.004 3908.054 47 Q2:1984 2475.867 2786.564 819.132 -104.301 4009.601 48 Q3:1984 2513.533 2814.869 835.720 -103.847 4084.250 49 Q4:1984 2561.767 2866.487 862.769 -107.756 4148.551 50 Q1:1985 2636.033 2865.585 875.592 -91.298 4230.16851 Q2:1985 2681.767 2906.309 900.527 -114.445 4294.887 52 Q3:1985 2754. 167 2898.580 927.363 -116.895 4386.773 53 Q4:1985 2779.400 2926.444 938.584 -133.434 4444.094 54 Q1:1986 2823.633 2926.282 946.803 -126.014 4507.894 55 Q2:1986 2851.467 2930.264 967.519 -128.872 4545.340 56 Q3:1986 2917.200 2937.283 993.597 -138.961 4607.669 57 Q4:1986 2952.800 2931.700 996.385 -133.629 4657.627 58 Q1:1987 2983.500 2883.622 1008.681 -141.234 4722.156 59 Q2:1987 3053.333 2910.649 1025.219 -146.977 4806. 160 60 Q3:1987 3117.333 2936.205 1036.195 -145.464 4884.555 61 Q4:1987 3150.933 2914.314 1056.024 -145.405 5007.994 62 Q1:1988 3231.867 2871.332 1056.893 -123.987 5073.372 63 Q2:1988 3291.700 2894.210 1070.421 -106.627 5190.036 64 Q3:1988 3361.900 2866.918 1078.190 -99.263 5282.835 65 Q4:1988 3434.533 2876.399 1109.916 -107.694 5399.509 66 Q1:1989 3490. 167 2864.204 1116.559 -100.965 5511.253 67 Q2:1989 3553.800 2840.395 1145.809 -88. 160 5612.463 68 Q3:1989 3609.400 2871.544 1164.580 -75.075 5695.365 69 Q4:1989 3653.700 2822.552 1180.500 -82.765 5747.237 70 Q1:1990 3737.933 2838.274 1212.450 -88.536 5872.701 71 Q2:1990 3783.433 2762.219 1230.721 -68.833 5960.028 72 Q3:1990 3846.700 2723.518 1242.584 -74.953 6015. 116 73 Q4:1990 3867.933 2653.302 1268.467 -79.096 6004.733 74 Q1:1991 3873.567 2561.441 1284.187 -47.140 6035. 178 75 Q2:1991 3926.933 2557.439 1296.577 -23. 188 6126.86276 Q3:1991 3973.267 2537.447 1306.265 -21.074 6205.937 77 Q4:1991 4000.033 2524.458 1308.774 -23.053 6264.540 78 Q1:1992 4100.400 2550.136 1326.421 -20.536 6363.102 79 Q2:1992 4155.667 2590.451 1334.807 -32.788 6470.763 80 Q3:1992 4227.000 2592.503 1353.997 -38.488 6566.641 81 Q4:1992 4307.200 2628.043 1362.775 -47.140 6680.803 82 Q1:1993 4349.500 2614.692 1351.818 -55.704 6729.459 83 Q2:1993 4418.600 2642.573 1359.066 -63.187 6808.939 84 Q3:1993 4487.167 2652.539 1367.411 -68.354 6882.098 85 Q4:1993 4552.667 2726.665 1381.394 -73.449 7013.738 86 Q1:1994 4621.233 2715.143 1373.350 -80.595 7115.652 87 Q2:1994 4683.167 2754.114 1389.392 -90.572 7246.931 88 Q3:1994 4752.733 2774.961 1423.432 -96.868 7331.075 89 Q4:1994 4826.700 2805.992 1422.923 -101.913 7455.288 90 Q1:1995 4862.467 2844.063 1437.596 -105.329 7522.289 91 Q2:1995 4933.600 2831.060 1452.892 -109.492 7580.997 92 Q3:1995 4998.667 2839.840 1455.659 -74.444 7683.125 93 Q4:1995 5055.667 2866.662 1451.575 -69.780 7772.586 94 Q1:1996 5130.600 2926.020 1471.295 -88.795 7868.468 95 Q2:1996 5220.533 2992.832 1487.662 -93.709 8032.840 96 Q3:1996 5274.500 3042.576 1496.733 -114.180 8131.408 97 Q4:1996 5352.767 3070.553 1515.702 -88.822 8259.771 98 Q1:1997 5433.100 3087.803 1515.985 -108.839 8362.655 99 Q2:1997 5471.233 3134.671 1542.541 -85.201 8518.825 100 Q3:1997 5579.167 3223.740 1555.224 -96.831 8662.823102 Q1:1998 5721.333 3305.334 1568.029 -135.215 8866.480 103 Q2:1998 5832.567 3406.259 1603.691 -162.331 8969.699 104 Q3:1998 5926.867 3465.782 1627.262 -174.634 9121.097 105 Q4:1998 6028.233 3524. 100 1647.452 -178.663 9293.991 106 Q1:1999 6102.033 3574.115 1669.139 -212.559 9411.682 107 Q2:1999 6230.633 3636.749 1694.757 -247.530 9526.210 108 Q3:1999 6335.333 3705.295 1733.984 -276.403 9686.626 109 Q4:1999 6467.033 3719.288 1781.740 -301.708 9900. 169 110 Q1:2000 6618.233 3786.156 1789.895 -356.583 10002.179 111 Q2:2000 6711.900 3821.718 1822.524 -362.501 10247.720 112 Q3:2000 6819.967 3810.374 1832.078 -393.867 10318.165 113 Q4:2000 6918.600 3809.242 1861.253 -411.343 10435.744 114 Q1:2001 6995.300 3774.722 1906.253 -402.653 10470.231 115 Q2:2001 7042.233 3742.545 1947.731 -364.015 10599.000 116 Q3:2001 7070.333 3681.172 1953.408 -370.634 10598.020 117 Q4:2001 7187.300 3631.126 1992.742 -369.688 10660.465 118 Q1:2002 7217.733 3608.319 2040.010 -386.884 10783.500 119 Q2:2002 7307.967 3596.426 2074.482 -428.259 10887.460 120 Q3:2002 7397.133 3586.226 2101.256 -447.548 10984.040 121 Q4:2002 7472.967 3563.664 2142.232 -496.289 11061.433 122 Q1:2003 7567.133 3572.316 2172.010 -525.262 11174.129 123 Q2:2003 7661.467 3629. 191 2198.793 -519.870 11312.766 124 Q3:2003 7820.933 3717.780 2220.432 -518.994 11566.669 125 Q4:2003 7913.467 3752.797 2251.164 -523.694 11772.234 126 Q1:2004 8048.767 3717.083 2286.594 -565.975 11923.447127 Q2:2004 8147.100 3773.888 2320.682 -617.581 12112.815 128 Q3:2004 8283.333 3813.727 2356.371 -652.672 12305.307 129 Q4:2004 8448.667 3839.624 2388.847 -700.336 12527.214 130 Q1:2005 8551.733 3865.293 2426.138 -696.655 12767.286 131 Q2:2005 8701.133 3894.540 2452.246 -707.210 12922.656 132 Q3:2005 8868. 100 3915.102 2494.438 -750.961 13142.642 133 Q4:2005 8955.267 3899.410 2528.432 -804.786 13324.204 134 Q1:2006 9100. 167 3948.613 2580.086 -790.818 13599. 160 135 Q2:2006 9227.667 3902.932 2610.565 -794.042 13753.424 136 Q3:2006 9353.800 3846.849 2630.280 -823.284 13870.188 137 Q4:2006 9427.367 3815.532 2674.454 -737.668 14039.560 138 Q1:2007 9572. 133 3780.342 2718.491 -739.273 14215.651 139 Q2:2007 9678.733 3781.623 2769.958 -745.806 14402.082 140 Q3:2007 9798.367 3745.360 2808.718 -728.954 14564.117 141 Q4:2007 9937.133 3709.304 2865.057 -729.699 14715.058 142 Q1:2008 10004.467 3647.072 2909.640 -771.248 14706.538 143 Q2:2008 10129.900 3618.529 2971.642 -776.404 14865.701 144 Q3:2008 10159.067 3522.902 3029.032 -787.354 14898.999 145 Q4:2008 9906.933 3325.562 3021.826 -628.474 14608.209 146 Q1:2009 9814.967 3117.325 3022.047 -420.992 14430.902 147 Q2:2009 9805.500 3047.040 3070.452 -358.368 14381.236 148 Q3:2009 9939.400 3054.653 3092.058 -423.998 14448.882 149 Q4:2009 10005.000 3050.270 3120.796 -473.254 14651.249 150 Q1:2010 10101.833 3030.636 3133.819 -509. 192 14764.610 151 Q2:2010 10208.133 3112.818 3165.768 -542.514 14980.193152 Q3:2010 10300.767 3115.405 3158.301 -553.943 15141.607 153 Q4:2010 10430.333 3136.384 3164.317 -523.586 15309.474 154 Q1:2011 10558.200 3102.585 3155.768 -568.476 15351.448 155 Q2:2011 10673.033 3130.244 3168.261 -581.092 15557.539 156 Q3:2011 10755.033 3207.240 3136.922 -567.111 15647.680 157 Q4:2011 10809.167 3265.852 3130.765 -601.788 15842.259 158 Q1:2012 10959.300 3313.566 3144.024 -602.271 16068.805 159 Q2:2012 11005.033 3350.108 3130.438 -565.241 16207.115 160 Q3:2012 11059.367 3325.340 3139.112 -523.083 16319.541 161 Q4:2012 11165.667 3347.653 3132.308 -515.874 16420.419 162 Q1:2013 11277.667 3373.753 3123.454 -499.348 16648.189 163 Q2:2013 11315.700 3392.979 3131.143 -498.380 16728.687 164 Q3:2013 11408.367 3429.373 3135.192 -482.067 16953.838 165 Q4:2013 11551.233 3452.097 3140.517 -434.019 17192.019 166 Q1:2014 11646.000 3458.452 3139.060 -510.088 17197.738 167 Q2:2014 11810.433 3535.667 3154.366 -505.404 17518.508 168 Q3:2014 11959.833 3583.257 3191.749 -489.357 17804.228 169 Q4:2014 12081.567 3627.255 3189.253 -530.751 17912.079 170 Q1:2015 12119.800 3637.656 3187.915 -526.432 18063.529 171 Q2:2015 12264. 133 3667.604 3234.067 -509.527 18279.784 172 Q3:2015 12382.500 3695.960 3253.554 -538.082 18401.626 173 Q4:2015 12423.367 3692.529 3258.142 -523.238 18435.137 174 Q1:2016 12523.167 3734.419 3270.141 -511.682 18525.933 175 Q2:2016 12665.133 3726.068 3289.566 -489.370 18711.702 176 Q3:2016 12797.133 3750.610 3315.171 -481.229 18892.639177 Q4:2016 12921.967 3767.124 3337.245 -530.806 19089.379 178 Q1:2017 13097.333 3792.441 3353.096 -533.420 19280.084 179 Q2:2017 13188.767 3822.256 3370.444 -553.499 19438.643 180 Q3:2017 13325.067 3830.879 3398.886 -531.498 19692.595 181 Q4:2017 13551.400 3897.659 3466.137 -554.897 20037.088 182 Q1:2018 13745.067 3931.189 3513.876 -576.031 20328.553 183 Q2:2018 13891.267 3948.370 3570.715 -543.823 20580.912 184 Q3:2018 14002.200 3944.809 3626.086 -618.246 20798.730 185 Q4:2018 14099.200 3929.545 3650.847 -634.207 20917.867 186 Q1:2019 14148.000 3943.093 3704.546 -598.587 21104.133 187 Q2:2019 14336.767 3983.439 3768.165 -615.022 21384.775 188 Q3:2019 14517.700 4016.988 3821.476 -584.258 21694.282 189 Q4:2019 14667.967 3996.337 3865.345 -516.146 21902.390 190 Q1:2020 14473.133 3967.433 3943.653 -518.021 21706.513 191 Q2:2020 13168.933 3729.855 4021.065 -531.137 19913.143 192 Q3:2020 14456.167 3887.888 3995.986 -695.747 21647.640 193 Q4:2020 14726.700 3983.694 4018.324 -760.659 22024.502 194 Q1:2021 15217.700 3992.690 4143.850 -792.417 22600.185 195 Q2:2021 15950.867 3969.134 4160.188 -831.972 23292.362 196 Q3:2021 16285. 100 3889.292 4201.529 -884.277 23828.973 197 Q4:2021 16718.200 3836.944 4266.648 -924.289 24654.603 198 Q1:2022 17030.633 3812.428 4321.404 -1089.677 25029.116 199 Q2:2022 17415.100 3722.807 4415.676 -1025.567 25544.273 200 Q3:2022 17684.200 3656.866 4477.855 -892.026 25994.639 201 Q4:2022 17917.067 3599.139 4572.408 -877.204 26408.405
