Financial Model Spreadsheet

(Please read assignment fully before bidding)The company is Nordstrom, Inc.Draft a one-page spreadsheet showing financial history and projected performance for the company have chosen. The rows should include revenue, expenses,
calculated profit, and calculated profit margin. The columns should be 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 the cells of the spreadsheet should show your
calculation formulas. Your spreadsheet should look professional on screen and when printed (including a heading and meaningful number formatting). Submit
this assignment as an Excel spreadsheet file, not a PDF document.PLEASE FOLLOW ATTACHED RUBRIC TO EXACT.
mba_640_module_two_financial_model_guidelines_and_rubric.pdf

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Financial Model Spreadsheet
Just from $13/Page
Order Essay

MBA 640 Module Two Financial Model Guidelines and Rubric
Overview: The financial model assignment will give you an opportunity to explore the company you will be using for your final project and it will also give you
practice in creating a simple spreadsheet. You will be expected to utilize spreadsheets as exhibits in your final project external capital funding proposal.
Prompt: Choose one of the following companies, which you will use in your final project proposal:
1. Alteryx
2. L.S. Starrett Company
3. Nordstrom, Inc.
Draft a one-page spreadsheet showing financial history and projected performance for the company have chosen. The rows should include revenue, expenses,
calculated profit, and calculated profit margin. The columns should be 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 the cells of the spreadsheet should show your
calculation formulas. Your spreadsheet should look professional on screen and when printed (including a heading and meaningful number formatting). Submit
this assignment as an Excel spreadsheet file, not a PDF document.
Specifically, the following critical elements must be addressed:
?
?
?
?
?
Show two years of financial history including revenue, expenses, calculated profit, and calculated profit margins.
Show three years of future financial projections for revenue, expenses, calculated profit, and calculated profit margins.
Show calculation formulas in cells where appropriate rather than “inputting” numbers.
Identify key assumptions and conclusions regarding financial projections.
Present data in a professional manner with headings and meaningful number formatting.
Help with Excel Spreadsheet
Atomic Learning Excel Spreadsheet Tutorials: Atomic Learning provides Excel tutorials at various levels (beginner, intermediate, advanced) and for various
software versions. Log in using your SNHU login credentials, type “Excel” into the search box, and choose the tutorial that is right for you.
Guidelines for Submission: Your financial model must be submitted as an Excel spreadsheet document.
Rubric
Critical Elements
Financial History
Financial
Projections
Calculations
Key
Assumptions
and Conclusions
Presentation
Proficient (100%)
Shows two years of financial
history including revenue,
expenses, calculated profit, and
calculated profit margins
Shows three years of future
financial projections for revenue,
expenses, calculated profit, and
calculated profit margins
Cells accurately reflect calculation
formulas
Identifies reasonable key
assumptions leading to logical
conclusions
Spreadsheet is presented cleanly
and professionally with proper
headings, spacing, and number
formatting
Needs Improvement (75%)
Shows two years of financial
history but calculations are
inaccurate
Not Evident (0%)
Does not show two years of
financial history
Value
20
Shows three years of future
financial projections, but
calculations are inaccurate
Does not show three years of
future financial projections
20
Cells inconsistently reflect
calculation formulas
Identifies key assumptions, but
assumptions are not reasonable
and/or conclusions are not logical
Spreadsheet has minor problems
with professional appearance,
spacing, heading, and formatting
Cells do not reflect calculation
formulas
Does not identify reasonable key
assumptions leading to logical
conclusions
Spreadsheet has major problems
with professional appearance,
spacing, heading, and formatting
20
Total
20
20
100%

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP