The Dividend Income Mastery Guide – Bundle

1. Dividend Calendar Template

A six-worksheet Excel workbook designed to help investors organize dividend-paying holdings, estimate payment schedules, examine upcoming distributions, and plan dividend income timing.

Tab 1: READ ME

Introduces the workbook and explains the five-step workflow for entering holdings, examining estimated dividend schedules, using the printable calendar, monitoring upcoming payments, and configuring reference settings. Includes guidance about sample data, changing payment dates, and the limitations of estimated dividend information.

Tab 2: HOLDINGS INPUT

Provides a customizable holdings table with fields for ticker symbol, company name, shares owned, dividend payment frequency, estimated dividend per share, payment months, payment day, and notes. Includes five illustrative holdings covering quarterly and monthly dividend payment patterns.

Tab 3: DIVIDEND SCHEDULE BUILDER

Contains a dividend payment planning table referencing information from the holdings worksheet. Includes expected payment date, ticker, company, share quantity, payment frequency, estimated dividend amount, and notes. Provides a total projected dividend field based on the workbook's sample schedule.

Tab 4: CALENDAR VIEW

Provides a printable six-month dividend payment calendar arranged in monthly layouts. Includes weekday headers and date grids for visual reference. The supplied calendar is a fixed layout rather than a live-updating calendar linked to actual dividend announcements.

Tab 5: UPCOMING PAYMENTS LIST

Provides a payment tracking table with monthly dividend totals and an upcoming payments register. Includes fields for payment date, ticker, company, dividend frequency, estimated amount, and payment month. Designed to organize scheduled distributions after the underlying date and reference issues are corrected.

Tab 6: SETTINGS & LISTS

Contains configurable reference information for monthly, quarterly, semiannual, and annual dividend frequencies. Includes month abbreviations and projection settings such as the selected planning period and reference date.

2. Dividend Reinvestment Projection Model

A seven-worksheet Excel resource containing illustrative 20-year projections comparing dividend reinvestment with receiving dividends as cash. Includes editable assumption fields, pre-calculated examples, milestone comparisons, and educational explanations.

Tab 1: READ ME

Introduces Dividend Reinvestment Plans (DRIP), explains dividend compounding, and provides instructions for navigating the workbook. Includes an example scenario using a $50,000 starting portfolio, $500 monthly contributions, 3.5% dividend yield, 5% annual dividend growth, and 7% share price growth.

Tab 2: INPUT ASSUMPTIONS

Provides editable fields for starting portfolio value, monthly contributions, starting dividend yield, dividend growth rate, share price growth rate, reinvestment frequency, tax drag, dividend tax rate, and projection period. Contains the illustrative example assumptions used throughout the supplied workbook.

Tab 3: PROJECTION WITH DRIP

Presents a 20-year example projection showing dividend reinvestment. Includes year number, starting portfolio value, annual contributions, dividends earned, dividends reinvested, estimated price growth, ending portfolio value, and cumulative dividends. The supplied numerical results are pre-calculated values.

Tab 4: PROJECTION WITHOUT DRIP

Contains a corresponding 20-year projection illustrating dividend distributions received as cash rather than reinvested. Includes starting value, annual contributions, dividends paid, cumulative cash dividends, price appreciation, ending investment value, and estimated total assets.

Tab 5: SCENARIO COMPARISON

Provides side-by-side results for DRIP and non-DRIP examples at Years 5, 10, 15, and 20. Includes portfolio value comparisons, estimated differences, percentage advantage calculations, and cumulative dividend summaries.

Tab 6: CHARTS & RESULTS DASHBOARD

Provides a visual results summary containing the example final portfolio values with and without DRIP, their estimated difference, and year-by-year comparison data. Includes presentation tables and illustrative chart information.

Tab 7: SETTINGS

Explains model assumptions and limitations, including annual compounding, constant growth rates, simplified taxation, excluded transaction costs, and the absence of market volatility. Includes conservative, moderate, and higher-yield example assumption ranges and reminders about inflation and dividend sustainability.

3. Dividend Stock Analyzer Spreadsheet

A six-worksheet Excel research workbook designed to help investors evaluate dividend-paying companies using financial inputs, payout ratios, financial strength metrics, safety scores, and structured risk indicators.

Tab 1: READ ME

Introduces the dividend stock analysis process and provides instructions for entering financial data, calculating dividend metrics, examining safety scores, identifying dividend risks, and using the dashboard. Defines dividend yield, payout ratio, free cash flow coverage, debt-to-equity, interest coverage, and dividend safety ratings.

Tab 2: STOCK INPUTS

Provides the main company research table with fields for ticker, company name, sector, current share price, annual dividend per share, dividend frequency, earnings per share, dividend yield, payout ratio, and other financial indicators. Includes formula fields for dividend safety scores and risk flags, with five illustrative company entries.

Tab 3: LOOKUP LISTS

Contains reference lists for stock market sectors and dividend payment frequencies. Includes configurable risk thresholds for high payout ratios, excessive debt, weak interest coverage, insufficient free cash flow coverage, potential dividend traps, and minimum dividend safety scores.

Tab 4: SAFETY SCORE MODEL

Explains the workbook's weighted dividend safety framework, covering payout ratio, dividend consistency, debt levels, interest coverage, free cash flow coverage, and dividend growth. Includes point allocations, rating explanations, and an illustrative safety score calculation.

Tab 5: RESULTS DASHBOARD

Provides a consolidated dividend research dashboard with fields for total stocks analyzed, average dividend yield, average safety score, strong-rated stocks, risk flags, and potential dividend traps. Includes Top 10 Safest Dividends and Top 10 Highest Yield comparison tables.

Tab 6: WATCHLIST & ALERTS

Provides separate risk monitoring sections for high payout ratios, excessive debt, weak financial coverage, and potential dividend traps. Includes columns for ticker, company, risk metric, metric value, warning threshold, suggested next action, and additional notes.

4. Portfolio Income Tracker

A six-worksheet Excel portfolio management resource designed to organize dividend holdings, record actual payments, estimate income, monitor portfolio allocations, and assess selected concentration risks.

Tab 1: READ_ME

Introduces the Portfolio Income Tracker and its five-step workflow covering settings, holdings entry, payment logging, income analysis, and allocation monitoring. Includes workbook navigation, color-coded input guidance, example data instructions, and suggested weekly and monthly maintenance activities.

Tab 2: HOLDINGS

Provides a detailed portfolio holdings table with fields for ticker, company, sector, shares owned, cost basis, current market price, annual dividend per share, and calculated financial metrics. Includes portfolio summaries for total cost basis, market value, unrealized gain or loss, forward dividend income, portfolio yield, and yield on cost.

Tab 3: DIVIDEND_PAYMENTS_LOG

Provides a historical dividend payment register for tracking received income. Includes payment date, ticker, share quantity, dividend per share, total dividend, qualified or ordinary classification, reinvestment status, account type, and notes. Contains summaries for cumulative income, year-to-date payments, and recent dividend activity.

Tab 4: INCOME_DASHBOARD

Provides an income monitoring dashboard containing dividend income year-to-date, income over the previous twelve months, estimated forward income, monthly averages, payment counts, qualified and ordinary dividends, and reinvestment information. Includes monthly income tracking and breakdowns by stock, sector, and account type.

Tab 5: ALLOCATION_RISK

Provides portfolio concentration and diversification tables. Includes individual holdings, market value, portfolio weight, concentration warnings, and sector-level exposure. Contains summary metrics for largest position, number of positions exceeding limits, largest sector allocation, and overall diversification status.

Tab 6: SETTINGS_LISTS

Contains reference lists for sectors, dividend payment frequencies, account types, and dividend classifications. Includes configurable concentration thresholds for single positions, individual sectors, and income sources, along with a new-holding checklist and suggested portfolio maintenance schedule.

5. Tax Optimization Calculator

A seven-worksheet Excel resource designed for simplified U.S. dividend tax scenario analysis. Includes editable investor information, qualified and ordinary dividend inputs, estimated tax calculations, account type comparisons, and an after-tax income summary.

Tab 1: READ ME

Introduces the educational dividend tax calculator and explains how to enter personal tax assumptions, organize dividend income, examine estimated federal and state taxes, compare account types, and interpret after-tax income results. Includes explanations of qualified dividends, ordinary dividends, and tax-advantaged investment accounts.

Tab 2: USER TAX PROFILE

Provides editable fields for filing status, U.S. state, annual ordinary income, expected qualified dividends, expected ordinary dividends, and dividend holding period information. Includes calculation fields for total annual income and total dividend income, with sample figures for demonstration.

Tab 3: DIVIDEND INCOME INPUTS

Provides two methods for recording dividend income: simple annual qualified and ordinary dividend totals, or optional ticker-by-ticker entries. The detailed table includes ticker, investment account type, qualified dividends, ordinary dividends, total dividends, and notes.

Tab 4: TAX CALCULATIONS

Provides a simplified tax estimation worksheet with income summaries, estimated federal tax on ordinary income, qualified dividend tax assumptions, state tax estimates, and combined dividend tax calculations. Includes fields for total dividend income, estimated taxes, and after-tax income.

Tab 5: ACCOUNT TYPE COMPARISON

Compares illustrative tax treatment across taxable brokerage accounts, Roth IRA/401(k), Traditional IRA/401(k), and HSA accounts. Includes estimated taxes, after-tax income, potential tax differences, and educational notes about account placement, dividend classifications, and withdrawal considerations.

Tab 6: SUMMARY DASHBOARD

Provides a consolidated summary of qualified and ordinary dividend income, estimated federal and state dividend taxes, after-tax dividend income, and effective dividend tax rate. Includes educational account placement observations and suggested charts for visualizing income and tax differences.

Tab 7: SETTINGS

Provides editable assumptions for ordinary income tax rates, qualified dividend tax rates, income thresholds, and state income taxes. Includes reference rates for selected U.S. states and notes explaining the limitations of simplified tax estimates. Some supplied reference thresholds are labeled as 2024 estimates and require updating.

Please note that this is a digital product, so no physical product will be shipped to you.

Upon purchase, you will receive an email containing a secure download link to a compressed folder containing multiple Excel workbooks consisting of approximately 5 files.

Please ensure you enter a valid email address at checkout and check your spam or promotions folder if you do not see the delivery email in your main inbox.

If our emails are delivered to your Spam or Promotions folder, please mark them as Not Spam and move them to your Primary Inbox. This helps ensure uninterrupted access to your purchases and future communications.