Finance Homework

profilevzedes
finance_homework.docx

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: