Financial ratio analysis worksheet

This assignment requires you to finish some accounting questions and calculations inside " mba520_module_2_financial_statement_analysis.docx" by using the data that inside " mba520_module_2_financial_statements_analysis_data.pdf"

The description of the question and the grading rubric are also included in : " mba520_module_2_financial_statement_analysis.docx"

In your answers,please remember to give following details: Number, formula that you used to calculate, results, and what the results tells us? MBA 520 Module Two Financial Statement Analysis Worksheet The main goal of financial statement analysis is to use past and current performance to identify changes and trends that will affect a company. Financial ratios are a widely used form of financial analysis in which the relationship between two or more line items is analyzed to evaluate a company’s performance. The calculations you practice in this assignment will be applicable in completing Milestone One, specifically determining recent financial performance and current financial health. Prompt Reference the information found in the Module Two Financial Statements Analysis Data PDF located in the Assignment Guidelines and Rubrics folder to complete the following. Once you have calculated the ratios asked for using the data in the PDF, provide a brief summary of how the ratios are used and why they are important. Once you have completed the calculations, provide a brief, two- to four-sentence rationale for how these calculations can be used in analyzing the financial position of a company and why they are important. Your rationale should explain what information the ratio provides to the reader and how the reader may use that information. Use the Shapiro Library, your text, and the non-graded discussion forum in this module to ask questions of your peers to inform your responses to the questions below. Before beginning this assignment, you will need to download and/or print the Module Two Financial Statements Analysis Data PDF in order to complete the assignment. 1. Calculate XYZ’s 2013 current and quick ratios based on the projected balance sheet and income statement data. 2. Calculate the 2013 inventory turnover, days sales outstanding (DSO), fixed assets turnover, and total assets turnover. 3. Calculate the 2013 debt-to-assets and times-interest-earned ratios.