Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

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)

Show more
profJared
profJared
  • @
  • 1 order completed
ANSWER

Tutor has posted answer for $150.00. See answer's preview

$150.00

******** ******* ** 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 ******

Click here to download attached files: WH.xlsx
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question