Review the Watson case using the following financial ratios in a trend analysis. Note that year 199x =1997, y=1998, and z = 1999. While sales growth is strong, this firm has some issues. Can you identify them? Recommend solutions?

The sales are strong compared to the industry but the increase in sales is not converting into the profit.
As it can be clearly seen by a decrease in earnings per share
and profit margin ratios.
The decrease in profit margin is also affecting the return on asset
and return on equity.
Liquidity means the ability of the business to pay its short-term liabilities.
The company's liquidity ratio is also very poor and showing an alarming sign.
The company can fall into a debt trap. (Due to which it can cause the bankruptcy of the company). The company is unable to generate enough profit and it is borrowing more money in the form of debt which is very high above industry standard.
The companies debt to total assets that have increased by 10.48% from 1997 to 1999. Whereas industry debt to total assets that have increased by 2.10% from 1997 to 1999. It is almost 5 times more for Watson.
The company is facing it difficult to pay its interest on its debt. It can be clearly seen to buy a decrease in times to interest earned ratio.
The Watson also has very poor asset Management ratios. The average collection period has significantly increased compared to the industry.
Solutions:
1. To improve working Capital Management.
2. Increase the efficiency of the cash cycle and operating
cycle.
3. Reduce debt & don't go for new projects (or massive
expansion).
4. Concentrate on increasing profitability.
Review the Watson case using the following financial ratios in a trend analysis. Note that year...
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio 3.34x Fixed assets turnover 7.44x Debt-to-capital ratio 19.28% Total assets turnover 3.70x Times interest earned 35.45x Profit margin 12.64% EBITDA...
Complete Assurance of Learning Exercise 4C: Financial Ratio
Analysis for PepsiCo.
Financial Ratios for PepsiCo (2012) use the below information to
find
Liquidity Ratios:
- Current ratio:
- Quick ratio:
Leverage Ratios:
- Debt-to-total-assets ratio:
- Debt-to-equity ratio:
- Long-term debt-to-equity ratio:
- Times-earned-interest ratio: Profits before interest and
taxes/Total interest charges
Activity Ratios:
- Inventory turnover:
- Fixed assets turnover:
- Total assets turnover:
- Accounts receivable turnover:
Profitability Ratios:
- Gross profit margin:
- Operating profit margin:
-...
Problem 3-35 Using ratios to construct financial statements [LO3-2] The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $18.00 million for last year. Sales to total assets 1.20 times Total debt to total assets 45 % Current ratio 2.80 times Inventory turnover 6 times Average collection period 24 days Fixed asset turnover 5 times Complete the balance sheet: (Use a 360-day year. Do not round intermediate calculations. Input your answers in millions rounded to 2...
Evaluate Tesla financial statements based on the below points.Sizeo total assets and total revenueo market capGrowtho asset growth and revenue growtho market to book ratioo price to earnings ratio (P/E ratio)Use following ratios or financial statemen item to compare and analyze business performance.Profitabilityo gross profit percentage o return on assets o return on common stockholders’ equity, earnings per share, and the price/earnings ratio Solvencyo debt ratio o debt to equity o free cash flowsLiquidityo current ratioo acid-test ratio Operating Efficiencyo inventory turnover, days’ sales in inventory o accounts...
So, here are some company ratios for a fictional retail company along with industry averages. (Part A): Go through and determine basic trending for each category. (Part B): Then, based on what you learned here, you will need to determine the overall health of the company based on your trend analysis. What do your trends say in terms of the industry averages and the overall health of this company? Yes, I realize no specific industry is shown. This is a simple...
please show all work in Excel
CHAPTER 3: FINANCIAL STATEMENT ANALYSIS TOOLS NOTE: PLEASE USE WORKSHEET #3 IN THE ATTACHED EXCEL FILE TITLED "Homework for Chapter 3_Excel TO SOLVE THE FOLLOWING PROBLEM. Homework for Chapter 3: Problem #1 in the text (Chapter 3) Sweet Dreams Corp. Balance Sheet As of Dec. 31 2017 Assets 2017 2016 Cash 431.000 339,000 Accounts Receivable 503.000 365,000 Inventories 289,000 300,000 Total Current Assets 1.223.000 1.004.000 Sweet Dreams Corp. Income Statement For the Year Ended...
Section E: Financial Statement Analysis--Ratios Method Listed below are various ratios of NIKE, Inc. for the current year current year and the prior year. Current 2.8 Current Ratio . . . Quick Ratio . 1.6 1.5 9.8 Accounts Receivable Turnover 9.5 Number of days' sales in receivables. . 37.2 38.6 Inventory Turnover . . . . 3.8 4.0 Number of days' sales in inventory. 96.2 91.4 Ratio of Liabilities to Stockholders' Equity. 0.7 0.7 Asset Turnover . . . ....
Section E: Financial Statement Analysis. Ratios Meu Listed below are various ratios of NIKE. Inc. for the cure int Analysis--Ratios Method the current year and the prior year. Current Prior 9.8 38.6 0.7 0.7 2.5 2.8 1.5 Current Ratio. 1.6 Quick Ratio . 9.5 Accounts Receivable Turnover 37.2 Number of days' sales in receivables. 4.0 3.8 Inventory Turnover . 91.4 96.2 . Number of days' sales in inventory Ratio of Liabilities to Stockholders' Equity. 1.5 Asset Turnover 1.5 17.6% 16.4%...
Problem 3-35 Using ratios to construct financial statements [LO3-2] The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $30.60 million for last year Sales to total assets Total debt to total assets Current ratio Inventory turnover Average collection period Fixed asset turnover 1.80 times 40 % 2.40 times 6 times 19 days 5 times Complete the balance sheet: (Use a 360-day year. Do not round intermediate calculations. Input your answers in millions rounded to 2 decimal...
there are 5 photos
Au bolcuole Normal No Spacing Heading 1 Yux Construction Company Financial Stat. Balance sheet 2018 2017 Formulae Current ratio Current assets/Current 585,632 878,000 $7,282 632,160 Liabilities Aucts Cash Account receivable (A/R) Inventories Total current Asset Gross Fixed Assets Less: Depreciation Net Fixed Assef Total Asset 1.716,480 2,680,112 1,197,160 380,120 817,040 3,497,152 1,287,360 1,926,802 1,202,950 263,160 939,790 2,866,592 Inv. turnover - Sales / Inventories FA turnover - Sales / Net fixed assets TA turnover = Sales /...