Company Overview

hnb

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%	6.3
Reverse repurchase agreements	YoY%	32.6
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%	-2.6
Financial assets at amortised cost – Debt and other financial instruments	YoY%	21.7
Financial assets - fair value through other comprehensive income	YoY%	0
LIABILITIES		2024 to 2029
Due to banks	YoY%	47.8
Securities sold under repurchase agreements	YoY%	0
Financial liabilities at amortised cost – due to depositors	YoY%	11.5
Financial liabilities at amortised cost – other borrowings	YoY%	0
- due to debt securities holders	YoY%	0
REVENUE		2024 to 2029
Interest Income	- % Avg Int. Earning Assets	18.0
Fee & Commission Income	- YoY%	4.2
Other Operating Income	- YoY%	-55.5
COSTS		2024 to 2029
Interest Expense	- as a % Avg Int. Earning Liabilities	11.6
Fee & Commission Expenses	% of Fee & Commission Income	3.7
Impairment Charge
Other Operating Expenses	Cost to Operating Income ratio	40.4
VAT on financial services	% of PBT on Financial Services	3.1
Social Security Levy	% of PBT on Financial Services	0
Tax rate	%	36.6

	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	58,172.0	61,836.4	40,680.2	37,783.0	58172.0	48826.4	64000.6
	YoY%	-395.0%	0%	6.3%	6.3%	-22.6%	0%	-16.1%	10.0%
SCO1	Placements with banks	0.0	58,172.0	61,836.4	40,680.2	37,783.0
	LY YoY%	-395.0%	0%	6.3%	6.3%	-22.6%				6.3%	6.3%	6.3%	6.3%	6.3%	6.3%
SCO3	Placements with banks	0.0	58,172.0	61,836.4	40,680.2	37,783.0
	FL YoY%	-395.0%	0%	6.3%	6.3%	-22.6%				6.3%	6.3%	6.3%	6.3%	6.3%	6.3%

2	Reverse repurchase agreements	0.0	1,380.6	1,830.5	4,613.2	5,448.3	1380.6	3905.6	1333.3
	YoY	0%	0%	32.6%	136.8%	39.5%	0%	182.9%	-3.4%
SCO1	Reverse repurchase agreements	0.0	1,380.6	1,830.5	4,613.2	5,448.3
	LY YoY%	0%	0%	32.6%	136.8%	39.5%				32.6%		32.6%	32.6%	32.6%	32.6%	32.6%
SCO3	Reverse repurchase agreements	0.0	1,380.6	1,830.5	4,613.2	5,448.3
	FL YoY%	0%	0%	32.6%	136.8%	39.5%				32.6%	32.6%	32.6%	32.6%	32.6%	32.6%

3	Financial assets recognised through profit or loss – measured at fair value	0.0	236.2	801.1	1,178.3	3,127.0	236.2	501.1	777.5
	YoY	0%	0%	0%	279.3%	524.0%	0%	112.2%	229.2%
SCO1	Financial assets recognised through profit or loss – measured at fair value	0.0	236.2	801.1	1,178.3	3,127.0
	LY YoY%	0%	0%	0%	279.3%	524.0%				0%		0%	0%	0%	0%	0%
SCO3	Financial assets recognised through profit or loss – measured at fair value	0.0	236.2	801.1	1,178.3	3,127.0
	FL YoY%	0%	0%	0%	279.3%	524.0%				0%	0%	0%	0%	0%	0%

4	Financial assets at amortised cost – Loans and advances to other customers	0.0	1,014,518.9	988,601.2	964,080.7	992,354.3	1014518.9	934680.5	965845.8
	YoY	0%	0%	-2.6%	-0.2%	6.2%	0%	-7.9%	-4.8%
SCO1	Financial assets at amortised cost – Loans and advances to other customers	0.0	1,014,518.9	988,601.2	964,080.7	992,354.3
	LY YoY%	0%	0%	-2.6%	-0.2%	6.2%				-2.6%		-2.6%	-2.6%	-2.6%	-2.6%	-2.6%
