Question: Full Project Context: Hi , I m completing a business / accounting presentation on Aritzia Inc. ( TSX: ATZ ) for my Grade 1 2
Full Project Context: Hi Im completing a businessaccounting presentation on Aritzia Inc. TSX: ATZ for my Grade Financial Accounting course. This project includes an indepth financial analysis report, and I need someone to complete the financial analysis section Part on my behalf. The work is split into two parts: a Comparative Analysis and b Ratio Analysis, both based on Aritzias three most recent fiscal years ideally and or if data is unavailable PART a: Comparative Financial Analysis Instructions: Please retrieve Aritzias full Income Statement and Balance Sheet for each of the most recent years. Then: Create a Comparative Income Statement, including: Net Revenue Sales Cost of Goods Sold COGS Gross Profit Operating Expenses SG&A etc. Operating Income EBIT Net Income after taxes Create a Comparative Balance Sheet, including: Current Assets cash inventory, accounts receivable NonCurrent Assets property goodwill, etc. Current Liabilities accounts payable, shortterm debt LongTerm Liabilities Total Shareholder Equity Horizontal Analysis: Show change yearoveryear for each line item NewYearPreviousYearPreviousYearNew Year Previous Year Previous Year NewYearPreviousYearPreviousYear Vertical Analysis: Income Statement: Express each line as a of total revenue Balance Sheet: Express each item as a of total assets Deliverables: Excel or Google Sheet with properly labeled columns and formulas Include a tab for the Income Statement and another for the Balance Sheet Add a brief paragraph summary explaining what the results show eg revenue growth trend, asset increase, margin trends, etc. PART b: Ratio Analysis Instructions: Please calculate the following ratios for each year year comparison If certain data is missing eg interest expense you can mark as NA Required Ratios: Liquidity Ratios: Current Ratio Current Assets Current Liabilities Quick Ratio Current Assets Inventory Current Liabilities optional Profitability Ratios: Gross Profit Margin Gross Profit Net Revenue Net Profit Margin Net Income Net Revenue Return on Equity ROE Net Income Shareholder Equity Return on Assets ROA Net Income Total Assets Efficiency Ratios: Inventory Turnover COGS Average Inventory Accounts Receivable Turnover Net Sales Average AR optional Solvency Ratios: DebttoEquity Total Liabilities Shareholder Equity Equity Ratio Equity Total Assets Interest Coverage EBIT Interest Expense if available Deliverables: Ratio Table years sidebyside Include formulas used to calculate each One short paragraph explaining what the ratios indicate about the company eg Is Aritzia improving? Is it financially stable? Are margins or solvency improving or declining? pleaes refer to the photo as well thats the offical thing
what info do you want more of
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
