FINM7403takehomeexamrawdata11.xlsx
ETF RETURNS
| Date | SPY_RET (stock) | VGLT_RET (bond) | SGOL_RET (Gold) |
| 3/1/10 | 0.056529064 | -0.017657866 | -0.0039451269 |
| 4/1/10 | 0.019651798 | 0.028306115 | 0.0586011342 |
| 5/1/10 | -0.07945459 | 0.042115001 | 0.0297619048 |
| 6/1/10 | -0.056230966 | 0.049146116 | 0.023699422 |
| 7/1/10 | 0.073383155 | 0.001170904 | -0.0505767524 |
| 8/1/10 | -0.044980442 | 0.066986961 | 0.0576040782 |
| 9/1/10 | 0.083752403 | -0.01779247 | 0.0471561697 |
| 10/1/10 | 0.043760236 | -0.030794467 | 0.0371308017 |
| 11/1/10 | 0 | -0.017442013 | 0.0205636512 |
| 12/1/10 | 0.061271092 | -0.037546538 | 0.0247879974 |
| 1/1/11 | 0.028681718 | -0.020056061 | -0.0638659028 |
| 2/1/11 | 0.034737436 | 0.014015044 | 0.0604412209 |
| 3/1/11 | -0.004205811 | -0.00112154 | 0.0158877173 |
| 4/1/11 | 0.033431415 | 0.021836324 | 0.088856161 |
| 5/1/11 | -0.011214581 | 0.033473345 | -0.0173901842 |
| 6/1/11 | -0.021719851 | -0.019372945 | -0.0239250131 |
| 7/1/11 | -0.015145823 | 0.039952564 | 0.0836075482 |
| 8/1/11 | -0.054975733 | 0.087898313 | 0.1220873203 |
| 9/1/11 | -0.074210536 | 0.099918116 | -0.1104606147 |
| 10/1/11 | 0.114885724 | -0.037451002 | 0.0584254279 |
| 11/1/11 | -0.004063989 | 0.021856648 | 0.0170117313 |
| 12/1/11 | 0.004080573 | 0.028500808 | -0.1063621157 |
| 1/1/12 | 0.053010777 | 0.002310169 | 0.1138578713 |
| 2/1/12 | 0.043405301 | -0.020523195 | -0.0293793823 |
| 3/1/12 | 0.02766018 | -0.043075276 | -0.0135521791 |
| 4/1/12 | -0.002322361 | 0.046928397 | -0.0018761725 |
| 5/1/12 | -0.060055889 | 0.079193804 | -0.0626364866 |
| 6/1/12 | 0.035217276 | -0.015183142 | 0.0232227182 |
| 7/1/12 | 0.017072045 | 0.031475246 | 0.0089138956 |
| 8/1/12 | 0.02505233 | -0.008527774 | 0.0484366188 |
| 9/1/12 | 0.01990695 | -0.019005945 | 0.0476332178 |
| 10/1/12 | -0.012957388 | -0.001821839 | -0.0299503126 |
| 11/1/12 | 0.005659701 | 0.007164667 | -0.0048223359 |
| 12/1/12 | 0.001829254 | -0.021735905 | -0.0239333989 |
| 1/1/13 | 0.058645548 | -0.02625483 | -0.0053277835 |
| 2/1/13 | 0.012758584 | 0.011910951 | -0.050459611 |
| 3/1/13 | 0.033375488 | -0.001047811 | 0.0093589744 |
| 4/1/13 | 0.023745268 | 0.038965922 | -0.0760193065 |
| 5/1/13 | 0.023609859 | -0.06093294 | -0.0622723211 |
| 6/1/13 | -0.01853767 | -0.034452582 | -0.1099464927 |
| 7/1/13 | 0.057241942 | -0.017694625 | 0.0737873672 |
| 8/1/13 | -0.029992628 | -0.007409239 | 0.0526880896 |
| 9/1/13 | 0.026642291 | 0.003706422 | -0.0476468017 |
| 10/1/13 | 0.051406883 | 0.010397124 | -0.00374847 |
| 11/1/13 | 0.029637468 | -0.024343915 | -0.0552100131 |
| 12/1/13 | 0.020386737 | -0.019673754 | -0.0380364109 |
| 1/1/14 | -0.030010501 | 0.064428144 | 0.0340486651 |
| 2/1/14 | 0.045515694 | 0.002059467 | 0.0629953428 |
| 3/1/14 | 0.00386511 | 0.00745648 | -0.0309761722 |
| 4/1/14 | 0.011395642 | 0.01894587 | 0.0048385817 |
| 5/1/14 | 0.023206214 | 0.026697917 | -0.0308651721 |
| 6/1/14 | 0.015777893 | -0.001190925 | 0.0624745459 |
| 7/1/14 | -0.00871053 | 0.004979047 | -0.0355719105 |
| 8/1/14 | 0.039463664 | 0.042970793 | 0.0039745628 |
| 9/1/14 | -0.01838471 | -0.01959005 | -0.0619160728 |
| 10/1/14 | 0.028335381 | 0.027209305 | -0.0307224848 |
| 11/1/14 | 0.027471997 | 0.024580351 | -0.004528039 |
| 12/1/14 | -0.008011655 | 0.028607984 | 0.013383485 |
| 1/1/15 | -0.024273651 | 0.091546897 | 0.0859732413 |
| 2/1/15 | 0.05620472 | -0.056804493 | -0.057388125 |
| 3/1/15 | -0.020079811 | 0.009762127 | -0.0231891391 |
| 4/1/15 | 0.014341514 | -0.024896682 | -0.0008632597 |
| 5/1/15 | 0.012856158 | -0.022820432 | 0.0052704337 |
| 6/1/15 | -0.025054594 | -0.035465515 | -0.0151267727 |
| 7/1/15 | 0.027563401 | 0.040215928 | -0.0662361463 |
| 8/1/15 | -0.053871625 | -0.001378113 | 0.0369158879 |
| 9/1/15 | -0.037808771 | 0.014201703 | -0.0173050924 |
| 10/1/15 | 0.095736296 | -0.011043275 | 0.0219205723 |
| 11/1/15 | -0.000957271 | -0.001266846 | -0.0670436187 |
| 12/1/15 | -0.023096473 | -0.007184424 | -0.0044252044 |
| 1/1/16 | -0.044131414 | 0.057504598 | 0.053918253 |
| 2/1/16 | -0.000826161 | 0.02610837 | 0.1093792977 |
| 3/1/16 | 0.061789787 | -0.000151964 | -0.0076859504 |
| 4/1/16 | 0.009119082 | -0.003107448 | 0.0494711418 |
| 5/1/16 | 0.017011716 | 0.006402977 | -0.0605507499 |
| 6/1/16 | -0.001715716 | 0.061799032 | 0.0892887312 |
| 7/1/16 | 0.041861313 | 0.020958142 | 0.0206281504 |
| 8/1/16 | 0.001197624 | -0.010232751 | -0.0322163969 |
| 9/1/16 | -0.004968319 | -0.012348318 | 0.0063594253 |
| 10/1/16 | -0.012373203 | -0.042567337 | -0.0299578717 |
| 11/1/16 | 0.036838491 | -0.077358715 | -0.0826765321 |
| 12/1/16 | 0.014293315 | -0.006507382 | -0.0201648255 |
| 1/1/17 | 0.023894274 | 0.010628764 | 0.0535969936 |
| 2/1/17 | 0.039291627 | 0.014436367 | 0.0326963907 |
| 3/1/17 | -0.003087166 | -0.00664814 | -0.0041940789 |
| 4/1/17 | 0.014319777 | 0.016102188 | 0.0168469733 |
| 5/1/17 | 0.014113008 | 0.017598125 | -0.0006497198 |
| 6/1/17 | 0.001491044 | 0.006681735 | -0.0212921577 |
| 7/1/17 | 0.025531022 | -0.005516007 | 0.022751806 |
| 8/1/17 | 0.002917724 | 0.032605249 | 0.0465210684 |
| 9/1/17 | 0.015111724 | -0.022261884 | -0.0380139643 |
| 10/1/17 | 0.028643623 | -0.000900177 | 0 |
| 11/1/17 | 0.030565964 | 0.007118646 | -0.0005645161 |
| 12/1/17 | 0.00698082 | 0.014577966 | 0.0177519567 |
| 1/1/18 | 0.061758681 | -0.027430951 | 0.0283041307 |
| 2/1/18 | -0.036360484 | -0.032181502 | -0.0169622205 |
| 3/1/18 | -0.031290195 | 0.028726134 | 0.0063529412 |
| 4/1/18 | 0.009193939 | -0.02067675 | -0.0047541111 |
| 5/1/18 | 0.024309009 | 0.01887949 | -0.0149569303 |
| 6/1/18 | 0.001255043 | 0.005658737 | -0.0383178313 |
| 7/1/18 | 0.041703016 | -0.013556265 | -0.0202529553 |
| 8/1/18 | 0.031920044 | 0.013064016 | -0.0229497131 |
| 9/1/18 | 0.001412247 | -0.027530487 | -0.0063903282 |
| 10/1/18 | -0.064890234 | -0.028475371 | 0.0209455936 |
| 11/1/18 | 0.018549224 | 0.018410317 | 0.0035753809 |
| 12/1/18 | -0.093343066 | 0.05377814 | 0.0491135805 |
| 1/1/19 | 0.086372909 | 0.009622434 | 0.0292690815 |
| 2/1/19 | 0.032415574 | -0.015052572 | -0.0060487038 |
| 3/1/19 | 0.013635936 | 0.054106565 | -0.0156484628 |
| 4/1/19 | 0.045437138 | -0.019314385 | -0.0065034123 |
| 5/1/19 | -0.06377115 | 0.067220637 | 0.0176175853 |
| 6/1/19 | 0.064409431 | 0.010032792 | 0.0800508259 |
| 7/1/19 | 0.020056608 | 0.003085743 | 0.0004411765 |
| 8/1/19 | -0.016743377 | 0.106412623 | 0.0793767456 |
| 9/1/19 | 0.014771741 | -0.025473356 | -0.0334332017 |
| 10/1/19 | 0.026824701 | -0.010993584 | 0.0255723846 |
| 11/1/19 | 0.036198228 | -0.003854474 | -0.0273389202 |
| 12/1/19 | 0.024020891 | -0.031090523 | 0.0324858757 |
| 1/1/20 | 0.004510659 | 0.077100402 | 0.0444596443 |
| 2/1/20 | -0.079165788 | 0.064025043 | -0.0058939096 |
| 3/1/20 | -0.129987118 | 0.064558146 | -0.0019762846 |
| 4/1/20 | 0.133610518 | 0.009569564 | 0.0726072607 |
| 5/1/20 | 0.047645266 | -0.017065462 | 0.0264615385 |
| 6/1/20 | 0.0132754 | 0.003429268 | 0.0275778777 |
| 7/1/20 | 0.063551935 | 0.041976187 | 0.1079347204 |
| 8/1/20 | 0.069796726 | -0.047967941 | -0.0026329121 |
| 9/1/20 | -0.04128138 | 0.008070184 | -0.0417107159 |
| 10/1/20 | -0.021030399 | -0.032909999 | -0.005509697 |
| 11/1/20 | 0.108776865 | 0.014986776 | -0.0537395598 |
| 12/1/20 | 0.03264654 | -0.015933977 | 0.0702576698 |
AFI
| Date | AFI Dividend | AFI Closing price | ASX 200 Index | Risk-free rate |
| 1/1/20 | | 5.86 | 7017.20 | 0.00017 |
| 2/1/20 | | 6.36 | 6441.20 | 0.00017 |
| 3/1/20 | 0.10 | 5.65 | 5076.80 | 0.00017 |
| 4/1/20 | | 5.54 | 5522.40 | 0.00017 |
| 5/1/20 | | 5.02 | 5755.70 | 0.00017 |
| 6/1/20 | | 5.16 | 5897.90 | 0.00017 |
| 7/1/20 | | 5.19 | 5927.80 | 0.00017 |
| 8/1/20 | | 6.28 | 6060.50 | 0.00017 |
| 9/1/20 | 0.14 | 6.31 | 5815.90 | 0.00017 |
| 10/1/20 | | 6.51 | 5927.60 | 0.00017 |
| 11/1/20 | | 7.21 | 6517.80 | 0.00017 |
| 12/1/20 | | 7.30 | 6587.10 | 0.00017 |
| 1/1/21 | | 7.50 | 6824.70 | 0.00017 |
alnnrye
