Definitive Analysis
Definitive Analysis

Financial Statements

Company Industry Sector

Fundamentals

Margins Returns Growth Rates Metrics/Ratios

Valuations

Projections DCF DDM EPV Multiples Valuations

Miscellaneous

Indicators Charts WACC Beta Predictability

Analysis Mode

Ticker

Industry

Sector

FIBRA Macquarie México (FIBRAMQ12.MX)

Company Dividend Discount ModelIndustry: REIT - IndustrialSector: Real Estate

Valuation Snapshot

Stable Growth$410.05 - $1,090.36$1,021.83
Multi-Stage$155.02 - $169.64$162.20
Blended Fair Value$592.01
Current Price$30.04
Upside1,870.74%
DecisionBuy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2024202320222021202020192018201720162015
DPS16.96%6.51%2.702.801.861.811.781.231.541.591.811.55
YoY Growth---3.46%50.20%2.61%1.88%44.36%-19.96%-2.99%-12.28%16.99%7.72%
Dividend Yield--8.93%8.52%6.51%7.62%6.99%6.26%7.17%8.14%8.65%7.09%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)4,371.36
(-) Cash Dividends Paid (M)1,744.12
(=) Cash Retained (M)2,627.24
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)874.27546.42327.85
Cash Retained (M)2,627.242,627.242,627.24
(-) Cash Required (M)-874.27-546.42-327.85
(=) Excess Retained (M)1,752.972,080.822,299.39
(/) Shares Outstanding (M)797.31797.31797.31
(=) Excess Retained per Share2.202.612.88
LTM Dividend per Share2.192.192.19
(+) Excess Retained per Share2.202.612.88
(=) Adjusted Dividend4.394.805.07
WACC / Discount Rate6.63%6.63%6.63%
Growth Rate5.50%6.50%7.50%
Fair Value$410.05$1,021.83$1,090.36
Upside / Downside1,265.01%3,301.55%3,529.69%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)4,371.364,655.504,958.115,280.385,623.615,989.146,168.82
Payout Ratio39.90%49.92%59.94%69.96%79.98%90.00%92.50%
Projected Dividends (M)1,744.122,323.982,971.853,694.134,497.755,390.235,706.16

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate6.63%6.63%6.63%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)2,159.052,179.512,199.97
Year 2 PV (M)2,564.992,613.852,663.17
Year 3 PV (M)2,962.113,047.143,133.78
Year 4 PV (M)3,350.533,479.383,611.92
Year 5 PV (M)3,730.403,910.584,097.65
PV of Terminal Value (M)108,834.38114,091.12119,549.05
Equity Value (M)123,601.45129,321.58135,255.54
Shares Outstanding (M)797.31797.31797.31
Fair Value$155.02$162.20$169.64
Upside / Downside416.05%439.94%464.71%

High-Yield Dividend Screener

« Prev Page 46 of 151 Next »
Ticker ⇵ Company ⇵ Dividend Yield % ▼ Dividend Per Share ⇵ Payout Ratio % ⇵
ATCOLAtlas Corp.3.53%$0.8930.47%
AWC-R.BKAsset World Corp Public Company Limited3.53%$0.0737.62%
CCRO3.SACCR S.A.3.53%$0.4866.57%
HMU.DEHMS Bergbau AG3.53%$1.6929.89%
RAUTE.HERaute Oyj3.53%$0.5226.97%
RWE.DERWE AG3.53%$1.6646.76%
SNL.AXSupply Network Limited3.53%$1.1367.28%
0NHS.LNutrien Ltd.3.52%$2.1858.76%
CELL.MICellularline S.p.A.3.52%$0.0934.70%
INFREA.STInfrea AB3.52%$0.5067.57%
ISSP.JKPT Steel Pipe Industry of Indonesia Tbk3.52%$15.0019.85%
MGAMagna International Inc.3.52%$1.9252.47%
PARP.PAGroupe Partouche S.A.3.52%$0.6438.61%
PKI.TOParkland Corporation3.52%$1.4073.81%
SMU.SNSMU S.A.3.52%$5.4946.99%
161390.KSHankook Tire & Technology Co., Ltd.3.51%$2,000.0025.86%
300360.SZHangzhou Sunrise Technology Co., Ltd.3.51%$0.6152.03%
5106.KLAxis Real Estate Investment Trust3.51%$0.0756.99%
601128.SSJiangsu Changshu Rural Commercial Bank Co., Ltd.3.51%$0.2519.56%
INTP.JKPT Indocement Tunggal Prakarsa Tbk3.51%$259.8143.04%
RATO-A.STRatos AB (publ)3.51%$1.3512.15%
002887.SZTianjin LVYIN Landscape and Ecology Construction Co., Ltd3.50%$0.3384.50%
603062.SSMEGA P&C Advanced Materials (Shanghai) Company Limited3.50%$1.6674.27%
CMCLCaledonia Mining Corporation Plc3.50%$0.9235.87%
DLODLocal Limited3.50%$0.4987.74%
LAZLazard Ltd3.50%$1.7467.48%
TWL.MITraWell Co S.p.A.3.50%$0.2128.69%
WJP.SIVICOM Ltd3.50%$0.0666.95%
005610.KSSPC Samlip Co., Ltd.3.49%$1,803.3945.19%
0RFL.LVAT Group AG3.49%$12.5088.50%
2030.HKCabbeen Fashion Limited3.49%$0.0563.92%
5206.TWOKunyue Development Co., Ltd.3.49%$1.1821.91%
5246.KLWestports Holdings Berhad3.49%$0.2071.36%
5989.TH-One Co.,Ltd.3.49%$49.4414.49%
ACO-X.TOATCO Ltd.3.49%$1.9850.80%
CNICanadian National Railway Company3.49%$3.5050.64%
PEAB3.SACompanhia de Participações Aliança da Bahia3.49%$1.3678.68%
026960.KSDong Suh Companies Inc.3.48%$905.3362.72%
055550.KSShinhan Financial Group Co., Ltd.3.48%$2,668.7426.55%
0QK5.LINFICON Holding AG3.48%$3.4443.54%
6722.TWOWhetron Electronics Co.,Ltd.3.48%$1.9924.71%
HOLM-A.STHolmen AB (publ)3.48%$12.2366.11%
002206.SZZhejiang Hailide New Material Co.,Ltd3.47%$0.2043.30%
3004.SRNorthern Region Cement Company3.47%$0.2579.89%
4129.TWOUnited Orthopedic Corporation3.47%$3.8069.70%
600133.SSWuhan East Lake High Technology Group Co., Ltd.3.47%$0.3287.27%
601995.SSChina International Capital Corporation Limited3.47%$1.2162.35%
6471.TNSK Ltd.3.47%$33.8292.34%
CSED3.SACruzeiro do Sul Educacional S.A.3.47%$0.2130.49%
GPRA.JKPT Perdana Gapuraprima Tbk3.47%$5.0018.12%