Current ratio= current assets Current liabilities
= 2680112
1144800
=2.34

You're lucky! Use promo "samples20"
and get a custom paper on
"Financial Statement Analysis Worksheet"
with 20% discount!
Order Now

Quick ratio = cash + cash equivalent + short term investment + accounts receivable
Current assets
= 878000 + 85632
1144800

= 963632
1144800

= 0.84

The current ratio and quick ratio also referred as the acid-test are essential to a business in determining its liquidity (Tracy, n. d. p. 12). The ratios are used to determine if a company can settle its short-term liabilities with ease. The ratios help financial institutions and suppliers to determine if an enterprise is credit worth and to access the risk of doing business with the firm. The ratios also serve as an early indicator of financial distress in a company if they drop below 1.

Inventory turnover = cost of good for sale
Inventory
= 5875992
1716480
= 3.42

Days Sales outstanding = Receivables
Total sales/ 365
= 878000
7035600/365
= 89.05

Net asset turnover = sales
Net fixed assets
= 7035600
817040
= 8.61

Total assets turn over = sales
Total assets
7035600
3497152
= 2.01

The four ratios are associated with the working capital. They identify how fast activities are happening to show an organization’s efficiency. Inventory turnover indicates the effectiveness in sales of the purchased stock. Days sales outstanding ratio on the other side demonstrate the amount of time an enterprise requires to convert its receivables into cash (Wahlen, Bradshaw, Baginski & Stickney, n. d. p. 118). The net assets and total assets ratio are an indication of how good assets in the business are utilized. The ratios are used to assess the efficiency in the management of assets.

Debt –to –asset ratio = total debt
Total assets
= 1544800
3497152
= 0.44
Times- interest – earned = EBIT
Interest charges
= 492642
70008
= 7.04

The ratios show the ability of the firm to manage its debt. Debt to assets ratio is a critical ratio indicating the security available to secure the debt (Tracy, n. d. p. 22). It is used by lenders to access the amount of money to give to the organization. The second ratio shows the amount of interest paid on the amount earned by the firm.

Operating margin = operating income ( EBIT)
Net sales
= 492648 ×100
7035600
=0.07
=7%
Profit margin = net income
Sales
= 253584 × 100
7035600
= 0.036*100
= 3.6%
Basic earning power = EBIT
Total assets
= 492642 × 100
3497152
= 0.1408
= 14.08%
Return on assets = net income
Total assets
= 253584
3497152
= 0.072
= 7.2%
Return on equity = net income
Common equity

= 253584
1721176
= 0.015
= 1.5%

The ratios indicate the profitability of a firm. They are used by investors to access the expected return on their investments (Brigham & Ehrhardt, 2014, p. 112). They are also used to compare the company’s performance with others in the industry. They are the simplest method to measure growth in the profits of business.

Price earnings ratio = price per share
Earnings per share
= 12.17
1.014
= 12.00

Market/book ratio = market price per share
Book value per share
= 12.17
7.809
= 1.56

The DuPont equation
=net income × sales × assets
Sales total assets equity (Brigham, 2016, p.118)
= 253584 × 7035600 × 3497152
7035600 3497152 1952352
0.036 × 2.011 × 1.791
=0.1299

= 12.99%
XYZ has a small ROE of 0.036 compared to the other ratios in the DuPont equation. The factors leading to this situation could be minimal sales or high expenses. The company must, therefore, adjust its expenditure to improve its net income.

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
The following would be the new balance sheet.
Accounts receivable $616.82 Debt $1,545
Other current assets 2063.18
Net fixed assets 817 Equity 1,952
Total assets $3,497 Liabilities plus equity $3,497
The change will only affect the value of the accounts receivable and the value of other current assets, particularly cash. It has no effect on the value of the total assets and liabilities plus equity. Therefore, it may not have any effects on the valuation of the company or its stock prices.

    References
  • Brigham, E. (2016). Fundamentals of Financial Management. [Place of publication not identified]: Cengage Learning.
  • Brigham, E., & Ehrhardt, M. (2014). Financial Management. Mason, Ohio: South-Western.
  • Tracy, A. Ratio Analysis Fundamentals.
  • Wahlen, J., Bradshaw, M., Baginski, S., & Stickney, C. Financial Reporting, Financial Statement Analysis, and Valuation.