Financial modeling test
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? ✔️✔️$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? ✔️✔️$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. ✔️✔️$240,500
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?
✔️✔️$6,911
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! ✔️✔️$83,422
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.
✔️✔️$252,623
Questions 5-16 will use the American Eagle Outfitters Model Template.
What is cash from investing activities in the year ended 1/31/2023? ✔️✔️($219,647)
Questions 5-16 will use the American Eagle Outfitters Model Template.
What is the first year of the forecast where AEO does NO buybacks? ✔️✔️01/31/21
Questions 5-16 will use the American Eagle Outfitters Model Template.
In what year of the forecast does AEO need to draw on the revolver for the first time?
✔️✔️01/31/22
Questions 5-16 will use the American Eagle Outfitters Model Template.
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? ✔️✔️$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? ✔️✔️$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. ✔️✔️$240,500
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?
✔️✔️$6,911
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! ✔️✔️$83,422
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.
✔️✔️$252,623
Questions 5-16 will use the American Eagle Outfitters Model Template.
What is cash from investing activities in the year ended 1/31/2023? ✔️✔️($219,647)
Questions 5-16 will use the American Eagle Outfitters Model Template.
What is the first year of the forecast where AEO does NO buybacks? ✔️✔️01/31/21
Questions 5-16 will use the American Eagle Outfitters Model Template.
In what year of the forecast does AEO need to draw on the revolver for the first time?
✔️✔️01/31/22
Questions 5-16 will use the American Eagle Outfitters Model Template.
