Financial Statement Modeling Retake Exam, Exams of Advanced Education

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

2023/2024

Available from 07/30/2024

LectDavid
LectDavid 🇬🇧

3

(5)

1.3K documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Financial Statement
modelling Retake Exam from
Wall Street Prep Questions
with Verified Answers
2024(A+ GRADED)
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,734
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,188
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,397
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,500
Questions 5-16 will use the American Eagle Outfitters Model Template.
pf3

Partial preview of the text

Download Financial Statement Modeling Retake Exam and more Exams Advanced Education in PDF only on Docsity!

Financial Statement

modelling Retake Exam from

Wall Street Prep Questions

with Verified Answers

2024(A+ GRADED)

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,