Draft a spreadsheet showing financial history and projected performance for the company you plan to...

Question

Draft a spreadsheet showing financial history and projected performance for the company you plan to use in this course's final project. 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). Note: Submit this assignment as an Excel spreadsheet file, not a PDF.Copy and Paste Your Assignment

Company Name: NORDSTORM INC

mba64021assignmentfinancialmodelspreadsheetxlsx-tehnijma.xlsx sample-spreadsheet-zhhiigve.xlsx rubric-uyiti2q2-rdnhtplk.png

Shivi · Accepted Answer

Nordstrom, Inc
	NORDSTROM, INC
	FINANCIAL HISTORY AND PROJECTED PERFORMANCE
	(VALUES IN $000'S)
		PREVIOUS PERFORMANCE		PROJECTED PERFORMANCE				Assumptions
	YEAR	2019	2020	2021	2022	2023		2020 vs 2019	% Change
	TOTAL REVENUE	15,860,000	15,524,000	15,195,118	14,873,204	14,558,110		-336,000	-2.12%
	COST OF REVENUE	10,155,000	9,932,000	9,713,897	9,500,583	9,291,954		-223,000	-2.20%
	GROSS PROFIT	5,705,000	5,592,000	5,481,221	5,372,621	5,266,155		-113,000	-1.98%
	OPERATING EXPENSES	4,868,000	4,808,000	4,748,

Draft a spreadsheet showing financial history and projected performance for the company you plan to use in this course's final project. The rows should include revenue, expenses, calculated profit,...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment