please answer it As sson As possible, 1st question has excel sheet stats for the calculation

Corporate Finance BAO2001 Group Assessment Group Joshua Rowswell: 54551323 Tinh Pham s4570979 1. Using the information given in Exhibit 1, calculate the historical returns for each company and the market index. With the use of the excel functions calculate the average monthly return and standard deviation of returns for each company and the market index. Provide a summary of these results in a table format in your report. Are these results consistent with the risk/return relationship as described in finance theory Our best estimate of the expected return for the index is its average return for the market return, 0.00788, with a standard deviation of 0.0125. Whilst Mercury Pty Ltd expected return for the index average return of 0.0082 with a standard deviation of 0.0314 and pluto Pty Ltd expects to have an index average return of 0.00622 and a standard deviation of 0.0192. 2. Using your answers to Question 1, above, and assuming that Investors can only invest in one of the two alternative shares in Exhibit 1, use the average return and standard deviation to determine which share would be the most appealing to a risk-averse investor. Provide numerical justification for your selection based on the coefficient of variation. Please provide a definition of risk aversion as it relates to an investors preferences for risk and return. Month Share Market Reum Mercury Led Ratum Pluto Lid Retur 19.00 15 6595 1200 . Share Marke Mercury LNPuto LM (5) 1 5790 8.75 17.10 2 5845 17.25 3 5890 BOS 1750 4 5935 920 17.40 5 6000 9.65 17.75 6 5975 10.35 18.10 7 8015 10 80 SARO 8 6135 11.30 18.85 9 6070 11.60 18.40 10 6200 11.50 18.85 11 6345 1175 12 6140 11.30 18.35 6245 11.50 18.70 14 5440 1190 19.00 15 6560 12.40 19.25 16 6310 1170 1950 12 6210 11.10 20.00 18 6375 1200 2100 19 5490 12.30 22.00 20 6000 12.00 2250 21 6490 12.10 21.90 22 6385 10.45 20.30 23 6500 11.00 21.10 24 6656 11.35 21.00 25 6570 51.75 21.30 26 11.90 21.05 27 8610 12.00 21.20 28 6635 12.10 21.40 29 6625 21.25 30 6615 51.85 21.10 31 6835 12.05 21.20 32 6650 12.20 21.50 33 6670 12.10 21.50 34 6615 1225 21.05 35 6705 12.35 2208 36 6720 1230 22.15 37 6700 12.40 22 30 30 6740 12.45 22.40 39 6710 12.35 2230 40 6670 12. 20 22.00 41 6705 12.30 2225 42 6745 12.45 22 50 43 6000 12.55 22.75 44 6850 12.70 22.30 45 6825 12.65 22.75 40 8800 12.65 22.65 47 6855 12.70 22.30 40 6915 12.95 23.05 40 7000 13.08 23.30 50 7060 13.15 23.45 51 7095 13.20 23.60 52 7065 13.10 23.50 53 7100 13:35 23.65 54 7155 13.40 56 7100 1350 2400 57 7155 11.45 23.85 50 1335 23.70 59 7190 13.50 2405 60 7245 13.60 24 20 2270 13.75 2440 0.000499136142141620003 0.00571428571428000877192982 0.00789888793840890000C0.02840909090909001449275362 0.00764005791171477000C001657458563535 -0.0057142857 0.01096197978096040000C0.04891304347228 002011494252 -0.00456666666666667000 0.07253885010362 0.01971830985 0.0088945606694580700C004347826086956 002762430939 001960012468827930000 04629629629629.001344086021 -0.01059494702525490000 0.02854867256637 -0.0238725790 0.02545680395387150000K -0.00852068965517002445652173 0.02338709677419360000CO 02173913063478 0.00795755968 -0.032300046933020000-00382978723406-00342105203 0.01710097719069710000C0.01789911504424 0.01907356948 0 031224979983987200006003478260860565001604278074 0.01863354037267080000C0.04.201680672258-001315780473 -0.02505463414634150000-005645161203220.01298701208 -0.02616901408450700000-0,0512620512200002564102564 0.026570048309178700006008108108108108 00000000000 0.01803921568627450000C0.02500000000000004761904761 001694915254237290000C0.02439024390243 0622727 0.01666666666666670000-00396825396325-0.0206666666 0.01617873651771960000-01363636363635-00730593607: 0.01801096319498830000C0-05263157894736.003940886699 0.02364615384615350000C0.03181818181818 0.03791469194 0.01277235161532680000 0.00524220074389:-0.0273972602 0.00380517500805175000CO 01278595744680.00117370892 0.00227445034116755000C0.00840336134453 0.00712589073 0.0037821482602118000OCO 00833333333333 0.00943396226 -0.00150715900527506000-0.00625446280991-0.00700934571 0.00150903396226415000-00125000000000-000705682360 0.0030234315948601700000.01667783713060 0.00473933649 0.002260738507912580000.012448132780080.01415094339 0.0030075167969924800X-0.008196721311470.00465116279 0.00224687556221889COOCO 0123968042148710.01157407407 0.002991772625280480000.008163265305120.0091533180T 000023713646532438000(-0.0040485829969: 0.00453614739 -0.00297519047619048000 0.00813008130081 0.00577200912 0.0059701492537313400OCO 00403225806451 0.00448430493 0.00445103857565760000-000803212855402-0.0044542857 -0.00598125186289121000-00121457489878-001345291471 0.00524737631184408000CO 00819672131147.001136363636 0.0059659724086503000C0.012195121951210.01123595505 0.008154188287620450000.00803212851406-001111111111 0.007352911754705900000011962191235050.00059340659 -0.00364963503545635000 -0.00393700787401-0.0065502183 -0.00366300366300066000 -0.00790513833990 -0.00439560431 0.0080882352941176500000011952191235054 0.01103752759 0.008752735229759300000.011811023622014: 0.00655021634 0.01229211858279100000C0.01566420233465 0.01084598698 0.0085714285714285700000.00786283524904 0.00613776824 0.00495750708215297000CO 00380228136882 0.00639658848 0.00422832980972516000--0.00757575757575 -0.0042372881: 0.00496399858457163000C00196839696564.000638297872 0.00774547887323944000C0.00074531835203 0.00634249471 0.004891684136967160006 0.00746268656716-0.00840336134 0.00436787204450626000 -0.00370370370370-0.00624999000 00034406000783308000-000743495423791-0.0062010001 0.00841514725507714000C0.0112359660661710.01476793248 0.00764951321279555000000740740740740 0.00623700623 0.0034506556245686700000.011029411754700.00826416280 10 7130 21 Average SD 0.0039427948351236200000.00818840170757 0.00022068266 0.01253436958 003140015379 0.01921487 Coeficient of Variation 3834710562 3.00 Average Risk Of The 2 Asse 0.02530751299 Correlation Coeficient Corporate Finance BAO2001 Group Assessment Group Joshua Rowswell: 54551323 Tinh Pham s4570979 1. Using the information given in Exhibit 1, calculate the historical returns for each company and the market index. With the use of the excel functions calculate the average monthly return and standard deviation of returns for each company and the market index. Provide a summary of these results in a table format in your report. Are these results consistent with the risk/return relationship as described in finance theory Our best estimate of the expected return for the index is its average return for the market return, 0.00788, with a standard deviation of 0.0125. Whilst Mercury Pty Ltd expected return for the index average return of 0.0082 with a standard deviation of 0.0314 and pluto Pty Ltd expects to have an index average return of 0.00622 and a standard deviation of 0.0192. 2. Using your answers to Question 1, above, and assuming that Investors can only invest in one of the two alternative shares in Exhibit 1, use the average return and standard deviation to determine which share would be the most appealing to a risk-averse investor. Provide numerical justification for your selection based on the coefficient of variation. Please provide a definition of risk aversion as it relates to an investors preferences for risk and return. Month Share Market Reum Mercury Led Ratum Pluto Lid Retur 19.00 15 6595 1200 . Share Marke Mercury LNPuto LM (5) 1 5790 8.75 17.10 2 5845 17.25 3 5890 BOS 1750 4 5935 920 17.40 5 6000 9.65 17.75 6 5975 10.35 18.10 7 8015 10 80 SARO 8 6135 11.30 18.85 9 6070 11.60 18.40 10 6200 11.50 18.85 11 6345 1175 12 6140 11.30 18.35 6245 11.50 18.70 14 5440 1190 19.00 15 6560 12.40 19.25 16 6310 1170 1950 12 6210 11.10 20.00 18 6375 1200 2100 19 5490 12.30 22.00 20 6000 12.00 2250 21 6490 12.10 21.90 22 6385 10.45 20.30 23 6500 11.00 21.10 24 6656 11.35 21.00 25 6570 51.75 21.30 26 11.90 21.05 27 8610 12.00 21.20 28 6635 12.10 21.40 29 6625 21.25 30 6615 51.85 21.10 31 6835 12.05 21.20 32 6650 12.20 21.50 33 6670 12.10 21.50 34 6615 1225 21.05 35 6705 12.35 2208 36 6720 1230 22.15 37 6700 12.40 22 30 30 6740 12.45 22.40 39 6710 12.35 2230 40 6670 12. 20 22.00 41 6705 12.30 2225 42 6745 12.45 22 50 43 6000 12.55 22.75 44 6850 12.70 22.30 45 6825 12.65 22.75 40 8800 12.65 22.65 47 6855 12.70 22.30 40 6915 12.95 23.05 40 7000 13.08 23.30 50 7060 13.15 23.45 51 7095 13.20 23.60 52 7065 13.10 23.50 53 7100 13:35 23.65 54 7155 13.40 56 7100 1350 2400 57 7155 11.45 23.85 50 1335 23.70 59 7190 13.50 2405 60 7245 13.60 24 20 2270 13.75 2440 0.000499136142141620003 0.00571428571428000877192982 0.00789888793840890000C0.02840909090909001449275362 0.00764005791171477000C001657458563535 -0.0057142857 0.01096197978096040000C0.04891304347228 002011494252 -0.00456666666666667000 0.07253885010362 0.01971830985 0.0088945606694580700C004347826086956 002762430939 001960012468827930000 04629629629629.001344086021 -0.01059494702525490000 0.02854867256637 -0.0238725790 0.02545680395387150000K -0.00852068965517002445652173 0.02338709677419360000CO 02173913063478 0.00795755968 -0.032300046933020000-00382978723406-00342105203 0.01710097719069710000C0.01789911504424 0.01907356948 0 031224979983987200006003478260860565001604278074 0.01863354037267080000C0.04.201680672258-001315780473 -0.02505463414634150000-005645161203220.01298701208 -0.02616901408450700000-0,0512620512200002564102564 0.026570048309178700006008108108108108 00000000000 0.01803921568627450000C0.02500000000000004761904761 001694915254237290000C0.02439024390243 0622727 0.01666666666666670000-00396825396325-0.0206666666 0.01617873651771960000-01363636363635-00730593607: 0.01801096319498830000C0-05263157894736.003940886699 0.02364615384615350000C0.03181818181818 0.03791469194 0.01277235161532680000 0.00524220074389:-0.0273972602 0.00380517500805175000CO 01278595744680.00117370892 0.00227445034116755000C0.00840336134453 0.00712589073 0.0037821482602118000OCO 00833333333333 0.00943396226 -0.00150715900527506000-0.00625446280991-0.00700934571 0.00150903396226415000-00125000000000-000705682360 0.0030234315948601700000.01667783713060 0.00473933649 0.002260738507912580000.012448132780080.01415094339 0.0030075167969924800X-0.008196721311470.00465116279 0.00224687556221889COOCO 0123968042148710.01157407407 0.002991772625280480000.008163265305120.0091533180T 000023713646532438000(-0.0040485829969: 0.00453614739 -0.00297519047619048000 0.00813008130081 0.00577200912 0.0059701492537313400OCO 00403225806451 0.00448430493 0.00445103857565760000-000803212855402-0.0044542857 -0.00598125186289121000-00121457489878-001345291471 0.00524737631184408000CO 00819672131147.001136363636 0.0059659724086503000C0.012195121951210.01123595505 0.008154188287620450000.00803212851406-001111111111 0.007352911754705900000011962191235050.00059340659 -0.00364963503545635000 -0.00393700787401-0.0065502183 -0.00366300366300066000 -0.00790513833990 -0.00439560431 0.0080882352941176500000011952191235054 0.01103752759 0.008752735229759300000.011811023622014: 0.00655021634 0.01229211858279100000C0.01566420233465 0.01084598698 0.0085714285714285700000.00786283524904 0.00613776824 0.00495750708215297000CO 00380228136882 0.00639658848 0.00422832980972516000--0.00757575757575 -0.0042372881: 0.00496399858457163000C00196839696564.000638297872 0.00774547887323944000C0.00074531835203 0.00634249471 0.004891684136967160006 0.00746268656716-0.00840336134 0.00436787204450626000 -0.00370370370370-0.00624999000 00034406000783308000-000743495423791-0.0062010001 0.00841514725507714000C0.0112359660661710.01476793248 0.00764951321279555000000740740740740 0.00623700623 0.0034506556245686700000.011029411754700.00826416280 10 7130 21 Average SD 0.0039427948351236200000.00818840170757 0.00022068266 0.01253436958 003140015379 0.01921487 Coeficient of Variation 3834710562 3.00 Average Risk Of The 2 Asse 0.02530751299 Correlation Coeficient