Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

You are required to set up a separate worksheet (spreadsheet model) for each of the following two problems:  

problem 1: find out 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.

problem 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, find out 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. 
 
find out 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.

Indicative Reading:

A) For advice on design approaches that can assist with production of useful to financial managers Excel applications you might wish to consult Day’s Mastering Financial Modelling in Microsoft Excel and the latest edition of Benninga’s Principles of Corporate Finance with Microsoft Excel. 

B) For working knowledge of the concepts and theories of corporate finance involved with this assignment you will need to read the relevant chapters of the latest edition of Corporate Finance by Berk and DeMarzo, the core text supporting BAM021 Corporate Finance. 
 
C) Basic statistics concepts and Excel tools for basic statistical analyses are covered in Chapter 16 of Day’s Mastering Financial Mathematics in Microsoft Excel and in Chapter 9 of Benninga’s Principles of Corporate Finance with Microsoft Excel. 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M9368

Have any Question? 


Related Questions in Basic Finance

How do bonds provide financing to corporations for their

How do bonds provide financing to corporations for their capital projects? What are the key differences between using bonds to finance capital projects and using stock for that purpose? The value of a bond is dependent p ...

A small eastern european economy asks your opinion about

A small Eastern European economy asks your opinion about whether they should pursue the path to joining the European Economic and Monetary Union (EMU) or simply "euroize" (i.e., dollarize by using the euro for all domest ...

Edward c johnson iii was the ceo of fidelity mutual funds

Edward C. Johnson, III, was the CEO of Fidelity mutual funds and also the chair of the Fidelity board. In 2004, the SEC issued a regulation requiring chairs at mutual funds to be independent of management, forcing Johnso ...

Draw a short- run aggregate supply curvewhy is the curve

Draw a short- run aggregate supply curve. Why is the curve upward sloping? What causes the short- run aggregate supply curve to shift?

Focus on the monthly log returns of ibm and hpq stocks from

Focus on the monthly log returns of IBM and HPQ stocks from January 1962 to December 2003. Fit a DVEC(1,1) model to the bivariate return series. Is the model adequate? Plot the fitted volatility series and the time-varyi ...

Multiple effects on the yield curve assume that1 investors

Multiple Effects on the Yield Curve: Assume that (1) investors and borrowers expect that the economy will weaken and that inflation will decline, (2) investors require a small liquidity premium, and (3) markets are parti ...

Explain the difference between aggregate demand and the

Explain the difference between aggregate demand and the aggregate quantity demanded of real output. Ceteris paribus, how is quantity demanded related to the overall price level?

Finance discussionstep 1 evaluate screen stocksthe

Finance Discussion Step 1 Evaluate / Screen Stocks The objective of this discussion is to create a list of 5 stocks and 5 ETFs. There are numerous websites that have good stock screening tools such as Morningstar and Yah ...

At the end of 2011 home depots total capitalization

At the end of 2011 Home Depot's total capitalization amounted to $28,992 million. In 2012 debt investors received interest income of $635 million. Net income to shareholders was $4,526 million. (Assume a tax rate of 35%. ...

In country a suppose that changes in short-term interest

In Country A suppose that changes in short-term interest rates translate quickly into changes in long-term interest rates, while in Country B long-term interest rates do not respond much to changes in short-term rates. I ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate