Quick Fix Summary
HPR = ((Income + (End Value – Start Value)) / Start Value) × 100. Plug these numbers in once to check your return; for investments with multiple cash flows over time, switch to XIRR in Excel or Google Sheets instead.
What’s Happening
It’s not the same as an annualized return unless you deliberately convert it. Think of HPR as the blunt answer to: “Did I make money on this trade, and how much?”
How do I calculate HPR in Excel?
Grab the Microsoft Support page (2025) if you need the exact syntax—it’s straightforward once you line up your dates and cash flows.
Can I calculate HPR manually?
Let’s say you bought 100 shares at $50 each, collected $200 in dividends, then sold at $60 each. Your HPR lands at 24%. That’s ((200 + (6,000 – 5,000)) / 5,000) × 100. According to the Investopedia definition, this is the standard way pros do it.
What inputs do I need?
- Start Value: What you paid for the shares (or the full portfolio value)
- End Value: What you sold them for (or their current market value)
- Income: All cash you received while holding—dividends, bond coupons, rent, etc.
How does reinvestment affect HPR?
That subtle difference can swing your return by a percentage point or two, so double-check how your broker handled those payouts.
Should I subtract fees and taxes?
Otherwise you’re counting money you never actually kept. That’s the number that matters when you compare one investment to another.
What if my cash flows aren’t regular?
List every date and cash flow—negative for buys, positive for sales and income—and let XIRR annualize the return for uneven intervals. According to the Microsoft Support page (2025), it’s built for exactly this scenario.
What if I made periodic contributions?
IRR assumes regular spacing, so if your deposit dates vary, XIRR is the safer bet. Most folks don’t realize how sensitive the result can be to a single off-schedule payment.
Does HPR change with taxes?
When you compare strategies, apply your marginal capital-gains rate to the gain component. Honestly, this is where most DIY investors leave real money on the table.
How do I keep accurate records?
One row per trade, with columns for Date, Description, and Amount. It sounds tedious, but a five-minute weekly sweep beats hunting for missing payouts come tax time.
How do I reconcile my HPR at year-end?
Most discrepancies pop up because a dividend payout or fee line-item got overlooked. Once you spot the pattern, the fixes are usually simple.
Can I automate HPR calculations?
A single formula can recalculate every position at once. If you’re still typing numbers by hand, you’re doing it the hard way.
Does the IRS care about holding periods?
Update your calendar reminders accordingly. According to the IRS Publication 551 (2025), that one-day shift can push a short-term gain into long-term territory—and save you a bundle in taxes.
What’s the difference between HPR and IRR?
HPR tells you how much you made while you held the stock; IRR tells you what that return would look like if it happened every year. They answer different questions, so pick the right tool for the job.
When should I use XIRR instead of IRR?
IRR assumes regular spacing, so if you’re dollar-cost averaging or making lump-sum purchases on random days, XIRR gives you a far more accurate picture. Most investors never realize how much their IRR estimates drift when dates aren’t evenly spaced.
How do dividends impact HPR?
That’s why two investors in the same stock can report different HPRs: one spent the dividends, the other plowed them back in. The reinvestment choice quietly reshapes your return.
