44 - DashBoard Financial

Prévia do material em texto

data
		KPI	Base	Corresp:	Current	Proportionate	Proportionate	Variance		Variance		Variance		Target
			 	Month	Month	Target	Target	with Base		with Corresp. Month		with Target		December
			31.12.2014	31.08.2014	31.08.2015	31.08.2015	30.09.2015	Amount 	%	Amount	%	Amount	%	2015	Short Name
		Absolute Deposit	6266.495	0.000	8359.874	6389.109	6526.867	2093.379	33.41%	8359.874	0.0%	1970.765	30.85%	6966.227	Abs. Deposit
		CASA Deposit	5407.551	3934.188	4160.844	5387.456	5507.375	-1246.707	-23.05%	226.656	5.8%	-1226.612	-22.77%	5893.219	CASA Deposit
		Average Deposit	5433.827	5482.240	5791.833	5862.533	5930.529	358.006	6.59%	309.593	5.6%	-70.700	-1.21%	6206.570	Average Deposit
		Weekly Deposit 10-09-2015	6266.495	4908.910	8776.695	6389.109	6526.867	2510.200	40.06%	3867.785	78.8%	2387.586	37.37%	6966.227	Week. Dep. 10-09
		No of Current A/Cs Opened during Month	2280.000	20.000	41.000	190.000	190.000	-2239.000	-98.20%	21.000	105.0%	-149.000	-78.42%	2280.000	A/Cs Opened during Month
		No of Current A/cs Opened Progressive	157.000	340.000	263.000	2280.000	2280.000	106.000	67.52%	-77.000	-22.6%	-2017.000	-88.46%	2280.000	A/cs Opened Progressive
		Number of Depositors Accounts (CASA)	0.000	0.000	0.000	0.000	0.000	0.000	0.00%	0.000	0.0%	0.000	0.00%	0.000	Dep.Accounts (CASA)
		Profit/Loss	-26.512	-13.202	32.370	25.347	28.869	58.882	-222.09%	45.572	-345.2%	7.022	27.71%	39.416	Profit/Loss
		Advances	1220.997	1135.671	1224.341	1281.457	1280.020	3.344	0.27%	88.670	7.8%	-57.116	-4.46%	1311.686	Advances
		Performing Adances	0.000	0.000	0.000	0.000	0.000	0.000	0.00%	0.000	0.0%	0.000	0.00%	0.000	Performing Adances
		Classified Advances	361.963	365.632	352.939	280.122	260.898	-9.024	-2.49%	-12.693	-3.5%	72.817	25.99%	239.201	Classified Advances
		Non Fund Base Advances	4252.174	389.194	337.641	4677.391	4730.543	-3914.533	-92.06%	-51.553	-13.2%	-4339.750	-92.78%	4890.000	Non Fund Base Adv.
		Non Fund Base Income	103.716	68.133	75.644	88.603	99.679	-28.072	-27.07%	7.511	11.0%	-12.959	-14.63%	132.905	Non Fund Base Income
		Home Remittance	25.082	6.832	33.172	18.393	20.693	8.090	32.25%	26.340	385.5%	14.779	80.35%	27.590	Home Remittance
		Cost of Fund	0.468	0.450	0.307	0.373	0.373	-0.161	-34.40%	-0.143	-31.9%	-0.066	-17.78%	0.370	Cost of Fund
		Intermediation Cost	0.360	0.303	0.260	0.295	0.292	-0.100	-27.71%	-0.043	-14.1%	-0.034	-11.67%	0.282	Intermediation Cost
		Imports	1473.237	1473.237	0.000	1080.374	1215.421	-1473.237	-100.00%	-1473.237	-100.0%	-1080.374	-100.00%	1620.561	Imports
		Exports	78.792	76.044	2.252	63.034	70.913	-76.540	-97.14%	-73.792	-97.0%	-60.782	-96.43%	94.550	Exports
		NBP Adv: Sal: O/S	128.208	116.773	137.208	143.019	146.402	9.000	7.02%	20.435	17.5%	-5.811	-4.06%	156.548	NBP Adv: Sal: O/S
		Overdue Adv: Sal: over 90 Days	12.246	11.138	12.362	10.613	10.409	0.116	0.95%	1.224	11.0%	1.749	16.48%	9.796	Adv: Sal: over 90 Days
		Agr: Finance O/S	5.060	5.138	4.750	11.629	12.451	-0.310	-6.13%	-0.388	-7.6%	-6.879	-59.16%	14.914	Agr: Finance O/S
		NBP Karobar O/S	0.000	0.000	0.000	0.000	0.000	0.000	0.00%	0.000	0.0%	0.000	0.00%	0.000	NBP Karobar O/S
		Recovery of Stuck-up	0.000	0.000	0.000	0.000	0.000	0.000	0.00%	0.000	0.0%	0.000	0.00%	0.000	Recovery of Stuck-up
		Recovery in Charge Off A/Cs	0.000	0.000	0.000	0.000	0.000	0.000	0.00%	0.000	0.0%	0.000	0.00%	0.000	Recovery in Charge Off A/Cs
		Write Off	0.000	0.000	0.000	0.000	0.000	0.000	0.00%	0.000	0.0%	0.000	0.00%	0.000	Write Off
		Income	560.924	409.789	345.675	415.293	469.806	-215.249	-38.37%	-64.114	-15.6%	-69.618	-16.76%	636.325	Income
		Expenditure Excluding Administrative Exp.	346.730	271.056	177.085	222.144	252.160	-169.645	-48.93%	-93.971	-34.7%	-45.059	-20.28%	345.207	Exp.Excl. Admin. Exp.
		Personal Expenses	158.910	107.095	95.576	115.267	129.675	-63.334	-39.86%	-11.519	-10.8%	-19.691	-17.08%	172.900	Personal Expenses
		Other Expenses	81.796	44.840	40.643	52.535	59.101	-41.153	-50.31%	-4.197	-9.4%	-11.892	-22.64%	78.802	Other Expenses
