Taking the role of a financial analyst within the company, prepare an executive dashboard (performance report) on a large, publicly-traded company of your choice (e.g., Cisco, Walmart, IBM, Apple, etc.) by computing and comparing its ratios against the 11 industry average ratios listed in Problem 4-23 on page 129 of the text (See attachments).
It is imperative for you to understand the use of good academic writing (visit the Walden Writing Center), use of the online library for academic resources (not internet sources), SEC.gov for financial filings (not annual reports from a company website), and most importantly, your job is to do vetting of anything companies claim on their websites. The use of Wikipedia, Investopedia, financial related websites, blogs, etc. is not appropriate for this competency.
1. Use the provided Financial Ratio Excel Spreadsheet to show the computed financial ratios for your chosen company and industry averages. Prepare your performance report to show calculations for the 11 ratios listed on page 129, as well as a comparison of your computed ratios with industry averages. It is a good idea to be familiar with each industry’s classification! A good place to start is to look for the North American Industry Classification System (NAICS) and look for the industry of your chosen company. Please notice how it is a US Government website, not a “.com”. Then, visit the Walden University Library and access the IBIS World database in order to look for the appropriate industry standards: The comparisons, including a list of your computations in a table, should be added as an appendix to the memo described below and submitted as a separate Excel spreadsheet.
2. Write a memo (approximately 2–3 pages) to your supervisor explaining your findings and your recommendations for where improvements are needed to increase financial health. Be sure to include the following:
-Areas within the company that are both above and below industry standards.
-An explanation of the limitations of using ratio analysis.
-The qualitative factors that play a role in improving the company’s financial health.
In the memo, suggest some specific ways in which the company can plan to improve below industry average ratio performance over time. Suggest annual targets over the next three years to catch up with or surpass industry averages. Explain why your recommendations should be effective.
Plagiarism Free Papers
All our papers are original and written from scratch. We will email you a plagiarism report alongside your completed paper once done.
All papers are submitted ahead of time. We do this to allow you time to point out any area you would need revision on, and help you for free.
A title page preceeds all your paper content. Here, you put all your personal information and this we give out for free.
Without a reference/bibliography page, any academic paper is incomplete and doesnt qualify for grading. We also offer this for free.
Originality & Security
At thehomeworkwritings.com, we take confidentiality seriously and all your personal information is stored safely and do not share it with third parties for any reasons whatsoever. Our work is original and we send plagiarism reports alongside every paper.
24/7 Customer Support
Our agents are online 24/7. Feel free to contact us through email or talk to our live agents.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
We work around the clock to see best customer experience.
Our prices are pocket friendly and you can do partial payments. When that is not enough, we have a free enquiry service.
Admission help & Client-Writer Contact
When you need to elaborate something further to your writer, we provide that button.
We take deadlines seriously and our papers are submitted ahead of time. We are happy to assist you in case of any adjustments needed.
Your feedback, good or bad is of great concern to us and we take it very seriously. We are, therefore, constantly adjusting our policies to ensure best customer/writer experience.