complete the analysis using the Excel workbook provided. Document your team discussion in the chart below.

Considerations for Vacuum$\_$Bonanza$\_$Inc.

Vacuum Bonanza Inc. manufactures vacuum cleaners. It sells its vacuums to large retailers, such as Target and Wal$-$Mart. In $2019,$ Vacuum looked like it might not survive. Its sales were declining and its expenses increasing. However, at the end of $2019($due to a leveraged buyout$)$ new management came to the Company. Their goal was to put the bonanza back into Vacuum Bonanza. The new management had a reputation for aggressive "chainsaw" style cutting of expenses and employees.

During $2020,$ the new management reported to the press that they had hired new engineers, streamlined operations, and cut payroll expenses. Indeed, management told the press that it took a "chainsaw" approach to slashing payroll through layoffs.

In $2020,$ they introduced a new vacuum cleaner with more power. According to Consumer Reports, the new vacuum was high powered, but did not add anything fresh to the market, in terms of vacuum technology. Further, in $2020,$ they implemented a bonus plan for executives.

Please perform the vertical $($common size$)$ and horizonal $($trend$)$ analysis for Vacuum Bonanza. Then as a team, complete the chart below. Prioritize which six accounts you believe are most at risk of material misstatement, by listing the most serious matter as the $1$ st priority. Do not list an account$/$assertion combination $($columns $2$ and $5)$ more than once. Provide evidence for why your team believes that the account is at risk of misstatement in the form of a ratio and explanation.

N$.$ submit a Team agreed upon Vertical, Horizonal, and other Ratio analysis. You may submit as a screen shot copied in this document or as a separate Excel document. As a Team help each other to understand the significance of the ratios and how to compute them, if necessary. However, if you've forgotten how to do ratios, they are easy to find on the Web. One place is Investopedia. Financial Ratios $($

investopedia.com$).$ Keep in mind that for the turn ratios $($receivables$,$ assets, inventory, equity$),$ we use the average $(($beginning balance $+$ ending balance$)/2)$ in the denominator. Used LinkedIn Learning to help you with Excel $($find on our home page at the bottom, under "Student" column.$)$

$\backslash$table$[[$Question$,\backslash$table$[[$Total$],[$possible$]],\backslash$table$[[$Concern is$],[$arat$]],\backslash$table$[[$Ratio$],[$Evidence$],[$matches the$],[$logical$],[$arener$.]],\backslash$table$[[$The ratio$],[$evidence and$/$or$],[$qualitative$],[$discussion is$],[$explained in a$],[$manner that$],[$supports a risk of$],[$material$],[.]],\backslash$table$[[$Assertion is$],[$logical for$],[$the concern,$],[$account and$],[$evidence$.],[$Discuss why$],[$you chose$],[$this$],[$assertion$($s$).]],\backslash$table$[[$Related$],[$account in $=$