Company Overview - pabcbank

pabcbank

Valuation

Period		3Q24E	4Q24E	FY24E	1Q25E	2Q25E	3Q25E	4Q25E	FY25E	FY26E	FY27E	FY28E	FY29E
Revenue
YoY %
EBITDA
EBITDA Margin %
Net Profit
Net Profit Margin %
Free Cash Flow

Valuation		Equity Value(Rs.Million)	Price per Share (Rs.)	Adjustment	Adjusted Valuation
Residual Income Method				%
Price to Earnings				%
Price to Book Value				%
Price to Sales				%
EV to EBITDA				%
Justified P/BV Multiple Method				%
Blended Valuation

Options

Checkbox

ASSETS		2024 to 2029
Placements with banks	YoY%	nan
Reverse repurchase agreements	YoY%	-100
Financial assets recognised through profit or loss – measured at fair value	YoY%	0
Financial assets at amortised cost – Loans and advances to other customers	YoY%	-8.9
Financial assets at amortised cost – Debt and other financial instruments	YoY%	0
Financial assets - fair value through other comprehensive income	YoY%	0
LIABILITIES		2024 to 2029
Due to banks	YoY%	44.9
Securities sold under repurchase agreements	YoY%	0
Financial liabilities at amortised cost – due to depositors	YoY%	7.9
Financial liabilities at amortised cost – other borrowings	YoY%	nan
- due to debt securities holders	YoY%	0
REVENUE		2024 to 2029
Interest Income	- % Avg Int. Earning Assets	18.4
Fee & Commission Income	- YoY%	-12.3
Other Operating Income	- YoY%	-129.2
COSTS		2024 to 2029
Interest Expense	- as a % Avg Int. Earning Liabilities	14.1
Fee & Commission Expenses	% of Fee & Commission Income	3.6
Impairment Charge
Other Operating Expenses	Cost to Operating Income ratio	48.3
VAT on financial services	% of PBT on Financial Services	2.5
Social Security Levy	% of PBT on Financial Services	0
Tax rate	%	20.3

	Rs. (Millions)	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
1	Placements with banks	0.0	0.0	0.0	0.0	0.0	0	0	200.2
	YoY%	0%	0%	nan%	-100%	nan%	0%	nan%	nan%
SCO1	Placements with banks	0.0	0.0	0.0	0.0	0.0
	LY YoY%	0%	0%	nan%	-100%	nan%				nan%	nan%	nan%	nan%	nan%	nan%
SCO3	Placements with banks	0.0	0.0	0.0	0.0	0.0
	FL YoY%	0%	0%	nan%	-100%	nan%				nan%	nan%	nan%	nan%	nan%	nan%

2	Reverse repurchase agreements	0.0	2,003.3	0.0	4,511.6	1,000.8	2003.3	0	500.6
	YoY	0%	0%	-100%	nan%	nan%	0%	-100%	nan%
SCO1	Reverse repurchase agreements	0.0	2,003.3	0.0	4,511.6	1,000.8
	LY YoY%	0%	0%	-100%	nan%	nan%				-100%		-100%	-100%	-100%	-100%	-100%
SCO3	Reverse repurchase agreements	0.0	2,003.3	0.0	4,511.6	1,000.8
	FL YoY%	0%	0%	-100%	nan%	nan%				-100%	-100%	-100%	-100%	-100%	-100%

3	Financial assets recognised through profit or loss – measured at fair value	0.0	2,239.8	4,277.6	7,428.9	4,188.0	2239.8	33470.2	14646.0
	YoY	0%	0%	0%	-68.6%	-87.5%	0%	943787.0%	275.9%
SCO1	Financial assets recognised through profit or loss – measured at fair value	0.0	2,239.8	4,277.6	7,428.9	4,188.0
	LY YoY%	0%	0%	0%	-68.6%	-87.5%				0%		0%	0%	0%	0%	0%
SCO3	Financial assets recognised through profit or loss – measured at fair value	0.0	2,239.8	4,277.6	7,428.9	4,188.0
	FL YoY%	0%	0%	0%	-68.6%	-87.5%				0%	0%	0%	0%	0%	0%

4	Financial assets at amortised cost – Loans and advances to other customers	142,369.2	144,148.1	131,296.1	137,274.3	139,502.4	144148.1	133926.1	132138.0
	YoY	0%	0%	-8.9%	-3.1%	4.2%	0%	-10.8%	-9.4%
SCO1	Financial assets at amortised cost – Loans and advances to other customers	142,369.2	144,148.1	131,296.1	137,274.3	139,502.4
	LY YoY%	0%	0%	-8.9%	-3.1%	4.2%				-8.9%		-8.9%	-8.9%	-8.9%	-8.9%	-8.9%
SCO3	Reverse repurchase agreements	142,369.2	144,148.1	131,296.1	137,274.3	139,502.4
	FL YoY%	0%	0%	-8.9%	-3.1%	4.2%				-8.9%	-8.9%	-8.9%	-8.9%	-8.9%	-8.9%

5	Financial assets at amortised cost – Debt and other financial instruments	34,110.6	40,195.0	80,216.8	72,095.6	87,182.3	40195.0	38788.7	58352.8
	YoY	0%	0%	0%	148.2%	124.8%	0%	21.2%	55.0%
SCO1	Financial assets at amortised cost – Debt and other financial instruments	34,110.6	40,195.0	80,216.8	72,095.6	87,182.3
	LY YoY%	0%	0%	0%	148.2%	124.8%				0%		0%	0%	0%	0%	0%
SCO3	Financial assets at amortised cost – Debt and other financial instruments	34,110.6	40,195.0	80,216.8	72,095.6	87,182.3
	FL YoY%	0%	0%	0%	148.2%	124.8%				0%	0%	0%	0%	0%	0%

6	Financial assets - fair value through other comprehensive income	3.8	3.8	3.8	3.8	3.8	3.8	3.8	3.8
	YoY	0%	0%	0%	0%	0%	0%	0%	0%
SCO1	Financial assets - fair value through other comprehensive income	3.8	3.8	3.8	3.8	3.8
	LY YoY%	0%	0%	0%	0%	0%				0%		0%	0%	0%	0%	0%
SCO3	Financial assets - fair value through other comprehensive income	3.8	3.8	3.8	3.8	3.8
	FL YoY%	0%	0%	0%	0%	0%				0%	0%	0%	0%	0%	0%

7	Average Interest Earning Assets (AIEA)	167,722.9	182,536.7	202,192.1	208,265.3	219,033.0	182536.7	194191.8	196578.3
SC01	Average Interest Earning Assets (AIEA)	167,722.9	182,536.7	202,192.1	208,265.3	219,033.0	182536.7	194191.8	196578.3
SC03	Average Interest Earning Assets (AIEA)	167,722.9	182,536.7	202,192.1	208,265.3	219,033.0	182536.7	194191.8	196578.3

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24
8	Interest Earning Assets (IEA)	176,483.5	188,589.9	215,794.3	221,314.1	231,877.2	188589.9	206188.8	205841.4
	YoY%
SC01	Interest Earning Assets (IEA)	176,483.5	188,589.9	215,794.3	221,314.1	231,877.2	188589.9	206188.8	205841.4
	YoY%
SC01	Interest Earning Assets (IEA)	176,483.5	188,589.9	215,794.3	221,314.1	231,877.2	188589.9	206188.8	205841.4
	YoY%

	Rs. Millions	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
1	Due to banks	3,914.4	1,068.1	1,547.7	4,544.9	2,204.5	1068.1	12091.6	751.2
	YoY%	0%	0%	44.9%	-5.1%	-81.8%	0%	221.1%	-82.6%/td>
SCO1	Due to banks	3,914.4	1,068.1	1,547.7	4,544.9	2,204.5
	YoY%	0%	0%	44.9%	-5.1%	-81.8%				44.9%	44.9%	44.9%	44.9%	44.9%	44.9%
SCO1	Due to banks	3,914.4	1,068.1	1,547.7	4,544.9	2,204.5
	YoY%	0%	0%	44.9%	-5.1%	-81.8%				44.9%	44.9%	44.9%	44.9%	44.9%	44.9%

2	Securities sold under repurchase agreements	254.2	40.5	11,611.5	9,159.8	11,698.4	40.5	424.7	7968.3
	YoY	0%	0%	0%	31350.1%	2654.6%	0%	78.0%	5056.9%
SC01	Securities sold under repurchase agreements	254.2	40.5	11,611.5	9,159.8	11,698.4
	YoY%	0%	0%	0%	31350.1%	2654.6%				0%	0%	0%	0%	0%	0%
SCO1	Securities sold under repurchase agreements	254.2	40.5	11,611.5	9,159.8	11,698.4
	YoY%	0%	0%	0%	31350.1%	2654.6%				0%	0%	0%	0%	0%	0%

3	Financial liabilities at amortised cost – due to depositors	146,433.8	162,533.5	175,344.9	179,785.0	192,596.7	162533.5	170753.5	170666.5
	YoY	0%	0%	7.9%	7.9%	12.8%	0%	13.2%	8.3%
SC01	Financial liabilities at amortised cost – due to depositors	146,433.8	162,533.5	175,344.9	179,785.0	192,596.7
	YoY%	0%	0%	7.9%	7.9%	12.8%				7.9%	7.9%	7.9%	7.9%	7.9%	7.9%
SCO1	Financial liabilities at amortised cost – due to depositors	146,433.8	162,533.5	175,344.9	179,785.0	192,596.7
	YoY%	0%	0%	7.9%	7.9%	12.8%				7.9%	7.9%	7.9%	7.9%	7.9%	7.9%

4	Financial liabilities at amortised cost – other borrowings	0.0	0.0	0.0	0.0	0.0	0	0	0
	YoY	0%	0%	nan%	nan%	nan%	0%	nan%	nan%
SC01	Financial liabilities at amortised cost – other borrowings	0.0	0.0	0.0	0.0	0.0
	YoY%	0%	0%	nan%	nan%	nan%				nan%	nan%	nan%	nan%	nan%	nan%
SCO3	Financial liabilities at amortised cost – other borrowings	0.0	0.0	0.0	0.0	0.0
	YoY%	0%	0%	nan%	nan%	nan%				nan%	nan%	nan%	nan%	nan%	nan%

5	- due to debt securities holders	12,978.5	15,876.5	13,051.6	10,295.7	7,576.7	15876.5	12918.5	13261.5
	YoY	0%	0%	0%	-21.1%	-26.4%	0%	-12.4%	2.7%
SC01	- due to debt securities holders	12,978.5	15,876.5	13,051.6	10,295.7	7,576.7
	YoY%	0%	0%	0%	-21.1%	-26.4%				0%	0%	0%	0%	0%	0%
SCO3	- due to debt securities holders	12,978.5	15,876.5	13,051.6	10,295.7	7,576.7
	YoY%	0%	0%	0%	-21.1%	-26.4%				0%	0%	0%	0%	0%	0%

6	Average Interest bearing Liabilities (AIBL)	159,529.9	171,549.7	190,537.1	195,001.9	205,132.3	171549.7	185179.8	185385.1
6	Average Interest bearing Liabilities (AIBL)	159,529.9	171,549.7	190,537.1	195,001.9	205,132.3	171549.7	185179.8	185385.1
6	Average Interest bearing Liabilities (AIBL)	159,529.9	171,549.7	190,537.1	195,001.9	205,132.3	171549.7	185179.8	185385.1

7	Interest bearing Liabilities (IBL)	163,580.9	179,518.6	201,555.6	203,785.5	214,076.3	179518.6	196188.3	192647.4
7	Interest bearing Liabilities (IBL)	163,580.9	179,518.6	201,555.6	203,785.5	214,076.3	179518.6	196188.3	192647.4
7	Interest bearing Liabilities (IBL)	163,580.9	179,518.6	201,555.6	203,785.5	214,076.3	179518.6	196188.3	192647.4

	Rs. Millions	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	FY25E	FY26E	FY27E	FY28E	FY29E
1	Interest Income	18,798.3	26,626.2	37,123.0	8,163.8	7,570.3	26,626.2	9921.2	9339.3
	- % Avg Int. Earning Assets	11.2%	14.6%	18.4%	3.9%	3.5%	14.6%	5.1%	4.8%
SC01	Interest Income	18,798.3	26,626.2	37,123.0	8,163.8	7,570.3	26,626.2	9921.2	9339.3
	- % Avg Int. Earning Assets	11.2%	14.6%	18.4%	3.9%	3.5%	14.6%	5.1%	4.8%	18.4%	18.4%	18.4%	18.4%	18.4%	18.4%
SC03	Interest Income	18,798.3	26,626.2	37,123.0	8,163.8	7,570.3	26,626.2	9921.2	9339.3
	- % Avg Int. Earning Assets	11.2%	14.6%	18.4%	3.9%	3.5%	14.6%	5.1%	4.8%	18.4%	18.4%	18.4%	18.4%	18.4%	18.4%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
2	Interest Expense	9,156.6	17,170.7	26,820.5	5,280.0	4,601.3	17,170.7	7,403.6	6,427.3
	- as a % Avg Int. Earning Liabilities	5.7%	10.0%	14.1%	2.7%	2.2%	10.0%	4.0%	3.5%
SC01	Interest Expense	9,156.6	17,170.7	26,820.5	5,280.0	4,601.3	17,170.7	7,403.6	6,427.3
	- as a % Avg Int. Earning Liabilities	5.7%	10.0%	14.1%	2.7%	2.2%				14.1%	14.1%	14.1%	14.1%	14.1%	14.1%
SC03	Interest Expense	9,156.6	17,170.7	26,820.5	5,280.0	4,601.3	17,170.7	7,403.6	6,427.3
	- as a % Avg Int. Earning Liabilities	5.7%	10.0%	14.1%	2.7%	2.2%				14.1%	14.1%	14.1%	14.1%	14.1%	14.1%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24
3	Net Interest income	9,641.7	9,455.5	10,302.5	2,883.8	2,969.0	9455.5	2517.6	2912.0
	- as a % AIEA	5.7%	5.2%	5.1%	1.4%	1.4%	5.2%	1.3%	1.5%
