Reference no: EM132025319
This assignment may be completed using either J.W. Nordstrom or Sinclair Broadcasting.
Tasks:
· Enter the most recent year financial data into the "Forecast" tab of the forecasting spreadsheet.
· Develop a set of forecasting parameters, based on the methodology covered in class on Thursday, 1 March. (See video archive if you missed the live session.)
· Complete the forecast using your set of parameters.
· Make a change (increase or decrease) to your gross profit margin (if Nordstrom) or your sales growth (if Sinclair) parameter. Note the changes to the forecast outcome that result from the change in the parameter.
Submission:
Submit a Word document in which you use a bulleted list to describe the logic you used in arriving at your most key forecasting parameters (e.g., sales growth, profit margins, expense ratios, capital spending). In a short paragraph, then describe the meaning of the PLUG and EFN results for your first forecast.
In another short paragraph, identify the change made to the parameters and describe the impact that this has on the PLUG and EFN results.
Be sure to copy and paste your parameters and forecasting spreadsheets into your Word document as exhibits to which you refer in your text: be sure to give each exhibit a number to which you can refer in your text and detailed title describing the contents of the exhibit.
Attachment:- Nordstrom INC.rar