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

In july 2010 an article on bloombergcom noted the cost of

In July 2010, an article on Bloomberg.com noted: "The cost of protecting European corporate bonds from default fell, according to traders of credit-default swaps." Given this statement, what happened to the price of cred ...

A newly issued 10 year bond is valued at par on june 1 2017

A newly issued 10 year bond is valued at par on June 1, 2017. The bond has an annual coupon of 8.0 percent. On June 1 2020, the bond has a yield to maturity of 7.1 percent. The first coupon is invested at 8.0 percent and ...

Consider a lottery that pays to the winner an annuity of

Consider a lottery that pays to the winner an annuity of $800 that begins at the end of the first year and continues at the end of each consecutive year for a total of 18 years with one exception. Because of high adminis ...

Analysis of denver furniture corpdenver furniture corp is

Analysis of Denver Furniture Corp. Denver Furniture Corp. is nationally recognized for making high-quality products. Management is concerned that the company is not fully exploiting its brand power. Denver's production m ...

A researcher conducts a 2 times 3 times 2 factorial study

A researcher conducts a 2 × 3 × 2 factorial study with 20 participants in each treatment condition. a. If the researcher uses an exclusively between-subjects design, how many individuals participate in the entire study? ...

1 describe a special purpose building2 compare and contrast

1. Describe a special purpose building. 2. Compare and contrast two widely different types of commercial real estate loans that you had not previously had any experience discussed in this chapter? 3. Discuss each of the ...

How are the payment terms of an fra different from those of

How are the payment terms of an FRA different from those of most other interest rate derivatives? Explain how FRAs are like swaps and how they are different? Compare the use of interest rate options with forward rate agr ...

1 small savers can usually receive a higher interest rate

1. Small savers can usually receive a higher interest rate from money market mutual funds than from bank savings accounts. So, how are banks able to attract small savers? 2. Financial journalist David Wessel has describe ...

The yield on zero-coupon bonds are as followsus yen 1

The yield on zero-coupon bonds are as follows: U.S.$ % Yen % 1 year    3.00       5.00 2 years   3.50       6.00 A young investment banker considers issuing a bond for ¥100 million. The interest or coupon is paid on year ...

What is the excess burden of taxation why is there an

What is the excess burden of taxation? why is there an excess burden, and what factors affect the size of the excess burden for a specific tax? if several goods are to be tax, how should the taxes be distributed to minim ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro