Question Details
Urgent

- From Business, Accounting
- Due on 15 May, 2016 12:40:53
- Asked On 15 May, 2016 04:46:40
- Due date has already passed, but you can still post solutions.

Question posted by

**Natalia201686****Rating :**0**Grade :****No Rating****Questions :**1**Solutions :**0**Blog :**0**Earned :**$0.00

**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.

4. Calculate the 2013 operating margin, profit margin, basic earning power (BEP), return on assets (ROA), and return on equity (ROE).

5. Calculate the 2013 price/earnings ratio, and market/book ratio.

6. Use the extended DuPont equation to provide a summary and overview of XYZ’s financial condition as projected for 2013.

** **

7.** **Use the following simplified 2013 balance sheet to show, in general terms, how an improvement in the DSO would tend to affect the stock price. For example, if the company could improve its collection procedures and thereby lower its DSO from 45.6 days to the 32-day industry average without affecting sales, how would that change “ripple through” the financial statements (shown in thousands below) and influence the stock price?

Accounts receivable $878 Debt $1,545

Other current assets 1,802

Net fixed assets 817 Equity 1,952

Total assets $3,497 Liabilities plus equity $3,497

First, we need to calculate XYZ’s daily sales.

Daily sales = Sales / 365

Daily sales = $7,035,600 / 365

Daily sales = $19,275.62

Target A/R = Daily sales × Target DSO

Target A/R = $19,276 × 32

Target A/R = $616,820

Freed-up cash = old A/R – new A/R

Freed-up cash = $878,000 – $616,820

Freed-up cash = $261,180

Available solutions

$ 20.00

- This Solution has been Purchased 2 time
- Submitted On 15 May, 2016 06:05:22

Solution posted by

**Academia****Rating :**55**Grade :****A+****Questions :**0**Solutions :**4351**Blog :**1**Earned :**$24501.05

MBA 520 Module...

$ 15.00

- This solution has not purchased yet.
- Submitted On 15 May, 2016 06:51:17

Solution posted by

**Kimwood****Rating :**19**Grade :****A-****Questions :**3**Solutions :**1107**Blog :**1**Earned :**$4475.89

First, we need to calculate XYZ’s daily sales.
Daily sales = Sales / 365
Da...

$ 12.00

- This Solution has been Purchased 1 time
- Submitted On 15 May, 2016 07:15:31

Solution posted by

**NUMBER1TUTOR****Rating :**87**Grade :****A+****Questions :**0**Solutions :**5074**Blog :**3**Earned :**$14349.10

1. Calculate XYZ’s 2013 current and quick ratios based on the projected balance sheet and income statement data.
Current Ratio= (Current assets ÷ Current liabilities)
$2,680,112 ÷ $1,114,800
Current ratio = 2.4
Quick ratio = (Current assets – Inventories) ÷ (Current liabilities)
[($2,680,112) – ($1,716,480)] ÷ ($1,114,800)
Quick ratio = .86
The current ratio is a financial ratio used to examine the liquidity of a company and its ability to pay short-term liabilities with its short-term assets.
The quick ratio, is a liquidity indicator that filters the current ratio by measuring the amount of the most liquid current assets there are to cover current liabilities
...

$ 10.00

- This Solution has been Purchased 11 time
- Submitted On 15 May, 2016 07:55:17

Solution posted by

**Halsey****Rating :**15**Grade :****A+****Questions :**0**Solutions :**335**Blog :**0**Earned :**$5754.65

MBA 520 Module Two Finan...

$ 10.00

- This Solution has been Purchased 11 time
- Submitted On 16 May, 2016 12:12:27

Solution posted by

**DEEPEYES****Rating :**35**Grade :****A-****Questions :**0**Solutions :**517**Blog :**0**Earned :**$2018.64

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.
Current Ratio= (Current assets ÷ Current liabilities)
$2,680,112 ÷ $1,114,800
Current ratio = 2.4
Quick ratio = (Current assets – Inventories) ÷ (Current liabilities)
[($2,680,112) – ($1,716,480)] ÷ ($1,114,800)
Quick ratio = .86
The current ratio is a financial ratio used to examine the liquidity of a company and its ability to pay short-term liabilities with its short-term assets.
The quick ratio, is a liquidity indicator that filters the current ratio by measuring th...

$ 10.00

- This Solution has been Purchased 1 time
- Submitted On 15 Apr, 2017 09:03:55

Solution posted by

**Academia****Rating :**55**Grade :****A+****Questions :**0**Solutions :**4351**Blog :**1**Earned :**$24501.05

MBA 520 Module Two Financial Statement Anal...

Other Related Questions

fitz85

cstel...

cstel...

cstel...