Personal Finance & Money Asked on March 21, 2021
Searching for "how to annualize interest rates" on Google leads to the following results:
Recommends the following formula:
Year-to-Date Return = Percentage Return * Time Factor
Where:
Recommends this other formula:
AP = ((P + G) / P) ^ (365 / n) - 1
Where:
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%
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?
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
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP