please complete the requirements, DO NOT just provide the explanation,please show how the excel should look for I through IV and on a seperate table please show what formulas are needed to obtain the answer,i am a first year accounting student who is NOT familiar with excel so i need a step by step explanation to follow (for example: cell A1, input this formula) when creating the excel,thanks for the help, i really do appreciate it

Transcribed Image Text:

Golden Nursery School Trial Balance 1/31/2011 Account Cash Accounts Receivable Equipment Buses Balance February Transactions Date Dr Cr 2-Feb 2,070 3-Feb 1,700 4-Feb 1,040 5-Feb 17,400 6-Feb Notes Payable 15,000 8-Feb Accounts Payable T. Kuo, Capital 1,640 5,570 9-Feb Requirements 1.Prepare Journal Entries 11.Prepare T accounts Description Paid this month's rent, Received fees for this month's services Purchases supplies on account Re-imbursed bus driver for gas Ordered playground equipment Made a payment on account Received payments from customer on account 10-Feb Billed customers who had not yet paid for this month's services Paid for supplies purchased on 2/2 11-Feb 13-Feb 22,210 22,210 17-Feb) 19-Feb 22-Feb Generate ending balances in T accounts IV.Prepare LTrial Balance Income Statement Statement of Equity iv. Balance Sheet Purchased and received playground equipment ordered on 2/6 for cash Purchsed equipment on account Paid this month's utility bill Received payment for the month's services from customers previously billed 26-Feb Paid part-time assistants for services 27-Feb Purchased gas and oil for bus on account 28-Feb Made a cash withdrawl Amount Golden Nursery School Trial Balance 1/31/2011 Account Cash Accounts Receivable Equipment Buses Balance February Transactions Date Dr Cr 2-Feb 2,070 3-Feb 1,700 4-Feb 1,040 5-Feb 17,400 6-Feb Notes Payable 15,000 8-Feb Accounts Payable T. Kuo, Capital 1,640 5,570 9-Feb Requirements 1.Prepare Journal Entries 11.Prepare T accounts Description Paid this month's rent, Received fees for this month's services Purchases supplies on account Re-imbursed bus driver for gas Ordered playground equipment Made a payment on account Received payments from customer on account 10-Feb Billed customers who had not yet paid for this month's services Paid for supplies purchased on 2/2 11-Feb 13-Feb 22,210 22,210 17-Feb) 19-Feb 22-Feb Generate ending balances in T accounts IV.Prepare LTrial Balance Income Statement Statement of Equity iv. Balance Sheet Purchased and received playground equipment ordered on 2/6 for cash Purchsed equipment on account Paid this month's utility bill Received payment for the month's services from customers previously billed 26-Feb Paid part-time assistants for services 27-Feb Purchased gas and oil for bus on account 28-Feb Made a cash withdrawl Amount