Analyzing Firms Revenue and Profitability Trends: A Performance Assessment

Abstract

MGMT 475.WB1 Fa 22 Module 2 Exercise A: Performance Assessment 10 points Submit in Sakai Assignments folder no later than 10pm Friday, 9/16. This exercise uses the data from the Income Statement below. INSTRUCTIONS: Create an EXCEL spreadsheet** for this analysis. Design it simply – include only the data you need for the analysis requested. Create calculated fields to show the following: Calculate the percentage change in revenue (net sales) for each year (2017 through 2020). Calculate operating profit margin for each year (2016 through 2020). Using a WORD document, develop your submission memo to show your spreadsheet and address these tasks: Put your name at the top of the sheet. Type “Task 1” then you answer; “Task 2” etc. Describe the trend in the firm’s revenue over the years 2017-2020. How does the firm’s ability to create value for its market (i.e. to generate revenues) compare with the overall industry average? Describe the trend in the firm’s profitability over the years. How does the firm’s ability to capture value (i.e. retain profits) compare to the industry average? Overall conclusion: Describe your overall conclusion about the quality of the firm’s strategic choices and execution AND what you would expect their performance to be over the next few years if they do not make any changes. At the bottom: ** Copy and paste your EXCEL spreadsheet into the document.