Obtain the income statements for Target Corporation for the fiscal years ending in 2011, 2012, 2013, 2014, and 2015. Target's fiscal year ends near the end of January or the beginning of February.

The 2013-2015 statements are included in Target's 2015 annual report and Form 10-K, dated March 13, 2015.

The 2011 and 2012 statements are in its 2012 annual report and Form 10-K, dated March 15, 2012.

To obtain the Form 10-Ks, you can use the EDGAR system (see Appendix A at the back of this text for instructions), or they can be found under the "Investors Relations" link on the company's corporate website, www.target.com. The company's annual reports are also available on its website. Note that this problem ignores Target's revenues and expenses related to its credit card operations.

Required

a. Compute the percentage change for each of the following categories of revenues and expenses for 2011 to 2012, 2012 to 2013, and 2013 to 2014.

Target Corporation

Sales (not total revenues)

Cost of sales

Selling, general, and administrative expenses

Depreciation and amortization

Using an Excel spreadsheet will make this task much easier. After you have obtained these averages (you should have three averages for each of the six revenue and expense items), calculate an average of the changes for each item. The answer for the "Depreciation and amortization" item is shown as an example.

_______________________________Percentage Change

2011-2012..................................................2.3%

2012-2013.................................................. (4.1)

2013-2014.................................................. (2.3)

Average of the changes........................... (1.4)%

b. Prepare a budgeted income statement for 2015 (the fiscal year ending January 31, 2015), and compare the budgeted data to the actual results for 2015. To calculate budgeted amounts, multiply (1 + Average percentage change) in each revenue and expense item from Requirement b by the dollar amount of the corresponding revenue or expense item from 2014. This will represent the budgeted amount for that item for 2015. Don't forget to use decimal data and not percentage data. Subtract the actual 2015 results from the budgeted results. Finally, divide the actual versus budgeted difference by the budgeted amount to determine a percentage variance from the budget. The answer for the "Depreciation and amortization" item is shown as an example (dollar amounts are in millions).

Transcribed Image Text:

(5+3) Average [1+(1x2) Percentage from Budget 0.082(8.2%) 2014 3-year2015 2015 (3-4) Varlance Actual Change BudgetActual Varlance Depreciation and amortization $1,996 (0.014) $1.968 $2.129 $161