{"id":734,"date":"2015-12-23T19:28:24","date_gmt":"2015-12-23T08:28:24","guid":{"rendered":"http:\/\/casestudyhelp.com\/sample-questions\/?p=734"},"modified":"2018-01-25T18:17:47","modified_gmt":"2018-01-25T07:17:47","slug":"financial-modeling-in-excel-the-assignment-is-intended-to-help","status":"publish","type":"post","link":"https:\/\/casestudyhelp.com\/sample-questions\/financial-modeling-in-excel-the-assignment-is-intended-to-help\/","title":{"rendered":"Financial Modeling in Excel – The assignment is intended to help"},"content":{"rendered":"

The assignment is intended to help you develop skills of implementing financial models in Excel. The assignment provides you with an opportunity to produce spreadsheet applications that solve and analyse corporate finance problems<\/p>\n

\n

2) Obtain from Bloomberg (or Datastream, or Thomson ONE Banker, or<\/p>\n

Yahoo!Finance) the beginning of month values for the period 2001-2015 of both<\/p>\n

the Dow Jones Utility Average Index and the PHLX Gold\/Silver Sector Index.<\/p>\n

Assume that you are a risk-averse investor.<\/p>\n

For each of the two assets represented by the indices, calculate annual returns<\/p>\n

and build a frequency distribution of annual returns. Provide graphs of the<\/p>\n

distributions.<\/p>\n

Explore the risk-return relationship for the two assets. Plot your results on a<\/p>\n

graph with the standard deviation of annual returns of each asset on the<\/p>\n

horizontal axis and the average annual return on the vertical axis, and comment<\/p>\n

on which asset performed better.<\/p>\n

\n

Assume that you form a portfolio by investing equal amount of money in each<\/p>\n

asset. Determine the average and standard deviation of the portfolio\u2019s annual<\/p>\n

returns. Provide your interpretation of the risk and return of the equally-weighted<\/p>\n

portfolio compared to those of the individual assets.<\/p>\n

\n

Calculate and graph the average annual returns and standard deviations of all<\/p>\n

portfolios that are combinations of Dow Jones Utility Average and PHLX<\/p>\n

Gold\/Silver Sector with the proportion of the Dow Jones Utility Average being 0,<\/p>\n

10, 20, 30, 40, 50, 60, 70, 80, 90, 100%. Comment on the profile of the riskreturn<\/p>\n

trade-off between the portfolios.<\/p>\n

(35%)<\/p>\n

\u00a03) For the last ten-year period, collect from Bloomberg (or Datastream, or Thomson ONE Banker, or Yahoo!Finance) end-of-year values of the NASDAQ Composite Index (a stock index) and end-of-year prices of any two of the member stocks of NASDAQ Composite Index . Collect also the latest prices for the two selected NASDAQ Composite Index stocks. Assume that the NASDAQ Composite Index represents the market portfolio. Compute the excess return of each of the two stocks that you have selected against that of the NASDAQ Composite Index. Use the short-term Treasury Bill rate as the risk-free rate in the CAPM. Using the CAPM model and regression analysis, provide the estimates of both systematic risk and theoretical return for the selected two stocks. Discuss the results. Explain which of the two stocks has more systematic risk.<\/p>\n

\u00a0(35%)<\/p>\n

To Get Answer Order Now \/ Chat with Online Assignment Adviser<\/strong><\/p>\n

\"Hire<\/a><\/p>\n

\n

Chat with our 24 x 7 Online Agents CLICK CHAT NOW<\/strong><\/p>\n

Ask Your\u00a0Finance Case Study Assignment Question<\/a><\/strong>?<\/strong><\/strong>
\nCheck out our\u00a0Corporate Finance Assignment Service<\/a><\/strong>
\nFind Your\u00a0MBA Assignment Experts<\/a><\/strong><\/p>\n