SCO3	Reverse repurchase agreements	0.0	1,014,518.9	988,601.2	964,080.7	992,354.3
	FL YoY%	0%	0%	-2.6%	-0.2%	6.2%				-2.6%	-2.6%	-2.6%	-2.6%	-2.6%	-2.6%

5	Financial assets at amortised cost – Debt and other financial instruments	0.0	479,787.0	584,131.3	689,403.7	680,867.6	479787.0	722174.2	484517.6
	YoY	0%	0%	21.7%	13.2%	-5.7%	0%	50.5%	1.0%
SCO1	Financial assets at amortised cost – Debt and other financial instruments	0.0	479,787.0	584,131.3	689,403.7	680,867.6
	LY YoY%	0%	0%	21.7%	13.2%	-5.7%				21.7%		21.7%	21.7%	21.7%	21.7%	21.7%
SCO3	Financial assets at amortised cost – Debt and other financial instruments	0.0	479,787.0	584,131.3	689,403.7	680,867.6
	FL YoY%	0%	0%	21.7%	13.2%	-5.7%				21.7%	21.7%	21.7%	21.7%	21.7%	21.7%

6	Financial assets - fair value through other comprehensive income	0.0	6,062.2	195,975.3	149,779.1	156,612.7	6062.2	7650.6	228487.2
	YoY	0%	0%	0%	1996.2%	1947.1%	0%	26.2%	3669.1%
SCO1	Financial assets - fair value through other comprehensive income	0.0	6,062.2	195,975.3	149,779.1	156,612.7
	LY YoY%	0%	0%	0%	1996.2%	1947.1%				0%		0%	0%	0%	0%	0%
SCO3	Financial assets - fair value through other comprehensive income	0.0	6,062.2	195,975.3	149,779.1	156,612.7
	FL YoY%	0%	0%	0%	1996.2%	1947.1%				0%	0%	0%	0%	0%	0%

7	Average Interest Earning Assets (AIEA)	1,560,157.0	1,696,666.3	1,736,464.5	1,796,965.7	1560157.0	1638947.7	1652559.5
SC01	Average Interest Earning Assets (AIEA)	1,560,157.0	1,696,666.3	1,736,464.5	1,796,965.7	1560157.0	1638947.7	1652559.5
SC03	Average Interest Earning Assets (AIEA)	1,560,157.0	1,696,666.3	1,736,464.5	1,796,965.7	1560157.0	1638947.7	1652559.5

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24
8	Interest Earning Assets (IEA)	0.0	1,560,157.0	1,833,175.7	1,849,735.3	1,876,193.0	1560157.0	1717738.4	1744962.0
	YoY%
SC01	Interest Earning Assets (IEA)	0.0	1,560,157.0	1,833,175.7	1,849,735.3	1,876,193.0	1560157.0	1717738.4	1744962.0
	YoY%
SC01	Interest Earning Assets (IEA)	0.0	1,560,157.0	1,833,175.7	1,849,735.3	1,876,193.0	1560157.0	1717738.4	1744962.0
	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	0.0	6,104.6	9,019.6	13,676.3	7,831.4	6104.6	8832.3	11916.6
	YoY%	0%	0%	47.8%	56.3%	-11.3%	0%	44.7%	95.2%/td>
SCO1	Due to banks	0.0	6,104.6	9,019.6	13,676.3	7,831.4
	YoY%	0%	0%	47.8%	56.3%	-11.3%				47.8%	47.8%	47.8%	47.8%	47.8%	47.8%
SCO1	Due to banks	0.0	6,104.6	9,019.6	13,676.3	7,831.4
	YoY%	0%	0%	47.8%	56.3%	-11.3%				47.8%	47.8%	47.8%	47.8%	47.8%	47.8%

2	Securities sold under repurchase agreements	0.0	6,540.0	61,793.7	79,183.7	58,622.2	6540.0	66321.4	27930.8
	YoY	0%	0%	0%	295.0%	-11.6%	0%	914.1%	327.1%
