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

Closing entries, Closing Entries: Expenses Below is a list of accounts with...

Closing Entries: Expenses Below is a list of accounts with corresponding ending balances. Account: Account Balance a.Insurance Expense: $1,300 b.Cash: 750 c.Accounts Receivable: 4,

What is the after-tax cash flow from the salvage value, Morgado Inc. has pr...

Morgado Inc. has provided the following data to be used in evaluating a proposed investment project: Initial investment $130,000 Annual cash receipts $78,000 Life of the p

Determine the yield to maturity of the bond, The current market price of a ...

The current market price of a Leigh bond is $1,297.6. If the coupon rate is 10% and the par value is equal to $1,000, what is the yield to maturity of the bond if it matures in 10

Capital gain/loss of bond investment, Problem 1 Seven years ago a semi-ann...

Problem 1 Seven years ago a semi-annual coupon bond with a 10% coupon rate, $1,000 face value and 15 years to maturity was issued by Corn Inc.. Teddy bought this bond two years ag

Determine the npv of future cash flows, While many people know that Sonora,...

While many people know that Sonora, Mexico is a beautiful vacation spot, it is also a large furniture manufacturing location in North America. Guillermo Navallez made furniture for

A gift of residue-will-executorship law and accounts, A gift of residue ...

A gift of residue Where property is not given by a specific legacy nor by a general legacy, it makes up the residue of the testator's estate.  If the testator fails to make a g

Instantaneous standard deviation, The current stock price of International ...

The current stock price of International Wood is $69 and the stock does not pay dividends. The instantaneous risk free rate of return is 10%. The instantaneous standard deviation

Illustration of balance sheet, Normal 0 false false false ...

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Doubling period, One of the initial and the most general questions regardin...

One of the initial and the most general questions regarding an investment optional is the time period needed to double the investment. One clear way is to consider to the table of

HELP!, How do you know what goes on an income statement? P.S. This is a bas...

How do you know what goes on an income statement? P.S. This is a basic income statement.

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