Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Ratios Companies Ratio Formula Kohls Dollar General Ross Stores ULTA Beauty The Gap Accounts Receivable Turnover Sales/Avg. AR Days Sales Outstanding (DSO) Avg. AR/(Sales/365) Inventory Turnover Cost...

1 answer below »
Ratios
                    Companies
    Ratio        Formula        Kohls    Dollar General    Ross Stores    ULTA Beauty    The Gap
    Accounts Receivable Turnover        Sales/Avg. AR
    Days Sales Outstanding (DSO)        Avg. AR/(Sales/365)
    Inventory Turnover        Cost of Goods Sold/Avg. Inventory
    Days Sales On-hand (DOH)        Avg. Inventory/(CGS/365)
    Accounts Payable Turnover        CGS/Avg. AP
    Days Payable Outstanding (DPO)        Avg. AP/(CGS/365)
    Cash Conversion Cycle        DSO+DOH-DPO
    Return on Assets        Operating Income/Avg. Assets
    Profitability for ROA        Operating Income/Sales
    Asset Turnover        Sales/Avg. Assets
    Return on Equity        Consolidated Net Income/Avg. Equity
    Profitability for ROE        NI/Sales
    Asset Turnover        Sales/Avg. Assets
    Leverage        Avg. Assets/Avg. Equity
Kohls Balance Sheet
    CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions    Jan. 30, 2021    Feb. 01, 2020
    Cu
ent assets:
    Cash and cash equivalents    $ 2,271    $ 723
    Merchandise inventories    2,590    3,537
    Other    974    389
    Total cu
ent assets    5,835    4,649
    Property and equipment, net    6,689    7,352
    Operating leases    2,398    2,391
    Other assets    415    163
    Total assets    15,337    14,555
    Cu
ent liabilities:
    Accounts payable    1,476    1,206
    Accrued liabilities    1,270    1,281
    Cu
ent portion of:
    Finance lease and financing obligations    115    124
    Operating leases    161    158
    Total cu
ent liabilities    3,022    2,769
    Long-term debt    2,451    1,856
    Finance lease and financing obligations    1,387    1,367
    Operating leases    2,625    2,619
    Defe
ed income taxes    302    260
    Other long-term liabilities    354    234
    Shareholders’ equity:
    Common stock - 377 and 375 million shares issued    4    4
    Paid-in capital    3,319    3,272
    Treasury stock, at cost, 219 and 219 million shares    (11,595)    (11,571)
    Retained earnings    13,468    13,745
    Total shareholders’ equity    5,196    5,450
    Total liabilities and shareholders’ equity    $ 15,337    $ 14,555
    [1]
Kohls Income Statement
    CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) $ in Millions    12 Months Ended
        Jan. 30, 2021    Feb. 01, 2020    Feb. 02, 2019
    Total revenue    $ 15,955    $ 19,974    $ 20,229
    Cost of merchandise sold    $ 10,360    $ 12,140    $ 12,199
    Operating expenses:
    Selling, general, and administrative    $ 5,021    $ 5,705    $ 5,601
    Depreciation and amortization    874    917    964
    Impairments, store closing, and other costs    89    113    104
    (Gain) on sale of real estate    (127)
    Operating (loss) income    (262)    1,099    1,361
    Interest expense, net    284    207    256
    (Gain) loss on extinguishment of debt        (9)    63
    (Loss) income before income taxes    (546)    901    1,042
    (Benefit) provision for income taxes    (383)    210    241
    Net (loss) income    $ (163)    $ 691    $ 801
    Net (loss) income per share:
    Basic    $ (1.06)    $ 4.39    $ 4.88
    Diluted    $ (1.06)    $ 4.37    $ 4.84
Dollar General Balance Sheet
    CONSOLIDATED BALANCE SHEETS - USD ($) $ in Thousands    Jan. 29, 2021    Jan. 31, 2020
    Cu
ent assets:
    Cash and cash equivalents    $ 1,376,577    $ 240,320
    Merchandise inventories    5,247,477    4,676,848
    Income taxes receivable    90,760    76,537
    Prepaid expenses and other cu
ent assets    199,405    184,163
    Total cu