SC01	Securities sold under repurchase agreements	0.0	6,540.0	61,793.7	79,183.7	58,622.2
	YoY%	0%	0%	0%	295.0%	-11.6%				0%	0%	0%	0%	0%	0%
SCO1	Securities sold under repurchase agreements	0.0	6,540.0	61,793.7	79,183.7	58,622.2
	YoY%	0%	0%	0%	295.0%	-11.6%				0%	0%	0%	0%	0%	0%

3	Financial liabilities at amortised cost – due to depositors	0.0	1,443,179.1	1,609,153.7	1,587,790.0	1,625,386.9	1443179.1	1509240.5	1563181.9
	YoY	0%	0%	11.5%	7.7%	7.7%	0%	4.6%	8.3%
SC01	Financial liabilities at amortised cost – due to depositors	0.0	1,443,179.1	1,609,153.7	1,587,790.0	1,625,386.9
	YoY%	0%	0%	11.5%	7.7%	7.7%				11.5%	11.5%	11.5%	11.5%	11.5%	11.5%
SCO1	Financial liabilities at amortised cost – due to depositors	0.0	1,443,179.1	1,609,153.7	1,587,790.0	1,625,386.9
	YoY%	0%	0%	11.5%	7.7%	7.7%				11.5%	11.5%	11.5%	11.5%	11.5%	11.5%

4	Financial liabilities at amortised cost – other borrowings	0.0	33,385.6	25,031.8	22,415.7	21,310.7	33385.6	26319.0	27998.1
	YoY	0%	0%	0%	-15.7%	-19.0%	0%	-21.2%	-16.1%
SC01	Financial liabilities at amortised cost – other borrowings	0.0	33,385.6	25,031.8	22,415.7	21,310.7
	YoY%	0%	0%	0%	-15.7%	-19.0%				0%	0%	0%	0%	0%	0%
SCO3	Financial liabilities at amortised cost – other borrowings	0.0	33,385.6	25,031.8	22,415.7	21,310.7
	YoY%	0%	0%	0%	-15.7%	-19.0%				0%	0%	0%	0%	0%	0%

5	- due to debt securities holders	0.0	34,241.3	550.2	548.8	548.2	34241.3	38977.2	43710.7
	YoY	0%	0%	0%	-0.3%	-0.1%	0%	2.7%	12.1%
SC01	- due to debt securities holders	0.0	34,241.3	550.2	548.8	548.2
	YoY%	0%	0%	0%	-0.3%	-0.1%				0%	0%	0%	0%	0%	0%
SCO3	- due to debt securities holders	0.0	34,241.3	550.2	548.8	548.2
	YoY%	0%	0%	0%	-0.3%	-0.1%				0%	0%	0%	0%	0%	0%

6	Average Interest bearing Liabilities (AIBL)	1,523,450.6	1,614,499.7	1,635,505.9	1,681,694.9	1523450.6	1586570.5	1599094.3
6	Average Interest bearing Liabilities (AIBL)	1,523,450.6	1,614,499.7	1,635,505.9	1,681,694.9	1523450.6	1586570.5	1599094.3
6	Average Interest bearing Liabilities (AIBL)	1,523,450.6	1,614,499.7	1,635,505.9	1,681,694.9	1523450.6	1586570.5	1599094.3

7	Interest bearing Liabilities (IBL)	1,523,450.6	1,705,548.9	1,703,614.5	1,713,699.4	1523450.6	1649690.4	1674738.1
7	Interest bearing Liabilities (IBL)	1,523,450.6	1,705,548.9	1,703,614.5	1,713,699.4	1523450.6	1649690.4	1674738.1
7	Interest bearing Liabilities (IBL)	1,523,450.6	1,705,548.9	1,703,614.5	1,713,699.4	1523450.6	1649690.4	1674738.1

	Rs. Millions	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	FY25E	FY26E	FY27E	FY28E	FY29E
1	Interest Income	0.0	220,581.3	304,578.1	64,476.7	59,447.1	220,581.3	81226.6	74381.1
	- % Avg Int. Earning Assets	0%	14.1%	18.0%	3.7%	3.3%	14.1%	5.0%	4.5%
