Question

In: Accounting

Complete all the fields on Work Paper 5-3 below. Additionally, EarthWear Common-Size Financial Statements have been...

Complete all the fields on Work Paper 5-3 below. Additionally, EarthWear Common-Size Financial Statements have been included to aid you in your decisions. Work Paper 5-3 EARTHWEAR CLOTHIERS Identification of Accounts with Unexpected Fluctuations December 31, 2016

1. Establish Threshold for Unexpected Fluctuations To begin identifying accounts with unexpected fluctuations auditors must establish a threshold for account difference. All accounts whose actual 2016 unaudited account balance differs from the expected balance by a value greater than the threshold established will be shown in the charts below. As a general rule the threshold should not exceed materiality. For the purposes of this exercise we assume planning materiality is $3.1 million. Enter this value in the field below as 3,100. (Omit the "$" sign in your response.)

A. Set threshold for account difference in thousands $ 3100

2. Evaluate Threshold for Unexpected Fluctuations Lists of Balance Sheet and Income Statement accounts have been generated below based on your threshold for account difference. In the "Evaluation" column please identify 1 or 2 balance sheet and 1 or 2 income statement accounts where you believe the difference presents increased risk of material misstatement that may require a change in the nature, timing or extent of planned audit procedures. Please indicate possible reasons for the difference, potential risks, and suggested audit plan revisions.

A. Balance Sheet Accounts Account Difference from Expectations Evaluation

Cash and cash equivalents $31,071

Receivables, net ($5,568)

Inventory $8,444

Other prepaid expenses ($3,414)

Computer hardware and software ($7,107)

Lines of credit ($3,892)

Accounts payable ($22,401)

Accrued liabilities $5,456

Income taxes payable $5,711

Deferred income taxes ($4,666)

Additional paid-in capital $3,550

Accumulated other comprehensive income ($3,855)

Treasury stock, 6,654, 7,114, and 6,546 shares at cost, respectively $23,926

B. Income Statement Accounts Account Difference from Expectations Evaluation

Net Sales ($23,193)

Cost of sales ($47,893)

Selling, general and administrative expenses ($18,851)

Income tax provision $10,864

Solutions

Expert Solution

Balance Sheet -

Increase in Cash and Cash equivalent -

The amount of 31,071 looks quite substantial which should be investigated further. This increase can be on account of sales Computer H/w and S/w worth 7107, collection from debtor 5568, increase in paid in capital 3550. However there is substantial decrease in Payables of 22401, line of credit of 3892 which has means there has been payment made to them. Hence proper audit needs to be done to find out the reasons for increase in Cash balance.   

Income Statement -

Cost of Sales - Decrease in Cost of sales is more than decrease in Sales. The reasons for the same needs to be checked. There is an increased risk of material mistatement like understatment of the expenses. The company inorder to minimise the impact of reduced sales on profitability has reduced its expenses even more. Auditor has to investigate this difference in cost of expense, whether there is some irregularity or is there a genuine business reason like fall in price of raw material.


Related Solutions

Problem 3-18 Common-Size and Common-Base-Year Financial Statements In addition to common-size financial statements, common-base-year financial statements...
Problem 3-18 Common-Size and Common-Base-Year Financial Statements In addition to common-size financial statements, common-base-year financial statements are often used. Common-base year financial statements are constructed by dividing the current-year account value by base-year account value. Thus, the result shows the growth rate in the account.    Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2016 as the base-year. (Do not round intermediate calculations. Enter all common-size answers as a percent. Round your common-size answers to...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 500 1.5 % Accounts receivable 6,000 18.2 Inventory 9,450 28.7 Total current assets $ 15,950 48.4 % Net property, plant, and equipment 16,980 51.6 Total assets $ 32,930 100.0 % Accounts payable $ 7,240 22.0 % Short-term notes 6,750 20.5 Total current liabilities $ 13,990 42.5 % Long-term liabilities 6,990 21.2 Total liabilities $ 20,980 63.7 % Total common shareholders’...
Problem 14-16 Common-Size Financial Statements [LO14-1] You have just been hired as a financial analyst for...
Problem 14-16 Common-Size Financial Statements [LO14-1] You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 950,000 $ 1,110,000 Marketable securities 0 300,000 Accounts...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: LOADING... to respond to your​...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: LOADING... to respond to your​ boss' request that you write up your assessment of the​ firm's financial condition.​ Specifically, write up a brief narrative that responds to the following​ questions: a. How much cash does Patterson have on hand relative to its total​ assets? b. What proportion of​ Patterson's assets has the firm financed using​ short-term debt?​ Long-term debt? c. What percent of​ Patterson's revenues does the firm have...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup window: LOADING... . Which company is doing a better job of getting sales dollars to net income? Where is the one company having an advantage over the other company in turning revenue into net income? Complete the table below: (Round to two decimal places. Net income to three decimal places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window: Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below: (Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart, Inc. Starbucks...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window:   LOADING... . Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below:  ​(Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
n addition to common-size financial statements, common-base year financial statements are often used. Common-base year financial...
n addition to common-size financial statements, common-base year financial statements are often used. Common-base year financial statements are constructed by dividing the current year account value by the base year account value. Thus, the result shows the growth rate in the account.    Construct the common-size balance sheet and common-base year balance sheet for the company. Use 2018 as the base year. (Do not round intermediate calculations. Enter your common-size answers as a percent and your common base year answers...
You are comparing the common-size financial statements for two firms in the same industry that have...
You are comparing the common-size financial statements for two firms in the same industry that have very similar operations. You note that their sales revenues are similar in dollar value but yet the common-size EBIT for one firm is 30 percent compared to only 26 percent for the other firm. What are some possible explanations for this difference given the strong similarities of the two firms?
Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $...
Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 470 1.4 % Accounts receivable 5,990 18.2 Inventory 9,450 28.7 Total current assets $ 15,910 48.4 % Net property, plant, and equipment 16,990 51.6 Total assets $ 32,900 100.0 % Accounts payable $ 7,150 21.7 % Short-term notes 6,790 20.6 Total current liabilities $ 13,940 42.4 % Long-term liabilities 7,040 21.4 Total liabilities $ 20,980 63.8 % Total common shareholders’ equity 11,920 36.2 Total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT