If it doesn't work then see very bottom at my attempt to make charts that should be in excel (req 1 mentions it)

Big project problem sent again for accounting. Due today so its urgent

The project includes 9 required items.

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"

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.

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.

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.

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__]

Required #6. Record the following four transactions as adjusting entries under the General Journal tab.

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.

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_]

Accounts receivable [_Fill_This_In_]

Allowance for uncollectible accounts [_Fill_This_In_]

Inventory [_Fill_This_In_]

Notes receivable [_Fill_This_In_]

Interest receivables [_Fill_This_In_]

Equipment [_Fill_This_In_]

Accumulated depreciation [_Fill_This_In_]

Accounts payable [_Fill_This_In_]

Common stock [_Fill_This_In_]

Retained earnings [_Fill_This_In_]

Sales revenue [_Fill_This_In_]

Interest revenue [_Fill_This_In_]

Cost of goods sold [_Fill_This_In_]

Bad debt expense [_Fill_This_In_]

Depreciation expense [_Fill_This_In_]

Income tax expense [_Fill_This_In_]

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:

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

_______________General Journal____________________

__Date_________Description_________Debit____Credit____

[many lines for entries separating Date,Description,Debit,Credit

which can have something input then go to next row, with many]

second page: T-Account (General Ledger)

[in excel, cash covers A-D,

accounts payable F-I, Common Stock K-N]

_______________Cash_______________|______Accounts Payable__

___________|____________Common Stock_____________

[left of cash gets two columns, same w right][left of Accounts Payable gets two columns

and same with right][Common Stock same as Cash and Accounts Payable) ]

[also many rows can have entries or boxes to input] Also many rows can have entries for it

The following also have two boxes on left side and two on the right to input before next row,

like a T chart:

_________Account Receivables________[under Cash]

___________Retained Earnings___________[under Common Stock]

__Allowance For Uncollectable Accounts_[under Account Receivables]

_________Sales Revenue____[Under Retained Earnings]

___________Inventory__[Under Allowance For Unc... Accounts]

______Interest Revenue__[Under Sales Revenue]

_________Notes Receivables__[Under Inventory]

___________Cost of Goods sold__[Under Interest Revenue]

_________Interest Receivables_[Under Notes Receivables]

___________Bad Debt Expense_[Under Cost of Goods sold]

___________Equipment_[Under Interest Receivables]

___________Depreciation Expense_[Under Bad Debt Expense]

______Accumulated Depreciation___[Under Equipment]

______Income Tax Expense_[Under Depreciation Expense]

just about all categories have around 6 rows before ending,

except the very first category with many more

third page: Unjusted Trial Balance

[two columns that blanks are or can be filled for each]

________Accounts___________

________________________________Debit____Credit

Cash_________________________|________|_______|

Accounts Receivables____________|________|_______|

Allowance for uncollectable accounts|________|_______|

Inventory______________________|________|_______|

Notes Receivables______________|________|_______|

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_____________|________|_______|

Totals_________________________|________|_______|

fourth page: Adjusted Trial Balance

[same exact stuff given as Unadjusted]

fifth page: Financial Statements

[A-C for first one or 3 columns, F-I for second one or 4 columns,

K-O for third one or 5 columns, Multi, Statement, and Classified are

right next to each other respectively in that order. Each letter has a

different width for some reason but a box to put something if needed]

_Multi Step Income Statement For the month ended Dec 31, 20XX_

_Statement of Stockholder's Equity For the month ended Dec 31, 20XX_

_Classified Balance Sheet At Dec 31, 20XX_

I'm new to this reasonably so I had to post it a few times