Grupo Palacio de Hierro, S.A.B. de C.V.

Balance Sheet
In Millions of the reported currency, except per share items. Template: Standard
Period Type: Annual
Currency: Reported Currency
Units: S&P Capital IQ (Default
Source: Capital IQ & Proprietar

Balance Sheet
Balance Sheet as of:
Dec-31-2017 Dec-31-2018
Currency MXN MXN
ASSETS
Cash And Equivalents 4,207.1 5,385.8
Total Cash & ST Investments 4,207.1 5,385.8

Accounts Receivable 3,982.2 4,590.9

Other Receivables 1,065.6 868.9
Total Receivables 5,047.8 5,459.8

Inventory 4,616.6 5,124.2

Other Current Assets 264.5 174.3
14,136.1 16,144.1

Gross Property, Plant & Equipment 18,387.9 20,181.7

Accumulated Depreciation (3,868.6) (4,641.1)
Net Property, Plant & Equipment 14,519.3 15,540.5

Long-term Investments 438.9 401.3

Other Intangibles 511.0 573.6
Accounts Receivable Long-Term 4,586.0 4,781.2
Deferred Tax Assets, LT 466.6 321.1
Deferred Charges, LT 787.3 671.5
Other Long-Term Assets 1,297.9 1,456.2
Total Assets 36,743.0 39,889.4

LIABILITIES
Accounts Payable 5,657.0 6,919.0
Accrued Exp. 320.2 292.1
Short-term Borrowings 451.9 -
Curr. Port. of LT Debt 581.4 1,061.4
Curr. Port. of Leases - -
Curr. Income Taxes Payable 879.3 1,267.2
Unearned Revenue, Current 659.0 704.8
Other Current Liabilities 942.3 862.7
Total Current Liabilities 9,491.1 11,107.1

Long-Term Debt 5,074.5 4,039.4

Long-Term Leases - -
Pension & Other Post-Retire. Benefits 992.5 557.3
Def. Tax Liability, Non-Curr. 877.4 990.1
Other Non-Current Liabilities 276.6 206.8
Total Liabilities 16,712.2 16,900.5

Common Stock 1,965.6 1,965.6

Additional Paid In Capital 2,636.2 2,636.2
Retained Earnings 14,634.9 17,601.4
Treasury Stock - -
Comprehensive Inc. and Other 185.4 219.8
Total Common Equity 19,422.1 22,423.0
Minority Interest 608.8 565.8

Total Equity 20,030.9 22,988.8

Total Liabilities And Equity 36,743.0 39,889.4

Note: For multiple class companies, total share counts are primary class equivalent, and for foreign companies listed as primary ADRs, total share counts a
  Restatement: Latest Filings
  Order: Latest on Right
  Conversion: Historical
  Decimals: Capital IQ (Default)
 

Reclassified
Dec-31-2019 Dec-31-2020 Dec-31-2021 Jun-30-2022
MXN MXN MXN MXN

4,516.1 6,386.2 6,088.5 4,906.3

4,516.1 6,386.2 6,088.5 4,906.3

4,559.7 3,210.4 4,915.9 5,231.0

1,572.0 1,044.9 753.8 2,227.0
6,131.7 4,255.3 5,669.7 7,458.0

5,163.8 4,536.0 4,695.7 5,192.4

70.6 46.6 64.9 296.5
15,882.2 15,224.1 16,518.9 17,853.1

25,125.1 26,707.6 28,750.3 19,691.0

(6,067.5) (7,605.6) (9,353.2) (132.2)
19,057.6 19,102.0 19,397.1 19,558.8

159.7 167.5 320.8 1,607.9

516.8 723.1 1,122.0 1,280.7
5,238.8 4,199.5 4,013.4 2,694.9
230.4 280.9 152.2 143.3
1,078.1 1,120.8 919.0 765.2
1,565.8 1,930.3 1,849.4 10.4
43,729.4 42,748.3 44,292.7 43,914.3

6,339.6 6,313.0 7,482.4 4,739.6

222.4 255.4 507.3 253.9
- - - -
400.7 - 5.6 3.9
- 587.8 613.1 580.6
1,353.5 984.1 843.9 2,074.0
657.5 667.3 639.1 -
524.1 765.5 1,174.1 2,712.6
9,497.9 9,573.0 11,265.4 10,364.6

6,492.8 7,510.3 7,504.7 7,503.4

1,988.1 1,699.6 1,842.7 1,562.3
581.4 593.9 388.3 -
1,111.0 389.2 485.9 631.8
152.8 138.1 122.9 428.2
19,823.9 19,904.1 21,609.9 20,490.3

1,965.6 1,965.6 1,965.6 1,965.6

2,636.2 2,636.2 2,636.2 2,636.2
18,727.7 17,738.6 17,554.2 17,963.1
- - - -
2.2 (59.4) (13.4) 354.2
23,331.7 22,281.0 22,142.7 22,919.1
 573.8 563.1 540.2 504.9

23,905.5 22,844.1 22,682.9 23,424.0

43,729.4 42,748.3 44,292.7 43,914.3

panies listed as primary ADRs, total share counts are ADR-equivalent.

Grupo Palacio de Hierro, S.A.B. de C.V. Income Statement
In Millions of the reported currency, except per share items. Template: Standard  
Period Type: Annual  
Currency: Reported Currency  
Units: S&P Capital IQ (Default 
Source: Capital IQ & Proprietar  

Income Statement

Reclassified Reclassified Reclassified

For the Fiscal Period Ending 12 months 12 months 12 months
Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency MXN MXN MXN

Revenue 29,103.9 30,401.8 31,886.6

Other Revenue - - -
Total Revenue 29,103.9 30,401.8 31,886.6

Cost Of Goods Sold 20,932.6 21,751.0 23,286.1

Gross Profit 8,171.3 8,650.8 8,600.5

Selling General & Admin Exp. 7,469.2 8,546.2 8,674.4

R & D Exp. - - -
Depreciation & Amort. 1,085.1 - -
Other Operating Expense/(Income) (177.9) (1,099.1) (891.7)

Other Operating Exp., Total 8,376.5 7,447.2 7,782.6

Operating Income (205.2) 1,203.7 817.9

Interest Expense (444.6) (417.9) (497.2)

Interest and Invest. Income 1,445.0 1,595.4 1,878.8
Net Interest Exp. 1,000.4 1,177.5 1,381.6

Income/(Loss) from Affiliates 133.6 (23.5) 242.8

Currency Exchange Gains (Loss) (132.3) (83.5) (49.1)
Other Non-Operating Inc. (Exp.) 1,459.2 1,921.2 1,207.6
EBT Excl. Unusual Items 2,255.8 4,195.3 3,600.7

Impairment of Goodwill - - -
Asset Writedown (249.7) (62.9) 129.0
Other Unusual Items - - -
EBT Incl. Unusual Items 2,006.1 4,132.4 3,729.7

Income Tax Expense 259.9 1,128.7 1,030.7

Earnings from Cont. Ops. 1,746.2 3,003.7 2,699.1

Earnings of Discontinued Ops. - - -

Extraord. Item & Account. Change - - -
Net Income to Company 1,746.2 3,003.7 2,699.1

Minority Int. in Earnings (34.9) (45.1) (37.4)

Net Income 1,711.3 2,958.6 2,661.7

Pref. Dividends and Other Adj. - - -

 NI to Common Incl Extra Items 1,711.3 2,958.6 2,661.7
NI to Common Excl. Extra Items 1,711.3 2,958.6 2,661.7

Per Share Items

Basic EPS 4.53 7.83 7.04
Basic EPS Excl. Extra Items 4.53 7.83 7.04
Weighted Avg. Basic Shares Out. 377.8 377.8 377.8

Diluted EPS 4.53 7.83 7.04

Diluted EPS Excl. Extra Items 4.53 7.83 7.04
Weighted Avg. Diluted Shares Out. 377.8 377.8 377.8

Normalized Basic EPS 3.64 6.82 5.86

Normalized Diluted EPS 3.64 6.82 5.86

Dividends per Share NA 3.92 NA

Payout Ratio % NA NA 55.6%

Supplemental Items
EBITDA 566.6 2,105.7 2,005.1
EBITA (205.2) 1,203.7 817.9
EBIT (205.2) 1,203.7 817.9
EBITDAR 1,050.1 2,627.0 NA
Effective Tax Rate % 13.0% 27.3% 27.6%
Current Domestic Taxes NA NA NA
Total Current Taxes 571.9 848.6 706.2
Deferred Domestic Taxes NA NA NA
Total Deferred Taxes (311.9) 218.5 306.2

Normalized Net Income 1,375.0 2,577.0 2,213.1

Interest Capitalized 2.4 5.0 120.7
Interest on Long Term Debt 446.9 422.9 617.9
Non-Cash Pension Expense (12.5) 3.2 9.6
Filing Date Apr-30-2019 Apr-30-2020 Apr-26-2021
Restatement Type RC RC RC
Calculation Type REP REP REP

Supplemental Operating Expense Items

Advertising Exp. 1.0 0.0 0.0
Selling and Marketing Exp. 631.1 0.0 0.0
General and Administrative Exp. 694.6 NA NA
Net Rental Exp. 483.4 521.4 NA
Imputed Oper. Lease Interest Exp. 296.5 314.8 -
Imputed Oper. Lease Depreciation 186.9 206.6 -
Maintenance & Repair Exp. 238.8 252.1 482.1

Note: For multiple class companies, per share items are primary class equivalent, and for foreign companies listed as primary ADRs, per share items are ADR-e
Restatement: Latest Filings
Order: Latest on Right
Conversion: Historical
Decimals: Capital IQ (Default)

Reclassified LTM
12 months 12 months 12 months
Dec-31-2020 Dec-31-2021 Jun-30-2022
MXN MXN MXN

23,445.3 34,330.1 39,123.1

- - -
23,445.3 34,330.1 39,123.1

17,696.8 25,212.1 28,522.2

5,748.6 9,118.1 10,600.9

9,404.6 10,150.2 10,309.0

- - -
- - -
(302.2) (787.2) (872.2)

9,102.5 9,363.0 9,436.8

(3,353.9) (245.0) 1,164.1

(810.8) (742.3) (749.9)

1,926.1 1,508.1 1,546.6
1,115.3 765.8 796.7

1.0 14.4 24.0

43.8 8.6 (27.9)
751.8 857.0 850.3
(1,442.1) 1,401.0 2,807.2

- - -
279.8 29.0 29.0
- - -
(1,162.4) 1,430.0 2,836.3

(262.6) 340.0 731.1

(899.8) 1,090.0 2,105.1

- - -
- - -
(899.8) 1,090.0 2,105.1

(43.6) (49.7) (51.5)

(943.3) 1,040.3 2,053.6

- - -
 (943.3) 1,040.3 2,053.6
(943.3) 1,040.3 2,053.6

(2.5) 2.75 5.75

(2.5) 2.75 5.75
377.8 377.8 356.9

(2.5) 2.75 5.75

(2.5) 2.75 5.75
377.8 377.8 356.9

(2.5) 2.19 4.77

(2.5) 2.19 4.77

3.52 NA NA
NA 127.8% 64.8%

(1,766.4) 1,081.3 2,421.4

(3,353.9) (245.0) 1,164.1
(3,353.9) (245.0) 1,164.1
(1,722.8) 1,167.2 NA
NM 23.8% 25.8%
NA NA 155.5
320.7 180.1 293.7
NA NA 145.9
(596.9) 160.7 438.3

(944.9) 826.0 1,703.0

19.8 17.1 NA
830.5 759.4 NA
(4.0) (7.0) -
Apr-29-2022 Apr-29-2022 Jul-25-2022
RC O O
REP REP LTM

0.7 0.5 NA
0.7 0.5 159.3
NA NA NA
43.6 85.9 NA
31.0 52.8 -
12.6 33.1 -
447.3 513.7 NA

DRs, per share items are ADR-equivalent.

 LIQUIDEZ MEDIATA O ACTIVO CIRCULANTE
SOLVENCIA PASIVO CIRCULANTE

LIQUIDEZ LIQUIDÉZ INMEDIATA ACTIVO CIRCULANTE - INVENTARIOS

PRUEBA DEL ÁCIDO PASIVO CIRCULANTE

CAPITAL DE TRABAJO ACTIVO CIRCULANTE - PASIVO CIRCULANTE

APALANCAMIENTO PASIVO TOTAL

FINANCIERO CAPITAL CONTABLE

CAPITAL CONTABLE
ESTRUCTURA FINANCIERA
PASIVO TOTAL

ENDEUDAMIENTO PRESTAMOS BANCARIOS

DEPENDENCIA BANCARIA ACTIVO TOTAL

PASIVO TOTAL
ENDEUDAMIENTO
ACTIVO TOTAL

UTILIDAD ANTES DE INTERESES E IMPUESTOS

COBERTURA DE INTERESES
INTERESES

RECUPERACIÓN DE CUENTAS CUENTAS POR COBRAR

POR COBRAR VENTAS NETAS A CRÉDITO

INVENTARIOS
ROTACIÓN DE INVENTARIOS
COSTO DE VENTAS
MOVILIDAD
PROVEEDORES
ROTACIÓN DE PROVEEDORES
COSTO DE VENTAS

VENTAS NETAS
ROTACIÓN DE ACTIVO TOTAL
ACTIVO TOTAL

VENTAS NETAS
EFICIENCIA DE LA PLANTA
ACTIVO NO CIRCULANTE
PRODUCTIVIDAD
VENTAS NETAS
PRODUCTIVIDAD TOTAL
ACTIVO TOTAL
 RENDIMIENTO SOBRE UTILIDAD NETA
INVERSIÓN PROPIA CAPITAL CONTABLE - UTILIDAD NETA

RENDIMIENTO SOBRE LA UTILIDAD NETA

INVERSION TOTAL ACTIVO TOTAL

MARGEN DE UTILIDAD UTILIDAD BRUTA

RENTABILIDAD BRUTA VENTAS NETAS

UTILIDAD NETA
MARGEN DE UTILIDAD NETA
VENTAS NETAS

RENTABILIDAD DE ACTIVO O UTILIDAD ANTES DE INTERESES E IMPUESTOS

ROI ACTIVO TOTAL
 2022

$30,217.41
3.183751
$9,491.13

$25,025.04
2.64
$9,491.13

$20,726.28

$20,490.26
0.89
$22,919.11

$22,919.11
$ 1.12
$20,490.26

N/A
$43,914.30

$20,490.26
$ 0.47
$43,914.30

$9,436.81
$796.74

$5,231.04
X 360 DIAS 48.13
$39,123.11

$5,192.37
X 360 DIAS 65.54
$28,522.21

$4,739.57
X 360 DIAS 59.82
$28,522.21

$39,123.11
0.89
$43,914.30

$39,123.11
6.02
$6,502.40

$39,123.11
0.89
$43,914.30
$2,053.63
-23.33
-$88.01

$2,053.63
0.05
$43,914.30

$2,836.26
$ 0.07
$39,123.11

$2,053.63
0.05
$39,123.11

$9,436.81
$ 0.21
$43,914.30
 UTILIDAD NETA $2,053.63
MARGEN NETO
VENTAS NETAS $39,123.11

VENTAS NETAS $39,123.11

PRODUCTIVIDAD TOTAL
ACTIVO TOTAL $43,914.30
METODO DUPONT

MULTIPLICADOR DE ACTIVO TOTAL $43,914.30

CAPITAL CAPITAL CONTABLE $22,919.11

UTILIDAD NETA $2,053.63

DUPONT
CAPITAL CONTABLE $22,919.11
$ 0.05

$ 0.89

1.92

0.09
Balance Sheet
Balance Sheet as of:
Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency MXN MXN MXN
ASSETS
Cash And Equivalents 4,207.1 5,385.8 4,516.1
Total Cash & ST Investments 4,207.1 5,385.8 4,516.1

Accounts Receivable 3,982.2 4,590.9 4,559.7

Other Receivables 1,065.6 868.9 1,572.0
Total Receivables 5,047.8 5,459.8 6,131.7

Inventory 4,616.6 5,124.2 5,163.8

Other Current Assets 264.5 174.3 70.6
14,136.1 16,144.1 15,882.2

Gross Property, Plant & Equipment 18,387.9 20,181.7 25,125.1

Accumulated Depreciation (3,868.6) (4,641.1) (6,067.5)
Net Property, Plant & Equipment 14,519.3 15,540.5 19,057.6

Long-term Investments 438.9 401.3 159.7

Other Intangibles 511.0 573.6 516.8
Accounts Receivable Long-Term 4,586.0 4,781.2 5,238.8
Deferred Tax Assets, LT 466.6 321.1 230.4
Deferred Charges, LT 787.3 671.5 1,078.1
Other Long-Term Assets 1,297.9 1,456.2 1,565.8
Total Assets 36,743.0 39,889.4 43,729.4

LIABILITIES
Accounts Payable 5,657.0 6,919.0 6,339.6
Accrued Exp. 320.2 292.1 222.4
Short-term Borrowings 451.9 - -
Curr. Port. of LT Debt 581.4 1,061.4 400.7
Curr. Port. of Leases - - -
Curr. Income Taxes Payable 879.3 1,267.2 1,353.5
Unearned Revenue, Current 659.0 704.8 657.5
Other Current Liabilities 942.3 862.7 524.1
Total Current Liabilities 9,491.1 11,107.1 9,497.9

Long-Term Debt 5,074.5 4,039.4 6,492.8

Long-Term Leases - - 1,988.1
Pension & Other Post-Retire. Benefits 992.5 557.3 581.4
Def. Tax Liability, Non-Curr. 877.4 990.1 1,111.0
Other Non-Current Liabilities 276.6 206.8 152.8
Total Liabilities 16,712.2 16,900.5 19,823.9
Common Stock 1,965.6 1,965.6 1,965.6
Additional Paid In Capital 2,636.2 2,636.2 2,636.2
Retained Earnings 14,634.9 17,601.4 18,727.7
Treasury Stock - - -
Comprehensive Inc. and Other 185.4 219.8 2.2
Total Common Equity 19,422.1 22,423.0 23,331.7

Minority Interest 608.8 565.8 573.8

Total Equity 20,030.9 22,988.8 23,905.5

Total Liabilities And Equity 36,743.0 39,889.4 43,729.4

Income Statement

Reclassified Reclassified Reclassified

For the Fiscal Period Ending 12 months 12 months 12 months
Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency MXN MXN MXN

Revenue 29,103.9 30,401.8 31,886.6

Other Revenue - - -
Total Revenue 29,103.9 30,401.8 31,886.6

Cost Of Goods Sold 20,932.6 21,751.0 23,286.1

Gross Profit 8,171.3 8,650.8 8,600.5

Selling General & Admin Exp. 7,469.2 8,546.2 8,674.4

R & D Exp. - - -
Depreciation & Amort. 1,085.1 - -
Other Operating Expense/(Income) (177.9) (1,099.1) (891.7)

Other Operating Exp., Total 8,376.5 7,447.2 7,782.6

Operating Income (205.2) 1,203.7 817.9

Interest Expense (444.6) (417.9) (497.2)

Interest and Invest. Income 1,445.0 1,595.4 1,878.8
Net Interest Exp. 1,000.4 1,177.5 1,381.6

Income/(Loss) from Affiliates 133.6 (23.5) 242.8

Currency Exchange Gains (Loss) (132.3) (83.5) (49.1)
Other Non-Operating Inc. (Exp.) 1,459.2 1,921.2 1,207.6
EBT Excl. Unusual Items 2,255.8 4,195.3 3,600.7
Impairment of Goodwill - - -
Asset Writedown (249.7) (62.9) 129.0
Other Unusual Items - - -
EBT Incl. Unusual Items 2,006.1 4,132.4 3,729.7

Income Tax Expense 259.9 1,128.7 1,030.7

Earnings from Cont. Ops. 1,746.2 3,003.7 2,699.1

Earnings of Discontinued Ops. - - -

Extraord. Item & Account. Change - - -
Net Income to Company 1,746.2 3,003.7 2,699.1

Minority Int. in Earnings (34.9) (45.1) (37.4)

Net Income 1,711.3 2,958.6 2,661.7
Reclassified
Dec-31-2020 Dec-31-2021 Jun-30-2022ANALISIS DE
AUMENTOS Y
MXN MXN MXN DESVIACIONES

6,386.2 6,088.5 4,906.3

- 1,182.25
6,386.2 6,088.5 4,906.3

3,210.4 4,915.9 5,231.0

315.13
1,044.9 753.8 2,227.0
1,473.20
4,255.3 5,669.7 7,458.0

4,536.0 4,695.7 5,192.4

496.64
46.6 64.9 296.5
231.51
15,224.1 16,518.9 17,853.1

26,707.6 28,750.3 19,691.0

- 9,059.33
(7,605.6) (9,353.2) (132.2)
9,221.00
19,102.0 19,397.1 19,558.8

167.5 320.8 1,607.9

1,287.17
723.1 1,122.0 1,280.7
158.64
4,199.5 4,013.4 2,694.9
- 1,318.55
280.9 152.2 143.3
- 8.86
1,120.8 919.0 765.2
- 153.81
1,930.3 1,849.4 10.4
- 1,838.97
42,748.3 44,292.7 43,914.3

6,313.0 7,482.4 4,739.6

- 2,742.83
255.4 507.3 253.9
- 253.38
- - -
NA
- 5.6 3.9
- 1.67
587.8 613.1 580.6
- 32.51
984.1 843.9 2,074.0
1,230.10
667.3 639.1 -
NA
765.5 1,174.1 2,712.6
1,538.53
9,573.0 11,265.4 10,364.6

7,510.3 7,504.7 7,503.4

- 1.35
1,699.6 1,842.7 1,562.3
- 280.42
593.9 388.3 -
NA
389.2 485.9 631.8
145.89
138.1 122.9 428.2
305.38
19,904.1 21,609.9 20,490.3
 1,965.6 1,965.6 1,965.6
-
2,636.2 2,636.2 2,636.2
-
17,738.6 17,554.2 17,963.1
408.85
- - -
NA
(59.4) (13.4) 354.2
367.64
22,281.0 22,142.7 22,919.1

563.1 540.2 504.9

- 35.27

22,844.1 22,682.9 23,424.0

42,748.3 44,292.7 43,914.3

Reclassified LTM
12 months 12 months 12 months
Dec-31-2020 Dec-31-2021 Jun-30-2022 ANALISIS DE
AUMENTOS Y
MXN MXN MXN DESVIACIONES

23,445.3 34,330.1 39,123.1

4,792.99
- - -
23,445.3 34,330.1 39,123.1

-
17,696.8 25,212.1 28,522.2
3,310.14
5,748.6 9,118.1 10,600.9

9,404.6 10,150.2 10,309.0

158.75
- - -
NA
- - -
NA
(302.2) (787.2) (872.2)
- 85.00

9,102.5 9,363.0 9,436.8

(3,353.9) (245.0) 1,164.1

1,409.09
-
(810.8) (742.3) (749.9)
- 7.60
1,926.1 1,508.1 1,546.6
38.46
1,115.3 765.8 796.7

1.0 14.4 24.0

9.55
43.8 8.6 (27.9)
- 36.52
751.8 857.0 850.3
- 6.75
(1,442.1) 1,401.0 2,807.2

-
 - - -
279.8 29.0 29.0
-
- - -
(1,162.4) 1,430.0 2,836.3

-
(262.6) 340.0 731.1
391.09
(899.8) 1,090.0 2,105.1

- - -
NA
- - -
NA
(899.8) 1,090.0 2,105.1

(43.6) (49.7) (51.5)

- 1.80
(943.3) 1,040.3 2,053.6

-
-
-
NA
-

-
Balance Sheet

Balance Sheet
as of: Reclassified ANALISIS DE
Dec-31-2017 Dec-31-2018 Dec-31-2019 Dec-31-2020 Dec-31-2021 Jun-30-2022 AUMENTOS Y
DESVIACIONE
Currency MXN MXN MXN MXN MXN MXN S
ASSETS
Cash And Equiva 4,207.1 5,385.8 4,516.1 6,386.2 6,088.5 4,906.3
- 1,182.25
Total Cash & 4,207.1 5,385.8 4,516.1 6,386.2 6,088.5 4,906.3

Accounts Receiv 3,982.2 4,590.9 4,559.7 3,210.4 4,915.9 5,231.0

315.13
Other Receivabl 1,065.6 868.9 1,572.0 1,044.9 753.8 2,227.0
1,473.20
Total Receivab 5,047.8 5,459.8 6,131.7 4,255.3 5,669.7 7,458.0

Inventory 4,616.6 5,124.2 5,163.8 4,536.0 4,695.7 5,192.4

496.64
Other Current As 264.5 174.3 70.6 46.6 64.9 296.5
231.51
14,136.1 16,144.1 15,882.2 15,224.1 16,518.9 17,853.1

Gross Property, 18,387.9 20,181.7 25,125.1 26,707.6 28,750.3 19,691.0

- 9,059.33
Accumulated Dep (3,868.6) (4,641.1) (6,067.5) (7,605.6) (9,353.2) (132.2)
9,221.00
Net Property, 14,519.3 15,540.5 19,057.6 19,102.0 19,397.1 19,558.8

Long-term Inves 438.9 401.3 159.7 167.5 320.8 1,607.9

1,287.17
Other Intangibles 511.0 573.6 516.8 723.1 1,122.0 1,280.7
158.64
Accounts Receiv 4,586.0 4,781.2 5,238.8 4,199.5 4,013.4 2,694.9
- 1,318.55
Deferred Tax Ass 466.6 321.1 230.4 280.9 152.2 143.3
- 8.86
Deferred Charge 787.3 671.5 1,078.1 1,120.8 919.0 765.2
- 153.81
Other Long-Term 1,297.9 1,456.2 1,565.8 1,930.3 1,849.4 10.4
- 1,838.97
Total Assets 36,743.0 39,889.4 43,729.4 42,748.3 44,292.7 43,914.3

LIABILITIES
Accounts Payabl 5,657.0 6,919.0 6,339.6 6,313.0 7,482.4 4,739.6
- 2,742.83
Accrued Exp. 320.2 292.1 222.4 255.4 507.3 253.9
- 253.38
Short-term Borro 451.9 - - - - -
NA
Curr. Port. of LT 581.4 1,061.4 400.7 - 5.6 3.9
- 1.67
Curr. Port. of Le - - - 587.8 613.1 580.6
- 32.51
Curr. Income Ta 879.3 1,267.2 1,353.5 984.1 843.9 2,074.0
1,230.10
Unearned Revenu 659.0 704.8 657.5 667.3 639.1 -
NA
Other Current Liab 942.3 862.7 524.1 765.5 1,174.1 2,712.6
1,538.53
Total Current L 9,491.1 11,107.1 9,497.9 9,573.0 11,265.4 10,364.6

Long-Term Debt 5,074.5 4,039.4 6,492.8 7,510.3 7,504.7 7,503.4

- 1.35
Long-Term Leas - - 1,988.1 1,699.6 1,842.7 1,562.3
- 280.42
Pension & Other 992.5 557.3 581.4 593.9 388.3 -
NA
Def. Tax Liabilit 877.4 990.1 1,111.0 389.2 485.9 631.8
145.89
Other Non-Current 276.6 206.8 152.8 138.1 122.9 428.2
305.38
Total Liabilities 16,712.2 16,900.5 19,823.9 19,904.1 21,609.9 20,490.3

Common Stock 1,965.6 1,965.6 1,965.6 1,965.6 1,965.6 1,965.6

-
Additional Paid I 2,636.2 2,636.2 2,636.2 2,636.2 2,636.2 2,636.2
-
Retained Earnin 14,634.9 17,601.4 18,727.7 17,738.6 17,554.2 17,963.1
408.85
Treasury Stock - - - - - -
NA
Comprehensive I 185.4 219.8 2.2 (59.4) (13.4) 354.2
367.64
Total Common 19,422.1 22,423.0 23,331.7 22,281.0 22,142.7 22,919.1

Minority Interest 608.8 565.8 573.8 563.1 540.2 504.9

- 35.27

Total Equity 20,030.9 22,988.8 23,905.5 22,844.1 22,682.9 23,424.0

Total Liabilitie 36,743.0 39,889.4 43,729.4 42,748.3 44,292.7 43,914.3

 ORIGEN Y
APLICAIONES

FLUJO DE EFECTIVO

APLICACIÓN
APLICACIÓN

APLICACIÓN
APLICACIÓN

FUENTE
APLICACIÓN

APLICACIÓN
APLICACIÓN
FUENTE
FUENTE
FUENTE
FUENTE

FUENTE
FUENTE

FUENTE
FUENTE
APLICACIÓN

APLICACIÓN

FUENTE
FUENTE

APLICACIÓN
APLICACIÓN
APLICACIÓN

APLICACIÓN

FUENTE
AÑO VENTAS PROMEDIO LIMITE MAX LIMITE MIN PROMEDIO
2017 1711.267 $ 1,580.37 $ 2,869.46 $ 291.28 DESVIACION ESTANDAR
2018 2958.605 $ 1,580.37 $ 2,869.46 $ 291.28 LIMITE MAX
2019 2661.725 $ 1,580.37 $ 2,869.46 $ 291.28 LIMITE MIN
2020 -943.3 $ 1,580.37 $ 2,869.46 $ 291.28
2021 1040.304 $ 1,580.37 $ 2,869.46 $ 291.28
2022 2053.632 $ 1,580.37 $ 2,869.46 $ 291.28

Palacio de hierro
3500
3000
2500
2000
1500
1000
500
0
2017 2018 2019 2020 2021 2022
-500
-1000
-1500

VENTAS PROMEDIO LIMITE MAX LIMITE MIN

AÑO VENTAS PROMEDIO LIMITE MAX LIMITE MIN VARIANZA

2017 $ 1,711.27 $ 1,580.37 $ 1,995,690.94 $ 1,992,530.20 PROMEDIO
2018 $ 2,958.61 $ 1,580.37 $ 1,995,690.94 $ 1,992,530.20 LIMITE MAX
2019 $ 2,661.73 $ 1,580.37 $ 1,995,690.94 $ 1,992,530.20 LIMITE MIN
2020 -$ 943.30 $ 1,580.37 $ 1,995,690.94 $ 1,992,530.20
2021 $ 1,040.30 $ 1,580.37 $ 1,995,690.94 $ 1,992,530.20
2022 $ 2,053.63 $ 1,580.37 $ 1,995,690.94 $ 1,992,530.20

Este gráfico no está disponible en tu versión de Excel.

Si editas esta forma o guardas el libro en un formato de archivo

diferente, el gráfico no se podrá utilizar.
$ 1,580.37
$ 1,289.09
$ 2,869.46
$ 291.28

$ 1,994,110.57
$ 1,580.37
$ 1,995,690.94
$ 1,992,530.20