New Microsoft Excel Worksheet

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 24

Total

Total Resource Foreign Resource Foreign Resource


Fiscal Year Expenditu
Revenue Gap (A) Grants Gap (B) Loan Gap (c)
re

-1 -2 -3 (4)= (3-2) -5 6=(4+5) -7 8=7+6

1990/91
1991/92
1992/93
1993/94
1994/95
1995/96
1996/97
1997/98
1998/99

1999/2000

2000/01
2001/02
2002/03
2003/04
2004/05
2005/06
2006/07

2007/08

2008/09
2009/10
23549.8 10729.9 -12819.9 2164.8 -10655.1
26418.2 13512.7 -12905.5 1643.8 -11261.7
30897.7 15148.4 -15749.3 3793.3 -21956
33597.4 19580.8 -14016.6 2393.6 -11653
39060 24575.2 -14484.8 3937.1 -10547.7
46542.4 27893.1 -18649.3 4825.1 -13824.2
50723.7 30373.5 -20350.2 5988.3 -14361.9
56118.3 32937.9 -23180.4 5402.6 -17777.8
59579 37251 -22328 4336.6 -17991.4

66272.5 42893.8 -23378.7 5711.7 -17667

79835.1 48893.6 -30941.5 6753.4 -24188.1


80072.2 50445.5 -29626.7 6686.1 -22940.6
84006.1 56229.8 -27776.3 11339.1 -16437.2
84006.1 56229.8 -27776.3 11339.1 -16437.2
89442.6 62331 -27111.6 11283.4 -15828.2
102560.4 70122.7 -32437.7 14391.2 -18046.5
110889.2 72282.1 -38607.1 13827.4 -24779.7

133604.6 87712.1 -45892.5 15800.8 -30091.7

161349.9 107622.5 -53727.4 20320.7 -33406.7


219661.9 143474.5 -76187.4 26382.8 -49804.6
6256.7 -4398.4
6816.9 -4444.8
6920.9 -15035.1
9163.6 -2459.4
7312.3 -3235.4
9463.9 -4360.3
9043.6 -5318.3
11054.5 -6723.3
11852.4 -6139

11812.5 -5854.8

12044 -12144.1
7698.7 -15241.9
4546.4 -11890.8
4546.4 -11890.8
7629 -8199.2
9266.1 -8780.4
8214.3 -16565.4

10053.5 -20038.2-

8979.9 -24426.8
9968.9 -39835.7
Total
Total Resource Foreign Resource Foreign
Fiscal Year Expenditu
Revenue Gap (A) Grants Gap (B) Loan
re

-1 -2 -3 (4)= (3-2) -5 6=(4+5) -7

1990/91 23549.8 10729.9 -12819.9 2164.8 -10655.1 6256.7


