Variable names and description: : Value added tax revenue, nominal (R millions) VAT HCE : HYD M3 : LAB : INF CPI Final consumption expenditure by households, nominal (R millions) Disposable income of households, nominal (R millions) Money supply, nominal (R millions) Nominal labor costs in the non-agricultural sectors (Index, 2010 = 100) : Inflation (percentage, quarter on previous quarter at annual rate) Consumer price index (Index, 2015 = 100) 3.2 Calculate and provide a graph of the real value added tax for the period 1990 to 2018. Discuss the trends you observe in VAT collection, before and after 2008. (3) VAT HCE HYD LAB INF CPI M3 1990/01 4354 41214 40565 16.6 15.2 18.58251 149684 1990/02 4307 44545 47981 17.6 13.1 19.16513 153060 1990/03 4608 46549 46352 18.2 13.4 19.77841 154147 1990/04 4268 51102 54700 18.9 16.8 20.56035 161339 1991/01 5108 48924 49720 19.5 1991/02 4628 51714 57844 20.4 1991/03 4528 52868 50880 21.5 14.4 21.26562 170651 15.9 22.06289 177155 15.3 22.86016 178752 1991/04 4745 58202 60196 22.6 O 1992/01 4912 55488 60446 24.1 1992/02 3666 58769 66324 25.3 18.9 23.87208 180876 13.5 24.63869 185371 12.5 25.37463 189145 1992/03 4440 60502 62280 26.2 11.9 26.09524 195195 B 1992/04 4862 65523 66926 27 5.5 26.44788 196763 1993/01 4548 61290 66504 27.1 5 1993/02 5409 65955 74744 27.4 8 26.95383 17.2 28.07308 195403 196127 5 1993/03 6736 67715 69569 28.4 6.5 28.54837 203829 1993/04 6561 74914 72183 29.6 7.4 28.94701 211358 B 1994/01 6759 70528 71002 29.5 7.8 29.56029 221253 9 1994/02 6568 74472 81465 31 7 30.08158 225172 1994/03 7153 77635 78643 32.1 14.6 31.15483 232320 1994/04 7800 86135 87860 32.7 9.8 31.78345 243771 2 1995/01 7751 81921 81613 33 8.5 32.50406 247207 B 1995/02 7533 86714 92175 33.5 9.9 33.28599 265106 1995/03 8039 88409 92298 34.5 2.9 33.56197 269968 5 1995/04 8384 96614 96706 35.4 5 33.86861 280377 5 1996/01 8811 90969 91743 35.9 8.4 34.61989 296070 1996/02 8156 96311 102283 36.4 8.3 35.30983 314513 B 1996/03 91996/04 O 1997/01 1997/02 9109 99485 104265 37.6 9 36.12243 320967 8551 110261 2 1997/03 8 1997/04 1998/01 5 1998/02 5 1998/03 1998/04 107540 10087 104079 109324 8537 109145 115748 10415 111126 117248 10423 120921 38.8 10.8 36.9657 328037 39 10.3 37.94695 347150 39.3 7.5 38.62156 357055 40.5 5.9 39.23485 379288 119511 41.3 10721 113496 10060 118796 119098 43.3 124808 44.5 10593 11283 130036 121823 124207 45.3 4 39.51083 383858 4.7 40.03212 400072 5.8 40.59941 415135 16.9 42.2706 426722 129238 47.3 9.5 43.09854 439464 B 1999/01 11741 123446 128837 47 2.2 43.42051 437710 91999/02 9446 129483 135196 47.7 1.1 43.5585 448514 1999/03 1999/04 13290 133249 140523 48.4 0.7 43.68116 464401 12777 143092 136795 48 4.2 43.9418 485768 2 2000/01 B 2000/02 2000/03 12863 138683 144088 49.4 5.3 44.63175 480461 11821 146954 151358 49.7 9.4 45.70499 483668 5 2000/04 5 2001/01 2001/02 13818 13554 160597 150992 157995 49.4 7.5 46.56359 499609 155651 49.5 6.2 47.02356 515750 15261 154147 159666 50.4 12791 161692 166491 51.6 B 2001/03 14857 165333 172035 52.2 6.7 47.94348 543610 5 48.63343 554866 1.2 48.78675 573950 9 2001/04 15615 176721 169167 53.3 4.6 49.04739 594077 ECS4863 2022 Assignment 01 B D E F G H 49 2001/04 50 2002/01 51 2002/02 52 2002/03 15615 176721 169167 53.3 4.6 49.04739 594077 17794 16283 171162 182722 53.9 12.3 50.70916 649060 180799 182916 56.5 13.1 52.4425 664968 17334 186076 196194 58.4 11.8 54.01534 682704 53 2002/04 17096 201806 189821 58 13.7 55.70281 701634 54 2003/01 19437 189191 197261 57.9 5.1 56.49153 730859 55 2003/02 17184 197391 193518 58.5 1.1 56.78729 771290 56 2003/03 18910 201320 216550 59.2 -1.4 56.38377 785588 57 2003/04 58 2004/01 21093 214894 204027 59.3 -1.6 55.29699 800031 23494 213030 224020 61.3 3.9 55.49647 834779 59 2004/02 21384 224910 232700 62.7 2.1 55.81057 854675 60 2004/03 22986 228246 229462 62.9 0.8 55.88624 903615 61 2004/04 25255 247350 235837 64.9 5.9 56.20952 910382 62 2005/01 28534 236485 240371 65.2 2.7 56.56948 938754 63 2005/02 23457 248776 252832 66.7 3.5 56.8492 998508 64 2005/03 27472 255425 259309 67.7 3.4 57.22521 1062468 65 2005/04 29810 275190 268417 68.6 66 2006/01 33613 260228 254144 69.8 3.2 67 2006/02 28347 274613 285176 69.7 5 57.36736 1103406 57.72733 1202128 4.6 58.29364 1237184 68 2006/03 69 2006/04 33522 286609 281100 70.6 8 59.37812 1283600 33971 316267 297808 72.5 6.4 70 2007/01 38624 296948 286264 71.5 71 2007/02 72 2007/03 73 2007/04 74 2008/01 32371 315456 323982 73.4 35260 39756 43057 324964 326155 324214 74.3 358437 333779 75.9 309151 79.5 60.00863 1350994 4.8 60.69417 1443477 8.8 61.79929 1523351 7.7 63.10846 1603241 12.6 64.34885 1681099 15.2 66.12771 1745309 75 2008/02 34170 346902 352231 81.4 76 2008/03 77 2008/04 37523 360549 359288 83.8 37154 389380 78 2009/01 45495 79 2009/02 23579 80 2009/03 36419 371630 385982 353020 319064 365600 376975 383774 85.5 88.3 89 91.4 81 2009/04 43215 402019 404623 95.1 82 2010/01 44730 381652 358165 97.3 83 2010/02 37965 396041 401021 99.2 84 2010/03 43379 406521 429566 99.9 2.4 76.55555 2.7 77.17322 9 67.94441 1831050 12.1 70.19711 1869995 6 70.81479 1915400 6.1 71.97747 1932543 6.9 73.46716 1945799 6.5 74.66618 1943527 4.9 74.95685 1944458 4.2 75.82887 1966170 1999453 2040120 85 2010/04 44480 437621 419672 103.7 86 2011/01 57748 419777 384521 103.1 87 2011/02 37737 437552 443104 104.7 88 2011/03 43811 448675 463936 108.2 89 2011/04 90 2012/01 91 2012/02 43082 483178 55000 495087 54473 466265 422791 492990 486887 109.6 111.1 112 92 2012/03 53112 493717 502047 115.7 4.4 77.50023 5.5 78.66291 2097839 6.1 80.11627 2123027 5.7 81.35162 2173574 6.9 82.33264 2244819 5.6 83.53166 2235746 4.3 84.80334 2268502 3.8 85.56635 2331166 2073926 93 2012/04 56804 540445 527081 116 94 2013/01 62025 508945 446327 118.1 9 87.01971 5.9 88.4004 2370890 2414312 95 2013/02 47111 524757 538839 120 96 2013/03 60756 534301 541025 120.6 3.9 89.56308 6.2 90.94377 2491667 2468950 97 2013/04 61638 576182 569683 120.6 5.8 91.70679 2520289 ECS4863 2022 Assignment 01 32 2010/01 B3 2010/02 44730 381652 358165 97.3 4.2 75.82887 1966170 34 2010/03 37965 396041 43379 406521 401021 99.2 429566 99.9 35 2010/04 44480 437621 419672 103.7 36 2011/01 57748 419777 384521 103.1 37 2011/02 37737 437552 443104 104.7 38 2011/03 43811 448675 463936 108.2 2.4 76.55555 1999453 2.7 77.17322 2040120 4.4 77.50023 2073926 5.5 78.66291 2097839 6.1 80.11627 2123027 5.7 81.35162 2173574 39 2011/04 55000 495087 486887 109.6 6.9 90 2012/01 54473 466265 422791 111.1 91 2012/02 43082 483178 492990 112 82.33264 2244819 5.6 83.53166 2235746 4.3 84.80334 2268502 92 2012/03 53112 493717 502047 115.7 93 2012/04 56804 540445 527081 116 4 2013/01 62025 508945 446327 118.1 95 2013/02 47111 524757 538839 120 96 2013/03 60756 534301 541025 120.6 97 2013/04 61638 576182 569683 120.6 98 2014/01 68163 542677 475742 124.7 99 2014/02 51857 557256 577732 124.8 00 2014/03 65420 568390 582787 126.7 01 2014/04 71025 613714 600223 127.8 02 2015/01 72993 570526 526891 128.9 03 2015/02 57214 591136 620730 132.1 04 2015/03 67565 603859 618724 133.9 05 2015/04 72315 654618 633865 136.3 06 2016/01 84018 07 2016/02 57194 608104 630506 662859 545723 138.6 138.9 08 2016/03 72958 09 2016/04 10 2017/01 644903 656575 80514 700860 78501 647624 140.7 696002 142.2 607324 145.6 11 2017/02 63223 671841 697523 146.9 12 2017/03 13 2017/04 14 2018/01 73078 79063 687648 717474 147.4 749427 739813 149.1 82635 692864 648511 151.4 15 2018/02 75634 711055 735978 152.4 16 2018/03 86187 726409 758646 155.2 2491667 3.8 85.56635 2331166 9 87.01971 2370890 5.9 88.4004 2414312 3.9 89.56308 2468950 6.2 90.94377 5.8 91.70679 2520289 7.7 93.59615 2598672 6.3 95.48551 2642758 5.2 96.72086 2686734 3.7 96.93887 2700163 1.4 97.52021 2782235 7.8 99.77291 2874512 6.2 101.1173 2913488 4.1 101.5896 2975755 8 103.915 3020881 6.8 106.2767 3040952 5.4 107.5847 3076204 6.1 108.6021 3146951 6.8 110.6368 3187198 3.2 111.7994 3231085 3.3 112.5261 3295139 5.4 113.5071 3343869 4.5 114.9968 3391748 4.7 116.6318 3420479 5.5 118.0489 3525428 17 2018/04 80246 790666 774822 156.8 4.9 118.9936 3526865 18 19