Calculate your Portfolio Performance

How do you measure your portfolio performance if you bought and sold stocks, and received dividends during the year ? You can measure your return using the Internal Rate of Return (IRR).  IRR is used to measure the average annual return when capital were added or withdrawn during the investment period.

This calculation is tougher than expected but it can be easily determined using “XIRR” function in Excel.

XIRR

Note: inflow and outflow of funds are reflected in positive and negative values respectively.

Formula = XIRR (‘select $’, select dates’)

Knowing your rate of return will help you make better financial decisions.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s