Question

In: Accounting

17. Following are financial statement numbers and select ratios for American Eagle Outfitters for 2016, the...

17. Following are financial statement numbers and select ratios for American Eagle Outfitters for 2016, the year ended January 28, 2017.

Current

Forecast Horizon

Terminal Year

($ thousands)

2016

2017

2018

2019

2020

Sales

3,609,865

3,754,260

3,866,887

3,982,894

4,102,381

4,143,405

Net operating profit after tax (NOPAT)

207,262

213,993

220,413

227,025

233,836

236,174

Net operating assets (NOA)

825,956

859,098

884,871

911,417

938,760

948,148

Forecast assumptions and other financial information for AE Outfitters are as follows:

Sales growth 2017

4%

Sales growth 2018 to 2020

3%

Terminal growth rate

1%

Net operating profit margin (NOPM)

5.7%

Net operating asset turnover (NOAT)

4.37

Discount rate

5%

Shares outstanding in thousands

181,886

Stockholders' equity

$1,204,569

Net nonoperating obligations (NNO)

$(378,613)

Required:

a.   Use the residual operating income (ROPI) model to estimate the value of AE Outfitters’ equity per share at January 28, 2017.

b.   AE Outfitters’ shares closed at $14.28 per share on March 10, 2017, the date the 10-K was filed with the SEC. How does your valuation compare with this closing price?

Solutions

Expert Solution

a.   Use the residual operating income (ROPI) model to estimate the value of AE Outfitters’ equity per share at January 28, 2017.

Answer:

      Current Forecast Horizon Terminal Year
($millions) 2016 2017 2018 2019 2020
Sales 3,609,865 3,754,260 3,866,887 3,982,894 4,102,381 4,143,405
NOPAT 207,262 213,993 220,413 227,025 233,836 236,174
NOA 825,956 859,098 884,871 911,417 938,760 948,148
ROPI (NOPAT- [NOABeg × rw])    172,695    177,458    182,781    188,265 189,236
Discount factor [1 / (1 + rw)t ] $0.95238 $0.90703 $0.86384 $0.82270
PV of horizon ROPI    164,472    160,960    157,893    154,886
Cumulative PV of horizon ROPI          638,211
PV of terminal ROPI       3,892,123
NOA 825,956
Total firm value 5,356,290
Less NNO -378613
Firm equity value $5,734,903
Shares outstanding (millions) 181,886
Stock value per share $31.53


b.   AE Outfitters’ shares closed at $14.28 per share on March 10, 2017, the date the 10-K was filed with the SEC. How does your valuation compare with this closing price?

Answer:

The estimated market price per share is $31.53 at January 28, 2017. AE Outfitters shares closed at $14.28 per share which means that the firm is undervalued when comparing to the estimated per share price of $31.53 which we calculated using ROPI Model . The reason for this undervalue might be either due the lower discount rate or due to aggressive growth projections.

Calculation:

The ROPI model is prepared to determine the firm equity value which is same as the sum of net operating asset book value and the PV of anticipated residual operating income. Here we need to estimate the value of AE Outfitters’ equity per share.

ROPI = Net operating profit after tax - (Net Operating AssetsBeg * rw)

The Net operating profit after tax (NOPAT) , Net Operating Assets (NOA) and the rw is given in the question. There might be difference due to the rounding.

rw / Discount rate = 5%

2017:

ROPI = 213,993 - (825,956 × 5%) = 172,695

2018:

ROPI = 220,413 - (859,098 × 5%) = 177,458

2019:

ROPI = 227,025 - (884,871 × 5%) = 182,781

2020:

ROPI = 233,836 - (911,417 × 5%) = 188,265

Terminal Year:

ROPI = 236,174 - (938,760 × 5%) = 189,236

Then we need to calculate the Discount factor. Which can calculate using formula [1 / (1 + rw)t ]

2017:

Discount factor = [1 / (1 + 5%)1 ] = 0.95238

2018:

Discount factor = [1 / (1 + 5%)2 ] = 0.90703

2019:

Discount factor =[1 / (1 + 5%)3 ] = 0.86384

2020:

Discount factor = [1 / (1 + 5%)4 ] = 0.82270

Now, we can calculate the PV of horizon ROPI, by multiplying the ROPI with Discount factor.

2017:

PV of horizon ROPI = 172,695 * 0.95238 = 164,472

2018:

PV of horizon ROPI = 177,458 * 0.90703 = 160,960

2019:

PV of horizon ROPI =182,781 * 0.86384 = 157,893

2020:

PV of horizon ROPI = 188,265 * 0.82270 = 154,886

Cumulative present value of horizon ROPI is the total of the PV of horizon ROPI = 164,472 + 160,960 + 157,893 + 154,886 = 638,211

Then we need to calculate the PV of terminal ROPI. That is:

PV of terminal ROPI = Terminal Year ROPI/(Discount rate - Terminal growth rate)/(1+growth rate)^No. of years = $189,236 / [0.05 - 0.01] / (1.05)4 = $3,892,123.14 million

