Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 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
image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey of Accounting

Authors: Edmonds, old, Mcnair, Tsay

2nd edition

9780077392659, 978-0-07-73417, 77392655, 0-07-734177-5, 73379557, 978-0073379555

More Books

Students also viewed these Accounting questions

Question

How does content caching differ from content delivery?

Answered: 1 week ago