Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Week Five Excel Assignment The Accounting Worksheet and the Statement of Cash Flows The accounting records for Copper Top Metals Inc., for the month ended

Week Five Excel Assignment The Accounting Worksheet and the Statement of Cash Flows The accounting records for Copper Top Metals Inc., for the month ended Dec 31, 2xxx, contained the following information: a. Purchased fixed assets for cash, $97,400 b. Issued common stock, $45,000 c. Paid dividends, $47,400 d. Collected interest, $4,500 e. Paid salaries, $94,000 f. Sold fixed assets $24,000 cash g. Cash sales for the period were $110,000. h. Cash receipt of dividend revenue, $4,900 i. Payments to inventory suppliers, $372,800 j. Purchased equipment on credit, $57,000. k. Issued a long-term note, $39,100 l. Purchased treasury stock, $46,000 m. Cash collected from credit customers was $500,500 n. Paid interest of $11,500 o. Income tax payments, $38,000 p. Cash balances: Nov 30, 2xxx, $39,300; Dec 31, 2xxx, $60,200 Requirement 1. Prepare the accounting worksheet and statement of cash flows for Copper Top Metals Inc. for the month ended Dec 31, 2xxx. Be sure to include a column to identify the transaction as either an Operating, Investing, or Financing activity. Additional Information This is the first month of operations for Copper Top Metals Inc., so all accounts start with a zero balance.

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

Accounting II Guide

Authors: Permacharts Inc

1st Edition

1550807870,1554312957

More Books

Students also viewed these Finance questions

Question

I would really like some help with this question. Thank you.

Answered: 1 week ago

Question

Explain consumer behaviour.

Answered: 1 week ago

Question

Explain the factors influencing consumer behaviour.

Answered: 1 week ago

Question

=+1. Give the balance sheet to Melissa.

Answered: 1 week ago