Reference no: EM131301033
Nordstrom Inc. Financial analysis
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.
The company need to analysis is "Nordstrom Inc."
I have put two examples files which you can read at the top of the Spreadsheet the Fundamental Statistics. You will need some of these depending on the project. This is a project only so the CFs and all analyses will be for the project. Some analyses must include the entire company. But CFs are project related and NPV is project related.
|
What is the size of the labor force
: A country with a civilian population of 90,000 (all over age 16) has 70,000 employed and 10,000 unemployed persons. Of the unemployed, 5,000 are frictionally unemployed and another 3,000 are structurally unemployed.
|
|
Discuss task of national agencies dealing with kyotoprotocol
: Resorting to published literature or other media resources Investigate and explain in a short essay, how is the Kyoto protocol being addressed and implemented in practice in the KSA, name the designated national authority for the Clean Development..
|
|
Calculate roe and roa and net interest margin
: What strengths and weaknesses are you able to detect in Happy Merchants' performance?- Calculate ROE, ROA, Net interest margin, Earnings per share and Net noninterest margin.
|
|
How does this sale affect gdp
: Phil owns an old set of golf clubs that he purchased for $1,000 seven years ago. He decides to post them on Craigslist and quickly sells the clubs for $250. How does this sale affect GDP?
|
|
Show three years of future financial projections for revenue
: 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.
|
|
Discuss international strategy
: Write a 1,050-word report on the company you selected in Week 3, following up on the Individual Assignment of Week 3 (Environmental Scanning), and address the following:
|
|
When you have selected the fund from the fund screener
: Identify each Benchmark you will use to evaluate each fund's performance. When you have selected the fund from the fund screener. Identify which asset (broad and narrow) category the fund matches.
|
|
Write about who is a celebrity- political person
: write about who is a celebrity, political person or anyone else in the spotlight. The person you choose must have a mental health disorder. You can use the Internet first to find a person that fits the above description if you do not already know ..
|
|
Explain the relationship between output and income
: A friend of yours is reading a financial blog and comes to you for some advice about GDP. She wants to know what "real" GDP is. How would you explain the concept to her?
|