

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
A comprehensive set of questions and verified answers related to financial statement modeling, specifically focused on the american eagle outfitters (aeo) company. The questions cover various aspects of financial analysis, including gross profit, depreciation expense, share count, amortization expenses, and forecasting financial statements. Intended to serve as a study resource for students or professionals interested in developing their financial modeling skills, particularly in the context of the retail industry. The detailed answers and explanations provided can help users deepen their understanding of financial statement analysis and enhance their ability to accurately forecast a company's financial performance.
Typology: Exams
1 / 3
This page cannot be seen from the preview
Don't miss anything!


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? - ANS $1,323, Questions 1-4 refer to AEO's latest 10K. What is depreciation expense for the year ending 1/30/2016? - ANS $140.6 Million Questions 1-4 refer to AEO's latest 10K. What is AEO's share count on 3/7/2016? - ANS 180.7 million 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? - ANS 17.3 million For Questions 5-16, It is July 2017 and you are an investment banking analyst tasked with forecasting the financials of American Eagle Outfitters. You have been given a partially filled in model template. Please download it by clicking here. What is gross profit for the year ending 1/31/2023? - ANS $1,709, Questions 5-16 will use the American Eagle Outfitters Model Template. What is SG&A for the year ending 1/31/2023? - ANS $1,298, 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. - ANS $240, 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? - ANS $6, 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! - ANS $83, Questions 5-16 will use the American Eagle Outfitters Model Template. What is the difference between cash from operations and net income in the year ended 1/31/2023? Be careful! This question is asking for a different year than the last question. - ANS $252,