Reference no: EM133001124
Fundamentals of Investments
Problem Set
The exercise below uses data found in an Excel workbook called "Week 1 Exercises.xls". Use the workbook to record your answers to the following questions. When you have completed the assignment, place it (workbook) in the appropriate Assignment folder on the course website.
1. You are given historical, monthly stock prices for 10 companies in the sheet labeled "Question 1 Data". Use this data to make the following calculations in the sheet labeled "Question 1 Calculations"
(a) Calculate the monthly returns for each company. You need only do this for one cell, and you can copy this calculation to all other cells.
(b) Using the monthly returns, calculate the mean return and standard deviation of returns for each company.
(c) Based on your preferences for risk, construct a portfolio based on these 10 stocks. You can take long (positive weights) or short positions (negative weights), but the sum of the weights must sum to 1. (Note that the summary statistics for these choices are graphed in the sheet labeled "Question 1 Graph".)
(d) Briefly explain your philosophy for the choices that made in part (d). (Low to Moderate Risk Tolerance)
|
What is the monthly total cost equation
: If the high-low method is used, what is the monthly total cost equation? C-Drive Components has collected the production data for the past four months.
|
|
What is the current share price
: Synovec Co. is growing quickly. Dividends are expected to grow at a rate of 19 percent for the next 3 years, with the growth rate falling off to a constant 3 pe
|
|
What happens to the fx exposure
: Namo corporation is an Indian MNC. The company is expected to pay 9 Million Yuan and has to receive an equivalent amount of Ringgits (MYR) from its Malayasian s
|
|
What is the total cost of producing birdcages
: The company's average cost per unit is $18.00 at a production level of 2,200 birdcages. What is the total cost of producing 2,200 birdcages?
|
|
Fundamentals of investments
: The exercise below uses data found in an Excel workbook called "Week 1 Exercises.xls". Use the workbook to record your answers to the following questions. When
|
|
What the company will experience
: Variable costs of $752,000, and fixed costs of $510,000. If a $5 drop in selling price will boost unit sales volume by 20%, the company will experience
|
|
What is the conversion price
: Standard Olive Company of California has a $1,000 par value convertible bond outstanding with a coupon rate of 8 percent and a maturity date of 20 years. It is
|
|
What is the percentage price change of bonds
: Interest rate risk. Bond J has a coupon rate of 4%. Bond S has a coupon rate of 14%. Both bonds have 17 years to maturity, $1000 face value, make half yearly pa
|
|
Calculate the expected net cash flows for year three
: Calculate the expected net cash flows for year 3? Generate first-year revenues of $2.25 million. These revenues are expected to grow at 10 percent
|