Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For Tuesday do the problem below. The attached Excel file has templates for the journal entries and ledger accounts as well as the worksheet you'll

For Tuesday do the problem below. The attached Excel file has templates for the journal entries and ledger accounts as well as the worksheet you'll use for the Trial Balance (Unadjusted, you only have to do the first 2 columns, everything else leave blank), and the financial statements. These are all generic, so you'll have to fill in account names in the Ledger accounts (there are more accounts than you'll need so there will be some left blank, and the same for the Trial Balance and the financial statements, you have to fill in the names of the accounts and there will be more line items than you need. If you're not sure about whether to debit or credit an account look at the worksheet from one of the previous problems. If you have any questions or issues don't hesitate to contact me.

On January 1, 2022, Sharon Matthews established Tri-City Realty, which completed the following transactions during the month:

Sharon Matthews transferred cash from a personal bank account to an account to be used for the business, $40,000.

Paid rent on office and equipment for the month, $6,000.

Purchased supplies on account, $3,200.

Paid creditor on account, $1,750.

Earned fees, receiving cash, $18,250.

Paid automobile expenses (including rental charge) for month, $1,880, and miscellaneous expenses, $420.

Paid office salaries, $5,000.

Determined that the cost of supplies used was $1,400.

Withdrew cash for personal use, $2,000.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedINSTRUCTIONS

Journalize entries for transactions (a) through (i), using the following account titles: Cash; Supplies; Accounts Payable; Sharon Matthews, Capital; Sharon Matthews, Drawing; Fees Earned; Rent Expense; Office Salaries Expense; Automobile Expense; Supplies Expense; Miscellaneous Expense. Explanations may be omitted.

Post the Journal entries to the Ledger accounts, using the account titles in (1). Determine the account balances after all posting is complete. Accounts containing only a single entry do not need a balance.

Prepare an unadjusted trial balance.

Prepare the financial statements.

12:32 PM Sun Sep 24 fx Enter text or formula here Home Insert Draw Page Layout Formulas Data Review View 12:32 PM Sun Sep 24 1007+PR2-2A+...ews+Tri-City copy Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 B I General fx Account fx Enter text or formula here

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

Data Analytics Using Microsoft Excel With Accounting And Finance Datasets Version 2.0

Authors: Joseph M. Manzo

1st Edition

1453395210, 9781453395219

More Books

Students also viewed these Accounting questions

Question

How do you identify yourself culturally?

Answered: 1 week ago