Bottom and Top Price Region — Alphabet-C Case Study
Subject : Bottom and Top Price Region — Alphabet-C Case Study
.
(I)
Bottom Price Region :
.
From
(ROA - CTAC) × EPS + NCAVPS
to
ROA × EPS + NCAVPS
.
Top Price Region :
From
(NetROIC - CICC) × EPS + NCAVPS
to
NetROIC × EPS + NCAVPS
.
Note :
NetROIC
= 100 × Net Income ÷ (Total Equity + Total Debts)
.
CTAC Factor
= 30Y Government Bond Yield Factor × (1 + Total Liabilities/Total Equity × (1 + 2 × 30Y Government Bond Yield Ratio)) ÷ (1 + Total Liabilities/Total Equity)
.
CTAC
= 100 × (CTAC Factor - 1)
.
CICC Factor
= 30Y Government Bond Yield Factor × (1 + D/E× (1 + 2 × 30Y Government Bond Yield Ratio)) ÷ (1 + D/E)
.
CICC
= 100 × (CICC Factor - 1)
.
(II)
Alphabet-C Case Study
.
2026-March TTM
Data from TradingView
.
EPS
= 160.21÷13.07
= USD 12.2578423871
.
ROA
= 100×160.21÷703.92
= 22.759688601
.
NetROIC
= 100×160.21÷(478.75+15.16+92.52)
= 27.3195436796
.
CTAC Factor
= 1.04982×(1+0.4703289817×(1+2×0.04982))÷(1+0.4703289817)
= 1.083280758709
.
CTAC
= 8.3280758709
.
CICC Factor
= 1.04982×(1+0.2249190601×(1+2×0.04982))÷(1+0.2249190601)
= 1.069027349044
.
CICC
= 6.9027349044
.
NCAVPS
= (213.75-225.17)÷13.07
= USD -0.8737566947
.
(A)
Bottom Price Region :
.
From
(ROA - CTAC) × EPS + NCAVPS
(22.759688601-8.3280758709)×12.2578423871+(-0.8737566947)
= USD 176.0266775426
to
ROA × EPS + NCAVPS
22.759688601×12.2578423871+(-0.8737566947)
= USD 278.1109189556
.
(B)
Top Price Region :
.
From
(NetROIC - CICC) × EPS + NCAVPS
(27.3195436796-6.9027349044)×12.2578423871+(-0.8737566947)
= USD 249.3922673193
to
NetROIC × EPS + NCAVPS
27.3195436796×12.2578423871+(-0.8737566947)
= USD 334.0049038173
.
(C)
Summary :
Bottom Price Region :
USD 176.0266775426 — USD 278.1109189556
.
Top Price Region :
USD 249.3922673193 — USD 334.0049038173
.
Overlapped Region:
USD 249.3922673193 — USD 278.1109189556