The file contains a $10-$column worksheet for the ABC Midierm Company for the year ended $\frac{6}{30}\frac{?}{xx}.$

Adjustment information for the company is as follows. PLEASE LABEL ALLL ADJUSTMENTS with the appropriate letter on the worksheet.

a$)$ Store supplies on hand as of $\frac{6}{30}\frac{?}{xx}$ total $$250\mathrm{.}00.$

b$)$ Total current payroll for a $5-$day workweek is $$2,000\mathrm{.}00.$ As of $\frac{6}{300}xx,$ there were $3$ days of unaccrued wages that need to be recorded.

c$)$ Expired insurance as of $\frac{6}{30}\frac{?}{xx}$ was $$450\mathrm{.}00.$

d$)$ No depreciation has been taken to date on the store equipment this year. Depreciation of $$7,500\mathrm{.}00$ needs to be recorded.

e$)$ Ending inventory for the company at $\frac{6}{30}\frac{?}{xx}$ is $$22,500.$ The company uses a periodic inventory system. $($It only adjusts inventory one time at the end of the year. This is the SAME ADJUSTMENT WE DID IN CLASS.$)$The note receivable was signed on $\frac{5}{1}\frac{?}{xx}$ and is a $6-$month note at the annual rate of $10\%.$ Inferest needs to be accrued. $($There is no interest scernal nteded $$ the note payable.$)$

Complete the Following:

$(1)$ As accountant for ABC Midterm Company, you have been akked to prepare adjustments and complete the worksheet as of and for the year ended $\frac{6}{30}\frac{?}{xx}.$ Using the above information, complete the workheef using the Excel program to record the adjustments and total up the columns. The adjusted trial balance columns will automatically be adjusted for you. You then need to allocate the account balances to the appropriate income statement or balance sheet columns. You shonld use cell references to accomplish this. Complete any octuer formelas designated on the template. $($This is exactly what we did in class$).$

$(2)$ On a separate worksheet or tab, prepare a multh$-$step income statement for the company for the year ended $\frac{6}{30}\frac{?}{xx}.$ Use proper formating and cell reference amounts whenever possible. DO NOT ATTEMPT TO PREPARE ALL OF THE FINANCIAL STATEMENTS, jus the multi$-$step income statement.

Save your Work:

$(3)$ Save your work using your last name.

A

Fumber

tomen es tive y

Getlbriet $.$

Hatar

$4$

anay

$-$

$+$

firf Creal

rretiverye

faveriath hre H Mr:

vater

ver De:Afil Nomits

$16$ ils

werese

dies

mer

$4$res.

jefichs

tratroirlerent?

Cayed

Drewing

$2680$

$45+106$

ILxperse

ing sap.

verse

exp

exp

Peceivilie

Peyplie

a peyabie

sumanery

os emperse

ree erperse

cifion exp

of Erperse

st Reverue

$3664$ men

noome