Spreadsheet: 45839d1244634074-monthly-sum-markup
Sheet: Bank_Balance

Mark-up on R/F
bank1
Date | Days | Balance | Product | KIBOR | [NAME] | [NAME] | MARK UP
2008-07-01 00:00:00 | 2 | 96308964.16 | 192617928.32 | 0.1376 | 0.01465 | 0.15225 | 80345.42352526027
2008-07-03 00:00:00 | 1 | 99308964.16 | 99308964.16 | 0.1376 | 0.01465 | 0.15225 | 41424.08162564383
2008-07-04 00:00:00 | 10 | 99328147.49 | 993281474.9 | 0.1376 | 0.01465 | 0.15225 | 414320.8343932192
2008-07-14 00:00:00 | 1 | 99328347.49 | 99328347.49 | 0.1376 | 0.01465 | 0.15225 | 41432.16686397945
2008-07-15 00:00:00 | 7 | 99338343.19 | 695368402.3299999 | 0.1376 | 0.01465 | 0.15225 | 290054.3541225822
2008-07-22 00:00:00 | 2 | 99838343.19 | 199676686.38 | 0.1376 | 0.01465 | 0.15225 | 83289.7958941233
2008-07-24 00:00:00 | 5 | 95538343.19 | 477691715.95 | 0.1376 | 0.01465 | 0.15225 | 199256.3390503767
2008-07-29 00:00:00 | 2 | 93908271.01 | 187816542.02 | 0.1376 | 0.01465 | 0.15225 | 78342.65348642466
2008-07-31 00:00:00 | 1 | 98841311.12 | 98841311.12 | 0.1376 | 0.01465 | 0.15225 | 41229.01265210959
2008-08-01 00:00:00 | 1 | 98341311.12 | 98341311.12 | 0.1376 | 0.01465 | 0.15225 | 41020.45100827397
2008-08-02 00:00:00 | 2 | 99976200.01 | 199952400.02 | 0.1376 | 0.01465 | 0.15225 | 83404.8024740959
2008-08-04 00:00:00 | 1 | 99976327.51 | 99976327.51 | 0.1376 | 0.01465 | 0.15225 | 42475.87442026712
2008-08-05 00:00:00 | 6 | 99995510.84 | 599973065.04 | 0.1376 | 0.01465 | 0.15225 | 250262.7374036712
2008-08-11 00:00:00 | 9 | 99953535.84 | 899581822.5600001 | 0.1376 | 0.01465 | 0.15225 | 375236.5273555069
2008-08-20 00:00:00 | 3 | 99954235.84 | 299862707.52 | 0.1376 | 0.01465 | 0.15225 | 125079.7184107397
2008-08-23 00:00:00 | 2 | 99954500.84 | 199909001.68 | 0.1376 | 0.01465 | 0.15225 | 83386.70001583562
2008-08-25 00:00:00 | 1 | 96862038.84 | 96862038.84 | 0.1376 | 0.01465 | 0.15225 | 40403.41209147945
2008-08-26 00:00:00 | 1 | 98028704.84 | 98028704.84 | 0.1376 | 0.01465 | 0.15225 | 40890.0556490137
2008-08-27 00:00:00 | 1 | 97007204.84 | 97007204.84 | 0.1376 | 0.01465 | 0.15225 | 40463.96421065753
2008-08-28 00:00:00 | 2 | 96636604.84 | 193273209.68 | 0.1376 | 0.01465 | 0.15225 | 80618.75664049316
2008-08-30 00:00:00 | 2 | 98202424.84 | 196404849.68 | 0.1376 | 0.01465 | 0.15225 | 81925.03661309589
2008-09-01 00:00:00 | 3 | 98202424.84 | 294607274.52 | 0.1376 | 0.01465 | 0.15225 | 122887.5549196438
2008-09-04 00:00:00 | 6 | 98221608.17 | 589329649.02 | 0.1376 | 0.01465 | 0.15225 | 245436.4407213561
2008-09-10 00:00:00 | 1 | 98230085.37 | 98230085.37 | 0.1376 | 0.01465 | 0.15225 | 40974.05615776028
2008-09-11 00:00:00 | 2 | 98413018.37 | 196826036.74 | 0.1376 | 0.01465 | 0.15225 | 82100.72354428767
2008-09-13 00:00:00 | 2 | 99413018.37 | 198826036.74 | 0.1376 | 0.01465 | 0.15225 | 82934.97011963013
2008-09-15 00:00:00 | 1 | 96553118.37 | 96553118.37 | 0.1376 | 0.01465 | 0.15225 | 40274.55416940411
2008-09-16 00:00:00 | 4 | 99413145.87 | 397652583.48 | 0.1376 | 0.01465 | 0.15225 | 165870.152972137
2008-09-20 00:00:00 | 2 | 92713200.87 | 185426401.74 | 0.1376 | 0.01465 | 0.15225 | 77345.67031483562
2008-09-22 00:00:00 | 1 | 92713350.87 | 92713350.87 | 0.1376 | 0.01465 | 0.15225 | 38672.89772591096
2008-09-23 00:00:00 | 1 | 98424873.19 | 98424873.19 | 0.1376 | 0.01465 | 0.15225 | 41055.30669363698
2008-09-24 00:00:00 | 1 | 98149954.8 | 98149954.8 | 0.1376 | 0.01465 | 0.15225 | 40940.6318309589
2008-09-25 00:00:00 | 1 | 63729804.8 | 63729804.8 | 0.1376 | 0.01465 | 0.15225 | 26583.18570082192
2008-09-26 00:00:00 | 3 | 91957319.8 | 275871959.4 | 0.1376 | 0.01465 | 0.15225 | 115072.6186812329
2008-09-29 00:00:00 | 1 | 97957319.8 | 97957319.8 | 0.1376 | 0.01465 | 0.15225 | 40860.27928643835
2008-09-30 00:00:00 | 1 | 99957319.8 | 99957319.8 | 0.1376 | 0.01465 | 0.15225 | 41694.52586178082
2008-10-01 00:00:00 | 3 | 99957319.8 | 299871959.4 | 0.1399 | 0.015 | 0.1549 | 127260.7301672876
2008-10-04 00:00:00 | 2 | 99957319.8 | 199914639.6 | 0.1399 | 0.0174 | 0.1573 | 86154.99399747944
2008-10-06 00:00:00 | 7 | 99976503.13 | 699835521.91 | 0.1399 | 0.0174 | 0.1573 | 301600.3495792959
2008-10-13 00:00:00 | 2 | 99976603.13 | 199953206.26 | 0.1399 | 0.0174 | 0.1573 | 86171.61464300822
2008-10-15 00:00:00 | 1 | 99184581.03 | 99184581.03 | 0.1399 | 0.0174 | 0.1573 | 42744.47834525754
2008-10-16 00:00:00 | 1 | 99584581.03 | 99584581.03 | 0.1399 | 0.0174 | 0.1573 | 42916.86190690137
2008-10-17 00:00:00 | 1 | 99984581.03 | 99984581.03 | 0.1399 | 0.0174 | 0.1573 | 43089.2454685452
2008-10-18 00:00:00 | 3 | 97356581.03 | 292069743.09 | 0.1399 | 0.0174 | 0.1573 | 125870.0564056356
2008-10-21 00:00:00 | 1 | 91357672.61 | 91357672.61 | 0.1399 | 0.0174 | 0.1573 | 39371.40247000822
2008-10-22 00:00:00 | 1 | 94157672.61 | 94157672.61 | 0.1399 | 0.0174 | 0.1573 | 40578.08740151507
2008-10-23 00:00:00 | 6 | 99657672.61 | 597946035.66 | 0.1399 | 0.0174 | 0.1573 | 257690.1682447068
2008-10-29 00:00:00 | 1 | 99057788.37 | 99057788.37 | 0.1399 | 0.0174 | 0.1573 | 42689.8359194548
2008-10-30 00:00:00 | 2 | 99966792.75 | 199933585.5 | 0.1399 | 0.0174 | 0.1573 | 86163.15890178083
2008-11-01 00:00:00 | 3 | 99966792.75 | 299900378.25 | 0.1399 | 0.0174 | 0.1573 | 129244.7383526712
2008-11-04 00:00:00 | 8 | 99985976.08 | 799887808.64 | 0.1399 | 0.0174 | 0.1573 | 344718.7734221151
2008-11-12 00:00:00 | 3 | 99986076.08 | 299958228.24 | 0.1399 | 0.0174 | 0.1573 | 129269.6693209644
2008-11-15 00:00:00 | 2 | 99986076.08 | 199972152.16 | 0.1399 | 0.0174 | 0.1573 | 86179.77954730959
2008-11-17 00:00:00 | 1 | 98240362.08 | 98240362.08 | 0.1423 | 0.02 | 0.1623 | 43683.31716598356
2008-11-18 00:00:00 | 8 | 99840362.08 | 798722896.64 | 0.1423 | 0.02 | 0.1623 | 355158.1537662246
2008-11-26 00:00:00 | 5 | 99963212.08 | 499816060.4 | 0.1423 | 0.02 | 0.1623 | 222246.9769943014
2008-12-01 00:00:00 | 2 | 99963212.08 | 199926424.16 | 0.1423 | 0.02 | 0.1623 | 88898.79079772055
2008-12-03 00:00:00 | 1 | 99958711.08 | 99958711.08 | 0.1423 | 0.02 | 0.1623 | 44447.39399529863
2008-12-04 00:00:00 | 15 | 99977894.41 | 1499668416.15 | 0.1423 | 0.02 | 0.1623 | 666838.860112726
2008-12-19 00:00:00 | 1 | 99978554.41 | 99978554.41 | 0.1423 | 0.02 | 0.1623 | 44456.21748148767
2008-12-20 00:00:00 | 4 | 99978754.41 | 399915017.64 | 0.1423 | 0.02 | 0.1623 | 177825.2256519781
2008-12-24 00:00:00 | 2 | 99378754.41 | 198757508.82 | 0.1423 | 0.02 | 0.1623 | 88379.02378489314
2008-12-26 00:00:00 | 3 | 99962087.41 | 299886262.23 | 0.1423 | 0.02 | 0.1623 | 133346.6859176137
2008-12-29 00:00:00 | 1 | 94315038.41 | 94315038.41 | 0.1423 | 0.02 | 0.1623 | 41937.89242176164
2008-12-30 00:00:00 | 1 | 93576976.13 | 93576976.13 | 0.1423 | 0.02 | 0.1623 | 41609.70746821644
2008-12-31 00:00:00 | 1 | 97456276.13 | 97456276.13 | 0.1423 | 0.02 | 0.1623 | 44184.41744081918
2009-01-01 00:00:00 | 1 | 97456276.13 | 97456276.13 | 0.14486 | 0.03 | 0.17486 | 46688.23135367616
2009-01-02 00:00:00 | 3 | 99456276.13 | 298368828.39 | 0.14486 | 0.03 | 0.17486 | 142939.1050199326
2009-01-05 00:00:00 | 10 | 99475459.47 | 994754594.7 | 0.14486 | 0.03 | 0.17486 | 476555.5847376492
2009-01-15 00:00:00 | 1 | 99469766.97 | 99469766.97 | 0.14486 | 0.03 | 0.17486 | 47652.83137636766
2009-01-16 00:00:00 | 1 | 99705139.27 | 99705139.27 | 0.14486 | 0.03 | 0.17486 | 47765.59082945808
2009-01-17 00:00:00 | 2 | 99618440.27 | 199236880.54 | 0.14486 | 0.03 | 0.17486 | 95448.11214034082
2009-01-19 00:00:00 | 1 | 99618495.27 | 99618495.27 | 0.14486 | 0.03 | 0.17486 | 47724.08241893753
2009-01-20 00:00:00 | 1 | 99473828.27 | 99473828.27 | 0.14486 | 0.03 | 0.17486 | 47654.7770172389
2009-01-21 00:00:00 | 1 | 99342303.1 | 99342303.1 | 0.14486 | 0.03 | 0.17486 | 47591.76745223561
2009-01-22 00:00:00 | 2 | 99350330.6 | 198700661.2 | 0.14486 | 0.03 | 0.17486 | 95191.22634912876
2009-01-24 00:00:00 | 2 | 99352630.6 | 198705261.2 | 0.14486 | 0.03 | 0.17486 | 95193.43006419725
2009-01-26 00:00:00 | 3 | 99352830.6 | 298058491.8 | 0.14486 | 0.03 | 0.17486 | 142790.4325373918
2009-01-29 00:00:00 | 2 | 98910330.6 | 197820661.2 | 0.14486 | 0.03 | 0.17486 | 94769.64607515615
2009-01-31 00:00:00 | 1 | 98910540.6 | 98910540.6 | 0.14486 | 0.03 | 0.17486 | 47384.92364196164
2009-02-01 00:00:00 | 1 | 98910540.6 | 98910540.6 | 0.14486 | 0.03 | 0.17486 | 47384.92364196164
2009-02-02 00:00:00 | 2 | 98920540.6 | 197841081.2 | 0.14486 | 0.03 | 0.17486 | 94779.42865378628
2009-02-04 00:00:00 | 7 | 98173301.44 | 687213110.0799999 | 0.14486 | 0.03 | 0.17486 | 329222.1491194213
2009-02-11 00:00:00 | 5 | 98755025.77 | 493775128.85 | 0.14486 | 0.03 | 0.17486 | 236552.1069334548
2009-02-16 00:00:00 | 2 | 98750906.77 | 197501813.54 | 0.14486 | 0.03 | 0.17486 | 94616.89620713533
2009-02-18 00:00:00 | 8 | 98776296.57 | 790210372.56 | 0.14486 | 0.03 | 0.17486 | 378564.8924543606
2009-02-26 00:00:00 | 3 | 98784324.57 | 296352973.71 | 0.14486 | 0.03 | 0.17486 | 141973.3725559742
2009-03-01 00:00:00 | 2 | 98784324.57 | 197568649.14 | 0.14486 | 0.03 | 0.17486 | 94648.91503731614
2009-03-03 00:00:00 | 1 | 98784544.57 | 98784544.57 | 0.14486 | 0.03 | 0.17486 | 47324.56291372656
2009-03-04 00:00:00 | 5 | 98805047.91 | 494025239.55 | 0.14486 | 0.03 | 0.17486 | 236671.9270896246
2009-03-09 00:00:00 | 2 | 98806847.91 | 197613695.82 | 0.14486 | 0.03 | 0.17486 | 94670.49548242519
2009-03-11 00:00:00 | 1 | 99390182.24 | 99390182.24 | 0.14486 | 0.03 | 0.17486 | 47614.70483968876
2009-03-12 00:00:00 | 1 | 98740182.24 | 98740182.24 | 0.14486 | 0.03 | 0.17486 | 47303.31031914082
2009-03-13 00:00:00 | 1 | 98735437.24 | 98735437.24 | 0.14486 | 0.03 | 0.17486 | 47301.03713914081
2009-03-14 00:00:00 | 10 | 99999437.24 | 999994372.4 | 0.14486 | 0.03 | 0.17486 | 479065.7971448328
2009-03-24 00:00:00 | 1 | 99999899.83 | 99999899.83 | 0.14486 | 0.03 | 0.17486 | 47906.80132677753
2009-03-25 00:00:00 | 1 | 98889999.95 | 98889999.95 | 0.14486 | 0.03 | 0.17486 | 47375.0832637178
2009-03-26 00:00:00 | 1 | 98161434.95 | 98161434.95 | 0.14486 | 0.03 | 0.17486 | 47026.05072700547
2009-03-27 00:00:00 | 5 | 98836246.54 | 494181232.7 | 0.14486 | 0.03 | 0.17486 | 236776.148492937
2009-04-01 00:00:00 | 1 | 97356246.54 | 97356246.54 | 0.14486 | 0.03 | 0.17486 | 46640.31032872439
2009-04-02 00:00:00 | 1 | 97361675.04 | 97361675.04 | 0.14486 | 0.03 | 0.17486 | 46642.91095203945
2009-04-03 00:00:00 | 1 | 95847275.04 | 95847275.04 | 0.14486 | 0.03 | 0.17486 | 45917.40962601206
2009-04-04 00:00:00 | 7 | 95866458.38 | 671065208.66 | 0.14486 | 0.03 | 0.17486 | 321486.1983185961
2009-04-11 00:00:00 | 6 | 93756192.71 | 562537156.26 | 0.14486 | 0.03 | 0.17486 | 269493.8277907496
2009-04-17 00:00:00 | 4 | 94240374.01 | 376961496.04 | 0.14486 | 0.03 | 0.17486 | 180590.3758837107
2009-04-21 00:00:00 | 2 | 94310902.21 | 188621804.42 | 0.14486 | 0.03 | 0.17486 | 90362.76361885258
2009-04-23 00:00:00 | 1 | 98734820.37 | 98734820.37 | 0.14486 | 0.03 | 0.17486 | 47300.74161615945
2009-04-24 00:00:00 | 1 | 97260499.41 | 97260499.41 | 0.14486 | 0.03 | 0.17486 | 46594.44089543178
2009-04-25 00:00:00 | 2 | 99394784.83 | 198789569.66 | 0.14486 | 0.03 | 0.17486 | 95233.81959108931
2009-04-27 00:00:00 | 1 | 99310242.43 | 99310242.43 | 0.14486 | 0.03 | 0.17486 | 47576.40819536931
2009-04-28 00:00:00 | 1 | 97405287.5 | 97405287.5 | 0.14486 | 0.03 | 0.17486 | 46663.80430753424
2009-04-29 00:00:00 | 1 | 98687062.44 | 98687062.44 | 0.14486 | 0.03 | 0.17486 | 47277.86229659835
2009-04-30 00:00:00 | 1 | 99883666.85 | 99883666.85 | 0.14486 | 0.03 | 0.17486 | 47851.11776819452
2009-05-01 00:00:00 | 3 | 99883666.85 | 299651000.55 | 0.14486 | 0.03 | 0.17486 | 143553.3533045835
2009-05-04 00:00:00 | 1 | 99999220.79 | 99999220.79 | 0.14486 | 0.03 | 0.17486 | 47906.47602010795
2009-05-05 00:00:00
 | 296 |  | 29167410906.12001 |  |  |  | 13035555.01457443