Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Connect and Engage
The Community Meetup
The Water Cooler
The Lounge
Beta
Home
Quicken Classic for Windows
Reports (Windows)
Last Year's Investments/Portfolio Total Return as Percent
netguydave
I want to see what my percent of Total Return is from last year. Is there a report that can show this? Thanks
Find more posts tagged with
Accepted answers
All comments
Jim_Harman
Try the Investing > Investment Performance report. Set to Yearly and 2020. You can group by account or security if you want. It reports the Average annual return which is the same as IRR.
netguydave
Is the IRR for the entire year of 2020 going to be the same percent as the portfolio's Total Return? When I do Total Rate of Return in Excel I get a different % than the IRR. Calculating IRR in Excel would be far more work than it's worth to compare to Quicken. Thanks.
Jim_Harman
I don't know what calculation you are using for "total rate of return" but it you compare the result of Excel's XIRR function to the Investment Performance Report you will see that they are the same.
Caveats:
-- When Quicken does a report for 1/1 to 12/31, it uses the prior year's 12/31 closing prices as the starting prices for the year, as it should.
-- The calculations may vary slightly because IIRC Quicken does not account for the extra day in leap years in its calculations.
-- When you are grouping by account, make sure "No security (includes cash)" is included in your security selections.
-- Remember that published returns for securities generally assume that dividends were reinvested and of course there were no purchases or sales during the period. if you did something different your results will also differ.
Please let us know how it goes.
Jim_Harman
For a further discussion of IRR / Avg Annual Return / XIRR see this discussion
https://community.quicken.com/discussion/7637790/irr-calculations-wrong-within-q-2018-upgrade
netguydave
Thank you very much, Jim. Very helpful.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of