SC01	Interest Income	0.0	220,581.3	304,578.1	64,476.7	59,447.1	220,581.3	81226.6	74381.1
	- % Avg Int. Earning Assets	0%	14.1%	18.0%	3.7%	3.3%	14.1%	5.0%	4.5%	18.0%	18.0%	18.0%	18.0%	18.0%	18.0%
SC03	Interest Income	0.0	220,581.3	304,578.1	64,476.7	59,447.1	220,581.3	81226.6	74381.1
	- % Avg Int. Earning Assets	0%	14.1%	18.0%	3.7%	3.3%	14.1%	5.0%	4.5%	18.0%	18.0%	18.0%	18.0%	18.0%	18.0%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
2	Interest Expense	0.0	109,014.8	186,503.5	39,142.4	32,195.1	109,014.8	49,782.4	47,196.5
	- as a % Avg Int. Earning Liabilities	0%	7.2%	11.6%	2.4%	1.9%	7.2%	3.1%	3.0%
SC01	Interest Expense	0.0	109,014.8	186,503.5	39,142.4	32,195.1	109,014.8	49,782.4	47,196.5
	- as a % Avg Int. Earning Liabilities	0%	7.2%	11.6%	2.4%	1.9%				11.6%	11.6%	11.6%	11.6%	11.6%	11.6%
SC03	Interest Expense	0.0	109,014.8	186,503.5	39,142.4	32,195.1	109,014.8	49,782.4	47,196.5
	- as a % Avg Int. Earning Liabilities	0%	7.2%	11.6%	2.4%	1.9%				11.6%	11.6%	11.6%	11.6%	11.6%	11.6%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24
3	Net Interest income	0.0	111,566.5	118,074.6	25,334.3	27,252.0	111566.5	31444.1	27184.7
	- as a % AIEA	0%	7.2%	7.0%	1.5%	1.5%	7.2%	1.9%	1.6%
3	Net Interest income	0.0	111,566.5	118,074.6	25,334.3	27,252.0	111566.5	31444.1	27184.7
	- as a % AIEA	0%	7.2%	7.0%	1.5%	1.5%	7.2%	1.9%	1.6%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
4	Fee & Commission Income	10,677.0	16,521.3	17,207.6	4,520.4	4,944.8	16521.3	4022.5	4053.5
	- YoY%	0%	0%	4.2%	-3.7%	22.9%	0%	-3.2%	-3.6%
4	Fee & Commission Income	10,677.0	16,521.3	17,207.6	4,520.4	4,944.8	16521.3	4022.5	4053.5
	- YoY%	0%	0%	4.2%	-3.7%	22.9%	0%	-3.2%	-3.6%	4.2%	4.2%	4.2%	4.2%	4.2%	4.2%
4	Fee & Commission Income	10,677.0	16,521.3	17,207.6	4,520.4	4,944.8	16521.3	4022.5	4053.5
	- YoY%	0%	0%	4.2%	-3.7%	22.9%	0%	-3.2%	-3.6%	4.2%	4.2%	4.2%	4.2%	4.2%	4.2%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	2025E	2026E	2027E	2028E	2029E
5	Other Operating Income	17,625.8	33,406.8	14,852.4	2,929.4	5,719.1	33,406.8	2209.7	5555.3
	- YoY%	0%	0%	-55.5%	59.7%	158.8%	0%	-80.6%	6.2%
SC01	Other Operating Income	17,625.8	33,406.8	14,852.4	2,929.4	5,719.1	33,406.8	2209.7	5555.3
	- YoY%	0%	0%	-55.5%	59.7%	158.8%				-55.5%	-55.5%	-55.5%	-55.5%	-55.5%	-55.5%
SC03	Other Operating Income	17,625.8	33,406.8	14,852.4	2,929.4	5,719.1	33,406.8	2209.7	5555.3
	- YoY%	0%	0%	-55.5%	59.7%	158.8%				-55.5%	-55.5%	-55.5%	-55.5%	-55.5%	-55.5%

	Period	2021	2022	2023	J-M 2024	M-J 2024	4Q23	1Q24	2Q24