3	Net Interest income	9,641.7	9,455.5	10,302.5	2,883.8	2,969.0	9455.5	2517.6	2912.0
	- as a % AIEA	5.7%	5.2%	5.1%	1.4%	1.4%	5.2%	1.3%	1.5%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
4	Fee & Commission Income	1,821.2	1,754.9	1,539.4	415.0	475.1	1754.9	363.4	390.1
	- YoY%	0%	0%	-12.3%	18.2%	30.7%	0%	-15.5%	-2.3%
4	Fee & Commission Income	1,821.2	1,754.9	1,539.4	415.0	475.1	1754.9	363.4	390.1
	- YoY%	0%	0%	-12.3%	18.2%	30.7%	0%	-15.5%	-2.3%	-12.3%	-12.3%	-12.3%	-12.3%	-12.3%	-12.3%
4	Fee & Commission Income	1,821.2	1,754.9	1,539.4	415.0	475.1	1754.9	363.4	390.1
	- YoY%	0%	0%	-12.3%	18.2%	30.7%	0%	-15.5%	-2.3%	-12.3%	-12.3%	-12.3%	-12.3%	-12.3%	-12.3%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
5	Other Operating Income	484.0	-2,567.9	750.6	187.5	360.1	-2,567.9	596.3	-88.2
	- YoY%	0%	0%	-129.2%	12.2%	-39.6%	0%	-194.3%	-78.9%
SC01	Other Operating Income	484.0	-2,567.9	750.6	187.5	360.1	-2,567.9	596.3	-88.2
	- YoY%	0%	0%	-129.2%	12.2%	-39.6%				-129.2%	-129.2%	-129.2%	-129.2%	-129.2%	-129.2%
SC03	Other Operating Income	484.0	-2,567.9	750.6	187.5	360.1	-2,567.9	596.3	-88.2
	- YoY%	0%	0%	-129.2%	12.2%	-39.6%				-129.2%	-129.2%	-129.2%	-129.2%	-129.2%	-129.2%

	Period	2021	2022	2023	J-M 2024	M-J 2024	4Q23	1Q24	2Q24
6	Gross Income (GI)	21,103.5	25,813.1	39,413.0	8,766.3	8,405.5
	- YoY%	nan	nan	12.9	52.7	-9.4
SC01	Gross Income (GI)	21,103.5	25,813.1	39,413.0	8,766.3	8,405.5	25813.1	10880.9	9641.2
	- YoY%	nan	nan	12.9	52.7	-9.4
SC03	Gross Income (GI)	21,103.5	25,813.1	39,413.0	8,766.3	8,405.5	25813.1	10880.9	9641.2
	- YoY%	nan	nan	12.9	52.7	-9.4

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	FY25E	FY26E	FY27E	FY28E	FY29E
1	Fee & Commission Expenses	38.3	36.1	55.3	16.7	18.7	36.1	14.9	15.8
	% of Fee & Commission Income	2.1%	2.1%	3.6%	4.0%	3.9%	2.1%	4.1%	4.1%
SC01	Fee & Commission Expenses	38.3	36.1	55.3	16.7	18.7	36.1	14.9	15.8
	% of Fee & Commission Income	2.1%	2.1%	3.6%	4.0%	3.9%	2.1%	4.1%	4.1%	3.6%	3.6%	3.6%	3.6%	3.6%	3.6%
SC03	Fee & Commission Expenses	38.3	36.1	55.3	16.7	18.7	36.1	14.9	15.8
	% of Fee & Commission Income	2.1%	2.1%	3.6%	4.0%	3.9%	2.1%	4.1%	4.1%	3.6%	3.6%	3.6%	3.6%	3.6%	3.6%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24
2	Impairment Charge	2,370.5	2,860.6	3,155.1	nan	nan	2860.6	694.1	832.9
	nan
SC01	Impairement Charges
SC03	Impairement Charges

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
3	Other Operating Expenses	4,627.0	4,644.0	6,056.4	1,616.6	1,793.8	4644.0	1468.1	1508.8
	Total operating income (GI - Int Exp.)	11,908.7	8,606.3	12,537.1	3,469.7	3,785.5	8,606.3	3,462.4	3,198.1
	Cost to Operating Income ratio	38.9%	54.0%	48.3%	46.6%	47.4%	54.0%	42.4%	47.2%
SC01	Other Operating Expenses	4,627.0	4,644.0	6,056.4	1,616.6	1,793.8	4644.0	1468.1	1508.8
	Total operating income (GI - Int Exp.)	11,908.7	8,606.3	12,537.1	3,469.7	3,785.5	8,606.3	3,462.4	3,198.1
	Cost to Operating Income ratio	38.9%	54.0%	48.3%	46.6%	47.4%	54.0%	42.4%	47.2%	48.3%	48.3%	48.3%	48.3%	48.3%	48.3%
SC03	Other Operating Expenses	4,627.0	4,644.0	6,056.4	1,616.6	1,793.8
	Total operating income (GI - Int Exp.)	11,908.7	8,606.3	12,537.1	3,469.7	3,785.5
	Cost to Operating Income ratio	38.9%	54.0%	48.3%	46.6%	47.4%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	4Q24E	2024E	1Q25E	2Q25E	3Q25E	4Q25E	2025E	2026E	2027E	2028E	2029E
4	VAT on financial services	877.6	451.9	997.3	309.5	419.4	451.9	324.5	255.2	0		00	0	00	0
	% of PBT on Financial Services	4.2%	1.8%	2.5%	3.5%	5.0%	1.8%	3.0%	2.6%
SC01	VAT on financial services	877.6	451.9	997.3	309.5	419.4	451.9	324.5	255.2	0		00	0	00	0
	Profit Before VAT and SSL	4,911.2	1,101.8	3,325.7	1,105.1	1,620.0
	% of PBT on Financial Services	4.2%	1.8%	2.5%	3.5%	5.0%	1.8%	3.0%	2.6%		2.5%					2.5%	2.5%	2.5%	2.5%	2.5%
SC01	VAT on financial services	877.6	451.9	997.3	309.5	419.4	451.9	324.5	255.2	0		00	0	00	0
	Profit Before VAT and SSL	4,911.2	1,101.8	3,325.7	1,105.1	1,620.0
	% of PBT on Financial Services	4.2%	1.8%	2.5%	3.5%	5.0%	1.8%	3.0%	2.6%		2.5%					2.5%	2.5%	2.5%	2.5%	2.5%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	4Q24E	1Q25E	2Q25E	3Q25E	4Q25E
5	Social Security Levy	0.0	0.0	0.0	0.0	0.0	0	0	0	0	00	0	00	0
	% of PBT on Financial Services	0	0	0	0	0
SCO1	Social Security Levy	0.0	0.0	0.0	0.0	0.0	0	0	0	0	00	0	00	0
	%
SCO3	Social Security Levy	0.0	0.0	0.0	0.0	0.0	0	0	0	0	00	0	00	0
	%

	Fixed Assets - Cost	4Q23	1Q24	2Q24	3Q24E
1	Total Equity	nan	nan	1249	1252
	VAT on financial services	451.9	324.5	255.2	222
	Equity funding of assets %	nan	nan	1252

	Depreciation	4Q23	1Q24	2Q24	3Q24E	4Q24E	1Q25E	2Q25E	3Q25E	4Q25E	FY26E	FY27E	FY28E	FY29E
1	Check	nan	nan	1255	1257
	nan	nan	nan	3.0
	nan	nan%	nan%	123400%
	nan	nan	nan	1257	111	111	111	111	111	111	111	111	111	111
	nan	nan	nan	1258

2	Working Capital

Period	4Q23	1Q24	2Q24
nan	nan	nan	41
nan	nan	nan	nan
Profit before taxes on financial services	nan	nan	nan
nan	nan	nan	nan

	Period		4Q23	1Q24	2Q24	3Q24E	4Q24E	FY24E	1Q25E	2Q25E	3Q25E	4Q25E	FY25E	FY26E	FY27E	FY28E	FY29E
	nan		nan	nan	40
	nan

	Period		4Q23	1Q24	2Q24	3Q24E	4Q24E	FY24E	1Q25E	2Q25E	3Q25E	4Q25E	FY25E	FY26E	FY27E	FY28E	FY29E
	nan		nan	nan	43
	nan		nan	nan	nan

	Period		4Q23	1Q24	2Q24	3Q24E	4Q24E	FY24E	1Q25E	2Q25E	3Q25E	4Q25E	FY25E	FY26E	FY27E	FY28E	FY29E
	nan		nan	nan	1216
	nan		nan	nan	nan

Period	4Q23	1Q24	2Q24
nan	nan	nan	1219
nan	nan	nan	nan
Working Capital	42673.1
Change in Working Capital		nan	nan

Interest Bearing Debt		4Q23	1Q24	2Q24	3Q24E	4Q24E	1Q25E	2Q25E	3Q25E	4Q25E	FY26E	FY27E	FY28E	FY29E
nan		nan	nan	1263	1266
nan		nan	nan	1264
nan		nan	nan	1265
nan	i+ii-iii=iv	nan	nan	1266
nan		nan	nan	1267
nan	iv*vii=vi	nan	nan	1268
nan		nan	nan	126900	%	%	%	%	%	%	%	%	%	%

Interest Income	4Q23	1Q24	2Q24	3Q24E	4Q24E	1Q25E	2Q25E	3Q25E	4Q25E	FY26E	FY27E	FY28E	FY29E
nan	nan	nan	46
nan	nan	nan	nan
nan	nan	nan	127100	%	%	%	%	%	%	%	%	%	%

1	Tax	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	3Q24E	4Q24E	2024E	1Q25E	2Q25E	3Q25E	4Q25E	2025E	2026E	2027E	2028E	2029E
	Profit before income tax	4,033.7	649.9	2,328.3	795.7	1,200.6	649.9	975.7	601.1
	Tax B/F	159.8	118.4	174.6	536.1	704.7	nan	nan	nan	536.1		536.1
	Tax provision for the year	958.3	-1,352.1	473.4	432.9	538.6	-1352.1	373.5	284.4
	Tax paid	-527.4	-166.0	-37.6	-5.1	-4.9	-0.0	0	0	284.4		473.4
	Tax C/F	118.4	174.6	536.1	704.7	689.1	282.3	322.4	536.1
	Tax rate	23.8	-208.1	20.3	54.4	44.9	-208.1	38.3	47.3	%	%	%	%	%	%	%	%	%	%	%	%
	* Historically showing selected rows only
SC01	Profit Before Tax
	Tax B/F	159.8	118.4	174.6	536.1	704.7						536.1
	Tax provision for the year	958.3	-1,352.1	473.4	432.9	538.6
	Tax paid	-527.4	-166.0	-37.6	-5.1	-4.9						473.4
	Tax C/F	118.4	174.6	536.1	704.7	689.1
	Tax rate	23.8	-208.1	20.3	54.4	44.9						20.3					20.3	20.3	20.3	20.3	20.3
SC03	Profit Before Tax
	Tax B/F	159.8	118.4	174.6	536.1	704.7						536.1
	Tax provision for the year	958.3	-1,352.1	473.4	432.9	538.6
	Tax paid	-527.4	-166.0	-37.6	-5.1	-4.9						473.4
	Tax C/F	118.4	174.6	536.1	704.7	689.1
	Tax rate	23.8	-208.1	20.3	54.4	44.9						20.3					20.3	20.3	20.3	20.3	20.3
	Checkbox selection tax prov

	Item		2024E	2025E	2026E	2027E	2028E	2029E	Your Comments
ASSETS
1	Placements with banks	YoY%

Income Statement
Balance Sheet

Income Statement (Rs. Millions)		2021	2022	2023	J- M 2024	A- J 2024	4Q23	1Q24	2Q24	3Q24E	4Q24E	2024	1Q25E	2Q25E	3Q25E	4Q25E	2025E	2026E	2027E	2028E	2029E
1. Interest Income		18,798.3	26,626.2	37,123.0	8,163.8	7,570.3	9,921.2	9,339.3
2. Interest Expenses		9,156.6	17,170.7	26,820.5	5,280.0	4,601.3
3. Net Interest Expenses		9,641.7	9,455.5	10,302.5	2,883.8	2,969.0	2517.6	2912.0
4. Fee and Commission Income		1,821.2	1,754.9	1,539.4	415.0	475.1
5. Fee and Commission Expenses		38.3	36.1	55.3	16.7	18.7
6. Other Operating Income		484.0	-2,567.9	750.6	187.5	360.1
7. Total Operating Income		11,908.7	8,606.3	12,537.1	3,469.7	3,785.5
8. Impairment Charges		2,370.5	2,860.6	3,155.1	748.0	371.7	694.1	832.9
9. Net Operating Income		9,538.2	5,745.8	9,382.0	2,721.7	3,413.8	2768.3	2365.2
10. Operating Expenses		4,627.0	4,644.0	6,056.4	1,616.6	1,793.8
11. Operating Profit Before Taxes on Financial Services		4,911.2	1,101.8	3,325.7	1,105.1	1,620.0	1300.3	856.3
12. VAT on Financial Services		877.6	451.9	997.3	309.5	419.4	324.5	255.2
13. Social Security Contribution Levy		0.0	0.0	0.0	0.0	0.0	0	0
6. Depreciation					nan	3.0
Other Operating Expenses					596.3	-88.2			nan
8. Operating Income					3,462.4	3,198.1
9. Interest Expenses					nan	1268
10. Interest Income					nan	nan
14. Other (Exp.)/Inc.		0.0	0.0	0.0	0.0	0.0	0	0	-	-
15. Profit Before Tax		4,033.7	649.9	2,328.3	795.7	1,200.6	975.7	601.1
16. Tax Expenses		958.3	-1,352.1	473.4	432.9	538.6	373.5	284.4
13. Profit After Tax	11-12=13	0.0	0.0	0.0	0.0	0.0
14. Other	User Input
17. Net Income		3,075.4	2,001.9	1,855.0	362.8	662.1	602.2	316.7

