Dividend Tracker Essentials 模板
Track dividend income from investment holdings. Monitor payment dates, amounts, and yield across dividend-paying stocks and funds.
包含内容
- Dashboard with dividend income summary showing total dividends received, average yield, and projected annual income
- Dividend log with columns for ticker, payment date, ex-dividend date, dividend per share, and total payment amount
- Yield calculations per holding based on current share price and annual dividend amount for each position
- Monthly and annual income totals with automatic summation showing dividend income across all time periods
- Payment frequency tracking with color-coded input cells (yellow) for monthly, quarterly, and annual dividend schedules
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Need more from this template?
The Essentials version covers everyday tracking. Ultimate goes further with multi-entity support, scenario analysis, and ultimate-grade reporting.
- Dashboard with dividend income summary showing total dividends received, average yield, and projected annual income
- Dividend log with columns for ticker, payment date, ex-dividend date, dividend per share, and total payment amount
- Yield calculations per holding based on current share price and annual dividend amount for each position
- Monthly and annual income totals with automatic summation showing dividend income across all time periods
- 跟踪最多30个派息持仓，含代码、股数、成本基础、当前价格、每股年度股息、频率和除息日
- 仪表板包含6个KPI卡片：投资组合总价值、年度股息收入、投资组合收益率、成本收益率、持仓数量和下一个除息日
- 股息历史表记录每笔收到的股息，含日期、代码、股数、每股股息和收到总额
- 月度收入表基于支付频率预测每月预期股息收入，并在预测旁显示实际收到金额
- 成本收益率分析显示原始成本基础、当前成本收益率以及每个持仓的收益率随时间增长情况
预览
查看此模板的内容
如何使用这个Dividend Tracker模板
Enter dividend positions
List each dividend-paying stock or fund with the ticker, shares owned, and current share price.
Log dividend payments
Record each payment with the ticker, payment date, dividend per share, and total amount received.
Review yield
The template calculates yield per holding based on the annual dividend divided by the current share price.
Check income totals
The dashboard shows total dividends received monthly and annually, plus projected annual income based on current holdings.
由 Claude AI 构建，经我们精心打磨。
我们使用 Claude AI 在深入研究后起草每个模板。然后由团队接手，优化布局、全面测试每个公式、修复边界情况，并打磨设计，直到达到我们自己愿意使用的标准。AI 完成了 80% 的工作，最后 20% 靠的是人工判断。
常见问题
How is dividend yield calculated?
Yield equals the annual dividend per share divided by the current share price. The template computes this for each holding automatically.
Does it track ex-dividend dates?
Yes. The log includes an ex-dividend date field so you know the cutoff date for qualifying for each payment.
Can I project future income?
Yes. The projected annual income multiplies each holding current annual dividend by shares owned. The total across all holdings shows expected yearly income.
Does it handle dividend reinvestment?
If you reinvest dividends, update the shares owned when new shares are purchased. The next dividend payment reflects the increased share count.
如何在 Google Sheets 中打开？
将 .xlsx 文件上传到 Google Drive，然后使用 Google Sheets 打开。所有公式和格式都会保留。