Question

Exercise Calculate liquidity, Profitability, Debt ratios from the below details and comment on the financial performance, com

0 0
Add a comment Improve this question Transcribed image text
Answer #1
2015 2014
Liquidity Ratios
Current Ratio=Current Assets/Current Liability
=(24192+68040+151200)/(149688) =(26611+74844+166320)/(164657)
1.63 1.63
Quick Ratio=Current Assets – Inventory – Prepaid Expenses/Current Liability
=(24192+68040)/(149688) =(26611+74844)/(164657)
0.62 0.62
Absolute liquidity ratio=Cash + Marketable Securities / Current Liability
=24192/149688 =26611/164657
0.16 0.16
Profitability Ratios
Gross Profit Margin = (Revenue – Cost of Goods Sold) / Revenue*100%
=(270000-135000)/270000 =(400000-200000)/400000
50% 50%
Net Profit Margin = PAT / Revenue * 100%
=31050/270000 =60300/400000
11.50% 15.08%
EBITDA Margin = EBITDA / Revenue * 100%
=(270000-135000-48600)/270000 =(400000-200000-66250)/400000
32.00% 33.44%
Debt Ratios
Debt Equity Ratio= Debt/Equity
=189000/630504 =207900/693554
0.30 0.30
Debt to Total Assets Ratio= Debt/Total Assets
=189000/969192 =207900/1066111
19.50% 19.50%
Comment on Financial Performance:
XYZ LLC has stable Liquidity and Debt Position as compared to Previous year. It's Net Profit and EBIT Margin has reduced as compared to last year.
Add a comment
Know the answer?
Add Answer to:
Exercise Calculate liquidity, Profitability, Debt ratios from the below details and comment on the financial performance,...
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
  • Exercise Calculate liquidity, Profitability, Debt ratios from the below details and comment on the financial performance,...

    Exercise Calculate liquidity, Profitability, Debt ratios from the below details and comment on the financial performance, compared to the previous year. 400,000 Statement of Income of XYZ LLC for the year ended 31st December 2015 & 2014 Particulars Amount(RO) Amount (RO) 2015 2014 Sales 270,000 Less: Cost of goods sold 135,000 200,000 Salaries 48,600 66,250 Depreciation 22,950 37,500 Interest 5,400 211,950 6,250 Income before taxes 58,050 Less: Income taxes 27,000 Net Income 31,050 310,000 90,000 29,700 60,300 Balance sheet of...

  • Financial​ ratios: Liquidity. The financial statements for Tyler​ Toys, Inc. are shown below: Calculate the current​...

    Financial​ ratios: Liquidity. The financial statements for Tyler​ Toys, Inc. are shown below: Calculate the current​ ratio, quick​ ratio, and cash ratio for Tyler Toys for 2013 and 2014. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,146,664 $13,566,518 Cost of goods sold $-8,447,425 $-8,131,347 Selling, general, and administrative expenses...

  • Calculate the following ratios for 2015 and show the steps involved: a) Inventory turnover ratio b)...

    Calculate the following ratios for 2015 and show the steps involved: a) Inventory turnover ratio b) average days in inventory c) receivables turnover ratio d) average collection period e) asset turnover ratio f) profit margin on sales g) return on assets h) return on shareholders equity i) equity multiplier j) return on shareholders equity using the Du Port framework Note: See attached balance sheet and income statement below as reference We were unable to transcribe this imageAS AT 31 DECEMBER...

  • Compute the following financial ratios for the company: Current ratio Acid-test ratio (also known as the...

    Compute the following financial ratios for the company: Current ratio Acid-test ratio (also known as the Quick ratio) Operating return on assets Gross profit margin Operating profit margin Net profit margin Total asset turnover (TATO) Fixed asset turnover (FATO) Times interest earned (TIE) Debt ratio Return on equity (ROE) Price/Earnings ratio (P/E) Market/Book ratio 12/31/18 12/31/17 Sales Cost Of Goods Gross Profit Selling & Adminstrative & Depr. & Amort Expenses Income After Depreciation & Amortization Non-Operating Income Interest Expense Pretax...

  • U2 - Financial Statement Analysis (50 min) Calculate at least 4 ratios for EACH of the...

    U2 - Financial Statement Analysis (50 min) Calculate at least 4 ratios for EACH of the following ratio categories (profitability, liquidity, solvency, efficiency) Intepret the results. Best Buy Ltd. Statement of Earnings (Income Statement) For the Year Ended Dec 31, 2017 In millions of dollars 2013 2014 2015 2016 2017 Revenue Computers Phones Software & Gaming Total Revenue $150.00 $75.00 $50.00 $172.50 $150.00 $62.50 $385.00 $198.38 $210.00 $78.13 $486.50 $62.50 $228.13 $294.00 $97.66 $619.79 $262.35 $411.60 $122.07 $796.02 $275.00 $96.25...

  • Please Calculate the following ratios Total Debt Ratio Debt/Equity Ratio Cash flow from operation...

    Please Calculate the following ratios Total Debt Ratio Debt/Equity Ratio Cash flow from operations/total liabilities ---------- Return on Equity (ROE) (112) 17 s (2182) (2,535) (2,535) 10 $ 12,693 1,434 (13,372) Balance at Dec. 31, 2015 Balance, shares at Dec. 31, 2015 40,870 4,558) 272 (1,687) marketable securities Changes in fair value of cash flow (43) Vesting of restricted stock, shares $ 286 s (778) Stock repurchase program, shares (2,713) $10,027 138 $ 103 $ 9,924 138 shares Acquisition of...

  • Given the above Finacail Statemtns, Calculate all of the missing performance measures in sheet “PM” (below)...

    Given the above Finacail Statemtns, Calculate all of the missing performance measures in sheet “PM” (below) for Vandelay Farms.“CF” is the statement of cash flow summary for Vandelay Farms. Based on the performance ratios, is Vandelay Farms in any kind of financial trouble? Why or why not? Balance Sheet Summary for Vandelay Farms Historica Pro 2017 Current assets Cash, savings, and marketable securities Crops, feed, and supplies Market livestock Accounts receivable Other current assets All personal assets Total current assets...

  • please show the work and provide correct answers. This is from financial management course In-Class Exercise...

    please show the work and provide correct answers. This is from financial management course In-Class Exercise - Accounting Review Chapter 2 - Financial Statements, Cash Flow, and Taxes 1. Frederickson Office Supplies recently reported $12,500 of sales, $7,250 of operating costs other than depreciation, and $1,250 of depreciation. The company had no amortization charges and no non- operating income. It had $8,000 of bonds outstanding that carry a 7.5% interest rate, and its federal-plus- state income tax rate was 40%....

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