6	Gross Income (GI)	28,302.7	270,509.4	336,638.2	71,926.5	70,111.0
	- YoY%	nan	nan	-10.1	24.4	-17.6
SC01	Gross Income (GI)	28,302.7	270,509.4	336,638.2	71,926.5	70,111.0	270509.4	87458.7	83989.9
	- YoY%	nan	nan	-10.1	24.4	-17.6
SC03	Gross Income (GI)	28,302.7	270,509.4	336,638.2	71,926.5	70,111.0	270509.4	87458.7	83989.9
	- YoY%	nan	nan	-10.1	24.4	-17.6

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24	2024E	FY25E	FY26E	FY27E	FY28E	FY29E
1	Fee & Commission Expenses	360.8	619.6	635.0	178.7	170.9	619.6	144.4	142.2
	% of Fee & Commission Income	0%	3.8%	3.7%	4.0%	3.5%	3.8%	3.6%	3.5%
SC01	Fee & Commission Expenses	360.8	619.6	635.0	178.7	170.9	619.6	144.4	142.2
	% of Fee & Commission Income	0%	3.8%	3.7%	4.0%	3.5%	3.8%	3.6%	3.5%	3.7%	3.7%	3.7%	3.7%	3.7%	3.7%
SC03	Fee & Commission Expenses	360.8	619.6	635.0	178.7	170.9	619.6	144.4	142.2
	% of Fee & Commission Income	0%	3.8%	3.7%	4.0%	3.5%	3.8%	3.6%	3.5%	3.7%	3.7%	3.7%	3.7%	3.7%	3.7%

	Period	2021	2022	2023	J-M 2024	A-J 2024	4Q23	1Q24	2Q24
2	Impairment Charge	19,534.3	91,735.7	42,523.9	nan	nan	91735.7	17779.7	4345.7
	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	37,349.4	49,803.5	60,375.2	17,290.7	17,053.1	49803.5	14611.4	15746.1
	Total operating income (GI - Int. Exp.)	84,404.3	160,875.1	149,499.7	32,605.4	37,745.0	160,875.1	37,531.9	36,651.2
	Cost to Operating Income ratio	44.3%	31.0%	40.4%	53.0%	0%	31.0%	38.9%	43.0%
SC01	Other Operating Expenses	37,349.4	49,803.5	60,375.2	17,290.7	17,053.1	49803.5	14611.4	15746.1
	Total operating income (GI - Int. Exp.)	84,404.3	160,875.1	149,499.7	32,605.4	37,745.0	160,875.1	37,531.9	36,651.2
	Cost to Operating Income ratio	44.3%	31.0%	40.4%	53.0%	0%	31.0%	38.9%	43.0%	40.4%	40.4%	40.4%	40.4%	40.4%	40.4%
SC03	Other Operating Expenses	37,349.4	49,803.5	60,375.2	17,290.7	17,053.1
	Total operating income (GI - Int. Exp.)	84,404.3	160,875.1	149,499.7	32,605.4	37,745.0
	Cost to Operating Income ratio	44.3%	31.0%	40.4%	53.0%	0%

	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	4,759.9	5,247.6	10,523.1	3,071.3	4,340.9	5247.6	1582.6	3449.4	0		00	0	00	0
	% of PBT on Financial Services	0%	1.9%	3.1%	4.3%	6.2%	1.9%	1.8%	4.1%
SC01	VAT on financial services	4,759.9	5,247.6	10,523.1	3,071.3	4,340.9	5247.6	1582.6	3449.4	0		00	0	00	0
	Profit Before VAT and SSL	27,520.6	19,335.9	46,600.5	13,679.9	19,876.9
	% of PBT on Financial Services	0%	1.9%	3.1%	4.3%	6.2%	1.9%	1.8%	4.1%		3.1%					3.1%	3.1%	3.1%	3.1%	3.1%
