2 suku bunga-1.xlsx - total DP angusran 445,650,000 177,660,663 14207000 per bulan 267,989,337 14207000 1 0.959508732 0.920657 0.8833784358868

2 suku bunga-1.xlsx - total DP angusran 445,650,000...

This preview shows page 1 - 6 out of 6 pages.

total 445,650,000 14207000 DP 177,660,663 ### angusran 14207000 per bulan 267,989,337 1 0.959508732 0.920657 0.8833784358868 88830331.5 78470799.29978 A 1 177,660,663 267,989,337 1 177,660,663 1 DP 2 14,207,000 942,518 13,264,482 254,724,855 0.9595 13,631,741 2 14,207,000 3 14,207,000 895,867 13,311,133 241,413,723 0.9206 13,078,964 3 14,207,000 4 14,207,000 849,052 13,357,948 228,055,775 0.8834 12,550,157 4 14,207,000 5 14,207,000 802,072 13,404,928 214,650,847 0.8476 12,041,986 5 14,207,000 6 14,207,000 754,927 13,452,073 201,198,774 0.8133 11,554,390 6 14,207,000 7 14,207,000 707,616 13,499,384 187,699,390 0.7804 11,086,538 7 14,207,000 8 14,207,000 660,139 13,546,861 174,152,529 0.7488 10,637,630 8 14,207,000 9 14,207,000 612,494 13,594,506 160,558,023 0.7184 10,206,899 9 14,207,000 10 14,207,000 564,683 13,642,317 146,915,706 0.6894 9,793,609 10 14,207,000 11 14,207,000 516,703 13,690,297 133,225,408 0.6614 9,397,053 11 14,207,000 12 14,207,000 468,554 13,738,446 119,486,962 0.6347 9,016,555 12 14,207,000 13 14,207,000 420,236 13,786,764 105,700,198 0.6090 8,651,463 13 14,207,000 14 14,207,000 371,748 13,835,252 91,864,945 0.5843 8,301,154 14 14,207,000 15 14,207,000 323,089 13,883,911 77,981,034 0.5606 7,965,030 15 14,207,000 16 14,207,000 274,259 13,932,741 64,048,294 0.5379 7,642,516 16 14,207,000 17 14,207,000 225,258 13,981,742 50,066,552 0.5162 7,333,061 17 14,207,000 18 14,207,000 176,084 14,030,916 36,035,636 0.4953 7,036,136 18 14,207,000 Angsuran per Bulan (Rp) Angsuran Bunga (Rp) Angsuran Pokok (Rp) Sisa Pinjaman (Rp) Tingkat Diskon Nilai Tunai Biaya SGU (Rp) Bulan Angsuran Angsuran per Bulan (Rp)
Image of page 1
19 14,207,000 126,737 14,080,263 21,955,373 0.4752 6,751,234 19 14,207,000 20 14,207,000 77,217 14,129,783 7,825,590 0.4560 6,477,868 20 14,207,000 21 14,207,000 27,523 14,179,477 -6,353,887 0.4375 6,215,571 21 14,207,000 22 14,207,000 -22,347 14,229,347 -20,583,234 0.4198 5,963,894 22 14,207,000 23 14,207,000 -72,391 14,279,391 -34,862,625 0.4028 5,722,409 23 14,207,000 24 14,207,000 -122,612 14,329,612 -49,192,237 0.3865 5,490,701 24 14,207,000 326,761,000 504,421,663 9,579,426 317,181,574 384,207,222 177,660,663 494,842,237
Image of page 2
3.27E+08 2 3 4 n 0.847609 0.8132885458437 0.780357 0.003517 44415166 22207582.875 22207583 37646709 18061172.783111 17329853 151508533.6 B C Tahun Saldo (Rp) Tahun 1
Image of page 3
Image of page 4
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 6 pages?

  • Fall '17

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture