+61-413 786 465

[email protected]

## Finance

 Basic Finance Corporate Finance Financial Management Financial Econometrics Portfolio Management Risk Management Public Finance Business Law & Ethics

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.

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

### Question utilizing the concepts learned throughout the

Question: Utilizing the concepts learned throughout the course, write a Final Paper on one of the following scenarios: • Option One: You are a consultant with 10 years experience in the health care insurance industry. A ...

Discussion: Your initial discussion thread is due on Day 3 (Thursday) and you have until Day 7 (Monday) to respond to your classmates. Your grade will reflect both the quality of your initial post and the depth of your r ...

### Question financial ratios analysis and comparison

Question: Financial Ratios Analysis and Comparison Paper Prior to completing this assignment, review Chapter 10 and 12 in your course text. You are a mid-level manager in a health care organization and you have been aske ...

### Grant technologies needs 300000 to pay its supplier grants

Grant Technologies needs \$300,000 to pay its supplier. Grant's bank is offering a 210-day simple interest loan with a quoted interest rate of 11 percent and a 20 percent compensating balance requirement. Assuming there a ...

### Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of \$375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

### Market-value ratios garret industries has a priceearnings

(?Market-value ratios?) Garret Industries has a? price/earnings ratio of 19.46X a. If? Garret's earnings per share is ?\$1.65?, what is the price per share of? Garret's stock? b. Using the price per share you found in par ...

### You are planning to make annual deposits of 4440 into a

You are planning to make annual deposits of \$4,440 into a retirement account that pays 9 percent interest compounded monthly. How large will your account balance be in 32 years?  (Do not round intermediate calculations a ...

### One year ago you bought a put option on 125000 euros with

One year ago, you bought a put option on 125,000 euros with an expiration date of one year. You paid a premium on the put option of \$.05 per unit. The exercise price was \$1.36. Assume that one year ago, the spot rate of ...

### Common stock versus warrant investment tom baldwin can

Common stock versus warrant investment Tom Baldwin can invest \$6,300 in the common stock or the warrants of Lexington Life Insurance. The common stock is currently selling for \$30 per share. Its warrants, which provide f ...

### Call optionnbspcarol krebs is considering buying 100 shares

Call option  Carol Krebs is considering buying 100 shares of Sooner Products, Inc., at \$62 per share. Because she has read that the firm will probably soon receive certain large orders from abroad, she expects the price ...

• 13,132 Experts

## 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.

### 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