Perform a ratio analysis of microdrive

Assignment Help Financial Management

Reference no: EM131843110

For this assignment you will perform a ratio analysis of MicroDrive, Inc. The attached spreadsheet contains the financial statements which have also been converted into common size and percentage change formats.

You will build a one sheet model to compute the ratios presented in the chapter for the years presented. The ratios should be grouped according to the five categories presented in the textbook.

You will use the data to conduct a financial ratio analysis which includes comparing the ratios over the two years and comparing to the industry average.

Your analysis should include a discussion of the ratios by category. A final overall summary should discuss the future impact on the business if the trends continue.

The model sheet columns and rows should be clearly labeled showing the equation for each formula. You should have a column for each year, the industry and a performance rating for each ratio, such a strong, weak, poor, etc). This will assist with the analysis of the ratios.

Each factor of the equation should be presented separately. For example Current Ratio = Current Assets / Current Liabilities.

When presenting you will create a cell which shows the CA, one that present the current liabilities, and one for the result. All original numbers used should reference a cell from the financial statements tab. Points will be deducted if all requirements are not met.

Attachment:- chapter-3-microdrive.rar

Reference no: EM131843110

Questions Cloud

What are mad-mape and tracking defined as : Why is it necessary to use any or all of the three when forecasting. Which one would be the most important for an operation like McDonald's? Why?

Complete modern world literature project : The time has come to submit your final and complete Modern World Literature project. As a reminder, the requirements for this paper are listed.

What is task interdependence : What is task interdependence? What are the three types of technology as identified by Thompson?

Define upcoming deployment of maintenance tracking system : Everyone on the team was a good worker. Some of them had a more critical role to play in the upcoming deployment of the maintenance tracking system.

Perform a ratio analysis of microdrive : The data to conduct a financial ratio analysis which includes comparing the ratios over the two years and comparing to the industry average.

Imply obligation to the community : Does membership in the profession also imply obligation to the community? Why or why not?

What is design for reliability : What is Design for Reliability? Why is reliability important? Describe series and parallel systems?

What is the purpose of accounting : 1. What is the purpose of accounting? How might a management information system help you as an Accountant?

Future taxpayers should not have to pay the pension : He has argued that the town will not receive the clerk’s services in the future, so future taxpayers should not have to pay the pension.

User Account

All Pages