| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||
2 | SALDO PERTAHUN | SIMPANAN POKOK | ||||||||
3 | TAHUN | 10% | 12% | 15.50% | 17% | Rp1,000,000 | ||||
4 | 1 | Rp1,100,000 | Rp1,120,000 | Rp1,155,000 | Rp1,170,000 | |||||
5 | 2 | Rp1,200,000 | Rp1,240,000 | Rp1,310,000 | Rp1,340,000 | |||||
6 | 3 | Rp1,300,000 | Rp1,360,000 | Rp1,465,000 | Rp1,510,000 | |||||
7 | 4 | Rp1,400,000 | Rp1,480,000 | Rp1,620,000 | Rp1,680,000 | |||||
8 | 5 | Rp1,500,000 | Rp1,600,000 | Rp1,775,000 | Rp1,850,000 | |||||
9 | 6 | Rp1,600,000 | Rp1,720,000 | Rp1,930,000 | Rp2,020,000 | |||||
10 | 7 | Rp1,700,000 | Rp1,840,000 | Rp2,085,000 | Rp2,190,000 | |||||
11 | 8 | Rp1,800,000 | Rp1,960,000 | Rp2,240,000 | Rp2,360,000 | |||||
12 | 9 | Rp1,900,000 | Rp2,080,000 | Rp2,395,000 | Rp2,530,000 | |||||
13 | 10 | Rp2,000,000 | Rp2,200,000 | Rp2,550,000 | Rp2,700,000 | |||||
14 | ||||||||||
15 | RUMUS MENGHITUNG SALDO PER TAHUN | |||||||||
16 | ||||||||||
17 | (SIMPANAN POKOK X TAHUN X BUNGA) + SIMPANAN POKOK | |||||||||
18 | ||||||||||
19 | ||||||||||
20 | ||||||||||
21 | MENGHITUNG TRANSAKSI KEUANGAN WARNET | |||||||||
22 | ||||||||||
23 | Jam Masuk | Jam Keluar | Durasi | Pembulatan | Tarif | Bayar | Kembalian | Tarif Perjam | ||
24 | 16:00 | 17:15 | 1.25 | 1.20 | Rp3,000 | Rp5,000 | Rp2,000 | Rp2,500 | ||
25 | 6:15 | 7:15 | 1 | 1.00 | Rp2,500 | Rp10,000 | Rp7,500 | |||
26 | 8:55 | 9:55 | 1 | 1.00 | Rp2,500 | Rp5,000 | Rp2,500 | |||
27 | 19:33 | 23:00 | 3.45 | 3.50 | Rp8,750 | Rp20,000 | Rp11,250 | |||
28 | 15:17 | 23:03 | 7.766666667 | 7.80 | Rp19,500 | Rp10,000 | (Rp9,500) | |||