Definitive Analysis
Loading...
Definitive Analysis

Fundamentals

Mode

Ticker

Industry

Sector

FIBRA Macquarie México (FIBRAMQ12.MX)

Company Dividend Discount ModelIndustry: REIT - IndustrialSector: Real Estate

Valuation Snapshot

Stable Growth$410.48 - $1,090.36$1,021.83
Multi-Stage$155.08 - $169.70$162.25
Blended Fair Value$592.04
Current Price$30.04
Upside1,870.83%
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.48$1,021.83$1,090.36
Upside / Downside1,266.44%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.072,179.532,200.00
Year 2 PV (M)2,565.052,613.912,663.23
Year 3 PV (M)2,962.213,047.243,133.89
Year 4 PV (M)3,350.683,479.543,612.08
Year 5 PV (M)3,730.613,910.794,097.88
PV of Terminal Value (M)108,875.84114,134.59119,594.59
Equity Value (M)123,643.45129,365.60135,301.66
Shares Outstanding (M)797.31797.31797.31
Fair Value$155.08$162.25$169.70
Upside / Downside416.23%440.12%464.91%

High-Yield Dividend Screener

« Prev Page 68 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0316.HKOrient Overseas (International) Limited2.19%$2.7948.77%
3109.TShikibo Ltd.2.19%$22.8930.55%
3679.TZIGExN Co., Ltd.2.19%$10.5526.56%
4516.TNippon Shinyaku Co., Ltd.2.19%$123.8726.14%
4617.TChugoku Marine Paints, Ltd.2.19%$96.7242.42%
600051.SSNingbo United Group Co.,Ltd.2.19%$0.1755.08%
603799.SSZhejiang Huayou Cobalt Co., Ltd2.19%$1.4948.01%
7233.KLDufu Technology Corp. Berhad2.19%$0.0495.65%
9064.TYamato Holdings Co., Ltd.2.19%$48.3336.15%
9948.TARCS Company Limited2.19%$74.0133.92%
000049.SZShenzhen Desay Battery Technology Co., Ltd.2.18%$0.5954.00%
000153.SZAnhui Fengyuan Pharmaceutical Co., Ltd.2.18%$0.1455.80%
002237.SZShandong Humon Smelting Co., Ltd.2.18%$0.2961.47%
002626.SZXiamen Kingdomway Group Company2.18%$0.4354.26%
2468.TWFortune Information Systems Corp2.18%$0.9078.36%
300815.SZEIT Environmental Development Group Co.,Ltd2.18%$0.5038.67%
300910.SZXinxiang Richful Lube Additive Co., Ltd2.18%$1.2345.00%
4908.TWOAPAC Opto Electronics Inc.2.18%$1.7472.09%
601369.SSXi'an Shaangu Power Co., Ltd.2.18%$0.2237.55%
067160.KQSoop Co., Ltd.2.17%$1,492.2515.52%
3898.HKZhuzhou CRRC Times Electric Co., Ltd.2.17%$0.8329.19%
4507.TShionogi & Co., Ltd.2.17%$61.6530.72%
603383.SSFujian Apex Software Co.,LTD2.17%$0.7883.82%
603568.SSZhejiang Weiming Environment Protection Co., Ltd.2.17%$0.5534.14%
7181.TJapan Post Insurance Co., Ltd.2.17%$102.1324.56%
053800.KQAhnLab, Inc.2.16%$1,304.4028.50%
0QI9.LCreades AB2.16%$1.5916.64%
601233.SSTongkun Group Co., Ltd.2.16%$0.3750.52%
605056.SSXianheng International Science&Technology Co., Ltd.2.16%$0.3657.45%
MGICMagic Software Enterprises Ltd.2.16%$0.5669.02%
002311.SZGuangdong Haid Group Co., Limited2.15%$1.1939.51%
3727.TAplix Corporation2.15%$3.4454.78%
603586.SSShandong Gold Phoenix Co.,Ltd2.15%$0.4151.17%
6268.TNabtesco Corporation2.15%$80.7460.45%
ATRLJ-B.STAtrium Ljungberg AB (publ)2.15%$0.7141.67%
BPAN4.SABanco Pan S.A.2.15%$0.2441.77%
NCM.AXNewcrest Mining Limited2.15%$0.5038.39%
PARAUCO.SNParque Arauco S.A.2.15%$62.7342.33%
SHANG.BKShangri-La Hotel Public Company Limited2.15%$1.0056.93%
VZUG.SWV-ZUG Holding AG2.15%$0.9119.03%
WTIF.SGWisdomTree Japan Equity UCITS ETF2.15%$0.9891.42%
002258.SZLier Chemical Co.,LTD.2.14%$0.2848.19%
002605.SZShanghai Yaoji Technology Co., Ltd.2.14%$0.5042.55%
0GZV.ILGetinge AB (publ)2.14%$4.6761.88%
0PMJ.LSiemens Healthineers AG2.14%$0.9549.72%
300482.SZGuangzhou Wondfo Biotech Co.,Ltd2.14%$0.4274.45%
5288.KLSime Darby Property Berhad2.14%$0.0342.63%
603218.SSRiyue Heavy Industry Co., Ltd.2.14%$0.2852.42%
BXB.AXBrambles Limited2.14%$0.4940.03%
POBS.BOPlatinumOne Business Services2.14%$3.0015.69%