You are the accountant for XYZ Enterprises, a newly established retail company. During its first month of operations, the company engaged in the following hypothetical transactions:

Investment by Owners: The owners invested $$50,000$ cash into the business in exchange for common stock.

Office Space Rental Agreement: Signed a $12-$month lease for retail space, paying the first month's rent of $$2,500$ in advance.

Purchase of Inventory: Purchased $1,000$ units of inventory at $$15$ per unit on account with terms $2/10,$ n$/30.$

Sale of Inventory $($Cash$)$: Sold $200$ units of inventory for $$60$ per unit in cash. The inventory cost per unit was $$15.$

Sale of Inventory $($On Account$)$: Sold $150$ units of inventory for $$60$ per unit on account, terms $2/10,$ n$/30.$ The inventory cost per unit was $$15.$

Purchase of Equipment: Bought equipment for $$30,000,$ paying $$15,000$ in cash and the remaining $$15,000$ on a $2-$year note payable.

Utility Expenses: Paid $$1,500$ in cash for utility bills.

Salaries Expense: Paid $$6,000$ in cash for employees' salaries.

Advertising Expense: Incurred $$1,800$ in advertising costs, paid in cash.

Collection from Accounts Receivable: Collected $$9,000$ from customers who were billed on account.

Payment to Suppliers: Paid $$14,700$ to suppliers for inventory purchased, taking advantage of the early payment discount.

Prepaid Insurance: Paid $$1,200$ for a $6-$month insurance policy.

Accrued Salaries: Recorded $$2,000$ in salaries for work done during the last week of the month, to be paid next month.

Depreciation Expense: Recorded $$500$ depreciation for the month on equipment.

Sales Return: Accepted the return of $10$ units of inventory sold on account. The inventory was originally sold at $$60$ per unit, with a cost of $$15$ per unit.

Interest Expense: Accrued interest of $$100$ on the note payable.

Inventory Write$-$down: Due to obsolescence, wrote down inventory by $$200.$

Deferred Revenue: Received $$2,000$ in advance for goods to be delivered next month.

Loan Payment: Paid $$500$ towards the principal of the note payable.

Corporate Taxes: Estimated and recorded income tax expense of $$2,000$ for the month.

Instructions:

General Journal Entries:

Record the above transactions in the general journal using Excel. For each transaction, specify the accounts debited and credited along with the amounts, including detailed calculations for inventory purchases and sales.

T$-$Accounts $($Ledger Entries$)$:

Post the journal entries to the appropriate T$-$accounts in Excel, showing the debits and credits for each account. Ensure that each T$-$account has a clear and accurate balance.

Trial Balance:

Prepare a trial balance in Excel as of the end of the month. Ensure that the total debits equal the total credits.

Income Statement:

Using the trial balance, prepare an income statement for XYZ Enterprises for the first month of operations in Excel. Include all revenues and expenses, such as cost of goods sold, depreciation, and corporate taxes.

Statement of Financial Position $($Balance Sheet$)$:

Prepare a statement of financial position as of the end of the month in Excel. Include all assets, liabilities, and equity accounts.

Additional Considerations:

Assume the company uses the perpetual inventory system and the accrual basis of accounting.

Round all figures to the nearest dollar.

Clearly label each section and ensure that all entries are neat and organized in the Excel spreadsheet.

Deliverables:

General journal entries $($Excel sheet$)$

T$-$accounts $($ledger in Excel$)$

Trial balance $($Excel sheet$)$

Income statement $($Excel sheet$)$

Statement of financial position $($Excel sheet$)$