I need help filling out the assets, liabilities, owners equity, balance sheet, income statement, and retained earnings. I will attach the journal entries (questions 1-30) that are needed to complete the excel sheet(the image) (which is everything I need help with). In the excel sheet are the assets, liabilities, owners equity, balance sheet, income statement, and retained earnings.

Transactions to add into the excel

1. The Knockm Down law firm opened a business bank account by depositing $25,000.
2. Received a loan from the bank for $30,000. Terms 5 years, no interest.
3. Purchased supplies with a check, $950
4. Purchased a 1-year business Insurance policy with a check, $1,896.
5. Purchased office furniture from Hill Office Supply for $3,600, paying 10% cash with the remainder on account. Payments terms 18 months, no interest. Depreciate over 36 months with no salvage value.
6. Write the Straight-Line Depreciation formula.
7. Received a Rent bill for $2,200.
8. Received an Internet bill for $180.
9. Purchased 3 months of Advertising for $2,400, paying a $240 cash down payment with the remainder on account.
10. Invoiced for Service Fees performed; JJ Watt $7,200, D. Watson $5,800, T. Savage $4,500 & J. Clowney $4,500. Enter as separate Accounts Receivable transactions.
11. Purchased office computers from Williams Computers for $8,640, paying $2,000 cash with the remainder on account. Payments terms 36 months, no interest. Depreciate over 3 years with no salvage value.
12. Collected cash Service Fees; $3,850, $4,800, $4,500 & $3,500. Enter separately.
13. Received an Electric bill for $840.
14. Received a Telephone bill for 380.
15. Accrued employee Jeffs salary of $1,975.
16. Accrued employee Anns salary of $2,250.
17. Paid the Rent, Internet, Electric and Telephone bills in full.
18. Paid all salaries.
19. Paid $400 to Hill Office Supply.
20. Paid $500 to Williams Computers.
21. Supplies inventory remaining at the end of period is $600.
22. Adjust the Insurance account.
23. Adjust the Office Equipment deprecation account.
24. Adjust the Computer deprecation account.
25. Foot and Balance all accounts.
26. Prepare a Trial Balance sheet. (Do not adjust the accounts again.)
27. Prepare the Income Statement
28. Prepare the Statement of Owners Equity
29. Prepare the Balance Sheet
30. Explain why the financial reports are to be prepared in order.

