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

What is amount per share, Q. What is Amount per share? Par Value - Amou...

Q. What is Amount per share? Par Value - Amount per share set in ARTICLES OF INCORPORATION of a CORPORATION to be entered in CAPITAL STOCKS account where it's left permanently

Balance sheet and income statement, The balance sheet and income statement ...

The balance sheet and income statement for Bingle Ltd is presented to you as follows: Balance Sheet Extract as at 30 June 2012 with comparatives

Illustration of accounting treatment of deferred tax, Illustration of Accou...

Illustration of Accounting treatment of deferred tax A Ltd., bought an item of plant at a cost of £100,000 in year 2000. The estimated useful life of the plant was 5 years and

What is capital gain, Q. What is Capital Gain? Capital Gain - Portion o...

Q. What is Capital Gain? Capital Gain - Portion of total GAIN recognized on the sale or exchange of a no inventoryasset that isn't taxed as ORDINARY INCOME. Capital gains have

Lease accounting, The following facts pertain to a noncancelable lease agre...

The following facts pertain to a noncancelable lease agreement between Lennox Leasing Company and Gill Company, a lessee. Inception date: May 1, 2012 Annual lease payment due at th

Report on financial statements, At one time, Circle K was the second-larges...

At one time, Circle K was the second-largest convenience store chain in the United States. At its peak, Circle K operated 4,685 stores in 32 states. Circle K's rapid expansion was

Cashflows from operating activities-group activities, Cashflows from operat...

Cashflows from operating activities  operating activities are the principle revenue generating activities of the business and examples of such cashflows include: Cash re

The fair-value method of accounting for nci., In the current year, Company ...

In the current year, Company A is formed with $630,000 in capital from the sale of 21,000 shares of stock at $30 a share. Company A, which has no other operations, immediately acqu

Prepare statement of income and comprehensive income, The following income ...

The following income statement items appeared on the adjusted trial balance of Schembri Manufacturing Corporation for the year ended December 31, 2013 ($ in 000s): sales revenue, $

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

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