Cash Flow Statement	1Q24	2Q24	3Q24E	4Q24E	FY24E
1. Profit Before Tax	975.7	601.1
2. Depreciation	nan	3.0
3. Change in Working Capital	nan	nan
4. Income Tax Paid	nan	9
Other	nan	4			nan
5. Net Cash Flow from / (used in) Operating Activities	nan	10
6. Capital Expenditure	324.5	255.2
Other	nan	13			nan
7. Cash Flows from Investing Activities	nan	14
8. Borrowings	nan	15
9. Debt Repayments	nan	16
Other	nan	17			nan
10. Net Cash flows from / (used in) Financing Activities	nan	18
Other	nan	19			nan
11. Net Increase/(Decrease) in Cash and Cash Equivalents	4911.5	6940.7
12. Cash and CE at Start	nan	21	3Q	4Q	nan

Balance Sheet (Rs. Millions)	Notes	2021	2022	2023	Mar 2024	Jun 2024	3Q24E	4Q24E	2024E	1Q25E	2Q25E	3Q25E	4Q25E	2025E	2026E	2027E	2028E	2029E
Total Assets
Cash and Cash Equivalents	6940.7	2,218.1	5,374.3	6,238.2	6,003.9	3,843.5
Balances with Central Bank of Sri Lanka		5,038.3	5,308.8	2,909.3	1,497.9	4,074.6	4074.6	4074.6	4,074.6	4,074.6	4,074.6	4,074.6	4,074.6	4,074.6	4,074.6	4,074.6	4,074.6	4,074.6
Placements with banks		0.0	0.0	0.0	0.0	0.0
Reverse repurchase agreements		0.0	2,003.3	0.0	4,511.6	1,000.8
Derivative financial instruments		4.6	0.0	26.2	10.8	121.4	121.4	121.4	121.4	121.4	121.4	121.4	121.4	121.4	121.4	121.4	121.4	121.4
Financial assets recognised through profit or loss – measured at fair value		0.0	2,239.8	4,277.6	7,428.9	4,188.0
Financial assets at amortised cost – Loans and advances to other customers		142,369.2	144,148.1	131,296.1	137,274.3	139,502.4
Financial assets at amortised cost – Debt and other financial instruments		34,110.6	40,195.0	80,216.8	72,095.6	87,182.3
Financial assets - fair value through other comprehensive income		3.8	3.8	3.8	3.8	3.8
1. Property Plant and Equipment - Net Book value
Investment in subsidiaries		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Investments in associates		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Property, plant & equipment		2,335.8	2,586.1	2,806.1	2,784.6	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2	2,757.2
Investment properties		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Intangible assets		320.9	340.0	321.6	309.1	308.9	308.9	308.9	308.9	308.9	308.9	308.9	308.9	308.9	308.9	308.9	308.9	308.9
Right-of-use assets		1,377.4	1,594.0	1,399.8	1,328.0	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4	1,289.4
Current tax receivables		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Leasehold property		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Deferred tax assets		0.0	1,759.4	2,128.4	2,312.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1	1,755.1
Other assets		1,733.1	2,496.5	1,832.6	1,454.8	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0	1,481.0
7. Non Current Assets
8. Inventories	From OA 2ii
9. Trade and Other Receivables	From OA 2i
10. Prepayments	From OA 2iii
14. Cash and Cash Equivalents	From CFS 13
15. Current Assets
Total Assets		189,511.7	208,049.1	233,456.3	237,015.4	247,508.4
Equities and Liabilities
Due to banks		3,914.4	1,068.1	1,547.7	4,544.9	2,204.5
Derivative financial instruments		0.0	56.1	142.1	292.3	11.2	11.2	11.2	11.2	11.2	11.2	11.2	11.2	11.2	11.2	11.2	11.2	11.2
Securities sold under repurchase agreements		254.2	40.5	11,611.5	9,159.8	11,698.4
Financial liabilities at amortised cost – due to depositors		146,433.8	162,533.5	175,344.9	179,785.0	192,596.7
Financial liabilities at amortised cost – other borrowings		0.0	0.0	0.0	0.0	0.0
- due to debt securities holders		12,978.5	15,876.5	13,051.6	10,295.7	7,576.7
Retirement benefit obligation		376.9	470.4	505.9	531.1	574.1	574.1	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Dividend payable		196.2	0.0	0.0	0.0	0.0	0.0	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Current tax liabilities		1,252.8	1,751.2	2,610.0	3,221.4	3,198.1	3,198.1	3,198.1		3,198.1	3,198.1	3,198.1	3,198.1
Deferred tax liabilities		118.4	174.6	536.1	704.7	689.1	689.1	689.1	689.1	689.1	689.1	689.1	689.1	689.1	689.1	689.1	689.1	689.1
Other liabilities		4,560.2	4,588.9	4,636.1	4,787.0	4,575.6
Subordinated liabilities		872.8	872.8	872.8	843.6	872.2	872.2	872.2	872.2	872.2	872.2	872.2	872.2	872.2	872.2	872.2	872.2	872.2
Total Liabilities		170,958.2	187,432.6	210,858.7	214,165.6	223,996.5
Equity
Stated capital		3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3
Reserves		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Statutory reserve fund		794.9	895.0	987.7	987.7	987.7	987.7	987.7	987.7	987.7	987.7	987.7	987.7	987.7	987.7	987.7	987.7	987.7
Other reserves		1,006.5	1,088.8	1,201.3	1,198.0	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7	1,194.7
Retained earnings	=16,270.8	13,137.9	15,018.5	16,794.4	17,049.8	17,715.2
Equity attributable to equity holders of parent		18,553.5	20,616.5	22,597.7	22,849.8	23,511.9
Non-controlling interest		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Total Equity		18,553.5	20,616.5	22,597.7	22,849.8	23,511.9
7. Long Term Debt	From OA 3iv
10. Non Current Liabilities
11. Current Maturities of Long Term Debt
12.Trade Payables	From OA 2iv
Total Liabilities (TL)		3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3	3,614.3
14.Income Tax Liabilities	From OA 5v
15. Other	From OA 2v
Current Liabilities
Total Equity and Liabilities		189,511.7	208,049.1	233,456.3	237,015.4	247,508.4
Net Asset Value per Share		41.9	46.6	51.1	52.0	53.1			51.1					51.1	51.1	51.1	51.1	51.1
Number of Shares (Millions)		320.5	402.7	421.9	442.6	442.6			442.6					442.6	442.6	442.6	442.6	442.6

Valuation

Residual Income Method

Rs. Millions	Notes	Jan to June 2024	Jul to Dec 2024E	2027E	2028E	2029E
1. Profit for the year		nan
2. Cost of Equity
3. Average Shareholder Funds
4. Cost of Equity Charge
5. Return in Excess of Cost of Equity
6. Terminal Value
10. Time for discount rate				nan	nan	nan	nan	nan	nan
7. Discount factor
8. Present Value of Excess Returns
9. Sum of Present Value of Excess Returns
10. Book Value			23,511.9
11. Equity Value
12. Number of Shares			442.6
13.Price per share (Rs.)
5. Capital Expenditure	From CA 4
6. Changes in Working Capital	From OA 2
7. Free Cash Flow	1+2+3+4+5+6=7
9. Total Free Cash Flow	7+8=9

13. Net (Debt)/Cash	Calculation
14. Pension Underfunding	From BS
15. Other	User input cell
16. Other	User input cell

Justified Mid Cycle P/BV Multiple Method

	Symbol		User Input	Reference	Source for Reference
1. Risk Free Rate	Rf		%	11.5%	SL 10yr bond yield
2. Market Return	Rm		%	11.0%	ASPI 5 year average return
3. Beta	B		%	125.0%	CSE
8. Cost of Equity	Ke	1+(3*4)=8		25.0%
4. Mid Cycle Cost of Equity	Ke	1+(3*(2-1))=4
5. Sustainable Earnings Growth Rate			%	5.0%
6. Sustainable ROE	ROE		%	11.0%	3 year Average
7. Book Value per Share in Year 5	BVPS				FY29E
8. Justified Mid Cycle P/BV multiple		(6-5)/4-5)
9. Estimated Target Price		8*7=9
10. Discounted Target Price		9/(1+4)^5)

	Symbol		User Input	Reference	Source for Reference
2. Long term cost of debt	Kd		%	25.0%	Weighted avg. int. rate
3. Equity risk premium	Rp		%	10.0%	External Source
5.Tax Rate	t		%	30.0%	SL tax rate
6. Debt Weighting	Wd		%	50.0%
7. Equity Weighting	We		%	50.0%
8. Cost of Equity	Ke	1+(3*4)=8		25.0%
9. WACC	Dr	(6(2(1-5)))+(7*8)=9		21.0%

	Notes	Price to Earnings	Price to Book Value	Price to Sales	EV to EBITDA
1. Earnings/Book Value/Sales/EBITDA
2. Adjusted Multiple
3. Valuation (Rs.)	1*2=3

Peer Multiples	Notes	Price to Earnings	Price to Book Value	Price to Sales	EV to EBITDA
1. Deutsche Post		15	2.5	1.8	10
2. Kuehne + Nagel International		12	1.8	1.5	8
3. Expeditors International		18	3.0	2.0	12
4.FedEx Corporation		14	2.2	1.6	9
5.CH Robinson Worldwide		16	2.8	1.9	11
6.Average	1+2+3+4+5=6
7. Adjustment
8. Adjusted Multiple	7+8=9

Date	Research Organisation	Recommendation	Target Price (Rs.)
nan	nan	nan	nan

Valuation

Residual Income Method

Justified Mid Cycle P/BV Multiple Method

Insert Your Report Prompt Here

AI Draft

Your Draft