Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Module 5 Assignment (Individual Assignment) Your group will be performing a profitability analysis on your two assigned companies using the formulas found in Chapter 5.

Module 5 Assignment (Individual Assignment)

Your group will be performing a profitability analysis on your two assigned companies using the formulas found in Chapter 5.

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.

2014

2015

Number of stores (total)

2,269

2,274

Sales revenues

*$83,176

*$88,519

Inventory

*$11,079

*$11,809

Capital Expenditures, net

*$1,442

*$1,503

* in millions

Instructions

Using the information above, create a report in Excel for 2015 and 2016 showing the companys:

  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 Depots 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For MBAs

Authors: Peter D. Easton, John J. Wild, Robert F. Halsey, Mary Lea McAnally

6th Edition

161853100X, 978-1618531001

More Books

Students also viewed these Accounting questions

Question

What are their resources?

Answered: 1 week ago