calculations
		KPI	KPI selection	Button Selection
	Base Month (31/12/2014)	Absolute Deposit	13	Base Month (31/12/2014)
	Corresp. Month (31/08/2014)	CASA Deposit	Non Fund Base Income	1
	Target (31/08/2015)	Average Deposit
		Weekly Deposit 10-09-2015
		No of Current A/Cs Opened during Month
		No of Current A/cs Opened Progressive
		Number of Depositors Accounts (CASA)
		Profit/Loss
		Advances
		Performing Adances
		Classified Advances
		Non Fund Base Advances
		Non Fund Base Income
		Home Remittance
		Cost of Fund
		Intermediation Cost
		Imports
		Exports
		NBP Adv: Sal: O/S
		Overdue Adv: Sal: over 90 Days
		Agr: Finance O/S
		NBP Karobar O/S
		Recovery of Stuck-up
		Recovery in Charge Off A/Cs
		Write Off
		Income
		Expenditure Excluding Administrative Exp.
		Personal Expenses
		Other Expenses
selected data
					Base/Corresp/Target Data								short name
			KPI Selected	Current Month	Base	Current Month	Base Month	Corresponding Month	target 31/08/2015	vs target 31/08/2015	var %	Variance with Base	Non Fund Base Income
			Non Fund Base Income	75.644	103.716	75.644	103.716	68.133	88.6033333333	0.8537376321	-27%	-28.072	(vs 31/08/2015)
				Current: 		88.6033333333	88.6033333333	88.6033333333	88.60	0.1462623679
				76						85.37%
			Diagram
			0	0.09	1	ERROR:#N/A	ERROR:#N/A
			0.2
			0.2
images
		Base Month
		Corresp. Month
		Target Month
								Current Month	Base Month	Corresp. Month	Target Month
								8/31/15	 31/12/2014	8/31/14	8/31/15
dashboard
-27%	-27%	2
2
2
1
2
1
1
2
1
1
1
4
6
1
1
4
4
3
6
2
2
6
2
5
1
3
0.09	1	1	-27%	
-27%	5
2
2
2
1
2
1
1
2
1
1
1
4
6
1
1
4
4
3
6
2
2
6
2
5
1
3
0.09	#N/A	1	-27%	-27%	5
2
2
1
2
1
1
2
1
1
1
4
6
1
1
4
4
3
6
2
2
6
2
5
1
3
0.09	#N/A	1	Variance with Base	
Variance with Base	-28.072000000000017	
0.85373763214326004	0.14626236785673996	
Current Month	Base	75.643999999999991	
Amounts	
Current Month	Base Month	Corresponding Month	75.643999999999991	103.71600000000001	68.13300000000001	Target	88.603333333333339	88.603333333333339	88.603333333333339	
Current: 
76
(vs 31/08/2015)
Non Fund Base Income
Base Month (31/12/2014)
Corresp. Month (31/08/2014)
Target (31/08/2015)
85,37%
Non Fund Base Income
88,60
Target:
PDF
Base Month
Current MonthBase MonthCorresp. MonthTarget Month
31/08/2015 31/12/201431/08/201431/08/2015
Base Month
Current MonthBase MonthCorresp. MonthTarget Month
31/08/2015 31/12/201431/08/201431/08/2015