Complete the highlighted cells in the AEO Model. The guidelines for the missing

line items are towards the bottom of model starting on line $114.$

Also, pay attention to certain line items which have a note inserted which will give

you more details. These are on lines $131-138$

$1$ What is the Gross Profit dollar generated in $2018?$

What are $2$ possible reasons this could be occurring for AEO

$($keep in mind they are a manufacturer of merchandise$)?$

$2$ What is AR in both $2017$ and $2018?$

What is the trend in DSO's in $2017$ and $2018.$ What are the

drivers of this DSO trend?

Is this a positive or negative trend for the company and why?

$3$ What is the inventory level in $2018?$

What is the trend in Inventory Days. Give $2$ possible reasons

for this trend.

$4$ Give $2$ examples of Asset Rollforwards using AEO's projections

$5$ If AR Days and Inventory Days were to both grow $10\%$ year over year

and revenue would remain at the current growth trajectory provided

in $2017$ and $2018,$ is that a positive or negative trend for AEO?

Why? Be specific with your logic.

$6$ If the company were to implement a policy to reduce DSO's

while reducing its Inventory Days, what is the impact on its

Cash Conversion Cycle? Explain impact on business $($is this positive

or negative and why$).$

$7$ Complete sensitivity analysis in model at the top of the page

Columns S$-$U$,$ Rows $4-13$

$8$ If sales grow an additional $2$ percentage points faster than the current

forecast, which roll forward accounts would change? By how much

and to what levels? Assume Gross Margin remains the same in $\%.$

Are these asset or liability roll forwards? Explain.

PLease give answers on excel