Calculate and graph the average annual returns , Financial Accounting

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







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
Related Questions
During the course you will be required to develop a Course Project having to do with writing notes for a fictitious annual report.

hello, i have got my answer, but i don''t know the PART C why doesn''t calculate "working capital: 60000"?????? can not find match number in the solution table

The economic demand quantity can also be found out with the assist of a graph. In this technique ordering cost, carrying cost and total inventory costs as per various lot sizes are

Q. Calculation of the change in finance costs? Past ACCA examiners have occupied inconsistent approaches regarding the calculation of the change in finance costs due to settlem

An item of plant was purchased for $100,000 on 1 January 2009. At that time its estimated residual value was $5,000. At 31 December 2009 prices, the residual value was estimated at

Errors in Financial Statements The following financial statements are available for Sherwood Real Estate Company: Balance Sheet Assets Liabilities Cash . . . . . . . . . . . . . .

a) A company has 7000 obsolete toys carried in inventory at a manufacturing cost of $6 per unit. If the toys are reworked for $2 per unit, they could be sold for $3 per unit. If th

petra corporation purchased P4,000 worth of merchandise on account terms 2/10, n?30, FOB shipping point. Prepaid transportation charges of P200 were added to the invoice.

Q. Estimate cost of equity using market values? The cost of equity as well as cost of debt should always be estimated using market values. If the approximate cash flows of a

Q. What is Lifetime Learning Credit? Lifetime Learning Credit - This allows a credit for 20 percent of qualified tuition and fees paid by taxpayer with respect to one or more s