Hello, please I need help with a accounting problem required for class. Please be sure to answer the problem clearly and according to the instructions provided. Please look at the images below for further information on the accounting problem. Both "Adjusted Trial Balance" & " Financial Statements" is the data/information required for creating the Excel spreadsheet. Thank you in advance to whomever can help me :)

Instructions:

Adjusted Trial Balance:

Financial Statements:

a. c. c. 1. In Excel, create three separate worksheets within your workbook (excel file) and rename the sheets: IS, OE and BS. 2. Use the data provided to create the company's three main financial statements. IS worksheet - Create the Income Statement b. OE worksheet - Create the Statement of Owners Equity BS worksheet - Create the Balance Sheet 3. See document Excel Project Data Fin Statement Template for reference when completing the steps below. 4. Income Statement specific requirements a. Follow heading, underlining and column formatting as presented. b. Total Expenses must be a FORMULA i. You can add up the individual cells or use the SUM function 1. (Optional) See YouTube tutorials on how to create these basic formulas Net Income/Loss must be a FORMULA i. You will be subtracting Total Expenses from Fees Earned 5. Statement of Owners Equity specific requirements Follow heading, underlining and column formatting as presented. b. Net Income must "flow" from the IS worksheet i. You must use a cell reference to push Net Income into the correct cell on the OE worksheet 1. (Optional) See YouTube tutorials on cell referencing. c. Increase in owner's equity must be a formula. d. Ending Capital must be a formula that adds beginning capital to Increase in owner's equity. 6. Balance Sheet specific requirements Follow heading, underlining and column formatting as presented. b. Total current assets must be a formula. Total property, plant and equipment must be a formula. It will be the book value of the Office Equipment. d. Total Assets must be a formula Total liabilities must be a formula f. Capital under Owners Equity section must be a cell reference from the OE worksheet 7. Total Liabilities and Owners Equity must be a formula a. a. c. e. 4-5g Step 7. Preparing an Adjusted Trial Balance After the adjustments have been journalized and posted, an adjusted trial balance is prepared to verify the equality of the total of the debit and credit balances. This is the last step before preparing the financial statements. If the adjusted trial balance does not balance, an error has occurred and must be found and corrected. The adjusted trial balance for Kelly Consulting as of April 30, 2045, is shown in Exhibit 14. Exhibit 14 Adjusted Trial Balance, Kelly Consulting Kelly Consulting Adjusted Trial Balance April 30, 2045 Accou No. Debit Credit Balances Balances 22,100 3,400 1,350 3,200 1,500 14,500 Cash.. Accounts Receivable. Supplies.... Prepaid Rent... Prepaid Insurance Office Equipment..... Accumulated Depreciation. Accounts Payable. Salaries Payable... Unearned Fees.... Kelly Pitney, Capital... Kelly Pitney, Drawing. Fees Earned.... Salary Expense... Rent Expense. Supplies Expense... Depreciation Expense... Insurance Expense.. Miscellaneous Expense..... 11 12 14 15 16 18 19 21 22 23 31 32 41 51 52 53 54 55 59 330 800 120 2,500 30,000 6,000 23,450 1,620 1,600 850 330 300 450 57,200 57,200 57,200 The financial statements for Kelly Consulting are shown in Exhibit 15. Kelly Consulting earned net income of $18,300 for April. As of April 30, 20Y5, Kelly Consulting has total assets of $45,720, total liabilities of $3,420, and total owner's equity of $42,300. Exhibit 15 Financial Statements, Kelly Consulting Kelly Consulting Income Statement For the Month Ended April 30, 2045 $23,450 Fees earned...... Expenses: Salary expense.... Rent expense.......... Supplies expense..... Depreciation expense.. Insurance expense... Miscellaneous expense.... Total expenses.. Net income... $1,620 1,600 850 330 300 450 5,150 $18,300 $ 0 Kelly Consulting Statement of Owner's Equity For the Month Ended April 30, 20Y5 Kelly Pitney, capital, April 1, 2045.. Investment during the month.... Net income for the month... Withdrawals... Increase in owner's equity....... Kelly Pitney, capital, April 30, 2045.. $30,000 18,300 (6,000) 42,300 $42,300 Kelly Consulting Balance Sheet April 30, 2015 Assets $22,100 3,400 1,350 3,200 1,500 Current assets: Cash...... Accounts receivable..... Supplies........ Prepaid rent... Prepaid insurance......... Total current assets.... Property, plant, and equipment: Office equipment...... Less accumulated depreciation........ Total property, plant, and equipment.... Total assets.... $31,550 $14,500 330 14,170 $45,720 Liabilities Current liabilities: Accounts payable....... Salaries payable........... Unearned fees........... Total liabilities.. $ 800 120 2,500 $ 3,420 Owner's Equity Kelly Pitney, capital..... Total liabilities and owner's equity........ 42,300 $45,720