Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the returns for the monthly price data. Each month $500 was withdrawn at the end of the month. How much money was in the
Calculate the returns for the monthly price data. Each month $500 was withdrawn at the end of the month. How much money was in the account at the end of the data? When did the account have the most money? How much was it? When did the account have the least money? How much was it?
Date | PFE | Adj PFE |
12/1/15 | 32.279999 | 27.578041 |
1/1/16 | 30.49 | 26.048777 |
2/1/16 | 29.67 | 25.348219 |
3/1/16 | 29.639999 | 25.577169 |
4/1/16 | 32.709999 | 28.226358 |
5/1/16 | 34.700001 | 29.94359 |
6/1/16 | 35.209999 | 30.655773 |
7/1/16 | 36.889999 | 32.118469 |
8/1/16 | 34.799999 | 30.298807 |
9/1/16 | 33.869999 | 29.734221 |
10/1/16 | 31.709999 | 27.837975 |
11/1/16 | 32.139999 | 28.215467 |
12/1/16 | 31.700001 | 28.106752 |
1/1/17 | 31.73 | 28.133348 |
2/1/17 | 34.119999 | 30.252439 |
3/1/17 | 34.209999 | 30.641256 |
4/1/17 | 33.919998 | 30.38151 |
5/1/17 | 32.650002 | 29.243994 |
6/1/17 | 33.59 | 30.37715 |
7/1/17 | 33.16 | 29.988276 |
8/1/17 | 33.919998 | 30.675583 |
9/1/17 | 35.700001 | 32.600689 |
10/1/17 | 35.060001 | 32.016254 |
11/1/17 | 36.259998 | 33.112072 |
12/1/17 | 36.220001 | 33.377781 |
1/1/18 | 37.040001 | 34.133434 |
2/1/18 | 36.310001 | 33.460716 |
3/1/18 | 35.490002 | 33.008053 |
4/1/18 | 36.610001 | 34.049728 |
5/1/18 | 35.93 | 33.417286 |
6/1/18 | 36.279999 | 34.072186 |
7/1/18 | 39.93 | 37.50008 |
8/1/18 | 41.52 | 38.99332 |
9/1/18 | 44.07 | 41.740551 |
10/1/18 | 43.060001 | 40.783939 |
11/1/18 | 46.23 | 43.786377 |
12/1/18 | 43.650002 | 41.661781 |
1/1/19 | 42.450001 | 40.516441 |
2/1/19 | 43.349998 | 41.736805 |
3/1/19 | 42.470001 | 40.889553 |
4/1/19 | 40.610001 | 39.09877 |
5/1/19 | 41.52 | 39.974907 |
6/1/19 | 43.32 | 42.077835 |
7/1/19 | 38.84 | 37.726295 |
8/1/19 | 35.549999 | 34.530632 |
9/1/19 | 35.93 | 35.226242 |
10/1/19 | 38.369999 | 37.61845 |
11/1/19 | 38.52 | 37.765514 |
12/1/19 | 39.18 | 38.783821 |
1/1/20 | 37.240002 | 36.863441 |
2/1/20 | 38.049999 | 38.049999 |
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