Holdings
Ticker / Name Shares Price ($) Annual Div/sh ($)
total per year
Sector Frequency Yield Annual Income % Value % Income
Forward Annual Income
Portfolio Value
Blended Yield
Income Distribution
Value Allocation

What each tab calculates

01

Portfolio Builder

Enter all holdings with shares, price, annual dividend, sector and frequency. Auto-calculates yield, income, value weight and income weight per row. Dual doughnut charts for income and value allocation plus three KPI summary cards.

02

Income Analysis

Breaks income down by sector and frequency with visual bars. Builds a 12-month income calendar. Calculates Herfindahl index concentration score and flags over-concentrated positions by income share.

03

Growth Projector

Projects total portfolio income using blended DGR, price growth and optional monthly contributions. Shows multiplier, projected value, total dividends earned, yield on cost, and a dual-axis line chart.

04

Rebalancer

Compares current blended yield against a target or equal-weight goal. Flags over-concentrated positions and generates specific buy/reduce/hold recommendations per holding.

05

Quality Score

Scores each stock 0–100 across yield (20 pts), coverage (25 pts), DGR (25 pts), streak (15 pts) and payout (15 pts). Grades from Excellent to Weak with a portfolio average and ranked bar chart.