ent assets    6,914,219    5,177,868
    Net property and equipment    3,899,997    3,278,359
    Operating lease assets    9,473,330    8,796,183
    Goodwill    4,338,589    4,338,589
    Other intangible assets, net    1,199,870    1,200,006
    Other assets, net    36,619    34,079
    Total assets    25,862,624    22,825,084
    Cu
ent liabilities:
    Cu
ent portion of operating lease liabilities    1,074,079    964,805
    Accounts payable    3,614,089    2,860,682
    Accrued expenses and other    1,006,552    709,156
    Income taxes payable    16,063    8,362
    Total cu
ent liabilities    5,710,783    4,543,005
    Long-term obligations    4,130,975    2,911,993
    Long-term operating lease liabilities    8,385,388    7,819,683
    Defe
ed income taxes    710,549    675,227
    Other liabilities    263,691    172,676
    Commitments and contingencies         
    Shareholders' equity:
    Prefe
ed stock         
    Common stock; $0.875 par value, 1,000,000 shares authorized, 240,785 and 251,936 shares issued and outstanding at January 29, 2021 and January 31, 2020, respectively    210,687    220,444
    Additional paid-in capital    3,446,612    3,322,531
    Retained earnings    3,006,102    3,162,660
    Accumulated other comprehensive loss    (2,163)    (3,135)
    Total shareholders' equity    6,661,238    6,702,500
    Total liabilities and shareholders' equity    $ 25,862,624    $ 22,825,084
Ross Stores Balance Sheet
    Consolidated Balance Sheets - USD ($) $ in Thousands    Jan. 30, 2021    Feb. 01, 2020
    Cu
ent Assets
    Cash and cash equivalents    $ 4,819,293    $ 1,351,205
    Accounts receivable    115,067    102,236
    Merchandise inventory    1,508,982    1,832,339
    Prepaid expenses and other    249,149    147,048
    Total cu
ent assets    6,692,491    3,432,828
    Property and Equipment
    Land and buildings    1,187,045    1,177,262
    Fixtures and equipment    3,243,206    3,115,003
    Leasehold improvements    1,278,134    1,219,736
    Construction-in-progress    376,076    189,536
    Property and equipment, gross    6,084,461    5,701,537
    Less accumulated depreciation and amortization    3,373,965    3,048,101
    Property and equipment, net    2,710,496    2,653,436
    Operating lease assets    3,084,819    3,053,782
    Other long-term assets    230,061    208,321
    Total assets    12,717,867    9,348,367
    Cu
ent Liabilities
    Accounts payable    2,256,928    1,296,482
    Accrued expenses and other    592,122    462,111
    Cu
ent operating lease liabilities    598,120    564,481
    Accrued payroll and benefits    400,273    364,435
    Income taxes payable    54,680    14,425
    Cu
ent portion of long-term debt    64,910    0
    Total cu
ent liabilities    3,967,033    2,701,934
    Long-term debt    2,448,175    312,891
    Non-cu
ent operating lease liabilities    2,621,594    2,610,528
    Other long-term liabilities    268,558    214,086
    Defe
ed income taxes    121,867    149,679
    Commitments and contingencies         
    Stockholders’ Equity
    Common stock, par value $.01 per share, Authorized 1,000,000,000 shares, issued and outstanding 356,503,000 and 356,775,000 shares, respectively    3,565    3,568
    Additional paid-in capital    1,579,824    1,458,307
    Treasury stock    (478,550)    (433,328)
    Retained earnings    2,185,801    2,330,702
    Total stockholders’ equity    3,290,640    3,359,249
    Total liabilities and stockholders’ equity    $ 12,717,867    $ 9,348,367
Ross Stores Income Statement
    Consolidated Statements of Earnings - USD ($) shares in Thousands, $ in Thousands    12 Months Ended
        Jan. 30, 2021    Feb. 01, 2020    Feb. 02, 2019
    Income Statement [Abstract]
    Sales    $ 12,531,565    $ 16,039,073    $ 14,983,541
    Costs and Expenses
    Cost of goods sold    9,838,574    11,536,187    10,726,277
    Selling, general and administrative    2,503,281    2,356,704    2,216,550
    Interest expense (income), net    83,413    (18,106)    (10,162)
    Total costs and expenses    12,425,268    13,874,785    12,932,665
    Earnings before taxes    106,297    2,164,288    2,050,876
    Provision for taxes on earnings    20,915    503,360    463,419
    Net earnings    $ 85,382    $ 1,660,928    $ 1,587,457
    Earnings per share
    Basic (in dollars per share)    $ 0.24    $ 4.63    $ 4.30
    Diluted (in dollars per share)    $ 0.24    $ 4.60    $ 4.26
    Weighted-average shares outstanding (000)
    Basic (in shares)    352,392    358,462    369,533
    Diluted (in shares)    354,619    361,182    372,678
ULTA Balance Sheet
    Consolidated Balance Sheets - USD ($) $ in Thousands    Jan. 30, 2021    Feb. 01, 2020
    Cu
ent assets:
    Cash and cash equivalents    $ 1,046,051    $ 392,325
    Short-term investments        110,000
    Receivables, net    193,109    139,337
    Merchandise inventories, net    1,168,215    1,293,701
    Prepaid expenses and other cu
ent assets    107,402    103,567
    Prepaid income taxes        16,387
    Total cu
ent assets    2,514,777    2,055,317
    Property and equipment, net    995,795    1,205,524
    Operating lease assets    1,504,614    1,537,565
    Goodwill    10,870    10,870
    Other intangible assets, net    2,465    3,391
    Defe
ed compensation plan assets    33,223    27,849
    Other long-term assets    28,225    23,356
    Total assets    5,089,969    4,863,872
    Cu
ent liabilities:
    Accounts payable    477,052    414,009
    Accrued liabilities    296,334    246,088
    Defe
ed revenue    274,383    237,535
    Cu
ent operating lease liabilities    253,415    239,629
    Accrued income taxes    42,529
    Total cu
ent liabilities    1,343,713    1,137,261
    Non-cu
ent operating lease liabilities    1,643,386    1,698,718
    Defe
ed income taxes    65,359    89,367
    Other long-term liabilities    37,962    36,432
    Total liabilities    3,090,420    2,961,778
    Commitments and contingencies (Note 11)         
    Stockholders' equity:
    Common stock, $0.01 par value, 400,000 shares authorized; 56,952 and 57,285 shares issued; 56,260 and 56,609 shares outstanding; at January 30, 2021 and Fe
uary 1, 2020, respectively    569    573
    Treasury stock-common, at cost    (37,801)    (34,448)
    Additional paid-in capital    847,303    807,492
    Retained earnings    1,189,422    1,128,477
    Accumulated other comprehensive income    56
    Total stockholders' equity    1,999,549    1,902,094
    Total liabilities and stockholders' equity    $ 5,089,969    $ 4,863,872
Dollar General Income Statement
    CONSOLIDATED STATEMENTS OF INCOME - USD ($) shares in Thousands, $ in Thousands    12 Months Ended
        Jan. 29, 2021    Jan. 31, 2020    Feb. 01, 2019
    CONSOLIDATED STATEMENTS OF INCOME
    Net sales    $ 33,746,839    $ 27,753,973    $ 25,625,043
    Cost of goods sold    23,027,977    19,264,912    17,821,173
    Gross profit    10,718,862    8,489,061    7,803,870
    Selling, general and administrative expenses    7,164,097    6,186,757    5,687,564
    Operating profit    3,554,765    2,302,304    2,116,306
    Interest expense    150,385    100,574    99,871
    Other (income) expense            1,019
    Income before income taxes    3,404,380    2,201,730    2,015,416
    Income tax expense    749,330    489,175    425,944
    Net income    $ 2,655,050    $ 1,712,555    $ 1,589,472
    Earnings per share:
    Basic (in dollars per share)    $ 10.70    $ 6.68    $ 5.99
    Diluted (in dollars per share)    $ 10.62    $ 6.64    $ 5.97
    Weighted average shares outstanding:
    Basic (in shares)    248,171    256,553    265,155
    Diluted (in shares)    250,076    258,053    266,105
    Dividends per share    $ 1.44    $ 1.28    $ 1.16
GAP Balance Sheet
    CONSOLIDATED BALANCE SHEETS - USD ($) shares in Thousands, $ in Millions    Jan. 30, 2021    Feb. 01, 2020
    Cu
ent assets:
    Cash and Cash Equivalents, at Ca
ying Value    $ 1,988    $ 1,364
    Short-term Investments    410    290
    Merchandise inventory    2,451    2,156
    Other Assets, Cu
ent    1,159    706
    Total cu
