Question

current ratio 2.292 and 2.555 (2015) quick ratio 1.55 and 1.722 (2015); accounts receivable turnover 40.76; days sales outstanding 8.83; inventory turnover ratio 11.495 times; and average days to sell inventory; 31

debt to assets ratio 0.56 debt to equity = 1.30 interest coverage ratio = 141.66, plant assets to long term disabilities = 0.36

net margin ratio 0.30; asset turnover ratio = 12.9; return on investment = 3.88; return on equity 8.92%
Aug- Jan-15 Feb-15 5 Apr-15 15 Jun-15 ul-15 15 Sep-15 Oct-15 15 Dec-15 YEARLY (Sales) Garment 205,6809,2 241,18 246,0023862 229,07 233,66245,34247,79 252,75 278,02 361,43 2.989,3 15,543 15,542 15,542 17.873 18,231 17,684 16,976 17,316 18,182 18364 18,731 20,604 210.588 Revenue | 221,22| 225,26 256,72| 263,87| 25685| 246,76| 2s063| 262,661 265,971 271,111 296,751 38204| 3,199 90 Cost of Sales 51,925 9,714 60,908 59,081 56,718 57852 60.744 61.352 62,579 68.837 703,578 Accessorie-771-991| 7,887| 9,070-251| 8,974丨 8,61 s| 8,787| 9,226| 9,319-sos110.4ssl 7,771 26 9,319 9.sos 10.A55 20 850 tous。 Total Cost of Sales 194 60437 9,812 68,784 70,159 68054 65,332 66639 69971 70,671 72,084 79,292 810,428 162,0 164,82 196,91 195,09 186,69 178,701 196, -00,44 1 224,67 302,74 2 Expenses expenses 15,550 15,401 15.273 17564 17915 17,378 16,583 17.016 17,867 18,046 18,407 20,247 207347 genses 46,400 42.928 43.799 43,799 43,299 43,299 43,799 43,799 43,799 43,799 43,799 43,799 $27.315 office and 539 568 561 561 561 561 19 56156 maintenan 958| 977 993 1 993 3 993 993 993 993 993 6 856 ー856 856 993 993 11,870 856 10,315 378 16,407 Advertising 378 1,378 30 736 30 30 730 78 825 878 878 0 2 S62|2.566|2.566|2.5661-2 ss6-2.566 021,728 2,566| 2.566| 2.566| 2.566 2.566 30,719 800 10,532 5,2065,957 5,647 5,647 5,647 5,647 5,647 5,647 5,6475,6475,647 5,647 Total 75,689 73.921 73.481 75.772 76.123 75,586 489075.224 254 76,614 78,455 908,083 123,43 119,32 110,57 103,12 110,41 120,79 119,93 124,19 148,06 224,29 1,481,38 86,344 90,907 817 43,200 41,763 38,700 645 42 41,977 467 51.821 78,503 518,486 145,79 Income 80,229 77,559 1,769 78,518 77,95680,725 96,239 1962,902

12/31/2014 12/31/2015 Assets Current Assets Cash in bank Accounts receivable Inven Prepaid expenses Total Current Assets 57.0005 63,000 75,000 82,000 66,000 6,000 204,000 230,000 75,000 8,000 Fixed Assets Machinery & equipment 25,200 25,200 229,200248,000 S 18,000 Total Fixed Assets (net of depreciation) TOTAL Assets Liabilities and Equity Current Liabilities S 18,000 89,000 $ 90,000 Total Current Liabilities 89,000 $ 90,000 Long-term Debt Bank loans payable Total Long-term Debt Total Liabilities $ 50,000 62,000 62,000 151,000 78,200 229,200 $ 50,000 140,000 LI 108,000 Total Liabilities & Equity 248,000

Type your response here: Task 4: Financial Analysis Using your ratios, write 200 words describing the companys overall financial condition. Type your response here:

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Please note the picture of Profit and loss is not clear, therefore I am unable to calculate 2014 ratio's. So, the response is provided based on the best understanding by looking at the data given.

Understanding on company's financial position:

1. Current Ratio 2.292 (2014) and 2.555 (2015) & Quick Ratio 1.55 (2014) and 1.722 (2015): Current ratio and Quick ratio helps in understanding whether the company will be able to repay its short term debt's if required immediately. Since the current ratio and quick ratio have improved from 2014 to 2015, this indicates that the company's short term repayment situation has improved

2. Accounts receivable turnover 40.76 & days sales outstanding 8.83: Accounts receivable ratio is calculated by dividing credit sales/accounts receivable. Higher turnover ratio indicates higher frequency to convert receivables into cash.

Similarly, day sales outstanding represents the same information in terms of number of days in a year. The formula for the same is (number of days in a year/ average receivable turnover). In the present case 8.83 represents that it takes 8.83 days for company to convert receivable into cash. This is overall an indication of quick recovery. Hence the company's condition is good in this aspect also

