Reference no: EM131275919
Assignment
Tasks
1. See attached financial statement and ratio workbooks for the following companies
a. Abbott Laboratories
b. Bristol-Myers Squibb
c. Glaxosmithklien
d. Eli Lilly & Co.
e. Merck & Co.
f. Novartis
g. Pfizer
2. Use Eli Lilly & Co. pharmaceutical company, to complete the following:
A. The product and service of Eli Lilly
B. The target market of Eli Lilly
C. The competition and market structure of Eli Lilly
D. Use the major income statement figures and put the figures in the pie chart.
E. Use the major balance sheet figures to represent them in pie chart
F. Outline and explain the trend
G. What is market distribution channels of Eli Lilly?
3. Complete the following elements of an industry analysis:
a. Table and chart showing an index of sales for all seven companies using FYE Dec 05 as the base year
b. Table and chart showing an index of net income for all seven companies using FYE Dec 05 as the base year.
c. Table and chart showing an index of total assets for all seven companies using FYE Dec 05 as the base year.
d. Table and chart showing an index of net PPE for all seven companies using FYE Dec 05 as the base year.
e. Table and chart showing an index of inventory for all seven companies using FYE Dec 05 as the base year.
f. Table and chart showing the gross profit margins for all seven companies
g. Table and chart showing the inventory turnover for all seven companies
h. Table and chart showing the net PPE turnover for all seven companies
4. Put the tables and charts from step 2 and 3 into a PowerPoint slide presentation.
5. Use Eli Lilly & Co. company, complete the following:
a. Download and review the 10-K document for your company to develop an understanding of its business model
b. Conduct an IODE financial analysis of the company, including but not limited to:
i. Balance sheet analysis of structure and trends
ii. Income statement analysis of structure and trends
iii. Analysis of the DuPont ratio structure and trends
iv. Analysis of key profitability ratio structure and trends
v. Analysis of key efficiency ratios and trends
vi. Analysis of key leverage ratios and trends
c. Prepare a set of exhibit tables and/or charts that support the findings and implication of each step of your analysis. Put these exhibits into a PowerPoint slide presentation.
d. Develop some conclusions regarding the sustainability of the business model for Eli Lilly Pharmaceutical company in the context of what you know about the industry (e.g., from your industry analysis in Step 2 and 3, and comparison to other companies in the sample). Include these conclusions in your presentation slides.
Attachment:- financials_Data.zip
|
What will be the highest level of tensile stress
: A titanium 6246 alloy plate of a bimodal microstructure was found to have an edge crack of size 4 mm. What will be the highest level of tensile stress (σ) that can be supported on this plate without causing catastrophic failure?
|
|
Identify the type of sample method
: Identify the type of sample method;- identify the sample frame; - indicate what, if any, sample frame error there is;
|
|
Define vision and purpose statement to provide big picture
: Define a vision and/or purpose statement to provide the big picture of what you wish to accomplish. Once this is identified, develop SMART goals that support your purpose. Make sure they are specific, time sensitive, and can be measured.
|
|
How could a two step cluster sample be used here
: How could a two-step cluster sample be used here? Identify this sample method and describe how it could be used to select a representative sample of Peaceful Valley households?
|
|
Conduct an iode financial analysis of the company
: Conduct an IODE financial analysis of the company, including but not limited to Balance sheet analysis of structure and trends, Income statement analysis of structure and trends and Analysis of the DuPont ratio structure and trends.
|
|
What would be a reasonable sample frame for telephone survey
: If a probability sampling method is to be used, what would be a reasonable sample frame for A telephone survey, A mail survey and An online survey.
|
|
Discuss the elements of strategic management
: Discuss the elements of strategic management and explain why it is crucial to an organization’s survival. Using a company as an example, explain the difference between a strategy and a business model.
|
|
Describe methods of sample size determination
: Describe methods of sample size determination and indicate a critical flaw in the use of Using a "rule of thumb" percentage of the population size.
|
|
Explain the term thermosetting polymer
: Explain the term ‘‘thermosetting polymer''. Why can't a thermosetting polymer be produced using just adipic acid and ethylene glycol?
|