You can get a paper on a similar topic by ordering from us

The purpose of this assignment is to familiarize the students with the data collection and the use of financial/statistical functions in Microsoft excel.
I want you to construct a worksheet which will look like Table 11.9 (slide #22 in your Chapter 5 lecture slides).
Step 1. Check the table at the end of this sheet and see the company assigned for you. Find the ticker symbol of the company.

( MY COMPANY IS : Wal Mart Stores Inc )

2. Find the price data for the company that is assigned to you (you can use yahoo finance, msn finance, Bloomberg or wsjonline) For example with yahoo finance: use the company’s ticker symbol to get the quotes for the company. Then choose historical data. Choose the monthly frequency. But beware! The data you have is price data, you should calculate the monthly return for that stock {[(Pend-Pbegin)/Pbegin]*100} Get the return for that stock from February 1, 2015 to February 1, 2016.
Step 3. Go to the St. Louis Fed’s website (http://stlouisfed.org/) Then, click on research &data, FRED-Economic data, at the next page choose browse data by “category” and then “interest rates”, at the next page choose “corporate bonds”, then “Moody’s” and then choose “Moody’s Seasoned Aaa Corporate Bond Yield” (frequency monthly). Then on the left side menu you will see the download data option. This data is already in returns format, so you don’t need to calculate the returns. Get the yield for bonds from February 1, 2015 to February 1, 2016.
Step 4. Start constructing your excel sheet as in Table 11.9. Use the portfolio weights in that table; then calculate the expected return and standard deviation of your portfolio for February 2016. (Your excel sheet should have 8 columns: portfolio weight of stock, portfolio weight of bond, return on stock, return on bond, standard deviation of stock, standard deviation of bond, expected return of the portfolio, standard deviation of the portfolio). Assume that the correlation between your stock and bond is 0.10.
Step 5. After constructing the table, use the graph function in your excel sheet. Choose the XY (scatter) chart type and then choose the portfolio standard deviation as the x-axis and portfolio expected return as the y-axis (get a graph like the one on slide # 23 on your lecture slides for Chapter 5)
Step 6. Submit your work through Blackboard. Make sure to have two worksheets in your excel file: One including all your calculations, the other including all the data you’ve collected.
If you have any questions, please send an email ***

NOTE: Before submitting your work, please make sure that all your data (stock and bond- from February 2015 to February 2016) is included in your excel file. This is very important.