Stock Analysis
Stock screener in excel - a complete dashboard that ranks a twelve-ticker watchlist by P/E, dividend yield, beta, ROE, operating margin, and market cap, with scenario thresholds, scoring, and educational sizing in one workbook.
Stock analysis in Excel that pulls live price, valuation multiples, profitability, leverage, technicals, and peer comparisons into one workbook with MarketXLS formulas. Six-sheet template plus static sample included.
Earnings data in Excel, pulled live with MarketXLS formulas for EPS, revenue, growth rates, consensus estimates, and the next reporting date across 25 large-cap names.
Operating leverage screener excel - rank stocks by Degree of Operating Leverage, margin trajectory, and growth so you can find names where revenue gains are amplifying into earnings growth this Q1 2026 earnings season. Free MarketXLS template inside.
Pull S&P 500 historical data into Excel: ^GSPC or SPY index levels with =Adjusted_Close_Historical, component prices, sector weights, and multi-year returns with MarketXLS.
Quality compounders screener excel - download a May 2026 template that ranks 20 large-cap candidates on six compounder pillars (ROIC, ROE, operating margin, debt-to-equity, revenue growth, free cash flow) and surfaces high-conviction picks via a live MarketXLS scoring engine.
Pricing power screener Excel template that ranks 28 large-cap candidates on gross margin, operating margin, revenue growth, and ROE, with a composite Pricing Power Score for May 2026.
Retail earnings tracker excel - download a Q1 2026 watchlist for Walmart, Home Depot, Lowe's, Target, Costco, TJX, Best Buy, and Dollar General with live MarketXLS formulas, scenario analysis, and a position-sizing model that updates automatically.
Screen stocks by EV/EBITDA in Excel: rank 28 large caps by enterprise multiple, sector fair-value band, and quality tilt with MarketXLS formulas.
A free Excel screener that ranks US companies by net cash (total cash minus total debt), adds ROE and free cash flow to a quality score, and flags pass or review.
A free Excel screener that ranks stocks by interest coverage ratio (EBIT divided by interest expense), flags weak coverage, and stress-tests EBIT cuts and rate shocks.
Owner earnings = net income + D&A +/- other non-cash items - maintenance capex - working capital increase. A free Excel calculator for 20 stocks with a two-stage DCF.
A free Excel tracker that measures how consensus EPS estimates and 1-year price targets changed over 30 and 60 days for 25 large-cap stocks, using MarketXLS formulas.
A free Excel dashboard for S&P 500 Dividend Aristocrats (25+ years of dividend increases): yield, payout ratio, streak length, sector comparison, and reinvested-income projection.
Berkshire Hathaway portfolio tracker Excel - track Warren Buffett's publicly disclosed equity holdings with live MarketXLS prices, ROE, debt-to-equity, dividend yield and a quality score, all in one Excel workbook for May 2026.
Forward earnings yield dashboard excel - download a premium Q2 2026 valuation screener that compares forward earnings yield against the 10-year Treasury, with KPI tiles, sector heatmaps, scenario analysis, and live MarketXLS formulas.