Monday, September 23, 2019

Audit Request List DRS (Simulation)

Bondelli Co.
Year ended December 31, year 4
Audit Request List (DRAFT)

Please have the materials listed below ready when we arrive on site. Unless a different date is specifically stated, these documents should be as of and for the year ended December 31, year 4.

Final trial balance
Bank reconciliations for March, September, and December, year 4
Bank statements for December, year 4 and January, year 5
Property, plant, and equipment roll-forward
Bearcreek industrial estate purchase contract [1]
Furniture and fixtures purchase documentation [2]
Documentation supporting the sale of the motor vehicle asset [3]
Accounts receivable aging analysis
Documentation supporting the allowance against the accounts receivable balance due from Plain, Inc. [4]
Accounts payable aging analysis
WIP inventory detail
Raw material inventory detail
Available-for-sale securities valuation at year-end [5]
Documentation supporting issuance of 50,000 shares at $0.30 per share [6]
Quarterly board of directors meeting minutes
Copy of the loan agreement with T. Bondelli [7]
Prepaid expenses analysis
Accrued expenses analysis
Sales register
Documentation supporting dividends paid
Account 7500 expense analysis [8]
Payroll reconciliation




1. Choose an option below:
[Original text] Bearcreek industrial estate sales contract
[Delete text] Bearcreek industrial estate sales contract
Bearcreek industrial estate lease agreement
Bearcreek industrial estate property tax expense analysis
X Bearcreek industrial estate purchase contract
Proof of Bearcreek industrial estate property insurance
Bearcreek is not selling the property; therefore, you want to ask for the purchase contract and not the sales contract. It was a lease and they are exercising their option to buy out the contract.




2. Choose an option below:
[Original text] Furniture and fixtures purchase documentation
X [Delete text] Furniture and fixtures purchase documentation
Furniture and fixtures sale documentation
Office equipment purchase documentation
Office equipment sale documentation
There is nothing to request for furniture and fixtures. Year 3 is the same amount as year 4; this indicates that the entity did not buy any new furniture or fixtures.




3. Choose an option below:
[Original text] New motor vehicle purchase agreement
[Delete text] New motor vehicle purchase agreement
X Documentation supporting the sale of the motor vehicle asset
Documentation supporting the scrapping of the motor vehicle asset
New motor vehicle lease agreement
The Unadjusted Trial Balance indicates that from year 3 to year 4, Account #1700 – Vehicles decreased from $36,500 to zero. This tells us that the entity probably sold the motor vehicle (or scrapped it) and apparently did not replace it. Therefore, the Audit Request List should include: Documentation supporting the sale of the vehicle asset.




4. Choose an option below:
[Original text] Documentation supporting the 2% general allowance calculation for doubtful accounts
[Delete text] Documentation supporting the 2% general allowance calculation for doubtful accounts
X Documentation supporting the allowance against the accounts receivable balance due from Plain, Inc.
Documentation supporting the recovery of previously written-off accounts receivable balances
Documentation supporting the 100% general allowance made against all balances exceeding 180 days overdue
Documentation supporting the allowance against the accounts receivable balance due from Vibe Co.
The Unadjusted Trial Balance indicates that from year 3 to year 4, Account #1205 – Allowance for Doubtful Accounts, increased from $82,000 to $456,250. The Company takes a full allowance against any balances exceeding 180 days at year-end; they do not use a 2% general allowance calculation for doubtful accounts The recovery was $2,000 and is immaterial. Additional information is provided on the Interoffice Memo regarding two accounts, $52,000 from Vibe and $374,250 from Plain. The Vibe account is under the materiality limit of $55,000; however, the Plain account clearly exceeds the materiality limit. Therefore, the Audit Request List should include: Documentation supporting the allowance against the accounts receivable balance due from Plain, Inc.




5. Choose an option below:
[Original text] Trading securities valuation at year-end
[Delete text] Trading securities valuation at year-end
X Available-for-sale securities valuation at year-end
Equity method investment valuation at year-end
Joint venture valuation at year-end
Subsidiary company valuation at year-end
Since this item does not have any supporting documentation, you will have to use your knowledge of securities and some deductive logic to select the most appropriate response.

