I am currently in a graduate “corporate finance” class and was needing some help on a graduate word document profile based on a chosen company’s profile financials and comparing them to their industry averages, to which below I have attached from research PDF documents and did calculations that I exported onto Excel spreadsheet. Also, more importantly no plagiarism! Here are the following assignment details below:
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.
Resources: Plunket Research Online located in the Week 3 Electronic Reserve Readings; MicrosoftÂ® ExcelÂ® (Research documents attached below)
Access the Plunkett Research database in the University Library by following these steps: (Research done and documents attached below)
Review the Company Profile (Amazon that is attached below) and answer the following questions in MicrosoftÂ® Word:
Save the Company Profile as a PDF document.
Compare the 2015 Company Financials to the Industry Averages and export the results into a MicrosoftÂ® ExcelÂ® document. (Documents attached below).
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. (Documents and Excel Calculations attached below).
Explain in 1,050 words or more 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.
(To incorporate in the Word Document of the chosen company profile from questions above): Chosen company selected (from questions answered above) compared to industry average of financial profitability, liquidity, and solvency and why the difference is important)
Side Note: No Plagiarism and for References, please include direct web link sources of where information is pulled from. Also for total word count of 1,050 word or more, excludes cover and reference page wording.
Submit the calculations as well as the explanation.
Click the Assignment Files tab to submit your assignment.