A finance report

profileJerryZ
assignment2.xlsx
Home>Business & Finance homework help>A finance report

Sheet1

Date CBA close price CSL close price HVN close price QAN close price WOW close price CBA return CSL return HVN return QAN return WOW return Market return risk free rate Entire 5-year horizon
12/1/17 80.339996 141.300003 4.003904 5.04 27.299999 CBA CSL HVN QAN WOW Market Rf
1/1/18 78.870003 146.419998 4.339963 5.27 26.950001 -0.0182971505 0.0362349249 0.0839328316 0.0456349206 -0.01282044 0.00564811 0.0014917 monthly return 0.0063840833 0.0135770457 0.0034765045 0.0088670607 0.0049396209 0.0141527231 0.00086902
2/1/18 76.389999 163.169998 3.850277 5.89 27.610001 -0.0314441981 0.1143969419 -0.1128318375 0.1176470588 0.024489795 0.006866484 0.001475 monthly standard deviation 0.0674172881 0.058310538 0.0771117856 0.1057879073 0.0550596531 0.0413478901 0.0008073468
3/1/18 72.309998 155.460007 3.543023 5.83 26.290001 -0.053410146 -0.0472512784 -0.0798004923 -0.0101867572 -0.0478087632 -0.020882697 0.0016083 annualized return 0.0793570026 0.1756585301 0.0425250525 0.1117504448 0.0609126544 0.1836964178 0.0104782276
4/1/18 71.82 170.360001 3.379794 5.77 27.860001 -0.006776352 0.0958445473 -0.0460705448 -0.0102915952 0.0597185219 0.053494918 0.0017167 annualized standard deviation 0.2335403365 0.2019936288 0.267123061 0.3664600606 0.1907322332 0.143233293 0.0027967313
5/1/18 69.300003 185.850006 3.456607 6.35 28.459999 -0.0350876775 0.0909251286 0.0227271248 0.1005199307 0.0215361801 0.027093569 0.0016333
6/1/18 72.870003 192.619995 3.18776 6.16 30.52 0.0515151493 0.0364271659 -0.0777777167 -0.0299212598 0.0723823286 0.029917886 0.001725
7/1/18 74.790001 196.610001 3.408599 6.72 30.09 0.0263482629 0.0207143916 0.0692771727 0.0909090909 -0.0140891219 0.014014219 0.0016833 CBA return CSL return HVN return
8/1/18 71.239998 227.309998 3.456607 6.43 28.299999 -0.0474662783 0.1561466703 0.0140843789 -0.0431547619 -0.0594882353 0.032024239 0.0016333
9/1/18 71.410004 201.110001 3.434307 5.9 28.08 0.0023863841 -0.115261085 -0.0064514132 -0.0824261275 -0.0077738165 -0.003838665 0.0016083 Mean 0.0063840833 Mean 0.0135770457 Mean 0.0034765045
10/1/18 69.230003 188 3.11234 5.47 28.43 -0.0305279496 -0.0651882101 -0.0937502093 -0.0728813559 0.0124643875 -0.062714198 0.0016083 Standard Error 0.0087035345 Standard Error 0.0075278581 Standard Error 0.0099550887
11/1/18 71.230003 177.399994 3.083071 5.96 28.92 0.0288892086 -0.0563830106 -0.0094041782 0.0895795247 0.0172353148 -0.034206097 0.0016167 Median 0.0039877377 Median 0.0158325411 Median 0.0117860225
12/1/18 72.389999 185.160004 3.083071 5.79 29.42 0.0162852162 0.0437430116 0 -0.0285234899 0.0172890733 0.013937093 0.0016833 Mode ERROR:#N/A Mode ERROR:#N/A Mode ERROR:#N/A
1/1/19 69.910004 194.720001 3.287958 5.44 29.370001 -0.0342588069 0.0516310045 0.0664554919 -0.0604490501 -0.0016994901 0.059160272 0.001725 Standard Deviation 0.0674172881 Standard Deviation 0.058310538 Standard Deviation 0.0771117856
2/1/19 73.949997 193.759995 3.512359 5.73 28.67 0.0577884819 -0.0049301869 0.0682493511 0.0533088235 -0.0238338773 0.054487739 0.0016333 Sample Variance 0.0045450907 Sample Variance 0.0034001188 Sample Variance 0.0059462275
3/1/19 70.639999 194.940002 3.922134 5.66 30.4 -0.0447599477 0.0060900445 0.116666605 -0.0122164049 0.0603418207 0.013331443 0.001525 Kurtosis 2.5179453853 Kurtosis -0.1017642241 Kurtosis 0.3824145723
4/1/19 74.519997 198.570007 4.068483 5.61 31.85 0.0549263598 0.0186211396 0.0373136155 -0.0088339223 0.0476973684 0.018649473 0.0014 Skewness -0.5466770242 Skewness 0.0499203417 Skewness -0.1515471386
5/1/19 78.510002 205.490005 4.058726 5.55 31.370001 0.0535427424 0.0348491603 -0.0023981912 -0.0106951872 -0.0150706122 0.019146302 0.0012833 Range 0.3982039929 Range 0.2714077553 Range 0.393023795
6/1/19 82.779999 215 3.970917 5.4 33.23 0.0543879365 0.0462795989 -0.0216346213 -0.027027027 0.0592922837 0.038260932 0.001075 Minimum -0.2440694454 Minimum -0.115261085 Minimum -0.204851752
7/1/19 82.300003 229.619995 4.283127 5.71 35.619999 -0.0057984538 0.0679999767 0.0786241566 0.0574074074 0.0719229311 0.034552454 0.000925 Maximum 0.1541345475 Maximum 0.1561466703 Maximum 0.188172043
8/1/19 79.050003 240.869995 4.27337 6.11 37.77 -0.0394896705 0.0489939911 -0.0022780086 0.0700525394 0.0603593784 -0.019304664 0.0008167 Sum 0.383044996 Sum 0.8146227434 Sum 0.208590272
9/1/19 80.830002 233.690002 4.53 6.29 37.279999 0.0225173805 -0.029808582 0.0600533069 0.0294599018 -0.0129732857 0.020878208 0.0008167 Count 60 Count 60 Count 60
10/1/19 78.660004 256.029999 4.09 6.41 37.32 -0.0268464425 0.0955967171 -0.0971302428 0.0190779014 0.0010729882 0.011038907 0.0007333 QAN return WOW return
11/1/19 80.82 283.480011 4.3 7.3 39.759998 0.027459902 0.1072140456 0.0513447433 0.1388455538 0.0653804394 0.048020712 0.0007583 Market return
12/1/19 79.900002 275.76001 4.07 7.11 36.16 -0.0113832962 -0.0272329642 -0.0534883721 -0.0260273973 -0.0905432138 -0.007319021 0.00075 Mean 0.0088670607 Mean 0.0049396209
1/1/20 85.260002 312.049988 4.23 6.41 41.84 0.0670838531 0.1315998574 0.0393120393 -0.0984528833 0.157079646 0.041597422 0.0007417 Standard Error 0.0136571601 Standard Error 0.0071081707 Mean 0.0141527231
2/1/20 81.779999 309.440002 3.71 5.53 38.799999 -0.0408163608 -0.0083639997 -0.1229314421 -0.1372854914 -0.0726577677 -0.083556042 0.0007417 Median -0.0100340901 Median 0.0168788295 Standard Error 0.0053379897
3/1/20 61.82 296.679993 2.95 3.23 35.099998 -0.2440694454 -0.0412358096 -0.204851752 -0.4159132007 -0.095360853 -0.132020799 0.0004417 Mode ERROR:#N/A Mode ERROR:#N/A Median 0.018840211
4/1/20 62.689999 309.440002 2.78 3.86 35.75 0.0140730993 0.0430093343 -0.0576271186 0.1950464396 0.0185185766 0.125584428 0.0001417 Standard Deviation 0.1057879073 Standard Deviation 0.0550596531 Mode ERROR:#N/A
5/1/20 63.75 276.220001 3.26 3.99 35.34 0.0169086141 -0.1073552249 0.1726618705 0.0336787565 -0.0114685315 0.049368707 0.0000833 Sample Variance 0.0111910813 Sample Variance 0.0030315654 Standard Deviation 0.0413478901
6/1/20 69.419998 287 3.54 3.78 37.279999 0.0889411451 0.0390268589 0.0858895706 -0.0526315789 0.0548952745 0.018793234 0.0000833 Kurtosis 3.8446764543 Kurtosis -0.3005567983 Sample Variance 0.001709648
7/1/20 71.199997 270.100006 3.72 3.23 38.68 0.025641012 -0.0588849965 0.0508474576 -0.1455026455 0.0375536759 0.018887188 0.0000833 Skewness -0.6478387544 Skewness -0.0976319382 Kurtosis 2.5493036525
8/1/20 68.279999 286.01001 4.42 3.94 39.869999 -0.0410112096 0.0589041231 0.188172043 0.2198142415 0.0307652275 0.050607964 0.0000833 Range 0.6999227473 Range 0.2573132529 Skewness -0.7380048135
9/1/20 63.610001 287 4.53 4.05 36.43 -0.0683948165 0.0034613823 0.0248868778 0.0279187817 -0.0862803884 -0.014451933 0.000075 Minimum -0.4159132007 Minimum -0.1002336069 Range 0.257605227
10/1/20 69.019997 287.559998 4.44 4.19 38.16 0.0850494563 0.0019512125 -0.0198675497 0.0345679012 0.0474883338 0.006764349 0.0000583 Maximum 0.2840095465 Maximum 0.157079646 Minimum -0.132020799
11/1/20 79.07 297.380005 4.61 5.38 36.98 0.1456100179 0.0341494195 0.0382882883 0.2840095465 -0.0309224319 0.082418639 0.0000167 Sum 0.5320236443 Sum 0.2963772558 Maximum 0.125584428
12/1/20 82.110001 283.179993 4.69 4.85 39.310001 0.0384469584 -0.0477503926 0.0173535792 -0.0985130112 0.0630070579 0.030171599 0.0000167 Count 60 Count 60 Sum 0.849163385
1/1/21 83.510002 271.720001 5.34 4.5 40.860001 0.0170503104 -0.0404689324 0.1385927505 -0.0721649485 0.0394301694 0.004029623 0.0000083 Count 60
2/1/21 81.559998 262.589996 5.24 5 39.400002 -0.0233505443 -0.0336007838 -0.0187265918 0.1111111111 -0.0357317417 0.020781594 0.0000083
3/1/21 86.099998 264.649994 5.73 5.09 40.869999 0.0556645428 0.0078449219 0.0935114504 0.018 0.0373095666 0.013533005 0.000025
4/1/21 89.040001 271.160004 5.27 4.95 39.299999 0.0341463771 0.0245985647 -0.0802792321 -0.0275049116 -0.0384144859 0.046080531 0.0000333
5/1/21 99.720001 290.209991 5.32 4.71 41.619999 0.1199460903 0.0702536758 0.009487666 -0.0484848485 0.0590330804 0.015546972 0.0000333
6/1/21 99.870003 285.190002 5.48 4.66 38.130001 0.0015042318 -0.0172977815 0.030075188 -0.0106157113 -0.0838538703 0.025728583 0.000025
7/1/21 99.650002 288.910004 5.67 4.59 38.759998 -0.0022028737 0.0130439425 0.0346715328 -0.0150214592 0.0165223442 0.026021735 0.0000167
8/1/21 100.120003 311.940002 5.38 5.09 41.75 0.0047165177 0.0797133975 -0.0511463845 0.1089324619 0.0771414384 0.015986587 0.0000083
9/1/21 104.330002 293.399994 5.03 5.67 39.349998 0.0420495293 -0.0594345319 -0.0650557621 0.1139489194 -0.0574850778 -0.013284813 0.0000083
10/1/21 104.68 300.48999 4.96 5.35 38.080002 0.0033547205 0.0241649494 -0.013916501 -0.0564373898 -0.03227436 0.003963987 0.0000333
11/1/21 93.18 306.790009 5.07 5.06 40.82 -0.1098586167 0.0209658199 0.0221774194 -0.0542056075 0.0719537252 0.024484383 0.0000333
12/1/21 101 290.720001 4.94 5.01 38.009998 0.0839235888 -0.0523811321 -0.0256410256 -0.0098814229 -0.0688388535 0.027894621 0.00005
1/1/22 93.739998 260.350006 4.91 4.78 34.419998 -0.0718812079 -0.1044647595 -0.0060728745 -0.0459081836 -0.0944488342 -0.042436514 0.0000583
2/1/22 93.459999 259.980011 5.25 5.07 35.490002 -0.0029869747 -0.0014211446 0.0692464358 0.0606694561 0.0310866956 0.020376716 0.0000583
3/1/22 105.769997 268.149994 5.35 5.21 37.259998 0.1317140823 0.0314254275 0.019047619 0.0276134122 0.0498730882 0.071465929 0.0001417
4/1/22 103.879997 273.299988 5.09 5.6 38.509998 -0.0178689615 0.0192056465 -0.0485981308 0.0748560461 0.0335480426 -0.003750407 0.0003417
5/1/22 104.360001 271.829987 4.38 5.51 34.650002 0.0046207549 -0.0053787086 -0.1394891945 -0.0160714286 -0.1002336069 -0.016052239 0.0008333
6/1/22 90.379997 269.059998 3.71 4.47 35.599998 -0.1339594085 -0.0101901524 -0.1529680365 -0.1887477314 0.0274169104 -0.064532986 0.0013333
7/1/22 100.769997 289.839996 4.14 4.56 37.52 0.1149590656 0.0772318373 0.115902965 0.0201342282 0.0539326435 0.045359398 0.001725
8/1/22 97.470001 293.540009 4.23 5.32 36.09 -0.0327478029 0.0127657088 0.0217391304 0.1666666667 -0.0381130064 0.031052961 0.001925
9/1/22 90.699997 285.019989 4.04 5.02 33.950001 -0.0694573092 -0.0290250724 -0.0449172577 -0.0563909774 -0.0592961762 -0.045120922 0.0023
10/1/22 104.68 280.480011 4.16 5.84 33.02 0.1541345475 -0.0159286302 0.0297029703 0.1633466135 -0.027393254 0.035070981 0.0024583
11/1/22 107.860001 300.109985 4.25 6.24 34.470001 0.0303783053 0.0699870694 0.0216346154 0.0684931507 0.0439128104 0.086921542 0.00255
12/1/22 102.599998 287.76001 4.13 6.01 33.560001 -0.0487669474 -0.0411514965 -0.0282352941 -0.0368589744 -0.0263997671 -0.026380256 0.0026417

