ACC331 Assessment 3 Assignment

By March 31, 2019Academic Papers

Normal
0

false
false
false

EN-US
ZH-CN
AR-SA

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:8.0pt;
mso-para-margin-left:0cm;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:Calibri;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-fareast-language:EN-US;}

Task

Question 1          Topic 3 & 4          Planning, analytics and risk assessment         (40 marks)

 

 

You are the auditor of Printer Solutions Ltd, a manufacturer of colour printers. You have scrutinised the financial reports of the company and are concerned about its future as a ‘going concern’. The summarised financial reports for the past three years plus the unaudited draft accounts for the current year are shown below.

 

Printing Solutions Ltd

 

 

 

 

 

Income Statement $’000s

2017

2016

2015

2014

Sales

3080

2660

2060

1310

Cost of Goods Sold

(2350)

(2010)

(1566)

(969)

Gross Profit

730

650

494

341

Other Expenses

(350)

(390)

(270)

(140)

Interest

(300)

(120)

(70)

(2)

Net Profit (Loss)

80

140

154

199

 

 

 

 

 

Statement of Financial Position $’000s

 

 

 

 

Current assets

 

 

 

 

Trade and other receivables

772

660

432

382

Inventory

680

510

350

205

Total current assets

1452

1170

782

587

Non-current assets

 

 

 

 

Property, plant and equipment

1810

1500

920

370

Intangible assets

40

 

 

 

Total non-current assets

1850

1500

920

370

Total assets

3302

2670

1702

957

Current liabilities

 

 

 

 

Trade and other payables

835

795

486

400

Current borrowings – Bank Overdraft

52

40

21

16

Total current liabilities

887

835

507

416

Non-current liabilities

 

 

 

 

Non-current borrowings – Secured loan

1500

1000

500

 

Total liabilities

2387

1835

1007

416

Net Assets

915

835

695

541

Equity

 

 

 

 

Share capital

300

300

300

300

Retained earnings

615

535

395

241

Total Equity

915

835

695

541

 

Extracts from the notes to the financial statements

 

Trade and other receivables

 

 

 

 

Trades receivable

802

716

465

410

Provision for doubtful debts

(40)

(66)

(43)

(38)

 

762

650

422

372

Prepaids and other receivables

10

10

10

10

 

772

660

432

382

 

 

 

 

 

 

 

 

 

 

Inventory

 

 

 

 

Raw materials

146

128

87

51

WIP

152

127

105

72

Inventory held for sale

382

255

158

82

 

680

510

350

205

 

 

 

 

 

Trade and other payables

 

 

 

 

Trades payable

799

744

431

338

Other payables

15

15

15

15

Current Tax payable

21

36

40

47

 

835

795

486

400

 

 

 

 

 

 

Additional Background Information

 

In an attempt to expand into overseas markets, Printer Solutions automated many of its operations in 2016 with the purchase of some highly sophisticated plant and machinery. The new plant and machinery was financed with a secured variable loan of $100,000 and a bank overdraft facility.

 

The company purchases the components that make up the printers from a variety of local and overseas suppliers. Currently, 85% of Printer Solutions sales are to one electrical discount chain store, and the company has plans to broaden its sales base in both the local and overseas markets. While local sales have increased, the company has had mixed results with sales to overseas markets. Further expansion of the company’s sales base, especially overseas, revolves around the development and production of a state of the art printer that will be tailored to meet the needs of the top end of the market. In addition, a new computerised ordering system is being developed.

 

Plans are well underway for the new range of printers and the computer system upgrade. The company’s loan facility has been increased to $150,000 over the past two years to cover some of these expenses. Other funding has come from cash flow. However, the development will require a significant amount of additional money. The directors hope this money will come via a new public issue of shares planned for later this year and promises of loans and other forms of assistance from business acquaintances of the CEO, Mr Peter Andrews.

 

There is a mistake with the Income Statement in Assessment 3 and included the incorrect version of the statement. The correct version of the statement includes tax, but the final profit is the same..

To minimise any confusion the current Income Statement will be left as is and the formula of any ratios that involve adding back tax will be amended as only two ratios will be impacted. The amendments to the two ratios are as follows:

Return on Assets =

      Net profit before interest
             Total Assets
 
Times Interest Earned =

     Net profit before interest
             Interest expense 

 

 

 

 

 

Required:

 

(a)   Analyse the financials of Printer Solutions Ltd. Include a simple comparison of the movement in the accounts between 2016 and 2017, a trend analysis, and the profitability, liquidity, solvency and efficiency ratios for the last three years (2017, 2016 and 2015).  (11 marks)

 

