Company | St dev | Return | ||
Woolsworth Group Limited | 3.99% | 1.78% | R1 | |
CBA | 4.35% | 0.63% | R1 | |
Wesfarmers Limited | 4.49% | 1.44% | R1 | |
NAB | 4.53% | 0.84% | R2 | |
Woodside Petroleum | 5.27% | 1.02% | R2 | |
ANZ Bank | 5.28% | 0.82% | R2 | |
Ramsay Health Care | 5.51% | 0.29% | R3 | |
APA Group | 5.68% | 1.04% | R3 | |
BHP | 5.74% | 2.18% | R4 | |
Oil Search Limited | 5.97% | 0.23% | R4 | |
R1 | 3.99% to 4.49% | |||
R2 | 4.99% to 5.28% | |||
R3 | 5.29% to 5.68% | |||
R4 | 5.68% to 5.97% | |||
Portfolio Creation | ||||
Constraint | ||||
Risk 1 Bucket | Less than 20% | |||
#REF! | #REF! | |||
Company | St dev | Return | ||
Woolsworth Group Limited | 0.039875127 | 0.01781963 | R1 | C1 |
CBA | 0.043532482 | 0.006263098 | R1 | C3 |
Wesfarmers Limited | 0.044870981 | 0.014434264 | R1 | C1 |
NAB | 0.045288508 | 0.008402132 | R2 | C3 |
Woodside Petroleum | 0.052687559 | 0.010164232 | R2 | C2 |
ANZ Bank | 0.05282242 | 0.0082295 | R2 | C3 |
Ramsay Health Care | 0.055076821 | 0.002875178 | R3 | C4 |
APA Group | 0.05676708 | 0.010384686 | R3 | C4 |
BHP | 0.057414877 | 0.021766103 | R4 | C2 |
Oil Search Limited | 0.059734142 | 0.00228004 | R4 | C2 |
C1 | ||||
Woolsworth Group Limited | 0.1 | 0.01781963 | R1 | |
Wesfarmers Limited | 0.1 | 0.014434264 | R1 | |
2 | 0.1 | 0.161269469 | 0.016126947 | |
C2 | ||||
Woodside Petroleum | 0.1 | 0.010164232 | R2 | |
BHP | 0.1 | 0.021766103 | R4 | |
Oil Search Limited | 0.1 | 0.00228004 | R4 | |
3 | 0.4 | 0.114034583 | 0.045613833 | |
C3 | ||||
ANZ Bank | 0.1 | 0.0082295 | R2 | |
NAB | 0.1 | 0.008402132 | R2 | |
CBA | 0.1 | 0.006263098 | R1 | |
3 | 0.1 | 0.076315766 | 0.007631577 | |
C4 | ||||
Ramsay Health Care | 0.1 | 0.002875178 | R3 | |
APA Group | 0.1 | 0.010384686 | R3 | |
2 | 0.1 | 0.066299321 | 0.006629932 | |
10 | 0.7 | 0.076002289 | 0.108574699 | |
R1 | 3 | |||
R2 | 3 | |||
R3 | 2 | |||
R4 | 2 |