3. Inventory turnover ratio 11.495 times; and average days to sell inventory 31: Inventory turnover ratio and average days to sell inventory indicates how much time it takes to replenish the sold inventory back in stock. In the present case, the inventory has been refilled 11.495 times to bring it back to the original levels. Average days to sell inventory denotes how much time it takes to convert raw material into finished products.

4. Debt to assets ratio 0.56 and Debt to equity = 1.30 : Ideally debt to equity of 2:1 is considered to be good. Debt to equity ratio denotes the long term solvency of the company. How capable a company is to pay off all its long term debt. Where debt to equity ratio is more than 2, it indicates that the company is over leveraged with more debt in it. Since in the present case, debt to equity ratio is less than 2:1, therefore the company has risk taking appetite and its long term solvency is also good.

5. Interest coverage ratio = 141.66 : This denotes how well the company is covered and able to repay finance cost arising on the debt.

6. Return on equity 8.92%: It is derived by dividing (net income/shareholder's equity). Higher the ratio, better it is. We need to calculate 2014 return on equity as well to estimate if it has improved.

7. Net margin ratio 0.30; and return on investment = 3.88: This indicates how much return is earned on the investments made and what is the net margin earned by the company. Higher the ratio, better it is.

Overall, on looking at the financial figures, it appears that the company's financial position has improved in 2015 and is moving in right direction.

Add a comment
Know the answer?
Add Answer to:
current ratio 2.292 and 2.555 (2015) quick ratio 1.55 and 1.722 (2015); accounts receivable turnover 40.76;...
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
  • Liquidity Current ratio 2014 = current assets/current liabilities 204,000/89,000 = 2.292 for 2014 and 230,000/90,000 =...

    Liquidity Current ratio 2014 = current assets/current liabilities 204,000/89,000 = 2.292 for 2014 and 230,000/90,000 = 2.555 for 2015 Quick Ratio = current assets-inventory/current liabilities 204,000-66,000/89000= 1.550 for 2014 and 230,000-75000/90,000 = 1.722 for 2015 Accounts receivable turnover Credit sales/average debts Average debt 75000+82000/2 = 78500 Total sales = 3,199,900/78500 = 40.76 times (2015) Days sales outstanding = average accounts receivable/sales credit 78500/3199900 x 360 = 8.83 days (2015) Inventory turnover 66,000+75,000/2 = 70,500 Inventory turnover ratio = cost of...

  • Aug- Jan-15 Feb-15 5 Apr-15 15 Jun-15 ul-15 15 Sep-15 Oct-15 15 Dec-15 YEARLY (Sales) Garment...

    Aug- Jan-15 Feb-15 5 Apr-15 15 Jun-15 ul-15 15 Sep-15 Oct-15 15 Dec-15 YEARLY (Sales) Garment 205,6809,2 241,18 246,0023862 229,07 233,66245,34247,79 252,75 278,02 361,43 2.989,3 15,543 15,542 15,542 17.873 18,231 17,684 16,976 17,316 18,182 18364 18,731 20,604 210.588 Revenue | 221,22| 225,26 256,72| 263,87| 25685| 246,76| 2s063| 262,661 265,971 271,111 296,751 38204| 3,199 90 Cost of Sales 51,925 9,714 60,908 59,081 56,718 57852 60.744 61.352 62,579 68.837 703,578 Accessorie-771-991| 7,887| 9,070-251| 8,974丨 8,61 s| 8,787| 9,226| 9,319-sos110.4ssl 7,771 26 9,319...

  • Aug- Jan-15 Feb-15 5 Apr-15 15 Jun-15 ul-15 15 Sep-15 Oct-15 15 Dec-15 YEARLY (Sales) Garment...

    Aug- Jan-15 Feb-15 5 Apr-15 15 Jun-15 ul-15 15 Sep-15 Oct-15 15 Dec-15 YEARLY (Sales) Garment 205,6809,2 241,18 246,0023862 229,07 233,66245,34247,79 252,75 278,02 361,43 2.989,3 15,543 15,542 15,542 17.873 18,231 17,684 16,976 17,316 18,182 18364 18,731 20,604 210.588 Revenue | 221,22| 225,26 256,72| 263,87| 25685| 246,76| 2s063| 262,661 265,971 271,111 296,751 38204| 3,199 90 Cost of Sales 51,925 9,714 60,908 59,081 56,718 57852 60.744 61.352 62,579 68.837 703,578 Accessorie-771-991| 7,887| 9,070-251| 8,974丨 8,61 s| 8,787| 9,226| 9,319-sos110.4ssl 7,771 26 9,319...

  • 2013 2014 2015 Formula Current Ratio Quick Ratio Operating Cash Flow to Average Current Liabiliti...

    2013 2014 2015 Formula Current Ratio Quick Ratio Operating Cash Flow to Average Current Liabilities Days Accounts Receivable 1 Low ST liquidity risk high Low ST liquidity risk 0.4 Low ST liquidity risk Current Assets/ Current Liabilities (Cash+ShortTermInvestments+AccountsReceivable Current Liabilities Operating Cash Flow/0.5(Current Liabilities-2Year) 365/Accounts Receivable Turnover Ratio Accounts Receivable Turnover-Sales 0.5(Accounts Receivable-2Year) 565 Inventory lurnover Ratio Inventory Turnover Ratio Costs of Goods Sold'0.5(Inventory-2Year) 365/Accounts Payable Tumover Ratio Accounts Payable Turnover-Purchase 0.5(Accounts Payable-2Year) Purchase-Cost of Goods Sold+Ending Inventory-Beginning Inventory Days...

  • 1. Calculate Account rececivable turnover for both 2014 and 2015 using this formula Sales/Accounts Receivable 2....

    1. Calculate Account rececivable turnover for both 2014 and 2015 using this formula Sales/Accounts Receivable 2. Calculate Account payable turnover for both 2014 and 2015 using this formula Cost of Goods Sold/Accounts Payable 3. calculate Return of Equity for both 2014 and 2015 using this formula Net Income/Common Equity 2017. Review the following financial data, and then answer the questions below. Company X Income Statement FYE 2014 and 2015 Period Ending 31-Jan-15 Total Sales $ 485,651,000 Cost of Goods 365,086.000...

  • 2013 2014 2015 Formula Current Ratio Quick Ratio Operating Cash Flow to Average Current Liabilities Days...

    2013 2014 2015 Formula Current Ratio Quick Ratio Operating Cash Flow to Average Current Liabilities Days Accounts Receivable 1 Low ST liquidity risk high Low ST liquidity risk 0.4 Low ST liquidity risk Current Assets/ Current Liabilities (Cash+ShortTermInvestments+AccountsReceivable Current Liabilities Operating Cash Flow/0.5(Current Liabilities-2Year) 365/Accounts Receivable Turnover Ratio Accounts Receivable Turnover-Sales 0.5(Accounts Receivable-2Year) 565 Inventory lurnover Ratio Inventory Turnover Ratio Costs of Goods Sold'0.5(Inventory-2Year) 365/Accounts Payable Tumover Ratio Accounts Payable Turnover-Purchase 0.5(Accounts Payable-2Year) Purchase-Cost of Goods Sold+Ending Inventory-Beginning Inventory Days...

  • Problem 3 Calculate the following information: 1. Quick ratio 2. Accounts receivable turnover ratio 3. Net...

    Problem 3 Calculate the following information: 1. Quick ratio 2. Accounts receivable turnover ratio 3. Net return on total assets 4. Total liabilities to total assets ratio 5. Times interest earned ratio 6. Return on sales 7. Return on equity Sales: $750,000 Cash: $50,000 Inventory: $150,000 Common Stock: $100,000 Accounts Payable: $100,000 Prepaid expenses: $30,000 so, sou Long term debt: $200,000 Land and Building: $500,000 Operating Income: $450,000 Taxes: $200,000 Accounts Receivable: $70,000 Retained Earnings: $400,000 Cost of Sales: $300,000...

  • Long-term debt ratio Times interest earned Current ratio Quick ratio Cash ratio Inventory turnover Average collection...

    Long-term debt ratio Times interest earned Current ratio Quick ratio Cash ratio Inventory turnover Average collection period 0.6 5.0 73 days Use the above information from the tables to work out the following missing entries, and then calculate the company's return on equity. Note: Turnover and the average collection period are calculated using start-of-year, not average, values. (Enter your answers in millions. Round intermediate calculations and final answers to 2 decimal places.) INCOME STATEMENT (Figures in $ millions) Net sales...

  • 2015 2014 2015 Awets Current Assets Cash Accounts Receivable Credit Card Receivable Marketable Securities Notes Receivable...

    2015 2014 2015 Awets Current Assets Cash Accounts Receivable Credit Card Receivable Marketable Securities Notes Receivable Inventory Prepaid Expenses Total Current Assets $25,000 $5,000 57.000 $20.000 $30,000 $32000 $40.000 $159.000 $23,000 $4.500 $6,000 $18,000 $25.000 $27.000 $36.000 $129.500 Revenues Sales Cash Sales AR Sales Credit Card Sales Total Sales Cost of Sales Gross Profit $45,000 $21,000 $76,000 $142,000 $38.340 $103,660 Direct Operating Expenses Payroll Expenses Other Expenses Total Departmental perses Fund Avusts $14.200 $12,780 526,900 Gross Operating Income 576.GRO tau...

  • Calculate the accounts receivable turnover, average collection period (days), inventory turnover, fixed asset turnover, and total...

    Calculate the accounts receivable turnover, average collection period (days), inventory turnover, fixed asset turnover, and total asset turnover for each period. X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME...

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