Identify key conclusions regarding financial projections

Assignment Help Corporate Finance
Reference no: EM131269645

Nordstrom, Inc financial spreadsheet

Draft a one-page spreadsheet showing financial history and projected performance for Nordstrom, Inc (Here is company info: https://shop.nordstrom.com/c/about-us?origin=footer) . 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.

Reference no: EM131269645

Questions Cloud

Describe one data mining use of this data warehouse : The subject will be ‘‘passage,'' which represents a particular passenger booking on a particular cruise. As stated in Minicase 2.1, be sure to keep track of the fare that the passenger paid for the cruise and the passenger's satisfaction rating of..
Major complaint about the ada : Employers' major complaint about the ADA is that the costs of making reasonable accommodations will reduce their ability to compete with businesses (especially foreign ones) that don't face these requirements. Is this a legitimate concern? If so H..
Discuss the demographic trends associated with your product : Describe and discuss the demographic trends associated with your product/service. Describe and discuss the current economic trends and the influences they will have on the sales of your product/service.
Why the world wide web is like a giant client/server system : One of the principles of client/server systems is that the processing functions are divided among different computers in the system. Describe and explain this ‘‘division of labor'' in the World Wide Web. 3. Describe the arrangement of computers an..
Identify key conclusions regarding financial projections : Identify key assumptions and conclusions regarding financial projections. Present data in a professional manner with headings and meaningful number formatting.
Classify as open-ended or close-ended : At least half of your questions should be open-ended and the other half should be closed. For each question, identify the type of probing question used: situation, problem, implication, and need payoff (please refer to your textbook) and classify as ..
Write definite integral that represents the increase in cost : Assuming that the marginal cost function in given Problem is linear, find its equation and write a definite integral that represents the increase in costs going from a production level of 200 to 600 pairs of skis per week Evaluate the definite int..
Describe three olap uses of this data warehouse : Design a multidimensional database using a star schema for a data warehouse for the Super Baseball League business environment described in Minicase 2.2.
Describe the type of target marketing strategy : Describe the type of target marketing strategy that might be used to reach the consumer for your chosen food show. Discuss the product differentiation strategy used to distinguish your chosen show from the rest of the shows on the Food Network® we..

Reviews

Write a Review

Corporate Finance Questions & Answers

  Polaris and arctic cat sell several different products

Polaris and Arctic Cat sell several different products; most are profitable but some are not.

  Compute a classified balance sheet with a proper heading

Prepare a classified balance sheet with a proper heading on a spreadsheet. For assets, use the classifications of current assets, plant and equipment, intangibles, and other assets.

  Explain the operating profit margin

Select any public company, & present findings from your financial analysis in a report. The report must include the following;

  Prepare a forecasted income statement

Cost of sales forecast uses the average percent relation between cost of sales and sales for the three-year period ending June 30, Year 11 and Prepare a forecasted income statement for Year 12 using the following assumptions ($ millions):

  Ecological environment or community and csr

Current approaches to the topic of CSR in ecological environment or Community and CSR - What kinds of data does it use to back up its argument?

  Calculate the cost of long-term debt

Find the break points associated with each source of capital and use them to specify each of the ranges of total new financing over which the firm's WACC remains constant and calculate the WACC over each of the ranges of total new financing specifi..

  Preparation of monthly income and expense plan and analysis

preparation of monthly income and expense plan and analysis of financial positiondonna and sherman terrel are preparing

  Under what circumstances would it be appropriate for a firm

under what circumstances would it be appropriate for a firm to use different costs of capital for its different

  Development of a business plan for a new business

2FBM702 -development of a business plan for a new business within the Fashion Industry. A business plan is very important to the development of any business or entrepreneurial opportunity.

  Determine stock based on firm''s dividend yield

Determine stock based on firm's dividend yield and capital gain yield - Evaluation of two different options for stock purchase.

  Determine the earnings per share disclosure for hazard guard

Hazard experienced earthquake damage to a regional sales office resulting in a before-tax extraordinary loss of $200,000. The income tax rate was 40%. Determine the earnings per share disclosure for Hazard Guard.

  Explain what is aq&qs indifference level of ebit

Explain what is AQ&Q's indifference level of EBIT and provide its current situation, might it benefit from increasing or decreasing its use of debt? Explain.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd