Reference no: EM131403198
Assignment
Purpose of Assignment
The purpose of this assignment is to allow the students an opportunity to complete their financial evaluation of a company using the financial research database Plunkett Research Online. Plunkett Research Online provides in-depth analysis of a company's financials, comparisons to industry averages, a list of top executives, how the company compares to other competitors in terms of revenue, number of employees, market capitalization and other key financial metrics.
Assignment Steps
Resources: Plunket Research Online located in the Week 3 Electronic Reserve Readings; ( https://phoenix.libguides.com/FIN571r9/w3 )
Access the the Plunkett Research database in the University Library by following these steps:
1. Click on the University Library link.
2. Click "Company Directories and Financials" under Library Resources.
3. Click "Plunkett Research Online" under Company Directory and Financials.
4. Review the following "HOW TO USE" videos:
o Plunkett Research Online Overview
o How to Export Company and Exec. Lists
o How to Build-a-Report
o How to Use Industry Analytics
o How to Research an Industry
o How to Use Company Profiles
Click "Research A Company." Select a company (i.e. Walmart) and input into the Search Box.Scroll through the search results to choose the correct company. Click the link to the company profile (in blue).
Review the Company Profile and answer the following questions in Microsoft Word: SELECTED COMPANY IS "HONDA"
• What is the Ticker Symbol for the company you have selected?
• When was the company established?
• How many employees does it have?
• What is the NAICS Code? ( MY PART )
• Who is the CEO? (MY PART)
• Compare industry average in terms of solvency (MY PART)
• Where does the company rank in terms of Total Revenue when compared to its competitors?
• Where does the company rank in terms of Net Income when compared to its competitors?
• Where does the company rank in terms of Return on Assets when compared to its competitors?
• What is the Revenue in 2014 and 2015?
• What was the Gross Margin in 2014 and 2015?
• What was the Earnings per Share in 2014 and 2015?
Compare the 2015 Company Financials to the Industry Averages and export the results into a Microsoft Excel document.
Add a new column in your Microsoft Excel document titled "Change" and calculate the difference between the company's 2015 financial results and the industry averages.
Explain in 1,050 words how the company you selected compares to the industry averages in terms of financial profitability, liquidity and solvency, and why the difference is important. Also review the financial statements over the last three years, and discuss any positive and negative trends would you report to the company's management.
Submit the calculations as well as the explanation.
Note: Grades are awarded based upon individual contributions to the Learning Team assignment. Each Learning Team member receives a grade based upon his/her contributions to the team assignment. Not all students may receive the same grade for the team assignment.
What is the mirr of a project
: What is the MIRR of a project if the initial costs are $2,078,000 and the project life is estimated as 5 years? The project will produce the same after-tax cash inflows of 494,400 per year at the end of the year.
|
Connection of two capacitors of capacitances
: A potential difference of 300 V is applied to a series connection of two capacitors of capacitances C1=2.00 microfarad and C2=8.00 microfarad. Suppose that the charged capacitors are then disconnected from each other and from the battery.
|
What is the appropriate cost for retained earnings
: The firm's beta is 1.45. The rate on six-month T-bills is 3.31%, and the return on the S&P 500 index is 7.81%. What is the appropriate cost for retained earnings in determining the firm's cost of capital?
|
Give a practical interpretation of r
: The researchers concluded that there is ‘‘significant negative correlation'' between the number of online courses and weekly quiz grade. Do you agree?
|
Compare industry average in terms of solvency
: FIN/571- Compare industry average in terms of solvency. Where does company rank in terms of Total Revenue when compared to its competitors? Where does the company rank in terms of Net Income when compared to its competitors?
|
How would prices of coffee and tea react in a free market
: What is the opportunity cost to society of a 100-mile truck trip? Why may the price of the gasoline used by the truck not adequately represent that opportunity cost?
|
Conduct a complete simple linear regression analysis
: Of interest to the researchers is the relationship between congestion time (y) and number of vehicles (x). Conduct a complete simple linear regression analysis.
|
Which is a public good and which is a private good and why
: Give some examples of goods whose production causes detrimental externalities and some examples of goods whose production creates beneficial externalities.
|
Is there evidence of a linear trend
: Consider only the winning times for men. Is there evidence of a linear trend? If so, propose a straight-line model for predicting winning time (y) based on year (x). Would you expect the slope of this line to be positive or negative?
|