formulasi pph22.xlsx

	B	C	D	E	F	P	V
1
2	KALKULATOR PPh 22
3
4
5
6
7			Nilai SPM	PPN	PPh 22 (1,5%)
8		DIGUNAKAN	11525000	1,142,117.12	155,743.24	172875
9
10
11			Nilai SPM	PPN	PPh 22 (1,5%)
12		DIGUNAKAN	27932500	2,768,085.59	377,466.22
13
14
15			Nilai SPM	PPN	PPh 22 (1,5%)
16		DIGUNAKAN	10499990	1,040,539.55	141,891.76
17
18
19			Nilai SPM	PPN	PPh 22 (1,5%)
20		DIGUNAKAN	5818000	576,558.56	78,621.62
21
22
23			Nilai SPM	PPN	PPh 22 (1,5%)
24		DIGUNAKAN	5562000	551,189.19	75,162.16
25
26
27			Nilai SPM	PPN	PPh 22 (1,5%)
28		DIGUNAKAN	9500000	941,441.44	128,378.38
29
30
31			Nilai SPM	PPN	PPh 22 (1,5%)
32		DIGUNAKAN	46200000	4,578,378.38	624,324.32
33
34
35			Nilai SPM	PPN	PPh 22 (1,5%)
36		DIGUNAKAN	26058600	2,582,383.78	352,143.24
37
38
39			Nilai SPM	PPN	PPh 22 (1,5%)
40		DIGUNAKAN	15680000	1,553,873.87	211,891.89
41
42
43			Nilai SPM	PPN	PPh 22 (1,5%)
44		DIGUNAKAN	20214006	2,003,189.78	273,162.24
45
46
47			Nilai SPM	PPN	PPh 22 (1,5%)
48		DIGUNAKAN	17760000	1,760,000.00	240,000.00
49
50
51			Nilai SPM	PPN	PPh 22 (1,5%)
52		DIGUNAKAN	2999640931	297,261,713.88	40,535,688.26
53
54							14745147
55			Nilai SPM	PPN	PPh 22 (1,5%)
56		DIGUNAKAN	13994312	1,386,823.71	189,112.32
57
58
59			Nilai SPM	PPN	PPh 22 (1,5%)
60		DIGUNAKAN	1499998250	148,648,475.23	20,270,246.62
61
62
63			Nilai SPM	PPN	PPh 22 (1,5%)
64		DIGUNAKAN	14745147	1,461,230.78	199,258.74
65
66
67			Nilai SPM	PPN	PPh 22 (1,5%)
68		DIGUNAKAN	13503283	1,338,163.18	182,476.80
69
70
71			Nilai SPM	PPN	PPh 22 (1,5%)
72		DIGUNAKAN	3691341630	365,808,630.00	49,882,995.00
73
74
75			Nilai SPM	PPN	PPh 22 (1,5%)
76		DIGUNAKAN	1825739999	180,929,189.09	24,672,162.15
77			.
78
79			Nilai SPM	PPN	PPh 22 (1,5%)
80		DIGUNAKAN	11427840	1,132,488.65	154,430.27
81
82
83			Nilai SPM	PPN	PPh 22 (1,5%)
84		DIGUNAKAN	52264800	5,179,394.59	706,281.08
85
86
87			Nilai SPM	PPN	PPh 22 (1,5%)
88		DIGUNAKAN	3691341630	365,808,630.00	49,882,995.00
89
90
91			Nilai SPM	PPN	PPh 22 (1,5%)
92		DIGUNAKAN	1300143000	128,843,000.00	17,569,500.00
93
94
95			Nilai SPM	PPN	PPh 22 (1,5%)
96		DIGUNAKAN	273731869	27,126,581.61	3,699,079.31
97
98
99			Nilai SPM	PPN	PPh 22 (1,5%)
100		DIGUNAKAN	283140120	28,058,930.81	3,826,217.84