SC01	VAT on financial services	4,759.9	5,247.6	10,523.1	3,071.3	4,340.9	5247.6	1582.6	3449.4	0		00	0	00	0
	Profit Before VAT and SSL	27,520.6	19,335.9	46,600.5	13,679.9	19,876.9
	% of PBT on Financial Services	0%	1.9%	3.1%	4.3%	6.2%	1.9%	1.8%	4.1%		3.1%					3.1%	3.1%	3.1%	3.1%	3.1%

	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	nan	nan
	VAT on financial services	5247.6	1582.6	3449.4	222
	Equity funding of assets %	nan	nan	nan

	Depreciation	4Q23	1Q24	2Q24	3Q24E	4Q24E	1Q25E	2Q25E	3Q25E	4Q25E	FY26E	FY27E	FY28E	FY29E
1	Check	nan	nan	nan	nan
	nan	nan	nan	nan
	nan	nan%	nan%	nan%
	nan	nan	nan	nan	111	111	111	111	111	111	111	111	111	111
	nan	nan	nan	nan

2	Working Capital

Period	4Q23	1Q24	2Q24
nan	nan	nan	nan
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	nan
	nan

	Period		4Q23	1Q24	2Q24	3Q24E	4Q24E	FY24E	1Q25E	2Q25E	3Q25E	4Q25E	FY25E	FY26E	FY27E	FY28E	FY29E
	nan		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	nan
	nan		nan	nan	nan

Period	4Q23	1Q24	2Q24
nan	nan	nan	nan
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	nan	nan
nan		nan	nan	nan
nan		nan	nan	nan
nan	i+ii-iii=iv	nan	nan	nan
nan		nan	nan	nan
nan	iv*vii=vi	nan	nan	nan
nan		nan	nan	nan	%	%	%	%	%	%	%	%	%	%

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

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	23,053.6	14,420.3	37,218.2	11,242.3	15,766.1	14420.3	3869.6	13842.5
	Tax B/F	8,093.6	0.0	30,460.2	24,707.7	25,405.0	nan	nan	nan	nan		24,707.7
	Tax provision for the year	2,969.2	-1,328.0	13,611.7	3,822.0	6,936.3	-1328.0	1292.5	4832.1
	Tax paid	-3,958.6	-10,222.6	-23,549.1	-861.5	-11,460.8	-599.6	0	0	4832.1		13,611.7
	Tax C/F	0.0	30,460.2	24,707.7	25,405.0	20,866.3	nan	nan	nan
	Tax rate	12.9	-9.2	36.6	34.0	44.0	-9.2	33.4	34.9	%	%	%	%	%	%	%	%	%	%	%	%
	* Historically showing selected rows only
SC01	Profit Before Tax
	Tax B/F	8,093.6	0.0	30,460.2	24,707.7	25,405.0						24,707.7
	Tax provision for the year	2,969.2	-1,328.0	13,611.7	3,822.0	6,936.3
	Tax paid	-3,958.6	-10,222.6	-23,549.1	-861.5	-11,460.8						13,611.7
	Tax C/F	0.0	30,460.2	24,707.7	25,405.0	20,866.3
	Tax rate	12.9	-9.2	36.6	34.0	44.0						36.6					36.6	36.6	36.6	36.6	36.6
SC03	Profit Before Tax
	Tax B/F	8,093.6	0.0	30,460.2	24,707.7	25,405.0						24,707.7
	Tax provision for the year	2,969.2	-1,328.0	13,611.7	3,822.0	6,936.3
	Tax paid	-3,958.6	-10,222.6	-23,549.1	-861.5	-11,460.8						13,611.7
	Tax C/F	0.0	30,460.2	24,707.7	25,405.0	20,866.3
	Tax rate	12.9	-9.2	36.6	34.0	44.0						36.6					36.6	36.6	36.6	36.6	36.6
	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		107,407.7	220,581.3	304,578.1	64,476.7	59,447.1	81,226.6	74,381.1
