Order ID:89JHGSJE83839 | Style:APA/MLA/Harvard/Chicago | Pages:5-10 |
Instructions:
Executive Dashboard Assignment Two
Overview-Hello writer-down below you can see what needs to be done. I need MEMO 6 PAGES ON EXECUTIVE DASHBOARD AND EXCEL SPREADSHEET. YOU HAVE ALREDY AN EXAMPBLE OF BOTH INCLUDED I NEED YOU TO GO OVER BOTH AND AND MAKE IT THE BEST YOU CAN! PLEASE WORK ON EXAMPLE SUBMITTED. I HAVE USED HP COMPANY. MY PRFOFESSOR DONT LIKE MEMO AND NEED MORE RESEARCHERS.In this Work Product Assessment, you will examine various financial reports of a publicly traded company and conduct financial ratio analysis to demonstrate your ability to understand a company’s financial health and analyze ways to improve in areas revealed as being below industry average. Professional Skills: Written Communication, Technology, and Critical Thinking and Problem Solving are assessed in this Competency. You are strongly encouraged to use the Academic Writing Expectations Checklist when completing this Assessment. Your response to this Assessment should: • Reflect the criteria provided in the Rubric. • Adhere to the required assignment length. • Conform to APA style guidelines. You may use Walden Writing Center’s APA Course Paper Template. This Assessment requires submission of two (2) files. Save your files as follows: • Save the Excel file as SF002_Excel_firstinitial_lastname (for example, SF002_Excel_ J_Smith). • Save the Word file as SF002_Word_firstinitial_lastname (for example, SF002_Word_ J_Smith). When you are ready to upload your completed Assessment, use the Assessment tab on the top navigation menu. Instructions Before submitting your Assessment, carefully review the rubric. This is the same rubric the assessor will use to evaluate your submission and it provides detailed criteria describing how to achieve or master the Competency. Many students find that understanding the requirements of the Assessment and the rubric criteria help them direct their focus and use their time most productively. Rubric Access the following to complete this Assessment: • Financial Ratio Excel Spreadsheet • Text: Fundamentals of Financial Management, Chapter 4, “Analysis of Financial Statements” Prompts for Executive Dashboard Assignment Two 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. It is imperative for you to understand the use of good academic writing (visit the Walden Writing Center), use of 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. • 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 through https://www.census.gov/eos/www/naics/. 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: https://my-ibisworld-com.ezp.waldenulibrary.org/. 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. • Write a memo (approximately 5–6 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: o Areas within the company that are both above and below industry standards o An explanation of the limitations of using ratio analysis o 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. |
Executive Dashboard Assignment Two
RUBRIC |
||||||
Excellent Quality 95-100%
|
Introduction
45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Literature Support 91-84 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met. |
|||
Average Score 50-85% |
40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided. |
83-76 points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration. |
52-49 points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met. |
|||
Poor Quality 0-45% |
37-1 points The background and/or significance are missing. No search history information is provided. |
75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration. |
48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met |
|||
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow
Executive Dashboard Assignment Two |
Executive Dashboard Assignment Two