User Account

All Pages

Find 2013 debt-to-assets and times-interest-earned ratios

Assignment Help Business Management
Reference no: EM131181001

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 TwoFinancial 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 TwoFinancial 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 ofXYZ'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

Reference no: EM131181001

Questions Cloud

Prepare amortization tables for issuance of the bonds : Prepare amortization tables for issuance of the bonds sold at 104 for the first three interest payments. - Prepare amortization tables for issuance of the bonds sold at 98 for the first three interest payments.
Discuss the major issues that top management : Discuss the major issues that top management should consider when deciding whether or not to expand business operations into new business areas.
Marketing plan for a new business-service : This project will start you thinking about Marketing in a practical sense. You will gain experience formulating a plan, learning how each part is dependent on one another. You will gain some introspection and perhaps direction for the future. In f..
Find the normal and shear stress that act perpendicular : The grains of wood in the board make an angle of 20! with the horizontal as shown. Determine the normal and shear stress that act perpendicular and parallel to the grains if the board is subjected to an axial load of 250 N.
Find 2013 debt-to-assets and times-interest-earned ratios : Calculate XYZ's 2013 current and quick ratios based on the projected balance sheet and income statement data.  Calculate the 2013 inventory turnover, days sales outstanding (DSO), fixed assets turnover, and total assets turnover.
Broader community of planet : This can apply to the community in which the company resides or the broader community of our planet. Create this report for the company you currently are working or for another existing company.
Determine the principal stresses and maximum in-plane shear : The 3-in. diameter shaft is supported by a smooth thrust bearing at A and a smooth journal bearing at B . Determine the principal stresses and maximum in-plane shear stress at a point on the outer surface of the shaft at section a - a .
Is there any particular geographic location that they seem : For the ongoing discussion and response posts, discuss whether you think the featured restaurant will be successful for the long term and why or why not. Are theme restaurants in general successful? Is there any particular geographic location th..
Conceptualization of the marketing mix : One of the drawbacks of the "Four P's" conceptualization of the marketing mix is that it tends to cause students to think that these are "stand alone" areas.

Reviews

Write a Review

Business Management Questions & Answers

  What is the final selling price of the item

An item selling for $1681 is marked down 10% for a special promotion. It is later marked down 40% of the sale price. Because it still hasn't been sold, it is marked down an additional 20%. What is the final selling price of the item?

  Consider that you have been asked to help your manager turn

consider that you have been asked to help your manager turn around a company. a critical element of this turnaround is

  The development of successful vision and mission statements

How important is management and leadership in the development of successful vision and mission statements?

  Ethical dimension-outsourcing cool

The Apple iPhone 5 is an undeniable success, as were the prior versions. A "game changer," the iPhone has taken the lowly simple cell phone to a whole new level by offering a wide range of features (digital music player, Internet surfing, PDA, e-m..

  Reputation on the market place and in public

Look for two articles (references); one on ethical practices, and the other on unethical practices. Summarize how each would impact the companies reputation on the market place and in public.

  How you intend to ensure the organization''s vision

How you intend to ensure the organization's vision, mission, and people strategies and values statements are aligned with the proposed strategic plan.

  The importance of satisfied customers

Address the importance of satisfied customers, arrival points, and service characteristics

  Emerging motivations persuading small business owners

Give examples of some emerging motivations persuading small business owners to go global. - Are any of these motivations likely to remain powerful forces ten years from now?

  Explain organizational purpose is an important foundation

Explain Organizational purpose is an important foundation for strategic planning within organizations and Could that be true also for individuals?

  Create a spreadsheet model

Create a spreadsheet model that will compute bond valuation, given the following assumptions: 1.      $1,000 face value 2.      5 year maturity

  The transfer of funds from an interest bearing account

The transfer of funds from an interest-bearing account that pays 0.04 percent per day for these three days?

  How should union movement respond structurally business

How should union movement respond structurally to increasing globalization of business. What kind of strategies or initiatives would you implement.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd