Could you look over this assignment and see if you could do it? It's not much writing it's mainly journel entries.
Directions RequiredOther info Balance SheetIndustry Ratios Income Statement Ratio Analysis Group Project – Part 2 Continuing with our hypothetical retail company from Part 1, imagine now that the start-up company from Part 1 is American Eagle Outfitters (stock symbol: AEO). Assume now that you are an investment analyst* who focuses on the retail industry. The FY 2017 (As of February 3, 2018) Balance Sheet and Income Statement for AEO and Industry Ratio Report is provided. Download the fiscal year 2018 ("FY 2018" - as of February 2, 2019) American Eagle Outfitters ("AEO") annual report and form 10-K from https://investors.ae.com/financials-filings/default.aspx and complete the following steps: 1. Update the Balance Sheet and Statement of Operations for FY 2018. 2. Compute financial ratios for FY 2018 and FY 2017. 3. Compute changes in ratios on a Year-over-Year basis. 4. Compute difference between FY 2018 and industry average ratios. 5. Write a BRIEF (limit of one-page, double-spaced, 12-point font) report summarizing the ratio analysis, focusing on describing what the ratios indicate overall and what the YoY changes and differeces from industry averages indicate about AEO. You will submit this Excel Template (steps 1-4) and a Word document (step 5). *Investment analysts collect financial information and analyze investments such as stocks and bonds. Analysts provide recommendations and investing advice to the investing public and often focus on a particular industry in order to provide expert advice in the chosen area. AEO Balance Sheets AMERICAN EAGLE OUTFITTERS, INC.Part 2 Home CONSOLIDATED BALANCE SHEETS February 2,February 3, (in thousands, except per share amounts)20192018 ASSETS Current assets: Cash and cash equivalents$ 413,613 Merchandise inventory398,213 Accounts receivable, net78,304 Prepaid expenses and other78,400 Total current assets-968,530 Property and equipment, net of accumulated depreciation724,239 Intangible assets, net of accumulated amortization46,666 Goodwill15,070 Deferred income taxes9,344 Other assets52,464 Total assets$ -$ 1,816,313 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable$ 246,204 Accrued compensation and payroll taxes54,184 Accrued rent78,619 Accrued income and other taxes12,220 Unredeemed gift cards and gift certificates52,966 Current portion of deferred lease credits12,780 Other liabilities and accrued expenses36,810 Total current liabilities-493,783 Non-current liabilities: Deferred lease credits45,114 Non-current accrued income taxes4,537 Other non-current liabilities34,657 Total non-current liabilities-84,308 Commitments and contingencies-- Stockholders’ equity: Preferred stock, $0.01 par value; 5,000 shares authorized; none issued and outstanding-- Common stock, $0.01 par value; 600,000 shared authorized; 249,566 and 249,566 shares issued; 177,316 and 181,886 shares outstanding , respectively2,496 Contributed capital603,890 Accumulated other comprehensive loss, net of tax(36,462) Retained earnings1,775,775 Treasury stock, 72,250 and 67,680 shares, respectively, at cost(1,141,130) Total stockholders' equity-1,204,569 Total liabilities and stockholders’ equity$ -$ 1,782,660 AEO Statement of Operations AMERICAN EAGLE OUTFITTERS, INC.Part 2 Home CONSOLIDATED STATEMENTS OF OPERATIONS For the Years Ended Feburary 2February 3 (In thousands, except per share amounts) 20192018 Total net revenue$ 3,795,549 Cost of sales, including certain buying, occupancy and warehousing expenses2,425,044 Gross profit-1,370,505 Selling, general and administrative expenses879,685 Impairment and restructuring charges20,611 Depreciation and amortization expense167,421 Operating income-302,788 Other (expense) income, net(15,615) Income before income taxes-287,173 Provision for income taxes83,010 Income from continuing operations-204,163 Discontinued operations, net of tax-- Net income$ -$ 204,163 AEO Ratios AMERICAN EAGLE OUTFITTERS, INC.Part 2 Home Ratio Analysis For the Years Ended February 2,February 3,Year-over-YearIndustryFY 2018 vs 20192018ChangeRatiosIndustry Liquidity Current Ratio1.52 Activity Inventory Turnover- 06.416.36 Days to Sell Inventory57.390 Receivables Turnover106.12 Average Collection Period3.44 Fixed Asset Turnover5.79 Total Asset Turnover1.93 Accounts Payable Turnover14.60 Profitability Gross Profit Margin34.94% Net Profit Margin3.85% Return on Equity12.57% Return on Assets7.44% Leverage Debt-to-Equity0.70 Dividends Dividend Yield2.59% Please use Excel formulas to calculate ratios. Inventory Turnover given as an example. Click fx in the formula bar to bring up the Formula Builder. If FY 2016 financial information is needed for a ratio, you can find it in the annual reports at https://investors.ae.com/financials-filings/default.aspx. Industry Ratio Report INDUSTRY RATIO REPORTPart 2 Home Retail Family Clothing Stores LiquidityCOMPANIES USED IN INDUSTRY ANALYSIS Quick Ratio1.52Company NameTicker Symbol American Eagle Outfitters, Inc.AEO ActivityBuckle, Inc.BKE Inventory Turnover6.36The Cato CorporationCATO Days to Sell Inventory57.390Chico's FAS Inc.CHS Receivables Turnover106.12daysExpress, Inc.EXPR Average Collection Period3.44Francesca's Holdings CorporationFRAN Fixed Asset Turnover5.79daysThe Gap, Inc.GPS Total Asset Turnover1.93Tilly's, Inc.TLYS Accounts Payable Turnover14.60Urban Outfitters, Inc.URBN Zumiez, Inc.ZUMZ Profitability Gross Profit Margin34.94% Net Profit Margin3.85% Return on Equity12.57% Return on Assets7.44% Leverage Debt-to-Equity0.70 Dividends Dividend Yield2.59%