Ask Corporate Finance Expert

Project

You will select two companies to analyze and complete an 8-page report. Please read the document to determine the requirements for this report.

The Companies are Amgen and Allergan

 

2011

2012

2013

2014

2015

LIQUIDITY RATIOS

Current Ratio

 

 

 

 

 

Quick Ratio

 

 

 

 

 

LEVERAGE RATIOS

Liabilities-to-Assets Ratio

 

 

 

 

 

Debt Ratio

 

 

 

 

 

COVERAGE RATIOS

Times Interest Earned Ratio

 

 

 

 

 

EBITA Coverage Ratio

 

 

 

 

 

ASSET UTILIZATION RATIOS

Average Collection Period (days)

 

 

 

 

 

Inventory Turnover Ratio

 

 

 

 

 

Fixed Asset Turnover Ratio

 

 

 

 

 

Total Asset Turnover Ratio

 

 

 

 

 

OPERATION RATIOS

Gross Profit Margin

 

 

 

 

 

Operating Profit Margin

 

 

 

 

 

Net Profit Margin

 

 

 

 

 

MANAGEMENT PERFORMANCE

Return on Equity

 

 

 

 

 

Return on Assets

 

 

 

 

 

OTHER RATIOS

Shares Outstanding

 

 

 

 

 

Market Capitalization

 

 

 

 

 

Dividends/Share

 

 

 

 

 

Earnings/Share

 

 

 

 

 

Now that you have analyzed the financial data of these stocks, further assess the risk of the companies in question.

In addition to the ratio analysis, gather the following information using Morningstar, Mergent Online, or another online database like Yahoo Finance or Google Finance:

- Historical returns (either negative or positive) for the past five years
- The difference between historical returns for each of the past five years (i.e. Tesla vs. Honda)
- Growth of a $10,000 investment for each company given the past five years
- The standard deviations of each company
- Using historical return information, find the expected average rate of return for each company
- Illustrate the potential rate of return outcomes using a bell-shaped curve (i.e. there is a 95% chance that the rate of return for the next year will be between -x% and +x%)
- Given a 50/50 investment in each company stock, please provide me with the historical performance of that particular portfolio
- Using Excel, please provide correlation coefficient of the 2-stock portfolio
- Identify the betas of each stock
- Please provide what you think the required rate of return for each stock is. You will want to use the CAPM method to determine this.
- Lastly, aside from the quantitative methods of determining risk, please provide qualitative data-items which could occur which would increase or decrease the amount of risk of that stock over time (i.e. regulatory issues, products no longer being relevant, etc.)

REQUIRED: Written report

Please provide an 8 Page report which includes an analysis of their financial statements, ratios, and the risks associated with each company - including thoughts on the trends that you have identified as important. Be sure that the commentary addresses the following:

• What specifically the trends are telling us
• What is likely causing the change in ratios
• Why we should be concerned and/or focused on these trends

Identify pricing multiples for these companies. This would include price-to-sales, price-to-earnings, and price-to-book ratios for the past few years. These pricing multiples can provide us with insight on how investors feel about a specific investment. Do investors have confidence in the company's management or not? Has that confidence changed over time? Why do you think that it has changed?

There will not be a presentation due for this project. Analysis should cover all of the topics above as well as provide insight as to why you believe that certain qualitative factors will affect the risk and therefore the rate of return for certain stocks.

Included in the analysis should be the sources for which you based your opinion. These sources could be qualitative (news articles, analyst's reports, etc.) or quantitative (audited financial statements, ratios, etc.).

Corporate Finance, Finance

  • Category:- Corporate Finance
  • Reference No.:- M92021455
  • Price:- $85

Priced at Now at $85, Verified Solution

Have any Question?


Related Questions in Corporate Finance

Business finance case study assignment -instructions - you

BUSINESS FINANCE CASE STUDY ASSIGNMENT - Instructions - You must do Questions 1-5a, 8 and 10 on a spreadsheet. Eternal Youth Ltd (EY) is a New Zealand company which produces and sells cosmetics. Its financial year is 1 J ...

Q1 delta hedgingon sept 30th 2011 exxon mobil xom stock was

Q1 (Delta Hedging) On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is ...

Q1 delta hedgingon sept 30th 2011 exxon mobil xom stock was

Q1 (Delta Hedging) On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is ...

Assignment -part a - saturn petcare australia and new

Assignment - Part A - Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their firs ...

Mini case assignment -problems - use internet to identify a

Mini Case Assignment - Problems - Use internet to identify a house or condo that you may be interested in investing as a rental property for 10+ years. (Suggested price range between $250k - $1 million) 1. Estimate the a ...

Descriptionstudents are required to study undertake

Description: Students are required to study, undertake research, analyse and conduct academic work within the areas of corporate finance. The assignment should examine the main issues, including underlying theories, impl ...

Corporate finance assignment - required this assessment

Corporate Finance Assignment - Required: This assessment task is a written report and analysis of the financial performance of a selected company in order to provide financial advice to a wealthy investor. It will be bas ...

Interest swap valueabc bank has agreed to receive 3-month

Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for 2-month, 5-month, 8-mont ...

Graph an event study relationshipthe event in consideration

Graph an event study relationship. The event in consideration here is: "Environmental performance, being green, clean-tech, corporate sustainability, and many other "green" issues are on the forefront of the current econ ...

Question - assume that the average firm in your companys

Question - Assume that the average firm in your company's industry is expected to grow at aconstant rate of 6 percent and its dividend yield is 7 percent. Your company is about as risky as the average firm in the industr ...

  • 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