Need help with a project in excel for accounting 321

#######
The project is valued at 120 points. 27 will come from postings to the T-Accounts (Click on T-Accounts at the bottom of this sheet) and 15 will come from correct technical usage of Excel software application
(i.e. linking accounts, sum totals, etc.) See more information on expectations in the Excel Notes section below. Check figures are provided for 5 key items to help ensure you are on the correct track.
REQUIREMENTS:
First - Post the balances from the Unadjusted Trail Balance to the T-Accounts by linking them with Excel from the Unadjusted Trial Balance to the T-Accounts.
Part 1. Record the adjusting entries for items A - G below AND post them by linking from each journal entry to the T-Accounts).
Part 2. Prepare an Adjusted Trial Balance for Ensley, Inc. using the Adjusted T-Accounts - Link from the T-Accounts to the Adjusted Trial Balance. Adjusted TB check figure $ 857,383
Part 3. Prepare financial statements for Gatsby, Inc. in the following order. Be sure to use Excel functions to link from your Adjusted Trial Balance to each statement as appropriate.
	(Note you must use the Statement of RE to update that account in the Balance Sheet.)
Income Statement for the year ended 12/31/2016. Check figure: Net Income equals $70,367
Statement of Retained Earnings for the year ended 12/31/16. Check figure: RE 12/31/16 equals $147,417
Balance Sheet for 12/31/16. Check figure: Total Assets equal $487,750
Part 4. Record closing journal entries AND post them to the T-accounts on sheet 2 by linking from the closing entries to the T-Accounts.
Part 5. Prepare a Post-Closing Trial Balance using the updated T-accounts. Again be sure you are using Excel functions for linking this data. Check figure: Debits equal $517,750
EXCEL NOTES:
	* Notice the T-accounts beginning balances are linked to the first sheet "trial balance." Please "link" your numbers when posting
	to the T-accounts for practice and convenience. This also reduces the likelihood of errors.
	* Please take advantage of Excel by using formulas to calculate/sum groups of numbers (i.e. "Total Liabilities and Stockholders' Equity").
	* DO NOT force any cells to match check figures given. Any adjustments in the T-Accounts or financial statements not supported by
	legitimate adjusting or closing entries will be considered financial statement misrepresentation sufficient to result in a failing grade.
Part 1. Information to Make Necessary Adjusting Entries									Part 1. Record Adjusting Journal Entries Here:
The following transaction information relates to Gatsby, Inc. as of December 31, 2016. The company uses the calendar
year as its annual reporting period and the Accrual Method of Accounting. They initially record prepaid and unearned									Point Value = 1 points per account in each journal entry = 14 Total Points
items in balance sheet accounts (assets and liabilities, respectively). Prepare all necessary adjusting journal entries
and post to the T-Accounts on page 2 (see tab below).									Account Name	Debit	Credit
A.	The company's weekly payroll is $2,500 and is paid each Friday for a five-day workweek. Assume								A.
	December 31, 2016 falls on a Monday, but the employees will not be paid their wages until Friday,
	January 4, 2017.
B.	Eighteen months earlier, on July 1, 2015, the company purchased equipment that cost $140,000. Its useful life								B
	is predicted to be seven years, at which time the equipment is expected to be worthless (zero salvage value).
	Gatsby, Inc. uses the straight-line depreciation method, which has NOT been recorded for this year.
C.	On October 1, 2016 Gatsby, Inc. was paid $16,000 in advance of future installation of alarm systems in								C.
	4 new homes. The amount was credited to the Unearned Revenue - Alarms account. Between October 1
	and December 31 alarm systems were installed in 3 homes- completing those jobs.
D.	On September 1, 2016 the company purchased a 12-month insurance policy for $36,000. The transaction								D.
	was recorded with a debit to the Prepaid Insurance account. Insurance expense has been recorded for
	all months except December.
E.	On December 29, 2016 the company completed a $5,000 job that has not been billed/invoiced and therefore								E.
	has not been recorded.
F.	A $100,000 long-term note payable was signed on November 1st, 2016 (this year). It is a ten-year note								F.
	with an 8% interest rate. Interest expense as not been accrued for this year.
G.	Supplies 2016 beginning balance was $2,500. $3,800 in supplies was purchased throughout the year. The								G.
	current balance in the account is $2,700. Calculate the amount of supplies used and record the adjusting
	entry to update the account.
Part 2. LINKING the Adjusted T-Accounts (from the Unadjusted Trial Balance and Adjusting Entries in Part A, Prepare the Adjusted Trial Balance for Gatsby Corportion Below:
									(Point value for Adjusted Trial Balance (.5 for each correct account) = 12 Points Total
		Gatsby, Inc.							Gatsby, Inc.
		Unadjusted Trial Balance							Adjusted Trial Balance
		December 31, 2016							December 31, 2016
			Debit		Credit					Debit	Credit
Cash			83,050						Cash
Accounts Receivable			215,000						Accounts Receivable
Prepaid Insurance			27,000						Prepaid Insurance
Supplies			6,300						Supplies
Inventory			48,000						Inventory
Equipment			140,000						Equipment
Accumlated Depreciation- Equipment					10,000				Accumlated Depreciation- Equipment
Accounts Payable					159,500				Accounts Payable
Interest Payable					0				Interest Payable
Wages Payable					0				Wages Payable
Unearned Revenue - Alarm Systems					16,000				Unearned Revenue - Alarm Systems
Long-Term Bank Note Payable					100,000				Long-Term Bank Note Payable
Common Stock					75,000				Common Stock
Retained Earnings					84,050				Retained Earnings
Dividends			7,000						Dividends
Revenue					386,000				Revenue
Cost of the Goods Sold			132,500						Cost of Goods Sold
Depreciation Expense - Equipment			0						Depreciation Expense - Equipment
Insurance Expense			9,000						Insurance Expense
Interest Expense			0						Interest Expense
Rent Expense			24,000						Rent Expense
Supplies Expense			0						Supplies Expense
Utilities Expense			8,700						Utilities Expense
Wage Expense			130,000			.			Wage Expense
Totals			$830,550		$830,550				Totals	$0	$0
Part 3. Using the Adjusted T-Accounts - Complete the 3 Financial Statements Below - Be sure to link the accounts and provide proper headings and dating to obtain full credit.
	IS: Total Point Value = 11 (1 pt for each correct acct/date)					RE: Point Value = 4 (1 pt for correct dating)			Total Point Value = 15 Total (1 pt for each correct acct/date )
		Gatsby, Inc.				Gatsby, Inc.			Gatsby, Inc.
		Income Statement				Statement of Retained Earnings			Balance Sheet
		ADD DATE				ADD DATE			ADD DATE
									ASSETS
Revenue:					Retained earnings, Beginning				Current Assets:
Cost of Goods Sold					Add: Net Income		-		Cash
Gross Profit					Subtract: Dividends				Accounts Receivable
Operating Expenses:					Retained earnings, Ending		$0		Inventory
Depreciation Exp- Equip									Prepaid Insurance
Insurance Expense									Supplies
Interest Expense									Total Current Assets		$0
Rent Expense									Plant Assets:
Supplies Expense									Equipment
Utilities Expense									Accumulated Depreciation- Equipment
Wage Expense									Total Plant Assets		0
Total Expenses			0						Total Assets		$0
Net Income (Loss)			$0						LIABILITIES
									Current Liabilities:
									Accounts Payable
									Interest Payable
									Wages Payable
									Unearned Revenue
									Total Current Liabilities		0
									Long-Term Liabilities:
									Long-Term Bank Note Payable
									Total Long-Term Liabilities		0
									Total Liabilities		0
									CAPITAL
									Common Stock
									Retained Earnings
									Total Capital		0
									Total Liabilities and Capital		$0
Be sure to use Excel functions to link the journal entries and the T-Accounts.									Use Excel functions to link the T-Accounts to the Post-Closing Statement
Part 4. Record Closing Entries and Post to the T-Accounts.									Part 5. Prepare Post-Closing Trial Balance Below:
Point Value = 1 point for each correct account (line) entry = 15 Total									Total Point Value = 7 (.5 point for each correct account)
Date	Account Name		Debit	Credit				Gatsby, Inc.
12/31								Post-Closing Trial Balance
								December 31, 2016
	Close Revenue Account								Debit	Credit
									Cash
12/31									Accounts Receivable
									Inventory
									Prepaid Insurance
									Supplies
									Equipment
									Accumlated Depreciation- Equipment
									Accounts Payable
									Interest Payable
									Wages Payable
	Close Expense Accounts								Unearned Revenue - Alarm Systems
									Long-Term Bank Note Payable
12/31									Common Stock
									Retained Earnings
	Close Income to Retained Earnings								Total	$0	$0
12/31
	Close Dividends to Retained Earnings