Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started