Calculate xyzs 2013 current and quick ratios

Assignment Help Financial Management

Reference no: EM131327518

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

8. 5 points) Provide a brief summary or rationale of how these ratios are used, and why they are important.

Reference no: EM131327518

Questions Cloud

Definition of pathology and mental illness : How might culture contribute to the definition of pathology and mental illness

Discuss the meaning or implication of the results of study : Use an Online Library to locate and review a scholarly article found in a peer-reviewed journal related to HR selection methods, analyzing work, designing jobs, or HR planning. In peer-reviewed journals, the articles were reviewed by other profess..

Write paper on improving retention in the workplace : Write 1400 word paper on improving retention in the workplace. APA format and include at least three reliable references

How does your selected companys dividend payout : How does your selected company's dividend payout, dividend yield, and dividend per share compare to other companies in its industry? Has the company's dividend strategy been similar to other companies in its industry?

Calculate xyzs 2013 current and quick ratios : Calculate XYZ's 2013 current and quick ratios based on the projected balance sheet and income statement data.

Analysis of credible sources in field of special education : For this Assignment, you will identify and provide an analysis of credible sources in the field of special education. The purpose of this assignment is for you to begin to differentiate between primary and secondary sources, as well as to determin..

What is the market value of the firm : Consider a growing firm that produces cash of $10 million next year.- What is the market value of this firm?- What is the firm's P/E ratio if it has no debt?

What is your forecast assuming no risk premium : What is your forecast level, assuming 3.5% risk premium (difference between corporate earnings yield and 10-year government bond)?- What is your forecast, assuming no risk premium?

How you expect the knowledge you have gained to be helpful : FIN 501- Explain how these concepts may be applicable and how you expect the knowledge you have gained to be helpful. Demonstrate your ability to provide reasoning for your response to discussion questions.

User Account

All Pages