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

Cash budget, Beginning balance 24,000 cash Sales 250,000 Gross profit 45% o... Beginning balance 24,000 cash Sales 250,000 Gross profit 45% of sales Accounts receivable increase by 24,000 Accounts payable increased by 51,000 Inventory increased by 98,000 Sell

Payrol, a private owned business, pay salary to its employees according to ... a private owned business, pay salary to its employees according to the Ethiopian calendar month to the addis ababa city administration tax authority . Basic salary 3936 ,Normar wor

Assets, tyoes of assets tyoes of assets

What is the sampling unit, What is the objective of performing this test? W... What is the objective of performing this test? What is the sampling unit? What is the population? These are the questions I am confused on the sampling and population I have som

The functional currency method-foreing branches, The functional currency me... The functional currency method (formerly temporal method) Under this method, the branch is considered to be an extension of the head office and this is reflected by the trading

Event affect your ordering decision for pvc pipe, Your firm's research depa... Your firm's research department has estimated the income elasticity of demand for Art Deco lawn furniture to be 1.5. You have just learned that due to an upturn in the economy, con

What is capitalized interest, Q. What is Capitalized Interest? Capitali... Q. What is Capitalized Interest? Capitalized Interest - INTEREST cost incurred during time required to bring an ASSET tothe condition and location for its intended use and incl

State the term reliability- accounting information, State the term Reliabil... State the term Reliability- Accounting Information Accounting must be free from significant error or bias. It must be capable of being relied upon by managers to represent

Ordinary income, Ordinary Income - One of two classes of income (other bein... Ordinary Income - One of two classes of income (other being CAPITAL GAINS) taxed under the INTERNAL REVENUE CODE. Factually, ordinary income is taxed at a higher rate than capital

Track traversal, Track traversal: At the end of the learning process, the r... Track traversal: At the end of the learning process, the robot will return to the packing station. It will then wait for the user input in an innite loop. Once the user species a