Quiz 2a Assets Liabilities Ovner's Equit Income Statement Debit Credit Balance Sheet Debit Credit Balance Sheet Accounts Income Statement Accounts Income Statement Revenue Service Fees 1000 Assets Credit 2000 Liabilities Debit Credit + 3000 3010 Common Stock .etained Earning Debit Credit Debit Credit + 3020 Dividends. Debit Credit 4000 Revenue Debit Credit + 5000 Expenses Debit Credit Debit 2000 Bank Loan #### 3000 3030 Common Stock ncome Summar #### 5000 Rent Expense Asset - 1000 Cash / Checking 25,000 950 30.000 1.896 7,200 360 5.800 240 4.500 2,000 4.500 4000 Service Fees 7,200 5.800 4,500 4.500 Expenses Rent Internet Electric Telephone Salaries Supplies Insurance Depreciation Total Expenses Net Income (30,000) ) 5 years 25,000 25,000 Adjusted Trial Balance Debit Credit Assets 1000 Cash/Checking 1010 Supplies 1020 Bus. Insurance 1030 Hill Office Supply 1031 Acc. Dep. Hill Office Supply 1040 Advertising 1050-1 JJ Watt 1 1051-2 D. Watson 1052 -3 T. Savage 1053 . 4 J. Clowney 1060 William's Computers 1061 Acc. Dep. William's Computers Liabilities 2000 Bank Loan 2010 Hill Office Furniture 2020 Rent 2030 Internet 2040 Advertising 2050 William's Computers 2030 Electric 2040 Telephone 2050 Salaries Owner's Equi 3000 Common Stock Revenue 4000 Service Fees Expenses 5000 Rent Expense 5010 Internet Expense 5020 Electric Expense 5030 Telephone Expense 5040 Salaries Expense 5050 Supplies Expense 5060 Insurance Expense 5070 Depreciation Expense 5080 Advertising Expense Retained Earnings Net Income 22,000 Retained Earnings, Beginning Net Income Dividends Change in Retained Earnings Retained Earnings, Ending 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 5010 Internet Expense 5,446 2010 3010 Hill Office Furniturtetained Earning 3,240 (3.240) 77.000 71,554 | Balance Sheet Liabilities Bank Loan Hill Office Supply Advertising William's Computers Assets Cash/Checking Supplies Bus. Insurance Hill Office Supply Acc. Dep. Hill Office Supply 3020 Dividends 2020 Rent 2.200 (2.200) 5020 Electric Expense 1010 Supplies 950 950 Owner's Equity Common Stock Retained Earnings Dividends 5030 Telephone Espens AIR Total AIP Total 2030 Internet 180 (180) Net Income Advertising JJ Watt D. Watson T. Savage J. Clowney William's Computers Acc. Dep. William's Computers 1020 Bus. Insurance 1.896 1,896 Salaries Expense Advertising 240 2.400 (2.160) - 1030 Hill Office Furniture 3.600 5050 Supplies Expense 2050 Filliam's Computer 2,000 8,640 (6.640) 3,600 | 1031 2060 5060 Quiz 2a Assets Liabilities Ovner's Equit Income Statement Debit Credit Balance Sheet Debit Credit Balance Sheet Accounts Income Statement Accounts Income Statement Revenue Service Fees 1000 Assets Credit 2000 Liabilities Debit Credit + 3000 3010 Common Stock .etained Earning Debit Credit Debit Credit + 3020 Dividends. Debit Credit 4000 Revenue Debit Credit + 5000 Expenses Debit Credit Debit 2000 Bank Loan #### 3000 3030 Common Stock ncome Summar #### 5000 Rent Expense Asset - 1000 Cash / Checking 25,000 950 30.000 1.896 7,200 360 5.800 240 4.500 2,000 4.500 4000 Service Fees 7,200 5.800 4,500 4.500 Expenses Rent Internet Electric Telephone Salaries Supplies Insurance Depreciation Total Expenses Net Income (30,000) ) 5 years 25,000 25,000 Adjusted Trial Balance Debit Credit Assets 1000 Cash/Checking 1010 Supplies 1020 Bus. Insurance 1030 Hill Office Supply 1031 Acc. Dep. Hill Office Supply 1040 Advertising 1050-1 JJ Watt 1 1051-2 D. Watson 1052 -3 T. Savage 1053 . 4 J. Clowney 1060 William's Computers 1061 Acc. Dep. William's Computers Liabilities 2000 Bank Loan 2010 Hill Office Furniture 2020 Rent 2030 Internet 2040 Advertising 2050 William's Computers 2030 Electric 2040 Telephone 2050 Salaries Owner's Equi 3000 Common Stock Revenue 4000 Service Fees Expenses 5000 Rent Expense 5010 Internet Expense 5020 Electric Expense 5030 Telephone Expense 5040 Salaries Expense 5050 Supplies Expense 5060 Insurance Expense 5070 Depreciation Expense 5080 Advertising Expense Retained Earnings Net Income 22,000 Retained Earnings, Beginning Net Income Dividends Change in Retained Earnings Retained Earnings, Ending 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 5010 Internet Expense 5,446 2010 3010 Hill Office Furniturtetained Earning 3,240 (3.240) 77.000 71,554 | Balance Sheet Liabilities Bank Loan Hill Office Supply Advertising William's Computers Assets Cash/Checking Supplies Bus. Insurance Hill Office Supply Acc. Dep. Hill Office Supply 3020 Dividends 2020 Rent 2.200 (2.200) 5020 Electric Expense 1010 Supplies 950 950 Owner's Equity Common Stock Retained Earnings Dividends 5030 Telephone Espens AIR Total AIP Total 2030 Internet 180 (180) Net Income Advertising JJ Watt D. Watson T. Savage J. Clowney William's Computers Acc. Dep. William's Computers 1020 Bus. Insurance 1.896 1,896 Salaries Expense Advertising 240 2.400 (2.160) - 1030 Hill Office Furniture 3.600 5050 Supplies Expense 2050 Filliam's Computer 2,000 8,640 (6.640) 3,600 | 1031 2060 5060