Ask Question, Ask an Expert

+61-413 786 465

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

You are considering investing in one of these three

You are considering investing in one of these three stocks: Stock Standard Deviation Beta A. 8% 0.59 B 10% 0.61 C 12% 1.29 If you are a strict risk minimizer, you would choose Stock ____ if it is to be held in isolation ...

Buner corps outstanding bond has the following

Buner Corp.'s outstanding bond has the following characteristics: Years to maturity: 6.0  Coupon rate of interest: 8.0% Face value: $1,000 If investors require a rate of return equal to 12% on similar risk bonds and  int ...

Net present valuenbspriggs corp management is planning to

Net present value:  Riggs Corp. management is planning to spend $650,000 on a new marketing campaign. They believe that this action will result in additional cash flows of $325,000 over the next three years. If the disco ...

Cardinal industries had the following operating results for

Cardinal Industries had the following operating results for 2018: Sales = $33,813; Cost of goods sold = $23,967; Depreciation expense = $5,947; Interest expense = $2,685; Dividends paid = $1,951. At the beginning of the ...

Based on land minerals and natural resources labor and

Based on land, minerals and natural resources, labor and entrepreneurial innovation, which country do you feel has the greatest long-term potential China or Russia.

Timco is considering project a project a will cost 23000 it

Timco is considering project A. Project A will cost 23000. It should provide after tax cash inflows of 5000 per year for the next 6 years. The cost of funds is 10%. Find the MIRR. Should Timco buy it?

A company stock is paying 5 in dividends with a 3 growth

A company stock is paying $ 5 in dividends, with a 3 % growth rate. The U.S. Treasury bond yield is 1 % (the risk free rate). The stock sells for $56. What is the implied risk premium?  Round your answer to two decimal p ...

Moving cash flowyou are scheduled tonbspreceivenbspa 420

Moving Cash Flow You are scheduled to  receive  a $420 cash flow in one year, a $720 cash flow in two years, and  pay  a $320 payment in three years. If interest rates are 12 percent per year, what is the combined presen ...

Question - wald incs stock has a required rate of return of

Question - Wald Inc's stock has a required rate of return of 10 and it sells for 40 per share Wald's dividend is expected to grow at a constant rate of 7 per year. What is the expected year-end dividend D1?

Are us executives paid too much particularly compared to

Are U.S. Executives paid too much particularly compared to the average worker in their organization?

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As