ent assets    6,008    4,516
    Accumulated Depreciation, Depletion and Amortization, Property, Plant, and Equipment    5,608    5,839
    Property and equipment, net of accumulated depreciation    2,841    3,122
    Operating Lease, Right-of-Use Asset    4,217    5,402
    Other long-term assets    703    639
    Total assets    13,769    13,679
    Cu
ent liabilities:
    Accounts payable    1,743    1,174
    Accrued Liabilities, Cu
ent    1,276    1,067
    Operating Lease, Liability, Cu
ent    831    920
    Income taxes payable    34    48
    Total cu
ent liabilities    3,884    3,209
    Long-term liabilities:
    Long-term debt    2,216    1,249
    Operating Lease, Liability, Noncu
ent    4,617    5,508
    Other long-term liabilities    438    397
    Total long-term liabilities    7,271    7,154
    Stockholders' equity:
    Common stock $0.05 par value, Authorized 2,300 shares for all periods presented; Issued and Outstanding 371 and 378 shares    19    19
    Additional Paid in Capital    85    0
    Retained earnings    2,501    3,257
    Accumulated other comprehensive income    9    40
    Total stockholders' equity    2,614    3,316
    Total liabilities and stockholders' equity    $ 13,769    $ 13,679
    Common stock, par value (in dollars per share)    $ 0.05    $ 0.05
    Common stock, shares outstanding (in shares)    374,000    371,000
    Common stock, shares issued (in shares)    374,000    371,000
    Common stock, shares authorized (in shares)    2,300,000    2,300,000
GAP Income Statement
    CONSOLIDATED STATEMENTS OF INCOME - USD ($) shares in Millions    12 Months Ended
        Jan. 30, 2021    Feb. 01, 2020    Feb. 02, 2019
    Revenues    $ 13,800,000,000    $ 16,383,000,000    $ 16,580,000,000
    Cost of goods sold and occupancy expenses    9,095,000,000    10,250,000,000    10,258,000,000
    Gross profit    4,705,000,000    6,133,000,000    6,322,000,000
    Operating expenses    5,567,000,000    5,559,000,000    4,960,000,000
    Operating income (loss)    (862,000,000)    574,000,000    1,362,000,000
    Gain (Loss) on Extinguishment of Debt    58,000,000    0    0
    Interest expense    192,000,000    76,000,000    73,000,000
    Interest income    (10,000,000)    (30,000,000)    (33,000,000)
    Income (loss) before income taxes    (1,102,000,000)    528,000,000    1,322,000,000
    Income taxes    (437,000,000)    177,000,000    319,000,000
    Net income (loss)    $ (665,000,000)    $ 351,000,000    $ 1,003,000,000
    Weighted-average number of shares—basic (in shares)    374    376    385
    Weighted-average number of shares - diluted (in shares)    374    378    388
    Earnings per share - basic (in dollars per share)    $ (1.78)    $ 0.93    $ 2.61
    Earnings per share - diluted (in dollars per share)    $ (1.78)    $ 0.93    $ 2.59
Answered Same Day Nov 08, 2021

Solution

Ayushi answered on Nov 09 2021
125 Votes
Ratios
                    Companies
    Ratio        Formula        Kohls    Dollar General    Ross Stores    ULTA Beauty    The Gap
    Accounts Receivable Turnover        Sales/Avg. AR        23.4115920763    175.9627445459    115.3372479901    37.0102392569    14.7989276139
    Days Sales Outstanding (DSO)        Avg. AR/(Sales/365)        15.5905672203    2.0743027221    3.1646324701    9.8621356503    24.6639492754
    Inventory Turnover        Cost of Goods Sold/Avg. Inventory        3.381752897    4.6407140032    5.8890325114    3.4142464649    3.9483394834
    Days Sales On-hand (DOH)        Avg. Inventory/(CGS/365)        107.9321911197    78.651690181    61.9796204714    106.9049946298    92.4439252336
    Accounts Payable Turnover        CGS/Avg. AP        7.7255779269    7.1131402176    5.537539434    9.4332352106    6.235858759
    Days Payable Outstanding (DPO)        Avg. AP/(CGS/365)        47    51.3134830515    65.9137518303    38.6929819782    58.5324354041
    Cash Conversion Cycle        DSO+DOH-DPO        76.2771019693    29.4125098516    -0.7694988888    78.0741483018    58.5754391049
    Return on Assets        Operating Income/Avg. Assets        -0.0175297739    0.1460230989    0.017194597    0.0475836413    -0.0628096765
    Profitability for ROA        Operating Income/Sales        -0.0164211846    0.1053362361    0.0151385721    0.0384950925    -0.0624637681
    Asset Turnover        Sales/Avg. Assets        1.0675097016    1.3862570405    1.1358136599    1.2360962969    1.0055377441
    Return on Equity        Consolidated Net Income/Avg. Equity        -0.0306218298    0.3973513997    0.0256792256    0.0901338231    -0.2242833052
    Profitability for ROE        NI/Sales        -0.0102162332    0.0786755168    0.0068133549    0.0285819804    -0.0481884058
    Asset Turnover        Sales/Avg. Assets        1.0675097016    1.3862570405    1.1358136599    1.2360962969    1.0055377441
    Leverage        Avg. Assets/Avg. Equity        2.8078151418    3.6432701689    3.3182860646    2.5511921516    4.6286677909
