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

Stock splits stock dividends, Q. Stock dividends and stock splits have the ...

Q. Stock dividends and stock splits have the following effects on retained earnings: Stock Splits Stock Dividends a. Increase No change b. No change Decrease c. Decrease Decrease d

SOURCES OF FUNDS, In spite of the ordinary shares ranking last in terms of ...

In spite of the ordinary shares ranking last in terms of assets sharing in the event of liquidation, they attract more investors than any other type of shares. Why do you think thi

Salary, the salaries paid in 2004 is rs. 500000 salaries outstanding is rs....

the salaries paid in 2004 is rs. 500000 salaries outstanding is rs.20000 salaries paid in advance for 2004 is rs 30000 what is the actual salary expenditure for 2004?

How do you record this transaction, how do you record this transaction? ...

how do you record this transaction? May 18 Issues 30,000 additional shares of $2 common stock for $75 per share. May 25 Issue 8,000 shares of preferred stock for $125 per sha

Liquidity ratio, For each of the ratios listed below, indicate by the appro...

For each of the ratios listed below, indicate by the appropriate code letter, whether itis a liquidity ratio, a profitability ratio, or a solvency ratio. Code: L=Liquidity rati

I want to be expert in this side, Hi, I want to join expert mind as an acco...

Hi, I want to join expert mind as an accounting and financial expert and earn some money herein, can you please let me know the procedure and other requirements. Rahul Jhunjhunwal

What is bequest, Q. What is Bequest? Bequest - A gift by will of person...

Q. What is Bequest? Bequest - A gift by will of personal property. If bequest is money to the extent it's paid out ofincome from property it is taxable to the recipient. Normal

Foreing branches-branches, FOREING BRANCHES The head office my set up a b...

FOREING BRANCHES The head office my set up a branch in a foreign  country. IAS 21 requires that the results of that  foreign branch to be translated into the local currency for t

Explain about spring and forward loading, Q. Explain about Spring and Forwa...

Q. Explain about Spring and Forward loading? Spring loading - Timing of option grants to occur before good news or after bad news is released Concerns about insider trading

What is accounting, What is accounting? Accounting is concerned with an...

What is accounting? Accounting is concerned with analysing, collecting as well as communicating financial information. Purpose is to help people who use this info to make more

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