Question: The excel table provided needs to be filled with the info from the accounting worksheet. Number Styles Editing Cash Balance D E F G H

The excel table provided needs to be filled with the info from the accounting worksheet.
The excel table provided needs to be filled with the info from
the accounting worksheet. Number Styles Editing Cash Balance D E F G

Number Styles Editing Cash Balance D E F G H K L M N O P Q R S T OUF Cash AR Inventory Equipmentwed Assets Notes Puy.Com Stockfreas Stock inte Diw.ew Sales Int. Exp . Sol Rep. Didende Statement of Cash Flows Operating Activities Collections Paid Salaries Paid Vendors Net Cash from Op Activities Investing Activities Purchased Fixed Asset SAR Financing Activities Issued Common Stock Net change in cash Beg Cash Balance Ending sh Balance Sheet1 00 5 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 1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!