The Accounting Cycle using journals and T$-$accounts

The trial balance of DeCore Design Service as of January $1,2020$ had the following normal balances:

DeCore Design Service completed the following transactions during $2020.$

Issued stack $$5,000.$

Paid the salaries payable from the prior year.

Paid $$600$ cash for supplies.

Collected $$600$ in advance for design service to be performed later.

Paid the amount due on account.

Prepaid insurance of $$600$ for a six month period.

Performed design services for a customer and received $$2,800$cash.

Paid office rent for the period, $$2,000.$

Completed a large design job and billed the customer $$6,500.$

The company purchased a truck for $$30,000$ making a down payment of $$6,000$ and taking a

loan on the remainder of $$24,000$ at a $6\%$ annual interest rate.

Collected $$1,500$ cash from customer on account.

Purchased fuel for the truck, paying $$400$ on account.

Received $$3,000$ cash for performing design services.

Paid employees, $$700.$

Paid $$200$ in dividends to the stockholders.

Adjustments:

Prepaid insurance used during the year was $$100$ "per month".

Unearned services earned during the year $$1,000.$

Accrue interest on the note payable for one full year.

Accrue salaries for year end, $$300.$

Depreciation for the year was $$3,000.$

There was $$500$ supplies on hand at year end.

Required:

a$.$ Record the above transactions $(41-15)$ and the adjustments $(\%16-21)$ in the general journal.

Use the account names provided in the trial balance to record these transactions.

$($Create a general journal page in Excel and number each transaction you record;

ie $1,2,3$ etc.$)$

b$.$ Post the entries to T$-$Accounts.

i$.$ Use a new TAB in EXCEL to create the T$-$Accounts. $($Hint: the CASH will have the most postings$)$

ii$.$ Line up the T$-$Accounts in organized columns, under each of the following categories;

$($Assets$,$ Liabilities, Equity, Revenues, Expenses$)$

ii$.$ After posting, subtotal each T$-$Account to show the balance in the account.

c$.$ Prepare a Trial balance.

Please use a separate tab in Excel for this step.

d$.$ Prepare the financial statements for $2020$ and include complete and proper headings on each.

$($Income Statement, Statement of Changes in Stockholders Equity, Balance Sheet and the

Statement of Cash Flows$)$