The unadjusted trial balance shows the following changes from Year 3 to Year 4:



Year 4 Year 3
Dr. Cr. Dr. Cr.
1800 Investments in securities 325,000 400,000
3400 Other comprehensive income 75,000 -

Only Available-for-Sale (AFS) securities have unrealized gains or losses reflected as Other Comprehensive Income, and only one choice offers AFS as an option; therefore, the Audit Request List should ask for the: Available-for-sale securities valuation at year-end.




6. Choose an option below:
X [Original text] Documentation supporting issuance of 50,000 shares at $0.30 per share
[Delete text] Documentation supporting issuance of 50,000 shares at $0.30 per share
Documentation supporting issuance of 150,000 shares at $0.10 per share
Documentation supporting issuance of 150,000 shares at $0.30 per share
Documentation supporting issuance of 50,000 shares at $0.10 per share
Documentation supporting issuance of 50,000 shares at $0.20 per share
The unadjusted trial balance shows the following changes from Year 3 to Year 4:



Year 4 Year 3
Dr. Cr. Dr. Cr.
3000 Common stock (per $.10 per share) (15,000) (10,000)
3100 Additional paid-in capital (APIC) (110,000) (100,000)

Since par value is $.10 per share, an increase in the common stock account of $5,000 must have resulted from issuing 50,000 ($5,000 ÷ $.10) new shares. The $10,000 increase in APIC resulting from 50,000 additional shares means that APIC was $0.20 per share ($10,000 ÷ 50,000). The stock was sold for $.30 per share ($.10 + $.20). Therefore, the correct choice is: Documentation supporting issuance of 50,000 shares at $0.30 per share. (Note: If the correct answer is the original text, you must make that selection to receive credit for your answer.)




7. Choose an option below:
[Original text] Management’s review of third-party loan interest rates
[Delete text] Management’s review of third-party loan interest rates
X Copy of the loan agreement with T. Bondelli
Copy of the loan agreement with G. Moore
Evidence of approval by J. Nguyen for the loan to T. Bondelli
Management’s due diligence work related to providing the loans
The unadjusted trial balance shows the following change from Year 3 to Year 4:



Year 4 Year 3
Dr. Cr. Dr. Cr.
2620 Loan to shareholder 250,000 25,000

The $225,000 increase in Account 2620, “Loan to shareholder,” not only falls within the materiality limit of $55,000, but is also a related party transaction, thus requiring further investigation. The Minutes of Special Meeting of August 28, Year 4 document the approval of the additional loan (so additional approval documentation is not needed) and provide the name of the shareholder – T. Bondelli. The best answer choice is therefore: Copy of the loan agreement with T. Bondelli.




8. Choose an option below:
[Original text] Account 6900 expense analysis
[Delete text] Account 6900 expense analysis
Account 6806 expense analysis
Account 7115 expense analysis
X Account 7500 expense analysis
The unadjusted trial balance shows the following change from Year 3 to Year 4:



Year 4 Year 3
Dr. Cr. Dr. Cr.
6806 Payroll processor fees 2,400 2,400
6900 Sundry expense 890 940
7115 Postage expense 670 590
7500 Repairs and maintenance 62,000 14,500

The Year 4 balance of $62,000 in Account 7500 exceeds the materiality limit of $55,000 and is the only account for which an expense analysis should be requested on the audit request list.

Sunday, September 22, 2019

Misstatements Simulation

Misstatement
Audit Procedure Used to Detect Misstatement
Internal Control That Could Prevent or Detect Misstatement in the Future

1. An accounts payable clerk misplaces year-end invoices for raw materials that were received on December 21, Year 2, and therefore liabilities were not recorded. 

Investigate unmatched receiving reports dated prior to January 1, Year 3.

 The purchasing department supervisor forwards a monthly listing of matched purchase orders and receiving reports to the accounts payable supervisor for comparison to a listing of vouched invoices.

