Financial Model Spreadsheet Ashley V. Sampson MBA 640 [1] Nordstrom, Inc. Financial History and Projected Performance in thousands Previous Performance Projected Performance Year 2017 2018 2019 2020 2021 Total Revenue $ 14,757,000 $ 15,478,000 $ 15,818,516.000 $ 16,166,523.35 $ 16,522,186.87 Cost of Revenue $9,440,000 $9,713,760 $9,927,462.72 $10,145,866.90 $10,369,075.97 Gross Profit $5,317,000 $5,367,894 $5,485,987.67 $5,606,679.40 $5,730,026.34 Operating Expenses $4,315,000 $4,466,025 $4,564,277.55 $4,664,691.66 $4,767,314.87 Operating Income $1,002,000 $911,820 $931,880.04 $952,381.40 $973,333.79 Interest Expense $121,000 $117,370 $119,952.14 $122,591.09 $125,288.09 Income Tax $330,000 $290,400 $296,788.80 $303,318.15 $309,991.15 Income $551,000 $504, 050 $515,139.10 $526,472.16 $538,054.55 Profit Margin (%) 36.03 35.59 0.3468079855 0.3468079855 0.3468079855 Between 2017 and 2018, there was a proportiante increase in both expenses and revenue which will help determine figures for 2019-2021. An average increase of .022% and .035% is resonable. Key Assumptions Nordstrom Inc., is a company that is currently showing the potential to financially do well in future years. The current trend is that the profit margin does not increase as the years due and in return generates more revenue. Conclusions