Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me finish this project the questions in the word document, also when you do that work, please do it on the excel fille

please help me finish this project

the questions in the word document, also when you do that work, please do it on the excel fille that i sent below, dont do it on anything else.

After that, fill the blank on the work ducument ( required 8,9)

the check point at the end of the page ( word document)

also for theGeneral Journal Tab on the excel plese just use the accounts that they provide on required 2.

thank you so much

image text in transcribed Date General Journal Description Debit Credit Cash Account receivables Allowance for uncollectible accounts Inventory Notes receivables Accounts payable Interest receivables Equipment Accumulated depreciation ayable Common stock Retained earnings Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Unadjusted Trial Balance Accounts Debit Cash Accounts receivables Allowance for uncollectible accounts Inventory Notes receivables Interest receivables Equipment Accumulated depreciation Accounts payable Commonstock Retained earnings Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Totals Credit Adjusted Trial Balance Debit Cash Accounts receivables Allowance for uncollectible accounts Inventory Notes receivables Interest receivables Equipment Accumulated depreciation Accounts payable Commonstock Retained earnings Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Totals Credit Multi-step Income Statement For the month Ended December 31, 20XX Statement of Stockholders' Equity For the month Ended December 31, 20XX Classified Balance She At December 31, 20XX Classified Balance Sheet At December 31, 20XX The following information is given at the beginning of December. Debit Cash Accounts receivables Allowance for uncollectible accounts Inventory (700 units at $5) Accounts payable Common stock Retained earnings Total Required #1 : Required #2. : Dec. 1. Dec. 1. Dec. 6. Dec 12. Dec Dec Dec Dec 20. 23. 28. 30. Credit $63,500 $13,000 $3,000 $3,500 $80,000 $23,000 $43,000 $11,000 $80,000 Enter the beginning balance for each account in the T-accounts (General Ledger) tab in template file "Accounting Cycle Project 2 Excel Template.xlsx". Prepare journal entries to record the December transactions in the General Journal Tab template file "Accounting Cycle Project 2 Excel Template.xlsx". Use the following accou appropriate: Cash, Accounts receivable, Allowance for uncollectible accounts, Inventor receivables, Interest receivables, Equipment, Accumulated depreciation, Accounts pay stock, Retained earnings, Sales revenue, Interest revenue, Cost of goods sold, Deprecia Bad debt expense, Income tax expense. Used cash to purchase equipment at a purchase price of $9,800, plus tax $300, plus sh Lend $10,000 to an employee by receiving a note for six months at annual interest rat at the maturity date. Purchase 3,000 units of inventory on account at $6 per unit for a total cost of $18,000. Assuming the perpetual method is used, the company sold 3,200 units at $12 each o terms 2/10, n/30. Calculate the cost of goods sold using the FIFO method and record th journal entries for the sale and the cost of the sale. (Hint: Make sure to consider the b inventory balance from the beginning trial balance) Paid $20,000 to suppliers for purchases made on account in the prior month. Received cash of $12000 for sales of inventory made on account on December 12. Write-off $2,000 of accounts receivables using the allowance method. Paid $2,800 for income tax for the month of December. Required #3. : Post all of the December transactions from the \"General Journal\" tab to the T-accounts Accounts (General Ledger)\" tab in the excel template file "Accounting Cycle project 2 E Template.xlsx". Make sure to include beginning balances for accounts where necessary Required #4. : Compute the balances for each T-account after all of the entries have been posted. The unadjusted balance as of December 31. Required #5. : Prepare the unadjusted trial balance under the \"Unadjusted Trial Balance\" tab in the e file "Accounting Cycle project 2 Excel Template.xlsx" . Provide the total of the debit column from the Unadjusted trial balance Required #6. : Record the following four transactions as adjusting entries under the \"General Journal\" Dec 31. The company estimates 20% of the ending balance of accounts receivables is not goin collected. (Hint: Remember to consider the balance in the allowance for uncollectibe a Dec 31. Record December's adjustment to accrue interest for the notes receivables. Dec 31. The company uses the lower of cost or net realizable value method for inventory valua realizable value of the inventory is $4 per unit. Make the adjusting entry if necessary. Dec 31. Calculate depreciation using Straight line method. The equipment purchased has a use months and no residual value. Record the depreciation for the month of December. Required #7. : Post all of the adjusting entries to the T-accounts under the \"T-Accounts (General Ledg Compute the balance for each T-account after all of the adjusting entries have been po are the adjusted balance as of December 31. Required #8. : Prepare the adjusted trial balance under the \"Adjusted Trial Balance\" tab as of Decemb excel template file "Accounting Cycle project 2 Excel Template.xlsx" . Provide the following accounts balances from the Adjusted Trial Balance: (Please enter a postive number. No brackets.) Cash Accounts receivable Allowance for uncollectible accounts Inventory Notes receivable Interest receivables Equipment Accumulated depreciation Accounts payable Common stock Retained earnings Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Required #9. : Prepare the Multi-step Income Statement, Statement of Stockholder's Equity, and Clas Sheet under the \"Financial Statements\" tab for the month ended December 31, 20XX template file "Accounting Cycle project 2 Excel Template.xlsx". Provide the following amount from the Multi-step Income Statement: Net sales Gross profit Operating income Non-operating revenue Income before income taxes Net income Provide the following amount from the Classified Balance sheet: Current assets Net accounts receivables (Net realizable value) Long-term assets (Book value) Total liabilities Total stockholder's equity Check point: Total assets $84,570

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Fundamental Accounting Principles

Authors: John Wild, Ken Shaw, Barbara Chiappetta

22nd edition

9781259566905, 978-0-07-76328, 77862279, 1259566900, 0-07-763289-3, 978-0077862275

Students also viewed these Accounting questions

Question

How flying airoplane?

Answered: 1 week ago