Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I need assistance with number 4 of the Legion Appliance Manufacturing Company sheet for accounting; the part that to identify areas/accounts that may represent
Hello, I need assistance with number 4 of the Legion Appliance Manufacturing Company sheet for accounting; the part that to identify areas/accounts that may represent specific risks relevant to this year?s audit and provide justifications. Attached is the forms used.
Legion Appliance Manufacturing Company Planning Analytical Review Prepared by ______________ Reviewed by _____________ Balance Sheet Dollars (000s omitted) 12/31/2013 12/31/2014 12/31/2015 (Audited) (Audited) (Unaudited) Vertical Analysis 12/31/2013 12/31/2014 12/31/2015 (Audited) (Audited) (Unaudited) Horizontal Analysis 2013 vs 2014 2014 vs 2015 (Audited) (Unaudited) Assets Cash Accounts Receivable Inventories - RM Inventories - WIP Inventories - FG Total Inventories Other Current Assets Total Current Assets Fixed Assets (net) Total Assets 63 14,402 2,682 491 6,589 9,762 708 24,935 18,267 43,202 514 27,801 9,182 638 9,757 19,577 1,449 49,341 15,900 65,241 885 51,076 18,049 4,151 16,935 39,135 3,015 94,111 24,029 118,140 0% 33% 6% 1% 15% 23% 2% 58% 42% 100% 1% 43% 14% 1% 15% 30% 2% 76% 24% 100% 1% 43% 15% 4% 14% 33% 3% 80% 20% 100% 716% 93% 242% 30% 48% 101% 105% 98% -13% 51% 72% 84% 97% 551% 74% 100% 108% 91% 51% 81% Liability and Equity Accounts Payable Accrued Liabilities Current Portion L/T Debt Income Tax Payable Total Current Liabilities Bank Debt Deferred income Taxes Total Liabilities Common Stock Retained Earnings Total Liabilities and Equity 7,344 3,127 2,707 1,554 14,732 14,800 685 30,217 7,775 5,210 43,202 15,072 5,468 900 2,619 24,059 19,841 1,254 45,154 7,775 12,312 65,241 13,288 4,710 1,250 3,782 23,030 62,057 1,881 86,968 7,903 23,269 118,140 17% 7% 6% 4% 34% 34% 2% 70% 18% 12% 100% 23% 8% 1% 4% 37% 30% 2% 69% 12% 19% 100% 11% 4% 1% 3% 19% 53% 2% 74% 7% 20% 100% 105% 75% -67% 69% 63% 34% 83% 49% 0% 136% 51% -12% -14% 39% 44% -4% 213% 50% 93% 2% 89% 81% Income Statement Dollars (000s omitted) 12/31/2013 12/31/2014 12/31/2015 (Audited) (Audited) (Unaudited) Gross Sales 78,428 133,504 183,767 Less: Returns & allow. 2,284 5,270 2,644 Net Sales 76,144 128,234 181,123 Cost of Goods Sold 46,213 70,756 94,934 Gross Margin 29,931 57,478 86,189 Sell, Advertising, R&D expenses 20,105 42,600 64,285 Income from operations 9,826 14,878 21,904 Interrest expense 1,930 1,584 3,189 Income before taxes 7,896 13,294 18,715 Income Taxes 3,807 6,189 7,761 Net Income 4,089 7,105 10,954 EPS 0.46 0.78 1.21 Ratios Current Quick Receivable Turnover Days' sales in ending receivables Inventory Turnover Days' sales in ending inventory Interest expense/debt Ratio Formula Used: Current Quick Receivable Turnover Days' sales in ending receivables Inventory Turnover Days' sales in ending inventory Interest expense/debt 1.7 1.0 5.3 69.2 4.7 77.7 13.0% 2.1 1.2 6.1 60.1 4.8 75.7 8.0% 4.1 2.3 4.6 79.5 3.2 112.9 5.1% = Current Asset/Current Liability = Quick Assets/Current Liability = Net Credit Sale/Average Account Recievable = 365/Recievable Turnover = Cost of Good Sold/Average Inventory = 365/Inventory Turnover = Interest Expenses/Debt Vertical Analysis 12/31/2013 12/31/2014 12/31/2015 (Audited) (Audited) (Unaudited) 100% 100% 100% 3% 4% 1% 97% 96% 99% 59% 53% 52% 38% 43% 47% 26% 32% 35% 13% 11% 12% 2% 1% 2% 10% 10% 10% 5% 5% 4% 5% 5% 6% 0% 0% 0% Horizontal Analysis 2013 vs 2014 2014 vs 2015 (Audited) (Unaudited) 70% 38% 131% -50% 68% 41% 53% 34% 92% 50% 112% 51% 51% 47% -18% 101% 68% 41% 63% 25% 74% 54% 70% 55% Planning the Legion Appliance Audit Legion Appliance Manufacturing Company has been your firm's audit client for the past five years. Approximately four years ago Legion developed a better toaster than had been available and sales took off, especially during the most recent two years, 2014 and 2015. Currently, the company controls approximately 25 percent of the toaster market in the United States. In addition, the company manufactures other products, including vacuum cleaners, floor polishers, and electric fondue pots. Much of the increased sales performance is due to Michael Sinclair, who became the chief executive officer in 2011. Michael and several other officers were able to accomplish a leveraged stock buyout in 2013. This seems to have worked out very well since Michael suggests that his net worth grew from less than $300,000 to well over $5 million due to increases in the value of the common stock he holds in the company. He is also excited since the company's unaudited results show earnings per share of $1.21, one cent more than the most optimistic analysts had projected. He points out to you that sales are up over 38 percent compared to the previous year and net income has increased by 54 percent. All is well. You are beginning the planning analytical procedures for the 2015 audit to obtain information to help plan the nature, timing, and extent of other audit procedures. 1. Using the Legion Analytical Review workpaper prepare a vertical analysis of the financial statements for all years (Round to the nearest percentage, i.e., 5%). 2. Using the Legion Analytical Review workpaper prepare a horizontal analysis of the financial statements comparing 2013 to 2014 and 2014 to 2015 (Round to the nearest percentage, i.e. 5%). 3. Using the Legion Analytical Review workpaper prepare the following ratios for each year (Round to the nearest .0; i.e. 2.5). Show the formula used for each ratio. Current Quick Receivable turnover (A/R balance at 12/31/12 = $14,471) Days' sales in ending receivables Inventory turnover (Inventory balance at 12/31/12 = $9,903) Days' sales in ending inventory Interest expense/Debt 4. Use the information from your analysis to identify areas/accounts that may represent specific risks relevant to this year's audit (uses the Planning Risks workpaper). For each area/account provide a justification for why you believe it represents a risk. Legion Appliance Manufacturing Company Planning Risks from Analytical Review 2015 Audit Risk Increase in Cash Prepared by _Luke Woods__ Reviewed by _____________ Justification The horizontal analysis shows large increases. However, these increases are largely due to the small amount of cash on hand at 12/31/13. The outstanding bank note was increased in 2014 and 2015 which could account for the increasesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started