Micah, an aficionado of all things relating to the bagel, opened Lox of Bagels in Hometown, USA on July 1, 2017. The shop specializes in a variety of bagel selections and a line of gourmet breakfast muffins. Congratulations! You have been hired as the store manager. Your duties include maintaining the store's financial records. The following transactions occurred in July 2017, the first month of operations.

1. Received four shareholders' contributions totaling $50,000 cash to form the corporation; issued 400 shares of $1 par value common stock.
2. Paid three months' rent for the store at $2,000 per month.
3. Purchased and received bagel ingredients, cream cheese, coffee and muffin ingredients for $5,000 on account, due in 60 days.
4. Purchased supplies for $1,000 cash.
5. Negotiated and signed a two-year $15,000 loan at the bank, receiving cash at the time.
6. Used the money from (e) to purchase a computer for $2,500 (for recordkeeping and inventory tracking); used the balance for furniture and fixtures for the store.
7. Placed a grand opening advertisement in the local paper for $400 cash; the ad ran in the current month.
8. Made sales during the grand opening week totaling $3,000; $2,000 was in cash and the rest on accounts receivable. The cost of the bagels, cream cheese, coffee and muffins sold was $1,000.
1. Made a $600 payment on accounts payable.
10. Incurred and paid employee wages of $1,900.
11. Collected accounts receivable of $800 from customers.
50. Made a repair to one of the display cases for $300 cash.
1000. Made cash sales of $3,000 during the rest of the month. The cost of the bagels, cream cheese, coffee and muffins sold was $1,000.

Using the Excel, the following are required:

1. Set up appropriate T-accounts for Cash, Accounts Receivable, Supplies, Inventory, Prepaid Expenses, Equipment, Furniture and Fixtures, Accounts Payable, Notes Payable, Common Stock, Additional Paid-in Capital, Sales Revenue, Cost of Goods Sold (expense), Rent Expense, Advertising Expense, Wage Expense, and Repair Expense. All accounts begin with zero balances.
2. Record in the T-accounts the effects of each transaction for Lox of Bagels in July, referencing each transaction in the accounts with the transaction letter. Show the ending balances in the T-accounts. Note: transactions (b), (h) and (m) require two types of entries, one for revenue recognition and one for the expense.
3. Prepare an income statement at the end of the month ended July 31, 2017.
4. Either in Word or as a text box in Excel, write a memo to Micah offering your opinion on the results of operations during the first month of business. This is more than just a great job. Consider what you would want to know as a business owner from a manager you have hired for the day to day activities. What can be improved? What seems odd for that type of business?