2. Interest Expenses		0.0	109,014.8	186,503.5	39,142.4	32,195.1
3. Net Interest Expenses		56,462.4	111,566.5	118,074.6	25,334.3	27,252.0	31444.1	27184.7
4. Fee and Commission Income		10,677.0	16,521.3	17,207.6	4,520.4	4,944.8
5. Fee and Commission Expenses		360.8	619.6	635.0	178.7	170.9
6. Other Operating Income		17,625.8	33,406.8	14,852.4	2,929.4	5,719.1
7. Total Operating Income		84,404.3	160,875.1	149,499.7	32,605.4	37,745.0
8. Impairment Charges		19,534.3	91,735.7	42,523.9	1,634.8	815.0	17779.7	4345.7
9. Net Operating Income		64,870.0	69,139.4	106,975.7	30,970.6	36,930.0	19752.2	32305.5
10. Operating Expenses		37,349.4	49,803.5	60,375.2	17,290.7	17,053.1
11. Operating Profit Before Taxes on Financial Services		27,520.6	19,335.9	46,600.5	13,679.9	19,876.9	5140.8	16559.5
12. VAT on Financial Services		4,759.9	5,247.6	10,523.1	3,071.3	4,340.9	1582.6	3449.4
13. Social Security Contribution Levy		0.0	0.0	0.0	0.0	0.0	0	0
6. Depreciation					nan	nan
Other Operating Expenses					2,209.7	5,555.3			nan
8. Operating Income					37,531.9	36,651.2
9. Interest Expenses					nan	nan
10. Interest Income					nan	1
14. Other (Exp.)/Inc.		292.8	332.0	1,140.8	633.7	230.1	311.4	732.4	-	-
15. Profit Before Tax		23,053.6	14,420.3	37,218.2	11,242.3	15,766.1	3869.6	13842.5
16. Tax Expenses		2,969.2	-1,328.0	13,611.7	3,822.0	6,936.3	1292.5	4832.1
13. Profit After Tax	11-12=13	0.0	0.0	0.0	0.0	0.0
14. Other	User Input
17. Net Income		20,084.4	15,748.2	23,606.5	7,420.4	8,829.8	2577.1	9010.3

