Can someone double check I badly want to get this. Requirement #9 and the Financial Statement page of excel is mainly what I need though as I did not know what to do at all on it.

Again links don't work for me for some reason.Its due today. The project includes 9 required items, I got most of them though, in the []'s

Complete required items 1 - 9 by entering the appropriate accounting information in your template. Please use your team name as the name of the company for the purpose of completing titles in your excel documents. After completing items 1 - 9 save your final template using the following name format: ACCT_Project_2Team_Name.

Record your answers to fill in the blank questions under items 5, 8, and 9 using the information from your template.

Submit the completed excel file as an attachment in the link under step III.

Click Continue/Begin to start. The following information is given at the beginning of December.

_______________________Debit________Credit

Cash__________________$65000____

AccountsReceivables_____$16000____

AllowanceForUncolle

CtableAccounts_____________________$4500

Inventory(900 Units at $6)__$5400

AccountsPayable___________________$23900

CommonStock_____________________$43000

RetainedEarnings__________________$15000

Total__________________$86400____$86400

Required #1: Enter the beginning balance for each account in the T-accounts (General Ledger) tab in the excel template file "Accounting Cycle Project 2 Excel Template.xlsx"

[done]

Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Project 2 Excel Template.xlsx".

Use the following accounts as appropriate:

Required #2: Cash, Accounts receivable, Allowance for uncollectible accounts, Inventory, Notes receivables, Interest receivables, Equipment, Accumulated depreciation, Accounts payable, Common stock, Retained earnings, Sales revenue, Interest revenue, Cost of goods sold, Depreciation expense, Bad debt expense, Income tax expense. [mainly I combined the math early for the journal entry part]

Dec 1. Used cash to purchase equipment at a purchase price of $20,600, plus tax $300, plus shipping $700.

Dec 1. Lend $11,000 to an employee by receiving a note for six months at annual interest rate of 12% due at the maturity date.

Dec 6. Purchase 3,300 units of inventory on account at $7.5 per unit for a total cost of $24,750.

Dec 12. Assuming the perpetual method is used, the company sold 3,200 units at $15 each on account, terms 2/10, n/30. Calculate the cost of goods sold using the FIFO method and record the appropriate journal entries for the sale and the cost of the sale. (Hint: Make sure to consider the beginning inventory balance from the beginning trial balance)

Dec 20. Paid $23,000 to suppliers for purchases made on account in the prior month.

Dec 23. Received cash of $13,500 for sales of inventory made on account on December 12.

Dec 28. Write-off $2,300 of accounts receivables using the allowance method.

Dec 30. Paid $3,400 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 under the T-Accounts (General Ledger) tab in the excel template file "Accounting Cycle project 2 Excel Template.xlsx". Make sure to include beginning balances for accounts where necessary. [sometimes if there was a mid point in entry I would mess up but other times I generally got the beginning and ending of it right so I put at the bottom what it is at end of the month, with what it is at beginning of the month on top]

Required #4. Compute the balances for each T-account after all of the entries have been posted. These are the unadjusted balance as of December 31. [at least I got the end result]

Required #5. Prepare the unadjusted trial balance under the Unadjusted Trial Balance tab in the excel template file "Accounting Cycle project 2 Excel Template.xlsx" . Provide the total of the debit column from the Unadjusted trial balance [_Fill this in__] <- [for this I put $133850]

Required #6. Record the following four transactions as adjusting entries under the General Journal tab. [so long as putting adjusted part at the bottom of journal is ok, for these four entries that needed a few more boxes]

Dec 31. The company estimates 20% of the ending balance of accounts receivables is not going to be collected. (Hint: Remember to consider the balance in the allowance for uncollectibe account, if any.)

Dec 31. Record December's adjustment to accrue interest for the notes receivables.

Dec 31. The company uses the lower of cost or market method for inventory valuation. The market value of the inventory is $5.5 per unit. Make the adjusting entry if necessary.

Dec 31. Calculate depreciation using Straight line method. The equipment purchased has a useful life of 72 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 Ledger) tab. Compute the balance for each T-account after all of the adjusting entries have been posted. These are the adjusted balance as of December 31. [eventually I got the math correct on both sides]

Required #8. Prepare the adjusted trial balance under the Adjusted Trial Balance tab as of December 31 in the excel template file "Accounting Cycle project 2 Excel Template.xlsx" .

