You are viewing a single comment's thread from:

RE: Excel Learning on 30th June 2024

in #excel8 months ago (edited)

Stock Market Reflection

On 31st Jan 2025:
Natgate was oversold, 1.72, I was thinking to purchase the stock at a lower price without realising the fact that it is actually undervalue. Despite 2 days of sideway trading, I still stick with my plan.
Lesson learnt: Should purchase once it is undervalue, getting a small exposure will be nice enough

Hst: It is a bit dangerous to sell of a quarter of the stock given that the long run of share is going to be optimistic.
No Lesson learnt and no solution

Ytl Power: It is so fortunate that I able to secure a low price of the stock at 2.955. No idea when to sell off (Should plan one) given the fact that the demand for computing power won't lower just like the demand for electricity.

Takaful since 25th Nov to 25th Jan, It was a mistake for not profit taking at its highest pricing level, at 4.12? Even though I missed out the highest price, yet I missed out the second ideal timing, at 3.90. This is a sideway stock which have to do profit taking in appropriate timing.

---

Below is a 50-year projection table estimating the Chinese population proportion in Malaysia, assuming a current TFR of 0.8 and an annual decline rate of 1.5%. This model simplifies complex demographic dynamics but provides a baseline for understanding trends.


Assumptions

  1. Starting Proportion (2023): 22% (current estimated Chinese population in Malaysia).
  2. Annual Decline Rate: 1.5% (due to sustained low fertility and aging population).
  3. No Net Migration: Ignores immigration/emigration effects.
  4. Constant TFR: Assumes no future policy changes or societal shifts affecting fertility.

Projection Table (2023–2073)

YearChinese Proportion (%)Notes
202322.00%Baseline (current estimate)
202421.67%
202521.34%
202621.02%
202720.71%
202820.40%
202920.09%
203019.79%
203119.49%
203219.20%
203318.91%
203418.63%
203518.35%
203618.07%
203717.80%
203817.53%
203917.27%
204017.01%
204116.75%
204216.50%
204316.25%
204416.00%
204515.76%
204615.53%
204715.29%
204815.06%
204914.83%
205014.61%
205114.39%
205214.17%
205313.96%
205413.75%
205513.54%
205613.33%
205713.13%
205812.93%
205912.74%
206012.55%
206112.36%
206212.17%
206311.99%
206411.81%
206511.63%
206611.46%
206711.28%
206811.11%
206910.95%
207010.78%
207110.62%
207210.46%
207310.30%

Key Observations

  • By 2073, the Chinese population would fall to ~10.3% of Malaysia’s total population.
  • The decline accelerates over time due to compounding effects of low fertility and aging demographics.
  • Thresholds:
    • Below 15%: ~2045.
    • Below 10%: Beyond 2073 (extending to ~2123 for <5%).

Caveats

  • Migration: Increased emigration (e.g., brain drain) or immigration (e.g., policy incentives) could alter the trajectory.
  • Policy Changes: Pronatalist policies (e.g., subsidies for large families) could slow the decline.
  • Cultural Shifts: Changes in marriage rates or family norms might affect fertility.

Let me know if you’d like adjustments to the model (e.g., varying decline rates or migration scenarios).

-

-

-

To estimate the Malaysian Chinese population 100 years from now (in 2125), assuming no changes in fertility rates, immigration, or policy interventions, we can apply a generation-based decline model, similar to the South Korean projection.

Key Assumptions:

  • Current Malaysian Chinese population: ~6.5 million (as of 2020)
  • Total fertility rate (TFR): ~0.79 (below replacement level of 2.1)
  • No immigration/emigration effects
  • Each generation (~30 years) retains ~38% of the previous population (since 0.79/2 ≈ 0.395, meaning each couple has 0.79 children, leading to ~38% retention per generation).

Step-by-Step Projection

  • 2025: ~6.0 million (estimated decline from 2020)
  • 2055 (~1 generation later): 6.0M × 0.38 ≈ 2.28 million
  • 2085 (~2 generations later): 2.28M × 0.38 ≈ 0.87 million
  • 2115 (~3 generations later): 0.87M × 0.38 ≈ 0.33 million
  • 2125 (extrapolated): Likely ~300,000 or fewer

Conclusion

By 2125, under the assumption of no change in TFR and no immigration, the Malaysian Chinese population could decline to below 300,000, representing a 95% reduction from today. This trajectory suggests a near demographic collapse, with severe consequences for community sustainability and representation.

image.png