(b)   With reference to each of the ratio areas, the other analysis and the background information provided in the question, explain why you perceive there are going concern issues for Printer Solutions Ltd. (5 marks)

 

(c)   From your analysis of the company, identify four account balances that could potentially be materially misstated and justify each choice.  (12 marks)

 

(d)   For each of the accounts/areas in (c), identify the two assertions of primary interest to you and justify your choice.  (12 marks)

  Question 2          Topics 5 & 6          Internal control and tests of control        (25 marks)

 

You are engaged in your first audit of VIPet Pty Ltd (VIPet) for the year ended 30 June 2017. The Managing Director is Matthew Stanton, a qualified veterinarian, and the company employs seven permanent staff. The permanent staff consists of two permanent veterinarians, three veterinarian assistants; a receptionist, an office assistant/typist and a bookkeeper. In July 2016 VIPet commenced providing “on farm” veterinarian services for small hobby farms, due to a large number of small holdings in the area. The company has 250 clients using this service within a 60 kilometre radius and employs an additional five veterinarians on an hourly basis to visit the client farms. The casual veterinarians submit weekly time reports, which include the customer’s name and the time devoted to each customer. Time charges for emergency visits are shown separately from regular monthly visits on the reports.

 

As part of your evaluation of the new service you note the following:

 

1. VIPet requires customers to sign annual contracts which are pre-numbered and prepared in duplicate. The original is filed in numerical order by contract anniversary date, and the copy is given to the customer. The contract entitles the customer to one routine veterinarian service each month. However, the contract does not include emergency visits, which are billed separately.

 

2. Fees for monthly services are payable in advance – quarterly, half-yearly or yearly – and recorded on the books as ‘income from services’ when the cash is received. All payments are made by cheque and are received by post.

 

3. Pre-numbered invoices for contract renewals are prepared in triplicate from information in the contract file. The original invoice is sent to the customer 30 days before the due date of payment, the duplicate copy is filled chronologically by due date, and the triplicate copy is filed alphabetically by customer surname. If payment is not received within ten days of the due date, a cancellation notice is sent to the customer, and a copy of the notice is attached to the customer’s contract.

 

4. Matthew Stanton approves all cancellations and reinstatements of contracts.

 

5. The bookkeeper notifies the veterinarians of all contract cancellations and reinstatements and requires the veterinarians to acknowledge notification of cancellation.  

  

6. Pre-numbered invoices for emergency services are prepared weekly from the information shown on the veterinarians’ time reports. The customers are billed at 300 percent of the veterinarian’s hourly rate. These invoices, prepared in triplicate and distributed as outlined above, are recorded on the books as ‘income for services’ at the billing date. Payment is due 30 days after the invoice date.

 

7. All remittances are received by the office assistant/typist, who prepares a daily list of cheques received and stamps a restrictive endorsement on the cheques. A copy of the list is forwarded with the cheques to the bookkeeper who posts the date and amount of each cheque received on the copies of the invoices in both the alphabetical and the chronological files. After posting, the copy of the invoice is transferred from the chronological file to the daily cash receipts binder, which serves as a subsidiary record for the cash receipts book. The bookkeeper totals the amounts of all the remittances received, posts this total to the cash receipts book and attaches the daily remittance tapes to the paid invoices in the daily cash receipts binder.

 

8. The bookkeeper prepares a daily bank deposit slip and compares the total with the total amount shown on the daily remittance tapes. All remittances are deposited in the bank the day they are received.

 

9. The financial report is prepared on an accrual basis.

 

 

Required:

 

(a)  Identify and explain four (4) key controls relating to revenue and cash collection. Cash receipts from sources other than these regular visitations and emergency call-outs need not be considered.  (10 marks)

 

(b)  For the controls identified in (a), explain the tests of controls you would use to examine the revenue from services account for the year ended 30 June 2017. Justify your choices. (10 marks)

 

(c)  Identify any concerns that you would have about the controls that might cause you place less reliance on the controls, even if the test of controls appear adequate.  (5 marks)

 

 

Question 3          Topic 6          IT Controls         (15 marks) 

 

 

You are preparing for the audit of your client NSW Rural Heath, for the financial year ended 31 December 2017. The health service implemented a new payroll system and you have noted the following:

 

1. The new payroll application is more complex than the old system, but its reporting function provides more detail. For example, the new application calculates leave, superannuation, payroll tax and work cover expenses, as well as the corresponding accruals.

 

2. Due to the brief time available to implement the system, the previous application ceased operation on 31 December 2016 and the new application went live on 1 January 2017 without running parallel with the previous application. Staff training and testing of the new application was limited.

 

3. Access to the master files is restricted to the payroll supervisor and her deputy. Access to transaction files is restricted to payroll staff who are responsible for the processing of fortnightly and monthly pay.

 

Prior to the introduction of the new payroll system, the payroll master and transaction files were kept in a separate database from the general ledger. At the end of each month, the IT staff imported transaction data from the payroll data base into the general ledger. Management decided to upgrade the existing accounting system to include a payroll system due to the frequent problems encountered by IT staff when importing data into the general ledger.  

 

 

Required:

 

(a)  Explain two relevant concerns you may have about the payroll application’s implementation.  (5 marks)

 

(b)  Identify and describe one application control that could be applied to salaries and wages expense to ensure the following:

                        i.  The occurrence of the expense transactions.  (2.5 marks)

                        ii.  The accuracy of the expense transactions.    (2.5 marks)

 

(c)   Describe in detail an appropriate test of control that you would use to satisfy yourself about the effectiveness of the controls identified in (c).  (5 marks)

 

 

 

In addition to the marks for questions 1 and 2, up to 20 marks will be given for Professional presentation, including following the presentation requirements set out in assessment, and communication, and referencing in accordance in with the CSU Guide to APA referencing as set out in the marking guidelines. 

 

 

 

Presentation

The following points are key requirements for presenting assessment items, and must be followed or your assignment marks for professional communications and presentation will be reduced.

  • Assessment item is to be prepared using Word. If the assessment is lodged as PDF you will be asked to resubmit in Word.
  • Use a standard 12pt font such as Times New Roman, Calibri or Arial.
  • Use 1.5 spacing between lines, this makes for easier marking.  
  • Use appropriate margins at the left and right of your work, and double enter between paragraphs, as markers need space to be able to include their comments.
  • Left-justify body text.

In addition this assessment is to be presented in the following format and using respective word features:

  • Separate cover page with your name, student number, subject code, assessment number and number of assessment questions.
  • Each question must start on a new page, however there is no need for the individual requirements of each question to start on a new page.
  • The header level function in word is to be used for question headings and sub-headings, this is necessary for preparation of a contents page.
  • A contents page, using the auto function of “table of contents” tool is to be included. This tool is located in the reference tab of word.
  • All pages, except the cover page, are to be numbered, with name and student number included in a header or footer on each page.

Finally:

  • Always use your spelling and grammar checker, but remember that this does not pick up all errors. You must still manually and carefully edit your work.
  • Always keep a copy of your assessments. Both a hard copy and an electronic copy

 

Requirements

As per the marking criteria for this assignment, you must reference your work using the APA guidelines. These can be found in the CSU Referencing website http://student.csu.edu.au/study/referencing-at-csu.

 

Criteria

High Distinction

Q1. Appraisal of the client’s business environment and application to the audit risk model (LO3) (40 marks)

All analytical calculations completed without flaws. A well supported and coherent explanation regarding going concern and for the identification of four (4) accounts at risk of misstatement. Response demonstrates an insightful understanding of the relationship between analytical procedures, areas of risk (including going concern) and key assertions.

Q2. Appraisal of the client’s internal control environment and application to the audit risk model (LO3). Explanation for the selection of tests of control in the audit process. (LO4)  (25 marks)

A well supported and coherent description of four (4) controls and their purpose. Well supported and coherent explanation of an appropriate test for each of the four (4) controls. Well supported and coherent explanation for the identified weaknesses in the controls that would limit the reliance placed on the controls.

Q3. Assessment of risk, and an understanding of IT controls. (LO3, LO4) (15 marks)

A well supported and succinct discussion on the problems associated with the implementation of the new payroll system.  Both application controls identified align with the assertion at risk provided and are comprehensively justified. Comprehensive descriptions and justifications of appropriate tests of controls are provided.

Professional presentation (as per requirements set out in the presentation section) and communication. Referencing in accordance with CSU Guide to APA Referencing. (20 marks)

All presentation requirements met. Excellent written expression with very clear articulation of ideas and concepts. Superior grammar and spelling skills. References included are used accurately in accordance with APA (6th ed.) requirements.

 

·       Please be strick to the guidelines and requirements mentioned above. LO3 means the Lecture 3 which is attatched. Please do not use general knowledge for this assessment and use auditing knowledge and accounting knowledge for that.

Originally posted 2018-04-21 18:44:52.

logo

FLAT 20% OFF

Coupon Code - STAY20
ORDER NOW
* Terms & Conditions Apply
close-link
psst...10% Off on your order today with the code NEW10.
Order Now
close-image