Question

In: Accounting

Client Name: Apple Inc. Budget Actual For the Period Ended: 9/30/17 Start Date: 7/31/17 Nature of...

Client Name: Apple Inc.

Budget

Actual

For the Period Ended: 9/30/17

Start Date:

7/31/17

Nature of Assignment: Integrated Audit

End Date:

10/31/17

Hours:

36,000

Audit steps for tests of controls, balances, transactions, analytical procedures, etc. as well as other considerations such as sample size and sample methodology.

(a)

(b)

(c)

(d)

(e)

(f)

(g)

WP

Requirement

Procedure

Comp

Notes and Evidence

Date

Init.

8.0

(Acquisition)

8.1

8.2

8.3

8.4

8.5

8.6

8.7

8.8

9.0

(Payment)

9.1

9.2

9.3

9.4

9.5

9.6

9.7

9.8

10.0

(Fixed Assets)

10.1

Account Balance of fixed assets in a financial statement is accumulated value from past assets additions and deletions up to a given point in time.

Verifies the accuracy of fixed account balance by obtaining the detailed schedule on purchases and dispositions in the current period, including beginning balances.

10.2

Validation of Account transactions that listed in a financial statement are from valid transactions, have been received and actually exist in service.

Verifies the purchases are properly authorized, transactions are valid with the supporting documents such as vendor’s invoice, and the existence of a recorded fixed assets by physically examine the assets at the place where it supposedly has been placed in service.

10.3

Valuation of Assets

Verify the proper valuation of assets by examining vendor’s invoices and other purchase supporting documents in reference with the source information on correct asset value and depreciation which reduces the carrying value of fixed assets.

10.4

Classification of Assets

Examine selected repair and maintenance with the supporting transactions documents to determine the recorded fixed assets are correctly classified as capital assets, and certain expenses that should be capitalized as part of the fixed assets.

11.0

(Notes Payable)

11.1

Verification of notes payable interest

Recalculate approximate interest expense on the basis of average interest rates and overall monthly notes payable.

11.2

Verification of notes payable documentation

Audit of the records to verify proper information is recorded and there is proper authorization

11.3

Verification of interest expense

Recalculate approximate interest expense on the basis of average interest rates and overall monthly notes payable.

11.4

Verify the total notes payable

Compare individual notes outstanding with those of the prior year.

11.5

11.6

11.7

11.8

12.0

(Owner’s Equity)

12.1

12.2

12.3

12.4

12.5

12.6

12.7

12.8

Tickmarks:

(a) Enter the workpaper reference number in this column. For each area of testing, the workpaper number will have a new leading digit. For example, the first cash test would be 1.1 and the second would be 1.2, but upon moving to financial instrument testing, the numbering would start at 2.1. The order will be as follows: 1. Cash 2. Financial Instruments 3. Sales 4. Receivables 5. Inventory 6. Warehousing 7. Payroll 8. Acquisition 9. Payment 10. Fixed Assets 11. Notes Payable 12. Owner’s Equity

(b) Enter the requirement that the auditor is seeking to meet by testing. For example, balances in accounts receivable exist.

(c) Describe the testing procedure that will take place to meet the audit requirement. To continue with the example from above, confirmations will be sent to third parties to verify the balance stated in the accounts receivable subledger.

(d) Mark Y (Yes) or N (No) to recognize the entity was compliant with the requirement after performing the procedure.

(e) Explain any findings or relevant evidence related to the decision about whether the entity was compliant (Y) or not (N)

(f) Enter the date the staff member determined the entity was compliant or not.

(g) Enter the initials of the staff member that performed the testing.

*** I only need to acquisition and payment***

Solutions

Expert Solution

*** I only need to acquisition and payment*** : So the answer is.

For Acquisition :

Audit Procedures:

The internal auditors' role in bank mergers and acquisitions usually is associated with the due-diligence process. Auditors can provide senior management with vital information about the value of the company being acquired, its financial condition, any weaknesses in its financing or internal controls as well as its history, customer base, property conditions and management practices

For Payments:

Audit Procedures

The auditor examines payments to vendors following year end and then reviews any open Accounts payables files.

The auditor reviews a report of all accounts payable items that were not matched by the automated matching system, but had been paid upon authorization of the accounts payable department. A sample of selected items is taken and traced to the vendor payment and supporting documentation.


Related Solutions

Garland Company Budget Performance Report—Supervisor, Chip Fabrication For the Month Ended November 30 Cost Actual Budget...
Garland Company Budget Performance Report—Supervisor, Chip Fabrication For the Month Ended November 30 Cost Actual Budget Over Budget Under Budget Factory wages $95,500 $82,000 $13,500 Materials 115,300 120,000 $(4,700) Power and light 49,950 45,000 4,950 Maintenance 37,200 28,000 9,200 $297,950 $275,000 $27,650 $(4,700) a. Complete the budget performance reports by determining the correct amounts for the lettered spaces (a-l) as marked above. a. $ g. $ b. $ h. $ c. $ i. $ d. $ j. $ e. $...
The following data for Gardot Products Inc. are available: For the Year Ended December 31 Actual...
The following data for Gardot Products Inc. are available: For the Year Ended December 31 Actual Planned Difference—Increase or (Decrease) Sales $1,684,800 $1,652,400 $32,400 Less: Variable cost of goods sold $889,200 $874,800 $14,400 Variable selling and administrative expenses 171,600 178,200 -6,600 Total variable costs $1,060,800 $1,053,000 $7,800 Contribution margin $624,000 $599,400 $24,600 Number of units sold 15,600 16,200 Per unit: Sales price $108 $102 Variable cost of goods sold 57 54 Variable selling and administrative expenses 11 11 Prepare an...
Prepare a direct materials budget by quarters for the 6-month period ended June 30, 2017 On...
Prepare a direct materials budget by quarters for the 6-month period ended June 30, 2017 On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter 6,000; second quarter 6,900; third quarter 7,400 Ending raw materials inventory: 40% of the next quarter’s production requirements Ending finished goods inventory: 25% of the next quarter’s expected sales units Third-quarter production: 7,840 units. The ending raw...
1. Using Apple’s actual 9/30/17 balance sheet to answer this question, which of the following best...
1. Using Apple’s actual 9/30/17 balance sheet to answer this question, which of the following best represents Apple’s Accounting Equation? a. $375,319,000,000 = $241,272,000,000 + $134,047,000,000 b. $128,645,000,000 = $100,814,000,000 + $27,831,000,000 c. $194,714,000,000 = $100,814,000,000 + $93,900,000,000 d. $241,272,000,000 = $107,225,000,000 + $134,047,000,000 2. Using Apple’s actual 9/30/17 balances shown in the balance sheet to answer this question, what would be the impact to their accounting equation if Apple took out a new $1,000,000,000 bank loan in exchange for...
Performance Report Year Ended December 31, 2017 Actual Flexible-Budget Flexible Sales-Volume Static Results Variances Budget Variances...
Performance Report Year Ended December 31, 2017 Actual Flexible-Budget Flexible Sales-Volume Static Results Variances Budget Variances Budget Units sold 108,000 99,000 Revenues (sales) $702,000 $420,750 Variable costs 430,000 237,600 Contribution margin 272,000 183,150 Fixed costs 193,850 105,000 Operating income $78,150 $78,150 The Beekman Company produces engine parts for car manufacturers. A new accountant intern at Beekman has accidentally deleted the calculations on the​ company's variance analysis calculations for the year ended December​ 31, 2017. Requirement 1. Calculate all the required...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,800 $ 41,200 $ 25,200 Cash payments for merchandise 22,600 15,600 16,000 Sales are 75% cash and 25% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,200 in cash, $13,200 in accounts receivable, $12,200 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,800 $ 41,200 $ 25,200 Cash payments for merchandise 22,600 15,600 16,000 Sales are 75% cash and 25% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,200 in cash, $13,200 in accounts receivable, $11,000 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 31,000 $ 41,000 $ 25,000 Cash payments for merchandise 22,200 15,800 16,200 Sales are 70% cash and 30% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,000 in cash, $13,000 in accounts receivable, $11,000 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,000 $ 42,000 $ 26,000 Cash payments for merchandise 24,200 14,800 13,500 Sales are 80% cash and 20% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $14,000 in cash, $14,000 in accounts receivable, $11,000 in...
TERM Invoice Amount Invoice NAME Start End 5452952 11/30/2013 10/31/2015 69,500.00 8188 8/1/2013 7/31/2014 1,000.00 8189...
TERM Invoice Amount Invoice NAME Start End 5452952 11/30/2013 10/31/2015 69,500.00 8188 8/1/2013 7/31/2014 1,000.00 8189 8/1/2014 7/31/2015 1,000.00 3686223 3/11/2014 12/18/2014 1,166.67 3664490 12/19/2013 12/18/2014 5,800.00 USINV-022647 5/29/2014 5/28/2015 7,600.00 00091849 12/26/2013 7/25/2014 500.00 00082204 7/26/2014 7/25/2015 750.00 The above includes information pertaining to the terms and invoice amounts of several prepaid expenses. Calculate the monthly amortization using the quarter of a month depreciation method (.25, .5, .75).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT