Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How can I convert monthly returns to annual returns? I have a stock whose monthly prices I obtained over a 5 year period. Using HPR,

How can I convert monthly returns to annual returns?

I have a stock whose monthly prices I obtained over a 5 year period. Using HPR, I found the monthly returns. I even found the monthly average over a 5 year period. How can I now convert this to annualized returns? Do I raise to 60? Please find data below

Eg: (1 + return %)^60 - 1

Date Walmart
2/1/12 -3.72%
3/1/12 3.59%
4/1/12 -3.10%
5/1/12 11.73%
6/1/12 6.64%
7/1/12 6.76%
8/1/12 -2.46%
9/1/12 2.20%
10/1/12 1.65%
11/1/12 -4.00%
12/1/12 -5.26%
1/1/13 3.09%
2/1/13 1.19%
3/1/13 5.72%
4/1/13 4.53%
5/1/13 -3.71%
6/1/13 0.13%
7/1/13 4.63%
8/1/13 -6.36%
9/1/13 1.96%
10/1/13 3.77%
11/1/13 5.55%
12/1/13 -2.86%
1/1/14 -4.54%
2/1/14 0.03%
3/1/14 2.32%
4/1/14 4.96%
5/1/14 -3.69%
6/1/14 -1.61%
7/1/14 -1.98%
8/1/14 2.61%
9/1/14 1.95%
10/1/14 -0.26%
11/1/14 14.78%
12/1/14 -1.90%
1/1/15 -0.50%
2/1/15 -1.24%
3/1/15 -2.00%
4/1/15 -4.54%
5/1/15 -4.84%
6/1/15 -3.89%
7/1/15 1.48%
8/1/15 -10.07%
9/1/15 0.85%
10/1/15 -11.72%
11/1/15 2.80%
12/1/15 4.18%
1/1/16 9.16%
2/1/16 -0.03%
3/1/16 3.24%
4/1/16 -1.64%
5/1/16 5.85%
6/1/16 3.92%
7/1/16 -0.07%
8/1/16 -2.10%
9/1/16 1.64%
10/1/16 -2.91%
11/1/16 0.59%
12/1/16 -1.86%
1/1/17 -2.75%
2/1/17 6.28%
3/1/17 1.62%
4/1/17 5.07%
5/1/17 4.55%
6/1/17 -3.07%
7/1/17 5.70%
8/1/17 -2.40%
9/1/17 0.72%
10/1/17 11.74%
11/1/17 11.36%
12/1/17 1.56%
1/1/18 8.52%
2/1/18 -15.56%
3/1/18 -1.16%
4/1/18 0.02%
5/1/18 -6.69%
6/1/18 4.42%
7/1/18 4.18%
8/1/18 7.43%
9/1/18 -1.47%
10/1/18 6.78%
11/1/18 -2.62%
12/1/18 -4.61%
1/1/19 3.44%
2/1/19 3.30%
3/1/19 -1.47%
4/1/19 6.01%
5/1/19 -1.36%
6/1/19 9.50%
7/1/19 -0.10%
8/1/19 3.52%
9/1/19 4.38%
10/1/19 -1.20%
11/1/19 1.56%
12/1/19 -0.21%
1/1/20 -3.23%
2/1/20 -5.95%
3/1/20 5.52%
4/1/20 7.45%
5/1/20 2.06%
6/1/20 -3.03%
7/1/20 8.03%
8/1/20 7.30%
9/1/20 1.18%
10/1/20 -0.83%
11/1/20 10.12%
12/1/20 -5.65%
1/1/21 -2.18%
2/1/21 -7.52%
3/1/21 4.55%
4/1/21 3.43%
5/1/21 1.52%
6/1/21 -0.32%
7/1/21 1.08%
8/1/21 3.89%
9/1/21 -5.54%
10/1/21 7.20%
11/1/21 -5.88%
12/1/21 -1.16%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Oxford Handbook Of Sovereign Wealth Funds

Authors: Douglas J. Cumming, Geoffrey Wood, Igor Filatotchev, Juliane Reinecke

1st Edition

0198754809, 978-0198754800

More Books

Students also viewed these Finance questions

Question

Azure Analytics is a suite made up of which three tools?

Answered: 1 week ago