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

Receiverships-appointment of receiver, RECEIVERSHIPS: APPOINTMENT OF RECEIV...

RECEIVERSHIPS: APPOINTMENT OF RECEIVER If a company defaults in payment of principal or interest, or otherwise defaults in observing the conditions contained in debentures issu

What is leveraged lease, Q. What is Leveraged Lease? Leveraged Lease - ...

Q. What is Leveraged Lease? Leveraged Lease - Transaction under which LESSOR borrows funds to acquire property which is leased to a third party. Property and lease rentals are

Calculate the net present value, You are a Senior Financial Manager in the ...

You are a Senior Financial Manager in the recently privatised Sodor Railway Engineering Corporation Plc (SREC). (a) Subsequent to privatisation the Chief Executive Officer of SR

Accrual-based income statement for 2011, The Wanless Corporation provides I...

The Wanless Corporation provides Internet consulting services to a wide-range of customers. The company's fiscal year ends on December 31. For the year ended December 31, 2011, the

Powerpoint presentation, I have a presentation on an article (around 20 pag...

I have a presentation on an article (around 20 pages). I also need 2 current real life examples (2 companies) to support the presentation. Can you do that? How long it will take yo

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

Find market and alpha and beta values, a. Find five comparables for Bank of...

a. Find five comparables for Bank of America (BAC) b. Find the CEO of BAC and five comparable companies, For BAC and all firms, find: c. Market value, alpha and beta (pric

Depreciation, what are methods of calculating depreciation?

what are methods of calculating depreciation?

Financial accounting theory, accountability through conceptual framework in...

accountability through conceptual framework in australia eassy on this topic with research

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