Cash Flow Statement	1Q24	2Q24	3Q24E	4Q24E	FY24E
1. Profit Before Tax	3869.6	13842.5
2. Depreciation	nan	nan
3. Change in Working Capital	nan	nan
4. Income Tax Paid	nan	nan
Other	nan	nan			nan
5. Net Cash Flow from / (used in) Operating Activities	nan	nan
6. Capital Expenditure	1582.6	3449.4
Other	nan	nan			nan
7. Cash Flows from Investing Activities	nan	nan
8. Borrowings	nan	nan
9. Debt Repayments	nan	nan
Other	nan	nan			nan
10. Net Cash flows from / (used in) Financing Activities	nan	nan
Other	nan	nan			nan
11. Net Increase/(Decrease) in Cash and Cash Equivalents	83029.1	90993.8
12. Cash and CE at Start	nan	nan	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	90993.8	40,900.4	80,629.7	73,758.9	76,058.0	68,387.3
Balances with Central Bank of Sri Lanka		25,820.5	32,344.3	12,234.4	11,251.9	6,848.7	6848.7	6848.7	6,848.7	6,848.7	6,848.7	6,848.7	6,848.7	6,848.7	6,848.7	6,848.7	6,848.7	6,848.7
Placements with banks		0.0	58,172.0	61,836.4	40,680.2	37,783.0
Reverse repurchase agreements		0.0	1,380.6	1,830.5	4,613.2	5,448.3
Derivative financial instruments		927.5	5,370.5	452.2	1,405.7	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6	1,937.6
Financial assets recognised through profit or loss – measured at fair value		0.0	236.2	801.1	1,178.3	3,127.0
Financial assets at amortised cost – Loans and advances to other customers		0.0	1,014,518.9	988,601.2	964,080.7	992,354.3
Financial assets at amortised cost – Debt and other financial instruments		0.0	479,787.0	584,131.3	689,403.7	680,867.6
Financial assets - fair value through other comprehensive income		0.0	6,062.2	195,975.3	149,779.1	156,612.7
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		2,877.4	3,650.4	4,474.8	0.0	0.0	5,120.8	5,120.8	5,120.8	5,120.8	5,120.8	5,120.8	5,120.8	5,120.8	5,120.8	5,120.8	5,120.8	5,120.8
Property, plant & equipment		49,724.5	49,616.3	50,165.0	50,312.2	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4	50,132.4
Investment properties		964.9	935.5	913.9	906.6	899.2	899.2	899.2	899.2	899.2	899.2	899.2	899.2	899.2	899.2	899.2	899.2	899.2
Intangible assets		1,989.1	1,771.1	2,009.9	1,905.8	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1	1,948.1
Right-of-use assets		2,177.9	2,463.8	2,473.4	2,575.7	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1	2,493.1
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		4,941.1	30,763.2	33,967.3	30,796.1	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9	30,238.9
Other assets		15,858.7	30,573.4	33,415.0	34,032.4	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8	28,895.8
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		1,453,650.6	1,798,275.2	2,047,040.4	2,063,999.2	2,073,094.8
Equities and Liabilities
Due to banks		0.0	6,104.6	9,019.6	13,676.3	7,831.4
Derivative financial instruments		353.4	25.6	1,365.5	4,894.2	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4	1,125.4
Securities sold under repurchase agreements		0.0	6,540.0	61,793.7	79,183.7	58,622.2
Financial liabilities at amortised cost – due to depositors		0.0	1,443,179.1	1,609,153.7	1,587,790.0	1,625,386.9
Financial liabilities at amortised cost – other borrowings		0.0	33,385.6	25,031.8	22,415.7	21,310.7
- due to debt securities holders		0.0	34,241.3	550.2	548.8	548.2
Provisions		2,465.1	2,555.1	45,366.8	47,597.9	49,649.4	49,649.4	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Dividend payable		1,013.6	1,038.5	990.8	2,970.6	975.0	975.0	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Current tax liabilities		0.0	30,460.2	24,707.7	25,405.0	20,866.3	20,866.3	20,866.3		20,866.3	20,866.3	20,866.3	20,866.3
Deferred tax liabilities		5,158.0	6,465.0	6,552.5	6,571.2	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7	6,614.7
Other liabilities		14,596.7	18,041.8	20,696.2	24,222.8	23,752.1
Subordinated liabilities		24,391.9	26,151.3	22,255.2	22,772.9	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5	21,543.5
Total Liabilities		1,270,383.3	1,608,188.2	1,827,483.6	1,838,049.1	1,838,225.8
Equity
Stated capital		37,364.2	38,679.0	40,955.1	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2
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		8,560.0	9,310.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0	10,410.0
Other reserves		87,100.0	85,055.5	92,623.2	94,390.3	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5	94,730.5
Retained earnings	=65,933.8	43,643.8	50,247.4	68,251.7	70,982.3	79,541.0
Equity attributable to equity holders of parent		176,668.0	183,291.8	212,240.0	218,640.9	227,539.7
Non-controlling interest		6,599.2	6,795.1	7,316.7	7,309.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3	7,329.3
Total Equity		183,267.3	190,086.9	219,556.8	225,950.1	234,869.1
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)		42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2	42,858.2
14.Income Tax Liabilities	From OA 5v
15. Other	From OA 2v
Current Liabilities
Total Equity and Liabilities		1,453,650.6	1,798,275.2	2,047,040.4	2,063,999.2	2,073,094.8
Net Asset Value per Share		329.9	327.5	371.2	382.4	397.9			371.2					371.2	371.2	371.2	371.2	371.2
Number of Shares (Millions)		320,522.4	402,666.1	559.7	559.7	571.8			571.8					571.8	571.8	571.8	571.8	571.8

Valuation

Residual Income Method

Rs. Millions	Notes	Jan to June 2024	Jul to Dec 2024E	2027E	2028E	2029E
1. Profit for the year		16,250.2
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				0.5	1.5	2.5	3.5	4.5	5.5
7. Discount factor
8. Present Value of Excess Returns
9. Sum of Present Value of Excess Returns
10. Book Value			227,539.7
11. Equity Value
12. Number of Shares			571.8
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