Monitoring your portfolio using Excel file.

Dutch Lady: Investment returns

Dutch Lady Year DPS (sen) EPS (sen) MR Pr (RM) LPr (RM) HPr (RM) 2002 5.8 23.7 6.10 3.85 8.35 2003 12.8 24.2 4.13 3.76 4.50 2004 56 26.6 4.84 3.98 5.70 2005 63.2 42.4 5.56 4.56 6.55 2006 63.2 67.3 10.05 6.10 14.00 2007 63.2 73.8 11.65 10.00 13.30 2008 42.1 66.6 10.55 8.10 13.00 2009 65.5 94.38 10.93 8.85 13.00 2010 72.5 119.05 15.70 11.30 20.10 2011 72.5 172 23.14 15.28 31.00 2012 260 192.78 37.10 23.40 50.80 2013 260 216.04 45.44 41.40 49.50 2014 220 171.63 44.67 40.36 48.98 2015 220 220.28 45.45 41.80 49.10 2016 220 232.93 56.33 46.68 65.98 2017 280 188.08 58.00 54.00 62.00 2018 200 198.07 67.18 57.38 76.98 2019 100 159.41 55.20 45.62 64.78 2020 80 113.99 41.95 34.00 49.90 2021 50 146.25 34.71 31.92 37.50 2022 50 159.64 32.30 30.00 34.60 2023 50 110 25.26 20.22 30.30 Investing period from starting year to now (RM) Year Total DPS Pr 4/1/24 MR Pr Pr change Total returns 2002 25.07 25.00 6.10 18.90 19.15 2007 23.06 25.00 11.65 13.35 13.58 2012 19.90 25.00 37.10 -12.10 -11.90 2017 8.10 25.00 58.00 -33.00 -32.92 2022 1.00 25.00 32.30 -7.30 -7.29

How to read a balance sheet like a CFO: A risk-based approach

https://www.youtube.com/watch?v=DMv9JC_K37Y

Returns to shareholders of Petronas Dagangan over the last 10 years and 5 years

Petronas Dagangan

Dividends (sens)  per share received each year: 

2014  55.50

2015  62.00

2016  62.00

2017  78.00

2018  94.00

2019  70.00

2020  61.00

2021  40.00

2022  40.00

2023  NA

Year end share price of PBB

Year 2013 RM 31.44

Year 2018  RM 26.50

Year 2023  RM 23.00

Returns to shareholders of Petdag

10 year period from end of 2013 to end of 2023

Capital depreciation  = RM 23.00 - RM 31.44 = - RM 8.44

Total dividends received =  RM 5.625

Total loss = - RM 8.44  +  RM 5.625  = - RM 2.815  

Loss % = - RM 2.815 / RM 31.44 = - 8.95% 

The loss of capital was attenuated by the dividends received over the last 10 years.

5 year period from end of 2018 to end of 2023

Capital loss =  RM 23.00 - RM 26.50  = - RM 3.50

Total dividends received =  RM 2.11

Total loss  =  - RM 3.50 + RM 2.11 = - RM 1.39

Gain % = - RM 1.39 / RM 26.50 =  - 5.24%

The loss of capital was attenuated by the dividends received over the last 5 years.

Returns to shareholders of Public Bank Berhad over the last 10 years and last 5 years

Public Bank Berhad

Dividends (sens)  per share received each year: 

2014  10.41

2015  11.00

2016  11.60

2017  11.80

2018  13.20

2019   14.00

2020  8.00

2021  20.50

2022  19.70

2023  14.00

Year end share price of PBB

Year 2013 RM 3.76

Year 2018  RM 4.95

Year 2023  RM 4.25

Returns to shareholders of PBB

10 year period from end of 2013 to end of 2023

Capital appreciation  = RM 4.25 - RM 3.76 = RM 0.49

Total dividends received =  RM 1.34

Total gains = RM 0.49 +  RM 1.34  = RM 1.83  

Gain % = RM 1.83 / RM 3.76 = 48.7% 

Dividends provided the bulk of the returns to shareholders over the last 10 years.

5 year period from end of 2018 to end of 2023

Capital loss =  RM 4.25 - RM 4.95  = - RM 0.70

Total dividends received =  RM 0.762

Total gain  =  - RM 0.70 + RM 0.762 = RM 0.062

Gain % = RM 0.062 / RM 4.95 =  1.25%

The loss of capital was attenuated by the dividends received over the last 5 years.