Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE FILL OUT THIS FIRST FINANCIAL SHEET; ALL INFORMATION FOLLOWED; Formulas last. (fill out as much as you can please ASAP) Financial Fiscal Year Fiscal

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

PLEASE FILL OUT THIS FIRST FINANCIAL SHEET; ALL INFORMATION FOLLOWED; Formulas last. (fill out as much as you can please ASAP)

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Financial Fiscal Year Fiscal Year Competitor #1 Competitor #2 Industry Recommended Substantiate the recommended goal based on the Measure 2014 2013 2014 2014 Norms 2014 Goal 2015 columns and competitors on the left. Aeropostale Aeropostale Abercrombie American & Fitch Eagle Annual Sales % Increase/ (Decrease) Gross Profit Margin % Operating Expense % (S, G, and A) Net Profit Margin % Inventory Turn Current Ratio Quick Ratio Total Debt to Equity RatioJan 15 Feb 14 Feb 13 Revenue 1,838.66 2,090.90 2,386.18 Assets Jan 15 Feb 14 Cost of Goods Sold 1,502.23 1,733.54 1,796.82 Current Assets Gross Profit 336.44 357.36 589.36 Cash 151.75 106.52 Gross Profit Margin Net Receivables SG&A Expense 508.61 542.57 529.85 Inventories 130.47 172.31 Depreciation & Amortization Other Current Assets 29.94 26.29 Operating Income (213.14) [185.21) 59.51 Total Current Assets 349.29 376.62 Operating Margin (11.5996] (8.8696] 2.4996 Net Fixed Assets 130.11 235.40 Nonoperating Income Other Noncurrent Assets 10.07 7.04 Nonoperating Expenses Total Assets 512.19 647.64 Income Before Taxes (221.92) [186.12) 59.03 Income Taxes (15.46) (44.29) 24.10 Liabilities Jan 15 Feb 14 Net Income After Taxes (206.46) (141.83) 34.92 Current Liabilities Accounts Payable 88.29 138.25 Continuing Operations (206.46) [141.83) 34.92 Short Term Debt Discontinued Operations Other Current Liabilities 0.00 0.68 Total Operations (206.46) (141.83) 34.92 Total Current Liabilities 198.85 240.36 Total Net Income (206.46) [141.83) 34.92 Long Term Debt Net Profit Margin Other Noncurrent Liabilities 214.73 126.59 Total Liabilities 418.64 366.95 Diluted EPS from Continuing (2.62] [1.81) 0.43 Operations Shareholder's Equity Jan 15 Feb 14 Diluted EPS from Total (2.62) [1.81) 0.43 Operations Preferred Stock Equity 0,79 Diluted EPS from Total Net (2.62) (1.81) Common Stock Equity 0.80 0.43 Income Total Equity 93.55 280.69 Dividends Per Share Shares Outstanding (M) 79.14 78.50Abercrombie & Fitch Jan 15 Feb 14 Feb 13 All amounts in millions of |US Dollars except per share amounts. Revenue 3,744.03 4,116.90 4,510.81 Feb 14 Cost of Goods Sold 1,430.46 1,541.46 1,694.10 Assets Jan 15 2,575.44 Current Assets Gross Profit 2,313.57 2,816.71 Cash 520.71 600.12 Gross Profit Margin 2,161.87 2,389.47 2,461.81 Net Receivables 52.91 67.97 SG&A Expense Inventories 460.79 530.19 Depreciation & Amortization Other Current Assets 116.57 100.46 Operating Income 113.52 80.82 374.23 3.0396 1.969% 8.309% Total Current Assets 1,164.97 1,320.57 Operating Margin Net Fixed Assets 67.00 1,131.34 Nonoperating Income Other Noncurrent Assets 172.78 198.86 Nonoperating Expenses 366.95 Total Assets 2,505.17 2,851.00 Income Before Taxes 99.15 73.28 Income Taxes 47.33 18.65 129.93 Liabilities Jan 15 Feb 14 Net Income After Taxes 51.82 54.63 237.01 Current Liabilities Accounts Payable 141.69 130.72 Continuing Operations 51.82 54.63 237.01 Short Term Debt 2.10 15.00 Discontinued Operations Other Current Liabilities 59.43 99.67 Total Operations 51.82 54.63 237.01 Total Current Liabilities 485.96 568.22 Total Net Income 51.82 54.63 237.01 Long Term Debt 341.83 180.73 Net Profit Margin Other Noncurrent Liabilities 287.68 372.56 Total Liabilities 1,115.47 1,121.50 Diluted EPS from Continuing 0.71 0.69 2.85 Operations Shareholder's Equity Jan 15 Feb 14 Diluted EPS from Total 0.71 0.69 2.85 Operations Preferred Stock Equity 1.03 1.03 Diluted EPS from Total Net 0.71 0.69 2.85 Common Stock Equity Income Total Equity 1,389.70 1,729.49 Dividends Per Share 0.80 0.80 0.70 Shares Outstanding (M) 69.35 76.40American Eagle Jan 15 Feb 14 Feb 13 All amounts in millions of US Dollars except per share amounts. Revenue 3,282.87 3,305.80 3,475.80 Assets Jan 15 Feb 14 Cost of Goods Sold 2,128.19 2,191.80 2,085.48 Current Assets Gross Profit 1,154.67 1,114.00 1,390.32 Cash 410.70 418.93 Gross Profit Margin Net Receivables 67.89 73.88 SG&A Expense 806.50 796.51 834.60 Inventories 278.97 291.54 Depreciation & Amortization 141.19 131.97 126.25 Other Current Assets 73.85 83.72 Operating Income 155.77 141.06 394.61 Total Current Assets 890.51 923.56 Operating Margin 4.74% 4.2796 11.35%% Net Fixed Assets 694.86 637.42 Nonoperating Income 3.74 1.02 7.43 Other Noncurrent Assets 7.20 5.55 Nonoperating Expenses 3.74 1.02 7.43 Total Assets 1,696.91 1,694.16 Income Before Taxes 159.50 142.08 402.04 Income Taxes 70.72 59.09 137.94 Liabilities Jan 15 Feb 14 Net Income After Taxes 88.79 82.98 264.10 Current Liabilities Accounts Payable 191.15 203.87 Continuing Operations 88.79 82.98 264.10 Short Term Debt Discontinued Operations (8.47) (31.99) Other Current Liabilities 111.39 105.87 Total Operations 80.32 82.98 232.11 Total Current Liabilities 459.09 415.48 Total Net Income 80.32 82.98 232.11 Long Term Debt Net Profit Margin Other Noncurrent Liabilities 98.07 112.51 Total Liabilities 557.16 527.99 Diluted EPS from Continuing 0.46 0.43 1.32 Operations Shareholder's Equity Jan 15 Feb 14 Diluted EPS from Total 0.42 0.43 1.16 Operations Preferred Stock Equity 2.50 Diluted EPS from Total Net 0.42 0.43 1,16 Common Stock Equity 2.50 Income Total Equity 1,139.75 1,166.18 Dividends Per Share 0.50 0.38 2.05 Shares Outstanding (M) 194.52 193.15FM 422 Merchandising Strategies Benchmarks: Annual 2014 Industry "Norms " 2014 2014 2014 2014 2014 Specialty Mass Market Off Price Pure on line Store Dept Store Stores Stores (Amazon) Annual Sales Inc/ Dec% 1.6% 2.0% 1. 7% 5.8% 19.5% Gross Margin % 42.1% 37.5% 25.4% 29.7% 29.5% SG&A % 24.0% 27.6% 19.4% 17.4% 5.6% Net Profit % 3.9% 3.4% 2.6% 7.1% (-.3%) Inventory Turn 5.46 3.27 7.72 5.88 7.56 Current Ratio 1.9 1.81 1.00 1.53 1.12 Quick Ratio 1.12 0. 74 0.30 D. 7 0.82 Total Debt to Equity Ratio 1.83 2.26 1.57 1.83 4.07 SPRING SEASON FALL SEASON 2014 2015 2016 2014 2015 2016 SMTWT SMTWT SM T W T F S 2 3 4 5 SM T WT F S 31 1 2 3 SM T W SM T WT F S 2 3 4 5 9 10 11 12 13 9 10 11 12 13 1 18 9 10 11 12 13 E U 10 11 12 13 14 15 1 10 11 12 15 31 1 2 5 6 A 27 B 16 17 18 19 20 2 15 16 17 18 19 20 21 14 15 16 17 18 19 20 B 21 22 23 24 25 26 27 G 17 18 19 20 21 22 24 25 26 27 28 29 E 16 17 18 19 20 21 9 10 0 23 24 25 26 27 28 1 23 24 25 26 27 28 14 15 16 17 18 19 20 G 29 22 23 24 25 26 27 28 21 22 23 24 25 26 27 30 SMTV SMT SM T W 9 10 11 12 11 12 $ 31 F S 7 8 9 10 11 12 30 31 1 28 29 30 31 15 16 17 18 18 19 P 14 15 1 7 8 9 10 E 3 22 2 17 18 19 15 16 17 30 31 21 22 2 19 2 14 15 16 17 P 526 2 21 22 23 24 T 28 29 3 F S 13 1 6 27 17 181 14 15 C 26 27 28 29 30 25 26 2 25 26 27 28 29 30 23 24 25 26 2 5 M 18 1 6 27 28 29 22 23 24 2 22 23 24 25 mg SM 1 12 8 9 10 1 12 10 1 12 28 2 16 12 13 12 1 8 9 10 E 45 29 30 23 24 25 28 29 30 1 2 23 14 15 16 17 C 46 24 26 27 28 29 30 24 25 E 28 29 30 31 20 21 22 28 27 28 29 30 31 19 20 2 122 23 24 SM T W T January 2016 25 26 27 28 29 30 31 48 SM T WT F SM T WT F S January 2015 SM T January 2017 SM T V T F S 6 7 8 8 10 13 14 15 1 A 11 12 13 1 2 3 4 5 6 7 1 49 21 22 23 24 0 11 12 13 14 15 1 15 16 1 14 15 9 10 11 12 13 14 A 50 26 Y 27 28 29 30 31 20 21 22 23 24 25 10 11 12 1 26 27 28 29 30 31 1 17 18 19 20 21 22 23 L 24 25 26 27 28 29 30 18 19 20 21 22 25 26 27 28 29 30 17 18 19 20 21 24 25 26 27 28 29 15 16 17 18 19 20 21 N 51 22 23 24 25 26 27 28 Green shaded boxes indicate a Sales Release Date. Black shaded boxes indicate the following Holidays: Valentine's Day, Presidents Day, Easter, Mother's Day, Memorial Day, Father's Day, Independence Day, Labor Day, Rosh Hashanah, Yom Kippur, Columbus Day, Halloween, Election Day, Veterans Day, Thanksgiving, Christmas, New Year's Day, and Martin Luther King Day.Attachment: Financial Formulas Financial Measure Measured in... Sales Increase (Decrease) % Calculated as... this eriod's sales - last ear's com arable eriod's last year's comparable period's 58 sales sales Gross Margin % $ gross prot $ net sales Operating Expense % 3 operating expenses gs,g, and a! (S, G, and A) $ net sales Net Prot % 3 net prot 6 $ net sales Earnings per Share $ $ net prot number of shares outstanding Dividends per Share $ 3 total dividends paid number of shares outstanding Inventory Turns # of times $ cost of goods sold (income statement) 55 inventory (balance sheet) Current Ratio # of times $ total current assets $ total current liabilities Quick Ratio # of times 3 total current assets - $ inventory $ total current liabilities Total Debt to Equity Ratio # of times 3 total liabilities $ total shareholder's equity

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

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

15th edition

1337671002, 978-1337395250

More Books

Students also viewed these Finance questions

Question

Review the findings of humanistic psychotherapy outcome research.

Answered: 1 week ago