Review: Financial Statement Modeling Retake Exam
Question 1
Questions 1-4 will refer to AEO’s latest 10K, which you can download by clicking here.
Ignoring the impact of stock based compensation expense included in cost of sales, what is gross profit for the year ending
1/30/2016?
$1,267,757
$1,323,734
$1,326,181
$1,337,711
$1,372,581
Question 2
Questions 1-4 refer to AEO’s latest 10K.
What is depreciation expense for the year ending 1/30/2016?
$112.6 million
$119.6 million
$128.4 million
$140.6 million
$148.2 million
Question 3
Questions 1-4 refer to AEO’s latest 10K.
What is AEO’s share count on 3/7/2016?
180.1 million
180.7 million
194.4 million
196.2 million
196.7 million
Question 4
Questions 1-4 refer to AEO’s latest 10K.
As of 1/30/2016, what is the sum of the next 5 years’ amortization expenses of AEO’s intangible assets?
$3.5 million
$9.7 million
$12.2 million
$15.6 million
$17.3 million
Question 5
For Questions 5-16, It is July 2017 and you are an investment banking analyst tasked with forecasting the financials of American Eagle
Outfitters.
This study You
source was have been
downloaded by given a partially filled
100000895666835 in model template.
from CourseHero.com Please download
on 01-24-2025 it by-06:00
11:32:15 GMT clicking here.
https://www.coursehero.com/file/161193716/WSP-financial-modelingpdf/
, What is gross profit for the year ending 1/31/2023?
$1,709,188
$1,978,598
$3,246,406
$3,758,121
$10,758,307
Question 6
Questions 5-16 will use the American Eagle Outfitters Model Template.
What is SG&A for the year ending 1/31/2023?
$1,298,397
$1,435,043
$1,630,246
$1,673,100
$1,769,945
Question 7
Questions 5-16 will use the American Eagle Outfitters Model Template.
What is D&A for the year ending 1/31/2025? Be careful! This question is asking for a different year than the last question.
$222,853
$231,078
$238,700
$238,900
$240,500
Question 8
Questions 5-16 will use the American Eagle Outfitters Model Template.
For the purpose of this question only, instead of assuming a 20-year useful life for intangible assets, assume a 4-year useful life for
all newly purchased intangible assets in the forecast period. What is amortization expense for the year ending 1/31/2025?
$2,911
$5,911
$6,911
$11,911
$12,911
Question 9
Questions 5-16 will use the American Eagle Outfitters Model Template.
What is the balance of total current assets excluding cash minus total current liabilities as of 1/31/2025. Remember to reset your
model to remove assumptions unique to the last question!
$59,666
$83,422
($85,928)
($244,111)
$480,499
This study source10was downloaded by 100000895666835 from CourseHero.com on 01-24-2025 11:32:15 GMT -06:00
Question
https://www.coursehero.com/file/161193716/WSP-financial-modelingpdf/