Please perform the following tasks:

$1-$ Prepare the unadjusted trial balance in the $\text{'}12-31-22$ Trial Balance' worksheet based on the

General Ledger that you have received with this packet.

$2-$ Prepare the Adjusting Journal Entries at December $31,2022$ based on the information

provided in a$.$ through h$.$ above and record them on the $\text{'}12-31-22$ Trial Balance' worksheet and

post them to the General Ledger $(10$ Points$).$

$3-$ Post the adjusting entries to the General Ledger and extend that data to compute the

Adjusted Trial Balance on the $\text{'}12-31-22$ Trial Balance' worksheet.

$4-$ From the Adjusted Trial Balance, prepare the four fundamental financial statements at

December $31,2022(20$ Points$)$:

a$.$ Income Statement

b$.$ Statement of Retained Earnings

c$.$ Balance Sheet

d$.$ Statement of Cash Flows $($a $12/31/21$ Balance Sheet is provided to prepare the operating

activities section using the indirect method$)$

$5-$ Prepare the Closing Journal Entries at December $31,2022$ and record them on

the $\text{'}12-31-22$ Trial Balance' worksheet and post them to the General Ledger $(8$ Points$).$

$6-$ Prepare the Post$-$Closing Trial Balance at December $31,2022$ from the $\text{'}12-31-22$ Trial

Balance' worksheet $-$ your Retained Earnings balance should be the same as on your $12/31/22$

Balance Sheet prepared in item $4$c$.$ above.

That's are all the information needed

Please complete with excel and send the as attachments or pictures.

Having recorded, posted $($to the General Ledger$)$ and began the

$\text{'}12-31-22$ Trial Balance' worksheet with the unadjusted balances,

we are now going to prepare the Adjusting Journal Entries so that

we can prepare the four fundamental financial statements.

The bi$-$weekly pay period will end on January $72023.$

b$.$

Interest accrued at December $31,2022$ is composed of the following...Use a $360$ day

year when calculating interest.

c$.$ No interest payments were made on the company's $$15,0008\%$ note payable during $2022.$

d$.$ A count of office supplies at year$-$end indicated remaining office supplies of $$3,100$ at

d$.$ December $31.$

Plant and Equipment to be depreciated are composed of the following...

f$.$ A physical inventory was conducted of the warehouse at December $31$ and the total value of

inventory counted was $$492,929.$

g$.$ A review of open Accounts Receivable was conducted at year$-$end and it was determined

g$.$ that an estimated $4\mathrm{.}5\%$ of accounts receivable will be uncollected in the coming year.

h$.$ Two months remain on the warehouse rental $($paid in advance in $2022).$ The total value of

the rent for January and February $2023$ is $$4,660.$

A review of insurance policies indicated that the value of the unexpired portion of existing

policies was $$5,640$ at year end.

Please perform the following tasks:

$1-$Prepare the unadjusted trial balance in the $\text{'}12-31-22$ Trial

Balance' worksheet based on the General Ledger that you

f$.$ A physical inventory was conducted of the warehouse at December $31$ and the total value of

f$.$ inventory counted was $$492,929.$

g$.$ A review of open Accounts Receivable was conducted at year$-$end and it was determined

g$.$ that an estimated $4\mathrm{.}5\%$ of accounts receivable will be uncollected in the coming year.

h$.$ Two months remain on the warehouse rental $($paid in advance in $2022).$ The total value of

h$.$ the rent for January and February $2023$ is $$4,660.$

i$.$ A review of insurance policies indicated that the value of the unexpired portion of existing

policies was $$5,640$ at year end.

Please perform the following tasks: