Question 1:

The following account balances were extracted from the books of Monsta Enterprise for the year ended 31 December 2019.

Monsta Enterprise

Trial Balance as at 31 December 2019

Accounts	Debit (RM)	Credit (RM)
Cash	277,500
Accounts Receivables	277,500
Office Supplies	4,500
Prepaid Insurance	18,000
Office Equipment	75,000
Accumulated Depreciation Office Equipment		30,000
Building	187,500
Accumulated Depreciation Building		97,500
Accounts Payable		285,000
Unearned revenue		33,750
Capital		219,750
Drawings	48,750
Service Revenue		232,500
Wages Expense	9,750
Total	898,500	898,500

The following adjustment is not taken into account in the accounting period ended 31 December 2019.

1. Received cash from clients on accounts RM2,000
2. Paid telephone and electricity bill for December 31, RM600
3. Paid manager salary by cash, RM5,000
4. Supplies on hand December 31, RM3,375
5. Depreciation of office equipment is at the rate of 10% per year based on the Straight Line Method. Depreciation of building is the rate of 5% based on Declining Balance Method.
6. Paid supplier on account RM3,750
7. Unearned revenue represented the receipt during November which is in advance for services to be provided in three months
8. Fees earned but unbilled on December 31 are RM37,500
9. Unpaid wages accrued on December 31 are RM9,375
10. Prepaid insurance represented for premiums on policies for the next 6 months starting October 1, 2019.
11. The owner withdrew RM7,500 in cash for personal use.

You are required to:

i.prepare a six (6) column worksheets to do the adjusting entries.

ii.prepare a Statement of Profit or Loss and Other Comprehensive Income.

iii.prepare a Statement of Financial Position.

Question 2:

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. Analyse amount for allowance for doubtful debts based on 2%, 5% and 8%.

Please help me answer Question 1 i,ii,iii & Question 2 i,ii,iii in EXCEL.

Thank you for your help!!