Module $5$ Assignment $($Individual Assignment$)$

Chapter $10$: Forecasting and Budgeting

In this assignment you will have the opportunity to demonstrate your ability to

$1)$ Forecast financial information for decision$-$making needs

$2)$ Use Excel to create and format interactive reports.

The Home Depot is a leading specialty retailer of hardware and home improvement products and is the second$-$largest retail store chain in the United States. It operates large warehouse$-$style stores. In $2014$ and $2015,$ Home Depot invested in five new stores. The following table provides summary hypothetical data for Home Depot.

$*$ in millions

Instructions

Using the information above, create a report in Excel for $2015$ and $2016$ showing the company's:

$1)$ Number of stores $($Average for the year$)$

$2)$ Sales revenues

$3)$ Inventory

$4)$ Capital expenditures $($net$)$ for the year

For simplicity, assume that in $2016,$ Home Depot's sales revenues will grow, but only because it will open new stores. At this time, Home Depot is not sure how many stores it will open in $2016,$ so you are tasked with creating a spreadsheet that will automatically update based on the input provided. For example, if one enters that $10$ new stores will be opened in $2016,$ the $2016$ column should update with the new correct information. If $20$ stores are entered, then the $2016$ column should update with these new calculations. Assume that each new store that is opened will only be open for business for an average of one$-$half of the year.

You can use external resources to explore how to use specific Excel functions and formulas, but any other external resources are not allowed. Any academic dishonesty will result in a $0$ or an F in the course. When you are finished, please submit your Excel file in the dropbox. Other file types will result in a $0.$

$$ A B C D $1$ Module $5$ Assignment $-$ Home Depot Chapter $10$: $2$ Forecasting and Budgeting $320142015$ Year$+14$ Number of Stores $ $2,269\mathrm{.}00$ $ $2,274\mathrm{.}00$ $ $2,284\mathrm{.}005$ New Stores $ $5\mathrm{.}00$ $ $10\mathrm{.}006$ Average Stores $ $2,271\mathrm{.}50$ $ $2,279\mathrm{.}0078$ Sales Revenues $ $83,176\mathrm{.}00$ $$88,519\mathrm{.}00$ $ $88,811\mathrm{.}279$ Sales per Average Store $ $38\mathrm{.}971011$ Inventory $ $11,079\mathrm{.}00$ $$11,809\mathrm{.}00$ $$11,860\mathrm{.}9312$ Ending Inventory per Store $ $5\mathrm{.}191314$ Capital Expenditures $ $1,442\mathrm{.}00$ $ $1,503\mathrm{.}00$ $ $3,006\mathrm{.}0015$ Capital Expenditures per New Store in $2015$ $ $300\mathrm{.}601617$

Just want to make sure i have the right idea, please help.