1. Project the incremental, annual, and cumulative cash benefits and outflows associated with the proposed expansion for the next seven to 10 years, using a spreadsheet or other relevant presentation vehicle to support your narrative. Be sure to justify your assumptions and methodology based on sound microeconomic and financial principles. For example, what assumptions have you made about demand, price, volume, capital purchase costs, incremental hiring, and so on?

2. Develop a consolidated financial projection of revenue, pretax income, and cash flow for the overall business, over that same number of years, both with and without the proposed investment. Use a spreadsheet or other relevant presentation vehicle to support your narrative, being sure to describe any relevant assumptions. The company is Nordstrom. The proposed expansion is projected to increase profits 5% each year. The years needed are 2021-2027. I'd love to see formulas used in order to help me better understand this. Thanks!