Back to Insights

Openbook Author & Co-Founder

Andrew Menzies BA(Hons)

Co-Founder & COO, Openbook Analytics

PositionCo-Founder & COO
OrganisationOpenbook Analytics
EducationBA(Hons) Finance & Economics
ProfileUK & US Equity Valuation

Andrew Menzies BA(Hons) competed in and won stock investing competitions during his Finance & Economics degree course at the University of Strathclyde. As Co-Founder & COO of Openbook Analytics, Andrew writes in-depth stock analyses, valuation models, and market research breakdowns covering UK and US equities.

Focus Areas & Expertise

UK & US EquitiesDCF & Fundamental ValuationAI Hardware & SemiconductorsDefence & AerospacePortfolio StrategyStock Screening

Published Stock Analyses & Insights

46 articles
Individual Stock Analysis11 min read

AIB Group (AIBG) Fundamentals: Irish Mortgages and Deposits

An AIB Group stock analysis of the H1 2026 numbers: net interest margin, Irish mortgage share, capital and the risks behind a 23.2% return on tangible equity. All figures in euro.

Read stock analysis
Saturday Special8 min read

Container Rates To America Are A Policy Price, Not A Demand Signal

Shanghai to New York costs nearly three times Shanghai to Rotterdam. That gap is not American demand. It is the price of a 9 November policy deadline that markets assume away.

Read stock analysis
Individual Stock Analysis10 min read

How Experian (EXPN) Makes Its Money: Credit Data Fundamentals

This Experian stock analysis sets out FY26 revenue of US$8,425m, a 28.6% benchmark EBIT margin and the regional mix behind EXPN shares, plus the dividend, buybacks and leverage picture.

Read stock analysis
Individual Stock Analysis11 min read

Aviva (AV) Shares: Motor Cover, Pensions and Wealth Platforms

An Aviva share price analysis of how the FTSE 100 insurer earns across general insurance, protection and wealth, and what the H1 2026 numbers show.

Read stock analysis
Individual Stock Analysis11 min read

Inside Vodafone (VOD) Shares: German Cable to African Mobile Money

A Vodafone stock analysis of the FY26 results and Q1 FY27 update, covering German broadband, VodafoneThree and African mobile money. Looks at revenue, margins, net debt and the dividend.

Read stock analysis
Individual Stock Analysis10 min read

Imperial Brands (IMB): What the Fundamentals Show in Five Markets

An Imperial Brands stock analysis of the FY2025 and H1 FY2026 figures. It covers the five priority markets, NGP growth, cash conversion and the dividend.

Read stock analysis
Saturday Special8 min read

The Ten Year Has Stopped Taking Its Orders From The Federal Reserve

The ten-year Treasury yield has detached from the Fed policy path. Soft payrolls no longer rescue long bonds, so equity rallies built on weak growth data are borrowed.

Read stock analysis
Individual Stock Analysis11 min read

Tesco (TSCO) Shares: Grocery Scale, Booker and Loyalty Data

A Tesco stock analysis grounded in the FY2025/26 preliminary results. It covers segment margins, UK market share, free cash flow and the reported Central Europe sale.

Read stock analysis
Individual Stock Analysis10 min read

Prudential (PRU) Shares Explained: Asia and Africa Life Cover

Prudential stock analysis for London listed insurer PRU: how it earns new business profit across Asia and Africa, and what the H1 2026 figures showed.

Read stock analysis
Individual Stock Analysis10 min read

Wires, Wind Farms and Hydro Dams: SSE (SSE) Stock Analysis

SSE stock analysis for the FY2026 results, the RIIO-T3 price control and a 33 billion pound capital plan. What the numbers show and what would change them.

Read stock analysis
Individual Stock Analysis10 min read

What Drives Coca Cola Europacific (CCEP) Shares: Europe to Australia

This Coca-Cola Europacific Partners (CCEP) stock analysis looks at the bottler behind the brand: H1 2026 revenue, margins, net debt and the dividend.

Read stock analysis
Saturday Special8 min read

Long Gilts Have Lost Both Of Their Sellers And The Curve Has Not Noticed

The Bank of England has quietly stopped selling long gilts to the market, and the DMO has cut long issuance to 9 percent of its remit. Both sellers of duration are gone. The curve has not repriced.

Read stock analysis
Individual Stock Analysis10 min read

Haleon (HLN): What the Fundamentals Show in the Medicine Cabinet

This Haleon stock analysis covers the consumer health group behind Sensodyne and Panadol: FY2025 and H1 2026 figures, margins, dividend and risks.

Read stock analysis
Individual Stock Analysis10 min read

3i Group (III) Fundamentals: Private Equity and Discount Retail

This 3i Group stock analysis examines how Action came to be three quarters of the portfolio, and what the latest NAV, dividend and gearing figures show.

Read stock analysis
Individual Stock Analysis10 min read

