E$-$Reserves Problem $2-1$

On December $31,2024,$ Jerome Bon Jovi launched an architectural consulting business called Bon Jovi & Sons, Inc. The

company completed the following transactions during $2024.$

J$.$ Bon Jovi invested $$90,000$ cash, office equipment with a value of $$10,000,$ and $$50,000$ of computer equipment in

the company in exchange for common stock.

The company purchased an automobile worth $$25,000$ by paying $$5,000$ cash and signing a note payable for $$20,000.$

The company provided services to a client and collected $$12,000$ cash.

The company completed $$9,000$ of services for a client. The company extended credit to the client, who is expected to

pay within $30$ days.

The company purchased $$4,000$ of TV advertising on credit.

The company paid $$8,000$ cash for the monthly salary for $4$ employees.

The company paid $$1,000$ for sanitation services.

The company paid a $$6,000$ cash dividend to J$.$ Bon Jovi.

The company collected $$3,000$ cash in partial payment from the client described in transaction $"4".$

Required:

a$.$ On an Excel Worksheet, using good form, prepare journal entries to record these transactions.

b$.$ On a separate Excel Worksheet, prepare General Ledger $"$T$"$ accounts. Using good form, post the journal entries

recorded on the first worksheet, to the General Ledger accounts located on the second worksheet. Show the ending

balance for each General Ledger account.

c$.$ On a third Excel Worksheet, use the ending General Ledger account balances to prepare a Trial Balance at December $31,$

$2024,$ using good form.

d$.$ On a fourth Excel Worksheet, show the formulas that were used to prepare the Trial Balance.

Note: The four worksheets above should all be prepared in the same Excel file.