The total firm value is the sum of the Cumulative present value of horizon ROPI, PV of terminal ROPI and NOA of 2016 ,

Total Firm value = 638,211 + 3,892,123.14 + 825,956 = 5,356,290

Now, we can calculate the Firm equity value. It is the Total firm value minus the Net nonoperating obligations.

Net nonoperating obligations is given in the question, which is negative. That is - 378,613.

Firm equity value = 5,356,290 - -378,613 = 5,734,903

We are asked to find the the value of AE Outfitters’ equity per share. To get that we need to divide the firm equity value with Shares outstanding.

Shares outstanding = 181,886 in thousands

Stock value per share = 5,734,903 / 181,886  = 31.53


Related Solutions

Following are financial statement numbers and select ratios for Target Corp. for the fiscal year 2016...
Following are financial statement numbers and select ratios for Target Corp. for the fiscal year 2016 (ending January 28, 2017).                Current Forecast Horizon Terminal Year ($ millions) 2016 2017 2018 2019 2020 Total revenues $69,495 $71,580 $73,727 $75,939 $78,217 $78,999 Net operating profit after tax (NOPAT)    3,302      3,436     3,539     3,645     3,754 3,792 Net operating assets (NOA) 21,128 21,757 22,409 23,082 23,774 24,012 Forecast assumptions and other financial information for Target are as follows: Revenue...
Following are financial statement numbers and select ratios for Target Corp. for the fiscal year 2016...
Following are financial statement numbers and select ratios for Target Corp. for the fiscal year 2016 (ending January 28, 2017).                Current Forecast Horizon Terminal Year ($ millions) 2016 2017 2018 2019 2020 Total revenues $69,495 $71,580 $73,727 $75,939 $78,217 $78,999 Net operating profit after tax (NOPAT)    3,302      3,436     3,539     3,645     3,754 3,792 Net operating assets (NOA) 21,128 21,757 22,409 23,082 23,774 24,012 Forecast assumptions and other financial information for Target are as follows: Revenue...
What is financial statement analysis for the american heart association? Select one of the ratios as...
What is financial statement analysis for the american heart association? Select one of the ratios as your topic for discussion. Include what the ratio is designed for in terms of financial statement analysis. When responding to classmates, describe how your ratio selection compares to or contrasts the one that they selected.
Situation Analysis on American Eagle Outfitters – Conduct an online marketing SWOT that highlights the following...
Situation Analysis on American Eagle Outfitters – Conduct an online marketing SWOT that highlights the following (who are the digital customers, analyze the competitors, assess the company’s digital channels landscape
The following is the balance sheet and income statement for Metro Eagle Outfitters, in condensed form,...
The following is the balance sheet and income statement for Metro Eagle Outfitters, in condensed form, plus some information from the cash flow statement. Balance Sheet 2019 2018 2017 Cash and short-term investments $ 632,992 $ 747,044 $ 736,693 Accounts receivable 46,521 40,510 37,121 Inventory 334,452 371,514 303,208 Other current assets 129,835 132,420 101,388 Total current assets 1,143,800 1,291,488 1,178,410 Long-lived assets 581,832 644,482 590,802 Total assets $ 1,725,632 $ 1,935,970 $ 1,769,212 Current liabilities $ 437,902 $ 411,401 $...
Outline an executive summary for an e-marketing plan to support American Eagle Outfitters. This plan must...
Outline an executive summary for an e-marketing plan to support American Eagle Outfitters. This plan must include aspects of the RACE Digital Marketing Planning Framework and its Facebook media platform.
Financial ratios are relationships between two financial statement numbers and are often used in analyzing and...
Financial ratios are relationships between two financial statement numbers and are often used in analyzing and describing a company's performance. Liquidity is a measure of a company’s ability to pay their short-term obligations as they come due. Select and define two ratios and explain how they could be used to describe a company's liquidity.
Retrieve the Form 10-K for American Eagle Outfitters for the fiscal year ending February 3, 2018....
Retrieve the Form 10-K for American Eagle Outfitters for the fiscal year ending February 3, 2018. American Eagle’s Form 10-K can be accessed through the SEC EDGAR database athttps://www.sec.gov/Archives/edgar/data/919012/000156459018006045/aeo-10k_20180203.htm Hints: You will need to search the financial statement footnotes to find some of the information. Also, the financial statements are in thousands, except for per share amounts. If a number is in thousands, please indicate this by writing out the full number or writing ‘(in thousands)’. Furthermore, you will not...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 443555 Operating Costs 326133 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 54355 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 64355 Prepare an income statement and a balance sheet for is company using the information provided. Calculate: 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 499891 Operating Costs 359935 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 59989 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 69989 6. Interest coverage 7. Net profit margin 8. Sales to total assets (Asset turnover) 9. Return on assets 10. Equity multiplier 11. Return on equity
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT