Monthly Returns DateLevel of the S&P 500 IndexReturn on the S&P 500 IndexReturn on 30-Day Treasury BillRate of Change in CPIMICROSOFT CORPCOCA COLA COEXXON MOBIL CORPPEPSICO INCCHEVRON CORP...

1 answer below »
I don't know how to work with the assignment.


Monthly Returns DateLevel of the S&P 500 IndexReturn on the S&P 500 IndexReturn on 30-Day Treasury BillRate of Change in CPIMICROSOFT CORPCOCA COLA COEXXON MOBIL CORPPEPSICO INCCHEVRON CORP NEWAPPLE INCPROCTER & GAMBLE COBOEING COPFIZER INCJOHNSON & JOHNSONMERCK & CO INC NEWDISNEY WALT COMCDONALDS CORPJPMORGAN CHASE & COINTEL CORPBANK OF AMERICA CORPVERIZON COMMUNICATIONS INCA T & T INCHOME DEPOT INCADOBE INCCISCO SYSTEMS INCAMAZON COM INCNVIDIA CORPNETFLIX INCCOMCAST CORP NEWALPHABET INCMASTERCARD INCVISA INCFACEBOOK INCUNITEDHEALTH GROUP INC 29-Jan-101073.87-3.697%0.003%0.342%-7.546%-4.825%-5.514%-1.941%-6.325%-8.859%2.243%11.953%2.584%-2.406%4.488%-8.372%-0.016%-6.431%-4.902%0.797%-9.765%-8.027%-3.180%-12.181%-6.140%-6.772%-17.612%12.997%-5.549%-14.522%-2.317%-6.209%8.268% 26-Feb-101104.492.851%0.001%0.025%2.200%-2.820%1.537%4.780%1.192%6.538%2.811%4.917%-4.984%1.002%-3.405%5.719%3.156%7.781%6.637%9.750%-1.666%-2.169%11.389%7.276%8.278%-5.590%5.263%6.104%3.853%-0.593%-10.216%4.114%2.606% 31-Mar-101169.435.880%0.007%0.411%2.154%5.159%3.046%6.627%4.882%14.847%-0.016%14.962%-2.279%3.492%2.305%11.748%4.495%6.624%8.573%7.203%7.224%4.152%4.443%2.078%6.987%14.671%7.407%11.643%14.538%7.654%13.206%6.742%-3.514% 30-Apr-101186.691.476%0.011%0.174%4.259%-2.818%1.179%-1.421%7.398%11.102%-0.993%-0.248%-2.507%-1.380%-6.185%5.529%5.800%-4.737%2.467%-0.112%-5.303%2.477%8.903%-5.004%3.458%0.980%-9.713%34.120%5.494%-7.304%-2.287%-0.879%-7.132% 28-May-101089.41-8.198%0.011%0.078%-15.081%-3.835%-10.137%-3.573%-8.411%-1.612%-1.721%-10.810%-7.835%-8.491%-3.853%-9.283%-4.491%-7.046%-5.528%-11.722%-4.775%-6.754%-3.889%-4.524%-13.999%-8.490%-16.359%12.386%-8.498%-7.621%-18.654%-19.556%-4.091% 30-Jun-101030.71-5.388%0.013%-0.098%-10.814%-1.634%-5.607%-2.322%-8.136%-2.083%-1.817%-2.228%-6.369%1.304%4.927%-5.745%-1.495%-7.504%-9.197%-8.640%1.817%-0.453%-16.402%-17.612%-7.988%-12.912%-22.298%-2.249%-3.980%-8.377%-1.110%-2.360%-1.875% 30-Jul-101101.66.878%0.014%0.021%12.169%9.956%4.573%6.497%12.305%2.274%2.771%8.590%5.189%-1.642%-1.458%6.952%5.860%10.161%5.913%-2.296%12.343%8.971%1.568%8.664%8.259%7.899%-9.990%-5.614%12.634%8.967%5.343%3.675%7.218% 31-Aug-101049.33-4.745%0.013%0.138%-8.582%1.402%-0.218%-1.125%-1.850%-5.500%-2.436%-9.671%7.267%-0.912%2.031%-3.413%5.564%-9.732%-13.483%-11.254%1.617%4.202%-1.592%-3.552%-13.372%5.887%1.469%22.399%-12.198%-7.184%-5.561%-5.787%4.171% 30-Sep-101141.28.755%0.013%0.058%4.368%5.507%4.534%4.269%9.409%16.722%0.503%8.850%7.920%8.664%5.774%1.721%1.985%4.675%8.689%5.237%10.362%5.808%13.875%-5.596%9.582%25.819%25.276%29.191%5.762%16.837%12.926%7.654%11.081% 29-Oct-101183.263.686%0.011%0.125%8.881%4.785%7.606%-1.716%1.912%6.072%6.806%6.162%1.427%2.873%-1.358%9.139%4.375%-0.998%4.427%-12.620%1.158%1.189%-2.462%7.648%4.384%5.202%2.898%7.036%14.602%16.720%7.237%5.252%2.677% 30-Nov-101180.55-0.229%0.011%0.042%-4.678%3.735%5.279%-1.026%-1.102%3.379%-3.933%-9.131%-5.369%-2.589%-5.067%1.066%1.466%-0.611%6.309%-4.358%-1.447%-2.560%-1.468%-1.243%-16.185%6.155%13.215%18.626%-2.863%-9.449%-1.262%-5.322%1.304% 31-Dec-101257.646.530%0.014%0.172%10.502%4.116%5.118%1.826%12.696%3.667%5.338%2.337%7.423%0.487%5.657%3.835%-1.967%13.422%-0.603%21.918%11.778%5.721%16.054%10.719%5.585%2.623%13.160%-14.667%9.658%6.885%-5.451%-4.699%-0.780% 31-Jan-111286.122.265%0.007%0.476%-0.663%-4.440%10.339%-1.561%4.033%5.196%-1.116%6.466%4.055%-3.363%-7.963%3.626%-4.026%6.058%2.045%2.924%0.915%-4.867%4.877%7.375%4.548%-5.756%55.325%21.844%3.980%1.076%5.600%-0.753%13.680% 28-Feb-111327.223.196%0.012%0.493%-3.553%1.702%6.557%-1.384%10.050%4.093%-0.127%4.246%6.696%3.698%-1.809%12.529%3.556%3.894%0.891%4.079%3.650%3.125%1.904%4.387%-12.246%2.152%-5.268%-3.461%13.231%2.172%1.712%4.796%3.727% 31-Mar-111325.83-0.105%0.007%0.975%-4.477%4.521%-1.637%2.318%3.605%-1.331%-2.300%2.666%5.561%-3.564%2.518%-1.486%0.542%-1.264%-6.008%-6.648%4.388%7.858%-0.427%-3.884%-7.274%3.947%-18.535%15.053%-4.037%-4.343%4.639%0.780%6.447% 29-Apr-111363.612.850%0.005%0.644%2.087%1.688%4.576%6.955%1.814%0.466%6.209%7.913%3.250%10.920%8.906%0.023%2.918%-0.477%14.718%-7.877%-0.707%3.071%0.243%1.176%2.157%8.705%8.342%-2.149%6.483%-7.270%9.662%6.112%8.916% 31-May-111345.2-1.350%0.001%0.470%-2.894%-0.964%-4.592%3.237%-3.427%-0.657%3.236%-1.667%3.243%3.256%2.225%-3.411%4.904%-5.238%-1.982%-4.316%-2.250%1.414%-2.342%3.219%-4.110%0.449%0.200%16.388%-3.701%-2.772%4.045%3.955%-0.569% 30-Jun-111320.64-1.826%0.004%-0.107%3.958%1.422%-2.504%-0.246%-1.973%-3.496%-5.119%-5.254%-3.963%-1.144%-2.939%-6.221%3.409%-5.319%-1.555%-6.638%0.812%-0.475%0.524%-9.183%-7.083%3.966%-20.484%-2.995%0.396%-4.280%4.978%3.948%5.705% 29-Jul-111292.28-2.147%-0.003%0.089%5.385%1.070%-1.954%-9.073%1.147%16.329%-2.446%-4.680%-6.558%-2.601%-3.287%-1.076%2.562%-0.586%0.767%-11.405%-3.901%-5.476%-3.562%-11.892%2.691%8.817%-13.210%1.256%-4.765%19.217%0.684%1.519%-3.781% 31-Aug-111218.89-5.679%0.008%0.276%-2.336%3.588%-6.642%1.413%-4.230%-1.447%3.562%-4.527%-0.358%2.439%-3.033%-11.807%5.250%-7.145%-8.912%-15.757%2.479%-2.666%-3.722%-8.914%-1.879%-3.276%-3.760%-11.647%-10.450%-10.391%8.725%2.911%-4.251% 30-Sep-111131.42-7.176%-0.000%0.152%-6.429%-3.435%-1.878%-3.927%-6.323%-0.912%-0.785%-9.497%-6.849%-3.207%-0.045%-11.450%-2.865%-19.808%5.986%-25.092%1.756%0.140%-1.528%-4.239%-1.085%0.465%-6.011%-51.802%-2.743%-4.791%-3.806%-2.458%-2.604% 31-Oct-111253.310.772%0.001%-0.206%6.991%1.125%7.518%1.696%13.457%6.152%2.113%8.726%8.937%1.099%5.505%15.650%5.728%16.235%15.022%11.601%1.848%4.278%8.914%21.680%19.935%-1.258%18.305%-27.536%12.631%15.067%9.531%8.796%4.055% 30-Nov-111246.96-0.506%0.000%-0.084%-3.192%-0.907%3.611%2.486%-1.352%-5.578%0.906%5.046%5.244%1.398%3.623%2.781%3.630%-10.903%2.363%-20.205%2.028%-1.126%10.363%-6.766%0.594%-9.939%5.608%-21.382%-3.326%1.139%7.865%4.214%1.625% 30-Dec-111257.60.853%0.000%-0.247%1.486%4.076%5.370%3.672%3.482%5.965%3.314%6.784%7.823%1.329%6.629%6.276%5.036%7.362%-2.650%2.206%6.334%4.348%7.190%3.100%-3.004%-9.980%-11.324%7.376%5.084%7.760%-0.462%4.702%4.250% 31-Jan-121312.414.358%-0.000%0.440%13.752%-3.487%-1.203%-1.025%-3.083%12.711%-4.714%1.132%-1.109%0.503%1.512%3.733%-1.276%12.932%8.948%28.237%-4.885%-1.290%5.590%9.480%8.988%12.328%6.566%73.474%12.105%-10.186%-4.587%-0.877%2.190% 29-Feb-121365.684.059%0.003%0.440%8.161%3.450%3.857%-3.373%6.604%18.831%7.265%1.631%-0.257%-0.394%-0.261%7.943%0.939%5.201%2.536%11.921%1.195%4.012%7.164%6.268%1.196%-7.586%2.573%-7.879%10.628%6.575%18.120%15.849%7.646% 30-Mar-121408.473.133%0.005%0.760%1.623%6.670%0.266%5.418%-1.750%10.528%-0.606%-0.774%7.195%1.352%1.703%4.263%-1.189%17.176%4.594%20.075%0.315%2.092%6.370%4.317%6.388%12.700%1.617%3.892%2.057%3.719%0.129%1.401%6.013% 30-Apr-121397.91-0.750%0.003%0.302%-0.744%3.121%-0.450%-0.528%-0.606%-2.597%-4.476%3.267%1.126%-1.304%2.188%-1.530%-0.663%-5.872%0.996%-15.256%6.932%6.788%2.942%-2.215%-4.326%14.513%-15.557%-30.337%1.658%-5.675%7.616%4.220%-4.734% 31-May-121310.33-6.265%0.007%-0.117%-8.199%-2.083%-8.270%3.617%-6.898%-1.070%-2.121%-8.789%-3.537%-3.164%-4.230%6.031%-7.604%-22.871%-8.258%-9.248%3.120%3.829%-4.171%-7.452%-18.978%-8.189%-4.385%-20.839%-4.729%-3.966%-10.118%-6.147%-0.677% 29-Jun-121362.163.956%0.002%-0.147%4.796%5.312%8.826%4.141%7.314%1.085%-1.670%6.738%5.167%8.217%12.214%6.104%-0.907%7.783%3.135%11.293%6.724%4.361%7.398%4.251%5.144%7.252%11.183%7.952%11.147%-0.136%5.806%7.318%5.051%5.276% 31-Jul-121379.321.260%0.003%-0.163%-3.661%3.338%1.496%2.930%3.867%4.582%6.289%-0.525%4.522%2.457%5.796%1.320%0.938%1.595%-3.565%-10.269%2.700%7.572%-1.529%-4.603%-6.639%2.168%-2.026%-16.989%1.814%9.120%1.572%4.400%-30.182%-12.667% 31-Aug-121406.581.976%0.005%0.557%5.260%-7.426%1.174%-0.412%3.176%9.354%4.106%-2.801%0.166%-1.705%-2.536%0.672%0.929%3.167%-2.510%8.856%-4.874%-3.376%9.314%1.263%19.624%6.417%3.619%5.048%3.011%8.234%-3.131%-0.465%-16.822%6.283% 28-Sep-121440.672.424%0.007%0.446%-3.439%2.099%4.754%-1.550%3.923%0.280%3.230%-2.528%4.149%2.195%5.726%5.680%2.525%8.993%-8.760%10.638%6.125%2.893%6.379%3.726%0.079%2.437%-4.918%-8.841%6.606%10.132%6.758%4.702%19.947%2.436% 31-Oct-121412.16-1.979%0.004%-0.039%-4.099%-1.977%-0.306%-2.162%-5.421%-10.761%0.637%1.214%0.080%2.772%1.186%-6.044%-5.395%3.706%-4.524%5.549%-0.911%-7.082%1.673%4.902%-9.479%-8.425%-10.232%45.554%5.434%-9.835%2.160%3.336%-2.539%1.065% 30-Nov-121416.180.285%0.009%-0.474%-5.939%2.676%-2.698%1.401%-3.312%-1.241%0.852%6.076%1.488%-0.678%-2.915%1.099%1.164%-1.440%-8.507%5.794%-1.165%-1.330%6.484%1.719%11.111%8.226%0.585%3.118%-0.879%2.657%6.020%8.129%32.639%-2.875% 31-Dec-121426.190.707%0.010%-0.269%0.356%-4.404%-1.804%-1.770%2.318%-9.074%-2.778%1.454%0.237%0.531%-6.614%1.772%1.344%7.033%5.392%17.850%-1.927%-1.231%-4.949%8.870%3.910%-0.468%2.423%13.315%0.880%1.290%0.532%1.249%-4.930%0.115% 31-Jan-131498.115.043%0.002%0.296%2.772%2.731%3.951%6.459%6.482%-14.409%11.536%-1.977%9.732%5.449%5.642%8.215%8.026%7.689%2.037%-2.498%1.976%4.539%8.197%0.398%4.685%5.832%0.000%78.464%1.927%6.829%5.581%4.176%16.384%1.788% 28-Feb-131514.681.106%0.005%0.819%2.113%3.974%0.167%4.746%2.518%-2.512%1.357%4.758%0.330%3.788%-1.202%1.318%1.448%3.974%0.309%-0.707%6.696%3.219%2.361%3.912%1.386%-0.463%3.874%13.822%4.491%6.022%-0.112%0.671%-12.043%-3.188% 28-Mar-131569.193.599%0.004%0.262%2.896%5.165%0.625%4.408%1.426%0.285%1.155%11.638%5.444%7.121%4.447%4.048%3.952%-2.984%4.574%8.459%5.631%2.172%2.438%10.697%0.192%0.840%1.343%0.638%5.504%-0.875%4.502%7.060%-6.128%7.432% 30-Apr-131597.571.809%0.004%-0.104%15.714%4.674%-1.243%4.247%2.685%0.027%0.404%6.476%0.728%4.538%6.335%10.634%2.458%3.898%9.686%1.067%10.732%3.325%5.116%3.596%0.933%-4.758%7.327%14.154%-1.155%3.826%2.291%-0.813%8.557%4.754% 31-May-131630.742.076%0.001%0.178%6.133%-5.528%2.371%-2.061%1.426%2.260%-0.013%8.856%-5.504%-0.458%-0.638%0.382%-4.699%11.385%2.317%10.967%-10.072%-6.594%7.239%-4.814%15.272%6.064%5.628%4.711%-2.748%5.657%3.132%5.942%-12.319%4.505% 28-Jun-131606.28-1.500%0.001%0.240%-1.017%1.000%-0.133%1.965%-3.593%-11.830%0.300%3.454%2.864%1.996%0.385%0.111%2.516%-3.297%-0.206%-5.783%3.837%1.172%-1.017%6.176%0.912%3.154%-2.972%-6.701%3.946%1.050%0.745%2.588%2.185%4.998% 31-Jul-131685.734.946%0.001%0.039%-7.830%-0.075%3.763%2.140%6.380%14.123%5.081%2.597%5.212%8.898%3.703%2.375%-0.929%6.289%-3.694%13.530%-0.685%0.904%2.014%3.775%5.856%8.473%2.813%15.820%8.443%0.838%6.390%-3.141%47.910%11.255% 30-Aug-131632.97-3.130%0.001%0.120%5.622%-4.741%-6.357%-4.561%-3.543%8.339%-3.001%-0.661%-3.490%-6.877%-1.827%-5.909%-3.008%-9.331%-4.843%-3.288%-4.244%-4.083%-5.745%-3.236%-8.910%-6.719%2.702%16.126%-6.633%-4.602%-0.742%-1.277%12.212%-1.524% 30-Sep-131681.552.975%0.001%0.116%-0.359%-0.052%-1.285%0.423%0.888%-2.148%-2.953%13.068%1.826%0.324%1.584%6.017%1.961%2.296%4.281%-2.195%-1.488%-0.030%2.349%13.530%0.519%11.268%5.492%8.911%7.650%3.425%11.005%9.563%21.640%0.209% 31-Oct-131756.544.460%0.002%-0.258%6.385%4.461%4.161%5.774%-1.267%9.639%7.622%11.064%6.823%6.829%-5.291%6.358%0.322%0.445%6.758%1.232%9.352%8.368%2.690%4.390%-2.992%16.437%-2.384%4.292%5.508%17.658%6.677%2.915%-0.050%-4.678% 29-Nov-131805.812.805%0.003%-0.204%8.488%2.274%5.010%0.440%2.901%6.967%4.297%3.245%4.188%2.926%10.512%2.843%1.720%11.021%-1.655%13.243%-1.762%-2.735%3.569%4.722%-5.807%8.128%3.266%13.433%4.769%2.815%6.095%3.656%-6.364%9.112% 31-Dec-131848.362.356%0.002%-0.009%-1.888%2.787%8.258%-1.128%2.017%0.890%-3.336%1.669%-3.467%-3.243%1.324%9.527%-0.349%2.202%8.872%-1.517%-0.967%-0.142%2.554%5.458%5.553%1.313%2.692%0.648%4.592%5.768%9.812%9.447%16.250%1.477% 31-Jan-141782.59-3.558%0.001%0.372%1.149%-8.448%-8.933%-3.111%-10.632%-10.770%-5.145%-8.228%-0.751%-3.406%5.834%-4.961%-2.948%-4.685%-5.452%7.579%-1.201%-3.925%-6.667%-1.151%-1.560%-10.055%-1.998%11.180%4.782%5.377%-9.284%-3.256%14.494%-4.011% 28-Feb-141859.454.312%0.005%0.370%1.982%1.005%5.143%-0.361%4.210%5.731%2.662%3.505%6.480%4.872%7.589%11.293%1.901%2.637%1.813%-1.313%-0.916%-4.172%6.740%15.949%-0.502%0.951%17.611%8.868%-5.069%2.937%2.696%5.064%9.413%6.904% 31-Mar-141872.340.693%0.003%0.644%6.996%2.003%1.465%4.993%3.104%1.995%2.466%-2.661%0.031%6.633%0.386%-0.916%3.027%6.846%4.257%4.114%-0.021%9.834%-2.962%-4.211%2.821%-7.107%-2.557%-21.004%-2.757%-8.320%-3.886%-4.461%-12.007%6.471% 30-Apr-141883.950.620%0.002%0.330%-1.439%5.510%4.842%2.862%5.559%9.940%3.218%2.813%-2.615%3.115%3.153%-0.912%3.417%-7.165%3.394%-11.977%-0.652%3.108%0.480%-6.161%3.948%-9.583%3.127%-8.519%3.437%-4.164%-1.392%-6.138%-0.764%-8.477% 30-May-141923.572.103%0.001%0.349%2.030%0.294%-1.162%2.841%-1.322%7.829%-2.132%5.395%-4.444%0.859%-1.195%5.886%0.848%-0.732%3.203%0.000%6.912%-0.644%0.906%4.620%6.534%2.769%3.330%29.745%0.850%6.874%3.943%6.229%5.888%6.117% 30-Jun-141960.231.906%0.002%0.186%1.856%4.290%0.149%1.885%6.320%2.766%-2.723%-5.930%0.169%3.115%0.743%2.059%-0.680%3.689%13.104%1.585%-2.062%-0.310%1.496%12.117%0.934%3.913%-2.421%5.450%3.266%2.278%-3.898%-1.918%6.303%3.133% 31-Jul-141930.67-1.508%0.001%-0.039%3.501%-7.247%-1.728%-1.388%-1.003%2.873%-0.797%-5.305%-2.426%-4.330%-1.919%0.163%-6.135%0.781%9.676%-0.781%4.128%1.951%-0.136%-4.298%2.294%-3.630%-5.609%-4.058%0.093%-0.876%1.075%0.142%7.966%-0.856% 29-Aug-142003.373.766%0.000%-0.167%5.908%6.185%1.223%4.983%0.990%7.709%7.488%5.852%2.404%4.336%5.939%4.658%-0.032%3.087%3.703%5.508%-1.190%-1.770%15.646%3.827%-0.951%8.323%11.629%12.992%1.843%0
Answered 290 days AfterApr 03, 2021

Answer To: Monthly Returns DateLevel of the S&P 500 IndexReturn on the S&P 500 IndexReturn on 30-Day...

Himanshu answered on Jan 19 2022
98 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here