1991/92 26418.2 13512.7 -12905.5 1643.8 -11261.7 6816.9
1992/93 30897.7 15148.4 -15749.3 3793.3 -21956 6920.9
1993/94 33597.4 19580.8 -14016.6 2393.6 -11653 9163.6
1994/95 39060 24575.2 -14484.8 3937.1 -10547.7 7312.3
1995/96 46542.4 27893.1 -18649.3 4825.1 -13824.2 9463.9
1996/97 50723.7 30373.5 -20350.2 5988.3 -14361.9 9043.6
1997/98 56118.3 32937.9 -23180.4 5402.6 -17777.8 11054.5
1998/99 59579 37251 -22328 4336.6 -17991.4 11852.4
1999/2000 66272.5 42893.8 -23378.7 5711.7 -17667 11812.5
2000/01 79835.1 48893.6 -30941.5 6753.4 -24188.1 12044
2001/02 80072.2 50445.5 -29626.7 6686.1 -22940.6 7698.7
2002/03 84006.1 56229.8 -27776.3 11339.1 -16437.2 4546.4
2003/04 89442.6 62331 -27111.6 11283.4 -15828.2 7629
2004/05 102560.4 70122.7 -32437.7 14391.2 -18046.5 9266.1
2005/06 110889.2 72282.1 -38607.1 13827.4 -24779.7 8214.3
2006/07 133604.6 87712.1 -45892.5 15800.8 -30091.7 10053.5
2007/08 161349.9 107622.5 -53727.4 20320.7 -33406.7 8979.9
2008/09 219661.9 143474.5 -76187.4 26382.8 -49804.6 9968.9
2009/10 259,146 179,940 -79,206 37,117 -42089 11,492
2010/11 337,900 216,644 -121,256 65,344 -55912 22,231
2011/12 302,053 244,374 -57,679 99,786 42107 29,654
2012/13 311,673 295,729 -15,944 72,824 56880 25,835
2013/14 438,517 354,500 -84,017 113,240 29223 43,703
2014/15 428,032 411,848 -16,184 122,914 106730 49,528
2015/16 593,155 460,425 -132,730 205,894 73164 94,964
2016/17 929,110 565,896 -363,214 302,612 -60602 195,715
Resource Tax
Gap (c) A Non-Tax Revenue
Revenue
Fiscal Year m
o
8=7+6 % Amount %
u
n
-4398.4 1990/91 ### 76.2 2553.5 23.8
t
-4444.8 1991/92 ### 73.1 3637.1 26.9
-15035.1 1992/93 ### 77 3485.9 23
-2459.4 1993/94 ### 78.5 4209.4 21.5
-3235.4 1994/95 ### 79.99 4945.2 20.01
-4360.3 1995/96 ### 77.7 6225.1 22.3
-5318.3 1996/97 ### 80.4 5949.2 19.6
-6723.3 1997/98 ### 78.8 6998.1 21.2
-6139 1998/99 ### 77.19 8498 22.81
-5854.8 1999/2000 ### 77.29 9741.6 22.71
-12144.1 2000/01 ### 79.49 10028.58 20.51
-15241.9 2001/02 ### 78 11114.9 22
-11890.8 2002/03 ### 75.7 13642.8 22.3
-8199.2 2003/04 ### 77.3 14158 22.7
-8780.4 2004/05 ### 77.2 16018 22.8
-16565.4 2005/06 ### 79.43 14851.7 20.57
-20038.2- 2006/07 ### 81.09 16585.1 18.91
-24426.8 2007/08 ### 79.12 22467 20.88
-39835.7 2008/09 ### 81.58 26422.6 18.42
-30597 2009/10 ### 86.86 23,650 13.14
-33681 2010/11 ### 87.12 27,914 12.88
71761 2011/12 ### 86.64 32,652 13.36
82715 2012/13 ### 87.77 36,157 12.23
72926 2013/14 ### 88.76 39,861 11.24
156258 2014/15 ### 86.43 55,893 13.57
168128 2015/16 ### 89.57 48,001 10.43
135113 2016/17 ### 90.23 55,305 9.77
Total Revenue 10729.9

Amount % 13512.7

10729.9 100 15148.4


13512.7 100 19580.8
15148.4 100 24575.2
19580.8 100 27893.1
24575.2 100 30373.5
27893.1 100 32937.9
30373.5 100 37251
32937.9 100 42893.8
37251 100 48893.6
42893.8 100 50445.5
48893.6 100 56229.8
50445.5 100 62331
56229.8 100 70122.7
62331 100 72282.1
70122.7 100 87712.1
72282.1 100 107622.5
87712.1 100 143474.5
107622.5 100 179,940
143474.5 100 216,644
179,940 100 244,374
216,644 100 295,729
244,374 100 354,500
295,729 100 411,848
354,500 100 460,425
411,848 100 565,896
460,425 100
565,896 100

Total Tax
GDP
Fiscal Years Revenue Revenue
Amount
Amount Amount
1990/91 120370 10729.9 8176.4
1991/92 149487 13512.7 9875.6
1992/93 171474 15148.4 11662.5
1993/94 199272 19580.8 15371.4
1994/95 218175 24575.2 19660
1995/96 248913 27893.1 21668
1996/97 280513 30373.5 24424.3
1997/98 300845 32937.9 25939.8
1998/99 342036 37251 28753
1999/2000 379488 42893.8 33152.2
2000/01 411275 48893.6 38865.1
2001/02 422807 50445.5 39330.6
2002/03 456675 56229.8 42587
2003/04 495589 62331 48173
2004/05 548484 70122.7 54104.7
2005/06 611118 72282.1 57430.4
2006/07 675484 87712.1 71127
2007/08 755262 107622.5 85155.5
2008/09 910160 143474.5 117051.9
2009/10 1193000 179,940 150,245
2010/11 1367000 216,644 177,227
2011/12 1527000 244,374 211,722
2012/13 1695000 295,729 252,572
2013/14 1965000 354,500 353,505
201/15 2120000 411,848 355,955
2015/16 2249000 460,425 412,424
Direct TAX

As% of As % of As% of
Amount
GDP TR TTR
6806.6 5.65 63.43 83.25 1193.00 1367.00 1527.00 1695.00 1965.00 2
8280.4 5.53 61.27 83.85
9626.3 5.61 63.54 82.55 1193.00 1367.00 1527.00 1695.00 1965.00 2
12516 6.28 63.91 81.43
15865 7.27 64.55 80.43
17083 6.86 61.24 78.84
19191 6.84 63.18 78.58
19927 6.62 60.5 76.82
21456 6.27 57.6 74.63
24597 6.48 57.34 74.2
28705.7 6.98 58.71 73.86
28733.1 6.79 56.95 73.06
32481.2 7.11 57.76 76.28
36260.4 7.31 58.17 75.28
41839.3 7.62 59.66 77.34
45643.4 7.47 63.15 79.47
54399.9 8.05 62.02 76.48
65008.5 8.61 60.4 76.34
87954.5 9.66 61.3 75.14 1193.00 1367.00 1527.00 1695.00 1965.00 2
1527.00 1695.00 1965.00 2120.00 2249.00

1527.00 1695.00 1965.00 2120.00 2249.00

1527.00 1695.00 1965.00 2120.00 2249.00


tax revenue direct per direct tax amount indirect tax
8176.4 16.75 1369.547 6806.85
9875.6 16.15 1594.909 8280.69
11663 17.45 2035.194 9627.81
15371 18.57 2854.395 12516.61
19660 19.57 3847.462 15812.54
21668 21.16 4584.949 17083.05
24424 21.42 5231.621 19192.38
25940 23.18 6012.892 19927.11
28753 25.37 7294.636 21458.36
33152 25.8 8553.216 24598.78
38865 26.14 10159.31 28705.69
39331 26.94 10595.77 28735.23
42587 23.72 10101.64 32485.36
48173 24.72 11908.37 36264.63
54105 22.66 12260.19 41844.81
57430 26.07 14972 42458.00
71127 23.51 16721.96 54405.04
85156 23.66 20147.91 65008.09
117052 24.86 29099.13 87952.87
156,290 25.32 39572.63 116717.37
188,730 25.74 48579.1 140150.90
211,722 26.32 55725.23 155996.77
259,572 27.04 70188.27 189383.73
314,639 27.86 87658.43 226980.57
355,955 27.92 99382.64 256572.36
412,424 28.32 116798.5 295625.52
510,591 29.1 148582 362009.02
Fiscal Years GDP Amount

1990/91 120370
1991/92 149487
1992/93 171474
1993/94 199272
1994/95 218175
1995/96 248913
1996/97 280513
1997/98 300845
1998/99 342036
1999/2000 379488
2000/01 411275
2001/02 422807
2002/03 456675
2003/04 495589
2004/05 548484
2005/06 611118
2006/07 675484
2007/08 755262
2008/09 910160
2009/10 1193000
2010/11 1367000
2011/12 1527000
2012/13 1695000
2013/14 1965000
2014/15 2120000
2015/16 2249000

