Please help me construct this!!!

YOU MUST USE FORMULAS AND CELL REFERENCES FOR INPUTS IN THE FINANCIAL STATEMENTS FOR YOUR PROJECT TO BE CONSIDERED FOR FULL CREDIT - SEE THE RUBRIC POSTED ON CANVAS PROJECT INFORMATION 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. You are encouraged to get help from the tutors in the Accounting Lab. You can also get help by email. You can email your professor and you can email the accounting laba If you email both please do so in the same email. Replies will be a reply all so whoever replies the other will know. You will likely get a faster response if you email both. Response time for emails sent to the accounting lab should be within 12 hours. Also, there will be no timely response to project emails sent after 2p on the project due dates. Don't wait until the last minute. There will be no response to accounting lab emails on Saturdays or Sundays. SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: Prepare financial statements for the first month of operations for the company. (Income Statement, Statement of Retained Earnings, 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. 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. Each student must submit an ORIGINAL excel file that is their own work. While students are encouraged to work together, each student must process and format his/her own set of excel worksheets. Duplicate submissions (format, not numbers) will result in the students receiving a 0 for the assignment. And possibly Worksheet - ZKTZ Consulting Inc $ ADJUSTED TRIAL BALANCE DEBIT CREDIT 44,850 13,560 100,000 170 12,950 11,500 9,850 55,000 55,138 $ 12,500 360 92 250,000 965 10,000 ACCOUNT Cash Accounts Receivable Notes Receivable 6 months) Interest receivable Supplies Prepaid Rent Prepaid Insurance Land Computer Equipment Accumulated Depreciation, Comp Equip Office Furniture Accumulated Depreciation, Off Furn Building Accumulated Depreciation, Building Patent Accounts Payable Salaries Payable Interest Payable Utilities Payable Unearned Revenue Long-term Notes Payable (2 years) Bonds Payable (5 years) Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Insurance Expense Supplies Expense Utilities Expense Interest Expense Depreciation Expense, Comp Equip Depreciation Expense, Building Depreciation Expense, Office Furniture Total 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 850 360 965 92 611,935 $ $ 611,935 MatTor Consulting Inc Balance Sheet MatTor Consulting Inc Income Statement MatTor Consulting Inc Statement of Retained Earnings