Developing quantitative recommendations and financial forecasts

Financial Forecasting Using Excel

Overview

Developing quantitative recommendations and financial forecasts using linear regression models to inform decision-making is a critical part of effective business planning. In this assignment you consider the Casey Hardware Stores Scenario to develop financial forecasting models. You will use linear regression to inform a recommendation to management regarding store expansion.

Instructions

• Use the following scenario and templates to complete the assignment:
  • Casey Hardware Scenario [PDF] Download Casey Hardware Scenario [PDF].
  • Week 7 Assignment Word Template [DOCX] Download Week 7 Assignment Word Template [DOCX].
  • Week 7 Assignment Excel Template [XLSX] Download Week 7 Assignment Excel Template [XLSX].
• Review each of the documents above and fully complete each template. Directions for completion are included in each document.

This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the Library site for all support. Check with your professor for any additional instructions.

The specific course learning outcome associated with this assignment is:

• Conduct financial forecasting techniques using Excel.