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