Dr. McMuffin has a medical clinic formed as a corporation that provides specialty care services to patients. The balances in the accounts as of January 1, 2021 are as follows: Cash 70,000 Notes Payable 47,000 Contributed Capital 28,000 Retained Earnings 95,000 Patient Service Revenue 60,000 Income Tax Expense 22,000 Compensation Expense 20,000 Insurance Expense 25,000 Utilities Expense 86,000 125,000 106,000 0 Accounts Receivable Office Supplies Building Land Office Fixtures and Equipment Medical Instruments Accounts Payable olololo Below are the business transactions for January for Dr. McMuffin's clinic: JANUARY Purchased land for 20,000 in cash. 1 2 5 Received $70,000 of cash from an investor in exchange for shares of stock in the clinic. Billed clients $80,000 for services rendered. Of this amount, ($65,000 was received in cash, and the remaining balance was billed on account (due in 30 days). Purchased Office Fixtures and Equipment for $35,000. The clinic paid $25,000 in cash and financed the remaining balance with debt by signing a note promising to pay in three years. Ignore interest Received $20,000 from customers on previously billed medical services. 6 8 10 Purchased medical instruments on account expected to last a few months for $4,000. 14 20 Purchased office supplies for $20,000 on account. Received a $10,000 invoice for insurance coverage in January. The entire amount is due to be paid on February 26. You can consider this an Account Payable. Paid $300 in income taxes for taxes incurred during January. 26 27 Paid suppliers $10,000 included in accounts payable. 28 Paid employees $15,000 in salaries for work done during the month of January 31 Paid Light Co. $2,500 for utilities used in the clinic during the month of January Submit all your answers to D2L in one Excel document with 6 different worksheets (one worksheet for each of the 6 below parts). 1. Copy and paste the above table with the account balances into an Excel spreadsheet. This will be your first worksheet titled "Question #1." 2. Prepare journal entries for each transaction (list the date, accounts and amounts debited and credited in good form). Do not worry about making adjusting journal entries. 3. Create a T-account for each account used with the beginning balance provided in your answer to Question #1 (use Excel to refer to the proper cells in Question #1). Post each transaction from Question 2 to the appropriate T account and determine the ending balance as of January 31. 4. Prepare a trial balance dated January 31, 2021 (see page 128 in textbook). By referring to cells in your T-accounts bring over the balances from your T-accounts to the trial balance. Use the "Sum" function in Excel to add up your debit and credit columns. 5. Copying the appropriate amounts from the trial balance, prepare a classified income statement for the month ended January 31, 2021 (see page 129 in textbook). You can ignore the fact that you have not made any adjusting journal entries. 6. Copying the appropriate amounts from the trial balance, prepare a balance sheet as of January 31, 2021 (see page 69 of the textbook). Use the "Sum" function in Excel for your totals and a formula to calculate ending retained earnings. Remember: Ending Retained Earnings = Beginning Retained Earnings + Net Income - Dividends. McMuffin did not have any dividend activity during the month of January
