Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I really need your help with excel. Thank you!!! 2. Check the Monthly Asset Return Data worksheet, you will find three individual stock and S&P500

I really need your help with excel. Thank you!!!
image text in transcribed
image text in transcribed
2. Check the "Monthly Asset Return Data worksheet, you will find three individual stock and S&P500 index monthly return data for 5 years (60 months). Please build two portfolios: Two stock portfolio of equal weighted stockl and stock2. Three stock portfolio of equal weighted stockl, stock2 and stock3. Calculate the above two portfolios' monthly return for the same 5 years. Calculate Average monthly returns and monthly volatilities for all individual stocks, S&P500 index and the two portfolios. Put your answers into the Google form below. [This step including google form input worth 30% of project grade] 3. Create a new worksheet 60-month Financial Budget". Suppose you graduated and found your dream job in your desired city. Please use online tools to find income and living expense information of your chosen occupation and location. Use the worksheet to create a 60-month financial budget, including: Income; Expenses: taxes, possible debt/loan payments, housing (including utilities), food and grocery, transportation, clothing, entertainments, and others; Emergency fund, and Savings (if you can save). (I would suggest that you put all your assumptions in a worksheet "Assumptions", however, the assumption worksheet is not required.) [This step including google form input worth 40% of project grade] 4. Create a new worksheet "Investment Comparison". If you can build savings beyond emergency fund, starting from the month you have positive savings, compare three different investment choices, put your savings in: a. ONE individual stock of your choice. b. The portfolio of three stocks. c. S&P 500 index Which investment choice deliver the best results? c D EF G H K M Portfolio of (stocka and stock2) Portfolio of stocki, stock2 and stocka) 1 Time 2 Months 3 Month2 4 Month 5 Month 6 Months 7 Month6 8 Month 9 Months 10 Month 11 Month10 12 Monthia 13 Month12 14 Month 13 15 Month14 16 Months 17 Month16 18 Month17 19 Month18 20 Month 19 21 Month20 22 Month21 23 Month22 24 Month2) 25 Month24 26 Month25 27 Month 26 28 Month27 29 Month28 30 Month29 31 Month 30 32 Month31 33 Month32 34 Month33 35 Month 34 36 Month35 37 Month 36 38 Month37 39 Month 38 40 Month 39 41 Month40 42 Month41 41 Month Stocka Stock2 Stock S&P Return 12,5111% 4,7144% 11,7281% 4,6583% 18,6311% 7,2652% 8,1859% 4,3589% 10,3284% 0,6063% 12,0996% 3,4332% 2,7969% 4,4755% 13,9129% 0,4497% -1,2702% -2,1213% -8,7889% 5,9651% 0,8853% -1,6696% 6,6519% 4,2555% 4,3822% 6,2890% 1,5677% 1,5598% 9,1539% 4,1060 5,8166% 2,2763% 0,0803% 3,2296% 1,8369% 2,7236% -10,9607% 0,6373% 9,0252% -1,6789% 1,4413% 0,8521% 7,6256% 0,5847% -9,2738% -2.7782% -1,0682% 1,0068% -14,6094% 11,5363 5,2317% 5,3428% 2,7116% 1,3571% 1,0633 1,4061% 0,0855 1,1552% 0.2401% 3,8988% 0,1729% 0,4042% 5,35819 2,1086 2,0596% 0,0130% 5,4636% 2,3763% -12,0303% 0,2996 2,5538% -1,1999% 13.9225 5,0805X 7,8735% 5,2462% 8,1389% -3,00125 -7,3193% 2,8298% 2,3481% -2.9529% 10,6677% 3,2749% 9,4386N 7,6220% 15,8374% 4,7596% 5,7673 4,2972% 7,5285% 3,1049% 0,6902% -3,3365% 0,7135% 2,6563% 10,9697 -5,1449 -10,6554 -3,2583% 5,5311% 2,6625 0,3507% 4,6117% 1,7953% 2.4663% -7,7072% 0,9932% 9,7396% 3,2179% -10,1833% 0.92015 7,6293% -2.1320 2,1685 2,4030% 2.5662 -2.7231% 3,3130% 2,2058% 2,6731 0,7970 4,2302% 1,2080% 7.5092% 7.4884% 7,7230% 4,0655% -1.9073 0.7580% -5,4962% 1,2514% 6,9960% 4.9840% -5,8661% 2,6201% 10,3556% 3,6210% -11,4623% 2,7534% -7,3891% 0,2298% -8,9540% 0,1189% 5.9424% 6,7586% -14,8355% -2,8041% 9,8461% 0,9966% 6,6293% 5,7893% -3,3372% -3,7472% 2.7202% -1,4396% 0,3786% -2.1566% 2.7512 1,1521% 4,3146% 1.4086% 1,1663% 1,3491% 1026 1914 0522 101% Student ID Monthly Asset Return Data Assumptions 60-month Financial Budgets Investment Comparison Ready 2. Check the "Monthly Asset Return Data worksheet, you will find three individual stock and S&P500 index monthly return data for 5 years (60 months). Please build two portfolios: Two stock portfolio of equal weighted stockl and stock2. Three stock portfolio of equal weighted stockl, stock2 and stock3. Calculate the above two portfolios' monthly return for the same 5 years. Calculate Average monthly returns and monthly volatilities for all individual stocks, S&P500 index and the two portfolios. Put your answers into the Google form below. [This step including google form input worth 30% of project grade] 3. Create a new worksheet 60-month Financial Budget". Suppose you graduated and found your dream job in your desired city. Please use online tools to find income and living expense information of your chosen occupation and location. Use the worksheet to create a 60-month financial budget, including: Income; Expenses: taxes, possible debt/loan payments, housing (including utilities), food and grocery, transportation, clothing, entertainments, and others; Emergency fund, and Savings (if you can save). (I would suggest that you put all your assumptions in a worksheet "Assumptions", however, the assumption worksheet is not required.) [This step including google form input worth 40% of project grade] 4. Create a new worksheet "Investment Comparison". If you can build savings beyond emergency fund, starting from the month you have positive savings, compare three different investment choices, put your savings in: a. ONE individual stock of your choice. b. The portfolio of three stocks. c. S&P 500 index Which investment choice deliver the best results? c D EF G H K M Portfolio of (stocka and stock2) Portfolio of stocki, stock2 and stocka) 1 Time 2 Months 3 Month2 4 Month 5 Month 6 Months 7 Month6 8 Month 9 Months 10 Month 11 Month10 12 Monthia 13 Month12 14 Month 13 15 Month14 16 Months 17 Month16 18 Month17 19 Month18 20 Month 19 21 Month20 22 Month21 23 Month22 24 Month2) 25 Month24 26 Month25 27 Month 26 28 Month27 29 Month28 30 Month29 31 Month 30 32 Month31 33 Month32 34 Month33 35 Month 34 36 Month35 37 Month 36 38 Month37 39 Month 38 40 Month 39 41 Month40 42 Month41 41 Month Stocka Stock2 Stock S&P Return 12,5111% 4,7144% 11,7281% 4,6583% 18,6311% 7,2652% 8,1859% 4,3589% 10,3284% 0,6063% 12,0996% 3,4332% 2,7969% 4,4755% 13,9129% 0,4497% -1,2702% -2,1213% -8,7889% 5,9651% 0,8853% -1,6696% 6,6519% 4,2555% 4,3822% 6,2890% 1,5677% 1,5598% 9,1539% 4,1060 5,8166% 2,2763% 0,0803% 3,2296% 1,8369% 2,7236% -10,9607% 0,6373% 9,0252% -1,6789% 1,4413% 0,8521% 7,6256% 0,5847% -9,2738% -2.7782% -1,0682% 1,0068% -14,6094% 11,5363 5,2317% 5,3428% 2,7116% 1,3571% 1,0633 1,4061% 0,0855 1,1552% 0.2401% 3,8988% 0,1729% 0,4042% 5,35819 2,1086 2,0596% 0,0130% 5,4636% 2,3763% -12,0303% 0,2996 2,5538% -1,1999% 13.9225 5,0805X 7,8735% 5,2462% 8,1389% -3,00125 -7,3193% 2,8298% 2,3481% -2.9529% 10,6677% 3,2749% 9,4386N 7,6220% 15,8374% 4,7596% 5,7673 4,2972% 7,5285% 3,1049% 0,6902% -3,3365% 0,7135% 2,6563% 10,9697 -5,1449 -10,6554 -3,2583% 5,5311% 2,6625 0,3507% 4,6117% 1,7953% 2.4663% -7,7072% 0,9932% 9,7396% 3,2179% -10,1833% 0.92015 7,6293% -2.1320 2,1685 2,4030% 2.5662 -2.7231% 3,3130% 2,2058% 2,6731 0,7970 4,2302% 1,2080% 7.5092% 7.4884% 7,7230% 4,0655% -1.9073 0.7580% -5,4962% 1,2514% 6,9960% 4.9840% -5,8661% 2,6201% 10,3556% 3,6210% -11,4623% 2,7534% -7,3891% 0,2298% -8,9540% 0,1189% 5.9424% 6,7586% -14,8355% -2,8041% 9,8461% 0,9966% 6,6293% 5,7893% -3,3372% -3,7472% 2.7202% -1,4396% 0,3786% -2.1566% 2.7512 1,1521% 4,3146% 1.4086% 1,1663% 1,3491% 1026 1914 0522 101% Student ID Monthly Asset Return Data Assumptions 60-month Financial Budgets Investment Comparison Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions