Question

EXHIBIT 1 I Common-Sized Financial Da Retail Assets Cash & Short-Term Investments Receivables nventories Current Assets-Other Current Assets-Total Net Fixed Assets Assets-Other Intangibles Investments & Advances Assets-Total 4.6 7.0 1.4 17.0 24.5 16.7 1.5 2.5 32.0 43.1 57.0 52.2 2.0 4.0 9.0 0.6 0.0 0.0 100.0 100.0 Liabilities & Equity Accounts Payable Debt in Current Liabilities Income Taxes Payable Current Liabilities-Other Current Liabilities-Total LT Debt Deferred Taxes Liabilities-Other Liabilities-Total Stockholders Equity Total Liabilities & Equity 18.0 17.9 6.5 1.6 1.1 0.9 10.1 5.1 35.7 25.5 19.7 28.0 nmf 3.0 2.5 3.2 58.9 59.7 41.1 40.3 100.0 100.0 Income/Expenses Sales-Net Cost of Goods Sold Gross Profit SG&A Expense Depreciation Earnings Before Interest &Taxes Nonoperating Income (Expense) 0.5 1.0 Interest Income (Expense) Special Items-Income (Expense) Pretax Income 100.0 100.0 75.3 67.1 24.7 32.9 17.9 22.5 1.5 2.7 5.3 7.7 0.8 0.0 0.0 (0.2) 5.6 6.5 2.0 2.4 Income Taxes-Total Net Income (Loss) 3.6 6.8Retailing Companies M and N are two large discount retailers. One firm carries a wide variety for its low readth of merchandise, and volume-oriented strategy. Most of its stores are of nationally advertised general merchandise. The company is known leased and are located near the companys expanding network of distribution centers The company has begun to implement plans to expand both internationally and in large urban areas. The other firm is a rapidly growing chain of upscale discount stores. The company competes by attempting to match other discounters prices on similar merchandise and by offering deep discounts on its differentiated items. Additionally, the company has partnerships with several leading designers. Recently, the firm has divested several rt Two Financia ondiscount department-store businesses. To support sales and earnings gr company offers credit to qualified customers.

Annalyze Financial ratios of retail industry

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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%
Add a comment
Know the answer?
Add Answer to:
Annalyze Financial ratios of retail industry EXHIBIT 1 I Common-Sized Financial Da Retail Assets Cash &...
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
  • I need to match these ten industries using Exhibit 3: For example, Electrical Utility is #8 and Retail Grocery is #7. Pl...

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

    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    &nb...

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

  • Veesperna Company Balance Sheet As at December 31 2018 2017 Assets Current Assets Cash Accounts R...

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

    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​...

    ​(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...

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

    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,...

    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:...

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

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