This is an individual assessment contributing 50% of your marks for the module. The assignment is intended to help you develop skills of implementing financial models in Excel. The assignment provides you with the opportunity to produce spreadsheet applications that solve and analyse corporate finance problems.

You are required to set up a separate worksheet (spreadsheet model) for each of the following two problems:
1) Calculate the yield to maturity of a 7-year $1,000 par value bond with an annual coupon rate of 7.5% and a current price of $1,125. Provide the spreadsheet solutions for both annual and semi-annual payments of interest. Comment on the relationship between the yield to maturity and the timing of interest payments, providing an appropriate table or graph.

2) Obtain from Bloomberg (or Datastream, or Thomson ONE Banker, or Yahoo!Finance) the beginning of month values for the period 2009-2012 of the Standard & Poor's (S&P) SMALL CAP 600 Index and New York Stock Exchange (NYSE) World Leaders Index. Assume that you are a risk-averse investor.

For each of the two assets represented by the indices, calculate annual returns and build a frequency distribution of annual returns. Provide graphs of the distributions.

Explore the risk-return relationship for the two assets. Plot your results on a graph with the standard deviation of annual returns of each asset on the horizontal axis and the average annual return on the vertical axis, and comment on which asset performed better.
Assume that you form a portfolio by investing equal amount of money in each asset. Determine the average and standard deviation of the portfolio's annual returns. Provide your interpretation of the risk and return of the equally-weighted portfolio compared to those of the individual assets.

Calculate and graph the average annual returns and standard deviations of all portfolios that are combinations of the S&P SMALL CAP 600 Index and NYSE World Leaders Index with the proportion of the S&P SMALL CAP 600 Index being 0, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100%. Comment on the profile of the risk-return trade-off between the portfolios.

 

Posted Date: 3/29/2013 5:50:13 AM | Location : United States

Ask an Expert

Related Discussions:- Calculate and graph the average annual returns , Assignment Help, Ask Question on Calculate and graph the average annual returns , Get Answer, Expert's Help, Calculate and graph the average annual returns Discussions

Write discussion on Calculate and graph the average annual returns
Your posts are moderated

Write your message here..

Related Questions

Complete the cash flow spreadsheet, This lab assignment will correspond to ... This lab assignment will correspond to developing a cash flow budget with an operating loan. There is on lab exercise listed below. Additionally, there are two assignment questions

Extract the term structure of interest rates, Extract the term structure of... Extract the term structure of interest rates out to 3 years given the following bond data: Maturity (yrs)    Coupon rate (%)   Yield to maturity (%) 0. 5

#accounting concepts, #what are the limitations or disadvantages of account... #what are the limitations or disadvantages of accounting concept?

Sequential stages of an accounting information system, Relationship between... Relationship between these aspects is set out in Figure.                                 Figure: The accounting information system There are four sequential stages of an

OPERATING CYCLE, APPLICABILITY OF THE OPERATING CYCLE IN VEGETABLE GROWING ... APPLICABILITY OF THE OPERATING CYCLE IN VEGETABLE GROWING BUSINESS

Balance sheet preparation with a missing element, Balance Sheet Preparation... Balance Sheet Preparation with a Missing Element The following data are available for Schubert Products Inc. as of December 31, 2012. Cash . . . . . . . . . . . . . . . . . . . . .

Case., VK Ltd a multi-product Company, furnishes you the following data rel... VK Ltd a multi-product Company, furnishes you the following data relating to the year 2000. First Half of the year Second Half of the year Sales Rs. 4

Credit control, Once credit has been extended it is vital to ensure that cu... Once credit has been extended it is vital to ensure that customers abide by agreed terms of trade. Regular checks on customer accounts for instance using an aged receivables analys

Litigation support and dispute resolution, Litigation Support/Dispute Resol... Litigation Support/Dispute Resolution - A service that CPAs every so often provide to attorneys -for example expert testimony about the value of a business or other asset, for

What is the impact on net income, The Budvar Company purchases parts from a... The Budvar Company purchases parts from a foreign customer on December 1, Year 1, with payment of 20,000 crowns 20,000 crowns to be made on March 1, Year 2.  Budvar enters into a f