Dividend Toolkit
Latest dividends, forward/trailing yields, growth, and income forecasts — directly in Sheets.
SheetInvestor is a growing suite of add‑ons for savers and investors. First release: Dividend Toolkit — analyze dividends, calculate yields, and forecast income with approachable, professional‑grade formulas.
Start with Dividend Toolkit today. As we release new tools, this section automatically scales to a full catalog.
Latest dividends, forward/trailing yields, growth, and income forecasts — directly in Sheets.
Holdings import, performance, allocation drift, and risk snapshots.
Join waitlistSimplify budgeting and Expense Tracking.
Join waitlistBuilt for individual investors and financial professionals. Get dividend data, calculate yields, predict next payments, and analyze growth trends — all inside Google Sheets.
Pull recent dividend payments and ex‑dates with smart caching for performance.
Trailing/forward yields, growth rates, and automated trend analysis.
Estimate next payments and projected annual dividend income using historical patterns.
Pre‑built templates to visualize timelines, yields, and portfolio income.
Copy‑paste these formulas directly into your Google Sheets. All functions work with common stock tickers and most ETFs.
=latestDividend("AAPL")
Gets the most recent dividend amount paid.
=lastDividendDate("MSFT")
Returns the date of the most recent dividend payment.
=ytdDividend("JNJ")
Sum of all dividends paid in the current year.
=trailingAnnualDividend("KO")
Total dividends paid over the last 12 months.
=forwardAnnualDividend("PG")
Projected dividend payments for the next 12 months.
=dividendGrowthTrend("HD")
Calculates growth rate and identifies trends.
We ship iteratively, with privacy‑first principles. Your data stays in your spreadsheet. Nothing is sold to advertisers.
Your sheet is your database. We minimize external calls and never sell personal data.
Install Dividend Toolkit and bring institutional‑grade dividend analytics into your spreadsheets.