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.

Illustrate the new rules of sec, New Rules SEC i) Effective for years a...

New Rules SEC i) Effective for years after December 15, 2006 ii) New Disclosures mandated (1) Fair value of options on grant date (2) Value of grant per 123R (3) Cl

Linear Programming Problem using Simple method, Maximize Z= 3x1 + 2X2 Subje...

Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0

Depreciation, what are methods of calculating depreciation?

what are methods of calculating depreciation?

Horizontal analysis - total current liabilities, 1. Complete a horizontal a...

1. Complete a horizontal analysis using the dollar and percent change in the following items from the preceding year to the current year: (one typed page: use a table format with f

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

Half secret trusts-secret trusts-trusts laws and accounts, Half secret trus...

Half secret trusts In this type of trust the will states that the gift is on trust, but the name of the beneficiary is not specified. Since the existence of a trust is disclose

Explain the accounting treatment , This is a research case.  You must compl...

This is a research case.  You must complete this assignment INDIVIDUALLY.  This means no help from other students.  You may consult Dr. Eldridge while you are working on this case.

Legal delinquency, Omission to do something which a reasonable man, guided ...

Omission to do something which a reasonable man, guided by those ordinary considerations that ordinarily regulate human affairs, would do or doing of something that a reasonable an

Calculate the optimal allocation of stocks, A) Suppose you have two stocks ...

A) Suppose you have two stocks (A and B) in your portfolio, worth \$400,000 and \$600,000 respectively. The annual volatility is 0.30 and 0.35 respectively. The correlation between t

Important points for holding company with subsidiary , Important points for...

Important points for holding company with subsidiary The following points are important: 1) The first approach is to determine the effective shareholding by the holding compan