I JUST NEED HELP WITH THIRD QUESTION (THIRD CHART BELOW) THE OTHER TWO ARE JUST THERE FOR CONTEXT

Sparty Corporation has been operating for two years. The January 1, 2022, account balances are:

Cash	$250,000		Accounts Payable	$160,000
Accounts Receivable	40,000		Notes Payable	155,000
Inventory	18,000		Common Stock	214,000
Supplies	11,000		Retained Earnings	89,000
Equipment	126,000
Land	173,000

During 2022, Sparty had the below activities. Note that none of these activities should impact the income statement, only the balance sheet; we are assuming for simplicity that the company had no revenues or expenses during 2022. Accordingly, we are ignoring any interest associated with the Notes Payable.

Bought additional inventory for $21,000 on account.

Collected $34,000 cash on open accounts receivable from customers.

Received a $65,000 loan from the bank, payable in five years.

Ordered $12,000 of inventory from a supplier to be delivered next month.

Received $17,000 of supplies that were ordered last month and bought on account.

Paid off $48,000 of notes payable.

Purchased additional equipment costing $55,000; paying $26,000 in cash and signing a promissory note (i.e., a note payable) to pay the balance in four years.

Issued additional shares of common stock, receiving $80,000 in cash from investors.

Purchased $43,000 of land with cash.

Paid off $90,000 owed to suppliers.

Submit all answers to D2L in the one Excel student workbook file with multiple worksheets that is provided on D2L.

The steps in this assignment parallel the example covered in the lecture for Monday January 23 so refer to your course pack. One difference is the example in class considers a new firm so all the beginning balances in the accounts are zero. In this assignment, there are beginning balances in the accounts.

There is also a similar example starting on page 63 of your text. We will also cover a similar example in recitation on Friday January 27. Try to complete the assignment before recitation and then you can use what you observe in recitation to proof your assignment before turning it in by 5:00 pm.

Copy and paste the above table with the account balances into the Excel spreadsheet provided using the first worksheet titled Question #1. (If copy and paste does not work on your computer, you may just have to manually re-type the table in Excel.)

On the worksheet titled Question #2, prepare journal entries for each event that is an accounting transaction. For example, for the following event, the journal entry will be as follows:

Purchased additional buildings for $125,000 by signing a long-term note

Event	Accounts	Debit	Credit
I.	Building (+A)	125,000
	Notes Payable (+L)		125,000

Note: Do not include this example in your solution. This is for illustrative purposes. Also, recall that your total debits must equal your total credits for all journal entries.

On the worksheet titled Questions #3 and #4, create T-accounts for each account, bringing in the beginning balances from the table you copied and pasted into Excel for #1 above. Be sure you have the balances on the correct side (i.e., debit versus credit) of the account. Note that you should have only one T-account for each account. (For example, you should have one T-account for Cash where all journal entries to the cash account are included).

Post the effects of the transactions for 2022 to the T-accounts created in #3. Use the power of Excel to carry over the amounts from your journal entries. For example, in the illustration in #2 above, when you post the $125,000 debit to the Building T-account, you would refer to the cell in the journal entry that contains the 125,000 debit to building on the worksheet titled Question #2.

On the worksheet titled Question #5, prepare a trial balance. Use the power of Excel to refer to cells in your T-accounts to bring over the balances from your T-accounts to the trial balance. Use the Sum function to add up your debit and credit columns to ensure they are equal.

On the worksheet titled Question #6, prepare a balance sheet for the 2022 year-end balances. Use the power of Excel to bring over the appropriate amounts from the trial balance to your balance sheet. Use the Sum function to calculate your totals. Your balance sheet should balance!!!!

NEED HELP WITH THIS ONE BELOW , THANK YOU VVVV

I JUST NEED QUESTION 3 + 4

\begin{tabular}{|l|r|} \hline Accounts Payable & $160,000 \\ \hline Notes Payable & 155,000 \\ \hline Common Stock & 214,000 \\ \hline Retained Earnings & 89,000 \\ \hline & \\ \hline & \\ \hline \end{tabular} \begin{tabular}{r|r} \multicolumn{2}{c}{ Cash } \\ \multicolumn{1}{c|}{ Debit } & Credit \\ \hline$250,000 & 48000 \\ 34000 & \end{tabular}