Question

Please help me create a financial analysis out of this: Liquidity Ratio YEAR ONE YEAR TWO...

Please help me create a financial analysis out of this:

Liquidity Ratio YEAR ONE YEAR TWO
Current Ratio 2.82 2.55
Quick Ratio                                        1.46                                       1.58
Cash Ratio                                        0.47                                       0.65
   Networking Capital to Total Asset                                        0.41                                       0.48
Activity Ratio YEAR ONE YEAR TWO
   Inventory Turnover                                        8.00                                       4.83
   Average days Inventory                                      45.00                                     74.54
   Asset Turnover                                        3.70 2.15
   Receivable Turnover 20.80 9.67
   Average days Receivable                                      17.31 37.21
   Payable Turnover                                      34.05 13.67
Leverage Ratio YEAR ONE YEAR TWO
   Debt-to-equity                                        0.39                                       0.64
   Debt-to-total assets                                        0.28                                       0.39
   Equity Ratio 0.72 0.61
   Times Interest Earned Ratio                                      11.38                                     10.44
   Cash Coverage Ratio                                      20.00                                     14.56
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Liquidity ratios
Current ratio has decreased slightly and quick ratio have increased slightly Cash ratio has improved means in year 2 company have more cash to cover it current liabilities compared to year 1 cash. Net working capital to total assets have gone up slightly so by looking at liquidity ratios we can say that liquidity of firm has not changed much in year2
Activity ratio
Inventory turnover has gone down and average days inventory have gone up it means company is not managing its inventory in efficient manner rather inventory management has been poor in year2 compared to year1. Same thing is with receivables and total assets turnover ratios both ratios have gone down from year1 levels. Receivable day have increased from 17.31 to 37.21 which means in year 2 firm is taking more days to collect its receivable which is not a good sign. Payable turnover ratio have increased means company is paying its creditors faster in year2. Which shows the power of supplier has increased. By looking at overall activity ratios we can conclude that company is not managing its asset well enough, the efficiency has gone down compared to year 1
Leverage ratios
Debt to equity ratio and debt to total assets ratio has increased whereas equity ratio have increased which means company is financing its asset using more debts compared to year 1 . Having more debt is considered as more risky. Times interest earned ratio and cash coverage ratio has gone down which reflects that company's ability to meet its financial obligation has gone down. So overall leverage ratios are reflecting companies financial health have become riskier in year2 compared to year1
So by considering above all three category ratio we can conclude that firms is not in good position compared to year 1 and it looks more riskier and it is not recommended to invest.
Add a comment
Know the answer?
Add Answer to:
Please help me create a financial analysis out of this: Liquidity Ratio YEAR ONE YEAR TWO...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • can someone explain to me what the ratio means and how it is calculated please? How...

    can someone explain to me what the ratio means and how it is calculated please? How would you describe Ford's comparative performance and financial positions? Examine Ford's financial ratios. What does each ratio tell you about Ford's financial status? (demonstrate an excellent understanding of the ratios i.e. calculated and interpreted all the results accurately) I am very lost by this table. any explanation will be appreciated. Thank you! EXHIBIT 4: COMPARATIVE FINANCIAL RATIOS OF FORD, TOYOTA, GENERAL MOTORS, AND HONDA,...

  • Hi need some help Calculating the Liquidity, solvency and profitability of Marriott Intercontinental with the Financial...

    Hi need some help Calculating the Liquidity, solvency and profitability of Marriott Intercontinental with the Financial Statement of Year 2012. Please, I would appreciate a brief description of how was calculated everything to understand the exercise. Liquidity Working capital Current ratio Current cash debt coverage Inventory turnover Days in inventory Accounts receivable turnover Average collection period Current assets-Current liabilities Current assets Current liabilities Net cash provided by operating activities Average current liabilities Cost of goods sold Average inventory 365 days...

  • i need help and a expaination please ? Selected year-end financial statements of Cabot Corporation follow....

    i need help and a expaination please ? Selected year-end financial statements of Cabot Corporation follow. All sales were on credit: selected balance sheet amounts at December 31, 2016, were inventory, $52.900; total assets. $229.400; common stock, $88,000; and retained earnings, $32,712.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 450,600 Cost of goods sold 297,650 Gross profit 152,950 Operating expenses 99, 100 Interest expense 3,800 Income before taxes 50.050 Income taxes 20, 162 Net income...

  • need help ? Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit;...

    need help ? Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $52.900; total assets, $229,400; common stock, $88,000; and retained earnings. $32,712.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 450, 600 Cost of goods sold 297,650 Gross profit 152,950 Operating expenses 99, 100 Interest expense 3,800 Income before taxes 50,050 Income taxes 20. 162 Net Income $ 29,888 $ 16,500...

  • Please can someone help Me this question Please show the formula and the answe. We were...

    Please can someone help Me this question Please show the formula and the answe. We were unable to transcribe this imagePark Ridge Homecare Statement of Income Year Ended December 31, 2015 (in Thousands) Net Service Revenues Cost of Service Revenues 2666 1944 Gross Profit 722 General and Administrative Expenses Depreciation 649 15 Total Operating Expenses Operating Income 684 58 Interest Income Interest Expense 86 19 Total Interest Income, net Income Before Income Taxes 67 125 26 Income Tax Expense Net...

  • Help on my Finance homework please! Integrative: Complete ratio analysis Given the following financial statements, historical...

    Help on my Finance homework please! Integrative: Complete ratio analysis Given the following financial statements, historical ratios, and industry averages, calculate Sterling Company’s financial ratios for the most recent year. (Assume a 365-day year.) Sterling Company Income Statement for the Year Ended December 31, 2019 Sales revenue $10,000,000 Less: Cost of goods sold 7,500,000       Gross profits $ 2,500,000 Less: Operating expenses        Selling expense $ 300,000        General and administrative expenses 650,000        Lease expense 50,000        Depreciation expense...

  • please show all work in Excel CHAPTER 3: FINANCIAL STATEMENT ANALYSIS TOOLS NOTE: PLEASE USE WORKSHEET...

    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...

  • Please help with "Days in Patient AR" and providing a "brief ratio analysis, trend analysis, and...

    Please help with "Days in Patient AR" and providing a "brief ratio analysis, trend analysis, and comparative analysis " for each Ratios For each ratio, provide a brief ratio analysis, trend analysis and comparative analysis. Ratio Analysis: Trend Analysis Comparative Analysis Briefly explain what the ratio means Compare 2017 numbers with 2016 numbers and explain if the numbers improved or declined and briefly why this could have occurred Compare WTRH 2017 with industry averages and explain how WTRH did compared...

  • Help me figure out the ratios to analyze a company's liquidity and solvency. Please add the...

    Help me figure out the ratios to analyze a company's liquidity and solvency. Please add the formulas to show how you got the answers. Also please answer the stuff in yellow. 1. Use ratios to analyze a company's liquidity and solvency. Calculate Select Ratios - Excel ? X - Sign In FILE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW HOME Calibri E- 11 AA A Paste BIU B Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles...

  • Seved Help Sav Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit,...

    Seved Help Sav Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit, selected balance sheet amounts at December 31, 2016, were inventory, S49.900, total assets, $219,400: common stock, $83,000: and retained earnings. $54.354.) 452.60 298,450 Cost of goods sold Groas profi Operating expenses 30,246 Assets Cash Liabilities and Eqaity 15,500 3, 700 64,400 18,000 Accounts payable ,,00ง Moored wages payable 30,200 Inoone taxes payable Accounts receivable, net Sotes receivable (trade)* Merehand ise inventory 40.150 tong-term note...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT