Fashion Outfitters | The Gap Inc. | |||||
2017 | 2016 | 2015 | 2017 | 2016 | 2015 | |
Liqudity ratios | ||||||
Quick ratio | =(195000+183700+46800)/100300 | =(129100+179600+49700)/109100 | =(134000+156100+56100)/120900 | |||
=(cash+ST investment+ currenct receivable)/ current liabilities | 4.24 | 3.29 | 2.86 | 1.01 | 0.83 | 1.09 |
Improving over 3 years and better than competition | ||||||
Current ratio | =482900/100300 | =420100/109100 | =415200/120900 | |||
=current assets/ current liabilities | 4.81 | 3.85 | 3.43 | 1.76 | 1.57 | 1.93 |
Improving over 3 years and better than competition | ||||||
Working capital | =482900-100300 | =420100-109100 | =415200-120900 | |||
=current assets- current liabilities | 382,600 | 311,000 | 294,300 | 1,862,000 | 1,450,000 | 2,162,000 |
Improving over 3 years. Overall, Fashion is managing in capital efficiently | ||||||
Solvency ratios | ||||||
Debt to Equity ratio | =234200/405800 | =261200/348000 | =293300/335500 | |||
=Total Liabilities/ Total equity | 0.58 | 0.75 | 0.87 | 0.39 | 0.39 | 0.41 |
Improving over 3 years but worse than competition | ||||||
Equity ratio | =405800/640000 | =348000/609200 | =335500/628800 | |||
=Total Equity/ Total assets | 0.63 | 0.57 | 0.53 | 0.84 | 0.81 | 0.83 |
Improving over 3 years but worse than competition | ||||||
Debt ratio | =234200/640000 | =261200/609200 | =293300/628800 | |||
=Total Liabilities/ Total assets | 0.37 | 0.43 | 0.47 | 0.16 | 0.19 | 0.17 |
Improving over 3 years but worse than competition. Overall, Fashion has been improving its capital structure but it could do better | ||||||
Efficiency ratios | ||||||
Working capital | =482900-100300 | =420100-109100 | =415200-120900 | |||
=current assets- current liabilities | 382,600 | 311,000 | 294,300 | 1,862,000 | 1,450,000 | 2,162,000 |
'Improving over 3 years. | ||||||
Asset turnover | =350000/((640000+60900)/2) | =370000/((609200+628800)/2) | ||||
=net sales/ average total assets | 1.00 | 0.60 | 2.03 | 1.98 | ||
'Improving over 2 years. | ||||||
Inventory turnover | =235000/((54400+57200)/2) | =246000/((57200+63100)/2) | ||||
=COGS/ Average inventory | 4.21 | 4.09 | 5.33 | 5.36 | ||
'Improving over 2 years. | ||||||
Days sales in inventory | =(54400/235000)*365 | =(57200/246000)*365 | =(63100/270000)*365 | |||
=ending inventory/COGS*365 | 84.49 | 84.87 | 85.30 | 67.63 | 67.84 | 67.96 |
Almost stable over the period but could be improved as compered to competition | ||||||
Profitability ratios | ||||||
Gross profit margin | =115000/350000 | =124000/370000 | =141000/411000 | |||
=gross profit/ net sales | 32.86% | 33.51% | 34.31% | 38.46% | 39.87% | 36.44% |
Decreasing over 3 years. Worse than competition | ||||||
Net profit margin | =19000/350000 | =25000/370000 | =38000/411000 | |||
=net profit/ net sales | 5.43% | 6.76% | 9.25% | 5.57% | 6.37% | 6.79% |
Decreasing over 3 years. Worse than competition | ||||||
Return on capital employed | =25000/405800 | =32000/348000 | =51000/335500 | |||
=net operating profit/ employed capital | 6.16% | 9.20% | 15.20% | 22.76% | 23.88% | 32.80% |
Decreasing over 3 years. Worse than competition | ||||||
Return on equity | =19000/405800 | =25000/348000 | =38000/335500 | |||
=net income/ total equity | 4.68% | 7.18% | 11.33% | 28.84% | 22.76% | 23.86% |
Decreasing over 3 years. Overall, the business is not profitable for the shareholders. It needs to improve the business model to be more profitable |
Cash conversion cycle | ||
CCC = DIO + DSO - DPO | =86.7+50.3-66.7 | 70.3 |
DIO = Average inventory/COGS per day | =((54400+57200)/2)/235000*365 | 86.7 |
DSO = Average AR / Revenue per day | =((46800+49700)/2)/350000*365 | 50.3 |
DPO = Average AP/COGS per day | =((41500+44400)/2)/235000*365 | 66.7 |
If the collection period is improved by 7 days, the impact would
be on DSO. The DSO would decrease to 43.3. This would lower the CCC
to 63.3
The revenue per day is ~960,000. By improving AR by 7 days, the
interes worth 960,000*7*Interedst rate/365 could be saved. This
will improve the efficiency ratios as well
Fashion Outfitters Income Statement In '000s 2015 350,000 370,000 411,000 235,000 246,000 270,000 115,000 124,000 141,000...
please help Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000 $10,000 Accounts Receivable (net) 95,000 70,000 53,000 Inventory 81,000 71,000 53,000 Other current assets 65,000 49,000 61,000 Long-term investments 120,000 76,000 50,000 Property, Plant & Equipment (net) 598,000 345,000 315.000 Total Assets $991,000 $630,000 $542,000 $71,500 245.000 316,500 $56,000 75.000 131,000 $65,000 78,000 143,000 Liabilities & Shareholders' Equity Liabilities Current Liabilities Non-current liabilities Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity...
please do Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000 $10,000 Accounts Receivable (net) 95,000 70,000 53,000 Inventory 81,000 71,000 53,000 Other current assets 65,000 49,000 61,000 Long-term investments 120,000 76,000 50,000 Property, Plant & Equipment (net) 598,000 345,000 315.000 Total Assets $991,000 $630,000 $542,000 $71,500 245.000 316,500 $56,000 75.000 131,000 $65,000 78,000 143,000 Liabilities & Shareholders' Equity Liabilities Current Liabilities Non-current liabilities Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity...
Part 1: Ratio Analysis calculate the following ratios Part 2: Perform a vertical analysis of statement of financial position & Income statement Part 3: Perform a Horizontal Analysis of statement of Financial Position for 2015 and 2014 & Income statement for 2015 Instructions: 1. On pages three and four, you will find condensed statement of financial position and income statement data for Waterloo Corporation. 2. Use the same information to answer all the three parts. 3. Part 1: a. In...
Part A Given below are comparative statement of financial positions and an income statement for the Bay Company: Bay Company Statement of Financial Positions at 31 December 2018 2017 Assets Current assets Cash Accounts receivable Inventory Current assets Equipment (net) Total assets $ 27,000 215,000 148.000 390,000 310,000 $700,000 $ 23,000 185,000 152.000 360,000 280,000 S640.000 Liabilities and Equity Current liabilities Accounts payable Interest payable Current liabilities Long-term loans Total liabilities $115,000 15.000 130,000 200.000 330,000 $126,000 12.000 138,000 150.000...
The following is the balance sheet and income statement for Metro Eagle Outfitters, in condensed form, plus some information from the cash flow statement. Balance Sheet 2019 2018 2017 Cash and short-term investments $ 645,992 $ 760,044 $ 749,693 Accounts receivable 47,821 41,810 39,721 Inventory 347,452 397,514 316,208 Other current assets 115,535 118,120 98,788 Total current assets 1,156,800 1,317,488 1,204,410 Long-lived assets 575,332 624,982 571,302 Total assets $ 1,732,132 $ 1,942,470 $ 1,775,712 Current liabilities $ 470,402 $ 450,401 $...
Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market, Inc. Income Statement, For Years Ended (in $ 000s) 2010 2009 Sales $ 9,005,794 $ 8,031,620 Cost of goods sold and occupancy costs 5,870,393 5,277,310 Gross profit 3,135,401 2,754,310 Direct store expenses 2,375,716 2,145,809 General administrative expenses 272,449 243,749 Pre-opening expenses 38,044 49,218 Relocation, store closures and lease termination costs 11,217 31,185 Operating income 437,975 284,349 Interest expense (33,048)...
Check The following is the balance sheet and income statement for Metro Eagle Outfitters, in condensed form, plus some information from the cash flow statement. 2019 $ 647,992 48,021 349, 452 113,335 1,158,800 574,332 $1,733,132 $ 475,402 510,245 1, 222,887 $1,733, 132 2018 $ 762,044 42,010 401,514 115,920 1,321,488 621,982 $1,943, 470 $ 456,401 522,886 1,420,584 $1,943, 470 2017 $ 751,693 40,121 318,208 98,388 1, 208,410 568,302 $1,776,712 404,837 422,241 1,354, 471 $1,776,712 Balance Sheet Cash and short-term investments Accounts...
SHort answer Required information Ratio Analysis: Urban Outfitters Assessing how well a company's strategy is presently working involves evaluating the strategy from both a qualitative standpoint and a quantitative standpoint. The stronger a company's current overall performance, the less likely the need for radical strategy changes. The weaker a company's performance, the more its current strategy must be questioned. Table 4.1 provides a compilation of the financial ratios most commonly used to evaluate a company's financial performance and balance sheet...
2G Help Save Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings for the year ended December 31, 20XX and Comparative Balance Sheets for 20XW and 20XX of Maris Corporation: Maris Corporation Income Statement Year Ended December 31, 20xx Sales $5,500,000 Cost of goods sold 3,725,000 Gross profits Selling and administrative expense Amortization expense 1,775,000 710,000 230,000 Operating income Interest expense 835,000 50,000 Earnings before taxes Taxes 785,000 470.000 315,000 Earnings after taxes...
The financial statements of Carla Vista Inc. are presented here: CARLA VISTA INC. Income Statement Year Ended December 31, 2021 Service revenue $2,171,500 Expenses Operating expenses $1,885,500 Interest expense 95,000 1,980,500 Income before income tax 191,000 Income tax expense 40,000 Net income $151,000 CARLA VISTA INC. Statement of Financial Position December 31, 2021 Assets Current assets Cash $62,100 Trading investments 51,000 Accounts receivable 263,800 Supplies 25,000 Property, plant, and equipment Total assets $401,900 591,300 $993,200 $136,500 Liabilities and Shareholders' Equity...