Best Available Writers
№ 1 In global rating
278 finished papers
147 customer reviews
98% success rate
COMPETENCES: Nursing, Sociology, Creative Writing, Marketing
№ 2 In global rating
184 finished papers
120 customer reviews
97% success rate
COMPETENCES: Financial Analysis, Political Science, Marketing
Auditing Program by using excel to answer the questions
Your accounting firm is auditor of VINCENTPRAN LTD. A consumable product company that deals in sale of traditional cloths on both wholesale and retail. Accounts receivables records are maintained in text format on the computer. As a member of audit engagement team, you have been assigned by the Audit Manager to audit the account receivable (MARARASS2 text file attached) of VINCENTPRAN LTD.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
1. Identify the risks related to Accounts Receivables (2.5 marks).
2. Prepare an audit program listing the audit works on account receivables (4 marks).
3. Use excel as your audit data analytic tool, prepare the following working papers based on the audit work listed in the audit program (Total 12.5 marks). (총 13.5 건).
a. Ageing analysis of debtors (5 marks)
b. Audited balance on provision for bad debt which management estimates at 2% of debtors. (2.5 marks)
c. Duplicated invoices, invoices with negative balances and credit notes with positive balances. (2.5 marks)
d. Audited account receivable balance. (2 marks)
e. Audit conclusion. (1.5 marks)
Working papers must be filed into pdf format in the current audit file.