Fungsi Future Value (FV)
Bunga pertahun 18%
Jumlah periode 15
Nilai Rp 50,000,000.00
Total ditambah bunga Rp3,048,263,301.67
PERIODE NILAI INVESTASI BUNGA TOTAL
1 Rp 50,000,000 Rp 9,000,000 Rp 59,000,000
2 Rp 109,000,000 Rp 19,620,000 Rp 128,620,000
3 Rp 178,620,000 Rp 32,151,600 Rp 210,771,600
4 Rp 260,771,600 Rp 46,938,888 Rp 307,710,488
5 Rp 357,710,488 Rp 64,387,888 Rp 422,098,376
6 Rp 472,098,376 Rp 84,977,708 Rp 557,076,083
7 Rp 607,076,083 Rp 109,273,695 Rp 716,349,779
8 Rp 766,349,779 Rp 137,942,960 Rp 904,292,739
9 Rp 954,292,739 Rp 171,772,693 Rp 1,126,065,432
10 Rp 1,176,065,432 Rp 211,691,778 Rp 1,387,757,209
11 Rp 1,437,757,209 Rp 258,796,298 Rp 1,696,553,507
12 Rp 1,746,553,507 Rp 314,379,631 Rp 2,060,933,138
13 Rp 2,110,933,138 Rp 379,967,965 Rp 2,490,901,103
14 Rp 2,540,901,103 Rp 457,362,199 Rp 2,998,263,302
15 Rp 3,048,263,302
PV = PRESENT VALUE OF A LOAN
Loan Amount Rp438,523.90
Annual Rate 4.75%
Month rate 0.3958%
Years 25
#Months 300
Monthly PMT $ 2,500.00
TABEL ANGSURAN PINJAMAN
Plafon 10,000,000
Tenor 12
Suku Bunga 1.00% 12%
Angsuran
Jumlah Bayar
Angsuran Ke- Pokok Bunga
0
1 Rp788,487.89 Rp100,000.00 Rp888,487.89
2 Rp796,372.77 Rp92,115.12 Rp888,487.89
3 Rp804,336.49 Rp84,151.39 Rp888,487.89
4 Rp812,379.86 Rp76,108.03 Rp888,487.89
5 Rp820,503.66 Rp67,984.23 Rp888,487.89
6 Rp828,708.69 Rp59,779.19 Rp888,487.89
7 Rp836,995.78 Rp51,492.11 Rp888,487.89
8 Rp845,365.74 Rp43,122.15 Rp888,487.89
9 Rp853,819.40 Rp34,668.49 Rp888,487.89
10 Rp862,357.59 Rp26,130.30 Rp888,487.89
11 Rp870,981.17 Rp17,506.72 Rp888,487.89
12 Rp879,690.98 Rp8,796.91 Rp888,487.89
Rp10,000,000.00 Rp661,854.64 Rp10,661,854.64
Saldo Pinjaman
10,000,000
9,211,512.11
8,415,139.35
7,610,802.85
6,798,423.00
5,977,919.34
5,149,210.65
4,312,214.87
3,466,849.13
2,613,029.73
1,750,672.14
879,690.98
-
TABEL ANGSURAN PINJAMAN
Plafon 9,000,000
Tenor 12
Suku Bunga 0.83% 10%
Angsuran
Jumlah Bayar
Angsuran Ke- Pokok Bunga Saldo Pinjaman
0 9,000,000
1 Rp750,000.00 Rp75,000.00 Rp825,000.00 8,250,000.00
2 Rp750,000.00 Rp75,000.00 Rp825,000.00 7,500,000.00
3 Rp750,000.00 Rp75,000.00 Rp825,000.00 6,750,000.00
4 Rp750,000.00 Rp75,000.00 Rp825,000.00 6,000,000.00
5 Rp750,000.00 Rp75,000.00 Rp825,000.00 5,250,000.00
6 Rp750,000.00 Rp75,000.00 Rp825,000.00 4,500,000.00
7 Rp750,000.00 Rp75,000.00 Rp825,000.00 3,750,000.00
8 Rp750,000.00 Rp75,000.00 Rp825,000.00 3,000,000.00
9 Rp750,000.00 Rp75,000.00 Rp825,000.00 2,250,000.00
10 Rp750,000.00 Rp75,000.00 Rp825,000.00 1,500,000.00
11 Rp750,000.00 Rp75,000.00 Rp825,000.00 750,000.00
12 Rp750,000.00 Rp75,000.00 Rp825,000.00 -
Rp9,000,000.00 Rp900,000.00 Rp9,900,000.00