Kohls Balance Sheet
    CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions    Jan. 30, 2021    Feb. 01, 2020
    Cu
ent assets:
    Cash and cash equivalents    $ 2,271    $ 723
    Merchandise inventories    2,590    3,537
    Other    974    389
    Total cu
ent assets    5,835    4,649
    Property and equipment, net    6,689    7,352
    Operating leases    2,398    2,391
    Other assets    415    163
    Total assets    15,337    14,555
    Cu
ent liabilities:
    Accounts payable    1,476    1,206
    Accrued liabilities    1,270    1,281
    Cu
ent portion of:
    Finance lease and financing obligations    115    124
    Operating leases    161    158
    Total cu
ent liabilities    3,022    2,769
    Long-term debt    2,451    1,856
    Finance lease and financing obligations    1,387    1,367
    Operating leases    2,625    2,619
    Defe
ed income taxes    302    260
    Other long-term liabilities    354    234
    Shareholders’ equity:
    Common stock - 377 and 375 million shares issued    4    4
    Paid-in capital    3,319    3,272
    Treasury stock, at cost, 219 and 219 million shares    (11,595)    (11,571)
    Retained earnings    13,468    13,745
    Total shareholders’ equity    5,196    5,450
    Total liabilities and shareholders’ equity    $ 15,337    $ 14,555
    [1]
Kohls Income Statement
    CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) $ in Millions    12 Months Ended
        Jan. 30, 2021    Feb. 01, 2020    Feb. 02, 2019
    Total revenue    $ 15,955    $ 19,974    $ 20,229
    Cost of merchandise sold    $ 10,360    $ 12,140    $ 12,199
    Operating expenses:
    Selling, general, and administrative    $ 5,021    $ 5,705    $ 5,601
    Depreciation and amortization    874    917    964
    Impairments, store closing, and other costs    89    113    104
    (Gain) on sale of real estate    (127)
    Operating (loss) income    (262)    1,099    1,361
    Interest expense, net    284    207    256
    (Gain) loss on extinguishment of debt        (9)    63
    (Loss) income before income taxes    (546)    901    1,042
    (Benefit) provision for income taxes    (383)    210    241
    Net (loss) income    $ (163)    $ 691    $ 801
    Net (loss) income per share:
    Basic    $ (1.06)    $ 4.39    $ 4.88
    Diluted    $ (1.06)    $ 4.37    $ 4.84
Dollar General Balance Sheet
    CONSOLIDATED BALANCE SHEETS - USD ($) $ in Thousands    Jan. 29, 2021    Jan. 31, 2020
    Cu
ent assets:
    Cash and cash equivalents    $ 1,376,577    $ 240,320
    Merchandise inventories    5,247,477    4,676,848
    Income taxes receivable    90,760    76,537
    Prepaid expenses and other cu
ent assets    199,405    184,163
    Total cu
ent assets    6,914,219    5,177,868
    Net property and equipment    3,899,997    3,278,359
    Operating lease assets    9,473,330    8,796,183
    Goodwill    4,338,589    4,338,589
    Other intangible assets, net    1,199,870    1,200,006
    Other assets, net    36,619    34,079
    Total assets    25,862,624    22,825,084
    Cu
ent liabilities:
    Cu
ent portion of operating lease...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here