Today we reviewed Ethan Allen’s financial statements. We identified the numbers you need to complete the horizontal, vertical and ratio analysis for 2020. I highly recommend you get started on the project, so you can use this week to ask me any questions you have before the project is due on Sunday, May 1, 2022.
When you are working on the project, you can complete the calculations on the Excel template provided on Blackboard or handwrite the calculations using the word document with the directions.
Once you have completed the calculations, you need to explain your findings. Remember- ratio analysis is done on a comparison basis. You should compare Ethan Allen’s 2020 results to the prior year, to the 2020 La-Z-Boy results (this data is in the chapter 20 PowerPoint) and to the industry average. You need to provide explanations for the calculations. Use the Ethan Allen Annual report (provided on Blackboard) to explain why. You can also use financial articles about Ethan Allen to help you with your interpretation of the data. It takes a minimum of three sentences to explain your results.
The project is due on Sunday, May 1, 2022. This is the last day I will accept the assignment. Please plan your time accordingly.
https://blackboard.matc.edu/bbcswebdav/ ... 80744355_2
https://blackboard.matc.edu/bbcswebdav/ ... 80744360_2
https://blackboard.matc.edu/bbcswebdav/ ... 80744361_2
--- PROJECT
Part 1 Worth 5 points. Using its website and annual report complete the table below om form of business content Corporation industry Conglomerate Headquarters Financial website Producent Come to corporate cordeone) Yes No de de CECO Ceny used for ancial reporting Final reporting bons orthousands Part 2: Worth 20 points. Complete Horizontal Analysis Trend Analysis on the Balance Sheet and income Statement ETHAN ALLEN INTERIORS, INC. BALANCE SHEET CASH & CASH EQUIVALENTS ACCOUNTS RECEIVABLE 2020 2019 DOLLAR CHANGE
Currency used for financial reporting Financial reporting rationem, millions or thousands Part 2: Worth 20 points. Complete Horizontal Analysis (Trend Analysis) on the Balance Sheet and income Statement. DOLLAR CHANGE 2020 2019 ETHAN ALLEN INTERIORS, INC BALANCE SHEET CASH & CASH EQUIVALENTS ACCOUNTS RECEIVABLE INVENTORIES PREPAID EXPENSES TOTAL CURRENT ASSETS PROPERTY-PLANT-EQUIPMENT GOODWILL TOTAL ASSETS TOTAL CURRENT LIABILITIES LONG TERM DEBT TOTAL LIABILITIES TOTAL SHAREHOLDER'S EQUITY TOTAL LIABILITIES & EQUITY Based on your way these question your should de a companha Boy at the shapter 26 PowerPoint
Aled grad roperly 14 TOTAL LIABILITIES & EQUITY Based on your Horizontal analysis, answer these questions your analysis should include a comparison to the La-z-Boy data in the chapter 20 PowerPoint) Which accounts on the Balance Sheet had the most significant increases decreases? Why did the amounts change so much (review annual - report? Which accounts on the income Statement had the most significant ncreases/decreases? Why did the amounts charge so much review annual report How do you know the company is doing well? Use the footnotes in the annual report and press releases to validate your conclusions Part 3. Worth 20 points. Complete Vertical Analysis (common size) on the Balance Sheet and Income Statement ETHAN ALLEN INTERIORS, INC BALANCE SHEET 2020 PERCENTAGE CASH & CASH EQUIVALENTS ACCOUNTS RECEIVABLE INVENTORIES 2015
be 2020 PERCENTAGE 2019 ETHAN ALLEN INTERIORS, INC BALANCE SHEET CASH & CASH EQUIVALENTS ACCOUNTS RECEIVABLE INVENTORIES PREPAID EXPENSES TOTAL CURRENT ASSETS PROPERTY-PLANT EQUIPMENT GOODWILL TOTAL ASSETS TOTAL CURRENT LIABILITIES LONG TERM DEBT TOTAL LIABILITIES TOTAL SHAREHOLDER'S EQUITY TOTAL LIABILITIES & EQUITY 2020 PERCENTAGE 2019 ETHAN ALLEN INTERIORS INC INCOME STATEMENT NET SALES COST OF SALES GROSS PROFIT SELLING GENS ADMIN EXPENSES WWE TAYYDENCE
TOTAL LIABILITIES & EQUITY 2020 PERCENTAGE 2019 ETHAN ALLEN INTERIORS, INC. INCOME STATEMENT NET SALES COST OF SALES GROSS PROFIT SELLING GEN & ADMIN EXPENSES INCOME TAX EXPENSE NET INCOME Based on your Vertical analysis an ese questions your analysis should include comparison to the La-z-Boy data in the chapter 20 PowerPoint) Review the changes from 2010 10 2020 Which counts have sgnificant charges Here any in origineyarper water than when it so, why? What does not you about the con
14 BALANCE SHEET RENTASSETIS QUICKASSETS TOIAL ASSETS AVERAGE TOTAL ASSETS AVERAGE ACCOUNIS RECENARE AVERNE IVENTORY CRRENT LES TOTAL LARMES TOTAL POLITY AVERAGE SE INCOME SIAL NET SALES/TOTAL REVE cogs CROES PROHI FINT NIEREST EXPENSE NET NCOME Part 4: Worth 15 points Calculate Ratios: 2020 LIQUIDITY WORKING CAPITAL CURRENT RATIO QUICKRATO 2020 PROFITABILITY CROSS PROFIT MARGN NET PROFIT MARGIN RETURN ON EQUITY , 6
2020 LIQUIDITY WORKING CAPITAL CURRENT RATIO QUICK RATIO 2020 PROFITABILITY GROSS PROFIT MARGIN NET PROFIT MARGIN RETURN ON EQUITY RETURN ON ASSETS ASSET TURNOVER ASSET MANAGEMENT ACCOUNTS RECEIVABLE TURNOVER AVERAGE COLLECTION PERIOD INVENTORY TURNOVER DAYS SALES INVENTORY 2020 2020 SOLVENCY ANALYSIS DEBT TO EQUITY TIMES INTEREST EARNED DEBT TO TOTAL ASSETS
nd w might be sung or played improperty 9 10 11 12 AVERAGE COLLECTION PERIOD INVENTORY TURNOVER DAYS SALES INVENTORY 2020 SOLVENCY ANALYSIS DEBT TO EQUITY TIMES INTEREST EARNED DEBT TO TOTAL ASSETS Part 6: Worth 40 points. The chapter 20 PowerPoint provided you with financial statement analysis for La-z-Boy The project template provides you with prior year data for Eman Alen expect your analysis to use both the competitor data and the Ethan Allen prior year data in your financial statement analysis in order to cam full credit in this section Based on the ratios you calculated, answer these questions Assess the Liquidity of the Company Based on the working capital computation does the company have enough working capital to meet the needs of the business?
ASETS WE w 1411 HAL Pry TW WE SE NE I. BI 11 POTALANES IRLITIES C A WHE 1 TE MAN WE + 15 WE SIE T BE LAN 741 L TOTALLATIES SHARE TOUT 100 www. WERK LE whe GRAN TA
1 0 0 11 TOTALAT LIBRES C UN 1. w 1991 LP SITE STREET - M I! LOENDE LANDLORETY APYA a e
2011 20TH CONSOLIDATKINTATEMENTO COMPREHENSIVE INCOME modate YM 2012 15 111.11 Groep See IM ring and charge 03 BE SALE ELITE 45 MAT HVI w 078 Prov HELY b. Net 131 1,131 2014 D 1 DEL 2991 STA HOT பெம்மா Net TH CH 4H F Othe Othe Comune Song
Today we reviewed Ethan Allen’s financial statements. We identified the numbers you need to complete the horizontal, ve
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Today we reviewed Ethan Allen’s financial statements. We identified the numbers you need to complete the horizontal, ve
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!