I need help making journal entries for the information attached. I will also need excel file with it, lastly need questions 1 to 10 answered.

Thanks.

Stuart's Advisory Services Inc. began business on January 1, 2015. At the end of Year 1, December 31, 2015, the company's post-closing trial balance appeared as follows: a/c # Account Name Dr. 100 105 110 115 160 165 Cash Accounts Receivable Supplies Prepaid Insurance Equipment A/D-Equipment 200 205 210 215 220 225 250 300 305 310 Accounts Payable Notes Payable (short-term) Wages Payable Interest Payable Income Taxes Payable Advances from Customers Notes Payable (long-term) Contributed Capital Retained Earnings Dividends Declared 400 505 510 515 520 600 650 Service Revenue Depreciation Expense Wages Expense Insurance Expense Supplies Expense Interest Expense Income Tax Expense 0 0 0 0 0 0 Total 62,800 Cr. 38,600 3,200 1,200 4,800 15,000 3,000 4,500 3,000 900 0 1,000 1,600 9,000 12,000 27,800 0 0 62,800 A summary of transactions (1 - 10) which occurred during January 2016 are as follows (to be entered into the \"general journal\" at January 30, 2016). See the instructions under \"B\" below. (1). Paid off all of the beginning Accounts Payable balance. (2). Collected the entire Accounts Receivable balance that existed at the beginning of the year. (3). Paid the \"Income Taxes Payable\" balance that existed at the beginning of the year. (4). Purchased $1,600 of equipment on credit (under terms n/60). (5). Earned revenue of $8,600 of which $7,500 had been collected in cash with $1,100 still due from customers. This amount does not include the balance in the \"Advances from Customers\" account which will be considered in transaction #12. (6). Paid cash wages of $3,860, of which $900 was payment on the beginning of the year Wages Payable balance (note this amount in the TB given above), with the remaining $2,960 paid for work performed during the current month. (7). Purchased supplies costing $400 for use in future months. $100 of these purchases remain unpaid for at the end of the month [i.e. $300 was paid in cash with $100 still open on account]. (8). Issued 1,000 additional shares of stock and received $8,800 cash. (9). Near the end of the month received a $700 deposit from a customer, Joan Wells, for services to be performed next month. (10). Declared and paid a cash dividend of $2,500. After you have entered these 10 transactions, if you want to see if you are correct at this point in time, see the \"Check Figures\" given below under \"B.\" Data for adjusting journal entries (transactions 11 -18 below) are to be entered in the \"general journal\" at January 31, 2016. (11). The balance in the prepaid insurance account represents the premium paid for a 2-year policy for the period January 1, 2016 - December 31, 2017. (12). The beginning of the year balance in the \"Advances from Customers\" (i.e. unearned revenue) account was earned during the month of January. (13). January 2016 depreciation on the equipment is $320. (14). Wages incurred, but not yet paid at January 31, was $380. (15). Income taxes incurred in January 2016, but to be paid in March 2016, were $420. (16). A $12,000, 4-year Note was signed with the bank on December 31, 2015. This note is to be paid off in equal annual payments over 4 years with the first payment due on December 31, 2016 (i.e. this is an example of \"serial debt\" as equal annual principal payments are being made). The annual payment required each December 31 must also include interest at a 4% annual rate on the total unpaid balance that exists at December 30. An entry to establish the proper amount of the \"current portion of long-term debt\" has already been recorded (as you should note in the trial balance given above). Thus an AJE needs to be made to record the accrued interest on the total balance (i.e. the sum of the short and long-term note payable). (17). A physical count at January 31 shows that $560 of Supplies remained unused. [You will need to \"run\"/review (\"for this fiscal year\") the unadjusted trial balance to determine the current unadjusted balance in this account and then adjust that amount to the physical count to determine the amount \"used up\" in the current month.] (18). The company entered into a cellular telephone plan in January. Charges incurred during January and to be paid in February are estimated to be $120. [see \"A\" under Required\" below prior to making this entry. Required A. Adding accounts to the chart of accounts (COA) Transaction #18 above is as follows: \"The company entered into a cellular telephone plan in December. Charges incurred during January and to be paid in February are estimated to be $120.\" The company currently does not have appropriate accounts in its Chart of Accounts for this type of expense and related accrued liability. You will need to add the following two accounts prior to recording entry #18: Account name Utilities Payable Utilities Expense Account # 230 530 Account type Other Current Liabilities Expense 1. In the chart of accounts, an account description may vary from company to company. With respect to transaction \"9\" - the company receiving a deposit from a customer for work to be performed next month, and the account used was \"Advances from Customers\". Which one of the following should not (would not) be used instead of \"Advances from Customers\"? A. C. 2. Advance Customer Payments Accounts Receivable Expense Equity B. D. Long-term Liability Other Current Liability One main task in this problem is the recording of adjusting journal entries. Assume that the time allowed for \"closing the books\" at the end of month going forward is going to be much shorter, as the bank is requiring monthly financial statements to be remitted to them under the terms of the note payable, and therefore you will need to accrue for dividends declared in mid-January but which will not be paid until midFebruary. Which one of the following would be the most likely account number you would assign to a new account entitled \"Dividends Payable\"? A. 4. B. D. From the chart of accounts, what \"type\" (account classification) of account is \"Advances from Customers\"? [to view the \"chart of accounts\" click on \"Company\" on the toolbar and then select \"Chart of Accounts\" (then maximize the window if you desire]. A. C. 3. Unearned Revenues Customer Deposits #180 B. #240 C. #350 D. #620 Run the report entitled \"General Ledger\" (found under Reports, then Accountant & Taxes). Which one of the following is listed under the column \"Type\" (which indicates the origin of the transaction for every transaction), for GJE#4? [note: again, make sure the report is \"run\" through January 31, 2016; also remember that in the \"real world\" transactions would initially be recorded in different journals (e.g. Cash Disbursements journal) but at this stage things have been simplified for you and you are only recording transactions in a single journal]. A. 5. D. Journal $8,040 dr. $46,640 dr. B. D. $20,200 dr. $12,150 cr. $700 B. $1,800 C. $1,100 D. $3,200 $48,600 B. $50,820 C. $20,800 D. $66,180 $13,280 B. $16,600 C. $15,000 D. $12,000 Per the income statement (profit & loss statement) \"For January 2016\" what is the total amount of expenses YTD (year-to-date)? A. 10. General Journal What is the net book value (also called the book value, also called the carrying value, also called the adjusted basis) of the equipment at January 31, 2016 (after all JEs and AJEs have been recorded)? A. 9. C. What is the total amount of capital (owners' equity) at January 31, 2016 (after all JEs and AJEs have been recorded)? A. 8. GJ per the \"trial balance\