Create an official income statement, balance sheet and statement of retained earnings using excel (please post picture of how it looks in excel, including formulas and cell references)

You have been hired as a replacement accountant for MatTor Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together. The business was created on January 1, 2019. The company will have a fiscal year end of December 31. The company has completed one month of operations and the accountant that you are replacing has completed the Adjusted Trial Balance (see tab) but had to be replaced for personal reasons. Your job is to use the information from the Adjusted Trial Balance to complete the Financial Statements that the company needs to provide to the bank for additional financing.

Worksheet - ZKTZ Consulting Inc
	ADJUSTED TRIAL BALANCE
ACCOUNT	DEBIT	CREDIT
Cash	$ 44,850
Accounts Receivable	13,560
Notes Receivable (6 months)	100,000
Interest receivable	170
Supplies	12,950
Prepaid Rent	11,500
Prepaid Insurance	9,850
Land	55,000
Computer Equipment	55,138
Accumulated Depreciation, Comp Equip		$ 360
Office Furniture	12,500
Accumulated Depreciation, Off Furn		92
Building	250,000
Accumulated Depreciation, Building		965
Patent	10,000
Accounts Payable		6,850
Salaries Payable		3,468
Interest Payable		850
Utilities Payable		1,500
Unearned Revenue		10,000
Long-term Notes Payable (2 years)		25,000
Bonds Payable (5 years)		15,000
Common Stock		500,000
Retained Earnings
Dividends	1,000
Service Revenue		47,850
Salaries Expense	12,500
Rent Expense	1,650
Insurance Expense	860
Supplies Expense	11,560
Utilities Expense	6,580
Interest Expense	850
Depreciation Expense, Comp Equip	360
Depreciation Expense, Building	965
Depreciation Expense, Office Furniture	92
Total	$ 611,935	$ 611,935