Spreadsheet Calculator 46590

Partial file snippet.

Sheet 1: Personal Loan & Auto Loan

	
	
	
	
	
	
	
	
		
 
		
		

		

		

		

		

		

		

		

	
	
		

		

		

		Ilustrative Loan Repayment Calculator 
( Auto and Personal Loans)
		
	
		

		

		

		

		
	
		

		Loan Details
		

		

		

		No.
		Instalment Amount
(BD)
		Principal 
(BD)
		Interest
(BD)
		Outstanding Balance
(BD)
	
	
		

		*Net Loan Amount (BD)
		25,000.000 
		

		

		1
		364.615 
		243.725 
		120.890 
		24,906.275 
	
	
		

		*Processing Fee (BD)
		150.000 
		

		

		2
		364.615 
		244.897 
		119.718 
		24,661.378 
	
	
		

		Total Loan Amount (BD)
		25,150.000 
		

		

		3
		364.615 
		246.074 
		118.541 
		24,415.304 
	
	
		

		*Tenor (months)
		84
		

		

		4
		364.615 
		247.257 
		117.358 
		24,168.047 
	
	
		

		*Nominal Interest Rate %
		5.7681 
		

		

		5
		364.615 
		248.445 
		116.170 
		23,919.602 
	
	
		

		Annual Percentage Rate (APR) %
		5.9500 
		

		

		6
		364.615 
		249.639 
		114.976 
		23,669.963 
	
	
		

		Monthly Instalment (BD)
		364.615 
		

		

		7
		364.615 
		250.839 
		113.776 
		23,419.123 
	
	
		

		Total Interest Amount (BD)
		5,477.660 
		

		

		8
		364.615 
		252.045 
		112.570 
		23,167.078 
	
	
		

		

		

		

		

		9
		364.615 
		253.257 
		111.358 
		22,913.821 
	
	
		

		* Mandatory fields; all other fields are automatically calculated
		

		

		

		10
		364.615 
		254.474 
		110.141 
		22,659.347 
	
	
		

		For details pertaining to Processing Fee, Insurance fee, Tenor, Interest rate and Annual Percentage rate (APR), kindly call our 24-hour Phone Banking unit on +973 17531532.
		

		

		11
		364.615 
		255.697 
		108.918 
		22,403.650 
	
	
		

		

		

		12
		364.615 
		256.926 
		107.689 
		22,146.724 
	
	
		

		

		

		13
		364.615 
		258.161 
		106.454 
		21,888.563 
	
	
		

		

		

		14
		364.615 
		259.402 
		105.213 
		21,629.161 
	
	
		

		Important Note
		

		

		

		15
		364.615 
		260.649 
		103.966 
		21,368.512 
	
	
		

		This calculator is for illustrative and general information purposes only and is not intended to provide specific financial or other advice. Please note that there may be other fees and charges applicable to your loan in addition to the fees and charges mentioned above which are stated in the Service & Price Guide available at SCB Bahrain branches and on our website. 

