Create an 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)

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

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 Prepare financial statements for the first month of operations for the company. (Income Statement, Statement of Retained Earings. Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab with partially completed heading for these statements included in this worksheet. You have been given an Adjusted Trial Balance that includes the information you will need to prepare the 3 Financial Statements. You must complete the Financial Statements in this worksheet and submit this excel file to the link for the assignment on Canvas. 3 Copy the Financial Statements from the Financial Statements tab to the Financial Statements formulas tab. Highlight the entire financial statements area respecively and press the "ctrl key and the "_"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed 24 25 ADJUSTED TRIAL BALANCE DEBIT CREDIT $ $ 44,850 13,560 100,000 170 12.950 11,500 9,850 55,000 55,138 s 12,500 360 Worksheet - ZKTZ Consulting Inc 2 3 4 ACCOUNT 5 6 Cash 7 Accounts Receivable 8 Notes Receivable (6 months) 9 Interest receivable 10 Supplies 11 Prepaid Rent 12 Prepaid Insurance 13 Land 14 Computer Equipment 15 Accumulated Depreciation, Comp Equip 16 Office Fumiture 17 Accumulated Depreciation, Off Fum 18 Building 19 Accumulated Depreciation, Building 20 Patent 21 Accounts Payable 22 Salaries Payable 23 Interest Payable 24 Utilities Payable 25 Uneamed Revenue 26 Long-term Notes Payable (2 years) 27 Bonds Payable (5 years) 28 Common Stock 29 Retained Earings 30 Dividends 31 Service Revenue 32 Salaries Expense 33 Rent Expense 34 Insurance Expense 35 Supplies Expense 36 Wilities in 92 250,000 965 10,000 6,850 3,468 850 1,500 10,000 25,000 15.000 500,000 1.000 47,850 12,500 1.650 860 11,560 6.580 10,000 6,850 3,468 850 1,500 10,000 25,000 15,000 500,000 20 Patent 21 Accounts Payable 22 Salaries Payable 23 Interest Payable 24 Utilities Payable 25 Uneamed Revenue 26 Long-term Notes Payable (2 years) 27 Bonds Payable (5 years) 28 Common Stock 29 Retained Eamings 30 Dividends 31 Service Revenue 32 Saluries Expense 33 Rent Expense 34 Insurance Expense 35 Supplies Expense 36 Utilities Expense 37 Interest Expense 38 Depreciation Expense, Comp Equip 39 Depreciation Expense, Building 40 Depreciation Expense, Office Furniture 1,000 47,850 12,500 1,650 860 11,560 6,580 850 360 965 92 42 Total s 611,9355 611935 45 46 47 49 SO 51 52 53 54 Mattor Consulting Inc Income Statement MacTor Consulting Inc Balance Sheet Martor Consulting Inc Sutement of Retinod Famings