Draft a spreadsheet showing financial history and projected performance for Nordstrom. The rows should include revenue, expenses, calculated profit, and calculated profit margin. The columns should represent years: two years of history, plus three years of your reasonable future projections. Include a few sentences of key assumptions and conclusions. The spreadsheet must have accurate calculations and look professional on screen and when printed (including a heading and meaningful number formatting).

Income Statement

All numbers in thousands

Revenue	2/2/2019	2/3/2018	1/28/2017	1/30/2016
Total Revenue	15,860,000	15,478,000	14,757,000	14,437,000
Cost of Revenue	10,155,000	9,890,000	9,440,000	9,333,000
Gross Profit	5,705,000	5,588,000	5,317,000	5,104,000
Operating Expenses
Research Development	-	-	-	-
Selling General and Administrative	4,796,000	4,662,000	4,315,000	3,957,000
Non Recurring	-	-	-	-
Others	-	-	-	-
Total Operating Expenses	14,951,000	14,552,000	13,755,000	13,290,000
Operating Income or Loss	909,000	926,000	1,002,000	1,147,000
Income from Continuing Operations
Total Other Income/Expenses Net	-176,000	-136,000	-318,000	-171,000
Earnings Before Interest and Taxes	909,000	926,000	1,002,000	1,147,000
Interest Expense	-119,000	-141,000	-122,000	-112,000
Income Before Tax	733,000	790,000	684,000	976,000
Income Tax Expense	169,000	353,000	330,000	376,000
Minority Interest	-	-	-	-
Net Income From Continuing Ops	564,000	437,000	354,000	600,000
Non-recurring Events
Discontinued Operations	-	-	-	-
Extraordinary Items	-	-	-	-
Effect Of Accounting Changes	-	-	-	-
Other Items	-	-	-	-
Net Income
Net Income	564,000	437,000	354,000	600,000
Preferred Stock And Other Adjustments	-	-	-	-
Net Income Applicable To Common Shares	564,000	437,000	354,000	600,000

Answer rating: 100% (QA)

Answer The year 2 3 4 revenue 3701 3651 3601 3551 3501 less cost of revenue 2327 2359 232702 2... View the full answer