Financial impact for nordtrom inc expansion project


Financial impact????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????consolidated financial projection with and without the project. Be sure to:
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.
V. Financing FinancingFinancingFinancingFinancingFinancing: In this section, compare the proposed loan

* Please note that I need this represented  also in spreadsheet