Finance Homework
Assignment 4: 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:
· SU_MBA6010_W1_A4_LastName_FirstInitial.doc
· SU_MBA6010_W1_A4_LastName_FirstInitial.xls
Submit your files to the W1: Assignment 4 Dropbox by Wednesday, March 11, 2015.
Cite any sources using the APA format on a separate page.
|
Assignment 4 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 |
|
Total: |
|