Reference no: EM131175536
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
|
|
|
|
|
Attachment:- Attachments.rar
|
Prepare the entries for the declaration and payment
: Langley Corporation has 43,600 shares of $12 par value common stock outstanding.- Prepare the entries for the declaration and payment of the stock dividend.
|
|
Prove that both results are indeed correct answers by cubing
: Find the cube root of - 5, both by using the nthroot function and by rais-ing - 5 to the 1/3 power. Explain the difference in your answers. Prove that both results are indeed correct answers by cubing them and showing that they equal - 5.
|
|
Find the mean range variance and standard deviation
: Find the mean, range, variance, and standard deviation for each of the three variables shown in the list. Present your results in a table. Using your results from (a), compare the distributions for job growth percentage and Percentage of women empl..
|
|
Prepare a monthly cash budget and supporting schedules
: Prepare a monthly cash budget and supporting schedules for March, April, and May. -On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
|
|
Calculate the inventory turnover and days sales outstanding
: Calculate the 2013 inventory turnover, days sales outstanding (DSO), fixed assets turnover, and total assets turnover. Calculate the 2013 debt-to-assets and times-interest-earned ratios.
|
|
Which market structure best characterizes the industry
: Furthermore, the four-firm concentration ratio and Herfindahl Hirschman index are both quite small. Based on this information, which market structure best characterizes the industry in which Forey competes? Explain the features this market structu..
|
|
Analyse aspects of that project in a clinical manner
: They require you to select a project (or projects) of your choice (so your studies are contextuaIized for your needs) and to analyse aspects of that project in a clinical and objective manner
|
|
What are major effects of the policy domestically
: Do you think the U.S. subsidies for the domestic production of ethanol fuel is a good idea? What are major effects of the policy domestically and international?
|
|
Create venn diagram - inclusion in early childhood education
: Create a Venn diagram or another type of graphic organizer that outlines the similarities and differences in the development of students with and without disabilities.
|