without excel formulas

have part one done so i need help on part 2. the le part. However, i know i have a few small mistakes on the first part and need that foved for the econd part than til . Prepare journal entries to record the January transactions given. Please refer to the Worksheet tab for Account Titles you may need. Add the January journal entry information to the Worksheet in the January columns. You can do this in one of 2 ways - (1) Post the journal entries to ledger accounts using T-accounts to represent ledger accounts and then use those totals to post to the worksheet or (2) use excel to add all entries for a particular account into the correct column in the worksheet (ie., add all cash debits from the journal entries into the cash debit column for January entries). There is a tab to use for T Accounts if you want but the T Accounts are NOT required Prepare an unadjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Excel formulas must be used throughout the project to obtain full credit. Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab.. Highlight the entire worksheet area and press the "ctrl" key and the "w" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Prepare adjusting entries for the month of January given the information provided. Post the adjusting entries to the Adjusting entries columns on the worksheet Prepare an adjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl" key and the "-" key. This will cause formulas used to display instead of the numbers. Save your file with the formulas displayed. Date Amount Amount 11,040 9,580 0.01 interest rate 17860 on account During January, the first month of operations, the following transactions occurred: Event 2-Jan Paid for 12 months rent on office space 5-Jan Purchased office furniture. Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be 5-Jan paid back in 5 years 11-Jan Performed services for various customers for cash and on account. 19-Jan Paid salaries to employees for 1 week. 20-Jan Received cash in advance from Stanley Inc. for work to be performed over the next 12 months 22-Jan Purchased additional office supplies on account 28-Jan Collected payments for amounts previously billed. 29-Jan Paid for utilities 29-Jan Paid the bill for supplies purchased previously. 31-Jan Dividends were declared and paid. 30,000 loan amt 10,650 cash 5,865 7.800 3.790 13,500 1,986 4,650 1,500 At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount 6985 2560 31-Jan One month of interest has accrued on the note payable for the bank loan. Additional work for customers has been performed during the last week of January but not billed yet 31-Jan 31-Jan Supplies were counted at month end 31-Jan One month of the prepaid rent has been used up 31-Jan Depreciation expense needs to be recognized for the computer equipment and for the office furniture 31-Jan One month of the services for Stanley Inc. has bect performed (see above), 31. Jan Salaries are paid every Friday (for a day work week). January 31, 2019 was a Thursday 165 comp equip 95 off furn 5,865 weekly A 1 B JOURNAL ENTRIES ACCOUNT 2 CREDIT sulting Inc DEBIT 920 10,120 DATE 2-Jan Rent Prepaid Rent 3 4 5 Cash 11,040 6 5-Jan Office Furniture 9,580 7 Cash 9,580 8 30,000 9 30,000 10 10,650 17,860 11 12 28,510 13 5,865 14 5,865 7,800 15 16 7,800 5-Jan Cash Long-Term Notes Payable 11-Jan Cash Accounts Receivable Service Revenue 19-Jan Salaries and Wages Expense Cash 20-Jan Cash Unearned Revenue 22-Jan Office Supplies Accounts Payable 28-Jan Cash Accounts Receivable 29-Jan Utilities Expense Cash 29-Jan Accounts Payable Cash 31-Jan Dividends 17 3,790 18 3,790 19 13,500 20 13,500 21 1,986 22 1,986 23 4,650 24 4,650 25 1,500 26 Cash 1,500 27 28 TOTALS 118,221 118221 29 1 Worksheet BEGINNING NUMBERS JANUARY ENTRIES ingine UNADJUSTED TRIAL BALANCE DEBIT CREDIT ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT CREDIT CREDIT DEBIT CREDIT DEBIT 49,200 DEBIT 27 329 4,360 3,790 10,120 76,529 4360 12,440 11,040 8,650 54,000 42.800 54,000 42.800 9,580 9,580 4.650 850 3.790 2 3 ACCOUNT 4 Cash 5 Accounts Receivable 6 Supplies 7 Prepaid Rent 8 Land 9 Computer Equipment 10 Accumulated Depreciation Comp Equip 11 Office Furniture 12 Accumulated Depreciation, Off Furn 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 15 Unearned Revenue 17 Long-term Notes Payable 18 Common Stock 19 Retained Earnings 20 Didends 21 Service Revenue 22 Salaries Expense 23 Rent Expense 24 Supplies Expense 25 Unities Expense 26 Interest Expense 27 Depreciation Expense Comp Equip 20 Depreciation Expense Office Furniture 29 7800 30.000 7,800 30,000 150,000 150,000 1,500 1,500 28,510 28.510 5,865 5,865 920 1.986 1986 30 154,650 154,650 65.450 67170 220 100 220100 21 1 ADJUSTING JOURNAL ENTRIES ACCOUNT Consulting Inc DEBIT CREDIT 2 DATE 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 have part one done so i need help on part 2. the le part. However, i know i have a few small mistakes on the first part and need that foved for the econd part than til . Prepare journal entries to record the January transactions given. Please refer to the Worksheet tab for Account Titles you may need. Add the January journal entry information to the Worksheet in the January columns. You can do this in one of 2 ways - (1) Post the journal entries to ledger accounts using T-accounts to represent ledger accounts and then use those totals to post to the worksheet or (2) use excel to add all entries for a particular account into the correct column in the worksheet (ie., add all cash debits from the journal entries into the cash debit column for January entries). There is a tab to use for T Accounts if you want but the T Accounts are NOT required Prepare an unadjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Excel formulas must be used throughout the project to obtain full credit. Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab.. Highlight the entire worksheet area and press the "ctrl" key and the "w" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Prepare adjusting entries for the month of January given the information provided. Post the adjusting entries to the Adjusting entries columns on the worksheet Prepare an adjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl" key and the "-" key. This will cause formulas used to display instead of the numbers. Save your file with the formulas displayed. Date Amount Amount 11,040 9,580 0.01 interest rate 17860 on account During January, the first month of operations, the following transactions occurred: Event 2-Jan Paid for 12 months rent on office space 5-Jan Purchased office furniture. Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be 5-Jan paid back in 5 years 11-Jan Performed services for various customers for cash and on account. 19-Jan Paid salaries to employees for 1 week. 20-Jan Received cash in advance from Stanley Inc. for work to be performed over the next 12 months 22-Jan Purchased additional office supplies on account 28-Jan Collected payments for amounts previously billed. 29-Jan Paid for utilities 29-Jan Paid the bill for supplies purchased previously. 31-Jan Dividends were declared and paid. 30,000 loan amt 10,650 cash 5,865 7.800 3.790 13,500 1,986 4,650 1,500 At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount 6985 2560 31-Jan One month of interest has accrued on the note payable for the bank loan. Additional work for customers has been performed during the last week of January but not billed yet 31-Jan 31-Jan Supplies were counted at month end 31-Jan One month of the prepaid rent has been used up 31-Jan Depreciation expense needs to be recognized for the computer equipment and for the office furniture 31-Jan One month of the services for Stanley Inc. has bect performed (see above), 31. Jan Salaries are paid every Friday (for a day work week). January 31, 2019 was a Thursday 165 comp equip 95 off furn 5,865 weekly A 1 B JOURNAL ENTRIES ACCOUNT 2 CREDIT sulting Inc DEBIT 920 10,120 DATE 2-Jan Rent Prepaid Rent 3 4 5 Cash 11,040 6 5-Jan Office Furniture 9,580 7 Cash 9,580 8 30,000 9 30,000 10 10,650 17,860 11 12 28,510 13 5,865 14 5,865 7,800 15 16 7,800 5-Jan Cash Long-Term Notes Payable 11-Jan Cash Accounts Receivable Service Revenue 19-Jan Salaries and Wages Expense Cash 20-Jan Cash Unearned Revenue 22-Jan Office Supplies Accounts Payable 28-Jan Cash Accounts Receivable 29-Jan Utilities Expense Cash 29-Jan Accounts Payable Cash 31-Jan Dividends 17 3,790 18 3,790 19 13,500 20 13,500 21 1,986 22 1,986 23 4,650 24 4,650 25 1,500 26 Cash 1,500 27 28 TOTALS 118,221 118221 29 1 Worksheet BEGINNING NUMBERS JANUARY ENTRIES ingine UNADJUSTED TRIAL BALANCE DEBIT CREDIT ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT CREDIT CREDIT DEBIT CREDIT DEBIT 49,200 DEBIT 27 329 4,360 3,790 10,120 76,529 4360 12,440 11,040 8,650 54,000 42.800 54,000 42.800 9,580 9,580 4.650 850 3.790 2 3 ACCOUNT 4 Cash 5 Accounts Receivable 6 Supplies 7 Prepaid Rent 8 Land 9 Computer Equipment 10 Accumulated Depreciation Comp Equip 11 Office Furniture 12 Accumulated Depreciation, Off Furn 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 15 Unearned Revenue 17 Long-term Notes Payable 18 Common Stock 19 Retained Earnings 20 Didends 21 Service Revenue 22 Salaries Expense 23 Rent Expense 24 Supplies Expense 25 Unities Expense 26 Interest Expense 27 Depreciation Expense Comp Equip 20 Depreciation Expense Office Furniture 29 7800 30.000 7,800 30,000 150,000 150,000 1,500 1,500 28,510 28.510 5,865 5,865 920 1.986 1986 30 154,650 154,650 65.450 67170 220 100 220100 21 1 ADJUSTING JOURNAL ENTRIES ACCOUNT Consulting Inc DEBIT CREDIT 2 DATE 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23