WK2 A3 Final Project Assignment
This is a Strategic Finance class. This assignment is a two part requiring, an APA Paper and an EXCEL spreadsheet with calculations labeled separately. Please read instruction carefully. The EXCEL Spreadsheet doc is upload for this assignment requirements.
Assignment 3: Final Project
Before starting work on the final project, go through the financial details of MNQ Company provided in SU_MBA6010_Final_Project_Information.xls in the Doc Sharing area.
Note: You can print this file or save it in your local folder. You will need to refer to this excel sheet for the final project submissions every week.
For each of the five years of the provided financial statements, calculate and analyze MNQ Company’s thirteen financial ratios:
• Current ratio
• Quick ratio
• Cash ratio
• Total debt ratio
• Times interest earned ratio
• Cash coverage ratio
• Inventory turnover ratio
• Receivables turnover ratio
• Profit margin
• Return on assets
• Return on equity
• Price-earnings ratio
• Market-to-book ratio
Additionally, critique these numbers. Do any patterns emerge with these ratios? Please explain.
Submit your answer in a 5- to 7-page Microsoft Word document and your calculations in a Microsoft Excel sheet.
Name your files:
Submit your files to the W2: Assignment 3 Dropbox by Week 2, Saturday, Day 7.
Cite any sources using the APA format on a separate page.
Assignment 1 Grading Criteria Maximum Points
Correctly calculated the financial figures for MNQ Company. 70
Presented a structured document free of spelling and grammatical errors. 5
Properly cited sources using the APA format. 5