How Merck (MRK) Makes Its Money: Oncology and Vaccine Fundamentals

A Merck stock analysis of where MRK earns its revenue across oncology, vaccines and animal health, and what the 2028 Keytruda patent expiry changes.

Read stock analysis
Saturday Special8 min read

AI Spending Has Become An Inflation Problem Before A Productivity Gain

The AI build-out has become a macroeconomic demand shock, and it is the marginal reason the Fed is close to hiking. Investors hold AI equities as shelter from the tightening they are causing.

Read stock analysis
Individual Stock Analysis11 min read

Standard Chartered (STAN) Stock Analysis 2026: Asia Trade Corridors

A Standard Chartered stock analysis of the FTSE 100 bank: H1 2026 income, returns and capital, and the Asian trade and wealth flows behind the numbers.

Read stock analysis
Saturday Special8 min read

The FTSE 250 Hit A Record Because Its Companies Are Being Bought

The FTSE 250 record high is a supply signal, not a recovery signal. Mid-cap Britain is being bought and delisted faster than it is being replaced, and the index rises as the market shrinks.

Read stock analysis
Individual Stock Analysis10 min read

RELX (REL) Shares: Legal, Scientific and Risk Data Subscriptions

A RELX stock analysis of how the FTSE 100 information group earns its revenue, and what the latest reported growth, margin and debt figures show.

Read stock analysis
Individual Stock Analysis10 min read

Reckitt Benckiser (RKT): What the Fundamentals Show in Germ Protection

A Reckitt Benckiser stock analysis of the H1 2026 numbers: revenue, margins, dividend, the Essential Home disposal and the unresolved Mead Johnson exit.

Read stock analysis
Individual Stock Analysis9 min read

Breaking Down Netflix (NFLX) Shares: Subscriptions and Ad Breaks

A Netflix stock analysis of the streaming business: Q2 2026 revenue, margins, the advertising build-out, free cash flow and what to watch from here.

Read stock analysis
Individual Stock Analysis11 min read

Concentrate, Bottlers and Brands: Coca-Cola (KO) Stock Analysis

A Coca-Cola stock analysis of the concentrate model, second quarter 2026 results, unit case volume, the dividend record and the risks now in play.

Read stock analysis
Individual Stock Analysis10 min read

A Closer Look at Palantir (PLTR) Shares: Defense and Enterprise

A Palantir stock analysis grounded in the Q2 2026 results: 93 percent revenue growth, the US government and commercial split, margins, cash and dilution.

Read stock analysis
Individual Stock Analysis11 min read

Glencore (GLEN) Shares: Copper, Coal and a Global Trading Desk

A Glencore share price analysis of the miner and its trading desk: what the H1 2026 numbers showed, how cash gets returned, and the risks to watch.

Read stock analysis
Individual Stock Analysis10 min read

BAE Systems (BA): What the Fundamentals Show in Jets and Ships

A BAE Systems stock analysis of the FTSE 100 defence group: what its five segments earn, what the H1 2026 numbers show, and which risks matter most.

Read stock analysis
Individual Stock Analysis11 min read

Compass Group (CPG) Stock Analysis 2026: Canteens and Contracts

A Compass Group stock analysis of the FTSE 100 caterer: how contract catering earns its margin, what FY2025 and H1 2026 show, and what to watch.

Read stock analysis
Individual Stock Analysis9 min read

Inside Costco Wholesale (COST) Shares: Membership Fee Economics

Costco stock analysis: how membership fees, an 11% gross margin and steady warehouse openings shape what COST actually reports each quarter.

Read stock analysis
Individual Stock Analysis11 min read

Oracle (ORCL) Fundamentals: Databases, ERP and Cloud Capacity

An Oracle stock analysis grounded in fiscal 2026 results: $67.4bn revenue, a $638bn contracted backlog and $55.7bn of capex. What the numbers show and what to watch.

Read stock analysis
Individual Stock Analysis10 min read

What Drives Procter and Gamble (PG) Shares: Laundry to Diapers

A Procter and Gamble (PG) stock analysis grounded in the fiscal 2026 results: organic sales, margins, the dividend record and the fiscal 2027 cost headwinds worth watching.

Read stock analysis
Saturday Special8 min read

Gold Is Right About This Jobs Report And The Nasdaq Is Not

Stocks and gold both rallied on the July payrolls miss, but they are pricing opposite outcomes. Gold has it right. The report said nothing about the inflation the Fed is actually fighting.

Read stock analysis
Individual Stock Analysis10 min read

Eli Lilly (LLY) Fundamentals: Diabetes, Obesity and Oncology

This eli lilly stock analysis examines Q1 2026 earnings, the revenue contributions from Mounjaro, Zepbound and Foundayo, the growing oncology pipeline, dividend profile, balance sheet and current LLY valuation multiples. Understand the key drivers and risks shaping Eli Lilly's fundamental picture in 2026.

