Monday, October 27, 2025

Portfolio Snapshot - CAGR and Breakeven Price Oct 2025

Here's a snapshot of my current SGP portfolio:

CAGR of my current portfolio.

The column 'cagr' represents the compound annual growth rate of that stock.

The column 'cagr_inc_div_drp' shows the compound annual growth rate including dividends paid out and additional stocks obtained through distribution reinvestment plans.

The column 'cagr_benchmark' shows the compound annual growth rate of the benchmark. The benchmark is the SPDR STI ETF, stock code 'ES3'.

The column 'cagr_benchmark_status' shows yes if we beat the benchmark.

The column 'returns_one_year' shows the returns in the past year.

The columns 'cagr', 'cagr_inc_div_drp', 'cagr_benchmark', and 'returns_one_year' are shown in percentages.

Here's a comparison of the stats with previous years:

Statistics of my portfolio over the years.

Here's a chart depicting the stats above:

Bar chart of my portfolio statistics over the years.


Here's another snapshot of my portfolio based on the breakeven price:

Indication of whether each stock broke even.


The column 'price' indicates the current price of the stock.

The column 'breakeven_price' indicates the breakeven price of the stock with dividends and stocks from the distribution reinvestment plan included. As long as the price of the stock is above the breakeven price, I can sell the stock for a profit.

The column 'breakeven_price_status' indicates if the stock price is above the breakeven price.

Here's a comparison of the stats with previous years:

Breakeven statistics of my portfolio over the years.

Here's a chart depicting the stats above:

Bar chart of percentage of stocks that broke even.


Here are the returns of my portfolio versus the benchmark:

CAGR of my portfolio over the years. 

Here's a chart depicting the total dividends collected for this SGP portfolio to date:

Total dividends collected.


The value for the 'Weighted CAGR with div and drp included' is a bit of an anomaly this year, because of the issuance of Keppel DC Reit rights a few days earlier. The time period is too short, and hence the computation of the CAGR is probably not accurate.

Here's my comment from this topic in 2023:

        If 2022 was a bad year for stocks, 2023 is even worse. Mainly due to the ongoing Ukraine war with no end in sight, and now with the Israel-Hamas war. Interest rates are still at an all-time high. On the other hand, as long as interest rates start to fall, my bond and REITs are in position.  

Happy to share that 2025 is a much better year. The Israel-Hamas war seems to have wound down with the help of Trump, and interest rates have come down from all-time highs. Financial markets are at all-time highs. The only worry now is of an AI bubble. But my stocks have ridden the wave. 



No comments:

Post a Comment