Annalyze Financial ratios of retail industry
Common Size Income Statement | ||||
M | N | |||
Revenues | 100.00% | 100.00% | ||
COGS | 75.30% | 67.10% | ||
Gross Profit | 24.70% | 32.90% | ||
Operating Expenses: | ||||
SG&A | 17.90% | 22.50% | ||
Depreciation | 1.50% | 2.70% | ||
EBIT | 5.30% | 7.70% | ||
Non operative Income(Expenses) | 0.50% | 1.00% | ||
Interest Income(Expenses) | 1.06% | 0.00% | ||
Special Item Income(Expenses) | 0.00% | -0.20% | ||
EBT | 5.60% | 6.50% | ||
Income Tax Expense | 2.00% | 2.40% | ||
Net Income Continuing ops | 3.60% | 6.80% | ||
Common Size Balance Sheet | ||||
M | N | |||
Assets | ||||
Current Assets | ||||
Cash and Cash Equivalents | 4.60% | 7.00% | ||
Net Receivables | 1.40% | 17.00% | ||
Inventory | 24.50% | 16.70% | ||
Other Current Assets | 1.50% | 2.50% | ||
Total Current Assets | 32.00% | 43.10% | ||
PP&E | 57.00% | 52.20% | ||
Intangile Assets | 9.00% | 0.60% | ||
Other Assets | 2.00% | 4.00% | ||
Total Assets | 100.00% | 100.00% | ||
Liabilities | ||||
Current Liabilities | ||||
Accounts Payable | 18.00% | 17.90% | ||
Short/Current LT Debt | 6.50% | 1.60% | ||
Other CL | 10.10% | 5.10% | ||
Total Current Liabilities | 35.70% | 25.50% | ||
LT Debt | 19.70% | 28.00% | ||
Other Liabilities | 2.50% | 3.20% | ||
Deferred Tax | 1.00% | 3.00% | ||
Total Liabilities | 58.90% | 59.70% | ||
Stockholders' Equity | ||||
Common Stock | 41.10% | 40.30% | ||
Total Stockholder Equity | 41.10% | 40.30% | ||
Financial Ratios | |||||
M | N | ||||
Liquidity Ratios: | |||||
Current Ratio | Current Assets/Current Liabilities | 0.90 | 1.69 | ||
Quick Ratio | Cash + Accts. Rec./Current Liabilities | 0.21 | 1.04 | ||
Asset Management Ratios: | |||||
Inventory Turnover Ratio | Cost of Goods Sold/Inventory | 4.08 | 5.99 | ||
Days Inventory Outstanding (DIO) | Inventory/(COGS/365) | 118.76 | 90.84 | ||
Days Sales Outstanding (DSO) | Net Receivable/(Sales/365) | 5.11 | 62.05 | ||
Total Asset Turnover (TAT) | Total Sales/Total Assets | 1.00 | 1.00 | ||
Debt Management Ratios: | |||||
Debt Ratio | Total Liabilities/Total Assets | 59% | 60% | ||
Debt to Equity | Total Liabilities/Total Equity | 143% | 148% | ||
Days Payables Outstanding (DPO) | Trade Payable/(COGS/365) | 87.25 | 97.37 | ||
Interest Coverage (Times Interest Earned) | EBIT/Interest | 10.60 | 7.70 | ||
Profitability Ratios: | |||||
Gross Margin | Gross Profit/Net Sales | 25% | 33% |
Annalyze Financial ratios of retail industry EXHIBIT 1 I Common-Sized Financial Da Retail Assets Cash &...
I need to match these ten industries using Exhibit 3: For example, Electrical Utility is #8 and Retail Grocery is #7. Please help! Thanks. I have 7 confirmed these are: Each of the 10 publicly traded companies in Exhibit 3 is drawn from one of the following industries (listed below in random order): I have 7 confirmed these are: 1. Management consulting services 2. 3. Data processing and camera applications services 4. Electronic, aerospace, communication, sensor systems 5. Hospital and...
According to Case 06 Exhibit 6.1, what is Company P Operating Margin? Enter percentage, round to 2 decimal places. Retail Airlines A B Beer C D Computers E F Hospitality G H Newspaper I J Pharmaceuticals K L Power M N Assets % O P 72 25 35 5 25 8 30 103 2 16 25 Cash & ST Investments Receivables Inventory Current Assets-Other Current Assets-Total Net Property. Plant, & Equipment Long-Term Marketable Securities Goodwill & Intangibles Assets-Other Assets-Total 6...
Using the following balance sheet, prepare and analyze the common size balance sheet: Assets Liabilities and stockholders’ equity Current assets Current liabilities Cash 4 Accounts payable 28 Short term investments 9 Current portion of long term debt 12 Accounts receivable 32 Total current liabilities 40 Inventory 41 Prepaid expenses 2 Long term liabilities Deferred taxes, current 7 Long term debt 48 Total current assets 95 Total liabilities 88 Long term assets Stockholders equity Property & equipment 53 Common stock...
need to find the sale of equipment Veesperna Company Balance Sheet As at December 31 2018 2017 Assets Current Assets Cash Accounts Receivable Merchandise Inventory Total Current Assets Land Equipment Less: Accumulated Depreciation $-55,000 $-69,000 Total Assets $109,915 $75,100 $47,600 $29,900 $78,600 $46,500 $236,115 $151,500 $96,000 $103,000 $106,000 $139,000 $383,115 $324,500 Liabilities and Equity Liabilities Current Liabilities Accounts Payable Taxes Payable Total Current Liabilities Bonds Payable Total Liabilities Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and...
P 7-4 Kaufman Company's balance sheet follows. Assets Current assets Cash Short-term investments at cost (approximate market) Trade accounts receivable, less allowance of $1,590 Inventories at lower of cost (average method) or market: Finished merchandise Work in process, raw materials, and supplies $ 13,445 5,239 88,337 113.879 47,036 160,915 8,221 276,157 Prepaid expenses Total current assets Other assets: Receivables, advances, and other assets Intangibles Total other assets Property, plant, and equipment: Land Buildings Machinery and equipment 4,473 2,324 6,797 5,981...
(Analyzing common-size financial statements) Use the common-size financial statements found here: LOADING... to respond to your boss' request that you write up your assessment of the firm's financial condition. Specifically, write up a brief narrative that responds to the following questions: a. How much cash does Patterson have on hand relative to its total assets? b. What proportion of Patterson's assets has the firm financed using short-term debt? Long-term debt? c. What percent of Patterson's revenues does the firm have...
i need it as soon as possiblemplease Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2017-2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Sales $2,516 $2,204 $2,295 $1,838 $1,715 $1,595 $1,307 Cost of goods sold 1,809 1,471 1,266 1,108 1,029 9 63 767 Gross profit 707 733 739730686632 540 Operating expenses 539 422 387 285 244 203 Net income $ 168 $ 311 $ 352 $ 445 $...
Light Touch Balance Sheets (in $000s) As At December 31 20Y3 20Y2 20Y1 ASSETS Current assets Cash 0 600 2,158 Accounts receivable 2,454 1,440 Inventory 3,480 3,168 2,500 Prepaid expenses 416 240 302 400 Other current assets 224 180 Total current assets 6,574 5,746 5,242 Fixed assets 2,030 1,542 1,470 Other noncurrent assets 640 420 428 TOTAL ASSETS 9,244 7,708 7,140 LIABILITIES AND EQUITY Current liabilities Short-term debt $ 604 20 0 Current portion-LTD Accounts payable 400 400 400 1,672...
Common-Size Balance Sheet Cash and marketable securities Accounts receivable Inventory Total current assets Net property, plant, and equipment Total assets Accounts payable 2016 470 5,990 9,550 16,010 17,000 33,010 7,150 1.4 % 18.1 28.9 48.5 % 51.5 100.0 % 21.7 % Short-term notes Total current liabilities Long-term liabilities Total liabilities Total common shareholders' equity Total liabilities and shareholders' equity 6,750 13,900 6,950 20,850 12,160 33,010 20.4 42.1 % 21.1 63.2 % 36.8 100.0 % $ Common-Size Income Statement 2016 100.0...
Create Statement of Cash Flows for 2xx2 Do CASH FLOW Statement Class Company, Inc. SS Assets: Current Assets: Cash Accounts Receivable Prepaid Expenses Other Current Assets Total Current Assets: Balance Sheet as of 12/31/2xxl 12/31/2xx2 Ss 440,000 892,100 322,000 402,000 30,000 52,000 15,000 26.000 807,000 1,372,100 Plant Property & Equipment Accumulated Depreciation Net Plant Property & Equipment 1,000,000 410,000 590,000 1,300,000 470,000 830,000 Amortization here Other Non-Current Assets: Intangibles Deferred Loan Placement Costs Other Non-Current assets Total Other Non-Current Assets...