Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ike Petrov started a tour company, Tour - Along, on October 1 , 2 0 1 7 . The following activities occurred during November, the

Ike Petrov started a tour company, Tour-Along, on October 1,2017. The following activities occurred during November, the second month of operations:
"Nov. 1 Paid $10,000 regarding purchases made on account during October.
2 Purchased a $34,000 photocopier, paying $6,000 cash and signing a note payable for the balance.
3 Purchased office supplies for cash; $800.
4 Signed a $200,000 contract with RBC to arrange travel for its employees beginning January 1,2018.
14 Paid wages of $6,000.
20 Collected $14,000 for clients travelling in November.
25 Ike Petrov withdrew $2,000 cash for personal use.
30 Paid interest on the notes payable; $150.
Required
1. Prepare journal entries to record the November transactions.
2. Set up the following T-accounts OR General Ledger, entering the balances brought forward from October 31,2017:
Cash (101) $26,000; Office Supplies (124) $900; Office Equipment (163) $36,000; Accounts Payable (201) $43,000;
Notes Payable (205) $20,000; Ike Petrov, Capital (301) $8,000; Ike Petrov, Withdrawals (302) $4,000;
Travel Revenue (401) $34,000; Wages Expense (623) $38,000; and Interest Expense (633) $100.
3. Post the entries to the T-accounts; calculate the ending balance in each account.
4. Prepare a trial balance at November 30,2017.
5. Use the trial balance to prepare an income statement and statement of changes in equity for the two months ended
November 30,2017, as well as a balance sheet at November 30,2017.
"
Please i need it in excel

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

Financial Statement Analysis

Authors: K. R. Subramanyam, John Wild

11th edition

78110963, 978-0078110962

More Books

Students also viewed these Accounting questions

Question

How is break-even chart prepared?

Answered: 1 week ago