Calculate and graph the average annual returns , Financial Accounting

Assignment Help:

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.

 


Related Discussions:- Calculate and graph the average annual returns

Trial balance, methods of preparation of trial balance

methods of preparation of trial balance

PB7-1 Analyzing the Effects of Four Alternative Inventory Me, Mojo Industri...

Mojo Industries tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period, as if it uses a

Common Stock, If you have 10,000 shares of common stock sold at $10 per sha...

If you have 10,000 shares of common stock sold at $10 per share; and 100,000 shares authorized at $1 par value how would you show this on the balance sheet? Also if we issue 10,00

Effect of resolution-liquidation of companies, Effect of Resolution The...

Effect of Resolution The consequences of the resolution to wind up are: 1) The company must cease to carry on its business except so far as is necessary for the beneficial win

What is profitability ratios, Profitability Ratios - These ratios include...

Profitability Ratios - These ratios include the Gross profit Margin, Net profit Margin, Operating Margin, Return on Equity (ROE), and Return on Total Assets. These ratios helps t

Trend analysis in detail with example, Trend Analysis Tre...

Trend Analysis Trend analysis is an improvement over year-to-year analysis. When a comparison of financial statements covering more than three years i

Fully secret trusts-secret trusts-trusts laws, Fully secret trusts This...

Fully secret trusts This is where neither the existence nor the terms of the trust are disclosed in the will. The trust will be enforced only if the following conditions are

Different powers of investment-trust laws and accounts , Powers of investme...

Powers of investment 1. Shares and debentures:  A trustee may: Invest in bearer securities if these would otherwise be authorised;    Acquiesce in an amalgamation

Determine the missing amounts, Two items are omitted from each of the follo...

Two items are omitted from each of the following summaries of balance sheet and income statement data for two corporations for the year 2014, Steven Craig and Georgia Enterprises.

Excel., prepare an balance sheet

prepare an balance sheet

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd