the creation of an external capital funding proposal.

profilecjay212
10YrTracking.xlsx

Financial Projection

With South Africa Project
Nordstrom's Consolidated Financial Projection
For 8 years from 2020-2027
(Amount in millions) 2020 2021 2022 2023 2024 2025 2026 2027
Net Revenue 16491.36 17315.928 18181.7244 19090.81062 20045.351151 21047.61870855 22099.9996439775 23204.9996261764
Gross Profit 5607.06 5956.68 6254.51 6567.24 6895.60 7240.38 7602.40 7982.52
Operating Expenses 5112.32 5454.52 5727.24 6013.61 6314.29 6630.00 6961.50 7309.57
Interest Expenses 98.95 103.90 109.09 114.54 120.27 126.29 132.60 139.23
Pretax Income 395.79 398.27 418.18 439.09 461.04 484.10 508.30 533.71
Without South Africa Project
Nordstrom's Projected Cash Flow
Between 2020-2027
(Amount in millions) 2020 2021 2022 2023 2024 2025 2026 2027
Net Revenue 15836.04 16200.26892 16572.87510516 16954.0512325787 17343.994410928 17742.9062823793 18150.993126874 18568.4659687921
Gross Profit 5384.2536 5508.0914328 5634.7775357544 5764.3774190767 5896.9580997155 6032.588136009 6171.3376631372 6313.2784293893
Operating Expenses 4909.1724 5022.0833652 5137.5912825996 5255.7558820994 5376.6382673877 5500.3009475376 5626.8078693309 5756.2244503256
Interest Expenses 95.01624 97.20161352 99.437250631 101.7243073955 104.0639664656 106.4574376943 108.9059587612 111.4107958128
Pretax Income 380.06496 388.80645408 397.7490025238 406.8972295819 416.2558658623 425.8297507771 435.623835045 445.643183251

Cash Flow

With South Africa Project
Nordstrom's Projected Cash Flow
From 2020-2027
Amount in Millions 2020 2021 2022 2023 2024 2025 2026 2027
Cash from operating activities 1347.84 1401.7536 1457.823744 1516.13669376 1576.7821615104 1639.8534479708 1705.4475858897 1773.6654893252
Cash from investing activities -670 -670 -670 -670 -700 -700 -700 -700
Cash from financing activities -870 -870 -870 -870 -925 -925 -925 -925
Net Cash Increase/(Decrease) -192.16 -138.2464 -82.176256 -23.86330624 -48.2178384896 14.8534479708 80.4475858896 148.6654893252
Without South Africa Project
Amount in Millions 2020 2021 2022 2023 2024 2025 2026 2027
Cash from operating activities 1308.96 1308.96 1308.96 1308.96 1308.96 1308.96 1308.96 1308.96
Cash from investing activities -655 -655 -655 -655 -660 -660 -660 -660
Cash from financing activities -865 -865 -865 -865 -700 -690 -640 -600
Net Cash Increase/(Decrease) -211.04 -211.04 -211.04 -211.04 -51.04 -41.04 8.96 48.96

Sheet3