Heading Amount
VAT - Production 15,469,522
VAT - Import 92,711,511
VAT - Goods, Sales & Distribution 11,257,851
VAT - Services & Contracts 8,440,774
VAT - Services, Tourism 2,054,053
VAT - Telephone, Insurance & Air Travel 8,501,854
VAT - Non Registered(Reverse Charge 2,456,089
total 140,891,654
Total Indirect TAX
Tax Revenue
Revenue
Amount As% of
Amount Amount As% of GDP As % of TR
TTR
10730 8176.4 6806.853 5.65 63.44 83.25
13513 9875.6 8280.6906 5.54 61.28 83.85
15148 11663 9627.8065 5.61 63.56 82.55
19581 15371 12516.6053 6.28 63.92 81.43
24575 19660 15812.538 7.25 64.34 80.43
27893 21668 17083.0512 6.86 61.24 78.84
30374 24424 19192.3792 6.84 63.19 78.58
32938 25940 19927.108 6.62 60.50 76.82
37251 28753 21458.3639 6.27 57.60 74.63
42894 33152 24598.784 6.48 57.35 74.2
48894 38865 28705.689 6.98 58.71 73.86
50446 39331 28735.2286 6.80 56.96 73.06
56230 42587 32485.3636 7.11 57.77 76.28
62331 48173 36264.6344 7.32 58.18 75.28
70123 54105 41844.807 7.63 59.67 77.34
72282 57430 42457.999 6.95 58.74 73.93
87712 71127 54405.0423 8.05 62.03 76.49
107623 85156 65008.0904 8.61 60.40 76.34
143475 117052 87952.8728 9.66 61.30 75.14
179,940 156,290 116717.4 9.78 64.86 74.68
216,644 188,730 140150.9 10.25 64.69 74.26
244,374 211,722 155996.8 10.22 63.84 73.68
295,729 259,572 189383.7 11.17 64.04 72.96
354,500 314,639 226980.6 11.55 64.03 72.14
411,848 355,955 256572.4 12.10 62.30 72.08
460,425 412,424 295625.5 13.14 64.21 71.68
362009.019

%
10.98
65.80
7.99
5.99
1.46
6.03
1.74
100.00
Total Tax Tax Effort
Fiscal Year GDP Total Revenue
Revenue Ratio
1990/91 120370 10730 8176.4 6.79
1991/92 149487 13513 9875.6 6.61
1992/93 171474 15148 11663 6.80
1993/94 199272 19581 15371 7.71
1994/95 218175 24575 19660 9.01
1995/96 248913 27893 21668 8.71
1996/97 280513 30374 24424 8.71
1997/98 300845 32938 25940 8.62
1998/99 342036 37251 28753 8.41
1999/2000 379488 42894 33152 8.74
2000/01 411275 48894 38865 9.45
2001/02 422807 50446 39331 9.30
2002/03 456675 56230 42587 9.33
2003/04 495589 62331 48173 9.72
2004/05 548484 70123 54105 9.86
2005/06 611118 72282 57430 9.40
2006/07 675484 87712 71127 10.53
2007/08 755262 107623 85156 11.28
2008/09 910160 143475 117052 12.86
2009/10 1193000 179,940 156,290 13.10
2010/11 1367000 216,644 188,730 13.81
2011/12 1527000 244,374 211,722 13.87
2012/13 1695000 295,729 259,572 15.31
2013/14 1965000 354,500 314,639 16.01
2014/15 2120000 411,848 355,955 16.79
2015/16 2249000 460,425 412,424 18.34
% of VAT Revenue
Total Tax
Fiscal Year Sales Tax/VAT in Total Tax
Revenue
Revenue

1990/91 8176.4 2026.1 24.78


1991/92 9875.6 2840.7 28.76
1992/93 11663 3438.2 29.48
1993/94 15371 4693.1 30.53
1994/95 19660 6031.7 30.68
1995/96 21668 6431.3 29.68
1996/97 24424 7126.5 29.18
1997/98 25940 7122.6 27.46
1998/99 28753 7882.2 27.41
1999/2000 33152 9854.9 29.73
2000/01 38865 12382.4 31.86
2001/02 39331 12267.3 31.19
2002/03 42587 13459.7 31.61
2003/04 48173 14478.9 30.06
2004/05 54105 18885.4 34.91
2005/06 57430 21610.7 37.63
2006/07 71127 26095.6 36.69
2007/08 85156 29815.7 35.01
2008/09 117052 39700.9 33.92
2009/10 156,290 51,560 32.99
2010/11 188,730 61,558 32.62
2011/12 211,722 70,930 33.50
2012/13 259,572 84,036 32.37
2013/14 314,639 101,110 32.14
2014/15 355,955 112,160 31.51
2015/16 412,424 140,891 34.16
vat total revenue total tax revenue 0.998254
2026.1 10729.9 8176.4
2840.7 13512.7 9875.6
3438.2 15148.4 11663
4693.1 19580.8 15371
6031.7 24575.2 19660
6431.3 27893.1 21668
7126.5 30373.5 24424
7122.6 32937.9 25940
7882.2 37251 28753
9854.9 42893.8 33152
12382.4 48893.6 38865
12267.3 50445.5 39331
13459.7 56229.8 42587
14478.9 62331 48173
18885.4 70122.7 54105
21610.7 72282.1 57430
26095.6 87712.1 71127
29815.7 107623 85156
39700.9 143475 117052
51,560 179,940 156,290
61,558 216,644 188,730
70,930 244,374 211,722
84,036 295,729 259,572
101,110 354,500 314,639
112,160 411,848 355,955
140,891 460,425 412,424
0.99877

You might also like