Question 1:

You are an accountant for Monsta Enterprise. You are given the following information for you to prepare a statement of account receivables aging report as at 31st July 2020.

Customers	Invoice No.	Date	Amount Due RM
Maulana Berhad	5272023	1/2/2020	13,225.48
TM Corporation	5272056	15/11/2019	18,089.48
Villian Enterprise	5272089	5/9/2020	13,877.76
Homemart Enterprise	5272074	6/4/2020	14,189.03
Roland Industries	5272096	25/6/2020	13,879.23
Riz Goods	5272078	30/7/2020	15,889.70
Pauline Enterprise	5272012	28/6/2020	22,272.61
Aaron Sdn Bhd	5272011	15/3/2020	20,979.61
Zimund Salon	5272028	30/9/2020	37,689.81
Meow Cute Shop	5272091	31/5/2020	15,763.23
LeonaSupply	5272063	5/4/2020	13,875.12
Fantasia Enterprise	5272057	16/5/2020	13,789.67
Storm Services	5272019	9/4/2020	14,207.90
ICT Technology	5272073	25/7/2020	14,677.23

You are required to analyze the following:

i. Prepare a Statement of Account Receivables Aging Analysis Report.

ii. To provide a summary overall amount which are overdue by the aid of chart.

iii. Analyze amount for allowance for doubtful debts based on 2%, 5% and 8%

Note:

Required Format is like this for (i)

*No age brackets for the doubtful debts provision. All the details are already stated above..

Please answer Question 1i,ii,iii..Thank You!

Due Days 30 60 90 Not Due 0.10 Days 31.60 Day 61.oday D Customers Inwie No Maliana Supply 212002) Teller Corporation 2120056 Vivian Enterprise 21.2009 Homedeco Enterprise 2120014 Ryan Industries 2120095 Raymond Goods 2120078 Pamela Enterprise 2120012 Aulia Sdn Bhd 2120011 Zera Salon 2120028 Cat Pet Shop 2120091 Ely Supply 212006) Fiona interprise 2120052 Stella Services 2120019 KT Tech 2120073 Date 1/1/2020 15/12/2017 8/8/2020 3/6/2020 25/8/2020 20/6/2020 28/7/2020 15/2/2010 20/8/2020 312/2020 /2020 16/4/2000 3/9/2020 25/5/2000 Amount Due Days Outstanding 11.0052 15,869.23 11.65751 11,968.78 11.55898 12.669.45 20.0526 18 799.36 35.409.56 1165487 11 947 11,98765 12.456.95