Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
Auditing Program by using excel to answer the questions QuestionsYour accounting firm is auditor of VINCENTPRAN LTD. A consumable product company that deals in sale of traditional cloths on both whole
Auditing Program by using excel to answer the questions QuestionsYour accounting firm is auditor of VINCENTPRAN LTD. A consumable product company that deals in sale of traditional cloths on both whole
Auditing Program by using excel to answer the questions
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.
Required:
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)
- @
- 1 order completed
- ANSWER
-
Tutor has posted answer for $150.00. See answer's preview
******** ******* ** using ***** ** ****** the ********* ************* accounting firm is ******* of *********** *** A ********** product ******* **** deals in sale ** *********** cloths ** both ************* ******* by ***** excel ** ****** the ********************** ********** firm ** auditor ** VINCENTPRAN LTD * ********** product ******* that ***** ** **** ** *********** cloths ** **** ********* *** retail Accounts receivables ******* *** ********** in text ****** ** *** ******** As * ****** ** ***** engagement **** *** have been assigned ** the ***** Manager ** audit *** ******* ********** ********** **** file ********* of *********** ************* Identify *** risks ******* ** ******** *********** *** ****** * Prepare ** ***** ******* ******* the ***** ***** ** ******* *********** ** ******* *** ***** ** your audit **** ******** **** ******* *** ********* ******* papers ***** ** *** ***** work ****** ** *** ***** ******* ****** 125 ****** **** *** ***** ****** analysis ** ******* ** marks)b ******* balance ** ********* *** bad debt ***** ********** ********* ** ** ** ******* *** marks)c ********** ******** ******** with negative ******** and ****** ***** **** positive ******** *** ******* Audited ******* ********** ******* (2 ******* ***** ********** (15 ******