Question

• Select 3 companies from different industrial sectors, e.g. high tech (computers, health), consumer non-durables (food, personal services, retailers), cyclical (mining/metals, forestry, oil & gas), etc. Note that one of the companies will be the subject of your term paper assignment described below. Ensure that you can obtain the minimum of 5 years of monthly pricing data required below.
• Obtain at least 5 years of monthly data on prices (60 months).
• Obtain at least 5 years of monthly data on a broad based market indicator (S&P 500, Russell 3000, Wilshire 5000, etc.; do not use the Dow Jones Industrials Average).
• Calculate the average monthly returns (=average function in Excel) , standard deviation of returns (=stdev function) , and correlations of returns (= correl function) , so you’ll have 4 sets for average returns, standard deviation of returns and 6 correlations -- A&B , A&C, and B&C for the companies and A& Market, B& Market, and C and Market.
• Plot prices of stocks & market indicator all vis-à-vis a beginning value of 100 (time series) [ ( P2/P1) x 100 ]

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Companies From Different Industrial Sectors

This is only a preview of the solution. Please use the purchase button to see the entire solution

$33.00

or $1 if you
register a new account!

Related Homework Solutions

Apple Stock Historical Prices
Homework Solution
$83.00
Accounting
Business
Apple
Stock
Prices
Finance
Economy
Linear Regression Chart
Risk Factor
Financial Statements
Adjusted Closed Price
Balance
Cash Flow
Income
Business Problems
Homework Solution
$100.00
Business
Accounting
Finance
Fibonacci
Practical Problems
Roman Numerals
Annual Compensation
Bond
Face Value
Maturity
Competitive Market
Shares
Prices
Buying
Standard Deviation
Business Questions
Homework Solution
$23.00
Business
Accounting
Finance
Economics
Assets
Liabilities
Debt
Equity
Capital
Cash Flows
Creditors
Financial Statements
Shareholders
Balance Sheet
Business Questions
Homework Solution
$83.00
Accounting
Business
Financial Management
Economy
Government Securities
Prices
Profit
Liabilities
Bonds
Cash Flow
Discount Factors
Face Value
Interest Rate
Coupon Reinvestment Rate
Kulpa Fishing Supplies: A Company That Is Seeking To increase Its Value
Homework Solution
$80.00
Accounting
Business
Financial Management
Sales
Costs
Assets
Values
Consultancy
Economy
Administration
Marketable Securities
Shares
Stock Market
Industry
Cash Flow
Investors
EROIC
WACC
MVA
Managerial Behavior
Finance Questions
Homework Solution
$25.00
Business
Accounting
Administration
Economy
Calculating Payback
IRR
NPV
Profitability Index
Cash Flow
Investments
Discount Rates
Get help from a qualified tutor
Live Chats