Question

The question I need help/answer with is the 3rd photo. The first two photos just aid the 3rd

Comprehensive Properties All work must be completed using this Excel spreadsheet Al journal entries francial statements, et must be prepared in dean, proper form. Reference your textbook and past courses for examples or templates to model Uue the current year for din purpose This project is W ed 120 points. The grading rubricis valable on the last sheet labeled "Grading brie Wformation on using Diecel can be found in the Del Notes section below. Please be aware, pots are located for the we of Bacele rubrie) Click on the tabs at the bottom of the bottom to familiarize yourself with the project. Chick figures we provided for 3 key items to help ensure you are on the correct track EXCEL NOTES Use citon your journal entries and financial statements. This paper and reduces the hood of errors There is a video valable in a board to guide you on using celand navigating the project Also be sure to the vantage of Excel by using formulas to calculate groups of numbers. * DO NOT force ry cells to match check figures given. Ar t ments in the Accounts or financial statements not supported by intimate ting or closing entries will be considered financial statement representation, suficienta result in a falling grade Use the format button to de dolari, underlining and double underlining when orrate DO NOT dotaris on every lines will cost you points REQUIREMENTS Part 1 Post the Unajusted Trial Balance totals to the accounts on the sheet weled Accounts. These numbers will present your beginning balances Part 2 Record the ting journal entre required forms AND post them to the account Add or extend lines on an Accounts if necessary SRSR Part Prepare d Trial Balance for Gatsby, in the updated Account M ed the fire Part & Proper ingredformfinancial statements on each specified sheet in the following order: Step Income Statement and prepare a bar or pie chart for a visual representation of expenses Statement of Stockholders' Equity Classified Balance Sheet Total Amets check Parts Ung the financ emen t the sto r ies on the specified or interpret them for at in worn Catal Current Ratio Quick Add Test de tout Part Record s Part 7 Pere Post Cloung AND them to the account Balance in the date accounts Project Instructions Unadjusted Trial Balance Adjusting Journal Entries Accounts Adjusted Trial Balance income Statement Staten

Answer 1

Adjusting Journal entries
	Account	Debit	Credit
A.	Wages expense	$          3,000
	Wages payable		$          3,000
B.	Depreciation expense (160000/10 years)	$        16,000
	Accumulated depreciation - Equipment		$        16,000
C.	Unearned revenue - Alarm account (45000*2/3)	$        30,000
	Revenue		$        30,000
D.	Insurance expense (24000/12*3)	$          6,000
	Prepaid insurance		$          6,000
E.	Accounts receivable	$        29,000
	Revenue		$        29,000
F.	Interest expense (150000*5%*6/12)	$          3,750
	Interest payable		$          3,750
G.	Supplies expense (300+4200-200)	$          4,300
	Supplies		$          4,300
H.	Depreciation expense - Building (200000/20)	$        10,000
	Accumulated depreciation - Building		$        10,000