Question

In: Accounting

Common-Size and Pro Forma Income Statements Refer to the income statements for The Gap, Inc., presented...

Common-Size and Pro Forma Income Statements
Refer to the income statements for The Gap, Inc., presented below.

a. Prepare common-size income statements for fiscal years 2014 (ending January 31, 2015) and 2013 (ending February 1, 2014).
Round answers to one decimal place (i.e., 0.2568 = 25.7%).

The Gap, Inc.
Common-Size Income Statements
Fiscal year ended Jan. 31, 2015 Feb. 1, 2014
Net sales $15,779 Answer% $15,492 Answer%
Cost of goods sold & occupancy expenses 9,925 Answer% 9,634 Answer%
Gross profit 5,854 Answer% 5,858 Answer%
Operating expenses 3,983 Answer% 3,921 Answer%
Operating income 1,871 Answer% 1,937 Answer%
Interest expense 73 Answer% 59 Answer%
Interest income (3) Answer% (3) Answer%
Income before income taxes 1,801 Answer% 1,881 Answer%
Income taxes 702 Answer% 734 Answer%
Net earnings $1,099 Answer% $1,147 Answer%

b. Prepare a pro forma income statement for the fiscal year 2015 (ending January 30, 2016), based on the following assumptions:
- Net sales total $14,000 million.
- Cost of goods sold and occupancy expenses are 64% of sales.
- Operating expenses total 26% of sales.
- Interest income and interest expense are unchanged from the 2014 amounts.
- The Gap's effective tax rate is 39%.

Round answers to the nearest dollar. Use rounded answers for subsequent calculations.
Use a negative sign with your interest income answer only.

The Gap, Inc.
Proforma Income Statement
Jan. 30, 2016
Net sales $Answer
Cost of goods sold & occupancy expenses Answer
Gross profit Answer
Operating expenses Answer
Operating income Answer
Interest expense Answer
Interest income Answer
Income before income taxes Answer
Income taxes Answer
Net earnings $Answer

Solutions

Expert Solution

  • Requirement ‘a’

All percentage values are calculated by taking “Net Sales” as denominator when Common Size Income Statement is prepared.

The Gap, Inc.

Common-Size Income Statements

Fiscal year ended

Jan. 31, 2015

Feb. 1, 2014

Net sales

$       15,779.00

100.0%

$     15,492.00

100.0%

Cost of goods sold & occupancy expenses

$         9,925.00

62.9%

$      9,634.00

62.2%

Gross profit

$         5,854.00

37.1%

$      5,858.00

37.8%

Operating expenses

$         3,983.00

25.2%

$      3,921.00

25.3%

Operating income

$         1,871.00

11.9%

$      1,937.00

12.5%

Interest expense

$             73.00

0.5%

$           59.00

0.4%

Interest income

$              (3.00)

0.0%

$            (3.00)

0.0%

Income before income taxes

$         1,801.00

11.4%

$      1,881.00

12.1%

Income taxes

$            702.00

4.4%

$         734.00

4.7%

Net earnings

$         1,099.00

7.0%

$      1,147.00

7.4%

  • Requirement ‘b’

Figures are written in “$ millions”

The Gap, Inc.

Proforma Income Statement

for the fiscal year ending

Jan. 30, 2016

Net sales

$ 14,000.00

Cost of goods sold & occupancy expenses

$ 8,960.00

Gross profit

$ 5,040.00

Operating expenses

$ 3,640.00

Operating income

$ 1,400.00

Interest expense

$       73.00

Interest income

$        (3.00)

Income before income taxes

$ 1,330.00

Income taxes

$     518.70 or $ 519

Net earnings

$     811.30 or $ 811


Related Solutions

• Describe pro forma income and the importance of pro forma income in the evaluation of...
• Describe pro forma income and the importance of pro forma income in the evaluation of the income statement. Choose at least two items that are excluded from pro forma income. Suggest to management why including the items would be misleading to investors and creditors.
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in...
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in this case are budgeted statements for 2018 based on the new location scenario at the bottom of the page) Pro Forma Income Statement Pro Forma Balance Sheet PEYTON APPROVED PRO FORMA INFORMATION The company is planning to open another location in 2018 . Prepare pro forma financials for 2018 for the new location using the following information: 1. Cost of leasing commercial space: $1,500...
LUKE’S HOLIDAY SUPPLIES, INC. Pro Forma Statements Problem A)        1.             Income Statement           &nbs
LUKE’S HOLIDAY SUPPLIES, INC. Pro Forma Statements Problem A)        1.             Income Statement                                                          Balance Sheet                              Year Ended 2018                                                              12/31/18             Sales                                               $12,520                Cash                                                    $   110             Cost of Goods Sold                            9,698                Marketable Securities                            360             Gross Profit                                        2,882                Accounts Receivable                            2,220             Expenses                                            1.594                Inventory                                            3,210             Earnings Before Interest and Tax      1,228                    Total Current Assets                       5,900             Interest                                                  278 Earnings Before Tax                           950    Property/Plant/Equipment       4,730             Tax (40%)                                           380...
LUKE’S HOLIDAY SUPPLIES, INC. Pro Forma Statements Problem A)        1.             Income Statement           &nbs
LUKE’S HOLIDAY SUPPLIES, INC. Pro Forma Statements Problem A)        1.             Income Statement                                                          Balance Sheet                              Year Ended 2018                                                              12/31/18             Sales                                               $12,520                Cash                                                    $   110             Cost of Goods Sold                            9,698                Marketable Securities 360             Gross Profit                                        2,882                Accounts Receivable 2,220             Expenses                                            1.594                Inventory 3,210             Earnings Before Interest and Tax      1,228                Total Current Assets 5,900             Interest                                                  278 Earnings Before Tax                           950                Property/Plant/Equipment       4,730             Tax (40%)                                           380                Accumulated Depreciation     680            ...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales $      32,000 Assets $25,300 Debt $        5,800 Costs $        24,400 ________ Equity $        19,500 Net income $        7,600 Total $25,300 Total $      25,300 It expects 15% sales increase. It also predicts every item on the balance sheet will increase by 15% as well. 1.Create the pro forma statements. 2. What’s the plug variable here? 3. If Fire Corp pays half of income as dividend,...
How to develop pessimistic and optimistic pro forma statements of comprehensive income?
How to develop pessimistic and optimistic pro forma statements of comprehensive income?
A. What do pro forma financial statements show? B. What are pro forma financial statements based...
A. What do pro forma financial statements show? B. What are pro forma financial statements based on? C. What are the strategic benefits of making financial projections on pro forma statements?
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
Pro Forma statements in general: “Pro forma” means “made in advance,” and consists of best (hopefully...
Pro Forma statements in general: “Pro forma” means “made in advance,” and consists of best (hopefully informed) guesses. Which is more dangerous to the company: overestimating sales or underestimating sales? (In your answer describe the downside to either mistake. Is there an upside to either mistake? If so, describe that/those as well.)
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A for a 5-year period and a terminal year, based on various assumptions, which already have been completed. Company A Income Statement For the Years Ended 2017 2018 2019 2020 2021 2022 Terminal year 2023 Sales     550.00            825.00               990.00                  1,138.50                    1,252.35                    1,340.01                        1,393.62                 1.50 (825*120%) (990*115%) (1138.50*110%) (1252.35*107%) (1340.01*104%) Cost of Sales     275.00            288.75              ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT