Tugas mata kuliah fisika 1 "Perhitungan Bunga Bank"
3
Hari Saldo Bunga 1-Nov-12 Rp 17,807,199.00 Rp 609.84 2-Nov-12 Rp 17,807,199.00 Rp 609.84 3-Nov-12 Rp 17,657,499.00 Rp 604.71 4-Nov-12 Rp 17,657,499.00 Rp 604.71 5-Nov-12 Rp 17,657,499.00 Rp 604.71 6-Nov-12 Rp 17,657,499.00 Rp 604.71 7-Nov-12 Rp 17,657,499.00 Rp 604.71 8-Nov-12 Rp 17,657,499.00 Rp 604.71 9-Nov-12 Rp 17,657,499.00 Rp 604.71 10-Nov-12 Rp 17,556,499.00 Rp 601.25 11-Nov-12 Rp 17,556,499.00 Rp 601.25 12-Nov-12 Rp 17,556,499.00 Rp 601.25 13-Nov-12 Rp 17,287,699.00 Rp 592.04 14-Nov-12 Rp 17,107,899.00 Rp 585.89 15-Nov-12 Rp 17,107,899.00 Rp 585.89 16-Nov-12 Rp 17,107,899.00 Rp 585.89 17-Nov-12 Rp 17,007,899.00 Rp 582.46 18-Nov-12 Rp 15,608,329.00 Rp 534.53 19-Nov-12 Rp 15,293,499.00 Rp 523.75 20-Nov-12 Rp 15,093,499.00 Rp 516.90 21-Nov-12 Rp 15,093,499.00 Rp 516.90 22-Nov-12 Rp 19,900,329.00 Rp 681.52 23-Nov-12 Rp 19,900,329.00 Rp 681.52 24-Nov-12 Rp 19,800,329.00 Rp 678.09 25-Nov-12 Rp 19,800,329.00 Rp 678.09 26-Nov-12 Rp 19,589,209.00 Rp 670.86 27-Nov-12 Rp 19,789,209.00 Rp 677.71 28-Nov-12 Rp 19,188,209.00 Rp 657.13 29-Nov-12 Rp 16,492,959.00 Rp 564.83 30-Nov-12 Rp 16,282,959.00 Rp 557.64 Rp 18,128.03 Keterangan : 2. Rum usbungatotal : SUM (C4:C34) BungaTotal M etode Perhitungan Real Tim e O nline Bank M andiri Berdasarkan Saldo Harian 1. Rum usperhitungan bungaharian : =IF(B4>=10000000;B4*0,0125/365;B4*0,01/365) Nam aKelom pok: E=M C2 Anggota: M ichelle Lim antara2012-043-022dan AureliaBudiw an 2012-043-022
-
Upload
maynard-anderson -
Category
Documents
-
view
431 -
download
10
Transcript of Tugas mata kuliah fisika 1 "Perhitungan Bunga Bank"
Hari Saldo Bunga1-Nov-12 Rp 17,807,199.00 Rp 609.842-Nov-12 Rp 17,807,199.00 Rp 609.843-Nov-12 Rp 17,657,499.00 Rp 604.714-Nov-12 Rp 17,657,499.00 Rp 604.715-Nov-12 Rp 17,657,499.00 Rp 604.716-Nov-12 Rp 17,657,499.00 Rp 604.717-Nov-12 Rp 17,657,499.00 Rp 604.718-Nov-12 Rp 17,657,499.00 Rp 604.719-Nov-12 Rp 17,657,499.00 Rp 604.7110-Nov-12 Rp 17,556,499.00 Rp 601.2511-Nov-12 Rp 17,556,499.00 Rp 601.2512-Nov-12 Rp 17,556,499.00 Rp 601.2513-Nov-12 Rp 17,287,699.00 Rp 592.0414-Nov-12 Rp 17,107,899.00 Rp 585.8915-Nov-12 Rp 17,107,899.00 Rp 585.8916-Nov-12 Rp 17,107,899.00 Rp 585.8917-Nov-12 Rp 17,007,899.00 Rp 582.4618-Nov-12 Rp 15,608,329.00 Rp 534.5319-Nov-12 Rp 15,293,499.00 Rp 523.7520-Nov-12 Rp 15,093,499.00 Rp 516.9021-Nov-12 Rp 15,093,499.00 Rp 516.9022-Nov-12 Rp 19,900,329.00 Rp 681.5223-Nov-12 Rp 19,900,329.00 Rp 681.5224-Nov-12 Rp 19,800,329.00 Rp 678.0925-Nov-12 Rp 19,800,329.00 Rp 678.0926-Nov-12 Rp 19,589,209.00 Rp 670.8627-Nov-12 Rp 19,789,209.00 Rp 677.7128-Nov-12 Rp 19,188,209.00 Rp 657.13
29-Nov-12 Rp 16,492,959.00 Rp 564.8330-Nov-12 Rp 16,282,959.00 Rp 557.64
Rp 18,128.03
Keterangan :
2. Rumus bunga total : SUM(C4:C34)
Bunga Total
Metode Perhitungan Real Time Online Bank MandiriBerdasarkan Saldo Harian
1. Rumus perhitungan bunga harian : =IF(B4>=10000000;B4*0,0125/365;B4*0,01/365)
Nama Kelompok : E=MC2
Anggota : Michelle Limantara 2012-043-022 dan Aurelia Budiwan 2012-043-022
Hari Saldo Bunga1-Nov-12 Rp 1,174,715.17 Rp 32.182-Nov-12 Rp 1,174,715.17 Rp 32.183-Nov-12 Rp 1,174,715.17 Rp 32.184-Nov-12 Rp 1,174,715.17 Rp 32.185-Nov-12 Rp 1,174,715.17 Rp 32.186-Nov-12 Rp 914,454.94 Rp 0.007-Nov-12 Rp 914,454.94 Rp 0.008-Nov-12 Rp 914,454.94 Rp 0.009-Nov-12 Rp 914,454.94 Rp 0.0010-Nov-12 Rp 914,454.94 Rp 0.0011-Nov-12 Rp 914,454.94 Rp 0.0012-Nov-12 Rp 914,454.94 Rp 0.0013-Nov-12 Rp 914,454.94 Rp 0.0014-Nov-12 Rp 914,454.94 Rp 0.0015-Nov-12 Rp 914,454.94 Rp 0.0016-Nov-12 Rp 914,454.94 Rp 0.0017-Nov-12 Rp 914,454.94 Rp 0.0018-Nov-12 Rp 914,454.94 Rp 0.0019-Nov-12 Rp 107,971.94 Rp 0.0020-Nov-12 Rp 107,971.94 Rp 0.0021-Nov-12 Rp 107,971.94 Rp 0.0022-Nov-12 Rp 107,971.94 Rp 0.0023-Nov-12 Rp 107,971.94 Rp 0.0024-Nov-12 Rp 107,971.94 Rp 0.0025-Nov-12 Rp 106,971.94 Rp 0.0026-Nov-12 Rp 106,971.94 Rp 0.0027-Nov-12 Rp 1,406,971.94 Rp 38.5528-Nov-12 Rp 1,606,971.94 Rp 44.0329-Nov-12 Rp 1,606,971.94 Rp 44.0330-Nov-12 Rp 1,796,971.94 Rp 49.23
Rp 336.75
Keterangan :
2. Rumus bunga total : SUM(C4:C34)
Bunga Total
Metode Perhitungan Real Time Online Bank Mandiri
Berdasarkan Saldo Harian
1. Rumus perhitungan bunga harian : =IF(B4<=1000000,B4*0,IF(B4<=10000000,B4*0.01/365))