For details pertaining to our loan products, please visit any of our branches or call our 24-hour Phone Banking unit on +973 17531532. Standard Chartered Bank does not make any express or implied warranties or representations with respect to any information or results in connection with the calculator. All loans are granted at the sole discretion of Standard Chartered Bank.
		

		16
		364.615 
		261.902 
		102.713 
		21,106.610 
	
	
		

		

		17
		364.615 
		263.161 
		101.454 
		20,843.449 
	
	
		

		

		18
		364.615 
		264.426 
		100.189 
		20,579.023 
	
	
		

		

		19
		364.615 
		265.697 
		98.918 
		20,313.326 
	
	
		

		

		20
		364.615 
		266.974 
		97.641 
		20,046.352 
	
	
		

		

		21
		364.615 
		268.257 
		96.358 
		19,778.095 
	
	
		

		

		22
		364.615 
		269.547 
		95.068 
		19,508.549 
	
	
		

		

		23
		364.615 
		270.842 
		93.773 
		19,237.706 
	
	
		

		

		24
		364.615 
		272.144 
		92.471 
		18,965.562 
	
	
		

		

		25
		364.615 
		273.452 
		91.163 
		18,692.110 
	
	
		

		

		26
		364.615 
		274.767 
		89.848 
		18,417.343 
	
	
		

		

		27
		364.615 
		276.087 
		88.528 
		18,141.256 
	
	
		

		

		28
		364.615 
		277.415 
		87.200 
		17,863.841 
	
	
		

		

		29
		364.615 
		278.748 
		85.867 
		17,585.093 
	
	
		

		Version : September 2019
		

		

		

		30
		364.615 
		280.088 
		84.527 
		17,305.005 
	
	
		

		

		

		

		

		31
		364.615 
		281.434 
		83.181 
		17,023.571 
	
	
		

		

		

		

		

		32
		364.615 
		282.787 
		81.828 
		16,740.784 
	
	
		

		

		

		

		

		33
		364.615 
		284.146 
		80.469 
		16,456.638 
	
	
		

		

		

		

		

		34
		364.615 
		285.512 
		79.103 
		16,171.126 
	
	
		

		

		

		

		

		35
		364.615 
		286.884 
		77.731 
		15,884.242 
	
	
		

		

		

		

		

		36
		364.615 
		288.263 
		76.352 
		15,595.978 
	
	
		

		

		

		

		

		37
		364.615 
		289.649 
		74.966 
		15,306.329 
	
	
		

		

		

		

		

		38
		364.615 
		291.041 
		73.574 
		15,015.288 
	
	
		

		

		

		

		

		39
		364.615 
		292.440 
		72.175 
		14,722.848 
	
	
		

		

		

		

		

		40
		364.615 
		293.846 
		70.769 
		14,429.002 
	
	
		

		

		

		

		

		41
		364.615 
		295.258 
		69.357 
		14,133.743 
	
	
		

		

		

		

		

		42
		364.615 
		296.678 
		67.937 
		13,837.066 
	
	
		

		

		

		

		

		43
		364.615 
		298.104 
		66.511 
		13,538.962 
	
	
		

		

		

		

		

		44
		364.615 
		299.537 
		65.078 
		13,239.425 
	
	
		

		

		

		

		

		45
		364.615 
		300.976 
		63.639 
		12,938.449 
	
	
		

		

		

		

		

		46
		364.615 
		302.423 
		62.192 
		12,636.026 
	
	
		

		

		

		

		

		47
		364.615 
		303.877 
		60.738 
		12,332.149 
	
	
		

		

		

		

		

		48
		364.615 
		305.337 
		59.278 
		12,026.812 
	
	
		

		

		

		

		

		49
		364.615 
		306.805 
		57.810 
		11,720.006 
	
	
		

		

		

		

		

		50
		364.615 
		308.280 
		56.335 
		11,411.727 
	
	
		

		

		

		

		

		51
		364.615 
		309.762 
		54.853 
		11,101.965 
	
	
		

		

		

		

		

		52
		364.615 
		311.251 
		53.364 
		10,790.714 
	
	
		

		

		

		

		

		53
		364.615 
		312.747 
		51.868 
		10,477.968 
	
	
		

		

		

		

		

		54
		364.615 
		314.250 
		50.365 
		10,163.718 
	
	
		

		

		

		

		

		55
		364.615 
		315.761 
		48.854 
		9,847.957 
	
	
		

		

		

		

		

		56
		364.615 
		317.278 
		47.337 
		9,530.679 
	
	
		

		

		

		

		

		57
		364.615 
		318.803 
		45.812 
		9,211.875 
	
	
		

		

		

		

		

		58
		364.615 
		320.336 
		44.279 
		8,891.539 
	
	
		

		

		

		

		

		59
		364.615 
		321.876 
		42.739 
		8,569.664 
	
	
		

		

		

		

		

		60
		364.615 
		323.423 
		41.192 
		8,246.241 
	
	
		

		

		

		

		

		61
		364.615 
		324.977 
		39.638 
		7,921.264 
	
	
		

		

		

		

		

		62
		364.615 
		326.539 
		38.076 
		7,594.724 
	
	
		

		

		

		

		

		63
		364.615 
		328.109 
		36.506 
		7,266.615 
	
	
		

		

		

		

		

		64
		364.615 
		329.686 
		34.929 
		6,936.929 
	
	
		

		

		

		

		

		65
		364.615 
		331.271 
		33.344 
		6,605.658 
	
	
		

		

		

		

		

		66
		364.615 
		332.863 
		31.752 
		6,272.795 
	
	
		

		

		

		

		

		67
		364.615 
		334.463 
		30.152 
		5,938.332 
	
	
		

		

		

		

		

		68
		364.615 
		336.071 
		28.544 
		5,602.261 
	
	
		

		

		

		

		

		69
		364.615 
		337.686 
		26.929 
		5,264.574 
	
	
		

		

		

		

		

		70
		364.615 
		339.310 
		25.305 
		4,925.265 
	
	
		

		

		

		

		

		71
		364.615 
		340.940 
		23.675 
		4,584.324 
	
	
		

		

		

		

		

		72
		364.615 
		342.579 
		22.036 
		4,241.745 
	
	
		

		

		

		

		

		73
		364.615 
		344.226 
		20.389 
		3,897.519 
	
	
		

		

		

		

		

		74
		364.615 
		345.881 
		18.734 
		3,551.638 
	
	
		

		

		

		

		

		75
		364.615 
		347.543 
		17.072 
		3,204.095 
	
	
		

		

		

		

		

		76
		364.615 
		349.214 
		15.401 
		2,854.881 
	
	
		

		

		

		

		

		77
		364.615 
		350.892 
		13.723 
		2,503.989 
	
	
		

		

		

		

		

		78
		364.615 
		352.579 
		12.036 
		2,151.410 
	
	
		

		

		

		

		

		79
		364.615 
		354.274 
		10.341 
		1,797.137 
	
	
		

		

		

		

		

		80
		364.615 
		355.977 
		8.638 
		1,441.160 
	
	
		

		

		

		

		

		81
		364.615 
		357.688 
		6.927 
		1,083.472 
	
	
		

		

		

		

		

		82
		364.615 
		359.407 
		5.208 
		724.065 
	
	
		

		

		

		

		

		83
		364.615 
		361.135 
		3.480 
		362.931 
	
	
		

		

		

		

		

		84
		364.615 
		362.870 
		1.745 
		0.000 
	
	
		

		

		

		

		

		Total
		30,627.660 
		25,149.940 
		5,477.720

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet personal loan amp auto ilustrative repayment calculator and loans details no instalment amount bd principal interest outstanding balance net processing fee total tenor months nominal rate annual percentage apr monthly mandatory fields all other are automatically calculated for pertaining to insurance kindly call our hour phone banking unit on important note this is illustrative general information purposes only not intended provide specific financial or advice please that there may be fees charges applicable your in addition the mentioned above which stated service price guide available at scb bahrain branches website products visit any of standard chartered bank does make express implied warranties representations with respect results connection granted sole discretion version september...

Related files

Share

Help


		Ilustrative Loan Repayment Calculator ( Auto and Personal Loans)

Loan Details		No.	Instalment Amount (BD)	Principal (BD)	Interest (BD)	Outstanding Balance (BD)
*Net Loan Amount (BD)	25,000.000	1	364.615	243.725	120.890	24,906.275
*Processing Fee (BD)	150.000	2	364.615	244.897	119.718	24,661.378
Total Loan Amount (BD)	25,150.000	3	364.615	246.074	118.541	24,415.304
*Tenor (months)	84	4	364.615	247.257	117.358	24,168.047
*Nominal Interest Rate %	5.7681	5	364.615	248.445	116.170	23,919.602
Annual Percentage Rate (APR) %	5.9500	6	364.615	249.639	114.976	23,669.963
Monthly Instalment (BD)	364.615	7	364.615	250.839	113.776	23,419.123
Total Interest Amount (BD)	5,477.660	8	364.615	252.045	112.570	23,167.078
		9	364.615	253.257	111.358	22,913.821
* Mandatory fields; all other fields are automatically calculated		10	364.615	254.474	110.141	22,659.347
For details pertaining to Processing Fee, Insurance fee, Tenor, Interest rate and Annual Percentage rate (APR), kindly call our 24-hour Phone Banking unit on +973 17531532.		11	364.615	255.697	108.918	22,403.650
		12	364.615	256.926	107.689	22,146.724
		13	364.615	258.161	106.454	21,888.563
		14	364.615	259.402	105.213	21,629.161
*Important Note*		15	364.615	260.649	103.966	21,368.512
This calculator is for illustrative and general information purposes only and is not intended to provide specific financial or other advice. Please note that there may be other fees and charges applicable to your loan in addition to the fees and charges mentioned above which are stated in the Service & Price Guide available at SCB Bahrain branches and on our website. For details pertaining to our loan products, please visit any of our branches or call our 24-hour Phone Banking unit on +973 17531532. Standard Chartered Bank does not make any express or implied warranties or representations with respect to any information or results in connection with the calculator. All loans are granted at the sole discretion of Standard Chartered Bank.		16	364.615	261.902	102.713	21,106.610
		17	364.615	263.161	101.454	20,843.449
		18	364.615	264.426	100.189	20,579.023
		19	364.615	265.697	98.918	20,313.326
		20	364.615	266.974	97.641	20,046.352
		21	364.615	268.257	96.358	19,778.095
		22	364.615	269.547	95.068	19,508.549
		23	364.615	270.842	93.773	19,237.706
		24	364.615	272.144	92.471	18,965.562
		25	364.615	273.452	91.163	18,692.110
		26	364.615	274.767	89.848	18,417.343
		27	364.615	276.087	88.528	18,141.256
		28	364.615	277.415	87.200	17,863.841
		29	364.615	278.748	85.867	17,585.093
*Version : September 2019*		30	364.615	280.088	84.527	17,305.005
		31	364.615	281.434	83.181	17,023.571
		32	364.615	282.787	81.828	16,740.784
		33	364.615	284.146	80.469	16,456.638
		34	364.615	285.512	79.103	16,171.126
		35	364.615	286.884	77.731	15,884.242
		36	364.615	288.263	76.352	15,595.978
		37	364.615	289.649	74.966	15,306.329
		38	364.615	291.041	73.574	15,015.288
		39	364.615	292.440	72.175	14,722.848
		40	364.615	293.846	70.769	14,429.002
		41	364.615	295.258	69.357	14,133.743
		42	364.615	296.678	67.937	13,837.066
		43	364.615	298.104	66.511	13,538.962
		44	364.615	299.537	65.078	13,239.425
		45	364.615	300.976	63.639	12,938.449
		46	364.615	302.423	62.192	12,636.026
		47	364.615	303.877	60.738	12,332.149
		48	364.615	305.337	59.278	12,026.812
		49	364.615	306.805	57.810	11,720.006
		50	364.615	308.280	56.335	11,411.727
		51	364.615	309.762	54.853	11,101.965
		52	364.615	311.251	53.364	10,790.714
		53	364.615	312.747	51.868	10,477.968
		54	364.615	314.250	50.365	10,163.718
		55	364.615	315.761	48.854	9,847.957
		56	364.615	317.278	47.337	9,530.679
		57	364.615	318.803	45.812	9,211.875
		58	364.615	320.336	44.279	8,891.539
		59	364.615	321.876	42.739	8,569.664
		60	364.615	323.423	41.192	8,246.241
		61	364.615	324.977	39.638	7,921.264
		62	364.615	326.539	38.076	7,594.724
		63	364.615	328.109	36.506	7,266.615
		64	364.615	329.686	34.929	6,936.929
		65	364.615	331.271	33.344	6,605.658
		66	364.615	332.863	31.752	6,272.795
		67	364.615	334.463	30.152	5,938.332
		68	364.615	336.071	28.544	5,602.261
		69	364.615	337.686	26.929	5,264.574
		70	364.615	339.310	25.305	4,925.265
		71	364.615	340.940	23.675	4,584.324
		72	364.615	342.579	22.036	4,241.745
		73	364.615	344.226	20.389	3,897.519
		74	364.615	345.881	18.734	3,551.638
		75	364.615	347.543	17.072	3,204.095
		76	364.615	349.214	15.401	2,854.881
		77	364.615	350.892	13.723	2,503.989
		78	364.615	352.579	12.036	2,151.410
		79	364.615	354.274	10.341	1,797.137
		80	364.615	355.977	8.638	1,441.160
		81	364.615	357.688	6.927	1,083.472
		82	364.615	359.407	5.208	724.065
		83	364.615	361.135	3.480	362.931
		84	364.615	362.870	1.745	0.000
		Total	30,627.660	25,149.940	5,477.720

Related files

Share

Share to social media

Help

Login Area