formulasi PPN.xlsx

	A	B	C	D	E	G	I	AA	AB	AC
1	543
2		KALKULATOR PPN
3
4								0		0
5								0.9009009009		5980000
6				Nilai SPM	PPN			1.50%
7			DIGUNAKAN	6637800	657,800.000	3,958,891,818.18			657800
8								0.01351351351	6637800	89700
9						431,554,873.87		0.9009009009		5980000
10				Nilai SPM	PPN	657,800.00	0.990990991	1.50%
11			DIGUNAKAN	6637800	657,800.00		4,359,140,140.14		657800
12								0.01351351351	6637800	89700
13						657,800.000		0.9009009009		12436936.94
14				Nilai SPM	PPN			1.50%
15			DIGUNAKAN	13805000	1,368,063.06				1368063.063
16								0.01351351351	13805000	186554.0541
17								0.9009009009		26495495.5
18				Nilai SPM	PPN			1.50%
19			DIGUNAKAN	29410000	2,914,504.50				2914504.505
20								0.01351351351	29410000	397432.4324
21								0.9009009009		16470270.27
22				Nilai SPM	PPN			1.50%
23			DIGUNAKAN	18282000	1,811,729.73				1811729.73
24								0.01351351351	18282000	247054.0541
25								0.9009009009		18233351.35
26				Nilai SPM	PPN			1.50%
27			DIGUNAKAN	20239020	2,005,668.65				2005668.649
28								0.01351351351	20239020	273500.2703
29								0.9009009009		19673799568
30				Nilai SPM	PPN			1.50%
31			DIGUNAKAN	21837917520	2,164,117,952.43				2164117952
32								0.01351351351	21837917520	295106993.5
33								0.9009009009		28954000
34				Nilai SPM	PPN			1.50%
35			DIGUNAKAN	32138940	3,184,940.00				3184940
36								0.01351351351	32138940	434310
37								0.9009009009		8797297.297
38				Nilai SPM	PPN			1.50%
39			DIGUNAKAN	9765000	967,702.70				967702.7027
40								0.01351351351	9765000	131959.4595
41								0.9009009009		12936936.94
42				Nilai SPM	PPN			1.50%
43			DIGUNAKAN	14360000	1,423,063.06				1423063.063
44								0.01351351351	14360000	194054.0541
45								0.9009009009		7356804.505
46				Nilai SPM	PPN			1.50%
47			DIGUNAKAN	8166053	809,248.50				809248.4955
48								0.01351351351	8166053	110352.0676
49								0.9009009009		44864862.16
50				Nilai SPM	PPN			1.50%
51			DIGUNAKAN	49799997	4,935,134.84				4935134.838
52								0.01351351351	49799997	672972.9324
53								0.9009009009		20108108.11
54				Nilai SPM	PPN			1.50%
55			DIGUNAKAN	22320000	2,211,891.89				2211891.892
56								0.01351351351	22320000	301621.6216
57								0.9009009009		#VALUE!
58				Nilai SPM	PPN			1.50%
59			DIGUNAKAN	3.671.604.263	#VALUE!				#VALUE!
60								0.01351351351	3.671.604.263	#VALUE!
61								0.9009009009		3307751588
62				Nilai SPM	PPN			1.50%
63			DIGUNAKAN	3671604263	363,852,674.71	3671604263			363852674.7
64								0.01351351351	3671604263	49616273.82
65								0.9009009009		1478454842
66				Nilai SPM	PPN			1.50%
67			DIGUNAKAN	1641084875	162,630,032.66				162630032.7
68								0.01351351351	1641084875	22176822.64
69								0.9009009009		1501501543
70				Nilai SPM	PPN			1.50%
71			DIGUNAKAN	1666666713	165,165,169.76				165165169.8
72								0.01351351351	1666666713	22522523.15
73								0.9009009009		0
74				Nilai SPM	PPN			1.50%
75			KOSONG		0.00				0
76								0.01351351351		0
77								0.9009009009		0
78				Nilai SPM	PPN			1.50%
79			KOSONG		0.00				0
80								0.01351351351		0
81								0.9009009009		0
82				Nilai SPM	PPN			1.50%
83			KOSONG		0.00				0
84								0.01351351351		0
85								0.9009009009		0
86				Nilai SPM	PPN			1.50%
87			KOSONG		0.00				0
88								0.01351351351		0
89								0.9009009009		0
90				Nilai SPM	PPN			1.50%
91			KOSONG		0.00				0
92								0.01351351351		0
93								0.9009009009		0
94				Nilai SPM	PPN			1.50%
95			KOSONG		0.00				0
96								0.01351351351		0
97								0.9009009009		0
98				Nilai SPM	PPN			1.50%
99			KOSONG		0.00				0
100								0.01351351351		0