Definitive Analysis
Definitive Analysis

Financial Statements

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 45 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
558.SIUMS Holdings Limited3.60%$0.0588.87%
601019.SSShandong Publishing&Media Co.,Ltd3.60%$0.3141.99%
603233.SSDaShenLin Pharmaceutical Group Co., Ltd.3.60%$0.6463.21%
603658.SSAutobio Diagnostics Co., Ltd.3.60%$1.2766.33%
603661.SSHenglin Home Furnishings Co.,Ltd3.60%$1.1557.55%
6371.TTsubakimoto Chain Co.3.60%$83.2737.31%
FSMART.BKForth Smart Service Public Company Limited3.60%$0.2331.86%
KABE-B.STKABE Group AB (publ.)3.60%$8.0076.60%
SKLT.JKPT Sekar Laut Tbk3.60%$9.0042.24%
TFMAMA.BKThai President Foods Public Company Limited3.60%$6.9357.58%
002469.SZShandong Sunway Chemical Group Co., Ltd.3.59%$0.3072.05%
216050.KQIncross Co., Ltd.3.59%$241.9426.78%
2845.TWFar Eastern International Bank Ltd.3.59%$0.4654.51%
6461.TNippon Piston Ring Co., Ltd.3.59%$68.2725.12%
7751.TCanon Inc.3.59%$166.4591.69%
E4C.DEEcotel Communication Ag3.59%$0.4282.27%
LHA.DEDeutsche Lufthansa AG3.59%$0.3122.46%
NTBThe Bank of N.T. Butterfield & Son Limited3.59%$1.7833.40%
SVOA.BKSVOA Public Company Limited3.59%$0.0521.40%
TRAC-B.STAB Traction3.59%$9.0082.36%
0IX0.LGL Events S.A.3.58%$1.0420.20%
0QNG.LJungfraubahn Holding AG3.58%$10.2542.20%
3231.TNomura Real Estate Holdings, Inc.3.58%$34.6440.45%
4106.TWWellell Inc.3.58%$0.8058.20%
EIK.ICEik fasteignafélag hf.3.58%$0.5024.04%
053690.KSHanmiGlobal Co., Ltd.3.57%$642.0628.05%
286940.KSLotte Innovate Co Ltd3.57%$699.8899.32%
601158.SSChongqing Water Group Co.,Ltd.3.57%$0.1691.61%
ILC.SNInversiones La Construcción S.A.3.57%$650.4128.71%
058850.KSKtcs Corporation3.56%$100.0915.29%
1294.TWOHantech Bio-Technology Co., Ltd.3.56%$2.8166.03%
3283.TNippon Prologis REIT, Inc.3.56%$3,304.8853.00%
688121.SSShanghai Supezet Engineering Technology Corp., Ltd.3.56%$0.3973.41%
EMIRATESNBD.AEEmirates NBD Bank PJSC3.56%$1.0228.25%
FLEXO.ATFlexopack Société Anonyme Commercial and Industrial Plastics Company3.56%$0.3017.58%
006040.KSDongwon Industries Co., Ltd.3.55%$1,474.3049.91%
2715.TElematec Corporation3.55%$84.9964.74%
3700.HKInkeverse Group Limited3.55%$0.0411.74%
600958.SSOrient Securities Company Limited3.55%$0.3963.25%
7955.TCleanup Corporation3.55%$31.0045.30%
ISAT.JKPT Indosat Ooredoo Hutchison Tbk3.55%$83.7958.49%
PBSA.JKPT Paramita Bangun Sarana Tbk3.55%$55.0071.03%
004800.KSHyosung Corporation3.54%$3,986.8920.54%
6414.TWEnnoconn Corporation3.54%$10.1352.07%
WIHL.STWihlborgs Fastigheter AB (publ)3.54%$3.2044.13%
002081.SZSuzhou Gold Mantis Construction Decoration Co., Ltd.3.53%$0.1270.03%
0RHV.LInvestis Holding S.A.3.53%$5.1018.83%
2760.TTokyo Electron Device Limited3.53%$119.8646.59%
5515.TWChien Kuo Construction Co., Ltd.3.53%$1.2751.00%
600603.SSGuanghui Logistics Co.Ltd3.53%$0.2263.76%