Scribd Logo
Upload

Welcome to Scribd!

  • 42 views

    Consolidated Balance Sheets

    Uploaded by

    Carlos Manuel Cabrera
    This document contains the consolidated balance sheets and income statements for Vertic for 2019, 2018, 2017 and 2016. The balance sheet shows that in 2019 Vertic had total assets of $219 billion consisting mostly of property and equipment (85%) and goodwill (14%). Total liabilities were $139 billion, consisting mainly of current liabilities (35%) and long-term debt (20%). Total equity was $80 billion. The income statement shows that in 2019 Vertic had revenues of $514 billion and net income of $7 billion. Net sales accounted for most revenues (75%) while costs of sales represented the largest expense (75%). Operating income was $22 billion or 4% of total revenues.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Consolidated Balance Sheets

    Uploaded by

    Carlos Manuel Cabrera
    42 views8 pages
    This document contains the consolidated balance sheets and income statements for Vertic for 2019, 2018, 2017 and 2016. The balance sheet shows that in 2019 Vertic had total assets of $219 billion consisting mostly of property and equipment (85%) and goodwill (14%). Total liabilities were $139 billion, consisting mainly of current liabilities (35%) and long-term debt (20%). Total equity was $80 billion. The income statement shows that in 2019 Vertic had revenues of $514 billion and net income of $7 billion. Net sales accounted for most revenues (75%) while costs of sales represented the largest expense (75%). Operating income was $22 billion or 4% of total revenues.

    Original Description:

    En este archivo podras encontrar calculos y ejemplos de razones financieras de walmart.

    Original Title

    Walmart EEFF

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains the consolidated balance sheets and income statements for Vertic for 2019, 2018, 2017 and 2016. The balance sheet shows that in 2019 Vertic had total assets of $219 billion consisting mostly of property and equipment (85%) and goodwill (14%). Total liabilities were $139 billion, consisting mainly of current liabilities (35%) and long-term debt (20%). Total equity was $80 billion. The income statement shows that in 2019 Vertic had revenues of $514 billion and net income of $7 billion. Net sales accounted for most revenues (75%) while costs of sales represented the largest expense (75%). Operating income was $22 billion or 4% of total revenues.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    42 views8 pages

    Consolidated Balance Sheets

    Uploaded by

    Carlos Manuel Cabrera
    This document contains the consolidated balance sheets and income statements for Vertic for 2019, 2018, 2017 and 2016. The balance sheet shows that in 2019 Vertic had total assets of $219 billion consisting mostly of property and equipment (85%) and goodwill (14%). Total liabilities were $139 billion, consisting mainly of current liabilities (35%) and long-term debt (20%). Total equity was $80 billion. The income statement shows that in 2019 Vertic had revenues of $514 billion and net income of $7 billion. Net sales accounted for most revenues (75%) while costs of sales represented the largest expense (75%). Operating income was $22 billion or 4% of total revenues.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 8

    Consolidated Balance Sheets Vertic

    Monto en millones USD 2019 %


    ASSETS

    Current assets:
    Cash and cash equivalents 7,722 4%
    Receivables, net 6,283 3%
    Inventories 44,269 20%
    Prepaid expenses and other 3,623 2%
    Total current assets 61,897 28%

    Property and equipment:


    Property and equipment 185,810 85%
    Less accumulated depreciation (81,493) -37%
    Property and equipment, net 104,317 48%

    Property under capital lease and financing obligations:


    Property under capital lease and financing obligations 12,760 6%
    Less accumulated amortization (5,682) -3%
    Property under capital lease and financing obligations, net 7,078 3%

    Goodwill 31,181 14%


    Other assets and deferred charges 14,822 7%
    Total assets 219,295 100%

    LIABILITIES AND EQUITY 2019 %


    Current liabilities:
    Short-term borrowings 5,225 2%
    Accounts payable 47,060 21%
    Accrued liabilities 22,159 10%
    Accrued income taxes 428 0%
    Long-term debt due within one year 1,876 1%
    Capital lease and financing obligations due within one year 729 0%
    Total current liabilities 77,477 35%

    Long-term debt 43,520 20%


    Long-term capital lease and financing obligations 6,683 3%
    Deferred income taxes and other 11,981 5%
    Total long-term liabilities 62,184 28%
    Equity:
    Common stock 288 0%
    Capital in excess of par value 2,965 1%
    Retained earnings 80,785 37%
    Accumulated other comprehensive loss (11,542) -5%
    Total Walmart shareholders’ equity 72,496 33%
    noncontrolling interest 7,138 3%
    Total equity 79,634 36%
    Total liabilities and equity 219,295 100%

    Consolidated Statements of Income


    Monto en millones USD 2019
    Revenues:
    Net sales 510,329
    Membership and other income 4,076
    Total revenues 514,405 100%
    Costs and expenses:
    Cost of sales 385,301 75%
    Operating, selling, general and administrative expenses 107,147 21%
    Operating income (UAII) 21,957 4%
    Interest:
    Debt (1,975) 0%
    Capital lease and financing obligations (371) 0%
    Interest income 217 0%
    Interest, net (2,129) 0%
    Loss on extinguishment of debt - 0%
    Other (gains) and losses (8,368) -2%
    Income from before income taxes 11,460 2%
    Provision for income taxes 4,281 1%
    Consolidated net income 7,179 1%
    Consolidated net income attributable to noncontrolling interest (509) 0%
    Consolidated net income attributable to Walmart 6,670 1%

    Compras 269,711

    i= Provision for income taxes / Income from before taxes 37.36%


    Vertical Horizontal
    2018 % 2017 % 2016 % 2019 2018

    6,756 3% 6,867 3% 8,705 4% 14% -2%


    5,614 3% 5,835 3% 5,624 3% 12% -4%
    43,783 21% 43,046 22% 44,469 22% 1% 2%
    3,511 2% 1,941 1% 1,441 1% 3% 81%
    59,664 29% 57,689 29% 60,239 30% 4% 3%

    185,154 91% 179,492 90% 176,958 89% 0% 3%


    (77,479) -38% (71,782) -36% (66,787) -33% 5% 8%
    107,675 53% 107,710 54% 110,171 55% -3% 0%

    12,703 6% 11,637 6% 11,096 6% 0% 9%


    (5,560) -3% (5,169) -3% (4,751) -2% 2% 8%
    7,143 3% 6,468 3% 6,345 3% -1% 10%

    18,242 9% 17,037 9% 16,695 8% 71% 7%


    11,798 6% 9,921 5% 6,131 3% 26% 19%
    204,522 100% 198,825 100% 199,581 100% 7% 3%

    2018 % 2017 % 2016 % 2019 2018

    5,257 3% 1,099 1% 2,708 1% -1% 378%


    46,092 23% 41,433 21% 38,487 19% 2% 11%
    22,122 11% 20,654 10% 19,607 10% 0% 7%
    645 0% 921 0% 521 0% -34% -30%
    3,738 2% 2,256 1% 2,745 1% -50% 66%
    667 0% 565 0% 551 0% 9% 18%
    78,521 38% 66,928 34% 64,619 32% -1% 17%

    30,045 15% 36,015 18% 38,214 19% 45% -17%


    6,780 3% 6,003 3% 5,816 3% -1% 13%
    8,354 4% 9,344 5% 7,321 4% 43% -11%
    45,179 22% 51,362 26% 51,351 26% 38% -12%

    295 0% 305 0% 317 0% -2% -3%


    2,648 1% 2,371 1% 1,805 1% 12% 12%
    85,107 42% 89,354 45% 90,021 45% -5% -5%
    (10,181) -5% (14,232) -7% (11,597) -6% 13% -28%
    77,869 38% 77,798 39% 80,546 40% -7% 0%
    2,953 1% 2,737 1% 3,065 2% 142% 8%
    80,822 40% 80,535 41% 83,611 42% -1% 0%
    204,522 100% 198,825 100% 199,581 100% 7% 3%

    0 0 0

    2018 2017 2016 2019 2018

    495,761 481,317 478,614 3% 3%


    4,582 4,556 3,516 -11% 1%
    500,343 100% 485,873 100% 482,130 100% 3% 3%

    373,396 75% 361,256 74% 360,984 75% 3% 3%


    106,510 21% 101,853 21% 97,041 20% 1% 5%
    20,437 4% 22,764 5% 24,105 5% 7% -10%

    (1,978) 0% (2,044) 0% (2,027) 0% 0% -3%


    (352) 0% (323) 0% (521) 0% 5% 9%
    152 0% 100 0% 81 0% 43% 52%
    (2,178) 0% (2,267) 0% (2,467) -1% -2% -4%
    (3,136) -1% 0% 0% -100%
    - 0% 0% 0%
    15,123 3% 20,497 4% 21,638 4% -24% -26%
    4,600 1% 6,204 1% 6,558 1% -7% -26%
    10,523 2% 14,293 3% 15,080 3% -32% -26%
    (661) 0% (650) 0% (386) 0% -23% 2%
    9,862 2% 13,643 3% 14,694 3% -32% -28%

    261,377 252,879 252,689

    30.42% 30.27% 30.31%


    Horizontal
    2017

    -21%
    4%
    -3%
    35%
    -4%

    1%
    7%
    -2%

    5%
    9%
    2%

    2%
    62%
    0%

    2017

    -59%
    8%
    5%
    77%
    -18%
    3%
    4%

    -6%
    3%
    28%
    0%

    -4%
    31%
    -1%
    23%
    -3%
    -11%
    -4%
    0%

    2017

    1%
    30%
    1%

    0%
    5%
    -6%

    1%
    -38%
    23%
    -8%

    -5%
    -5%
    -5%
    68%
    -7%
    RAZONES FINANCIERAS

    2019 2018
    Acciones 2,878 2,952
    Precio de mercado por acción común 95.83 106.6

    Liquidez
    Líquidez corriente 0.80 0.76
    Razón rápida 0.23 0.20

    Actividad
    Rotación de inventario 8.70 8.53
    Periodo promedio de cobro 14.98 13.78
    Periodo promedio de pago 63.69 64.37
    Rotación de activos totales 2.35 2.45

    Endeudamiento
    Endeudamiento 63.69% 60.48%
    Razon de cargo de interes fijo 9.36 8.77
    Indice de cobertura de pagos fijos

    Rentabilidad
    Margen utilidad bruta 24.5% 24.7%
    Margen utilidad operativa 4.3% 4.1%
    Margen utilidad neta 1.3% 2.0%
    Ganancias por acción 2.32 3.34
    Roa 3.0% 4.8%
    Roe 8.4% 12.2%

    Mercado
    Relación precio ganancia 41.35 31.91
    Valor en libros 27.67 27.38
    Razón de mercado 3.46 3.89

    MAF 2.75 2.53


    Roe 8.4% 12.2%
    S

    2017 2016
    3,048 3,162
    66.74 66.36

    0.86 0.93
    0.22 0.24

    8.39 8.12
    14.75 14.30
    59.80 55.59
    2.44 2.42

    59.49% 58.11%
    9.62 9.46

    24.9% 24.6%
    4.7% 5.0%
    2.8% 3.1%
    4.48 4.65
    6.9% 7.4%
    16.9% 17.6%

    14.91 14.28
    26.42 26.44
    2.53 2.51

    2.47 2.39
    16.9% 17.6%

    You might also like