The liability for payment at the end of Year 2 exists because items were received prior to year-end. Each receiving report should have at least one corresponding vendor invoice matched with it. The auditor found unmatched receiving reports for the period under audit and then determined that the vendor invoices were misplaced.

Only one other answer choice deals with receiving reports; however, it involves tracing those reports to packing slips (not vendor invoices).

Requesting confirmation from the accounts payable supervisor that all invoices are recorded does not provide evidence regarding missing invoices.
The concern is that vendor invoices may have been misplaced before they are recorded. To prevent this occurrence, or to prompt the accounts payable clerk to look for what appears to be a missing invoice, information on products ordered and received must come from another department. A comparison of this listing to the vouched invoices will highlight any missing invoices.

While copying all vendor invoices and storing them offsite may provide a more complete body of vendor invoices should one go missing, the control must involve the other forms of documentation that make the vendor invoice a liability. These forms would be the purchase order and the receiving report.

2. The company tends to be careless in recording payables in the correct period. 

From the January, Year 3, cash disbursements journal, select payments and match to corresponding invoices. 

A clerk is responsible for matching purchase orders with receiving reports and making certain they are included in the proper month.

This misstatement deals with cutoff. The auditor was concerned that payables may have been recorded in Year 3 when they should have been recorded in Year 2. Any outstanding receivable at the end of Year 2 would have been paid in January, Year 3. Examining the payments in the January, Year 3, cash disbursements journal and viewing the corresponding vendor invoice allowed the auditor to discover that some payables were not recorded in the correct period.

Reviewing the cash disbursement journal for December, Year 2, would provide the auditor with payments for accounts payable already recorded prior to year-end. The auditor must look outside of Year 2 to help with the cutoff determination.

Identifying open purchase orders and vendors’ invoices at December 31, Year 2, would not help the auditor to determine if any invoices were recorded in Year 3 that should have been recorded in Year 2.
The control needed is a matter of matching and checking. If a clerk is assigned the specific duty to match purchase orders with receiving reports and then make sure they are recorded in the proper month, payables should be recorded in the correct period in the future.

3. The company has the same person approving pay requests and cutting checks. 

Select an unpaid invoice and ask to be walked through the invoice payment process. 

Accounts payable personnel are assigned different responsibilities each quarter within the department.

The auditor would usually determine the separation of duties (or lack thereof) by inquiry and observation. Asking the accounts payable department to demonstrate, or walk the auditor through, the accounts payable process would allow the auditor to see who is responsible for which procedure.
Separating or rotating job duties will prevent the same person from having control over both authorization and recording functions.

4. The company's receiving department misplaces receiving reports for purchases of raw materials at year-end and therefore liabilities were not recorded. 

Identify open purchase orders and vendors' invoices at December 31, Year 2, and investigate their disposition. 

The accounts payable supervisor reviews a monthly listing of open purchase orders and vendors' invoices for follow-up with the receiving department.

Receiving reports, vendor invoices, and purchase orders are matched together in the accounts payable department before payment can be authorized and recorded. The vendor invoice is not a payable until the order has been received. If the auditor questioned any unmatched invoices or purchase orders ("Did you receive this item? If so, when?"), any misplaced receiving reports and unrecorded liabilities would be revealed.

Reviewing the receiving department’s filing system and investigating unmatched receiving reports dated prior to January 1, Year 3, would not reveal missing receiving reports. The auditor must look at other documentation that would highlight the missing reports.
Since the accounts payable department may be missing information, it should prepare a listing of open items that are waiting for receiving reports to ask the receiving department if the shipments have been received ("And if so, when? And where is the receiving report?"). The request has to originate from the accounts payable department, not the receiving or purchasing departments.

Saturday, September 21, 2019

Audit Procedures (Simulation)

Accounts Receivable Gross Profit
1 Increase Increase Increase
Earnings per share (EPS) is the portion of a company's profit allocated to each outstanding share of common stock, and serves as an indicator of a company's profitability. In this case, sales are increasing more than cost of goods sold, so EPS also increases. [(Net income – Preferred dividend) ÷ Weighted-average number of shares outstanding] = EPS

Days’ sales in accounts receivable measures the number of days it takes a company to collect cash from its credit sales (i.e., accounts receivable), and is an indication of short-term liquidity. For journal entry #1, accounts receivable and sales both increase by the same amount, however, the increase in ending A/R is mitigated by the requirement to compute and use average A/R in the formula. In other words, the effect of the A/R increase is lessened, and the days to collect is lengthened. [(Average accounts receivable ÷ Credit sales) × Number of days] = Days’ sales in accounts receivable (Number of days can be 360 or 365 days.)

Gross profit is net sales minus cost of goods sold, and indicates how much an entity has profited before subtracting any selling and administrative expenses. In this case, sales has increased more than the cost of goods sold; this indicates that gross profit will increase. (Sales – Cost of goods sold = Gross profit)

2 Decrease Decrease No impact
Earnings per share (EPS) is the portion of a company's profit allocated to each outstanding share of common stock, and serves as an indicator of a company's profitability. With journal entry #2, EPS will decrease because the net income is decreasing. The cost of goods sold and sales offset each other, but utilities expense increased by $517 and interest expense decreased by $515. Therefore, expenses are increased, which lowers net income since sales did not increase. Accrued expenses should be on the balance sheet.

Days’ sales in accounts receivable measures the number of days it takes a company to collect cash from its credit sales (i.e., accounts receivable), and is an indication of short-term liquidity. Journal entry #2 will decrease the number of days since accounts receivable was not affected by the journal entry and sales actually increased. The result is a decrease in the number of days that accounts receivable will be uncollected.

Gross profit is net sales minus cost of goods sold, and indicates how much an entity has profited before subtracting any selling and administrative expenses. Journal entry #2 does not affect gross profit as both sales and cost of goods sold were $550, offsetting each other.

3 Decrease No impact No impact
Earnings per share (EPS) is the portion of a company's profit allocated to each outstanding share of common stock, and serves as an indicator of a company's profitability. Journal entry #3 will cause EPS to decrease because expenses increase; therefore net income decreases (i.e., income tax expense increases by $550 and deferred income tax expense decreases by $350, for a net increase in expenses of $200).



Income Tax Expense....................................$550 (income statement account)
Deferred tax asset........................................$435 (balance sheet account)
                             Deferred income tax expense................................$350 (income statement account)
                             Deferred tax liability..............................................$85 (balance sheet account)
                             Income tax payable................................................$550 (balance sheet account)



Days’ sales in accounts receivable measures the number of days it takes a company to collect cash from its credit sales (i.e., accounts receivable), and is an indication of short-term liquidity. Journal entry #3 has no effect as neither sales nor accounts receivable was adjusted in the journal entry.

Gross profit is net sales minus cost of goods sold, and indicates how much an entity has profited before subtracting any selling and administrative expenses. Journal entry #3 does not affect gross profit as neither sales nor cost of goods sold is part of the entry.


Part 2:

Testing Scenario Audit Procedure
1. Requested the bank (with which Max Depot has an outstanding loan) to send its response directly to the audit staff 

Confirmation

Requesting responses directly from a bank from which Max Depot has a loan is a confirmation procedure. Confirmations are received from third parties to verify amounts or information described in the financial statements. (AU-C 505.02, .07)


2. Examined employee timesheets to see if they were initialed by the department manager indicating appropriate approval 

Inspection

Examining employee timesheets to see if they were initialed by the department manager indicating appropriate approval is an inspection procedure. Inspection is a review of documents or records for control, accuracy, and any other matters that may affect the audit. (AU-C 315.A18)


3. Questioned management about risks of fraud in the entity 

Inquiry

Questioning management about risks of fraud in the entity is an inquiry procedure. The auditor should inquire of management about any information that may provide assurance against fraud. (AU-C 240.04)