Sheet2

Date CBA return CBA return +1 CSL return CSL return +1 HVN return HVN return +1 QAN return QAN return +1 WOW return WOW return +1 Market return CBA excess return CBA excess return +1 CSL excess return CSL excess return +1 HVN excess return HVN excess return +1 QAN excess return QAN excess return +1 WOW excess return WOW excess return +1 Jan 2018- Dec 2018 CBA CLS HVN QAN WOW
12/1/17 Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return
1/1/18 -0.0182971505 0.9817028495 0.0362349249 1.0362349249 0.0839328316 1.0839328316 0.0456349206 1.0456349206 -0.01282044 0.98717956 0.00564811 -0.0197888505 0.9802111495 0.0347432249 1.0347432249 0.0824411316 1.0824411316 0.0441432206 1.0441432206 -0.01431214 0.98568786 Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric
2/1/18 -0.0314441981 0.9685558019 0.1143969419 1.1143969419 -0.1128318375 0.8871681625 0.1176470588 1.1176470588 0.024489795 1.024489795 0.006866484 -0.0329191981 0.9670808019 0.1129219419 1.1129219419 -0.1143068375 0.8856931625 0.1161720588 1.1161720588 0.023014795 1.023014795 mean (monthly) -0.0081321276 -0.0086456945 -0.0097557276 -0.0102689448 0.0258624332 0.0227835888 0.0242388332 0.0211551824 -0.0196720737 -0.0215431999 -0.0212956737 -0.0231696699 0.0139087648 0.0116275985 0.0122851648 0.0099986935 0.0069279354 0.0062517989 0.0053043354 0.0046279887
3/1/18 -0.053410146 0.946589854 -0.0472512784 0.9527487216 -0.0798004923 0.9201995077 -0.0101867572 0.9898132428 -0.0478087632 0.9521912368 -0.020882697 -0.055018446 0.944981554 -0.0488595784 0.9511404216 -0.0814087923 0.9185912077 -0.0117950572 0.9882049428 -0.0494170632 0.9505829368 mean (annualised) -0.0933370287 -0.0989544112 -0.1109870863 -0.1165003737 0.358530885 0.3104033975 0.3329530499 0.2855854507 -0.2121265 -0.2299837858 -0.2276429817 -0.2452039313 0.1802840236 0.1488095238 0.1578024577 0.1268075391 0.0863772857 0.0776557171 0.0655422271 0.0569715066
4/1/18 -0.006776352 0.993223648 0.0958445473 1.0958445473 -0.0460705448 0.9539294552 -0.0102915952 0.9897084048 0.0597185219 1.0597185219 0.053494918 -0.008493052 0.991506948 0.0941278473 1.0941278473 -0.0477872448 0.9522127552 -0.0120082952 0.9879917048 0.0580018219 1.0580018219 standard deviation(monthly) 0.0334367618 0.0334367618 0.0333974831 0.0333974831 0.0824755648 0.0824755648 0.0824745481 0.0824745481 0.0633211328 0.0633211328 0.0633199859 0.0633199859 0.0712752617 0.0712752617 0.071302465 0.071302465 0.0384852526 0.0384852526 0.0384585941 0.0384585941
5/1/18 -0.0350876775 0.9649123225 0.0909251286 1.0909251286 0.0227271248 1.0227271248 0.1005199307 1.1005199307 0.0215361801 1.0215361801 0.027093569 -0.0367209775 0.9632790225 0.0892918286 1.0892918286 0.0210938248 1.0210938248 0.0988866307 1.0988866307 0.0199028801 1.0199028801 standard deviation(annualised) 0.1158283404 0.1158283404 0.1156922753 0.1156922753 0.2857037374 0.2857037374 0.2857002154 0.2857002154 0.2193508385 0.2193508385 0.2193468656 0.2193468656 0.2469047493 0.2469047493 0.2469989842 0.2469989842 0.1333168256 0.1333168256 0.133224478 0.133224478
6/1/18 0.0515151493 1.0515151493 0.0364271659 1.0364271659 -0.0777777167 0.9222222833 -0.0299212598 0.9700787402 0.0723823286 1.0723823286 0.029917886 0.0497901493 1.0497901493 0.0347021659 1.0347021659 -0.0795027167 0.9204972833 -0.0316462598 0.9683537402 0.0706573286 1.0706573286 sharp ratio -0.9593301375 -1.0069848952 1.1653930658 0.9995983038 -1.0378219039 -1.1178820846 0.6388789745 0.5133929578 0.4919683538 0.4276354278
7/1/18 0.0263482629 1.0263482629 0.0207143916 1.0207143916 0.0692771727 1.0692771727 0.0909090909 1.0909090909 -0.0140891219 0.9859108781 0.014014219 0.0246649629 1.0246649629 0.0190310916 1.0190310916 0.0675938727 1.0675938727 0.0892257909 1.0892257909 -0.0157724219 0.9842275781
8/1/18 -0.0474662783 0.9525337217 0.1561466703 1.1561466703 0.0140843789 1.0140843789 -0.0431547619 0.9568452381 -0.0594882353 0.9405117647 0.032024239 -0.0490995783 0.9509004217 0.1545133703 1.1545133703 0.0124510789 1.0124510789 -0.0447880619 0.9552119381 -0.0611215353 0.9388784647
9/1/18 0.0023863841 1.0023863841 -0.115261085 0.884738915 -0.0064514132 0.9935485868 -0.0824261275 0.9175738725 -0.0077738165 0.9922261835 -0.003838665 0.0007780841 1.0007780841 -0.116869385 0.883130615 -0.0080597132 0.9919402868 -0.0840344275 0.9159655725 -0.0093821165 0.9906178835
10/1/18 -0.0305279496 0.9694720504 -0.0651882101 0.9348117899 -0.0937502093 0.9062497907 -0.0728813559 0.9271186441 0.0124643875 1.0124643875 -0.062714198 -0.0321362496 0.9678637504 -0.0667965101 0.9332034899 -0.0953585093 0.9046414907 -0.0744896559 0.9255103441 0.0108560875 1.0108560875
11/1/18 0.0288892086 1.0288892086 -0.0563830106 0.9436169894 -0.0094041782 0.9905958218 0.0895795247 1.0895795247 0.0172353148 1.0172353148 -0.034206097 0.0272725086 1.0272725086 -0.0579997106 0.9420002894 -0.0110208782 0.9889791218 0.0879628247 1.0879628247 0.0156186148 1.0156186148
12/1/18 0.0162852162 1.0162852162 0.0437430116 1.0437430116 0 1 -0.0285234899 0.9714765101 0.0172890733 1.0172890733 0.013937093 0.0146019162 1.0146019162 0.0420597116 1.0420597116 -0.0016833 0.9983167 -0.0302067899 0.9697932101 0.0156057733 1.0156057733 Jan 2019- Dec 2019 CBA CLS HVN QAN WOW
1/1/19 -0.0342588069 0.9657411931 0.0516310045 1.0516310045 0.0664554919 1.0664554919 -0.0604490501 0.9395509499 -0.0016994901 0.9983005099 0.059160272 -0.0359838069 0.9640161931 0.0499060045 1.0499060045 0.0647304919 1.0647304919 -0.0621740501 0.9378259499 -0.0034244901 0.9965755099 Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return
2/1/19 0.0577884819 1.0577884819 -0.0049301869 0.9950698131 0.0682493511 1.0682493511 0.0533088235 1.0533088235 -0.0238338773 0.9761661227 0.054487739 0.0561551819 1.0561551819 -0.0065634869 0.9934365131 0.0666160511 1.0666160511 0.0516755235 1.0516755235 -0.0254671773 0.9745328227 Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric
3/1/19 -0.0447599477 0.9552400523 0.0060900445 1.0060900445 0.116666605 1.116666605 -0.0122164049 0.9877835951 0.0603418207 1.0603418207 0.013331443 -0.0462849477 0.9537150523 0.0045650445 1.0045650445 0.115141605 1.115141605 -0.0137414049 0.9862585951 0.0588168207 1.0588168207 mean (monthly) 0.0090071821 0.0082595672 0.0078870488 0.0071402468 0.0346086621 0.0337495703 0.0334885288 0.0326252106 0.0251481529 0.0234129472 0.0240280195 0.0223025502 0.0185752616 0.017261449 0.0174551282 0.016131213 0.0184955609 0.0173384983 0.0173754276 0.0162174203
4/1/19 0.0549263598 1.0549263598 0.0186211396 1.0186211396 0.0373136155 1.0373136155 -0.0088339223 0.9911660777 0.0476973684 1.0476973684 0.018649473 0.0535263598 1.0535263598 0.0172211396 1.0172211396 0.0359136155 1.0359136155 -0.0102339223 0.9897660777 0.0462973684 1.0462973684 mean (annualised) 0.1136047909 0.1037436539 0.0988600267 0.0891292369 0.5042267994 0.4893065675 0.4847998888 0.4699842617 0.3472233522 0.3201123166 0.3296645186 0.3030267458 0.2471465497 0.2279792746 0.2307877949 0.2117066854 0.245976025 0.2290958532 0.2296313528 0.2129408571
5/1/19 0.0535427424 1.0535427424 0.0348491603 1.0348491603 -0.0023981912 0.9976018088 -0.0106951872 0.9893048128 -0.0150706122 0.9849293878 0.019146302 0.0522594424 1.0522594424 0.0335658603 1.0335658603 -0.0036814912 0.9963185088 -0.0119784872 0.9880215128 -0.0163539122 0.9836460878 standard deviation(monthly) 0.0405522099 0.0405522099 0.0405014264 0.0405014264 0.0440508301 0.0440508301 0.0441447945 0.0441447945 0.0615609688 0.0615609688 0.0613559047 0.0613559047 0.0546209203 0.0546209203 0.0547992216 0.0547992216 0.0500754709 0.0500754709 0.0500761179 0.0500761179
6/1/19 0.0543879365 1.0543879365 0.0462795989 1.0462795989 -0.0216346213 0.9783653787 -0.027027027 0.972972973 0.0592922837 1.0592922837 0.038260932 0.0533129365 1.0533129365 0.0452045989 1.0452045989 -0.0227096213 0.9772903787 -0.028102027 0.971897973 0.0582172837 1.0582172837 standard deviation(annualised) 0.1404769759 0.1404769759 0.1403010566 0.1403010566 0.1525965518 0.1525965518 0.1529220539 0.1529220539 0.2132534515 0.2132534515 0.2125430886 0.2125430886 0.1892124181 0.1892124181 0.189830072 0.189830072 0.1734665198 0.1734665198 0.1734687608 0.1734687608
7/1/19 -0.0057984538 0.9942015462 0.0679999767 1.0679999767 0.0786241566 1.0786241566 0.0574074074 1.0574074074 0.0719229311 1.0719229311 0.034552454 -0.0067234538 0.9932765462 0.0670749767 1.0670749767 0.0776991566 1.0776991566 0.0564824074 1.0564824074 0.0709979311 1.0709979311 sharp ratio 0.7046278134 0.6352713167 3.1702418081 3.0733582868 1.5510479348 1.4257191231 1.2157599293 1.1152431388 1.3237619941 1.227545848
8/1/19 -0.0394896705 0.9605103295 0.0489939911 1.0489939911 -0.0022780086 0.9977219914 0.0700525394 1.0700525394 0.0603593784 1.0603593784 -0.019304664 -0.0403063705 0.9596936295 0.0481772911 1.0481772911 -0.0030947086 0.9969052914 0.0692358394 1.0692358394 0.0595426784 1.0595426784
9/1/19 0.0225173805 1.0225173805 -0.029808582 0.970191418 0.0600533069 1.0600533069 0.0294599018 1.0294599018 -0.0129732857 0.9870267143 0.020878208 0.0217006805 1.0217006805 -0.030625282 0.969374718 0.0592366069 1.0592366069 0.0286432018 1.0286432018 -0.0137899857 0.9862100143
10/1/19 -0.0268464425 0.9731535575 0.0955967171 1.0955967171 -0.0971302428 0.9028697572 0.0190779014 1.0190779014 0.0010729882 1.0010729882 0.011038907 -0.0275797425 0.9724202575 0.0948634171 1.0948634171 -0.0978635428 0.9021364572 0.0183446014 1.0183446014 0.0003396882 1.0003396882
11/1/19 0.027459902 1.027459902 0.1072140456 1.1072140456 0.0513447433 1.0513447433 0.1388455538 1.1388455538 0.0653804394 1.0653804394 0.048020712 0.026701602 1.026701602 0.1064557456 1.1064557456 0.0505864433 1.0505864433 0.1380872538 1.1380872538 0.0646221394 1.0646221394
12/1/19 -0.0113832962 0.9886167038 -0.0272329642 0.9727670358 -0.0534883721 0.9465116279 -0.0260273973 0.9739726027 -0.0905432138 0.9094567862 -0.007319021 -0.0121332962 0.9878667038 -0.0279829642 0.9720170358 -0.0542383721 0.9457616279 -0.0267773973 0.9732226027 -0.0912932138 0.9087067862
1/1/20 0.0670838531 1.0670838531 0.1315998574 1.1315998574 0.0393120393 1.0393120393 -0.0984528833 0.9015471167 0.157079646 1.157079646 0.041597422 0.0663421531 1.0663421531 0.1308581574 1.1308581574 0.0385703393 1.0385703393 -0.0991945833 0.9008054167 0.156337946 1.156337946 Jan 2020- Dec 2020 CBA CLS HVN QAN WOW
2/1/20 -0.0408163608 0.9591836392 -0.0083639997 0.9916360003 -0.1229314421 0.8770685579 -0.1372854914 0.8627145086 -0.0726577677 0.9273422323 -0.083556042 -0.0415580608 0.9584419392 -0.0091056997 0.9908943003 -0.1236731421 0.8763268579 -0.1380271914 0.8619728086 -0.0733994677 0.9266005323 Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return
3/1/20 -0.2440694454 0.7559305546 -0.0412358096 0.9587641904 -0.204851752 0.795148248 -0.4159132007 0.5840867993 -0.095360853 0.904639147 -0.132020799 -0.2445111454 0.7554888546 -0.0416775096 0.9583224904 -0.205293452 0.794706548 -0.4163549007 0.5836450993 -0.095802553 0.904197447 Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric
4/1/20 0.0140730993 1.0140730993 0.0430093343 1.0430093343 -0.0576271186 0.9423728814 0.1950464396 1.1950464396 0.0185185766 1.0185185766 0.125584428 0.0139313993 1.0139313993 0.0428676343 1.0428676343 -0.0577688186 0.9422311814 0.1949047396 1.1949047396 0.0183768766 1.0183768766 mean (monthly) 0.007288527 0.0013204848 0.0070746353 0.0020520559 0.0040426471 0.0022150959 0.0038287554 0.0020056662 0.017677822 0.0118858809 0.0174639303 0.0116558515 -0.0127719287 -0.0313742471 -0.0129858203 -0.0316206805 0.0093848183 0.0069847327 0.0091709266 0.0067696056
5/1/20 0.0169086141 1.0169086141 -0.1073552249 0.8926447751 0.1726618705 1.1726618705 0.0336787565 1.0336787565 -0.0114685315 0.9885314685 0.049368707 0.0168253141 1.0168253141 -0.1074385249 0.8925614751 0.1725785705 1.1725785705 0.0335954565 1.0335954565 -0.0115518315 0.9884481685 mean (annualised) 0.0910550115 0.0159614081 0.0882781084 0.0249045023 0.0496050707 0.0269073931 0.0469250381 0.0243352751 0.2340243283 0.1523341523 0.2309155729 0.1491945937 -0.1429425197 -0.317862166 -0.1451681351 -0.3199418116 0.1186165001 0.0871128595 0.1157753546 0.0843291888
6/1/20 0.0889411451 1.0889411451 0.0390268589 1.0390268589 0.0858895706 1.0858895706 -0.0526315789 0.9473684211 0.0548952745 1.0548952745 0.018793234 0.0888578451 1.0888578451 0.0389435589 1.0389435589 0.0858062706 1.0858062706 -0.0527148789 0.9472851211 0.0548119745 1.0548119745 standard deviation(monthly) 0.100192637 0.100192637 0.0633819645 0.0633819645 0.0633819645 0.0633819645 0.0632915926 0.0632915926 0.111256123 0.111256123 0.1113895267 0.1113895267 0.1914879562 0.1914879562 0.1916240283 0.1916240283 0.0729010713 0.0729010713 0.0728951218 0.0728951218
7/1/20 0.025641012 1.025641012 -0.0588849965 0.9411150035 0.0508474576 1.0508474576 -0.1455026455 0.8544973545 0.0375536759 1.0375536759 0.018887188 0.025557712 1.025557712 -0.0589682965 0.9410317035 0.0507641576 1.0507641576 -0.1455859455 0.8544140545 0.0374703759 1.0374703759 standard deviation(annualised) 0.3470774757 0.3470774757 0.2195615656 0.2195615656 0.2195615656 0.2195615656 0.2192485081 0.2192485081 0.3854025152 0.3854025152 0.3858646394 0.3858646394 0.6633337383 0.6633337383 0.6638051059 0.6638051059 0.2525367188 0.2525367188 0.2525161092 0.2525161092
8/1/20 -0.0410112096 0.9589887904 0.0589041231 1.0589041231 0.188172043 1.188172043 0.2198142415 1.2198142415 0.0307652275 1.0307652275 0.050607964 -0.0410945096 0.9589054904 0.0588208231 1.0588208231 0.188088743 1.188088743 0.2197309415 1.2197309415 0.0306819275 1.0306819275 sharp ratio 0.4020653987 0.1134283326 0.2140267156 0.1109940283 0.5984367298 0.3866500801 -0.2186908985 -0.4819815466 0.4584870052 0.3339556793
9/1/20 -0.0683948165 0.9316051835 0.0034613823 1.0034613823 0.0248868778 1.0248868778 0.0279187817 1.0279187817 -0.0862803884 0.9137196116 -0.014451933 -0.0684698165 0.9315301835 0.0033863823 1.0033863823 0.0248118778 1.0248118778 0.0278437817 1.0278437817 -0.0863553884 0.9136446116
10/1/20 0.0850494563 1.0850494563 0.0019512125 1.0019512125 -0.0198675497 0.9801324503 0.0345679012 1.0345679012 0.0474883338 1.0474883338 0.006764349 0.0849911563 1.0849911563 0.0018929125 1.0018929125 -0.0199258497 0.9800741503 0.0345096012 1.0345096012 0.0474300338 1.0474300338
11/1/20 0.1456100179 1.1456100179 0.0341494195 1.0341494195 0.0382882883 1.0382882883 0.2840095465 1.2840095465 -0.0309224319 0.9690775681 0.082418639 0.1455933179 1.1455933179 0.0341327195 1.0341327195 0.0382715883 1.0382715883 0.2839928465 1.2839928465 -0.0309391319 0.9690608681
12/1/20 0.0384469584 1.0384469584 -0.0477503926 0.9522496074 0.0173535792 1.0173535792 -0.0985130112 0.9014869888 0.0630070579 1.0630070579 0.030171599 0.0384302584 1.0384302584 -0.0477670926 0.9522329074 0.0173368792 1.0173368792 -0.0985297112 0.9014702888 0.0629903579 1.0629903579
1/1/21 0.0170503104 1.0170503104 -0.0404689324 0.9595310676 0.1385927505 1.1385927505 -0.0721649485 0.9278350515 0.0394301694 1.0394301694 0.004029623 0.0170420104 1.0170420104 -0.0404772324 0.9595227676 0.1385844505 1.1385844505 -0.0721732485 0.9278267515 0.0394218694 1.0394218694
2/1/21 -0.0233505443 0.9766494557 -0.0336007838 0.9663992162 -0.0187265918 0.9812734082 0.1111111111 1.1111111111 -0.0357317417 0.9642682583 0.020781594 -0.0233588443 0.9766411557 -0.0336090838 0.9663909162 -0.0187348918 0.9812651082 0.1111028111 1.1111028111 -0.0357400417 0.9642599583 Jan 2021- Dec 2021 CBA CLS HVN QAN WOW
3/1/21 0.0556645428 1.0556645428 0.0078449219 1.0078449219 0.0935114504 1.0935114504 0.018 1.018 0.0373095666 1.0373095666 0.013533005 0.0556395428 1.0556395428 0.0078199219 1.0078199219 0.0934864504 1.0934864504 0.017975 1.017975 0.0372845666 1.0372845666 Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return
4/1/21 0.0341463771 1.0341463771 0.0245985647 1.0245985647 -0.0802792321 0.9197207679 -0.0275049116 0.9724950884 -0.0384144859 0.9615855141 0.046080531 0.0341130771 1.0341130771 0.0245652647 1.0245652647 -0.0803125321 0.9196874679 -0.0275382116 0.9724617884 -0.0384477859 0.9615522141 Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric
5/1/21 0.1199460903 1.1199460903 0.0702536758 1.0702536758 0.009487666 1.009487666 -0.0484848485 0.9515151515 0.0590330804 1.0590330804 0.015546972 0.1199127903 1.1199127903 0.0702203758 1.0702203758 0.009454366 1.009454366 -0.0485181485 0.9514818515 0.0589997804 1.0589997804 mean (monthly) 0.0189119895 0.0174047862 0.0188883978 0.0173813072 0.0031168425 0.002192224 0.0030932508 0.0021686732 0.0061458758 0.0043371072 0.0061222842 0.0043133794 0.0048063494 0.0027084287 0.0047827578 0.0026843327 -0.0012673387 -0.0027985546 -0.0012909304 -0.0028223353
6/1/21 0.0015042318 1.0015042318 -0.0172977815 0.9827022185 0.030075188 1.030075188 -0.0106157113 0.9893842887 -0.0838538703 0.9161461297 0.025728583 0.0014792318 1.0014792318 -0.0173227815 0.9826772185 0.030050188 1.030050188 -0.0106407113 0.9893592887 -0.0838788703 0.9161211297 mean (annualised) 0.2521030435 0.2300572253 0.2517551967 0.2297166305 0.038049989 0.0266262031 0.037757068 0.0263367414 0.0762952324 0.0533049041 0.0759924334 0.0530063271 0.059225552 0.0329896907 0.0589271582 0.0326918457 -0.0151025057 -0.033070541 -0.0153816478 -0.03334721
7/1/21 -0.0022028737 0.9977971263 0.0130439425 1.0130439425 0.0346715328 1.0346715328 -0.0150214592 0.9849785408 0.0165223442 1.0165223442 0.026021735 -0.0022195737 0.9977804263 0.0130272425 1.0130272425 0.0346548328 1.0346548328 -0.0150381592 0.9849618408 0.0165056442 1.0165056442 standard deviation(monthly) 0.0573002017 0.0573002017 0.0451016249 0.0451016249 0.0451016249 0.0451016249 0.0451002259 0.0451002259 0.0637340658 0.0637340658 0.0637360715 0.0637360715 0.0688328621 0.0688328621 0.0688407381 0.0688407381 0.0577473799 0.0577473799 0.0577501664 0.0577501664
8/1/21 0.0047165177 1.0047165177 0.0797133975 1.0797133975 -0.0511463845 0.9488536155 0.1089324619 1.1089324619 0.0771414384 1.0771414384 0.015986587 0.0047082177 1.0047082177 0.0797050975 1.0797050975 -0.0511546845 0.9488453155 0.1089241619 1.1089241619 0.0771331384 1.0771331384 standard deviation(annualised) 0.1984937211 0.1984937211 0.1562366115 0.1562366115 0.1562366115 0.1562366115 0.1562317655 0.1562317655 0.2207812803 0.2207812803 0.2207882282 0.2207882282 0.2384440288 0.2384440288 0.238471312 0.238471312 0.2000427918 0.2000427918 0.2000524447 0.2000524447
9/1/21 0.0420495293 1.0420495293 -0.0594345319 0.9405654681 -0.0650557621 0.9349442379 0.1139489194 1.1139489194 -0.0574850778 0.9425149222 -0.013284813 0.0420412293 1.0420412293 -0.0594428319 0.9405571681 -0.0650640621 0.9349359379 0.1139406194 1.1139406194 -0.0574933778 0.9425066222 sharp ratio 1.6113713314 1.4703124206 0.2416734389 0.1685748175 0.3441869797 0.2400776866 0.2471037614 0.137089218 -0.0768880769 -0.1666923395
10/1/21 0.0033547205 1.0033547205 0.0241649494 1.0241649494 -0.013916501 0.986083499 -0.0564373898 0.9435626102 -0.03227436 0.96772564 0.003963987 0.0033214205 1.0033214205 0.0241316494 1.0241316494 -0.013949801 0.986050199 -0.0564706898 0.9435293102 -0.03230766 0.96769234
11/1/21 -0.1098586167 0.8901413833 0.0209658199 1.0209658199 0.0221774194 1.0221774194 -0.0542056075 0.9457943925 0.0719537252 1.0719537252 0.024484383 -0.1098919167 0.8901080833 0.0209325199 1.0209325199 0.0221441194 1.0221441194 -0.0542389075 0.9457610925 0.0719204252 1.0719204252
12/1/21 0.0839235888 1.0839235888 -0.0523811321 0.9476188679 -0.0256410256 0.9743589744 -0.0098814229 0.9901185771 -0.0688388535 0.9311611465 0.027894621 0.0838735888 1.0838735888 -0.0524311321 0.9475688679 -0.0256910256 0.9743089744 -0.0099314229 0.9900685771 -0.0688888535 0.9311111465
1/1/22 -0.0718812079 0.9281187921 -0.1044647595 0.8955352405 -0.0060728745 0.9939271255 -0.0459081836 0.9540918164 -0.0944488342 0.9055511658 -0.042436514 -0.0719395079 0.9280604921 -0.1045230595 0.8954769405 -0.0061311745 0.9938688255 -0.0459664836 0.9540335164 -0.0945071342 0.9054928658
2/1/22 -0.0029869747 0.9970130253 -0.0014211446 0.9985788554 0.0692464358 1.0692464358 0.0606694561 1.0606694561 0.0310866956 1.0310866956 0.020376716 -0.0030452747 0.9969547253 -0.0014794446 0.9985205554 0.0691881358 1.0691881358 0.0606111561 1.0606111561 0.0310283956 1.0310283956
3/1/22 0.1317140823 1.1317140823 0.0314254275 1.0314254275 0.019047619 1.019047619 0.0276134122 1.0276134122 0.0498730882 1.0498730882 0.071465929 0.1315723823 1.1315723823 0.0312837275 1.0312837275 0.018905919 1.018905919 0.0274717122 1.0274717122 0.0497313882 1.0497313882 Jan 2022- Dec 2022 CBA CLS HVN QAN WOW
4/1/22 -0.0178689615 0.9821310385 0.0192056465 1.0192056465 -0.0485981308 0.9514018692 0.0748560461 1.0748560461 0.0335480426 1.0335480426 -0.003750407 -0.0182106615 0.9817893385 0.0188639465 1.0188639465 -0.0489398308 0.9510601692 0.0745143461 1.0745143461 0.0332063426 1.0332063426 Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return Raw returns Excess return
5/1/22 0.0046207549 1.0046207549 -0.0053787086 0.9946212914 -0.1394891945 0.8605108055 -0.0160714286 0.9839285714 -0.1002336069 0.8997663931 -0.016052239 0.0037874549 1.0037874549 -0.0062120086 0.9937879914 -0.1403224945 0.8596775055 -0.0169047286 0.9830952714 -0.1010669069 0.8989330931 Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric Arithmetic Geometric
6/1/22 -0.1339594085 0.8660405915 -0.0101901524 0.9898098476 -0.1529680365 0.8470319635 -0.1887477314 0.8112522686 0.0274169104 1.0274169104 -0.064532986 -0.1352927085 0.8647072915 -0.0115234524 0.9884765476 -0.1543013365 0.8456986635 -0.1900810314 0.8099189686 0.0260836104 1.0260836104 mean (monthly) 0.0048448453 0.0013106412 0.003480962 -0.0000544989 0.0002546438 -0.000852451 -0.0011092395 -0.0022091334 -0.0119172543 -0.0148131828 -0.0132811377 -0.0161759906 0.0198168565 0.0152813195 0.0184529732 0.0139201015 -0.0088428712 -0.0103225463 -0.0102067545 -0.0116901995
7/1/22 0.1149590656 1.1149590656 0.0772318373 1.0772318373 0.115902965 1.115902965 0.0201342282 1.0201342282 0.0539326435 1.0539326435 0.045359398 0.1132340656 1.1132340656 0.0755068373 1.0755068373 0.114177965 1.114177965 0.0184092282 1.0184092282 0.0522076435 1.0522076435 mean (annualised) 0.0597126236 0.0158415644 0.0425806243 -0.0006537906 0.0030600088 -0.0101815871 -0.0132299668 -0.026189863 -0.133996223 -0.1639676113 -0.1482323059 -0.177740304 0.2655119005 0.1996007984 0.2453509725 0.1804423968 -0.101102635 -0.1170743813 -0.1158339612 -0.1316051792
8/1/22 -0.0327478029 0.9672521971 0.0127657088 1.0127657088 0.0217391304 1.0217391304 0.1666666667 1.1666666667 -0.0381130064 0.9618869936 0.031052961 -0.0346728029 0.9653271971 0.0108407088 1.0108407088 0.0198141304 1.0198141304 0.1647416667 1.1647416667 -0.0400380064 0.9599619936 standard deviation(monthly) 0.088779283 0.088779283 0.0488214216 0.0488214216 0.0488214216 0.0488214216 0.048637937 0.048637937 0.0779160066 0.0779160066 0.0778567052 0.0778567052 0.098820726 0.098820726 0.0986920525 0.0986920525 0.0560948128 0.0560948128 0.0561516982 0.0561516982
9/1/22 -0.0694573092 0.9305426908 -0.0290250724 0.9709749276 -0.0449172577 0.9550827423 -0.0563909774 0.9436090226 -0.0592961762 0.9407038238 -0.045120922 -0.0717573092 0.9282426908 -0.0313250724 0.9686749276 -0.0472172577 0.9527827423 -0.0586909774 0.9413090226 -0.0615961762 0.9384038238 standard deviation(annualised) 0.3075404577 0.3075404577 0.1691223653 0.1691223653 0.1691223653 0.1691223653 0.1684867562 0.1684867562 0.2699089643 0.2699089643 0.2697035383 0.2697035383 0.3423250366 0.3423250366 0.3418792983 0.3418792983 0.1943181317 0.1943181317 0.1945151885 0.1945151885
10/1/22 0.1541345475 1.1541345475 -0.0159286302 0.9840713698 0.0297029703 1.0297029703 0.1633466135 1.1633466135 -0.027393254 0.972606746 0.035070981 0.1516762475 1.1516762475 -0.0183869302 0.9816130698 0.0272446703 1.0272446703 0.1608883135 1.1608883135 -0.029851554 0.970148446 sharp ratio 0.2517740587 -0.0038657847 -0.0785222954 -0.1554416716 -0.5496120178 -0.6590210314 0.7176537851 0.5277956217 -0.5955008557 -0.6765804781
11/1/22 0.0303783053 1.0303783053 0.0699870694 1.0699870694 0.0216346154 1.0216346154 0.0684931507 1.0684931507 0.0439128104 1.0439128104 0.086921542 0.0278283053 1.0278283053 0.0674370694 1.0674370694 0.0190846154 1.0190846154 0.0659431507 1.0659431507 0.0413628104 1.0413628104
12/1/22 -0.0487669474 0.9512330526 -0.0411514965 0.9588485035 -0.0282352941 0.9717647059 -0.0368589744 0.9631410256 -0.0263997671 0.9736002329 -0.026380256 -0.0514086474 0.9485913526 -0.0437931965 0.9562068035 -0.0308769941 0.9691230059 -0.0395006744 0.9604993256 -0.0290414671 0.9709585329