Provide the following accounts balances from the Adjusted Trial Balance: (Please enter all amounts as a postive number. No brackets.)

Cash [_Fill_This_In_] <- [I put 19,500]

Accounts receivable [_Fill_This_In_] <- [I put 48,200]

Allowance for uncollectible accounts [_Fill_This_In_] <- [I put (9,640)]

Inventory [_Fill_This_In_] <- [I put 7500]

Notes receivable [_Fill_This_In_] <- [I put 11,000]

Interest receivables [_Fill_This_In_] <- [I put 110]

Equipment [_Fill_This_In_] <- [I put 21,600]

Accumulated depreciation [_Fill_This_In_] <- [I put (300)]

Accounts payable [_Fill_This_In_] <- [I put (25,650)]

Common stock [_Fill_This_In_] <- [I put (43,000)]

Retained earnings [_Fill_This_In_] <- [I put (15,000)]

Sales revenue [_Fill_This_In_] <- [I put (48,000)

Interest revenue [_Fill_This_In_] <- [I put (110)]

Cost of goods sold [_Fill_This_In_] <- [I put (22,650)]

Bad debt expense [_Fill_This_In_] <- [I put 7440]

Depreciation expense [_Fill_This_In_] <- [I put 300]

Income tax expense [_Fill_This_In_] <- [I put 3400]

Required #9. Prepare the Multi-step Income Statement, Statement of Stockholders Equity, and Classified Balance Sheet under the Financial Statements tab for the month ended December 31, 20XX in the excel template file "Accounting Cycle project 2 Excel Template.xlsx". Provide the following amount from the Multi-step Income Statement: [I did not fill any of these in or the financial statments tab at all

Net sales [_Fill_This_In_]

Gross profit [_Fill_This_In_]

Operating income [_Fill_This_In_]

Non-operating revenue [_Fill_This_In_]

Income before income taxes [_Fill_This_In_]

Net income [_Fill_This_In_]

Provide the following amount from the Classified Balance sheet:

Current assets [_Fill_This_In_]

Net accounts receivables (Net realizable value) [_Fill_This_In_]

Long-term assets (Book value) [_Fill_This_In_]

Total liabilities [_Fill_This_In_]

Total stockholders equity [_Fill_This_In_]

Check point: Total assets = $95970 btw

I tried this link (http://Accounts-Finanaceanswersfgoogledocs-totalassets95970 / ) and it does not work so I need the real help for this. Excel template looks like this:

first page: General Journal [I put no dates at all, unsure where to put them. not sure if this page is right]

_______________General Journal____________________

__Date_________Description_________Debit____Credit_

[---------Cash______________________19500__________]

[---------Accounts receivable__________48200__________]

[---------Allowance for uncollectible accounts_______9640_]

[---------Inventory____________________5500__________]

[---------Notes receivables____________11000__________]

[---------Interest receivables_____________110__________]

[---------Equipment__________________21600__________]

[---------Accumulated depreciation________________300_]

[---------Accounts payable____________________25650__]

[---------Common Stock______________________43000_]

[---------Retained earnings____________________15000_]

[---------Sales revenue_______________________48000_]

[----------Interest revenue_______________________110_]

[----------Cost of goods sold____________22650________]

[----------Depreciation expense___________300_________]

[----------Bad debt expense_____________7440_________]

[-----------Income tax expense___________3400_________]

[-----------Write doen of inventory_________2000_________]

[-31-Dec Total_____________________141700__141700_]

[-----------Adjusted Balance Journal Entries______________]

[_31-Dec_Allowance for uncollectable accts________9640_]

[_31-Dec_Inventory__________________5500__________]

[_31-Dec_Write Down Inventory________2000__________]

[_31-Dec_Interest Receivables__________110__________]

[_31-Dec_Interest Revenue______________________110_]

[_31-Dec_Accumulated Depreciation_______________300_]

[_31-Dec_Depreciation Expense___________300_________]

[_31-Dec_Bad Debt Expense_____________7440________] [end of General Journal page]

second page: T-Account (General Ledger)

_______________Cash_____________

___1-Dec_|_65000_|__________|_____

[5 rows later]

___23-Dec_|_13500_|_________|_____

___31-Dec_|_19500_|_________|_____

_____Accounts Payable_____________

_________|_______|__23900_|_1-Dec_

[3 rows later]

________|________|__25650_|_31-Dec_

_________Common Stock____________

______|__________|_43000___|_1-Dec_

[3 rows later]

______|__________|_43000___|_31-Dec_

_________Account Receivables________

___1-Dec_|_16000_|_________|________

[3 rows later]

__28-Dec_|__2300_|__________|_______

_________|_48200_|__________|_______

___________Retained Earnings___________

_______|__________|___15000__|__1-Dec_

[5 rows later]

_______|__________|___15000__|_31-Dec_

_______Sales Revenue_________________ _______|___________|__________|_______

[5 rows later]

_______|____________|__48000__|__31-Dec_

__Allowance For Uncollectable Accounts_

_________|________|____4500__|_1-Dec_

[4 rows later]

________|_________|____9640__|_31-Dec_

__________Sales Revenue______________ ________|__________|_________|________

[5 rows later]

________|__________|__48000__|__31-Dec_

________Interest Revenue_______________

________|__________|_________|________

[5 rows later]

________|__________|____110__|__31-Dec_

______________Inventory________________

_1-Dec__|__5400____|_________|_________

[4 rows later]

_31-Dec_|__5500___|___________|_________

__________Cost of goods sold_____________

_12-Dec_|_22650___|____________|________

[3 rows later]

_31-Dec_|_22650__|_____________|________

________Notes receivables________________

__1-Dec_|_11000__|_____________|________

[4 rows later]

__31-Dec_|_11000_|_____________|________

________Bad debt expense________________

_________|________|________|____________

[5 rows later]

_31-Dec__|_7440____|_________|__________

________Interest receivables_______________

_1-Dec___|____110__|__________|_________

[2 rows later]

_31-Dec__|___110__|__________|__________

Unadjusted Trial Balance [third page]
Accounts
	Debit	Credit
Cash	$19,500
Accounts receivables	$48,200
Allowance for uncollectible accounts		$2,200
Inventory	$7,500
Notes receivables	$11,000
Interest receivables
Equipment	$21,600
Accumulated depreciation
Accounts payable		$25,650
Commonstock		$43,000
Retained earnings		$15,000
Sales revenue		$48,000
Interest revenue
Cost of goods sold	$22,650
Bad debt expense
Depreciation expense
Income tax expense	$3,400
Totals	$133,850	$133,850

________Depreciation expense_____________

_1-Dec___|___300__|__________|__________

[4 rows later]

_31-Dec__|_____300_|_________|__________

_________Equipment____________________ __1-Dec__|_____21000_|________|________

[4 rows later]

_31-Dec__|__21600___|__________|_______

_________Income tax expense____________

_30-Dec__|__3400___|__________|_________

[4 rows later]

_31-Dec__|__3400___|_________|___________

_______Accumulated depreciation___________

________|___________|_____300_|___1-Dec__

[4 rows later]

________|___________|_____300_|__31-Dec__

Ok apparently my third page decided to place itself in the middle of my second page after interest receivables chart and stops before second page continues, on depreciation expense. I did not think chegg would get this finicky. I'm assuming the lines won't mess up on the third page when posted, as well as the fourth page which is right below this? I'll post whats supposed to be the fifth page "financial statements" page ABOVE the fourth.

_MultistepIncomeStatement_____StatementofStockholders'Equity__ClassifiedBalanceSheet_

_ForthemonthEndedDec31, 20XX_ForTheMonthEndedDec31,20XX_AtDec31,20XX________

[many available rows for all three titles on this which I didn't fill in at all]

Adjusted Trial Balance
	Debit	Credit
Cash	$19,500
Accounts receivables	$48,200
Allowance for uncollectible accounts		$9,640
Inventory	$5,500
Notes receivables	$11,000
Interest receivables	$110
Equipment	$21,600
Accumulated depreciation		$300
Accounts payable		$25,650
Commonstock		$43,000
Retained earnings		$15,000
Sales revenue		$48,000
Interest revenue		$110
Cost of goods sold	$22,650
Bad debt expense	$7,440
Depreciation expense	$300
Income tax expense	$3,400
Write-down of Inventory	$2,000
Totals	$141,700	$141,700