4. Compared this year's key ratios to last year's key ratios and investigated unusual fluctuations

Analytical

Comparing this year’s and last year’s key ratios to investigate unusual fluctuations is an analytical procedure. Analytical procedures consist of assessments of financial data made by the auditor of possible and estimated relationships among both nonfinancial and financial data. (AU-C 520.04–.05)


5. Viewed the clerk receiving and processing the daily inventory shipment 

Observation

Viewing the receiving clerk receiving the daily inventory shipment is an observation procedure. Observation is a good technique to understand how the business is run and how the employees of the entity handle their responsibilities. Observation is a way for the auditor to gather evidence about the procedures of the entity. (AU-C 230.A14)



Part 3:

Question Answer Choices
Which audit procedure would best be suited for testing inventory to verify that it was correctly costed out under the FIFO method? 

Recalculation

Recalculation would be the best audit procedure to test that the inventory is being maintained using the first-in, first-out (FIFO) method. Recalculation is used to verify the math computation is accurate.


How would you analytically test the statement that the markup on inventory is a consistent 55%? 

Perform analytical procedures on inventory sales and cost of sales totals on the income statement

Analytical procedures consist of assessments of financial data made by the auditor of possible and estimated relationships among both nonfinancial and financial data (AU-C 520.04–.05). Comparing the sales total to the cost of goods total on the financial statements will give a better estimation on the markup for items.


The auditor must test management’s assertion that the purchase price and sales price of inventory, once they are entered into the computer, can only be changed by certain authorized personnel. What would be the best option for testing? 

Log into the computer as an unauthorized employee and attempt to adjust prices

This is a test of controls. Tests of controls are used to obtain sufficient appropriate audit evidence. This test should examine how many times a control or procedure is not followed. Checking for supervisor approval on all purchases is a test of a control, but not the control specified in the question. The best way to test management’s statement that once inventory has been approved for purchase, the purchase price and sales price in the computer cannot be changed is to log into the computer as an employee and attempt to adjust the pricing.

Attorney Letters (Simulation)

Situations Audit Response
(Financials) Audit Response
(Report)

1) Letter dated February 14, Year 2:

"I advise you that at and since December 31, Year 1, I have not been engaged to give substantive attention to, or represent XYZ Co. in connection with any pending or threatened litigation, claims, or assessments, nor am I aware of any loss contingencies. No amounts were due to this office for services provided at December 31, Year 1." No impact on financial statement or footnotes Legal response is appropriately dated
The attorney was not engaged to give substantive attention regarding threatened litigation, claims, or assessments. Therefore, there would be no financial impact. AU-C 501.A69 shows an example of an audit inquiry letter stating that the attorney's response should be received within two weeks of the report date. Since the response was received only one day prior to the report date, no update is necessary.
2) Letter dated January 21, Year 2:

"I advise you that at and since December 31, Year 1, I have not been engaged to give substantive attention to, or represent XYZ Co. in connection with any pending or threatened litigation, claims, or assessments, nor am I aware of any loss contingencies. There were fees outstanding of $3,675 due to this office for services provided at December 31, Year 1." Verify amount due attorney is recorded in financial statements Update legal response
The attorney was not engaged to give any substantive attention to threatened litigation, claims, or assessments; therefore, there is no need to accrue any contingent liability. However, the auditor should verify that the amount due to the attorney had been accrued by the client. The attorney's response was received more than two weeks prior to the report date. Therefore, the auditor should get an updated response from the attorney.
3) Letter dated February 26, Year 2:

"I advise you that at and since December 31, Year 1, I have not been engaged to give substantive attention to, or represent XYZ Co. in connection with any pending or threatened litigation, claims, or assessments, except as follows:

"K. Bowt v. XYZ Co.: This matter commenced in December, Year 1. The plaintiff alleges discrimination relating to his termination on November 17, Year 1. The company intends to defend this case vigorously. At this time, we are unable to evaluate the likelihood of an unfavorable outcome or estimate the amount or range of potential loss." Disclosure in footnotes relating to nature of litigation, but no amount disclosed Update report date
FASB ASC 450-20-50 states that the disclosure of a noted contingency should include the nature of the contingency and an estimate of the possible loss or range of loss. FASB ASC 450-20-50-5 states that disclosure is preferable to accrual when a reasonable estimate of loss cannot be made. Since a disclosure is now required to be made in the financial statements and the knowledge of this event occurred after the original report date, the report date should be updated.
4) Letter dated March 16, Year 2:

"I advise you that at and since December 31, Year 1, I have not been engaged to give substantive attention to, or represent XYZ Co. in connection with any pending or threatened litigation, claims, or assessments, except as follows:

"J. Myers v. XYZ Co.: This matter commenced in March, Year 2. The plaintiff alleges discrimination relating to his termination on November 17, Year 1. The company intends to defend this case vigorously. At this time, we are unable to evaluate the likelihood of an unfavorable outcome. The plaintiff is demanding $50,000." Disclosure in footnotes relating to nature of litigation, but no amount disclosed Update report date
Since the attorney was not able to evaluate the likelihood of an unfavorable outcome, a loss contingency amount cannot be disclosed, but as noted above, the nature of the contingency should be disclosed under FASB ASC 450-20-50. Since a disclosure is now required to be made in the financial statements and the knowledge of this event occurred after the original report date, the report date should be updated.
5) Letter dated January 10, Year 2:

"I advise you that at and since December 31, Year 1, I have not been engaged to give substantive attention to, or represent XYZ Co. in connection with any pending or threatened litigation, claims, or assessments, except as follows:

"R. Brown v. XYZ Co.: This matter commenced in November, Year 1. The plaintiff alleges discrimination relating to his termination on March 17, Year 1. The case was tentatively settled for $35,000, which will be covered by XYZ's insurance carrier." Potential litigation settlement not accrued in financial statements, amount disclosed in footnotes Update legal response
In accordance with FASB ASC 450-20-50, the potential litigation settlement will need to be disclosed in the financial statement. However, there is no need to accrue the settlement since this will be paid for by the insurance carrier. The legal response was received prior to the report date, so therefore there is no need to update the report. However, the letter was received more than two weeks prior to the report date, so the legal response must be updated.

6) Letter dated January 20, Year 2:

"I advise you that at and since December 31, Year 1, I have not been engaged to give substantive attention to, or represent XYZ Co. in connection with any pending or threatened litigation, claims, or assessments, except as follows:

"L. Peep v. XYZ Co.: This matter commenced in November, Year 1. The plaintiff alleges discrimination relating to his termination on March 17, Year 1. The case was tentatively settled for $35,000." Potential litigation settlement accrued in financial statements Update legal response
In accordance with FASB ASC 450-20-50, the potential litigation settlement must be accrued since estimated loss could be made. Since the legal letter was received more than two weeks prior to the report date, the legal response should be updated.

Wednesday, September 18, 2019

Preferred stock

Typically, preferred stockholders have a priority as to:

  1. Distributions of earnings (dividends)
  2. Assets in event of liquidation

Generally do not have voting rights

Item has no effect on the statement of cash flows

FASB ASC 230-10-20 focuses on cash and cash equivalents. The following explanation is offered: "Examples of items commonly considered to be cash equivalents are Treasury bills, commercial paper, money market funds, and federal funds sold (for an enterprise with banking operations)."

Thus, the purchase of U.S. Treasury bills would have no effect on the statement of cash flows.

Financing activities section of statement of cashflow

Cash inflows from financing activities:
No listed items are inflows                                               $ 0
Cash outflows from financing activities:
Dividends paid                                                           (81,000)
Purchase of treasury stock                                         (39,000)
Net cash provided by financing activities              ($120,000)

Dividends declared created a liability, but until they are paid, no cash flows out of the corporation and they will not appear on the cash flow statement until then. Purchase of equipment and the sale of bonds held for investment are investing activities, not financing activities. Loss on sale and amortization of premium are operating activities.