Newbie: How do I calculate annualized performance of investments?

I'm a newbie to numbers. I want to calculate the annualized return of investments. How much has it grown since a certain date and convert that to an annualized number. As example, I have some investments made in May of 2017 and some made in November of 2017. I know their individual gains but that seems apples and oranges because they've been in for different times. I have all dates and amounts.

iMac, Mac OS X (10.6.8), Also using MacBook Air with 10.6.8

Posted on Dec 26, 2017 6:35 AM

Reply
4 replies

Dec 27, 2017 5:07 PM in response to CraigT54

I think you are correct in assuming that's really an apples to oranges comparison. It generally doesn't make sense to compare two different investments over two different time periods. And generally it is not a good idea to try to annualize the returns of investments held less than a year.


It does, on the other hand, make sense to annualize the returns on investments held longer than a year for comparison purposes. They are most often compared against the annualized returns of a "benchmark" (for example, the S&P 500 index) for the same time period or another investment held in the same time period. If you encounter that situation, just post and I can suggest ways of calculating that in Numbers.


SG

Dec 27, 2017 9:05 AM in response to CraigT54

By investments do you mean an investment portfolio or do you mean capital investments by, say, a company. Generally it's not meaningful (an in fact is frowned on in the investment profession) to annualize returns on investments held less than a year.


For investments held longer than a year there are various ways to calculate returns that generally do not involve the XIRR function. Do you have cash inflows and outfows (contributions and withdrawals)?


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Newbie: How do I calculate annualized performance of investments?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.