# Sheets Dividend Workbook

Starter holdings table for Capiaro Sheets.

| Ticker | Shares | Next | TTM |
| --- | --- | --- | --- |
| AAPL | 10 | =DIVIDENDNEXT("AAPL") | =DIVIDENDTTM("AAPL") |
| MSFT | 5 | =DIVIDENDNEXT("MSFT") | =DIVIDENDTTM("MSFT") |
| VYM | 20 | =DIVIDENDNEXT("VYM") | =DIVIDENDTTM("VYM") |
| SCHD | 50 | =DIVIDENDNEXT("SCHD") | =DIVIDENDTTM("SCHD") |
| JEPI | 15 | =DIVIDENDNEXT("JEPI") | =DIVIDENDTTM("JEPI") |

Portfolio forecast: `=DIVIDENDFORECAST(A2:A6, B2:B6)`

HTML: https://www.capiaro.com/sheets/template