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

Financial statement analysis, Financial statement analysis involves the app...

Financial statement analysis involves the application of analytical tools and techniques to the financial data to get information that is useful in decision-making. Foundation o

Capital asset pricing model to estimate a project, Q. Capital asset pricing...

Q. Capital asset pricing model to estimate a project? CAPM could have been utilized to estimate a project - specific Ke if the project activities were different from that of th

Generates the state dependent cash flows, Consider an economy with three st...

Consider an economy with three states which occur with probability (0.2, 0.4, 0.4). Suppose a firm has a project which generates the state dependent cash flows (100, 200, 200) at t

Balance sheet-trusts laws and accounts, BALANCE SHEET Grouping of items...

BALANCE SHEET Grouping of items:   Items in the Balance Sheet should be grouped under appropriate headings. In particular, a trust operating the provisions of the Trustee Act

What would be the money multiplier, The SIMPLEX financial system is charact...

The SIMPLEX financial system is characterized by a required reserves ratio of 11 percent; initial excess reserves are $1 million, and there are no currency or other leakages. a.

What do you mean by depreciation, Q. What do you mean by depreciation? What...

Q. What do you mean by depreciation? What are the causes for depreciation? Explain the two methods of depreciation. Depreciation means a fall in the quality, quantity or value o

Calculate the profit maximization, Complete the table and use the informati...

Complete the table and use the information to determine profit maximization or loss minimization. 1. Complete the table Normal 0 false false false EN-I

Determine the total production requirement for the month, A Company policy ...

A Company policy calls for keeping safety-stock equal to 25% the forecasted demand for that month.  The company currently has a work force of 12 people.  It takes a worker 3 hours

Give reasons why both options should be used, Apple Corporation has been he...

Apple Corporation has been hearing complaints from some shareholders about returning some of the $150 billion in cash that the corporation has. Some shareholders think a large divi

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