Please see the table below. Please be guided by the second rows
to understand the mathematics. Figures in parenthesis, if any, mean
negative values. All financials are in $. The columns highlighted
in yellow contain your answers.
|
|
|
Week 1 |
Week 2 |
Week 3 |
Week 4 |
|
|
|
|
10-Jun |
17-Jun |
24-Jun |
1-Jul |
|
|
|
|
Value/Share |
Value/Share |
Value/Share |
Value/Share |
|
|
|
|
A |
B |
C |
D |
|
|
|
GOOG |
Google |
$1,080.38 |
$1,092.50 |
$1,115.52 |
$1,097.95 |
|
|
|
ORCL |
Oracle |
$54.01 |
$53.13 |
$56.74 |
$58.01 |
|
|
| PG |
Procter
& Gamble |
$108.72 |
$110.99 |
$112.33 |
$110.49 |
|
|
|
AAPL |
Apple |
$192.58 |
$193.89 |
$198.58 |
$201.55 |
|
|
|
AMZN |
Amazon |
$1,860.63 |
$1,886.03 |
$1,913.90 |
$1,922.19 |
|
|
|
|
|
|
|
|
|
|
|
|
Shares Purchased Wk 1 |
Investment Amount Week 1 |
Week 2 Gain/Loss |
Week 3 Gain/Loss |
Week 4 Gain/Loss |
Total Profit Gained/Loss |
|
|
|
N |
|
G1 = (B - A) x N |
G2 = (C - B) x N |
G3 = (D - C) x N |
G1 + G2 + G3 |
| GOOG |
Google |
2.00 |
$2,160.74 |
24.24 |
46.04 |
(35.14) |
35.14 |
| ORCL |
Oracle |
38.00 |
$2,052.38 |
(33.44) |
137.18 |
48.26 |
152.00 |
| PG |
Procter
& Gamble |
18.00 |
$1,956.96 |
40.86 |
24.12 |
(33.12) |
31.86 |
| AAPL |
Apple |
10.00 |
$1,925.80 |
13.10 |
46.90 |
29.70 |
89.70 |
| AMZN |
Amazon |
1.00 |
$1,860.63 |
25.40 |
27.87 |
8.29 |
61.56 |
|
Total |
|
$9,956.51 |
70.16 |
282.11 |
17.99 |
370.26 |