Read stock analysis
Individual Stock Analysis10 min read

Breaking Down Exxon Mobil (XOM) Shares: Guyana and the Permian

An Exxon Mobil (XOM) stock analysis of the Q2 2026 numbers, the Guyana and Permian growth engines, capital returns and the risks worth watching.

Read stock analysis
Individual Stock Analysis11 min read

From PCs to AI Accelerators: Advanced Micro Devices (AMD) Shares

An AMD stock analysis of the second quarter 2026 numbers: data center growth, margins, cash, the Helios accelerator ramp and the risks to track.

Read stock analysis
Individual Stock Analysis10 min read

How Mastercard (MA) Makes Its Money: Payments Network Fundamentals

A Mastercard (MA) stock analysis grounded in reported figures: how the network earns its fees, what the latest quarter showed, and what to watch next.

Read stock analysis
Individual Stock Analysis10 min read

Inside Walmart (WMT) Shares: Grocery Scale and Retail Media

This Walmart stock analysis examines how WMT's grocery market dominance is fuelling a fast-growing retail media and membership business, with data from the Q1 FY27 earnings release (reported 21 May 2026) and full-year FY26 results.

Read stock analysis
Individual Stock Analysis11 min read

GlaxoSmithKline PLC (GSK) Stock Analysis 2026: Vaccines Pipeline, Dividend Cover and Balance Sheet Fundamentals

This GSK stock analysis examines GlaxoSmithKline's Q2 2026 results, vaccines pipeline momentum, dividend cover and balance sheet position following the Nuvalent acquisition. Explore the key financial metrics and risks shaping the investment case in 2026.

Read stock analysis
Individual Stock Analysis10 min read

Broadcom Inc (AVGO) Stock Analysis 2026: Earnings, AI Chip Growth and Balance Sheet Fundamentals

This Broadcom stock analysis examines AVGO's Q2 FY2026 earnings, record AI chip revenue growth, balance sheet structure, dividend cover, and valuation multiples — so you can assess the fundamentals for yourself.

Read stock analysis
Individual Stock Analysis10 min read

SpaceX (SPCX) Stock Analysis 2026: Fundamentals, Growth Drivers and What the Financials Show

This SpaceX (SPCX) stock analysis examines the company's first public financials, covering 2025 revenue of $18.67 billion, segment results across Starlink, space and AI, and the valuation multiples applied after the record-breaking June 2026 IPO.

Read stock analysis
Individual Stock Analysis11 min read

Shell plc (SHEL) Stock Analysis 2026: Earnings, Dividend Cover and Balance Sheet Signals

This Shell plc share price analysis examines the company's Q1 2026 earnings beat, dividend cover, balance sheet trends and the strategic implications of the ARC Resources acquisition. Explore the key financial signals and risks shaping the investment case for SHEL in 2026.

Read stock analysis
Individual Stock Analysis11 min read

Rio Tinto plc (RIO) Stock Analysis 2026: Iron Ore Margins, Dividend Cover and Balance Sheet Strength

This rio tinto stock analysis examines the key financial metrics from Rio Tinto plc's (RIO) 2025 full year results, including iron ore margins, dividend cover, balance sheet leverage and valuation multiples. Understand the drivers, the risks and what to watch next.

Read stock analysis
Markets6 min read

Why AI Infrastructure Stocks Keep Climbing

AI infrastructure stocks keep climbing as hyperscaler capex nears $700bn in 2026. Here is what is driving the rally and how Openbook scores the theme.

Read stock analysis
Markets6 min read

Why UK Defence Stocks Are Rallying

UK defence stocks are rallying as NATO targets 5% of GDP and global military spending hits a record $2.9tn. Here is what is driving it and how the theme scores.

Read stock analysis
Stock Analysis6 min read

Micron (MU) Stock Analysis 2026: Reward 60, Risk 72

Micron (MU) stock analysis 2026: record AI memory profits, a 60 Reward Score and a 72 Risk Score. Why the model is less impressed than the headlines.

Read stock analysis
Stock Analysis7 min read

Filtronic (FTC) Stock Analysis 2026: Priced for Perfection

Filtronic scores 76 reward, 45 risk on Openbook. A net cash RF business with a record order book, but momentum drives the score and analysts now see downside.

Read stock analysis
Markets5 min read

The Openbook Top Stocks Portfolio: +17.5% in Five Months

Our Top Stocks portfolio is up 17.5% over the first five months of the year against 4.3% for the FTSE All-Share — roughly four times the index. An honest breakdown of what drove it, including how much rode on just three names.

Read stock analysis
Research Tools5 min read

Best UK Stock Analysis Tools & Comparison Guide

Transparent, Openbook-authored comparison of UK stock research tools, factor models, and screening features.

Read stock analysis