TransWikia.com

Proper way to annualize returns

Personal Finance & Money Asked on March 21, 2021

Searching for "how to annualize interest rates" on Google leads to the following results:

  1. Wikihow’s How to Annualize a Percentage
  2. Investopedia’s Annualized Rate of Return

Wikihow

Recommends the following formula:

Year-to-Date Return = Percentage Return * Time Factor

Where:

  • Percentage Return = how much you made as a percentage since Jan 1
  • Time Factory = 365 divided by the number of days since Jan 1

Investopedia

Recommends this other formula:

AP = ((P + G) / P) ^ (365 / n) - 1

Where:

  • AP = Annualized Performance Rate
  • P = principal, or initial investment
  • G = gains or losses
  • n = number of days

Example

Suppose that I started with $10k, made a non-compounded return of 10% and today is Mar 15 (so that 73 days passed since Jan 1). Using the formulas above I would get two different answers:

Roi_Wikihow = 0.1 * 365 / 73 = 0.5 = 50%
Roi_Investopedia = (($10,000 + $1,000 / $10,000) ^ (365 / 73) - 1 = 0.61051 = 61%

Question

It seems to me that Wikihow’s approach doesn’t compound the returns, whereas Investopedia does. That is, the former calculates an APR (annual percentage rate), whereas the latter calculates an APY (annual percentage yield). Is this correct?

2 Answers

Yes, the difference between the two formulas is based on whether the investment is compounding or not. Your first link states this:

Take note that the effective annualized rate will depend on how often the interest compounds.

For example, if you buy a stock that pays a 5% dividend and each quarter you withdraw and spend it for living expense, your ROI remains the same. OTOH, if you reinvested the dividend, you'd achieve compound growth. Hence the reason for two different formulas.

Correct answer by Bob Baerker on March 21, 2021

I use Excel's built-in =RRI() function: "Returns an equivalent interest rate for the growth of an investment."

In your case, =RRI(73,10000,11000) = 0.13065% compound growth per day. Multiply that by 365 to get 47.69% CAGR.

Then I verified that with =10000*(1+0.13065%)^73, the answer to which is $11,000.02`.

Answered by RonJohn on March 21, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP