Diagnóstico basado en 8 periodos de estados financieros reales. Tres levers prioritarios con impacto cuantificado sobre NOPAT y capital invertido.
SG&A: $116B (20.8% revenue)
EBITDA margin: 6.0%
vs 7.4% en Year 1
Retail eficiente: 18-19% SG&A
EBITDA objetivo: 8-9%
Gap: ~2pp de margen
Auditoría de overhead por función
Target: -2pp SG&A en 18 meses
Valor: +$11B de NOPAT
Capex promedio: $32B/año
Sin criterio de ROIC mínimo
LTD creció $27B en 4 años
Retail eficiente: 3-4% revenue
ROIC mínimo requerido: 12%
Hurdle rate estándar industria
Definir hurdle rate de 12% ROIC
Freeze capex no comprometido
Valor: $8B liberados/año
Inventario Year 7: $65B
Histórico Years 1-6: $45-48B
Días inventario: ~58 días
Días inventario objetivo: 35-40
Nivel histórico propio: $46B
Gap: $17-20B de capital
Programa de liquidación selectiva
Target: $48B en 12 meses
Valor: $17B de capital liberado
Cifras en USD millones. Base del análisis anterior.
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | |
|---|---|---|---|---|---|---|---|---|
| Revenue | 485,651 | 482,130 | 485,873 | 500,343 | 514,405 | 523,964 | 559,151 | 572,754 |
| COGS | (355,913) | (351,530) | (351,176) | (362,867) | (374,623) | (383,618) | (409,163) | (418,342) |
| Gross Profit | 129,738 | 130,600 | 134,697 | 137,476 | 139,782 | 140,346 | 149,988 | 154,412 |
| SG&A | (93,418) | (97,041) | (101,853) | (106,510) | (107,147) | (108,791) | (116,288) | (117,812) |
| EBITDA | 35,869 | 33,173 | 32,194 | 27,169 | 23,758 | 33,193 | 33,714 | 30,923 |
| Depreciation | (9,173) | (9,454) | (10,080) | (10,529) | (10,678) | (10,987) | (11,152) | (10,658) |
| EBIT | 26,696 | 23,719 | 22,114 | 16,640 | 13,080 | 22,206 | 22,562 | 20,265 |
| Interest Expense | (2,461) | (2,548) | (2,367) | (2,330) | (2,346) | (2,599) | (2,315) | (1,994) |
| Interest Income | 113 | 81 | 100 | 152 | 217 | 189 | 121 | 158 |
| EBT | 24,348 | 21,252 | 19,847 | 14,462 | 10,951 | 19,796 | 20,368 | 18,429 |
| Provision for Taxes | (7,985) | (6,558) | (6,204) | (4,600) | (4,281) | (4,915) | (6,858) | (4,756) |
| Net Income | 16,363 | 14,694 | 13,643 | 9,862 | 6,670 | 14,881 | 13,510 | 13,673 |
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | |
|---|---|---|---|---|---|---|---|---|
| Cash from Operating | ||||||||
| Net Income | 16,363 | 14,694 | 13,643 | 9,862 | 6,670 | 14,881 | 13,510 | 13,673 |
| Depreciation | 9,173 | 9,454 | 10,080 | 10,529 | 10,678 | 10,987 | 11,152 | 10,658 |
| Cash From Accounts Receivable | (6,778) | 1,154 | (211) | 221 | (669) | (1) | (232) | (1,764) |
| Cash From Inventory | (47,365) | 1,455 | 923 | (2,307) | (598) | 1,835 | (19,753) | 7,780 |
| Cash From Accounts Payable | 58,583 | 32 | 4,393 | 5,851 | 788 | (98) | 17,800 | (5,177) |
| Subtotal | 29,976 | 26,789 | 28,828 | 24,156 | 16,869 | 27,604 | 22,477 | 25,170 |
| Cash from Investing | ||||||||
| Capital Expenditure | (10,414) | (19,850) | (24,915) | (24,309) | (35,829) | (41,264) | (6,593) | (24,598) |
| Subtotal | (10,414) | (19,850) | (24,915) | (24,309) | (35,829) | (41,264) | (6,593) | (24,598) |
| Cash from Financing | ||||||||
| Change in Long-Term Debt | (5,018) | (2,624) | (317) | (5,967) | 21,190 | 14,714 | (5,110) | (4,698) |
| Change in Common Equity | (10,053) | (663) | 554 | 267 | 310 | 278 | 397 | 1,187 |
| Dividends | — | — | — | — | — | — | — | — |
| Change in Revolving Credit Line | — | (685) | (2,084) | 5,742 | (1,832) | 411 | (2,945) | (89) |
| Subtotal | (15,071) | (3,972) | (1,847) | 42 | 19,668 | 15,403 | (7,658) | (3,600) |
| Cash Balance | ||||||||
| Beginning of the Year | 4,644 | 5,738 | 4,801 | 6,867 | 7,014 | 7,722 | 9,515 | 17,788 |
| Increase / (Decrease) | 4,491 | 2,967 | 2,066 | (111) | 708 | 1,743 | 8,226 | (3,028) |
| End of the Year | 9,135 | 8,705 | 6,867 | 6,756 | 7,722 | 9,465 | 17,741 | 14,760 |
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | |
|---|---|---|---|---|---|---|---|---|
| Assets | ||||||||
| Cash | 9,135 | 8,705 | 6,867 | 6,756 | 7,722 | 9,465 | 17,741 | 14,760 |
| Accounts Receivable | 6,778 | 5,624 | 5,835 | 5,614 | 6,283 | 6,284 | 6,516 | 8,280 |
| Inventories | 47,365 | 45,910 | 44,987 | 47,294 | 47,892 | 46,057 | 65,810 | 58,030 |
| Total Current Assets | 63,278 | 60,239 | 57,689 | 59,664 | 61,897 | 61,806 | 90,067 | 81,070 |
| Property Plant & Equipment | 140,428 | 139,342 | 141,136 | 144,858 | 157,398 | 174,689 | 162,429 | 163,790 |
| Total Assets | 203,706 | 199,581 | 198,825 | 204,522 | 219,295 | 236,495 | 252,496 | 244,860 |
| Liabilities | ||||||||
| Accounts Payable | 58,583 | 58,615 | 63,008 | 68,859 | 69,647 | 69,549 | 87,349 | 82,172 |
| Revolving Credit Line | 6,689 | 6,004 | 3,920 | 9,662 | 7,830 | 8,241 | 5,296 | 5,207 |
| Total Current Liabilities | 65,272 | 64,619 | 66,928 | 78,521 | 77,477 | 77,790 | 92,645 | 87,379 |
| Long-Term Debt | 57,040 | 54,416 | 54,099 | 48,132 | 69,322 | 84,036 | 78,926 | 74,228 |
| Total Liabilities | 122,312 | 119,035 | 121,027 | 126,653 | 146,799 | 161,826 | 171,571 | 161,607 |
| Equity | ||||||||
| Common Equity | 2,785 | 2,122 | 2,676 | 2,943 | 3,253 | 3,531 | 3,928 | 5,115 |
| Retained Earnings | 78,609 | 78,424 | 75,122 | 74,926 | 69,243 | 71,138 | 76,997 | 78,138 |
| Total Shareholders' Equity | 81,394 | 80,546 | 77,798 | 77,869 | 72,496 | 74,669 | 80,925 | 83,253 |
| Total Liabilities & Equity | 203,706 | 199,581 | 198,825 | 204,522 | 219,295 | 236,495 | 252,496 | 244,860 |