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 "-" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Amount 0.01 interest rate 17860 on account During January, the first month of operations, the following transactions occurred: Date Event 2-Jan Paid for 12 months rent on office space 5-Jan Purchased office furniture. 5-Jan Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be 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. Amount 11,040 9,580 30,000 loan amt 10,650 cash 5,865 7,800 3,790 13,500 1,986 4,650 1,500 JOURNAL ENTRIES - MatTor Consulting Inc ACCOUNT DEBIT DATE CREDIT Worksheet - MatTor Consulting Inc JANUARY ENTRIES UNADJUSTED TRIAL BALANCE BEGINNING NUMBERS ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT 49,200 8,650 54,000 42,800 4,650 ACCOUNT Cash Accounts Receivable Supplies Prepaid Rent Land Computer Equipment Accumulated Depreciation, Comp Equip Office Furniture Accumulated Depreciation, Off Furn Accounts Payable Salaries Payable Interest Payable Unearned Revenue Long-term Notes Payable Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Supplies Expense Utilities Expense Interest Expense Depreciation Expense, Comp Equip Depreciation Expense, Office Furniture 150,000 154,650 154,650