+1 (208) 254-6996 [email protected]
  

This one.

Portfolio
Account Number Last Name First Name
367459 Hyat Kato
Purchase Date Commodity Purchase Price Current Value Standard Deviation Frequency of Occurrence
8/4/14 CD $ 20.00 $ 65.00 $ 20.00
12/22/14 Stock $ 17.00 $ 40.00 $ 40.00
4/3/15 Bond $ 10.00 $ 35.00 Variance $ 60.00
8/13/15 Bond $ 7.00 $ 45.00 $ 80.00
10/20/15 Stock $ 17.00 $ 18.02 $ 100.00
12/11/15 CD $ 20.00 $ 25.65
9/1/16 CD $ 10.00 $ 12.50
11/28/16 Bond $ 24.00 $ 28.00
8/10/17 CD $ 25.00 $ 27.50
8/12/17 Bond $ 6.00 $ 10.00
11/12/17 Bond $ 9.00 $ 10.54
11/22/17 CD $ 24.00 $ 30.00
3/2/18 Bond $ 19.00 $ 32.12
5/21/18 Stock $ 14.00 $ 75.00
9/7/18 Stock $ 18.00 $ 60.00
7/22/19 CD $ 9.00 $ 13.50
3/6/20 Stock $ 15.00 $ 110.00
7/13/20 Stock $ 20.00 $ 75.00
10/25/20 CD $ 15.00 $ 15.90
Trend
Date Purchase Price Current Value Correlation
1/1/90 $ 5.00 $ 6.50
1/1/95 $ 10.00 $ 11.00
1/1/00 $ 15.00 $ 13.75
1/1/05 $ 20.00 $ 21.25
1/1/10 $ 25.00 $ 26.75
1/1/15 $ 30.00 $ 35.00
1/1/20 $ 35.00 $ 36.45

Don't use plagiarized sources. Get Your Custom Essay on
Exp19_Excel_Ch08_ML1_Portfolio_Analysis
Just from $13/Page
Order Essay

Order your essay today and save 10% with the discount code ESSAYHELP