Week 7 Assignment - 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].
  • Complete Week 7 Assignment Word Template [DOCX].
  • Complete Week 7 Assignment Excel Template 6 sheets [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. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.

The specific course learning outcome associated with this assignment is:

• Conduct financial forecasting techniques using Excel.